/// <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; } }