public void AddFile(S_FileInfo file, bool withDefaultAttr = false)
{
file.NodeID = this.ID;
file.FullNodeID = this.FullPathID;
if (!file.IsNewModel)
{
throw new Formula.Exceptions.BusinessException("文件对象不是新建对象，无法调用添加方法");
}
file.Save(withDefaultAttr);
this.FileInfos.Add(file);
}
public void Download(S_FileInfo fileInfo, string SpaceID, string ArchiveType, bool CheckCar = false)
{
var user = FormulaHelper.GetUserInfo();
var entities = FormulaHelper.GetEntities <DocConstEntities>();
if (fileInfo.Space == null)
{
throw new Formula.Exceptions.BusinessException("没有获取到申请文件的配置空间信息，无法进行申请下载");
}
if (fileInfo.ConfigInfo == null)
{
throw new Formula.Exceptions.BusinessException("没有获取到申请文件的文件配置类别信息，无法进行申请下载");
}
var carItem = entities.Set <S_CarInfo>().FirstOrDefault(d => d.FileID == fileInfo.ID &&
d.State != "Finish" && d.UserID == user.UserID && d.Type == "DownLoad");
if (carItem == null)
{
carItem = new S_CarInfo();
carItem.ID = FormulaHelper.CreateGuid();
carItem.NodeID = fileInfo.NodeID;
carItem.Type = ItemType.DownLoad.ToString();
carItem.UserID = user.UserID;
carItem.UserName = user.UserName;
carItem.CreateDate = DateTime.Now;
carItem.FileID = fileInfo.ID;
carItem.SpaceID = SpaceID;
carItem.ConfigID = fileInfo.ConfigInfo.ID;
carItem.Name = fileInfo.CreateCarName();//fileInfo.Name;
carItem.Code = fileInfo.DataEntity.GetValue("Code");
carItem.State = ItemState.New.ToString();
carItem.DataType = fileInfo.ConfigInfo.Name;
carItem.CreateUser = user.UserName;
carItem.CreateUserID = user.UserID;
var attchments = new List <string>();
ArchiveType = "MainFile,Attachments," + ArchiveType;
foreach (var item in ArchiveType.Split(','))
{
if (!string.IsNullOrEmpty(fileInfo.CurrentAttachment.DataEntity.GetValue(item)))
{
attchments.Add(fileInfo.CurrentAttachment.DataEntity.GetValue(item));
}
}
carItem.Attachments = string.Join(",", attchments);
entities.Set <S_CarInfo>().Add(carItem);
}
else if (CheckCar)
{
throw new Formula.Exceptions.BusinessException("该文件已在下载车中，请前往下载车申请下载");
}
}
public void AddFile(S_FileInfo file, bool withDefaultAttr = false)
{
this.SetNodeFileCount();
file.NodeID = this.ID;
file.FullNodeID = this.FullPathID;
file.FullNodeName = this.FullPathName;
file.DataEntity.SetValue("State", DocState.Normal.ToString());
if (!file.IsNewModel)
{
throw new Formula.Exceptions.BusinessException("文件对象不是新建对象，无法调用添加方法");
}
file.Save(withDefaultAttr);
this.FileInfos.Add(file);
}
void SetFileAttr(S_FileInfo file, string Attr)
{
var dic = JsonHelper.ToObject(Attr);
foreach (string key in dic.Keys)
{
if (key == "ID" || key == "NodeID" || key == "SpaceID" || key == "ConfigID" || key == "FullNodeID" || key == "State" || key == "BorrowState" ||
key == "BorrowUserID" || key == "BorrowUserName")
{
continue;
}
file.DataEntity.SetValue(key, dic.GetValue(key));
}
}
public void SyncInstanceDataState()
{
var details = this.T_Borrow_FileInfo.ToList();
var spaceList = new List <S_DOC_Space>();
foreach (var item in details)
{
var space = spaceList.FirstOrDefault(a => a.ID == item.SpaceID);
if (space == null)
{
space = DocConfigHelper.CreateConfigSpaceByID(item.SpaceID);
if (space == null)
{
continue;
}
spaceList.Add(space);
}
if (!String.IsNullOrEmpty(item.FileID))
{
var file = new S_FileInfo(item.FileID, space);
if (file == null)
{
continue;
}
file.DataEntity.SetValue("BorrowState", BorrowReturnState.Borrow.ToString());
file.DataEntity.SetValue("BorrowUserID", this.CreateUserID);
file.DataEntity.SetValue("BorrowUserName", this.CreateUserName);
file.Save(false);
}
else
{
var node = new S_NodeInfo(item.NodeID, space);
if (node == null)
{
continue;
}
node.DataEntity.SetValue("BorrowState", BorrowReturnState.Borrow.ToString());
node.DataEntity.SetValue("BorrowUserID", this.CreateUserID);
node.DataEntity.SetValue("BorrowUserName", this.CreateUserName);
node.Save(false);
}
}
}
private S_FileInfo archFile(Dictionary <string, object> reorganizeDetail, S_NodeInfo node, string targetConfigID = "")
{
var fileConfig = node.ConfigInfo.S_DOC_FileNodeRelation.FirstOrDefault(a => a.FileID == targetConfigID);
if (fileConfig == null)
{
throw new Formula.Exceptions.BusinessException("节点【" + node.Name + "】下无法绑定该文件类型【" + targetConfigID + "】！");
}
if (fileConfig != null && fileConfig.S_DOC_File != null)
{
var file = new DocSystem.Logic.Domain.S_FileInfo(node.Space.ID, fileConfig.S_DOC_File.ID);
var fileFields = fileConfig.S_DOC_File.S_DOC_FileAttr.Select(a => a.FileAttrField).ToList();
var buttonEditFields = fileConfig.S_DOC_File.S_DOC_FileAttr.Where(a => a.InputType.IndexOf(ControlType.ButtonEdit.ToString()) > -1).ToList();
foreach (var item in buttonEditFields)
{
fileFields.Add(item.FileAttrField + "Name");
}
foreach (var fileds in fileFields)
{
if (fileds.ToLower() == "id" || fileds.ToLower() == "attr" || fileds.ToLower() == "storagenum" || fileds.ToLower() == "storagetype" || fileds.ToLower() == "mainfile")
{
continue;
}
var _value = reorganizeDetail.GetValue(fileds);
if (fileds.ToLower().Equals("quantity"))
{
file.DataEntity.SetValue("StorageNum", _value);
}
if (!string.IsNullOrEmpty(_value))
{
file.DataEntity.SetValue(fileds, _value);
}
}
//var file = new DocSystem.Logic.Domain.S_FileInfo(node.Space.ID, fileConfig.S_DOC_File.ID);
if (!String.IsNullOrEmpty(reorganizeDetail.GetValue("Attr")))
{
SetFileAttr(file, reorganizeDetail.GetValue("Attr"));
}
//file.DataEntity.SetValue("Name", reorganizeDetail.GetValue("Name"));
file.DataEntity.SetValue("StorageType", "Electronic");
file.DataEntity.SetValue("NodeID", node.ID);
//file.DataEntity.SetValue("Code", reorganizeDetail.GetValue("Code"));
//file.DataEntity.SetValue("RelateID", reorganizeDetail.GetValue("RelateID"));
//file.DataEntity.SetValue("State", DocState.Normal);
//归档人、部门、时间存储
if (!string.IsNullOrEmpty(GetQueryString("SendUser")))
{
Dictionary <string, string> depate = GetDepartment(GetQueryString("SendUser"));
file.DataEntity.SetValue("ArchivePeople", GetQueryString("SendUser"));
file.DataEntity.SetValue("ArchivePeopleName", depate.GetValue("SendUserName"));
file.DataEntity.SetValue("ArchiveDate", GetQueryString("SendDate"));
file.DataEntity.SetValue("ArchiveDepartment", depate.GetValue("DeptID"));
file.DataEntity.SetValue("ArchiveDepartmentName", depate.GetValue("DeptName"));
}
if (!String.IsNullOrEmpty(reorganizeDetail.GetValue("MainFile")))
{
var attachment = new S_Attachment(node.Space.ID);
attachment.DataEntity.SetValue("MainFile", reorganizeDetail.GetValue("MainFile"));
attachment.DataEntity.SetValue("PDFFile", reorganizeDetail.GetValue("PDFFile"));
attachment.DataEntity.SetValue("PlotFile", reorganizeDetail.GetValue("PlotFile"));
attachment.DataEntity.SetValue("XrefFile", reorganizeDetail.GetValue("XrefFile"));
attachment.DataEntity.SetValue("DwfFile", reorganizeDetail.GetValue("DwfFile"));
attachment.DataEntity.SetValue("TiffFile", reorganizeDetail.GetValue("TiffFile"));
attachment.DataEntity.SetValue("SignPdfFile", reorganizeDetail.GetValue("SignPdfFile"));
file.AddAttachment(attachment);
}
file.IsValidateDataAttr = false;
DocSystem.FileController.FileValidateDataAttr(file);
//node.AddFile(file, true);
file.Save(true);
return(file);
}
return(null);
}
void _archiveDBS(S_D_DBS parentDBS, List <S_D_DBS> archiveDbsList, S_NodeInfo parentNode, S_DOC_Space docSpace, bool archiveFiles = true, bool isAll = true)
{
var folders = archiveDbsList.Where(d => d.ParentID == parentDBS.ID).ToList();
foreach (var folder in folders)
{
if (String.IsNullOrEmpty(folder.ArchiveFolder))
{
continue;
}
S_NodeInfo node = S_NodeInfo.GetNode(docSpace.ID, folder.ArchiveFolder, " where Name='" + folder.Name + "' and ParentID='" + parentNode.ID + "' ");
if (node == null)
{
node = new DocSystem.Logic.Domain.S_NodeInfo(docSpace.ID, folder.ArchiveFolder);
this.SetAttr <S_D_DBS>(node, folder);
node.Name = folder.Name;
node.DataEntity.SetValue("State", DocState.Normal.ToString());
node.DataEntity.SetValue("RelateID", folder.ID);
parentNode.AddChild(node, true);
}
else
{
this.SetAttr <S_D_DBS>(node, folder);
node.Name = folder.Name;
node.DataEntity.SetValue("State", DocState.Normal.ToString());
node.DataEntity.SetValue("RelateID", folder.ID);
node.Save();
}
if (archiveFiles && node.ConfigInfo.S_DOC_FileNodeRelation.Count > 0 && node.ConfigInfo.S_DOC_FileNodeRelation.FirstOrDefault().S_DOC_File != null)
{
#region 归档文件
var fileConfig = node.ConfigInfo.S_DOC_FileNodeRelation.FirstOrDefault().S_DOC_File;
var docList = folder.S_D_Document.ToList();
var _group = docList.GroupBy(a => a.RelateID).Select(a =>
new { a.Key, MaxVersion = a.Max(b => (string.IsNullOrEmpty(b.Version) ? 0d : Convert.ToDouble(b.Version))) }
).ToList();
if (!isAll)
{
docList = docList.Where(a => _group.Any(g => g.Key == a.RelateID && g.MaxVersion == (string.IsNullOrEmpty(a.Version) ? 0d : Convert.ToDouble(a.Version)))).ToList();
}
foreach (var doc in docList)
{
var file = S_FileInfo.GetFile(docSpace.ID, fileConfig.ID, " NodeID='" + node.ID + "' and RelateID='" + doc.ID + "' ");
if (file == null)
{
file = new DocSystem.Logic.Domain.S_FileInfo(docSpace.ID, fileConfig.ID);
if (!String.IsNullOrEmpty(doc.Attr))
{
this.SetFileAttr(file, doc.Attr);
}
file.DataEntity.SetValue("Name", doc.Name);
file.DataEntity.SetValue("Code", doc.Code);
file.DataEntity.SetValue("RelateID", doc.ID);
file.DataEntity.SetValue("State", DocState.Normal);
if (!String.IsNullOrEmpty(doc.MainFiles) || !String.IsNullOrEmpty(doc.PDFFile) ||
!String.IsNullOrEmpty(doc.PlotFile) || !String.IsNullOrEmpty(doc.XrefFile) ||
!String.IsNullOrEmpty(doc.DwfFile) || !String.IsNullOrEmpty(doc.TiffFile) ||
!String.IsNullOrEmpty(doc.SignPdfFile))
{
var attachment = new S_Attachment(docSpace.ID);
attachment.DataEntity.SetValue("MainFile", doc.MainFiles);
attachment.DataEntity.SetValue("PDFFile", doc.PDFFile);
attachment.DataEntity.SetValue("PlotFile", doc.PlotFile);
attachment.DataEntity.SetValue("XrefFile", doc.XrefFile);
attachment.DataEntity.SetValue("DwfFile", doc.DwfFile);
attachment.DataEntity.SetValue("TiffFile", doc.TiffFile);
attachment.DataEntity.SetValue("SignPdfFile", doc.SignPdfFile);
attachment.DataEntity.SetValue("CreateUser", this.CurrentUserInfo.UserID);
attachment.DataEntity.SetValue("CreateUserName", this.CurrentUserInfo.UserName);
file.AddAttachment(attachment);
}
node.AddFile(file, true);
}
else
{
if (!String.IsNullOrEmpty(doc.Attr))
{
this.SetFileAttr(file, doc.Attr);
}
file.Save();
var attachment = new S_Attachment(docSpace.ID);
attachment.DataEntity.SetValue("MainFile", doc.MainFiles);
attachment.DataEntity.SetValue("PDFFile", doc.PDFFile);
attachment.DataEntity.SetValue("PlotFile", doc.PlotFile);
attachment.DataEntity.SetValue("XrefFile", doc.XrefFile);
attachment.DataEntity.SetValue("DwfFile", doc.DwfFile);
attachment.DataEntity.SetValue("TiffFile", doc.TiffFile);
attachment.DataEntity.SetValue("SignPdfFile", doc.SignPdfFile);
attachment.DataEntity.SetValue("CreateUser", this.CurrentUserInfo.UserID);
attachment.DataEntity.SetValue("CreateUserName", this.CurrentUserInfo.UserName);
file.AddAttachment(attachment);
}
doc.State = "Archive";
doc.ArchiveDate = DateTime.Now;
if (doc.RelateTable == "S_E_Product")
{
//string update = "Update S_E_Product Set ArchiveState='True', ArchiveDate='" + DateTime.Now.ToString() + "' where ID='" + doc.RelateID + "'";
string update = string.Format(@"update S_E_Product set ArchiveState='True', ArchiveDate='{2}' where ID='{0}'
update S_E_ProductVersion set ArchiveState='True', ArchiveDate='{2}' where ProductID='{0}' and Version='{1}'", doc.RelateID, doc.Version, DateTime.Now.ToString());
this.entities.Database.ExecuteSqlCommand(update);
}
}
#endregion
}
_archiveDBS(folder, archiveDbsList, node, docSpace, archiveFiles, isAll);
}
}
public JsonResult Archive(string ProjectInfoID, bool IsAll)
{
Action action = () =>
{
var projectInfo = this.GetEntityByID <S_I_ProjectInfo>(ProjectInfoID);
if (projectInfo == null)
{
throw new Formula.Exceptions.BusinessException("未能找到项目信息，无法归档");
}
var rootFolder = projectInfo.ProjectMode.S_T_DBSDefine.FirstOrDefault(d => d.DBSType == DBSType.Root.ToString());
if (String.IsNullOrEmpty(rootFolder.ArchiveFolder))
{
throw new Formula.Exceptions.BusinessException("没有为根节点定义归档目录，项目无法归档");
}
var archiveFolders = projectInfo.S_D_DBS.Where(d => !String.IsNullOrEmpty(d.ArchiveFolder)).ToList();
var sqlHelper = SQLHelper.CreateSqlHelper(ConnEnum.InfrasBaseConfig);
var dt = sqlHelper.ExecuteDataTable("select * from S_DOC_Node where ID='" + rootFolder.ArchiveFolder + "'");
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessException("根节点定义的归档目录不存在，归档失败");
}
var folderDef = FormulaHelper.DataRowToDic(dt.Rows[0]);
var docSpace = DocSystem.Logic.DocConfigHelper.CreateConfigSpaceByID(folderDef.GetValue("SpaceID"));
if (docSpace == null)
{
throw new Formula.Exceptions.BusinessException("所选择的档案空间定义不存在，请联系管理员确认档案空间配置是否正确");
}
S_NodeInfo rootNode = S_NodeInfo.GetNode(docSpace.ID, rootFolder.ArchiveFolder, " where RelateID='" + projectInfo.DBSRoot.ID + "'");
if (rootNode == null)
{
rootNode = new DocSystem.Logic.Domain.S_NodeInfo(docSpace.ID, rootFolder.ArchiveFolder);
rootNode.Name = projectInfo.Name;
rootNode.DataEntity.SetValue("Code", projectInfo.Code);
rootNode.DataEntity.SetValue("State", DocState.Normal.ToString());
rootNode.DataEntity.SetValue("RelateID", projectInfo.DBSRoot.ID);
}
this.SetAttr <S_I_ProjectInfo>(rootNode, projectInfo);
rootNode.Save(true);
var fileConfig = rootNode.ConfigInfo.S_DOC_FileNodeRelation.FirstOrDefault();
if (fileConfig != null && fileConfig.S_DOC_File != null)
{
Convert.ToDouble("");
var docList = projectInfo.DBSRoot.S_D_Document.Where(d => d.State != "Archive").ToList();
var _group = docList.GroupBy(a => a.RelateID).Select(a =>
new { a.Key, MaxVersion = a.Max(b => (string.IsNullOrEmpty(b.Version) ? 0d : Convert.ToDouble(b.Version))) }
).ToList();
if (!IsAll)
{
docList = docList.Where(a => _group.Any(g => g.Key == a.RelateID && g.MaxVersion == (string.IsNullOrEmpty(a.Version) ? 0d : Convert.ToDouble(a.Version)))).ToList();
}
foreach (var doc in docList)
{
var file = new DocSystem.Logic.Domain.S_FileInfo(docSpace.ID, fileConfig.S_DOC_File.ID);
if (!String.IsNullOrEmpty(doc.Attr))
{
this.SetFileAttr(file, doc.Attr);
}
file.DataEntity.SetValue("Name", doc.Name);
file.DataEntity.SetValue("Code", doc.Code);
rootNode.AddFile(file, true);
if (!String.IsNullOrEmpty(doc.MainFiles) || !String.IsNullOrEmpty(doc.PDFFile) ||
!String.IsNullOrEmpty(doc.PlotFile) || !String.IsNullOrEmpty(doc.XrefFile) ||
!String.IsNullOrEmpty(doc.DwfFile) || !String.IsNullOrEmpty(doc.TiffFile) ||
!String.IsNullOrEmpty(doc.SignPdfFile))
{
var attachment = new S_Attachment(docSpace.ID);
attachment.DataEntity.SetValue("MainFile", doc.MainFiles);
attachment.DataEntity.SetValue("PDFFile", doc.PDFFile);
attachment.DataEntity.SetValue("PlotFile", doc.PlotFile);
attachment.DataEntity.SetValue("XrefFile", doc.XrefFile);
attachment.DataEntity.SetValue("DwfFile", doc.DwfFile);
attachment.DataEntity.SetValue("TiffFile", doc.TiffFile);
attachment.DataEntity.SetValue("SignPdfFile", doc.SignPdfFile);
attachment.DataEntity.SetValue("TiffFile", doc.TiffFile);
attachment.DataEntity.SetValue("CreateUser", this.CurrentUserInfo.UserID);
attachment.DataEntity.SetValue("CreateUserName", this.CurrentUserInfo.UserName);
file.AddAttachment(attachment);
}
doc.State = "Archive";
doc.ArchiveDate = DateTime.Now;
if (doc.RelateTable == "S_E_Product")
{
//string update = "Update S_E_Product Set ArchiveState='True', ArchiveDate='" + DateTime.Now.ToString() + "' where ID='" + doc.RelateID + "'";
string update = string.Format(@"update S_E_Product set ArchiveState='True', ArchiveDate='{2}' where ID='{0}'
update S_E_ProductVersion set ArchiveState='True', ArchiveDate='{2}' where ProductID='{0}' and Version='{1}'", doc.RelateID, doc.Version, DateTime.Now.ToString());
this.entities.Database.ExecuteSqlCommand(update);
}
}
}
this._archiveDBS(projectInfo.DBSRoot, archiveFolders, rootNode, docSpace, true, IsAll);
this.entities.SaveChanges();
};
if (System.Configuration.ConfigurationManager.AppSettings["UseMsdtc"].ToLower() == "true")
{
using (TransactionScope ts = new TransactionScope())
{
action();
ts.Complete();
}
}
else
{
action();
}
return(Json(""));
}
public JsonResult ArchiveFile(string ProjectInfoID, string Files)
{
Action action = () =>
{
var projectInfo = this.GetEntityByID <S_I_ProjectInfo>(ProjectInfoID);
if (projectInfo == null)
{
throw new Formula.Exceptions.BusinessException("未能找到项目信息，无法归档");
}
var rootFolder = projectInfo.ProjectMode.S_T_DBSDefine.FirstOrDefault(d => d.DBSType == DBSType.Root.ToString());
if (String.IsNullOrEmpty(rootFolder.ArchiveFolder))
{
throw new Formula.Exceptions.BusinessException("没有为根节点定义归档目录，项目无法归档");
}
var sqlHelper = SQLHelper.CreateSqlHelper(ConnEnum.InfrasBaseConfig);
var dt = sqlHelper.ExecuteDataTable("select * from S_DOC_Node where ID='" + rootFolder.ArchiveFolder + "'");
if (dt.Rows.Count == 0)
{
throw new Formula.Exceptions.BusinessException("根节点定义的归档目录不存在，归档失败");
}
var folderDef = FormulaHelper.DataRowToDic(dt.Rows[0]);
var docSpace = DocSystem.Logic.DocConfigHelper.CreateConfigSpaceByID(folderDef.GetValue("SpaceID"));
if (docSpace == null)
{
throw new Formula.Exceptions.BusinessException("所选择的档案空间定义不存在，请联系管理员确认档案空间配置是否正确");
}
#region 创建项目根节点
S_NodeInfo rootNode = S_NodeInfo.GetNode(docSpace.ID, rootFolder.ArchiveFolder, " where RelateID='" + projectInfo.DBSRoot.ID + "'");
if (rootNode == null)
{
rootNode = new DocSystem.Logic.Domain.S_NodeInfo(docSpace.ID, rootFolder.ArchiveFolder);
rootNode.Name = projectInfo.Name;
rootNode.DataEntity.SetValue("Code", projectInfo.Code);
rootNode.DataEntity.SetValue("State", DocState.Normal.ToString());
}
#endregion
this.SetAttr <S_I_ProjectInfo>(rootNode, projectInfo);
rootNode.DataEntity.SetValue("RelateID", projectInfo.DBSRoot.ID);
rootNode.Save(true);
var fileList = JsonHelper.ToList(Files);
foreach (var item in fileList)
{
if (item.Keys.Contains("NewAdd") && item.GetValue("NewAdd") == "T")
{
continue;
}
var doc = this.GetEntityByID <S_D_Document>(item.GetValue("DocumentID"));
if (doc == null)
{
continue;
}
var folder = doc.S_D_DBS;
if (String.IsNullOrEmpty(folder.ArchiveFolder))
{
throw new Formula.Exceptions.BusinessException("没有为【" + folder.Name + "】配置指定归档信息，无法归档");
}
var node = rootNode.AllChildren.FirstOrDefault(d => d.RelateID == folder.ID);
if (node == null)
{
this._archiveDBS(projectInfo.DBSRoot, folder.Ansestors, rootNode, docSpace, false);
node = rootNode.AllChildren.FirstOrDefault(d => d.RelateID == folder.ID);
}
if (node == null)
{
throw new Formula.Exceptions.BusinessException("目录创建失败，文件【" + doc.Name + "】归档失败");
}
#region 归档文件
var fileConfig = node.ConfigInfo.S_DOC_FileNodeRelation.FirstOrDefault();
if (fileConfig != null && fileConfig.S_DOC_File != null)
{
var file = S_FileInfo.GetFile(docSpace.ID, fileConfig.S_DOC_File.ID, " NodeID='" + node.ID + "' and RelateID='" + doc.ID + "' ");
if (file == null)
{
file = new DocSystem.Logic.Domain.S_FileInfo(docSpace.ID, fileConfig.S_DOC_File.ID);
if (!String.IsNullOrEmpty(doc.Attr))
{
this.SetFileAttr(file, doc.Attr);
}
file.DataEntity.SetValue("Name", doc.Name);
file.DataEntity.SetValue("Code", doc.Code);
file.DataEntity.SetValue("RelateID", doc.ID);
file.DataEntity.SetValue("State", DocState.Normal);
if (!String.IsNullOrEmpty(doc.MainFiles) || !String.IsNullOrEmpty(doc.PDFFile) ||
!String.IsNullOrEmpty(doc.PlotFile) || !String.IsNullOrEmpty(doc.XrefFile) ||
!String.IsNullOrEmpty(doc.DwfFile) || !String.IsNullOrEmpty(doc.TiffFile) ||
!String.IsNullOrEmpty(doc.SignPdfFile))
{
var attachment = new S_Attachment(docSpace.ID);
attachment.DataEntity.SetValue("MainFile", doc.MainFiles);
attachment.DataEntity.SetValue("PDFFile", doc.PDFFile);
attachment.DataEntity.SetValue("PlotFile", doc.PlotFile);
attachment.DataEntity.SetValue("XrefFile", doc.XrefFile);
attachment.DataEntity.SetValue("DwfFile", doc.DwfFile);
attachment.DataEntity.SetValue("TiffFile", doc.TiffFile);
attachment.DataEntity.SetValue("SignPdfFile", doc.SignPdfFile);
file.AddAttachment(attachment);
}
node.AddFile(file, true);
}
else
{
if (!String.IsNullOrEmpty(doc.Attr))
{
this.SetFileAttr(file, doc.Attr);
}
file.DataEntity.SetValue("RelateID", doc.ID);
file.Save();
var attachment = new S_Attachment(docSpace.ID);
attachment.DataEntity.SetValue("MainFile", doc.MainFiles);
attachment.DataEntity.SetValue("PDFFile", doc.PDFFile);
attachment.DataEntity.SetValue("PlotFile", doc.PlotFile);
attachment.DataEntity.SetValue("XrefFile", doc.XrefFile);
attachment.DataEntity.SetValue("DwfFile", doc.DwfFile);
attachment.DataEntity.SetValue("TiffFile", doc.TiffFile);
attachment.DataEntity.SetValue("SignPdfFile", doc.SignPdfFile);
file.AddAttachment(attachment);
}
doc.State = "Archive";
doc.ArchiveDate = DateTime.Now;
if (doc.RelateTable == "S_E_Product")
{
//string update = "Update S_E_Product Set ArchiveState='True', ArchiveDate='" + DateTime.Now.ToString() + "' where ID='" + doc.RelateID + "'";
string update = string.Format(@"update S_E_Product set ArchiveState='True', ArchiveDate='{2}' where ID='{0}'
update S_E_ProductVersion set ArchiveState='True', ArchiveDate='{2}' where ProductID='{0}' and Version='{1}'", doc.RelateID, doc.Version, DateTime.Now.ToString());
this.entities.Database.ExecuteSqlCommand(update);
}
}
#endregion
}
this.entities.SaveChanges();
};
if (System.Configuration.ConfigurationManager.AppSettings["UseMsdtc"].ToLower() == "true")
{
using (TransactionScope ts = new TransactionScope())
{
action();
ts.Complete();
}
}
else
{
action();
}
return(Json(""));
}
public void Publish()
{
var user = FormulaHelper.GetUserInfo();
if (this.ReorganizeState == DocSystem.Logic.ReorganizeState.Execute.ToString())
{
if (this.ReorganizeUser != user.UserID)
{
throw new Formula.Exceptions.BusinessException("【" + this.TaskName + "】已经由【" + this.ReorganizeUserName + "】整编，请等【" + this.ReorganizeUserName + "】整编完成以后再操作");
}
}
else if (this.ReorganizeState != DocSystem.Logic.ReorganizeState.Finish.ToString())
{
throw new Formula.Exceptions.BusinessException("【" + this.TaskName + "】未完成整编，无法归档");
}
var docList = this.GetDocConfigSqlHelper().ExecuteList <S_R_Reorganize_DocumentList>
("select * from S_R_Reorganize_DocumentList where S_R_ReorganizeID='" + this.ID + "'");
if (docList.Any(a => string.IsNullOrEmpty(a.ReorganizeFullID)))
{
throw new Formula.Exceptions.BusinessException("所有文件资料都指定整编目录后才能归档");
}
//归档
var docSpace = DocConfigHelper.CreateConfigSpaceByID(this.SpaceID);
var nodeIds = docList.Select(a => a.ReorganizeFullID.Split('.').LastOrDefault()).Distinct();
var db = SQLHelper.CreateSqlHelper(docSpace.SpaceKey, docSpace.ConnectString);
string sql = "select * from S_NodeInfo where ID in ('" + string.Join("','", nodeIds) + "') ";
var dt = db.ExecuteDataTable(sql);
var nodeList = new List <S_NodeInfo>();
foreach (DataRow row in dt.Rows)
{
nodeList.Add(new S_NodeInfo(row));
}
foreach (var item in docList)
{
var nodeID = item.ReorganizeFullID.Split('.').LastOrDefault();
var node = nodeList.FirstOrDefault(a => a.ID == nodeID);
if (node == null)
{
throw new Formula.Exceptions.BusinessException("【" + this.TaskName + "】未找到【" + item.Name + "】的整编目录【" + item.ReorganizePath + "】，无法归档");
}
var fileConfig = node.ConfigInfo.S_DOC_FileNodeRelation.FirstOrDefault();
if (fileConfig != null && fileConfig.S_DOC_File != null)
{
var file = S_FileInfo.GetFile(docSpace.ID, fileConfig.S_DOC_File.ID, " NodeID='" + node.ID + "' and RelateID='" + item.RelateID + "' ");
if (file == null)
{
file = new DocSystem.Logic.Domain.S_FileInfo(docSpace.ID, fileConfig.S_DOC_File.ID);
if (!String.IsNullOrEmpty(item.Attr))
{
this.SetFileAttr(file, item.Attr);
}
file.DataEntity.SetValue("Name", item.Name);
file.DataEntity.SetValue("Code", item.Code);
file.DataEntity.SetValue("RelateID", item.RelateID);
file.DataEntity.SetValue("State", DocState.Normal);
if (!String.IsNullOrEmpty(item.MainFile))
{
var attachment = new S_Attachment(docSpace.ID);
attachment.DataEntity.SetValue("MainFile", item.MainFile);
attachment.DataEntity.SetValue("PDFFile", item.PDFFile);
attachment.DataEntity.SetValue("PlotFile", item.PlotFile);
attachment.DataEntity.SetValue("XrefFile", item.XrefFile);
attachment.DataEntity.SetValue("DwfFile", item.DwfFile);
attachment.DataEntity.SetValue("TiffFile", item.TiffFile);
attachment.DataEntity.SetValue("SignPdfFile", item.SignPdfFile);
file.AddAttachment(attachment);
}
node.AddFile(file, true);
}
else
{
if (!String.IsNullOrEmpty(item.Attr))
{
this.SetFileAttr(file, item.Attr);
}
file.DataEntity.SetValue("RelateID", item.RelateID);
file.Save();
var attachment = new S_Attachment(docSpace.ID);
attachment.DataEntity.SetValue("MainFile", item.MainFile);
attachment.DataEntity.SetValue("PDFFile", item.PDFFile);
attachment.DataEntity.SetValue("PlotFile", item.PlotFile);
attachment.DataEntity.SetValue("XrefFile", item.XrefFile);
attachment.DataEntity.SetValue("DwfFile", item.DwfFile);
attachment.DataEntity.SetValue("TiffFile", item.TiffFile);
attachment.DataEntity.SetValue("SignPdfFile", item.SignPdfFile);
file.AddAttachment(attachment);
}
}
}
}
