/// <summary> /// 获取病人对象 /// </summary> private void GeInpat() { try { DataTable dtInpat = DS_SqlHelper.ExecuteDataTable(@"select noofinpat,patid,outhosdept, outhosward,outbed,name from inpatient where noofinpat=@noofinpat", new SqlParameter[] { new SqlParameter("@noofinpat", CurrentNoofinpat) }, CommandType.Text); //datatable->inpatientsim inpatient = DataTableToList <InpatientSim> .ConvertToModelOne(dtInpat); } catch (Exception ex) { throw ex; } }
/// <summary> /// 抓取所有数据元 DataTable->Dictionary /// Add by xlb 2013-04-12 /// </summary> /// <returns></returns> public Dictionary <string, DateElementEntity> GetDataElement() { try { Dictionary <string, DateElementEntity> dateElement = new Dictionary <string, DateElementEntity>(); SqlParameter p_result = new SqlParameter("@result", SqlDbType.Structured); p_result.Direction = ParameterDirection.Output; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@ElementId", SqlDbType.VarChar, 50), new SqlParameter("@ElementName", SqlDbType.VarChar, 50), new SqlParameter("@ElementClass", SqlDbType.VarChar, 50), new SqlParameter("@ElementPYM", SqlDbType.VarChar, 50), p_result }; sqlParams[0].Value = ""; sqlParams[1].Value = ""; sqlParams[2].Value = ""; sqlParams[3].Value = ""; DataTable dtData = DS_SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElement", sqlParams, CommandType.StoredProcedure); DataTable dtElementEntity = dtData.Clone(); foreach (DataRow row in dtData.Rows) { dtElementEntity.Rows.Clear(); dtElementEntity.Rows.Add(row.ItemArray); DateElementEntity dateElementEntity = DataTableToList <DateElementEntity> .ConvertToModelOne(dtElementEntity); dateElement.Add(row["ELEMENTFLOW"].ToString(), dateElementEntity); } return(dateElement); } catch (Exception ex) { throw ex; } }