public ActionResult Index(OrderProfitLog OrderProfitLog, EFPagingInfo <OrderProfitLog> p, int IsFirst = 0) { this.TempData.Remove("SysAgentList"); #region 校验与初始化 //if (OrderProfitLog.STime.IsNullOrEmpty()) //{ // OrderProfitLog.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); //} //if (OrderProfitLog.ETime.IsNullOrEmpty()) //{ // //OrderProfitLog.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); // OrderProfitLog.ETime = DateTime.Now; //} p.SqlWhere.Add(f => f.LogType == 3); if (!OrderProfitLog.TNum.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TNum == OrderProfitLog.TNum); } if (!OrderProfitLog.OrderType.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.OrderType == OrderProfitLog.OrderType); } if (!OrderProfitLog.Agent.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Agent == OrderProfitLog.Agent); } if (!OrderProfitLog.STime.IsNullOrEmpty() && !OrderProfitLog.ETime.IsNullOrEmpty()) { DateTime ETime = OrderProfitLog.ETime; p.SqlWhere.Add(f => f.AddTime > OrderProfitLog.STime && f.AddTime < ETime); } #endregion p.PageSize = 20; p.OrderByList.Add("Id", "DESC"); IPageOfItems <OrderProfitLog> OrderProfitLogList = null; if (IsFirst == 0) { OrderProfitLogList = new PageOfItems <OrderProfitLog>(new List <OrderProfitLog>(), 0, 20, 0, new Hashtable()); } else { OrderProfitLogList = Entity.Selects <OrderProfitLog>(p); } ViewBag.OrderProfitLogList = OrderProfitLogList; ViewBag.OrderProfitLog = OrderProfitLog; IList <OrderProfitLog> List = OrderProfitLogList.GroupBy(n => n.UId).Select(n => n.First()).ToList(); List <int> UId = OrderProfitLogList.Select(o => o.UId).Distinct().ToList(); IList <Users> UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList(); List <int> AgentId = OrderProfitLogList.Select(o => o.Agent).Distinct().ToList(); IList <SysAgent> AgentList = Entity.SysAgent.Where(n => n.State == 1 && AgentId.Contains(n.Id)).ToList(); ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList(); ViewBag.SysAgentList = Entity.SysAgent.Where(n => AgentId.Contains(n.Id)).ToList(); this.TempData["SysAgentList"] = ViewBag.SysAgentList; ViewBag.SelectSysAgentList = Entity.SysAgent.Where(n => n.State == 1).ToList(); ViewBag.Xls = this.checkPower("Xls"); return(View()); }
public ActionResult Index(OrderProfitLog OrderProfitLog, EFPagingInfo <OrderProfitLog> p, string TName, DateTime?STime, DateTime?ETime, bool?IsShowSupAgent, int IsFirst = 0) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } if (STime.IsNullOrEmpty()) { STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); } if (ETime.IsNullOrEmpty()) { //JobOrders.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); ETime = DateTime.Now; } IPageOfItems <OrderProfitLog> OrderProfitLogList = null; if (IsFirst == 0) { OrderProfitLogList = new PageOfItems <OrderProfitLog>(new List <OrderProfitLog>(), 0, 10, 0, new Hashtable()); } else { p = this.Condition(OrderProfitLog, p, TName, STime, ETime, IsShowSupAgent); OrderProfitLogList = Entity.Selects <OrderProfitLog>(p); } ViewBag.TName = TName; ViewBag.OrderProfitLogList = OrderProfitLogList; ViewBag.OrderProfitLog = OrderProfitLog; IList <OrderProfitLog> List = OrderProfitLogList.GroupBy(n => n.UId).Select(n => n.First()).ToList(); List <int> UId = new List <int>(); foreach (var pp in List) { UId.Add(pp.UId); } ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList(); ViewBag.SelectAgentsList = Entity.SysAgent.Where(n => n.State == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.STime = STime; ViewBag.ETime = ETime; ViewBag.ExcelExport = this.checkPower("Xls"); return(View()); }