/// <summary> /// 消费记录 /// </summary> public Object GetAccountDetailLis(string bDate, string eDate, string tenantCode, string csType, string page, string rows) { rows = "10"; if (string.IsNullOrEmpty(page) || string.IsNullOrEmpty(rows)) { page = "1"; bDate = "1900-01-01"; eDate = "2090-01-01"; } if (string.IsNullOrEmpty(bDate)) { bDate = "1900-01-01"; } if (string.IsNullOrEmpty(eDate)) { eDate = "2090-01-01"; } int consumeType = -1; if (string.IsNullOrEmpty(csType)) consumeType = -1; else consumeType = Convert.ToInt32(csType); int pageIndex = Convert.ToInt32(page); int pageSize = Convert.ToInt32(rows); int rowIndex = (pageIndex - 1) * pageSize; DateTime beginDate = Convert.ToDateTime(bDate + " 00:00:00"); DateTime endDate = Convert.ToDateTime(eDate + " 23:59:59"); int rowNumber = Convert.ToInt32(rows); int total = 0; VAccountDetail model = new VAccountDetail(); IList<ETenantAccountDetail> list = DACFacade.Movo.TenantAccountDetailDAC.SelectList(tenantCode, beginDate, endDate, consumeType, rowIndex, pageSize, out total); IList<EAccountDetailView> viewList = new List<EAccountDetailView>(); for (int h = 0; h < list.Count; h++) { EAccountDetailView em = new EAccountDetailView(); em.Index = h + 1; em.ConsumeMoney = list[h].ConsumeMoney; em.ConsumeType = list[h].ConsumeType; em.CreateTime = list[h].CreateTime.Value; em.OperateType = list[h].OperateType; em.Remark = list[h].Remark; em.TargetTenantCode = list[h].TargetTenantCode; em.TenantCode = list[h].TenantCode; viewList.Add(em); } model.RowCount = total; model.listModel = viewList; int totalRowCount = model.RowCount; IList<EAccountDetailView> edwcList = model.listModel; if (model == null || totalRowCount == 0) return null; int i = 1; int r = totalRowCount % pageSize == 0 ? 0 : 1; var query = from u in edwcList select new { index = i++, cell = new string[]{ u.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), GetConsumeType(u.ConsumeType), u.OperateType == EnumOperateType.Income?"+"+u.ConsumeMoney.ToString():"-"+u.ConsumeMoney.ToString(), u.Remark.ToString() } }; var res = new { total = totalRowCount / pageSize + r, page = pageIndex, records = totalRowCount, rows = query.Take(totalRowCount) }; return res; }
/// <summary> /// 充值消费记录 /// </summary> public VAccountDetail AccountDetailQuerySearch(string bDate, string eDate, string consumeType, int pageSize, int rowIndex, string tenantCode) { DateTime beginDate = DateTime.Today.AddDays(-30); DateTime endDate = DateTime.Today; int type = -1; int rowcount = 0; if (!string.IsNullOrEmpty(bDate) && !string.IsNullOrEmpty(eDate) && !string.IsNullOrEmpty(consumeType)) { beginDate = DateTime.Parse(bDate); endDate = DateTime.Parse(eDate); type = int.Parse(consumeType); } VAccountDetail model = new VAccountDetail(); IList<ETenantAccountDetail> list = DACFacade.Movo.TenantAccountDetailDAC.SelectList(tenantCode, beginDate, endDate, type, rowIndex, pageSize,out rowcount); IList<EAccountDetailView> viewList = new List<EAccountDetailView>(); for (int i = 0; i < list.Count; i++) { EAccountDetailView em = new EAccountDetailView(); em.Index = i + 1; em.ConsumeMoney = list[i].ConsumeMoney; em.ConsumeType = list[i].ConsumeType; em.CreateTime = list[i].CreateTime.Value; em.OperateType = list[i].OperateType; em.Remark = list[i].Remark; em.TargetTenantCode = list[i].TargetTenantCode; em.TenantCode = list[i].TenantCode; viewList.Add(em); } model.RowCount = rowcount; model.listModel = viewList; return model; }