/// <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;
}
}
