/// <summary> /// Update a ProduceMaterialExit. /// </summary> public void Update(Model.ProduceMaterialExit produceMaterialExit) { // // todo: add other logic here. // Validate(produceMaterialExit); try { BL.V.BeginTransaction(); if (produceMaterialExit != null) { produceMaterialExit.UpdateTime = DateTime.Now; accessor.Update(produceMaterialExit); Model.ProduceMaterialExit oldModel = this.GetDetails(produceMaterialExit.ProduceMaterialExitId); cancelAffect(oldModel); detailsAccessor.Delete(produceMaterialExit); addDetail(produceMaterialExit); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public EditForm(Model.ProduceMaterialExit ProduceMaterialExit, string action) : this() { this._produceMaterialExit = ProduceMaterialExit; this._produceMaterialExit.Detail = this.produceExitDetailManager.Select(ProduceMaterialExit); this.action = action; }
public EditForm(Model.ProduceMaterialExit ProduceMaterialExit) : this() { this._produceMaterialExit = ProduceMaterialExit; this._produceMaterialExit.Detail = this.produceExitDetailManager.Select(_produceMaterialExit); this.action = "view"; }
protected override void MoveLast() { // if (_produceMaterialExit == null) { this._produceMaterialExit = this.produceMaterialExitManager.Get(this.produceMaterialExitManager.GetLast() == null ? "" : this.produceMaterialExitManager.GetLast().ProduceMaterialExitId); } }
/// <summary> /// Insert a ProduceMaterialExit. /// </summary> public void Insert(Model.ProduceMaterialExit produceMaterialExit) { // // todo:add other logic here // Validate(produceMaterialExit); TiGuiExists(produceMaterialExit); try { produceMaterialExit.InsertTime = DateTime.Now; produceMaterialExit.UpdateTime = DateTime.Now; BL.V.BeginTransaction(); string invoiceKind = this.GetInvoiceKind().ToLower(); //string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceMaterialExit.InsertTime.Value.Year); //string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceMaterialExit.InsertTime.Value.Year, produceMaterialExit.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceMaterialExit.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); accessor.Insert(produceMaterialExit); addDetail(produceMaterialExit); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Delete ProduceMaterialExit by primary key. /// </summary> public void Delete(string produceExitMaterialId) { // // todo:add other logic here // Model.ProduceMaterialExit model = this.Get(produceExitMaterialId); this.Delete(model); }
public void Delete(Model.ProduceMaterialExit produceMaterialExit) { // // todo:add other logic here // //cancelAffect(produceMaterialExit); 在下个方法中执行 this.Delete(produceMaterialExit.ProduceMaterialExitId); }
public EditForm(string id) : this() { this._produceMaterialExit = this.produceMaterialExitManager.Get(id); this._produceMaterialExit.Detail = this.produceExitDetailManager.Select(_produceMaterialExit); this.action = "view"; this.flag = 1; }
protected override void MovePrev() { Model.ProduceMaterialExit produceMaterialExit = this.produceMaterialExitManager.GetPrev(this._produceMaterialExit); if (produceMaterialExit == null) { throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows); } this._produceMaterialExit = this.produceMaterialExitManager.Get(produceMaterialExit.ProduceMaterialExitId); }
public Model.ProduceMaterialExit GetDetails(string produceExitMaterialId) { Model.ProduceMaterialExit produceMaterialExit = accessor.Get(produceExitMaterialId); if (produceMaterialExit != null) { produceMaterialExit.Detail = detailsAccessor.Select(produceMaterialExit); } return(produceMaterialExit); }
protected override void MoveLast() { if (this.tag == 1) { this.tag = 0; return; } this._produceMaterialExit = this.produceMaterialExitManager.Get(this.produceMaterialExitManager.GetLast() == null ? "" : this.produceMaterialExitManager.GetLast().ProduceMaterialExitId); }
public RO(string produceMaterialExitId) { InitializeComponent(); this.produceMaterialExit = this.produceMaterialExitManager.Get(produceMaterialExitId); if (this.produceMaterialExit == null) { return; } this.produceMaterialExit.Detail = this.produceMaterialExitDetailManager.Select(this.produceMaterialExit); this.DataSource = this.produceMaterialExit.Detail; //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.ProduceMaterialExitDetail; this.xrLabelDate.Text += DateTime.Now.ToShortDateString(); //生產退料 //this.xrLabelPronoteHeader.Text = this.produceMaterialExit.PronoteHeaderID; this.xrLabelDepot.Text = this.produceMaterialExit.Depot == null ? string.Empty : this.produceMaterialExit.Depot.ToString(); this.lblSupplier.Text = this.produceMaterialExit.Supplier == null ? string.Empty : this.produceMaterialExit.Supplier.ToString(); this.xrLabelProduceExitMaterialId.Text = this.produceMaterialExit.ProduceMaterialExitId; this.xrLabelProduceExitMaterialDate.Text = this.produceMaterialExit.ProduceExitMaterialDate.Value.ToString("yyyy-MM-dd"); //客戶訂單編號 //this.xrLabelInvoiceCusXoId.Text = this.produceMaterialExit.CustomerInvoiceXOId; if (this.produceMaterialExit.Employee0 != null) { this.xrLabelEmployee0.Text = this.produceMaterialExit.Employee0.EmployeeName; } if (this.produceMaterialExit.WorkHouse != null) { this.xrLabelDepartment.Text = this.produceMaterialExit.WorkHouse.Workhousename; } this.xrLabelProduceExitMaterialDesc.Text = this.produceMaterialExit.ProduceExitMaterialDesc; //if (!string.IsNullOrEmpty(this.produceMaterialExit.PronoteHeaderID)) //{ // Model.PronoteHeader mPH = new BL.PronoteHeaderManager().Get(this.produceMaterialExit.PronoteHeaderID); // if (mPH != null) // { // this.lblZhuJianProductName.Text = mPH.Product.ToString(); // } //} //明细 this.TCInumber.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_Inumber); this.TC_Pro_Id.DataBindings.Add("Text", this.DataSource, "Product.Id"); this.xrTableproductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.xrDepotPosi.DataBindings.Add("Text", this.DataSource, "DepotPosition." + Model.DepotPosition.PROPERTY_ID); this.xrUnit.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProductUnit); this.xrTableProduceQuantity.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProduceQuantity); this.TCPronoteHeaderId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_PronoteHeaderId); this.TCInvoiceXOCusId.DataBindings.Add("Text", this.DataSource, "InvoiceXO." + Model.InvoiceXO.PRO_CustomerInvoiceXOId); this.xrProductioinBatch.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProductioinBatch); }
private void cancelAffect(Model.ProduceMaterialExit ProduceMaterialExit) { foreach (Model.ProduceMaterialExitDetail oldDetail in ProduceMaterialExit.Detail) { if (oldDetail.Product == null || oldDetail.Product.ProductId == null) { continue; } oldDetail.DepotPosition = depotPositionAccessor.Get(oldDetail.DepotPositionId); stockAccessor.Decrement(oldDetail.DepotPosition, oldDetail.Product, oldDetail.ProduceQuantity); } }
private void cancelAffect(Model.ProduceMaterialExit ProduceMaterialExit) { foreach (Model.ProduceMaterialExitDetail oldDetail in ProduceMaterialExit.Detail) { if (oldDetail.Product == null || oldDetail.Product.ProductId == null || (oldDetail.IsCountStock.HasValue && oldDetail.IsCountStock.Value)) { continue; } oldDetail.DepotPosition = depotPositionAccessor.Get(oldDetail.DepotPositionId); stockAccessor.Decrement(oldDetail.DepotPosition, oldDetail.Product, oldDetail.ProduceQuantity); productAccessor.UpdateProduct_Stock(oldDetail.Product); } }
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { this.produceMaterialExit = this.bindingSourceproduceMaterialExit.Current as Model.ProduceMaterialExit; if (this.produceMaterialExit != null) { if (this.produceMaterialExit.Detail == null) { this.produceMaterialExit.Detail = new List <Model.ProduceMaterialExitDetail>(); } this.produceMaterialExit.Detail = this.produceMaterialExitDetailManager.Select(this.produceMaterialExit); this.bindingSourceproduceMaterialExitDetail.DataSource = this.produceMaterialExit.Detail; } }
private void addDetail(Model.ProduceMaterialExit produceMaterialExit) { foreach (Model.ProduceMaterialExitDetail produceMaterialExitDetail in produceMaterialExit.Detail) { if (produceMaterialExitDetail.Product == null || string.IsNullOrEmpty(produceMaterialExitDetail.Product.ProductId)) { continue; } produceMaterialExitDetail.ProduceMaterialExitId = produceMaterialExit.ProduceMaterialExitId; detailsAccessor.Insert(produceMaterialExitDetail); stockAccessor.Increment(depotPositionAccessor.Get(produceMaterialExitDetail.DepotPositionId), produceMaterialExitDetail.Product, produceMaterialExitDetail.ProduceQuantity); productAccessor.UpdateProduct_Stock(produceMaterialExitDetail.Product); } }
/// <summary> /// Delete ProduceMaterialExit by primary key. /// </summary> public void Delete(string produceExitMaterialId) { // // todo:add other logic here // Model.ProduceMaterialExit model = this.Get(produceExitMaterialId); 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); cancelAffect(model); accessor.Delete(produceExitMaterialId); }
private void barBtnSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { ListForm form = new ListForm(); if (form.ShowDialog(this) == DialogResult.OK) { Model.ProduceMaterialExit currentModel = form.SelectItem as Model.ProduceMaterialExit; if (currentModel != null) { this._produceMaterialExit = currentModel; this._produceMaterialExit = this.produceMaterialExitManager.GetDetails(_produceMaterialExit.ProduceMaterialExitId); this.Refresh(); } } }
protected override void Delete() { if (this._produceMaterialExit == null) { return; } if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK) { return; } this.produceMaterialExitManager.Delete(this._produceMaterialExit); this._produceMaterialExit = this.produceMaterialExitManager.GetNext(this._produceMaterialExit); if (this._produceMaterialExit == null) { this._produceMaterialExit = this.produceMaterialExitManager.GetLast(); } }
private void TiGuiExists(Model.ProduceMaterialExit model) { if (this.ExistsPrimary(model.ProduceMaterialExitId)) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); //string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, model.InsertTime.Value.Year); //string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InsertTime.Value.Year, model.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.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); model.ProduceMaterialExitId = this.GetIdSimple(model.InsertTime.Value); TiGuiExists(model); //throw new Helper.InvalidValueException(Model.Product.PRO_Id); } }
protected override void AddNew() { this._produceMaterialExit = new Model.ProduceMaterialExit(); this._produceMaterialExit.ProduceMaterialExitId = this.produceMaterialExitManager.GetId();// Guid.NewGuid().ToString(); this._produceMaterialExit.ProduceExitMaterialDate = DateTime.Now; this._produceMaterialExit.Employee0 = BL.V.ActiveOperator.Employee; this._produceMaterialExit.Detail = new List <Model.ProduceMaterialExitDetail>(); //if (this.action == "insert") //{ // Model.ProduceMaterialExitDetail detail = new Model.ProduceMaterialExitDetail(); // detail.Inumber = this._produceMaterialExit.Detail.Count + 1; // // detail.ProduceExitMaterialDetailId = Guid.NewGuid().ToString(); // // detail.MPSheaderId = null; // detail.ProduceQuantity = 0; // detail.ProductStock = 0; // detail.Product = new Book.Model.Product(); // this._produceMaterialExit.Detail.Add(detail); // this.bindingSourceDetails.Position = this.bindingSourceDetails.IndexOf(detail); //} }
private void Validate(Model.ProduceMaterialExit produceMaterialExit) { if (string.IsNullOrEmpty(produceMaterialExit.ProduceMaterialExitId)) { throw new Helper.RequireValueException(Model.ProduceMaterialExit.PRO_ProduceMaterialExitId); } if (string.IsNullOrEmpty(produceMaterialExit.WorkHouseId)) { throw new Helper.RequireValueException(Model.ProduceMaterialExit.PRO_WorkHouseId); } foreach (Model.ProduceMaterialExitDetail detail in produceMaterialExit.Detail) { if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) { continue; } if (string.IsNullOrEmpty(detail.DepotPositionId)) { throw new Helper.RequireValueException(Model.ProduceOtherExitDetail.PRO_DepotPositionId); } } }
public bool HasRowsAfter(Model.ProduceMaterialExit e) { return(sqlmapper.QueryForObject <bool>("ProduceMaterialExit.has_rows_after", e)); }
public bool HasRowsBefore(Model.ProduceMaterialExit e) { return(sqlmapper.QueryForObject <bool>("ProduceMaterialExit.has_rows_before", e)); }
public void Update(Model.ProduceMaterialExit e) { this.Update <Model.ProduceMaterialExit>(e); }
public void Insert(Model.ProduceMaterialExit e) { this.Insert <Model.ProduceMaterialExit>(e); }
public override void Refresh() { if (this._produceMaterialExit == null) { this.AddNew(); this.action = "insert"; } else { if (this.action == "view") { this._produceMaterialExit = this.produceMaterialExitManager.GetDetails(_produceMaterialExit.ProduceMaterialExitId); } } this.textEditExitId.EditValue = this._produceMaterialExit.ProduceMaterialExitId; this.textEditDescription.Text = this._produceMaterialExit.ProduceExitMaterialDesc; this.newChooseWorkHorseId.EditValue = this._produceMaterialExit.WorkHouse; this.tEtPronoteHeaderId.Text = this._produceMaterialExit.PronoteHeaderID; this.textEditCustomerXOId.EditValue = this._produceMaterialExit.CustomerInvoiceXOId; if (!string.IsNullOrEmpty(this._produceMaterialExit.PronoteHeaderID)) { Model.PronoteHeader pronoteHeader = this.pronoteHeaderManager.Get(this._produceMaterialExit.PronoteHeaderID); if (pronoteHeader != null) { Model.Product product = pronoteHeader.Product; this.textEditProId.Text = product.Id; this.textEditProName.Text = product.ProductName; this.textEditCusProName.Text = product.CustomerProductName; } else { this.textEditProId.EditValue = null; this.textEditProName.EditValue = null; this.textEditCusProName.EditValue = null; } } else { this.textEditProId.EditValue = null; this.textEditProName.EditValue = null; this.textEditCusProName.EditValue = null; } if (global::Helper.DateTimeParse.DateTimeEquls(this._produceMaterialExit.ProduceExitMaterialDate, global::Helper.DateTimeParse.NullDate)) { this.dateEdit1.EditValue = null; } else { this.dateEdit1.EditValue = this._produceMaterialExit.ProduceExitMaterialDate; } this.EmpAudit.EditValue = this._produceMaterialExit.AuditEmp; this.textEditAuditState.Text = this.GetAuditName(this._produceMaterialExit.AuditState); this.newChooseEmployee0.EditValue = this._produceMaterialExit.Employee0; this.newChooseDepot.EditValue = this._produceMaterialExit.Depot; this.nccChooseSupplier.EditValue = this._produceMaterialExit.Supplier; this.bindingSourceDetails.DataSource = this._produceMaterialExit.Detail; base.Refresh(); switch (this.action) { case "insert": this.gridView1.OptionsBehavior.Editable = true; this.barBtnSearch.Enabled = false; this.barButtonItem1.Enabled = true; break; case "update": this.gridView1.OptionsBehavior.Editable = true; this.barBtnSearch.Enabled = false; this.barButtonItem1.Enabled = true; break; case "view": this.gridView1.OptionsBehavior.Editable = false; this.barBtnSearch.Enabled = true; this.barButtonItem1.Enabled = false; break; } this.textEditExitId.Properties.ReadOnly = true; }
public Model.ProduceMaterialExit GetNext(Model.ProduceMaterialExit e) { return(sqlmapper.QueryForObject <Model.ProduceMaterialExit>("ProduceMaterialExit.get_next", e)); }
public Model.ProduceMaterialExit GetPrev(Model.ProduceMaterialExit e) { return(sqlmapper.QueryForObject <Model.ProduceMaterialExit>("ProduceMaterialExit.get_prev", e)); }
protected override void MoveFirst() { this._produceMaterialExit = this.produceMaterialExitManager.Get(this.produceMaterialExitManager.GetFirst() == null ? "" : this.produceMaterialExitManager.GetFirst().ProduceMaterialExitId); }