/// <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);
}
