package UIE.UIE03;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class UIECOMM extends CoreIComponent {
	public CoreReturnObject getCommCode(String CodeCD){
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		str.append("SELECT T.LG_CD,T.LG_NM,T.SM_CD,T.SM_CFNM 																											\n");
		str.append("FROM TBZ00_COMMCD T                                                                           \n");
		str.append("WHERE T.LG_CD IN (SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(:1) AS TABSTR_T))) \n");
		str.append("UNION ALL                                                                                     \n");
		str.append("SELECT LG_CD,LG_NM,SM_CD,SM_CD SM_CFNM FROM(                                                  \n");
		str.append("        SELECT DISTINCT SPEC_STL_GRD SM_CD,'H_STL_GRD' LG_CD ,'ÈÈÔþÅƺÅ' LG_NM                \n");
		str.append("        FROM TBB01_KEY_PROD                                                                   \n");
		str.append("                                                                                              \n");
		str.append("        ORDER BY SPEC_STL_GRD                                                                 \n");
		str.append(")                                                                                             \n");
		str.append("UNION ALL                                                                                     \n");
		str.append("SELECT LG_CD,LG_NM,SM_CD,SM_CD SM_CFNM FROM(                                                  \n");
		str.append("        SELECT DISTINCT C_SPEC_STL_GRD SM_CD,'C_STL_GRD' LG_CD ,'ÀäÔþÅƺÅ' LG_NM              \n");
		str.append("        FROM TBB01_KEY_PROD                                                                   \n");
		str.append("                                                                                              \n");
		str.append("        ORDER BY C_SPEC_STL_GRD                                                               \n");
		str.append(")                                                                                             \n");
		str.append("UNION ALL                                                                                     \n");
		str.append("SELECT 'CUST_CD' LG_CD,'¿Í»§Ãû³Æ' LG_NM,CUST_CD SM_CD,CUST_NM SM_CFNM                         \n");
		str.append("FROM(                                                                                         \n");
		str.append("SELECT * FROM (                                                                               \n");
		str.append("				SELECT CUST_CD, CUST_NM                                                       \n");
		str.append("				FROM TBZ00_CUSTOMER                                                           \n");
		str.append("				ORDER BY CUST_NM)                                                             \n");
		str.append(")                                                                                             \n");

		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteQuery(sql,new Object[]{CodeCD});
		return cro;
	}
	
	public CoreReturnObject getOrdSeq(String ordNO){
		CoreReturnObject cro=new CoreReturnObject();
		return null;
	}
}