public void DataBindToGridview() { ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); ZWL.BLL.ERPBuMen BuMenModel = new ZWL.BLL.ERPBuMen(); string Department_ID = BuMenModel.GetList("BuMenName='" + ZWL.Common.PublicMethod.GetSessionValue("Department") + "'").Tables[0].Rows[0]["ID"].ToString(); DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName='******'%" + this.TextBox1.Text + "%' and CHARINDEX('" + Department_ID + "',p_depart_ids)>0 order by ID desc"); if (ds!=null) { GVData.DataSource = ds; 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.ERPBuMen MyERPBuMen = new ZWL.BLL.ERPBuMen(); string DirID = "0"; try { DirID = Request.QueryString["DirID"].ToString(); } catch { } GVData.DataSource = MyERPBuMen.GetList("DirID=" + DirID + " and BuMenName Like '%"+this.TextBox1.Text+"%' 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.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); ZWL.BLL.ERPBuMen BuMenModel = new ZWL.BLL.ERPBuMen(); string Department_ID = BuMenModel.GetList("BuMenName='" + ZWL.Common.PublicMethod.GetSessionValue("Department") + "'").Tables[0].Rows[0]["ID"].ToString(); DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName='******'%" + this.TextBox1.Text + "%' and CHARINDEX('" + Department_ID + "',p_depart_ids)>0 order by ID desc"); if (ds != null) { GVData.DataSource = ds; 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.ERPBuMen MyERPBuMen = new ZWL.BLL.ERPBuMen(); string DirID = "0"; try { DirID = Request.QueryString["DirID"].ToString(); } catch { } GVData.DataSource = MyERPBuMen.GetList("DirID=" + DirID + " and BuMenName Like '%" + this.TextBox1.Text + "%' 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.ERPBuMen MyERPBuMen = new ZWL.BLL.ERPBuMen(); string DirID = "0"; try { DirID = Request.QueryString["DirID"].ToString(); } catch { } DataSet ds = MyERPBuMen.GetList("DirID=" + DirID + " and BuMenName Like '%" + this.TextBox1.Text + "%' order by ID desc"); GVData.DataSource = ds; GVData.DataBind(); AspNetPager1.RecordCount = ds.Tables[0].Rows.Count; }