2023年6月21日发(作者：)

多条件查询，动态添加SqlParameter参数，动态添加where条件List ilist = new List();

(new SqlParameter("@Param1", "1")); (new SqlParameter("@Param2", "2")); (new SqlParameter("@Param3", "3")); (new SqlParameter("@Param4", "4")); (new SqlParameter("@ParamLike","%5%"));//Like的写法 SqlParameter[] param = y(); List listWhere = new List(); List listParameters = new List(); if (d) { ("Name like @name"); (new SqlParameter("name","%"++"%")); } if (d) { ("MobilePhone like @mobile"); (new SqlParameter("mobile", "%" + + "%")); } string sql = "select * from T_Customersn";

if ( > 0) { string sqlWhere = (" and ", y()); sql =sql+" where "+sqlWhere; } urce = eDataTable(sql, y());

2023年6月21日发(作者：)

多条件查询，动态添加SqlParameter参数，动态添加where条件List ilist = new List();

(new SqlParameter("@Param1", "1")); (new SqlParameter("@Param2", "2")); (new SqlParameter("@Param3", "3")); (new SqlParameter("@Param4", "4")); (new SqlParameter("@ParamLike","%5%"));//Like的写法 SqlParameter[] param = y(); List listWhere = new List(); List listParameters = new List(); if (d) { ("Name like @name"); (new SqlParameter("name","%"++"%")); } if (d) { ("MobilePhone like @mobile"); (new SqlParameter("mobile", "%" + + "%")); } string sql = "select * from T_Customersn";

if ( > 0) { string sqlWhere = (" and ", y()); sql =sql+" where "+sqlWhere; } urce = eDataTable(sql, y());