/// <summary> /// 获取用户开户行列表 /// </summary> /// <param name="currentPage">当前页码</param> /// <param name="uBank">查询实体</param> /// <returns></returns> private List<Apply_Main> GetApply_MainList(int currentPage, Apply_Main AM, string beginDate, string endDate) { var amList = db.Apply_Main.AsQueryable(); User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; //区分用户加载数据,如果不是超级管理员,只能查看自己的数据 if (!UserPower.adminUserCode.Contains(loginUser.cUserCode)) { amList = amList.Where(ub => ub.ApplyUserID == loginUser.ID); } #region 条件筛选 if (AM != null && !string.IsNullOrEmpty(AM.ApplyUserID.ToString()) && AM.ApplyUserID > 0) { amList = amList.Where(ub => ub.ApplyUserID == AM.ApplyUserID); } //如果用户选择了开始时间和结束时间 if (!string.IsNullOrEmpty(beginDate) && !string.IsNullOrEmpty(endDate)) { int[] beginArr = WebComm.GetIntArrayByStringArray(beginDate.Split('-')); int[] endArr = WebComm.GetIntArrayByStringArray(endDate.Split('-')); DateTime bDate,dDate; bDate = Convert.ToDateTime(beginDate); dDate = Convert.ToDateTime(endDate); int beginYear = beginArr[0]; int beginMonth = beginArr[1]; int beginDay = beginArr[2]; int endYear = endArr[0]; int endMonth = endArr[1]; int endDay = endArr[2]; //amList = amList.Where(a => a.iyear >= beginYear && a.imonth >= beginMonth && a.iday >= beginDay) // .Where(a => a.iyear <= endYear && a.imonth <= endMonth && a.iday <= endDay); amList = amList.Where(a => a.ApplyDate >= bDate && a.ApplyDate <= dDate); } //如果只选择了开始时间 else if (!string.IsNullOrEmpty(beginDate) && string.IsNullOrEmpty(endDate)) { DateTime bDate; bDate = Convert.ToDateTime(beginDate); //int[] beginArr = WebComm.GetIntArrayByStringArray(beginDate.Split('-')); //int beginYear = beginArr[0]; //int beginMonth = beginArr[1]; //int beginDay = beginArr[2]; //amList = amList.Where(a => a.iyear >= beginYear && a.imonth >= beginMonth && a.iday >= beginDay); amList = amList.Where(a => a.ApplyDate >= bDate); } #endregion SetPagerOptions(amList.Count(), currentPage); List<Apply_Main> list = amList.OrderBy(b => b.ID).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(); //添加合计行 Apply_Main applySum = new Apply_Main(); applySum.Apply_Sub = null; applySum.ApplyDate = new DateTime(); applySum.ApplyInMoney = list.Sum(l => l.ApplyInMoney); applySum.ApplyOutMoney = list.Sum(l => l.ApplyOutMoney); applySum.ApplyUserID = loginUser.ID; applySum.CreateDate = null; applySum.ID = 0; applySum.iday = 0; applySum.imonth = 0; applySum.iNowCashMoney = 0; applySum.iyear = 0; applySum.User = null; list.Insert(0, applySum); return list; }
public ActionResult List(Apply_Main am) { int pageNO = 1; if (Request.Form["pageNum"] != null) { int.TryParse(Request.Form["pageNum"], out pageNO); } BindComboxUser(); string ApplyDate_Begin = Request.Form["ApplyDate_Begin"]; string ApplyDate_End = Request.Form["ApplyDate_End"]; ViewBag.beginDate = ApplyDate_Begin; ViewBag.endDate = ApplyDate_End; List<Apply_Main> list = GetApply_MainList(pageNO, am, ApplyDate_Begin, ApplyDate_End); return View(viewFolder + "List.cshtml", list); }