U8Cloud 插件到货单

package nc.bs.rc.receive; import java.math.BigDecimal; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Types; import java.util.ArrayList; import java.util.Date; import java.util.Enumeration; import java.util.HashMap; import java.util.Hashtable; import java.util.Iterator; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; import java.util.Vector; import javax.naming.NamingException; import nc.bs.framework.common.NCLocator; import nc.bs.ml.NCLangResOnserver; import nc.bs.po.OrderDMO; import nc.bs.pu.pub.BsPuTool; import nc.bs.pu.pub.PubDMO; import nc.bs.pu.pub.PubImpl; import nc.bs.pub.DataManageObject; import nc.bs.pub.SystemException; import nc.bs.pub.para.SysInitDMO; import nc.bs.pub.pf.IBackCheckState; import nc.bs.pub.pf.ICheckState; import nc.bs.pub.pf.IQueryData; import nc.bs.pub.pf.IQueryData2; import nc.bs.scm.pub.TempTableDMO; import nc.bs.scm.pub.ctrl.ControlScParamUtil; import nc.hr.utils.PubEnv; import nc.itf.ic.service.IICToPU_StoreadminDMO; import nc.itf.po.IOrder; import nc.itf.pu.inter.IPuToQc_ArriveorderDMO; import nc.itf.pu.pub.fw.LockTool; import nc.itf.scm.cenpur.service.TempTableUtil; import nc.itf.uap.sf.ICreateCorpQueryService; import nc.jdbc.framework.crossdb.CrossDBResultSet; import nc.vo.pf.change.IChangeVOCheck; import nc.vo.po.pub.Operlog; import nc.vo.pub.AggregatedValueObject; import nc.vo.pub.BusinessException; import nc.vo.pub.CircularlyAccessibleValueObject; import nc.vo.pub.VOStatus; import nc.vo.pub.lang.UFBoolean; import nc.vo.pub.lang.UFDate; import nc.vo.pub.lang.UFDateTime; import nc.vo.pub.lang.UFDouble; import nc.vo.pub.para.SysInitVO; import nc.vo.pub.pf.IPFSourceBillFinder; import nc.vo.pub.pf.SourceBillInfo; import nc.vo.rc.receive.ArriveorderBbVO; import nc.vo.rc.receive.ArriveorderHeaderVO; import nc.vo.rc.receive.ArriveorderItemVO; import nc.vo.rc.receive.ArriveorderVO; import nc.vo.rc.receive.CheckRsltItemVO; import nc.vo.rc.receive.IArriveorderStatus; import nc.vo.scm.cenpur.service.ChgPriceMnyVO; import nc.vo.scm.constant.ScmConst; import nc.vo.scm.pu.BillStatus; import nc.vo.scm.pu.BillTypeConst; import nc.vo.scm.pu.PuPubVO; import nc.vo.scm.pu.VariableConst; import nc.vo.scm.pub.CustomerConfigVO; import nc.vo.scm.pub.SCMEnv; import nc.vo.scm.pub.TempTableVO; import nc.vo.scm.pub.excp.RwtIcToPoException; import nc.vo.scm.qc.pub.QcresultVO; import org.apache.commons.lang.StringUtils; /** * Arriveorder的DMO类。 * * 创建日期：(2001-6-8) * * @author：晁志平 */ public class ArriveorderDMO extends DataManageObject implements IQueryData, ICheckState, IQueryData2, IPuToQc_ArriveorderDMO,// 到货单提供给质检单的回写服务接口 IBackCheckState, IPFSourceBillFinder, IChangeVOCheck// v51:加入到货推式生成入库时的业务约束检查 { /** * ArriveorderDMO 构造子注解。 * * @exception javax.naming.NamingException * 父类构造子抛出的异常。 * @exception nc.bs.pub.SystemException * 父类构造子抛出的异常。 */ public ArriveorderDMO() throws javax.naming.NamingException, SystemException { super(); } /** * ArriveorderDMO 构造子注解。 * * @param dbName * java.lang.String 在EJB Server中配置的数据库DataSource名称。 * @exception javax.naming.NamingException * 父类构造子抛出的异常。 * @exception nc.bs.pub.SystemException * 父类构造子抛出的异常。 */ public ArriveorderDMO(String dbName) throws javax.naming.NamingException, SystemException { super(dbName); } public ArriveorderItemVO[] queryTranBodysByHid(String pk_hid) throws BusinessException{ String sql = "select carriveorder_bid, carriveorderid, pk_corp, corder_bid, corderid, cmangid, cassistunit, " + "narrvnum, nassistnum, nwastnum, nwastassistnum, npresentnum, npresentassistnum, vproducenum, " + "ccurrencytypeid, noriginalcurprice, noriginalcurmny, nexchangeotobrate, nprice, nmoney, " + "dproducedate, ivalidday, dvaliddate, nelignum, nnotelignum," + "naccumchecknum, naccumwarehousenum, cwarehouseid, cstoreid, cupsourcebilltype, cupsourcebillid, cupsourcebillrowid, vmemo, " + "vdef1, vdef2, vdef3, vdef4, vdef5, vdef6,vdef7, vdef8, vdef9, vdef10, vdef11, vdef12, vdef13, vdef14, vdef15, vdef16, vdef17, vdef18, vdef19, vdef20, " + "pk_defdoc1,pk_defdoc2,pk_defdoc3,pk_defdoc4,pk_defdoc5,pk_defdoc6,pk_defdoc7,pk_defdoc8,pk_defdoc9,pk_defdoc10,pk_defdoc11,pk_defdoc12,pk_defdoc13,pk_defdoc14,pk_defdoc15,pk_defdoc16,pk_defdoc17,pk_defdoc18,pk_defdoc19,pk_defdoc20, " + "vfree1, vfree2, vfree3, vfree4, vfree5, " + "cbaseid, csourcebilltype, csourcebillid, csourcebillrowid, ts, cprojectid, cprojectphaseid, " + "crowno,vbackreasonb,naccreplenishnum,corder_bb1id ,blargess,blargessuprow ,pk_reqcorp," + "pk_reqstoorg,pk_creqwareid,pk_invoicecorp,creporterid,dreportdate,bfaflag,nplanarrvnum,dplanreceivedate,btransasset,noriginaltaxprice,noriginaltaxmny,noriginaltaxpricemny "; //start change 2021/11/17 新委外到货单增加BOM版本 if(ControlScParamUtil.isNewSc()) { sql += ",po_arriveorder_b.bomversion "; } //end sql += "from po_arriveorder_b "; sql += "where dr = 0 and carriveorderid= ? and btransasset='Y' "; ArriveorderItemVO[] arriveorderItems = null; Vector v = new Vector(); Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; @SuppressWarnings("unused") String sHid, sTmp; @SuppressWarnings("unused") Object oTmp; @SuppressWarnings("unused") Integer iTmp; ArriveorderItemVO arriveorderItem = null; try { con = getConnection(); stmt = con.prepareStatement(sql); stmt.setString(1, pk_hid); // 查询表体 rs = stmt.executeQuery(); // int index = 0; while (rs.next()) { // index = 0; // arriveorderItem = new ArriveorderItemVO(); // arriveorderItem.setCarriveorder_bid(rs.getString(++index)); //医药插件修改 开始 arriveorderItem.setBbiont(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBinjection(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBkillgerms(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBchemicalreagent(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBfamilyplan(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBvaccine(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBigf(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBspecialcomponent(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBinsulin(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBfood(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBhealthfood(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBcosmetic(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBnocash(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setIspecialmedicine(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setImedicalapparatus(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setIdangerous(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBchnherbalmed(PuPubVO.getUFBoolean_NullAs(rs.getString(++index), UFBoolean.FALSE)); arriveorderItem.setBchnmed(PuPubVO.getUFBoolean_NullAs(rs.getStrin