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;
}
}