using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

//Ref:
using System.Data;

using QMAPP.BoraUpgrade.Common;

using QMAPP.BoraUpgrade.Entity;

namespace QMAPP.BoraUpgrade.DAL
{
    /// <summary>
    /// 注塑条码打码-数据访问类
    /// CreateTime:2019.10.18
    /// Author    :陈冲
    /// Mail      :22367340@qq.com
    /// </summary>
    public class PrintCodeRouteDataAccess
    {
        #region 获取全部打码规则
        /// <summary>
        ///  获取全部打码规则
        /// </summary>
        /// <param name="productCode">产品编号</param>
        /// <returns></returns>
        public static DataTable GetPrintCodeRouteAllList()
        {
            DataTable returnVal = new DataTable();

            string sqlScript = @"Select * From [T_QD_PrintCodeRoute]";

            DataSet dataSet = SqlHelper.ExecuteDataset(Config.maindbConnectionString, CommandType.Text,sqlScript);

            if ( dataSet.Tables.Count > 0 )
            {
                returnVal = dataSet.Tables[0];
            }

            return returnVal;
        }

        public static DataTable GetExsitProductCodeQty(string productCode,string cellCode)
        {
            string sql = $"select * from T_AW_Product  where ProductCode='{productCode}' and WorkCell_Code='{cellCode}'";
            DataSet dataSet = SqlHelper.ExecuteDataset(Config.maindbConnectionString, CommandType.Text, sql);

            DataTable dataTable =  dataSet.Tables[0];
            
            return dataTable;
        }

        #endregion
    }
}