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