/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
T_FileList_BLL fileListBLL = new T_FileList_BLL();
T_WorkFlowDoResult_BLL doResultBLL = new T_WorkFlowDoResult_BLL();
string[] FileListIDS = DNTRequest.GetQueryString("FileListIDS").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] MustSubmitFlags = DNTRequest.GetQueryString("mustSubmitFlags").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (var i = 0; i < FileListIDS.Length; i++)
{
T_FileList_MDL fileListMDL = fileListBLL.GetModel(ConvertEx.ToInt(FileListIDS[i]));
if (fileListMDL != null && !fileListMDL.IsFolder)
{
T_WorkFlowDoResult_MDL doResultMDL = new T_WorkFlowDoResult_MDL();
doResultMDL.FileListID = ConvertEx.ToInt(FileListIDS[i]);
doResultMDL.SingleProjectID = DNTRequest.GetQueryInt("SingleProjectID", 0);
doResultMDL.WorkFlowID = DNTRequest.GetQueryInt("workFlowID", 0);
doResultMDL.DoUserID = Common.ConvertEx.ToInt(Common.Session.GetSessionInt("UserID"));
doResultMDL.DoDateTime = System.DateTime.Now;
doResultMDL.DoResult = ddlDoResult.SelectedValue;
doResultMDL.DoRemark = DoRemark.Text.Trim();
doResultBLL.Add(doResultMDL);
fileListMDL.Remark = DoRemark.Text.Trim();
fileListMDL.MustSubmitFlag = ConvertEx.ToBool(MustSubmitFlags[i]);
fileListBLL.Update(fileListMDL);
FileAccept(FileListIDS[i], ConvertEx.ToBool(ddlDoResult.SelectedValue));
}
}
Common.MessageBox.CloseLayerOpenWeb(this.Page);
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
BLL.T_FileList_BLL docBLL = new T_FileList_BLL();
Model.T_FileList_MDL docMDL = docBLL.GetModel(Common.ConvertEx.ToInt(DropDownList1.SelectedValue));
if (docMDL != null)
{
Label1.Text = docMDL.BH;
}
}
public string ArchiveCheckByManualCount(string singleProjectIDS)
{
T_FileList_BLL fileListBLL = new T_FileList_BLL();
List <string> ltResult = new List <string>();
string[] SplitSingleProjectID = singleProjectIDS.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string singleProjectID in SplitSingleProjectID)
{
DataTable dt = fileListBLL.GetFileListThanManualCount(singleProjectID);
if (dt != null)
{
List <string> ltFileResult = new List <string>();
int ArchiveID = 0;
int SingleProjectID = 0;
foreach (DataRow row in dt.Rows)
{
if (SingleProjectID == 0 || SingleProjectID != Common.ConvertEx.ToInt(row["SingleProjectID"]))
{
ltResult.Add("************************************************************");
ltResult.Add(string.Concat("工程编号:", row["gcbm"], " 工程名称:", row["gcmc"]));
}
if (ArchiveID == 0 || ArchiveID != Common.ConvertEx.ToInt(row["ArchiveID"]))
{
ltResult.Add("-------------------------------------------------------------------------");
ltResult.Add(string.Concat("案卷序号:", row["xh"], " 案卷题名-", row["ajtm"]));
}
ltResult.Add(string.Concat("文件序号:", row["OrderIndex"], " 文件编号:", row["BH"],
" 文件题名:", row["Title"], " 实体页数:", row["ManualCount"]));
ArchiveID = Common.ConvertEx.ToInt(row["ArchiveID"]);
SingleProjectID = Common.ConvertEx.ToInt(row["SingleProjectID"]);
}
}
}
if (ltResult.Count > 0)
{
string txtFileName = Guid.NewGuid().ToString() + ".txt";
FileStream fs1 = new FileStream(Server.MapPath("/Upload/TempReport/" + txtFileName), FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs1);
foreach (string str in ltResult)
{
sw.WriteLine(str);
}
sw.Close();
fs1.Close();
return(txtFileName);
}
else
{
return("0");
}
}
public DataTable GetFileListTable(string Title, string SingleProjectID)
{
try
{
T_FileList_BLL bll = new T_FileList_BLL();
DataSet ds = new DataSet();
ds = bll.GetList("SingleProjectID=" + SingleProjectID + "");
if (ds.Tables.Count > 0)
{
DataTable outDT = ds.Tables[0].Copy();
outDT.Clear();
Recursion(ds.Tables[0], 0, 0, ref outDT);
ds.Tables.Clear();
ds.Tables.Add(outDT);
BLL.T_SingleProject_BLL spBLL = new T_SingleProject_BLL();
Model.T_SingleProject_MDL spMDL = spBLL.GetModel(Common.ConvertEx.ToInt(SingleProjectID));
string strWhere = "1=1";
if (Session["SuperAdmin"].ToString().ToLower() == "true")
{//Leo 超级管理员看全部
}
else if (spMDL != null && spMDL.CompanyUserID == Common.ConvertEx.ToInt(Session["UserID"]))
{//Leo 工程管理员也看全部
}
else
{
strWhere += " and OperateUserID=" + Session["UserID"].ToString();
}
strWhere += " AND Title like '%" + Title + "%'";
if (strWhere != "1=1")
{
if (ds.Tables.Count > 0)
{
DataView dv = ds.Tables[0].Copy().DefaultView;
dv.RowFilter = strWhere;
if (dv.Count != ds.Tables[0].Rows.Count)
{
ds.Tables[0].Clear();
ds.Tables.RemoveAt(0);
ds.Tables.Add(dv.ToTable());
}
}
}
}
return(ds.Tables[0]);
}
catch
{
return(null);
}
}
public string GetFilelistBH(string FileListID)
{
string ReturnValue = "";
try
{
ReturnValue = new T_FileList_BLL().GetModel(Common.ConvertEx.ToInt(FileListID)).BH;
}
catch
{
ReturnValue = "";
}
return(ReturnValue);
}
/// <summary>
/// 检查文件对应的PDF文件是否存在
/// </summary>
/// <param name="fileListID">文件ID</param>
/// <returns></returns>
public static bool CheckPdfFileExistsForFileListID(int fileListID)
{
bool existsFlag = false;
T_FileList_BLL fileListBLL = new T_FileList_BLL();
T_FileList_MDL fileListMDL = fileListBLL.GetModel(fileListID);
string pdfFilePath = Path.Combine(fileListMDL.RootPath, fileListMDL.SingleProjectID.ToString(), "MPDF", fileListMDL.PDFFilePath);
if (System.IO.File.Exists(pdfFilePath))
{
existsFlag = true;
}
return(existsFlag);
}
public bool DeleteFileList(string FileListID)
{
bool flag = false;
T_FileList_BLL Bll = new T_FileList_BLL();
T_FileList_MDL Mdl = Bll.GetModel(ConvertEx.ToInt(FileListID));
if (Mdl != null && !Mdl.IsSystem)
{
Bll.Delete(ConvertEx.ToInt(FileListID));
PublicModel.writeLog(SystemSet.EumLogType.DelData.ToString(), string.Concat("T_FileList;key=", FileListID,
";SingleProjectID=", Mdl.SingleProjectID, ";bh=", Mdl.BH, ";Title=", Mdl.Title));
flag = true;
}
return(flag);
}
public string PartCountFileList(string singleProjectID)
{
try {
T_FileList_BLL Bll = new T_FileList_BLL();
DataTable tab = Bll.GetFinishFileCountByFileType(singleProjectID); //归档目录标题 PID=0
if (tab != null && tab.Rows.Count > 0)
{
StringBuilder strBuilder = new StringBuilder();
strBuilder.Append("<table class=\"layui-table\">");
strBuilder.Append(" <colgroup>");
strBuilder.Append(" <col width=\"230\">");
strBuilder.Append(" <col>");
strBuilder.Append(" </colgroup>");
strBuilder.Append(" <tbody>");
for (int i = 0; i < tab.Rows.Count; i++)
{
int PerCent = 0;
int doCount = ConvertEx.ToInt(tab.Rows[i]["doCount"]);
int allCount = ConvertEx.ToInt(tab.Rows[i]["allCount"]);
if (doCount > 0 && allCount > 0)
{
PerCent = ConvertEx.ToInt(ConvertEx.ToDouble(100 * doCount / allCount));
}
strBuilder.Append(" <tr>");
strBuilder.Append(" <td>" + String.Concat(tab.Rows[i]["BH"].ToString(), ":",
ConvertEx.ToString(tab.Rows[i]["Title"]), " <strong>", doCount, "/", allCount, "</strong>") + "</td>");
strBuilder.Append(" <td>");
strBuilder.Append(" <div class=\"layui-progress layui-progress-big\" lay-showpercent=\"true\">");
strBuilder.Append(" <div class=\"layui-progress-bar layui-bg-green\" lay-percent=\"" + PerCent + "%\"");
strBuilder.Append(" </div>");
strBuilder.Append(" </td>");
strBuilder.Append(" </tr>");
}
strBuilder.Append(" </tbody>");
strBuilder.Append("</table>");
return(strBuilder.ToString());
}
return("<blockquote class=\"layui-elem-quote\">该工程没有任何文件,原因:可能没有报建确认!</blockquote>");
}
catch (Exception ex) {
throw ex;
}
}
public string AddFile(string recidList, string singleProjectID)
{
try
{
string[] SelectList = recidList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
T_FileList_BLL fileListBLL = new T_FileList_BLL();
foreach (string ID in SelectList)
{
T_FileListTmp_MDL mdl = fileListTmpBLL.GetModel(ConvertEx.ToInt(ID));
mdl.MustSubmitFlag = true;
fileListBLL.Add(singleProjectID, mdl, true);
}
return(SystemSet._RETURN_SUCCESS_VALUE);
}
catch (Exception ex)
{
return(SystemSet._RETURN_SUCCESS_VALUE + ex.Message);
}
}
/// <summary>
/// 格式化电子文件图标,文件级
/// </summary>
/// <param name="fileListID">文件ID</param>
/// <param name="singleProjectID">工程ID</param>
/// <param name="bh">文件编号</param>
/// <param name="isFolder">是否是目录级</param>
/// <param name="imgSrc">null:默认pdf图标,其它为其它图标</param>
/// <returns></returns>
public static string getEfileImage(string fileListID, string singleProjectID, string bh, bool isFolder = true)
{
string strImage = " <img extFile=\"0\" style=\"cursor:pointer; border:0px;color:white;\" onclick=\"lookPDF(" + ConvertEx.ToInt(isFolder) + ",'" +
bh + "'," + fileListID + "," + singleProjectID + ")\" src=\"../Javascript/Layer/image/EFILE.png\" alt=\"没有文件PDF\" />";
if (!isFolder)
{
T_FileList_BLL fileListBLL = new T_FileList_BLL();
T_FileList_MDL fileListMDL = fileListBLL.GetModel(ConvertEx.ToInt(fileListID));
string pdfFilePath = Path.Combine(fileListMDL.RootPath, fileListMDL.SingleProjectID.ToString(), "MPDF", fileListMDL.PDFFilePath);
if (System.IO.File.Exists(pdfFilePath))
{
strImage = " <img extFile=\"1\" style=\"cursor:pointer;border:0px;\" onclick=\"lookPDF(" + ConvertEx.ToInt(isFolder) + ",'" +
bh + "'," + fileListID + "," + singleProjectID + ")\" src=\"../Javascript/Layer/image/EFILE_1.png\" alt=\"点击查看合并后的PDF\"/>";
}
}
return(strImage);
}
public string FileCheckBySignatureFinish(string singleProjectID)
{
T_FileList_BLL fileListBLL = new T_FileList_BLL();
List <string> ltResult = new List <string>();
DataTable dt = fileListBLL.GetFileListBySignatureFinishStatus(singleProjectID, 0);
if (dt != null)
{
List <string> ltFileResult = new List <string>();
int SingleProjectID = 0;
foreach (DataRow row in dt.Rows)
{
if (SingleProjectID == 0)
{
ltResult.Add("*********************签章未完成的文件列表*********************");
ltResult.Add(string.Concat("工程编号:", row["gcbm"], ";工程名称:", row["gcmc"]));
}
ltResult.Add("----------------------------------------------------------------");
ltResult.Add(string.Concat("文件编号:", row["BH"], ";文件题名:", row["Title"], ";需签章/已签章",
row["SignatureTmpCount"], "/", row["FinishSignaturecount"]));
SingleProjectID = Common.ConvertEx.ToInt(row["SingleProjectID"]);
}
}
if (ltResult.Count > 0)
{
string txtFileName = Guid.NewGuid().ToString() + ".txt";
FileStream fs1 = new FileStream(Server.MapPath("/Upload/TempReport/" + txtFileName), FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs1);
foreach (string str in ltResult)
{
sw.WriteLine(str);
}
sw.Close();
fs1.Close();
return(txtFileName);
}
else
{
return("0");
}
}
public string DeleteSingleProject(string SingleProjectID)
{
try {
T_FileList_BLL fileListBLL = new T_FileList_BLL();
Hashtable ht = new Hashtable();
ht.Add("SingleProjectID", SingleProjectID);
ht.Add("Unequal_Status", "0");
int fileCount = fileListBLL.GetFileCount(ht);
if (fileCount < 1)
{
new T_Other_BLL().DeleteCompanyOther(SingleProjectID, true);
return(SystemSet._RETURN_SUCCESS_VALUE);
}
else
{
return("该工程已有<strong style='color:red'>" + fileCount + "</strong>份登记文件,不能删除!");
}
} catch (Exception ex) {
return(SystemSet._RETURN_FAILURE_VALUE + ex.Message);
}
}
public string SubMitProject(string singleProjectID, string workFlowID, string workFlowDefineID)
{
Model.T_SingleProject_MDL spMDL = (new BLL.T_SingleProject_BLL()).GetModel(ConvertEx.ToInt(singleProjectID));
BLL.T_FileList_BLL flBLL = new T_FileList_BLL();
DataSet ds2 = flBLL.GetList("SingleProjectID=" + singleProjectID);
if (!String.IsNullOrEmpty(spMDL.gcbm) && ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0)
{
//窗口接收提交的时候,更新该工程所有案卷下的文件序号,根据文件编号排序更新
if (ConvertEx.ToInt(workFlowID) == PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.WINRECV.ToString()))
{
new T_Archive_BLL().updateFileOrderIndexBySingleProjectID(singleProjectID);
}
BLL.T_WorkFlowDefine_BLL wkBLL = new T_WorkFlowDefine_BLL();
Model.T_WorkFlowDefine_MDL wkMDL = wkBLL.GetModel(ConvertEx.ToInt(workFlowDefineID));
if (String.IsNullOrEmpty(wkMDL.SubmitCellPath)) //有些地方不需要填申请单的
{
WorkFlowManage workflowmanage = new WorkFlowManage();
if (workflowmanage.GoNextProjectWorkFlowSataus(ConvertEx.ToInt(singleProjectID), ConvertEx.ToInt(workFlowID)))
{
return(SystemSet._RETURN_SUCCESS_VALUE);
}
else
{
return(SystemSet._RETURN_FAILURE_VALUE);
}
}
else //填申请单的未做
{
return(SystemSet._RETURN_SUCCESS_VALUE);
}
}
else
{
return("请选分配任务!");
}
}
public string GetFilePath(string id)
{
string mEFilePath = string.Empty, oMDPdir = string.Empty, mOrgEFilePath = string.Empty;
T_FileList_BLL bll = new T_FileList_BLL();
T_FileList_MDL model = bll.GetModel(Common.ConvertEx.ToInt(id));
if (model != null)
{
if (!string.IsNullOrEmpty(model.RootPath) && !string.IsNullOrEmpty(model.PDFFilePath))
{
//string LastPath = model.RootPath.Substring(0, model.RootPath.Length - 1);
//int iPos1 = LastPath.LastIndexOf('\\');
//LastPath = LastPath.Substring(iPos1 + 1);
//string mHttpUrl = "http://" + Request.ServerVariables["HTTP_HOST"] + "/" + LastPath;
oMDPdir = string.Concat(model.RootPath, singleProjectID, "\\OMPDF\\");
mEFilePath = string.Concat(model.RootPath, singleProjectID, "\\MPDF\\", model.PDFFilePath.Replace("/", @"\"));
mOrgEFilePath = string.Concat(oMDPdir, model.PDFFilePath.Replace("/", @"\"));
if (!Directory.Exists(oMDPdir))
{
Directory.CreateDirectory(oMDPdir);
}
if (System.IO.File.Exists(mEFilePath))
{
if (Common.DNTRequest.GetQueryString("action") != "view")
{
System.IO.File.Copy(mEFilePath, mOrgEFilePath, true);
}
}
}
else
{
Common.MessageBox.ShowAndCloseWin(this, "没有文件,无法查看！");
}
}
return(mEFilePath);
}
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);
}
}
public string ExctFileList(string strIsFolder, string strFileListID, string strSingleProjectId,
string strTitle, string strZRR, string strWTH, string strStartTime, string strManualCount,
string strBH, string strPID, string myCode, string DefaultCompanyType, string strOldRecID)
{
string ReturnValue = "0";
try {
T_FileList_BLL Bll = new T_FileList_BLL();
T_FileList_MDL Mdl = new T_FileList_MDL();
int FileListId = ConvertEx.ToInt(strFileListID);
string SingleProjectId = strSingleProjectId;
if (FileListId > 0)
{
Mdl = Bll.GetModel(FileListId);
}
else
{
Mdl.PID = ConvertEx.ToInt(strPID);
Mdl.DefaultCompanyType = ConvertEx.ToInt(DefaultCompanyType);
Mdl.CompanyID = ConvertEx.ToInt(Common.Session.GetSession("CompanyID"));
Mdl.OperateUserID = ConvertEx.ToInt(Common.Session.GetSession("UserID"));
Mdl.recID = Bll.GetMaxRecID(SingleProjectId);
Mdl.IsSystem = false;
Mdl.BH = strBH;
Mdl.IsFolder = ConvertEx.ToBool(strIsFolder);
Mdl.PagesCount = 0; //上传页数默认为0
Mdl.OrderIndex = 0; //文件序号默认为0,组完卷,根据文件编号自动生成序号
}
Mdl.OldRecID = ConvertEx.ToInt(strOldRecID);//归档目录模板ID不能变,以后用户签章,模板ID关联签章流程
Mdl.shr_3 = "0";
Mdl.w_t_h = strWTH;
Mdl.SingleProjectID = ConvertEx.ToInt(SingleProjectId);
Mdl.zrr = strZRR;
Mdl.Title = strTitle;
Mdl.ManualCount = ConvertEx.ToInt(strManualCount);
Mdl.MyCode = myCode;
Mdl.CreateDate = DateTime.Now; //文件登记时间
Mdl.Version = PublicModel.getFileVersion(SingleProjectId); //获取文件的版本号
if (strStartTime != null && strStartTime.Trim().Length > 0)
{
Mdl.StartTime = ConvertEx.ToDate(strStartTime).ToString("yyyy-MM-dd");
}
if (FileListId > 0 && !Mdl.IsFolder)
{
Bll.Update(Mdl);
PublicModel.writeLog(SystemSet.EumLogType.UpdData.ToString(), string.Concat("T_FileList;key=", Mdl.FileListID,
";SingleProjectID=", Mdl.SingleProjectID, ";bh=", Mdl.BH, ";Title=", Mdl.Title));
//更改已登记状态
BLL.T_Other_BLL otherBLL = new BLL.T_Other_BLL();
otherBLL.UpdateArchiveStatus(FileListId.ToString(), 10);
}
else
{
FileListId = Bll.Add(Mdl);
PublicModel.writeLog(SystemSet.EumLogType.AddData.ToString(), string.Concat("T_FileList;key=", FileListId,
";SingleProjectID=", Mdl.SingleProjectID, ";bh=", Mdl.BH, ";Title=", Mdl.Title));
}
ReturnValue = FileListId.ToString();
} catch (Exception ex) {
LogUtil.Debug(this, "文件登记归档目录保存操作", ex);
}
return(ReturnValue);
}