| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165 |
- package xin.glue.ui.B.B01;
- import xin.glue.ui.B.common.SaveModifyHistory;
- 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.PosGenericDao;
- import com.posdata.glue.dao.vo.PosParameter;
- public class SaveHCSizeMap extends PosActivity
- {
- private PosGenericDao dao = this.getDao("mesdao");
- String INFID = "UIB010322";
- public String runActivity(PosContext context)
- {
-
- String[] SIZE_SPEC_CD = (String[])context.get("SIZE_SPEC_CD");
- String[] SIZE_RMK = (String[])context.get("SIZE_RMK");
-
- String[] T_CHK = (String[])context.get("T_CHK");
- String[] C_THK_MIN = (String[])context.get("C_THK_MIN");
- String[] C_THK_MAX = (String[])context.get("C_THK_MAX");
- String[] T_TOL_MIN = (String[])context.get("T_TOL_MIN");
- String[] T_TOL_MAX = (String[])context.get("T_TOL_MAX");
- String[] H_THK_AIM = (String[])context.get("H_THK_AIM");
- String[] C_THK_MIN1 = (String[])context.get("C_THK_MIN1");
- String[] C_THK_MAX1 = (String[])context.get("C_THK_MAX1");
-
- String[] W_CHK = (String[])context.get("W_CHK");
- String[] C_WTH_MIN = (String[])context.get("C_WTH_MIN");
- String[] C_WTH_MAX = (String[])context.get("C_WTH_MAX");
- String[] W_TOL_MIN = (String[])context.get("W_TOL_MIN");
- String[] W_TOL_MAX = (String[])context.get("W_TOL_MAX");
- String[] H_WTH_AIM = (String[])context.get("H_WTH_AIM");
- String[] C_WTH_MIN1 = (String[])context.get("C_WTH_MIN1");
- String[] C_WTH_MAX1 = (String[])context.get("C_WTH_MAX1");
-
- String[] rowStatus1 = (String[])context.get("rowStatus1");
- String[] rowStatus2 = (String[])context.get("rowStatus2");
- String[] rowStatus3 = (String[])context.get("rowStatus3");
-
- String[] REG_NM = (String[])context.get("REG_NM");
-
-
- PosParameter param = null;
-
- if(rowStatus1 != null)
- {
- param = new PosParameter();
- param.setWhereClauseParameter(0, SIZE_SPEC_CD[0]);
- dao.delete("UIB010322_02.DELETE", param);
- SaveModifyHistory.writeLog(dao, INFID, "D", "UIB010322_02.DELETE", param.getValueParameters(), "", REG_NM[0]);
- }
- //
- //ºñ¶È
- if(rowStatus2 != null)
- {
- param = new PosParameter();
- int len = rowStatus2.length;
- int j = 0;
- for(int i = 0 ; i< len ; i++)
- {
- j = 0;
- param = new PosParameter();
-
- if("i".equals(rowStatus2[i])&& "Y".equals(T_CHK[i]))
- {
- param.setValueParamter(j++, SIZE_SPEC_CD[0]);
- param.setValueParamter(j++, C_THK_MIN[i]);
- param.setValueParamter(j++, C_THK_MAX[i]);
- param.setValueParamter(j++, H_THK_AIM[i]);
- param.setValueParamter(j++, T_TOL_MIN[i]);
- param.setValueParamter(j++, T_TOL_MAX[i]);
- param.setValueParamter(j++, SIZE_RMK[0]);
- param.setValueParamter(j++, REG_NM[0]);
- dao.insert("UIB010322_THK_01.INSERT", param);
- SaveModifyHistory.writeLog(dao, INFID, "I", "UIB010322_THK_01.INSERT", param.getValueParameters(), "", REG_NM[0]);
- }
- else if("u".equals(rowStatus2[i])&& "Y".equals(T_CHK[i]))
- {
- param.setWhereClauseParameter(j++, C_THK_MIN[i]);
- param.setWhereClauseParameter(j++, C_THK_MAX[i]);
- param.setWhereClauseParameter(j++, H_THK_AIM[i]);
- param.setWhereClauseParameter(j++, T_TOL_MIN[i]);
- param.setWhereClauseParameter(j++, T_TOL_MAX[i]);
- param.setWhereClauseParameter(j++, SIZE_RMK[0]);
- param.setWhereClauseParameter(j++, REG_NM[0]);
- param.setWhereClauseParameter(j++, SIZE_SPEC_CD[0]);
- param.setWhereClauseParameter(j++, C_THK_MIN1[i]);
- param.setWhereClauseParameter(j++, C_THK_MAX1[i]);
- dao.update("UIB010322_THK_01.UPDATE", param);
- SaveModifyHistory.writeLog(dao, INFID, "U", "UIB010322_THK_01.UPDATE", param.getValueParameters(), "", REG_NM[0]);
- }
- else if("d".equals(rowStatus2[i])&& "Y".equals(T_CHK[i]))
- {
- param.setWhereClauseParameter(j++, SIZE_SPEC_CD[0]);
- param.setWhereClauseParameter(j++, "THK");
- param.setWhereClauseParameter(j++, C_THK_MIN[i]);
- param.setWhereClauseParameter(j++, C_THK_MAX[i]);
- param.setWhereClauseParameter(j++, "0");
- param.setWhereClauseParameter(j++, "0");
- dao.delete("UIB010322_01.DELETE" , param);
- SaveModifyHistory.writeLog(dao, INFID, "D", "UIB010322_01.DELETE", param.getValueParameters(), "", REG_NM[0]);
- }
- }
- }
-
- //¿í¶È
- if(rowStatus3 != null)
- {
- param = new PosParameter();
- int len = rowStatus3.length;
- int j = 0;
- for(int i = 0 ; i< len ; i++)
- {
- j = 0;
- param = new PosParameter();
- if("i".equals(rowStatus3[i])&& "Y".equals(W_CHK[i]))
- {
- param.setValueParamter(j++, SIZE_SPEC_CD[0]);
- param.setValueParamter(j++, "WTH");
- param.setValueParamter(j++, "0");
- param.setValueParamter(j++, "0");
- param.setValueParamter(j++, C_WTH_MIN[i]);
- param.setValueParamter(j++, C_WTH_MAX[i]);
- param.setValueParamter(j++, H_WTH_AIM[i]);
- param.setValueParamter(j++, W_TOL_MIN[i]);
- param.setValueParamter(j++, W_TOL_MAX[i]);
- param.setValueParamter(j++, SIZE_RMK[0]);
- param.setValueParamter(j++, REG_NM[0]);
- dao.insert("UIB010322_WTH_01.INSERT", param);
- SaveModifyHistory.writeLog(dao, INFID, "I", "UIB010322_WTH_01.INSERT", param.getValueParameters(), "", REG_NM[0]);
- }
- else if("u".equals(rowStatus3[i])&& "Y".equals(W_CHK[i]))
- {
- param.setWhereClauseParameter(j++, C_WTH_MIN[i]);
- param.setWhereClauseParameter(j++, C_WTH_MAX[i]);
- param.setWhereClauseParameter(j++, H_WTH_AIM[i]);
- param.setWhereClauseParameter(j++, W_TOL_MIN[i]);
- param.setWhereClauseParameter(j++, W_TOL_MAX[i]);
- param.setWhereClauseParameter(j++, SIZE_RMK[0]);
- param.setWhereClauseParameter(j++, REG_NM[0]);
- param.setWhereClauseParameter(j++, SIZE_SPEC_CD[0]);
- param.setWhereClauseParameter(j++, C_WTH_MIN1[i]);
- param.setWhereClauseParameter(j++, C_WTH_MAX1[i]);
- dao.update("UIB010322_WTH_01.UPDATE", param);
- SaveModifyHistory.writeLog(dao, INFID, "U", "UIB010322_WTH_01.UPDATE", param.getValueParameters(), "", REG_NM[0]);
- }
- else if("d".equals(rowStatus3[i])&& "Y".equals(W_CHK[i]))
- {
- param.setWhereClauseParameter(j++, SIZE_SPEC_CD[0]);
- param.setWhereClauseParameter(j++, "WTH");
- param.setWhereClauseParameter(j++, C_WTH_MIN[i]);
- param.setWhereClauseParameter(j++, C_WTH_MAX[i]);
- param.setWhereClauseParameter(j++, "0");
- param.setWhereClauseParameter(j++, "0");
- dao.delete("UIB010322_01.DELETE" , param);
- SaveModifyHistory.writeLog(dao, INFID, "D", "UIB010322_01.DELETE", param.getValueParameters(), "", REG_NM[0]);
- }
- }
- }
- return PosBizControlConstants.SUCCESS;
- }
- }
|