对查询出来的数据执行二次查询（DevExpress GridControl绑定数据）

来源：互联网发布：数据驱动安全百度云编辑：程序博客网时间：2024/06/07 15:08

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 '%" + CheckString.CheckStr(txtCusCompany.Text.Trim()) + "%'";            DataTable dt = new DataTable();            if (strWhere != " 1=1")            {//先克隆表结构                dt = ds.Tables[0].Clone();//查询数据并添加到dt中                DataRow[] newdr = ds.Tables[0].Select(strWhere, "id");                foreach (DataRow row in newdr)                {                    dt.Rows.Add(row.ItemArray);                }            }            else            {                dt = ds.Tables[0];            }            if (dt != null && dt.Rows.Count > 0)            {                gridControl1.DataSource = dt;            }            else            {                gridControl1.DataSource = null;            }        }

0 0