package xin.glue.ui.T.T01;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.PosJdbcDao;
import com.posdata.glue.dao.vo.PosParameter;

public class DeleteL2CoilComm extends PosActivity {

	public String runActivity(PosContext context) {

		logger.logInfo("    =========================================================================================  ");
		logger.logInfo("    Add new DAO definition. please...(applicationContext.xml)                                  ");
		logger.logInfo("    =========================================================================================  ");
		logger.logInfo("    ~ ... ~                                                                                    ");
		logger.logInfo("    <bean id=\"ds-0\" class=\"org.springframework.jndi.JndiObjectFactoryBean\">                ");
		logger.logInfo("        <property name=\"jndiName\" value=\"jdbc/Xg3QLocalDB\"/>                               ");
		logger.logInfo("        <property name=\"resourceRef\" value=\"true\"/>                                        ");
		logger.logInfo("    </bean>                                                                                    ");
		logger.logInfo("    <bean id=\"xetdao\" class=\"com.posdata.glue.dao.PosJdbcDao\">                             ");
		logger.logInfo("        <property name=\"dataSource\"><ref local=\"ds-0\"/></property>                         ");
		logger.logInfo("        <property name=\"queryManager\"><ref local=\"queryManager\"/></property>               ");
		logger.logInfo("    </bean>                                                                                    ");
		logger.logInfo("    <bean id=\"tx0\" class=\"com.posdata.glue.transaction.PosDataSourceTransactionManager\">   ");
		logger.logInfo("        <property name=\"dataSource\"><ref local=\"ds-0\"/>                                    ");
		logger.logInfo("    </property>                                                                                ");
		logger.logInfo("    </bean>                                                                                    ");
		logger.logInfo("                                                                                               ");
		logger.logInfo("                                                                                               ");
		logger.logInfo("    <bean id=\"ds-1\" class=\"org.springframework.jndi.JndiObjectFactoryBean\">                ");
		logger.logInfo("        <property name=\"jndiName\" value=\"jdbc/Xg3QTestDB\"/>                                ");
		logger.logInfo("        <property name=\"resourceRef\" value=\"true\"/>                                        ");
		logger.logInfo("    </bean>                                                                                    ");
		logger.logInfo("    <bean id=\"mesdao\" class=\"com.posdata.glue.dao.PosJdbcDao\">                             ");
		logger.logInfo("        <property name=\"dataSource\"><ref local=\"ds-1\"/></property>                         ");
		logger.logInfo("        <property name=\"queryManager\"><ref local=\"queryManager\"/></property>               ");
		logger.logInfo("    </bean>                                                                                    ");
		logger.logInfo("    <bean id=\"tx1\" class=\"com.posdata.glue.transaction.PosDataSourceTransactionManager\">   ");
		logger.logInfo("        <property name=\"dataSource\"><ref local=\"ds-1\"/>                                    ");
		logger.logInfo("    </property>                                                                                ");
		logger.logInfo("    </bean>                                                                                    ");
		logger.logInfo("    ~ ... ~                                                                                    ");
		logger.logInfo("    =========================================================================================  ");

		String[]	sDb_CoilNo	=	(String[])context.get("CoilNo");
		
		PosJdbcDao		dao		=  (PosJdbcDao)getDao("xetdao");
		String			sQuery	=	dao.getQueryManager().getQueryDefinition("SyncL2WithL3.DeleteL2CoilComm.Delete").getQueryStatement();
		StringBuffer 	sbQuery	=	new StringBuffer(sQuery);

		int			iCnt		= 	0;
		if(sDb_CoilNo != null)
			iCnt	=	sDb_CoilNo.length;

		PosParameter	param	= new PosParameter();
		if(iCnt > 0) {
			sbQuery.append("\n").append("AND A.COIL_NO LIKE '").append(sDb_CoilNo[0]).append("%'");
		}

		logger.logInfo(sbQuery.toString());
 		int		iRows	=	dao.deleteByQueryStatement(sbQuery.toString(), param);
		logger.logInfo(iRows + " deleted.");

		return PosBizControlConstants.SUCCESS;
	}

}