public Model.PCSampling GetDetail(string id)
{
Model.PCSampling model = this.Get(id);
if (model != null)
model.Details = accessorDetail.SelectByPCMaterialCheckId(id);
return model;
}
/// <summary>
/// Update a PCSampling.
/// </summary>
public void Update(Model.PCSampling pCSampling)
{
//
// todo: add other logic here.
//
try
{
BL.V.BeginTransaction();
Validate(pCSampling);
pCSampling.UpdateTime = DateTime.Now;
accessor.Update(pCSampling);
accessorDetail.DeleteByPCMaterialCheckId(pCSampling.PCSamplingId);
foreach (var item in pCSampling.Details)
{
accessorDetail.Insert(item);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
protected override Book.UI.Settings.BasicData.BaseEditForm GetEditForm(object[] args)
{
Type type = typeof(EditForm);
Model.PCSampling model = this.pCSamplingManager.Get((args[0] as Model.PCSamplingDetail) == null ? "" : (args[0] as Model.PCSamplingDetail).PCSamplingId);
args[0] = model;
return((EditForm)type.Assembly.CreateInstance(type.FullName, false, System.Reflection.BindingFlags.CreateInstance, null, args, null, null));
}
public void Validate(Model.PCSampling model)
{
if (model.PCSamplingDate == null)
throw new Helper.InvalidValueException(Model.PCSampling.PRO_PCSamplingDate);
if (string.IsNullOrEmpty(model.PronoteHeaderId))
throw new Helper.InvalidValueException(Model.PCSampling.PRO_PronoteHeaderId);
}
protected override void MoveLast()
{
if (LastFlag == 1)
{
LastFlag = 0; return;
}
this._PCSampling = this.manager.GetLast();
}
protected override void MoveNext()
{
Model.PCSampling p = this.manager.GetNext(this._PCSampling);
if (p == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._PCSampling = p;
}
protected override void AddNew()
{
this._PCSampling = new Book.Model.PCSampling();
this._PCSampling.PCSamplingId = this.manager.GetId();
this._PCSampling.PCSamplingDate = DateTime.Now;
this._PCSampling.Employee = BL.V.ActiveOperator.Employee;
this.action = "insert";
}
public EditForm(string PCSamplingId)
: this()
{
this._PCSampling = this.manager.Get(PCSamplingId);
this.action = "view";
if (this.action == "view")
{
LastFlag = 1;
}
}
public EditForm(Model.PCSampling model, string action)
: this()
{
if (model == null)
{
throw new ArithmeticException("invoiceid");
}
this._PCSampling = model;
this.action = action;
if (this.action == "view")
{
LastFlag = 1;
}
}
private void TiGuiExists(Model.PCSampling model)
{
if (this.ExistsPrimary(model.PCSamplingId))
{
//设置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.PCSamplingId = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
}
}
protected override void Delete()
{
if (this._PCSampling == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Model.PCSampling model = this.manager.GetNext(this._PCSampling);
this.manager.Delete(this._PCSampling.PCSamplingId);
if (model == null)
{
this._PCSampling = this.manager.GetLast();
}
else
{
this._PCSampling = model;
}
}
}
public override void Refresh()
{
if (this._PCSampling == null)
{
this.AddNew();
}
else
{
if (this.action == "view")
{
this._PCSampling = this.manager.GetDetail(this._PCSampling.PCSamplingId);
}
}
this.txt_PCSamplingId.Text = this._PCSampling.PCSamplingId;
this.date_PCSamplingDate.EditValue = this._PCSampling.PCSamplingDate;
this.txt_PronoteHeaderId.Text = this._PCSampling.PronoteHeaderId;
this.txt_InvoiceCusId.Text = this._PCSampling.InvoiceCusId;
this.nccEmployee.EditValue = this._PCSampling.Employee;
this.nccCustomer.EditValue = this._PCSampling.Customer;
this.txt_Model.Text = this._PCSampling.Model;
this.txt_Note.Text = this._PCSampling.Note;
this.nccEmployee1.EditValue = this._PCSampling.Employee1;
this.bindingSourceDetail.DataSource = this._PCSampling.Details;
base.Refresh();
switch (this.action)
{
case "view":
this.gridView1.OptionsBehavior.Editable = false;
break;
default:
this.gridView1.OptionsBehavior.Editable = true;
break;
}
this.txt_PronoteHeaderId.Properties.ReadOnly = true;
this.txt_PCSamplingId.Properties.ReadOnly = true;
}
public RO(Model.PCSampling model)
: this()
{
Model.PCSampling PCSampling = new BL.PCSamplingManager().GetDetail(model.PCSamplingId);
this.DataSource = PCSampling.Details;
this.lblCompanyName.Text = BL.Settings.CompanyChineseName;
this.lbl_ReportName.Text = "组装检验日报表";
//this.lbl_PrintDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.lbl_PCSamplingId.Text = PCSampling.PCSamplingId;
this.lbl_PCSamplingCheckDate.Text = PCSampling.PCSamplingDate.Value.ToString("yyyy-MM-dd");
this.lbl_PronoteHeaderId.Text = PCSampling.PronoteHeaderId;
this.lbl_InvoiceCusId.Text = PCSampling.InvoiceCusId;
this.lbl_Customer.Text = PCSampling.Customer == null ? "" : PCSampling.Customer.CustomerFullName;
this.lbl_model.Text = PCSampling.Model;
this.lbl_Note.Text = PCSampling.Note;
this.lbl_Employee.Text = PCSampling.Employee == null ? "" : PCSampling.Employee.EmployeeName;
this.lblEmployee1.Text = PCSampling.Employee1 == null ? "" : PCSampling.Employee1.EmployeeName;
TCProduct.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
TCCheckDate.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_PCSamplingDetailDate, "{0:yyyy-MM-dd HH:mm}");
TCCheckNum.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_CheckNum, "{0:0}");
TCGrade.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Grade);
TCWaiguan.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Waiguan);
TCJiao.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Jiao);
TCShensuojiao.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Shensuojiao);
TCSuoluosi.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Suoluosi);
TCCashang.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Cashang);
TCKuang.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Kuang);
TCBidian.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Bidian);
TCYinzi.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Yinzi);
TCBaozhuangdai.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Baozhuangdai);
TCTiaomabiao.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Tiaomabiao);
TCZhengcemai.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Zhengcemai);
TCChongji.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Chongji);
TCPassNum.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_PassNum, "{0:0}");
TCToudai.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Toudai);
TCTangzi.DataBindings.Add("Text", this.DataSource, Model.PCSamplingDetail.PRO_Tangzi);
}
/// <summary>
/// Insert a PCSampling.
/// </summary>
public void Insert(Model.PCSampling pCSampling)
{
//
// todo:add other logic here
//
try
{
BL.V.BeginTransaction();
this.Validate(pCSampling);
pCSampling.InsertTime = DateTime.Now;
pCSampling.UpdateTime = DateTime.Now;
this.TiGuiExists(pCSampling);
accessor.Insert(pCSampling);
foreach (var item in pCSampling.Details)
{
item.PCSamplingId = pCSampling.PCSamplingId;
accessorDetail.Insert(item);
}
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, pCSampling.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, pCSampling.InsertTime.Value.Year, pCSampling.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, pCSampling.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);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public Model.PCSampling GetNext(Model.PCSampling e)
{
return(accessor.GetNext(e));
}
public bool HasRowsAfter(Model.PCSampling e)
{
return(accessor.HasRowsAfter(e));
}
public Model.PCSampling GetPrev(Model.PCSampling e)
{
return(accessor.GetPrev(e));
}
public Model.PCSampling GetPrev(Model.PCSampling e)
{
return(sqlmapper.QueryForObject <Model.PCSampling>("PCSampling.get_prev", e));
}
public bool HasRowsBefore(Model.PCSampling e)
{
return(accessor.HasRowsBefore(e));
}
public bool HasRowsAfter(Model.PCSampling e)
{
return(sqlmapper.QueryForObject <bool>("PCSampling.has_rows_after", e));
}
public Model.PCSampling GetNext(Model.PCSampling e)
{
return(sqlmapper.QueryForObject <Model.PCSampling>("PCSampling.get_next", e));
}
public bool HasRowsBefore(Model.PCSampling e)
{
return(sqlmapper.QueryForObject <bool>("PCSampling.has_rows_before", e));
}
public void Update(Model.PCSampling e)
{
this.Update <Model.PCSampling>(e);
}
public void Insert(Model.PCSampling e)
{
this.Insert <Model.PCSampling>(e);
}
public void Delete(Model.PCSampling model)
{
if (model != null)
this.Delete(model.PCSamplingId);
}
protected override void MoveFirst()
{
this._PCSampling = this.manager.GetFirst();
}
