| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 |
- package xin.glue.ui.B.B02;
- import java.sql.CallableStatement;
- 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:UIB020030}
- * @author 梅贵平{meiguiping}
- * @date 2009-1-5 下午09:37:38
- * @JDK Version jdk1.4.2
- */
- public class SaveChargeAchievement extends PosActivity
- {
- public String runActivity(PosContext context)
- {
- ///ready
- PosGenericDao dao = this.getDao("mesdao");
- CallableStatement cstm = null;
- ///获取请求参数
- String[]REG_NM = (String[])context.get("REG_NM");
- String[]CHARGE_NO = (String[])context.get("CHARGE_NO");//炉次号,插入时其作用
- String[]PROC_CD = (String[])context.get("PROC_CD");//成分,插入时其作用
- String[]CHEM_SEQ = (String[])context.get("CHEM_SEQ");//工序,插入时其作用
- String[]CHEM_L2_PROC_CD=(String[])context.get("CHEM_L2_PROC_CD");//L2对应的工序代码
- String[]MOD_RMK = (String[])context.get("MOD_RMK");//备注
-
- //表格2、3、4、5
- String[]rowStuts2 = (String[])context.get("rowStuts2");//对应表格2、3、4、5修改的信息
- String[]CHEM_CD = (String[])context.get("CHEM_CD");//成分代码
- String[]CHEM_VAL = (String[])context.get("CHEM_VAL");//实绩值
-
- String[]rowStuts1 = (String[])context.get("rowStuts1");//针对datagrid1
- String[]rowStatusD = (String[])context.get("rowStatusD");//删除
- try
- {
- if(rowStuts2 != null)
- {
- int len = rowStuts2.length;
- cstm = dao.getCallableStatement("UIB020030_01.CALLSTATEMENT");
- int j = 1;
-
- for(int i = 0; i < len; i++)
- {
- j = 1;
- cstm.setString(j++, CHARGE_NO[0]);
- cstm.setString(j++, PROC_CD[0]);
- cstm.setString(j++, CHEM_SEQ[0]);
- cstm.setString(j++, CHEM_CD[i]);
- cstm.setString(j++, CHEM_VAL[i]);
- cstm.setString(j++, CHEM_L2_PROC_CD[0]);
- cstm.setString(j++, REG_NM[0]);
- cstm.setString(j++, MOD_RMK[0]);//备注
- cstm.setString(j++, Integer.toString(i));
- cstm.registerOutParameter(j++, java.sql.Types.VARCHAR);
- cstm.execute();
- }
- }
- else if(rowStatusD != null)
- {
- cstm = dao.getCallableStatement("UIB020030_02.CALLSTATEMENT");
- cstm.setString(1, CHARGE_NO[0]);
- cstm.setString(2, PROC_CD[0]);
- cstm.setString(3, CHEM_SEQ[0]);
- cstm.registerOutParameter(4, java.sql.Types.VARCHAR);
- cstm.execute();
- }
- else if(rowStuts1 != null)
- {
- // if("u".equals(rowStuts1[0]))
- // {
- // PosParameter param = new PosParameter();
- // param.setWhereClauseParameter(0, CHEM_L2_PROC_CD)
- // }
- }
- }catch(Exception ex)
- {
- ex.printStackTrace();
- }
- finally
- {
- try
- {
- if(cstm != null)
- {
- cstm.close();
- }
- }catch(Exception e)
- {
- e.printStackTrace();
- }
- }
-
-
- return PosBizControlConstants.SUCCESS;
- }
- }
|