/// <summary> /// 获取用户资金异动记录 /// </summary> /// <param name="model">model</param> /// <returns></returns> public ResultModel GetUserBalanceChangeLogList(SearchZJ_UserBalanceChangeLogModel model) { var log = _database.Db.ZJ_UserBalanceChangeLog; var logType = _database.Db.ZJ_AmountChangeType_lang; var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); // //移动类型语言ID where = new SimpleExpression(where, logType.LanguageID == model.LanguageId, SimpleExpressionType.And); if (model.AddOrCutTypeArry.Length > 0) { //异动类型 where = new SimpleExpression(where, log.AddOrCutType == model.AddOrCutTypeArry, SimpleExpressionType.And); } //显示 where = new SimpleExpression(where, log.IsDisplay == 1, SimpleExpressionType.And); if (model.UserID > 0) { //用户ID where = new SimpleExpression(where, log.UserID == model.UserID, SimpleExpressionType.And); } if (model.EndCreateDT != null && model.EndCreateDT.Value.Year != 0001) { //结束 时间加一天是为了查询结束当天的数据 where = new SimpleExpression(where, log.CreateDT < model.EndCreateDT, SimpleExpressionType.And); } if (model.BeginCreateDT != null && model.BeginCreateDT.Value.Year != 0001) { //开始时间 where = new SimpleExpression(where, log.CreateDT >= model.BeginCreateDT, SimpleExpressionType.And); } var query = log .Query() .LeftJoin(logType) .On(logType.ID == log.AddOrCutType) .Select( log.ID, log.AddOrCutAmount, log.IsAddOrCut, log.AddOrCutType, log.OrderNo, log.CreateDT, logType.TypeName ) .Where(where) .OrderByCreateDTDescending(); var result = new ResultModel { Data = new SimpleDataPagedList <ZJ_UserBalanceChangeLogModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }
/// <summary> /// 列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult List(SearchZJ_UserBalanceChangeLogModel model) { //SearchAC_OperateLogModel logmodel = new SearchAC_OperateLogModel(); model.PagedIndex = model.PagedIndex == 0 ? 0 : model.PagedIndex; model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; //查询列表 var result = this._zjUserBalanceChangeLog.GetZJ_UserBalanceChangeLogList(model); List <ZJ_UserBalanceChangeLogModel> ds = result.Data; var data = new { rows = ds, total = result.Data.TotalCount, }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取用户账户金额异动记录表 /// </summary> /// <param name="model">model</param> /// <returns></returns> public ResultModel GetZJ_UserBalanceChangeLogList(SearchZJ_UserBalanceChangeLogModel model) { var tb = _database.Db.ZJ_UserBalanceChangeLog; var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); // if (model.ID > 0) { //流水号 where = new SimpleExpression(where, tb.ID == model.ID, SimpleExpressionType.And); } if (model.AddOrCutType > 0) { //异动类型 where = new SimpleExpression(where, tb.AddOrCutType == model.AddOrCutType, SimpleExpressionType.And); } if (model.IsAddOrCut != 10) { // where = new SimpleExpression(where, tb.IsAddOrCut == model.IsAddOrCut, SimpleExpressionType.And); } if (!string.IsNullOrEmpty(model.OrderNo) && model.OrderNo.Trim() != "") { //订单编号 where = new SimpleExpression(where, tb.OrderNo.Like("%" + model.OrderNo.Trim() + "%"), SimpleExpressionType.And); } if (!string.IsNullOrEmpty(model.CreateBy) && model.CreateBy.Trim() != "") { //创建人(操作人) where = new SimpleExpression(where, tb.CreateBy.Like("%" + model.CreateBy.Trim() + "%"), SimpleExpressionType.And); } if (!string.IsNullOrEmpty(model.Account) && model.Account.Trim() != "") { //用户名(YH_User表,登陆账号) where = new SimpleExpression(where, _database.Db.YH_User.Account.Like("%" + model.Account.Trim() + "%"), SimpleExpressionType.And); } 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 (model.EndCreateDT != null && model.EndCreateDT.Value.Year != 0001) { //结束 时间加一天是为了查询结束当天的数据 where = new SimpleExpression(where, tb.CreateDT < model.EndCreateDT, SimpleExpressionType.And); } if (model.BeginCreateDT != null && model.BeginCreateDT.Value.Year != 0001) { //开始时间 where = new SimpleExpression(where, tb.CreateDT >= model.BeginCreateDT, SimpleExpressionType.And); } dynamic pc; dynamic zj; var query = tb .Query() .LeftJoin(_database.Db.ZJ_AmountChangeType, out zj) .On(_database.Db.ZJ_AmountChangeType.ID == tb.AddOrCutType) .LeftJoin(_database.Db.YH_User, out pc) .On(_database.Db.YH_User.UserID == tb.UserID) .Select( tb.ID, tb.UserID, tb.AddOrCutAmount, tb.IsAddOrCut, tb.OldAmount, tb.NewAmount, tb.AddOrCutType, tb.OrderNo, tb.Remark, tb.IsDisplay, tb.CreateBy, tb.CreateDT, zj.TypeName, pc.Phone, pc.Email, pc.NickName, pc.RealName, pc.Account ) .Where(where) .OrderByIDDescending(); var result = new ResultModel { Data = new SimpleDataPagedList <ZJ_UserBalanceChangeLogModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }