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