using Common;
using Model;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BLL.DAL
{
   public class DALPacking
    {
        public IList<Packing> GetPackingList(Packing Json, ref PageInfo pageInfo)
        {
            try
            {

                IList<Packing> list = new List<Packing>();
                StringBuilder strSql = new StringBuilder();
                List<SqlParam> para = new List<SqlParam>();
                strSql.Append("Select * from View_S_Packing ");


                if (Json.PackingCode != null && Json.PackingCode != "")
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("PackingCode like '%' + @PackingCode + '%' ");
                    para.Add(new SqlParam("@PackingCode", Json.PackingCode));
                }

                if (Json.PackingName != null && Json.PackingName != "")
                {
                    if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
                    strSql.Append("PackingName like '%' + @PackingName + '%'  ");
                    para.Add(new SqlParam("@PackingName", Json.PackingName));
                }

                if (para.Count < 1) strSql.Append("where IsDel = 0"); else strSql.Append(" and  IsDel = 0");


                SqlParam[] param = null;
                if (para != null)
                    param = para.ToArray();


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

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

                return list;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }
        public Packing GetModel(string PackingCode)
        {
            try
            {
                Packing us = null;
                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select * from S_Packing where ");
                strSql.Append("PackingCode = @PackingCode ");

                SqlParam[] para = new SqlParam[]
                {
                    new SqlParam("@PackingCode", PackingCode),
                };

                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);

                us = ModelConvertHelper<Packing>.ReaderToModel(dt);

                return us;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }
        public bool IsExist(string PackingCode, string value)
        {
            bool result = false;
            try
            {
                string[] para = new string[] { value };
                int dt = DataFactory.SqlDataBase().IsExist("S_Packing", PackingCode, para);
                if (dt > 0) result = true;
                return result;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }
        public bool Add(Packing model, string loginUser)
        {
            bool result = false;
            try
            {
                Hashtable ht = new Hashtable();

                ht["PackingCode"] = "'" + model.PackingCode + "'";
                ht["PackingName"] = "'" + model.PackingName + "'";

                ht["CreateUser"] = "'" + loginUser + "'";
                ht["CreateTime"] = "getdate()";
                ht["Demo"] = "'" + model.Demo + "'";
                ht["Long"] = "'" + model.Long + "'";
                
                ht["Wide"] = "'" + model.Wide + "'";
                ht["High"] = "'" + model.High + "'";
                ht["Volume"] = "'" + model.Volume + "'";
                ht["IsDel"] = 0;
                int _ret = DataFactory.SqlDataBase().InsertByHashtableNullParam("S_Packing", ht);

                if (_ret == 1) result = true;

                return result;

            }
            catch
            {
                return result;
            }
        }
        public bool Update(Packing model)
        {
            bool result = false;
            try
            {
                Hashtable ht = new Hashtable();

                ht["PackingName"] = string.IsNullOrEmpty(model.PackingName) ? "''" : "'" + model.PackingName + "'";
                ht["Demo"] = string.IsNullOrEmpty(model.Demo) ? "''" : "'" + model.Demo + "'";
                ht["Long"] = string.IsNullOrEmpty(model.Long) ? "''" : "'" + model.Long + "'";
                ht["Wide"] = string.IsNullOrEmpty(model.Wide) ? "''" : "'" + model.Wide + "'";
                ht["High"] = string.IsNullOrEmpty(model.High) ? "''" : "'" + model.High + "'";
                ht["Volume"] = string.IsNullOrEmpty(model.Volume) ? "''" : "'" + model.Volume + "'";
               
                string PackingCode = "'" + model.PackingCode + "'";

                int _ret = DataFactory.SqlDataBase().UpdateByHashtable("S_Packing", "PackingCode", PackingCode, ht);

                if (_ret == 1) result = true;

                return result;

            }
            catch
            {
                return result;
            }
        }
        public bool BatchDelete(string[] PackingCode)
        {
            bool result = false;
            try
            {
                int dt = DataFactory.SqlDataBase().IsExist("S_Packing", "PackingCode", PackingCode);
                if (dt >= PackingCode.Length)
                {
                    int i = 0;
                    while (i < PackingCode.Length)
                    {
                        StringBuilder sql = new StringBuilder();
                        sql.Append("update S_Packing set IsDel=1 where PackingCode='" + PackingCode[i] + "'");
                        int _ret = DataFactory.SqlDataBase().ExecuteBySql(sql);
                        if (_ret >= PackingCode.Length) result = true;
                        i++;
                    }
                }
                return result;

            }
            catch
            {
                return result;
            }
        }
    }
}