using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using ICSSoft.Base.Config.AppConfig;
using ICSSoft.Base.Config.DBHelper;
using System.Data.SqlClient;

namespace ICSSoft.Frame.Data.DAL
{
    public class ICSResOPDAL
    {
        public static DataTable GetResOPList(string LOTNO, int OPSEQ, string WorkPoint)
        {
            string sql = @"[dbo].[GET_ResOP]";
            sql = string.Format(sql, LOTNO, OPSEQ, WorkPoint);
            SqlParameter[] pms = new SqlParameter[]{
                new SqlParameter("@LOTNO",SqlDbType.NVarChar){Value=LOTNO},
                new SqlParameter("@OPSEQ",SqlDbType.Int){Value=OPSEQ},
                new SqlParameter("@WorkPoint",SqlDbType.NVarChar){Value =WorkPoint},
                new SqlParameter("@FLAG",SqlDbType.NVarChar){Value =DBNull.Value}
            };
            return DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.StoredProcedure, sql, pms).Tables[0];
        }
    }
}