public virtual void ShareFiles(HttpContext context) { YZRequest request = new YZRequest(context); int folderid = request.GetInt32("folderid"); JObject post = request.GetPostData <JObject>(); List <string> fileids = post["fileids"].ToObject <List <string> >(); using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider) { using (IDbConnection cn = provider.OpenConnection()) { YZSoft.FileSystem.FileCollection files = FileSystem.DirectoryManager.GetFiles(provider, cn, folderid, null, null, -1); foreach (string fileid in fileids) { if (files.TryGetFileByID(fileid) == null) { YZSoft.FileSystem.File file = new YZSoft.FileSystem.File(); file.FolderID = folderid; file.FileID = fileid; file.AddBy = YZAuthHelper.LoginUserAccount; file.AddAt = DateTime.Now; file.Comments = "share"; file.OrderIndex = YZSoft.FileSystem.DirectoryManager.GetFileNextOrderIndex(provider, cn, folderid); FileSystem.DirectoryManager.Insert(provider, cn, file); } } } } }
protected virtual DataSet GetSOPReportData(string fileid, int documentFolderID, JObject jProcess, Image chart) { DataSet rv = new DataSet(); File file = jProcess.ToObject <File>(); file.Chart = chart; using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider) { using (IDbConnection cn = provider.OpenConnection()) { //Global rv.Tables.Add(file.ToSOPTable(provider, cn, "Global")); //关卡 rv.Tables.Add(file.Sprites.SortByOrder().GetDetailTable(provider, cn, "ActivityDetail")); //RACI rv.Tables.Add(file.Sprites.SortByOrder().GetRACIDetailTable(provider, cn, "RACI")); //Risk rv.Tables.Add(file.Sprites.SortByOrder().GetActivityReferenceDetailTable(provider, cn, "Risk", "RiskDetail")); //KPI rv.Tables.Add(file.Sprites.SortByOrder().GetActivityReferenceDetailTable(provider, cn, "KPI", "KPIDetail")); //UsedByDocuments rv.Tables.Add(file.GetUsedByFiles(provider, cn).ToDetailTable(provider, cn, "UsedByDocuments")); //RelatedDocuments rv.Tables.Add(file.GetRelatedFiles(provider, cn).ToDetailTable(provider, cn, "RelatedDocuments")); //ChildProcess rv.Tables.Add(file.GetChildProcess(provider, cn).ToDetailTable(provider, cn, "ChildProcess")); //Forms rv.Tables.Add(file.AllFormReferences.ToDetailTable(provider, cn, "Forms")); //附件 YZSoft.FileSystem.FileCollection docs = FileSystem.DirectoryManager.GetFiles(provider, cn, documentFolderID, "ISNULL(Flag,'')<>'Generate'", "ID DESC", -1); docs = docs.PerformAttachmentInfo(provider, cn, null); rv.Tables.Add(docs.ToDetailTable("Attachments")); } } return(rv); }