/// <summary>
/// 用户余额变动记录
/// zhoub 20150714
/// </summary>
/// <returns></returns>
public ActionResult UserBalanceChangeIndex(string userID)
{
//TempData["AddOrCutTypeEnum"] =SimpleReocrdExtensions.ToSelectListItem((Enum)AddOrCutTypeEnum.充值);
SearchUserBalanceChangeModel searchModel = new SearchUserBalanceChangeModel();
searchModel.UserID = !string.IsNullOrEmpty(userID) ? long.Parse(userID) : 0;//modified by jimmy,2015-8-29
TempData["AddOrCutTypeEnum"] = SelectCommon.GetAmountChangeType();
return(View());
}
/// <summary>
/// 分页余额变动记录
/// </summary>
/// <param name="model">搜索模型</param>
/// <returns>列表数据</returns>
public ResultModel GetPagingZJ_UserBalanceChangeLog(SearchUserBalanceChangeModel model)
{
var tb = _database.Db.ZJ_UserBalanceChangeLog;
var whereExpr = _database.Db.YH_User.Account.Like("%" + model.Account + "%");
if (model.UserID != null)
{
whereExpr = new SimpleExpression(whereExpr, tb.UserID == model.UserID, SimpleExpressionType.And);
}
if (model.ID != null)
{
whereExpr = new SimpleExpression(whereExpr, tb.ID == model.ID, SimpleExpressionType.And);
}
if (model.RealName != null)
{
whereExpr = new SimpleExpression(whereExpr, _database.Db.YH_User.RealName.Like("%" + model.RealName + "%"), SimpleExpressionType.And);
}
if (model.IsAddOrCut != -1)
{
whereExpr = new SimpleExpression(whereExpr, tb.IsAddOrCut == model.IsAddOrCut, SimpleExpressionType.And);
}
if (model.AddOrCutType != null && model.AddOrCutType.Value != 0)//modified by jimmy,2015-8-29
{
whereExpr = new SimpleExpression(whereExpr, tb.AddOrCutType == model.AddOrCutType, SimpleExpressionType.And);
}
if (model.CreateBy != null)
{
whereExpr = new SimpleExpression(whereExpr, tb.CreateBy.Like("%" + model.CreateBy + "%"), SimpleExpressionType.And);
}
if (model.OrderNo != null)
{
whereExpr = new SimpleExpression(whereExpr, tb.OrderNo.Like("%" + model.OrderNo + "%"), SimpleExpressionType.And);
}
if (model.CreateDTBegin != null)
{
whereExpr = new SimpleExpression(whereExpr, tb.CreateDT >= model.CreateDTBegin, SimpleExpressionType.And);
}
if (model.CreateDTEnd != null)
{
whereExpr = new SimpleExpression(whereExpr, tb.CreateDT < Convert.ToDateTime(model.CreateDTEnd).AddDays(1), SimpleExpressionType.And);
}
var result = new ResultModel
{
Data =
new SimpleDataPagedList <UserBalanceChange>(_database.Db.ZJ_UserBalanceChangeLog.All().LeftJoin(_database.Db.YH_User).On(_database.Db.YH_User.UserID == _database.Db.ZJ_UserBalanceChangeLog.UserID).Select(_database.Db.ZJ_UserBalanceChangeLog.ID, _database.Db.ZJ_UserBalanceChangeLog.UserID, _database.Db.ZJ_UserBalanceChangeLog.AddOrCutAmount, _database.Db.ZJ_UserBalanceChangeLog.IsAddOrCut, _database.Db.ZJ_UserBalanceChangeLog.OldAmount, _database.Db.ZJ_UserBalanceChangeLog.NewAmount, _database.Db.ZJ_UserBalanceChangeLog.AddOrCutType, _database.Db.ZJ_UserBalanceChangeLog.OrderNo, _database.Db.ZJ_UserBalanceChangeLog.Remark, _database.Db.ZJ_UserBalanceChangeLog.IsDisplay, _database.Db.ZJ_UserBalanceChangeLog.CreateBy, _database.Db.ZJ_UserBalanceChangeLog.CreateDT, _database.Db.YH_User.Account, _database.Db.YH_User.RealName).Where(whereExpr), model.PagedIndex, model.PagedSize)
};
return(result);
}
/// <summary>
/// 用户余额变动数据获取
/// zhoub 20150714
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
public JsonResult GetUserBalanceChangeList(SearchUserBalanceChangeModel searchModel)
{
var result = _yh_UserService.GetPagingZJ_UserBalanceChangeLog(searchModel);
var data = new
{
rows = result.Data,
total = result.Data.TotalCount,
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
