public QueryPageModel <CapitalDetailInfo> GetCapitalDetails(CapitalDetailQuery query) { //var capitalDetail = Context.CapitalDetailInfo.Where(item => item.Mall_Capital.MemId == query.memberId); //var capital = DbFactory.Default.Get<CapitalInfo>().Where(p => p.MemId == query.memberId).Select(p => p.Id).ToList<long>(); var capitalDetail = DbFactory.Default .Get <CapitalDetailInfo>() .InnerJoin <CapitalInfo>((cdi, ci) => cdi.CapitalID == ci.Id && ci.MemId == query.memberId); if (query.capitalType.HasValue && query.capitalType.Value != 0) { capitalDetail.Where(e => e.SourceType == query.capitalType.Value); } if (query.startTime.HasValue) { capitalDetail.Where(e => e.CreateTime >= query.startTime); } if (query.endTime.HasValue) { capitalDetail.Where(e => e.CreateTime < query.endTime); } //int total = 0; //var model = capitalDetail.GetPage(p => p.OrderByDescending(e => e.CreateTime), out total, query.PageNo, query.PageSize); var model = capitalDetail.OrderByDescending(e => e.CreateTime).Select().ToPagedList(query.PageNo, query.PageSize); QueryPageModel <CapitalDetailInfo> result = new QueryPageModel <CapitalDetailInfo> { Models = model, Total = model.TotalRecordCount }; return(result); }
public ObsoletePageModel <CapitalDetailInfo> GetCapitalDetails(CapitalDetailQuery query) { var capitalDetail = Context.CapitalDetailInfo.Where(item => item.Himall_Capital.MemId == query.memberId); if (query.capitalType.HasValue && query.capitalType.Value != 0) { capitalDetail = capitalDetail.Where(e => e.SourceType == query.capitalType.Value); } if (query.startTime.HasValue) { capitalDetail = capitalDetail.Where(e => e.CreateTime >= query.startTime); } if (query.endTime.HasValue) { capitalDetail = capitalDetail.Where(e => e.CreateTime < query.endTime); } int total = 0; var model = capitalDetail.GetPage(out total, query.PageNo, query.PageSize, p => p.OrderByDescending(e => e.CreateTime)); ObsoletePageModel <CapitalDetailInfo> result = new ObsoletePageModel <CapitalDetailInfo> { Models = model, Total = total }; return(result); }
public object GetList(int pageNo = 1, int pageSize = 10) { CheckUserLogin(); var query = new CapitalDetailQuery { memberId = CurrentUser.Id, PageSize = pageSize, PageNo = pageNo }; var pageMode = MemberCapitalApplication.GetCapitalDetails(query); var model = pageMode.Models.ToList().Select(e => new CapitalDetailModel { Id = e.Id, Amount = e.Amount + e.PresentAmount, PresentAmount = e.PresentAmount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), SourceData = e.SourceData, SourceType = e.SourceType, Remark = GetRemark(e), PayWay = e.Remark }); return(Json(new { rows = model, total = pageMode.Total })); }
public object GetList(int pageNo = 1, int pageSize = 10) { CheckUserLogin(); var capitalService = ServiceApplication.Create <IMemberCapitalService>(); var query = new CapitalDetailQuery { memberId = CurrentUser.Id, PageSize = pageSize, PageNo = pageNo }; var pageMode = capitalService.GetCapitalDetails(query); var model = pageMode.Models.ToList().Select(e => new CapitalDetailModel { Id = e.Id, Amount = e.Amount + e.PresentAmount, PresentAmount = e.PresentAmount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), SourceData = e.SourceData, SourceType = e.SourceType, Remark = e.SourceType == CapitalDetailInfo.CapitalDetailType.Brokerage ? GetBrokerageRemark(e) : e.Remark, PayWay = e.Remark }); dynamic result = SuccessResult(); result.rows = model; result.total = pageMode.Total; return(result); }
public JsonResult List(CapitalDetailInfo.CapitalDetailType capitalType, int page, int rows) { IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>(); CapitalDetailQuery capitalDetailQuery = new CapitalDetailQuery() { memberId = base.CurrentUser.Id, capitalType = new CapitalDetailInfo.CapitalDetailType?(capitalType), PageSize = rows, PageNo = page }; PageModel <CapitalDetailInfo> capitalDetails = memberCapitalService.GetCapitalDetails(capitalDetailQuery); List <CapitalDetailModel> list = ( from e in capitalDetails.Models.ToList() select new CapitalDetailModel() { Id = e.Id, Amount = e.Amount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.Value.ToString(), SourceData = e.SourceData, SourceType = e.SourceType, Remark = string.Concat(e.SourceType.ToDescription(), ",单号:", e.Id), PayWay = e.Remark }).ToList(); DataGridModel <CapitalDetailModel> dataGridModel = new DataGridModel <CapitalDetailModel>() { rows = list, total = capitalDetails.Total }; return(Json(dataGridModel)); }
public JsonResult List(CapitalDetailInfo.CapitalDetailType capitalType, long userid, string startTime, string endTime, int page, int rows) { IMemberCapitalService service = this._iMemberCapitalService; CapitalDetailQuery query = new CapitalDetailQuery { memberId = userid, capitalType = new CapitalDetailInfo.CapitalDetailType?(capitalType), PageSize = rows, PageNo = page }; if (!string.IsNullOrWhiteSpace(startTime)) { query.startTime = new DateTime?(DateTime.Parse(startTime)); } if (!string.IsNullOrWhiteSpace(endTime)) { query.endTime = new DateTime?(DateTime.Parse(endTime).AddDays(1.0).AddSeconds(-1.0)); } ObsoletePageModel <CapitalDetailInfo> capitalDetails = service.GetCapitalDetails(query); List <CapitalDetailModel> list = (from e in capitalDetails.Models.ToList <CapitalDetailInfo>() select new CapitalDetailModel { Id = e.Id, Amount = e.Amount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.Value.ToString(), SourceData = e.SourceData, SourceType = e.SourceType, Remark = e.SourceType.ToDescription() + ",单号:" + e.Id, PayWay = e.Remark }).ToList <CapitalDetailModel>(); DataGridModel <CapitalDetailModel> data = new DataGridModel <CapitalDetailModel> { rows = list, total = capitalDetails.Total }; return(base.Json(data)); }
public JsonResult List(CapitalDetailInfo.CapitalDetailType capitalType, int page, int rows) { var capitalService = _iMemberCapitalService; var query = new CapitalDetailQuery { memberId = CurrentUser.Id, capitalType = capitalType, PageSize = rows, PageNo = page }; var pageMode = capitalService.GetCapitalDetails(query); var model = pageMode.Models.ToList().Select(e => new CapitalDetailModel { Id = e.Id, Amount = e.Amount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.Value.ToString(), SourceData = e.SourceData, SourceType = e.SourceType, Remark = e.SourceType.ToDescription() + ",单号:" + e.Id, PayWay = e.Remark }).ToList(); var models = new DataGridModel <CapitalDetailModel> { rows = model, total = pageMode.Total }; return(Json(models)); }
public JsonResult List(int page, int rows) { var capitalService = _iMemberCapitalService; var query = new CapitalDetailQuery { memberId = CurrentUser.Id, PageSize = rows, PageNo = page }; var pageMode = capitalService.GetCapitalDetails(query); var model = pageMode.Models.ToList().Select(e => new CapitalDetailModel { Id = e.Id, Amount = e.Amount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss"), SourceData = e.SourceData, SourceType = e.SourceType, Remark = e.SourceType.ToDescription(), PayWay = e.Remark }); return(Json(new { model = model, total = pageMode.Total })); }
public JsonResult List(Mall.Entities.CapitalDetailInfo.CapitalDetailType capitalType, int page, int rows) { var capitalService = _iMemberCapitalService; var query = new CapitalDetailQuery { memberId = CurrentUser.Id, capitalType = capitalType, PageSize = rows, PageNo = page }; var pageMode = capitalService.GetCapitalDetails(query); var model = pageMode.Models.ToList().Select(e => new CapitalDetailModel { Id = e.Id, Amount = e.Amount + (e.PresentAmount > 0 ? e.PresentAmount : 0), CapitalID = e.CapitalID, CreateTime = e.CreateTime.ToString(), SourceData = e.SourceData, SourceType = e.SourceType, PresentAmount = e.PresentAmount, Remark = GetCapitalRemark(e.SourceType, e.SourceData, e.Id.ToString(), e.Remark), PayWay = e.Remark, IsExitRefund = IsExitRefound(e.SourceData, e.SourceType) }).ToList(); var models = new DataGridModel <CapitalDetailModel> { rows = model, total = pageMode.Total }; return(Json(models)); }
public JsonResult List(int page, int rows) { IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>(); CapitalDetailQuery capitalDetailQuery = new CapitalDetailQuery() { memberId = base.CurrentUser.Id, PageSize = rows, PageNo = page }; PageModel <CapitalDetailInfo> capitalDetails = memberCapitalService.GetCapitalDetails(capitalDetailQuery); IEnumerable <CapitalDetailModel> list = from e in capitalDetails.Models.ToList() select new CapitalDetailModel() { Id = e.Id, Amount = e.Amount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.Value.ToString(), SourceData = e.SourceData, SourceType = e.SourceType, Remark = e.SourceType.ToDescription(), PayWay = e.Remark }; return(Json(list)); }
public JsonResult List(int page, int rows) { IMemberCapitalService service = this._iMemberCapitalService; CapitalDetailQuery query = new CapitalDetailQuery { memberId = base.CurrentUser.Id, PageSize = rows, PageNo = page }; ObsoletePageModel <CapitalDetailInfo> capitalDetails = service.GetCapitalDetails(query); IEnumerable <CapitalDetailModel> enumerable = from e in capitalDetails.Models.ToList <CapitalDetailInfo>() select new CapitalDetailModel { Id = e.Id, Amount = e.Amount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss"), SourceData = e.SourceData, SourceType = e.SourceType, Remark = e.SourceType.ToDescription(), PayWay = e.Remark }; return(base.Json(new { model = enumerable, total = capitalDetails.Total })); }
public JsonResult List(CapitalDetailInfo.CapitalDetailType capitalType, long userid, string startTime, string endTime, int page, int rows) { IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>(); CapitalDetailQuery capitalDetailQuery = new CapitalDetailQuery() { memberId = userid, capitalType = new CapitalDetailInfo.CapitalDetailType?(capitalType), PageSize = rows, PageNo = page }; CapitalDetailQuery nullable = capitalDetailQuery; if (!string.IsNullOrWhiteSpace(startTime)) { nullable.startTime = new DateTime?(DateTime.Parse(startTime)); } if (!string.IsNullOrWhiteSpace(endTime)) { DateTime dateTime = DateTime.Parse(endTime).AddDays(1); nullable.endTime = new DateTime?(dateTime.AddSeconds(-1)); } PageModel <CapitalDetailInfo> capitalDetails = memberCapitalService.GetCapitalDetails(nullable); List <CapitalDetailModel> list = ( from e in capitalDetails.Models.ToList() select new CapitalDetailModel() { Id = e.Id, Amount = e.Amount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.Value.ToString(), SourceData = e.SourceData, SourceType = e.SourceType, Remark = string.Concat(e.SourceType.ToDescription(), ",单号:", e.Id), PayWay = e.Remark }).ToList(); DataGridModel <CapitalDetailModel> dataGridModel = new DataGridModel <CapitalDetailModel>() { rows = list, total = capitalDetails.Total }; return(Json(dataGridModel)); }
public List <CapitalDetailInfo> GetCapitalDetailList(CapitalDetailQuery query) { var capitalDetail = Context.CapitalDetailInfo.Where(item => item.Himall_Capital.MemId == query.memberId); if (query.capitalType.HasValue && query.capitalType.Value != 0) { capitalDetail = capitalDetail.Where(e => e.SourceType == query.capitalType.Value); } if (query.startTime.HasValue) { capitalDetail = capitalDetail.Where(e => e.CreateTime >= query.startTime); } if (query.endTime.HasValue) { capitalDetail = capitalDetail.Where(e => e.CreateTime < query.endTime); } return(capitalDetail.ToList()); }
public JsonResult List(Himall.Entities.CapitalDetailInfo.CapitalDetailType capitalType, long userid, string startTime, string endTime, int page, int rows) { var capitalService = _iMemberCapitalService; var query = new CapitalDetailQuery { memberId = userid, capitalType = capitalType, PageSize = rows, PageNo = page }; if (!string.IsNullOrWhiteSpace(startTime)) { query.startTime = DateTime.Parse(startTime); } if (!string.IsNullOrWhiteSpace(endTime)) { query.endTime = DateTime.Parse(endTime).AddDays(1).AddSeconds(-1); } var pageMode = capitalService.GetCapitalDetails(query); var model = pageMode.Models.ToList().Select(e => new CapitalDetailModel { Id = e.Id, Amount = e.Amount + e.PresentAmount, CapitalID = e.CapitalID, CreateTime = e.CreateTime.ToString(), SourceData = e.SourceData, SourceType = e.SourceType, Remark = GetCapitalRemark(e.SourceType, e.SourceData, e.Id.ToString(), e.Remark), PayWay = GetPayWay(e.SourceData, e.SourceType), PresentAmount = e.PresentAmount }).ToList(); var models = new DataGridModel <CapitalDetailModel> { rows = model, total = pageMode.Total }; return(Json(models)); }
public PageModel <CapitalDetailInfo> GetCapitalDetails(CapitalDetailQuery query) { IQueryable <CapitalDetailInfo> capitalDetailInfo = from item in context.CapitalDetailInfo where item.ChemCloud_Capital.MemId == query.memberId select item; if (query.capitalType.HasValue && query.capitalType.Value != 0) { capitalDetailInfo = from e in capitalDetailInfo where (int)e.SourceType == (int)query.capitalType.Value select e; } if (query.startTime.HasValue) { capitalDetailInfo = from e in capitalDetailInfo where e.CreateTime >= query.startTime select e; } if (query.endTime.HasValue) { capitalDetailInfo = from e in capitalDetailInfo where e.CreateTime < query.endTime select e; } int num = 0; IQueryable <CapitalDetailInfo> page = capitalDetailInfo.GetPage(out num, query.PageNo, query.PageSize, (IQueryable <CapitalDetailInfo> p) => from e in p orderby e.CreateTime descending select e); return(new PageModel <CapitalDetailInfo>() { Models = page, Total = num }); }
/// <summary> /// 获取用户奖励信息 /// </summary> /// <returns></returns> public object GetCapitalInfo() { CheckUserLogin(); if (CurrentUser != null) { CapitalDetailQuery query = new CapitalDetailQuery(); query.memberId = CurrentUser.Id; query.capitalType = null; List <CapitalDetailInfo> list = ServiceProvider.Instance <IMemberCapitalService> .Create.GetCapitalDetailList(query); var data = new { CanWithDraw = list.Sum(a => a.Amount), //可提现 Rewards = list.Where(a => a.SourceType == CapitalDetailInfo.CapitalDetailType.OpenGroupReward || a.SourceType == CapitalDetailInfo.CapitalDetailType.InvitationReward || a.SourceType == CapitalDetailInfo.CapitalDetailType.ReturnMoney).Sum(a => a.Amount), //累计奖励 HasSettlement = list.Where(a => a.SourceType == CapitalDetailInfo.CapitalDetailType.WithDraw).Sum(a => a.Amount) //已结算 }; return(Json(new { Success = true, Data = data })); } else { return(Json(new { Success = false, Message = "未登录" })); } }
/// <summary> /// 取多个会员资产明细 /// </summary> /// <param name="query"></param> /// <returns></returns> public static ObsoletePageModel <CapitalDetailInfo> GetCapitalDetails(CapitalDetailQuery query) { return(_iMemberCapitalService.GetCapitalDetails(query)); }
/// <summary> /// 取多个会员资产明细 /// </summary> /// <param name="query"></param> /// <returns></returns> public static QueryPageModel <CapitalDetailInfo> GetCapitalDetails(CapitalDetailQuery query) { return(Service.GetCapitalDetails(query)); }
/// <summary> /// 获取用户奖励列表 /// </summary> /// <param name="cType"></param> /// <param name="pageNo"></param> /// <param name="pageSize"></param> /// <returns></returns> public object GetCapitalDetails(int cType = 0, int pageNo = 1, int pageSize = 10) { CheckUserLogin(); if (CurrentUser != null) { IMemberCapitalService _iMemberCapitalService = ServiceProvider.Instance <IMemberCapitalService> .Create; CapitalDetailQuery query = new CapitalDetailQuery(); query.memberId = CurrentUser.Id; query.capitalType = (CapitalDetailInfo.CapitalDetailType)cType; query.PageNo = pageNo; query.PageSize = pageSize; ObsoletePageModel <CapitalDetailInfo> list = ServiceProvider.Instance <IMemberCapitalService> .Create.GetCapitalDetails(query); List <CapitalDetailInfo> data = new List <CapitalDetailInfo>(); DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("CapitalID"); dt.Columns.Add("Amount"); dt.Columns.Add("CreateTime"); dt.Columns.Add("Remark"); dt.Columns.Add("SourceData"); dt.Columns.Add("SourceType"); dt.Columns.Add("ShopName"); dt.Columns.Add("Status"); dt.Columns.Add("UserLogo"); foreach (CapitalDetailInfo detail in list.Models) { DataRow dr = dt.NewRow(); dr["Id"] = detail.Id; dr["CapitalID"] = detail.CapitalID; dr["Amount"] = detail.Amount; dr["CreateTime"] = detail.CreateTime; dr["Remark"] = detail.Remark; dr["SourceData"] = detail.SourceData; dr["SourceType"] = detail.SourceType; dr["ShopName"] = ""; dr["Status"] = ""; dr["UserLogo"] = CurrentUser.Photo; if (detail.SourceType == CapitalDetailInfo.CapitalDetailType.WithDraw) { dr["Status"] = _iMemberCapitalService.GetWithDraw(Convert.ToInt64(detail.SourceData)).ApplyStatus.ToDescription(); } else { var order = ServiceProvider.Instance <IOrderService> .Create.GetOrder(Convert.ToInt64(detail.SourceData)); if (order != null) { dr["ShopName"] = order.ShopName; } } dt.Rows.Add(dr); } return(Json(new { Success = true, Data = dt, Total = list.Total })); } else { return(Json(new { Success = false, Message = "未登录" })); } }