public ActionResult Form(string primaryKey) { var sdid = ProjectProvider.Instance.Current.SD_ID; var models = _kpiService.GetManay(r => r.SD_ID == sdid); var count = models.Select(i => i.ORDER_NO).OrderByDescending(i => i.Value).FirstOrDefault(); if (count == null) { ViewBag.count = 1; } else if (string.IsNullOrEmpty(primaryKey)) { ViewBag.count = count + 1; } else { ViewBag.count = count; } var SD_ID = ProjectProvider.Instance.Current.SD_ID; var sd = _sdService.Get(r => r.SD_ID == SD_ID); var EKPI_CAT_PA_CODE = (sd == null) ? "" : sd.EKPI_CAT_PA_CODE; ViewBag.ItemType = _catconfService.GetSearchList(s => s.CAT_PA_CODE == EKPI_CAT_PA_CODE); return(View()); }
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; } }
public ActionResult InsertRSNData(HttpPostedFileBase filebase, string IsRsnOrDict, string primaryKey, string TC_PROJ_ID)//zlt HttpPostedFileBase { try { if (string.IsNullOrEmpty(primaryKey) || string.IsNullOrEmpty(TC_PROJ_ID)) { var result = new Tuple <string, string>("catch", "病种id或项目id为空"); return(Content(result.ToJson())); } DataTable error = null; var id = int.Parse(primaryKey); var projId = int.Parse(TC_PROJ_ID); //var connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString(); var sdInfo = _sdService.Get(r => r.SD_ID == id) ?? new SD_INFO(); var dbConfig = _dbConfService.Get(r => r.TC_PROJ_ID == projId && r.DB_CONF_TYPE == 2) ?? new PDP_DB_CONF(); //if (sdInfo.TC_PROJ_ID == ProjectProvider.Instance.Current.TC_PROJ_ID) //{ var connStr = $"Data Source='" + dbConfig.SERVER_NAME + "';Initial Catalog='" + dbConfig.DB_NAME + "';User ID='" + dbConfig.DB_USER + "';Password='******'"; //var connStr = $"Data Source='" + ProjectProvider.Instance.Current.UNIT_DATA_SOURCE + "';Initial Catalog='" + ProjectProvider.Instance.Current.UNIT_INITIAL_CATALOG + "';User ID='" + ProjectProvider.Instance.Current.UNIT_USER_ID + "';Password='******'"; var sdCode = sdInfo.SD_CODE; var filePath = Server.MapPath(string.Format("~/{0}", "File")); var fullPath = Path.Combine(filePath, filebase.FileName); filebase.SaveAs(fullPath); var excelBll = new ExcelBLL(connStr, primaryKey, sdCode); DataSet ds = ExcelOperater.Read(fullPath); if (IsRsnOrDict == "0") { if (IsPossible(ds)) { DataTable dtKpiInfo = new DataTable(); dtKpiInfo.Columns.Add("SD_EKPI_ID"); dtKpiInfo.Columns.Add("SD_EKPI_NAME"); var kpiInfoList = _kpiService.GetManay(r => r.SD_ID == id).ToList(); if (kpiInfoList != null && kpiInfoList.Count > 0) { foreach (var kpiInfo in kpiInfoList) { DataRow dr = dtKpiInfo.NewRow(); dr["SD_EKPI_ID"] = kpiInfo.SD_EKPI_ID; dr["SD_EKPI_NAME"] = kpiInfo.SD_EKPI_NAME; dtKpiInfo.Rows.Add(dr); } _sdService.ClearData(primaryKey, IsRsnOrDict); error = excelBll.InsertRSNData(ds, OperatorProvider.Instance.Current.RealName, dtKpiInfo); } else { var result = new Tuple <string, string>("catch", "该病种下无KPI数据!"); return(Content(result.ToJson())); } } else { var result = new Tuple <string, string>("catch", "导入的excel文件模板有问题!"); return(Content(result.ToJson())); } } else { var result = new Tuple <string, string>("catch", "该功能暂时未实现!"); return(Content(result.ToJson())); } //} //else //{ // var result = new Tuple<string, string>("catch", "请切换该项目为当前项目!"); // return Content(result.ToJson()); //} if (error != null && error.Rows.Count > 0) { var res = error.ToJson().Replace("\r\n", "").Replace(" ", "").Replace(" ", "").Replace("\"", "'"); var guid = Guid.NewGuid().ToString(); var result = new Tuple <string, string>("error", guid); ImportResult.Add(result, res); return(Content(result.ToJson())); } else { var result = new Tuple <string, string>("success", null); return(Content(result.ToJson())); } } catch (Exception ex) { var result = new Tuple <string, string>("catch", ex.Message); return(Content(result.ToJson())); } }