public ActionResult Create(ZJ_UserBalanceModel model) { if (ModelState.IsValid) { ResultModel resultModel = new ResultModel(); if (model.AddOrCutAmount >= 0) { model.AddOrCutType = 15; } else { model.AddOrCutType = 16; SearchZJ_UserBalanceModel smodel = new SearchZJ_UserBalanceModel(); smodel.UserID = model.UserID; smodel.PagedIndex = 0; smodel.PagedSize = 100; //获取用户余额,用于判断最多扣款 List <ZJ_UserBalanceModel> List = this._zjUserBalanceService.GetZJ_UserBalanceList(smodel).Data; if (List != null && List.Count > 0) { ZJ_UserBalanceModel zjubmodel = List[0]; if (zjubmodel.ConsumeBalance + model.AddOrCutAmount < 0) { resultModel.Messages = new List <string> { "Insufficient balance!" }; return(Json(resultModel, JsonRequestBehavior.AllowGet)); } } } model.IsDisplay = 1; var result = ZJ_UserBalanceCommon.UpdateZJ_UserBalance(model); resultModel.Messages = new List <string> { result == true ? "Recharge success!" : "Recharge failed!" }; var opera = string.Empty; opera += " UserID:" + model.UserID + ",AddOrCutAmount(充值金额):" + model.AddOrCutAmount + ",结果:" + result; LogPackage.InserAC_OperateLog(opera, "账户管理-用户账户信息-余额充值"); return(Json(resultModel, JsonRequestBehavior.AllowGet)); } return(PartialView(model)); }
/// <summary> /// 列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult List(SearchZJ_UserBalanceModel model) { model.PagedIndex = model.PagedIndex == 0 ? 0 : model.PagedIndex; model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; //查询列表 var result = this._zjUserBalanceService.GetZJ_UserBalanceList(model); List <ZJ_UserBalanceModel> ds = result.Data; var data = new { rows = ds, total = result.Data.TotalCount, }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> ///数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Create(long?id) { ZJ_UserBalanceModel model = new ZJ_UserBalanceModel(); if (id.HasValue) { SearchZJ_UserBalanceModel smodel = new SearchZJ_UserBalanceModel(); smodel.UserID = id.Value; smodel.PagedIndex = 0; smodel.PagedSize = 100; //查询列表 List <ZJ_UserBalanceModel> List = this._zjUserBalanceService.GetZJ_UserBalanceList(smodel).Data; if (List != null && List.Count > 0) { model = List[0]; } } return(PartialView(model)); }
/// <summary> /// 获取用户余额信息表 /// </summary> /// <param name="model">model</param> /// <returns>退换用户余额信息表</returns> public ResultModel GetZJ_UserBalanceList(SearchZJ_UserBalanceModel model) { var tb = _database.Db.ZJ_UserBalance; var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); // if (!string.IsNullOrEmpty(model.RealName) && model.RealName.Trim() != "") { //用户真实姓名 where = new SimpleExpression(where, _database.Db.YH_User.RealName.Like("%" + model.RealName.Trim() + "%"), SimpleExpressionType.And); } if (!string.IsNullOrEmpty(model.Phone) && model.Phone.Trim() != "") { //用户手机 where = new SimpleExpression(where, _database.Db.YH_User.Phone.Like("%" + model.Phone.Trim() + "%"), SimpleExpressionType.And); } if (!string.IsNullOrEmpty(model.Email) && model.Email.Trim() != "") { //Email where = new SimpleExpression(where, _database.Db.YH_User.Email.Like("%" + model.Email.Trim() + "%"), SimpleExpressionType.And); } if (!string.IsNullOrEmpty(model.Account) && model.Account.Trim() != "") { //用户真实姓名 where = new SimpleExpression(where, _database.Db.YH_User.Account.Like("%" + model.Account.Trim() + "%"), SimpleExpressionType.And); } if (model.UserID > 0) { //用户ID where = new SimpleExpression(where, tb.UserID == model.UserID, SimpleExpressionType.And); } dynamic pc; dynamic zjlog; var query = tb .Query() //.LeftJoin(_database.Db.ZJ_UserBalanceChangeLog, out zjlog) //.On(_database.Db.ZJ_UserBalanceChangeLog.UserID == tb.UserID) .LeftJoin(_database.Db.YH_User, out pc) .On(_database.Db.YH_User.UserID == tb.UserID) .Select( tb.UserID, tb.ConsumeBalance, tb.Vouchers, tb.AccountStatus, tb.CreateBy, tb.CreateDT, tb.UpdateBy, tb.UpdateDT, //zjlog.Remark, pc.Phone, pc.RealName, pc.Email, pc.NickName, pc.Account ) .Where(where) .OrderByUserIDDescending(); var result = new ResultModel { Data = new SimpleDataPagedList <ZJ_UserBalanceModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }