using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using Common;
using System.Collections;
using System.Net;

namespace BLL
{
    public class DALTray
    {
        /// <summary>
        /// 查询托盘信息
        /// </summary>
        /// <param name="trayModel">托盘实体类</param>
        /// <param name="pageInfo">分页信息</param>
        /// <returns>托盘信息，实体</returns>
        public IList<Tray> GetList(TrayList trayModel, ref PageInfo pageInfo) 
        {
            try
            {
                IList<Tray> list = new List<Tray>();
                StringBuilder strSql = new StringBuilder();

                strSql.Append("Select * from View_Log_Store_Palno where 1 = 1 ");
                if (trayModel.Addre != null && trayModel.Addre != "") 
                {
                    strSql.Append(" and Addre like '%" + trayModel.Addre + "%'");
                }
                if (trayModel.Palno != null && trayModel.Palno != "")
                { 
                    strSql.Append(" and Palno like '%" + trayModel.Palno + "%'");
                }
                if (trayModel.ALock != null && trayModel.ALock != "")
                {
                    strSql.Append(" and ALockNo = '" + trayModel.ALock + "'");
                }
                if (trayModel.BeCreateTime != null && trayModel.BeCreateTime != DateTime.MinValue)
                {
                    strSql.Append(" and CreateTime >= '"+trayModel.BeCreateTime+"'");
                }
                if (trayModel.EnCreateTime != null && trayModel.EnCreateTime != DateTime.MinValue)
                {
                    strSql.Append(" and CreateTime <= '" + trayModel.EnCreateTime + "'");
                }

                DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), null, "CreateTime", "DESC", ref pageInfo);

                return  ModelConvertHelper<Tray>.DataTableToModel(dt);
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 获取单行托盘信息
        /// </summary>
        /// <param name="Palno">托盘码</param>
        /// <returns>dataRow</returns>
        public Tray GetTrayModel(string Palno) 
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select * from View_Log_Store_Palno where palno = '" + Palno + "';");
                IDataReader dr = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql);

                return ModelConvertHelper<Tray>.ReaderToModel(dr);
            }
            catch (Exception)
            {
                return null;
            }
        }

        /// <summary>
        /// 新增编辑托盘
        /// </summary>
        /// <param name="trayModel">托盘信息集合</param>
        /// <returns>true:保存成功 false:保存失败</returns>
        public bool AddEdit(Tray trayModel) 
        {
            bool bl = false;
            try
            {
                int rowCount = 0;
                if (trayModel.Palno == "")
                {
                    // add托盘
                    string palnoNext = this.GetPalnoCode();
                    Hashtable ht = new Hashtable();
                    ht["Addre"] = "'" + trayModel.Addre + "'";
                    ht["Palno"] = "'" + palnoNext + "'";
                    ht["ALock"] = "'" + trayModel.ALock + "'";
                    ht["CreateTime"] = "convert(varchar(20),getdate(),120)";
                    ht["Demo"] = "'" + trayModel.Demo + "'";
                    ht["guid"] = "NEWID()";

                    rowCount = DataFactory.SqlDataBase().InsertByHashtableNullParam("log_Store_Palno", ht);
                }
                else 
                {
                    // Edit托盘
                    Hashtable ht = new Hashtable();
                    ht["Addre"] = "'" + trayModel.Addre + "'";
                    ht["CreateTime"] = "'" + trayModel.CreateTime + "'";
                    ht["Demo"] = "'" + trayModel.Demo + "'";
                    rowCount = DataFactory.SqlDataBase().UpdateByHashtable("log_Store_Palno", "Palno", trayModel.Palno, ht);
                }

                if (rowCount == 1)
                {
                    bl = true;
                }
            }
            catch (Exception)
            {
                bl = false;
            }

            return bl;
        }

        /// <summary>
        /// 删除托盘
        /// </summary>
        /// <param name="Palnolist">须删除项主键集合</param>
        /// <returns>true:删除成功 false:删除失败</returns>
        public bool Delete(string[] Palno) 
        {
            bool bl = false;
            try
            {
                // 后期可根据库存明细，来限制托盘的删除。
                int rowCount = DataFactory.SqlDataBase().BatchDeleteData("log_Store_Palno", "Palno", Palno);
                if (rowCount >= Palno.Length) 
                {
                    bl = true;
                }

                return bl;
            }
            catch (Exception)
            {
                return bl;
            }
        }

        /// <summary>
        /// 获取货位信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetGoodsPosPrint(string StorageNo) 
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                if (StorageNo != "")
                {
                    strSql.Append("select Addre from GoodsPos where StorageAraeNo = '" + StorageNo + "'; ");
                }

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);

                return dt;
            }
            catch (Exception)
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 获取单个货位信息
        /// </summary>
        /// <param name="Addre"></param>
        /// <returns></returns>
        public DataTable GetGoodsPos(string Addre) 
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                if (Addre != "")
                {
                    strSql.Append("select tb1.Addre,tb2.StorageName from GoodsPos as tb1 ");
                    strSql.Append("left join StorageArea as tb2 on tb1.StorageAraeNo = tb2.StorageNo ");
                    strSql.Append("where tb1.Addre = '"+ Addre + "';");
                }

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);

                return dt;
            }
            catch (Exception)
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 打印托盘信息
        /// </summary>
        /// <param name="Addre"></param>
        /// <param name="TrayNo"></param>
        /// <returns></returns>
        public DataTable GetTrayPrint(string Addre,string TrayNo) 
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select tb1.Addre,tb2.StorageName,tb3.Palno from GoodsPos as tb1 ");
                strSql.Append("left join StorageArea as tb2 on tb1.StorageAraeNo = tb2.StorageNo ");
                strSql.Append("left join log_Store_Palno as tb3 on tb1.Addre = tb3.Addre ");

                if (Addre != "")
                {
                    strSql.Append("where tb1.Addre = '" + Addre + "';");
                }
                else if (TrayNo != "") 
                {
                    strSql.Append("where tb3.Palno = '" + TrayNo + "';");
                }

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);

                return dt;
            }
            catch (Exception)
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 获取最大托盘码
        /// </summary>
        /// <returns></returns>
        private string GetPalnoCode() 
        {
            StringBuilder sbstr = new StringBuilder();
            try
            {
                string palno = "00000001";
                sbstr.Append("select isnull(max(palno)+1,'0') as palno from log_Store_Palno;");
                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sbstr);

                if (dt.Rows[0][0].ToString() != "0") 
                {
                    palno = dt.Rows[0][0].ToString().PadLeft(8,'0');
                }

                return palno;
            }
            catch (Exception)
            {
                return null;
            }
        }
    }
}