public JsonResult Compensate(string userId, int intergal, string cause, bool isActive, string id, int transactionIntegral) { if (ControllerContext.HttpContext.User == null) { return(Json(new { result = "false" })); } InsertIntergalModal insertIntergal = new InsertIntergalModal() { UserId = new Guid(userId), IntegralDetailID = Guid.NewGuid(), Integral = intergal, IntegralID = new Guid(id), IntegralRuleID = new Guid("6fa89adc-b26a-44db-9f59-2a033bd17e0b"), TransactionIntegral = transactionIntegral, TransactionRemark = "活动积分补偿", //规则的描述 TransactionDescribe = cause, IsActive = isActive, TransactionChannel = "pc", Versions = "1.0.0.0", Author = ControllerContext.HttpContext.User.Identity.Name }; int returnCount = new BizUserIntergal().InsertIntergal(insertIntergal); string result = returnCount == 0 ? "false" : "true"; return(Json(new { msg = result })); }
public int InsertIntergal(InsertIntergalModal insertIntergal) { return(new DALUserIntergal().InsertIntergal(insertIntergal)); }
public int InsertIntergal(InsertIntergalModal insertIntergal) { #region sql SqlParameter[] parameters = { new SqlParameter("@IntegralDetailID", insertIntergal.IntegralDetailID), new SqlParameter("@IntegralID", insertIntergal.IntegralID), new SqlParameter("@IntegralRuleID", insertIntergal.IntegralRuleID), new SqlParameter("@TransactionIntegral", insertIntergal.TransactionIntegral), //增加的积分 new SqlParameter("@TransactionRemark", insertIntergal.TransactionRemark), new SqlParameter("@TransactionDescribe", insertIntergal.TransactionDescribe), //增加的积分的描述原因 new SqlParameter("@IsActive", insertIntergal.IsActive), //默认启用有效 new SqlParameter("@TransactionChannel", insertIntergal.TransactionChannel), new SqlParameter("@Versions", insertIntergal.Versions) }; string sql = @"INSERT INTO Tuhu_profiles..tbl_UserIntegralDetail (IntegralDetailID, IntegralID, IntegralRuleID, TransactionIntegral, TransactionRemark, TransactionDescribe, IsActive, TransactionChannel, Versions, CreateDateTime, LasetUpdateTime ) VALUES( @IntegralDetailID, @IntegralID, @IntegralRuleID, @TransactionIntegral, @TransactionRemark, @TransactionDescribe, @IsActive, @TransactionChannel, @Versions, GETDATE(), GETDATE() ); "; SqlParameter[] parameterUpdate = { new SqlParameter("@Integral", insertIntergal.Integral + insertIntergal.TransactionIntegral), new SqlParameter("@UserID", insertIntergal.UserId) }; string sqlUpdate = @" UPDATE Tuhu_profiles..tbl_UserIntegral SET Integral=@Integral WHERE UserID=@UserID "; string sqlLog = @"INSERT INTO [Tuhu_Log].[dbo].[tbl_UserIntegralDetailLog] ( [IntegralDetailID] , [IntegralRuleID] , [Author] , [ChangeResult] , [Reason] , [CreateTime] , [UpdateTime] , [Remark] ) VALUES ( @IntegralDetailID , @IntegralRuleID , @Author , @ChangeResult , @Reason , GETDATE() , GETDATE() , @Remark )"; #endregion int result = 0; using (var dbHelper = new SqlDbHelper(strConn)) { try { dbHelper.BeginTransaction(); //新增用户积分详情 result = SqlHelper.ExecuteNonQuery(conn, Text, sql, parameters); //修改用户的总积分 if (result > 0) { result = SqlHelper.ExecuteNonQuery(conn, Text, sqlUpdate, parameterUpdate); } dbHelper.Commit(); } catch (Exception ex) { dbHelper.Rollback(); } } //插入日志表 if (result > 0) { var connLog = ConfigurationManager.ConnectionStrings["Tuhu_log"].ConnectionString; if (SecurityHelp.IsBase64Formatted(connLog)) { connLog = SecurityHelp.DecryptAES(connLog); } using (var dbhelper = new SqlDbHelper(connLog)) { var cmd = new SqlCommand(sqlLog); cmd.CommandType = Text; cmd.Parameters.AddWithValue("@IntegralDetailID", insertIntergal.IntegralDetailID); cmd.Parameters.AddWithValue("@IntegralRuleID", insertIntergal.IntegralRuleID); cmd.Parameters.AddWithValue("@Author", insertIntergal.Author); cmd.Parameters.AddWithValue("@ChangeResult", insertIntergal.IsActive); cmd.Parameters.AddWithValue("@Reason", insertIntergal.TransactionDescribe); cmd.Parameters.AddWithValue("@Remark", insertIntergal.TransactionRemark); dbhelper.ExecuteNonQuery(cmd); } } return(result); }