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()));
}
}
