public static string getPoctDeviceFault(string sn, string dtstart, string dtend)
{
try
{
DeviceQueryBLL bll = new DeviceQueryBLL();
var result = bll.GetPoctDeviceFaultBLL(sn, dtstart, dtend);
var retvalue = JsonConvert.SerializeObject(result).Replace("null", "\"\"");;
return(retvalue);
}
catch (Exception ex)
{
}
return(sn);
}
public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string message = "";
string Action = context.Request["Action"];
//params
string sn = context.Request["sn"] ?? "";
string model = context.Request["model"] ?? "";
if (model.Trim() == "0")
{
model = "";
}
string conditions = context.Request["conditions"] ?? "";
DeviceQueryBLL bll = new DeviceQueryBLL();
StatisticsBLL staticBll = new StatisticsBLL();
PoctStatisticsBLL poctStaticBll = new PoctStatisticsBLL();
QueryConditionModel condition;
DataTable dt = new DataTable();
string fileName = "";
string[] headers = new string[] { };
switch (Action)
{
case "fault":
dt = bll.GetDeviceFaultForExportBLL(sn);//获取导出数据源
fileName = "错误信息";
headers = new string[] { "错误码", "时间" };
break;
case "yangben":
dt = bll.GetDeviceSampleForExportBLL();//获取导出数据源
fileName = "样本信息";
headers = new string[] { "system_seq", "仪器序列号", "计数值", "计数类型", "时间" };
break;
case "cuowu":
dt = bll.GetDeviceFaultForExportBLL();//获取导出数据源
fileName = "错误信息";
headers = new string[] { "id", "仪器序列号", "错误码", "时间" };
break;
case "bio_fault":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = bll.GetBioDeviceFaultBLL(condition.SN, condition.dtStart, condition.dtEnd);
fileName = "生化仪统计_故障信息";
headers = new string[] { "错误码", "时间" };
break;
case "bio_all":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = staticBll.StatisticsAllBioDevicesForExportBLL(condition);
fileName = "生化仪统计_所有机器";
headers = new string[] { "仪器名称", "上报时间", "SIM卡号", "仪器序列号", "样本数", "R1试剂使用量(mL)", "R2试剂使用量(mL)" };
break;
case "bio_area":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = staticBll.BioStatisticsByAreaForExportBLL(condition);
fileName = "生化仪统计_按区域";
headers = new string[] { "装机区域", "仪器总数", "样本数", "R1试剂使用量(mL)", "R2试剂使用量(mL)" };
break;
case "bio_type":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = staticBll.BioStatisticsByTypeForExportBLL(condition);
fileName = "生化仪统计_按机型";
headers = new string[] { "机型", "仪器总数", "样本数", "R1试剂使用量(mL)", "R2试剂使用量(mL)" };
break;
case "poct_fault":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = bll.GetPoctDeviceFaultBLL(condition.SN, condition.dtStart, condition.dtEnd);
fileName = "POCT统计_故障信息";
headers = new string[] { "错误码", "时间" };
break;
case "poct_all":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = poctStaticBll.StatisticsAllPoctDevicesForExportBLL(condition);
fileName = "POCT统计_所有机器";
headers = new string[] { "仪器名称", "上报时间", "SIM卡号", "仪器序列号", "样本数", "测试卡消耗数" };
break;
case "poct_area":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = poctStaticBll.PoctStatisticsByAreaForExportBLL(condition);
fileName = "POCT统计_按区域";
headers = new string[] { "装机区域", "仪器总数", "样本数", "测试卡消耗数" };
break;
case "poct_type":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = poctStaticBll.PoctStatisticsByTypeForExportBLL(condition);
fileName = "POCT统计_按机型";
headers = new string[] { "机型", "仪器总数", "样本数", "测试卡消耗数" };
break;
case "poct_all_num":
condition = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = poctStaticBll.StatisticsAllPoctNumForExportBLL(condition);
fileName = "POCT统计_总量统计";
headers = new string[] { "仪器型号", "测试项目", "样本数", "测试卡消耗数" };
break;
case "bio_log":
LogConditionModel conditionModel = JsonConvert.DeserializeObject <LogConditionModel>(conditions.Replace("\"0\"", "\"\""));
dt = staticBll.StatisticsLogsForExportBLL(conditionModel);
fileName = "日志查询";
headers = new string[] { "仪器名称", "SIM卡号", "仪器序列号", "发生时间", "日志内容" };
break;
}
ExportExcel(context, dt, headers, fileName + sn + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"));
context.Response.Write(message);
}