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();
}
}
