using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Text;
using MESClassLibrary.BLL.Log;
using MESClassLibrary.DAL;
using MESClassLibrary.DAL.Mistake247;
using MESClassLibrary.Model;

namespace MESClassLibrary.BLL.Mistake247
{
    public class RecordBLL
    {
        private RecordDAL _recordDAL = new RecordDAL();

        public string SearchQLevelFromWms(string stockNo, string partCode)
        {
            return _recordDAL.SearchQLevel(stockNo, partCode);
        }
        /// <summary>
        /// 左前
        /// </summary>
        /// <returns></returns>
        public DataTable GetX247LF()
        {
            return _recordDAL.GetX247LF();
        }
        /// <summary>
        /// 左后
        /// </summary>
        /// <returns></returns>
        public DataTable GetX247LR()
        {
            return _recordDAL.GetX247LR();
        }
        /// <summary>
        /// 右前
        /// </summary>
        /// <returns></returns>
        public DataTable GetX247RF()
        {
            return _recordDAL.GetX247RF();
        }
        /// <summary>
        /// 右后
        /// </summary>
        /// <returns></returns>
        public DataTable GetX247RR()
        {
            return _recordDAL.GetX247RR();
        }



        public DataTable SearchByPartNo1(string PartNo)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchByPartNo1(PartNo);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable SearchCountByBox(string boxNo)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchCountByBox(boxNo);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public bool AddInfo(RecordModel md)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.AddInfo(md);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return false;
            }
        }

        public bool UpdateCreateTime1(string partNo)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.UpdateCreateTime1(partNo);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(),MethodBase.GetCurrentMethod());
                return false;
            }
        }

        public bool updateBoxInfo(RecordModel md)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.updateBoxInfo(md);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return false;
            }
        }

        public DataTable SearchState(int type1,int type2,int type3)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchState(type1,type2,type3);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public bool DelInfo(RecordModel md)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.DelInfo(md);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return false;
            }
        }

        public DataTable SearchBoxByPart(string part)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchBoxByPart(part);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable SearchByPartNo2(string partno)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchByPartNo2(partno);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable GetCount(string part,string batch)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.GetCount(part,batch);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }


        public DataTable GetRecord(string boxNo)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.GetRecord(boxNo);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable GetOrderNum(string orderno)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.GetOrderNum(orderno);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable SearchIsVisualByPartNo2(string partno)
        {
            try
            {
                RecordDAL da = new RecordDAL();
                try
                {
                    return da.SearchIsVisualByPartNo2(partno);
                }
                catch (Exception ex)
                {
                    LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                    return null;
                } 
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public string GetDeviceNo()
        {
            try
            {
                RecordDAL da=new RecordDAL();

                return da.GetDeviceNo();
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(),MethodBase.GetCurrentMethod());
                return "";
            }
        }

        #region 243

        public bool AddInfo1(RecordModel md)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.AddInfo1(md);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return false;
            }
        }

        public DataTable GetCount1(string part, string batch)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.GetCount1(part, batch);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable SearchByPartNo4(string partno)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchByPartNo4(partno);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable SearchBoxByPart1(string part)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchBoxByPart1(part);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable SearchCountByBox1(string boxNo)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchCountByBox1(boxNo);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public bool updateBoxInfo1(RecordModel md)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.updateBoxInfo1(md);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return false;
            }
        }

        public bool DelInfo1(RecordModel md)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.DelInfo1(md);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return false;
            }
        }
        public DataTable SearchState1(int type1, int type2, int type3)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.SearchState1(type1, type2, type3);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        public DataTable GetRecord1(string boxNo)
        {
            RecordDAL da = new RecordDAL();
            try
            {
                return da.GetRecord1(boxNo);
            }
            catch (Exception ex)
            {
                LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod());
                return null;
            }
        }

        #endregion

    }
}