//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));
}
