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;
	}

}