public bool UpdateSingle(User model) { if (model == null) { throw new ArgumentNullException("model"); } var sql = "UPDATE dbo.User_User SET Name=@Name, Email=@Email, Mobile=@Mobile, Status=@Status,GradeId=@GradeId WHERE Id=@Id"; var parameters = new[] { RepositoryContext.CreateParameter("@Name", model.Name), RepositoryContext.CreateParameter("@Email", model.Email), RepositoryContext.CreateParameter("@Mobile", model.Mobile), RepositoryContext.CreateParameter("@Status", model.Status), RepositoryContext.CreateParameter("@GradeId", model.GradeId), RepositoryContext.CreateParameter("@Id", model.Id) }; var count = RepositoryContext.ExecuteNonQuery(sql, parameters); if (count > 0) { return(true); } return(false); }
/// <summary> /// </summary> /// <param name="userId">用户Id</param> /// <param name="moneyTypeid"></param> /// <param name="changedAmount"></param> public bool ChangeFreezeAmount(long userId, Guid moneyTypeid, decimal changedAmount) { var sql = $"update Asset_Account set FreezeAmount=FreezeAmount+{changedAmount} where UserId={userId} and MoneyTypeId='{moneyTypeid}'"; return(RepositoryContext.ExecuteNonQuery(sql) > 0); }
/// <summary> /// Updates the account amount. /// </summary> /// <param name="userId">The user identifier.</param> /// <param name="moneyTypeId">The money type identifier.</param> /// <param name="amount">The amount.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> public bool UpdateAccountAmount(long userId, Guid moneyTypeId, decimal amount) { var sql = $@"update Asset_Account set Amount={amount}, HistoryAmount=(case when {amount}>=Amount then HistoryAmount+{ amount }-Amount else HistoryAmount end) where UserId={userId} and MoneyTypeId='{moneyTypeId}'"; return(RepositoryContext.ExecuteNonQuery(sql) > 0); }
public void SuccessOrder(long shareOrderId) { var sql = "update Things_Trade set Status=@Status ,UpdateTime=GETDATE() where Id=@Id"; var parameters = new[] { RepositoryContext.CreateParameter("@Id", shareOrderId), RepositoryContext.CreateParameter("@Status", Convert.ToInt16(ShareOrderStatus.Handled)), }; RepositoryContext.ExecuteNonQuery(sql, parameters); }
/// <summary> /// 执行脚本 /// </summary> /// <param name="sqlList"></param> private void ExecuteSql(List <string> sqlList) { foreach (var item in sqlList) { try { RepositoryContext.ExecuteNonQuery(item); } catch (Exception ex) { Trace.WriteLine(ex.Message); } } }
/// <summary> /// Errors the order. /// </summary> /// <param name="shareOrderId">The share order identifier.</param> /// <param name="message">The message.</param> public void ErrorOrder(long shareOrderId, string message) { var sql = "update Things_Trade set Summary=@Summary ,Status=@Status ,UpdateTime=GETDATE() where Id=@Id"; var parameters = new[] { RepositoryContext.CreateParameter("@Id", shareOrderId), RepositoryContext.CreateParameter("@Status", Convert.ToInt16(ShareOrderStatus.Error)), RepositoryContext.CreateParameter("@Summary", message) }; RepositoryContext.ExecuteNonQuery(sql, parameters); }
public bool UpdateRecommend(List <long> userIds, long parentId) { var sql = $" update user_user set parentId={parentId} where Id in ({userIds.ToSqlString()})"; var result = RepositoryContext.ExecuteNonQuery(sql); if (result > 0) { return(true); } return(false); }
public void UpdateMap(long userId, string map) { var updateMapSql = "UPDATE dbo.User_UserMap SET ParentMap=@ParentMap WHERE UserId=@UserId"; var parameters2 = new[] { RepositoryContext.CreateParameter("@UserId", userId), RepositoryContext.CreateParameter("@ParentMap", map) }; RepositoryContext.Transation(() => { var count = RepositoryContext.ExecuteNonQuery(updateMapSql, parameters2); }); }
public void ErrorQueue(long id, string message) { var sql = "update Basic_MessageQueue set Status=@status, Message=@message,RequestTime=GETDATE() where Id=@id"; var parameters = new[] { RepositoryContext.CreateParameter("@status", MessageStatus.Error), RepositoryContext.CreateParameter("@message", message), RepositoryContext.CreateParameter("@id", id) }; RepositoryContext.ExecuteNonQuery(sql, parameters); }
/// <summary> /// Changes the account amount. /// </summary> /// <param name="userId">The user identifier.</param> /// <param name="moneyTypeId">The money type identifier.</param> /// <param name="changedAmount">The changed amount.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> public bool ChangeAccountAmount(long userId, Guid moneyTypeId, decimal changedAmount) { var historyUpdateSql = string.Empty; if (changedAmount > 0) { historyUpdateSql = $" ,HistoryAmount=HistoryAmount+{changedAmount}"; } var sql = $"update Asset_Account set Amount=Amount+{changedAmount} {historyUpdateSql} where UserId={userId} and MoneyTypeId='{moneyTypeId}'"; return(RepositoryContext.ExecuteNonQuery(sql) > 0); }
public bool ChangePassword(long userId, string password) { var sql = @"update User_UserDetail set Password=@Password,ModifiedTime=GETDATE() where userId=@userid"; var parameters = new[] { RepositoryContext.CreateParameter("@Password", password), RepositoryContext.CreateParameter("@userid", userId) }; var count = RepositoryContext.ExecuteNonQuery(sql, parameters); if (count > 0) { return(true); } return(false); }
public void Pay(DbTransaction transaction, Bill bill, Account account) { var sqlAccount = $@"UPDATE [dbo].[Asset_Account] SET [Amount] = {account.Amount} ,[FreezeAmount] = {account.FreezeAmount} ,[HistoryAmount] = {account.HistoryAmount} WHERE Id={account.Id}"; var sqlBill = $@"INSERT INTO [dbo].[Asset_Bill]([UserId] ,[OtherUserId] ,[Type] ,[Flow] ,[MoneyTypeId],[Amount] ,[AfterAmount],[Intro] ,[CreateTime] ,[EntityId]) VALUES ({bill.UserId} ,{bill.OtherUserId} ,{(int)bill.Type} ,{(int)bill.Flow} ,'{bill.MoneyTypeId}' ,{bill.Amount} ,{bill.AfterAmount} ,'{bill.Intro}' ,'{bill.CreateTime}' ,{bill.EntityId})"; RepositoryContext.ExecuteNonQuery(transaction, sqlBill); RepositoryContext.ExecuteNonQuery(transaction, sqlAccount); }
public void HandleQueueAndUpdateContent(long id, string message = null, string summary = null) { if (message == null) { message = string.Empty; } if (summary == null) { summary = string.Empty; } var sql = "update Basic_MessageQueue set Status=@status, Message=@message, Summary=@summary,RequestTime=GETDATE() where Id=@id"; var parameters = new[] { RepositoryContext.CreateParameter("@status", MessageStatus.Handled), RepositoryContext.CreateParameter("@message", message), RepositoryContext.CreateParameter("@summary", summary), RepositoryContext.CreateParameter("@id", id) }; RepositoryContext.ExecuteNonQuery(sql, parameters); }
/// <summary> /// 添加商品库存 /// </summary> /// <param name="productId"></param> /// <param name="productSkuId"></param> /// <param name="count"></param> public bool AddStock(long productId, long productSkuId, int count) { var result = false; using (var transaction = RepositoryContext.BeginNativeDbTransaction()) { try { var sql = $"update Shop_Product set Stock=Stock+{count} where Id={productId}"; RepositoryContext.ExecuteNonQuery(transaction, sql); sql = $"update Shop_ProductSku set Stock=Stock+{count} where Id='{productSkuId}'"; RepositoryContext.ExecuteNonQuery(transaction, sql); transaction.Commit(); result = true; } catch { transaction.Rollback(); throw; } } return(result); }
/// <summary> /// 更新分润模块执行次数 /// </summary> /// <param name="shareOrderId">The share order identifier.</param> /// <param name="count">The count.</param> public void UpdateExcuteCount(long shareOrderId, long count) { var sql = $"update Things_Trade set ExecuteCount=ExecuteCount+{count} where Id={shareOrderId}"; RepositoryContext.ExecuteNonQuery(sql); }
public void Cancel(long id) { var sql = $"update Basic_MessageQueue set Status={(byte)MessageStatus.Canceld} where Id={id}"; RepositoryContext.ExecuteNonQuery(sql); }