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;
}
}
