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