package xin.glue.ui.B.B01; import java.sql.CallableStatement; import xin.glue.ui.B.common.SaveModifyHistory; 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; /** * 标准交付条件项目保存(界面ID:UIB010271) * @author 万磊{wanlei} * @date 2016-7-13 */ public class SaveSpecNoQlty extends PosActivity { public String runActivity(PosContext context) { PosGenericDao dao = this.getDao("mesdao"); PosParameter param= null; String INFID = "UIB010273"; //datagrid1 String[] DEV_SPEC_CD = (String[])context.get("DEV_SPEC_CD");//外形尺寸标准号 String[] rowStuts1 = (String[])context.get("rowStuts1");//对应datagrid1 String[] REG_NM = (String[])context.get("REG_NM");//操作人 String[] CHK = (String[])context.get("CHK"); String[] MARK = (String[])context.get("MARK"); int j = 0; if(rowStuts1 != null)//grid2被变更后的操作 { int len = rowStuts1.length; for(int i = 0; i < len; i++) { j = 0; //不允许为空 if("".equals(DEV_SPEC_CD[0]) ) { break;//若为空则直接退出循环 } else if("i".equals(rowStuts1[i])) { param = new PosParameter(); param.setValueParamter(j++, DEV_SPEC_CD[0]); param.setValueParamter(j++, REG_NM[0]); dao.insert("UIB010273_01.INSERT", param); SaveModifyHistory.writeLog(dao, INFID, "I", "UIB010273_01.INSERT", param.getValueParameters(), "", REG_NM[0]); } else if("d".equals(rowStuts1[i])) { param = new PosParameter(); param.setWhereClauseParameter(j++, MARK[i]); dao.delete("UIB010271_02.DELETE", param); SaveModifyHistory.writeLog(dao, INFID, "D", "UIB010270_02.DELETE", param.getWhereClauseParamters(), "", REG_NM[0]); } } } String[]rowStatusD = (String[])context.get("rowStatusD"); if(rowStatusD != null)//针对grid1删除操作 { param = new PosParameter(); param.setWhereClauseParameter(0, DEV_SPEC_CD[0]); dao.update("UIB010273_01.DELETE", param); SaveModifyHistory.writeLog(dao, INFID, "D", "UIB010270_01.DELETE", param.getWhereClauseParamters(), "", REG_NM[0]); } return PosBizControlConstants.SUCCESS; } }