| 123456789101112131415161718192021222324252627282930313233343536 |
- package UIK.UIK08;
- import java.sql.SQLException;
- import java.util.ArrayList;
- import javax.jms.Session;
- import UIB.COM.XmlSqlParsersFactory;
- import CoreFS.SA01.CoreIComponent;
- import CoreFS.SA06.CoreReturnObject;
- public class UIK080012 extends CoreIComponent {
- public CoreReturnObject doSave(String ordno, String ordseq, String retpt,
- String regID, String regSHIFT, String regGROUP)
- throws SQLException {
- CoreReturnObject cro = new CoreReturnObject();
- String sql = "";
- StringBuffer str = new StringBuffer("UPDATE TBE02_ORD_PRC \n");
- str.append("SET ORD_PRC_LOCK = '").append(retpt).append("'\n");
- str.append("where ORD_NO = '").append(ordno).append("' \n");
- str.append("and ORD_SEQ = '").append(ordseq).append("' \n");
- sql = str.toString();
- this.getDao("KgDao").ExcuteNonQuery(sql); // ExcuteNonQuery 增 删 改 无返回值
- // ExcuteQuery 查询 有返回值
- sql = XmlSqlParsersFactory.getSql("UIK080012_SHIFT.insert");
- this.getDao("KgDao").ExcuteNonQuery(sql,
- new Object[] { regID, regSHIFT, regGROUP, retpt,ordno,ordseq });
- return cro;
- }
- }
|