public IHttpActionResult InitPage(string projectId)
{
var info = RenewalInfo.Get(projectId);
var siteInfoProject = ProjectInfo.Get(projectId, FlowCode.Renewal_SiteInfo);
var estimatedVsActualConstruction = EstimatedVsActualConstruction.FirstOrDefault(e => e.RefId == siteInfoProject.Id);
if (estimatedVsActualConstruction == null)
{
var consInfo = RenewalConsInfo.Get(projectId);
var reinBasicInfo = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id);
var storeInfo = StoreSTLocation.FirstOrDefault(e => e.StoreCode == info.USCode);
estimatedVsActualConstruction = new EstimatedVsActualConstruction
{
RefId = siteInfoProject.Id,
GBDate = reinBasicInfo != null ? reinBasicInfo.GBDate : null,
CompletionDate = reinBasicInfo != null ? reinBasicInfo.ConsCompletionDate : null,
ARDC = reinBasicInfo != null ? reinBasicInfo.NewDesignType : null,
OriginalOperationSize = storeInfo.TotalArea,
OriginalSeatNumber = storeInfo.TotalSeatsNo,
ClosureDays = reinBasicInfo != null ? (reinBasicInfo.ConsCompletionDate.Value - reinBasicInfo.GBDate.Value).TotalDays.ToString() : ""
};
}
var result = new
{
Info = info,
Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_SiteInfo),
EstimatedVsActualConstruction = estimatedVsActualConstruction
};
return(Ok(result));
}
public IHttpActionResult GetCreateFlowInfo(string projectId, string flowCode)
{
Object entity = null;
if (flowCode.ToLower() == "rebuild")
{
entity = new RebuildInfo().GetRebuildInfo(projectId);
}
else if (flowCode.ToLower() == "reimage")
{
entity = ReimageInfo.GetReimageInfo(projectId);
}
else if (flowCode.ToLower() == "renewal")
{
entity = RenewalInfo.Get(projectId);
}
else if (flowCode.ToLower() == "tempclosure")
{
entity = TempClosureInfo.Get(projectId);
}
else if (flowCode.ToLower() == "closure")
{
entity = ClosureInfo.GetByProjectId(projectId);
}
else if (flowCode.ToLower() == "majorlease")
{
entity = new MajorLeaseInfo().GetMajorLeaseInfo(projectId);
}
return(Ok(entity));
}
public void DownloadToolTemplate(string projectId)
{
var renewalTool = RenewalTool.Get(projectId);
var renewalInfo = RenewalInfo.Get(projectId);
var fileName = renewalTool.DownloadToolTemplate();
var current = HttpContext.Current;
current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + SiteFilePath.GetTemplateFileName(renewalInfo.USCode, FlowCode.Renewal_Tool, "RenewalToolTemplate.xlsx"));
current.Response.ContentType = "application/octet-stream";
current.Response.WriteFile(fileName);
current.Response.End();
}
public IHttpActionResult InitPage(string projectId, string id = null)
{
var entity = RenewalConfirmLetter.Get(projectId, id);
return(Ok(new
{
Entity = entity,
Info = RenewalInfo.Get(projectId),
Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_ConfirmLetter),
Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_ConfirmLetter),
Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_ConfirmLetter)
}));
}
public IHttpActionResult InitPage(string projectId)
{
var info = RenewalInfo.Get(projectId);
var nego = RenewalLLNegotiation.Get(projectId);
return(Ok(new
{
LLNegotiation = nego,
USCode = info.USCode,
Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_LLNegotiation),
Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_LLNegotiation),
Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_LLNegotiation)
}));
}
public ActionResult StoreProjectRowsCount(string _USCode)
{
var resultData = new
{
ClosureRowsCount = ClosureInfo.Search(o => o.USCode == _USCode).ToList <ClosureInfo>().Count,
RenewalRowsCount = RenewalInfo.Search(o => o.USCode == _USCode).ToList <RenewalInfo>().Count,
RebuildRowsCount = RebuildInfo.Search(o => o.USCode == _USCode).ToList <RebuildInfo>().Count,
MajorLeaseRowsCount = MajorLeaseInfo.Search(o => o.USCode == _USCode).ToList <MajorLeaseInfo>().Count,
ReimageRowsCount = ReimageInfo.Search(o => o.USCode == _USCode).ToList <ReimageInfo>().Count,
TempClosureRowsCount = TempClosureInfo.Search(o => o.USCode == _USCode).ToList <TempClosureInfo>().Count
};
string result = Newtonsoft.Json.JsonConvert.SerializeObject(resultData);
return(Content(result));
}
public IHttpActionResult InitPage(string projectId, string id = null)
{
var letter = RenewalLetter.Get(projectId, id);
var project = ProjectInfo.Get(projectId, FlowCode.Renewal_Letter);
var isActor = ProjectUsers.IsRole(projectId, ClientCookie.UserCode, ProjectUserRoleCode.AssetActor);
letter.IsProjectFreezed = letter.CheckIfFreezeProject(projectId);
var nextRefTableId = new Guid(FlowInfo.GetRefTableId("RenewalConsInfo", projectId));
var nextFlowStarted = ProjectInfo.IsFlowStarted(projectId, FlowCode.Renewal_ConsInfo);
var haveTask = TaskWork.Any(t => t.RefID == projectId && t.TypeCode == FlowCode.Renewal_Letter && t.Status == TaskWorkStatus.UnFinish && t.ReceiverAccount == ClientCookie.UserCode);
var projectComment = ProjectComment.GetSavedComment(letter.Id, "RenewalLetter", ClientCookie.UserCode);
var isStarted = ProjectInfo.IsFlowStarted(projectId, FlowCode.Renewal_Letter);
var isFinished = ProjectInfo.IsFlowFinished(projectId, FlowCode.Renewal_Letter);
return(Ok(new
{
Info = RenewalInfo.FirstOrDefault(info => info.ProjectId == letter.ProjectId),
Letter = letter,
ProjectComment = projectComment != null ? projectComment.Content : "",
Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_Letter),
Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_Letter),
Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_Letter) && string.IsNullOrEmpty(id)
}));
}
public static List <EmailSendingResultType> SendPackageApprovalEmail(RenewalInfo info, RenewalPackage entity, ApproveUsers approvers)
{
var project = ProjectInfo.Get(entity.ProjectId, FlowCode.Renewal_Package);
var storeBasic = StoreBasicInfo.GetStorInfo(project.USCode);
var storeContract = StoreContractInfo.Search(c => c.StoreCode == project.USCode).OrderByDescending(c => c.CreatedTime).FirstOrDefault();
var assetMgr = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetManager);
var assetActor = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetActor);
var assetRep = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetRep);
var results = new List <EmailSendingResultType>();
using (EmailServiceClient emailClient = new EmailServiceClient())
{
List <SimpleEmployee> approveEmps = new List <SimpleEmployee> {
approvers.MarketMgr,
approvers.GM,
approvers.MDD,
approvers.FC,
approvers.MCCLAssetDtr
};
if (approvers.RegionalMgr != null)
{
approveEmps.Add(approvers.RegionalMgr);
}
if (approvers.CDO != null)
{
approveEmps.Add(approvers.CDO);
}
if (approvers.ManagingDirector != null)
{
approveEmps.Add(approvers.ManagingDirector);
}
//邮件模板中的数据
Dictionary <string, string> bodyValues = new Dictionary <string, string>();
//邮件内容中的键值对
bodyValues.Add("ApplicantName", ClientCookie.UserNameENUS);//--提交人
bodyValues.Add("StoreCode", storeBasic.StoreCode);
bodyValues.Add("StoreName", storeBasic.NameENUS + @" \ " + storeBasic.NameZHCN);
bodyValues.Add("Actor", assetActor.UserNameENUS); ////--呈递人
//bodyValues.Add("WorkflowName", Constants.TempClosure_Package);////--流程名称
bodyValues.Add("ProjectName", Constants.TempClosure); //项目名称
var viewPage = string.Format("{0}/Renewal/Main#/Package/View/param?projectId={1}",
HttpContext.Current.Request.Url.Authority, entity.ProjectId);
bodyValues.Add("FormUrl", viewPage);
Dictionary <string, string> templateFileds = entity.GetPrintTemplateFields();
var approveRecords = ProjectComment.GetList("TempClosurePackage", entity.Id, ProjectCommentStatus.Submit).Select(pc => new SubmissionApprovalRecord
{
OperatorID = pc.UserAccount,
OperatorName = pc.UserNameENUS,
OperatorTitle = pc.TitleNameENUS,
OperationDate = pc.CreateTime.HasValue ? pc.CreateTime.Value : DateTime.Now,
ActionName = pc.ActivityName,
Comments = pc.Content
}).ToList();
string imgPath = HtmlConversionUtility.HtmlConvertToPDF(HtmlTempalteType.Renewal, templateFileds, approveRecords);
approveEmps.ForEach(e =>
{
EmailMessage email = new EmailMessage();
List <string> emailAddresses = new List <string>
{
e.Mail,
"*****@*****.**",
"*****@*****.**",
"*****@*****.**"
};
if (bodyValues.ContainsKey("ApproverName"))
{
bodyValues["ApproverName"] = e.NameENUS;
}
else
{
bodyValues.Add("ApproverName", e.NameENUS);//--提交人
}
email.EmailBodyValues = bodyValues;
email.To = string.Join(";", emailAddresses);
email.Attachments = imgPath;
//var result = emailClient.SendEmail(email);
results.Add(new EmailSendingResultType());
});
approvers.NoticeUsers.ForEach(e =>
{
EmailMessage email = new EmailMessage();
List <string> emailAddresses = new List <string>
{
e.Mail,
"*****@*****.**",
"*****@*****.**",
"*****@*****.**"
};
if (bodyValues.ContainsKey("ApproverName"))//--提交人
{
bodyValues["ApproverName"] = e.NameENUS;
}
else
{
bodyValues.Add("ApproverName", e.NameENUS);
}
email.EmailBodyValues = bodyValues;
email.To = string.Join(";", emailAddresses);
email.Attachments = imgPath;
//var result = emailClient.SendEmail(email);
results.Add(new EmailSendingResultType());
});
}
return(results);
}
protected static BaseWFEntity GetEmptyWorkflowEntity(string flowCode)
{
BaseWFEntity wfEntity = null;
switch (flowCode)
{
case FlowCode.MajorLease:
wfEntity = new MajorLeaseInfo();
wfEntity.IsMainProject = true;
break;
case FlowCode.MajorLease_LegalReview:
wfEntity = new MajorLeaseLegalReview();
break;
case FlowCode.MajorLease_FinanceAnalysis:
wfEntity = new MajorLeaseFinancAnalysis();
break;
case FlowCode.MajorLease_ConsInfo:
wfEntity = new MajorLeaseConsInfo();
break;
case FlowCode.MajorLease_Package:
wfEntity = new MajorLeaseChangePackage();
break;
case FlowCode.MajorLease_ConsInvtChecking:
wfEntity = new MajorLeaseConsInvtChecking();
break;
case FlowCode.MajorLease_GBMemo:
wfEntity = new MajorLeaseGBMemo();
break;
case FlowCode.Closure:
wfEntity = new ClosureInfo();
wfEntity.IsMainProject = true;
break;
case FlowCode.Closure_ClosurePackage:
wfEntity = new ClosurePackage();
break;
case FlowCode.Closure_ClosureTool:
wfEntity = new ClosureTool();
break;
case FlowCode.Closure_ConsInvtChecking:
wfEntity = new ClosureConsInvtChecking();
break;
case FlowCode.Closure_LegalReview:
wfEntity = new ClosureLegalReview();
break;
case FlowCode.Closure_WOCheckList:
wfEntity = new ClosureWOCheckList();
break;
case FlowCode.Closure_ExecutiveSummary:
wfEntity = new ClosureExecutiveSummary();
break;
case FlowCode.TempClosure:
wfEntity = new TempClosureInfo();
wfEntity.IsMainProject = true;
break;
case FlowCode.TempClosure_LegalReview:
wfEntity = new TempClosureLegalReview();
break;
case FlowCode.TempClosure_ClosurePackage:
wfEntity = new TempClosurePackage();
break;
case FlowCode.Rebuild:
wfEntity = new RebuildInfo();
wfEntity.IsMainProject = true;
break;
case FlowCode.Rebuild_LegalReview:
wfEntity = new RebuildLegalReview();
break;
case FlowCode.Rebuild_FinanceAnalysis:
wfEntity = new RebuildFinancAnalysis();
break;
case FlowCode.Rebuild_ConsInfo:
wfEntity = new RebuildConsInfo();
break;
case FlowCode.Rebuild_Package:
wfEntity = new RebuildPackage();
break;
case FlowCode.Rebuild_ConsInvtChecking:
wfEntity = new RebuildConsInvtChecking();
break;
case FlowCode.Rebuild_GBMemo:
wfEntity = new GBMemo();
break;
case FlowCode.Renewal:
wfEntity = new RenewalInfo();
wfEntity.IsMainProject = true;
break;
case FlowCode.Renewal_Letter:
wfEntity = new RenewalLetter();
break;
case FlowCode.Renewal_LLNegotiation:
wfEntity = new RenewalLLNegotiation();
break;
case FlowCode.Renewal_ConsInfo:
wfEntity = new RenewalConsInfo();
break;
case FlowCode.Renewal_Tool:
wfEntity = new RenewalTool();
break;
case FlowCode.Renewal_Analysis:
wfEntity = new RenewalAnalysis();
break;
case FlowCode.Renewal_ClearanceReport:
wfEntity = new RenewalClearanceReport();
break;
case FlowCode.Renewal_ConfirmLetter:
wfEntity = new RenewalConfirmLetter();
break;
case FlowCode.Renewal_LegalApproval:
wfEntity = new RenewalLegalApproval();
break;
case FlowCode.Renewal_Package:
wfEntity = new RenewalPackage();
break;
case FlowCode.Renewal_GBMemo:
wfEntity = new RenewalGBMemo();
break;
case FlowCode.Reimage:
wfEntity = new ReimageInfo();
wfEntity.IsMainProject = true;
break;
case FlowCode.Reimage_ConsInfo:
wfEntity = new ReimageConsInfo();
break;
case FlowCode.Reimage_Summary:
wfEntity = new ReimageSummary();
break;
case FlowCode.Reimage_Package:
wfEntity = new ReimagePackage();
break;
case FlowCode.Reimage_ConsInvtChecking:
wfEntity = new ReimageConsInvtChecking();
break;
case FlowCode.Reimage_GBMemo:
wfEntity = new ReimageGBMemo();
break;
}
return(wfEntity);
}
public IHttpActionResult Update(RenewalInfo renewal)
{
renewal.UpdateFromProjectList();
return(Ok());
}
public IHttpActionResult Get(string projectId)
{
return(Ok(RenewalInfo.Get(projectId)));
}
public IHttpActionResult Create(PostCreateWorkflow <RenewalInfo> postCreateRenewal)
{
RenewalInfo.Create(postCreateRenewal);
return(Ok());
}
public IHttpActionResult GetRenewalApprovers(string flowCode, string projectId = "")
{
if (string.IsNullOrEmpty(flowCode))
{
return(BadRequest("flowCode is NULL"));
}
RenewalInfo renewalInfo = RenewalInfo.Get(projectId);
if (renewalInfo == null)
{
return(BadRequest("Could not find the Renewal Info, please check it!"));
}
var dicUsers = new Dictionary <string, object>();
var consMgr = ProjectUsers.GetProjectUser(projectId, ProjectUserRoleCode.CM);
switch (flowCode)
{
case FlowCode.Renewal_Letter:
{
var info = RenewalInfo.Get(projectId);
dicUsers.Add("AssetManagerCode", info.AssetManagerAccount);
dicUsers.Add("AssetManagers", new[] { Employee.GetSimpleEmployeeByCode(info.AssetManagerAccount) });
}
break;
case FlowCode.Renewal_GBMemo:
{
var refTableId = RenewalInfo.GetRefTableId("RenewalGBMemo", projectId);
var approvers = ApproveDialogUser.GetApproveDialogUser(refTableId) ?? new ApproveDialogUser();
dicUsers.Add("ConstructionManagerCode", approvers.ConstructionManagerCode);
dicUsers.Add("ConstructionManagers", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Cons_Mgr));
}
break;
case FlowCode.Renewal_ConsInfo:
{
var refTableId = RenewalInfo.GetRefTableId("RenewalConsInfo", projectId);
var approvers = ApproveDialogUser.GetApproveDialogUser(refTableId) ?? new ApproveDialogUser();
dicUsers.Add("ConstructionManagerCode", approvers.ConstructionManagerCode);
dicUsers.Add("MCCLConsManagerCode", approvers.MCCLConsManagerCode);
dicUsers.Add("ConstructionManagers", new List <SimpleEmployee> {
new SimpleEmployee {
Code = consMgr.UserAccount, NameENUS = consMgr.UserNameENUS, NameZHCN = consMgr.UserNameZHCN
}
});
dicUsers.Add("MCCLConsManagers", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.MCCL_Cons_Manager));
}
break;
case FlowCode.Renewal_Tool:
{
var refTableId = RenewalInfo.GetRefTableId("RenewalTool", projectId);
var approvers = ApproveDialogUser.GetApproveDialogUser(refTableId) ?? new ApproveDialogUser();
dicUsers.Add("FMCode", approvers.FMCode);
dicUsers.Add("FMs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Finance_Manager));
}
break;
case FlowCode.Renewal_LegalApproval:
{
var legal = ProjectUsers.GetProjectUser(projectId, ProjectUserRoleCode.Legal);
var refTableId = RenewalInfo.GetRefTableId("RenewalLegalApproval", projectId);
var approvers = ApproveDialogUser.GetApproveDialogUser(refTableId) ?? new ApproveDialogUser();
dicUsers.Add("LegalCode", legal.UserAccount);
dicUsers.Add("Legals", new List <SimpleEmployee> {
new SimpleEmployee {
Code = legal.UserAccount, NameENUS = legal.UserNameENUS, NameZHCN = legal.UserNameZHCN
}
});
dicUsers.Add("GeneralCounselCode", approvers.GeneralCounselCode);
dicUsers.Add("GeneralCounsels", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Legal_GeneralCounsel));
}
break;
case FlowCode.Renewal_Package:
{
var refTableId = RenewalInfo.GetRefTableId("RenewalPackage", projectId);
var approvers = ApproveDialogUser.GetApproveDialogUser(refTableId) ?? new ApproveDialogUser();
dicUsers.Add("MarketMgrCode", approvers.MarketMgrCode);
dicUsers.Add("MarketMgrs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Market_Asset_Mgr));
dicUsers.Add("RegionalMgrCode", approvers.RegionalMgrCode);
dicUsers.Add("RegionalMgrs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Regional_Asset_Mgr));
dicUsers.Add("MDDCode", approvers.MDDCode);
dicUsers.Add("MDDs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Market_DD));
dicUsers.Add("GMCode", approvers.GMCode);
dicUsers.Add("GMs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.GM));
dicUsers.Add("FCCode", approvers.FCCode);
dicUsers.Add("FCs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Finance_Controller));
dicUsers.Add("RDDCode", approvers.RDDCode);
dicUsers.Add("RDDs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.Regional_DD));
dicUsers.Add("VPGMCode", approvers.VPGMCode);
dicUsers.Add("VPGMs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.VPGM));
dicUsers.Add("MCCLAssetDtrCode", approvers.MCCLAssetDtrCode);
dicUsers.Add("MCCLAssetDtrs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.MCCL_Asset_Director));
dicUsers.Add("CDOCode", approvers.CDOCode);
dicUsers.Add("CDOs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.CDO));
dicUsers.Add("ManagingDirectorCode", approvers.MngDirectorCode);
dicUsers.Add("ManagingDirectors", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.MD)); //MCCL_Cons_Director
dicUsers.Add("MCCLAssetMgrCode", approvers.MCCLAssetMgrCode);
dicUsers.Add("MCCLAssetMgrs", Employee.GetStoreEmployeesByRole(renewalInfo.USCode, RoleCode.MCCL_Asset_Mgr));
dicUsers.Add("NoticeUsers", !string.IsNullOrEmpty(approvers.NoticeUsers) ? Employee.GetSimpleEmployeeByCodes(approvers.NoticeUsers.Split(';')) : null);
dicUsers.Add("NecessaryNoticeUsers", !string.IsNullOrEmpty(approvers.NecessaryNoticeUsers) ? Employee.GetSimpleEmployeeByCodes(approvers.NecessaryNoticeUsers.Split(';')) : Employee.GetSimpleEmployeeByCodes(NecessaryNoticeConfig.Search(i => i.FlowCode == FlowCode.Renewal_Package && !string.IsNullOrEmpty(i.DefaultUserCode)).Select(i => i.DefaultUserCode).ToArray()));
}
break;
}
return(Ok(dicUsers));
}
public IHttpActionResult UploadAttachment(string flowCode, string typeCode, string usCode, Guid Id)
{
var refTableId = string.Empty;
var refTableName = string.Empty;
var projectInfo = ProjectInfo.Get(Id);
var projectId = string.Empty;
if (projectInfo == null)
{
projectId = ProjectInfo.CreateDLProject(Id, flowCode, usCode, NodeCode.Start, ClientCookie.UserCode, false);
}
else
{
projectId = projectInfo.ProjectId;
}
using (TransactionScope tranScope = new TransactionScope())
{
switch (flowCode)
{
case FlowCode.Closure:
refTableName = "ClosureInfo";
var closureInfo = ClosureInfo.FirstOrDefault(i => i.ProjectId == projectId);
if (closureInfo != null)
{
refTableId = closureInfo.Id.ToString();
}
else
{
closureInfo = new ClosureInfo();
closureInfo.Id = Guid.NewGuid();
closureInfo.ProjectId = projectId;
closureInfo.USCode = usCode;
closureInfo.CreateDate = DateTime.Now;
closureInfo.CreateUserAccount = ClientCookie.UserCode;
closureInfo.CreateUserNameENUS = ClientCookie.UserNameENUS;
closureInfo.CreateUserNameZHCN = ClientCookie.UserNameZHCN;
closureInfo.Add();
refTableId = closureInfo.Id.ToString();
}
break;
case FlowCode.Rebuild:
refTableName = "RebuildInfo";
var rebuildInfo = RebuildInfo.FirstOrDefault(i => i.ProjectId == projectId);
if (rebuildInfo != null)
{
refTableId = rebuildInfo.Id.ToString();
}
else
{
rebuildInfo = new RebuildInfo();
rebuildInfo.Id = Guid.NewGuid();
rebuildInfo.ProjectId = projectId;
rebuildInfo.USCode = usCode;
rebuildInfo.CreateTime = DateTime.Now;
rebuildInfo.CreateUserAccount = ClientCookie.UserCode;
rebuildInfo.CreateUserNameENUS = ClientCookie.UserNameENUS;
rebuildInfo.CreateUserNameZHCN = ClientCookie.UserNameZHCN;
rebuildInfo.Add();
refTableId = rebuildInfo.Id.ToString();
}
break;
case FlowCode.MajorLease:
refTableName = "MajorLeaseInfo";
var majorLeaseInfo = MajorLeaseInfo.FirstOrDefault(i => i.ProjectId == projectId);
if (majorLeaseInfo != null)
{
refTableId = majorLeaseInfo.Id.ToString();
}
else
{
majorLeaseInfo = new MajorLeaseInfo();
majorLeaseInfo.Id = Guid.NewGuid();
majorLeaseInfo.ProjectId = projectId;
majorLeaseInfo.USCode = usCode;
majorLeaseInfo.CreateTime = DateTime.Now;
majorLeaseInfo.CreateUserAccount = ClientCookie.UserCode;
majorLeaseInfo.CreateUserNameENUS = ClientCookie.UserNameENUS;
majorLeaseInfo.CreateUserNameZHCN = ClientCookie.UserNameZHCN;
majorLeaseInfo.Add();
refTableId = majorLeaseInfo.Id.ToString();
}
break;
case FlowCode.Renewal:
refTableName = "RenewalInfo";
var renewalInfo = RenewalInfo.Get(projectId);
if (renewalInfo != null)
{
refTableId = renewalInfo.Id.ToString();
}
else
{
renewalInfo = new RenewalInfo();
renewalInfo.Id = Guid.NewGuid();
renewalInfo.ProjectId = projectId;
renewalInfo.USCode = usCode;
renewalInfo.CreateTime = DateTime.Now;
renewalInfo.CreateUserAccount = ClientCookie.UserCode;
renewalInfo.Add();
refTableId = renewalInfo.Id.ToString();
}
break;
case FlowCode.Reimage:
refTableName = "ReimageInfo";
var reimageInfo = ReimageInfo.GetReimageInfo(projectId);
if (reimageInfo != null)
{
refTableId = reimageInfo.Id.ToString();
}
else
{
reimageInfo = new ReimageInfo();
reimageInfo.Id = Guid.NewGuid();
reimageInfo.ProjectId = projectId;
reimageInfo.USCode = usCode;
reimageInfo.CreateDate = DateTime.Now;
reimageInfo.CreateUserAccount = ClientCookie.UserCode;
reimageInfo.CreateUserNameENUS = ClientCookie.UserNameENUS;
reimageInfo.CreateUserNameZHCN = ClientCookie.UserNameZHCN;
reimageInfo.Add();
refTableId = reimageInfo.Id.ToString();
}
break;
}
if (!string.IsNullOrEmpty(refTableId))
{
var files = HttpContext.Current.Request.Files;
var file = files[0];
string fileName = Path.GetFileName(file.FileName);
string fileExtension = Path.GetExtension(file.FileName);
var current = System.Web.HttpContext.Current;
string internalName = Guid.NewGuid() + fileExtension;
string absolutePath = current.Server.MapPath("~/") + "UploadFiles/" + internalName;
file.SaveAs(absolutePath);
Attachment att = Attachment.FirstOrDefault(i => i.RefTableID == refTableId && i.RefTableName == refTableName && i.TypeCode == typeCode);
if (att != null)
{
att.InternalName = internalName;
att.RefTableName = refTableName;
att.RefTableID = refTableId;
att.RelativePath = "//";
att.Name = fileName;
att.Extension = fileExtension;
att.Length = file.ContentLength;
att.CreateTime = DateTime.Now;
att.CreatorNameZHCN = ClientCookie.UserNameZHCN;
att.CreatorNameENUS = ClientCookie.UserNameENUS;
att.CreatorID = ClientCookie.UserCode;
Attachment.Update(att);
}
else
{
att = new Attachment();
att.InternalName = internalName;
att.RefTableName = refTableName;
att.RefTableID = refTableId;
att.RelativePath = "//";
att.Name = fileName;
att.Extension = fileExtension;
att.Length = file.ContentLength;
att.CreateTime = DateTime.Now;
att.CreatorNameZHCN = ClientCookie.UserNameZHCN;
att.CreatorNameENUS = ClientCookie.UserNameENUS;
att.CreatorID = ClientCookie.UserCode;
att.ID = Guid.NewGuid();
att.TypeCode = typeCode;
Attachment.Add(att);
}
}
tranScope.Complete();
return(Ok());
}
}
public IHttpActionResult GetAttachments(Guid Id, string flowCode)
{
var refTableId = string.Empty;
var refTableName = string.Empty;
var projectInfo = ProjectInfo.Get(Id);
if (projectInfo != null)
{
switch (flowCode)
{
case FlowCode.Closure:
refTableName = "ClosureInfo";
var closureInfo = ClosureInfo.GetByProjectId(projectInfo.ProjectId);
if (closureInfo != null)
{
refTableId = closureInfo.Id.ToString();
}
break;
case FlowCode.Rebuild:
refTableName = "RebuildInfo";
var rebuildInfo = RebuildInfo.FirstOrDefault(i => i.ProjectId == projectInfo.ProjectId);
if (rebuildInfo != null)
{
refTableId = rebuildInfo.Id.ToString();
}
break;
case FlowCode.MajorLease:
refTableName = "MajorLeaseInfo";
var majorLeaseInfo = MajorLeaseInfo.FirstOrDefault(i => i.ProjectId == projectInfo.ProjectId);
if (majorLeaseInfo != null)
{
refTableId = majorLeaseInfo.Id.ToString();
}
break;
case FlowCode.Renewal:
refTableName = "RenewalInfo";
var renewalInfo = RenewalInfo.Get(projectInfo.ProjectId);
if (renewalInfo != null)
{
refTableId = renewalInfo.Id.ToString();
}
break;
case FlowCode.Reimage:
refTableName = "ReimageInfo";
var reimageInfo = ReimageInfo.GetReimageInfo(projectInfo.ProjectId);
if (reimageInfo != null)
{
refTableId = reimageInfo.Id.ToString();
}
break;
}
if (!string.IsNullOrEmpty(refTableId))
{
var list = Attachment.Search(i => i.RefTableName == refTableName && i.RefTableID == refTableId).ToList();
foreach (var item in list)
{
item.FileURL = SiteInfo.ServiceUrl + "api/attachment/download?id=" + item.ID;
}
return(Ok(list));
}
}
return(Ok());
}
