public void DataBindToGridview() { ZWL.BLL.ERPJuanKu MyModel = new ZWL.BLL.ERPJuanKu(); GVData.DataSource = MyModel.GetList("JuanKuName Like '%" + this.TextBox1.Text + "%' and ( ','+CanViewUserList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' or UserName='******' ) order by ID desc"); GVData.DataBind(); LabPageSum.Text = Convert.ToString(GVData.PageCount); LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1)); this.GoPage.Text = LabCurrentPage.Text.ToString(); }
public void DataBindToGridview() { ZWL.BLL.ERPJuanKu MyModel = new ZWL.BLL.ERPJuanKu(); GVData.DataSource = MyModel.GetList("JuanKuName Like '%" + this.TextBox1.Text + "%' and ( ','+CanViewUserList+',' like '%,"+ZWL.Common.PublicMethod.GetSessionValue("UserName")+",%' or UserName='******' ) order by ID desc"); GVData.DataBind(); LabPageSum.Text = Convert.ToString(GVData.PageCount); LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1)); this.GoPage.Text = LabCurrentPage.Text.ToString(); }
public void DataBindToGridview() { GVData.PageSize = AspNetPager1.PageSize; GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1; ZWL.BLL.ERPJuanKu MyModel = new ZWL.BLL.ERPJuanKu(); DataSet ds = MyModel.GetList("JuanKuName Like '%" + this.TextBox1.Text + "%' order by ID desc"); GVData.DataSource = ds; GVData.DataBind(); AspNetPager1.RecordCount = ds.Tables[0].Rows.Count; }