int pageSize = 50;//SystemSet._PAGESIZE; protected void Page_Load(object sender, EventArgs e) { Ajax.Utility.RegisterTypeForAjax(typeof(Zxyys)); singleProjectID = DNTRequest.GetQueryString("SingleProjectID"); workFlowID = DNTRequest.GetQueryString("WorkFlowID"); if (!IsPostBack) { if (!PublicModel.isCompany() || PublicModel.isLeader()) { ddlCompany.DataBindEx(singleProjectID, string.Concat(SystemSet._JSCOMPANYINFO, ",", SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO)); } else { ddlCompany.DataBindEx(singleProjectID, Common.Session.GetSessionInt("CompanyID")); } ctrlProjectBaseInfo1.DataBindEx(singleProjectID); //工程信息 rdbFileStatus.DataBindEx(true); ddlFileType.DataBindEx(Common.ConvertEx.ToInt(singleProjectID), "0", "BH"); if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlCompany"))) { ddlCompany.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlCompany")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlChangeFile"))) { ddlChangeFile.SelectedValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlChangeFile")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlFileType"))) { ddlFileType.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlFileType")).ToUpper(); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtTitle"))) { txtTitle.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtTitle")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtMyCode"))) { txtMyCode.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtMyCode")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("fileStatus"))) { rdbFileStatus.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("fileStatus")); } BindGridView(1); } }
/// <summary> /// 绑定工程下所有业务单位 /// </summary> protected void ddlSingleProject_MySelectChanged() { if (ddlSingleProject.SelectValue != "") { if (PublicModel.isLeader() || !PublicModel.isCompany()) { ddlCompany.DataBindEx(ddlSingleProject.SelectValue, string.Concat(SystemSet._JSCOMPANYINFO, ",", SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO)); } else { ddlCompany.DataBindEx(ddlSingleProject.SelectValue, Common.Session.GetSessionInt("CompanyID")); } } }
protected void Page_Load(object sender, EventArgs e) { //ddlCompany.MySelectChange += new DigiPower.Onlinecol.Standard.Web.CommonCtrl.ctrlDropDownCompanyInfo.SelectChange(ddlCompany_SelectedIndexChanged); Ajax.Utility.RegisterTypeForAjax(typeof(ZJList)); singleProjectID = DNTRequest.GetQueryString("SingleProjectID"); workFlowID = DNTRequest.GetQueryString("WorkFlowID"); projectType = DNTRequest.GetQueryString("ProjectType"); if (!this.IsPostBack) { if (!PublicModel.isCompany() || PublicModel.isLeader()) { ddlCompany.DataBindEx(singleProjectID, string.Concat(SystemSet._JSCOMPANYINFO, ",", SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO)); } else { ddlCompany.DataBindEx(singleProjectID, Common.Session.GetSessionInt("CompanyID")); } ctrlProjectBaseInfo1.DataBindEx(singleProjectID); //工程信息 string CompanyID = Common.Session.GetSession("CompanyID"); if (CompanyID != "") { ddlCompany.SelectValue = CompanyID; DataBindExMyCode(null); } boxType.DataBindEx(); ajlx.DataBindEx(); //mj.DataBindEx(); //bgqx.DataBindEx(); BindFileList(); BindTreeYZJ(); } }
/// <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) { T_SingleProject_MDL spMDL = spBLL.GetModel(Common.ConvertEx.ToInt(singleProjectID)); if (spMDL != null) { singleProjectNo = spMDL.gcbm; projecttype = spMDL.ProjectType; //取当前工程的所有归档目录 string strWhere = " SingleProjectID=" + singleProjectID; //不显示声像节点 //jdk 2014.11.16 strWhere += " AND BH not like '%S%' "; if (PublicModel.isCompany() && !PublicModel.isLeader()) //监理或施工只能看到自己的 { strWhere += " and operateuserid=" + Common.Session.GetSession("UserID"); } if (ConvertEx.ToBool(SystemSet._ISIGNATUREPDF)) { if (!string.IsNullOrWhiteSpace(ddliSignaturePdf.SelectedValue)) { strWhere += " AND iSignaturePdf=" + ddliSignaturePdf.SelectedValue + ""; //是否需要签章 } if (!string.IsNullOrWhiteSpace(ddlSignatureFinishFlag.SelectedValue)) //签章完成状态 { string tempStrWhere = " and iSignaturePdf=1 and IsFolder=0 and (SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID)>0 "; int signatureFinishFlag = ConvertEx.ToInt(ddlSignatureFinishFlag.SelectedValue); //签章是否完成标记 那已签章完成的记录跟需要签章的记录比对. if (signatureFinishFlag == 1) //签章完成 { tempStrWhere += "and (SELECT COUNT(1) from T_FileList_SignatureLog f0 where f0.FileListID=T_FileList.FileListID and f0.SignatureFinishFlag=1)"; tempStrWhere += ">=(SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID) "; strWhere += tempStrWhere; } else if (signatureFinishFlag == 0) //签章未完成 { tempStrWhere += "and (SELECT COUNT(1) from T_FileList_SignatureLog f0 where f0.FileListID=T_FileList.FileListID and f0.SignatureFinishFlag=1)"; tempStrWhere += "<(SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID) "; strWhere += tempStrWhere; } } } 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 + "%' "; } Session["FileInfostrWhere"] = strWhere; 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(); } }