public EditForm(Model.ProduceOtherReturnMaterial produceOtherReturnMaterial, string action)
: this()
{
this._produceOtherReturnMaterial = produceOtherReturnMaterial;
this._produceOtherReturnMaterial.Details = this.produceOtherReturnDetailManager.Select(_produceOtherReturnMaterial);
this.action = action;
}
public Ro(Model.ProduceOtherReturnMaterial produceOtherReturnMaterial)
{
InitializeComponent();
this.xrLabelTitle.Text = BL.Settings.CompanyChineseName;
this.xrLabelName.Text = "ίÍâÍËØ›†Î";// Properties.Resources.ProduceOtherReturnMaterial;
this.xrLabelProduceOtherReturnMaterialId.Text = produceOtherReturnMaterial.ProduceOtherReturnMaterialId;
this.xrLabelPrintDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.xrLabelProduceOtherReturnMaterialDate.Text = produceOtherReturnMaterial.ProduceOtherReturnMaterialDate.Value.ToString("yyyy-MM-dd");
this.xrLabelProduceOtherReturnMaterialDesc.Text = produceOtherReturnMaterial.ProduceOtherReturnMaterialDesc;
this.xrLabelEmployee0Id.Text = produceOtherReturnMaterial.Employee0 == null ? "" : produceOtherReturnMaterial.Employee0.ToString();
//this.xrLabelEmployee1Id.Text = produceOtherReturnMaterial.Employee1 == null ? "" : produceOtherReturnMaterial.Employee1.ToString();
//this.xrLabelEmployee2Id.Text = produceOtherReturnMaterial.Employee2 == null ? "" : produceOtherReturnMaterial.Employee2.ToString();
this.xrLabelSupplier.Text = produceOtherReturnMaterial.Supplier == null ? "" : produceOtherReturnMaterial.Supplier.ToString();
this.DataSource = this.produceOtherReturnDetailManager.Select(produceOtherReturnMaterial);
this.xrTableCusProName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName);
this.xrTableProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
this.xrTableProductUnit.DataBindings.Add("Text", this.DataSource, Model.ProduceOtherReturnDetail.PRO_ProductUnit);
this.xrTableOtherCom.DataBindings.Add("Text", this.DataSource, Model.ProduceOtherReturnDetail.PRO_ProduceOtherCompactId);
this.xrTableDesc.DataBindings.Add("Text", this.DataSource, Model.ProduceOtherReturnDetail.PRO_ProduceOtherReturnDetailDesc);
this.xrTableSum.DataBindings.Add("Text", this.DataSource, Model.ProduceOtherReturnDetail.PRO_Quantity);
this.xrTableDesc.DataBindings.Add("Text", this.DataSource, Model.ProduceOtherReturnDetail.PRO_ProduceOtherReturnDetailDesc);
}
protected override void AddNew()
{
this._produceOtherReturnMaterial = new Model.ProduceOtherReturnMaterial();
this._produceOtherReturnMaterial.ProduceOtherReturnMaterialId = this._produceOtherReturnMaterialManager.GetId();
this._produceOtherReturnMaterial.ProduceOtherReturnMaterialDate = DateTime.Now;
this._produceOtherReturnMaterial.Employee0 = BL.V.ActiveOperator.Employee;
this._produceOtherReturnMaterial.Details = new List <Model.ProduceOtherReturnDetail>();
}
protected override void MovePrev()
{
Model.ProduceOtherReturnMaterial material = this._produceOtherReturnMaterialManager.GetPrev(this._produceOtherReturnMaterial);
if (material == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._produceOtherReturnMaterial = this._produceOtherReturnMaterialManager.Get(material.ProduceOtherReturnMaterialId);
}
public Model.ProduceOtherReturnMaterial GetDetails(Model.ProduceOtherReturnMaterial Material)
{
Model.ProduceOtherReturnMaterial temp = accessor.Get(Material.ProduceOtherReturnMaterialId);
if (temp != null)
{
temp.Details = accessorDetail.Select(temp);
}
return(temp);
}
/// <summary>
/// Update a ProduceOtherReturnMaterial.
/// </summary>
///
public void Update(Model.ProduceOtherReturnMaterial produceOtherReturnMaterial)
{
//
// todo: add other logic here.
//
//accessor.Update(produceOtherReturnMaterial);
this.Delete(produceOtherReturnMaterial);
this.Insert(produceOtherReturnMaterial);
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
ListForm lForm = new ListForm();
if (lForm.ShowDialog(this) == DialogResult.OK)
{
this._produceOtherReturnMaterial = lForm.SelectItem as Model.ProduceOtherReturnMaterial;
this.Refresh();
}
}
void Valid(Model.ProduceOtherReturnMaterial Material)
{
foreach (Model.ProduceOtherReturnDetail detail in Material.Details)
{
if (string.IsNullOrEmpty(detail.DepotPositionId))
{
throw new global::Helper.RequireValueException(Model.ProduceOtherReturnDetail.PRO_DepotPositionId);
}
}
}
/// <summary>
/// Insert a ProduceOtherReturnMaterial.
/// </summary>
public void Insert(Model.ProduceOtherReturnMaterial produceOtherReturnMaterial)
{
//
// todo:add other logic here
//
// Valid(produceOtherReturnMaterial);
try
{
BL.V.BeginTransaction();
produceOtherReturnMaterial.InsertTime = DateTime.Now;
produceOtherReturnMaterial.UpdateTime = DateTime.Now;
TiGuiExists(produceOtherReturnMaterial);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceOtherReturnMaterial.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceOtherReturnMaterial.InsertTime.Value.Year, produceOtherReturnMaterial.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceOtherReturnMaterial.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(produceOtherReturnMaterial);
foreach (Model.ProduceOtherReturnDetail item in produceOtherReturnMaterial.Details)
{
item.ProduceOtherReturnMaterialId = produceOtherReturnMaterial.ProduceOtherReturnMaterialId;
accessorDetail.Insert(item);
Model.ProduceOtherCompactDetail CompactDetail = produceOtherCompactDetailAccessor.Get(item.ProduceOtherCompactDetailId);
if (CompactDetail != null)
{
if (CompactDetail.CancelQuantity == null)
{
CompactDetail.CancelQuantity = 0;
}
CompactDetail.CancelQuantity += item.Quantity;
produceOtherCompactDetailAccessor.Update(CompactDetail);
}
//stockAccess.Increment(depotpositionAccess.Get(item.DepotPositionId), item.Product, item.Quantity);
//item.Product.StocksQuantity += stockAccess.GetTheCountByProduct(item.Product);
//item.Product.ProductImage = new byte[0];
//item.Product.ProductImage1 = new byte[0];
//item.Product.ProductImage2 = new byte[0];
//item.Product.ProductImage3 = new byte[0];
//productAccess.Update(item.Product);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void CancelAffect(Model.ProduceOtherReturnMaterial model)
{
foreach (Model.ProduceOtherReturnDetail item in accessorDetail.Select(model))
{
Model.ProduceOtherCompactDetail CompactDetail = produceOtherCompactDetailAccessor.Get(item.ProduceOtherCompactDetailId);
if (CompactDetail != null)
{
CompactDetail.CancelQuantity = CompactDetail.CancelQuantity == null ? 0 : CompactDetail.CancelQuantity - item.Quantity;
produceOtherCompactDetailAccessor.Update(CompactDetail);
}
}
}
public override void Refresh()
{
if (this._produceOtherReturnMaterial == null)
{
this.AddNew();
this.action = "insert";
}
else
{
if (this.action == "view")
{
this._produceOtherReturnMaterial = this._produceOtherReturnMaterialManager.GetDetails(this._produceOtherReturnMaterial);
}
}
this.textProduceOtherReturnMaterialId.Text = this._produceOtherReturnMaterial.ProduceOtherReturnMaterialId;
this.dateProduceOtherReturnMaterialDate.DateTime = this._produceOtherReturnMaterial.ProduceOtherReturnMaterialDate.Value;
this.newChooseEmployee0Id.EditValue = this._produceOtherReturnMaterial.Employee0;
this.newChooseEmployee1Id.EditValue = this._produceOtherReturnMaterial.Employee1;
this.newChooseEmployee2Id.EditValue = this._produceOtherReturnMaterial.Employee2;
this.EmpAudit.EditValue = this._produceOtherReturnMaterial.AuditEmp;
this.textEditAuditState.Text = this.GetAuditName(this._produceOtherReturnMaterial.AuditState);
this.txt_AmountMoney.Text = this._produceOtherReturnMaterial.AmountMoney.ToString();
this.txt_Tax.Text = this._produceOtherReturnMaterial.Tax.ToString();
this.txt_TotalMoney.Text = this._produceOtherReturnMaterial.TotalMoney.ToString();
this.PayDate.EditValue = this._produceOtherReturnMaterial.PayDate;
this.spe_InvoiceTaxrate.Value = this._produceOtherReturnMaterial.InvoiceTaxrate;
this.bindingSourceProduceOtherReturnDetail.DataSource = this._produceOtherReturnMaterial.Details;
base.Refresh();
switch (this.action)
{
case "insert":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "update":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "view":
this.gridView1.OptionsBehavior.Editable = false;
break;
}
this.textProduceOtherReturnMaterialId.Properties.ReadOnly = true;
}
protected override void Delete()
{
if (this._produceOtherReturnMaterial == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
this._produceOtherReturnMaterialManager.Delete(this._produceOtherReturnMaterial);
this._produceOtherReturnMaterial = this._produceOtherReturnMaterialManager.GetNext(this._produceOtherReturnMaterial);
if (this._produceOtherReturnMaterial == null)
{
this._produceOtherReturnMaterial = this._produceOtherReturnMaterialManager.GetLast();
}
}
private void TiGuiExists(Model.ProduceOtherReturnMaterial model)
{
if (this.ExistsPrimary(model.ProduceOtherReturnMaterialId))
{
//设置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.ProduceOtherReturnMaterialId = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
//throw new Helper.InvalidValueException(Model.Product.PRO_Id);
}
}
/// <summary>
/// Delete ProduceOtherReturnMaterial by primary key.
/// </summary>
public void Delete(string produceOtherReturnMaterialId)
{
//
// todo:add other logic here
//
try
{
BL.V.BeginTransaction();
Model.ProduceOtherReturnMaterial model = this.Get(produceOtherReturnMaterialId);
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(accessor.Get(produceOtherReturnMaterialId));
accessor.Delete(produceOtherReturnMaterialId);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public System.Collections.Generic.IList <Model.ProduceOtherReturnDetail> Select(Model.ProduceOtherReturnMaterial Material)
{
return(sqlmapper.QueryForList <Model.ProduceOtherReturnDetail>("ProduceOtherReturnDetail.selectByHeadId", Material.ProduceOtherReturnMaterialId));
}
public void Delete(Model.ProduceOtherReturnMaterial produceOtherReturnMaterial)
{
this.Delete(produceOtherReturnMaterial.ProduceOtherReturnMaterialId);
}
protected override void MoveLast()
{
this._produceOtherReturnMaterial = this._produceOtherReturnMaterialManager.GetLast() == null ? null : this._produceOtherReturnMaterialManager.GetLast();
}
public void Insert(Model.ProduceOtherReturnMaterial e)
{
this.Insert <Model.ProduceOtherReturnMaterial>(e);
}
public bool HasRowsAfter(Model.ProduceOtherReturnMaterial e)
{
return(sqlmapper.QueryForObject <bool>("ProduceOtherReturnMaterial.has_rows_after", e));
}
public Model.ProduceOtherReturnMaterial GetNext(Model.ProduceOtherReturnMaterial e)
{
return(accessor.GetNext(e));
}
public void Update(Model.ProduceOtherReturnMaterial e)
{
this.Update <Model.ProduceOtherReturnMaterial>(e);
}
public System.Collections.Generic.IList <Model.ProduceOtherReturnDetail> Select(Model.ProduceOtherReturnMaterial Material)
{
return(accessor.Select(Material));
}
public Model.ProduceOtherReturnMaterial GetPrev(Model.ProduceOtherReturnMaterial e)
{
return(sqlmapper.QueryForObject <Model.ProduceOtherReturnMaterial>("ProduceOtherReturnMaterial.get_prev", e));
}
public bool HasRowsAfter(Model.ProduceOtherReturnMaterial e)
{
return(accessor.HasRowsAfter(e));
}
