private void btnAdd_Click(object sender, EventArgs e)
{
XS.SearcharInvoiceXSForm f = new Book.UI.Invoices.XS.SearcharInvoiceXSForm();
if (f.ShowDialog(this) == DialogResult.OK)
{
if (f.key != null && f.key.Count > 0)
{
foreach (Model.InvoiceXODetail detail in f.key)
{
invoicezx = new Book.Model.InvoiceZX();
invoicezx.InvoiceZXId = Guid.NewGuid().ToString();
invoicezx.ParentInvoceZXId = null;
invoicezx.Product = detail.Product;
invoicezx.ProductId = detail.ProductId;
invoicezx.Customer = detail.Invoice.Customer;
invoicezx.CustomerId = detail.Invoice.CustomerId;
invoicezx.XOcustomer = detail.Invoice.xocustomer;
invoicezx.XOcustomerId = detail.Invoice.xocustomerId;
invoicezx.UNITPRICE = detail.InvoiceXODetailPrice;
//this.HasPackingNum = this.invoicezxmenager.SelectHasPackingNum(detail.ProductId);
invoicezx.ProductNum = Convert.ToDouble(detail.InvoiceXODetailQuantity0);
LInvoiceZXList.Add(invoicezx);
}
}
this.bindingSourceXO.DataSource = LInvoiceZXList;
this.gridControl6.RefreshDataSource();
this.bindingSourceXO.Position = this.bindingSourceXO.IndexOf(invoicezx);
}
f.Dispose();
GC.Collect();
}
public void Update(Model.InvoiceZX invoiceZX)
{
//
// todo: add other logic here.
//
invoiceZX.UpdateTime = DateTime.Now;
accessor.Update(invoiceZX);
}
public void Insert(Model.InvoiceZX invoiceZX)
{
//
// todo:add other logic here
//
//
invoiceZX.InsertTime = DateTime.Now;
invoiceZX.UpdateTime = DateTime.Now;
accessor.Insert(invoiceZX);
}
private void gridView5_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
Model.InvoiceZX invoicezx = bindingSourceDetail.Current as Model.InvoiceZX;
if (invoicezx.PackingId != null)
{
foreach (Model.InvoiceZX detail in RInvoiceZXList)
{
if (invoicezx.PackingId == detail.PackingId && invoicezx.InvoiceZXId != detail.InvoiceZXId)
{
invoicezx.PackingId = null;
MessageBox.Show(Properties.Resources.EntityExists, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
}
private void btnCheckInvoiceZX_Click(object sender, EventArgs e)
{
ZX.PackingForm f = new Book.UI.Invoices.ZX.PackingForm("Check");
if (f.ShowDialog(this) == DialogResult.OK)
{
if (f.checkedInvoicezx != null && f.checkedInvoicezx.Count > 0)
{
foreach (Model.InvoiceZX zx in f.checkedInvoicezx)
{
Model.InvoiceZGDetail detail = new Book.Model.InvoiceZGDetail();
detail.InvoiceZGDetailId = Guid.NewGuid().ToString();
detail.InvoiceZGId = this._invoiceZG.InvoiceZGId;
detail.InvoiceZXId = zx.InvoiceZXId;
detail.InvoiceZX = zx;
//detail.InvoiceZX.PackingId = zx.PackingId;
//detail.InvoiceZX.InvoiceNote = zx.InvoiceNote;
//detail.InvoiceZX.PackingNum = zx.PackingNum;
//detail.InvoiceZX.BWeight = zx.BWeight;
//detail.InvoiceZX.AllWeight = zx.AllWeight;
//detail.InvoiceZX.UNITPRICE = zx.UNITPRICE;
this._invoiceZG.Details.Add(detail);
}
}
if (f.checkedInvoicezx != null && f.checkedInvoicezx.Count == 0)
{
Model.InvoiceZX zx = f.SelectedItem as Model.InvoiceZX;
Model.InvoiceZGDetail detail = new Book.Model.InvoiceZGDetail();
detail.InvoiceZGDetailId = Guid.NewGuid().ToString();
detail.InvoiceZGId = this._invoiceZG.InvoiceZGId;
detail.InvoiceZXId = zx.InvoiceZXId;
detail.InvoiceZX = zx;
//detail.InvoiceZX.PackingId = zx.PackingId;
//detail.InvoiceZX.InvoiceNote = zx.InvoiceNote;
//detail.InvoiceZX.PackingNum = zx.PackingNum;
//detail.InvoiceZX.BWeight = zx.BWeight;
//detail.InvoiceZX.AllWeight = zx.AllWeight;
//detail.InvoiceZX.UNITPRICE = zx.UNITPRICE;
this._invoiceZG.Details.Add(detail);
}
}
this.bindingSourceDetail.DataSource = this._invoiceZG.Details;
this.bindingSourceDetail.MoveLast();
this.gridControl1.RefreshDataSource();
//Refresh();
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (bindingSourceXO.Current != null)
{
Model.InvoiceZX zx = this.bindingSourceXO.Current as Model.InvoiceZX;
this.LInvoiceZXList.Remove(zx);
while (this.RInvoiceZXList != null && this.RInvoiceZXList.Where(d => d.ParentInvoceZXId == zx.InvoiceZXId).ToList <Model.InvoiceZX>().Count > 0)
{
this.RInvoiceZXList.Remove(this.RInvoiceZXList.Where(d => d.ParentInvoceZXId == zx.InvoiceZXId).ToList <Model.InvoiceZX>().Last <Model.InvoiceZX>());
}
if (this.bindingSourceXO.DataSource == null || this.bindingSourceXO.Count == 0)
{
this.RInvoiceZXList = null;
this.bindingSourceDetail.DataSource = null;
}
this.gridControl5.RefreshDataSource();
this.gridControl6.RefreshDataSource();
}
}
public RO(Model.InvoiceZX invoiceZX)
: this()
{
if (invoiceZX != null)
{
this.xrBarCode1.Text = invoiceZX.InvoiceZXId;
this.lblCompanyName.Text = BL.Settings.CompanyChineseName;
this.lblROPacking.Text = Properties.Resources.XSPacking;
this.lblPrintDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.lblPackingId.Text = invoiceZX.PackingId;
this.lblPackingdate.Text = invoiceZX.InvoiceDate != null?invoiceZX.InvoiceDate.Value.ToString("yyyy-MM-dd") : null;
if (invoiceZX.Customer != null)
{
this.lblCustomer.Text = invoiceZX.Customer.ToString();
}
this.lblLong.Text = invoiceZX.BLong.ToString();
this.lblWidth.Text = invoiceZX.BWide.ToString();
this.lblHeigth.Text = invoiceZX.BHigh.ToString();
if (invoiceZX.AllWeight != null)
{
this.lblWeigth.Text = invoiceZX.AllWeight.ToString();
}
if (invoiceZX.BWeight != null)
{
this.lblAllWeight.Text = invoiceZX.BWeight.ToString();
}
this.lblNote.Text = invoiceZX.InvoiceNote;
if (invoiceZX.Employee != null)
{
this.lblEmployee.Text = invoiceZX.Employee.ToString();
}
this.DataSource = invoiceZX.Details;
tcProduct.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
tcInvoiceXODetailId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXO.PRO_CustomerInvoiceXOId);
tcNum.DataBindings.Add("Text", this.DataSource, Model.InvoiceZXDetail.PRO_ProductNum);
tcNote.DataBindings.Add("Text", this.DataSource, Model.InvoiceZXDetail.PRO_InvoiceZXDetailNote);
}
}
/// <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;
}
}
private void gridView4_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column.Name == "check")
{
Model.InvoiceZX invoicezx = this.bindingSourceRecord.Current as Model.InvoiceZX;
if ((bool)e.Value)
{
checkedInvoicezx.Add(invoicezx);
}
if (!(bool)e.Value)
{
foreach (Model.InvoiceZX zx in checkedInvoicezx)
{
if (zx.InvoiceZXId == invoicezx.InvoiceZXId)
{
checkedInvoicezx.Remove(invoicezx);
}
break;
}
}
}
}
public void Update(Model.InvoiceZX e)
{
this.Update <Model.InvoiceZX>(e);
}
public Model.InvoiceZX GetPrev(Model.InvoiceZX e)
{
return(accessor.GetPrev(e));
}
public Model.InvoiceZX GetPrev(Model.InvoiceZX e)
{
return(sqlmapper.QueryForObject <Model.InvoiceZX>("InvoiceZX.get_prev", e));
}
public Model.InvoiceZX GetNext(Model.InvoiceZX e)
{
return(sqlmapper.QueryForObject <Model.InvoiceZX>("InvoiceZX.get_next", e));
}
public bool HasRowsAfter(Model.InvoiceZX e)
{
return(sqlmapper.QueryForObject <bool>("InvoiceZX.has_rows_after", e));
}
public bool HasRowsBefore(Model.InvoiceZX e)
{
return(sqlmapper.QueryForObject <bool>("InvoiceZX.has_rows_before", e));
}
public bool HasRowsBefore(Model.InvoiceZX e)
{
return(accessor.HasRowsBefore(e));
}
public bool HasRowsAfter(Model.InvoiceZX e)
{
return(accessor.HasRowsAfter(e));
}
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 Model.InvoiceZX GetNext(Model.InvoiceZX e)
{
return(accessor.GetNext(e));
}
public void Insert(Model.InvoiceZX e)
{
this.Insert <Model.InvoiceZX>(e);
}
