/// <summary> /// 绑定角色信息 /// </summary> private void DBindMyRole(string rName) { #region 分页 string sqlWhere = ""; int pageNum = 1; if (!string.IsNullOrEmpty(Request.QueryString["RName"])) { rName = Request.QueryString["RName"]; } if (!string.IsNullOrEmpty(rName)) { sqlWhere = " Role_Name like '%" + rName.Trim() + "%'"; } try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception) { pageNum = 1; } string sql = mRole.GetListRoleInfo(rName); //分页方法 Pager1.GetDataBind("Repeater", "RepeaterMyRole", sql, pageNum, 10, "", "rownum", "SystemRoleInfo.aspx?id=" + Request.QueryString["id"] + "&RName=" + rName + "&"); #endregion }
private void BindData(bool isFirstPage) { var user = HttpContext.Current.Session["CurrentUser"] as Admin.Model.OrgUsers; #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by CreateDate desc,PTID DESC) as rownum,* FROM ProfType where 1=1 "; if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptList", sql, pageNum, pageSize, "", "rownum", "ProfType.aspx?id=" + Request.QueryString["id"] + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by CreateDate desc) as rownum,* FROM AdvisoryList where 1=1 and AdvisoryList.MType=1 "; var name = string.Empty; var status = string.Empty; //if (!string.IsNullOrEmpty(ddlStatus.SelectedValue) && ddlStatus.SelectedValue != "-1") { // status = ddlStatus.SelectedValue; // sql += " and Status =" + status; //} if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and Contact like '%" + name.Trim() + "%'"; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptListWork", sql, pageNum, pageSize, "", "rownum", "Advisory.aspx?ProName=" + name + "&Status=" + status + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { if (!string.IsNullOrEmpty(ddlSendType.SelectedValue)) { name = ddlSendType.SelectedValue; } if (!string.IsNullOrEmpty(name)) { var rpmodel = _dataDal.GetModel(Convert.ToInt32(name)); if (null != rpmodel) { if (rpmodel.Status == 0) { litMsg.Text = "<tr><td colspan=4 style=\"text-align: center;\"><span class=\"label label-important\" style=\"font-size:20px;line-height:20px;\">总站资源包未送审或发布,无法查看对应的铁路局资源包</span></td></tr>"; rptListWork.DataSource = null; rptListWork.DataBind(); } else { litMsg.Text = ""; Orpid = Convert.ToInt32(rpmodel.ORPID); #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 var sql = "select row_number() over(order by OrgOrganize.OrgId DESC) as rownum,OrgOrganize.* from OrgOrganize "; sql += " where OrgOrganize.OrgType=2 and OrgOrganize.Status=1 "; if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptListWork", sql, pageNum, pageSize, "", "rownum", "StaPackage.aspx?AreaId=" + Request.QueryString["AreaId"] + "&name=" + name + "&"); #endregion } } } }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { var orgid = Request.QueryString["orgid"]; var rpid = Request.QueryString["rpid"]; if (!string.IsNullOrEmpty(orgid) && !string.IsNullOrEmpty(rpid)) { var rpkmodel = _rootPackageDal.GetModel(Convert.ToInt32(rpid)); if (null != rpkmodel) { litInfo.Text = rpkmodel.RPName; } var omodel = _dataDal.GetModel(Convert.ToInt64(orgid)); if (null != omodel) { litInfo.Text += "-" + omodel.OrgName; } #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by oo.Addtime desc,oo.OrgId DESC) as rownum,oo.*,opl.SSPID,opl.SPID,opl.Status as sstatus from dbo.OrgOrganize oo join StaPackage spk on spk.OrgId=oo.OrgId join OrgPkgList opl on opl.SPID=spk.SPID where opl.OrgId='" + orgid + "' and opl.RPID='" + rpid + "' "; if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptListWork", sql, pageNum, pageSize, "", "rownum", "OrgWorkStation.aspx?orgid=" + Request.QueryString["orgid"] + "&rpid=" + rpid + "&"); #endregion } else { rptListWork.DataSource = null; rptListWork.DataBind(); } }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by oo.Addtime desc,oo.OrgId DESC) as rownum,oo.* FROM OrgOrganize oo where oo.[Status]=1 and OrgType=1 "; //sql += " left join SWCompany sw on sw.[SWOrgId]=oo.[OrgId] left join OrgOrganize os on sw.[COrgId]=os.[OrgId] "; //sql += " where oo.[Status]=1 and oo.[OrgType]=5 and oo.AreaId in (select AreaId from [dbo].[getOrgAreaChild]('" + Request.QueryString["AreaId"] + "')) "; var name = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and oo.OrgName like '%" + name + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["name"])) { name = Request.QueryString["name"]; txtRealName.Value = name; sql += " and oo.OrgName like '%" + name + "%' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptListWork", sql, pageNum, pageSize, "", "rownum", "OrgWorkStation.aspx?AreaId=" + Request.QueryString["AreaId"] + "&name=" + name + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by OrgEmployees.Addtime desc,OrgEmployees.EmplId DESC) as rownum,OrgEmployees.*,OrgUsers.UId,OrgUsers.LastLoginTime,OrgUsers.Type ,OrgOrganize.OrgName,OrgUsers.UserName FROM OrgEmployees join OrgUsers on OrgUsers.EmplId=OrgEmployees.EmplId left join OrgOrganize on OrgOrganize.OrgId=OrgEmployees.OrgId and OrgOrganize.Status=1 where OrgEmployees.Status=1 and OrgUsers.Status=1"; var name = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and EmplName like '%" + name + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["name"])) { name = Request.QueryString["name"]; txtRealName.Value = name; sql += " and EmplName like '%" + name + "%' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptList", sql, pageNum, pageSize, "", "rownum", "OrgUserDep.aspx?id=" + Request.QueryString["id"] + "&name=" + name + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by oo.CreateDate desc) as rownum,oo.* FROM Advertisement oo where 1=1 "; var name = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and oo.AName like '%" + name + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["name"])) { name = Request.QueryString["name"]; txtRealName.Value = name; sql += " and oo.AName like '%" + name + "%' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptListWork", sql, pageNum, pageSize, "", "rownum", "Default.aspx?name=" + name + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by li.LId desc) as rownum,li.* ,oa.AreaName from LandInfo li join OrgArea oa on oa.AreaId=li.AreaId and oa.AreaId in (select AreaId from [dbo].[getOrgAreaChild]('" + Request.QueryString["AreaId"] + "'))"; var name = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and LName like '%" + name.Trim() + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["name"])) { name = Request.QueryString["name"]; txtRealName.Value = name; sql += " and LName like '%" + name + "%' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptList", sql, pageNum, pageSize, "", "rownum", "AreaMain.aspx?id=" + Request.QueryString["id"] + "&name=" + name + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 1; //分页查询语句 string sql = "select row_number() over(order by Addtime desc,EmplId DESC) as rownum,* FROM OrgEmployees where Status=1 "; var name = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and EmplName like '%" + name + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["name"])) { name = Request.QueryString["name"]; txtRealName.Value = name; sql += " and EmplName like '%" + name + "%' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptList", sql, pageNum, pageSize, "", "rownum", "OrgDep.aspx?id=" + Request.QueryString["id"] + "&name=" + name + "&"); #endregion }
/// <summary> /// 绑定会员信息 /// </summary> private void DBindMyMember(string rName, string contact, string createDate, string createDateEnd) { #region 分页 string sqlWhere = " a.Status!=2 "; if (!string.IsNullOrEmpty(rName)) { sqlWhere += " and RealName like '%" + rName + "%'"; } if (!string.IsNullOrEmpty(createDate) && string.IsNullOrEmpty(createDateEnd)) { sqlWhere += " and convert(varchar(10),CreateDate,120)>='" + createDate + "'";; } if (string.IsNullOrEmpty(createDate) && !string.IsNullOrEmpty(createDateEnd)) { sqlWhere += " and convert(varchar(10),CreateDate,120)<='" + createDateEnd + "'"; } if (!string.IsNullOrEmpty(createDate) && !string.IsNullOrEmpty(createDateEnd)) { sqlWhere += " and convert(varchar(10),CreateDate,120) between '" + createDate + "' and '" + createDateEnd + "' "; } //分页查询语句 string sql = mUa.GetListUserAccount(sqlWhere); try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { throw ex; } //分页方法 Pager1.GetDataBind("Repeater", "RepeaterMyMember", sql, pageNum, 10, "", "rownum", "SystemMember.aspx?id=" + Request.QueryString["id"] + "&rName=" + rName + "&contact=" + contact + "&createDate=" + createDate + "&createDateEnd=" + createDateEnd + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by oo.CreateDate desc,oo.PIID DESC) as rownum,oo.*,ProfType.Name as TName FROM ProfInfo oo left join ProfType on ProfType.PTID=oo.PTID where oo.status=1 "; var name = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and oo.Name like '%" + name + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["name"])) { name = Request.QueryString["name"]; txtRealName.Value = name; sql += " and oo.Name like '%" + name + "%' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptListWork", sql, pageNum, pageSize, "", "rownum", "ProfInfo.aspx?name=" + name + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { #region 分页 //当前页码 int pageNum = 1; int pageSize = 20; //分页查询语句 if (string.IsNullOrEmpty(sort)) { sort = "a.IID"; } hfsort.Value = sort; string sql = "select row_number() over(order by " + sort + " desc) as rownum,RootPackage.RPName,a.minDate,a.maxDate,Infos.IID,Infos.IName,Infos.IType,Infos.NType,a.ttime,a.atime,a.vcount,OrgOrganize.OrgName,InfoType.IName as TName from Infos left join (select CONVERT(varchar(100), max(VisitDate), 20) as maxDate,CONVERT(varchar(100), min(VisitDate), 20) as minDate,VisitLog.IID,sum(StayDate) as ttime,avg(StayDate) as atime,count(*) as vcount from VisitLog where 1=1 "; //var rpid = string.Empty; //if (!string.IsNullOrEmpty(ddlSendType.SelectedValue) && "-1" != ddlSendType.SelectedValue) //{ // rpid = ddlSendType.SelectedValue; // sql += " and VisitLog.RPID ='" + rpid + "' "; // if (!string.IsNullOrEmpty(DropDownList1.SelectedValue) && "-1" != DropDownList1.SelectedValue) // { // sql += " and VisitLog.OrgId ='" + DropDownList1.SelectedValue + "' "; // } //} //var sdate = string.Empty; //if (!string.IsNullOrEmpty(txtRealName.Value)) //{ // sdate = txtRealName.Value; // sql += " and VisitDate>='" + Convert.ToDateTime(txtRealName.Value) + "' "; //} //var edate = string.Empty; //if (!string.IsNullOrEmpty(Text1.Value)) //{ // edate = Text1.Value; // sql += " and VisitDate<='" + Convert.ToDateTime(Text1.Value) + "' "; //} sql += " group by VisitLog.IID) a on Infos.IID=a.IID join TempInfo on TempInfo.TIID=Infos.TIID left join InfoType on InfoType.ITID=TempInfo.ITID join StaPackage on StaPackage.SPID=InfoType.SPID "; var rpid = string.Empty; if (!string.IsNullOrEmpty(ddlSendType.SelectedValue) && "-1" != ddlSendType.SelectedValue && !string.IsNullOrEmpty(DropDownList1.SelectedValue) && "-1" != DropDownList1.SelectedValue) { rpid = ddlSendType.SelectedValue; sql += " and StaPackage.SPID in (select SPID from OrgPkgList where RPID='" + rpid + "' and OrgId='" + DropDownList1.SelectedValue + "') "; } sql += " left join OrgOrganize on OrgOrganize.OrgId=StaPackage.OrgId left join RootPackage on RootPackage.RPID=StaPackage.RPID where 1=1 "; if (!string.IsNullOrEmpty(ddlSendType.SelectedValue) && "-1" != ddlSendType.SelectedValue) { rpid = ddlSendType.SelectedValue; sql += " and RootPackage.RPID ='" + rpid + "' "; } var sdate = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { sdate = txtRealName.Value; sql += " and a.minDate>='" + Convert.ToDateTime(txtRealName.Value).ToString("yyyy-MM-dd HH:mm:ss") + "' "; } var edate = string.Empty; if (!string.IsNullOrEmpty(Text1.Value)) { edate = Text1.Value; sql += " and a.maxDate<='" + Convert.ToDateTime(Text1.Value).ToString("yyyy-MM-dd HH:mm:ss") + "' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptListWork", sql, pageNum, pageSize, "", "rownum", "Default.aspx?sort=" + sort + "&orgid=" + DropDownList1.SelectedValue + "&sdate=" + sdate + "&edate=" + edate + "&rpid=" + rpid + "&"); #endregion }
/// <summary> /// 绑定数据 /// </summary> /// <param name="isFirstPage">搜索和删除用true IsPostBack用false</param> private void BindData(bool isFirstPage) { var user = HttpContext.Current.Session["CurrentUser"] as Admin.Model.OrgUsers; #region 分页 //当前页码 int pageNum = 1; int pageSize = 10; //分页查询语句 string sql = "select row_number() over(order by ComInfo.CreateDate desc,ComInfo.ID DESC) as rownum,ComInfo.*,OrgEmployees.EmplName FROM ComInfo left join OrgUsers on OrgUsers.UId=ComInfo.UId left join OrgEmployees on OrgEmployees.EmplId=OrgUsers.EmplId where 1=1 ";// and ComInfo.UId= " + user.UId; var name = string.Empty; if (!string.IsNullOrEmpty(txtRealName.Value)) { name = txtRealName.Value; sql += " and ComName like '%" + name + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["name"])) { name = Request.QueryString["name"]; txtRealName.Value = name; sql += " and ComName like '%" + name + "%' "; } var uname = string.Empty; if (!string.IsNullOrEmpty(txtUser.Value)) { uname = txtUser.Value; sql += " and OrgEmployees.EmplName like '%" + uname + "%' "; } else if (!string.IsNullOrEmpty(Request.QueryString["uname"])) { uname = Request.QueryString["uname"]; txtUser.Value = name; sql += " and OrgEmployees.EmplName like '%" + uname + "%' "; } var sdate = string.Empty; if (!string.IsNullOrEmpty(Text1.Value)) { sdate = Text1.Value; sql += " and ComInfo.CreateDate>='" + Convert.ToDateTime(Text1.Value).ToString("yyyy-MM-dd HH:mm:ss") + "' "; } var edate = string.Empty; if (!string.IsNullOrEmpty(Text2.Value)) { edate = Text2.Value; sql += " and ComInfo.CreateDate<='" + Convert.ToDateTime(Text2.Value).ToString("yyyy-MM-dd HH:mm:ss") + "' "; } if (!isFirstPage) { try { if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断 { pageNum = Convert.ToInt32(Request.QueryString["Page"]); } } catch (Exception ex) { pageNum = 1; } } //分页方法 Pager1.GetDataBind("Repeater", "rptList", sql, pageNum, pageSize, "", "rownum", "Default.aspx?id=" + Request.QueryString["id"] + "&name=" + name + "&sdate=" + sdate + "&edate=" + edate + "&uname=" + uname + "&"); #endregion }