/// <summary>
/// 页面数据绑定
/// </summary>
public void PageBind()
{
PageBase pb = new PageBase();
pb.TblName = "Tunnel_Img";
pb.FldName = "i_id";
pb.ProcedureName = "pagination";
pb.PageSize = pageSize;
if (cuttentPage == 0)
{
cuttentPage = pb.PageIndex;
}
pb.PageIndex = cuttentPage;
if (ul.LoginID == 1 || ul.JiaoSe(ul.LoginID) == "系统管理员" || ul.JiaoSe(ul.LoginID) == "总经理")
{
theEncoding = 1;
pb.StrWhere = "1=1 and i_name like '%" + name + "%' ";
}
else
{
pb.StrWhere = "1=1 and i_name like '%" + name + "%' and i_user=" + ul.LoginID;
}
int count = 0;
pb.DoCount = 1;
ti.GetList(pb, ref count); //获取总条数
pb.DoCount = 0;
if (false)
{
cuttentPage = cuttentPage - 1;
pb.PageIndex = cuttentPage;
}
List <Tunnel.Model.Tunnel_Img> modelList = new List <Tunnel.Model.Tunnel_Img>();
modelList = ti.GetList(pb, ref count);//获取分页结果
//数据绑定
DataList1.DataSource = modelList;
DataList1.DataBind();
//数据分页
MTCPager1.PageSize = pageSize;
MTCPager1.RecordCount = count;
MTCPager1.PageIndex = cuttentPage;
if (count <= pb.PageSize)
{
MTCPager1.Visible = false;
}
else
{
MTCPager1.Visible = true;
}
}
/// <summary>
/// 页面数据绑定
/// </summary>
public void PageBind()
{
PageBase pb = new PageBase();
pb.TblName = "Tunnel_Img";
pb.FldName = "i_id";
pb.ProcedureName = "pagination";
pb.PageSize = pageSize;
if (cuttentPage == 0)
{
cuttentPage = pb.PageIndex;
}
pb.PageIndex = cuttentPage;
if (ul.LoginID == 1 || ul.JiaoSe(ul.LoginID) == "系统管理员" || ul.JiaoSe(ul.LoginID) == "总经理")
{
theEncoding = 1;
#region 判断条件
if (name != "")
{
if (this.ddlYear.SelectedValue == "" && ddlType.SelectedValue == "")
{
pb.StrWhere = " i_name like '%" + name + "%' ";
}
else if (this.ddlYear.SelectedValue != "" && ddlType.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_name like '%{0}%' i_year ='{1}'", name, ddlYear.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_name like '%{0}%' i_type ='{1}'", name, ddlType.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue != "")
{
pb.StrWhere = string.Format(" i_name like '%{0}%' and i_year='{1}' and i_type='{2}'", name, ddlYear.SelectedValue.ToString(), ddlType.SelectedValue);
}
}
else
{
if (this.ddlYear.SelectedValue != "" && ddlType.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_year ='{0}'", ddlYear.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_type ='{0}'", ddlType.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue != "")
{
pb.StrWhere = string.Format(" i_year='{0}' and i_type='{1}'", ddlYear.SelectedValue.ToString(), ddlType.SelectedValue);
}
else if (ddlType.SelectedValue == "" && this.ddlYear.SelectedValue == "")
{
pb.StrWhere = "";
}
}
#endregion
}
else
{
#region 判断条件
if (name != "")
{
if (this.ddlYear.SelectedValue == "" && ddlType.SelectedValue == "")
{
pb.StrWhere = " i_name like '%" + name + "%' ";
}
else if (this.ddlYear.SelectedValue != "" && ddlType.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_name like '%{0}%' i_year ='{1}'", name, ddlYear.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_name like '%{0}%' i_type ='{1}'", name, ddlType.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue != "")
{
pb.StrWhere = string.Format(" i_name like '%{0}%' and i_year='{1}' and i_type='{2}'", name, ddlYear.SelectedValue.ToString(), ddlType.SelectedValue);
}
}
else
{
if (this.ddlYear.SelectedValue != "" && ddlType.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_year ='{0}'", ddlYear.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue == "")
{
pb.StrWhere = string.Format(" i_type ='{0}'", ddlType.SelectedValue.ToString());
}
else if (ddlType.SelectedValue != "" && this.ddlYear.SelectedValue != "")
{
pb.StrWhere = string.Format(" i_year='{0}' and i_type='{1}'", ddlYear.SelectedValue.ToString(), ddlType.SelectedValue);
}
else if (ddlType.SelectedValue == "" && this.ddlYear.SelectedValue == "")
{
pb.StrWhere = "";
}
}
#endregion
}
int count = 0;
pb.DoCount = 1;
ti.GetList(pb, ref count); //获取总条数
pb.DoCount = 0;
if (false)
{
cuttentPage = cuttentPage - 1;
pb.PageIndex = cuttentPage;
}
List <Tunnel.Model.Tunnel_Img> modelList = new List <Tunnel.Model.Tunnel_Img>();
modelList = ti.GetList(pb, ref count);//获取分页结果
//数据绑定
DataList1.DataSource = modelList;
DataList1.DataBind();
//数据分页
MTCPager1.PageSize = pageSize;
MTCPager1.RecordCount = count;
MTCPager1.PageIndex = cuttentPage;
if (count <= pb.PageSize)
{
MTCPager1.Visible = false;
}
else
{
MTCPager1.Visible = true;
}
}