private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.ListSourceRowIndex < 0)
{
return;
}
Model.CustomerProducts p = null;
IList <Model.InvoiceXSDetail> details = this.bindingSource1.DataSource as IList <Model.InvoiceXSDetail>;
if (details == null || details.Count <= 0)
{
return;
}
p = details[e.ListSourceRowIndex].PrimaryKey;
if (p == null)
{
return;
}
switch (e.Column.Name)
{
case "colProductId":
e.DisplayText = p.CustomerProductId;
break;
}
}
/// <summary>
/// Delete CustomerProducts by primary key.
/// </summary>
public void Delete(Model.CustomerProducts customerProducts)
{
//
// todo:add other logic here
//
try
{
BL.V.BeginTransaction();
accessor.Delete(customerProducts.PrimaryKeyId);
//指定客户产品对应产品编号
//添加的客户产品名稱添加至产品表CustomerProductName 字段
productAccessor.Delete(customerProducts.CustomerProductProceName);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void simpleButtonAppend_Click(object sender, EventArgs e)
{
Model.Customer customer = this.buttonEditCompany.EditValue as Model.Customer;
if (customer == null)
{
MessageBox.Show("Õˆßx„t¿Í‘ô£¡", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
this.bindingSource2.DataSource = this.customerProductManager.Select(customer);
Book.UI.Settings.BasicData.Customs.ChooseCustomerProductForm f = new Book.UI.Settings.BasicData.Customs.ChooseCustomerProductForm(customer);
if (f.ShowDialog(this) == DialogResult.OK)
{
Model.InvoiceZSDetail detail = new Book.Model.InvoiceZSDetail();
detail.InvoiceZSDetailId = Guid.NewGuid().ToString();
detail.Invoice = this.invoice;
// detail.Product = f.SelectedItem as Model.CustomerProducts;
Model.CustomerProducts product = f.SelectedItem as Model.CustomerProducts;
detail.PrimaryKey = product;
detail.PrimaryKeyId = product.PrimaryKeyId;
//detail.InvoiceProductUnit = detail.Product.ProductBaseUnit;
detail.InvoiceZSDetailQuantity = 0;
detail.InvoiceZSDetailPrice = decimal.Zero;
detail.InvoiceZSDetailMoney = decimal.Zero;
detail.InvoiceZSDetailNote = "";
this.invoice.Details.Add(detail);
this.gridControl1.RefreshDataSource();
this.bindingSource1.Position = this.bindingSource1.IndexOf(detail);
}
}
private void gridView1_ShowingEditor(object sender, CancelEventArgs e)
{
if (this.gridView1.FocusedColumn.Name == "gridColumn1")
{
if (this.gridView1.FocusedColumn.ColumnEdit is DevExpress.XtraEditors.Repository.RepositoryItemComboBox)
{
Model.CustomerProducts p = (this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as Model.InvoiceZSDetail).PrimaryKey;
this.repositoryItemComboBox1.Items.Clear();
// if (!string.IsNullOrEmpty(p.UnitGroup))
{
BL.ProductUnitManager manager = new Book.BL.ProductUnitManager();
IList <Model.ProductUnit> unitList = manager.Select(p.UnitGroup);
foreach (Model.ProductUnit item in unitList)
{
this.repositoryItemComboBox1.Items.Add(item.CnName);
}
}
//if (!string.IsNullOrEmpty(p.ProductBaseUnit))
//{
// this.repositoryItemComboBox1.Items.Add(p.ProductBaseUnit);
//}
//if (!string.IsNullOrEmpty(p.ProductInnerPackagingUnit))
//{
// this.repositoryItemComboBox1.Items.Add(p.ProductInnerPackagingUnit);
//}
//if (!string.IsNullOrEmpty(p.ProductOuterPackagingUnit))
//{
// this.repositoryItemComboBox1.Items.Add(p.ProductOuterPackagingUnit);
//}
}
}
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
Model.InvoiceZSDetail detail = this.gridView1.GetRow(e.RowHandle) as Model.InvoiceZSDetail;
if (e.Column == this.gridproductId)
{
if (detail != null)
{
Model.CustomerProducts p = customerProductManager.Get(e.Value.ToString());
detail.InvoiceZSDetailId = Guid.NewGuid().ToString();
detail.InvoiceZSDetailMoney = 0;
detail.InvoiceZSDetailNote = "";
detail.InvoiceZSDetailPrice = 0;
detail.InvoiceZSDetailQuantity = 0;
detail.PrimaryKey = p;
detail.PrimaryKeyId = p.PrimaryKeyId;
//detail.InvoiceProductUnit = detail.Product.ProductBaseUnit;
this.bindingSource1.Position = this.bindingSource1.IndexOf(detail);
}
this.gridControl1.RefreshDataSource();
}
if (e.Column == this.gridColumnDepotPisition)
{
if (detail != null)
{
Model.DepotPosition position = new BL.DepotPositionManager().Get(e.Value.ToString());
detail.DepotPosition = position;
detail.DepotPositionId = position.DepotPositionId;
}
this.gridControl1.RefreshDataSource();
}
}
public void MyClick(ref ChooseItem item)
{
ChooseCustomerProductForm f = new ChooseCustomerProductForm(_customer);
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Model.CustomerProducts customer = f.SelectedItem as Model.CustomerProducts;
item = new ChooseItem(customer, customer.CustomerProductId, customer.CustomerProductName);
}
}
/// <summary>
/// Select by primary key.
/// </summary>
public Model.CustomerProducts Get(string primaryKeyId)
{
Model.CustomerProducts product = accessor.Get(primaryKeyId);
if (product != null)
{
//product.CustomerProductProcessList = SelectProcessCategory(product);
//product.CustomerProductsBomInfos = SelectBomInfos(product);
}
return(product);
}
public void MyLeave(ref ChooseItem item)
{
BL.CustomerProductsManager manager = new Book.BL.CustomerProductsManager();
Model.CustomerProducts customer = manager.GetById(item.ButtonText);
if (customer != null)
{
item.EditValue = customer;
item.LabelText = customer.CustomerProductName;
item.ButtonText = customer.CustomerProductId;
}
}
/// <summary>
/// 货品编号开始区间
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonEditProductStart_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
string customerStart = string.IsNullOrEmpty(this.buttonEditCustomerStart.Text) ? "" : this.buttonEditCustomerStart.Text;
string customerEnd = string.IsNullOrEmpty(this.buttonEditCustomerEnd.Text) ? "zzzzzzz" : this.buttonEditCustomerEnd.Text;
Settings.BasicData.Customs.ChooseCustomerProductForm f = new Settings.BasicData.Customs.ChooseCustomerProductForm(customerStart, customerEnd);
if (f.ShowDialog(this) == DialogResult.OK)
{
Model.CustomerProducts product = f.SelectedItem as Model.CustomerProducts;
if (product != null)
{
this.buttonEditProductStart.Text = product.CustomerProductId;
}
}
}
private void gridView1_ShowingEditor(object sender, CancelEventArgs e)
{
if (this.gridView1.FocusedColumn.Name == this.colInvoiceProductUnit.Name)
{
if (this.gridView1.FocusedColumn.ColumnEdit is DevExpress.XtraEditors.Repository.RepositoryItemComboBox)
{
Model.CustomerProducts p = (this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as Model.InvoiceXJDetail).PrimaryKey;
this.repositoryItemComboBox1.Items.Clear();
IList <Model.ProductUnit> units = productUnitManager.Select(p.UnitGroupId);
foreach (Model.ProductUnit ut in units)
{
this.repositoryItemComboBox1.Items.Add(ut.CnName);
}
}
}
}
private void Validate(Model.CustomerProducts customerProducts)
{
if (string.IsNullOrEmpty(customerProducts.CustomerProductId))
{
throw new Helper.RequireValueException(Model.CustomerProducts.PRO_CustomerProductId);
}
if (customerProducts.Customer == null)
{
throw new Helper.RequireValueException(Model.CustomerProducts.PRO_CustomerId);
}
if (string.IsNullOrEmpty(customerProducts.ProductId))
{
throw new Helper.RequireValueException(Model.CustomerProducts.PRO_ProductId);
}
//if (this.IsExistsCustomerProductId(customerProducts.CustomerProductId, customerProducts.PrimaryKeyId))
// throw new Helper.MessageValueException("商品型號已經存在！");
}
/// <summary>
/// 计算装箱记录
/// </summary>
/// <param name="invoicezx"></param>
/// <param name="产品数量"></param>
/// <param name="装箱编号或日期不为空的记录条数"></param>
private void DetailAdd(Model.InvoiceZX invoicezx, int BoxNum, int detailnum, Model.CustomerProducts cp)
{
for (int i = 0; i < BoxNum - detailnum; i++)
{
Model.InvoiceZX Rinvoicezx = new Book.Model.InvoiceZX();
Rinvoicezx.InvoiceZXId = Guid.NewGuid().ToString();
Rinvoicezx.ParentInvoceZXId = invoicezx.InvoiceZXId;
Rinvoicezx.Product = invoicezx.Product;
Rinvoicezx.ProductId = invoicezx.ProductId;
Rinvoicezx.Customer = invoicezx.Customer;
Rinvoicezx.CustomerId = invoicezx.CustomerId;
Rinvoicezx.XOcustomer = invoicezx.XOcustomer;
Rinvoicezx.XOcustomerId = invoicezx.XOcustomerId;
Rinvoicezx.PackingNum = cp.PackingSpecification;
Rinvoicezx.UNITPRICE = invoicezx.UNITPRICE;
//if (i == BoxNum - detailnum - 1 && invoicezx.ProductNum % cp.PackingSpecification != 0)
// Rinvoicezx.PackingNum = invoicezx.ProductNum % cp.PackingSpecification;
if (cp != null)
{
Rinvoicezx.BLong = cp.BLong;
Rinvoicezx.BWide = cp.BWide;
Rinvoicezx.BHigh = cp.BHigh;
Rinvoicezx.BWeight = cp.JWeight;
Rinvoicezx.AllWeight = cp.MWeight;
Rinvoicezx.Caiji = cp.Caiji;
}
RInvoiceZXList.Add(Rinvoicezx);
}
for (int n = 0; n < detailnum - BoxNum; n++)
{
this.RInvoiceZXList.Remove(this.RInvoiceZXList.Where(d => d.ParentInvoceZXId == invoicezx.InvoiceZXId).ToList <Model.InvoiceZX>().Last <Model.InvoiceZX>());
}
if (invoicezx.ProductNum % cp.PackingSpecification != 0)
{
this.RInvoiceZXList.Where(d => d.ParentInvoceZXId == invoicezx.InvoiceZXId).ToList <Model.InvoiceZX>().Last <Model.InvoiceZX>().PackingNum = invoicezx.ProductNum % cp.PackingSpecification;
}
}
public void Update(Model.CustomerProducts e)
{
this.Update <Model.CustomerProducts>(e);
}
/// <summary>
/// 添加客户订单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButton1_Click(object sender, EventArgs e)
{
XS.SearcharInvoiceXSForm f = new Book.UI.Invoices.XS.SearcharInvoiceXSForm();
Model.CustomerProducts cp = null;
if (f.ShowDialog(this) == DialogResult.OK)
{
if (f.key != null && f.key.Count > 0)
{
Model.CustomerMarks mark = null;
Model.InvoicePackingDetail packingDetail = null;
//if (this._invoicePacking.Details != null && this._invoicePacking.Details.Count > 1)
//Id = 65 + this._invoicePacking.Details.Count;
foreach (Model.InvoiceXODetail detail in f.key)
{
if (this._invoicePacking.Details.Where(d => d.InvoiceXODetailId == detail.InvoiceXODetailId).ToList().Count > 0)
{
MessageBox.Show("已存在相同的訂單！", this.Text, MessageBoxButtons.OK);
continue;
}
packingDetail = new Book.Model.InvoicePackingDetail();
//packingDetail.InvoicePackingDetailId = this._invoicePackingDetailManager.GetId();
//this._invoicePackingDetailManager.TiGuiExists(packingDetail);
packingDetail.InvoicePackingDetailId = Guid.NewGuid().ToString();
packingDetail.InvoicePackingId = this._invoicePacking.InvoicePackingId;
packingDetail.HandbookId = detail.HandbookId;
packingDetail.HandbookProductId = detail.HandbookProductId;
packingDetail.Product = detail.Product;
packingDetail.ProductId = detail.ProductId;
packingDetail.Customer = detail.Invoice.Customer;
packingDetail.CustomerId = detail.Invoice.CustomerId;
packingDetail.XOCustomer = detail.Invoice.xocustomer;
packingDetail.XOCustomerId = detail.Invoice.xocustomerId;
packingDetail.UnitPrice = detail.InvoiceXODetailPrice;
packingDetail.InvoiceXOQuantity = detail.InvoiceXODetailQuantity0 == null ? 0 : detail.InvoiceXODetailQuantity0;
packingDetail.PackingNum = packingDetail.InvoiceXOQuantity;
packingDetail.HasFPQuantity = 0;
packingDetail.Amount = Convert.ToDecimal(packingDetail.PackingNum) * packingDetail.UnitPrice;
packingDetail.InvoiceXOId = detail.InvoiceId;
packingDetail.InvoiceXODetailId = detail.InvoiceXODetailId;
packingDetail.ProductUnit = detail.InvoiceProductUnit;
packingDetail.WeightUnit = "KGS";
packingDetail.PriceUnit = "USD";
packingDetail.BGHandBookProduct = new BL.BGHandbookDetail1Manager().SelectProName(detail.HandbookId, detail.HandbookProductId);
if (detail.Invoice.CustomerMarks != null && this._invoicePacking.Marks.Where(d => d.CustomerMarksName == detail.Invoice.CustomerMarks).ToList().Count < 1)
{
mark = new Book.Model.CustomerMarks();
mark.CustomerMarksId = Guid.NewGuid().ToString();
mark.InvoicePackingId = this._invoicePacking.InvoicePackingId;
mark.CustomerMarksName = detail.Invoice.CustomerMarks;
this._invoicePacking.Marks.Add(mark);
}
if (packingDetail.Product != null && !(string.IsNullOrEmpty(packingDetail.Product.CustomerProductName)) && !(string.IsNullOrEmpty(packingDetail.Product.CustomerId)))
{
cp = new BL.CustomerProductsManager().SelectByCustomerProductProceId(packingDetail.ProductId);
}
if (cp != null)
{
packingDetail.BLong = cp.BLong;
packingDetail.BWidth = cp.BWide;
packingDetail.BHeight = cp.BHigh;
packingDetail.UnitJWeight = cp.JWeight;
packingDetail.UnitMWeight = cp.MWeight;
packingDetail.UnitCaiji = cp.Caiji;
packingDetail.UnitNum = cp.PackingSpecification;
if (packingDetail.UnitNum > packingDetail.InvoiceXOQuantity)
{
packingDetail.BoxNum = 1;
packingDetail.AllJweight = Math.Round((double)(packingDetail.UnitJWeight * packingDetail.InvoiceXOQuantity / packingDetail.UnitNum), 4);
packingDetail.AllMWeight = Math.Round((double)(packingDetail.UnitMWeight * packingDetail.InvoiceXOQuantity / packingDetail.UnitNum), 4);
packingDetail.AllCaiji = Math.Round((double)(packingDetail.UnitCaiji * packingDetail.InvoiceXOQuantity / packingDetail.UnitNum), 4);
packingDetail.PackingNum = packingDetail.InvoiceXOQuantity == null ? 0 : packingDetail.InvoiceXOQuantity;
packingDetail.Amount = Convert.ToDecimal(packingDetail.PackingNum) * packingDetail.UnitPrice;
}
else
{
packingDetail.BoxNum = Convert.ToInt32(Math.Truncate(Convert.ToDouble(detail.InvoiceXODetailQuantity0 / packingDetail.UnitNum)));
packingDetail.AllJweight = packingDetail.UnitJWeight * packingDetail.BoxNum;
packingDetail.AllMWeight = packingDetail.UnitMWeight * packingDetail.BoxNum;
packingDetail.AllCaiji = packingDetail.UnitCaiji * packingDetail.BoxNum;
packingDetail.PackingNum = (packingDetail.UnitNum * packingDetail.BoxNum) == null ? packingDetail.InvoiceXOQuantity : packingDetail.UnitNum * packingDetail.BoxNum;
packingDetail.Amount = Convert.ToDecimal(packingDetail.PackingNum) * packingDetail.UnitPrice;
}
}
//if (packingDetail.UnitNum == 0 || packingDetail.UnitNum == null)
//{
// MessageBox.Show("請設置該產品的成箱數量！\r" + (packingDetail.Product == null ? null : packingDetail.Product), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// //return;
//}
//else
//{
// packingDetail.BoxNum = (int)(detail.InvoiceXODetailQuantity0 / this.PackingSpecification);
// //packingDetail.HandPackingId = Convert.ToChar(Id).ToString() + " 1" + "-" + packingDetail.BoxNum.ToString();
// packingDetail.PackingNum = this.PackingSpecification * packingDetail.BoxNum;
// packingDetail.AllJweight = packingDetail.UnitJWeight * packingDetail.BoxNum;
// packingDetail.AllMWeight = packingDetail.UnitMWeight * packingDetail.BoxNum;
// packingDetail.AllCaiji = packingDetail.UnitCaiji * packingDetail.BoxNum;
//}
this._invoicePacking.Details.Add(packingDetail);
if (packingDetail.UnitNum > 0 && packingDetail.InvoiceXOQuantity % packingDetail.UnitNum != 0 && packingDetail.UnitNum < packingDetail.InvoiceXOQuantity)
{
Model.InvoicePackingDetail invoicePackingDetail = new Book.Model.InvoicePackingDetail();
//invoicePackingDetail.InvoicePackingDetailId = this._invoicePackingDetailManager.GetId();
//this._invoicePackingDetailManager.TiGuiExists(invoicePackingDetail);
invoicePackingDetail.InvoicePackingDetailId = Guid.NewGuid().ToString();
invoicePackingDetail.InvoicePackingId = this._invoicePacking.InvoicePackingId;
invoicePackingDetail.HandbookId = detail.HandbookId;
invoicePackingDetail.HandbookProductId = detail.HandbookProductId;
invoicePackingDetail.Product = packingDetail.Product;
invoicePackingDetail.ProductId = packingDetail.ProductId;
invoicePackingDetail.Customer = packingDetail.Customer;
invoicePackingDetail.CustomerId = packingDetail.CustomerId;
invoicePackingDetail.XOCustomer = packingDetail.XOCustomer;
invoicePackingDetail.XOCustomerId = packingDetail.XOCustomerId;
invoicePackingDetail.UnitPrice = packingDetail.UnitPrice;
invoicePackingDetail.InvoiceXOQuantity = detail.InvoiceXODetailQuantity0 == null ? 0 : detail.InvoiceXODetailQuantity0;
invoicePackingDetail.PackingNum = invoicePackingDetail.InvoiceXOQuantity % packingDetail.UnitNum;
invoicePackingDetail.HasFPQuantity = 0;
invoicePackingDetail.Amount = Convert.ToDecimal(invoicePackingDetail.PackingNum) * invoicePackingDetail.UnitPrice;
invoicePackingDetail.ProductUnit = packingDetail.ProductUnit;
invoicePackingDetail.BoxNum = 1;
invoicePackingDetail.BLong = packingDetail.BLong;
invoicePackingDetail.BWidth = packingDetail.BWidth;
invoicePackingDetail.BHeight = packingDetail.BHeight;
invoicePackingDetail.UnitJWeight = Math.Round((double)(packingDetail.UnitJWeight * invoicePackingDetail.PackingNum / packingDetail.UnitNum), 4);
invoicePackingDetail.UnitMWeight = Math.Round((double)(packingDetail.UnitMWeight * invoicePackingDetail.PackingNum / packingDetail.UnitNum), 4);
invoicePackingDetail.UnitCaiji = Math.Round((double)(packingDetail.UnitCaiji * invoicePackingDetail.PackingNum / packingDetail.UnitNum), 4);
invoicePackingDetail.AllJweight = invoicePackingDetail.UnitJWeight;
invoicePackingDetail.AllMWeight = invoicePackingDetail.UnitMWeight;
invoicePackingDetail.AllCaiji = invoicePackingDetail.UnitCaiji;
invoicePackingDetail.WeightUnit = "KGS";
invoicePackingDetail.PriceUnit = "USD";
invoicePackingDetail.BGHandBookProduct = packingDetail.BGHandBookProduct;
this._invoicePacking.Details.Add(invoicePackingDetail);
}
}
}
double amount = 0;
foreach (var item in this._invoicePacking.Details)
{
amount += Convert.ToDouble(item.Amount);
}
this.txt_TotalAmount.Text = amount.ToString();
this.bindingSourceDetail.DataSource = _invoicePacking.Details;
this.gridControl1.RefreshDataSource();
this.bindingSourceDetail.MoveLast();
}
}
/// <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;
}
}
public void Delete(Model.CustomerProducts custeomerProduct)
{
accessor.Delete(custeomerProduct);
}
public Model.CustomerProducts GetNext(Model.CustomerProducts e)
{
return(sqlmapper.QueryForObject <Model.CustomerProducts>("CustomerProducts.get_next", e));
}
public Model.CustomerProducts GetPrev(Model.CustomerProducts e)
{
return(sqlmapper.QueryForObject <Model.CustomerProducts>("CustomerProducts.get_prev", e));
}
private void _Insert(Model.InvoiceZS invoice)
{
_ValidateForInsert(invoice);
//客户
if (invoice.Customer != null)
{
invoice.CustomerId = invoice.Customer.CustomerId;
}
// 库房
//invoice.DepotId = invoice.Depot.DepotId;
//经手人
if (invoice.Employee0 != null)
{
invoice.Employee0Id = invoice.Employee0.EmployeeId;
}
//录单人
if (invoice.Employee1 != null)
{
invoice.Employee1Id = invoice.Employee1.EmployeeId;
}
if ((Helper.InvoiceStatus)invoice.InvoiceStatus.Value == Helper.InvoiceStatus.Normal)
{
//过账人
if (invoice.Employee2 != null)
{
invoice.Employee2Id = invoice.Employee2.EmployeeId;
}
//过账时间
invoice.InvoiceGZTime = DateTime.Now;
}
//插入表单
accessor.Insert(invoice);
//插入明细
foreach (Model.InvoiceZSDetail detail in invoice.Details)
{
if (detail.PrimaryKey == null || string.IsNullOrEmpty(detail.PrimaryKey.PrimaryKeyId))
{
throw new Exception("商品不為空");
}
if (detail.DepotPosition == null || detail.DepotPositionId == null)
{
throw new Exception("貨位不為空");
}
detail.InvoiceId = invoice.InvoiceId;
invoiceZSDetailAccessor.Insert(detail);
Model.CustomerProducts p = detail.PrimaryKey;
p.PrimaryKeyId = detail.PrimaryKey.PrimaryKeyId;
if (p.DepotQuantity == null)
{
p.DepotQuantity = 0;
}
if (p.OrderQuantity == null)
{
p.OrderQuantity = 0;
}
p.DepotQuantity -= detail.InvoiceZSDetailQuantity;
//更新产品表库存
customerProductsAccessor.Update(p);
}
}
public Model.CustomerProducts GetNext(Model.CustomerProducts e)
{
return(accessor.GetNext(e));
}
public Model.CustomerProducts GetPrev(Model.CustomerProducts e)
{
return(accessor.GetPrev(e));
}
public bool HasRowsAfter(Model.CustomerProducts e)
{
return(accessor.HasRowsAfter(e));
}
public bool HasRowsAfter(Model.CustomerProducts e)
{
return(sqlmapper.QueryForObject <bool>("CustomerProducts.has_rows_after", e));
}
/// <summary>
/// Update a CustomerProducts.
/// </summary>
public void Update(Model.CustomerProducts customerProducts)
{
//
// todo: add other logic here.
//
this.Validate(customerProducts);
//if (this.ExistsExcept(customerProducts))
//{
// throw new Helper.InvalidValueException(Model.CustomerProducts.PRO_CustomerProductId);
//}
try
{
BL.V.BeginTransaction();
// StringBuilder strBU = new StringBuilder();
customerProducts.UpdateTime = DateTime.Now;
customerProducts.CustomerId = customerProducts.Customer.CustomerId;
// 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;
//if (IsExistsCustomerProductId(customerProducts.CustomerProductId, customerProducts.PrimaryKeyId))
// throw new Helper.InvalidValueException(Model.CustomerProducts.PRO_CustomerProductId);
////if (SelectByCustomerIdAndProductId(customerProducts.ProductId, customerProducts.PrimaryKeyId, customerProducts.CustomerId))
// throw new Helper.InvalidValueException(Model.CustomerProducts.PRO_CustomerId);
if (this.Exists(customerProducts))
{
throw new Helper.InvalidValueException(Model.CustomerProducts.PRO_CustomerProductId + "_Exists");
}
accessor.Update(customerProducts);
//修改商品
Model.Product product = productAccessor.Get(customerProducts.CustomerProductProceName);
//指定客户产品对应产品编号
product.CustomerBeforeProductId = customerProducts.Product.ProductId;
product.CustomerBeforeProductName = customerProducts.Product.ProductName;
product.ProductName = customerProducts.Product.ProductName;
//添加的客户产品名稱添加至产品表CustomerProductName 字段
product.CustomerProductName = customerProducts.CustomerProductId;
product.Customer = customerProducts.Customer;
product.ProductDescription = customerProducts.CustomerProductDesc;
product.ProductVersion = customerProducts.Version;
product.ProductDeadDate = customerProducts.VersionDate;
product.BasedUnitGroupId = customerProducts.UnitGroupId;
product.BuyUnitId = customerProducts.BuyUnitId;
product.SellUnitId = customerProducts.SellUnitId;
product.DepotUnitId = customerProducts.DepotUnitId;
product.ProduceUnitId = customerProducts.ProduceUnitId;
product.QualityTestUnitId = customerProducts.QualityTestUnitId;
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;
productAccessor.Update(product);
//客户产品价格
Model.CustomerProductPrice customerProducrPrice = new Book.Model.CustomerProductPrice();
customerProducrPrice.CustomerId = customerProducts.CustomerId;
//customerProducrPrice.ProductId = customerProducts.ProductId;
customerProducrPrice.UpdateTime = DateTime.Now;
customerProducrPrice.CustomerProductsId = customerProducts.PrimaryKeyId;
customerProductPriceAccessor.UpdateByCustomerProductsId(customerProducrPrice);
//customerProductProcessAccessor.Delete(customerProducts);
//customerProductsBomAccessor.Delete(customerProducts);
//包装
//packageCustomerDetailsAccessor.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)
//{
// bom.PriamryKeyId = Guid.NewGuid().ToString();
// bom.ProductId = bom.Product.ProductId;
// bom.PrimaryKeyId = customerProducts.PrimaryKeyId;
// customerProductsBomAccessor.Insert(bom);
//}
//foreach (Model.PackageCustomerDetails pac in customerProducts.PackageCustomerDetails)
//{
// pac.PackageCustomerDetailsId = Guid.NewGuid().ToString();
// pac.PrimaryKeyId = customerProducts.CustomerProductId;
// packageCustomerDetailsAccessor.Insert(pac);
//}
///////////////////////////////// //加工后名称添加
//加工后名称添加
//if (strBU != null)
//{
// customerProducts.PrimaryKeyId = Guid.NewGuid().ToString();
// 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 != null)
// {
// foreach (Model.PackageCustomerDetails pac in customerProducts.PackageCustomerDetails)
// {
// if (pac != null)
// {
// pac.PackageCustomerDetailsId = Guid.NewGuid().ToString();
// pac.PrimaryKeyId = customerProducts.CustomerProductId;
// packageCustomerDetailsAccessor.Insert(pac);
// }
// }
// }
//}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void _Update(Model.InvoiceZS invoice)
{
_ValidateForUpdate(invoice);
invoice.UpdateTime = DateTime.Now;
//invoice.DepotId = invoice.Depot.DepotId;
invoice.Employee0Id = invoice.Employee0.EmployeeId;
invoice.CustomerId = invoice.Customer.CustomerId;
Model.InvoiceZS invoiceOriginal = this.Get(invoice.InvoiceId);
Helper.InvoiceStatus invoiceStatus = (Helper.InvoiceStatus)invoice.InvoiceStatus.Value;
switch ((Helper.InvoiceStatus)invoiceOriginal.InvoiceStatus)
{
case Helper.InvoiceStatus.Draft:
switch ((Helper.InvoiceStatus)invoice.InvoiceStatus)
{
case Helper.InvoiceStatus.Draft:
invoiceZSDetailAccessor.Delete(invoice);
foreach (Model.InvoiceZSDetail detail in invoice.Details)
{
if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId))
{
continue;
}
detail.InvoiceZSDetailId = Guid.NewGuid().ToString();
detail.InvoiceId = invoice.InvoiceId;
invoiceZSDetailAccessor.Insert(detail);
}
break;
case Helper.InvoiceStatus.Normal:
accessor.Delete(invoiceOriginal.InvoiceId);
invoice.InsertTime = invoiceOriginal.InsertTime;
invoice.UpdateTime = DateTime.Now;
_Insert(invoice);
break;
case Helper.InvoiceStatus.Null:
throw new InvalidOperationException();
}
break;
case Helper.InvoiceStatus.Normal:
switch ((Helper.InvoiceStatus)invoice.InvoiceStatus)
{
case Helper.InvoiceStatus.Draft:
throw new InvalidOperationException();
case Helper.InvoiceStatus.Normal:
invoiceOriginal.InvoiceStatus = (int)Helper.InvoiceStatus.Null;
_TurnNull(invoiceOriginal);
invoiceZSDetailAccessor.Delete(invoiceOriginal);
accessor.Delete(invoiceOriginal.InvoiceId);
invoice.InsertTime = invoiceOriginal.InsertTime;
invoice.UpdateTime = DateTime.Now;
_Insert(invoice);
////消除影响
//foreach (Model.InvoiceZSDetail detail in invoiceOriginal.Details)
//{
// stockAccessor.Increment(invoiceOriginal.Depot, detail.Product, detail.InvoiceZSDetailQuantity.Value);
//}
//accessor.Delete(invoiceOriginal.InvoiceId);
//invoice.InvoiceStatus = (int)Helper.InvoiceStatus.Normal;
//invoice.InsertTime = invoiceOriginal.InsertTime;
//invoice.UpdateTime = DateTime.Now;
//_Insert(invoice);
break;
case Helper.InvoiceStatus.Null:
//invoice.Employee3Id = V.ActiveEmployee.EmployeeId;
//invoice.InvoiceZFTime = DateTime.Now;
//invoice.InvoiceZFCause = "";
//accessor.Update(invoice);
//invoice.Details = invoiceZSDetailAccessor.Select(invoice);
//消除影响
foreach (Model.InvoiceZSDetail detail in invoice.Details)
{
//if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) continue;
Model.CustomerProducts p = detail.PrimaryKey;
p.PrimaryKeyId = detail.PrimaryKey.PrimaryKeyId;
if (p.DepotQuantity == null)
{
p.DepotQuantity = 0;
}
if (p.OrderQuantity == null)
{
p.OrderQuantity = 0;
}
p.DepotQuantity += detail.InvoiceZSDetailQuantity;
customerProductsAccessor.Update(p);
}
break;
}
break;
case Helper.InvoiceStatus.Null:
throw new InvalidOperationException();
}
}
private void repositoryItemSpinEdit1_EditValueChanged(object sender, EventArgs e)
{
Model.InvoiceZX invoicezx = bindingSourceXO.Current as Model.InvoiceZX;
Model.CustomerProducts cp = null;
//成箱数量
double?PackingSpecification = 0.0;
if (invoicezx.Product != null && !(string.IsNullOrEmpty(invoicezx.Product.CustomerProductName) && string.IsNullOrEmpty(invoicezx.Product.CustomerId)))
{
cp = new BL.CustomerProductsManager().SelectByCustomerProductProceId(invoicezx.ProductId);
PackingSpecification = cp.PackingSpecification;
}
if (PackingSpecification == 0 || PackingSpecification == null)
{
MessageBox.Show("請設置成箱數量！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SpinEdit spe = sender as SpinEdit;
if (spe != null)
{
invoicezx.ProductNum = Convert.ToDouble(spe.Value.ToString());
}
else
{
invoicezx.ProductNum = ((sender as BindingSource).Current as Model.InvoiceZX).ProductNum;
}
int BoxNum = (int)(invoicezx.ProductNum / PackingSpecification);
int detailnum = 0;
while (this.RInvoiceZXList != null && this.RInvoiceZXList.Where(d => d.ParentInvoceZXId == invoicezx.InvoiceZXId && string.IsNullOrEmpty(d.PackingId) && string.IsNullOrEmpty(d.InvoiceDate.ToString())).ToList <Model.InvoiceZX>().Count > 0)
{
this.RInvoiceZXList.Remove(this.RInvoiceZXList.Where(d => d.ParentInvoceZXId == invoicezx.InvoiceZXId && string.IsNullOrEmpty(d.PackingId) && string.IsNullOrEmpty(d.InvoiceDate.ToString())).ToList <Model.InvoiceZX>().Last <Model.InvoiceZX>());
}
foreach (Model.InvoiceZX detail in RInvoiceZXList)
{
if (detail.ParentInvoceZXId == invoicezx.InvoiceZXId && (!string.IsNullOrEmpty(detail.PackingId) || !string.IsNullOrEmpty(detail.InvoiceDate.ToString())))
{
detailnum += 1;
}
}
if (invoicezx.ProductNum % PackingSpecification == 0)
{
DetailAdd(invoicezx, BoxNum, detailnum, cp);
invoicezx.BoxNum = BoxNum;
}
else
{
DetailAdd(invoicezx, BoxNum + 1, detailnum, cp);
invoicezx.BoxNum = BoxNum + 1;
}
foreach (Model.InvoiceZX iz in RInvoiceZXList)
{
iz.Sequence = (RInvoiceZXList.IndexOf(iz) + 1).ToString();
}
this.bindingSourceDetail.DataSource = RInvoiceZXList;
this.gridControl5.RefreshDataSource();
this.gridControl6.RefreshDataSource();
}
public bool HasRowsBefore(Model.CustomerProducts e)
{
return(accessor.HasRowsBefore(e));
}
public bool HasRowsBefore(Model.CustomerProducts e)
{
return(sqlmapper.QueryForObject <bool>("CustomerProducts.has_rows_before", e));
}
/// <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.ProduceCounty = customerProducts.Product.ProduceCounty;
productAccessor.Insert(product);
//客户产品价格
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);
product.QualityTestUnitId = customerProducts.QualityTestUnitId;
// 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;
}
}
public void Insert(Model.CustomerProducts e)
{
this.Insert <Model.CustomerProducts>(e);
}
