/// <summary> /// 增加一条数据 /// </summary> public void Add(Wuyiju.Model.DepositRecharge obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } using (var db = new DataContext()) { var _dao = this.GetDao(db); _dao.Insert(obj); } }
public void Recharge(Wuyiju.Model.DepositRecharge obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } if (obj.Huimoney <= 0) { throw new ApplicationException("充值金额有误"); } if (obj.Pay_Type == RechargeType.BankHui) { } using (var db = new DataContext()) { var userSvr = unity.GetInstance <IUserDAL>(db); var rechargeSvr = unity.GetInstance <IDepositRechargeDAL>(db); var user = userSvr.Get(obj.User_Id); var now = DateTime.Now; obj.Sn = string.Format("{0:yyMMdd}{1:d10}", now, rechargeSvr.GetMaxId() + 1); obj.Add_Time = now.ToUnixTimestamp(); obj.Total_Fee = obj.Huimoney; obj.Status = 0; db.BeginTransaction(); try { rechargeSvr.Insert(obj); user.Frozen_Money += obj.Huimoney; userSvr.Update(user); db.Commit(); } catch (Exception ex) { db.Rollback(); throw new ApplicationException("充值出现异常:" + ex.Message); } } }
/// <summary> /// 更新一条数据 /// </summary> public void Modify(Wuyiju.Model.DepositRecharge obj) { if (obj == null) { throw new ApplicationException("参数不能为空"); } var old = dao.Get(obj.Id); if (old == null) { throw new ApplicationException("非法操作记录不存在"); } using (var db = new DataContext()) { var _dao = this.GetDao(db); _dao.Update(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Wuyiju.Model.DepositRecharge model) { StringBuilder sql = new StringBuilder(); sql.Append("update ec_deposit_recharge set "); sql.Append(" sn = @sn , "); sql.Append(" pay_type = @pay_type , "); sql.Append(" status = @status , "); sql.Append(" user_id = @user_id , "); sql.Append(" add_time = @add_time , "); sql.Append(" pay_time = @pay_time , "); sql.Append(" total_fee = @total_fee , "); sql.Append(" pay_fee = @pay_fee , "); sql.Append(" trade_no = @trade_no , "); sql.Append(" txt = @txt , "); sql.Append(" shoukCard = @shoukCard , "); sql.Append(" huiBank = @huiBank , "); sql.Append(" huiMoney = @huiMoney , "); sql.Append(" huiTime = @huiTime , "); sql.Append(" huiUser = @huiUser , "); sql.Append(" huiFile = @huiFile , "); sql.Append(" huiRemark = @huiRemark , "); sql.Append(" user_name = @user_name "); sql.Append(" where id=@id "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("更新数据无效"); } }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Wuyiju.Model.DepositRecharge model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ec_deposit_recharge("); sql.Append("sn,pay_type,status,user_id,add_time,pay_time,total_fee,pay_fee,trade_no,txt,shoukCard,huiBank,huiMoney,huiTime,huiUser,huiFile,huiRemark,user_name"); sql.Append(") values ("); sql.Append("@sn,@pay_type,@status,@user_id,@add_time,@pay_time,@total_fee,@pay_fee,@trade_no,@txt,@shoukCard,@huiBank,@huiMoney,@huiTime,@huiUser,@huiFile,@huiRemark,@user_name"); sql.Append(") "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("插入数据无效"); } }