/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pageIndex"></param>
public void BindGrid(int pageIndex)
{
//从窗口接收开始,都是馆里人员操作,不用考虑建设单位等身份
string strWhere = " AND A.SingleProjectID=" + Common.DNTRequest.GetQueryString("SingleProjectID");
if (PublicModel.isSuperAdmin())
{//管理员管理员获取所有工程
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'";
}
else if (PublicModel.isArchiveUser())
{//档案馆用户看自己的
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = trBll.GetListPaging(strWhere, pageSize, pageIndex, out itemCount, null);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(ChangePassword));
if (Common.Session.GetSession("UserID") == "")
{
Response.Redirect("/UserLoginGather.aspx");
}
if (!this.IsPostBack)
{
T_UsersInfo_MDL userMDL = userinfoBLL.GetModel(ConvertEx.ToInt(Common.Session.GetSession("UserID")));
if (userMDL != null)
{
UserName.Text = userMDL.UserName;
Mobile.Text = userMDL.Mobile;
Fax.Text = userMDL.Fax;
Tel.Text = userMDL.Tel;
LoginName.Text = userMDL.LoginName;
if (!PublicModel.isSuperAdmin())
{
CompanyName.readOnly = true;
}
T_Company_MDL companyMDL = new T_Company_BLL().GetModel(userMDL.CompanyID);
if (companyMDL != null)
{
ViewState["companyMDL"] = companyMDL;
CompanyName.Text = companyMDL.CompanyName;
}
ViewState["userMDL"] = userMDL;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(RoleAdd));
MyAddInit();
CTRL_AREA.MySelectChange += new DigiPower.Onlinecol.Standard.Web.CommonCtrl.ctrlDropDownArea.SelectChange(CompanySelectChange);
if (!this.IsPostBack)
{
RoleType.DataValueField = "SystemInfoCode";
RoleType.DataBindEx();
if (PublicModel.isSuperAdmin())
{
CTRL_AREA.BindDblArea(true, "");
}
else
{
CTRL_AREA.BindDblArea(true, "AREA_CODE='" + Common.Session.GetSession("AREA_CODE") + "'");
}
if ((CommonEnum.PageState)ViewState["ps"] == CommonEnum.PageState.VIEW)
{
btnSave.Visible = false;
}
CompanySelectChange();
BindPage(ID);
}
}
/// <summary>
/// 列表数据绑定
/// </summary>
/// <param name="pageIndex"></param>
private void BindGridView(int pageIndex)
{
string sqlWhere = " b.CompanyType !=" + SystemSet._ARCHIVE;
if (!String.IsNullOrWhiteSpace(txtLoginName.Text.Trim()))
{
sqlWhere += " And a.LoginName like '%" + txtLoginName.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtUserName.Text.Trim()))
{
sqlWhere += " And a.UserName like '%" + txtUserName.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtCompanyName.Text.Trim()))
{
sqlWhere += " And b.CompanyName like '%" + txtCompanyName.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtGcmc.Text.Trim()))
{
sqlWhere += " And d.gcmc like '%" + txtGcmc.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtGcdd.Text.Trim()))
{
sqlWhere += " And d.gcdd like '%" + txtGcdd.Text.Trim() + "%' ";
}
if (ddlUserType.SelectedValue != "0")
{
sqlWhere += " And lower(a.UserType)='" + ddlUserType.SelectedValue.Trim().ToLower() + "' ";
}
if (PublicModel.isSuperAdmin()) //超级管理员
{
sqlWhere += " And b.Area_Code like '" + Common.Session.GetSession("OLD_AREA_CODE") + "%' ";
}
else if (PublicModel.isArchiveUser()) //馆里用户
{
sqlWhere += " And b.Area_Code like '" + Common.Session.GetSession("AREA_CODE") + "%' ";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = userBLL.GetCompanyUserList(sqlWhere, pageSize, pageIndex, out itemCount);
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pageIndex"></param>
public void BindGrid(int pageIndex)
{
//工程状态必须走到了 整理接收 且没有入库 !=3722 才可以做补卷管理
string strWhere = " AND D.WorkFlow_DoStatus >=(select WorkFlowID from T_WorkFlow where LOWER(WorkFlowCode)='" +
SystemSet.EumWorkFlowCode.WINRECV.ToString().ToLower() + "') and d.Status!=3722 ";
if (PublicModel.isSuperAdmin()) //管理员管理员获取所有工程
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'";
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
}
else
{
if (PublicModel.isLeader()) //建设单位只看到自己
{
strWhere += " AND A.SingleProjectID in (select SingleProjectID from T_SingleProject A,(select distinct ConstructionProjectID from T_Construction_Project ";
strWhere += " where CompanyID=" + Common.Session.GetSession("CompanyID") + ") B where A.ConstructionProjectID=B.ConstructionProjectID)";
}
}
if (txtgcmc.Text.Trim().Length > 0)
{
strWhere += " AND D.gcmc LIKE '%" + txtgcmc.Text.Trim() + "%'";
}
if (txtgcbm.Text.Trim().Length > 0)
{
strWhere += " AND D.gcbm LIKE '%" + txtgcbm.Text + "%'";
}
if (txtajtm.Text.Trim().Length > 0)
{
strWhere += " AND A.ajtm like '%" + txtajtm.Text.Trim() + "%' ";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = archiveBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
protected void BindGrid(int pageIndex)
{
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
Hashtable ht = new Hashtable();
ht.Add("CompanyType", DNTRequest.GetQueryString("CompanyType"));
if (txtCompanyName.Text.Trim().Length > 0)
{
ht.Add("CompanyName", txtCompanyName.Text.Trim());
}
if (PublicModel.isSuperAdmin()) //超级管理员
{
ht.Add("Area_Code", Common.Session.GetSession("AREA_CODE"));
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
ht.Add("Area_Code", Common.Session.GetSession("OLD_AREA_CODE"));
}
else if (PublicModel.isLeader()) //建设单位
{
ht.Add("Area_Code", Common.Session.GetSession("OLD_AREA_CODE"));
if (DNTRequest.GetQueryInt("CompanyType", 0) == SystemSet._JSCOMPANYINFO)
{
ht.Add("CompanyID", Common.Session.GetSession("CompanyID"));
}
}
else
{
ht.Add("CompanyID", Common.Session.GetSession("CompanyID"));
}
DataTable dt = compBLL.GetListPaging(ht, pageSize, pageIndex, out itemCount);
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pageIndex"></param>
public void BindGrid(int pageIndex)
{
//从窗口接收开始,都是馆里人员操作,不用考虑建设单位等身份
string strWhere = " AND A.SingleProjectID=" + Common.DNTRequest.GetQueryString("SingleProjectID");
if (PublicModel.isSuperAdmin()) //管理员管理员获取所有工程
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'";
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
}
Hashtable ht = new Hashtable();
if (ddlChkStatus.SelectedValue != "") //关于审核状态,都是查询最后一次的审核信息
{
ht.Add("CheckStatus", ddlChkStatus.SelectedValue);
ht.Add("SingleProjectID", singleProjectID);
ht.Add("WorkFlowID", workFlowID);
}
if (txtXH.Text != "")
{
strWhere += " AND XH=" + ConvertEx.ToInt(txtXH.Text.Trim()) + "";
}
if (txtTitle.Text.Trim().Length > 0)
{
strWhere += " AND A.ajtm like '%" + txtTitle.Text.Trim() + "%' ";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = trBll.GetListPaging(strWhere, pageSize, pageIndex, out itemCount, ht);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindGridView(int pageIndex)
{
Hashtable ht = new Hashtable();
ht.Add("CodeType", SystemSet.EumReportType.ZRS.ToString());
if (PublicModel.isSuperAdmin()) //超级管理员
{
ht.Add("AREA_CODE", Common.Session.GetSession("AREA_CODE"));
}
if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
ht.Add("OLD_AREA_CODE", Common.Session.GetSession("OLD_AREA_CODE"));
}
if (!String.IsNullOrWhiteSpace(txtReadyCheckBookCode.Text.Trim()))
{
ht.Add("ReadyCheckBookCode", txtReadyCheckBookCode.Text.Trim());
}
if (!String.IsNullOrWhiteSpace(txtGcmc.Text.Trim()))
{
ht.Add("gcmc", txtGcmc.Text.Trim());
}
if (!String.IsNullOrWhiteSpace(txtGcbm.Text.Trim()))
{
ht.Add("gcbm", txtGcbm.Text.Trim());
}
if (ddlProjectType.SelectValue != "" && ddlProjectType.SelectValue != "0")
{
ht.Add("ProjectType", ddlProjectType.SelectValue);
}
if (ddlReadyCheckBookType.SelectedValue == "1") //已发放
{
ht.Add("ReadyCheckBookTypeFlag", 1);
}
if (ddlReadyCheckBookType.SelectedValue == "0") //未发放
{
ht.Add("ReadyCheckBookTypeFlag", 0);
}
Session["ZRS_HtStrWhere"] = ht;
DataTable dt = readBLL.GetListPaging(ht, pageSize, pageIndex, out itemCount);
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindGridView(int pageIndex)
{
string sqlWhere = " b.CompanyType=" + SystemSet._ARCHIVE;
if (PublicModel.isSuperAdmin())
{
sqlWhere += " And b.Area_Code like '%" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
}
if (PublicModel.isArchiveUser())
{
sqlWhere += " And b.Area_Code like '%" + Common.Session.GetSession("AREA_CODE") + "%'";
}
if (!String.IsNullOrWhiteSpace(ddlCompany.SelectValue))
{
sqlWhere += " And a.CompanyID=" + ddlCompany.SelectValue + "";
}
if (!String.IsNullOrWhiteSpace(txtRoleName.Text.Trim()))
{
sqlWhere += " And a.RoleName like '%" + txtRoleName.Text.Trim() + "%'";
}
if (!String.IsNullOrWhiteSpace(ddlRoleType.SelectValue))
{
sqlWhere += " And lower(a.RoleType) like '%" + ddlRoleType.SelectValue.ToLower() + "%'";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = roleBLL.GetListPaging(sqlWhere, pageSize, pageIndex, out itemCount);
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(OutHelpCompanyAdd));
MyAddInit();
txtFileList.Attributes("onkeydown", "return false");
if (!this.IsPostBack)
{
ctrlOutHelpRole.DataBindEx(null, SystemSet._OUTHELP_ROLETYPE);
if ((CommonEnum.PageState)ViewState["ps"] == CommonEnum.PageState.VIEW)
{
btnSave.Visible = false;
ctrlOutHelpRole.Enabled = false;
}
ctrlCompanyBaseInfo1.DataBindEx(ConvertEx.ToInt(ID));
ctrlCompanyBaseInfo1.SetCompanyTypeEnable(false);
ctrlCompanyBaseInfo1.CompanyTypeID = CompanyType;
ctrlCompanyBaseInfo1.SetAreaCodeEnable(false);
if ((CommonEnum.PageState)ViewState["ps"] == CommonEnum.PageState.EDIT)
{
ctrlOutHelpRole.Enabled = false;
if (PublicModel.isSuperAdmin())
{
ctrlOutHelpRole.Enabled = true;
}
List <T_UsersInfo_MDL> ltUserInfo = new T_UsersInfo_BLL().GetModelList("CompanyID=" + ID);
if (ltUserInfo.Count > 0)
{
HidUserID.Value = ConvertEx.ToString(ltUserInfo[0].UserID);
txtLogName.Text = ltUserInfo[0].LoginName;
txtLogName.enabled = false;
ctrlOutHelpRole.SelectValue = ltUserInfo[0].RoleID.ToString();
txtPwd.Attributes("value", DESEncrypt.Decrypt(ltUserInfo[0].Passwd));
txtPwd2.Attributes("value", DESEncrypt.Decrypt(ltUserInfo[0].Passwd));
txtFileList.Attributes("value", ltUserInfo[0].OwnerFileTmp);
ViewState["UserID"] = ConvertEx.ToString(ltUserInfo[0].UserID);
}
}
}
}
/// <summary>
/// 绑定
/// </summary>
/// <param name="pageIndex"></param>
private void BindGrid(int pageIndex)
{
DataTable dt = new DataTable();
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
if (PublicModel.isSuperAdmin())
{
string _where = "";
if (txtXMMC.Text.Trim().Length > 0)
{
_where += "AND A.xmmc like '%" + txtXMMC.Text.Trim() + "%'";
}
dt = bll1.GetListPaging("", "", "", pageSize, pageIndex, out itemCount, _where);
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
dt = bll1.GetListPaging("", "", Common.Session.GetSession("OLD_AREA_CODE"), pageSize, pageIndex, out itemCount);
}
else //其他人只能看自己的
{
dt = bll1.GetListPaging(Common.Session.GetSession("CompanyID"), Common.Session.GetSession("RoleID"), pageSize, pageIndex, out itemCount);
}
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定列表
/// </summary>
/// <param name="pageIndex"></param>
private void BindGridView(int pageIndex)
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 AND Status>=3721 AND WorkFlow_DoStatus=" + ViewState["workFlowID"].ToString());
strWhere.Append(" AND ProjectType in (select SystemInfoCode from T_SystemInfo where SystemInfoID in(" + ProjectType + ")) ");
if (kgsj1.Text.Trim().Length > 0)
{
strWhere.Append(" AND kgsj>='" + kgsj1.Text.Trim() + " 00:00:00.00 ' ");
}
if (kgsj2.Text.Trim().Length > 0)
{
strWhere.Append(" AND kgsj<='" + kgsj2.Text.Trim() + " 23:59:59.99' ");
}
if (jgsj1.Text.Trim().Length > 0)
{
strWhere.Append(" AND jgsj>='" + jgsj1.Text.Trim() + " 00:00:00.00 ' ");
}
if (jgsj2.Text.Trim().Length > 0)
{
strWhere.Append(" AND jgsj<='" + jgsj2.Text.Trim() + " 23:59:59.99' ");
}
if (txtGcbm.Text.Trim().Length > 0)
{
strWhere.Append(" AND gcbm like '%" + txtGcbm.Text.Trim() + "%' ");
}
if (txtGcmc.Text.Trim().Length > 0)
{
strWhere.Append(" AND gcmc like '%" + txtGcmc.Text.Trim() + "%' ");
}
if (txtGcdd.Text.Trim().Length > 0)
{
strWhere.Append(" AND gcdd like '%" + txtGcdd.Text.Trim() + "%' ");
}
if (txtghxkzh.Text.Trim().Length > 0)
{
strWhere.Append(" AND ghxkzh like '%" + txtghxkzh.Text.Trim() + "%' ");
}
if (txtsgxkzh.Text.Trim().Length > 0)
{
strWhere.Append(" AND sgxkzh like '%" + txtsgxkzh.Text.Trim() + "%' ");
}
if (ddlChargeUserID.SelectValue != "" && ddlChargeUserID.SelectValue != "0")
{
strWhere.Append(" AND ChargeUserID= " + ddlChargeUserID.SelectValue);
}
if (PublicModel.isSuperAdmin()) //超级管理员
{
strWhere.Append(" AND Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%'");
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
strWhere.Append(" AND Area_Code like '" + ConvertEx.ToString(Session["OLD_AREA_CODE"]) + "%'");
}
else if (PublicModel.isLeader()) //工程管理员(建设单位)也看全部
{
strWhere.Append(" AND ConstructionProjectID in (select ConstructionProjectID from T_Construction_Project where CompanyID=" + Common.Session.GetSession("CompanyID") + ")");
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = singleProjectBLL.GetListPaging(strWhere.ToString(), pageSize, pageIndex, out itemCount);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定列表
/// </summary>
/// <param name="pageIndex"></param>
private void BindGridView(int pageIndex)
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 ");
string CompanyID = "";
//只显示文件登记环节的工程 ,暂时未考虑多机构的问题
strWhere.Append(" AND d.WorkFlowID=" + PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.FILEREG.ToString()));
if (ddlProjectType.SelectValue != "" && ddlProjectType.SelectValue != "0")
{
strWhere.Append(" AND a.ProjectType=(select SystemInfoCode from T_SystemInfo where SystemInfoID=" + ddlProjectType.SelectValue + ") ");
}
if (kgsj1.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.kgsj>='" + kgsj1.Text.Trim() + " 00:00:00.00 ' ");
}
if (kgsj2.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.kgsj<='" + kgsj2.Text.Trim() + " 23:59:59.99' ");
}
if (jgsj1.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.jgsj>='" + jgsj1.Text.Trim() + " 00:00:00.00 ' ");
}
if (jgsj2.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.jgsj<='" + jgsj2.Text.Trim() + " 23:59:59.99' ");
}
if (txtGcbm.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.gcbm like '%" + txtGcbm.Text.Trim() + "%' ");
}
if (txtGcmc.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.gcmc like '%" + txtGcmc.Text.Trim() + "%' ");
}
if (txtGcdd.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.gcdd like '%" + txtGcdd.Text.Trim() + "%' ");
}
if (txtghxkzh.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.ghxkzh like '%" + txtghxkzh.Text.Trim() + "%' ");
}
if (txtsgxkzh.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.sgxkzh like '%" + txtsgxkzh.Text.Trim() + "%' ");
}
if (ddlChargeUserID.SelectValue != "" && ddlChargeUserID.SelectValue != "0")
{
strWhere.Append(" AND a.ChargeUserID= " + ddlChargeUserID.SelectValue);
}
if (PublicModel.isSuperAdmin()) //超级管理员
{
CompanyID = "0";
strWhere.Append(" and a.Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%'");
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
CompanyID = "0";
strWhere.Append(" and a.Area_Code like '" + ConvertEx.ToString(Session["OLD_AREA_CODE"]) + "%'");
}
else
{
if (Common.Session.GetSessionInt("CompanyType") == SystemSet._JSCOMPANYINFO) //其他人只能看自己的
{
CompanyID = Common.Session.GetSession("CompanyId");
}
else
{
CompanyID = "0";
strWhere.Append(" AND EXISTS(select SingleProjectID from T_SingleProjectCompany where ");
strWhere.Append("CompanyID=" + Common.Session.GetSession("CompanyId") + " AND SingleProjectID=a.SingleProjectID )");
}
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = singleProjectBLL.GetListPaging(ConvertEx.ToInt(CompanyID), strWhere.ToString(), pageSize, pageIndex, out itemCount);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定归档目录
/// </summary>
/// <param name="pageIndex"></param>
private void BindGridView(int pageIndex)
{
T_SingleProject_MDL spMDL = spBLL.GetModel(Common.ConvertEx.ToInt(singleProjectID));
if (spMDL != null)
{
projectType = spMDL.ProjectType;
string strWhere = " SingleProjectID=" + singleProjectID;
strWhere += " AND BH not like '%S%' "; //不显示声像节点
if (PublicModel.isSuperAdmin() || !PublicModel.isCompany()) //Leo 超级管理员看全部
{
}
else if (spMDL != null && spMDL.CompanyUserID == Common.ConvertEx.ToInt(Common.Session.GetSession("UserID"))) //Leo 工程管理员也看全部,档案馆的人也可以看全部
{
}
else
{
strWhere += " AND operateuserid=" + Common.Session.GetSession("UserID");
}
if (!String.IsNullOrWhiteSpace(txtMyCode.Text.Trim()))
{
strWhere += " AND MyCode LIKE '%" + txtMyCode.Text.Trim() + "%'";
}
if (!String.IsNullOrWhiteSpace(txtTitle.Text.Trim()))
{
strWhere += " AND TITLE LIKE '%" + txtTitle.Text.Trim() + "%'";
}
if (!String.IsNullOrWhiteSpace(rdbFileStatus.SelectValue) && rdbFileStatus.SelectValue != "0")
{
strWhere += " AND Status=" + rdbFileStatus.SelectValue;
}
if (!String.IsNullOrWhiteSpace(ddlCompany.SelectValue) && ddlCompany.SelectValue != "0")
{
T_Company_BLL compBLL = new T_Company_BLL();
T_Company_MDL compMDL = compBLL.GetModel(ConvertEx.ToInt(ddlCompany.SelectValue));
if (compMDL != null)
{
strWhere += " AND DefaultCompanyType=" + compMDL.CompanyType + "";
}
}
if (!String.IsNullOrWhiteSpace(ddlFileType.SelectValue) && ddlFileType.SelectValue != "0")
{
strWhere += " AND BH like '" + ddlFileType.SelectValue + "%' ";
}
if (!String.IsNullOrWhiteSpace(ddlChangeFile.SelectedValue))
{
var changeFile = ddlChangeFile.SelectedValue;
if (changeFile == "1") //有变更
{
strWhere += " AND ISNULL(version,0)=(SELECT TOP 1 ISNULL(f.RollBackCount,0)from T_WorkFlowDefine f where f.SingleProjectID=" + singleProjectID + " ";
strWhere += "AND f.WorkFlowID=" + PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.FILEREG.ToString()) + ") ";
}
if (changeFile == "0") //无变更
{
strWhere += " AND ISNULL(version,0) !=(SELECT TOP 1 ISNULL(f.RollBackCount,0)from T_WorkFlowDefine f where f.SingleProjectID=" + singleProjectID + " ";
strWhere += "AND f.WorkFlowID=" + PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.FILEREG.ToString()) + ") ";
}
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = fileListBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
}
private void BindGridView(int pageIndex)
{
Hashtable ht = new Hashtable();
ht.Add("NotInCompanyType", string.Concat(SystemSet._ARCHIVE, ",", SystemSet._SIGNATURECOMPANYINFO, ",", SystemSet._OUTHELPCOMPANYINFO));
if (ddlProjectType.SelectValue != "" && ddlProjectType.SelectValue != "0")
{
ht.Add("ProjectType", ddlProjectType.SelectValue);
}
if (kgsj1.Text.Trim().Length > 0)
{
ht.Add("kgsj", kgsj1.Text.Trim());
}
if (kgsj2.Text.Trim().Length > 0)
{
ht.Add("kgsj2", kgsj2.Text.Trim());
}
if (jgsj1.Text.Trim().Length > 0)
{
ht.Add("jgsj", jgsj1.Text.Trim());
}
if (jgsj2.Text.Trim().Length > 0)
{
ht.Add("jgsj2", jgsj2.Text.Trim());
}
if (txtGcbm.Text.Trim().Length > 0)
{
ht.Add("gcbm", txtGcbm.Text.Trim());
}
if (txtGcmc.Text.Trim().Length > 0)
{
ht.Add("gcmc", txtGcmc.Text.Trim());
}
if (txtGcdd.Text.Trim().Length > 0)
{
ht.Add("gcdd", txtGcdd.Text.Trim());
}
if (txtghxkzh.Text.Trim().Length > 0)
{
ht.Add("ghxkzh", txtghxkzh.Text.Trim());
}
if (txtsgxkzh.Text.Trim().Length > 0)
{
ht.Add("sgxkzh", txtsgxkzh.Text.Trim());
}
if (ddlChargeUserID.SelectValue != "" && ddlChargeUserID.SelectValue != "0")
{
ht.Add("ChargeUserID", ddlChargeUserID.SelectValue);
}
if (PublicModel.isSuperAdmin()) //超级管理员 Area_Code
{
ht.Add("Area_Code", Common.Session.GetSession("AREA_CODE"));
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
ht.Add("Area_Code", Common.Session.GetSession("OLD_AREA_CODE"));
}
else //建设单位看自己相关的,监理,施工无权限
{
ht.Add("CompanyId", Common.Session.GetSession("CompanyId"));
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = singleProjectBLL.GetListPaging(ht, pageSize, pageIndex, out itemCount);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定列表数据
/// </summary>
/// <param name="pageIndex"></param>
private void BindGrid(int pageIndex)
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 ");
string CompanyID = "0";
if (kgsj1.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.kgsj>='" + kgsj1.Text.Trim() + " 00:00:00.00 ' ");
}
if (kgsj2.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.kgsj<='" + kgsj2.Text.Trim() + " 23:59:59.99' ");
}
if (jgsj1.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.jgsj>='" + jgsj1.Text.Trim() + " 00:00:00.00 ' ");
}
if (jgsj2.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.jgsj<='" + jgsj2.Text.Trim() + " 23:59:59.99' ");
}
if (txtGcmc.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.gcmc like '%" + txtGcmc.Text.Trim() + "%' ");
}
if (txtGcdd.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.gcdd like '%" + txtGcdd.Text.Trim() + "%' ");
}
if (txtghxkzh.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.ghxkzh like '%" + txtghxkzh.Text.Trim() + "%' ");
}
if (txtsgxkzh.Text.Trim().Length > 0)
{
strWhere.Append(" AND a.sgxkzh like '%" + txtsgxkzh.Text.Trim() + "%' ");
}
if (ddlChargeUserID.SelectValue != "" && ddlChargeUserID.SelectValue != "0")
{
strWhere.Append(" AND a.ChargeUserID= " + ddlChargeUserID.SelectValue);
}
if (ddlProjectType.SelectValue != "" && ddlProjectType.SelectValue != "0")
{
strWhere.Append(" AND a.ProjectType=(select SystemInfoCode from T_SystemInfo where SystemInfoID=" + ddlProjectType.SelectValue + ") ");
}
if (ddl_WorkFlowName.SelectValue != "" && ddl_WorkFlowName.SelectValue != "0")
{
strWhere.Append(" AND d.WorkFlowID =" + ddl_WorkFlowName.SelectValue + " ");
}
if (PublicModel.isSuperAdmin()) //超级管理员看全部
{
strWhere.Append(" and a.Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%' ");
}
else if (PublicModel.isArchiveUser()) //档案馆的人看全部部分
{
strWhere.Append("and a.Area_Code = '" + ConvertEx.ToString(Session["OLD_AREA_CODE"]) + "' ");
}
else if (PublicModel.isLeader()) //工程管理员(建设单位)也看全部
{
CompanyID = Common.Session.GetSession("CompanyId");
}
else
{
CompanyID = "0";
strWhere.Append(" AND EXISTS(select distinct SingleProjectID from T_SingleProjectCompany where ");
strWhere.Append("CompanyID=" + Common.Session.GetSession("CompanyId") + " AND SingleProjectID=a.SingleProjectID )");
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = singleProjectBLL.GetListPaging(ConvertEx.ToInt(CompanyID), strWhere.ToString(), pageSize, pageIndex, out itemCount);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}