private void Search()
{
DataSet ds = new DataSet();
string sDeliveryTimeFrom = "";
string sDeliveryTimeTo = "";
string strWhere = " 1=1";
if (dateRechargeTimeStart.Text.Trim() != "")
sDeliveryTimeFrom = dateRechargeTimeStart.Text.Trim();
if (dateRechargeTimeEnd.Text.Trim() != "")
sDeliveryTimeTo = dateRechargeTimeEnd.Text.Trim();
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@DeliveryTimeFrom", sDeliveryTimeFrom), new SqlParameter("@DeliveryTimeTo", sDeliveryTimeTo) };
DB db = new DB();
ds = db.ExecuteProcDs("p_CargoStatInfo", sqlParams);
if (txtCusCompany.Text.Trim() != "")
strWhere += " and Company like '%"
对查询出来的数据执行二次查询(DevExpress GridControl绑定数据)
最新推荐文章于 2022-12-26 20:34:25 发布