XinYu_RZMES/.svn/pristine/2e/2e53d3cef19b3861b5e261ad2e00de5b63330da5.svn-base

package xin.glue.ui.D.D02;

import java.math.BigDecimal;
import java.util.HashMap;
import java.util.Map;

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.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;

/**
 * 짱늴슬늴�뇜묘콘
 * @author 珙잭
 * @date 2009-2-6
 */
public class DeleteMatDnRst extends PosActivity
{

	public String runActivity(PosContext context)
	{
		String[]    MAT_SPEC_SEQ       =    (String[])context.get("MAT_SPEC_SEQ"    ) ; //MAT_SPEC_SEQ        재료사양일련번호
		String[]    PMAT_SPEC_SEQ      =    (String[])context.get("PMAT_SPEC_SEQ"   ) ; //PMAT_SPEC_SEQ       모재료사양일련번호
		//String[]    MAT_TP           =    (String[])context.get("MAT_TP"          ) ;
		//뎠품짱늴苟돨杰唐겼툰홍꼬�뇜빈疼路劤꿨흙
		//if(PMAT_SPEC_SEQ!=null && "03".equals(MAT_TP[0]))
		//{
		//	String sql2 = "DELETE FROM TBD01_MATDN_RST WHERE PMAT_SPEC_SEQ = '"+PMAT_SPEC_SEQ[0]+"'";
		//	getDao("mesdao").deleteByQueryStatement(sql2);
		//}

		//String[] WITHIN_SUB_SEQ        =    (String[])context.get("WITHIN_SUB_SEQ"  ) ;
		
		String[]    DSN_SLAB_NO        =    (String[])context.get("DSN_SLAB_NO"     ) ; //DSN_SLAB_NO         겼툰뵀
		/*String[]    P_DSN_SLAB_NO      =    (String[])context.get("P_DSN_SLAB_NO"   ) ; //P_DSN_SLAB_NO       莉북겼툰뵀ORD_NO
		String[]    ORD_NO             =    (String[])context.get("ORD_NO"          ) ;
		String[]    ORD_SEQ            =    (String[])context.get("ORD_SEQ"         ) ;
		String[]    SLAB_THK           =    (String[])context.get("MAT_THK"         ) ;
		String[]    SLAB_WTH           =    (String[])context.get("MAT_WTH"         ) ;
		String[]    SLAB_LEN           =    (String[])context.get("MAT_LEN"         ) ;
		String[]    SLAB_WGT           =    (String[])context.get("MAT_WGT"         ) ;
		String[]    SLAB_TRMTH_TP      =    (String[])context.get("SCARPING_PROC_YN") ;
		String[]    FAC_STL_GRD        =    (String[])context.get("FAC_STL_GRD"     ) ;
		String[]    COIL_THK           =    (String[])context.get("COIL_THK"        ) ;
		String[]    COIL_WTH           =    (String[])context.get("COIL_WTH"        ) ;
		String[]    COIL_LEN           =    (String[])context.get("COIL_LEN"        ) ;
		String[]    COIL_WGT           =    (String[])context.get("COIL_WGT"        ) ;
		String[]    PROC_PATH          =    (String[])context.get("PATH_PROC_CD"    ) ;
		String[]    HCR_YN             =    (String[])context.get("HCR_YN"          ) ;
		String[]    EMGMTR_YN          =    (String[])context.get("EMGMTR_YN"       ) ;
		String[]    FAC_STL_GRP        =    (String[])context.get("FAC_STL_GRP"     ) ;
		String[]    COMB_YN            =    (String[])context.get("COMB_YN"         ) ;
		String[]    ORD_FL             =    (String[])context.get("ORD_FL"          ) ;
    	String[]    CHK            =    (String[])context.get("CHK"   ) ;
		String[]    sDb_ExpMatNo            =    (String[])context.get("EXP_MAT_NO"      ) ; //EXP_MAT_NO          예정재료번호(예정CAST번호,예정CHARGE번호,예정SLAB번호)
		String[]    sDb_CmatCnt             =    (String[])context.get("CMAT_CNT"        ) ; //CMAT_CNT            자재료개수
		String[]    sDb_MatRt               =    (String[])context.get("MAT_RT"          ) ; //MAT_RT              재료행선(H:열연 P:후판)
		String[]    sDb_TreatRtCd           =    (String[])context.get("TREAT_RT_CD"     ) ; //TREAT_RT_CD         처리경로코드
		String[]    sDb_LineProcCd          =    (String[])context.get("LINE_PROC_CD"    ) ; //LINE_PROC_CD        제강통과공정라인
		String[]    sDb_MatLenMin           =    (String[])context.get("MAT_LEN_MIN"     ) ; //MAT_LEN_MIN         재료길이<최소>
		String[]    sDb_MatLenMax           =    (String[])context.get("MAT_LEN_MAX"     ) ; //MAT_LEN_MAX         재료길이<최대>
		String[]    sDb_CcmTermTime         =    (String[])context.get("CCM_TERM_TIME"   ) ; //CCM_TERM_TIME       주조시간(주조시간 = 예정주조완료일시 - 예정주조개시일시:분단위)
		String[]    sDb_WidChgFl            =    (String[])context.get("WID_CHG_FL"      ) ; //WID_CHG_FL          폭변경여부(Y/N Default:N)
		String[]    sDb_SmsDuedate          =    (String[])context.get("SMS_DUEDATE"     ) ; //SMS_DUEDATE         제강기한일(YYYYMMDD)
		String[]    sDb_PrcLine             =    (String[])context.get("PRC_LINE"        ) ; //PRC_LINE            전로호기
		String[]    sDb_CcmPrcLine          =    (String[])context.get("CCM_PRC_LINE"    ) ; //CCM_PRC_LINE        연주기번호
		String[]    sDb_ProgCd              =    (String[])context.get("PROG_CD"         ) ; //PROG_CD             진도코드(재료구분=01이면 JBA:BOF작업지시대기로 설정, 나머진 NULL)
		String[]    sDb_SlabCutSeq          =    (String[])context.get("SLAB_CUT_SEQ"    ) ; //SLAB_CUT_SEQ        SLAB전단순서
		String[]    sDb_DsgRate             =    (String[])context.get("DSG_RATE"        ) ; //DSG_RATE            설계실수율
		String[]    sDb_OverRollYn          =    (String[])context.get("OVER_ROLL_YN"    ) ; //OVER_ROLL_YN        OVERROLL여부(Y/N)
		String[]    sDb_SampleCut           =    (String[])context.get("SAMPLE_CUT"      ) ; //SAMPLE_CUT          SLABSAMPLE여부(Y/N)
		String[]    sDb_OrdFl               =    (String[])context.get("ORD_FL"          ) ; //ORD_FL              주여구분(1:주문재 2:여재)
		String[]    sDb_DelvReqDate         =    (String[])context.get("DELV_REQ_DATE"   ) ; //DELV_REQ_DATE       납기일자(YYYYMMDD)
		String[]    sDb_SpmProcYn           =    (String[])context.get("SPM_PROC_YN"     ) ; //SPM_PROC_YN         SKINPASS지정유무(Y/N)
		String[]    sDb_SendSts             =    (String[])context.get("SEND_STS"        ) ; //SEND_STS            전송상태(01:지시대기 02:전송대기 03:전송완료)
		*/
		PosParameter param = null;
		PosRowSet rowSet = null;
		if(MAT_SPEC_SEQ!=null)
		{
			int	iRows	=	MAT_SPEC_SEQ.length;
	
			//int j = 1;
			PosRow row = null;
			Map map = new HashMap();
			String matSpecSeq = "";
			BigDecimal rnum = null;
			for(int i = 0; i < iRows; i++) 
			{
				param = new PosParameter();
					/*param.setValueParamter(  0, DSN_SLAB_NO[i]     );
					param.setValueParamter(  1, P_DSN_SLAB_NO[i]   );
					param.setValueParamter(  2, ORD_NO[i]          );
					param.setValueParamter(  3, ORD_SEQ[i]         );
					param.setValueParamter(  4, SLAB_THK[i]        );
					param.setValueParamter(  5, SLAB_WTH[i]        );
					param.setValueParamter(  6, SLAB_LEN[i]        );
					param.setValueParamter(  7, SLAB_WGT[i]   	   );
					param.setValueParamter(  8, SLAB_TRMTH_TP[i]   );//---SLAB_TRMTH_TP
					param.setValueParamter(  9, "7.85"             );//---GRAVITY
					param.setValueParamter(  10, "N"               );//---AUTODSN_YN
					param.setValueParamter(  11, ""                );//---COIL_PACK_WGT_MIN
					param.setValueParamter(  12, ""                );//---COIL_PACK_WGT_MAX
					param.setValueParamter(  13, FAC_STL_GRD[i]    );
					param.setValueParamter(  14, COIL_THK[i]       );
					param.setValueParamter(  15, COIL_WTH[i]       );
					param.setValueParamter(  16, COIL_LEN[i]       );
					param.setValueParamter(  17, COIL_WGT[i]       );
					param.setValueParamter(  18, PROC_PATH[i]      );
					param.setValueParamter(  19, HCR_YN[i]         );
					param.setValueParamter(  20, EMGMTR_YN[i]      );
					param.setValueParamter(  21, FAC_STL_GRP[i]    );
					param.setValueParamter(  22, COMB_YN[i]        );
					param.setValueParamter(  23, "0"               );//---COIL_INDIA
					param.setValueParamter(  24, "0"               );///--COIL_OUTDIA*/
					
					//邱털뙤깊櫓角뤠닸瞳맡寮숩돨係션쩌，흔벎닸瞳，橙怜痰뫘劤앎옵鹿，흔벎꼇닸瞳，橙矜路劤꿨흙
					String sql = "SELECT DSN_SLAB_NO FROM TBD01_SLABDN_RST WHERE DSN_SLAB_NO='"+DSN_SLAB_NO[i] +"'";
					rowSet = getDao("mesdao").findByQueryStatement(sql);
		
					//String sql2 = "DELETE FROM TBD01_MATDN_RST WHERE MAT_SPEC_SEQ = '"+MAT_SPEC_SEQ[i]+"'";
					if(rowSet.hasNext())
					{
						continue;
					}
					else
					{
						param.setValueParamter(  0, MAT_SPEC_SEQ[i] );
						getDao("mesdao").insert("UID020020.DeleteMatDnRst.Row.Insert", param);
						
						param = new PosParameter(); 
						param.setWhereClauseParameter(0, MAT_SPEC_SEQ[i]);
						rowSet = getDao("mesdao").find("UID020020.DeleteMatDnRst.Row.Select", param);
						
						while(rowSet.hasNext())
						{
							param = new PosParameter();
							row = rowSet.next();
							map = row.getAttributes();
							matSpecSeq = (String)map.get("MAT_SPEC_SEQ");
							param.setWhereClauseParameter(0, matSpecSeq);
							getDao("mesdao").delete("UID020020.DeleteMatDnRst.Row.Delete", param);
						}
						
						param = new PosParameter();
						param.setWhereClauseParameter(  0, PMAT_SPEC_SEQ[i] );
						rowSet = getDao("mesdao").find("UID020020.UpdateMatDnRst.Row.Select", param);
						while(rowSet.hasNext())
						{
							param = new PosParameter();
							row = rowSet.next();
							map = row.getAttributes();
							matSpecSeq = (String)map.get("MAT_SPEC_SEQ");
							rnum = (BigDecimal)map.get("RNUM");
							
							param.setValueParamter(0, rnum);
							param.setValueParamter(1, matSpecSeq);
							getDao("mesdao").update("UID020020.UpdateMatDnRst.Row.Update", param);
						}
					}
				//}
			}
			
			/*String sql3 = "SELECT COUNT(MAT_SPEC_SEQ) AS COUNT FROM TBD01_MATDN_RST WHERE PMAT_SPEC_SEQ = '"+PMAT_SPEC_SEQ[1]+"'";
			rowSet = getDao("mesdao").findByQueryStatement(sql3);
			PosRow row = null;
			Map map = new HashMap();
			String count = "";
			while(rowSet.hasNext())
			{
				row = rowSet.next();
				map = row.getAttributes();
				count = (String)map.get("COUNT");
			}
			for(int i = 1; i <= Integer.valueOf(count).intValue(); i++)
			{
				
			}*/
		}
		return PosBizControlConstants.SUCCESS;
	}
}