| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152 |
- package xin.glue.ui.H.H04;
- import xin.glue.ui.common.PosGridSave;
- //import xin.glue.ui.common.component.PosSiteConfig;
- import xin.glue.ui.common.component.PosSiteLog;
- 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.vo.PosParameter;
- import com.posdata.glue.dao.vo.PosRowSet;
- /*
- * 使用轧辊登录与查询
- * @author TangLiang 唐亮
- * @data 2008.10.17
- */
- public class PosUseRollCancel extends PosActivity{
- public String runActivity(PosContext context)
- {
- // 从页面获取数据供插入和更新使用
- // 引入上部轧辊
- String[] top_roll_no = (String[]) context.get("TOP_ROLL_NO");
- // 引入下部轧辊
- String[] bot_roll_no = (String[]) context.get("BOT_ROLL_NO");
- // 上部传动侧轴承座
- String[] top_drive_chock = (String[]) context.get("TOP_DRIVE_CHOCK");
- // 上部操作侧轴承座
- String[] top_work_chock = (String[]) context.get("TOP_WORK_CHOCK");
- // 下部传动侧轴承座
- String[] bot_drive_chock = (String[]) context.get("BOT_DRIVE_CHOCK");
- // 下部操作侧轴承座
- String[] bot_work_chock = (String[]) context.get("BOT_WORK_CHOCK");
- // 引出上部轧辊
- String[] ext_top_roll_no = (String[]) context.get("EXT_TOP_ROLL_NO");
- // 引出下部轧辊
- String[] ext_bot_roll_no = (String[]) context.get("EXT_BOT_ROLL_NO");
- // 机架号
- String[] stand_no = (String[]) context.get("STAND_NO");
-
- //这里需要处理成对取消和单辊取消的情况,并做出不同的处理
- if(ext_top_roll_no[0].equals("") || ext_top_roll_no[0] == null){
- //引出上部为空,说明换的是下部的单辊
- if(!ext_bot_roll_no[0].equals("")){
- PosParameter param1 = new PosParameter();
- param1.setWhereClauseParameter(0, "U");
- param1.setWhereClauseParameter(1, ext_bot_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_S.update", param1);
-
- if (top_roll_no[0] != null && !top_roll_no[0].equals("")) {
- //更新引入上部轧辊
- PosParameter param2 = new PosParameter();
- param2.setWhereClauseParameter(0, "U");
- param2.setWhereClauseParameter(1, ext_bot_roll_no[0]);
- param2.setWhereClauseParameter(2, top_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_B.update", param2);
- }
- if (bot_roll_no[0] != null && !bot_roll_no[0].equals("")) {
- //更新引入下部轧辊信息,单辊默认为上辊。原来为A
- PosParameter param3 = new PosParameter();
- param3.setWhereClauseParameter(0, "T");
- param3.setWhereClauseParameter(1, "W");
- param3.setWhereClauseParameter(2, bot_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_A.update", param3);
- }
- }else{
- //抛出异常,引出都为空的情况下是不允许替换取消的
- //这里在前台处理
- }
-
-
- }else if(ext_bot_roll_no[0] == null || ext_bot_roll_no[0].equals("")){
- //引出下部为空的情况,说明换的是上部的单辊
- if(!ext_top_roll_no[0].equals("")){
- PosParameter param0 = new PosParameter();
- param0.setWhereClauseParameter(0, "U");
- param0.setWhereClauseParameter(1, ext_top_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_S.update", param0);
-
- if (top_roll_no[0] != null && !top_roll_no[0].equals("")) {
- //更新引入上部轧辊的信息,单辊默认为上辊。原来单辊为A
- PosParameter param2 = new PosParameter();
- param2.setWhereClauseParameter(0, "T");
- param2.setWhereClauseParameter(1, "W");
- param2.setWhereClauseParameter(2, top_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_A.update", param2);
- }
- if (bot_roll_no[0] != null && !bot_roll_no[0].equals("")) {
- //更新引入下部轧辊信息
- PosParameter param3 = new PosParameter();
-
- param3.setWhereClauseParameter(0, "U");
- param3.setWhereClauseParameter(1, ext_top_roll_no[0]);
- param3.setWhereClauseParameter(2, bot_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_B.update", param3);
-
- }
- }else{
- //抛出异常,引出都为空的情况下是不允许替换取消的
- //这里在前台处理
- }
- }else{
- //处理对辊的情况
- if(ext_top_roll_no[0] != null && !ext_top_roll_no[0].equals("") ){
- //如果存在的话就更新引出上部轧辊的标识,把roll_stat设置为S
- PosParameter param0 = new PosParameter();
- param0.setWhereClauseParameter(0, "U");
- param0.setWhereClauseParameter(1, ext_top_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_S.update", param0);
- }
- if(ext_bot_roll_no[0] != null && !ext_bot_roll_no[0].equals("") ){
- PosParameter param1 = new PosParameter();
- param1.setWhereClauseParameter(0, "U");
- param1.setWhereClauseParameter(1, ext_bot_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_S.update", param1);
- }
-
- if (top_roll_no[0] != null && !top_roll_no[0].equals("")) {
-
- //更新引入上部轧辊的信息
- PosParameter param2 = new PosParameter();
- param2.setWhereClauseParameter(0, "W");
- param2.setWhereClauseParameter(1, top_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_U.update", param2);
- }
-
- if (bot_roll_no[0] != null && !bot_roll_no[0].equals("")) {
-
- //更新引入下部轧辊信息
- PosParameter param3 = new PosParameter();
-
- param3.setWhereClauseParameter(0, "W");
- param3.setWhereClauseParameter(1, bot_roll_no[0]);
-
- getDao("mesdao").update("UIH040030_CANCEL_U.update", param3);
-
- }
- }
- return PosBizControlConstants.SUCCESS;
- }
- }
|