public bool AddAccountLog(Account_Log accountLog) { if (accountLog == null) { return(false); } else { db.Account_Log.Add(accountLog); db.SaveChanges(); return(true); } }
//提现 public ResultInfo <string> OutMoney(PutForwardRecordEntity entity) { ResultInfo <string> resultInfo = new ResultInfo <string>(); if (entity.userid == 0 || entity.money > 10000) { resultInfo.ResultCode = EmResultDescribe.参数错误; resultInfo.ResultData = "请输入有效金额"; } //判断余额是否充足 AccountEntity acc = noAwardBLL.GetAccountInfo(entity.userid); if (entity.money > acc.cash) { resultInfo.ResultCode = EmResultDescribe.参数错误; resultInfo.ResultData = "账户余额不足"; } else { decimal TXmoney = entity.money * (decimal)0.2; SortedDictionary <string, object> resDic = DoOutMoney(TXmoney, acc.openId); if (resDic["result_code"].ToString() == "SUCCESS") { var date = DateTime.Now.ToString(); Account_Log log = new Account_Log(); log.update_time = resDic["payment_time"].ToString(); log.pay_no = resDic["payment_no"].ToString(); log.pay_way = "公司商户"; log.user_id = entity.userid; log.account_id = Convert.ToInt32(acc.accountId); log.collection_account = "微信零钱"; log.cash = entity.money; noAwardBLL.UpdateAccountInfo(log); resultInfo.ResultCode = EmResultDescribe.正确返回结果; resultInfo.ResultData = "提现成功"; } else { resultInfo.ResultCode = EmResultDescribe.缺少必要信息; resultInfo.ResultData = resDic["return_msg"].ToString(); } } return(resultInfo); }
public bool UpdateAccountInfo(Account_Log log) { //添加转账记录 string logSql = @"INSERT INTO [WeChatServiceFlatform].[dbo].[account_log] ([create_time], [update_time], [can_cashing], [bill_type], [pay_no], [pay_way], [user_id], [account_id], [is_freezing], [collection_account], [cash]) VALUES (GETDATE(),@update_time,1,'1',@pay_no,@pay_way,@user_id, @account_id, '0', @collection_account, @cash);"; DynamicParameters insertParam = new DynamicParameters(); insertParam.Add("@update_time", log.update_time); insertParam.Add("@pay_no", log.pay_no); insertParam.Add("@pay_way", log.pay_way); insertParam.Add("@user_id", log.user_id); insertParam.Add("@account_id", log.account_id); insertParam.Add("@collection_account", log.collection_account); insertParam.Add("@cash", log.cash); //跟新账户余额 string Accsql = @"UPDATE [dbo].[account] SET [update_time]=@update_time,[balance]=balance-@cash,[cash]=cash-@cash WHERE [user_id]=@user_id;"; DynamicParameters updateParam = new DynamicParameters(); updateParam.Add("@update_time", log.update_time); updateParam.Add("@cash", log.cash); updateParam.Add("@user_id", log.user_id); using (var conn = new SqlConnection(DBConn.connStr)) { conn.Open(); IDbTransaction transaction = conn.BeginTransaction(); try { conn.Execute(logSql, insertParam, transaction); conn.Execute(Accsql, updateParam, transaction); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); return(false); } return(true); } }
/// <summary> /// 提现加日志 /// </summary> /// <param name="log"></param> /// <returns></returns> public bool UpdateAccountInfo(Account_Log log) { return(noAwardDAL.UpdateAccountInfo(log)); }