/// <summary> /// 电子文件对应的附件信息,一般在外部系统关联 ,比如筑业 /// </summary> /// <param name="fileListID"></param> /// <param name="outSideRelatedDtCount"></param> /// <param name="outSideRelatedString"></param> private void LoadEFileOutSideRelated(string fileListID, out int outSideRelatedDtCount, out string outSideRelatedString) { DataTable fileDT = new T_EFile_OutSideRelated_BLL().GetEFileOutSideRelated(fileListID).Tables[0]; outSideRelatedString = string.Empty; outSideRelatedDtCount = 0; if (fileDT != null && fileDT.Rows.Count > 0) { outSideRelatedDtCount = fileDT.Rows.Count; var index = 1; string btnStr = " <input type=\"button\" class=\"button\" onclick=\"loadPdf(this,'{0}')\" title=\"{1}\" value=\" 附件{2} \" />"; foreach (DataRow row in fileDT.Rows) { if (!string.IsNullOrWhiteSpace(row["RootPath"].ToString()) && row["RootPath"].ToString().Length > 0) { outSideRelatedString += String.Format(btnStr, FormatPdfSrc(row["RootPath"].ToString(), row["SingleProjectID"].ToString(), row["PDFFilePath"].ToString()), row["Title"].ToString(), index.ToString()); index++; } } } }
private string InsertFileList(XmlNode xmlNode) { string rtMsg = string.Empty; try { #region 新增文件信息 T_FileList_MDL fileMDL = new T_FileList_MDL(); string singleProjectID = xmlNode["SINGLEPROJECTID"].InnerText; //工程ID string operateUserID = xmlNode["OPERATEUSERID"].InnerText; //当前用户ID string pid = xmlNode["PID"].InnerText; //文件所属类别ID pid = GetFilePID(pid, xmlNode["FROMRECID"].InnerText, xmlNode["FROMTYPE"].InnerText); if (ConvertEx.ToInt(pid) < 1) { rtMsg = "传入的PID匹配失败!"; return(rtMsg); } T_UsersInfo_MDL userMDL = new T_UsersInfo_BLL().GetModel(ConvertEx.ToInt(operateUserID)); if (userMDL != null) { fileMDL.OperateUserID = userMDL.UserID; fileMDL.CompanyID = userMDL.CompanyID; T_Company_MDL companyMDL = new T_Company_BLL().GetModel(userMDL.CompanyID); if (companyMDL != null) { fileMDL.DefaultCompanyType = companyMDL.CompanyType; } } //记录文件在模板中对应的recid fileMDL.OldRecID = ConvertEx.ToInt(fileBLL.GetRecID(xmlNode["FROMRECID"].InnerText, xmlNode["FROMTYPE"].InnerText)); fileMDL.recID = fileBLL.GetMaxRecID(singleProjectID); fileMDL.PID = ConvertEx.ToInt(pid); fileMDL.IsFolder = false; IList <T_FileList_MDL> ltMDL = fileBLL.GetModelList("SingleProjectID=" + singleProjectID + " and recid=" + pid + ""); if (ltMDL != null && ltMDL.Count > 0) { fileMDL.BH = new T_Other_BLL().GetBH(singleProjectID, ltMDL[0].FileListID.ToString()); } fileMDL.PagesCount = ConvertEx.ToInt(xmlNode["PDFCOUNT"].InnerText); //PDF页数 fileMDL.ManualCount = ConvertEx.ToInt(xmlNode["PDFCOUNT"].InnerText); //实体页数 fileMDL.shr_3 = "0"; fileMDL.w_t_h = xmlNode["FILEID"].InnerText; fileMDL.SingleProjectID = ConvertEx.ToInt(xmlNode["SINGLEPROJECTID"].InnerText); fileMDL.zrr = xmlNode["ZRR"].InnerText; fileMDL.Title = xmlNode["TITLE"].InnerText; fileMDL.CreateDate = DateTime.Now; //文件登记时间 fileMDL.StartTime = xmlNode["START_DATE"].InnerText; fileMDL.CONVERT_DT = DateTime.Now.ToString("yyyy-MM-dd"); // xmlNode["START_DATE"].InnerText; fileMDL.CONVERT_FLAG = true; fileMDL.PDFFilePath = xmlNode["PDFFILEPATH"].InnerText; //合并的PDF文件名称 fileMDL.RootPath = Common.Common.EFileStartPath; //PDF存放路径 fileMDL.FROM_SID = xmlNode["SID"].InnerText; //筑业过来的文件SID,二次导入时据此判断 fileMDL.IsMerge = xmlNode["IsMerge"].InnerText; //合并后的PDF,还是单张表格的PDF fileMDL.Status = "10"; //已登记 fileMDL.OldStatus = "10"; fileMDL.SIGNATURE_FLAG = false; //导入不能为已签章@tyy20160326 int fileListID = fileBLL.Add(fileMDL); #endregion #region 关联文件对应的附件信息,先删除后添加 T_EFile_OutSideRelated_BLL efileOutSideRelatedBLL = new T_EFile_OutSideRelated_BLL(); efileOutSideRelatedBLL.DelEfileOutSideRelated(fileListID.ToString(), xmlNode["FROMTYPE"].InnerText); if (!string.IsNullOrWhiteSpace(xmlNode["EFILE_OUTSIDERELATED"].InnerText)) { string[] spEfileOutSideRelated = (xmlNode["EFILE_OUTSIDERELATED"].InnerText + ",").Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (var fromID in spEfileOutSideRelated) { T_EFile_OutSideRelated_MDL efileOutSideRelatedMDL = new T_EFile_OutSideRelated_MDL(); efileOutSideRelatedMDL.FileListID = fileListID.ToString(); efileOutSideRelatedMDL.FromID = fromID; efileOutSideRelatedMDL.FromType = xmlNode["FROMTYPE"].InnerText; efileOutSideRelatedBLL.Add(efileOutSideRelatedMDL); } } #endregion rtMsg = SystemSet._RETURN_SUCCESS_VALUE; } catch (Exception ex) { rtMsg = "failure:" + ex.Message; } return(rtMsg); }