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);
}
