public EMAccountDetailWithCount GetAccountDetailBalance(AccountDetailParam param) { EMAccountDetailWithCount model = new EMAccountDetailWithCount(); IEMTenantAccountDetailService service = new EMTenantAccountDetailService(); decimal balance = decimal.Zero; IList<EMTenantAccountDetail> list = service.Select(param.TenantCode, param.PageSize, out balance); model.Balance = balance; IList<EMAccountDetailViewModel> viewList = new List<EMAccountDetailViewModel>(); for (int i = 0; i < list.Count; i++) { EMAccountDetailViewModel em = new EMAccountDetailViewModel(); em.Index = i + 1; em.ConsumeMoney = list[i].ConsumeMoney; em.ConsumeType = list[i].ConsumeType; em.CreateTime = list[i].CreateTime; em.OperateType = list[i].OperateType; em.Remark = list[i].Remark; em.TargetTenantCode = list[i].TargetTenantCode; em.TargetTenantName = list[i].TargetTenantName; em.TenantCode = list[i].TenantCode; viewList.Add(em); } model.listModel = viewList; return model; }
public JsonResult GetAccontDetail(string tenantCode, string ConsumeType, string BeginTime, string EndTime, string rows, string pageSize) { AccountDetailParam model = new AccountDetailParam(); model.TenantCode = tenantCode; model.consumeType = Convert.ToInt32(ConsumeType); model.beginDate = Convert.ToDateTime(BeginTime); model.endDate = Convert.ToDateTime(EndTime + " 23:59:59"); model.PageSize = Convert.ToInt32(pageSize); model.RowIndex = (Convert.ToInt32(rows) - 1) * Convert.ToInt32(pageSize); EMAccountDetailWithCount list = _SysSettingService.SearchAccountDetail(model); if (list == null) return null; return Json(list, JsonRequestBehavior.AllowGet); }
public EMAccountDetailWithCount SearchAccountDetail(AccountDetailParam param) { EMAccountDetailWithCount model = new EMAccountDetailWithCount(); EMTenantAccountDetailService service = new EMTenantAccountDetailService(); int rowcount = 0; IList<EMTenantAccountDetail> list = service.Select(param.TenantCode, param.beginDate, param.endDate, param.consumeType, param.RowIndex, param.PageSize, ref rowcount); IList<EMAccountDetailViewModel> viewList = new List<EMAccountDetailViewModel>(); for(int i = 0;i<list.Count;i++) { EMAccountDetailViewModel em = new EMAccountDetailViewModel(); em.Index = i + 1; em.ConsumeMoney = list[i].ConsumeMoney; em.ConsumeType = list[i].ConsumeType; em.CreateTime = list[i].CreateTime; 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; }
/// <summary> /// 获取消费记录列表 /// </summary> /// <param name="keyWord">关键字</param> /// <param name="page">页索引</param> /// <param name="rows"></param> /// <returns></returns> public JsonResult GetAccountDetailList(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); AccountDetailParam param = new AccountDetailParam(); param.beginDate = beginDate; param.endDate = endDate; param.TenantCode = tenantCode; param.PageSize = pageSize; param.RowIndex = rowIndex; param.consumeType = consumeType; EMAccountDetailWithCount edwc = _ISysSettingWCFService.SearchAccountDetail(param); int totalRowCount = edwc.RowCount; IList<EMAccountDetailViewModel> edwcList = edwc.listModel; if (edwc == 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.ToString()), u.OperateType == PES.GPS.Entity.Enum.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 Json(res, JsonRequestBehavior.AllowGet); }