WebForm AspxGridView前、后端配合实现数据源重置且清除当前过滤条件的方法
前台代码:执行表格的数据回发命令,调用后台的ASPxGridViewCustomCallback事件
function sbcz_Click(s,e)
{
ASPxGridView1.PerformCallback();
}
后台代码:
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e)
{
string parameters_list = e.Parameters;
if (!parameters_list.Contains("数据同步"))
{
ASPxGridView1.FilterExpression = string.Empty;//清除前端当前的过滤条件为空
zxsj_dt = SqlHelper.ExecuteDataTable("select * from 装卸数据", new SqlParameter[] { });
ASPxGridView1.DataSource = zxsj_dt;
ASPxGridView1.DataBind();
}
else
{
string[] para_string_array = parameters_list.Split(',');
if (para_string_array.Length > 1)
{
string ybh_array = para_string_array[1].ToString().Trim();
string[] ybh_sz = ybh_array.Split('-');
if (ybh_sz.Length > 0)
{
string flt_str = "";
foreach (string st in ybh_sz)
{
flt_str += "业编号=" + st + " or ";
}
if (flt_str.Length > 0)
{
flt_str = flt_str.Substring(0, flt_str.Length - 4);
}
zxsj_dt = zxsj_dt.Select(flt_str, "").CopyToDataTable();
}
}
else
{
zxsj_dt.Clear();
}
ASPxGridView1.DataSource = zxsj_dt;
ASPxGridView1.DataBind();
}
}
秋风写于淄博 业务联系与技术交流 QQ375172665