public void GetUsers(string UserName, bool?IsShowSupAgent) { if (UserName.IsNullOrEmpty()) { Response.Write("[]"); return; } IList <Users> List = null; if (!(bool)IsShowSupAgent) { List = Entity.Users.Where(n => (n.TrueName.Contains(UserName) || n.NeekName.Contains(UserName) || n.UserName == UserName) && n.Agent == BasicAgent.Id).ToList(); //List = List.Where(n => n.Agent == BasicAgent.Id).ToList(); } else { SysAgent LowerLevelAgent = Entity.SysAgent.FirstOrDefault(s => s.Id == BasicAgent.Id); IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity); IList <int> UID = new List <int>(); foreach (var s in SysAgentList) { UID.Add(s.Id); } List = Entity.Users.Where(n => (n.TrueName.Contains(UserName) || n.NeekName.Contains(UserName) || n.UserName == UserName) && UID.Contains(n.Agent)).ToList(); // List = List.Where(n => UID.Contains(n.Agent)).ToList(); } foreach (var p in List) { p.Cols = "Id,UserName,TrueName,NeekName"; } string Json = List.EntityToJson(); Response.Write(Json); }
public ActionResult Index(JobOrders JobOrders, EFPagingInfo <JobOrders> p, bool?IsShowSupAgent, int?LowerLevel, DateTime?STime, DateTime?ETime, int IsFirst = 0) { IPageOfItems <JobOrders> JobOrdersList = null; if (IsShowSupAgent == null) { IsShowSupAgent = false; } ViewBag.BasicAgent = BasicAgent; ViewBag.IsAll = IsAll; LowerLevel = LowerLevel == null ? 0 : LowerLevel; if (IsFirst == 0) { JobOrders.State = 99; JobOrdersList = new PageOfItems <JobOrders>(new List <JobOrders>(), 0, 10, 0, new Hashtable()); } else { p = this.Condition(JobOrders, p, STime, ETime); 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.AgentId)); } else { p.SqlWhere.Add(f => f.AgentId == BasicAgent.Id);//读取全部分支机构 } JobOrdersList = Entity.Selects <JobOrders>(p); } ViewBag.JobOrdersList = JobOrdersList; ViewBag.JobOrders = JobOrders; ViewBag.Edit = this.checkPower("Edit"); ViewBag.ETime = ETime; ViewBag.STime = STime; ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.LowerLevel = LowerLevel; List <int> UId = JobOrdersList.Select(o => o.UId).Distinct().ToList(); ViewBag.UsersList = Entity.Users.Where(n => n.State == 1 && UId.Contains(n.Id)).ToList(); return(View()); }
private EFPagingInfo <OrderProfitLog> Condition(OrderProfitLog OrderProfitLog, EFPagingInfo <OrderProfitLog> p, string TName, DateTime?STime, DateTime?ETime, bool?IsShowSupAgent) { #region 校验与初始化 // p.SqlWhere.Add(f => f.PayState == 1); if (!OrderProfitLog.TNum.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TNum == OrderProfitLog.TNum); } if (!TName.IsNullOrEmpty()) { IList <Users> UList = Entity.Users.Where(n => n.TrueName == TName || n.NeekName == TName || n.UserName == 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 (!OrderProfitLog.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == OrderProfitLog.Agent).FirstOrNew(); IList <SysAgent> AgentsList = LowerLevelAgent.GetSupAgent(Entity); IList <int> UID = new List <int>(); foreach (var s in AgentsList) { UID.Add(s.Id); } p.SqlWhere.Add(f => UID.Contains(f.Agent)); } else { p.SqlWhere.Add(f => f.Agent == OrderProfitLog.Agent); } } //if (!JobOrders.AgentState.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AgentState == (JobOrders.AgentState == 99 ? 0 : JobOrders.AgentState)); } if (!STime.IsNullOrEmpty() && !ETime.IsNullOrEmpty()) { DateTime ETimes = ETime.Value; p.SqlWhere.Add(f => f.AddTime > STime && f.AddTime < ETimes); } #endregion p.SqlWhere.Add(o => o.OrderType == 31); p.OrderByList.Add("Id", "DESC"); return(p); }
public ActionResult Index(Orders Orders, bool?IsShowSupAgent, int IsFirst = 0) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } 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")); Orders.ETime = DateTime.Now; } EFPagingInfo <ApplyCredit> cp = new EFPagingInfo <ApplyCredit>(); EFPagingInfo <ApplyLoan> lp = new EFPagingInfo <ApplyLoan>(); if (!Orders.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == Orders.Agent).FirstOrNew(); IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity); IList <int> UID = new List <int>(); foreach (var s in SysAgentList) { UID.Add(s.Id); } cp.SqlWhere.Add(f => UID.Contains(f.AgentId)); lp.SqlWhere.Add(f => UID.Contains(f.AgentId)); } else { cp.SqlWhere.Add(f => f.AgentId == Orders.Agent); lp.SqlWhere.Add(f => f.AgentId == Orders.Agent); } } if (!Orders.STime.IsNullOrEmpty() && !Orders.ETime.IsNullOrEmpty()) { DateTime ETime = Orders.ETime; cp.SqlWhere.Add(f => f.PayTime > Orders.STime && f.PayTime < ETime); lp.SqlWhere.Add(f => f.PayTime > Orders.STime && f.PayTime < ETime); } cp.SqlWhere.Add(f => f.PayState == 1); lp.SqlWhere.Add(f => f.PayState == 1); cp.PageSize = 99999999; lp.PageSize = 99999999; cp.OrderByList.Add("Id", "DESC"); lp.OrderByList.Add("Id", "DESC"); IPageOfItems <ApplyCredit> ApplyCreditList = null; IPageOfItems <ApplyLoan> ApplyLoanList = null; if (IsFirst == 0) { ApplyLoanList = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable()); ApplyCreditList = new PageOfItems <ApplyCredit>(new List <ApplyCredit>(), 0, 10, 0, new Hashtable()); } else { if (Orders.TType.IsNullOrEmpty()) { ApplyCreditList = Entity.Selects <ApplyCredit>(cp); ApplyLoanList = Entity.Selects <ApplyLoan>(lp); } else if (Orders.TType == 1) { ApplyCreditList = Entity.Selects <ApplyCredit>(cp); ApplyLoanList = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable()); } else if (Orders.TType == 2) { ApplyLoanList = Entity.Selects <ApplyLoan>(lp); ApplyCreditList = new PageOfItems <ApplyCredit>(new List <ApplyCredit>(), 0, 10, 0, new Hashtable()); } else { ApplyLoanList = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable()); ApplyCreditList = new PageOfItems <ApplyCredit>(new List <ApplyCredit>(), 0, 10, 0, new Hashtable()); } } ViewBag.ApplyLoanList = ApplyLoanList; ViewBag.ApplyCreditList = ApplyCreditList; ViewBag.Orders = Orders; ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Xls = this.checkPower("Xls"); return(View()); }
public ActionResult Index(StopPayAudit StopPayAudit, EFPagingInfo <StopPayAudit> p, bool IsShowSupAgent = false, int LowerLevel = 0, int IsFirst = 0) { #region 条件 if (!StopPayAudit.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == StopPayAudit.Agent).FirstOrNew(); IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity, true); 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 == StopPayAudit.Agent); } } if (!StopPayAudit.TState.IsNullOrEmpty()) { p.SqlWhere.Add(o => o.TState == StopPayAudit.TState); } if (!StopPayAudit.CreateAdminName.IsNullOrEmpty()) { List <int> uids = new List <int>(); if (StopPayAudit.UId == 1) { uids = Entity.Users.Where(o => o.UserName == StopPayAudit.CreateAdminName).Select(o => o.Id).ToList(); } else if (StopPayAudit.UId == 2) { uids = Entity.Users.Where(o => o.Mobile == StopPayAudit.CreateAdminName).Select(o => o.Id).ToList(); } else if (StopPayAudit.UId == 3) { uids = Entity.Users.Where(o => o.TrueName == StopPayAudit.CreateAdminName).Select(o => o.Id).ToList(); } p.SqlWhere.Add(f => uids.Contains(f.UId)); } #endregion p.OrderByList.Add("Id", "DESC"); IPageOfItems <StopPayAudit> StopPayAuditList = null; if (IsFirst == 0) { StopPayAuditList = new PageOfItems <StopPayAudit>(new List <StopPayAudit>(), 0, 10, 0, new Hashtable()); } else { StopPayAuditList = Entity.Selects <StopPayAudit>(p); } ViewBag.StopPayAuditList = StopPayAuditList; ViewBag.StopPayAudit = StopPayAudit; //用户表 var SPAUsersList = StopPayAuditList.Select(o => o.UId).ToList(); ViewBag.UserSelect = Entity.Users.Where(o => SPAUsersList.Contains(o.Id)).ToList(); ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent;//是否显示下级 ViewBag.IsAudit = this.checkPower("Audit"); return(View()); }
/// <summary> /// 解冻管理 /// </summary> /// <param name="Users"></param> /// <param name="p"></param> /// <returns></returns> public ActionResult Index(StopPayAudit StopPayAudit, EFPagingInfo <StopPayAudit> p, bool IsShowSupAgent = false, int LowerLevel = 0, int UserSelect = 1, int IsFirst = 0) { if (!StopPayAudit.TState.IsNullOrEmpty()) { p.SqlWhere.Add(o => o.TState == StopPayAudit.TState); } //一级只有的功能 if (BasicAgent.Tier == 1) { IList <SysAgent> SysAgentList = null; if (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);//读取全部分支机构 } } else { p.SqlWhere.Add(f => f.Agent == BasicAgent.Id); } if (!StopPayAudit.CreateAdminName.IsNullOrEmpty()) { List <int> uids = new List <int>(); if (StopPayAudit.UId == 1) { uids = Entity.Users.Where(o => o.UserName == StopPayAudit.CreateAdminName).Select(o => o.Id).ToList(); } else if (StopPayAudit.UId == 2) { uids = Entity.Users.Where(o => o.Mobile == StopPayAudit.CreateAdminName).Select(o => o.Id).ToList(); } else if (StopPayAudit.UId == 3) { uids = Entity.Users.Where(o => o.TrueName == StopPayAudit.CreateAdminName).Select(o => o.Id).ToList(); } p.SqlWhere.Add(f => uids.Contains(f.UId)); } p.OrderByList.Add("Id", "DESC"); IPageOfItems <StopPayAudit> StopPayAuditList = null; if (IsFirst == 0) { StopPayAuditList = new PageOfItems <StopPayAudit>(new List <StopPayAudit>(), 0, 10, 0, new Hashtable()); } else { StopPayAuditList = Entity.Selects <StopPayAudit>(p); } //用户表 var SPAUsersList = StopPayAuditList.Select(o => o.UId).ToList(); ViewBag.UserSelect = Entity.Users.Where(o => SPAUsersList.Contains(o.Id)).ToList(); ViewBag.StopPayAuditList = StopPayAuditList; ViewBag.StopPayAudit = StopPayAudit; ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.LowerLevel = LowerLevel; 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("[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 ActionResult Index(Card Card, EFPagingInfo <Card> p, string Num0, string Num1, bool?IsShowSupAgent, int IsFirst = 0) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } if (IsFirst == 0) { PageOfItems <Card> CardList1 = new PageOfItems <Card>(new List <Card>(), 0, 10, 0, new Hashtable()); ViewBag.CardList = CardList1; ViewBag.Card = Card; ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.State == 1).ToList(); ViewBag.Num0 = Num0; ViewBag.Num1 = Num1; ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Add = this.checkPower("Add"); ViewBag.Xls = this.checkPower("Xls"); ViewBag.Save = this.checkPower("Save"); return(View()); } if (!Card.Code.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Code == Card.Code); } if (!Card.AId.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == Card.AId).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.AId)); } else { p.SqlWhere.Add(f => f.AId == Card.AId); } } if (!Card.State.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.State == (Card.State == 99 ? 0 : Card.State)); } if (!Card.Auto.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Auto == (Card.Auto == 99 ? 0 : Card.Auto)); } if (!Num0.IsNullOrEmpty() && !Num1.IsNullOrEmpty()) { long num0 = Int64.Parse(Num0); long num1 = Int64.Parse(Num1); num0 = num0 - 1000000000; num1 = num1 - 1000000000; p.SqlWhere.Add(f => f.Id >= num0 && f.Id <= num1); } else { if (!Num0.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Code == Num0); } } p.OrderByList.Add("Id", "DESC"); if (p.PageSize.IsNullOrEmpty()) { p.PageSize = 20; } if (p.PageSize == 10) { p.PageSize = 20; } IPageOfItems <Card> CardList = Entity.Selects <Card>(p); ViewBag.CardList = CardList; ViewBag.Card = Card; ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.State == 1).ToList(); ViewBag.Num0 = Num0; ViewBag.Num1 = Num1; ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Add = this.checkPower("Add"); ViewBag.Xls = this.checkPower("Xls"); ViewBag.Save = this.checkPower("Save"); return(View()); }
public object Save(SysAgent SysAgent, List <string> PId, List <Attach> Contract, Attach IDCard_Front, Attach IDCard_Reverse, Attach IDCard_Hand, List <Attach> Certificate, List <int> DelIds, string PassWord, int?AnsyCash0, int?AnsyNext0, int?AnsyCash1, int?AnsyNext1) { SysAgent baseSysAgent = Entity.SysAgent.FirstOrDefault(n => n.Id == SysAgent.Id); if (baseSysAgent == null) { ViewBag.ErrorMsg = AgentLanguage.Empty; return(View("Error")); } if (!IsBelongToAgent(baseSysAgent.Id)) { ViewBag.ErrorMsg = AgentLanguage.Surmount; return(View("Error")); } if (SysAgent.Tel.Contains("400-608-6765") || SysAgent.Tel.Contains("23769678") || SysAgent.Tel.Contains("22220076") || SysAgent.Tel.Contains("4006086765")) { ViewBag.ErrorMsg = "该客服号码禁止使用"; return(View("Error")); } SysAgent.PayGet = SysAgent.PayGet.IsNullOrEmpty() ? 0 : SysAgent.PayGet / 100; SysAgent.CashGet = 0;//SysAgent.CashGet.IsNullOrEmpty() ? 0 : SysAgent.CashGet / 100; SysAgent.LoanGet = SysAgent.LoanGet.IsNullOrEmpty() ? 0 : SysAgent.LoanGet / 100; SysAgent.Credit = SysAgent.Credit.IsNullOrEmpty() ? 0 : SysAgent.Credit / 100; SysAgent.Cash0 = SysAgent.Cash0.IsNullOrEmpty() ? 0 : SysAgent.Cash0 / 1000; SysAgent.Cash1 = SysAgent.Cash1.IsNullOrEmpty() ? 0 : SysAgent.Cash1 / 1000; bool MySysAgentMoney = this.checkPower("MySysAgent", "MoneySave"); if (!MySysAgentMoney) { //无权限的时候,以上级代理为准 SysAgent.Cash0 = BasicAgent.Cash0; SysAgent.Cash1 = BasicAgent.Cash1; SysAgent.ECash0 = BasicAgent.ECash0; SysAgent.ECash1 = BasicAgent.ECash1; SysAgent.Cash0Times = BasicAgent.Cash0Times; SysAgent.Cash1Times = BasicAgent.Cash1Times; } if (SysAgent.Cash0 < BasicSet.AgentCash0 || SysAgent.ECash0 < BasicSet.AgentECash0 || SysAgent.Cash1 < BasicSet.AgentCash1 || SysAgent.ECash1 < BasicSet.AgentECash1) { ViewBag.ErrorMsg = "费率设置有误!"; return(View("Error")); } if (SysAgent.Cash0Times > BasicSet.AgentCash0Times || SysAgent.Cash1Times > BasicSet.AgentCash1Times) { ViewBag.ErrorMsg = "费率设置有误!"; return(View("Error")); } SysAgent.AgentState = SysAgent.AgentState; //已绑定,手机不能改 if (!baseSysAgent.MyUId.IsNullOrEmpty()) { SysAgent.LinkMobile = baseSysAgent.LinkMobile; } bool IsLock = false; if (baseSysAgent.State == 1 && SysAgent.State == 0) { IsLock = true; } //保存销售记录为了取得id var salesLog = new SalesLog() { AddTime = DateTime.Now, AgentFee = SysAgent.AgentFee, ExpireTime = SysAgent.ExpireTime, State = 1, AgentId = SysAgent.Id, Salesman = SysAgent.Salesman, }; Entity.SalesLog.AddObject(salesLog); Entity.SaveChanges(); baseSysAgent = Request.ConvertRequestToModel <SysAgent>(baseSysAgent, SysAgent); //处理推广代理佣金 if (baseSysAgent.DaiLiGetType == 1) { baseSysAgent.DaiLiGet = baseSysAgent.DaiLiGet / 100; } //权限 string Str = string.Empty; if (PId != null) { foreach (var p in PId) { if (p != string.Empty) { Str += "," + p; } } Str += ","; } string AgentIds = baseSysAgent.Id.ToString();//用户下方批量更新下级代理 IList <SysAgent> AgentList = null; //取得之前的权限 string powerChar = Entity.SysAdmin.FirstOrDefault(s => s.Id == baseSysAgent.AdminId).PowerID; //取得之前的权限跟修改后的权限不同的权限 string[] strSpile = Str.Split(','); string[] powerSpile = powerChar.Split(','); strSpile = strSpile.Where(s => !string.IsNullOrEmpty(s)).ToArray(); powerSpile = powerSpile.Where(x => !string.IsNullOrEmpty(x)).ToArray(); //只有减少权限的时候才执行 if (strSpile.Length < powerSpile.Length) { string retChar = ""; for (int i = 0; i < powerSpile.Length; i++) { if (!string.IsNullOrWhiteSpace(powerSpile[i])) { if (!strSpile.Contains(powerSpile[i])) { retChar += powerSpile[i] + ","; } } } //取得代理商所有的下级 AgentList = SysAgent.GetSupAgent(Entity, true); foreach (var agentItem in AgentList) { IList <SysAdmin> SysAdminList = Entity.SysAdmin.Where(x => x.AgentId == agentItem.Id).ToList(); string[] retSplit = retChar.Split(','); foreach (var modelAdmin in SysAdminList) { foreach (var item in retSplit) { string formatChar = string.Format(",{0},", item); if (modelAdmin.PowerID.Contains(formatChar)) { modelAdmin.PowerID = modelAdmin.PowerID.Replace(formatChar, ","); } } if (!string.IsNullOrWhiteSpace(modelAdmin.PowerID) && !modelAdmin.PowerID.StartsWith(",")) { modelAdmin.PowerID = "," + modelAdmin.PowerID; } string SQL = "Update SysAdmin set PowerID = '" + modelAdmin.PowerID + "' where Id=" + modelAdmin.Id; Entity.ExecuteStoreCommand(SQL); } } } SysAdmin SysAdmin = Entity.SysAdmin.FirstOrDefault(n => n.Id == baseSysAgent.AdminId); if (SysAdmin != null) { SysAdmin.PowerID = Str; if (!PassWord.IsNullOrEmpty()) { SysAdmin.PassWord = PassWord.GetAdminMD5(); } SysAdmin.State = SysAgent.State; } this.ProcessAttach(SysAgent, salesLog, Contract, IDCard_Front, IDCard_Reverse, IDCard_Hand, Certificate, DelIds); Entity.SaveChanges(); //如果是修改的话这个应该不会执行 OpenOrBindUser(SysAgent.Id, Str); if (IsLock) { //锁定其下级所有代理 2016-07-05 Lin this.LockAllAgent(baseSysAgent); } Entity.SaveChanges(); if (!AnsyCash0.IsNullOrEmpty() || !AnsyCash1.IsNullOrEmpty() || !AnsyNext0.IsNullOrEmpty() || !AnsyNext1.IsNullOrEmpty()) { if (AgentList == null) { //取得代理商所有的下级 AgentList = SysAgent.GetSupAgent(Entity, true); } ; foreach (var p in AgentList) { AgentIds = AgentIds + "," + p.Id; } } if (AnsyCash0 == 1)//同步到用户 { string SQL = "Update Users Set ECash0=" + baseSysAgent.ECash0 + ",Cash0=" + baseSysAgent.Cash0 + " where Agent in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (AnsyCash1 == 1)//同步到用户 { string SQL = "Update Users Set ECash1=" + baseSysAgent.ECash1 + ",Cash1=" + baseSysAgent.Cash1 + " where Agent in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (AnsyNext0 == 1)//同步到代理 { string SQL = "Update SysAgent Set ECash0=" + baseSysAgent.ECash0 + ",Cash0=" + baseSysAgent.Cash0 + ",Cash0Times=" + baseSysAgent.Cash0Times + " where Id in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (AnsyNext0 == 1)//同步到代理 { string SQL = "Update SysAgent Set ECash1=" + baseSysAgent.ECash1 + ",Cash1=" + baseSysAgent.Cash1 + ",Cash1Times=" + baseSysAgent.Cash1Times + " where Id in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } ViewBag.Msg = "操作成功!"; ViewBag.IsColse = true; return(View("Succeed")); }
public ActionResult Index(Users Users, EFPagingInfo<Users> p, bool? IsShowSupAgent, int IsFirst = 0) { #region 条件 if (IsShowSupAgent == null) { IsShowSupAgent = false; } if (Users.CardStae.IsNullOrEmpty()) { Users.CardStae = 2; } if (!Users.UserName.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.UserName == Users.UserName); } if (!Users.TrueName.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TrueName.Contains(Users.TrueName) || f.NeekName.Contains(Users.TrueName)); } if (!Users.Mobile.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Mobile == Users.Mobile); } if (!Users.State.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.State == (Users.State == 99 ? 0 : Users.State)); } if (!Users.CardNum.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.CardNum == Users.CardNum); } if (!Users.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == Users.Agent).FirstOrNew(); IList<SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity, true); IList<int> UID = SysAgentList.Select(o => o.Id).ToList(); p.SqlWhere.Add(f => UID.Contains(f.Agent)); } else { p.SqlWhere.Add(f => f.Agent == Users.Agent); } } if (!Users.CardId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.CardId == Users.CardId); } if (!Users.MyPId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.MyPId == Users.MyPId && f.ShareType == 1); } if (!Users.RegAddress.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.RegAddress.Contains(Users.RegAddress)); } if (!Users.CardStae.IsNullOrEmpty()) { int CardStae = Users.CardStae; if (CardStae == 99) { CardStae = 0; } if (CardStae != 88) { p.SqlWhere.Add(f => f.CardStae == CardStae); } } if (!Users.HasT0.IsNullOrEmpty()) { int HasT0 = Users.HasT0; if (HasT0 == 2) { HasT0 = 0; } p.SqlWhere.Add(f => f.HasT0 == HasT0); } #endregion p.OrderByList.Add("Id", "DESC"); IPageOfItems<Users> UsersList = null; if (IsFirst == 0) { UsersList = new PageOfItems<Users>(new List<Users>(), 0, 10, 0, new Hashtable()); } else { UsersList = Entity.Selects<Users>(p); } ViewBag.UsersList = UsersList; ViewBag.Users = Users; ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.State==1).ToList(); //显示上级名字 var ulids = UsersList.Select(o => o.Id).Distinct().ToArray(); ViewBag.PName = Entity.Users.Select(o => new { o.Id, o.TrueName }).ToDictionary(o => o.Id, o => o.TrueName); ViewBag.IsShowSupAgent = IsShowSupAgent;//是否显示下级 ViewBag.Edit = this.checkPower("Edit"); ViewBag.DeductMoney = this.checkPower("DeductMoney"); ViewBag.MyUsers = this.checkPower("MyUsers"); ViewBag.Save = this.checkPower("Save"); ViewBag.ClearPId = this.checkPower("ClearPId"); ViewBag.StopPay = this.checkPower("StopPay"); ViewBag.StopPaySave = this.checkPower("StopPaySave"); ViewBag.UnFrozenList = this.checkPower("UnFrozenList"); ViewBag.UnFrozenAudit = this.checkPower("UnFrozenAudit"); ViewBag.Clear = this.checkPower("Clear"); ViewBag.ClearRZ = this.checkPower("ClearRZ"); ViewBag.UserTrail = this.checkPower("UserTrail", "Index"); ViewBag.UserMaillist = this.checkPower("UserMaillist", "Index"); ViewBag.UserIdCard = this.checkPower("UserIdCard", "Index"); ViewBag.UserIdLog = this.checkPower("UserIdCard", "Log"); ViewBag.UserLog = this.checkPower("UserLog", "Index"); ViewBag.ChangeT0BlackList = this.checkPower("Users", "ChangeT0BlackList"); ViewBag.ExcelInport = this.checkPower("ExcelInport"); ViewBag.Download = this.checkPower("Download"); 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("[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; } //判断是否为代理商 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) { baseUsers.UserType = 2; } else { baseUsers.UserType = 1; } //if (baseUsers.UserType == 1) //{ UsersList = baseUsers.GetSupUsers(Entity, baseSysSet.GlobaPromoteMaxLevel); UsersList = UsersList.Where(o => o.Id != baseUsers.Id).ToList(); baseUsers.UserTotal = UsersList.Count(); // } if (baseUsers.UserType == 2) { SysAgentList = SysAgent.GetSupAgent(Entity); IList <int> agents = SysAgentList.Where(o => o.Id != SysAgent.Id).Select(o => o.Id).ToList(); // UsersList = Entity.Users.Where(o => agents.Contains(o.Agent) && o.Id != baseUsers.Id).ToList(); //baseUsers.UserTotal = UsersList.Count(); //SysAgentList = SysAgentList.Where(o => o.Id != SysAgent.Id).ToList(); baseUsers.AgentTotal = agents.Count(); } baseUsers.Cols = "Id,UserName,UserType,UserTotal,AgentTotal"; DataObj.Data = baseUsers.OutJson(); DataObj.Code = "0000"; DataObj.OutString(); }
/// <summary> /// 条件 /// </summary> private EFPagingInfo <OrderCash> Condition(OrderCash OrderCash, EFPagingInfo <OrderCash> p, bool?IsShowSupAgent) { 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.Parse(DateTime.Now.ToString("yyyy-MM-dd")); // OrderCash.FTime = DateTime.Now; //} //if (!OrderCash.UId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.UId == OrderCash.UId); } if (!OrderCash.Owner.IsNullOrEmpty()) { IList <Users> UList = Entity.Users.Where(n => n.TrueName == OrderCash.Owner || n.NeekName == 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); } return(p); }
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 + "}"); }
public ActionResult Index(BaoUsers BaoUsers, EFPagingInfo <BaoUsersVM> p, string UserName, int?AgentID, bool?HasMoney, int IsFirst = 0, bool IsShowSupAgent = false) { int id = 0; var iquery = Entity.BaoUsers.Join(this.Entity.Users, b => b.UId, u => u.Id, (b, u) => new BaoUsersVM() { Users = u, BaoUsers = b }); if (!UserName.IsNullOrEmpty()) { iquery = iquery.Where(o => o.Users.UserName == UserName); } if (!BaoUsers.PayPwd.IsNullOrEmpty()) { id = this.Entity.Users.FirstOrNew(o => o.CardId == BaoUsers.PayPwd).Id; if (id != 0) { iquery = iquery.Where(o => o.BaoUsers.UId == id); } } if (HasMoney.HasValue) { if (HasMoney.Value) { iquery = iquery.Where(o => o.BaoUsers.AllMoney > 0); } else { iquery = iquery.Where(o => o.BaoUsers.AllMoney == 0); } } if (AgentID.HasValue) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == AgentID.Value).FirstOrNew(); IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity, true); IList <int> UID = SysAgentList.Select(o => o.Id).ToList(); iquery = iquery.Where(f => UID.Contains(f.Users.Agent)); } else { iquery = iquery.Where(f => f.Users.Agent == AgentID.Value); } } PageOfItems <BaoUsersVM> BaoUsersList = null; decimal sumAllMoney = 0m; decimal sumInMoney = 0m; if (IsFirst == 0) { BaoUsersList = new PageOfItems <BaoUsersVM>(new List <BaoUsersVM>(), 0, 10, 0, new Hashtable()); } else { var count = iquery.Count(); sumAllMoney = iquery.Sum(o => (decimal?)o.BaoUsers.AllMoney) ?? 0; sumInMoney = iquery.Sum(o => (decimal?)o.BaoUsers.InMoney) ?? 0; List <BaoUsersVM> a = iquery.OrderByDescending(o => o.BaoUsers.AllMoney).Skip(p.PageIndex < 1 ? 0 : ((p.PageIndex - 1) * p.PageSize)).Take(p.PageSize).ToList(); BaoUsersList = new PageOfItems <BaoUsersVM>(a, p.PageIndex, p.PageSize, count, p.OrderByList); } ViewBag.BaoUsersList = BaoUsersList; ViewBag.BaoUsers = BaoUsers; ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent;//是否显示下级 ViewBag.AgentID = AgentID; ViewBag.UserName = UserName; ViewBag.sumAllMoney = sumAllMoney; ViewBag.sumInMoney = sumInMoney; ViewBag.HasMoney = HasMoney; ViewBag.Log = this.checkPower("Log"); ViewBag.TransferUser = this.checkPower("TransferUser"); return(View()); }
public void Save(SysAgent SysAgent, List <string> PId, List <Attach> Contract, Attach IDCard_Front, Attach IDCard_Reverse, Attach IDCard_Hand, List <Attach> Certificate, List <int> DelIds, string PassWord, int?AnsyCash0, int?AnsyNext0, int?AnsyCash1, int?AnsyNext1, int sameid) { SysAgent.PayGet = SysAgent.PayGet.IsNullOrEmpty() ? 0 : SysAgent.PayGet / 100; SysAgent.CashGet = 0;//SysAgent.CashGet.IsNullOrEmpty() ? 0 : SysAgent.CashGet / 100; SysAgent.LoanGet = SysAgent.LoanGet.IsNullOrEmpty() ? 0 : SysAgent.LoanGet / 100; SysAgent.Credit = SysAgent.Credit.IsNullOrEmpty() ? 0 : SysAgent.Credit / 100; //已绑定,手机不能改 SysAgent baseSysAgent = Entity.SysAgent.FirstOrDefault(n => n.Id == SysAgent.Id); if (!baseSysAgent.MyUId.IsNullOrEmpty()) { SysAgent.LinkMobile = baseSysAgent.LinkMobile; } bool IsLock = false; if (baseSysAgent.State == 1 && SysAgent.State == 0) { IsLock = true; } //保存销售记录为了取得id var salesLog = new SalesLog() { AddTime = DateTime.Now, AgentFee = SysAgent.AgentFee, ExpireTime = SysAgent.ExpireTime, State = 1, AgentId = SysAgent.Id, Salesman = SysAgent.Salesman, }; Entity.SalesLog.AddObject(salesLog); Entity.SaveChanges(); SysAgent.Cash0 = SysAgent.Cash0 / 1000; SysAgent.Cash1 = SysAgent.Cash1 / 1000; //判断是否更新级数 bool IsUpMaxTier = false; if (SysAgent.AgentLevelMax > baseSysAgent.AgentLevelMax) { IsUpMaxTier = true; } else { SysAgent.AgentLevelMax = baseSysAgent.AgentLevelMax;//不大于的情况下不能修改 } baseSysAgent = Request.ConvertRequestToModel <SysAgent>(baseSysAgent, SysAgent); //处理推广代理佣金 if (baseSysAgent.DaiLiGetType == 1) { baseSysAgent.DaiLiGet = baseSysAgent.DaiLiGet / 100; } //默认代理不能被关闭 if (baseSysAgent.State == 0 && baseSysAgent.Id == 1) { baseSysAgent.State = 1; } //处理设置 if (SysAgent.IsTeiPai != 1) { SysAgent.Set3 = 0; SysAgent.Set4 = 0; } //权限 string Str = string.Empty; if (PId != null) { foreach (var p in PId) { if (p != string.Empty) { Str += "," + p; } } Str += ","; } string AgentIds = baseSysAgent.Id.ToString();//用户下方批量更新下级代理 IList <SysAgent> AgentList = null; //取得之前的权限 string powerChar = Entity.SysAdmin.FirstOrDefault(s => s.Id == baseSysAgent.AdminId).PowerID; //取得之前的权限跟修改后的权限不同的权限 string[] strSpile = Str.Split(','); string[] powerSpile = powerChar.Split(','); strSpile = strSpile.Where(s => !string.IsNullOrEmpty(s)).ToArray(); powerSpile = powerSpile.Where(x => !string.IsNullOrEmpty(x)).ToArray(); //只有减少权限的时候才执行 if (strSpile.Length < powerSpile.Length) { string retChar = ""; for (int i = 0; i < powerSpile.Length; i++) { if (!string.IsNullOrWhiteSpace(powerSpile[i])) { if (!strSpile.Contains(powerSpile[i])) { retChar += powerSpile[i] + ","; } } } //取得代理商所有的下级 AgentList = SysAgent.GetSupAgent(Entity); foreach (var agentItem in AgentList) { //根据商户Id获取管理员信息 IList <SysAdmin> SysAdminList = Entity.SysAdmin.Where(x => x.AgentId == agentItem.Id).ToList(); string[] retSplit = retChar.Split(','); foreach (var modelAdmin in SysAdminList) { foreach (var item in retSplit) { string formatChar = string.Format(",{0},", item); if (modelAdmin.PowerID.Contains(formatChar)) { modelAdmin.PowerID = modelAdmin.PowerID.Replace(formatChar, ","); } } if (!string.IsNullOrWhiteSpace(modelAdmin.PowerID) && !modelAdmin.PowerID.StartsWith(",")) { modelAdmin.PowerID = "," + modelAdmin.PowerID; } string SQL = "Update SysAdmin set PowerID = '" + modelAdmin.PowerID + "' where Id=" + modelAdmin.Id; Entity.ExecuteStoreCommand(SQL); } } } SysAdmin SysAdmin = Entity.SysAdmin.FirstOrDefault(n => n.Id == baseSysAgent.AdminId); if (SysAdmin != null) { SysAdmin.PowerID = Str; if (!PassWord.IsNullOrEmpty()) { SysAdmin.PassWord = PassWord.GetAdminMD5(); } SysAdmin.State = SysAgent.State; } this.ProcessAttach(SysAgent, salesLog, Contract, IDCard_Front, IDCard_Reverse, IDCard_Hand, Certificate, DelIds); Entity.SaveChanges(); //如果是修改的话这个应该不会执行 OpenOrBindUser(SysAgent.Id, Str); if (IsLock) { //锁定其下级所有代理 2016-07-05 Lin this.LockAllAgent(baseSysAgent); } Entity.SaveChanges(); //if (SysAgent) if (!AnsyCash0.IsNullOrEmpty() || !AnsyCash1.IsNullOrEmpty() || !AnsyNext0.IsNullOrEmpty() || !AnsyNext1.IsNullOrEmpty() || IsUpMaxTier) { if (AgentList == null) { //取得代理商所有的下级 AgentList = SysAgent.GetSupAgent(Entity, true); } foreach (var p in AgentList) { AgentIds = AgentIds + "," + p.Id; } } if (IsUpMaxTier) { string SQL = "Update SysAgent Set AgentLevelMax=" + baseSysAgent.AgentLevelMax + " where Id in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (AnsyCash0 == 1)//同步到用户 { string SQL = "Update Users Set ECash0=" + baseSysAgent.ECash0 + ",Cash0=" + baseSysAgent.Cash0 + " where Agent in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (AnsyCash1 == 1)//同步到用户 { string SQL = "Update Users Set ECash1=" + baseSysAgent.ECash1 + ",Cash1=" + baseSysAgent.Cash1 + " where Agent in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (AnsyNext0 == 1)//同步到代理 { string SQL = "Update SysAgent Set ECash0=" + baseSysAgent.ECash0 + ",Cash0=" + baseSysAgent.Cash0 + ",Cash0Times=" + baseSysAgent.Cash0Times + " where Id in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (AnsyNext0 == 1)//同步到代理 { string SQL = "Update SysAgent Set ECash1=" + baseSysAgent.ECash1 + ",Cash1=" + baseSysAgent.Cash1 + ",Cash1Times=" + baseSysAgent.Cash1Times + " where Id in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } if (sameid != SysAgent.SameAgent) { SysAgent tempAgent = Entity.SysAgent.FirstOrNew(o => o.Id == SysAgent.SameAgent); //调入商户 SysAgent Agengt = Entity.SysAgent.FirstOrNew(o => o.Id == sameid); //调出商户 UsersMoveLog UsersMoveLog = new UsersMoveLog() { AddTime = DateTime.Now, ToSAId = tempAgent.Id, ToName = tempAgent.Name.IsNullOrEmpty()?"":tempAgent.Name, FromName = Agengt.Name.IsNullOrEmpty()?"":Agengt.Name, FromSAId = Agengt.Id, UId = baseSysAgent.Id, UTrueName = baseSysAgent.Name.IsNullOrEmpty() ? "" : baseSysAgent.Name, OpName = AdminUser.TrueName, Type = 3, Tel = baseSysAgent.LinkMobile, }; this.Entity.UsersMoveLog.AddObject(UsersMoveLog); Entity.SaveChanges(); } BaseRedirect(); }
public ActionResult Index(Orders Orders, EFPagingInfo <Orders> p, bool?IsShowSupAgent, int IsFirst = 0) { this.TempData.Remove("SysAgentList"); #region 校验与初始化 if (IsShowSupAgent == null) { IsShowSupAgent = false; } 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")); Orders.ETime = DateTime.Now; } p.SqlWhere.Add(f => f.PayState == 1); p.SqlWhere.Add(f => f.TState == 2); if (!Orders.TNum.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TNum == Orders.TNum); } if (!Orders.TName.IsNullOrEmpty()) { IList <Users> UList = Entity.Users.Where(n => n.TrueName == Orders.TName || n.NeekName == 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.TType.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TType == Orders.TType); } if (!Orders.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == Orders.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 == Orders.Agent); } } if (!Orders.AgentState.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AgentState == (Orders.AgentState == 99 ? 0 : Orders.AgentState)); } if (!Orders.STime.IsNullOrEmpty() && !Orders.ETime.IsNullOrEmpty()) { DateTime ETime = Orders.ETime; p.SqlWhere.Add(f => f.PayTime > Orders.STime && f.PayTime < ETime); } #endregion p.PageSize = 99999999; p.OrderByList.Add("Id", "DESC"); IPageOfItems <Orders> OrdersList = null; if (IsFirst == 0) { OrdersList = new PageOfItems <Orders>(new List <Orders>(), 0, 10, 0, new Hashtable()); } else { OrdersList = Entity.Selects <Orders>(p); } ViewBag.OrdersList = OrdersList; ViewBag.Orders = Orders; IList <Orders> List = OrdersList.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.PayConfigList = Entity.PayConfig.Where(n => n.State == 1).ToList(); IList <Orders> List1 = OrdersList.GroupBy(n => n.Agent).Select(n => n.First()).ToList(); List <int> AgentId = new List <int>(); foreach (var pp in List1) { AgentId.Add(pp.Agent); } ViewBag.SysAgentList = Entity.SysAgent.Where(n => AgentId.Contains(n.Id) && n.Tier == 1).ToList(); this.TempData["SysAgentList"] = ViewBag.SysAgentList; ViewBag.SelectSysAgentList = Entity.SysAgent.Where(n => n.State == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Xls = this.checkPower("Xls"); return(View()); }
public void PaySave(SysAgent SysAgent, int[] PId, double[] Cost, int[] PState, int?AnsyCash, int?AnsyNext) { if (SysAgent.Id != 0) { SysAgent = Entity.SysAgent.FirstOrDefault(n => n.Id == SysAgent.Id); } if (SysAgent == null) { return; } for (int i = 0; i < PId.Length; i++) { int Pid = PId[i]; UserPayAgent PCT = Entity.UserPayAgent.FirstOrNew(n => n.AId == SysAgent.Id && n.PId == Pid); PCT.Cost = Cost[i] / 1000; if (PCT.Id.IsNullOrEmpty()) { PCT.PId = PId[i]; PCT.AId = SysAgent.Id; Entity.UserPayAgent.AddObject(PCT); } } Entity.SaveChanges(); IList <PayConfig> PayConfigList = new List <PayConfig>(); IList <UserPayAgent> UserPayAgentList = new List <UserPayAgent>(); IList <SysAgent> AgentList = new List <SysAgent>(); string AgentIds = "0"; if (AnsyCash == 1 || AnsyNext == 1) { PayConfigList = Entity.PayConfig.Where(n => n.State == 1).ToList(); UserPayAgentList = Entity.UserPayAgent.Where(n => n.AId == SysAgent.Id).ToList(); //取得代理商所有的下级 AgentList = SysAgent.GetSupAgent(Entity); foreach (var p in AgentList) { AgentIds = AgentIds + "," + p.Id; } } if (AnsyCash == 1) { //使用删除全部后根据用户表生成,有效解决了因接口关闭或新增加接口,老用户没有配置问题 string SQL = "Delete UserPay Where UId in(Select Id From Users Where Agent in(" + AgentIds + "))"; Entity.ExecuteStoreCommand(SQL); foreach (var p in PayConfigList) { double? cost = p.CostUser; UserPayAgent PCT = UserPayAgentList.FirstOrNew(n => n.AId == SysAgent.Id && n.PId == p.Id); if (!PCT.Id.IsNullOrEmpty()) { cost = PCT.Cost; } SQL = "INSERT INTO UserPay(UId,PId,Cost,IsDel) Select ID," + p.Id + " As PId," + cost + " As Cost, 0 As IsDel From Users where Id in(Select Id From Users Where Agent in(" + AgentIds + "))"; Entity.ExecuteStoreCommand(SQL); } } if (AnsyNext == 1) { //使用删除全部后根据用户表生成,有效解决了因接口关闭或新增加接口,老用户没有配置问题 string SQL = "Delete UserPayAgent Where AId in (" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); foreach (var p in PayConfigList) { double? cost = p.CostUser; UserPayAgent PCT = UserPayAgentList.FirstOrNew(n => n.AId == SysAgent.Id && n.PId == p.Id); if (!PCT.Id.IsNullOrEmpty()) { cost = PCT.Cost; } SQL = "INSERT INTO UserPayAgent(AId,PId,Cost,IsDel) Select ID," + p.Id + " As PId," + cost + " As Cost, 0 As IsDel From SysAgent where Id in(" + AgentIds + ")"; Entity.ExecuteStoreCommand(SQL); } } BaseRedirect(); }
public ActionResult Index(Users Users, EFPagingInfo <Users> p, bool?IsShowSupAgent, int?LowerLevel, int IsFirst = 0) { #region 条件 if (checkPower("ALL")) { IsAll = true; } if (IsShowSupAgent == null) { IsShowSupAgent = false; } LowerLevel = LowerLevel == null ? 0 : LowerLevel; ViewBag.IsAll = IsAll; /*有没有指定交易所属代理 * 有:校验是否从属关系 * 无:指定当前代理 */ if (!Users.Agent.IsNullOrEmpty()) { if (!IsBelongToAgent(Users.Agent)) { ViewBag.ErrorMsg = "只能查询当前用户下属代理的交易"; return(View("Error")); } } else { Users.Agent = this.BasicAgent.Id; } IList <SysAgent> SysAgentList = null; //没有"管理所有"权限的只能看到操作员自己的数据 if (!IsAll) { p.SqlWhere.Add(f => f.AId == AdminUser.Id);//指定的操作员 } else { 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);//获取所有下级代理商信息 } foreach (var s in SysAgentList) { UID.Add(s.Id); } p.SqlWhere.Add(f => UID.Contains(f.Agent)); } else { p.SqlWhere.Add(f => f.Agent == Users.Agent);//指定的代理 } } if (Users.CardStae.IsNullOrEmpty()) { Users.CardStae = 2; } if (!Users.RegAddress.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.RegAddress.Contains(Users.RegAddress)); } if (!Users.UserName.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.UserName == Users.UserName); } if (!Users.TrueName.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TrueName == Users.TrueName || f.NeekName == Users.TrueName); } if (!Users.Mobile.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Mobile == Users.Mobile); } if (!Users.State.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.State == (Users.State == 99 ? 0 : Users.State)); } if (!Users.CardNum.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.CardNum == Users.CardNum); } if (!Users.CardStae.IsNullOrEmpty()) { int CardStae = Users.CardStae; if (CardStae == 99) { CardStae = 0; } if (CardStae != 88) { p.SqlWhere.Add(f => f.CardStae == CardStae); } } #endregion p.OrderByList.Add("Id", "DESC"); IPageOfItems <Users> UsersList = null; if (IsFirst == 0) { UsersList = new PageOfItems <Users>(new List <Users>(), 0, 10, 0, new Hashtable()); } else { UsersList = Entity.Selects <Users>(p); } foreach (var item in UsersList) { item.Address = item.QRCode(); } ViewBag.UsersList = UsersList; ViewBag.Users = Users; SysSet SysSet = Entity.SysSet.FirstOrNew(); ViewBag.SysSet = SysSet; ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.SysAgentList = SysAgentList; ViewBag.LowerLevel = LowerLevel; ViewBag.Entity = Entity; ViewBag.IsAssureImg = checkPower("SaveAssureImg"); ViewBag.IsFrozen = this.checkPower("Frozen"); ViewBag.IsUnFrozen = this.checkPower("UnFrozen"); ViewBag.MyUsers = this.checkPower("MyUsers"); return(View()); }
private EFPagingInfo <OrderCash> Condition(OrderCash OrderCash, EFPagingInfo <OrderCash> p, bool?IsShowSupAgent, int IsFirst = 0, int TimeType = 1) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } p.SqlWhere.Add(f => f.OrderState == 2); p.SqlWhere.Add(f => f.PayState == 3 || f.PayState == 4); //if (!OrderCash.UId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.UId == OrderCash.UId); } 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.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.PayState.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.PayState == OrderCash.PayState); } 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 (TimeType == 1) { if (!OrderCash.AddTime.IsNullOrEmpty() && !OrderCash.FTime.IsNullOrEmpty()) { // DateTime FTime = ((DateTime)OrderCash.FTime).AddDays(1); DateTime FTime = OrderCash.FTime.Value.AddMilliseconds(999); p.SqlWhere.Add(f => f.AddTime > OrderCash.AddTime && f.AddTime < FTime); } } else { if (!OrderCash.AddTime.IsNullOrEmpty() && !OrderCash.FTime.IsNullOrEmpty()) { DateTime FTime = OrderCash.FTime.Value.AddMilliseconds(999); p.SqlWhere.Add(f => f.RefundTime > OrderCash.AddTime && f.RefundTime < FTime); } } return(p); }
public ActionResult Index(OrderHouse OrderHouse, EFPagingInfo <OrderHouse> p, bool?IsShowSupAgent, int IsFirst = 0) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } if (Request.QueryString["PageSize"].IsNullOrEmpty()) { p.PageSize = 30; } p.SqlWhere.Add(f => f.OrderState == 2); p.SqlWhere.Add(f => f.PayState == 1 || f.PayState == 2); //if (OrderHouse.AddTime.IsNullOrEmpty()) //{ // OrderHouse.AddTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); //} //if (OrderHouse.FTime.IsNullOrEmpty()) //{ // OrderHouse.FTime = DateTime.Now; //} if (IsFirst == 0) { PageOfItems <OrderHouse> OrderHouseList1 = new PageOfItems <OrderHouse>(new List <OrderHouse>(), 0, 10, 0, new Hashtable()); ViewBag.OrderHouseList = OrderHouseList1; ViewBag.OrderHouse = OrderHouse; ViewBag.UsersList = new List <Users>(); ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.State == 1 && n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Edit = this.checkPower("Edit"); ViewBag.Cancel = this.checkPower("Cancel"); ViewBag.Save = this.checkPower("Save"); return(View()); } //if (!OrderHouse.UId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.UId == OrderHouse.UId); } if (!OrderHouse.HouseOwner.IsNullOrEmpty()) { IList <Users> UList = Entity.Users.Where(n => n.TrueName.Contains(OrderHouse.HouseOwner) || n.NeekName.Contains(OrderHouse.HouseOwner) || n.UserName == OrderHouse.HouseOwner).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 (!OrderHouse.OId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.OId == OrderHouse.OId); } if (!OrderHouse.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == OrderHouse.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 == OrderHouse.Agent); } } if (!OrderHouse.FState.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.FState == (OrderHouse.FState == 99 ? 0 : OrderHouse.FState)); } if (!OrderHouse.TrunType.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TrunType == (OrderHouse.TrunType == 99 ? 0 : OrderHouse.TrunType)); } if (!OrderHouse.AId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AId == OrderHouse.AId); } if (!OrderHouse.FId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.FId == OrderHouse.FId); } if (!OrderHouse.AgentState.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AgentState == OrderHouse.AgentState); } if (!OrderHouse.AddTime.IsNullOrEmpty() && !OrderHouse.FTime.IsNullOrEmpty()) { // DateTime FTime = ((DateTime)OrderHouse.FTime).AddDays(1); DateTime FTime = OrderHouse.FTime.Value; p.SqlWhere.Add(f => f.PayTime > OrderHouse.AddTime && f.PayTime < FTime); } p.OrderByList.Add("Id", "DESC"); IPageOfItems <OrderHouse> OrderHouseList = null; if (IsFirst == 0) { OrderHouseList = new PageOfItems <OrderHouse>(new List <OrderHouse>(), 0, 10, 0, new Hashtable()); } else { OrderHouseList = Entity.Selects <OrderHouse>(p); } ViewBag.OrderHouseList = OrderHouseList; ViewBag.OrderHouse = OrderHouse; IList <OrderHouse> List = OrderHouseList.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.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Edit = this.checkPower("Edit"); ViewBag.Cancel = this.checkPower("Cancel"); ViewBag.Save = this.checkPower("Save"); return(View()); }
private EFPagingInfo <FastOrder> Condition(FastOrder FastOrder, EFPagingInfo <FastOrder> p, bool IsShowSupAgent) { #region 筛选条件 if (!FastOrder.PayWay.IsNullOrEmpty()) { p.SqlWhere.Add(o => o.PayWay == FastOrder.PayWay); } if (!FastOrder.TNum.IsNullOrEmpty()) { if (FastOrder.UId == 1) { p.SqlWhere.Add(f => f.TNum == FastOrder.TNum); } else { IList <Users> UList = Entity.Users.Where(n => n.TrueName.Contains(FastOrder.TNum) || n.NeekName.Contains(FastOrder.TNum) || n.UserName == FastOrder.TNum).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 (!FastOrder.UserState.IsNullOrEmpty()) { var value = FastOrder.UserState == 99 ? 0 : FastOrder.UserState; p.SqlWhere.Add(o => o.UserState == value); } if (!FastOrder.AgentState.IsNullOrEmpty()) { var value = FastOrder.AgentState == 99 ? 0 : FastOrder.AgentState; p.SqlWhere.Add(o => o.AgentState == value); } //是否选择了分支机构 if (!FastOrder.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == FastOrder.Agent).FirstOrNew(); IList <SysAgent> SysAgentList = LowerLevelAgent.GetSupAgent(Entity, true); IList <int> UID = SysAgentList.Select(o => o.Id).ToList(); p.SqlWhere.Add(f => UID.Contains(f.Agent)); } else { p.SqlWhere.Add(f => f.Agent == FastOrder.Agent); } } if (!FastOrder.STime.IsNullOrEmpty() && !FastOrder.ETime.IsNullOrEmpty()) { DateTime ETime = FastOrder.ETime; if (FastOrder.Bin == "1") { p.SqlWhere.Add(f => f.AddTime > FastOrder.STime && f.AddTime < ETime); } else { p.SqlWhere.Add(f => f.PayTime > FastOrder.STime && f.PayTime < ETime); } } #region 交易类型条件判断 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 99: //交易关闭 p.SqlWhere.Add(f => f.State == 0); break; } } #endregion #endregion p.OrderByList.Add("Id", "DESC"); return(p); }
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 Add(MsgAdmin MsgAdmin, int?IsObj, int?IsAdmin, int?IsPId, int?IsLevel) { string sendUsers = ""; //获取发送对象 if (IsObj.HasValue) { switch (IsObj) { case 0: //管理员 MsgAdmin.IsAdmin = 0; #region 给管理员发送 if (IsAdmin.HasValue) { if (IsAdmin.Value == 0) { //选择了所有的管理员 IList <SysAdmin> ListAdmin = BasicAgent.GetAgentAdmins(Entity); //获取所有的管理员 if (ListAdmin.Count > 1) { MsgAdmin.AId = 0; foreach (var item in ListAdmin) { sendUsers += item.Id + ","; } } else { MsgAdmin.AId = ListAdmin[0].Id; } } else { //如果选择了单个管理员 MsgAdmin.AId = IsAdmin.Value; } } #endregion break; case 1: //代理商 MsgAdmin.IsAdmin = 1; #region 给代理商发送 int isLevel = IsLevel.HasValue ? IsLevel.Value : 0; if (IsPId.HasValue) { if (IsPId.Value == 0) //如果选择的所有代理商 { IList <SysAgent> ListAgent = BasicAgent.GetSupAgent(Entity); if (isLevel == 1) { //包含下级 ListAgent = ListAgent.GetSupAgent(Entity); } IList <SysAdmin> modelAdmin = ListAgent.GetAgentAdmins(Entity); if (modelAdmin.Count > 1) { MsgAdmin.AId = 0; foreach (var adminItem in modelAdmin) { sendUsers += adminItem.Id + ","; } } else { MsgAdmin.AId = modelAdmin[0].Id; } } else //如果选择的单个代理商 { SysAgent agentModel = Entity.SysAgent.FirstOrDefault(x => x.Id == IsPId); IList <SysAdmin> modelAdmin = null; if (isLevel == 0) //不包含下级 { modelAdmin = agentModel.GetAgentAdmins(Entity); } else //包含下级 { //获取下级代理商 IList <SysAgent> ListAgent = agentModel.GetSupAgent(Entity); modelAdmin = ListAgent.GetAgentAdmins(Entity); } if (modelAdmin.Count > 1) { MsgAdmin.AId = 0; foreach (var item in modelAdmin) { sendUsers += item.Id + ","; } } else { MsgAdmin.AId = modelAdmin[0].Id; } } } #endregion break; } } MsgAdmin.PId = AdminUser.Id; MsgAdmin.SendUsers = !string.IsNullOrWhiteSpace(sendUsers) ? "," + sendUsers : ",0,"; MsgAdmin.Name = MsgAdmin.Name; MsgAdmin.Info = MsgAdmin.Info; MsgAdmin.State = MsgAdmin.State; MsgAdmin.AddTime = DateTime.Now; Entity.MsgAdmin.AddObject(MsgAdmin); Entity.SaveChanges(); BaseRedirect(); }
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 Index(ApplyLoan ApplyLoan, EFPagingInfo <ApplyLoan> p, bool?IsShowSupAgent, int IsFirst = 0) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } if (ApplyLoan.STime.IsNullOrEmpty()) { ApplyLoan.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); } if (ApplyLoan.ETime.IsNullOrEmpty()) { // ApplyLoan.ETime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); ApplyLoan.ETime = DateTime.Now; } if (IsFirst == 0) { PageOfItems <ApplyLoan> ApplyLoanList1 = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable()); ViewBag.ApplyLoanList = ApplyLoanList1; ViewBag.ApplyLoan = ApplyLoan; ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Xls = this.checkPower("Xls"); return(View()); } if (!ApplyLoan.TrueName.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TrueName == ApplyLoan.TrueName); } if (!ApplyLoan.Education.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Education.Contains(ApplyLoan.Education)); } if (!ApplyLoan.HasSheBao.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.HasSheBao == (ApplyLoan.HasSheBao == 99 ? 0 : ApplyLoan.HasSheBao)); } if (!ApplyLoan.Marry.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Marry == ApplyLoan.Marry); } if (!ApplyLoan.HasCar.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.HasCar == (ApplyLoan.HasCar == 99 ? 0 : ApplyLoan.HasCar)); } if (!ApplyLoan.House.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.House == ApplyLoan.House); } if (!ApplyLoan.HasCredit.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.HasCredit == ApplyLoan.HasCredit); } if (!ApplyLoan.State.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.State == ApplyLoan.State); } if (!ApplyLoan.AgentPay.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AgentPay == (ApplyLoan.AgentPay == 99 ? 0 : ApplyLoan.AgentPay)); } if (!ApplyLoan.AgentAId.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == ApplyLoan.AgentAId).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.AgentAId)); } else { p.SqlWhere.Add(f => f.AgentAId == ApplyLoan.AgentAId); } } if (!ApplyLoan.STime.IsNullOrEmpty() && !ApplyLoan.ETime.IsNullOrEmpty()) { DateTime ETime = ApplyLoan.ETime; p.SqlWhere.Add(f => f.PayTime > ApplyLoan.STime && f.PayTime < ETime); } p.SqlWhere.Add(f => f.PayState == 1); p.PageSize = 99999999; p.OrderByList.Add("Id", "DESC"); IPageOfItems <ApplyLoan> ApplyLoanList = Entity.Selects <ApplyLoan>(p); ViewBag.ApplyLoanList = ApplyLoanList; ViewBag.ApplyLoan = ApplyLoan; IList <ApplyLoan> List = ApplyLoanList.GroupBy(n => n.AgentId).Select(n => n.First()).ToList(); List <int> AgentId = new List <int>(); foreach (var pp in List) { AgentId.Add(pp.AgentId); } ViewBag.SysAgentList = Entity.SysAgent.Where(n => AgentId.Contains(n.Id) && n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Xls = this.checkPower("Xls"); return(View()); }
public ActionResult Index(ApplyLoan ApplyLoan, EFPagingInfo <ApplyLoan> p, bool?IsShowSupAgent, int IsFirst = 0) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } if (!ApplyLoan.TrueName.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TrueName == ApplyLoan.TrueName); } if (!ApplyLoan.Education.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Education.Contains(ApplyLoan.Education)); } if (!ApplyLoan.SheBao.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.SheBao == ApplyLoan.SheBao); } if (!ApplyLoan.Marry.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Marry == ApplyLoan.Marry); } if (!ApplyLoan.HasCar.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.HasCar == (ApplyLoan.HasCar == 99 ? 0 : ApplyLoan.HasCar)); } if (!ApplyLoan.House.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.House == ApplyLoan.House); } if (!ApplyLoan.HasCredit.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.HasCredit == ApplyLoan.HasCredit); } if (!ApplyLoan.State.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.State == ApplyLoan.State); } if (!ApplyLoan.AgentPay.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AgentPay == (ApplyLoan.AgentPay == 99 ? 0 : ApplyLoan.AgentPay)); } if (!ApplyLoan.AgentAId.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == ApplyLoan.AgentAId).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.AgentAId)); } else { p.SqlWhere.Add(f => f.AgentAId == ApplyLoan.AgentAId); } } p.OrderByList.Add("Id", "DESC"); IPageOfItems <ApplyLoan> ApplyLoanList = null; if (IsFirst == 0) { ApplyLoanList = new PageOfItems <ApplyLoan>(new List <ApplyLoan>(), 0, 10, 0, new Hashtable()); } else { ApplyLoanList = Entity.Selects <ApplyLoan>(p); } ViewBag.ApplyLoanList = ApplyLoanList; ViewBag.ApplyLoan = ApplyLoan; ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.Tier == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent; ViewBag.Save = this.checkPower("Save"); return(View()); }
private EFPagingInfo <Orders> Condition(Orders Orders, EFPagingInfo <Orders> p, bool?IsShowSupAgent, int TimeType = 1) { if (Orders.STime.IsNullOrEmpty()) { Orders.STime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); } if (Orders.ETime.IsNullOrEmpty()) { Orders.ETime = DateTime.Now; } if (!Orders.TType.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TType == Orders.TType); } if (!Orders.UId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.UId == Orders.UId); } //是否选择了一个分支机构 if (!Orders.Agent.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == Orders.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 == Orders.Agent); } } if (true) { } if (TimeType == 1)//交易时间 { if (!Orders.STime.IsNullOrEmpty() && !Orders.ETime.IsNullOrEmpty()) { DateTime ETime = Orders.ETime.AddMilliseconds(999); p.SqlWhere.Add(f => f.PayTime > Orders.STime && f.PayTime < 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 == 3 && 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); } 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; } } 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 == 3 && 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.TState == 3) && 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 } else { if (!Orders.STime.IsNullOrEmpty() && !Orders.ETime.IsNullOrEmpty()) { DateTime ETime = Orders.ETime.AddMilliseconds(999); p.SqlWhere.Add(f => f.InTimed > Orders.STime && f.InTimed < ETime); } if (!Orders.TType.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TType == Orders.TType && f.InState == 1); } else { int[] temp = { 1, 7, 8, 9 }; List <int> UID = new List <int>(temp); p.SqlWhere.Add(f => UID.Contains(f.TType) && f.InState == 1); } } return(p); }
/// <summary> /// /// </summary> /// <param name="Orders"></param> /// <param name="p"></param> /// <param name="IsShowSupAgent">是否显示下级</param> /// <param name="LowerLevel">下级代理商</param> /// <returns></returns> public ActionResult Index(Orders Orders, EFPagingInfo <Orders> p, bool?IsShowSupAgent, int?LowerLevel, int IsFirst = 0) { bool IsAll = false; if (checkPower("ALL")) { IsAll = true; } ViewBag.IsAll = IsAll; #region 条件校验 if (IsShowSupAgent == null) { IsShowSupAgent = false; } LowerLevel = LowerLevel == null ? 0 : LowerLevel; p.SqlWhere.Add(f => f.PayState != 0); p.SqlWhere.Add(f => f.TState == 2); if (!Orders.TNum.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TNum == Orders.TNum); } if (!Orders.TName.IsNullOrEmpty()) { IList <Users> UList = Entity.Users.Where(n => n.TrueName == Orders.TName || n.NeekName == 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.TType.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.TType == Orders.TType); } if (!Orders.AId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AId == Orders.AId); } if (!Orders.AgentState.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.AgentState == Orders.AgentState); } if (!Orders.STime.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.PayTime > Orders.STime); } else { Orders.STime = DateTime.Now.AddMonths(-1); } if (!Orders.ETime.IsNullOrEmpty()) { DateTime ETime = Orders.ETime; p.SqlWhere.Add(f => f.PayTime < ETime); } else { Orders.ETime = DateTime.Now; } TimeSpan TS = Orders.ETime.Subtract(Orders.STime); int Days = TS.Days; if (Days > 31) { ViewBag.ErrorMsg = "统计时间间隔不能超过31天!"; return(View("Error")); } if (IsAll) { 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);//读取全部分支机构 } } else { p.SqlWhere.Add(f => f.AId == AdminUser.Id);//读取用户 } #endregion p.OrderByList.Add("Id", "DESC"); IPageOfItems <Orders> OrdersList = null; if (IsFirst == 0) { OrdersList = new PageOfItems <Orders>(new List <Orders>(), 0, 10, 0, new Hashtable()); } else { OrdersList = Entity.Selects <Orders>(p); } ViewBag.OrdersList = OrdersList; ViewBag.Orders = Orders; //统计查询 if (OrdersList.TotalCount > 0) { var iquery = Entity.Orders.AsQueryable(); foreach (var item in p.SqlWhere) { iquery = iquery.Where(item); } //总金额 decimal SumAmoney = iquery.Sum(o => o.Amoney); ViewBag.SumAmoney = SumAmoney; //我的总佣金 decimal?SumMyProfit = Entity.OrderProfitLog.Where(o => o.Agent == BasicAgent.Id).Join(iquery, op => op.TNum, o => o.TNum, (op, o) => op.Profit).Sum(o => (decimal?)o); ViewBag.SumMyProfit = SumMyProfit; } //商户查询 IList <Orders> List = OrdersList.GroupBy(n => n.UId).Select(n => n.First()).ToList(); List <int> UId = new List <int>(); foreach (var pp in List) { UId.Add(pp.UId); } Dictionary <string, decimal> DicOrderProfitLog = new Dictionary <string, decimal>(); IList <Users> UsersList = Entity.Users.Where(n => UId.Contains(n.Id)).ToList(); foreach (var item in OrdersList) { DicOrderProfitLog.Add(item.TNum, Entity.OrderProfitLog.Where(o => o.TNum == item.TNum && o.Agent == BasicAgent.Id).Select(o => o.Profit).FirstOrDefault()); } ViewBag.DicOrderProfitLog = DicOrderProfitLog; ViewBag.UsersList = UsersList; ViewBag.SysAdminList = Entity.SysAdmin.Where(n => n.State == 1 && n.AgentId == AdminUser.AgentId).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.LowerLevel = LowerLevel; ViewBag.Edit = this.checkPower("Edit"); return(View()); }
public ActionResult Index(UserPayChange UserPayChange, EFPagingInfo <UserPayChange> p, bool?IsShowSupAgent, int IsFirst = 0) { if (IsShowSupAgent == null) { IsShowSupAgent = false; } if (IsFirst == 0) { PageOfItems <UserPayChange> UserPayChangeList1 = new PageOfItems <UserPayChange>(new List <UserPayChange>(), 0, 10, 0, new Hashtable()); ViewBag.UserPayChangeList = UserPayChangeList1; ViewBag.UserPayChange = UserPayChange; ViewBag.UsersList = null; ViewBag.SysAdminList = Entity.SysAdmin.Where(n => n.State == 1).ToList(); ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.State == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent;//是否显示下级 return(View()); } //if (UserPayChange.State.IsNullOrEmpty()) //{ // UserPayChange.State = 1; //} //if (UserPayChange.State == 99) //{ // UserPayChange.State = 0; //} if (!UserPayChange.Remark.IsNullOrEmpty()) { IList <Users> UList = Entity.Users.Where(n => n.TrueName.Contains(UserPayChange.Remark) || n.NeekName.Contains(UserPayChange.Remark) || n.UserName == UserPayChange.Remark).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 (!UserPayChange.State.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.State == UserPayChange.State); } if (!UserPayChange.SId.IsNullOrEmpty()) { //是否要显示下级 if ((bool)IsShowSupAgent) { SysAgent LowerLevelAgent = Entity.SysAgent.Where(s => s.Id == UserPayChange.SId).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.SId)); } else { p.SqlWhere.Add(f => f.SId == UserPayChange.SId); } } if (!UserPayChange.SAId.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.SAId == UserPayChange.SAId); } p.OrderByList.Add("Id", "DESC"); IPageOfItems <UserPayChange> UserPayChangeList = null; if (IsFirst == 0) { UserPayChangeList = new PageOfItems <UserPayChange>(new List <UserPayChange>(), 0, 10, 0, new Hashtable()); } else { UserPayChangeList = Entity.Selects <UserPayChange>(p); } ViewBag.UserPayChangeList = UserPayChangeList; ViewBag.UserPayChange = UserPayChange; IList <UserPayChange> List = UserPayChangeList.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.SysAdminList = Entity.SysAdmin.Where(n => n.State == 1).ToList(); ViewBag.SysAgentList = Entity.SysAgent.Where(n => n.State == 1).ToList(); ViewBag.IsShowSupAgent = IsShowSupAgent;//是否显示下级 ViewBag.Edit = this.checkPower("Edit"); ViewBag.Save = this.checkPower("Save"); return(View()); }