private void OpenFirstMenu(tb_Sys_Menu menuInfo) { if (menuInfo.MenuName.Trim() == "主页") { var form = this.MdiChildren.Where(i => i.Text == "主页").FirstOrDefault(); if (form != null) { this.xtraTabbedMdiManager1.SelectedPage = this.xtraTabbedMdiManager1.Pages[form]; return; } DashboardMain frmDashboard = new DashboardMain(); frmDashboard.MdiParent = this; frmDashboard.Text = menuInfo.MenuName.Trim(); frmDashboard.Show(); //this.xtraTabbedMdiManager1.Pages[frmDashboard] return; } appCacheService.AddItem("ParentMenu", menuInfo);//当前一级菜单信息存入缓存 string formText = menuInfo.MenuName; //if (SelecedTabByName(formText)) // return; var m = this.MdiChildren.Where(i => i.Name == "HomeForm").FirstOrDefault() as HomeForm; if (m != null) { m.IntitData(); // m.WindowState = FormWindowState.Maximized; m.Text = formText; // m.Show(); this.xtraTabbedMdiManager1.SelectedPage = this.xtraTabbedMdiManager1.Pages[m]; return; } string nameSpece = menuInfo.NameSpeace;//ERP.Winform.SysModule.HomForm Type type = Type.GetType(nameSpece); if (type == null) { throw new AppException("没有对应的窗体类型,创建失败"); } HomeForm obj = (HomeForm)Activator.CreateInstance(type); obj.Text = formText; obj.Name = "HomeForm"; obj.IntitData(); obj.OnShowDig += new HomeForm.del(obj_OnShowDig); obj.MdiParent = this; //obj.WindowState = FormWindowState.Maximized; obj.Show(); }
public JsonResult MainDashboard() { DashboardMain dashboard = new DashboardMain(); try { var distributorCount = context.Distributors .Where(w => (w.IsActive == true)) .Count(); var clientCount = context.ClientMasters .Where(w => (w.IsActive == true)) .Count(); var productSoldCount = context.Orders .Include(i => i.OrderStatus) .Where(w => w.OrderStatus.Status == "Payment") .Count(); var paymentDues = context.Invoices .Where(w => w.PaymentStatus.Status == "Unpaid" && w.IsDeleted == false) .Sum(s => s.TotalAmount); var callLogCount = 5; var pendingDeviceReadyCount = context.Orders .Include(i => i.OrderStatus) .Where(w => w.OrderStatus.Status == "Pending") .Count(); var pendingBillingCount = context.Orders .Include(i => i.OrderStatus) .Where(w => w.OrderStatus.Status == "Device Ready") .Count(); var pendingDispatchCount = context.Dispatchs .Where(w => w.Order.OrderStatus.Status == "Billing" && w.IsDispatched == false) .Count(); var pendingPaymentCount = context.Invoices .Where(w => w.PaymentStatus.Status == "Unpaid" && w.IsDeleted == false) .Count(); var totalCollection = context.Invoices .Where(w => w.PaymentStatus.Status == "Paid" && w.IsDeleted == false) .Sum(s => s.TotalAmount); var totalProfit = 100; var orderQueue = context.Orders .Include(i => i.OrderStatus) .Where(w => w.OrderStatus.Status != "Cancel" && w.OrderStatus.Status != "Payment") .Count(); var userCount = context.UserMasters .Where(w => w.IsActive == true) .Count(); dashboard.DistributorCount = distributorCount; dashboard.ClientCount = clientCount; dashboard.ProductSoldCount = productSoldCount; dashboard.PaymentDues = paymentDues; dashboard.CallLogCount = callLogCount; dashboard.PendingDeviceReadyCount = pendingDeviceReadyCount; dashboard.PendingBillingCount = pendingBillingCount; dashboard.PendingDispatchCount = pendingDispatchCount; dashboard.PendingPaymentCount = pendingPaymentCount; dashboard.TotalCollection = totalCollection; dashboard.TotalProfit = totalProfit; dashboard.OrderQueue = orderQueue; dashboard.UserCount = userCount; var today = DateTime.Today; var month = new DateTime(today.Year, today.Month, 1); var from = month.AddMonths(-12); ///Order Chart List <MonthlyChart> OrdersChart = new List <MonthlyChart>(); var fromDate = month; for (int i = 11; i >= 0; i--) { var date = fromDate.AddMonths(-i); var count = context.Orders .Where(w => w.CreatedOn.Value.Month == date.Month && w.CreatedOn.Value.Year == date.Year && w.OrderStatus.Status != "Cancel") .Count(); OrdersChart.Add(new MonthlyChart { Name = "OrdersChart", iYear = date.Year, sMonth = date.ToString("MMM"), Count = count }); } dashboard.OrdersChart = OrdersChart; ///End Order Chart ///Dispatch Chart List <MonthlyChart> DispatchChart = new List <MonthlyChart>(); for (int i = 11; i >= 0; i--) { var date = fromDate.AddMonths(-i); var count = context.Dispatchs .Where(w => w.CreatedOn.Value.Month == date.Month && w.CreatedOn.Value.Year == date.Year && w.IsDeleted == false && w.IsDispatched == true) .Count(); DispatchChart.Add(new MonthlyChart { Name = "DispatchChart", iYear = date.Year, sMonth = date.ToString("MMM"), Count = count }); } dashboard.DispatchChart = DispatchChart; ///End Dispatch Chart ///PaymentDues Chart List <MonthlyChart> PaymentDuesChart = new List <MonthlyChart>(); for (int i = 11; i >= 0; i--) { var date = fromDate.AddMonths(-i); var count = context.Invoices .Where(w => w.CreatedOn.Month == date.Month && w.CreatedOn.Year == date.Year && w.IsDeleted == false && w.PaymentStatus.Status == "UnPaid") .Count(); PaymentDuesChart.Add(new MonthlyChart { Name = "PaymentDuesChart", iYear = date.Year, sMonth = date.ToString("MMM"), Count = count }); } dashboard.PaymentDuesChart = PaymentDuesChart; ///End PaymentDues Chart ///CallLogsChart //List<MonthlyChart> PaymentDuesChart = new List<MonthlyChart>(); //for (int i = 11; i >= 0; i--) //{ // var date = fromDate.AddMonths(-i); // var count = context.Invoices // .Where(w => w.CreatedOn.Month == date.Month && w.CreatedOn.Year == date.Year && w.IsDeleted == false && w.PaymentStatus.Status == "UnPaid") // .Count(); // PaymentDuesChart.Add(new MonthlyChart // { // Name = "PaymentDuesChart", // iYear = date.Year, // sMonth = date.ToString("MMM"), // Count = count // }); //} //dashboard.PaymentDuesChart = PaymentDuesChart; ///End PaymentDues Chart return(Json(dashboard)); } catch (Exception ex) { throw; } finally { context = null; dashboard = null; } }