/// <summary>
        /// 根据产品的SKU的BarCode查询产品信息
        /// </summary>
        /// <param name="BarCode"></param>
        /// <returns></returns>
        public ProductEntity GetSkuBarCode(string BarCode)
        {
            V_SkuEntity entity = new V_SkuEntity();

            entity.IncludeAll();
            entity.Where(item => item.BarCode == BarCode)
            .And(item => item.IsDelete == (int)EIsDelete.NotDelete)
            .And(item => item.CompanyID == this.CompanyID)
            ;
            ProductEntity result = this.V_Sku.GetSingle <ProductEntity>(entity);

            return(result);
        }
        /// <summary>
        /// 查询SKU产品分页信息
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public List <ProductEntity> GetSkuList(ProductEntity entity, ref PageInfo pageInfo)
        {
            V_SkuEntity product = new V_SkuEntity();

            product.IncludeAll();
            product.OrderBy(item => item.ID, EOrderBy.DESC);
            product.Where(item => item.CompanyID == this.CompanyID)
            .And(item => item.IsDelete == (int)EIsDelete.NotDelete)
            ;

            if (entity.BarCode.IsNotEmpty())
            {
                product.And("BarCode", ECondition.In, "%" + entity.BarCode + "%");
            }
            if (entity.FactoryNum.IsNotEmpty())
            {
                product.And("FactoryNum", ECondition.In, "%" + entity.FactoryNum + "%");
            }
            if (entity.InCode.IsNotEmpty())
            {
                product.And("InCode", ECondition.In, "%" + entity.InCode + "%");
            }
            if (entity.ProductName.IsNotEmpty())
            {
                product.And("ProductName", ECondition.In, "%" + entity.ProductName + "%");
            }
            if (entity.CateNum.IsNotEmpty())
            {
                product.And(item => item.CateNum == entity.CateNum);
            }
            if (entity.UnitNum.IsNotEmpty())
            {
                product.And(item => item.UnitNum == entity.UnitNum);
            }
            if (entity.Color.IsNotEmpty())
            {
                product.And("Color", ECondition.In, "%" + entity.Color + "%");
            }
            if (entity.Size.IsNotEmpty())
            {
                product.And("Size", ECondition.In, "%" + entity.Size + "%");
            }
            if (entity.CusNum.IsNotEmpty())
            {
                product.And(item => item.CusNum == entity.CusNum);
            }
            if (entity.CusName.IsNotEmpty())
            {
                product.And("CusName", ECondition.In, "%" + entity.CusName + "%");
            }
            if (entity.SupNum.IsNotEmpty())
            {
                product.And(item => item.SupNum == entity.SupNum);
            }
            if (entity.SupName.IsNotEmpty())
            {
                product.And("SupName", ECondition.In, "%" + entity.SupName + "%");
            }
            int rowCount = 0;
            List <ProductEntity> listResult = this.V_Sku.GetList <ProductEntity>(product, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;

            return(listResult);
        }