dbtakeclothessql.java

一个优秀的干洗店管理系统

package dao.common.sql;

public interface DbTakeClothesSql {
	public String SET_ORDER_PAID_OR_NOT = 
		"update oneOrder set paid_or_not = ?,take_or_not = ? where order_id = ?";
	public String REGIST_REWASH = 
		"insert into rewash values(?,to_date(?,'yyyy-mm-dd'),to_date(?,'yyyy-mm-dd'),to_date(?,'yyyy-mm-dd'),?)";
	public String SET_ORDER_NEW_TAKE_DATE = 
		"update oneOrder set out_date_prodicted = to_date(?,'yyyy-mm-dd') where order_id = ?";
	public String REGIST_REFUND_ORDER = 
		"insert into refundment values(?,to_date(?,'yyyy-mm-dd'),?,?,?)";
	
	public static String GET_ORDER_ITEM_BY_ORDERID = 
		"select * from order_item where order_id = ? ";
	public static String GET_ORDER_BY_TAKE_OR_BOT = 
		"select * from oneOrder where take_or_not = ? ";
	public static String GET_CLOTHESTYPE_BY_CLOTHESID =
		"select * from clothes_type where clothes_id = ?";
	public static String GET_OPERATOR = "select * from operator";
	public static String GET_OPERATOR_NAME = "select operator_name from operator";
}