XinYu_LZMES/.svn/pristine/97/970a5496e66abd9ba6bb67ea26f84eb35080aaf2.svn-base

package UIL.UIL01;

import java.sql.SQLException;
import java.util.ArrayList;

import UIB.COM.XmlSqlParsersFactory;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

/**
 * 标签打印钢卷信息查询
 * 
 * @author Administrator
 * 
 */
public class UIL010020 extends CoreIComponent {
	/**
	 * 查询待打印钢卷信息
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryCoilList(ArrayList params) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		try {
			if (params != null && params.size() == 10) {
				String sql = "";
				int flag = Integer.parseInt(params.get(9).toString().trim());
				switch (flag) {
				case 1:// 酸轧出口
					sql = XmlSqlParsersFactory.getSql("UIL010020_01.SELECT");
					break;
				case 2:// 连退出口
					sql = XmlSqlParsersFactory.getSql("UIL010020_02.SELECT");
					break;
				case 3:// 重卷出口
					sql = XmlSqlParsersFactory.getSql("UIL010020_03.SELECT");
					break;
				case 4:// 酸洗出口
					sql = XmlSqlParsersFactory.getSql("UIL010020_05.SELECT");
					break;
				}

				params.remove(params.size() - 1);
				cro = this.getDao("KgDao").ExcuteQuery(sql, params.toArray());
			} else {
				cro.setV_errCode(-1);
				cro.setV_errMsg("查询失败，请联系管理员！");
			}
		} catch (Exception ex) {
			cro.setV_errCode(-1);
			cro.setV_errMsg("查询失败，请联系管理员！");
		}
		return cro;
	}

	public CoreReturnObject dateColor(String coilNo, String flag)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = "";
		try {
			if (flag.equals("A")) {
				sql = "UPDATE C_TBL02_COIL_COMM T SET T.PRINT_TP='Y' WHERE T.OLD_SAMPL_NO='"
						+ coilNo + "'";
			}
			if (flag.equals("B")) {
				sql = "UPDATE C_TBC02_COIL_COMM T SET T.PRINT_TP='Y' WHERE T.OLD_SAMPL_NO='"
						+ coilNo + "'";
			}
			if (flag.equals("D")) {
				sql = "UPDATE C_TBC02_COIL_COMM T SET T.PRINT_TP='Y' WHERE T.OLD_SAMPL_NO='"
						+ coilNo + "'";
			}
			cro = this.getDao("KgDao").ExcuteQuery(sql);
		} catch (Exception e) {

		}
		return cro;
	}

}