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