public Model.InvoiceZZ Get(string invoiceId) { Model.InvoiceZZ invoice = accessor.Get(invoiceId); invoice.DetailsIn = invoiceZZDetailAccessor.Select("I", invoice); invoice.DetailsOut = invoiceZZDetailAccessor.Select("O", invoice); return(invoice); }
public ViewForm(Model.InvoiceZZ initZZ) : this() { if (initZZ == null) { throw new ArithmeticException("invoiceid"); } this.invoice = initZZ; }
public ViewForm(string invoiceId) : this() { this.invoice = this.invoiceZZManager.Get(invoiceId); if (this.invoice == null) { throw new ArithmeticException("invoiceid"); } }
protected override Form GetViewForm() { Model.InvoiceZZ invoice = this.SelectedItem as Model.InvoiceZZ; if (invoice != null) { return(new ViewForm(invoice.InvoiceId)); } return(null); }
public EditForm(string invoiceId) : this() { this.invoice = this.invoiceManager.Get(invoiceId); if (this.invoice == null) { throw new ArithmeticException("invoiceid"); } this.action = "update"; }
public EditForm(Model.InvoiceZZ initZZ) : this() { if (initZZ == null) { throw new ArithmeticException("invoiceid"); } this.invoice = initZZ; this.action = "update"; }
protected override void MovePrev() { Model.InvoiceZZ invoice = this.invoiceManager.GetPrev(this.invoice); if (invoice == null) { throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows); } this.invoice = this.invoiceManager.Get(invoice.InvoiceId); }
public R01_I(Model.InvoiceZZ invoice) { InitializeComponent(); invoice.DetailsIn = this.invoiceDetailManager.Select("I", invoice); this.DataSource = invoice.DetailsIn; this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceZZDetail.PROPERTY_INVOICEZZDETAILQUANTITY); this.xrTableCellNote.DataBindings.Add("Text", this.DataSource, Model.InvoiceZZDetail.PROPERTY_INVOICEZZDETAILNOTE); }
/// <summary> /// 验证单据编号,经手人,出货和收货库房等 /// </summary> private void Validate(Model.InvoiceZZ invoiceZZ) { if (string.IsNullOrEmpty(invoiceZZ.InvoiceId)) { throw new Helper.RequireValueException("Id"); } if (invoiceZZ.Employee0 == null) { throw new Helper.RequireValueException("Employee0"); } if (invoiceZZ.DetailsIn.Count == 0) { throw new Helper.RequireValueException("Details1"); } foreach (Model.InvoiceZZDetail detail in invoiceZZ.DetailsIn) { if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) { continue; } if (detail.InvoiceZZDetailZongji == 0) { throw new Helper.RequireValueException("Details1"); } } if (invoiceZZ.DetailsOut.Count == 0) { throw new Helper.RequireValueException("Details0"); } foreach (Model.InvoiceZZDetail detail in invoiceZZ.DetailsOut) { if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) { continue; } if (detail.InvoiceZZDetailZongji == 0) { throw new Helper.RequireValueException("Details0"); } } }
protected override void TurnNull() { if (this.invoice == null) { return; } if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK) { return; } this.invoiceManager.TurnNull(this.invoice.InvoiceId); this.invoice = this.invoiceManager.GetNext(this.invoice); if (this.invoice == null) { this.invoice = this.invoiceManager.GetLast(); } }
public R01(string invoiceId) { InitializeComponent(); this.invoice = this.invoiceManager.Get(invoiceId); if (this.invoice == null) { return; } this.xrLabelCompanyInfoAddress.Text = BL.Settings.CompanyAddress1; this.xrLabelCompanyInfoFAX.Text = BL.Settings.CompanyFax; this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName + Properties.Resources.InvoiceZZ; this.xrLabelCompanyInfoTelphone.Text = BL.Settings.CompanyPhone; this.xrLabelInvoiceId.Text = this.invoice.InvoiceId; this.xrLabelInvoiceDate.Text = this.invoice.InvoiceDate.Value.ToString(); this.xrSubreport1.ReportSource = new R01_I(invoice); this.xrSubreport2.ReportSource = new R01_O(invoice); }
protected override void AddNew() { this.invoice = new Model.InvoiceZZ(); this.invoice.InvoiceId = this.invoiceManager.GetNewId(); this.invoice.InvoiceDate = DateTime.Now; this.invoice.DetailsIn = new List <Model.InvoiceZZDetail>(); this.invoice.DetailsOut = new List <Model.InvoiceZZDetail>(); if (this.action == "insert") { Model.InvoiceZZDetail detailOut = new Model.InvoiceZZDetail(); detailOut.InvoiceZZDetailId = Guid.NewGuid().ToString(); detailOut.InvoiceZZDetailKind = "O"; detailOut.InvoiceZZDetailNote = ""; detailOut.InvoiceZZDetailPrice = 0; detailOut.InvoiceZZDetailQuantity = 0; detailOut.InvoiceZZDetailZongji = 0; detailOut.InvoiceProductUnit = ""; detailOut.Product = new Book.Model.Product(); this.invoice.DetailsOut.Add(detailOut); this.bindingSourceOut.Position = this.bindingSourceOut.IndexOf(detailOut); Model.InvoiceZZDetail detailIn = new Model.InvoiceZZDetail(); detailIn.InvoiceZZDetailId = Guid.NewGuid().ToString(); detailIn.InvoiceZZDetailKind = "I"; detailIn.InvoiceZZDetailNote = ""; detailIn.InvoiceZZDetailPrice = 0; detailIn.InvoiceZZDetailQuantity = 0; detailIn.InvoiceZZDetailZongji = 0; detailIn.InvoiceProductUnit = ""; detailIn.Product = new Book.Model.Product(); this.invoice.DetailsIn.Add(detailIn); this.bindingSourceIn.Position = this.bindingSourceIn.IndexOf(detailIn); } }
public IList <Model.InvoiceZZDetail> Select(string kind, Model.InvoiceZZ invoiceZZ) { return(accessor.Select(kind, invoiceZZ)); }
public Model.InvoiceZZ GetPrev(Model.InvoiceZZ e) { return(sqlmapper.QueryForObject <Model.InvoiceZZ>("InvoiceZZ.get_prev", e)); }
public Model.InvoiceZZ GetNext(Model.InvoiceZZ e) { return(sqlmapper.QueryForObject <Model.InvoiceZZ>("InvoiceZZ.get_next", e)); }
public bool HasRowsAfter(Model.InvoiceZZ e) { return(sqlmapper.QueryForObject <bool>("InvoiceZZ.has_rows_after", e)); }
public Model.InvoiceZZ GetNext(Model.InvoiceZZ e) { return(accessor.GetNext(e)); }
public bool HasRowsAfter(Model.InvoiceZZ e) { return(accessor.HasRowsAfter(e)); }
public override void Refresh() { if (this.invoice == null) { this.invoice = new Book.Model.InvoiceZZ(); this.action = "insert"; } else { if (this.action == "view") { this.invoice = this.invoiceManager.Get(invoice.InvoiceId); } } this.textEditInvoiceId.EditValue = this.invoice.InvoiceId; this.dateEditInvoiceDate.DateTime = this.invoice.InvoiceDate.Value; this.buttonEditEmployee.EditValue = this.invoice.Employee0; this.textEditNote.EditValue = this.invoice.InvoiceNote; this.EmpAudit.EditValue = this.invoice.AuditEmp; this.textEditAuditState.Text = this.invoice.AuditStateName; this.bindingSourceIn.DataSource = this.invoice.DetailsIn; this.bindingSourceOut.DataSource = this.invoice.DetailsOut; switch (this.action) { case "insert": this.textEditInvoiceId.Properties.ReadOnly = false; this.dateEditInvoiceDate.Properties.ReadOnly = false; this.dateEditInvoiceDate.Properties.Buttons[0].Visible = true; this.textEditNote.Properties.ReadOnly = false; this.buttonEditEmployee.ButtonReadOnly = false; this.buttonEditEmployee.ShowButton = true; this.simpleButtonAppendIn.Enabled = true; this.simpleButtonRemoveIn.Enabled = true; this.simpleButtonAppendOut.Enabled = true; this.simpleButtonRemoveOut.Enabled = true; this.gridViewIn.OptionsBehavior.Editable = true; this.gridViewOut.OptionsBehavior.Editable = true; break; case "update": this.textEditInvoiceId.Properties.ReadOnly = true; this.dateEditInvoiceDate.Properties.ReadOnly = true; this.dateEditInvoiceDate.Properties.Buttons[0].Visible = false; this.textEditNote.Properties.ReadOnly = false; this.buttonEditEmployee.ButtonReadOnly = false; this.buttonEditEmployee.ShowButton = true; this.simpleButtonAppendIn.Enabled = false; this.simpleButtonRemoveIn.Enabled = true; this.simpleButtonAppendOut.Enabled = true; this.simpleButtonRemoveOut.Enabled = true; this.gridViewIn.OptionsBehavior.Editable = true; this.gridViewOut.OptionsBehavior.Editable = true; break; case "view": this.textEditInvoiceId.Properties.ReadOnly = true; this.dateEditInvoiceDate.Properties.ReadOnly = true; this.dateEditInvoiceDate.Properties.Buttons[0].Visible = false; this.textEditNote.Properties.ReadOnly = true; this.buttonEditEmployee.ButtonReadOnly = true; this.buttonEditEmployee.ShowButton = false; this.simpleButtonAppendIn.Enabled = false; this.simpleButtonRemoveIn.Enabled = false; this.simpleButtonAppendOut.Enabled = false; this.simpleButtonRemoveOut.Enabled = false; this.gridViewIn.OptionsBehavior.Editable = false; this.gridViewOut.OptionsBehavior.Editable = false; break; default: break; } base.Refresh(); }
protected override void MoveLast() { this.invoice = this.invoiceManager.Get(this.invoiceManager.GetLast() == null ? "" : this.invoiceManager.GetLast().InvoiceId); }
public bool HasRowsBefore(Model.InvoiceZZ e) { return(accessor.HasRowsBefore(e)); }
private void _Update(Model.InvoiceZZ invoice) { _ValidateForUpdate(invoice); Model.InvoiceZZ invoiceOriginal = this.Get(invoice.InvoiceId); switch ((Helper.InvoiceStatus)invoiceOriginal.InvoiceStatus) { case Helper.InvoiceStatus.Draft: switch ((Helper.InvoiceStatus)invoice.InvoiceStatus) { case Helper.InvoiceStatus.Draft: invoice.UpdateTime = DateTime.Now; accessor.Update(invoice); invoiceZZDetailAccessor.Delete(invoiceOriginal); foreach (Model.InvoiceZZDetail detail in invoice.DetailsIn) { if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) { continue; } detail.InvoiceZZDetailId = Guid.NewGuid().ToString(); detail.InvoiceId = invoice.InvoiceId; invoiceZZDetailAccessor.Insert(detail); } foreach (Model.InvoiceZZDetail detail in invoice.DetailsOut) { if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) { continue; } detail.InvoiceZZDetailId = Guid.NewGuid().ToString(); detail.InvoiceId = invoice.InvoiceId; invoiceZZDetailAccessor.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); accessor.Delete(invoiceOriginal.InvoiceId); invoice.InsertTime = invoiceOriginal.InsertTime; invoice.UpdateTime = DateTime.Now; _Insert(invoice); break; case Helper.InvoiceStatus.Null: Model.InvoiceZZDetail itemIn = invoice.DetailsIn[0]; Model.Product product = itemIn.Product; //if (itemIn.InvoiceProductUnit == product.ProductOuterPackagingUnit) //{ // product.ProductCurrentCGPrice = itemIn.InvoiceZZDetailPrice / Convert.ToDecimal(product.ProductBaseUnitRelationship.Value) / Convert.ToDecimal(product.ProductInnerUnitRelationship.Value); // zzInQuantity = itemIn.InvoiceZZDetailQuantity * product.ProductBaseUnitRelationship * product.ProductInnerUnitRelationship; //} //else if (itemIn.InvoiceProductUnit == product.ProductInnerPackagingUnit) //{ // product.ProductCurrentCGPrice = itemIn.InvoiceZZDetailPrice / Convert.ToDecimal(product.ProductBaseUnitRelationship.Value); // zzInQuantity = itemIn.InvoiceZZDetailQuantity * product.ProductBaseUnitRelationship; //} //else //{ // product.ProductCurrentCGPrice = itemIn.InvoiceZZDetailPrice; // zzInQuantity = itemIn.InvoiceZZDetailQuantity; //} //productAccessor.UpdateCost1(product, product.ProductCurrentCGPrice, -zzInQuantity); //stockAccessor.Decrement(itemIn.Depot, product, zzInQuantity.Value); foreach (Model.InvoiceZZDetail itemOut in invoice.DetailsOut) { if (itemOut.Product == null || string.IsNullOrEmpty(itemOut.Product.ProductId)) { continue; } Model.Product p = itemOut.Product; //if (itemOut.InvoiceProductUnit == itemOut.Product.ProductOuterPackagingUnit) //{ // p.ProductCurrentCGPrice = itemOut.InvoiceZZDetailPrice / Convert.ToDecimal(p.ProductBaseUnitRelationship.Value) / Convert.ToDecimal(p.ProductInnerUnitRelationship.Value); // zzOutQuantity = itemOut.InvoiceZZDetailQuantity * p.ProductBaseUnitRelationship * p.ProductInnerUnitRelationship; //} //else if (itemOut.InvoiceProductUnit == itemOut.Product.ProductInnerPackagingUnit) //{ // p.ProductCurrentCGPrice = itemOut.InvoiceZZDetailPrice / Convert.ToDecimal(p.ProductBaseUnitRelationship.Value); // zzOutQuantity = itemOut.InvoiceZZDetailQuantity * p.ProductBaseUnitRelationship; //} //else //{ // p.ProductCurrentCGPrice = itemOut.InvoiceZZDetailPrice; // zzOutQuantity = itemOut.InvoiceZZDetailQuantity; //} //stockAccessor.Increment(itemOut.Depot, p, zzOutQuantity.Value * itemIn.InvoiceZZDetailQuantity.Value); } break; } break; case Helper.InvoiceStatus.Null: throw new InvalidOperationException(); } }
public Model.InvoiceZZ GetPrev(Model.InvoiceZZ e) { return(accessor.GetPrev(e)); }
private void _Insert(Model.InvoiceZZ invoice) { _ValidateForInsert(invoice); invoice.Employee0Id = invoice.Employee0.EmployeeId; invoice.Employee1Id = invoice.Employee1.EmployeeId; if ((Helper.InvoiceStatus)invoice.InvoiceStatus.Value == Helper.InvoiceStatus.Normal) { invoice.Employee2Id = invoice.Employee2.EmployeeId; invoice.InvoiceGZTime = DateTime.Now; } accessor.Insert(invoice); //插入收货商品明细 Model.InvoiceZZDetail itemIn = invoice.DetailsIn[0]; if (itemIn.Product == null || string.IsNullOrEmpty(itemIn.Product.ProductId)) { } else { //itemIn.DepotId = itemIn.Depot.DepotId; Model.Product product = itemIn.Product; //if (itemIn.InvoiceProductUnit == product.ProductOuterPackagingUnit) //{ // product.ProductCurrentCGPrice = itemIn.InvoiceZZDetailPrice / Convert.ToDecimal(product.ProductBaseUnitRelationship.Value) / Convert.ToDecimal(product.ProductInnerUnitRelationship.Value); // quantity = itemIn.InvoiceZZDetailQuantity * product.ProductBaseUnitRelationship * product.ProductInnerUnitRelationship; //} //else if (itemIn.InvoiceProductUnit == product.ProductInnerPackagingUnit) //{ // product.ProductCurrentCGPrice = itemIn.InvoiceZZDetailPrice / Convert.ToDecimal(product.ProductBaseUnitRelationship.Value); // quantity = itemIn.InvoiceZZDetailQuantity * product.ProductBaseUnitRelationship; //} //else //{ // product.ProductCurrentCGPrice = itemIn.InvoiceZZDetailPrice; // quantity = itemIn.InvoiceZZDetailQuantity; //} itemIn.InvoiceId = invoice.InvoiceId; //productAccessor.UpdateCost1(product, product.ProductCurrentCGPrice,quantity); //stockAccessor.Increment(itemIn.Depot, itemIn.Product, quantity.Value); invoiceZZDetailAccessor.Insert(itemIn); } //插入出库商品明细 foreach (Model.InvoiceZZDetail itemOut in invoice.DetailsOut) { if (itemOut.Product == null || string.IsNullOrEmpty(itemOut.Product.ProductId)) { continue; } //itemOut.DepotId = itemOut.Depot.DepotId; Model.Product p = itemOut.Product; //if (itemOut.InvoiceProductUnit == itemOut.Product.ProductOuterPackagingUnit) //{ // p.ProductCurrentCGPrice = itemOut.InvoiceZZDetailPrice / Convert.ToDecimal(p.ProductBaseUnitRelationship.Value) / Convert.ToDecimal(p.ProductInnerUnitRelationship.Value); // zsQuantity = itemOut.InvoiceZZDetailQuantity * p.ProductBaseUnitRelationship * p.ProductInnerUnitRelationship; //} //else if (itemOut.InvoiceProductUnit == itemOut.Product.ProductInnerPackagingUnit) //{ // p.ProductCurrentCGPrice = itemOut.InvoiceZZDetailPrice / Convert.ToDecimal(p.ProductBaseUnitRelationship.Value); // zsQuantity = itemOut.InvoiceZZDetailQuantity * p.ProductBaseUnitRelationship; //} //else //{ // p.ProductCurrentCGPrice = itemOut.InvoiceZZDetailPrice; // zsQuantity = itemOut.InvoiceZZDetailQuantity; //} //stockAccessor.Decrement(itemOut.Depot, p, zsQuantity.Value * itemIn.InvoiceZZDetailQuantity.Value); itemOut.InvoiceId = invoice.InvoiceId; invoiceZZDetailAccessor.Insert(itemOut); } }
public void Insert(Model.InvoiceZZ e) { this.Insert <Model.InvoiceZZ>(e); }
public bool HasRowsBefore(Model.InvoiceZZ e) { return(sqlmapper.QueryForObject <bool>("InvoiceZZ.has_rows_before", e)); }
public void Update(Model.InvoiceZZ e) { this.Update <Model.InvoiceZZ>(e); }
private void _TurnNormal(Model.InvoiceZZ invoice) { invoice.InvoiceStatus = (int)Helper.InvoiceStatus.Normal; _Update(invoice); }