/// <summary> /// Delete ProductScrap by primary key. /// </summary> public void Delete(string productScrapId) { // // todo:add other logic here // try { BL.V.BeginTransaction(); Model.ProductScrap model = this.GetDetails(productScrapId); //accessorDetail.DeleteByPrimaryId(productScrapId); foreach (var item in model.Details) { accessorDetail.Delete(item.ProductScrapDetailId); accessorStock.Increment(new BL.DepotPositionManager().Get(item.DepotPositionId), item.Product, Convert.ToDouble(item.ScrapQuantity)); accessorProduct.UpdateProduct_Stock(item.Product); } accessor.Delete(productScrapId); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); SequenceManager.Decrement(sequencekey_d); BL.V.CommitTransaction(); } catch (Exception ex) { BL.V.RollbackTransaction(); throw ex; } }
protected override void AddNew() { this._productScrap = new Book.Model.ProductScrap(); this._productScrap.ProductScrapId = _manager.GetIdSimple(DateTime.Now); this._productScrap.Employee = BL.V.ActiveOperator.Employee; this._productScrap.ProductScrapDate = DateTime.Now; }
public Model.ProductScrap GetDetails(string id) { Model.ProductScrap model = this.Get(id); if (model != null) { model.Details = accessorDetail.SelectByPrimaryId(id); } return(model); }
protected override void MoveNext() { Model.ProductScrap model = this._manager.GetNext(this._productScrap); if (model == null) { throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows); } this._productScrap = model; }
protected override void MoveLast() { if (this.LastFlag == 1) { this.LastFlag = 0; return; } this._productScrap = this._manager.GetLast(); }
public EditForm(Model.ProductScrap productScrap, string action) : this() { this._productScrap = productScrap; this.action = action; if (this.action == "view") { LastFlag = 1; } }
public EditForm(Model.ProductScrap productScrap) : this() { if (productScrap == null) { throw new ArithmeticException("invoiceid"); } this._productScrap = productScrap; this.action = "view"; LastFlag = 1; }
private void TiGuiExists(Model.ProductScrap model) { if (this.ExistsPrimary(model.ProductScrapId)) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); SequenceManager.Increment(sequencekey_d); model.ProductScrapId = this.GetIdSimple(model.InsertTime.Value); TiGuiExists(model); } }
protected override void Delete() { if (this._productScrap == null) { return; } if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { Model.ProductScrap model = this._manager.GetNext(this._productScrap); this._manager.Delete(this._productScrap.ProductScrapId); if (model == null) { this._productScrap = this._manager.GetLast(); } else { this._productScrap = model; } } }
public RO(Model.ProductScrap model) : this() { this.lbl_Company.Text = BL.Settings.CompanyChineseName; this.lbl_ReportName.Text = "商品報廢單"; this.lbl_ReportDate.Text += DateTime.Now.Date.ToString("yyyy-MM-dd"); this.lbl_ProductScrapId.Text = model.ProductScrapId; this.lbl_Date.Text = model.ProductScrapDate.Value.ToString("yyyy-MM-dd"); this.lbl_Employee.Text = (model.Employee == null ? "" : model.Employee.EmployeeName); this.lbl_Depot.Text = (model.Depot == null ? "" : model.Depot.DepotName); this.lbl_Note.Text = model.Note; this.DataSource = model.Details; this.TCProductId.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id); this.TCProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.TXQTY.DataBindings.Add("Text", this.DataSource, Model.ProductScrapDetail.PRO_ScrapQuantity, "{0:0.##}"); this.TCDepotPosition.DataBindings.Add("Text", this.DataSource, "DepotPosition." + Model.DepotPosition.PROPERTY_ID); this.TCNote.DataBindings.Add("Text", this.DataSource, Model.ProductScrapDetail.PRO_Note); }
/// <summary> /// Update a ProductScrap. /// </summary> public void Update(Model.ProductScrap productScrap) { // // todo: add other logic here. // try { BL.V.BeginTransaction(); Validate(productScrap); productScrap.UpdateTime = DateTime.Now; accessor.Update(productScrap); //accessorDetail.DeleteByPrimaryId(productScrap.ProductScrapId); IList <Model.ProductScrapDetail> oldDetails = accessorDetail.SelectByPrimaryId(productScrap.ProductScrapId); foreach (var item in oldDetails) { accessorDetail.Delete(item.ProductScrapDetailId); accessorStock.Increment(new BL.DepotPositionManager().Get(item.DepotPositionId), item.Product, Convert.ToDouble(item.ScrapQuantity)); accessorProduct.UpdateProduct_Stock(item.Product); } foreach (var item in productScrap.Details) { accessorDetail.Insert(item); accessorStock.Decrement(new BL.DepotPositionManager().Get(item.DepotPositionId), item.Product, Convert.ToDouble(item.ScrapQuantity)); accessorProduct.UpdateProduct_Stock(item.Product); } BL.V.CommitTransaction(); } catch (Exception ex) { BL.V.RollbackTransaction(); throw ex; } }
public override void Refresh() { if (this._productScrap == null) { this.AddNew(); this.action = "insert"; } else { if (this.action == "view") { this._productScrap = this._manager.GetDetails(_productScrap.ProductScrapId); } } this.txt_ProductScrapID.EditValue = this._productScrap.ProductScrapId; this.date_ProductScarpDate.EditValue = this._productScrap.ProductScrapDate; this.ncc_Employee.EditValue = this._productScrap.Employee; this.lue_Depot.EditValue = this._productScrap.DepotId; this.txt_Note.EditValue = this._productScrap.Note; this.bindingSource1.DataSource = this._productScrap.Details; base.Refresh(); this.txt_ProductScrapID.Properties.ReadOnly = true; switch (this.action) { case "view": this.gridView1.OptionsBehavior.Editable = false; break; default: this.gridView1.OptionsBehavior.Editable = true; break; } }
/// <summary> /// Insert a ProductScrap. /// </summary> public void Insert(Model.ProductScrap productScrap) { // // todo:add other logic here // try { BL.V.BeginTransaction(); Validate(productScrap); productScrap.InsertTime = DateTime.Now; productScrap.UpdateTime = DateTime.Now; TiGuiExists(productScrap); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, productScrap.InsertTime.Value.ToString("yyyy-MM-dd")); SequenceManager.Increment(sequencekey_d); accessor.Insert(productScrap); foreach (var item in productScrap.Details) { accessorDetail.Insert(item); accessorStock.Decrement(new BL.DepotPositionManager().Get(item.DepotPositionId), item.Product, Convert.ToDouble(item.ScrapQuantity)); accessorProduct.UpdateProduct_Stock(item.Product); } BL.V.CommitTransaction(); } catch (Exception ex) { BL.V.RollbackTransaction(); throw ex; } }
public Model.ProductScrap GetPrev(Model.ProductScrap e) { return(sqlmapper.QueryForObject <Model.ProductScrap>("ProductScrap.get_prev", e)); }
public Model.ProductScrap GetNext(Model.ProductScrap e) { return(sqlmapper.QueryForObject <Model.ProductScrap>("ProductScrap.get_next", e)); }
public bool HasRowsAfter(Model.ProductScrap e) { return(sqlmapper.QueryForObject <bool>("ProductScrap.has_rows_after", e)); }
public bool HasRowsBefore(Model.ProductScrap e) { return(sqlmapper.QueryForObject <bool>("ProductScrap.has_rows_before", e)); }
public void Update(Model.ProductScrap e) { this.Update <Model.ProductScrap>(e); }
public void Insert(Model.ProductScrap e) { this.Insert <Model.ProductScrap>(e); }
public Model.ProductScrap GetNext(Model.ProductScrap e) { return(accessor.GetNext(e)); }
public Model.ProductScrap GetPrev(Model.ProductScrap e) { return(accessor.GetPrev(e)); }
public bool HasRowsAfter(Model.ProductScrap e) { return(accessor.HasRowsAfter(e)); }
public bool HasRowsBefore(Model.ProductScrap e) { return(accessor.HasRowsBefore(e)); }
protected override void MoveFirst() { this._productScrap = this._manager.GetFirst(); }