public void Validate(Model.AssemblySiteDifference model)
{
if (string.IsNullOrEmpty(model.AssemblySiteInventoryId))
{
throw new Helper.InvalidValueException(Model.AssemblySiteDifference.PRO_AssemblySiteInventoryId);
}
}
public AssemblySiteDifferenceForm(Model.AssemblySiteInventory model)
: this()
{
this._assemblySiteDifference = new Book.Model.AssemblySiteDifference();
this._assemblySiteDifference.AssemblySiteDifferenceId = this.manager.GetId();
this._assemblySiteDifference.Employee = BL.V.ActiveOperator.Employee;
this._assemblySiteDifference.AssemblySiteInventoryId = model.AssemblySiteInventoryId;
this._assemblySiteDifference.InvoiceDate = model.InvoiceDate;
Model.AssemblySiteDifferenceDetai detail;
foreach (var item in model.Details)
{
detail = new Book.Model.AssemblySiteDifferenceDetai();
detail.AssemblySiteDifferenceDetaiId = Guid.NewGuid().ToString();
detail.Product = item.Product;
detail.ProductId = item.ProductId;
detail.ActualQuantity = item.Quantity;
detail.TheoryQuantity = this.CountSiteQuantity(detail.ProductId, model.InvoiceDate.Value.Date.AddDays(1));
this._assemblySiteDifference.Details.Add(detail);
}
this.action = "insert";
this.isLast = 1;
}
public AssemblySiteDifferenceForm(Model.AssemblySiteDifference model, string action)
: this()
{
this._assemblySiteDifference = model;
this.isLast = 1;
this.action = action;
}
/// <summary>
/// Update a AssemblySiteDifference.
/// </summary>
public void Update(Model.AssemblySiteDifference assemblySiteDifference)
{
//
// todo: add other logic here.
//
try
{
BL.V.BeginTransaction();
this.Validate(assemblySiteDifference);
assemblySiteDifference.UpdateTime = DateTime.Now;
accessor.Update(assemblySiteDifference);
detailaccessor.DeleteByHeaderId(assemblySiteDifference.AssemblySiteDifferenceId);
foreach (var item in assemblySiteDifference.Details)
{
item.AssemblySiteDifferenceId = assemblySiteDifference.AssemblySiteDifferenceId;
detailaccessor.Insert(item);
}
BL.V.CommitTransaction();
}
catch (Exception ex)
{
BL.V.RollbackTransaction();
throw ex;
}
}
protected override void MoveLast()
{
if (this.isLast == 1)
{
this.isLast = 0;
return;
}
_assemblySiteDifference = this.manager.Get(this.manager.GetLast() == null ? "" : this.manager.GetLast().AssemblySiteDifferenceId);
}
protected override Book.UI.Settings.BasicData.BaseEditForm GetEditForm(object[] args)
{
Type type = typeof(AssemblySiteDifferenceForm);
Model.AssemblySiteDifference model = (args[0] as Model.AssemblySiteDifferenceDetai).AssemblySiteDifference;
args[0] = model;
return((AssemblySiteDifferenceForm)type.Assembly.CreateInstance(type.FullName, false, System.Reflection.BindingFlags.CreateInstance, null, args, null, null));
}
protected override void MovePrev()
{
Model.AssemblySiteDifference model = this.manager.GetPrev(_assemblySiteDifference);
if (model == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
_assemblySiteDifference = model;
}
public Model.AssemblySiteDifference GetDetail(string id)
{
Model.AssemblySiteDifference model = this.Get(id);
if (model != null)
{
model.Details = detailaccessor.SelectByHeaderId(id);
}
return(model);
}
protected override void AddNew()
{
if (this.isLast == 1)
{
this.isLast = 0;
return;
}
this._assemblySiteDifference = new Book.Model.AssemblySiteDifference();
this._assemblySiteDifference.AssemblySiteDifferenceId = this.manager.GetId();
this._assemblySiteDifference.Employee = BL.V.ActiveOperator.Employee;
this.action = "insert";
}
public void TiGuiExists(Model.AssemblySiteDifference model)
{
if (this.ExistsPrimary(model.AssemblySiteDifferenceId))
{
//设置KEY值
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, DateTime.Now.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, DateTime.Now.Year, DateTime.Now.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, DateTime.Now.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.AssemblySiteDifferenceId = this.GetId(DateTime.Now);
TiGuiExists(model);
}
}
protected override void Delete()
{
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
try
{
this.manager.Delete(_assemblySiteDifference.AssemblySiteDifferenceId);
_assemblySiteDifference = this.manager.GetNext(_assemblySiteDifference);
if (_assemblySiteDifference == null)
{
_assemblySiteDifference = this.manager.GetLast();
}
}
catch
{
throw;
}
}
/// <summary>
/// Insert a AssemblySiteDifference.
/// </summary>
public void Insert(Model.AssemblySiteDifference assemblySiteDifference)
{
//
// todo:add other logic here
//
try
{
BL.V.BeginTransaction();
this.Validate(assemblySiteDifference);
this.TiGuiExists(assemblySiteDifference);
assemblySiteDifference.InsertTime = DateTime.Now;
assemblySiteDifference.UpdateTime = DateTime.Now;
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, DateTime.Now.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, DateTime.Now.Year, DateTime.Now.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, DateTime.Now.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(assemblySiteDifference);
new BL.AssemblySiteInventoryManager().UpdateState(true, assemblySiteDifference.AssemblySiteInventoryId); //设置对应的盘点录入单“已生成盘点差异”状态
foreach (var item in assemblySiteDifference.Details)
{
item.AssemblySiteDifferenceId = assemblySiteDifference.AssemblySiteDifferenceId;
detailaccessor.Insert(item);
}
BL.V.CommitTransaction();
}
catch (Exception ex)
{
BL.V.RollbackTransaction();
throw ex;
}
}
public override void Refresh()
{
if (_assemblySiteDifference == null)
{
this.AddNew();
}
else if (this.action == "view")
{
this._assemblySiteDifference = this.manager.GetDetail(this._assemblySiteDifference.AssemblySiteDifferenceId);
}
this.txt_ID.EditValue = this._assemblySiteDifference.AssemblySiteDifferenceId;
this.txt_ID2.EditValue = this._assemblySiteDifference.AssemblySiteInventoryId;
this.date_Difference.EditValue = this._assemblySiteDifference.InvoiceDate;
this.ncc_Employee.EditValue = this._assemblySiteDifference.Employee;
this.txt_Note.EditValue = this._assemblySiteDifference.Note;
this.bindingSourceDetail.DataSource = _assemblySiteDifference.Details;
this.gridControl1.RefreshDataSource();
base.Refresh();
switch (this.action)
{
case "insert":
case "update":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "view":
this.gridView1.OptionsBehavior.Editable = false;
break;
}
this.txt_ID.Properties.ReadOnly = true;
this.txt_ID2.Properties.ReadOnly = true;
this.date_Difference.Properties.ReadOnly = true;
}
public AssemblySiteDifferenceRO(Model.AssemblySiteDifference model)
{
InitializeComponent();
this.DataSource = model.Details;
this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
this.lbl_ReportName.Text = "组装现场盘点差异";
this.lbl_ReportDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.lbl_ID.Text = model.AssemblySiteDifferenceId;
this.lbl_ID2.Text = model.AssemblySiteInventoryId;
this.lbl_Date.Text = model.InvoiceDate.HasValue ? model.InvoiceDate.Value.ToString("yyyy-MM-dd") : "";
this.lbl_Employee.Text = model.Employee == null ? "" : model.Employee.EmployeeName;
this.lbl_Note.Text = model.Note;
TC_ProductID.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id);
TCProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
TCCustomerProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName);
TCProductVersion.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductVersion);
TCActualQuantity.DataBindings.Add("Text", this.DataSource, Model.AssemblySiteDifferenceDetai.PRO_ActualQuantity, "{0:0.##}");
TCTheoryQuantit.DataBindings.Add("Text", this.DataSource, Model.AssemblySiteDifferenceDetai.PRO_TheoryQuantity, "{0:0.##}");
TCChayi.DataBindings.Add("Text", this.DataSource, "DiffQty", "{0:0.##}");
}
public bool HasRowsAfter(Model.AssemblySiteDifference e)
{
return(accessor.HasRowsAfter(e));
}
public Model.AssemblySiteDifference GetNext(Model.AssemblySiteDifference e)
{
return(accessor.GetNext(e));
}
public Model.AssemblySiteDifference GetPrev(Model.AssemblySiteDifference e)
{
return(sqlmapper.QueryForObject <Model.AssemblySiteDifference>("AssemblySiteDifference.get_prev", e));
}
public bool HasRowsAfter(Model.AssemblySiteDifference e)
{
return(sqlmapper.QueryForObject <bool>("AssemblySiteDifference.has_rows_after", e));
}
public bool HasRowsBefore(Model.AssemblySiteDifference e)
{
return(sqlmapper.QueryForObject <bool>("AssemblySiteDifference.has_rows_before", e));
}
public void Update(Model.AssemblySiteDifference e)
{
this.Update <Model.AssemblySiteDifference>(e);
}
public void Insert(Model.AssemblySiteDifference e)
{
this.Insert <Model.AssemblySiteDifference>(e);
}
public bool HasRowsBefore(Model.AssemblySiteDifference e)
{
return(accessor.HasRowsBefore(e));
}
protected override void MoveFirst()
{
_assemblySiteDifference = this.manager.Get(this.manager.GetFirst() == null ? "" : this.manager.GetFirst().AssemblySiteDifferenceId);
}
public AssemblySiteDifferenceForm(Model.AssemblySiteDifference model)
: this()
{
this._assemblySiteDifference = model;
this.isLast = 1;
}
