/// <summary>
/// 获取药品词典
/// </summary>
/// <returns></returns>
public static DataTable Get_DrugDiciton()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL();
base_dal.OleDB = oleDb;
return(base_dal.Get_HIS_DrugDicition());
}
/// <summary>
/// 获取匹配关心
/// </summary>
/// <param name="IsNew">是否是新增的匹配关系,true:是 false:下载的</param>
/// <param name="itemType">项目类型1-全部(不用);2-药品;3-项目</param>
/// <returns></returns>
public static DataTable Get_Ncms_MatchInfo(bool IsNew, string itemType)
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL();
base_dal.OleDB = oleDb;
if (IsNew)
{
if (itemType == "2")
{
return(base_dal.Get_Ncms_Drug_Match_TempList());
}
else
{
return(base_dal.Get_Ncms_Therapy_Match_TempList());
}
}
else
{
if (itemType == "2")
{
return(base_dal.Get_Ncms_Drug_MatchList());
}
else
{
return(base_dal.Get_Ncms_Therapy_MatchList());
}
}
}
/// <summary>
/// 获取指定SQL数据
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static DataTable GetDataTable(string strSql)
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL( );
base_dal.OleDB = oleDb;
return(base_dal.GetDataTable(strSql));
}
public ParameterSet()
{
//初始化加载所有参数,每个模块的所有参数对应一个Parameters并放到htParameters中
//htParameters.Key:ParameterCatalog
HIS.DAL.BASE_DAL dal = new HIS.DAL.BASE_DAL();
dal.OleDB = oleDb;
htParameters = new Hashtable();
//门诊经管
DataTable dtMzConfig = dal.Get_MZJG_Parameters();
htParameters.Add(ParameterCatalog.门诊经管, ToParameters(dtMzConfig));
//住院经管
DataTable dtZyCofig = dal.Get_ZYJG_parameters();
htParameters.Add(ParameterCatalog.住院经管, ToParameters(dtZyCofig));
//门诊医生
DataTable dtMZYSConfig = dal.Get_MZYS_Parameters();
htParameters.Add(ParameterCatalog.门诊医生站, ToParameters(dtMZYSConfig));
//住院医生
DataTable dtZYYSConfig = dal.Get_ZYYS_Parameters();
htParameters.Add(ParameterCatalog.住院医生站, ToParameters(dtZYYSConfig));
//住院护士
DataTable dtZYHSConfig = dal.Get_ZYHS_Parameters();
htParameters.Add(ParameterCatalog.住院护士站, ToParameters(dtZYHSConfig));
//药品管理
DataTable dtYPGLConfig = dal.Get_YPGL_Parameters();
htParameters.Add(ParameterCatalog.药品管理, ToParameters(dtYPGLConfig));
}
/// <summary>
/// 获得该人员的所属用户组
/// </summary>
/// <returns></returns>
public DataTable GetGroups()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL( );
base_dal.OleDB = oleDb;
return(base_dal.get_Employee_GetGroups(_employeeID));
}
/// <summary>
/// 获取收费项目列表
/// </summary>
/// <returns></returns>
public static DataTable GetServiceItemList()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL();
base_dal.OleDB = oleDb;
return(base_dal.get_Base_Service_Items());
}
public static DataTable GetRegisterTypeList()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL();
base_dal.OleDB = oleDb;
return(base_dal.GetRegisterTypeList());
}
public static DataTable GetRegisterTypeAndServiceItemRelation()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL();
base_dal.OleDB = oleDb;
return(base_dal.GetRegisterTypeAndServiceItemRelation());
}
public static DataTable GetBaseServiceItems()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL();
base_dal.OleDB = oleDb;
return(base_dal.GetBaseServiceItems());
}
/// <summary>
/// 获取医院还未使用的基本服务项目
/// </summary>
/// <returns></returns>
public static DataTable Get_BaseServiceItemWhereNotInUseByHospital()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL( );
base_dal.OleDB = oleDb;
return(base_dal.Get_Hospital_Service_Items( ));
}
/// <summary>
/// 获取医院的服务项目的执行科室(包括组合项目)
/// </summary>
/// <returns></returns>
public static DataTable Get_Hsitem_ExecDept()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL( );
base_dal.OleDB = oleDb;
return(base_dal.Get_Hsitem_ExecDept( ));
}
/// <summary>
/// 获取组合项目明细
/// </summary>
/// <returns></returns>
public static DataTable Get_Complex_Detail()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL( );
base_dal.OleDB = oleDb;
return(base_dal.Get_Complex_Item_Detail( ));
}
/// <summary>
/// 获取医保类型
/// </summary>
/// <returns></returns>
public static DataTable Get_Insur_Type()
{
HIS.DAL.BASE_DAL base_dal = new HIS.DAL.BASE_DAL();
base_dal.OleDB = oleDb;
return(base_dal.Get_Insur_Type( ));
}