public ActionResult Orders_Read3(string[] sdatepic, string[] edatepic, string[] datazl)
{
数据库处理 sjkcl = new 数据库处理();
List <资料种类> dataLists = dataLists = sjkcl.获取数据库表信息();
List <SKViewModel> result = new List <SKViewModel>();
if (datazl == null || datazl.Length == 0)
{
result = sjkcl.获取指定时间统计信息(Convert.ToDateTime(sdatepic[0]), Convert.ToDateTime(edatepic[0]));
}
else
{
bool bs = false;
foreach (string item in datazl)
{
if (item.ToLower() == "all")
{
bs = true;
}
}
if (bs)
{
result = sjkcl.获取指定时间统计信息(Convert.ToDateTime(sdatepic[0]), Convert.ToDateTime(edatepic[0]));
}
else
{
string filter = "";
foreach (string item in datazl)
{
filter += $"\'{item}\',";
}
filter = filter.Substring(0, filter.Length - 1);
result = sjkcl.获取指定时间统计信息(Convert.ToDateTime(sdatepic[0]), Convert.ToDateTime(edatepic[0]), filter);
}
}
for (int i = 0; i < result.Count; i++)
{
资料种类 item = dataLists.First(y => y.数据库表名称 == result[i].称);
if (item != null)
{
result[i].称 = item.表名称;
}
}
return(Json(result));
}
public ActionResult 当前小时分钟数据()
{
string[] datazl = "SK_Other_Minute,SK_Pre_Minute,SK_RHU_Minute,SK_PRS_Minute,SK_Tem_Minute,SK_Wind_Minute".Split(',');
数据库处理 sjkcl = new 数据库处理();
List <资料种类> dataLists = sjkcl.获取数据库表信息();
List <SKViewModel> result = new List <SKViewModel>();
string filter = "";
foreach (string item in datazl)
{
filter += $"\'{item}\',";
}
filter = filter.Substring(0, filter.Length - 1);
result = sjkcl.获取指定时间统计信息(DateTime.Now.Date.AddHours(DateTime.Now.Hour), DateTime.Now, filter);
List <DateTime> dateTimes = new List <DateTime>();
foreach (var item in result)
{
if (!dateTimes.Exists(y => y == item.时间))
{
dateTimes.Add(Convert.ToDateTime(item.时间));
}
}
foreach (string item in datazl)
{
foreach (DateTime mydt in dateTimes)
{
if (!result.Exists(y => y.时间 == mydt && y.称 == item))
{
result.Add(new SKViewModel {
时间 = mydt, 称 = item, 统计个数 = 0
});
}
}
}
for (int i = 0; i < result.Count; i++)
{
资料种类 item = dataLists.First(y => y.数据库表名称 == result[i].称);
if (item != null)
{
result[i].称 = item.表名称;
}
}
return(Json(result));
}
public List <SKViewModel> getdateDefault(DateTime sdate, DateTime edate, string datazl)
{
数据库处理 sjkcl = new 数据库处理();
List <资料种类> dataLists = sjkcl.获取数据库表信息();
List <SKViewModel> result = new List <SKViewModel>();
result = sjkcl.获取指定时间资料名统计信息(sdate, edate, datazl);
for (int i = 0; i < result.Count; i++)
{
资料种类 item = dataLists.First(y => y.数据库表名称 == result[i].称);
if (item != null)
{
result[i].称 = item.表名称;
}
}
return(result);
}
public ActionResult 备用(string[] sdatepic, string[] edatepic, string[] datazl, [DataSourceRequest] DataSourceRequest request)
{
数据库处理 sjkcl = new 数据库处理();
List <资料种类> dataLists = dataLists = sjkcl.获取数据库表信息();
List <SKViewModel> result = new List <SKViewModel>();
if (datazl == null || datazl.Length == 0)
{
result = sjkcl.获取指定时间统计信息(Convert.ToDateTime(sdatepic[0]), Convert.ToDateTime(edatepic[0]));
}
else
{
bool bs = false;
foreach (string item in datazl)
{
if (item.ToLower() == "all")
{
bs = true;
}
}
if (bs)
{
result = sjkcl.获取指定时间统计信息(Convert.ToDateTime(sdatepic[0]), Convert.ToDateTime(edatepic[0]));
}
else
{
string filter = "";
foreach (string item in datazl)
{
filter += $"\'{item}\',";
}
filter = filter.Substring(0, filter.Length - 1);
result = sjkcl.获取指定时间统计信息(Convert.ToDateTime(sdatepic[0]), Convert.ToDateTime(edatepic[0]), filter);
}
}
for (int i = 0; i < result.Count; i++)
{
资料种类 item = dataLists.First(y => y.数据库表名称 == result[i].称);
if (item != null)
{
result[i].称 = item.表名称;
if (result[i].称.Contains("分钟"))
{
result[i].种类 = "分钟";
}
else if (result[i].称.Contains("小时"))
{
result[i].种类 = "小时";
}
else
{
result[i].种类 = "其他";
}
}
}
List <SKViewModel> result2 = new List <SKViewModel>();
foreach (var item in result)
{
string name = item.称.Replace("小时", "").Replace("分钟", "");
if (!result2.Exists(y => y.称 == name && y.时间 == item.时间))
{
result2.Add(new SKViewModel()
{
称 = name,
时间 = item.时间
});;
}
if (item.种类 == "分钟")
{
result2.First(y => y.称 == name && y.时间 == item.时间).分钟个数 = item.统计个数;
}
else
{
result2.First(y => y.称 == name && y.时间 == item.时间).小时个数 = item.统计个数;
}
}
//result = result.Where(y => y.名称.Contains("小时")).ToList();
return(Json(result2));
}
