XinYu_RZMES/.svn/pristine/65/65b117888965432034a9c5b0ae62b08e7542d303.svn-base

package xin.glue.ui.B.B02.O1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import xin.glue.ui.B.B02.MutilConditionFind;

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

public class SaveCoilThkChanged extends PosActivity
{

	public String runActivity(PosContext context)
	{
		///reqData
		String[] SMP_NO	=	(String[])context.get("SMP_NO");
		
		///
		PosGenericDao	dao	=	this.getDao("mesdao");
		PosParameter	param	=	new PosParameter();
		param.setWhereClauseParameter(0, SMP_NO[0]);
		PosRowSet	rowset	=	 dao.find("UIB020111_02.SELECT", param);
		//SELECT * FROM TBB02_LOT_COM T WHERE T.SMP_NO = ? AND ( T.SMP_PROG_CD = 'B' OR T.SMP_PROG_CD = 'C')
		if(rowset.count() == 0)//如果查询出来的数据大于0，则可以进行操作，否则不允许操作
			return PosBizControlConstants.SUCCESS;
		
		//SELECT T.DCS_THK FROM TBH02_COIL_COMM T WHERE T.SAMPL_NO = '' AND T.SAMPL_PICK_YN    = 'Y' AND T.SMP_DIR_PIC_YN = 'Y'
		param	=	new PosParameter();
		param.setWhereClauseParameter(0, SMP_NO[0]);
		PosRowSet	rowset1	= dao.find("UIB020111_03.SELECT", param);
		
		String	dcsThk	=	"";
		if(rowset1.hasNext())
		{
			PosRow	row	=	rowset1.next();
			dcsThk		=	row.getAttribute("DCS_THK").toString();
		}
		
		if("".equals(dcsThk))//若没有判定规格则直接返回
		{
			return PosBizControlConstants.SUCCESS;
		}
		
		//update  tbb02_lot_coil
		param	=	new PosParameter();
		param.setWhereClauseParameter(0, dcsThk);
		param.setWhereClauseParameter(1, SMP_NO[0]);
		dao.update("UIB020111_04.UPDATE", param);
		
		///修改检化验数据
		Connection  con	=	null;
		PreparedStatement	pstm	=	null;
		try
		{
			String	driverClassName	=	"oracle.jdbc.driver.OracleDriver";
			Class.forName(driverClassName);
			
			String url =  "jdbc:oracle:thin:@10.10.0.8:1521:SQMESDB";  //正式
			String	userName	=	"JHYUSER";
			String	userPsw		=	"JHYUSER";
			con	=	DriverManager.getConnection(url , userName , userPsw);
//			System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"+con);
			MutilConditionFind mcf	=	new MutilConditionFind();
			
			String	sql	=	mcf.getQuerySql("UIB020111_02.UPDATE").toString();
			pstm	=	con.prepareStatement(sql);
			pstm.setString(1, dcsThk);
			pstm.setString(2, SMP_NO[0]);
			pstm.execute();
			
			sql	=	mcf.getQuerySql("UIB020111_03.UPDATE").toString();
			pstm	=	con.prepareStatement(sql);
			pstm.setString(1, dcsThk);
			pstm.setString(2, SMP_NO[0]);
			pstm.execute();
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
		finally
		{
			try
			{
				if(pstm != null)  pstm.close();
				if(con != null)	  con.close();
			}catch(Exception e)
			{
				e.printStackTrace();
			}
		}
		return PosBizControlConstants.SUCCESS;
	}

}