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