mohammad-bahrami
دوشنبه 27 شهریور 1391, 12:23 عصر
من می خوام یک پروسیجر برای کد زیر بنویسم که چند حالته است به نظر شما بهترین روش چیه؟
string strSql = "";
if (txt_name.Text.Trim() != "")
{
strSql = " name like N'%" + txt_name.Text + "%' ";
}
if (txt_phone.Text.Trim() != "")
{
if (strSql != "")
{
strSql += " and ";
}
strSql += " phone like N'%" + txt_phone.Text + "%' ";
}
if (txt_job.Text.Trim() != "")
{
if (strSql != "")
{
strSql += " and ";
}
strSql += " job like N'%" + txt_job.Text.Trim() + "%' ";
}
if (strSql != "")
{
strSql = " where " + strSql;
}
SqlDataSource1.SelectCommand = "select * from t_phone " + strSql;
string strSql = "";
if (txt_name.Text.Trim() != "")
{
strSql = " name like N'%" + txt_name.Text + "%' ";
}
if (txt_phone.Text.Trim() != "")
{
if (strSql != "")
{
strSql += " and ";
}
strSql += " phone like N'%" + txt_phone.Text + "%' ";
}
if (txt_job.Text.Trim() != "")
{
if (strSql != "")
{
strSql += " and ";
}
strSql += " job like N'%" + txt_job.Text.Trim() + "%' ";
}
if (strSql != "")
{
strSql = " where " + strSql;
}
SqlDataSource1.SelectCommand = "select * from t_phone " + strSql;