| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- package xin.glue.ui.B.B01;
- 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:UIB010060}
- * @author 梅贵平{meiguiping}
- * @date 2008-9-23 上午08:46:23
- * @JDK Version jdk1.4.2
- */
- public class SaveModeStlGrdStatus extends PosActivity
- {
- public String runActivity(PosContext context)
- {
- String[] rowStuts = (String[])context.get("rowStuts");//删除计划钢号的信息(对行)
- PosGenericDao dao = this.getDao("mesdao");
- PosParameter param = null;
- String[] STL_GRD = (String[])context.get("STL_GRD");//获得计划钢号
- String[] STL_GRD1 = (String[])context.get("STL_GRD1");//用于更新,无其他作用
- String[] STL_GRD_YN = (String[])context.get("STL_GRD_YN");//区分标准钢号或者厂内钢号,F表厂内钢号,S表标准钢号
-
- int dLength = rowStuts.length;//总记录条数
- int COUNT = 10;//替代钢号共有10种
-
- String[][] MOD_STL_GRD = new String[COUNT][];
- MOD_STL_GRD[0] = (String[])context.get("MOD_STL_GRD1");//获得替代钢号1
- MOD_STL_GRD[1] = (String[])context.get("MOD_STL_GRD2");//获得替代钢号2
- MOD_STL_GRD[2] = (String[])context.get("MOD_STL_GRD3");//获得替代钢号3
- MOD_STL_GRD[3] = (String[])context.get("MOD_STL_GRD4");//获得替代钢号4
- MOD_STL_GRD[4] = (String[])context.get("MOD_STL_GRD5");//获得替代钢号5
- MOD_STL_GRD[5] = (String[])context.get("MOD_STL_GRD6");//获得替代钢号6
- MOD_STL_GRD[6] = (String[])context.get("MOD_STL_GRD7");//获得替代钢号7
- MOD_STL_GRD[7] = (String[])context.get("MOD_STL_GRD8");//获得替代钢号8
- MOD_STL_GRD[8] = (String[])context.get("MOD_STL_GRD9");//获得替代钢号9
- MOD_STL_GRD[9] = (String[])context.get("MOD_STL_GRD10");//获得替代钢号10
- for(int i= 0; i < dLength; i++)//第几个计划钢号
- {
- if("u".equals(rowStuts[i]))//更新替代钢号信息
- {
- if(STL_GRD1 !=null&&!(STL_GRD1.equals(STL_GRD)))
- {
- param = new PosParameter();
- param.setWhereClauseParameter(0, STL_GRD[i]); //更新的计划钢号
- param.setWhereClauseParameter(1, STL_GRD1[i]); //原计划钢号
- dao.update("UIB010060_02.UPDATE", param);
- }
- for(int j=0; j < COUNT; j++)
- {
- param = new PosParameter();
- param.setWhereClauseParameter(0, ( "".equals(MOD_STL_GRD[j][i]) )?" ": MOD_STL_GRD[j][i] );//替代钢号
- param.setWhereClauseParameter(1, STL_GRD[i]); //计划钢号
- param.setWhereClauseParameter(2, new Integer(j+1)); //替代钢号的序号
- int changeCount = dao.update("UIB010060_01.UPDATE", param); //更新替代钢号
- if(changeCount == 0)
- {
- param = new PosParameter();
- param.setValueParamter(0, STL_GRD[i]);
- param.setValueParamter(1, new Integer(j+1));//替代钢号的序号
- param.setValueParamter(2, ( "".equals(MOD_STL_GRD[j][i]) )?" ": MOD_STL_GRD[j][i] );//替代钢号
- param.setValueParamter(3, STL_GRD_YN[0]);
- dao.insert("UIB010060_01.INSERT", param);
- }
- }
- }
- if("d".equals(rowStuts[i]))//删除某计划钢号信息
- {
- param = new PosParameter();
- param.setWhereClauseParameter(0, STL_GRD[i]);
- dao.delete("UIB010060_01.DELETE", param);
- }
- if("i".equals(rowStuts[i]))//增加计划钢号信息
- {
- for(int j=0; j < COUNT; j++)
- {
- param = new PosParameter();
- param.setValueParamter(0, STL_GRD[i]);
- param.setValueParamter(1, new Integer(j+1));//替代钢号的序号
- param.setValueParamter(2, ( "".equals(MOD_STL_GRD[j][i]) )?" ": MOD_STL_GRD[j][i] );//替代钢号
- param.setValueParamter(3, STL_GRD_YN[0]);
- dao.insert("UIB010060_01.INSERT", param);
- }//for end
- }//if "i" end
- }//for rowStuts end
- return PosBizControlConstants.SUCCESS;
- }//runActivity method end
- }
|