using Commom.Utility;
using Common;
using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace BLL.DAL
{
    public class DALStroeMat
    {
        /// <summary>
        /// 获取库存信息
        /// </summary>
        /// <param name="Json"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public IList<StroeMat> GetStroeMat(StroeMat Json, ref PageInfo pageInfo)
        {
            try
            {
                IList<StroeMat> list = new List<StroeMat>();
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select * from View_StroeMat_Material where 1=1 " + $" AND (DepartGuid='{Json.DepartGuid}' or DepartGuid is null) ");

                if (Json.MatNo != null && Json.MatNo != "")
                {
                    strSql.Append(" and MatNo like '%" + Json.MatNo + "%' ");
                }
                if (Json.MatName != null && Json.MatName != "")
                {
                    strSql.Append(" and MatName like '%" + Json.MatName + "%' ");
                }
                if (Json.PackFormat != null && Json.PackFormat != "")
                {
                    strSql.Append(" and PackFormat like '%" + Json.PackFormat + "%'  ");
                }
                //if (!string.IsNullOrEmpty(Json.Unit))     // 物料单位不作为条件
                //{
                //    strSql.Append(" and Unit = " + Json.Unit.AddQuotes());
                //}
                if (!string.IsNullOrEmpty(Json.BrandId))
                {
                    strSql.Append(" and BrandId = " + Json.BrandId.AddQuotes());
                }
                if (!string.IsNullOrEmpty(Json.MatTypeId))
                {
                    strSql.Append(" and MatTypeId = " + Json.MatTypeId.AddQuotes());
                }

                SqlParam[] param = null;
                DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "MatNo", "ASC", ref pageInfo);

                list = ModelConvertHelper<StroeMat>.DataTableToModel(dt);

                return list;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 获取库存明细
        /// </summary>
        /// <param name="Json"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public IList<StroeItems> GetStroeItems(StroeItems Json, ref PageInfo pageInfo)
        {
            try
            {
                IList<StroeItems> list = new List<StroeItems>();
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select * from View_StroeItems_Material where 1=1 " + $" AND (DepartGuid='{Json.DepartGuid}' or DepartGuid is null) ");

                if (!string.IsNullOrEmpty(Json.LingNo))
                {
                    strSql.Append("and LingNo like '%" + Json.LingNo + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.Addre))
                {
                    strSql.Append("and Addre like '%" + Json.Addre + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.Palno))
                {
                    strSql.Append("and Palno like '%" + Json.Palno + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.TuNo))
                {
                    strSql.Append("and TuNo like '%" + Json.TuNo + "%' ");
                }

                // 批次号
                if (!string.IsNullOrEmpty(Json.BatchNo))
                {
                    strSql.Append("and BatchNo like '%" + Json.BatchNo + "%' ");
                }
                // 批次描述
                if (!string.IsNullOrEmpty(Json.BatchDemo))
                {
                    strSql.Append("and BatchName like '%" + Json.BatchDemo + "%' ");
                }

                if (!string.IsNullOrEmpty(Json.MatNo))
                {
                    strSql.Append("and MatNo like '%" + Json.MatNo + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.MatName))
                {
                    strSql.Append("and MatName like '%" + Json.MatName + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.PackFormat))
                {
                    strSql.Append("and PackFormat like '%" + Json.PackFormat + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.MatTypeId))
                {
                    strSql.Append("and MatTypeId = " + Json.MatTypeId.AddQuotes());
                }
                // 序号
                if (!string.IsNullOrEmpty(Json.YeNo))
                {
                    strSql.Append(" and YeNo like '%" + Json.YeNo + "%' ");
                }
                // 合格证判定
                if (!string.IsNullOrEmpty(Json.Certificate))
                {
                    if (Json.Certificate == "有")
                    {
                        strSql.Append(" and LEN(isnull(certificate,'')) > 0");
                    }
                    else
                    {
                        strSql.Append(" and LEN(isnull(certificate,'')) = 0");
                    }
                }


                SqlParam[] param = null;
                DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "[dbo].PadLeft(YeNo,'0',3),MatNo ", "desc", ref pageInfo);
               // DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "[dbo].PadLeft(YeNo,'0',3)", "ASC", ref pageInfo);

                list = ModelConvertHelper<StroeItems>.DataTableToModel(dt);

                return list;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        public DataTable GetStroeMatDetail(StroeMat Json)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select * from View_StroeMat_Material where 1=1 ");

                if (Json.MatNo != null && Json.MatNo != "")
                {
                    strSql.Append(" and MatNo like '%" + Json.MatNo + "%' ");
                }
                if (Json.MatName != null && Json.MatName != "")
                {
                    strSql.Append(" and MatName like '%" + Json.MatName + "%' ");
                }
                if (Json.PackFormat != null && Json.PackFormat != "")
                {
                    strSql.Append(" and PackFormat like '%" + Json.PackFormat + "%'  ");
                }
                if (!string.IsNullOrEmpty(Json.BrandId))
                {
                    strSql.Append(" and BrandId = " + Json.BrandId.AddQuotes());
                }
                if (!string.IsNullOrEmpty(Json.MatTypeId))
                {
                    strSql.Append(" and MatTypeId = " + Json.MatTypeId.AddQuotes());
                }

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);
                dt.TableName = "View_StroeMat_Material";

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

        public DataTable GetStroeItems(StroeItems Json)
        {
            try
            {
                IList<StroeItems> list = new List<StroeItems>();
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select * from View_StroeItems_Material where 1=1 ");

                if (!string.IsNullOrEmpty(Json.LingNo))
                {
                    strSql.Append("and LingNo like '%" + Json.LingNo + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.Addre))
                {
                    strSql.Append("and Addre like '%" + Json.Addre + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.Palno))
                {
                    strSql.Append("and Palno like '%" + Json.Palno + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.TuNo))
                {
                    strSql.Append("and TuNo like '%" + Json.TuNo + "%' ");
                }

                if (!string.IsNullOrEmpty(Json.MatNo))
                {
                    strSql.Append("and MatNo like '%" + Json.MatNo + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.MatName))
                {
                    strSql.Append("and MatName like '%" + Json.MatName + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.PackFormat))
                {
                    strSql.Append("and PackFormat like '%" + Json.PackFormat + "%' ");
                }
                if (!string.IsNullOrEmpty(Json.MatTypeId))
                {
                    strSql.Append("and MatTypeId = " + Json.MatTypeId.AddQuotes());
                }

                strSql.Append(" order by [dbo].PadLeft(YeNo,'0',3) asc; ");

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);
                dt.TableName = "TbItems";
                return dt;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }
    }
}