public static string getModel() { DeviceQueryBLL bll = new DeviceQueryBLL(); var result = bll.getBioModel(); var retvalue = JsonConvert.SerializeObject(result).Replace("null", "\"\""); return(retvalue); }
public static string getProductType() { DeviceQueryBLL bll = new DeviceQueryBLL(); var result = bll.getProductType(); var retvalue = JsonConvert.SerializeObject(result); return(retvalue); }
public static string getNumDetail(string sn, string num) { try { DeviceQueryBLL bll = new DeviceQueryBLL(); var result = bll.getNumDetail(sn, num); var retvalue = JsonConvert.SerializeObject(result).Replace("null", "\"\"");; return(retvalue); } catch (Exception ex) { } return("{}"); }
public static string GetBioDeviceFault(string sn, string dtstart, string dtend) { try { DeviceQueryBLL bll = new DeviceQueryBLL(); var result = bll.GetBioDeviceFaultBLL(sn, dtstart, dtend); var retvalue = JsonConvert.SerializeObject(result).Replace("null", "\"\"");; return(retvalue); } catch (Exception ex) { } return(sn); }
public static string getBioDeviceDetial(string sn) { try { DeviceQueryBLL bll = new DeviceQueryBLL(); var result = bll.GetBioDeviceDetialBLL(sn); var retvalue = JsonConvert.SerializeObject(result).Replace("null", "\"\"");; return(retvalue); } catch (Exception ex) { } return(sn); }
public static string GetDeviceFault(string sn) { try { DeviceQueryBLL bll = new DeviceQueryBLL(); var result = bll.GetDeviceFaultBLL(sn); var retvalue = JsonConvert.SerializeObject(result); return(retvalue); } catch (Exception ex) { } return(sn); }
public static string getDeviceSampleList(string conditions) { if (string.IsNullOrEmpty(conditions)) { return("{\"total\":0,\"rows\":[]}"); } DeviceQueryBLL bll = new DeviceQueryBLL(); List <BioStatistics> list = new List <BioStatistics>(); list = bll.GetDeviceInfoBLL(conditions); var result = new { total = list.Count, rows = list }; return(JsonConvert.SerializeObject(result).Replace("null", "\"\"")); }
public static string getDeviceList(string conditions, int rows, int page, string sort, string sortOrder) { if (rows == 0) { return("{\"total\":0,\"rows\":[]}"); } DeviceQueryBLL bll = new DeviceQueryBLL(); PagerInfo pagerInfo = new PagerInfo(); pagerInfo.CurrenetPageIndex = page; pagerInfo.PageSize = rows; SortInfo sortInfo = new SortInfo(sort, sortOrder); QueryConditionModel conditionModel = JsonConvert.DeserializeObject <QueryConditionModel>(conditions.Replace("\"0\"", "\"\"")); if (conditionModel.QueryRange == "1") { conditionModel.DeviceState = MachineState.已连接仪器; } else if (conditionModel.QueryRange == "2") { conditionModel.DeviceState = MachineState.未连接仪器; } List <QueryList> list = new List <QueryList>(); list = bll.GetDeviceInfoBLL(conditionModel, pagerInfo, sortInfo); pagerInfo.RecordCount = bll.getDeviceCount(conditionModel); //Json格式的要求{total:22,rows:{}} //构造成Json的格式传递 var result = new { total = pagerInfo.RecordCount, rows = list }; return(JsonConvert.SerializeObject(result).Replace("null", "\"\"")); }
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); }