/// <summary> /// 查询记账信息 /// </summary> /// <param name="userID">用户ID</param> /// <param name="startTime">记账开始时间</param> /// <param name="endTime">记账结束时间</param> /// <param name="flowTypeID">资金类型ID</param> /// <param name="feeitemID">费用科目类型ID</param> /// <returns></returns> public JsonResult GetApplyMainList(int userID, DateTime?startTime, DateTime?endTime, int flowTypeID = 0, int feeitemID = 0) { Thread.Sleep(500); LycJsonResult lycResult = new LycJsonResult(); try { using (FDB = new FamilyCaiWuDBEntities()) { IQueryable <Apply_Main> qam = FDB.Apply_Main.Where(c => c.ApplyUserID == userID); //筛选日期 if (startTime != null && endTime == null) { qam = qam.Where(c => c.ApplyDate >= startTime.Value); } else if (startTime == null && endTime != null) { qam = qam.Where(c => c.ApplyDate <= endTime.Value); } else if (startTime != null && endTime != null) { qam = qam.Where(c => c.ApplyDate >= startTime.Value && c.ApplyDate <= endTime.Value); } var result = qam.Select(c => new { ApplyMainID = c.ID, ApplyUserID = c.ApplyUserID, ApplyDate = "", ApplyDate_date = c.ApplyDate, ApplyInMoney = c.ApplyInMoney, ApplyOutMoney = c.ApplyOutMoney, iyear = c.iyear, imonth = c.imonth, iday = c.iday, iNowCashMoney = c.iNowCashMoney.Value }).ToList(); List <QueryApplyMainModel> list = new List <QueryApplyMainModel>(); for (int i = 0; i < result.Count; i++) { QueryApplyMainModel am = new QueryApplyMainModel(); var c = result[i]; am.ApplyMainID = c.ApplyMainID; am.ApplyUserID = c.ApplyUserID; am.ApplyDate = c.ApplyDate_date.ToString("yyyy-MM-dd"); am.ApplyInMoney = c.ApplyInMoney.ToString(); am.ApplyOutMoney = c.ApplyOutMoney.ToString(); am.iyear = c.iyear; am.imonth = c.imonth; am.iday = c.iday; am.iNowCashMoney = c.iNowCashMoney.ToString(); list.Add(am); } var totalObj = new { totalIn = result.Sum(c => c.ApplyInMoney).ToString(), totalOut = result.Sum(c => c.ApplyOutMoney).ToString() }; var jsonObj = new { totalObj = totalObj, info = list }; lycResult.Data = new JsonResultModel(true, "账单查询成功", jsonObj); } } catch { lycResult.Data = new JsonResultModel(false, "账单查询失败", null); } return(lycResult); }
/// <summary> /// 查询记账信息 /// </summary> /// <param name="userID">用户ID</param> /// <param name="startTime">记账开始时间</param> /// <param name="endTime">记账结束时间</param> /// <param name="flowTypeID">资金类型ID</param> /// <param name="feeitemID">费用科目类型ID</param> /// <returns></returns> public JsonResult GetApplyMainList(int userID, DateTime? startTime, DateTime? endTime, int flowTypeID = 0, int feeitemID = 0) { Thread.Sleep(500); LycJsonResult lycResult = new LycJsonResult(); try { using (FDB = new FamilyCaiWuDBEntities()) { IQueryable<Apply_Main> qam = FDB.Apply_Main.Where(c => c.ApplyUserID == userID); //筛选日期 if (startTime != null && endTime == null) { qam = qam.Where(c => c.ApplyDate >= startTime.Value); } else if (startTime == null && endTime != null) { qam = qam.Where(c => c.ApplyDate <= endTime.Value); } else if (startTime != null && endTime != null) { qam = qam.Where(c => c.ApplyDate >= startTime.Value && c.ApplyDate <= endTime.Value); } var result = qam.Select(c => new { ApplyMainID = c.ID, ApplyUserID = c.ApplyUserID, ApplyDate = "", ApplyDate_date = c.ApplyDate, ApplyInMoney = c.ApplyInMoney, ApplyOutMoney = c.ApplyOutMoney, iyear = c.iyear, imonth = c.imonth, iday = c.iday, iNowCashMoney = c.iNowCashMoney.Value }).ToList(); List<QueryApplyMainModel> list = new List<QueryApplyMainModel>(); for (int i = 0; i < result.Count; i++) { QueryApplyMainModel am = new QueryApplyMainModel(); var c = result[i]; am.ApplyMainID = c.ApplyMainID; am.ApplyUserID = c.ApplyUserID; am.ApplyDate = c.ApplyDate_date.ToString("yyyy-MM-dd"); am.ApplyInMoney = c.ApplyInMoney.ToString(); am.ApplyOutMoney = c.ApplyOutMoney.ToString(); am.iyear = c.iyear; am.imonth = c.imonth; am.iday = c.iday; am.iNowCashMoney = c.iNowCashMoney.ToString(); list.Add(am); } var totalObj = new {totalIn = result.Sum(c=>c.ApplyInMoney).ToString(), totalOut = result.Sum(c=>c.ApplyOutMoney).ToString()}; var jsonObj = new { totalObj = totalObj , info = list}; lycResult.Data = new JsonResultModel(true, "账单查询成功", jsonObj); } } catch { lycResult.Data = new JsonResultModel(false, "账单查询失败", null); } return lycResult; }