package com.gc.impl;

import java.util.*;
import com.gc.action.SmallCategory;

public interface ISmallCategory {
	//按編號查詢
	List<SmallCategory> selectSmallCategoryBySCID(int scid);
	
	//按大類編號查詢
	List<SmallCategory> selectSmallCategoryByCID(int cid);
	
	//查詢所有的信息
	List<SmallCategory> selectAllSmallCategory();
	
	//按用戶選擇的條件查詢
	List<SmallCategory> selectSmallCategoryBySql(String sql);
	
	//查詢表中有多少行數(shù)據(jù)
	int selectCountOfSmallCategory();
	
	//管理小類別信息(增/刪/改)
	boolean OperatorSmallCategory(String sql);
	
	//刪除小類信息
	boolean DeleteSmallCategoryByCID(int scid);
}