public PageModel <CapitalInfo> GetCapitals(CapitalQuery query) { IQueryable <CapitalInfo> capitalInfo = from e in context.CapitalInfo where true select e; if (query.memberId.HasValue) { capitalInfo = from e in context.CapitalInfo where e.MemId == query.memberId select e; } int num = 0; IQueryable <CapitalInfo> page = capitalInfo.GetPage(out num, query.PageNo, query.PageSize, (IQueryable <CapitalInfo> o) => from e in o orderby e.Id descending select e); return(new PageModel <CapitalInfo>() { Models = page, Total = num }); }
public ObsoletePageModel <CapitalInfo> GetCapitals(CapitalQuery query) { var capital = Context.CapitalInfo.Where(e => true); if (query.memberId.HasValue) { capital = Context.CapitalInfo.Where(e => e.MemId == query.memberId); } int total = 0; var page = capital.GetPage(out total, query.PageNo, query.PageSize, o => o.OrderByDescending(e => e.Id)); ObsoletePageModel <CapitalInfo> result = new ObsoletePageModel <CapitalInfo> { Models = page, Total = total }; return(result); }
public JsonResult GetMemberCapitals(string user, int page, int rows) { var capitalService = _iMemberCapitalService; var memberService = _iMemberService; long?membid = null; if (!string.IsNullOrWhiteSpace(user)) { var memberInfo = memberService.GetMemberByName(user) ?? new UserMemberInfo() { Id = 0 }; membid = memberInfo.Id; } var query = new CapitalQuery { PageNo = page, PageSize = rows, Sort = "Balance", memberId = membid }; var pagemodel = capitalService.GetCapitals(query); var model = pagemodel.Models.ToList().Select(e => { var member = memberService.GetMember(e.MemId); return(new CapitalModel { Balance = e.Balance.Value, ChargeAmount = e.ChargeAmount.HasValue ? e.ChargeAmount.Value : 0.00M, FreezeAmount = e.FreezeAmount.HasValue ? e.FreezeAmount.Value : 0.00M, Id = e.Id, UserId = e.MemId, UserCode = member.UserName, UserName = string.IsNullOrWhiteSpace(member.RealName) ? member.UserName : member.RealName }); }); var models = new DataGridModel <CapitalModel> { rows = model, total = pagemodel.Total }; return(Json(models)); }
public JsonResult GetMemberCapitals(string user, int page, int rows) { IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>(); IMemberService memberService = ServiceHelper.Create <IMemberService>(); long?nullable = null; if (!string.IsNullOrWhiteSpace(user)) { nullable = new long?((memberService.GetMemberByName(user) ?? new UserMemberInfo() { Id = 0 }).Id); } CapitalQuery capitalQuery = new CapitalQuery() { PageNo = page, PageSize = rows, Sort = "Balance", memberId = nullable }; PageModel <CapitalInfo> capitals = memberCapitalService.GetCapitals(capitalQuery); IEnumerable <CapitalModel> capitalModels = capitals.Models.ToList().Select <CapitalInfo, CapitalModel>((CapitalInfo e) => { UserMemberInfo member = memberService.GetMember(e.MemId); return(new CapitalModel() { Balance = e.Balance.Value, ChargeAmount = (e.ChargeAmount.HasValue ? e.ChargeAmount.Value : new decimal(0, 0, 0, false, 2)), FreezeAmount = (e.FreezeAmount.HasValue ? e.FreezeAmount.Value : new decimal(0, 0, 0, false, 2)), Id = e.Id, UserId = e.MemId, UserCode = member.UserName, UserName = (string.IsNullOrWhiteSpace(member.RealName) ? member.UserName : member.RealName) }); }); DataGridModel <CapitalModel> dataGridModel = new DataGridModel <CapitalModel>() { rows = capitalModels, total = capitals.Total }; return(Json(dataGridModel)); }
public JsonResult GetMemberCapitals(string user, int page, int rows) { IMemberCapitalService memberCapitalService = this._iMemberCapitalService; IMemberService memberService = this._iMemberService; long?nullable1 = new long?(); if (!string.IsNullOrWhiteSpace(user)) { UserMemberInfo userMemberInfo = memberService.GetMemberByName(user); if (userMemberInfo == null) { userMemberInfo = new UserMemberInfo() { Id = 0L } } ; nullable1 = new long?(userMemberInfo.Id); } CapitalQuery capitalQuery = new CapitalQuery(); capitalQuery.PageNo = page; capitalQuery.PageSize = rows; capitalQuery.Sort = "Balance"; capitalQuery.memberId = nullable1; CapitalQuery query = capitalQuery; ObsoletePageModel <CapitalInfo> capitals = memberCapitalService.GetCapitals(query); IEnumerable <CapitalModel> enumerable = Enumerable.Select <CapitalInfo, CapitalModel>((IEnumerable <CapitalInfo>)Enumerable.ToList <CapitalInfo>((IEnumerable <CapitalInfo>)capitals.Models), (Func <CapitalInfo, CapitalModel>)(e => { UserMemberInfo member = memberService.GetMember(e.MemId); CapitalModel capitalModel1 = new CapitalModel(); capitalModel1.Balance = e.Balance.Value; CapitalModel capitalModel2 = capitalModel1; Decimal?nullable2; Decimal num1; if (!e.ChargeAmount.HasValue) { num1 = new Decimal(0, 0, 0, false, (byte)2); } else { nullable2 = e.ChargeAmount; num1 = nullable2.Value; } capitalModel2.ChargeAmount = num1; CapitalModel capitalModel3 = capitalModel1; nullable2 = e.FreezeAmount; Decimal num2; if (!nullable2.HasValue) { num2 = new Decimal(0, 0, 0, false, (byte)2); } else { nullable2 = e.FreezeAmount; num2 = nullable2.Value; } capitalModel3.FreezeAmount = num2; capitalModel1.Id = e.Id; capitalModel1.UserId = e.MemId; capitalModel1.UserCode = member.UserName; capitalModel1.UserName = string.IsNullOrWhiteSpace(member.RealName) ? member.UserName : member.RealName; return(capitalModel1); })); return(this.Json((object)new DataGridModel <CapitalModel>() { rows = enumerable, total = capitals.Total })); }
/// <summary> /// 取多个会员资产信息 /// </summary> /// <param name=""></param> /// <returns></returns> public static ObsoletePageModel <CapitalInfo> GetCapitals(CapitalQuery query) { return(_iMemberCapitalService.GetCapitals(query)); }
/// <summary> /// 取多个会员资产信息 /// </summary> /// <param name=""></param> /// <returns></returns> public static QueryPageModel <MemberCapital> GetCapitals(CapitalQuery query) { return(Service.GetCapitals(query)); }
public QueryPageModel <MemberCapital> GetCapitals(CapitalQuery query) { var db = DbFactory.Default.Get <MemberInfo>().LeftJoin <CapitalInfo>((mi, ci) => ci.MemId == mi.Id); if (query.MemberId > 0) { db.Where(e => e.Id == query.MemberId); } if (!string.IsNullOrEmpty(query.UserName)) { //var members = DbFactory.Default.Get<MemberInfo>().Where(p => p.UserName.Contains(query.UserName)).Select(p => p.Id).ToList<long>(); //db.Where(p => p.MemId.ExIn(members)); db.Where(p => p.UserName.Contains(query.UserName)); } switch (query.Sort.ToLower()) { case "balance": if (query.IsAsc) { db.OrderBy <CapitalInfo>(p => p.Balance); } else { db.OrderByDescending <CapitalInfo>(p => p.Balance); } break; case "freezeamount": if (query.IsAsc) { db.OrderBy <CapitalInfo>(p => p.FreezeAmount); } else { db.OrderByDescending <CapitalInfo>(p => p.FreezeAmount); } break; case "chargeamount": if (query.IsAsc) { db.OrderBy <CapitalInfo>(p => p.ChargeAmount); } else { db.OrderByDescending <CapitalInfo>(p => p.ChargeAmount); } break; case "presentamount": if (query.IsAsc) { db.OrderBy <CapitalInfo>(p => p.PresentAmount); } else { db.OrderByDescending <CapitalInfo>(p => p.PresentAmount); } break; default: db.OrderByDescending <CapitalInfo>(e => e.Balance); break; } db.Select <CapitalInfo>(p => new { Id = p.Id, Balance = p.Balance.ExIfNull(0), ChargeAmount = p.ChargeAmount.ExIfNull(0), FreezeAmount = p.FreezeAmount.ExIfNull(0), PresentAmount = p.PresentAmount.ExIfNull(0) }); db.Select(p => new { UserName = p.UserName, RealName = p.RealName, UserId = p.Id }); var page = db.ToPagedList <MemberCapital>(query.PageNo, query.PageSize); return(new QueryPageModel <MemberCapital> { Models = page, Total = page.TotalRecordCount }); }
public JsonResult GetMemberCapitals(CapitalQuery query) { var result = MemberCapitalApplication.GetCapitals(query); return(Json(result, true)); }