public object GetSummary([FromBody] JObject json) { try { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string id = dy.data.id; string userid = dy.userid; string year = dy.data.year; string month = dy.data.month; string deptId = dy.data.deptid; OperatorProvider.AppUserId = userid; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { return(new { code = -1, info = "请求失败,请登录!", data = new object() }); } var bll = new SelfEvaluateBLL(); EvaluateGroupSummaryEntity data = new EvaluateGroupSummaryEntity(); if (string.IsNullOrWhiteSpace(id)) { data = bll.GetSummary(year, month, deptId); } else { data = bll.GetSummaryById(id); } return(new { code = 0, info = "获取成功", data = data }); } catch (Exception ex) { return(new { code = -1, info = "获取数据失败:" + ex.Message, data = new object() }); } }
public object GetSelfEvaluateMonthList([FromBody] JObject json) { try { var bll = new SelfEvaluateBLL(); string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); int page = Convert.ToInt32(dy.data.pageNum), rows = Convert.ToInt32(dy.data.pageSize); string keyword = dy.data.keyword; string userid = dy.userid; OperatorProvider.AppUserId = userid; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { return(new { code = -1, count = 0, info = "请求失败,请登录!", data = new object() }); } var list = bll.GetList("", curUser.DeptCode, keyword).ToList(); var nlist = new List <MonthEvaluate>(); var ylist = list.GroupBy(x => x.Year).Select(x => x.FirstOrDefault().Year).OrderByDescending(x => x); //根据年分分组 var userCount = new UserBLL().GetList().Count(p => p.DepartmentCode.StartsWith(curUser.DeptCode) && p.IsPresence == "1"); foreach (string year in ylist) { var mlist = list.Where(x => x.Year == year).GroupBy(x => x.Month).Select(x => x.FirstOrDefault().Month).OrderByDescending(x => x);//查询当年数据根据月份分组 foreach (string month in mlist) { var obj = new MonthEvaluate(); obj.name = year + "年" + month + "月员工HSE自我评估"; obj.count1 = list.Where(x => x.Year == year && x.Month == month && x.IsFill == "1").GroupBy(x => x.CreateUserId).Count(); obj.count2 = ((userCount - obj.count1) < 0 ? 0 : (userCount - obj.count1)); obj.year = year; obj.month = month; var summary = bll.GetSummary(year, month, curUser.DeptId); obj.content = summary == null ? "" : summary.Content; nlist.Add(obj); } } return(new { code = 0, count = 0, info = "获取成功", data = nlist }); } catch (Exception ex) { return(new { code = -1, count = 0, info = "获取数据失败:" + ex.Message, data = new object() }); } }