public void DataBindToGridview() { GVData.PageSize = AspNetPager1.PageSize; GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1; ZWL.BLL.ERPWorkToDo MyModel = new ZWL.BLL.ERPWorkToDo(); DataSet ds = MyModel.GetList("WorkName Like '%" + this.TextBox1.Text + "%' and FormName Like '%" + this.TextBox2.Text + "%' and UserName Like '%" + this.TextBox3.Text + "%' order by ID desc"); GVData.DataSource = ds; GVData.DataBind(); AspNetPager1.RecordCount = ds.Tables[0].Rows.Count; }
public void DataBindToGridview() { GVData.PageSize = AspNetPager1.PageSize; GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1; ZWL.BLL.ERPWorkToDo MyModel = new ZWL.BLL.ERPWorkToDo(); DataSet ds = MyModel.GetList(" StateNow='正在办理' and ','+ShenPiRenList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' and WorkName Like '%" + this.TextBox1.Text + "%' and FormName Like '%" + this.TextBox2.Text + "%' and UserName Like '%" + this.TextBox3.Text + "%' order by ID desc"); GVData.DataSource = ds; GVData.DataBind(); AspNetPager1.RecordCount = ds.Tables[0].Rows.Count; }