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;
	}
}