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