コード例 #1
0
ファイル: HseToolController.cs プロジェクト: paddy235/ERCHTMS
        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() });
            }
        }
コード例 #2
0
ファイル: HseToolController.cs プロジェクト: paddy235/ERCHTMS
 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() });
     }
 }