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