/// <summary>
/// 抓取所有数据元
/// Add by xlb 2013-04-12
/// </summary>
/// <returns></returns>
public List <DateElementEntity> GetAllDateElement()
{
try
{
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 dtDateTable = DS_SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElement", sqlParams, CommandType.StoredProcedure);
List <DateElementEntity> dataList = DataTableToList <DateElementEntity> .ConvertToModel(dtDateTable);
return(dataList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 通过病人病案号抓取相应的使用对象集合
/// Add by xlb 2013-04-12
/// </summary>
/// <returns></returns>
public List <IemMainPageExceptUse> GetIemExceptUse(string noofinpat)
{
try
{
SqlParameter[] sps = { new SqlParameter("@noofinpat", noofinpat) };
DataTable dt = DS_SqlHelper.ExecuteDataTable(sqlGetIemUseByNoof, sps, CommandType.Text);
List <IemMainPageExceptUse> iemExceptUse = DataTableToList <IemMainPageExceptUse> .ConvertToModel(dt);
return(iemExceptUse);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 抓取病案扩展维护集合
/// Add by xlb 2013-04-12
/// </summary>
/// <param name="dateList">数据元集合</param>
/// <returns>扩展维护集合</returns>
public List <IemMainPageExcept> GetIemMainPageExcept(Dictionary <string, DateElementEntity> dateList)
{
try
{
SqlParameter p_result = new SqlParameter("@result", SqlDbType.Structured);
p_result.Direction = ParameterDirection.Output;
DataTable dataTable = DS_SqlHelper.ExecuteDataTable("MainPageExtenSion.GETIEMEXCEPT", new SqlParameter[] { p_result }, CommandType.StoredProcedure);
List <IemMainPageExcept> IemMainPageExceptList = DataTableToList <IemMainPageExcept> .ConvertToModel(dataTable);
foreach (var item in IemMainPageExceptList)
{
ConvertToIemMainExceptList(item, dateList);
}
return(IemMainPageExceptList);
}
catch (Exception ex)
{
throw ex;
}
}
