public void DataBindToGridview() { //string xKeGuanDep = "'"+ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 xKeGuanDep from ERPUser where UserName='******','")+"'")+"'"; //string ConditinonStr = " 1=1 "; //if (xKeGuanDep == "'所有部门'" || xKeGuanDep == "''") //{ //} //else //{ ConditinonStr = " Department in (" + xKeGuanDep + ") "; } ZWL.BLL.ERPUser MyModel = new ZWL.BLL.ERPUser(); //GVData.DataSource = MyModel.GetList("UserName Like '%" + this.TextBox1.Text + "%' and Department Like '%" + this.TextBox2.Text + "%' and " + ConditinonStr + " order by ID desc"); DataSet ds = MyModel.GetList("UserName Like '%" + this.TextBox1.Text + "%' and Department Like '%" + this.TextBox2.Text + "%' 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.ERPUser MyModel = new ZWL.BLL.ERPUser(); GVData.DataSource = MyModel.GetList("Department like '%" + this.TextBox1.Text.Trim() + "%' order by UserName asc"); 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.ERPUser MyModel = new ZWL.BLL.ERPUser(); DataSet ds = MyModel.GetList("Department like '%" + this.TextBox1.Text.Trim() + "%' order by UserName asc"); GVData.DataSource = ds; GVData.DataBind(); AspNetPager1.RecordCount = ds.Tables[0].Rows.Count; }
public void DataBindToGridview() { ZWL.BLL.ERPUser MyModel = new ZWL.BLL.ERPUser(); DataSet ds = MyModel.GetList("UserName Like '%" + this.TextBox1.Text + "%' and Department Like '%" + this.TextBox2.Text + "%' 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(); } }