1e6ee2a94e2e00fb5eaddabe77fafe90de301c23.svn-base 1.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. package UIK.UIK08;
  2. import java.sql.SQLException;
  3. import java.util.ArrayList;
  4. import javax.jms.Session;
  5. import UIB.COM.XmlSqlParsersFactory;
  6. import CoreFS.SA01.CoreIComponent;
  7. import CoreFS.SA06.CoreReturnObject;
  8. public class UIK080012 extends CoreIComponent {
  9. public CoreReturnObject doSave(String ordno, String ordseq, String retpt,
  10. String regID, String regSHIFT, String regGROUP)
  11. throws SQLException {
  12. CoreReturnObject cro = new CoreReturnObject();
  13. String sql = "";
  14. StringBuffer str = new StringBuffer("UPDATE TBE02_ORD_PRC \n");
  15. str.append("SET ORD_PRC_LOCK = '").append(retpt).append("'\n");
  16. str.append("where ORD_NO = '").append(ordno).append("' \n");
  17. str.append("and ORD_SEQ = '").append(ordseq).append("' \n");
  18. sql = str.toString();
  19. this.getDao("KgDao").ExcuteNonQuery(sql); // ExcuteNonQuery 增 删 改 无返回值
  20. // ExcuteQuery 查询 有返回值
  21. sql = XmlSqlParsersFactory.getSql("UIK080012_SHIFT.insert");
  22. this.getDao("KgDao").ExcuteNonQuery(sql,
  23. new Object[] { regID, regSHIFT, regGROUP, retpt,ordno,ordseq });
  24. return cro;
  25. }
  26. }