Example #1
0
        private void simpleButton2_Click(object sender, EventArgs e)
        {
            string sql = "select ProductId from Product where ProductBarCode is null";
            IList <Model.Product> list = this.productManager.DataReaderBind <Model.Product>(sql, null, CommandType.Text);

            string update;

            foreach (var item in list)
            {
                try
                {
                    BL.V.BeginTransaction();

                    item.ProductBarCode = new BL.ProductBarCodeSetManager().RandomBarCode();
                    productManager.BarCodeRecursion(item);

                    update = "update Product set ProductBarCode='" + item.ProductBarCode + "' where ProductId='" + item.ProductId + "'";
                    this.productManager.UpdateSql(update);
                    productBarCodeSetManager.Increment();

                    BL.V.CommitTransaction();
                }
                catch (Exception ex)
                {
                    BL.V.RollbackTransaction();
                    MessageBox.Show(ex.Message);
                }
            }
        }
        /// <summary>
        /// Insert a CustomerProducts.
        /// </summary>
        public void Insert(Model.CustomerProducts customerProducts)
        {
            this.Validate(customerProducts);

            //if (this.Exists(customerProducts))
            //{
            //    throw new Helper.InvalidValueException(Model.CustomerProducts.PROPERTY_CUSTOMERPRODUCTNAME);
            //}
            try
            {
                BL.V.BeginTransaction();
                //保存后返回第一个ID
                // string primarykeyid =null;
                string customProductName = null;
                // StringBuilder strBU = new StringBuilder();
                customerProducts.CustomerId = customerProducts.Customer.CustomerId;
                customerProducts.InsertTime = DateTime.Now;
                //保存后返回第一个ID
                // primarykeyid = customerProducts.PrimaryKeyId;
                customProductName = customerProducts.CustomerProductName;

                // customerProducts.BuyUnitId = customerProducts.BuyUnit == null ? null : customerProducts.BuyUnit.ProductUnitId;
                customerProducts.DepotId         = customerProducts.Depot == null ? null : customerProducts.Depot.DepotId;
                customerProducts.DepotPositionId = customerProducts.DepotPosition == null ? null : customerProducts.DepotPosition.DepotPositionId;
                //customerProducts.DepotUnitId = customerProducts.DepotUnit == null ? null : customerProducts.DepotUnit.ProductUnitId;
                //// customerProducts.MainUnitId = customerProducts.MainUnit == null ? null : customerProducts.MainUnit.ProductUnitId;
                //customerProducts.ProduceUnitId = customerProducts.ProduceUnit == null ? null : customerProducts.ProduceUnit.ProductUnitId;
                //customerProducts.QualityTestUnitId = customerProducts.QualityTestUnit == null ? null : customerProducts.QualityTestUnit.ProductUnitId;
                //customerProducts.SellUnitId = customerProducts.SellUnit == null ? null : customerProducts.SellUnit.ProductUnitId;
                //customerProducts.UnitGroupId = customerProducts.UnitGroup == null ? null : customerProducts.UnitGroup.UnitGroupId;


                Model.Product product = new Book.Model.Product();// customerProducts.Product;
                product.CustomerBeforeProductId = customerProducts.Product.ProductId;
                product.ProductId = Guid.NewGuid().ToString();



                customerProducts.CustomerProductProceName = product.ProductId;//新产生的商品ID
                //if (IsExistsCustomerProductId(customerProducts.CustomerProductId, customerProducts.PrimaryKeyId))
                //    throw new Helper.InvalidValueException(Model.CustomerProducts.PRO_CustomerProductId + "_Exists");
                //if (SelectByCustomerIdAndProductId(customerProducts.ProductId, null, customerProducts.CustomerId))
                //    throw new Helper.InvalidValueException(Model.CustomerProducts.PRO_CustomerId);
                if (this.Exists(customerProducts))
                {
                    throw new Helper.InvalidValueException(Model.CustomerProducts.PRO_CustomerProductId + "_Exists");
                }

                accessor.Insert(customerProducts);
                //加入商品表

                product.IsCustomerProduct = true;

                //指定客户产品对应产品编号

                product.CustomerBeforeProductName = customerProducts.Product.ProductName;
                //添加的客户产品名稱添加至产品表CustomerProductName 字段
                product.CustomerProductName = customerProducts.CustomerProductId;
                product.Customer            = customerProducts.Customer;
                product.ProductDescription  = customerProducts.CustomerProductDesc;
                if (product.Customer != null)
                {
                    product.CustomerId = product.Customer.CustomerId;
                }
                //byte[] pic = new byte[] { };
                //if (product.ProductImage == null)
                //    product.ProductImage = pic;
                //if (product.ProductImage1 == null)
                //    product.ProductImage1 = pic;
                //if (product.ProductImage2 == null)
                //    product.ProductImage2 = pic;
                //if (product.ProductImage3 == null)
                //    product.ProductImage3 = pic;
                product.XOPriceAndRange = customerProducts.XOPrice;


                product.Id          = customerProducts.Product.Id + "{" + product.CustomerBeforeProductName + "}" + "-" + customerProducts.Version;
                product.ProductName = customerProducts.Product.ProductName;
                //product.ProductCategory = customerProducts.Product.ProductCategory;
                product.ProductCategoryId = customerProducts.Product.ProductCategoryId;
                //    product.BasedUnitGroup = customerProducts.Product.BasedUnitGroup;
                product.BasedUnitGroupId = customerProducts.Product.BasedUnitGroupId;
                //  product.BuyUnit = this.product.BuyUnit;
                product.BuyUnitId = customerProducts.BuyUnitId;
                // product.Depot = this.product.Depot;
                product.DepotId = customerProducts.DepotId;
                // product.DepotUnit = this.product.DepotUnit;
                product.DepotUnitId = customerProducts.DepotUnitId;
                //  product.ProduceUnit = this.product.ProduceUnit;
                product.ProduceUnitId = customerProducts.ProduceUnitId;
                // product.SellUnit = this.product.SellUnit;
                product.SellUnitId = customerProducts.SellUnitId;
                // product.QualityTestUnit = this.product.QualityTestUnit;
                product.QualityTestUnitId = customerProducts.QualityTestUnitId;
                // product.WeightUnitGroup = this.product.WeightUnitGroup;
                product.WeightUnitGroupId = customerProducts.Product.WeightUnitGroupId;
                // product.WeightUnit = this.product.WeightUnit;
                product.WeightUnitId         = customerProducts.Product.WeightUnitId;
                product.HomeMade             = customerProducts.Product.HomeMade;
                product.OutSourcing          = customerProducts.Product.OutSourcing;
                product.TrustOut             = customerProducts.Product.TrustOut;
                product.Consume              = customerProducts.Product.Consume;
                product.ProductBarCodeIsAuto = true;
                //product.ProductBarCode = product.Id;
                product.StocksQuantity     = 0;
                product.OrderOnWayQuantity = 0;
                product.ProductVersion     = customerProducts.Version;
                product.ProductDeadDate    = customerProducts.VersionDate;
                product.EmployeeCreator    = BL.V.ActiveOperator.Employee;
                product.EmployeeCreatorId  = product.EmployeeCreator == null ? null : product.EmployeeCreator.EmployeeId;
                product.InsertTime         = DateTime.Now;

                //商品条码
                product.ProductBarCode = ProductBarCodeSetManager.RandomBarCode();
                ProductManager.BarCodeRecursion(product);
                ProductBarCodeSetManager.Increment();

                productAccessor.Insert(product);

                //自动生成对应的BOM单
                //Model.BomParentPartInfo bom = new Book.Model.BomParentPartInfo();
                //bom.BomId = Guid.NewGuid().ToString();
                //bom.Product = product;
                //bom.ProductId = product.ProductId;
                //bom.Id = new BL.BomParentPartInfoManager().GetId();
                //bom.LossRate = 0;
                //bom.EffectiveDate = DateTime.Now;
                //bom.DefaultQuantity = 1;
                //bom.Status = 0;
                //bom.IsEdit = "*";
                //bom.InsertTime = DateTime.Now;
                //string invoiceKind = "bom".ToLower();
                //string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, bom.InsertTime.Value.Year);
                //string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, bom.InsertTime.Value.Year, bom.InsertTime.Value.Month);
                //string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, bom.InsertTime.Value.ToString("yyyy-MM-dd"));
                //string sequencekey = string.Format(invoiceKind);
                //SequenceManager.Increment(sequencekey_y);
                //SequenceManager.Increment(sequencekey_m);
                //SequenceManager.Increment(sequencekey_d);
                //SequenceManager.Increment(sequencekey);
                //bom.EmployeeAddId = BL.V.ActiveOperator.EmployeeId;

                //bomParentPartInfoAccessor.Insert(bom);

                //客户产品价格
                Model.CustomerProductPrice customerProducrPrice = new Book.Model.CustomerProductPrice();
                customerProducrPrice.CustomerProductPriceId = Guid.NewGuid().ToString();
                customerProducrPrice.CustomerId             = customerProducts.CustomerId;
                customerProducrPrice.ProductId          = product.ProductId;
                customerProducrPrice.InsertTime         = DateTime.Now;
                customerProducrPrice.UpdateTime         = DateTime.Now;
                customerProducrPrice.CustomerProductsId = customerProducts.PrimaryKeyId;
                customerProductPriceAccessor.Insert(customerProducrPrice);

                // customerProductProcessAccessor.Delete(customerProducts);

                //foreach (Model.CustomerProductProcess cpp in customerProducts.CustomerProductProcessList)
                //{
                //   if (cpp.ProcessCategory == null) continue;

                //   strBU.Append(cpp.ProcessCategory.ProcessCategoryName);
                //   cpp.CustomerProductProcessId = Guid.NewGuid().ToString();
                //   cpp.PrimaryKeyId = customerProducts.PrimaryKeyId;
                // //  if (cpp.IsCheck.Value)
                //  // {
                //       cpp.ProcessId = cpp.Process == null ? null : cpp.Process.ProcessId;
                //   //}
                //   //else
                //   //{
                //   //    cpp.ProcessId = null;
                //   //}
                //   cpp.ProcessCategoryId = cpp.ProcessCategory == null ? null : cpp.ProcessCategory.ProcessCategoryId;
                //   customerProductProcessAccessor.Insert(cpp);
                // }
                //   foreach (Model.CustomerProductsBom bom in customerProducts.CustomerProductsBomInfos)
                //  {
                //      if (bom != null)
                //       {
                //           bom.PriamryKeyId = Guid.NewGuid().ToString();
                //           if (bom.Product != null)
                //               bom.ProductId = bom.Product.ProductId;
                //           bom.PrimaryKeyId = customerProducts.PrimaryKeyId;
                //           customerProductsBomAccessor.Insert(bom);
                //       }
                //   }

                //   if (customerProducts.PackageCustomerDetails!=null)
                //   {
                //       foreach (Model.PackageCustomerDetails pac in customerProducts.PackageCustomerDetails)
                //       {
                //           if (pac != null)
                //           {
                //               pac.PackageCustomerDetailsId = Guid.NewGuid().ToString();
                //               pac.PrimaryKeyId = customerProducts.CustomerProductId;
                //               packageCustomerDetailsAccessor.Insert(pac);
                //           }
                //        }
                //   }
                /////////////////////////////////  //加工后名称添加
                //加工后名称添加
                //if (strBU.Length!= 0 )
                //{
                //    customerProducts.PrimaryKeyId = Guid.NewGuid().ToString();

                // //   customerProductProcessAccessor.Delete(customerProducts);


                //    customerProducts.CustomerProductName +=strBU.ToString();
                //    accessor.Insert(customerProducts);
                //    foreach (Model.CustomerProductProcess cpp in customerProducts.CustomerProductProcessList)
                //    {
                //        if (cpp.ProcessCategory == null) continue;
                //        strBU.Append(customerProducts.CustomerProductName);
                //        cpp.CustomerProductProcessId = Guid.NewGuid().ToString();
                //        cpp.PrimaryKeyId = customerProducts.PrimaryKeyId;
                //        //  if (cpp.IsCheck.Value)
                //        // {
                //        cpp.ProcessId = cpp.Process == null ? null : cpp.Process.ProcessId;
                //        //}
                //        //else
                //        //{
                //        //    cpp.ProcessId = null;
                //        //}
                //        cpp.ProcessCategoryId = cpp.ProcessCategory == null ? null : cpp.ProcessCategory.ProcessCategoryId;
                //        customerProductProcessAccessor.Insert(cpp);
                //    }


                //foreach (Model.CustomerProductsBom bom in customerProducts.CustomerProductsBomInfos)
                //{
                //    if (bom != null)
                //    {
                //        bom.PriamryKeyId = Guid.NewGuid().ToString();
                //        if (bom.Product != null)
                //            bom.ProductId = bom.Product.ProductId;
                //        bom.PrimaryKeyId = customerProducts.PrimaryKeyId;
                //        customerProductsBomAccessor.Insert(bom);
                //    }
                //}
                //if (customerProducts.PackageCustomerDetails.Count!= 0)
                //{
                //    foreach (Model.PackageCustomerDetails pac in customerProducts.PackageCustomerDetails)
                //    {
                //        if (pac != null)
                //        {
                //            pac.PackageCustomerDetailsId = Guid.NewGuid().ToString();
                //            pac.PrimaryKeyId = customerProducts.CustomerProductId;
                //            packageCustomerDetailsAccessor.Insert(pac);
                //        }
                //    }
                //}
                //    customerProducts.PrimaryKeyId = primarykeyid;
                //     customerProducts.CustomerProductName =customProductName;
                //}

                BL.V.CommitTransaction();
            }
            catch
            {
                BL.V.RollbackTransaction();
                throw;
            }
        }