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

namespace BLL.DAL
{
  public  class DALPltOutDetail
    {
        public bool Add(List<StorePalno> 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 ErpOutDetail (OrdNo,Palno,Addre,CurQuant,Demo,Lever) values ");


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

                   

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

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

                    //lijiangang新增：更改货位状态为待出库
                    StringBuilder Sql = new StringBuilder();
                    Sql.Append("update DepotsLocation set TurnoverDemand='04' where LocationCode='" + EMats[i].Addre + "'");
                    DataFactory.SqlDataBase().ExecuteBySql(Sql);

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

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

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

                  
                }

                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<StorePalno> model)
        {
            bool result = false;
            try
            {

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

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

                return true;

            }
            catch
            {
                return result;
            }
        }
        public bool Delete(List<StorePalno> 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 ErpOutDetail where ");

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

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



                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 true;
            }
            catch
            {
                return result;
            }
        }
    }
}