//private string vkey = "VbrokerageRedis"; //private string key = "brokerageRedis"; //RedisHelper<ViewColonelAndBrokerage> vrh = new RedisHelper<ViewColonelAndBrokerage>(); //RedisHelper<Model.Brokerage> rh = new RedisHelper<Model.Brokerage>(); //List<ViewColonelAndBrokerage> Vjoinls = new List<ViewColonelAndBrokerage>(); //List<Model.Brokerage> joinls = new List<Model.Brokerage>(); //RedisHelper<Model.Brokerage> rhadd = new RedisHelper<Model.Brokerage>(); //List<Model.Brokerage> brokeragels = new List<Model.Brokerage>(); //public BrokerageRepository() //{ // Vjoinls = vrh.Get(vkey); // joinls = rh.Get(key); // // brokeragels = rhadd.Get(key); //} /// <summary> /// 添加佣金流水 /// </summary> /// <param name="brokerage"></param> /// <returns></returns> public int AddBrokerage(Model.Brokerage brokerage) { try { string sql = $" insert into Brokerage values (null,{brokerage.ColonelID},{brokerage.BrokerageType},{brokerage.Income},{brokerage.State},'{brokerage.EndTime}',{brokerage.OrderFormStatus}) "; int i = DapperHelper.Execute(sql); //if (i > 0) //{ // //重新获取视图数据 // Vjoinls = DapperHelper.GetList<ViewColonelAndBrokerage>(" select * from Brokerage a join colonel b on a.ColonelID=b.ColonelID "); // Vjoinls.Add(DapperHelper.GetList<Model.ViewColonelAndBrokerage>(" select * from brokerage order by BId desc limit 1 ").FirstOrDefault()); // //joinls.Add(brokerage); // rh.Set(key, joinls); // vrh.Set(vkey, Vjoinls); //} //brokeragels.Add(brokerage); //rhadd.Set(key, brokeragels); return(i); } catch (Exception) { throw; } }
/// <summary> /// 修改佣金流水 /// </summary> /// <param name="brokerage"></param> /// <returns></returns> public int UptBrokerage(Model.Brokerage brokerage) { try { string sql = $" update Brokerage set ColonelID={brokerage.ColonelID},BrokerageType={brokerage.BrokerageType},Income={brokerage.Income},State={brokerage.State},EndTime='{brokerage.EndTime}',OrderFormStatus={brokerage.OrderFormStatus} "; return(DapperHelper.Execute(sql)); } catch (Exception) { throw; } }
public int AddBrokerage(Model.Brokerage brokerage) { int i = _brokerageRepository.AddBrokerage(brokerage); if (i > 0) { logger.Debug($"添加佣金流水成功,id为{brokerage.BId}"); } else { logger.Debug($"添加佣金流水失败,id为{brokerage.BId}"); } return(i); }
/// <summary> /// 添加佣金流水 /// </summary> /// <param name="brokerage"></param> /// <returns></returns> public int AddBrokerage(Model.Brokerage brokerage) { string sql = $" insert into Brokerage values (null,{brokerage.ColonelID},{brokerage.BrokerageType},{brokerage.Income},{brokerage.State},'{brokerage.EndTime}',{brokerage.OrderFormStatus}) "; return(DapperHelper.Execute(sql)); }