/// <summary>
/// 选中最多5中检查类型，查看对应的信息对比
/// </summary>
/// <param name="startDateTime"></param>
/// <param name="endDateTime"></param>
/// <param name="hospitalDistrict"></param>
/// <returns></returns>
public List <SpecialInspection> GetSpecialInspectionsGroupByTime(DateTime startDateTime, DateTime endDateTime, String[] inspactTypes, params String[] hospitalDistrict)
{
var specialInspections = new List <SpecialInspection>();
var command = GetSpecialCommandGroupByTime(startDateTime, endDateTime, inspactTypes, hospitalDistrict);
var queryCommand = db.GetSqlStringCommand(command);
using (var reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
var si = new SpecialInspection();
si.TimeStamp = reader.GetString(0);
si.InspectionType = reader.GetString(1);
si.AppointmentDuration = StringHandler.GetDoubleByString(reader.IsDBNull(2) ? "0" : reader.GetString(2), 1);
si.ReportDuration = StringHandler.GetDoubleByString(reader.IsDBNull(3) ? "0" : reader.GetString(3), 1);
si.ActualInspectNum = StringHandler.GetDoubleByString(reader.IsDBNull(4) ? "0" : reader.GetString(4), 1);
si.BreakNum = StringHandler.GetDoubleByString(reader.IsDBNull(5) ? "0" : reader.GetString(5), 1);
specialInspections.Add(si);
}
}
return(specialInspections);
}
/// <summary>
/// 表格呈现以检查类型分组的特检信息表
/// </summary>
/// <param name="startDateTime"></param>
/// <param name="endDateTime"></param>
/// <param name="hospitalDistrict"></param>
/// <returns></returns>
public List <SpecialInspection> GetSpecialInspections(DateTime startDateTime, DateTime endDateTime, params String[] hospitalDistrict)
{
var specialInspections = new List <SpecialInspection>();
var hd = String.Join(",", hospitalDistrict);
var command = "SELECT JCLX,TO_CHAR(AVG(YYJCSC)) AS YYJCSC,TO_CHAR(AVG(JCBGSC)) AS JCBGSC,TO_CHAR(SUM(JCRS)) AS JCRS,TO_CHAR(SUM(SYRS)) AS SYRS FROM TJBG3.TJ_JCQKB "
+ " WHERE JCRQ>=TO_DATE('" + startDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "','YYYY-MM-DD HH24:MI:SS') "
+ " AND JCRQ<=TO_DATE('" + startDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "','YYYY-MM-DD HH24:MI:SS') AND YQDM IN (" + hd + ")"
+ " GROUP BY JCLX ";
var queryCommand = db.GetSqlStringCommand(command);
using (var reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
var si = new SpecialInspection();
si.InspectionType = reader.GetString(0);
si.AppointmentDuration = StringHandler.GetDoubleByString(reader.IsDBNull(1)?"0":reader.GetString(1), 1);
si.ReportDuration = StringHandler.GetDoubleByString(reader.IsDBNull(2) ? "0" : reader.GetString(2), 1);
si.ActualInspectNum = StringHandler.GetDoubleByString(reader.IsDBNull(3) ? "0" : reader.GetString(3), 1);
si.BreakNum = StringHandler.GetDoubleByString(reader.IsDBNull(4) ? "0" : reader.GetString(4), 1);
specialInspections.Add(si);
}
}
return(specialInspections);
}
