public ActionResult Delete(FastPayWay FastPayWay) { if (FastPayWay.Id != 0) { FastPayWay = Entity.FastPayWay.FirstOrDefault(n => n.Id == FastPayWay.Id); } if (FastPayWay == null) { ViewBag.ErrorMsg = "数据不存在"; return(View("Error")); } try { Entity.FastPayWay.DeleteObject(FastPayWay); Entity.SaveChanges(); APIExtensions.ClearCacheAll(); ViewBag.Msg = "删除成功"; return(View("Succeed")); } catch { ViewBag.Msg = "删除失败"; return(View("Error")); } }
public void Save(PayConfig PayConfig, string[] queryArray, int?AnsyCash, int?AnsyAgent) { PayConfig.Cost = PayConfig.Cost / 1000; PayConfig.CostAgent = PayConfig.CostAgent / 1000; PayConfig.CostUser = PayConfig.CostUser / 1000; if (PayConfig.Cost < 0 || PayConfig.CostUser < 0 || PayConfig.CostUser > 1 || PayConfig.Cost > 1 || PayConfig.Cost > PayConfig.CostUser) { Response.Redirect("/Manage/Home/Error.html?IsAjax=1&msg=费率设置有误"); return; } PayConfig basePayConfig = Entity.PayConfig.FirstOrDefault(n => n.Id == PayConfig.Id); //如果是微信支付配置的子商户号没有填写的话,去掉这个元素 if (basePayConfig.DllName == "WeiXin") { if (queryArray[4].IsNullOrEmpty()) { var temp = new ArrayList(queryArray); temp.RemoveAt(4); queryArray = (string[])temp.ToArray(typeof(string)); } } if (queryArray != null) { basePayConfig.QueryArray = string.Join(",", queryArray); } basePayConfig = Request.ConvertRequestToModel <PayConfig>(basePayConfig, PayConfig); Entity.SaveChanges(); if (AnsyCash == 1) { //使用删除全部后根据用户表生成,有效解决了因接口关闭或新增加接口,老用户没有配置问题 string SQL = "Delete UserPay Where PId=" + basePayConfig.Id; Entity.ExecuteStoreCommand(SQL); SQL = "INSERT INTO UserPay(UId,PId,Cost,IsDel) Select ID," + basePayConfig.Id + " As PId," + basePayConfig.CostUser + " As Cost, 0 As IsDel From Users"; Entity.ExecuteStoreCommand(SQL); } if (AnsyAgent == 1) { //使用删除全部后根据用户表生成,有效解决了因接口关闭或新增加接口,老用户没有配置问题 string SQL = "Delete UserPayAgent Where PId=" + basePayConfig.Id; Entity.ExecuteStoreCommand(SQL); SQL = "INSERT INTO UserPayAgent(AId,PId,Cost,IsDel) Select ID," + basePayConfig.Id + " As PId," + basePayConfig.CostUser + " As Cost, 0 As IsDel From SysAgent"; Entity.ExecuteStoreCommand(SQL); } if (AnsyAgent == 1 || AnsyCash == 1) { APIExtensions.ClearCacheAll(); } BaseRedirect(); }
public void MoneySave(SysSet SysSet, int?AnsyCash0, int?AnsyCash1, int?AnsyAgent0, int?AnsyAgent1) { SysSet.House = SysSet.House / 1000; SysSet.Cash0 = SysSet.Cash0 / 1000; SysSet.Cash1 = SysSet.Cash1 / 1000; SysSet.SysCash0 = SysSet.SysCash0 / 1000; SysSet.SysCash1 = SysSet.SysCash1 / 1000; SysSet.AgentCash0 = SysSet.AgentCash0 / 1000; SysSet.AgentCash1 = SysSet.AgentCash1 / 1000; SysSet.PayConfigAgent = SysSet.PayConfigAgent / 100; SysSet baseSysSet = BasicSet; SysSet.BaoUserAlert = SysSet.BaoUserAlert ?? string.Empty; SysSet.CashAlertMsgT0 = SysSet.CashAlertMsgT0 ?? string.Empty; SysSet.CashAlertMsgT1 = SysSet.CashAlertMsgT1 ?? string.Empty; baseSysSet = Request.ConvertRequestToModel <SysSet>(baseSysSet, SysSet); Entity.SaveChanges(); if (AnsyAgent0 == 1) { string SQL = "Update SysAgent Set ECash0=" + baseSysSet.ECash0 + ",Cash0=" + baseSysSet.Cash0 + ",Cash0Times=" + baseSysSet.Cash0Times; Entity.ExecuteStoreCommand(SQL); } if (AnsyAgent1 == 1) { string SQL = "Update SysAgent Set ECash1=" + baseSysSet.ECash1 + ",Cash1=" + baseSysSet.Cash1 + ",Cash1Times=" + baseSysSet.Cash1Times; Entity.ExecuteStoreCommand(SQL); } if (AnsyCash0 == 1) { string SQL = "Update Users Set ECash0=" + baseSysSet.ECash0 + ",Cash0=" + baseSysSet.Cash0; Entity.ExecuteStoreCommand(SQL); } if (AnsyCash1 == 1) { string SQL = "Update Users Set ECash1=" + baseSysSet.ECash1 + ",Cash1=" + baseSysSet.Cash1; Entity.ExecuteStoreCommand(SQL); } if (AnsyAgent0 == 1 || AnsyAgent1 == 1 || AnsyCash0 == 1 || AnsyCash1 == 1) { APIExtensions.ClearCacheAll(); } Response.Redirect("/Manage/SysSet/Money.html"); }
public ActionResult Save(FastPayWay FastPayWay, string[] queryArray, int STimeHH, int STimemm, int ETimeHH, int ETimemm) { FastPayWay.Cost = FastPayWay.Cost / 1000; FastPayWay.Cost2 = FastPayWay.Cost2 / 1000; FastPayWay.Cost3 = FastPayWay.Cost3 / 1000; FastPayWay.BankCost = FastPayWay.BankCost / 1000; FastPayWay.BankCost2 = FastPayWay.BankCost2 / 1000; FastPayWay.BankCost3 = FastPayWay.BankCost3 / 1000; FastPayWay.InCost = FastPayWay.InCost / 1000; FastPayWay.InCost2 = FastPayWay.InCost2 / 1000; FastPayWay.InCost3 = FastPayWay.InCost3 / 1000; if (FastPayWay.Cost < 0 || FastPayWay.BankCost < 0 || FastPayWay.Cost >= 1) { ViewBag.ErrorMsg = "费率设置有误"; return(View("Error")); } FastPayWay baseFastPayWay = Entity.FastPayWay.FirstOrDefault(n => n.Id == FastPayWay.Id); if (baseFastPayWay != null)//修改直通车通道 { //如果是微信支付配置的子商户号没有填写的话,去掉这个元素 if (baseFastPayWay.DllName == "WeiXin") { if (queryArray[4].IsNullOrEmpty()) { var temp = new ArrayList(queryArray); temp.RemoveAt(4); queryArray = (string[])temp.ToArray(typeof(string)); } } if (queryArray != null) { baseFastPayWay.QueryArray = string.Join(",", queryArray); } baseFastPayWay = Request.ConvertRequestToModel <FastPayWay>(baseFastPayWay, FastPayWay); baseFastPayWay.HasAliPay = FastPayWay.HasAliPay; baseFastPayWay.HasBank = FastPayWay.HasBank; baseFastPayWay.HasWeiXin = FastPayWay.HasWeiXin; DateTime STime = DateTime.Parse("1990-01-01 " + STimeHH + ":" + STimemm + ":00"); DateTime ETime = DateTime.Parse("1990-01-01 " + ETimeHH + ":" + ETimemm + ":" + (ETimeHH == 23 && ETimemm == 59 ? "59" : "00")); baseFastPayWay.STime = STime; baseFastPayWay.ETime = ETime; } else//添加直通车通道 { FastPayWay.Title = "测试名称"; FastPayWay.DllName = "HFJSPay"; FastPayWay.AddTime = DateTime.Now; FastPayWay.GroupType = "D0"; FastPayWay.Version = "V1.0.0"; FastPayWay.CanOpenBank = 1; DateTime STime = DateTime.Parse("1990-01-01 " + STimeHH + ":" + STimemm + ":00"); DateTime ETime = DateTime.Parse("1990-01-01 " + ETimeHH + ":" + ETimemm + ":" + (ETimeHH == 23 && ETimemm == 59 ? "59" : "00")); FastPayWay.STime = STime; FastPayWay.ETime = ETime; Entity.FastPayWay.AddObject(FastPayWay); } Entity.SaveChanges(); APIExtensions.ClearCacheAll(); ViewBag.Msg = "操作成功"; return(View("Succeed")); }
public void Save(int[] PId, double[] Cost, int[] PState, int?AnsyCash, int?AnsyNext) { bool Check = true; for (int i = 0; i < PId.Length; i++) { int Pid = PId[i]; double cost = Cost[i] / 1000; PayConfig PC = Entity.PayConfig.FirstOrDefault(n => n.Id == Pid); if (PC == null) { Check = false; } if (cost >= PC.CostAgent) { UserPayAgent PCT = Entity.UserPayAgent.FirstOrNew(n => n.AId == BasicAgent.Id && n.PId == Pid); PCT.Cost = Cost[i] / 1000; if (PCT.Id.IsNullOrEmpty()) { PCT.PId = PId[i]; PCT.AId = BasicAgent.Id; Entity.UserPayAgent.AddObject(PCT); } } else { Check = false; } } if (Check) { Entity.SaveChanges(); } else { Response.Redirect("/Agent/home/error.html?msg=费率设置有误~"); return; } 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 == BasicAgent.Id).ToList(); //取得代理商所有的下级 AgentList = BasicAgent.GetSupAgent(Entity, true); 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 == BasicAgent.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 == BasicAgent.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); } } if (AnsyCash == 1 || AnsyNext == 1) { APIExtensions.ClearCacheAll(); } BaseRedirect(); }