public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B4"].Value = inputInfo.Region.AsString(); worksheet.Cells["B5"].Value = inputInfo.Market.AsString(); worksheet.Cells["B6"].Value = inputInfo.City.AsString(); worksheet.Cells["B7"].Value = inputInfo.USCode.AsString(); worksheet.Cells["B8"].Value = inputInfo.StoreNameEN.AsString(); worksheet.Cells["B9"].Value = inputInfo.StoreNameCN.AsString(); worksheet.Cells["B10"].Value = inputInfo.OpenDate; if (inputInfo.GBDate.HasValue) { worksheet.Cells["B11"].Value = inputInfo.GBDate.Value; } if (inputInfo.ConsCompletionDate.HasValue) { worksheet.Cells["B12"].Value = inputInfo.ConsCompletionDate.Value; } worksheet.Cells["B13"].Value = Dictionary.ParseDisplayName(inputInfo.NewDesignType); worksheet.Cells["B14"].Value = inputInfo.NormType.AsString(); worksheet.Cells["B15"].Value = inputInfo.EstimatedSeatNO.AsString(); worksheet.Cells["B16"].Value = inputInfo.NewDTSiteArea.AsString(); worksheet.Cells["B17"].Value = inputInfo.NewOperationArea.AsString(); worksheet.Cells["B18"].Value = inputInfo.NewDiningArea.AsString(); worksheet.Cells["B19"].Value = inputInfo.WallPanelArea.AsString(); worksheet.Cells["B20"].Value = inputInfo.WallGraphicArea.AsString(); worksheet.Cells["B21"].Value = inputInfo.FacadeACMArea.AsString(); worksheet.Cells["B22"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewRemoteKiosk); worksheet.Cells["B23"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewAttachedKiosk); worksheet.Cells["B24"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewMcCafe); worksheet.Cells["B25"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewMDS); }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.StoreNameEN; worksheet.Cells["B3"].Value = inputInfo.USCode; worksheet.Cells["B5"].Value = inputInfo.City; worksheet.Cells["B6"].Value = inputInfo.Market; worksheet.Cells["B7"].Value = inputInfo.ActualCloseDate; }
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.Market; worksheet.Cells["B3"].Value = inputInfo.USCode; worksheet.Cells["B4"].Value = inputInfo.StoreName; worksheet.Cells["B5"].Value = inputInfo.OpenDate; worksheet.Cells["B6"].Value = inputInfo.LeaseExpirationDate; worksheet.Cells["B7"].Value = inputInfo.RenewalYears; worksheet.Cells["B8"].Value = inputInfo.ProductSales; worksheet.Cells["B9"].Value = inputInfo.Pac; worksheet.Cells["B10"].Value = inputInfo.Rent; worksheet.Cells["B11"].Value = inputInfo.DepreciationLhi; worksheet.Cells["B12"].Value = inputInfo.InterestLhi; worksheet.Cells["B13"].Value = inputInfo.ServiceFee; worksheet.Cells["B14"].Value = inputInfo.Accounting; worksheet.Cells["B15"].Value = inputInfo.Insurance; worksheet.Cells["B16"].Value = inputInfo.TaxesAndLicenses; worksheet.Cells["B17"].Value = inputInfo.DepreciationEssd; worksheet.Cells["B18"].Value = inputInfo.InterestEssd; worksheet.Cells["B19"].Value = inputInfo.OtherIncExp; worksheet.Cells["B20"].Value = inputInfo.NonProductSales; worksheet.Cells["B21"].Value = inputInfo.NonProductCosts; worksheet.Cells["B22"].Value = inputInfo.REII; worksheet.Cells["B23"].Value = inputInfo.LHIII; worksheet.Cells["B24"].Value = inputInfo.ESSDII; worksheet.Cells["B25"].Value = inputInfo.RENBV; worksheet.Cells["B26"].Value = inputInfo.LHINBV; worksheet.Cells["B27"].Value = inputInfo.ESSDNBV; worksheet.Cells["B28"].Value = inputInfo.RECost; worksheet.Cells["B29"].Value = inputInfo.LHICost; worksheet.Cells["B30"].Value = inputInfo.ESSDCost; worksheet.Cells["B31"].Value = inputInfo.TotalWriteOff; worksheet.Cells["B32"].Value = inputInfo.RentalStructure; worksheet.Cells["B33"].Value = inputInfo.ContributionMargin; worksheet.Cells["B34"].Value = inputInfo.SalesCompYr1; worksheet.Cells["B35"].Value = inputInfo.SalesCompYr2; worksheet.Cells["B36"].Value = inputInfo.SalesCompYr3; worksheet.Cells["B37"].Value = inputInfo.SalesCompYr4; worksheet.Cells["B38"].Value = inputInfo.SalesCompYr5; worksheet.Cells["B39"].Value = inputInfo.SalesCompYr6; worksheet.Cells["B40"].Value = inputInfo.SalesCompYr7; worksheet.Cells["B41"].Value = inputInfo.SalesCompYr8; worksheet.Cells["B42"].Value = inputInfo.SalesCompYr9; worksheet.Cells["B43"].Value = inputInfo.SalesCompYr10; worksheet.Cells["B44"].Value = inputInfo.SalesCompYr11; worksheet.Cells["B45"].Value = inputInfo.SalesCompYr12; worksheet.Cells["B46"].Value = inputInfo.SalesCompYr13; worksheet.Cells["B47"].Value = inputInfo.SalesCompYr14; worksheet.Cells["B48"].Value = inputInfo.SalesCompYr15; worksheet.Cells["B49"].Value = inputInfo.SalesCompYr16; worksheet.Cells["B50"].Value = inputInfo.SalesCompYr17; worksheet.Cells["B51"].Value = inputInfo.SalesCompYr18; worksheet.Cells["B52"].Value = inputInfo.SalesCompYr19; worksheet.Cells["B53"].Value = inputInfo.SalesCompYr20; worksheet.Cells["B54"].Value = inputInfo.ComSalesDesc; worksheet.Cells["B55"].Value = inputInfo.CompSales; worksheet.Cells["B56"].Value = inputInfo.FinanceYear + "-" + inputInfo.FinanceMonth; }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.Region; worksheet.Cells["B3"].Value = inputInfo.Province; worksheet.Cells["B4"].Value = inputInfo.City; worksheet.Cells["B5"].Value = inputInfo.StoreName; worksheet.Cells["B6"].Value = inputInfo.USCode; worksheet.Cells["B7"].Value = inputInfo.OpenDate.ToString("yyyy-MM-dd"); }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.Region; worksheet.Cells["B3"].Value = inputInfo.Market; worksheet.Cells["B4"].Value = inputInfo.StoreName; worksheet.Cells["B5"].Value = inputInfo.USCode; worksheet.Cells["B6"].Value = inputInfo.StoreTypeName; worksheet.Cells["B7"].Value = inputInfo.ActualCloseDate; worksheet.Cells["B8"].Value = inputInfo.PMNameENUS; }
public void Input(ExcelInputDTO excelInput) { using (var excelPackage = new ExcelPackage(_excelData.FileInfo)) { var worksheet = excelPackage.Workbook.Worksheets[_excelData.SheetName]; _excelData.Input(worksheet, excelInput); excelPackage.Save(); } }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["A" + RowNum].Value = inputInfo.Form.AsString(); worksheet.Cells["B" + RowNum].Value = inputInfo.Comments.AsString(); worksheet.Cells["C" + RowNum].Value = inputInfo.CreateBy.AsString(); worksheet.Cells["D" + RowNum].Value = inputInfo.SendTo.AsString(); worksheet.Cells["E" + RowNum].Value = inputInfo.CreateDate.AsString(); worksheet.Cells["F" + RowNum].Value = inputInfo.SenderPosition.AsString(); worksheet.Cells["G" + RowNum].Value = inputInfo.IsRead.AsString(); RowNum++; }
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.Region; worksheet.Cells["B3"].Value = inputInfo.Province; worksheet.Cells["B4"].Value = inputInfo.City; worksheet.Cells["B5"].Value = inputInfo.Market; worksheet.Cells["B6"].Value = inputInfo.StoreName; worksheet.Cells["B7"].Value = inputInfo.USCode; worksheet.Cells["B8"].Value = inputInfo.OpenDate.ToString("yyyy-MM-dd"); worksheet.Cells["B9"].Value = inputInfo.LeaseExpirationDate.ToString("yyyy-MM-dd"); worksheet.Cells["B10"].Value = inputInfo.Priority; }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.Region.AsString(); worksheet.Cells["B3"].Value = inputInfo.Province.AsString(); worksheet.Cells["B4"].Value = inputInfo.City.AsString(); worksheet.Cells["B5"].Value = inputInfo.Market.AsString(); worksheet.Cells["B6"].Value = inputInfo.StoreName.AsString(); worksheet.Cells["B7"].Value = inputInfo.USCode.AsString(); worksheet.Cells["B8"].Value = inputInfo.OpenDate; //worksheet.Cells["B9"].Value = inputInfo.Region.AsString(); //worksheet.Cells["B10"].Value = inputInfo.Region.AsString(); //worksheet.Cells["B11"].Value = inputInfo.Region.AsString(); }
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { string strRow = (3 + RowNumber).ToString(); worksheet.Cells["A" + strRow].Value = (RowNumber + 1).ToString(); worksheet.Cells["B" + strRow].Value = inputInfo.McdParticipants; worksheet.Cells["C" + strRow].Value = inputInfo.Content; worksheet.Cells["D" + strRow].Value = inputInfo.LLParticipants; worksheet.Cells["E" + strRow].Value = inputInfo.Topic; worksheet.Cells["F" + strRow].Value = inputInfo.Location; worksheet.Cells["G" + strRow].Value = inputInfo.MeetingDate; worksheet.Cells["H" + strRow].Value = inputInfo.CreateDate; RowNumber += 1; }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.Region; worksheet.Cells["B3"].Value = inputInfo.Market; worksheet.Cells["B4"].Value = inputInfo.StoreName; worksheet.Cells["B5"].Value = inputInfo.USCode; worksheet.Cells["B6"].Value = inputInfo.StoreTypeName; if (inputInfo.ClosureDate != null && inputInfo.ClosureDate != default(DateTime)) { worksheet.Cells["B7"].Value = inputInfo.ClosureDate; } worksheet.Cells["B8"].Value = inputInfo.PMNameENUS; }
public virtual void Edit(ExcelWorksheet worksheet, ExcelInputDTO excelInput) { }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { var projectInfo = ProjectInfo.FirstOrDefault(e => e.ProjectId == inputInfo.ProjectId); if (projectInfo == null) { throw new Exception("Cannot find the project info!"); } var store = StoreBasicInfo.Search(e => e.StoreCode == projectInfo.USCode).FirstOrDefault(); if (store == null) { throw new Exception("Cannot find Store info!"); } var reimageSummary = BaseWFEntity.GetWorkflowEntity(inputInfo.ProjectId, FlowCode.Reimage_Summary) as ReimageSummary; if (reimageSummary == null) { throw new Exception("Cannot find Reimage Summary Info!"); } var storeSTLocation = StoreSTLocation.GetStoreSTLocation(projectInfo.USCode); var storeLeaseInfo = new StoreProfitabilityAndLeaseInfo(); var reimageConsInfo = ReimageConsInfo.GetConsInfo(inputInfo.ProjectId); var reinvestment = ReinvestmentBasicInfo.FirstOrDefault(e => e.ConsInfoID == reimageConsInfo.Id); if (reimageSummary != null) { storeLeaseInfo = StoreProfitabilityAndLeaseInfo.FirstOrDefault(e => e.RefId == reimageSummary.Id); if (storeLeaseInfo != null) { if (storeLeaseInfo.LastRemodelDate.HasValue && storeLeaseInfo.LastRemodelDate.Value.ToString("yyyy-MM-dd") != "1900-01-01") { worksheet.Cells["B43"].Value = storeLeaseInfo.LastRemodelDate; } worksheet.Cells["B44"].Value = storeLeaseInfo.RemainingLeaseYears; worksheet.Cells["B46"].Value = storeLeaseInfo.TTMSOIPercent / 100; worksheet.Cells["B47"].Value = storeLeaseInfo.AsOf; worksheet.Cells["B48"].Value = reimageSummary.OperationRequirements; var financial = FinancialPreanalysis.FirstOrDefault(e => e.RefId == reimageSummary.Id); worksheet.Cells["B49"].Value = TryParseDecimal(financial.TotalSalesInc); worksheet.Cells["B45"].Value = financial.TTMSales; worksheet.Cells["B50"].Value = TryParseDecimal(financial.StoreCM) * 100 + "%"; worksheet.Cells["B51"].Value = financial.CurrentPriceTier; worksheet.Cells["B52"].Value = string.IsNullOrEmpty(financial.SPTAR) ? 0 : financial.SPTAR.As <decimal>(); worksheet.Cells["B53"].Value = financial.PriceTierafterReimage; } //worksheet.Cells["E4"].Value = financial.MarginInc; } else { var reimageInfo = ReimageInfo.FirstOrDefault(e => e.ProjectId == inputInfo.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; } } DateTime?dt = storeBasicInfo.ReImageDate; if (dt != null) { if (dt.ToString().Substring(0, 8) == "1/1/1900") { dt = null; } } worksheet.Cells["B43"].Value = dt; worksheet.Cells["B44"].Value = Year; //storeLeaseInfo.LastRemodelDate = dt; //storeLeaseInfo.RemainingLeaseYears = Year; } ReinvestmentCost cost = ReinvestmentCost.FirstOrDefault(e => e.ConsInfoID == reimageConsInfo.Id); worksheet.Cells["B2"].Value = store.Region; worksheet.Cells["B3"].Value = store.StoreCode; if (reinvestment != null) { worksheet.Cells["B8"].Value = TryParseDecimal(reinvestment.RightSizingSeatNo); worksheet.Cells["B11"].Value = TryParseDecimal(reinvestment.EstimatedSeatNo); worksheet.Cells["B41"].Value = reinvestment.GBDate; worksheet.Cells["B42"].Value = reinvestment.ConsCompletionDate; } if (cost != null) { worksheet.Cells["B13"].Value = TryParseDecimal(cost.DesignFee); worksheet.Cells["B14"].Value = TryParseDecimal(cost.PublicBudget); worksheet.Cells["B15"].Value = TryParseDecimal(cost.BuildingFacade); worksheet.Cells["B16"].Value = TryParseDecimal(cost.SiteBudget); worksheet.Cells["B17"].Value = TryParseDecimal(cost.BuildingWork); worksheet.Cells["B18"].Value = TryParseDecimal(cost.PlumbingSystem); worksheet.Cells["B19"].Value = TryParseDecimal(cost.ElectricalSystem); worksheet.Cells["B20"].Value = TryParseDecimal(cost.HVACDuctSystem); worksheet.Cells["B21"].Value = TryParseDecimal(cost.Signage); worksheet.Cells["B22"].Value = TryParseDecimal(cost.Seating); worksheet.Cells["B23"].Value = TryParseDecimal(cost.Decor); worksheet.Cells["B24"].Value = TryParseDecimal(cost.Kiosk); worksheet.Cells["B25"].Value = TryParseDecimal(cost.McCafe); worksheet.Cells["B26"].Value = TryParseDecimal(cost.MDS); worksheet.Cells["B27"].Value = TryParseDecimal(cost.Playland); worksheet.Cells["B28"].Value = TryParseDecimal(cost.KitchenCapacityUpgrade); worksheet.Cells["B29"].Value = TryParseDecimal(cost.BuildingWorks); worksheet.Cells["B30"].Value = TryParseDecimal(cost.KitchenEquipment); worksheet.Cells["B31"].Value = TryParseDecimal(cost.HVAC); worksheet.Cells["B32"].Value = TryParseDecimal(cost.Plumbing); worksheet.Cells["B33"].Value = TryParseDecimal(cost.ElectricDistribution); worksheet.Cells["B34"].Value = TryParseDecimal(cost.Structure); worksheet.Cells["B35"].Value = TryParseDecimal(cost.Others); worksheet.Cells["B36"].Value = TryParseDecimal(cost.LHIPMAct); worksheet.Cells["B37"].Value = TryParseDecimal(cost.SignagePMAct); worksheet.Cells["B38"].Value = TryParseDecimal(cost.EquipmentPMAct); worksheet.Cells["B39"].Value = TryParseDecimal(cost.SeatingPackagePMAct); worksheet.Cells["B40"].Value = TryParseDecimal(cost.DecorPMAct); } worksheet.Cells["B5"].Value = storeSTLocation.TotalArea.As <decimal>(); worksheet.Cells["B6"].Value = store.ProvinceZHCN; worksheet.Cells["B7"].Value = store.NameZHCN; worksheet.Cells["B4"].Value = TryParseDecimal(storeSTLocation.TotalSeatsNo); worksheet.Cells["B9"].Value = TryParseDecimal(storeSTLocation.KitchenArea); worksheet.Cells["B10"].Value = store.CityZHCN; if (!string.IsNullOrEmpty(storeSTLocation.DesignStyle)) { var dict = Dictionary.FirstOrDefault(i => i.Code == storeSTLocation.DesignStyle); if (dict != null) { worksheet.Cells["B12"].Value = dict.NameZHCN; } else { worksheet.Cells["B12"].Value = storeSTLocation.DesignStyle; } } //worksheet.Cells["B24"].Value = reimageSummary.ReinvestmentBasicInfo.NewKiosk; //worksheet.Cells["B25"].Value = reimageSummary.ReinvestmentBasicInfo.NewMcCafe; //worksheet.Cells["B26"].Value = reimageSummary.ReinvestmentBasicInfo.NewMDS; //worksheet.Cells["B41"].Value = reimageSummary.ReinvestmentBasicInfo.GBDate; //worksheet.Cells["B42"].Value = reimageSummary.ReinvestmentBasicInfo.ConsCompletionDate; worksheet.Cells["B10"].Value = store.CityZHCN; //worksheet.Cells["B11"].Value = inputInfo.StoreType; //worksheet.Cells["B12"].Value = inputInfo.StoreType; //worksheet.Cells["B13"].Value = inputInfo.StoreType; //worksheet.Cells["B14"].Value = inputInfo.StoreType; //worksheet.Cells["B15"].Value = inputInfo.StoreType; //worksheet.Cells["B16"].Value = inputInfo.StoreType; //worksheet.Cells["B17"].Value = inputInfo.StoreType; //worksheet.Cells["B18"].Value = inputInfo.StoreType; //worksheet.Cells["B19"].Value = inputInfo.StoreType; //worksheet.Cells["B20"].Value = inputInfo.StoreType; //worksheet.Cells["B21"].Value = inputInfo.StoreType; //worksheet.Cells["B22"].Value = inputInfo.StoreType; //worksheet.Cells["B23"].Value = inputInfo.StoreType; //worksheet.Cells["B27"].Value = inputInfo.StoreType; //worksheet.Cells["B28"].Value = inputInfo.StoreType; //worksheet.Cells["B29"].Value = inputInfo.StoreType; //worksheet.Cells["B30"].Value = inputInfo.StoreType; //worksheet.Cells["B31"].Value = inputInfo.StoreType; //worksheet.Cells["B32"].Value = inputInfo.StoreType; //worksheet.Cells["B33"].Value = inputInfo.StoreType; //worksheet.Cells["B34"].Value = inputInfo.StoreType; //worksheet.Cells["B35"].Value = inputInfo.StoreType; //worksheet.Cells["B36"].Value = inputInfo.StoreType; //worksheet.Cells["B37"].Value = inputInfo.StoreType; //worksheet.Cells["B38"].Value = inputInfo.StoreType; //worksheet.Cells["B39"].Value = inputInfo.StoreType; //worksheet.Cells["B40"].Value = inputInfo.StoreType; //if (reimageSummary.StoreProfitabilityAndLeaseInfo != null) //{ // worksheet.Cells["B43"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.LastRemodelDate; // worksheet.Cells["B44"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.RemainingLeaseYears; // worksheet.Cells["B45"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.TTMSales; // worksheet.Cells["B46"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.TTMSOIPercent; // worksheet.Cells["B47"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.AsOf; //} ////worksheet.Cells["B48"].Value = reimageSummary.OperationRequirements; //if (reimageSummary.FinancialPreanalysis != null) //{ // worksheet.Cells["B49"].Value = reimageSummary.FinancialPreanalysis.TotalSalesInc; // worksheet.Cells["B50"].Value = reimageSummary.FinancialPreanalysis.StoreCM; // worksheet.Cells["B51"].Value = reimageSummary.FinancialPreanalysis.CurrentPriceTier; // worksheet.Cells["B52"].Value = reimageSummary.FinancialPreanalysis.ISDWIP; // worksheet.Cells["B53"].Value = reimageSummary.FinancialPreanalysis.SPTAR; //} }
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.StoreNameCN.AsString(); worksheet.Cells["B3"].Value = inputInfo.USCode.AsString(); worksheet.Cells["B4"].Value = inputInfo.City.AsString(); worksheet.Cells["B5"].Value = inputInfo.Market.AsString(); worksheet.Cells["B6"].Value = inputInfo.OpenDate; worksheet.Cells["B7"].Value = inputInfo.Floor.AsString(); worksheet.Cells["B8"].Value = inputInfo.TotalArea.AsString(); worksheet.Cells["B9"].Value = inputInfo.TotalSeatsNo.AsString(); worksheet.Cells["B10"].Value = inputInfo.BE; worksheet.Cells["B11"].Value = inputInfo.LeasingTerm; worksheet.Cells["B12"].Value = inputInfo.RentCommencementDate; worksheet.Cells["B13"].Value = inputInfo.LeaseExpirationDate; worksheet.Cells["B14"].Value = inputInfo.RentType; worksheet.Cells["B15"].Value = inputInfo.RentStructure; worksheet.Cells["B16"].Value = TryParseDecimal(inputInfo.TotalSales_TTM); worksheet.Cells["B17"].Value = TryParseDecimal(inputInfo.SalesComp_TTM); worksheet.Cells["B18"].Value = TryParseDecimal(inputInfo.GCComp_TTM); worksheet.Cells["B19"].Value = TryParseDecimal(inputInfo.PAC_TTM); worksheet.Cells["B20"].Value = TryParseDecimal(inputInfo.SOI_TTM); worksheet.Cells["B21"].Value = TryParseDecimal(inputInfo.CASHFLOW_TTM); worksheet.Cells["B22"].Value = TryParseDecimal(inputInfo.TotalSales_TTMY1); worksheet.Cells["B23"].Value = TryParseDecimal(inputInfo.CompSales_TTMY1); worksheet.Cells["B24"].Value = TryParseDecimal(inputInfo.CompGC_TTMY1); worksheet.Cells["B25"].Value = TryParseDecimal(inputInfo.PAC_TTMY1); worksheet.Cells["B26"].Value = TryParseDecimal(inputInfo.SOI_TTMY1); worksheet.Cells["B27"].Value = TryParseDecimal(inputInfo.CashFlow_TTMY1); worksheet.Cells["B28"].Value = TryParseDecimal(inputInfo.TotalSales_TTMY2); worksheet.Cells["B29"].Value = TryParseDecimal(inputInfo.CompSales_TTMY2); worksheet.Cells["B30"].Value = TryParseDecimal(inputInfo.CompGC_TTMY2); worksheet.Cells["B31"].Value = TryParseDecimal(inputInfo.PAC_TTMY2); worksheet.Cells["B32"].Value = TryParseDecimal(inputInfo.SOI_TTMY2); worksheet.Cells["B33"].Value = TryParseDecimal(inputInfo.CashFlow_TTMY2); worksheet.Cells["B34"].Value = inputInfo.RemoteKiosk1_Status.AsString(); worksheet.Cells["B35"].Value = inputInfo.RemoteKiosk2_Status.AsString(); worksheet.Cells["B36"].Value = inputInfo.RemoteKiosk3_Status.AsString(); worksheet.Cells["B37"].Value = inputInfo.AttachedKiosk1_Status.AsString(); worksheet.Cells["B38"].Value = inputInfo.AttachedKiosk2_Status.AsString(); worksheet.Cells["B39"].Value = inputInfo.AttachedKiosk3_Status.AsString(); worksheet.Cells["B40"].Value = inputInfo.MDS_Status.AsString(); worksheet.Cells["B41"].Value = inputInfo.McCafe_Status.AsString(); worksheet.Cells["B42"].Value = inputInfo.TwentyFourHour_Status.AsString(); worksheet.Cells["B43"].Value = inputInfo.RemoteKiosk1_OpenDate; worksheet.Cells["B44"].Value = inputInfo.RemoteKiosk2_OpenDate; worksheet.Cells["B45"].Value = inputInfo.RemoteKiosk3_OpenDate; worksheet.Cells["B46"].Value = inputInfo.AttachedKiosk1_OpenDate; worksheet.Cells["B47"].Value = inputInfo.AttachedKiosk2_OpenDate; worksheet.Cells["B48"].Value = inputInfo.AttachedKiosk3_OpenDate; worksheet.Cells["B49"].Value = inputInfo.MDS_OpenDate; worksheet.Cells["B50"].Value = inputInfo.McCafe_OpenDate; worksheet.Cells["B51"].Value = inputInfo.TwentyFourHour_OpenDate; worksheet.Cells["B52"].Value = TryParseDecimal(inputInfo.LHI_NBV); worksheet.Cells["B53"].Value = TryParseDecimal(inputInfo.ESSD_NBV); worksheet.Cells["B54"].Value = TryParseDecimal(inputInfo.TotalCost_NBV); worksheet.Cells["B55"].Value = inputInfo.CurrentSituation.AsString(); worksheet.Cells["B56"].Value = inputInfo.NegotiationHistory.AsString(); worksheet.Cells["B57"].Value = inputInfo.ProposedSolution.AsString(); worksheet.Cells["B58"].Value = inputInfo.SalesTransfer.AsString(); worksheet.Cells["B59"].Value = inputInfo.MiniMarket.AsString(); worksheet.Cells["B60"].Value = inputInfo.StoreLocation.AsString(); }
public override void Edit(ExcelWorksheet worksheet, ExcelInputDTO excelInput) { worksheet.Cells["B54"].Value = excelInput.ComSalesDesc; }
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { worksheet.Cells["B2"].Value = inputInfo.USCode; worksheet.Cells["B3"].Value = inputInfo.StoreNameEN; worksheet.Cells["B4"].Value = inputInfo.StoreNameCN; worksheet.Cells["B5"].Value = worksheet.Cells["B12"].Value = inputInfo.MinimarketPriority; worksheet.Cells["B6"].Value = inputInfo.TADesrability; worksheet.Cells["B7"].Value = inputInfo.MMTADescription; worksheet.Cells["B8"].Value = inputInfo.MajorGenerators; worksheet.Cells["B9"].Value = worksheet.Cells["B16"].Value = inputInfo.SitePortfolioType; worksheet.Cells["B10"].Value = inputInfo.SiteRerating; worksheet.Cells["B11"].Value = worksheet.Cells["B18"].Value = inputInfo.SiteDescription; worksheet.Cells["B13"].Value = inputInfo.TADesrabilityNew; worksheet.Cells["B14"].Value = inputInfo.MMTADescriptionNew; worksheet.Cells["B15"].Value = inputInfo.MajorGeneratorsNew; worksheet.Cells["B17"].Value = inputInfo.SiteRERatingFuture; worksheet.Cells["B19"].Value = inputInfo.LeasedArea; worksheet.Cells["B20"].Value = inputInfo.OperationSize; worksheet.Cells["B21"].Value = inputInfo.Floors; worksheet.Cells["B22"].Value = inputInfo.Seats; worksheet.Cells["B23"].Value = inputInfo.BEType; worksheet.Cells["B24"].Value = inputInfo.LeaseTenureAndTerm; worksheet.Cells["B25"].Value = inputInfo.FreeRentalPeriod; worksheet.Cells["B26"].Value = inputInfo.RentStructure; worksheet.Cells["B27"].Value = inputInfo.MFStructure; worksheet.Cells["B28"].Value = inputInfo.LeasedAreaNew; worksheet.Cells["B29"].Value = inputInfo.OperationSizeNew; worksheet.Cells["B30"].Value = inputInfo.FloorsNew; worksheet.Cells["B31"].Value = inputInfo.SeatsNew; worksheet.Cells["B32"].Value = inputInfo.BETypeNew; worksheet.Cells["B33"].Value = inputInfo.LeaseTenureAndTermNew; worksheet.Cells["B34"].Value = inputInfo.FreeRentalPeriodNew; worksheet.Cells["B35"].Value = inputInfo.RentStructureNew; worksheet.Cells["B36"].Value = inputInfo.MFStructureNew; worksheet.Cells["B37"].Value = inputInfo.DRMFLastTY; worksheet.Cells["B38"].Value = inputInfo.DRMFLastTYSales; worksheet.Cells["B39"].Value = inputInfo.DRMF1stTY; worksheet.Cells["B40"].Value = inputInfo.DRMF1stTYSales; worksheet.Cells["B41"].Value = inputInfo.SRMFLastTY; worksheet.Cells["B42"].Value = inputInfo.SRMFLastTYSales; worksheet.Cells["B43"].Value = inputInfo.SRMF1stTY; worksheet.Cells["B44"].Value = inputInfo.SRMF1stTYSales; worksheet.Cells["B45"].Value = inputInfo.FairMarketRentAmount; worksheet.Cells["B46"].Value = inputInfo.FairMarketRentAgent; worksheet.Cells["B47"].Value = inputInfo.DR1stTYAmount; worksheet.Cells["B48"].Value = inputInfo.AnnualSOILastTY; worksheet.Cells["B49"].Value = inputInfo.AnnualSOIAvg; worksheet.Cells["B50"].Value = inputInfo.CashROILastTY; worksheet.Cells["B51"].Value = inputInfo.CashROIAvg; worksheet.Cells["B52"].Value = inputInfo.LastRemodeling; worksheet.Cells["B53"].Value = inputInfo.OriginalInvestment; worksheet.Cells["B54"].Value = inputInfo.NBV; worksheet.Cells["B55"].Value = inputInfo.AdditionalInvestmentCost; worksheet.Cells["B56"].Value = inputInfo.ExclusivityClause; worksheet.Cells["B57"].Value = inputInfo.McDsEarlyTerminationRight; worksheet.Cells["B58"].Value = inputInfo.McDsEPRight; worksheet.Cells["B59"].Value = inputInfo.LandlordEntity; worksheet.Cells["B60"].Value = inputInfo.SpecialClauses; worksheet.Cells["B61"].Value = inputInfo.OtherIssues; worksheet.Cells["B62"].Value = inputInfo.ExclusivityClauseNew; worksheet.Cells["B63"].Value = inputInfo.McDsEarlyTerminationRightNew; worksheet.Cells["B64"].Value = inputInfo.McDsEPRightNew; worksheet.Cells["B65"].Value = inputInfo.LandlordEntityNew; worksheet.Cells["B66"].Value = inputInfo.SpecialClausesNew; worksheet.Cells["B67"].Value = inputInfo.OtherIssuesNew; worksheet.Cells["B68"].Value = inputInfo.DecisionLogic; worksheet.Cells["B69"].Value = inputInfo.SpecialApprovalRequired; }
public abstract void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo);
//private string GetCellValue(decimal? val) //{ // string result = string.Empty; // if (val.HasValue) // { // result = val.Value.ToString("f2"); // } // return result; //} public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo) { var closureInfo = ClosureInfo.GetByProjectId(inputInfo.ProjectId); var storeInfo = StoreBasicInfo.FirstOrDefault(s => s.StoreCode == closureInfo.USCode); var storeContract = StoreContractInfo.Get(storeInfo.StoreCode); ClosureTool closureTool = ClosureTool.Get(inputInfo.ProjectId); //ClosureWOCheckList closureWoCheckList = ClosureWOCheckList.Get(inputInfo.ProjectId); worksheet.Cells["B2"].Value = storeInfo.Market; worksheet.Cells["B3"].Value = storeInfo.StoreCode; worksheet.Cells["B4"].Value = storeInfo.NameZHCN; worksheet.Cells["B5"].Value = storeInfo.OpenDate.ToString("yyyy-MM-dd"); if (storeContract != null) { worksheet.Cells["B6"].Value = storeContract.PartyAFullName; worksheet.Cells["B7"].Value = storeContract.EndDate.HasValue ? storeContract.EndDate.Value.ToString("yyyy-MM-dd") : ""; } worksheet.Cells["B8"].Value = closureInfo.ClosureTypeNameZHCN; if (closureInfo.ActualCloseDate != null) { worksheet.Cells["B9"].Value = closureInfo.ActualCloseDate.Value.ToString("yyyy-MM-dd"); } worksheet.Cells["B10"].Value = closureTool.Product_Sales_RMB_Adjustment; worksheet.Cells["B11"].Value = closureTool.PAC_RMB_Adjustment; worksheet.Cells["B12"].Value = closureTool.Rent_RMB_Adjustment; worksheet.Cells["B13"].Value = closureTool.DepreciationLHI_RMB_Adjustment; worksheet.Cells["B14"].Value = closureTool.InterestLHI_RMB_Adjustment; //INTEREST LHI // worksheet.Cells[15, 2].Value = closureTool..ToString(); worksheet.Cells["B15"].Value = closureTool.ServiceFee_RMB_Adjustment; worksheet.Cells["B16"].Value = closureTool.Accounting_RMB_Adjustment; worksheet.Cells["B17"].Value = closureTool.Accounting_RMB_Adjustment; worksheet.Cells["B18"].Value = closureTool.TaxesLicenses_RMB_Adjustment; worksheet.Cells["B19"].Value = closureTool.Depreciation_ESSD_RMB_Adjustment; worksheet.Cells["B20"].Value = closureTool.Interest_ESSD_RMB_Adjustment; worksheet.Cells["B21"].Value = closureTool.OtherIncExp_RMB_Adjustment; worksheet.Cells["B22"].Value = closureTool.NonProduct_Sales_RMB_Adjustment; worksheet.Cells["B23"].Value = closureTool.NonProduct_Costs_RMB_Adjustment; worksheet.Cells["B24"].Value = closureTool.CompSalesMacket_Adjustment; worksheet.Cells["B25"].Value = closureTool.CompCG_Adjustment; worksheet.Cells["B26"].Value = closureTool.CompCGMacket_Adjustment; worksheet.Cells["B27"].Value = closureTool.PACMarket_Adjustment; worksheet.Cells["B28"].Value = closureTool.SOIMarket_Adjustment; worksheet.Cells["B29"].Value = closureTool.TotalSales_TTMY1; worksheet.Cells["B30"].Value = closureTool.CompSales_TTMY1; worksheet.Cells["B31"].Value = closureTool.CompSales_Market_TTMY1; worksheet.Cells["B32"].Value = closureTool.CompGC_TTMY1; worksheet.Cells["B33"].Value = closureTool.CompGCMarket_TTMY1; worksheet.Cells["B34"].Value = closureTool.PAC_TTMY1; worksheet.Cells["B35"].Value = closureTool.PACMarket_TTMY1; worksheet.Cells["B36"].Value = closureTool.SOI_TTMY1; worksheet.Cells["B37"].Value = closureTool.SOIMarket_TTMY1; worksheet.Cells["B38"].Value = closureTool.CashFlow_TTMY1; worksheet.Cells["B39"].Value = closureTool.TotalSales_TTMY2; //sheet.Cells[36, 2].Value = closureTool.cashflow.ToString(); worksheet.Cells["B40"].Value = closureTool.CompSales_TTMY2; worksheet.Cells["B41"].Value = closureTool.CompSales_Market_TTMY2; worksheet.Cells["B42"].Value = closureTool.CompGC_TTMY2; worksheet.Cells["B43"].Value = closureTool.CompGCMarket_TTMY2; worksheet.Cells["B44"].Value = closureTool.PAC_TTMY2; worksheet.Cells["B45"].Value = closureTool.PACMarket_TTMY2; worksheet.Cells["B46"].Value = closureTool.SOI_TTMY2; worksheet.Cells["B47"].Value = closureTool.SOIMarket_TTMY2; worksheet.Cells["B48"].Value = closureTool.CashFlow_TTMY2; worksheet.Cells["B49"].Value = DateTime.Now.Year + " July"; var woEntity = ClosureWOCheckList.Get(closureTool.ProjectId); if (woEntity != null) { worksheet.Cells["B50"].Value = woEntity.RE_Original; worksheet.Cells["B51"].Value = woEntity.LHI_Original; worksheet.Cells["B52"].Value = woEntity.ESSD_Original; worksheet.Cells["B53"].Value = woEntity.RE_NBV; worksheet.Cells["B54"].Value = woEntity.LHI_NBV; worksheet.Cells["B55"].Value = woEntity.ESSD_NBV; worksheet.Cells["B56"].Value = woEntity.EquipmentTransfer; worksheet.Cells["B57"].Value = woEntity.ClosingCost; } var list = ClosureToolImpactOtherStore.Search(e => e.ClosureId == closureTool.Id).AsNoTracking().ToList(); if (list.Count > 0) { worksheet.Cells["B58"].Value = list[0].StoreCode; worksheet.Cells["B59"].Value = list[0].NameZHCN; worksheet.Cells["B60"].Value = list[0].ImpactSaltes; } if (list.Count > 1) { worksheet.Cells["B61"].Value = list[1].StoreCode; worksheet.Cells["B62"].Value = list[1].NameZHCN; worksheet.Cells["B63"].Value = list[1].ImpactSaltes; } worksheet.Cells["B64"].Value = closureTool.McppcoMargin; worksheet.Cells["B65"].Value = closureTool.MccpcoCashFlow; worksheet.Cells["B66"].Value = closureTool.Compensation; worksheet.Cells["B67"].Value = closureTool.CompAssumption; worksheet.Cells["B68"].Value = closureTool.CashflowGrowth; if (closureTool.IsOptionOffered.HasValue) { worksheet.Cells["B69"].Value = closureTool.IsOptionOffered.Value ? "Yes" : "No"; } worksheet.Cells["B70"].Value = closureTool.LeaseTerm; worksheet.Cells["B71"].Value = closureTool.Investment; worksheet.Cells["B72"].Value = closureTool.NPVRestaurantCashflows; if (closureTool.Yr1SOI != null) { worksheet.Cells["B73"].Value = closureTool.Yr1SOI; } if (closureTool.Yr1SOI != null) { worksheet.Cells["B74"].Value = closureTool.IRR; } if (closureTool.ConclusionComment != null) { worksheet.Cells["B76"].Value = closureTool.ConclusionComment; } }