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