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

namespace BLL
{
    public class DALCheckDetail :IDALCheckDetail
    {

        public IList<CheckMat> GetList(string CDNo)
        {
            try
            {
                IList<CheckMat> ls = new List<CheckMat>();
                StringBuilder strSql = new StringBuilder();
                strSql.Append("Select *,Unit as UnitFrist  from CheckDataDetail where IsDel = 0 ");
                if (!string.IsNullOrEmpty(CDNo))
                {
                    strSql.Append("and CDNo = " + CDNo.AddQuotes());
                }

                SqlParam[] param = null;

                IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, param);
                ls = ModelConvertHelper<CheckMat>.DataReaderToModel(dt);

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

        public bool Add(List<CheckMat> EMats)
        {
            bool result = false;
            try
            {
                //IList<ErpMat> ls = new List<ErpMat>();
                List<SqlParam> para = new List<SqlParam>();
                StringBuilder strSql = new StringBuilder();

                strSql.Append(" Insert into Log_Check_Detail ( CDNo,MatNo,MatName,PackFormat,UnitFrist,Batch,Palno,Quant,Addre,Demo ) values ");


                for (int i = 0; i < EMats.Count; i++)
                {
                    strSql.Append("(@CDNo" + i + ",");
                    para.Add(new SqlParam("@CDNo" + i, EMats[i].CDNo));

                    strSql.Append("@MatNo" + i + ",");
                    para.Add(new SqlParam("@MatNo" + i, EMats[i].MatNo));

                    strSql.Append("@MatName" + i + ",");
                    para.Add(new SqlParam("@MatName" + i, EMats[i].MatName));

                    strSql.Append("@PackFormat" + i + ",");
                    para.Add(new SqlParam("@PackFormat" + i, EMats[i].PackFormat));

                    strSql.Append("@UnitFrist" + i + ",");
                    para.Add(new SqlParam("@UnitFrist" + i, EMats[i].UnitFrist));

                    strSql.Append("@Batch" + i + ",");
                    para.Add(new SqlParam("@Batch" + i, EMats[i].Batch));

                    strSql.Append("@Palno" + i + ",");
                    para.Add(new SqlParam("@Palno" + i, EMats[i].Palno));

                    strSql.Append("@Quant" + i + ",");
                    para.Add(new SqlParam("@Quant" + i, EMats[i].Quant));

                    strSql.Append("@Addre" + i + ",");
                    para.Add(new SqlParam("@Addre" + i, EMats[i].Addre));

                    strSql.Append("@Demo" + i + "),");
                    para.Add(new SqlParam("@Demo" + i, EMats[i].Demo));
                }

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

                    strSql.Remove(strSql.Length - 1, 1);
                    param = para.ToArray();
                }
                int dt = DataFactory.SqlDataBase().ExecuteBySql(strSql, param);
                if (EMats.Count == dt) result = true;

                return result;
            }
            catch
            {
                return result;
            }
        }

        public bool Update(List<CheckMat> model)
        {
            bool result = false;
            try
            {

                if (!this.Delete(model)) return false;

                if (!this.Add(model)) return false;

                return true;

            }
            catch
            {
                return result;
            }
        }
        public bool IsExist(string name, string value)
        {
            bool result = false;
            try
            {
                string[] para = new string[] { value };
                int dt = DataFactory.SqlDataBase().IsExist("Roles", name, para);
                if (dt > 0) result = true;
                return result;
            }
            catch
            {
                return result;
            }

        }

       

        public bool Delete(List<CheckMat> EMats)
        {
            bool result = false;
            try
            {
                List<SqlParam> para = new List<SqlParam>();
                StringBuilder strSql = new StringBuilder();
                StringBuilder sp1 = new StringBuilder();
                StringBuilder sp2 = new StringBuilder();

                strSql.Append(" DELETE FROM Log_Check_Detail where " );

                int i;
                sp1.Append(" CDNo =  ");
                sp2.Append("  CDNo in ( ");
                for ( i= 0; i < EMats.Count; i++)
                {
                    if (i == 0)
                    {
                        sp1.Append(" @OrdNo ");
                        para.Add(new SqlParam("@CDNo", EMats[i].CDNo));
                    }

                    sp2.Append("@MatNo" + i + ",");
                    para.Add(new SqlParam("@MatNo" + i, EMats[i].MatNo));
                }

                if (i > 0)
                {
                    sp1.Append(" and  ");
                    sp2.Append(" )");
                    strSql.Append(sp1);
                    ;
                    strSql.Append(sp2.Remove(sp2.Length - 3, 1));

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

                    int dt = DataFactory.SqlDataBase().ExecuteBySql(strSql, param);


                    if (EMats.Count == dt ) result = true;

                }
                return result;
            }
            catch
            {
                return result;
            }
        }
    }
}