/// <summary>
/// 统计
/// </summary>
/// <returns></returns>
public ActionResult IndexStats(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;
}
p.PageSize = 9999999;
p = this.Condition(OrderProfitLog, p, TName, STime, ETime, IsShowSupAgent);
IPageOfItems <OrderProfitLog> OrderProfitLogList = Entity.Selects <OrderProfitLog>(p);
ViewBag.SumAmoney = OrderProfitLogList.Sum(o => o.Amoney);
ViewBag.SumProfit = OrderProfitLogList.Sum(o => o.Profit);
ViewBag.Count = OrderProfitLogList.ToList().Count;
return(this.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("[Orders]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
Orders Orders = new Orders();
Orders = JsonToObject.ConvertJsonToModel(Orders, json);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == Orders.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
//DataObj.OutError("2006");
//return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
//DataObj.OutError("2008");
//return;
}
EFPagingInfo <Orders> p = new EFPagingInfo <Orders>();
if (!Orders.Pg.IsNullOrEmpty())
{
p.PageIndex = Orders.Pg;
}
if (!Orders.Pgs.IsNullOrEmpty())
{
p.PageSize = Orders.Pgs;
}
if (!Orders.STime.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AddTime >= Orders.STime);
}
if (!Orders.ETime.IsNullOrEmpty())
{
Orders.ETime = Orders.ETime.AddHours(24);
p.SqlWhere.Add(f => f.AddTime <= Orders.ETime);
}
if (!Orders.IdCardState.IsNullOrEmpty())
{//凭证状态
if (Orders.IdCardState == 99)
{
p.SqlWhere.Add(f => f.IdCardState == 0);
}
else if (Orders.IdCardState == 98)
{
p.SqlWhere.Add(f => f.IdCardState == 1 || f.IdCardState == 2 || f.IdCardState == 4);
}
else
{
p.SqlWhere.Add(f => f.IdCardState == Orders.IdCardState);
}
}
bool IsOld = true;
#region 版本比较 升级之后比较长时间后可以考滤删除版本判断代码
//处理贴牌相关
var SysAgent = this.Entity.SysAgent.FirstOrDefault(o => o.Id == baseUsers.Agent);
if (SysAgent == null)
{
DataObj.OutError("1000");
return;
}
var topSysAgent = SysAgent.GetTopAgent(this.Entity);
if (!Equipment.SoftVer.IsNullOrEmpty())
{
Version v1 = new Version(Equipment.SoftVer);//当前版本
Version v2 = new Version("1.0");
if (Equipment.RqType.ToLower() == "apple")
{
//苹果
if (topSysAgent.IsTeiPai == 0)//好付
{
v2 = new Version("8.0");
}
else//贴牌
{
v2 = new Version("6.0");
}
}
else if (Equipment.RqType.ToLower() == "android")
{
//安卓
if (topSysAgent.IsTeiPai == 0)//好付
{
v2 = new Version("8.0.0");
}
else //贴牌
{
v2 = new Version("6.0");
}
}
if (v1 >= v2)
{
IsOld = false;
}
}
#endregion
if (!IsOld)//新版
{
#region 4.0条件判断
if (!(Orders.TType == 3 && Orders.TState == 3))
{
p.SqlWhere.Add(o => o.UId == baseUsers.Id);
}
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.PayState == 1 && f.IdCardState == 1);
break;
case 4: //待审核/已传证照
p.SqlWhere.Add(f => f.PayState == 1 && f.IdCardState == 2);
break;
case 5: //审核失败
p.SqlWhere.Add(f => 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)
{
switch (Orders.TState)
{
case 1: //处理中
p.SqlWhere.Add(f => f.TState == 1);
break;
case 2: //已汇出
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 2);
break;
case 3: //提现失败
p.SqlWhere.Add(f => f.TState == 3);
break;
case 4: //出款中
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 1);
break;
case 5: //退款
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 4);
break;
case 6: //退款中
p.SqlWhere.Add(f => f.TState == 2 && f.PayState == 3);
break;
}
}
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 == 2 && f.PayState == 1 && f.RUId == baseUsers.Id);
break;
}
}
if (Orders.TType == 6)
{
if (!Orders.TState.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.TState == Orders.TState);
}
}
if (Orders.TType == 7 || Orders.TType == 8)
{
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.PayState == 1 && f.InState == 1 && f.IdCardState == 2);
}
if (Orders.TState == 6)//待传证照
{
p.SqlWhere.Add(f => f.PayState == 1 && f.InState == 1 && f.IdCardState == 1);
}
if (Orders.TState == 7)//审核失败
{
p.SqlWhere.Add(f => f.PayState == 1 && f.InState == 1 && f.IdCardState == 4);
}
}
}
}
else
{
if (!Orders.TState.IsNullOrEmpty())
{
if (Orders.TState == 99)
{
p.SqlWhere.Add(f => f.TState == 0);
}
if (Orders.TState == 1)
{
p.SqlWhere.Add(f => f.PayState == 1);
}
if (Orders.TState == 2)
{
p.SqlWhere.Add(f => f.PayState == 0 && f.TState != 0);
}
}
}
#endregion
}
else
{
#region 4.0之前条件判断
//搜索
if (Orders.TType.IsNullOrEmpty())
{//不限类型，读取收支交易，收款订单只显示已支付订单
p.SqlWhere.Add(f => f.UId == baseUsers.Id || (f.RUId == baseUsers.Id && f.PayState == 1) && f.TType != 2);
}
else
{
if (Orders.TType == 4)
{
//已支付收款订单
p.SqlWhere.Add(f => f.TType == 3);
p.SqlWhere.Add(f => f.RUId == baseUsers.Id && f.PayState == 1);
}
else if (Orders.TType == 95)
{ //转帐单
p.SqlWhere.Add(f => f.TType == 3);
p.SqlWhere.Add(f => (f.RUId == baseUsers.Id && f.PayState == 1) || f.UId == baseUsers.Id);
}
else if (Orders.TType == 96) //收款订单
{
p.SqlWhere.Add(f => (f.TType == 3 && f.RUId == baseUsers.Id && f.PayState == 1) || (f.TType == 1 && f.UId == baseUsers.Id));
}
else
{
p.SqlWhere.Add(f => f.TType == Orders.TType);
p.SqlWhere.Add(f => f.UId == baseUsers.Id);
}
}
if (!Orders.TState.IsNullOrEmpty()) //交易状态
{
p.SqlWhere.Add(f => f.TState == Orders.TState);
}
if (!Orders.PayState.IsNullOrEmpty()) //支付状态
{
if (Orders.PayState == 99)
{
Orders.PayState = 0;
}
p.SqlWhere.Add(f => f.PayState == Orders.PayState);
}
#endregion
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <Orders> List = Entity.Selects <Orders>(p);
//处理转帐订单
foreach (var pp in List)
{
pp.Cols = pp.Cols + ",Json,PicList,UserCardName,CardUpdateTime";
if (baseUsers.Id == pp.RUId)
{
pp.TType = 4;
}
JObject JS = new JObject();
if (pp.TType == 1)
{ //银联卡支付
OrderRecharge OrderRecharge = Entity.OrderRecharge.FirstOrNew(n => n.OId == pp.TNum);
OrderRecharge.Cols = "Amoney,PayMoney,Poundage,PayType";
string JsStr = OrderRecharge.OutJson();
try
{
JS = (JObject)JsonConvert.DeserializeObject(JsStr);
}
catch (Exception Ex)
{
Log.Write("[Order]:", "【JsStr】" + JsStr, Ex);
}
pp.Json = JS;
}
if (pp.TType == 2)//提现不能取消
{
OrderCash OrderCash = Entity.OrderCash.FirstOrNew(n => n.OId == pp.TNum);
OrderCash.Cols = "Owner,Bank,CardNum,Deposit,Mobile,Province,City,District,Amoney,UserRate,TrunType,PayMoney";
OrderCash.PayMoney = OrderCash.Amoney - (decimal)OrderCash.UserRate;
string JsStr = OrderCash.OutJson();
try
{
JS = (JObject)JsonConvert.DeserializeObject(JsStr);
}
catch (Exception Ex)
{
Log.Write("[Order]:", "【JsStr】" + JsStr, Ex);
}
pp.Json = JS;
}
if (pp.TType == 3 || pp.TType == 4)//付款
{
OrderTransfer OrderTransfer = Entity.OrderTransfer.FirstOrNew(n => n.OId == pp.TNum);
Users Users = new Users();
if (pp.TType == 4)
{
Users = Entity.Users.FirstOrNew(n => n.Id == OrderTransfer.UId);
}
if (pp.TType == 3)
{
Users = Entity.Users.FirstOrNew(n => n.Id == OrderTransfer.RUId);
}
OrderTransfer.Mobile = Users.UserName;
OrderTransfer.ToUserName = Users.TrueName;
OrderTransfer.Cols = "UId,RUId,PayMoney,Poundage,Amoney,Mobile,ToUserName";
string JsStr = OrderTransfer.OutJson();
try
{
JS = (JObject)JsonConvert.DeserializeObject(JsStr);
}
catch (Exception Ex)
{
Log.Write("[Order]:", "【JsStr】" + JsStr, Ex);
}
pp.Json = JS;
}
if (pp.TType == 5)//防租
{
OrderHouse OrderHouse = Entity.OrderHouse.FirstOrNew(n => n.OId == pp.TNum);
OrderHouse.Cols = "HouseOwner,Bank,CardNum,Deposit,Mobile,MonthRent,SecurityMoney,PayMonth,Poundage,Amoney";
string JsStr = OrderHouse.OutJson();
try
{
JS = (JObject)JsonConvert.DeserializeObject(JsStr);
}
catch (Exception Ex)
{
Log.Write("[Order]:", "【JsStr】" + JsStr, Ex);
}
pp.Json = JS;
}
if (pp.TType == 6)
{ //升级
//PayConfigOrder PayConfigOrder = Entity.PayConfigOrder.FirstOrNew(n => n.OId == pp.TNum);
//Out = Out + "," + PayConfigOrder.ToStr();
pp.Poundage = 0;
}
if (pp.TType == 7 || pp.TType == 8 || pp.TType == 9)
{ //扫码
OrderF2F OrderF2F = Entity.OrderF2F.FirstOrNew(n => n.OId == pp.TNum);
OrderF2F.Cols = "Amoney,PayMoney,Poundage";
string JsStr = OrderF2F.OutJson();
try
{
JS = (JObject)JsonConvert.DeserializeObject(JsStr);
}
catch (Exception Ex)
{
Log.Write("[Order]:", "【JsStr】" + JsStr, Ex);
}
pp.Json = JS;
}
if (pp.TType == 10)
{//代理
}
pp.DoRemark(Entity);
pp.StateTxt = pp.GetState();
if (pp.RUId == baseUsers.Id && pp.PayState == 1)
{
pp.StateTxt = "已收";
}
if (pp.IdCardState > 1)
{
pp.Remark = pp.DDAuditRemark;
}
if (!pp.Remark.IsNullOrEmpty())
{
pp.Remark = pp.Remark.Replace("\t", "");
}
if (!pp.UserCardPic.IsNullOrEmpty())
{
var UserCardPicList = pp.UserCardPic.Split(',').ToList();
for (int i = 0; i < UserCardPicList.Count; i++)
{
var a = Utils.ImageUrl("Orders", UserCardPicList[i], AppImgPath);
UserCardPicList[i] = a;
}
JavaScriptSerializer JSS = new JavaScriptSerializer();
string data = JSS.Serialize(UserCardPicList);
JArray JO = (JArray)JsonConvert.DeserializeObject(data);
pp.PicList = JO;
}
}
IList <OrdersModel> OML = Utils.GetOrdersModel();
OML = OML.Where(n => n.Id != 10).ToList();
foreach (var P in OML)
{
if (P.Id == 3)
{
P.Id = 95;
}
}
IList <Orders> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append(",");
sb.Append(OML.EntityToString());
sb.Append(",\"state\":{");
sb.Append("\"0\":[{\"key\":\"交易关闭\",\"value\":\"99\"},{\"key\":\"已付\",\"value\":\"1\"},{\"key\":\"未付\",\"value\":\"2\"}],");
sb.Append("\"1\":[{\"key\":\"未付\",\"value\":\"1\"},{\"key\":\"已付\",\"value\":\"2\"},{\"key\":\"待传证照\",\"value\":\"3\"},{\"key\":\"已传证照\",\"value\":\"4\"},{\"key\":\"审核失败\",\"value\":\"5\"},{\"key\":\"退单\",\"value\":\"6\"},{\"key\":\"待入账\",\"value\":\"7\"}],");
sb.Append("\"2\":[{\"key\":\"处理中\",\"value\":\"1\"},{\"key\":\"已汇出\",\"value\":\"2\"},{\"key\":\"提现失败\",\"value\":\"3\"},{\"key\":\"出款中\",\"value\":\"4\"},{\"key\":\"已退款\",\"value\":\"5\"},{\"key\":\"退款中\",\"value\":\"6\"}],");
sb.Append("\"3\":[{\"key\":\"未付\",\"value\":\"1\"},{\"key\":\"已付\",\"value\":\"2\"},{\"key\":\"已收\",\"value\":\"3\"}],");
sb.Append("\"6\":[{\"key\":\"交易关闭\",\"value\":\"99\"},{\"key\":\"未付\",\"value\":\"1\"},{\"key\":\"已付\",\"value\":\"2\"}],");
sb.Append("\"7\":[{\"key\":\"交易关闭\",\"value\":\"99\"},{\"key\":\"进行中\",\"value\":\"1\"},{\"key\":\"已付\",\"value\":\"2\"},{\"key\":\"退单\",\"value\":\"3\"},{\"key\":\"待入账\",\"value\":\"4\"},{\"key\":\"已传证照\",\"value\":\"5\"},{\"key\":\"待传证照\",\"value\":\"6\"},{\"key\":\"审核失败\",\"value\":\"7\"}],");
sb.Append("\"8\":[{\"key\":\"交易关闭\",\"value\":\"99\"},{\"key\":\"进行中\",\"value\":\"1\"},{\"key\":\"已付\",\"value\":\"2\"},{\"key\":\"退单\",\"value\":\"3\"},{\"key\":\"待入账\",\"value\":\"4\"},{\"key\":\"已传证照\",\"value\":\"5\"},{\"key\":\"待传证照\",\"value\":\"6\"},{\"key\":\"审核失败\",\"value\":\"7\"}]");
sb.Append("},");
sb.Append("\"type\":[{\"key\":\"0\",\"value\":\"全部\"},{\"key\":\"1\",\"value\":\"银联卡支付\"},{\"key\":\"2\",\"value\":\"提现\"},{\"key\":\"3\",\"value\":\"转账\"},{\"key\":\"6\",\"value\":\"升级\"},{\"key\":\"7\",\"value\":\"支付宝\"},{\"key\":\"8\",\"value\":\"微信\"}]");
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[ApplyLoan]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
ApplyLoan ApplyLoan = new ApplyLoan();
ApplyLoan = JsonToObject.ConvertJsonToModel(ApplyLoan, json);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == ApplyLoan.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
EFPagingInfo <ApplyLoan> p = new EFPagingInfo <ApplyLoan>();
if (!ApplyLoan.Pg.IsNullOrEmpty())
{
p.PageIndex = ApplyLoan.Pg;
}
if (!ApplyLoan.Pgs.IsNullOrEmpty())
{
p.PageSize = ApplyLoan.Pgs;
}
p.SqlWhere.Add(f => f.UId == baseUsers.Id);
p.SqlWhere.Add(f => f.State > 0);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyLoan> List = Entity.Selects <ApplyLoan>(p);
IList <ApplyLoan> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[Users]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
Users Users = new Users();
Users = JsonToObject.ConvertJsonToModel(Users, json);
//获取用户信息
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == Users.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
if (Users.UserType != 1 && Users.UserType != 2)
{
DataObj.OutError("9002");
return;
}
//判断是否为代理商
SysAgent SysAgent = Entity.SysAgent.FirstOrDefault(o => o.LinkMobile == baseUsers.UserName && o.State == 1);
IList <SysAgent> SysAgentList = null;
IList <Users> UsersList = null;
SysSet baseSysSet = Entity.SysSet.FirstOrDefault();
//1用户2代理商
if (SysAgent == null && Users.UserType == 2)
{
DataObj.OutError("9003");
return;
}
//if (Users.UserType == 1 && SysAgent!=null)
//{
// UsersList = baseUsers.GetSupUsers(Entity, baseSysSet.GlobaPromoteMaxLevel);
// SysAgentList = SysAgent.GetSupAgent(Entity);
// IList<int> agents = SysAgentList.Select(o => o.Id).ToList();
// IList<Users> AgentUsersList = Entity.Users.Where(o => agents.Contains(o.Agent)).ToList();
// UsersList = UsersList.Concat(AgentUsersList).ToList();
//}
if (Users.UserType == 1)
{
UsersList = baseUsers.GetSupUsers(Entity, baseSysSet.GlobaPromoteMaxLevel);
}
if (Users.UserType == 2)
{
SysAgentList = SysAgent.GetSupAgent(Entity);
//IList<int> agents = SysAgentList.Select(o => o.Id).ToList();
//UsersList = Entity.Users.Where(o => agents.Contains(o.Agent)).ToList();
IList <string> agents = SysAgentList.Select(o => o.LinkMobile).ToList();
UsersList = Entity.Users.Where(o => agents.Contains(o.UserName)).ToList();
}
EFPagingInfo <Users> p = new EFPagingInfo <Users>();
if (!Users.Pg.IsNullOrEmpty())
{
p.PageIndex = Users.Pg;
}
if (!Users.Pgs.IsNullOrEmpty())
{
p.PageSize = Users.Pgs;
}
if (UsersList == null)
{
p.SqlWhere.Add(o => o.Id == 0);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <Users> List1 = Entity.Selects <Users>(p);
IList <Users> iList1 = List1.ToList();
StringBuilder sb1 = new StringBuilder("");
sb1.Append("{");
sb1.Append(List1.PageToString());
sb1.Append(",");
sb1.Append(iList1.EntityToString());
sb1.Append("}");
DataObj.Data = sb1.ToString();
DataObj.Code = "0000";
DataObj.OutString();
return;
}
IList <int> usersid = UsersList.Where(o => o.Id != baseUsers.Id).Select(o => o.Id).ToList();
p.SqlWhere.Add(f => usersid.Contains(f.Id));
p.SqlWhere.Add(f => f.Id != baseUsers.Id);
p.OrderByList.Add("Agent", "ASC");
IPageOfItems <Users> List = Entity.Selects <Users>(p);
IList <Users> iList = List.ToList();
foreach (var info in iList)
{
if (Users.UserType == 1)
{
if (info.MyPId != baseUsers.Id)
{
info.TrueName = info.TrueName.IsNullOrEmpty() ? "未认证" : info.TrueName.Substring(0, 1) + "**";
info.UserName = info.UserName.Substring(0, 3) + "****" + info.UserName.Substring(7, 4);
}
else
{
info.TrueName = info.TrueName.IsNullOrEmpty() ? "未认证" : info.TrueName;
}
}
if (Users.UserType == 2)
{
SysAgent agentTemp = Entity.SysAgent.FirstOrDefault(o => o.Id == info.Agent);
if (agentTemp == null || agentTemp.AgentID != SysAgent.Id)
{
info.TrueName = info.TrueName.IsNullOrEmpty() ? "未认证" : info.TrueName.Substring(0, 1) + "**";
info.UserName = info.UserName.Substring(0, 3) + "****" + info.UserName.Substring(7, 4);
}
else
{
info.TrueName = info.TrueName.IsNullOrEmpty() ? "未认证" : info.TrueName;
}
}
}
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[UserLog]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
UserLog UserLog = new UserLog();
UserLog = JsonToObject.ConvertJsonToModel(UserLog, json);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == UserLog.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
//DataObj.OutError("2006");
//return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
//DataObj.OutError("2008");
//return;
}
EFPagingInfo <UserLog> p = new EFPagingInfo <UserLog>();
if (!UserLog.Pg.IsNullOrEmpty())
{
p.PageIndex = UserLog.Pg;
}
if (!UserLog.Pgs.IsNullOrEmpty())
{
p.PageSize = UserLog.Pgs;
}
bool IsOld = true;
#region 版本比较
//处理贴牌相关
var SysAgent = this.Entity.SysAgent.FirstOrDefault(o => o.Id == baseUsers.Agent);
if (SysAgent == null)
{
DataObj.OutError("1000");
return;
}
var topSysAgent = SysAgent.GetTopAgent(this.Entity);
if (!Equipment.SoftVer.IsNullOrEmpty())
{
Version v1 = new Version(Equipment.SoftVer);//当前版本
Version v2 = new Version("1.0");
if (Equipment.RqType.ToLower() == "apple")
{
//苹果
if (topSysAgent.IsTeiPai == 0)//好付
{
v2 = new Version("8.0");
}
else//贴牌
{
v2 = new Version("6.0");
}
}
else if (Equipment.RqType.ToLower() == "android")
{
//安卓
if (topSysAgent.IsTeiPai == 0)//好付
{
v2 = new Version("8.0.0");
}
else //贴牌
{
v2 = new Version("6.0");
}
}
if (v1 >= v2)
{
IsOld = false;
}
}
#endregion
IPageOfItems <UserLog> List = null;
if (!IsOld)//新版
{
p.SqlWhere.Add(f => f.UId == baseUsers.Id && f.OType != 4);
var three = new int[] { 3, 5 };
var five = new int[] { 6, 7, 9, 10, 11, 12 };
switch (UserLog.OType)
{
case 1:
p.SqlWhere.Add(o => o.OType == 1);
break;
case 2:
p.SqlWhere.Add(o => o.OType == 2);
break;
case 3:
p.SqlWhere.Add(o => three.Contains(o.OType));
break;
case 4:
p.SqlWhere.Add(o => o.OType == 8);
break;
case 5:
p.SqlWhere.Add(o => five.Contains(o.OType));
break;
case 6:
p.SqlWhere.Add(o => o.OType == 15);
break;
}
p.OrderByList.Add("Id", "DESC");
List = Entity.Selects <UserLog>(p);
}
else//旧版
{
p.SqlWhere.Add(f => f.UId == baseUsers.Id && f.OType != 4);
//搜索
if (!UserLog.OType.IsNullOrEmpty())
{
if (UserLog.OType == 5)
{
p.SqlWhere.Add(f => f.OType == UserLog.OType || f.OType == 6 || f.OType == 11);
}
else if (UserLog.OType == 4)
{
p.SqlWhere.Add(f => f.OType == 8);
}
else if (UserLog.OType == 6)
{
IList <String> OrderList = Entity.OrderProfitLog.Where(o => o.UId == baseUsers.Id && o.LogType == 3).Select(o => o.TNum).ToList();
p.SqlWhere.Add(f => OrderList.Contains(f.OId));
}
else
{
p.SqlWhere.Add(f => f.OType == UserLog.OType);
}
}
p.OrderByList.Add("Id", "DESC");
List = Entity.Selects <UserLog>(p);
//处理转帐订单
foreach (var pp in List)
{
if (pp.OType == 6)
{
pp.OType = 5;
}
if (pp.OType == 12 || pp.OType == 11)
{
pp.OType = 2;
}
//pp.DoRemark(Entity);
if (pp.OType == 8)
{
OrderProfitLog OrderProfitLog = Entity.OrderProfitLog.FirstOrDefault(o => o.UId == pp.UId && o.TNum == pp.OId);
if (OrderProfitLog != null)
{
pp.ProfitName = OrderProfitLog.GetProfitName(Entity).ProfitName;
}
}
}
}
IList <UserLog> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[FastOrders]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
FastOrder FastOrder = new FastOrder();
FastOrder = JsonToObject.ConvertJsonToModel(FastOrder, json);
//var ford = this.Entity.FastOrder.FirstOrDefault(o => o.TNum == "20170606_01_0000024928");
//if (ford != null)
//{
// FastOrderExtensions.PushMsg(ford, this.Entity);
//}
//var Ord = new Orders()
//{
// Id = 5555,
// TState =1,
// TType = 8,
// TNum = "20170625111111111111",
// Amoney = 50,
// Poundage = 8,
// AddTime = DateTime.Now,
// ComeWay = 1,
// UId = 566,
// PayState = 1,
// IdCardState = 0,
//};
//Ord.SendMsg(this.Entity);
//System.Threading.Thread.Sleep(1000 * 60 * 1);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == FastOrder.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
EFPagingInfo <FastOrder> p = new EFPagingInfo <FastOrder>();
if (!FastOrder.Pg.IsNullOrEmpty())
{
p.PageIndex = FastOrder.Pg;
}
if (!FastOrder.Pgs.IsNullOrEmpty())
{
p.PageSize = FastOrder.Pgs;
}
p.SqlWhere.Add(f => f.UId == baseUsers.Id);
//搜索
if (!FastOrder.OType.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.OType == FastOrder.OType);
}
if (!FastOrder.State.IsNullOrEmpty())
{
switch (FastOrder.State)
{
case 1:
p.SqlWhere.Add(f => f.State == 1 && f.PayState == 0);
break;
case 2:
p.SqlWhere.Add(f => f.State == 1 && f.PayState == 1);
break;
case 3:
p.SqlWhere.Add(f => f.State == 1 && f.PayState == 1 && f.UserState == 0);
break;
case 4:
p.SqlWhere.Add(f => f.State == 1 && f.PayState == 1 && f.UserState == 1);
break;
}
}
if (!FastOrder.STime.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.AddTime >= FastOrder.STime);
}
if (!FastOrder.ETime.IsNullOrEmpty())
{
FastOrder.ETime = FastOrder.ETime.AddHours(24);
p.SqlWhere.Add(f => f.AddTime <= FastOrder.ETime);
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <FastOrder> List = Entity.Selects <FastOrder>(p);
//处理转帐订单
foreach (var pp in List)
{
if (pp.State == 1)
{
if (pp.PayState == 1)
{
if (pp.UserState == 1)
{
pp.State = 3;
}
else
{
pp.State = 2;
}
}
else
{
pp.State = 1;
}
}
else
{
pp.State = 0;
}
}
IList <FastOrder> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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 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("[MsgCallBack]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
MsgCallBack MsgCallBack = new MsgCallBack();
MsgCallBack = JsonToObject.ConvertJsonToModel(MsgCallBack, json);
if (MsgCallBack.Name.IsNullOrEmpty())
{
MsgCallBack.Name = "1.0";
}
if (MsgCallBack.Name != "2.0")
{
MsgCallBack.Name = "1.0";
}
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == MsgCallBack.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
EFPagingInfo <MsgCallBack> p = new EFPagingInfo <MsgCallBack>();
if (MsgCallBack.Pg.IsNullOrEmpty())
{
MsgCallBack.Pg = 1;
}
if (!MsgCallBack.Pg.IsNullOrEmpty())
{
p.PageIndex = MsgCallBack.Pg;
}
if (!MsgCallBack.Pgs.IsNullOrEmpty())
{
p.PageSize = MsgCallBack.Pgs;
}
p.SqlWhere.Add(f => f.UId == baseUsers.Id);
p.SqlWhere.Add(f => f.State > 0);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <MsgCallBack> List = Entity.Selects <MsgCallBack>(p);
IList <MsgCallBack> iList = new List <MsgCallBack>();
if (MsgCallBack.Name == "2.0")
{ //处理接口
var i = 1;
foreach (var item in List)
{
if (item.State == 2)
{
if (!item.Result.IsNullOrEmpty())
{
MsgCallBack Msg = new MsgCallBack();
Msg.Id = i;
Msg.Info = item.Result;
Msg.State = 2;
Msg.AddTime = (DateTime)item.EditTime;
Msg.Cols = "Info,State,AddTime";
iList.Add(Msg);
i++;
}
}
MsgCallBack msg = new MsgCallBack();
msg.Id = i;
msg.Info = item.Info;
msg.State = 1;
msg.AddTime = item.AddTime;
msg.Cols = "Info,State,AddTime";
iList.Add(msg);
i++;
}
if (List.TotalPage == MsgCallBack.Pg || List.TotalPage == 0)
{
MsgCallBack msg = new MsgCallBack();
msg.Id = i;
msg.Info = "您好，很高兴为您服务！";
msg.State = 2;
msg.AddTime = DateTime.Now;
msg.Cols = "Info,State,AddTime";
iList.Add(msg);
i++;
}
iList = iList.OrderByDescending(n => n.Id).ToList();
}
else
{
iList = List.ToList();
}
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
/// <summary>
/// 导出
/// </summary>
/// <param name="WTimes"></param>
public void XlsDo(UserLog UserLog, EFPagingInfo <UserLog> p, DateTime?STime, DateTime?ETime)
{
p.SqlWhere.Add(f => f.UId == UserLog.UId);
p.PageSize = 99999999;
if (!UserLog.OId.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.OId == UserLog.OId);
}
if (STime.HasValue)
{
p.SqlWhere.Add(f => f.AddTime >= STime);
}
if (ETime.HasValue)
{
if (ETime < new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day))
{
ETime = new DateTime(ETime.Value.Year, ETime.Value.Month, ETime.Value.Day, 23, 59, 59, 999);
}
//else
//{
// ETime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second, 999);
//}
p.SqlWhere.Add(f => f.AddTime <= ETime);
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <UserLog> UserLogList = Entity.Selects <UserLog>(p);
var UsersLogList = UserLogList.ToList();
if (UsersLogList == null || UsersLogList.Count <= 0)
{
Response.Write("暂无符合条件数据");
return;
}
string tempname = "UserLog.xlsx";
string file = Server.MapPath("/template") + "\\" + tempname;
ExcelPackage package = new ExcelPackage(new FileInfo(file), true);
var sheet = package.Workbook.Worksheets[1];
var cells = sheet.Cells;
int i = 3;
var typename = "";
//设置数据开始行
int Befor = 3;
foreach (var model in UsersLogList)
{
sheet.Row(i).Height = 20;//设置行高
cells["A" + i].Value = model.OId;
switch (model.OType)
{
case 1:
typename = "收款";
break;
case 2:
typename = "付款";
break;
case 3:
typename = "申请提现";
break;
case 4:
typename = "提现";
break;
case 5:
typename = "提现失败";
break;
case 6:
typename = "退款冲正";
break;
case 7:
typename = "奖金";
break;
case 8:
typename = "分润";
break;
case 9:
typename = "冻结";
break;
case 10:
typename = "解冻";
break;
case 11:
typename = "退款";
break;
case 12:
typename = "扣款";
break;
}
cells["B" + i].Value = typename;
cells["C" + i].Value = model.Amount;
cells["D" + i].Value = model.BeforAmount;
cells["E" + i].Value = model.BeforFrozen;
cells["F" + i].Value = model.AfterAmount;
cells["G" + i].Value = model.AfterFrozen;
cells["H" + i].Value = model.AddTime.ToString("yyyy-MM-dd HH:mm");
i++;
}
sheet.Cells[Befor, 3, i, 3].Style.Numberformat.Format = "#,##0.00";
sheet.Cells[Befor, 4, i, 4].Style.Numberformat.Format = "#,##0.00";
sheet.Cells[Befor, 5, i, 5].Style.Numberformat.Format = "#,##0.00";
sheet.Cells[Befor, 6, i, 6].Style.Numberformat.Format = "#,##0.00";
sheet.Cells[Befor, 7, i, 7].Style.Numberformat.Format = "#,##0.00";
Response.BinaryWrite(package.GetAsByteArray());//输出
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=余额变动明细表" + DateTime.Now.ToString("yyyyMMddHHmm") + ".xlsx");
}
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("[BaoList]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
BaoLog BaoLog = new BaoLog();
BaoLog = JsonToObject.ConvertJsonToModel(BaoLog, json);
if (BaoLog.Token.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
Users Users = Entity.Users.FirstOrDefault(n => n.Token == BaoLog.Token);
if (Users == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (Users.State != 1)
{
DataObj.OutError("2003");
return;
}
if (Users.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (Users.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
EFPagingInfo <BaoLog> p = new EFPagingInfo <BaoLog>();
if (!BaoLog.Pg.IsNullOrEmpty())
{
p.PageIndex = BaoLog.Pg;
}
if (!BaoLog.Pgs.IsNullOrEmpty())
{
p.PageSize = BaoLog.Pgs;
}
if (!BaoLog.LType.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.LType == BaoLog.LType);
}
p.SqlWhere.Add(f => f.UId == Users.Id);
p.SqlWhere.Add(f => f.LType == 1 || f.LType == 2 || f.LType == 3);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <BaoLog> List = Entity.Selects <BaoLog>(p);
foreach (var P in List)
{
if (P.LType == 1)
{
P.LTypeName = "转入";
}
if (P.LType == 2)
{
P.LTypeName = "转出";
}
if (P.LType == 3)
{
P.LTypeName = "收益";
}
}
IList <BaoLog> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[MsgHelp]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
MsgHelp MsgHelp = new MsgHelp();
MsgHelp = JsonToObject.ConvertJsonToModel(MsgHelp, json);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == MsgHelp.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
//DataObj.OutError("2006");
//return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
//DataObj.OutError("2008");
//return;
}
string url = SysImgPath + "/UpLoadFiles/MsgHelp/";
EFPagingInfo <MsgHelp> p = new EFPagingInfo <MsgHelp>();
if (!MsgHelp.Pg.IsNullOrEmpty())
{
p.PageIndex = MsgHelp.Pg;
}
if (!MsgHelp.Pgs.IsNullOrEmpty())
{
p.PageSize = MsgHelp.Pgs;
}
p.SqlWhere.Add(o => o.State == 1);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <MsgHelp> List = Entity.Selects <MsgHelp>(p);
IList <MsgHelp> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append(",\"imgpath\":\"" + url + "\"");
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[MsgNotice]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
MsgNotice MsgNotice = new MsgNotice();
MsgNotice = JsonToObject.ConvertJsonToModel(MsgNotice, json);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == MsgNotice.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
//if (baseUsers.CardStae != 2)//未实名认证
//{
// DataObj.OutError("2006");
// return;
//}
//if (baseUsers.MiBao != 1)//未设置支付密码
//{
// DataObj.OutError("2008");
// return;
//}
//下次改版让手机端传AgentId，这让有点伤性能，然后删除这条备注
SysAgent SysAgent = Entity.SysAgent.FirstOrNew(n => n.Id == baseUsers.Agent);
SysAgent = SysAgent.GetTopAgent(Entity);
EFPagingInfo <MsgNotice> p = new EFPagingInfo <MsgNotice>();
if (!MsgNotice.Pg.IsNullOrEmpty())
{
p.PageIndex = MsgNotice.Pg;
}
if (!MsgNotice.Pgs.IsNullOrEmpty())
{
p.PageSize = MsgNotice.Pgs;
}
p.SqlWhere.Add(f => f.NType == 0 || f.NType == 3);
p.SqlWhere.Add(f => f.State == 1 && f.AddTime > baseUsers.AddTime);
int AgentId = 999999999;
if (SysAgent.IsTeiPai == 1)
{
AgentId = SysAgent.Id;
}
p.SqlWhere.Add(f => f.AgentId == 0 || f.AgentId == AgentId);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <MsgNotice> List = Entity.Selects <MsgNotice>(p);
//处理以读未读
string UserId = string.Format("|{0}|", baseUsers.Id);
foreach (var pp in List)
{
pp.State = (byte)(pp.ReadUsers != null && pp.ReadUsers.IndexOf(UserId) == -1 ? 1 : 2);
if (pp.Info != null)
{
pp.Info = Utils.RemoveHtml(pp.Info);
pp.Info = pp.Info.Replace(" ", "");
}
}
IList <MsgNotice> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[OrderProfitLog]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
OrderProfitLog OrderProfitLog = new OrderProfitLog();
OrderProfitLog = JsonToObject.ConvertJsonToModel(OrderProfitLog, json);
//获取用户信息
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == OrderProfitLog.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
EFPagingInfo <OrderProfitLog> p = new EFPagingInfo <OrderProfitLog>();
if (!OrderProfitLog.Pg.IsNullOrEmpty())
{
p.PageIndex = OrderProfitLog.Pg;
}
if (!OrderProfitLog.Pgs.IsNullOrEmpty())
{
p.PageSize = OrderProfitLog.Pgs;
}
p.SqlWhere.Add(f => f.UId == baseUsers.Id && f.LogType == 1);
if (!OrderProfitLog.Tier.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Tier == OrderProfitLog.Tier);
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <OrderProfitLog> List = Entity.Selects <OrderProfitLog>(p);
IList <OrderProfitLog> iList = List.ToList();
foreach (var info in iList)
{
info.GetProfitName(Entity);
}
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
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("[MsgUser]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
MsgUser MsgUser = new MsgUser();
MsgUser = JsonToObject.ConvertJsonToModel(MsgUser, json);
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == MsgUser.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
//if (baseUsers.CardStae != 2)//未实名认证
//{
// DataObj.OutError("2006");
// return;
//}
//if (baseUsers.MiBao != 1)//未设置支付密码
//{
// DataObj.OutError("2008");
// return;
//}
string uid = string.Format(",{0},", baseUsers.Id);
EFPagingInfo <MsgUser> p = new EFPagingInfo <MsgUser>();
if (!MsgUser.Pg.IsNullOrEmpty())
{
p.PageIndex = MsgUser.Pg;
}
if (!MsgUser.Pgs.IsNullOrEmpty())
{
p.PageSize = MsgUser.Pgs;
}
//p.SqlWhere.Add(f => f.UId == baseUsers.Id || ( !f.DeleteUsers.Contains(uid) && f.SendUsers.Contains(uid)) );群发功能检索
p.SqlWhere.Add(f => f.UId == baseUsers.Id);
p.SqlWhere.Add(f => f.State > 0 && f.AddTime > baseUsers.AddTime);
p.OrderByList.Add("Id", "DESC");
IPageOfItems <MsgUser> List = Entity.Selects <MsgUser>(p);
foreach (var P in List.Where(n => n.UId == 0))
{ //处理已读
if (P.ReadUsers.IsNullOrEmpty())
{
P.ReadUsers = string.Empty;
}
if (P.ReadUsers.IndexOf(uid) != -1)
{
P.State = 2;
}
P.Info = Utils.RemoveHtml(P.Info);
P.Info = P.Info.Replace(" ", "");
}
IList <MsgUser> iList = List.ToList();
StringBuilder sb = new StringBuilder("");
sb.Append("{");
sb.Append(List.PageToString());
sb.Append(",");
sb.Append(iList.EntityToString());
sb.Append("}");
DataObj.Data = sb.ToString();
DataObj.Code = "0000";
DataObj.OutString();
}
