/// <summary>
///
/// </summary>
/// <param name="pageOfItems"></param>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public static IPageOfItems <object> ToObjectsPageOfItems <T>(this IPageOfItems <T> pageOfItems)
{
var result = new PageOfItems <object>(pageOfItems.Select(x => x as object))
{
PageIndex = pageOfItems.PageIndex,
PageSize = pageOfItems.PageSize,
TotalItemCount = pageOfItems.TotalItemCount,
SearchHitViewState = pageOfItems.SearchHitViewState
};
return(result);
}
/// <summary>
/// 将类型T的分页数据列表转换为类型TView的分页数据列表
/// </summary>
/// <typeparam name="T">原始数据类型</typeparam>
/// <typeparam name="TView">返回的数据类型</typeparam>
/// <param name="items">数据列表</param>
/// <param name="selector">数据转换选择器</param>
/// <returns>返回TView的分页数据列表</returns>
public static IPageOfItems <TView> ToView <T, TView>(this IPageOfItems <T> items, Func <T, TView> selector)
{
//初始化页面信息
var pageOfItems = new PageOfItems <TView>
{
PageIndex = items.PageIndex,
PageSize = items.PageSize,
TotalItemCount = items.TotalItemCount,
};
var list = items.Select(selector);
pageOfItems.AddRange(list.ToList());
return(pageOfItems);
}
public ActionResult MyUsers(Users Users, EFPagingInfo<Users> p, int IsFirst = 0)
{
if (IsFirst == 0)
{
PageOfItems<Users> UsersList1 = new PageOfItems<Users>(new List<Users>(), 0, 10, 0, new Hashtable());
ViewBag.UsersList = UsersList1;
ViewBag.Users = Users;
return View();
}
if (!Users.UserName.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.UserName.Contains(Users.UserName)); }
if (!Users.State.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.State == (Users.State == 99 ? 0 : Users.State)); }
if (!Users.MyPId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.MyPId == Users.MyPId); }
if (!Users.ShareType.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.ShareType == Users.ShareType); }
if (!Users.CardStae.IsNullOrEmpty())
{
int CardStae = Users.CardStae;
if (CardStae == 99)
{
CardStae = 0;
}
if (CardStae != 88)
{
p.SqlWhere.Add(f => f.CardStae == CardStae);
}
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems<Users> UsersList = Entity.Selects<Users>(p);
var pcids = UsersList.Select(o => o.PayConfigId).Distinct().ToArray();
List<PayConfigChange> PayConfigChangeList = new List<PayConfigChange>();
if (pcids.Length > 0)
{
string pcidsStr = string.Join(",", pcids);
PayConfigChangeList = this.Entity.ExecuteStoreQuery<PayConfigChange>("SELECT * FROM PayConfigChange Where Id in(" + pcidsStr + ")").ToList();
}
ViewBag.PayConfigChangeList = PayConfigChangeList;
ViewBag.UsersList = UsersList;
ViewBag.Users = Users;
//显示上级名字
return View();
}
public ActionResult Index(Orders Orders, EFPagingInfo <Orders> p, bool?IsShowSupAgent, int?LowerLevel, int IsFirst = 0)
{
if (IsFirst == 0)
{
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
if (checkPower("ALL"))
{
IsAll = true;
}
LowerLevel = LowerLevel == null ? 0 : LowerLevel;
ViewBag.IsAll = IsAll;
PageOfItems <Orders> OrdersList1 = new PageOfItems <Orders>(new List <Orders>(), 0, 10, 0, new Hashtable());
ViewBag.OrdersList = OrdersList1;
ViewBag.Orders = Orders;
//查询对应的商户
List <int> UId1 = OrdersList1.Select(o => o.UId).Distinct().ToList();
ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId1.Contains(n.Id)).ToList();
ViewBag.PayConfigList = Entity.PayConfig.Where(n => n.State == 1).ToList();
ViewBag.IsShowSupAgent = IsShowSupAgent;
ViewBag.BasicAgent = BasicAgent;
SysSet SysSet1 = Entity.SysSet.FirstOrNew();
ViewBag.SysSet = SysSet1;
ViewBag.Entity = Entity;
ViewBag.LowerLevel = LowerLevel;
return(View());
}
//if (Orders.STime.IsNullOrEmpty())
//{
// Orders.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
//}
//if (Orders.ETime.IsNullOrEmpty())
//{
// Orders.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
//}
//if (!Orders.STime.IsNullOrEmpty() && !Orders.ETime.IsNullOrEmpty())
//{
// DateTime ETime = Orders.ETime;
// p.SqlWhere.Add(f => f.PayTime > Orders.STime && f.PayTime < ETime);
//}
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
if (checkPower("ALL"))
{
IsAll = true;
}
ViewBag.IsAll = IsAll;
/*有没有指定交易所属代理
* 有:校验是否从属关系
* 无：指定当前代理
*/
if (!Orders.Agent.IsNullOrEmpty())
{
if (!IsBelongToAgent(Orders.Agent))
{
ViewBag.ErrorMsg = "只能查询当前用户下属代理的交易";
return(View("Error"));
}
}
else
{
Orders.Agent = this.BasicAgent.Id;
}
LowerLevel = LowerLevel == null ? 0 : LowerLevel;
//没有"管理所有"权限的只能看到操作员自己的数据
//if (!IsAll)
//{
// p.SqlWhere.Add(f => f.AId == AdminUser.Id);//交易所属用户
//}
//else
{
IList <SysAgent> SysAgentList = null;
if ((bool)IsShowSupAgent)
{
IList <int> UID = new List <int>();
if (LowerLevel != 0)
{
SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == LowerLevel).FirstOrNew();
SysAgentList = LowerLevelAgent.GetSupAgent(Entity);
}
else
{
SysAgentList = BasicAgent.GetSupAgent(Entity);//获取所有下级代理商信息
}
foreach (var s in SysAgentList)
{
UID.Add(s.Id);
}
p.SqlWhere.Add(f => UID.Contains(f.Agent));
}
else
{
p.SqlWhere.Add(f => f.Agent == Orders.Agent);//交易所属代理
}
}
#region 筛选条件
if (!Orders.OrderAddress.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.OrderAddress.Contains(Orders.OrderAddress));
}
if (!Orders.TNum.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TNum == Orders.TNum);
}
if (!Orders.LagEntryDay.IsNullOrEmpty())
{
if (Orders.LagEntryDay == 99)
{
p.SqlWhere.Add(f => f.LagEntryDay == 0);
}
else
{
p.SqlWhere.Add(f => f.LagEntryDay > 0);
}
}
if (!Orders.TrunType.IsNullOrEmpty())
{
if (Orders.TrunType == 1)
{
p.SqlWhere.Add(f => f.TrunType == 1);
}
else
{
p.SqlWhere.Add(f => f.TrunType == 0);
}
}
if (!Orders.TName.IsNullOrEmpty())
{
IList <Users> UList = Entity.Users.Where(n => n.TrueName.Contains(Orders.TName) || n.NeekName.Contains(Orders.TName) || n.UserName == Orders.TName).ToList();
List <int> UIds = new List <int>();
foreach (var pp in UList)
{
UIds.Add(pp.Id);
}
p.SqlWhere.Add(f => UIds.Contains(f.UId));
}
if (!Orders.PayWay.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.PayWay == Orders.PayWay);
}
if (!Orders.STime.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AddTime >= Orders.STime);
}
if (!Orders.ETime.IsNullOrEmpty())
{
DateTime ETime = Orders.ETime.AddHours(23).AddMinutes(59).AddSeconds(59);
p.SqlWhere.Add(f => f.AddTime <= ETime);
}
#region 交易类型条件判断
p.SqlWhere.Add(f => f.TType == 2);//读取对应的类型
if (Orders.TType == 2)
{
if (!Orders.TState.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TState == Orders.TState);
}
}
#endregion
#endregion
p.OrderByList.Add("Id", "DESC");
IPageOfItems <Orders> OrdersList = Entity.Selects <Orders>(p);
ViewBag.OrdersList = OrdersList;
ViewBag.Orders = Orders;
//查询对应的商户
List <int> UId = OrdersList.Select(o => o.UId).Distinct().ToList();
ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList();
//因为上面判段过了，这里其实是不用的
//if (checkPower("ALL"))
//{
// ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && n.Agent == AdminUser.AgentId && UId.Contains(n.Id)).ToList();
//}
//else
//{
// ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && n.AId == AdminUser.Id && UId.Contains(n.Id)).ToList();
//}
ViewBag.PayConfigList = Entity.PayConfig.Where(n => n.State == 1).ToList();
ViewBag.IsShowSupAgent = IsShowSupAgent;
ViewBag.BasicAgent = BasicAgent;
SysSet SysSet = Entity.SysSet.FirstOrNew();
ViewBag.SysSet = SysSet;
ViewBag.Entity = Entity;
ViewBag.LowerLevel = LowerLevel;
return(View());
}
public ActionResult OrdersRiskIndex(Orders Orders, EFPagingInfo <Orders> p, int IsFirst = 0)
{
ViewBag.Add = this.checkPower("Add");
ViewBag.Edit = this.checkPower("Edit");
if (IsFirst == 0)
{
var AgentList1 = this.BasicAgent.GetSupAgent(this.Entity);
PageOfItems <Orders> OrdersList1 = new PageOfItems <Orders>(new List <Orders>(), 0, 10, 0, new Hashtable());
ViewBag.Orders = Orders;
ViewBag.OrdersList = OrdersList1;
ViewBag.UsersList = new List <Users>();
ViewBag.AgentList = AgentList1;
return(View());
}
if (!Orders.DDAuto.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.DDAuto == Orders.DDAuto);
}
if (!Orders.IdCardState.IsNullOrEmpty())
{
if (Orders.IdCardState == 99)
{
p.SqlWhere.Add(f => f.IdCardState > 0);
}
else
{
p.SqlWhere.Add(f => f.IdCardState == Orders.IdCardState);
}
}
else
{
Orders.IdCardState = 1;
p.SqlWhere.Add(f => f.IdCardState == Orders.IdCardState);
}
if (!Orders.TNum.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TNum == Orders.TNum);
}
if (!Orders.STime.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.CardAddTime >= Orders.STime);
}
if (!Orders.ETime.IsNullOrEmpty())
{
var ETime = Orders.ETime.AddSeconds(-1);
p.SqlWhere.Add(f => f.CardAddTime <= ETime);
}
//下级代理
var AgentList = this.BasicAgent.GetSupAgent(this.Entity);
if (this.BasicAgent.Tier == 1)
{
var aids = AgentList.Select(o => o.Id).ToList();
p.SqlWhere.Add(o => aids.Contains(o.Agent));
}
else
{
p.SqlWhere.Add(o => o.Agent == this.BasicAgent.Id);
}
p.OrderByList.Add("CardAddTime", "DESC");
IPageOfItems <Orders> OrdersList = Entity.Selects <Orders>(p);
ViewBag.Orders = Orders;
ViewBag.OrdersList = OrdersList;
//查询对应的商户
List <int> UId = OrdersList.Select(o => o.UId).Distinct().ToList();
ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList();
ViewBag.AgentList = AgentList;
ViewBag.SaveAssureImg = this.checkPower("SaveAssureImg");
return(View("OrdersRiskIndex"));
}
public ActionResult Index(Orders Orders, EFPagingInfo <Orders> p, bool?IsShowSupAgent, int?LowerLevel, int IsFirst = 0)
{
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
if (IsFirst == 0)
{
if (checkPower("ALL"))
{
IsAll = true;
}
ViewBag.IsAll = IsAll;
PageOfItems <Orders> OrdersList1 = new PageOfItems <Orders>(new List <Orders>(), 0, 10, 0, new Hashtable());
ViewBag.OrdersList = OrdersList1;
ViewBag.Orders = Orders;
//查询对应的商户
List <int> UId1 = OrdersList1.Select(o => o.UId).Distinct().ToList();
ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId1.Contains(n.Id)).ToList();
ViewBag.PayConfigList = Entity.PayConfig.Where(n => n.State == 1).ToList();
ViewBag.IsShowSupAgent = false;
ViewBag.BasicAgent = BasicAgent;
SysSet SysSet1 = Entity.SysSet.FirstOrNew();
ViewBag.SysSet = SysSet1;
ViewBag.Entity = Entity;
ViewBag.LowerLevel = 0;
ViewBag.Edit = this.checkPower("Edit");
return(View());
}
if (checkPower("ALL"))
{
IsAll = true;
}
ViewBag.IsAll = IsAll;
/*有没有指定交易所属代理
* 有:校验是否从属关系
* 无：指定当前代理
*/
if (!Orders.Agent.IsNullOrEmpty())
{
if (!IsBelongToAgent(Orders.Agent))
{
ViewBag.ErrorMsg = "只能查询当前用户下属代理的交易";
return(View("Error"));
}
}
else
{
Orders.Agent = this.BasicAgent.Id;
}
LowerLevel = LowerLevel == null ? 0 : LowerLevel;
//没有"管理所有"权限的只能看到操作员自己的数据
if (!IsAll)
{
p.SqlWhere.Add(f => f.AId == AdminUser.Id);//交易所属用户
}
else
{
IList <SysAgent> SysAgentList = null;
if ((bool)IsShowSupAgent)
{
IList <int> UID = new List <int>();
if (LowerLevel != 0)
{
SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == LowerLevel).FirstOrNew();
SysAgentList = LowerLevelAgent.GetSupAgent(Entity, true);
}
else
{
SysAgentList = BasicAgent.GetSupAgent(Entity, true);//获取所有下级代理商信息
}
UID = SysAgentList.Select(o => o.Id).ToList();
p.SqlWhere.Add(f => UID.Contains(f.Agent));
}
else
{
p.SqlWhere.Add(f => f.Agent == BasicAgent.Id);//读取全部分支机构
}
}
#region 筛选条件
if (!Orders.OrderAddress.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.OrderAddress.Contains(Orders.OrderAddress));
}
if (!Orders.TNum.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TNum == Orders.TNum);
}
if (!Orders.LagEntryDay.IsNullOrEmpty())
{
if (Orders.LagEntryDay == 99)
{
p.SqlWhere.Add(f => f.LagEntryDay == 0);
}
else
{
p.SqlWhere.Add(f => f.LagEntryDay > 0);
}
}
if (!Orders.TrunType.IsNullOrEmpty())
{
if (Orders.TrunType == 1)
{
p.SqlWhere.Add(f => f.TrunType == 1);
}
else
{
p.SqlWhere.Add(f => f.TrunType == 0);
}
}
if (!Orders.TName.IsNullOrEmpty())
{
IList <Users> UList = Entity.Users.Where(n => n.TrueName.Contains(Orders.TName) || n.NeekName.Contains(Orders.TName) || n.UserName == Orders.TName).ToList();
List <int> UIds = new List <int>();
foreach (var pp in UList)
{
UIds.Add(pp.Id);
}
p.SqlWhere.Add(f => UIds.Contains(f.UId));
}
if (!Orders.PayWay.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.PayWay == Orders.PayWay);
}
if (!Orders.STime.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AddTime >= Orders.STime);
}
if (!Orders.ETime.IsNullOrEmpty())
{
DateTime ETime = Orders.ETime.AddHours(23).AddMinutes(59).AddSeconds(59);
p.SqlWhere.Add(f => f.AddTime <= ETime);
}
#region 交易类型条件判断
if (!Orders.TType.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TType == Orders.TType);//读取对应的类型
if (Orders.TType == 1)
{
if (!Orders.TState.IsNullOrEmpty())
{
switch (Orders.TState)
{
case 1: //未付
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 0);
break;
case 2: //已付
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 1);
break;
case 3: //待传证照
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 1);
break;
case 4: //待审核
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 2);
break;
case 5: //审核失败
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 4);
break;
case 6: //退单
p.SqlWhere.Add(f => f.TState == 4);
break;
case 7: //待入帐
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.InState == 0);
break;
}
}
}
if (Orders.TType == 2)
{
if (!Orders.TState.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TState == Orders.TState);
}
}
if (Orders.TType == 3)
{
switch (Orders.TState)
{
case 1: //未付
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 0);
break;
case 2: //已付
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 1);
break;
case 3: //待传证照
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 1);
break;
case 4: //待审核
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 2);
break;
case 5: //审核失败
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 4);
break;
}
}
if (Orders.TType == 5)
{
if (!Orders.TState.IsNullOrEmpty())
{
switch (Orders.TState)
{
case 99: //未付
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 0);
break;
case 1: //处理中
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 0);
break;
case 2: //已汇出
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 2);
break;
case 4: //出款中
p.SqlWhere.Add(f => (f.TState == 2 && f.PayState == 2 && f.IdCardState == 0) || (f.TState == 2 && f.PayState == 1 && f.IdCardState == 3));
break;
case 3: //审核失败
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 4);
break;
case 5: //退款中
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 3);
break;
case 6: //已退款
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 4);
break;
case 7: //待传身份证
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 1);
break;
case 8: //已传身份证
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.IdCardState == 2);
break;
}
}
}
if (Orders.TType == 6)
{
if (!Orders.TState.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TState == Orders.TState);
}
}
if (Orders.TType == 7 || Orders.TType == 8 || Orders.TType == 9)
{
if (!Orders.TState.IsNullOrEmpty())
{
if (Orders.TState == 99)
{
p.SqlWhere.Add(f => f.TState == 0);
}
if (Orders.TState == 1)
{
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 0);
}
if (Orders.TState == 2)
{
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 1);
}
if (Orders.TState == 3)//退单
{
p.SqlWhere.Add(f => f.TState == 4);
}
if (Orders.TState == 4)//待入帐
{
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.InState == 0);
}
if (Orders.TState == 5)//待审核
{
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.InState == 1 && f.IdCardState == 2);
}
if (Orders.TState == 6)//待传证照
{
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.InState == 1 && f.IdCardState == 1);
}
if (Orders.TState == 7)//审核失败
{
p.SqlWhere.Add(f => f.TState == 1 && f.PayState == 1 && f.InState == 1 && f.IdCardState == 4);
}
}
}
if (Orders.TType == 10)
{
if (!Orders.TState.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TState == Orders.TState);
}
}
}
#endregion
#endregion
p.OrderByList.Add("Id", "DESC");
IPageOfItems <Orders> OrdersList = Entity.Selects <Orders>(p);
ViewBag.OrdersList = OrdersList;
ViewBag.Orders = Orders;
//查询对应的商户
List <int> UId = OrdersList.Select(o => o.UId).Distinct().ToList();
ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList();
ViewBag.PayConfigList = Entity.PayConfig.Where(n => n.State == 1).ToList();
ViewBag.IsShowSupAgent = IsShowSupAgent;
ViewBag.BasicAgent = BasicAgent;
SysSet SysSet = Entity.SysSet.FirstOrNew();
ViewBag.SysSet = SysSet;
ViewBag.Entity = Entity;
ViewBag.LowerLevel = LowerLevel;
ViewBag.Edit = this.checkPower("Edit");
return(View());
}
public void Post()
{
string Data = DataObj.GetData();
if (Data.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
JObject json = new JObject();
try
{
json = (JObject)JsonConvert.DeserializeObject(Data);
}
catch (Exception Ex)
{
Log.Write("[JobOrders]:", "【Data】" + Data, Ex);
DataObj.OutError("1000");
return;
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
JobOrders JobOrders = new JobOrders();
JobOrders = JsonToObject.ConvertJsonToModel(JobOrders, json);
#region 获取用户信息
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == JobOrders.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
#endregion
EFPagingInfo <JobOrders> p = new EFPagingInfo <JobOrders>();
if (!JobOrders.Pg.IsNullOrEmpty())
{
p.PageIndex = JobOrders.Pg;
}
if (!JobOrders.Pgs.IsNullOrEmpty())
{
p.PageSize = JobOrders.Pgs;
}
p.SqlWhere.Add(f => f.UId == baseUsers.Id);
//这里JobOrders.State=1进行中 JobOrders.State=2已完成
if (JobOrders.State == 1)
{
p.SqlWhere.Add(f => f.State == 2 || f.State == 3);
}
else if (JobOrders.State == 2)
{
p.SqlWhere.Add(f => f.State == 4 || f.State == 5);
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <JobOrders> List = Entity.Selects <JobOrders>(p);
var tnums = List.Select(o => o.TNum).ToList();
var UserCardIds = List.Select(o => o.UserCardId).ToList();
List <JobItem> JobItemList = Entity.JobItem.Where(n => tnums.Contains(n.TNum)).ToList();
List <UserCard> UserCardList = Entity.UserCard.Where(n => UserCardIds.Contains(n.Id)).ToList();
foreach (var item in List)
{
item.Cols = item.Cols + ",Items,UsersCard";
var itemList = JobItemList.Where(o => o.TNum == item.TNum).ToList();
var JobItemModelList = itemList.GroupBy(o => o.RunTime.Date, (x, o) => new JobItemModel
{
date = x,
item = o.OrderBy(k => k.RunType).ToList().EntityToJson(),
}).OrderBy(o => o.date).ToList();
item.Items = JobItemModelList.EntityToJson();
var UserCard = UserCardList.FirstOrNew(o => o.Id == item.UserCardId);
string UserCardStr = UserCard.OutJson();
JObject JS = new JObject();
try
{
JS = (JObject)JsonConvert.DeserializeObject(UserCardStr);
}
catch (Exception Ex)
{
Log.Write("[JobOrders]:", "【JsStr】" + UserCardStr, Ex);
}
item.UsersCard = JS;
}
IList <JobOrders> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
string data = sb.ToString();
data = data.Replace("\"[{", "[{").Replace("}]\"", "}]").Replace("\\", "").Replace("]\"}", "]}");
DataObj.Data = data;
DataObj.Code = "0000";
DataObj.OutString();
}
public FileResult ExcelExport(FastOrder FastOrder, EFPagingInfo <FastOrder> p, bool?IsShowSupAgent)
{
p.PageSize = 9999999;
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
p = this.Condition(FastOrder, p, IsShowSupAgent.Value);
IPageOfItems <FastOrder> FastOrderList = Entity.Selects <FastOrder>(p);
List <int> UId = FastOrderList.Select(o => o.UId).Distinct().ToList();
//List<int> AgentIds = FastOrderList.Select(o => o.Agent).Distinct().ToList();
var UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList();
//var ResideSysAgentList = Entity.SysAgent.Where(n => AgentIds.Contains(n.Id)).ToList();
var FastPayWayList = Entity.FastPayWay.ToList();
var SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList();
DataTable table = new DataTable();
DataRow row = null;
// 创建 datatable
table.Columns.Add(new DataColumn("交易号", typeof(string)));
table.Columns.Add(new DataColumn("交易商户", typeof(string)));
table.Columns.Add(new DataColumn("总金额", typeof(decimal)));
table.Columns.Add(new DataColumn("手续费", typeof(decimal)));
table.Columns.Add(new DataColumn("分润", typeof(decimal)));
table.Columns.Add(new DataColumn("成本费率‰", typeof(decimal)));
table.Columns.Add(new DataColumn("成本费用(交易)", typeof(decimal)));
table.Columns.Add(new DataColumn("成本费用(代付)", typeof(decimal)));
table.Columns.Add(new DataColumn("用户费率‰", typeof(decimal)));
table.Columns.Add(new DataColumn("用户费用", typeof(decimal)));
table.Columns.Add(new DataColumn("利润", typeof(decimal)));
table.Columns.Add(new DataColumn("交易类型", typeof(string)));
table.Columns.Add(new DataColumn("交易时间", typeof(string)));
table.Columns.Add(new DataColumn("交易状态", typeof(string)));
table.Columns.Add(new DataColumn("用户结算", typeof(string)));
table.Columns.Add(new DataColumn("代理结算", typeof(string)));
table.Columns.Add(new DataColumn("支付通道", typeof(string)));
table.Columns.Add(new DataColumn("支付时间", typeof(string)));
table.Columns.Add(new DataColumn("分支机构", typeof(string)));
table.Columns.Add(new DataColumn("同级分润", typeof(decimal)));
// 填充数据
foreach (var item in FastOrderList)
{
var AgentPathArr = item.AgentPath.Split('|').ToList();
AgentPathArr.RemoveAll(o => o == string.Empty);
string TopAgentName = "";
if (AgentPathArr.Count > 0)
{
int AgentID = 0;
if (int.TryParse(AgentPathArr[0], out AgentID))
{
TopAgentName = SysAgentList.FirstOrNew(o => o.Id == AgentID).Name;
}
}
row = table.NewRow();
row[0] = item.TNum;
row[1] = UsersList.FirstOrNew(o => o.Id == item.UId).TrueName;
row[2] = item.Amoney.ToString("F2");
row[3] = item.Poundage.ToString("F2");
row[4] = item.AgentPayGet.ToString("F2");
row[5] = (item.SysRate * 1000).ToString("F2");
row[6] = (item.SysRate * item.Amoney).Floor().ToString("F2");
row[7] = item.SysCash.ToString("F2");
row[8] = (item.UserRate * 1000).ToString("F2");
row[9] = item.UserCash.ToString("F2");
row[10] = item.HFGet.ToString("F2");
row[11] = Utils.GetFastOrderModel().FirstOrNew(n => n.Id == item.OType).Name;
row[12] = item.AddTime.ToString("yyyy-MM-dd HH:mm");
row[13] = item.GetState();
row[14] = item.GetUserClearingState();
row[15] = item.GetAgentClearingState();
row[16] = FastPayWayList.FirstOrNew(o => o.Id == item.PayWay).Title;
row[17] = item.PayTime.HasValue ? item.PayTime.Value.ToString("yyyy-MM-dd HH:mm") : "";
row[18] = TopAgentName;
row[19] = item.SameGet.ToString("F2");
table.Rows.Add(row);
}
return(this.ExportExcelBase(table, "收付直通车"));
}
public ActionResult XLSDo(OrderProfitLog OrderProfitLog, EFPagingInfo <OrderProfitLog> p)
{
p.SqlWhere.Add(f => f.LogType == 3);
if (!OrderProfitLog.TNum.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TNum == OrderProfitLog.TNum);
}
if (!OrderProfitLog.LogType.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.LogType == OrderProfitLog.LogType);
}
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);
}
p.PageSize = 999999;
p.OrderByList.Add("Id", "DESC");
IPageOfItems <OrderProfitLog> OrderProfitLogList = null;
OrderProfitLogList = Entity.Selects <OrderProfitLog>(p);
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();
DataTable table = new DataTable();
DataRow row = null;
// 创建 datatable
table.Columns.Add(new DataColumn("交易号", typeof(string)));
table.Columns.Add(new DataColumn("交易商户", typeof(string)));
table.Columns.Add(new DataColumn("交易类型", typeof(string)));
table.Columns.Add(new DataColumn("交易金额", typeof(string)));
table.Columns.Add(new DataColumn("分润金额", typeof(string)));
table.Columns.Add(new DataColumn("分润时间", typeof(string)));
table.Columns.Add(new DataColumn("代理商名称", typeof(string)));
table.Columns.Add(new DataColumn("代理商层级", typeof(string)));
string state = "";
//订单按照支付时间排序
foreach (var item in OrderProfitLogList)
{
Users Users = UsersList.FirstOrNew(n => n.Id == item.UId);
SysAgent SysAgent = AgentList.FirstOrNew(o => o.Id == item.Agent);
if (item.OrderType == 21)
{
state = "直通车交易";
}
else if (item.OrderType == 10)
{
state = "自助开通代理";
}
else if (item.OrderType == 31)
{
state = "刷还交易";
}
row = table.NewRow();
row[0] = item.TNum;
row[1] = Users.TrueName;
row[2] = state;
row[3] = item.Amoney;
row[4] = item.Profit;
row[5] = item.AddTime.ToString("yyyy-MM-dd HH:mm");
row[6] = SysAgent.Name;
row[7] = item.Tier + "级";
table.Rows.Add(row);
}
string Time = DateTime.Now.ToString("yyyyMMddHHmmss") + new Random().Next(10, 99);
return(this.ExportExcelBase(table, "同级分润明细-" + Time));
}
