public override void Finish(TaskWorkStatus status, TaskWork task)
{
var info = RenewalInfo.Get(this.ProjectId);
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
{
using (TransactionScope tranScope = new TransactionScope())
{
ProjectProgress.SetProgress(ProjectId, "40%");
ProjectInfo.FinishNode(ProjectId, this.WorkflowCode, NodeCode.Finish);
var anlysisProj = ProjectInfo.FirstOrDefault(e => e.FlowCode == FlowCode.Renewal_Analysis &&
e.Status == ProjectStatus.UnFinish && e.ProjectId == ProjectId);
if (anlysisProj != null)
{
info.GenerateSubmitTask(FlowCode.Renewal_Analysis);
}
else
{
//Renewal Tool重新Edit并完成后，系统自动重新生成一次Renewal Analysis文件
var anlysis = RenewalAnalysis.Get(ProjectId);
if (anlysis != null)
{
anlysis.GenerateAttachment();
}
}
tranScope.Complete();
}
}
break;
}
}
public override void Finish(TaskWorkStatus status, TaskWork task)
{
var info = RenewalInfo.Get(this.ProjectId);
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
{
ProjectProgress.SetProgress(ProjectId, "90%");
var taskcontract = TaskWork.Search(e => e.RefID == ProjectId && e.TypeCode == FlowCode.Renewal_ContractInfo).FirstOrDefault();
if (taskcontract == null)
{
info.GenerateSubmitTask(FlowCode.Renewal_ContractInfo);
}
var taskSiteinfo = TaskWork.Search(e => e.RefID == ProjectId && e.TypeCode == FlowCode.Renewal_SiteInfo).FirstOrDefault();
if (taskSiteinfo == null)
{
info.GenerateSubmitTask(FlowCode.Renewal_SiteInfo);
}
ProjectInfo.CompleteMainIfEnable(ProjectId);
ProjectInfo.FinishNode(ProjectId, WorkflowCode, NodeCode.Renewal_Package_Approval);
}
break;
case TaskWorkStatus.K2ProcessDeclined:
{
ProjectInfo.UpdateProjectStatus(ProjectId, FlowCode.Renewal, ProjectStatus.Rejected);
ProjectInfo.Reject(ProjectId, FlowCode.Renewal_Package);
}
break;
}
}
public override void Finish(TaskWorkStatus status, TaskWork task)
{
var info = RenewalInfo.Get(ProjectId);
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
ProjectInfo.FinishNode(ProjectId, FlowCode.Renewal_LLNegotiation, NodeCode.Finish, ProjectStatus.Finished);
if (ProjectInfo.IsFlowFinished(ProjectId, FlowCode.Renewal_Letter))
{
ProjectProgress.SetProgress(ProjectId, "30%");
if (info.NeedProjectCostEst)
{
if (!ProjectInfo.IsFlowStarted(ProjectId, FlowCode.Renewal_ConsInfo))
{
info.GenerateSubmitTask(FlowCode.Renewal_ConsInfo);
}
}
else
{
ProjectInfo.FinishNode(ProjectId, FlowCode.Renewal_ConsInfo, NodeCode.Finish, ProjectStatus.Finished);
if (!ProjectInfo.IsFlowStarted(ProjectId, FlowCode.Renewal_Tool))
{
info.GenerateSubmitTask(FlowCode.Renewal_Tool);
}
}
}
break;
case TaskWorkStatus.K2ProcessDeclined:
break;
}
}
public static RenewalPackageDTO InitPage(string projectId, string id = null)
{
RenewalPackageDTO dto = new RenewalPackageDTO();
var entity = RenewalPackage.Get(projectId, id);
var project = ProjectInfo.Get(projectId, FlowCode.Renewal_Package);
var info = RenewalInfo.Get(projectId);
entity.IsProjectFreezed = entity.CheckIfFreezeProject(projectId);
entity.GenerateCover();
var haveTask = TaskWork.Any(t => t.RefID == projectId && t.TypeCode == FlowCode.Renewal_Package && t.Status == TaskWorkStatus.UnFinish && t.ReceiverAccount == ClientCookie.UserCode);
var projectComment = ProjectComment.GetSavedComment(entity.Id, "RenewalPackage", ClientCookie.UserCode);
var projectNode = NodeInfo.GetNodeInfo(project.NodeCode);
dto.Info = info;
dto.Entity = entity;
dto.Analysis = RenewalAnalysis.Get(entity.AnalysisId.Value);
dto.FinMeasureOutput = RenewalToolFinMeasureOutput.GetByToolId(entity.ToolId.Value);
dto.Uploadable = projectNode.Sequence >= 4 && ClientCookie.UserCode == dto.Info.AssetActorAccount;
var editStatuses = new[] { ProjectStatus.Finished, ProjectStatus.Rejected };
dto.ProjectComment = projectComment != null ? projectComment.Content : "";
dto.Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_Package);
dto.Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_Package);
dto.Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_Package) && string.IsNullOrEmpty(id);
if (entity.ProcInstId.HasValue)
{
var currentActivityName = K2FxContext.Current.GetCurrentActivityName(entity.ProcInstId.Value);
dto.Rejectable = !entity.WorkflowNormalActors.Contains(currentActivityName);
}
dto.IsLindaLu = string.Compare(ClientCookie.UserCode, ConfigurationManager.AppSettings["AssetMgrCode"], true) == 0;
return(dto);
}
public override string Edit()
{
var info = RenewalInfo.Get(this.ProjectId);
using (var tranScope = new TransactionScope())
{
var legalApproval = Duplicator.AutoCopy(this);
legalApproval.Id = Guid.NewGuid();
legalApproval.IsHistory = false;
legalApproval.LegalComments = "";
legalApproval.CreateUserAccount = ClientCookie.UserCode;
legalApproval.Add();
IsHistory = true;
this.Update();
ProjectInfo.Reset(ProjectId, this.WorkflowCode);
var attachments = Attachment.GetList(this.TableName, Id.ToString(), string.Empty);
attachments.ForEach(att =>
{
att.RefTableID = legalApproval.Id.ToString();
att.ID = Guid.NewGuid();
});
Attachment.Add(attachments.ToArray());
var assetActor = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetActor);
TaskWork.Cancel(t => t.RefID == ProjectId && t.Status == TaskWorkStatus.UnFinish);
var task = info.GenerateSubmitTask(this.WorkflowCode);
tranScope.Complete();
return(task.Url);
}
}
public override string Edit()
{
using (TransactionScope tranScope = new TransactionScope())
{
var info = RenewalInfo.Get(ProjectId);
this.IsHistory = true;
this.Update();
var entity = Duplicator.AutoCopy(this);
entity.Id = Guid.NewGuid();
entity.IsHistory = false;
entity.Add();
var attachments = Attachment.GetList(this.TableName, Id.ToString(), string.Empty);
attachments.ForEach(att =>
{
att.RefTableID = entity.Id.ToString();
att.ID = Guid.NewGuid();
});
Attachment.Add(attachments.ToArray());
TaskWork.Cancel(e => e.TypeCode == this.WorkflowCode && e.RefID == ProjectId && e.Status == TaskWorkStatus.UnFinish);
ProjectInfo.Reset(ProjectId, this.WorkflowCode);
var task = info.GenerateSubmitTask(this.WorkflowCode);
tranScope.Complete();
return(task.Url);
}
}
public override string Edit()
{
var taskUrl = string.Format("/Renewal/Main#/GBMemo?projectId={0}", ProjectId);
using (var scope = new TransactionScope())
{
var rbdInfo = RenewalInfo.Search(e => e.ProjectId.Equals(ProjectId)).FirstOrDefault();
if (rbdInfo == null)
{
throw new Exception("Could not find the Renewal Info, please check it!");
}
var task = rbdInfo.GenerateTaskWork(WorkflowCode, "Renewal GBMemo", "Renewal GBMemo", taskUrl);
task.ActivityName = NodeCode.Start;
task.ActionName = SetTaskActionName(ProjectId);
TaskWork.Add(task);
CompleteNotifyTask(ProjectId);
AttachmentsMemoProcessInfo.UpdateNotifyDate(ProjectId, FlowCode.GBMemo, false);
IsHistory = true;
Update(this);
Mapper.CreateMap <RenewalGBMemo, RenewalGBMemo>();
var entity = Mapper.Map <RenewalGBMemo>(this);
entity.Id = Guid.Empty;
entity.ProcInstID = null;
entity.IsHistory = false;
entity.Comments = null;
entity.Save("Edit");
CopyAppUsers(Id.ToString(), entity.Id.ToString());
scope.Complete();
}
return(taskUrl);
}
public static ConsInfoDTO <RenewalInfo, RenewalConsInfo> InitPage(string projectId, string id = "")
{
RenewalInfo info = RenewalInfo.Get(projectId);
var consInfo = RenewalConsInfo.Get(projectId, id);
if (consInfo == null)
{
consInfo = new RenewalConsInfo();
consInfo.ProjectId = projectId;
}
var isOriginator = ClientCookie.UserCode == info.PMAccount;
consInfo.IsProjectFreezed = consInfo.CheckIfFreezeProject(projectId);
var nextRefTableId = new Guid(FlowInfo.GetRefTableId("RenewalTool", projectId));
var nextFlowStarted = ProjectInfo.IsFlowStarted(projectId, FlowCode.Renewal_Tool);
var haveTask = TaskWork.Any(t => t.RefID == projectId && t.TypeCode == FlowCode.Renewal_Tool && t.Status == TaskWorkStatus.UnFinish && t.ReceiverAccount == ClientCookie.UserCode);
var projectComment = ProjectComment.GetSavedComment(consInfo.Id, "RenewalConsInfo", ClientCookie.UserCode);
if (string.IsNullOrEmpty(id))
{
consInfo.HasReinvenstment = info.NeedProjectCostEst;
}
ConsInfoDTO <RenewalInfo, RenewalConsInfo> dto = new ConsInfoDTO <RenewalInfo, RenewalConsInfo>();
dto.Entity = consInfo;
dto.Info = info;
dto.ReinBasicInfo = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id);
dto.ReinCost = ReinvestmentCost.GetByConsInfoId(consInfo.Id);
dto.WriteOff = WriteOffAmount.GetByConsInfoId(consInfo.Id);
dto.ProjectComment = projectComment != null ? projectComment.Content : "";
dto.Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_ConsInfo);
dto.Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_ConsInfo);
dto.Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_ConsInfo) && string.IsNullOrEmpty(id);
return(dto);
}
public override void Finish(TaskWorkStatus status, TaskWork task)
{
var info = RenewalInfo.Get(ProjectId);
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
ProjectProgress.SetProgress(ProjectId, "50%");
ProjectInfo.FinishNode(ProjectId, FlowCode.Renewal_Analysis, NodeCode.Finish, ProjectStatus.Finished);
if (info.RenewalYears > 2)
{
if (!ProjectInfo.FlowHaveTask(ProjectId, FlowCode.Renewal_ClearanceReport))
{
info.GenerateSubmitTask(FlowCode.Renewal_ClearanceReport);
}
}
else
{
ProjectInfo.FinishProject(this.ProjectId, FlowCode.Renewal_ClearanceReport);
if (!ProjectInfo.FlowHaveTask(ProjectId, FlowCode.Renewal_ConfirmLetter))
{
info.GenerateSubmitTask(FlowCode.Renewal_ConfirmLetter);
}
}
break;
case TaskWorkStatus.K2ProcessDeclined:
break;
}
}
public void Submit(string comment, Action onExecuting = null)
{
try
{
RenewalInfo info = RenewalInfo.Get(this.ProjectId);
var task = TaskWork.GetTaskWork(ProjectId, ClientCookie.UserCode, TaskWorkStatus.UnFinish,
FlowCode.Renewal, WorkflowCode);
var dataFields = SetWorkflowDataFields(task);
var procInstId = K2FxContext.Current.StartProcess(WorkflowProcessCode, ClientCookie.UserCode, dataFields);
if (procInstId > 0)
{
using (var tranScope = new TransactionScope())
{
task.Finish();
this.ProcInstId = procInstId;
this.CreateTime = DateTime.Now;
this.CreateUserAccount = ClientCookie.UserCode;
this.Update();
var project = ProjectInfo.Get(this.ProjectId, this.WorkflowCode);
project.CreateUserAccount = ClientCookie.UserCode;
project.Update();
var SavedComment = ProjectComment.GetSavedComment(this.Id, this.TableName, ClientCookie.UserCode);
if (SavedComment != null)
{
SavedComment.Status = ProjectCommentStatus.Submit;
SavedComment.Content = comment;
SavedComment.CreateTime = DateTime.Now;
SavedComment.Update();
}
else
{
ProjectComment.AddComment(
ProjectCommentAction.Submit,
comment,
this.Id,
this.TableName,
FlowCode.Renewal,
procInstId,
ProjectCommentStatus.Submit
);
}
ProjectInfo.FinishNode(this.ProjectId, this.WorkflowCode, NodeCode.Renewal_Tool_Input);
if (onExecuting != null)
{
onExecuting();
}
tranScope.Complete();
}
}
}
catch (Exception ex)
{
Log4netHelper.WriteInfo("[[Renewal Too]]:" + JsonConvert.SerializeObject(ex));
throw ex;
}
}
public static RenewalAnalysis Create(RenewalInfo info)
{
RenewalAnalysis analysis = new RenewalAnalysis();
analysis.Id = Guid.NewGuid();
analysis.ProjectId = info.ProjectId;
analysis.CreateTime = DateTime.Now;
analysis.CreateUserAccount = info.AssetActorAccount;
analysis.LeaseTenureAndTerm = string.Format("{0} years,from {1:yyyy-MM-dd} to {2:yyyy-MM-dd}", info.RenewalYears, info.NewLeaseStartDate, info.NewLeaseEndDate);
analysis.Add();
return(analysis);
}
public override void PrepareTask(TaskWork taskWork)
{
var info = RenewalInfo.Get(ProjectId);
if (taskWork.ReceiverAccount == info.AssetActorAccount && taskWork.ActivityName == "AssetActor")
{
ProjectInfo.FinishNode(ProjectId, this.WorkflowCode, NodeCode.Renewal_Tool_Approval);
if (!ProjectInfo.IsFlowFinished(ProjectId, FlowCode.Renewal_ConsInfo))
{
taskWork.Cancel();
}
}
}
public static List <string> GetYearMonths(string projectId, out string SelectedYearMonth)
{
var uscode = RenewalInfo.FirstOrDefault(ci => ci.ProjectId == projectId).USCode;
var yearMonthList = DataSync_LDW_AM_STFinanceData2.Search(f => f.UsCode == uscode).Select(i => new { YearMonth = i.FinanceYear + "-" + i.FinanceMonth }).Distinct().OrderByDescending(i => i).Take(12).ToList().Select(i => { return(i.YearMonth); }).ToList();
var ldw_financeData = LDW_FinanceData.Get(projectId);
if (ldw_financeData != null)
{
SelectedYearMonth = ldw_financeData.FinanceYear + "-" + ldw_financeData.FinanceMonth;
}
else
{
SelectedYearMonth = yearMonthList.FirstOrDefault();
}
return(yearMonthList);
}
public override List <ProcessDataField> SetWorkflowDataFields(TaskWork task)
{
RenewalInfo info = RenewalInfo.Get(this.ProjectId);
var processDataFields = new List <ProcessDataField>()
{
new ProcessDataField("dest_MCCLAssetManager", info.AssetManagerAccount),
new ProcessDataField("ProcessCode", WorkflowProcessCode)
};
if (task != null)
{
processDataFields.Add(new ProcessDataField("dest_Creator", ClientCookie.UserCode));
processDataFields.Add(new ProcessDataField("ProjectTaskInfo", JsonConvert.SerializeObject(task)));
}
return(processDataFields);
}
public override void Finish(TaskWorkStatus status, TaskWork task)
{
var info = RenewalInfo.Get(this.ProjectId);
Log4netHelper.WriteErrorLog(status.ToString());
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
{
Log4netHelper.WriteErrorLog("111111111");
ProjectProgress.SetProgress(ProjectId, "80%");
info.GenerateSubmitTask(FlowCode.Renewal_Package);
ProjectInfo.FinishNode(this.ProjectId, this.WorkflowCode, NodeCode.Renewal_LegalApproval_Approval, ProjectStatus.Finished);
Log4netHelper.WriteErrorLog("22222222");
}
break;
}
}
public override void Finish(TaskWorkStatus status, TaskWork task)
{
using (var scope = new TransactionScope())
{
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
RenewalInfo renInfo = RenewalInfo.Search(e => e.ProjectId.Equals(ProjectId)).FirstOrDefault();
var pmTaskUrl = string.Format(@"/Renewal/Main#/GBMemo/Process/Notify?projectId={0}", ProjectId);
var pmTask = renInfo.GenerateTaskWork(WorkflowCode, "Renewal GBMemo", "Renewal GBMemo", pmTaskUrl);
pmTask.ActivityName = "Notify";
pmTask.ActionName = "Notify";
TaskWork.Add(pmTask);
break;
}
scope.Complete();
}
}
public override List <ProcessDataField> SetWorkflowDataFields(TaskWork task)
{
RenewalInfo info = RenewalInfo.Get(this.ProjectId);
var processDataFields = new List <ProcessDataField>()
{
new ProcessDataField("dest_ConsMgr", !this.HasReinvenstment?"": AppUsers.ConstructionManager.Code),
new ProcessDataField("dest_MCCLConsMgr", !this.HasReinvenstment?"":AppUsers.MCCLConsManager.Code),
new ProcessDataField("ProcessCode", WorkflowProcessCode),
new ProcessDataField("IsNoReinvestment", (!this.HasReinvenstment).ToString(), "BOOLEAN")
};
if (task != null)
{
processDataFields.Add(new ProcessDataField("dest_Creator", ClientCookie.UserCode));
processDataFields.Add(new ProcessDataField("ProjectTaskInfo", JsonConvert.SerializeObject(task)));
}
return(processDataFields);
}
public override void Finish(TaskWorkStatus status, TaskWork task)
{
var info = RenewalInfo.Get(ProjectId);
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
ProjectProgress.SetProgress(ProjectId, "60%");
ProjectInfo.FinishNode(ProjectId, this.WorkflowCode, NodeCode.Finish, ProjectStatus.Finished);
if (!ProjectInfo.FlowHaveTask(ProjectId, FlowCode.Renewal_ConfirmLetter))
{
info.GenerateSubmitTask(FlowCode.Renewal_ConfirmLetter);
}
break;
case TaskWorkStatus.K2ProcessDeclined:
break;
}
}
public void GenerateCover()
{
if (!Attachment.Any(att => att.RefTableID == this.Id.ToString() && att.RequirementId == new Guid("9D1E247C-AAE0-44F6-869E-F50B3E633C1C")))
{
var info = RenewalInfo.Get(this.ProjectId);
var store = StoreBasicInfo.GetStorInfo(info.USCode);
var contract = StoreContractInfo.Get(info.USCode);
var context = HttpContext.Current;
var templateFileName = context.Server.MapPath("~/Template/RenewalCover_Template_v20130922.xlsx");
var fileName = context.Server.MapPath(string.Format("~/UploadFiles/{0}.xlsx", Guid.NewGuid()));
File.Copy(templateFileName, fileName);
var fileInfo = new FileInfo(fileName);
ExcelDataInputDirector excelDirector = new ExcelDataInputDirector(fileInfo, ExcelDataInputType.RenewalCover);
ExcelInputDTO excelInput = new ExcelInputDTO();
excelInput.Region = store.RegionENUS;
excelInput.Province = store.ProvinceZHCN;
excelInput.City = store.CityENUS;
excelInput.Market = store.MarketENUS;
excelInput.StoreName = store.NameZHCN;
excelInput.USCode = store.StoreCode;
excelInput.OpenDate = store.OpenDate;
excelInput.LeaseExpirationDate = contract.EndDate.Value;
excelInput.Priority = info.Priority;
excelDirector.Input(excelInput);
var att = new Attachment();
att.ID = Guid.NewGuid();
att.RefTableID = this.Id.ToString();
att.RefTableName = this.TableName;
att.RelativePath = "/";
att.TypeCode = "Cover";
att.RequirementId = Guid.Parse("9D1E247C-AAE0-44F6-869E-F50B3E633C1C");
att.Name = "Cover";
att.Extension = fileInfo.Extension;
att.InternalName = fileInfo.Name;
att.ContentType = "application/vnd.ms-excel";
att.Length = (int)fileInfo.Length;
att.CreatorID = ClientCookie.UserCode;
att.CreatorNameENUS = ClientCookie.UserNameENUS;
att.CreatorNameZHCN = ClientCookie.UserNameZHCN;
att.CreateTime = DateTime.Now;
att.Add();
}
}
public void UpdateStoreLLRecord()
{
var info = RenewalInfo.Get(this.ProjectId);
var negotiations = RenewalLLNegotiationRecord.GetRecords(this.Id);
if (negotiations.Count > 0)
{
StoreSTLLRecord record = StoreSTLLRecord.Get(info.USCode);
if (record == null)
{
var storeBasic = StoreBasicInfo.GetStorInfo(info.USCode);
record = new StoreSTLLRecord();
record.StoreCode = info.USCode;
record.StoreID = storeBasic.StoreID;
record.Id = Guid.NewGuid();
}
record.LLparticipants = negotiations[0].LLParticipants;
record.Location = negotiations[0].Location;
record.McdParticipants = negotiations[0].McdParticipants;
record.Content = negotiations[0].Content;
record.CreatedTime = negotiations[0].CreateTime;
record.Topic = negotiations[0].Topic;
record.Save();
var storeNegos = negotiations.Select(n => new StoreSTNegotiation
{
Id = Guid.NewGuid(),
StoreID = record.StoreID,
StoreCode = record.StoreCode,
IsBroker = record.IsBroker,
BrokerName = record.BrokerName,
DateTime = n.Date.Value.ToString("yyyy-MM-dd"),
Location = n.Location,
Topic = n.Topic,
McdParticipants = n.McdParticipants,
McdParticipantsAD = record.McdParticipantsAD,
LLparticipants = n.LLParticipants,
Content = n.Content,
CreatedTime = n.CreateTime
}).ToArray();
StoreSTNegotiation.Add(storeNegos);
}
}
public override string Edit()
{
var info = RenewalInfo.Get(ProjectId);
var analysis = Duplicator.AutoCopy(this);
analysis.Id = Guid.NewGuid();
analysis.IsHistory = false;
analysis.Add();
this.IsHistory = true;
this.Update();
ProjectInfo.Reset(ProjectId, this.WorkflowCode);
RenewalPackage package = RenewalPackage.Get(ProjectId);
package.AnalysisId = analysis.Id;
package.Update();
TaskWork.Cancel(e => e.TypeCode == FlowCode.Renewal_Analysis && e.RefID == ProjectId && e.Status == TaskWorkStatus.UnFinish);
var task = info.GenerateSubmitTask(FlowCode.Renewal_Analysis);
return(task.Url);
}
public override string Edit()
{
using (var tranScope = new TransactionScope())
{
var info = RenewalInfo.Get(this.ProjectId);
var entity = Duplicator.AutoCopy(this);
entity.Id = Guid.NewGuid();
entity.IsHistory = false;
entity.CreateTime = DateTime.Now;
entity.CreateUserAccount = ClientCookie.UserCode;
entity.Add();
this.IsHistory = true;
this.Update();
ProjectInfo.Reset(ProjectId, this.WorkflowCode);
var attachments = Attachment.GetList(this.TableName, Id.ToString(), string.Empty);
attachments.ForEach(att =>
{
att.RefTableID = entity.Id.ToString();
att.ID = Guid.NewGuid();
});
Attachment.Add(attachments.ToArray());
//var TypeCodes = new[] { FlowCode.Renewal_ContractInfo, FlowCode.Renewal_SiteInfo };
//foreach (var typeCode in TypeCodes)
//{
// var proj = ProjectInfo.Search(e => e.ProjectId == ProjectId && e.FlowCode == typeCode).FirstOrDefault();
// if (proj != null && proj.Status != ProjectStatus.Finished)
// {
// var oldTask = TaskWork.Search(t => t.RefID == ProjectId && t.Status == TaskWorkStatus.UnFinish && t.TypeCode == typeCode).FirstOrDefault();
// if (oldTask != null)
// {
// oldTask.Status = TaskWorkStatus.Cancel;
// TaskWork.Update(oldTask);
// }
// }
//}
var task = info.GenerateSubmitTask(this.WorkflowCode);
tranScope.Complete();
return(task.Url);
}
}
public static RenewalAnalysisDTO InitPage(string projectId)
{
RenewalAnalysisDTO dto = new RenewalAnalysisDTO();
var consInfo = RenewalConsInfo.Get(projectId);
var analysis = Get(projectId);
if (consInfo.HasReinvenstment)
{
var reinBasic = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentBasicInfo();
analysis.OperationSize = reinBasic.NewOperationSize;
}
dto.Info = RenewalInfo.Get(projectId);
analysis.LastRemodeling = GetLastRemodeling(dto.Info.USCode);
dto.Entity = analysis;
dto.HasReinvenstment = consInfo.HasReinvenstment;
dto.StoreInfo = PrepareStoreInfo(projectId, dto.Info.USCode);
dto.Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_Analysis);
dto.Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_Analysis);
dto.Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_Analysis);
return(dto);
}
public static RenewalLegalApprovalDTO InitPage(string projectId, string id = null)
{
RenewalLegalApprovalDTO dto = new RenewalLegalApprovalDTO();
var entity = Get(projectId, id);
var info = RenewalInfo.Get(projectId);
var isActor = ClientCookie.UserCode == info.AssetActorAccount;
entity.IsProjectFreezed = entity.CheckIfFreezeProject(projectId);
var nextRefTableId = new Guid(FlowInfo.GetRefTableId(entity.TableName, projectId));
var nextFlowStarted = ProjectInfo.IsFlowStarted(projectId, FlowCode.Renewal_Package);
var haveTask = TaskWork.Any(t => t.RefID == projectId && t.TypeCode == FlowCode.Renewal_LegalApproval && t.Status == TaskWorkStatus.UnFinish && t.ReceiverAccount == ClientCookie.UserCode);
var projectComment = ProjectComment.GetSavedComment(entity.Id, entity.TableName, ClientCookie.UserCode);
var appUser = ApproveDialogUser.GetApproveDialogUser(entity.Id.ToString());
dto.Info = info;
dto.Entity = entity;
dto.ProjectComment = projectComment != null ? projectComment.Content : "";
dto.IsGeneralCounsel = appUser != null && appUser.GeneralCounselCode == ClientCookie.UserCode;
dto.Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_LegalApproval);
dto.Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_LegalApproval);
dto.Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_LegalApproval) && string.IsNullOrEmpty(id);
return(dto);
}
public override void Finish(TaskWorkStatus status, TaskWork task)
{
switch (status)
{
case TaskWorkStatus.K2ProcessApproved:
{
ProjectInfo.FinishNode(ProjectId, this.WorkflowCode, NodeCode.Finish);
ProjectInfo.FinishNode(ProjectId, FlowCode.Renewal_LLNegotiation, NodeCode.Renewal_LLNegotiation_ConfirmLetter);
if (!ProjectInfo.IsFlowStarted(ProjectId, FlowCode.Renewal_ConsInfo))
{
var info = RenewalInfo.Get(task.RefID);
if (ProjectInfo.IsFlowFinished(ProjectId, FlowCode.Renewal_LLNegotiation))
{
ProjectProgress.SetProgress(ProjectId, "30%");
if (info.NeedProjectCostEst)
{
if (!ProjectInfo.IsFlowStarted(ProjectId, FlowCode.Renewal_ConsInfo))
{
info.GenerateSubmitTask(FlowCode.Renewal_ConsInfo);
}
}
else
{
ProjectInfo.FinishNode(ProjectId, FlowCode.Renewal_ConsInfo, NodeCode.Finish, ProjectStatus.Finished);
if (!ProjectInfo.IsFlowStarted(ProjectId, FlowCode.Renewal_Tool))
{
info.GenerateSubmitTask(FlowCode.Renewal_Tool);
}
}
}
}
TaskWork.Finish(t => t.TypeCode == this.WorkflowCode && t.RefID == this.ProjectId && t.Status == TaskWorkStatus.UnFinish);
}
break;
}
}
public override string Edit()
{
var info = RenewalInfo.Get(ProjectId);
var entity = Duplicator.AutoCopy(this);
entity.Id = Guid.NewGuid();
entity.IsHistory = false;
entity.Add();
this.IsHistory = true;
this.Update();
var records = RenewalLLNegotiationRecord.GetRecords(this.Id);
records.ForEach(rec =>
{
rec.Id = Guid.NewGuid();
rec.RenewalLLNegotiationId = entity.Id;
});
RenewalLLNegotiationRecord.Add(records.ToArray());
TaskWork.Cancel(e => e.TypeCode == this.WorkflowCode && e.RefID == ProjectId && e.Status == TaskWorkStatus.UnFinish);
ProjectInfo.Reset(ProjectId, this.WorkflowCode);
var task = info.GenerateSubmitTask(this.WorkflowCode);
return(task.Url);
}
public static RenewalGBMemo GetGBMemo(string projectId, string entityId = "")
{
var memo = (string.IsNullOrEmpty(entityId) ?
FirstOrDefault(e => e.ProjectId.Equals(projectId) && !e.IsHistory)
: FirstOrDefault(e => e.Id.ToString().Equals(entityId))) ?? new RenewalGBMemo();
memo.ProjectId = projectId;
var rnInfo = RenewalInfo.Get(projectId);
memo.Info = rnInfo;
memo.UsCode = rnInfo.USCode;
memo.Store = StoreBasicInfo.GetStore(memo.UsCode);
if (memo.Id == Guid.Empty)
{
memo.IsClosed = (memo.Store.StoreBasicInfo.statusName == "Closed");
memo.IsInOperation = false;
var consInfo = new RenewalConsInfo();
memo.ReinvestInfo = consInfo.GetReinvestmentBasicInfo(projectId);
if (memo.ReinvestInfo != null)
{
if ((memo.ReinvestInfo.NewAttachedKiosk.HasValue && memo.ReinvestInfo.NewAttachedKiosk.Value) ||
(memo.ReinvestInfo.NewRemoteKiosk.HasValue && memo.ReinvestInfo.NewRemoteKiosk.Value))
{
memo.IsKiosk = true;
}
memo.IsMcCafe = memo.ReinvestInfo.NewMcCafe.HasValue && memo.ReinvestInfo.NewMcCafe.Value;
memo.IsMDS = memo.ReinvestInfo.NewMDS.HasValue && memo.ReinvestInfo.NewMDS.Value;
memo.Is24Hour = memo.ReinvestInfo.NewTwientyFourHour.HasValue &&
memo.ReinvestInfo.NewTwientyFourHour.Value;
memo.GBDate = memo.ReinvestInfo.GBDate;
memo.ConstCompletionDate = memo.ReinvestInfo.ConsCompletionDate;
memo.ReopenDate = memo.ReinvestInfo.ReopenDate;
}
memo.Save();
}
else
{
var projectInfo = ProjectInfo.FirstOrDefault(e => e.ProjectId == projectId &&
e.FlowCode == FlowCode.Renewal_GBMemo);
if (projectInfo != null)
{
if (ClientCookie.UserCode.Equals(rnInfo.PMAccount))
{
var isFlowFlinshed =
TaskWork.Any(e =>
e.RefID == projectId && e.TypeCode == FlowCode.Renewal_GBMemo &&
e.Status == TaskWorkStatus.K2ProcessApproved && e.ProcInstID == memo.ProcInstID);
var isExistTask = TaskWork.Any(e => e.RefID == projectId &&
e.TypeCode == FlowCode.Renewal_GBMemo &&
e.Status == TaskWorkStatus.UnFinish &&
e.ReceiverAccount == ClientCookie.UserCode &&
(e.ActivityName == WFMajorLeaseLegalReview.Act_Originator || e.ActivityName == WFMajorLeaseLegalReview.Act_Start));
memo.IsShowEdit = isFlowFlinshed;
memo.IsShowRecall = !isFlowFlinshed && !isExistTask;
}
}
}
//if (ClientCookie.UserCode.Equals(rnInfo.PMAccount))
// memo.IsShowSave = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_GBMemo);
PopulateAppUsers(memo);
return(memo);
}
public string DownloadToolTemplate()
{
var templateFileName = string.Concat(SiteFilePath.Template_DIRECTORY, "/", SiteFilePath.RenewalTool_Template);
string fileName = string.Format("{0}/{1}.xlsx", SiteFilePath.TEMP_DIRECTORY, Guid.NewGuid());
File.Copy(templateFileName, fileName);
FileInfo fileInfo = new FileInfo(fileName);
ExcelDataInputDirector excelDirector = new ExcelDataInputDirector(fileInfo, ExcelDataInputType.RenewalTool);
ExcelInputDTO excelDto = new ExcelInputDTO();
var info = RenewalInfo.Get(this.ProjectId);
var storeBasic = StoreBasicInfo.GetStorInfo(info.USCode);
var storeContract = StoreContractInfo.Get(info.USCode);
var finInput = RenewalToolFinMeasureInput.Get(this.ProjectId, this.Id);
var wfAndReinCost = RenewalToolWriteOffAndReinCost.Get(this.ProjectId, this.Id);
excelDto.USCode = info.USCode;
excelDto.Market = storeBasic.Market;
excelDto.StoreName = storeBasic.NameZHCN + "/" + storeBasic.NameENUS;
excelDto.OpenDate = storeBasic.OpenDate;
if (storeContract.EndDate.HasValue)
{
excelDto.LeaseExpirationDate = storeContract.EndDate.Value;
}
excelDto.RenewalYears = info.RenewalYears;
excelDto.ProductSales = finInput.ProductSalesAdjustment;
excelDto.Pac = finInput.PacAdjustment;
excelDto.Rent = finInput.RentAdjustment;
excelDto.DepreciationLhi = finInput.DepreciationLhiAdjustment;
excelDto.InterestLhi = finInput.InterestLhiAdjustment;
excelDto.ServiceFee = finInput.ServiceFeeAdjustment;
excelDto.Accounting = finInput.AccountingAdjustment;
excelDto.Insurance = finInput.InsuranceAdjustment;
excelDto.TaxesAndLicenses = finInput.TaxesAndLicensesAdjustment;
excelDto.DepreciationEssd = finInput.DepreciationEssdAdjustment;
excelDto.InterestEssd = finInput.InterestEssdAdjustment;
excelDto.OtherIncExp = finInput.OtherIncExpAdjustment;
excelDto.NonProductSales = finInput.NonProductSalesAdjustment;
excelDto.NonProductCosts = finInput.NonProductCostsAdjustment;
excelDto.REII = wfAndReinCost.REII;
excelDto.LHIII = wfAndReinCost.LHIII;
excelDto.ESSDII = wfAndReinCost.ESSDII;
excelDto.RENBV = wfAndReinCost.RENBV;
if (wfAndReinCost.LHINBV.HasValue)
{
excelDto.LHINBV = wfAndReinCost.LHINBV.Value;
}
if (wfAndReinCost.ESSDNBV.HasValue)
{
excelDto.ESSDNBV = wfAndReinCost.ESSDNBV.Value;
}
excelDto.RECost = wfAndReinCost.RECost;
excelDto.LHICost = wfAndReinCost.LHICost;
excelDto.ESSDCost = wfAndReinCost.ESSDCost;
excelDto.TotalWriteOff = wfAndReinCost.REWriteOff + wfAndReinCost.LHIWriteOff + wfAndReinCost.ESSDWriteOff;
excelDto.RentalStructure = !string.IsNullOrEmpty(finInput.RentalStructure) ? (Nullable <decimal>)decimal.Parse(finInput.RentalStructure) : null;
excelDto.ContributionMargin = finInput.ContributionMargin;
excelDto.SalesCompYr1 = finInput.SalesCompYr1;
excelDto.SalesCompYr2 = finInput.SalesCompYr2;
excelDto.SalesCompYr3 = finInput.SalesCompYr3;
excelDto.SalesCompYr4 = finInput.SalesCompYr4;
excelDto.SalesCompYr5 = finInput.SalesCompYr5;
excelDto.SalesCompYr6 = finInput.SalesCompYr6;
excelDto.SalesCompYr7 = finInput.SalesCompYr7;
excelDto.SalesCompYr8 = finInput.SalesCompYr8;
excelDto.SalesCompYr9 = finInput.SalesCompYr9;
excelDto.SalesCompYr10 = finInput.SalesCompYr10;
excelDto.SalesCompYr11 = finInput.SalesCompYr11;
excelDto.SalesCompYr12 = finInput.SalesCompYr12;
excelDto.SalesCompYr13 = finInput.SalesCompYr13;
excelDto.SalesCompYr14 = finInput.SalesCompYr14;
excelDto.SalesCompYr15 = finInput.SalesCompYr15;
excelDto.SalesCompYr16 = finInput.SalesCompYr16;
excelDto.SalesCompYr17 = finInput.SalesCompYr17;
excelDto.SalesCompYr18 = finInput.SalesCompYr18;
excelDto.SalesCompYr19 = finInput.SalesCompYr19;
excelDto.SalesCompYr20 = finInput.SalesCompYr20;
excelDto.ComSalesDesc = this.ComSalesDesc;
excelDto.CompSales = finInput.CompSalesAdjustment;
excelDto.FinanceYear = finInput.FinanceYear;
excelDto.FinanceMonth = finInput.FinanceMonth;
excelDirector.Input(excelDto);
return(fileName);
}
public override string Edit()
{
string url;
using (var tranScope = new TransactionScope())
{
var info = RenewalInfo.Get(this.ProjectId);
var tool = Duplicator.AutoCopy(this);
tool.Id = Guid.NewGuid();
tool.IsHistory = false;
tool.CreateTime = DateTime.Now;
tool.CreateUserAccount = ClientCookie.UserCode;
tool.Add();
NewEntityId = tool.Id;
IsHistory = true;
this.Update();
ProjectInfo.Reset(ProjectId, this.WorkflowCode);
var attachments = Attachment.GetList(this.TableName, Id.ToString(), string.Empty);
attachments.ForEach(att =>
{
att.RefTableID = tool.Id.ToString();
att.ID = Guid.NewGuid();
});
Attachment.Add(attachments.ToArray());
var FinMI = RenewalToolFinMeasureInput.Get(this.ProjectId, this.Id);
var newFinMI = Duplicator.AutoCopy(FinMI);
newFinMI.Id = Guid.NewGuid();
newFinMI.ToolId = tool.Id;
newFinMI.Add();
var WfRc = RenewalToolWriteOffAndReinCost.Get(this.ProjectId, this.Id);
var newWfRc = Duplicator.AutoCopy(WfRc);
newWfRc.Id = Guid.NewGuid();
newWfRc.ToolId = tool.Id;
newWfRc.Add();
var FinMO = RenewalToolFinMeasureOutput.GetByToolId(this.Id);
var newFinMO = Duplicator.AutoCopy(FinMO);
newFinMO.Id = Guid.NewGuid();
newFinMO.ToolId = tool.Id;
newFinMO.Add();
var package = RenewalPackage.Get(this.ProjectId);
package.ToolId = tool.Id;
package.Update();
var oldTasks = TaskWork.Search(t => t.RefID == ProjectId && t.Status == TaskWorkStatus.UnFinish && new string[] { this.WorkflowCode, FlowCode.Renewal_Analysis }.Contains(t.TypeCode)).ToList();
oldTasks.ForEach(t =>
{
t.Status = TaskWorkStatus.Cancel;
});
TaskWork.Update(oldTasks.ToArray());
var anlysisProj = ProjectInfo.FirstOrDefault(e => e.FlowCode == FlowCode.Renewal_Analysis &&
e.Status == ProjectStatus.UnFinish && e.ProjectId == ProjectId);
if (anlysisProj != null)
{
var taskAnlysis = TaskWork.FirstOrDefault(e => e.TypeCode == FlowCode.Renewal_Analysis && e.RefID == ProjectId && e.Status == TaskWorkStatus.UnFinish);
if (taskAnlysis != null)
{
taskAnlysis.Status = TaskWorkStatus.Finished;
taskAnlysis.FinishTime = DateTime.Now;
taskAnlysis.Update();
}
}
var task = info.GenerateSubmitTask(this.WorkflowCode);
url = task.Url;
tranScope.Complete();
}
return(url);
}
public static RenewalToolDTO InitPage(string projectId, string id = null)
{
RenewalToolDTO dto = new RenewalToolDTO();
var tool = RenewalTool.Get(projectId, id);
var project = ProjectInfo.Get(projectId, FlowCode.Renewal_Tool);
var info = RenewalInfo.Get(projectId);
var isFinance = ClientCookie.UserCode == info.FinanceAccount;
tool.IsProjectFreezed = tool.CheckIfFreezeProject(projectId);
var nextRefTableId = new Guid(FlowInfo.GetRefTableId("RenewalAnalysis", projectId));
var nextFlowStarted = ProjectInfo.IsFlowStarted(projectId, FlowCode.Renewal_Analysis);
var haveTask = TaskWork.Any(t => t.RefID == projectId && t.TypeCode == FlowCode.Renewal_Tool && t.Status == TaskWorkStatus.UnFinish && t.ReceiverAccount == ClientCookie.UserCode);
var projectComment = ProjectComment.GetSavedComment(tool.Id, "RenewalTool", ClientCookie.UserCode);
var projectNode = NodeInfo.GetNodeInfo(project.NodeCode);
var packageStarted = ProjectInfo.IsFlowStarted(projectId, FlowCode.Renewal_Package);
string selectedYearMonth = null;
dto.Info = info;
dto.Entity = tool;
dto.TTMDataYearMonths = RenewalToolFinMeasureInput.GetYearMonths(projectId, out selectedYearMonth);
dto.FinMeasureInput = RenewalToolFinMeasureInput.Get(projectId, dto.Entity.Id);
if (string.IsNullOrEmpty(dto.FinMeasureInput.FinanceYear) || string.IsNullOrEmpty(dto.FinMeasureInput.FinanceMonth))
{
var ym = selectedYearMonth.Split('-');
dto.FinMeasureInput.FinanceYear = ym[0];
dto.FinMeasureInput.FinanceMonth = ym[1];
}
dto.FinMeasureInput.FinanceDataYearMonth = dto.FinMeasureInput.FinanceYear + "-" + dto.FinMeasureInput.FinanceMonth;
//dto.FinMeasureInput.ContributionMargin = StoreCM.Get(dto.Info.USCode).ContributionMargin;
McdAMEntities amdb = new McdAMEntities();
var finfo = amdb.DataSync_LDW_AM_STFinanceData2.FirstOrDefault(f => f.UsCode == dto.Info.USCode &&
f.FinanceYear == dto.FinMeasureInput.FinanceYear && f.FinanceMonth == dto.FinMeasureInput.FinanceMonth);
decimal cm = 0;
if (finfo != null && !string.IsNullOrEmpty(finfo.contribution_marginPct))
{
cm = decimal.Parse(finfo.contribution_marginPct);
}
dto.FinMeasureInput.ContributionMargin = cm;
var coninfo = RenewalConsInfo.FirstOrDefault(e => e.ProjectId == projectId && !e.IsHistory);
var conProj = ProjectInfo.FirstOrDefault(e => e.ProjectId == projectId && e.FlowCode == "Renewal_ConsInfo");
dto.WriteOffAndReinCost = RenewalToolWriteOffAndReinCost.Get(projectId, dto.Entity.Id, projectNode);
if (coninfo != null && !coninfo.HasReinvenstment)
{
dto.WriteOffAndReinCost.REWriteOff = null;
dto.WriteOffAndReinCost.LHIWriteOff = null;
dto.WriteOffAndReinCost.ESSDWriteOff = null;
dto.WriteOffAndReinCost.ESSDWriteOff = null;
dto.WriteOffAndReinCost.RECost = null;
dto.WriteOffAndReinCost.LHICost = null;
dto.WriteOffAndReinCost.ESSDCost = null;
}
dto.Uploadable = projectNode.Sequence >= 3 && ClientCookie.UserCode == dto.Info.AssetActorAccount && !packageStarted;
dto.ProjectComment = projectComment != null ? projectComment.Content : "";
dto.Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_Tool);
dto.Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_Tool);
dto.Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_Tool) && string.IsNullOrEmpty(id);
dto.IsFinished =
ProjectInfo.Any(
e =>
e.ProjectId == projectId && e.FlowCode == FlowCode.Renewal_Tool &&
e.Status == ProjectStatus.Finished);
return(dto);
}
