代码如下: StringBuilder selCondition = new StringBuilder();
selCondition.Append("select EDOCKEYID,QZH,MENLEI,ZRZ,AJTM");
selCondition.Append(" from MainDoc");
if (ddlSelectField.SelectedValue.ToString() == "selectAll")
{
selCondition.Append(" where QZH like '%@QZH%' or");
selCondition.Append(" AJTM like '%@AJTM%' or");
selCondition.Append(" MENLEI like '%@MENLEI%' or");
selCondition.Append(" GDND like '%@GDND%' or");
selCondition.Append(" BGQX like '%@BGQX%' or");
selCondition.Append(" CWND like '%@CWND%' or");
selCondition.Append(" CWYF like '%@CWYF%' or");
selCondition.Append(" CWRQ like '%@CWRQ%' or");
selCondition.Append(" WJND like '%@WJND%' or");
selCondition.Append(" WJDZ like '%@WJDZ%' or");
selCondition.Append(" WJBH like '%@WJBH%' or");
selCondition.Append(" ZRZ like '%@ZRZ%' or");
selCondition.Append(" KFBZ like '%@KFBZ%'");
SqlParameter[] paraments ={
new SqlParameter("@QZH",SqlDbType.VarChar),
new SqlParameter("@AJTM",SqlDbType.VarChar),
new SqlParameter("@MENLEI",SqlDbType.VarChar),
new SqlParameter("@GDND",SqlDbType.VarChar),
new SqlParameter("@BGQX",SqlDbType.VarChar),
new SqlParameter("@CWND",SqlDbType.VarChar),
new SqlParameter("@CWYF",SqlDbType.VarChar),
new SqlParameter("@CWRQ",SqlDbType.VarChar),
new SqlParameter("@WJND",SqlDbType.VarChar),
new SqlParameter("@WJDZ",SqlDbType.VarChar),
new SqlParameter("@WJBH",SqlDbType.VarChar),
new SqlParameter("@ZRZ%",SqlDbType.VarChar),
new SqlParameter("@KFBZ",SqlDbType.VarChar)}
%号应该怎么样加
请那位大虾指点一下
selCondition.Append("select EDOCKEYID,QZH,MENLEI,ZRZ,AJTM");
selCondition.Append(" from MainDoc");
if (ddlSelectField.SelectedValue.ToString() == "selectAll")
{
selCondition.Append(" where QZH like '%@QZH%' or");
selCondition.Append(" AJTM like '%@AJTM%' or");
selCondition.Append(" MENLEI like '%@MENLEI%' or");
selCondition.Append(" GDND like '%@GDND%' or");
selCondition.Append(" BGQX like '%@BGQX%' or");
selCondition.Append(" CWND like '%@CWND%' or");
selCondition.Append(" CWYF like '%@CWYF%' or");
selCondition.Append(" CWRQ like '%@CWRQ%' or");
selCondition.Append(" WJND like '%@WJND%' or");
selCondition.Append(" WJDZ like '%@WJDZ%' or");
selCondition.Append(" WJBH like '%@WJBH%' or");
selCondition.Append(" ZRZ like '%@ZRZ%' or");
selCondition.Append(" KFBZ like '%@KFBZ%'");
SqlParameter[] paraments ={
new SqlParameter("@QZH",SqlDbType.VarChar),
new SqlParameter("@AJTM",SqlDbType.VarChar),
new SqlParameter("@MENLEI",SqlDbType.VarChar),
new SqlParameter("@GDND",SqlDbType.VarChar),
new SqlParameter("@BGQX",SqlDbType.VarChar),
new SqlParameter("@CWND",SqlDbType.VarChar),
new SqlParameter("@CWYF",SqlDbType.VarChar),
new SqlParameter("@CWRQ",SqlDbType.VarChar),
new SqlParameter("@WJND",SqlDbType.VarChar),
new SqlParameter("@WJDZ",SqlDbType.VarChar),
new SqlParameter("@WJBH",SqlDbType.VarChar),
new SqlParameter("@ZRZ%",SqlDbType.VarChar),
new SqlParameter("@KFBZ",SqlDbType.VarChar)}
%号应该怎么样加
请那位大虾指点一下
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货