Beispiel #1
0
        private void GetDmDs()
        {
            ArrayList alTab_Dm = new ArrayList();                                                                                                                                                                 //代码表名称
            ArrayList alSql_Dm = new ArrayList();                                                                                                                                                                 //代码sql

            alTab_Dm.Add("PATH_DM"); alSql_Dm.Add("select * from PATH_DM where VALID in (1,2) order by KIND,SORT");                                                                                               //路径
            alTab_Dm.Add("JC_DISEASE"); alSql_Dm.Add("select id , CODING as code,isnull(CODING,'') + '(' + isnull(name,'') +')' name,PY_CODE,WB_CODE,CODING,name DISEASE_NAME  from JC_DISEASE where YBJKLX =0"); //诊断
            dsDM = DbOpt.GetDataSet(alSql_Dm, alTab_Dm);
        }