using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using CY.Infrastructure.Common;
using AbstractFactory;
using CY.Model;
using System.Data;
namespace CY.BLL.OA
{
    public class OA_CommoditySpeciAssociateBLL
    {
        IOA_CommoditySpeciAssociateDAL CommoditySpeciAssociateDAL = null;

        public OA_CommoditySpeciAssociateBLL()
        {
            CommoditySpeciAssociateDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_CommoditySpeciAssociateDAL) as IOA_CommoditySpeciAssociateDAL;


        }



        /// <summary>
        /// 批量新增
        /// </summary>
        /// <param name="SpecificationList"></param>
        /// <param name="CommodityId"></param>
        /// <returns></returns>
        public bool InsertModel(string[] SpecificationList, string CommodityId)
        {
            int? commodityId = MyConvert.ConvertToInt32(CommodityId);
            if (!commodityId.HasValue) return false; else { }

            List<OA_CommoditySpeciAssociate> commoditySpeciAssociates = new List<OA_CommoditySpeciAssociate>();

            for (int i = 0; i < SpecificationList.Length; i++)
            {
                if (!MyConvert.ConvertToInt32(SpecificationList[i]).HasValue) return false; else { }

                commoditySpeciAssociates.Add(new OA_CommoditySpeciAssociate()
                {
                    CommodityId = commodityId,
                    SpecificationId = SpecificationList[i].ToInt32()
                });

            }
            return CommoditySpeciAssociateDAL.InserModel(commoditySpeciAssociates.ToArray());

        }


        /// <summary>
        /// 批量删除
        /// </summary>
        /// <param name="models"></param>
        /// <returns></returns>
        public bool DeleteModel(string[] SpecificationList, string CommodityId)
        {
            int? commodityId = MyConvert.ConvertToInt32(CommodityId);
            if (!commodityId.HasValue) return false; else { }
            List<OA_CommoditySpeciAssociate> commoditySpeciAssociates = new List<OA_CommoditySpeciAssociate>();
            for (int i = 0; i < SpecificationList.Length; i++)
            {
                if (!MyConvert.ConvertToInt32(SpecificationList[i]).HasValue) return false;
                commoditySpeciAssociates.Add(new OA_CommoditySpeciAssociate() { CommodityId = commodityId, SpecificationId = SpecificationList[i].ToInt32() });
            }
            return CommoditySpeciAssociateDAL.DeleteModel(commoditySpeciAssociates.ToArray());

        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {

            return CommoditySpeciAssociateDAL.UpdateModel(model);
        }

        
        /// <summary>
        /// 单个查询
        /// </summary>
        /// <param name="SpecificationId"></param>
        /// <returns></returns>
        public Model.OA_CommoditySpeciAssociate SelectSingelModel(string SpecificationId)
        {
            return CommoditySpeciAssociateDAL.SelectSingelModel(SpecificationId);
        }

        /// <summary>
        /// 得到类别--规格对应
        /// </summary>
        /// <param name="CommodityId"></param>
        /// <returns></returns>
        public DataTable SelectModelPage(string CommodityId)
        {
            return CommoditySpeciAssociateDAL.SelectModelPage(CommodityId);

        }
        public IEnumerable<Model.OA_CommoditySpeciAssociate> SelectALLModel(string CommodityId)
        {
            return CommoditySpeciAssociateDAL.SelectALLModel(CommodityId);
        }


        public bool MananeModel(string[] SpecificationListBefore, string[] SpecificationListAfter, string CommodityId)
        {

            int? commodityId = MyConvert.ConvertToInt32(CommodityId);
            if (!commodityId.HasValue) return false; else { }

            List<OA_CommoditySpeciAssociate> Deletemodels = new List<OA_CommoditySpeciAssociate>();

            for (int i = 0; i < SpecificationListBefore.Length; i++)
            {
                if (!MyConvert.ConvertToInt32(SpecificationListBefore[i]).HasValue) return false; else { }

                Deletemodels.Add(new OA_CommoditySpeciAssociate()
                {
                    CommodityId = commodityId,
                    SpecificationId = SpecificationListBefore[i].ToInt32()
                });
            }
            List<OA_CommoditySpeciAssociate> Insertmodles = new List<OA_CommoditySpeciAssociate>();

            for (int i = 0; i < SpecificationListAfter.Length; i++)
            {
                if (!MyConvert.ConvertToInt32(SpecificationListAfter[i]).HasValue) return false; else { }

                Insertmodles.Add(new OA_CommoditySpeciAssociate()
                {
                    CommodityId = commodityId,
                    SpecificationId = SpecificationListAfter[i].ToInt32()
                });
            }
            return CommoditySpeciAssociateDAL.MananeModel(Deletemodels.ToArray(), Insertmodles.ToArray());
        }
    }

}