public void Update(RebateInfo entity)
{
using (SqlConnection conn = new SqlConnection(connectString))
{
string sql = @"UPDATE [Rebate] SET [Distributor_Id]=@Distributor_Id,[Commission]=@Commission,[Time]=@Time WHERE [Id]=@Id";
conn.Execute(sql, entity);
}
}
public int Add(RebateInfo entity)
{
int id = 0;
#region 事务：添加返佣记录，计算分销商 总佣金
using (SqlConnection conn = new SqlConnection(connectString))
{
conn.Open();
using (var transaction = conn.BeginTransaction())
{
try
{
//添加返佣记录
string sql = @"INSERT INTO [Rebate]([Distributor_Id],[User_Id],[Order_Id],[Commission],[Time]) VALUES(@Distributor_Id,@User_Id,@Order_Id,@Commission,@Time);
SELECT SCOPE_IDENTITY()";
id = conn.Query <int>(sql, entity, transaction).Single();
if (id > 0)
{
// 计算计算分销商 总佣金
sql = @"UPDATE [Usr] SET [Total_Commission]=[Total_Commission]+@commsion WHERE [Id]=@Distributor_Id";
int rows = conn.Execute(sql, new { commsion = entity.Commission, Distributor_Id = entity.Distributor_Id }, transaction);
if (rows > 0)
{
transaction.Commit();
}
else
{
id = 0;
transaction.Rollback();
}
}
else
{
id = 0;
transaction.Rollback();
}
}
catch (Exception ex)
{
id = 0;
transaction.Rollback();
}
}
}
#endregion
return(id);
}
public static int Add(RebateInfo entity)
{
return(dal.Add(entity));
}
