| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- package xin.glue.ui.B.common;
- import java.sql.CallableStatement;
- import java.sql.SQLException;
- 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;
- /**
- *
- * @Description 人工判定次品或者正常流转{界面ID:}
- * @author 梅贵平{meiguiping}
- * @date 2009-9-8 下午02:41:40
- * @JDK Version jdk1.4.2
- */
- public class SaveSlabPersonDcs extends PosActivity
- {
- public String runActivity(PosContext context)
- {
- ///ready
- PosGenericDao dao = this.getDao("mesdao");
- CallableStatement cstm= dao.getCallableStatement("UIB030202_05.CALLSTATEMENT");
-
- ///get request data
- String[]DCS_FLAG = (String[])context.get("DCS_FLAG");
- String[]rowStatus = (String[])context.get("rowStatus");
- String[]DCS_DETAIL = (String[])context.get("DCS_DETAIL");
- String[]REG_NM = (String[])context.get("REG_NM");
- String[]SLAB_NO = (String[])context.get("SLAB_NO");
-
- if(rowStatus == null)
- return PosBizControlConstants.SUCCESS;
- int len = rowStatus.length;
-
- try
- {
- for(int i = 0; i < len; i++)
- {
- cstm.setString(1, SLAB_NO[i]);//板坯号
- cstm.setString(2, REG_NM[0]);//操作人
- cstm.setString(3, DCS_FLAG[0]);//为L或者为F,L为正常流转,F为判废
- cstm.setString(4, DCS_DETAIL[0]);//说明(备注)
- cstm.registerOutParameter(5, java.sql.Types.VARCHAR);
- cstm.execute();
- }
- }catch(Exception ex)
- {
- logger.logWarn(ex.getMessage(), ex);
- }
- finally
- {
- if (cstm != null)
- {
- try
- {
- cstm.close();
- }
- catch (SQLException e)
- {
- logger.logWarn(e.getMessage(), e);
- }
- }
- }
- return PosBizControlConstants.SUCCESS;
- }
- }
|