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