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