public IHttpActionResult GetFinancialPreAnalysis(string projectId, string usCode, string pageType = "")
{
var financial = new FinancialPreanalysis();
var reimageSum = ReimageSummary.FirstOrDefault(e => e.ProjectId == projectId && e.IsHistory == false);
if (reimageSum != null)
{
financial = FinancialPreanalysis.FirstOrDefault(e => e.RefId == reimageSum.Id);
}
if (financial != null)
{
if (financial.Id != 0)
{
pageType = "save";
}
}
if (pageType == "")
{
//FinancialPreanalysis financial = reimageSummary.LoadFinancialPreanalysisInfo();
var enti = ReimageConsInfo.FirstOrDefault(e => e.ProjectId.Equals(projectId) && e.IsHistory == true);
if (enti == null)
{
enti = ReimageConsInfo.FirstOrDefault(e => e.ProjectId.Equals(projectId) && e.IsHistory == false);
}
WriteOffAmount writeOff = WriteOffAmount.FirstOrDefault(e => e.ConsInfoID == enti.Id);
if (financial == null)
{
financial = new FinancialPreanalysis();
}
if (writeOff != null)
{
financial.EstimatedWriteOffCost = writeOff.TotalII;
}
var ContributionMargin = StoreCM.Get(usCode).ContributionMargin.ToString();
var reimageConsInfo = ReimageConsInfo.GetConsInfo(projectId, "");
var reinvestmentBasicInfo = ReinvestmentBasicInfo.FirstOrDefault(e => e.ConsInfoID == reimageConsInfo.Id);
//ReinvestmentCost reinCost = ReinvestmentCost.FirstOrDefault(e => e.ConsInfoID == enti.Id);
financial.IsMcCafe = reinvestmentBasicInfo.NewMcCafe;
financial.IsKiosk = reinvestmentBasicInfo.NewKiosk;
financial.IsMDS = reinvestmentBasicInfo.NewMDS;
financial.IsTwientyFourHour = reinvestmentBasicInfo.NewTwientyFourHour;
financial.StoreCM = ContributionMargin;
}
return(Ok(financial));
}
public IHttpActionResult GetKeyMeasuresInfo(string projectId)
{
var reimage = ReimageConsInfo.GetConsInfo(projectId, "");
ReinvestmentCost reinCost = ReinvestmentCost.FirstOrDefault(e => e.ConsInfoID == reimage.Id);
var entity = ReimageSummary.FirstOrDefault(e => e.ProjectId.Equals(projectId) && e.IsHistory == false);
var financialPreanalysis = new FinancialPreanalysis();
if (entity != null)
{
financialPreanalysis = FinancialPreanalysis.FirstOrDefault(e => e.RefId.Equals(entity.Id));
}
if (reinCost != null)
{
financialPreanalysis.TotalReinvestmentNorm = reinCost.TotalReinvestmentNorm;
}
return(Ok(financialPreanalysis));
}
private string GenPrintReimageAttachment(ReimageInfo reimageInfo, ReimagePackage entity, PrintFileType fileType)
{
var storeInfo = StoreBasicInfo.GetStore(reimageInfo.USCode);
StoreBasicInfo store = storeInfo.StoreBasicInfo;
//生成Print文件
var printDic = new Dictionary <string, string>();
printDic.Add("WorkflowName", FlowCode.Reimage);
printDic.Add("ProjectID", entity.ProjectId);
printDic.Add("USCode", reimageInfo.USCode);
printDic.Add("Region", store.RegionENUS);
printDic.Add("Market", store.MarketENUS);
printDic.Add("City", store.CityENUS);
printDic.Add("AddressZHCN", store.AddressZHCN);
printDic.Add("OpenDate", store.OpenDate.ToString("yyyy-MM-dd"));
if (store.CloseDate.HasValue && store.CloseDate.Value.Year == 1900)
{
printDic.Add("ClosureDate", string.Empty);
}
else
{
printDic.Add("ClosureDate", store.CloseDate.HasValue ? (store.CloseDate.Value.ToString("yyyy-MM-dd")) : "");
}
printDic.Add("AssetsManager", storeInfo.StoreDevelop.AssetMgrName);
printDic.Add("AssetsRep", storeInfo.StoreDevelop.AssetRepName);
printDic.Add("StoreAge", (DateTime.Now.Year - store.OpenDate.Year).ToString());
var currentLeaseENDYear = storeInfo.CurrentYear - int.Parse(storeInfo.StoreContractInfo.EndYear);
printDic.Add("CurrentLeaseENDYear", currentLeaseENDYear.ToString());
printDic.Add("StoreNameEN", store.NameENUS);
printDic.Add("StoreNameCN", store.NameENUS);
var RmgSummaryentity = ReimageSummary.FirstOrDefault(e => e.ProjectId.Equals(entity.ProjectId) && e.IsHistory == false);
var financialPreanalysis = FinancialPreanalysis.FirstOrDefault(e => e.RefId.Equals(RmgSummaryentity.Id));
printDic.Add("SalesBuildingInvestment", financialPreanalysis.SalesBuildingInvestment);
printDic.Add("NoneSalesBuildingInvst", financialPreanalysis.NoneSalesBuildingInvst);
printDic.Add("TTMSales", financialPreanalysis.TTMSales.HasValue ? Math.Round(financialPreanalysis.TTMSales.Value, 2).ToString() : string.Empty);
var reimage = ReimageConsInfo.GetConsInfo(entity.ProjectId, "");
ReinvestmentCost reinCost = ReinvestmentCost.FirstOrDefault(e => e.ConsInfoID == reimage.Id);
printDic.Add("TotalReinvestmentNorm", reinCost.TotalReinvestmentNorm);
printDic.Add("TotalSalesInc", financialPreanalysis.TotalSalesInc);
printDic.Add("ROI", financialPreanalysis.ROI);
////printDic.Add("SalesInc", financialPreanalysis.ROI);
printDic.Add("PaybackYears", financialPreanalysis.PaybackYears);
printDic.Add("StoreCM", financialPreanalysis.StoreCM);
printDic.Add("EstimatedWriteOffCost", financialPreanalysis.EstimatedWriteOffCost);
printDic.Add("MarginInc", financialPreanalysis.MarginInc);
printDic.Add("ISDWIP", financialPreanalysis.ISDWIP);
printDic.Add("CurrStorePricingTier", financialPreanalysis.CurrentPriceTier);
printDic.Add("SPTAR", financialPreanalysis.SPTAR);
//Submission and Approval Records - 只显示通过意见
List <SubmissionApprovalRecord> recordList = new List <SubmissionApprovalRecord>();
//Submission and Approval Records Details — 所有意见
List <SubmissionApprovalRecord> recordDetailList = new List <SubmissionApprovalRecord>();
ProjectComment projectCommentBll = new ProjectComment();
ProjectCommentCondition condition = new ProjectCommentCondition();
var package = ReimagePackage.Get(entity.ProjectId);
condition.RefTableName = ReimagePackage.TableName;
condition.RefTableId = entity.Id;
condition.SourceCode = FlowCode.Reimage;
var commentList = VProjectComment.SearchVListForPDF(condition);
var commentDetailList = VProjectComment.SearchVList(condition);
SubmissionApprovalRecord record = null;
foreach (var item in commentList)
{
record = new SubmissionApprovalRecord();
record.ActionName = item.ActionDesc;
if (item.CreateTime != null)
{
record.OperationDate = item.CreateTime.Value;
}
record.OperatorID = item.UserAccount;
record.OperatorName = item.UserNameENUS;
record.OperatorTitle = item.PositionName;
record.Comments = item.Content;
recordList.Add(record);
}
foreach (var item in commentDetailList)
{
record = new SubmissionApprovalRecord();
record.ActionName = item.ActionDesc;
if (item.CreateTime != null)
{
record.OperationDate = item.CreateTime.Value;
}
record.OperatorID = item.UserAccount;
record.OperatorName = item.UserNameENUS;
record.OperatorTitle = item.PositionName;
record.Comments = item.Content;
recordDetailList.Add(record);
}
string result = string.Empty;
if (fileType == PrintFileType.Pdf)
{
result = HtmlConversionUtility.HtmlConvertToPDF(HtmlTempalteType.Reimage, printDic, recordList, recordDetailList);
}
else
{
result = HtmlConversionUtility.ConvertToImage(HtmlTempalteType.Reimage, printDic, recordList, recordDetailList);
}
return(result);
}
public IHttpActionResult GetStoreProfitabilityAndLeaseInfo(string projectId, string pageType = "")
{
StoreProfitabilityAndLeaseInfo store = new StoreProfitabilityAndLeaseInfo();
var reimageSummary = ReimageSummary.FirstOrDefault(e => e.ProjectId == projectId && e.IsHistory == false);
if (reimageSummary != null)
{
store =
StoreProfitabilityAndLeaseInfo.FirstOrDefault(e => e.RefId == reimageSummary.Id);
}
if (store != null)
{
if (store.Id != 0)
{
pageType = "save";
}
}
if (pageType == "")
{
//var resultStoreAllInfo = storeBll.GetStoreDetailsByEID(eid, usCode);
var reimageInfo = ReimageInfo.FirstOrDefault(e => e.ProjectId == projectId);
var storeBasicInfo = StoreBasicInfo.FirstOrDefault(e => e.StoreCode == reimageInfo.USCode);
var storeContractInfo = StoreContractInfo.FirstOrDefault(e => e.StoreCode == reimageInfo.USCode);
int Year = 0;
if (storeContractInfo != null)
{
if (storeContractInfo.EndDate != null)
{
DateTime dtNow = DateTime.Now;
Year = int.Parse(storeContractInfo.EndDate.ToString().Split('/')[2].Substring(0, 4)) - dtNow.Year;
}
}
//var stFinanceData =
// Mcdonalds.AM.DataAccess.DataSync_LDW_AM_STFinanceData.OrderByDescending(e => e.FinanceYear == DateTime.Now.Year.ToString(),
// e => e.FinanceMonth).FirstOrDefault();
//if (stFinanceData == null)
//{
// throw new Exception("Could not get the latest finance month data!");
//}
//var latestMonth = stFinanceData.FinanceMonth;
//var data = Mcdonalds.AM.DataAccess.DataSync_LDW_AM_STFinanceData.FirstOrDefault(e => e.FinanceYear == DateTime.Now.Year.ToString() && e.FinanceMonth == latestMonth && e.UsCode == stFinanceData.UsCode);
//store.AsOf =DateTime.Parse(DateTime.Now.Year + "/" + latestMonth + "/01");
//store.TTMSales = data.Total_Sales_TTM.As<decimal>();
//store.TTMSOIPercent = data.SOIPct_TTM.As<decimal>();
if (store == null)
{
store = new StoreProfitabilityAndLeaseInfo();
}
DateTime?dt = storeBasicInfo.ReImageDate;
if (dt != null)
{
if (dt.ToString().Substring(0, 8) == "1/1/1900")
{
dt = null;
}
}
store.LastRemodelDate = dt;
store.RemainingLeaseYears = Year;
}
return(Ok(store));
}
