/// <summary> /// 查询加班列表 /// </summary> /// <param name="request">条件</param> /// <returns>加班列表</returns> public Response <List <JBRecord> > GetJBRecordList(Request <JBQuery> request) { Response <List <JBRecord> > response = new Response <List <JBRecord> >(); try { if (request != null && request.Data != null) { JBQuery model = request.Data; RoleType role = utility.GetRoleType(cookieKey); model.UserID = role == RoleType.Admin ? model.UserID : utility.GetUserID(cookieKey); IQueryable <JBRecord> query = dbContext.JBRecords.AsQueryable(); if (model.UserID.HasValue && model.UserID != 0)//role != RoleType.Admin { query = query.Where(o => o.UserID == model.UserID.Value); } //if (model.Year.HasValue) //{ // query = query.Where(o => o.Year == model.Year.Value); //} //if (model.Month.HasValue) //{ // query = query.Where(o => o.Month == model.Month.Value); //} if (model.STime.HasValue) { query = query.Where(o => o.STime >= model.STime.Value); } if (model.ETime.HasValue) { query = query.Where(o => o.ETime <= model.ETime.Value); } if (!string.IsNullOrEmpty(model.RemarkKey)) { query = query.Where(o => o.Remark.Contains(model.RemarkKey)); } //response.Result = query.OrderByDescending(o => o.ModifiedTime).ToList(); response.TotalCount = query.Count(); int pageIndex = model.PageIndex <= 0 ? 1 : model.PageIndex; int pageSize = model.PageSize <= 0 ? 10 : model.PageSize; response.Result = query.OrderByDescending(o => o.ModifiedTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); if (response.Result != null && response.Result.Count > 0) { response.IsSuccess = true; } else { response.ErrorMsg = "没有数据!"; } log.AddLog(LogType.Info, "GetJBRecordList,查询结果:" + JsonConvert.SerializeObject(response), request.RequestKey); } } catch (Exception ex) { log.AddLog(LogType.Error, "GetJBRecordList,查询加班异常:" + ex.Message, request.RequestKey); } return(response); }
/// <summary> /// 查询加班记录 /// </summary> /// <param name="data"></param> /// <returns></returns> public ActionResult JBList(JBQuery data) { if (Request.HttpMethod == "POST") { Response <List <JBRecord> > response = new Response <List <JBRecord> >(); List <object> list = new List <object>(); if (data != null) { Request <JBQuery> request = new Request <JBQuery>(); request.Data = data; request.RequestKey = Guid.NewGuid().ToString(); request.RequsetTime = DateTime.Now; response = logic.GetJBRecordList(request); //行号 #region if (response.Result != null && response.Result.Count > 0) { int index = 1; foreach (JBRecord item in response.Result) { list.Add(new { RowNum = index, JID = item.JID, UserID = item.UserID, STime = item.STime, ETime = item.ETime, Hours = item.Hours, Remark = item.Remark, AddTime = item.AddTime, ModifiedTime = item.ModifiedTime }); index++; } } #endregion } //return Json(new { data = response.Result }); //return Json(new { rows = response.Result, total = response.TotalCount }); return(Json(new { rows = list, total = response.TotalCount })); } else { //int userid = Convert.ToInt32(Request.QueryString["userid"]); //int year = Convert.ToInt32(Request.Params["year"]); //int month = Convert.ToInt32(Request["month"]); ViewData["UserID"] = string.IsNullOrEmpty(Request["userid"])?"0":Request["userid"]; ViewData["Year"] = string.IsNullOrEmpty(Request["year"]) ? "0" : Request["year"]; ViewData["Month"] = string.IsNullOrEmpty(Request["month"]) ? "0" : Request["month"]; return(View()); } }