protected void Page_Load(object sender, EventArgs e) { ProjectType = DNTRequest.GetQueryString("Archive_Form"); if (!IsPostBack) { ddlProjectType.DataBindEx(true); ddlProjectType.SelectValue = ProjectType; ddlProjectType.Enabled = false; ddlChargeUserID.BindDataByCompanyID("", true, SystemSet._ROLECODE_CHARGEUSER, Common.Session.GetSession("OLD_AREA_CODE")); if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlProjectType"))) { ddlProjectType.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlProjectType")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("kgsj1"))) { kgsj1.Text = Server.UrlDecode(DNTRequest.GetQueryString("kgsj1")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("kgsj2"))) { kgsj2.Text = Server.UrlDecode(DNTRequest.GetQueryString("kgsj2")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("jgsj1"))) { jgsj1.Text = Server.UrlDecode(DNTRequest.GetQueryString("jgsj1")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("jgsj2"))) { jgsj2.Text = Server.UrlDecode(DNTRequest.GetQueryString("jgsj2")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtGcbm"))) { txtGcbm.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtGcbm")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtGcmc"))) { txtGcmc.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtGcmc")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtGcdd"))) { txtGcdd.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtGcdd")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlChargeUserID"))) { ddlChargeUserID.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlChargeUserID")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtghxkzh"))) { txtghxkzh.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtghxkzh")); } if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtsgxkzh"))) { txtsgxkzh.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtsgxkzh")); } ViewState["workFlowID"] = PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.IMPORT_TO.ToString()); BindGridView(AspNetPager.CurrentPageIndex); } }
public bool CheckSingleWorkFlowStatus(string workFlowID, string workFlowCode) { if (ConvertEx.ToInt(workFlowID) >= PublicModel.getWorkFlowIdByWorkFlowCode(workFlowCode)) { return(true); } else { return(false); } }
/// <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(); }
public string ExportToJson(int singleProjectID) { try { string jsonFileName = string.Empty; T_FileList_BLL fileListBLL = new T_FileList_BLL(); T_SingleProject_MDL singleMDL = singleProjectBLL.GetModel(singleProjectID); if (singleMDL != null) { if (singleMDL.WorkFlow_DoStatus != PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.FILEREG.ToString())) { return(SystemSet._RETURN_FAILURE_VALUE); } XmlDocument xmldoc = new XmlDocument(); XmlDeclaration xmldecl = xmldoc.CreateXmlDeclaration("1.0", "utf-8", null); xmldoc.AppendChild(xmldecl); XmlElement RESULT = xmldoc.CreateElement("RESULT"); xmldoc.AppendChild(RESULT); AppendChildXML(RESULT, xmldoc.CreateElement("GCMC"), singleMDL.gcmc); AppendChildXML(RESULT, xmldoc.CreateElement("GCBM"), singleMDL.gcbm); AppendChildXML(RESULT, xmldoc.CreateElement("SINGLEPROJECTID"), singleMDL.SingleProjectID.ToString()); AppendChildXML(RESULT, xmldoc.CreateElement("USERID"), Session["UserID"].ToString()); AppendChildXML(RESULT, xmldoc.CreateElement("OUT_DATE"), DateTime.Now.ToString("yyyy-MM-dd")); AppendChildXML(RESULT, xmldoc.CreateElement("ZRR"), Session["CompanyName"].ToString()); XmlElement FILETYPES = xmldoc.CreateElement("FILETYPES"); RESULT.AppendChild(FILETYPES); string strWhere = "singleprojectid=" + singleProjectID + " and DefaultCompanyType=" + Common.Session.GetSession("CompanyType") + " and BH NOT LIKE 'S%' "; DataTable dt = fileListBLL.GetList(600, strWhere, " BH asc").Tables[0]; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { XmlElement FILETYPE = xmldoc.CreateElement("FILETYPE"); FILETYPE.InnerText = string.Concat(ConvertEx.ToString(row["BH"]), "-", ConvertEx.ToString(row["Title"])); strWhere = " isfolder=1 and BH NOT LIKE 'S%' and pid=" + ConvertEx.ToString(row["RECID"]) + " "; if (fileListBLL.GetCount(strWhere) < 1) { FILETYPE.SetAttribute("SELECTED", "1"); } else { FILETYPE.SetAttribute("SELECTED", "0"); } FILETYPE.SetAttribute("FID", ConvertEx.ToString(row["PID"])); FILETYPE.SetAttribute("PID", ConvertEx.ToString(row["OldRecID"])); FILETYPES.AppendChild(FILETYPE); } } jsonFileName = String.Concat(SystemSet._RETURN_SUCCESS_VALUE, DateTime.Now.ToString("yyyyMMddHHmmss").ToString(), ".json"); xmldoc.Save(Server.MapPath("../Upload/TempReport/" + jsonFileName)); } return(jsonFileName); } catch (Exception ex) { return(SystemSet._RETURN_FAILURE_VALUE + ex.Message); } }
/// <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(); } }
public bool UpdateSingleProjectStatus(string SingleProjectID) { bool flag = false; T_SingleProject_MDL singleMDL = singleProjectBLL.GetModel(ConvertEx.ToInt(SingleProjectID)); if (singleMDL != null && singleMDL.Status == 3722 && singleMDL.WorkFlow_DoStatus == PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.IMPORT_TO.ToString())) //工程已入库,工程流程处于 移交入库 { singleMDL.Status = 3721; singleProjectBLL.Update(singleMDL); flag = true; PublicModel.writeLog(SystemSet.EumLogType.UpdData.ToString(), string.Concat("T_SingleProject;key=", SingleProjectID, ";gcbm=", singleMDL.gcbm, ";gcmc=", singleMDL.gcmc, ";工程重新入库")); } return(flag); }