/// <summary> /// 得到基本医疗服务项目 /// </summary> /// <returns></returns> public System.Data.DataTable get_Base_Service_Items() { //return GetDataTable( "select a.*,b.item_name as statitem_name from base_service_items a left join base_stat_item b on a.statitem_code =b.code order by item_id" ); string tb = OleDB.TableNameBM(Tables.BASE_SERVICE_ITEMS, "a") + OleDB.LeftJoin() + OleDB.TableNameBM(Tables.BASE_STAT_ITEM, "b") + OleDB.ON("a." + Tables.base_service_items.STATITEM_CODE, "b." + Tables.base_stat_item.CODE); string strsql = OleDB.Table(tb, "", "", Tables.base_service_items.ITEM_ID, Tables.base_service_items.ITEM_CODE, OleDB.FiledNameBM("a." + Tables.base_service_items.ITEM_NAME, "ITEM_NAME"), Tables.base_service_items.ITEM_UNIT, Tables.base_service_items.PRICE, OleDB.FiledNameBM("a." + Tables.base_service_items.PY_CODE, "PY_CODE"), Tables.base_service_items.STATITEM_CODE, Tables.base_service_items.STD_CODE, Tables.base_service_items.VALID_FLAG, OleDB.FiledNameBM("a." + Tables.base_service_items.WB_CODE, "WB_CODE"), OleDB.FiledNameBM("b." + Tables.base_stat_item.ITEM_NAME, "statitem_name")); strsql += OleDB.OrderBy() + Tables.base_service_items.ITEM_ID; return(GetDataTable(strsql)); }