/// <summary> /// 批量执行界面获取 /// </summary> /// <param name="clientKey"></param> /// <param name="hasExe"></param> /// <param name="noExe"></param> /// <returns></returns> public ActionResult SelectDataItemExe(string clientKey, string hasExe, string noExe) { var hasExeitemIdList = hasExe.Split(',').ToList(); var noExeItemIdList = noExe.Split(',').ToList(); var hasExeItems = _itemService.GetManay(i => hasExeitemIdList.Contains(i.SD_ITEM_ID.ToString())).Select(i => i.SD_ITEM_ID); var noExeItems = _itemService.GetManay(i => noExeItemIdList.Contains(i.SD_ITEM_ID.ToString())).Select(i => i.SD_ITEM_ID); ViewBag.HasExeData = hasExeItems.ToJson(); ViewBag.NoExeData = noExeItems.ToJson(); ViewBag.ClientKey = clientKey; return(View()); }
public ActionResult CompareDataItem(int cdrId1, int cdrId2, string startTime, string endTime) { var sdId = ProjectProvider.Instance.Current.SD_ID; var itemInfoList = _itemService.GetManay(m => m.SD_ID == sdId); var compareResult = _itemCompareService.GetCompareResult(cdrId1, cdrId2, startTime, endTime, itemInfoList); var result = new Dictionary <string, object>() { { "code", 0 }, { "msg", "success" }, { "data", compareResult }, { "count", compareResult.Count } }; return(Content(result.ToJson())); }
public ActionResult GetEkpiItem(string kpiId) { var id = int.Parse(kpiId); var ekpiItemList = _ekpiItemService.GetManay(i => i.SD_EKPI_ID == id); var itemIdList = ekpiItemList.Select(i => i.SD_ITEM_ID).ToList(); var itemInfo = _itemService.GetManay(i => itemIdList.Contains(i.SD_ITEM_ID)).ToList(); foreach (var item in ekpiItemList) { item.UPD_USER_ID = itemInfo.Where(i => i.SD_ITEM_ID == item.SD_ITEM_ID).ToList().FirstOrDefault().SD_ITEM_NAME; } return(Content(ekpiItemList.ToJson())); }
private List <USERSANDSTATES_VIEWMODEL> GetInfos(List <int> sdList) { try { var result = _ingroupService.GetManay(r => sdList.Contains(r.SD_ID)).GroupBy(r => new { r.SD_ID, r.CREATE_USER_ID }).Select(s => new USERSANDSTATES_VIEWMODEL { SD_ID = s.Key.SD_ID, CAT_CODE = "1", CREATE_USER_ID = s.Key.CREATE_USER_ID }).Concat(_dataitemService.GetManay(r => sdList.Contains((int)r.SD_ID)).GroupBy(r => new { r.SD_ID, r.CREATE_USER_ID }).Select(s => new USERSANDSTATES_VIEWMODEL { SD_ID = (int)s.Key.SD_ID, CAT_CODE = "2", CREATE_USER_ID = s.Key.CREATE_USER_ID })).Concat(_kpiService.GetManay(r => sdList.Contains((int)r.SD_ID)).GroupBy(r => new { r.SD_ID, r.CREATE_USER_ID }).Select(s => new USERSANDSTATES_VIEWMODEL { SD_ID = (int)s.Key.SD_ID, CAT_CODE = "3", CREATE_USER_ID = s.Key.CREATE_USER_ID })).ToList(); //var result = (from ingroup in _ingroupService.GetManay(r => sdList.Contains(r.SD_ID)) // select string.Format("{0};{1};{2}", ingroup.SD_ID, "1", ingroup.CREATE_USER_ID) // ).Concat(from dataItem in _dataitemService.GetManay(r => sdList.Contains((int)r.SD_ID)) // select string.Format("{0};{1};{2}", dataItem.SD_ID, "2", dataItem.CREATE_USER_ID)) // .Concat(from kpi in _kpiService.GetManay(r => sdList.Contains((int)r.SD_ID)) // select string.Format("{0};{1};{2}", kpi.SD_ID, "3", kpi.CREATE_USER_ID)).Distinct().Select(info=> new USERSANDSTATES_VIEWMODEL() // { // SD_ID = int.Parse(info.Split(';')[0]), // CAT_CODE = info.Split(';')[1], // CREATE_USER_ID = info.Split(';')[2] // } // ).ToList(); return(result); } catch (Exception ex) { throw ex; } }