这样的多条件查询,大家会怎么优化?
ViewState["sel"] = "";
if (name.Text.Trim() != "")
{
ViewState["sel"] += " a.Title like '%" + name.Text.Trim() + "%'";
}
else
{
ViewState["sel"] = " 1=1";
}
//时间不为空
if (StatTime.Text.Trim() != "" && EndTime.Text.Trim() != "")
{
ViewState["sel"] += " and a.AddDate >= '" + StatTime.Text + " 00:00:00' and a.AddDate <= '" + EndTime.Text + " 23:59:59" + "'";
}
else
{
//判断是否有一个时间
if (StatTime.Text.Trim() != "")
{
ViewState["sel"] += " and DATEDIFF(day,a.AddDate,'" + StatTime.Text + "')=0";
}
else if (EndTime.Text.Trim() != "")
{
ViewState["sel"] += " and DATEDIFF(day,a.AddDate,'" + EndTime.Text + "')=0";
}
else
{
}
}
if (flddl.SelectedValue != "0")
{
ViewState["sel"] += " and a.[Types] = " + flddl.SelectedValue + "";
}
SetFormInit();
}
谁有优化好的见解........如果是用参数传值的可以先不考虑的