/// <summary> /// 获取表头信息 /// </summary> private List <AkServerReportModel> getHeaderData() { List <AkServerReportModel> lt_headers = new List <AkServerReportModel>(); AkServerReportModel model1 = new AkServerReportModel(); AkServerReportModel model2 = new AkServerReportModel(); AkServerReportModel model3 = new AkServerReportModel(); model1.TimeInterval = AkConfig.StartDate.Replace("-", "") + "—" + AkConfig.EndDate.Replace("-", "") + " BK-SOS-Report 服务区"; //model1.HourTime = "BK-SOS-Report"; //model1.OrderModeName = "BK-SOS-Report"; //model1.TerminalName = "BK-SOS-Report"; //model1.SalesTurnover = "BK-SOS-Report"; //model1.OrderNum = "BK-SOS-Report"; model1.Item1 = "服务速度报表"; //model1.AvgProduct = AkDaoHelper.Instance_SystemParam.GetStoreNO(); //model1.Item2 = "服务区样表"; //model1.Item3 = "服务区样表"; //model1.Item4 = "服务区样表"; //model1.Item5 = "服务区样表"; //model1.Item6 = "服务区样表"; //model1.Item7 = "服务区样表"; lt_headers.Add(model1); model2.TimeInterval = "时段"; model2.HourTime = "小时"; model2.SalesTurnover = "营业额"; model2.OrderNum = "订单数量"; model2.AvgProduct = "产品平均数"; model2.Item1 = "系统点餐时间"; model2.Item2 = "收银时间"; model2.Item3 = "备餐时间"; model2.Item4 = "汇餐时间"; model2.Item5 = "整体时间"; model2.Item6 = "超时订单率"; model2.Item11 = "柜台"; model2.Item21 = "自助点餐(含手机点餐&大屏点餐)"; model2.Item31 = "外送"; lt_headers.Add(model2); model3.Item11 = "柜台订单数量"; model3.Item12 = "系统点餐时间"; model3.Item13 = "收银时间"; model3.Item14 = "备餐时间"; model3.Item15 = "汇餐时间"; model3.Item16 = "整体时间"; model3.Item21 = "自助点餐订单数量"; model3.Item22 = "备餐时间"; model3.Item23 = "汇餐时间"; model3.Item31 = "外送订单数量"; model3.Item32 = "备餐时间"; lt_headers.Add(model3); return(lt_headers); }
/// <summary> /// 添加数据记录 /// </summary> /// <param name="repastName"></param> /// <param name="orderMode"></param> /// <param name="terminalType"></param> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="ltResult"></param> private void AddRecode(string repastName, string startTime, string endTime, List <AkServerReportModel> ltResult, int type = 0) { AkServerReportModel model = new AkServerReportModel(); if (type == 0) { model.TimeInterval = repastName; model.HourTime = startTime + "-" + endTime; } else if (type == 1) { model.TimeInterval = repastName + "合计"; model.HourTime = startTime + "-" + endTime; } else if (type == 2) { model.TimeInterval = repastName + "合计"; model.HourTime = startTime + "-" + endTime; } model.SalesTurnover = this.DefaultValue; model.OrderNum = this.DefaultValue; model.AvgProduct = this.DefaultValue; model.Item1 = this.DefaultValue; model.Item2 = this.DefaultValue; model.Item3 = this.DefaultValue; model.Item4 = this.DefaultValue; model.Item5 = this.DefaultValue; model.Item6 = this.DefaultValue; model.Item11 = this.DefaultValue; model.Item12 = this.DefaultValue; model.Item13 = this.DefaultValue; model.Item14 = this.DefaultValue; model.Item15 = this.DefaultValue; model.Item16 = this.DefaultValue; model.Item21 = this.DefaultValue; model.Item22 = this.DefaultValue; model.Item23 = this.DefaultValue; model.Item31 = this.DefaultValue; model.Item32 = this.DefaultValue; model.RowIndex = rowIndex++; ltResult.Add(model); }
private void setTotalServerData(string startTime, string endTime, AkServerReportModel model) { startTime = startTime + ":00"; endTime = endTime + ":00"; if (model != null) { //@1.设置营业额 int salesTurnover = AkDaoHelper.Instance_Server.GetSalesTurnover(startTime, endTime); if (salesTurnover > 0) { model.SalesTurnover = salesTurnover.ToString(); } //@2.订单数量 Dictionary <string, decimal> orderNum = AkDaoHelper.Instance_Server.GetOrderNumber(startTime, endTime); if (orderNum != null && orderNum.Count > 0) { model.OrderNum = orderNum["all"].ConvertDigits(0); model.Item11 = orderNum["guit"].ConvertDigits(0); model.Item21 = orderNum["auto"].ConvertDigits(0); model.Item31 = orderNum["wais"].ConvertDigits(0); } //@3.点餐时间 Dictionary <string, decimal> orderTime = AkDaoHelper.Instance_Server.GetOrderTime(orderNum, startTime, endTime); if (orderTime != null && orderTime.Count > 0) { model.Item1 = orderTime["all"].ConvertDigits(0); model.Item12 = orderTime["guit"].ConvertDigits(0); } //@4.收银时间 Dictionary <string, decimal> cashTime = AkDaoHelper.Instance_Server.GetCashTime(orderNum, startTime, endTime); if (cashTime != null && cashTime.Count > 0) { model.Item2 = cashTime["all"].ConvertDigits(0); model.Item13 = cashTime["guit"].ConvertDigits(0); } //@5.备餐时间 Dictionary <string, decimal> prepareTime = AkDaoHelper.Instance_Server.GetPrepareTime(orderNum, startTime, endTime); if (prepareTime != null && prepareTime.Count > 0) { model.Item3 = prepareTime["all"].ConvertDigits(0); model.Item14 = prepareTime["guit"].ConvertDigits(0); model.Item22 = prepareTime["auto"].ConvertDigits(0); model.Item32 = prepareTime["wais"].ConvertDigits(0); } //@6.汇餐时间 Dictionary <string, decimal> remitTime = AkDaoHelper.Instance_Server.GetRemitTime(orderNum, startTime, endTime); if (remitTime != null && remitTime.Count > 0) { model.Item4 = remitTime["all"].ConvertDigits(0); model.Item15 = remitTime["guit"].ConvertDigits(0); model.Item23 = remitTime["auto"].ConvertDigits(0); } //@7.整体时间 Dictionary <string, decimal> wholeTime = AkDaoHelper.Instance_Server.GetWholeTime(orderNum, startTime, endTime); if (wholeTime != null && wholeTime.Count > 0) { model.Item5 = wholeTime["all"].ConvertDigits(0); model.Item16 = wholeTime["guit"].ConvertDigits(0); } //@8.超时订单% model.Item6 = AkDaoHelper.Instance_Server.GetTimeOut(orderNum, startTime, endTime); //产品平均数 int avg = AkDaoHelper.Instance_Server.GetAvgProduct(orderNum, startTime, endTime); if (orderNum != null && orderNum.ContainsKey("all")) { model.AvgProduct = orderNum["all"] > 0 ? (avg / orderNum["all"]).ConvertDigits(1) : string.Empty; } } }
/// <summary> /// Excel添加行数据 /// </summary> /// <param name="sheet"></param> /// <param name="model"></param> private void AddRow(ISheet sheet, AkServerReportModel model, List <int> ltStyle) { IRow dataRow = sheet.CreateRow(rowIndex); int column = 0; dataRow.Height = 18 * 20; ICell newCel0 = dataRow.CreateCell(column++); ICell newCel1 = dataRow.CreateCell(column++); ICell newCel2 = dataRow.CreateCell(column++); ICell newCel3 = dataRow.CreateCell(column++); ICell newCel4 = dataRow.CreateCell(column++); ICell newCel5 = dataRow.CreateCell(column++); ICell newCel6 = dataRow.CreateCell(column++); ICell newCel7 = dataRow.CreateCell(column++); ICell newCel8 = dataRow.CreateCell(column++); ICell newCel9 = dataRow.CreateCell(column++); ICell newCel10 = dataRow.CreateCell(column++); ICell newCel11 = dataRow.CreateCell(column++); ICell newCel12 = dataRow.CreateCell(column++); ICell newCel13 = dataRow.CreateCell(column++); ICell newCel14 = dataRow.CreateCell(column++); ICell newCel15 = dataRow.CreateCell(column++); ICell newCel16 = dataRow.CreateCell(column++); ICell newCel17 = dataRow.CreateCell(column++); ICell newCel18 = dataRow.CreateCell(column++); ICell newCel19 = dataRow.CreateCell(column++); ICell newCel20 = dataRow.CreateCell(column++); ICell newCel21 = dataRow.CreateCell(column++); newCel0.SetCellValue(model.TimeInterval); newCel1.SetCellValue(model.HourTime); newCel2.SetCellValue(model.SalesTurnover); newCel3.SetCellValue(model.OrderNum); newCel4.SetCellValue(model.AvgProduct); newCel5.SetCellValue(model.Item1); newCel6.SetCellValue(model.Item2); newCel7.SetCellValue(model.Item3); newCel8.SetCellValue(model.Item4); newCel9.SetCellValue(model.Item5); newCel10.SetCellValue(model.Item6); newCel11.SetCellValue(model.Item11); newCel12.SetCellValue(model.Item12); newCel13.SetCellValue(model.Item13); newCel14.SetCellValue(model.Item14); newCel15.SetCellValue(model.Item15); newCel16.SetCellValue(model.Item16); newCel17.SetCellValue(model.Item21); newCel18.SetCellValue(model.Item22); newCel19.SetCellValue(model.Item23); newCel20.SetCellValue(model.Item31); newCel21.SetCellValue(model.Item32); if (ltStyle != null && ltStyle.Contains(rowIndex)) { newCel0.CellStyle = this.StyleForegroundThin; newCel1.CellStyle = this.StyleForegroundThin; newCel2.CellStyle = this.StyleForegroundThin; newCel3.CellStyle = this.StyleForegroundThin; newCel4.CellStyle = this.StyleForegroundThin; newCel5.CellStyle = this.StyleForegroundThin; newCel6.CellStyle = this.StyleForegroundThin; newCel7.CellStyle = this.StyleForegroundThin; newCel8.CellStyle = this.StyleForegroundThin; newCel9.CellStyle = this.StyleForegroundThin; newCel10.CellStyle = this.StyleForegroundThin; newCel11.CellStyle = this.StyleForegroundThin; newCel12.CellStyle = this.StyleForegroundThin; newCel13.CellStyle = this.StyleForegroundThin; newCel14.CellStyle = this.StyleForegroundThin; newCel15.CellStyle = this.StyleForegroundThin; newCel16.CellStyle = this.StyleForegroundThin; newCel17.CellStyle = this.StyleForegroundThin; newCel18.CellStyle = this.StyleForegroundThin; newCel19.CellStyle = this.StyleForegroundThin; newCel20.CellStyle = this.StyleForegroundThin; newCel21.CellStyle = this.StyleForegroundThin; } else { newCel0.CellStyle = this.StyleThin; newCel1.CellStyle = this.StyleThin; newCel2.CellStyle = this.StyleThin; newCel3.CellStyle = this.StyleThin; newCel4.CellStyle = this.StyleThin; newCel5.CellStyle = this.StyleThin; newCel6.CellStyle = this.StyleThin; newCel7.CellStyle = this.StyleThin; newCel8.CellStyle = this.StyleThin; newCel9.CellStyle = this.StyleThin; newCel10.CellStyle = this.StyleThin; newCel11.CellStyle = this.StyleThin; newCel12.CellStyle = this.StyleThin; newCel13.CellStyle = this.StyleThin; newCel14.CellStyle = this.StyleThin; newCel15.CellStyle = this.StyleThin; newCel16.CellStyle = this.StyleThin; newCel17.CellStyle = this.StyleThin; newCel18.CellStyle = this.StyleThin; newCel19.CellStyle = this.StyleThin; newCel20.CellStyle = this.StyleThin; newCel21.CellStyle = this.StyleThin; } rowIndex++; }