public void PayCashDo(string List)
{
string[] Arr = List.Split(',');
List <int> ArrInt = new List <int>();
if (Arr.Length > 0)
{
foreach (string p in Arr)
{
ArrInt.Add(Int32.Parse(p));
}
}
else
{
Response.Write("{\"id\":0\"same\":0,\"success\":0,\"fail\":0}");
return;
}
IList <OrderCash> OrderCashList = Entity.OrderCash.Where(n => ArrInt.Contains(n.Id)).ToList();
TaskCash TaskCash = new TaskCash();
TaskCash.State = 0;
TaskCash.AddTime = DateTime.Now;
TaskCash.Total = OrderCashList.Count();
TaskCash.Success = 0;
TaskCash.Fail = 0;
Entity.TaskCash.AddObject(TaskCash);
Entity.SaveChanges();
int suc = 0;
int fa = 0;
int same = 0;
foreach (var O in OrderCashList)
{
if (O.PayState == 1 && O.OrderState == 2)
{
TaskCashInfo TaskCashInfo = Entity.TaskCashInfo.FirstOrDefault(n => n.OId == O.OId);
if (TaskCashInfo == null)
{
TaskCashInfo = new TaskCashInfo();
TaskCashInfo.OId = O.OId;
TaskCashInfo.TId = TaskCash.Id;
TaskCashInfo.State = 0;
TaskCashInfo.OState = 0;
TaskCashInfo.NState = 0;
TaskCashInfo.AddTime = DateTime.Now;
Entity.TaskCashInfo.AddObject(TaskCashInfo);
suc++;
}
else
{
same++;
}
}
else
{
fa++;
}
}
TaskCash.Total = suc;
Entity.SaveChanges();
System.Web.HttpContext.Current.Response.AddHeader("content-type", "application/json");
Response.Write("{\"id\":" + TaskCash.Id + ",\"same\":" + same + ",\"success\":" + suc + ",\"fail\":" + fa + "}");
}
public void PayCash(OrderCash OrderCash, EFPagingInfo <OrderCash> p, bool?IsShowSupAgent)
{
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
p.PageSize = 99999999;
p.SqlWhere.Add(f => f.OrderState == 2);
p.SqlWhere.Add(f => f.PayState == 1 || f.PayState == 2);
if (OrderCash.AddTime.IsNullOrEmpty())
{
OrderCash.AddTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
}
if (OrderCash.FTime.IsNullOrEmpty())
{
OrderCash.FTime = DateTime.Now;
}
if (!OrderCash.Owner.IsNullOrEmpty())
{
IList <Users> UList = Entity.Users.Where(n => n.TrueName.Contains(OrderCash.Owner) || n.NeekName.Contains(OrderCash.Owner) || n.UserName == OrderCash.Owner).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 (!OrderCash.Cash.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Amoney >= OrderCash.Cash);
}
if (!OrderCash.ECash.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Amoney <= OrderCash.ECash);
}
if (!OrderCash.OId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.OId == OrderCash.OId);
}
if (!OrderCash.Agent.IsNullOrEmpty())
{
//是否要显示下级
if ((bool)IsShowSupAgent)
{
SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == OrderCash.Agent).FirstOrNew();
IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity);
IList <int> UID = new List <int>();
foreach (var s in SysAgentList)
{
UID.Add(s.Id);
}
p.SqlWhere.Add(f => UID.Contains(f.Agent));
}
else
{
p.SqlWhere.Add(f => f.Agent == OrderCash.Agent);
}
}
if (!OrderCash.FState.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.FState == (OrderCash.FState == 99 ? 0 : OrderCash.FState));
}
if (!OrderCash.TrunType.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TrunType == (OrderCash.TrunType == 99 ? 0 : OrderCash.TrunType));
}
if (!OrderCash.AId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AId == OrderCash.AId);
}
if (!OrderCash.FId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.FId == OrderCash.FId);
}
if (!OrderCash.AgentState.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AgentState == OrderCash.AgentState);
}
if (!OrderCash.AddTime.IsNullOrEmpty() && !OrderCash.FTime.IsNullOrEmpty())
{
// DateTime FTime = ((DateTime)OrderCash.FTime).AddDays(1);
DateTime FTime = OrderCash.FTime.Value;
p.SqlWhere.Add(f => f.AddTime > OrderCash.AddTime && f.AddTime < FTime);
}
p.OrderByList.Add("Id", "ASC");
IPageOfItems <OrderCash> OrderCashList = Entity.Selects <OrderCash>(p);
TaskCash TaskCash = new TaskCash();
TaskCash.State = 0;
TaskCash.AddTime = DateTime.Now;
TaskCash.Total = OrderCashList.Count();
TaskCash.Success = 0;
TaskCash.Fail = 0;
Entity.TaskCash.AddObject(TaskCash);
Entity.SaveChanges();
int suc = 0;
int fa = 0;
int same = 0;
foreach (var O in OrderCashList)
{
if (O.PayState == 1 && O.OrderState == 2)
{
TaskCashInfo TaskCashInfo = Entity.TaskCashInfo.FirstOrDefault(n => n.OId == O.OId);
if (TaskCashInfo == null)
{
TaskCashInfo = new TaskCashInfo();
TaskCashInfo.OId = O.OId;
TaskCashInfo.TId = TaskCash.Id;
TaskCashInfo.State = 0;
TaskCashInfo.OState = 0;
TaskCashInfo.NState = 0;
TaskCashInfo.AddTime = DateTime.Now;
Entity.TaskCashInfo.AddObject(TaskCashInfo);
suc++;
}
else
{
same++;
}
}
else
{
fa++;
}
}
TaskCash.Total = suc;
Entity.SaveChanges();
System.Web.HttpContext.Current.Response.AddHeader("content-type", "application/json");
Response.Write("{\"id\":" + TaskCash.Id + ",\"same\":" + same + ",\"success\":" + suc + ",\"fail\":" + fa + "}");
}