/// <summary> /// 构建设计完结单信息 /// </summary> /// <param name="employeeID"></param> /// <returns></returns> private IQueryable <DesignResultViewModel> BuildResultInfo(int employeeID) { var role = storeEmployeesBLL.GetModel(p => p.ID == employeeID); List <DesignResultViewModel> designResultViews = new List <DesignResultViewModel>(); List <设计_设计案完结单> models = new List <设计_设计案完结单>(); if (role.是否店长 == true) { models = designResultBLL.GetModels(p => p.店铺ID == storeID).ToList(); } else { return(null); } foreach (var item in models) { DesignResultViewModel designResultViewModel = new DesignResultViewModel(); designResultViewModel.Id = item.id; designResultViewModel.制单日期 = item.制单日期; designResultViewModel.合计成交金额 = item.合计成交金额; var files = design_ProjectDrawingsBLL.GetModels(p => p.设计案提交表ID == item.设计案提交表ID && p.文件类型 == 8); List <String> listPath = new List <string>(); if (files.Count() > 0) { foreach (var ite in files) { listPath.Add(ite.存储路径); } designResultViewModel.完成效果图路径 = listPath; } designResultViewModel.实际完成时间 = item.实际完成时间; designResultViewModel.实际完成空间 = item.实际完成空间; designResultViewModel.审批状态 = item.审批状态; designResultViewModel.客户编号 = item.客户单号;//合同编号 designResultViewModel.店长审核 = item.店长审核; designResultViewModel.设计师确认 = item.设计师确认; designResultViewModel.销售审核 = item.销售审核; designResultViewModel.设计案提交表ID = item.设计案提交表ID; designResultViewModel.销售人员 = storeEmployeesBLL.GetModel(p => p.ID == item.销售人员).姓名; designResultViewModel.销售人员确认日期 = item.销售人员确认日期; designResultViewModel.销售单号 = item.销售单号; //订单编号 designResultViewModel.单据编号 = item.单据编号; //单据编号 designResultViewModel.店长 = storeEmployeesBLL.GetModel(p => p.ID == item.店长).姓名; designResultViewModel.店长审核日期 = item.店长确认日期; designResultViewModel.延期或无法完成原因 = item.延期或无法完成原因; designResultViewModel.建议 = item.建议; designResultViewModel.更新人 = item.更新人; designResultViewModel.计划完成时间 = item.计划完成时间; designResultViewModel.计划完成空间 = item.计划完成空间; designResultViewModel.设计师 = storeEmployeesBLL.GetModel(p => p.ID == item.设计师).姓名; designResultViewModel.设计师确认 = item.设计师确认; designResultViewModel.设计师确认日期 = item.设计师确认日期; designResultViewModel.更新日期 = item.更新日期; int sellID;//销售订单ID if (item.设计案提交表ID != null && item.设计案提交表ID != 0) { var phoneNumber = designSubmitBLL.GetModel(w => w.id == item.设计案提交表ID).联系方式; try { sellID = salesOrderBLL.GetModel(p => p.客户联系方式 == phoneNumber && p.店铺ID == storeID).ID; //根据联系方式查找相应的客户的订单ID designResultViewModel.客户编号 = salesOrderBLL.GetModel(p => p.ID == sellID).合同编号; //合同编号 designResultViewModel.设计案提交表ID = item.设计案提交表ID; designResultViewModel.销售单号 = salesOrderBLL.GetModel(p => p.ID == sellID).订单编号; //订单编号 designResultViewModel.单据编号 = salesOrderBLL.GetModel(p => p.ID == sellID).单据编号; //单据编号 } catch (Exception e) { return(null); } var lis = salesOrder_DetailsBLL.GetModels(p => p.单据ID == sellID).ToList();//根据订单ID查询订单详细 List <DesignResult_OrderDetailViewModel> list = new List <DesignResult_OrderDetailViewModel>(); foreach (var ite in lis) { DesignResult_OrderDetailViewModel model = new DesignResult_OrderDetailViewModel(); var spuid = product_SKUBLL.GetModel(p => p.ID == ite.SKU_ID).SPU_ID; var productid = product_SPUBLL.GetModel(p => p.ID == spuid).商品ID; var product = productBLL.GetModel(p => p.ID == productid); model.产品型号 = product.编号; model.单位 = product.计量单位; model.成交价 = ite.零售小计; model.数量 = ite.数量; model.空间 = ""; list.Add(model); } designResultViewModel.DesignResult_OrderDetailViewModel = list; } designResultViews.Add(designResultViewModel); } return(designResultViews.AsQueryable()); }
/// <summary> /// 门店管理首页 /// </summary> /// <returns></returns> public ActionResult Index() { string userName = HttpContext.User.Identity.Name; if (userName != null) { var employees = HttpContext.Session["Employee"] as Employees; ViewBag.Store = employees.店铺; ViewBag.IsManager = employees.是否店长; ViewBag.Employee = employees.姓名; ViewBag.IsManager = storeEmployeesBLL.GetModel(p => p.ID == employees.ID).是否店长; ViewBag.IsDesigner = storeEmployeesBLL.GetModel(p => p.ID == employees.ID).是否设计师; ViewBag.IsEmployee = storeEmployeesBLL.GetModel(p => p.ID == employees.ID).是否销售; } SetEmployee(); ViewBag.CustomerCount = "" + customerInfoBLL.GetModels(p => p.店铺ID == storeID).Count(); ViewBag.DesignApplyCount = "" + DesignSubmitBLL.GetModels(p => p.店铺ID == storeID).Count(); ViewBag.DesignResultCount = "" + DesignResultBLL.GetModels(p => p.店铺ID == storeID).Count(); //创建区域1 var series1 = new Series(); series1.Name = "全年接待数据"; //Poin数组 Point[] series1Points = new Point[12]; for (int i = 1; i < 13; i++) { var n = customerInfoBLL.GetModels(p => p.店铺ID == storeID && p.接待日期.Month == i).Count(); series1Points[i - 1] = new Point() { X = i, Y = n * 10 }; } series1.Data = new Data(series1Points); //创建区域2 var series2 = new Series(); series2.Name = "本月接待数据"; //获取本月有多少天 var month_days = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month); //Point数组 Point[] series2Points = new Point[month_days]; var n1 = customerInfoBLL.GetModels(p => p.店铺ID == storeID && p.接待日期.Month == DateTime.Now.Month); for (int i = 0; i < month_days; i++) { var m = n1.Where(p => p.接待日期.Day == i + 1).Count(); series2Points[i] = new Point() { X = i + 1, Y = m }; } series2.Data = new Data(series2Points); //把2个区域加入到Series集合中 var chartSeries = new List <Series>(); chartSeries.Add(series1); var chartSeries2 = new List <Series>(); chartSeries2.Add(series2); //创建chart model var chart1 = new Highcharts("接待年度统计"); chart1.InitChart(new Chart() { DefaultSeriesType = ChartTypes.Line }) .SetTitle(new Title() { Text = "接待年度统计" }) .SetSeries(chartSeries.ToArray()); ViewBag.ChartModel1 = chart1; var chart2 = new Highcharts("接待月统计"); chart2.InitChart(new Chart() { DefaultSeriesType = ChartTypes.Column }) .SetTitle(new Title() { Text = "接待月统计" }) .SetSeries(chartSeries2.ToArray()); ViewBag.ChartModel2 = chart2; return(View()); }