| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677 |
- package xin.glue.ui.J.J01;
- import java.io.ByteArrayOutputStream;
- import java.io.PrintStream;
- import java.sql.CallableStatement;
- import xin.glue.cargocnHttpClient.WayBillClient;
- 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;
- /**
- * 明细发送结束的同时将明细数据保存到货运中国、铁前数据库中去
- * @author KangMiao
- * @Date 2015-5-8 下午04:48:31
- *
- */
- public class resend extends PosActivity {
- public String runActivity(PosContext context) {
-
- //车辆号加入
- String[] TRANS_CAR_NO = (String[]) context.get("TRANS_CAR_NO");
- // 运输指示号
- String[] pDlivDirNo = (String[]) context.get("DLIV_DIRNO");
- // 钢种牌号
- String[] SPEC_STL_GRD = (String[]) context.get("SPEC_STL_GRD");
- // 重量
- String[] COIL_WGT = (String[]) context.get("COIL_WGT");
- // 发货时间
- String[] TRNF_DTIME = (String[]) context.get("TRNF_DTIME");
- // 收货单位
- String[] ORD_NM = (String[]) context.get("ORD_NM");
- // 到站点
- String[] DEST_PCD_DESC = (String[]) context.get("DEST_PCD_DESC");
- // 合同单位
- String[] CUST_NM = (String[]) context.get("CUST_NM");
- // 运输公司
- String[] SHIP_COMP_CD = (String[]) context.get("SHIP_COMP_CD");
- // 运输公司
- String[] SHIP_COMP_NM = (String[]) context.get("SHIP_COMP_NM");
- // 钢卷号
- String[] OLD_SAMPL_NO = (String[]) context.get("OLD_SAMPL_NO");
- // 产品名称
- String[] SM_CFNM = (String[]) context.get("SM_CFNM");
-
- CallableStatement cstm = null;
- try{
- cstm=getDao("mesdao").getCallableStatement("UIJ010060_03.CALL");
- cstm.setString(1, pDlivDirNo[0]);
- cstm.setString(2, "热轧线");
- cstm.setString(3, "");
-
- cstm.execute();
- }
- catch (Exception ex) {
- //System.out.println(pDlivDirNo[i] + "明细数据发送到铁前数据库执行失败UIJ010060_01.CALL**********");
- ByteArrayOutputStream baos = new ByteArrayOutputStream();
- ex.printStackTrace(new PrintStream(baos));
- String exception = baos.toString();
- String errStr = "\n异常原因:" + exception;
- logger.logInfo(pDlivDirNo[0] + "明细数据发送到铁前数据库执行失败UIJ010060_03.CALL;" + errStr);
- //ex.printStackTrace();
- }
- if (cstm != null) {
- try {
- cstm.close();
- } catch (Exception e) {
- }
- }
-
- return PosBizControlConstants.SUCCESS;
- }
- }
|