/// <summary>
/// 获取医院还未使用的基本服务项目
/// </summary>
/// <returns></returns>
public DataTable Get_BaseServiceItemWhereNotInUseByHospital()
{
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 tb2 = OleDB.Table(Tables.BASE_HOSPITAL_ITEMS, "", Tables.base_hospital_items.COMPLEX_ID + OleDB.NotEqualTo( ) + "0", Tables.base_hospital_items.ITEM_ID);
string strWhere = Tables.base_service_items.ITEM_ID + OleDB.Not() + " " + OleDB.In() + "(" + tb2 + ")";
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));
}
