public void UpdateUserBalance(long userId, int price, string rechargeRemark)
{
var entity = userRepository.Find(x => x.Id == userId).FirstOrDefault();
if (entity == null)
{
throw new ServiceException("不存在当前用户");
}
entity.Balance += price;
var rechargeRecord = new RechargeRecord();
rechargeRecord.CreateTime = DateTime.Now;
rechargeRecord.Operator = GetCurrentUser().UserName;
rechargeRecord.UserName = entity.UserName;
rechargeRecord.Price = price;
rechargeRecord.UserId = userId;
rechargeRecord.Remark = rechargeRemark;
userRepository.Transaction(() =>
{
userRepository.Save(entity);
rechargeRepository.Insert(rechargeRecord);
});
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//Column1
//DataGridView view = (DataGridView)sender;
//DataRowView itemRow = (DataRowView)view.Rows[e.RowIndex].DataBoundItem;
if (dataGridView1.DataSource != null && dataGridView1.Rows.Count > 0)
{
List <RechargeRecord> list = DataGridViewUtil.BindingListToList <RechargeRecord>(dataGridView1.DataSource);
if (e.RowIndex > -1 && e.ColumnIndex == Column1.Index)
{
RechargeRecord item = (RechargeRecord)list[e.RowIndex];
InteractResult <RechargeRecord> interResultList = CommonGlobalCache.ServerProxy.GetOneRechargeRecord(item.ID);
RechargeRecord curRecord = interResultList.Data;
EditRechargeFrom form = new EditRechargeFrom(curRecord);
// form.Costume_Newed += Form_Costume_Newed;
/* if (form.ShowDialog() == DialogResult.OK)
* {
* this.RefreshPage();
* }*/
if (form.ShowDialog(this.FindForm()) == DialogResult.OK)
{
Search();
this.RefreshPage();
}
}
}
// form.Show();
}
public JsonResult Create(RechargeRecord rechargeRecord)
{
var customer = customerService.GetCustomer(rechargeRecord.CustomerID);
if (customer == null)
{
return(JsonResult(new APIBaseResponse(false, "CM_002")));
}
if (rechargeRecord.Amount <= 0)
{
return(JsonResult(new APIBaseResponse(false, "CM_003")));
}
var customerAmount = new CustomerAmount
{
CustomerID = rechargeRecord.CustomerID,
Amount = rechargeRecord.Amount,
InUser = rechargeRecord.InUser
};
customerAmountService.CreateCustomerAmount(customerAmount);
rechargeRecordService.CreateRechargeRecord(rechargeRecord);
return(SuccessJsonResult());
}
public IHttpActionResult InsertRechargeRecord(RechargeRecord record)
{
LogHelper.WriteLog("InsertRechargeRecord " + record);
SimpleResult result = new SimpleResult();
IRechargeRecordService _service = new RechargeRecordService();
try
{
if (UserAuthorization)
{
var list = _service.InsertRechargeRecord(record);
result.Resource = list;
result.Status = Result.SUCCEED;
}
else
{
result.Status = ResultType;
result.Resource = ReAccessToken;
result.Msg = TokenMessage;
}
}
catch (Exception ex)
{
LogHelper.WriteLog("InsertRechargeRecord record" + record.ToString(), ex);
result.Status = Result.FAILURE;
result.Msg = ex.Message;
}
LogHelper.WriteLog("InsertRechargeRecord result" + Json(result));
return(Json(result));
}
/// <summary>
/// 添加一条充值记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddNewRecord(RechargeRecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"insert into Sys_RechargeRecord (AccId,OrderNo,State,CardNum,RealNum,PaidNum,GapNum,CardName,AddTime,Oid) Values " +
"(@accId,@orderNo,@state,@cardNum,@realNum,@paidNum,@gapNum,@cardName,@addTime,@oid);");
try
{
return(DapperHelper.Execute(strSql.ToString(), new
{
accId = model.AccId,
orderNo = model.OrderNo,
state = model.State,
cardNum = model.CardNum,
realNum = model.RealNum,
paidNum = model.PaidNum,
gapNum = model.GapNum,
cardName = model.CardName,
addTime = model.AddTime,
oid = model.Oid
}));
}
catch (Exception ex)
{
Logger.Error("添加充值记录出错", ex);
return(0);
}
}
public RechargeRecord GetRechargeRecordByCode(string code)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@rechargeRecord", code, System.Data.DbType.String);
RechargeRecord rechargeRecord = DapperSqlHelper.FindOne <RechargeRecord>("select * from [dbo].[RechargeRecord] where RechargeRecordCode=@rechargeRecord", paras, false);
return(rechargeRecord);
}
public EditRechargeFrom(RechargeRecord Record)
{
InitializeComponent();
curRechargeRecord = Record;
this.skinTextBox_MoneyAlipay.ValueChanged += skinTextBox_Money_ValueChanged;
this.skinTextBox_MoneyBankCard.ValueChanged += skinTextBox_Money_ValueChanged;
this.skinTextBox_MoneyCash.ValueChanged += skinTextBox_Money_ValueChanged;
this.skinTextBox_MoneyWeiXin.ValueChanged += skinTextBox_Money_ValueChanged;
// this.member = _member;
// this.isClose = isClose;
}
//充值
public ActionResult Recharge()
{
string userName = Request["username"];
UserInfoService userInfoService = new UserInfoService();
UserInfo user = userInfoService.LoadEntities(s => s.Name == userName).FirstOrDefault();
if (user == null)
{
throw new Exception("充值失败，充值用户不存！");
}
string money = Request["Money"];
if (!string.IsNullOrEmpty(money))
{
decimal rechargeMoney = decimal.Parse(money);
if (rechargeMoney > 0)
{
//增加一条充值记录
RechargeRecord rechargeRecord = new RechargeRecord();
rechargeRecord.userId = user.id;
rechargeRecord.RechargeBy = User.Identity.Name;
rechargeRecord.RechargeDate = DateTime.Now;
rechargeRecord.RechargeMoney = rechargeMoney;
RechargeRecordService rrs = new RechargeRecordService();
rrs.AddEntity(rechargeRecord);
//更新用户账户信息
Account account = accountService.LoadEntities(s => s.UserId == user.id).FirstOrDefault();
if (account == null)
{
Account accountNew = new Account();
accountNew.UserId = user.id;
accountNew.IsValid = true;
accountNew.Balance = rechargeMoney;
accountService.AddEntity(accountNew);
}
else
{
account.Balance = account.Balance + rechargeMoney;
accountService.UpdateEntity(account);
}
return(Content("ok"));
}
else
{
return(Content("充值失败，充值金额有误！"));
}
}
else
{
return(Content("充值失败，充值金额为空！"));
}
}
/// <summary>
/// 获取充值状态列表
/// </summary>
/// <param name="page"></param>
/// <param name="phoneNum"></param>
/// <param name="orderNo"></param>
/// <returns></returns>
public static string GetRechargeOrderList(int page, string phoneNum, string orderNo)
{
var model = MobileRecharge.GetHistoryOrder(page, 15, phoneNum, orderNo);
if (model.error_code == 0)
{
if (model.result.data != null)
{
foreach (var item in model.result.data)
{
//获取当前最后记录对应的订单ID
//int lastOid = Sys_RechargeRecordBLL.GetLastOid();
var tempModel = T_OrderInfoBLL.GetRechargeOrderListExtend(item.uorderid);
if (tempModel != null)
{
//更新的订单如果在记录表没有记录则插入信息
if (Sys_RechargeRecordBLL.CheckExist(tempModel.oid) == 0)
{
RechargeRecord recordModel = new RechargeRecord();
recordModel.AccId = tempModel.accId;
recordModel.AddTime = item.addtime;
recordModel.CardName = item.cardname;
recordModel.Oid = tempModel.oid;
recordModel.OrderNo = item.uorderid;
recordModel.State = item.game_state;
recordModel.CardNum = Convert.ToInt32(item.cardnum);
recordModel.RealNum = Convert.ToDecimal(item.uordercash);
recordModel.PaidNum = tempModel.RealPayMoney;
recordModel.GapNum = recordModel.RealNum - recordModel.PaidNum;
Sys_RechargeRecordBLL.AddNewRecord(recordModel);
}
item.accModel = T_AccountBLL.GetAccountBasic(tempModel.accId);
}
}
model.result.Summary = Sys_RechargeRecordBLL.GetRecordSum();
return(CommonLib.Helper.JsonSerializeObject(model, "yyyy-MM-dd HH:mm:ss"));
}
else
{
return("");
}
}
return(CommonLib.Helper.JsonSerializeObject(model));
}
private RechargeItemDataModel ProduceProvisionFromForm(RechargeRecord table)
{
if (table.Visible != 0 && table.Platfrom.Equals(platfrom) && table.Type != 3)
{
var _item = new RechargeItemDataModel();
_item.TableId = table.Id;
_item.ItemId = table.ItemId;
_item.GoodName = table.Name;
_item.GoodPrice = table.Price;
_item.GoodType = table.Type;
_item.GoodUnit = GainGoodPart();
_item.PurchaseTimes = PlayerDataManager.Instance.GetExData(table.ExdataId) + 1;
if (_item.GoodType == 0) // 月卡
{
var _timespan = GainMonthSolitaireLastTime();
if (_timespan.TotalSeconds > 0)
{
var _desc = string.Format(table.Desc, (int)_timespan.TotalDays);
_item.GoodDesc = _desc;
_item.Recommendation = false;
}
else
{
_item.GoodDesc = table.ExDesc;
_item.Recommendation = true;
}
}
else if (_item.GoodType == 1) // 普通充值
{
var _lastTimes = table.ExTimes - _item.PurchaseTimes;
if (_lastTimes == 0 || table.ExTimes < 0)
{
var exPercent = ((float)table.ExDiamond / table.Diamond).ToString("0%");
_item.GoodDesc = string.Format(table.ExDesc, table.ExDiamond, exPercent);
_item.Recommendation = true;
}
else
{
var normalPercent = ((float)table.NormalDiamond / table.Diamond).ToString("0%");
_item.GoodDesc = string.Format(table.ExDesc, table.NormalDiamond, normalPercent);
_item.Recommendation = false;
}
}
return(_item);
}
return(null);
}
private RechargeItemDataModel CreateItemFromTable(RechargeRecord table)
{
if (table.Visible != 0 && table.Platfrom.Equals(platfrom) && table.Type != 3)
{
var item = new RechargeItemDataModel();
item.TableId = table.Id;
item.ItemId = table.ItemId;
item.GoodName = table.Name;
item.GoodPrice = table.Price;
item.GoodType = table.Type;
item.GoodUnit = GetGoodUnit();
item.PurchaseTimes = PlayerDataManager.Instance.GetExData(table.ExdataId);
if (item.GoodType == 0) // 月卡
{
var timespan = GetMonthCardLastTime();
if (timespan.TotalSeconds > 0)
{
var desc = string.Format(table.Desc, (int)timespan.TotalDays);
item.GoodDesc = desc;
item.Recommendation = false;
}
else
{
item.GoodDesc = table.ExDesc;
item.Recommendation = true;
}
}
else if (item.GoodType == 1) // 普通充值
{
var lastTimes = table.ExTimes - item.PurchaseTimes;
if (lastTimes > 0)
{
item.GoodDesc = string.Format(table.ExDesc, lastTimes);
item.Recommendation = true;
}
else
{
item.GoodDesc = table.Desc;
item.Recommendation = false;
}
}
return(item);
}
return(null);
}
public bool InsertRechargeRecord(RechargeRecord record)
{
if (string.IsNullOrEmpty(record.RechargeRecordCode))
{
record.RechargeRecordCode = GetMaxCode();
}
DynamicParameters paras = new DynamicParameters();
paras.Add("@RechargeRecordCode", record.RechargeRecordCode, System.Data.DbType.String);
paras.Add("@UserCode", record.UserCode, System.Data.DbType.String);
paras.Add("@RechargeAmount", record.RechargeAmount, System.Data.DbType.String);
paras.Add("@Explain", record.Explain, System.Data.DbType.String);
paras.Add("@CreateTime", record.CreateTime, System.Data.DbType.String);
User userone = DapperSqlHelper.FindOne <User>(@"INSERT INTO [dbo].[RechargeRecord]
([RechargeRecordCode],[UserCode] ,[RechargeAmount] ,[Explain])
VALUES ( @RechargeRecordCode,
@UserCode,
@RechargeAmount,
@Explain,
getdate())", paras, false);
return(true);
}
public static int AddNewRecord(RechargeRecord model)
{
Sys_RechargeRecordDAL dal = new Sys_RechargeRecordDAL();
return(dal.AddNewRecord(model));
}
public void CreateRechargeRecord(RechargeRecord rechargeRecord)
{
rechargeRecordRepository.Insert(rechargeRecord);
unitOfWork.Commit();
}
/// <summary>
/// 充值
/// </summary>
/// <param name="userId">会员id</param>
/// <param name="subject">商品名称</param>
/// <param name="total_fee">交易金额</param>
/// <param name="out_trade_no">商户订单号</param>
/// <param name="body">商品描述</param>
private void Recharge(string userId, string subject, string total_fee, string out_trade_no, string body)
{
using (TransactionScope ts = new TransactionScope())
{
string integralSource = ""; //积分来源
//更新会员表
var user = _memberService.Find(userId.ToInt32());
if (subject.IndexOf("身家", StringComparison.Ordinal) > -1) //如果是身家充值
{
//获得原来的身家
decimal oldShenJia = user.Shenjia ?? 0;
//增加身家
decimal shenJia = oldShenJia + total_fee.ToDecimal();
//修改
user.Shenjia = shenJia;
_memberService.Update(user);
integralSource = "ShenJiaRecharge";
}
else if (subject.IndexOf("会员", StringComparison.Ordinal) > -1) //如果是购买会员
{
if (decimal.Parse(total_fee) == 99) //充值金额为99，则增加一年会员，兑换次数加10
{
int conversions = user.Conversions ?? 0;
int remainingConversions = user.RemainingConversions ?? 0;
DateTime stime = user.Stime ?? DateTime.MinValue; //会员开始时间
DateTime etime = user.Etime ?? DateTime.MinValue; //会员结束时间
DateTime nowTime = DateTime.Now;
if (etime > nowTime) //如果结束时间大于当前时间
{
user.Etime = etime.AddYears(1);
}
else
{
user.Stime = nowTime;
user.Etime = nowTime.AddYears(1);
}
user.Conversions = conversions + 10;
user.RemainingConversions = remainingConversions + 10;
user.Lv = 1;
_memberService.Update(user);
integralSource = "PurchaseVip";
}
}
//else if (subject.IndexOf("押金", StringComparison.Ordinal) > -1) //如果是支付押金
//{
// //获得原来的押金
// decimal oldDeposit = user.Deposit ?? 0;
// //增加押金
// decimal deposit = oldDeposit + decimal.Parse(total_fee);
// //修改
// user.Deposit = deposit;
// _memberService.Update(user);
// integralSource = "Deposit";
//}
//保存到充值记录表
RechargeRecord rechargeRecord = new RechargeRecord
{
UserId = userId,
Source = integralSource,
OrderNo = out_trade_no,
OrderName = subject,
Cnbi = "0",
RMB = total_fee,
WareDesc = body,
AddTime = DateTime.Now,
Status = 1
};
_rechargeRecordService.Add(rechargeRecord);
//保存到积分变更表
if (subject.IndexOf("身家", StringComparison.Ordinal) > -1)
{
IntegralChange integralChange = new IntegralChange
{
UserId = userId,
Source = integralSource,
ShenJia = decimal.Parse(total_fee),
Bean = "0",
Cnbi = "0",
Integral = 0,
Growth = 0,
Status = 1,
Ardent = 0,
AddTime = DateTime.Now
};
_integralChangeService.Add(integralChange);
}
ts.Complete();
}
}
