/// <summary> /// 重要指标 /// </summary> /// <returns></returns> internal List <EntityReportMainItem> GetMainIndicate(EntitymModelAccessRecord vo) { List <EntityReportMainItem> data = new List <EntityReportMainItem>(); List <EntityReportMainItemConfig> lstMainItemConfig; using (ProxyHms proxy = new ProxyHms()) { proxy.Service.GetTjResult(vo.regNo, out lstTjResult, out lstXjResult, out tjjljyVo); lstMainItemConfig = proxy.Service.GetReportMainItemConfig(); } if (lstTjResult == null) { return(null); } EntityReportMainItem mainItem; foreach (var mConfig in lstMainItemConfig) { EntityTjResult result = lstTjResult.Find(r => r.itemCode == mConfig.itemCode); if (result != null) { mainItem = new EntityReportMainItem(); mainItem.reportId = result.regNo; mainItem.sectionName = result.itemName; mainItem.itemName = result.itemName; mainItem.itemValue = result.itemResult; mainItem.itemUnits = result.unit; mainItem.itemRefrange = result.range; mainItem.isNormal = result.hint; if (!string.IsNullOrEmpty(result.hint)) { mainItem.pic = ReadImageFile("picHint.png"); } if (result.ttop == "2" && !string.IsNullOrEmpty(result.examinationNo)) { EntityTjResult resultTmp = lstTjResult.Find(r => r.itemCode == result.examinationNo); mainItem.sectionName = resultTmp.itemName; } data.Add(mainItem); } } return(data); }
/// <summary> /// 获取重要指标 /// </summary> /// <param name="reportId"></param> /// <returns></returns> public List <EntityReportMainItem> GetReportMainItem(string reportId) { List <EntityReportMainItem> data = null; SqlHelper svc = new SqlHelper(EnumBiz.onlineDB); if (string.IsNullOrEmpty(reportId)) { return(null); } string Sql = @"select a.pat_name AS clientName, a.reg_no AS reportId, a.dept_name as sectionName, a.hint as isNormal, a.comb_code AS itemCode, a.comb_name AS itemName, a.result AS itemValue, a.bound AS itemRefrange, a.unit as itemUnits, a.doct_name AS createName, a.rec_date AS createDate FROM V_TJBG a WHERE a.reg_no = ? and a.comb_code in (select itemCode from reportMainItemConfig)"; if (string.IsNullOrEmpty(reportId)) { return(null); } IDataParameter parm = svc.CreateParm(); parm.Value = reportId; DataTable dt = svc.GetDataTable(Sql, parm); if (dt != null && dt.Rows.Count > 0) { data = new List <EntityReportMainItem>(); EntityReportMainItem vo = null; foreach (DataRow dr in dt.Rows) { vo = new EntityReportMainItem(); //vo.id = dr["id"].ToString(); //vo.clientId = dr["clientId"].ToString(); vo.reportId = dr["reportId"].ToString(); vo.sectionName = dr["sectionName"].ToString(); vo.itemName = dr["itemName"].ToString(); vo.itemValue = dr["itemValue"].ToString(); vo.itemUnits = dr["itemUnits"].ToString(); vo.itemRefrange = dr["itemRefrange"].ToString(); vo.isNormal = dr["isNormal"].ToString(); //vo.minValue = dr["minValue"].ToString(); //vo.maxValue = dr["maxValue"].ToString(); //vo.orderId = Function.Int(dr["orderId"]) ; //vo.bakField1 = dr["bakField1"].ToString(); //vo.bakField2 = dr["bakField2"].ToString(); vo.createDate = Function.Datetime(dr["createDate"]); //vo.createId = dr["createId"].ToString(); vo.createName = dr["createName"].ToString(); //vo.modifyDate = Function.Datetime(dr["modifyDate"]) ; //vo.modifyId = dr["modifyId"].ToString(); //vo.modifyName = dr["modifyName"].ToString(); data.Add(vo); } } return(data); }