protected override void Delete()
{
if (this._ThicknessTest == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
//this._ThicknessTestManager.DeleteByPCPGOnlineCheckDetailId(this._ThicknessTest.ThicknessTestId);
this._ThicknessTestManager.Delete(this._ThicknessTest.ThicknessTestId);
if (this.sourceInvoice == 0)
{
this._ThicknessTest = this._ThicknessTestManager.mGetNext(this._ThicknessTest.InsertTime.Value, this._PCPGOnlineCheckDetailId);
if (this._ThicknessTest == null)
{
this._ThicknessTest = this._ThicknessTestManager.mGetLast(this._PCPGOnlineCheckDetailId);
}
}
else if (this.sourceInvoice == 1)
{
this._ThicknessTest = this._ThicknessTestManager.PFCGetNext(this._ThicknessTest.InsertTime.Value, this._PCFirstOnlineCheckDetailId);
if (this._ThicknessTest == null)
{
this._ThicknessTest = this._ThicknessTestManager.PFCGetLast(this._PCFirstOnlineCheckDetailId);
}
}
}
public void Update(Model.ThicknessTest thicknessTest)
{
Validate(thicknessTest);
try
{
BL.V.BeginTransaction();
detailManager.DeleteByheaderId(thicknessTest.ThicknessTestId);
foreach (Model.ThicknessTestDetails d in thicknessTest.Details)
{
d.ThicknessTestId = thicknessTest.ThicknessTestId;
detailManager.Insert(d);
}
thicknessTest.UpdateTime = DateTime.Now;
accessor.Update(thicknessTest);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public ROThicknessTest(Model.ThicknessTest thicknessTest)
: this()
{
if (thicknessTest == null)
{
return;
}
lblCompanyName.Text = BL.Settings.CompanyChineseName;
lblROThicknessTest.Text = Book.UI.Properties.Resources.ROThicknessTest;
lblTestId.Text = thicknessTest.ThicknessTestId;
lblPerspective.Text = thicknessTest.Perspectiverate.ToString();
lblTestDate.Text = thicknessTest.ThicknessTestDate.Value.ToString("yyyy-MM-dd");
lblRemarks.Text = thicknessTest.ThicknessDescript;
lblEmployee.Text = thicknessTest.Employee.EmployeeName;
lblPrintTime.Text += DateTime.Now.ToShortDateString();
this.DataSource = thicknessTest.Details;
TCThickness.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_HouduBiao);
TCGuanKou.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrGuanKou);
TCGuanKouDuiMian.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrGuanKouFengMian);
TCL1.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrL1);
TCL2.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrL2);
TCL3.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrL3);
TCL4.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrL4);
TCL5.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrL5);
TCR1.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrR1);
TCR2.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrR2);
TCR3.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrR3);
TCR4.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrR4);
TCR5.DataBindings.Add("Text", this.DataSource, Model.ThicknessTestDetails.PRO_attrR5);
}
protected override void MoveNext()
{
Model.ThicknessTest mThicknessTest = this._ThicknessTestManager.mGetNext(this._ThicknessTest.InsertTime.Value, this._PCPGOnlineCheckDetailId);
if (mThicknessTest == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._ThicknessTest = this._ThicknessTestManager.Get(mThicknessTest.ThicknessTestId);
}
protected override void AddNew()
{
this._ThicknessTest = new Model.ThicknessTest();
this._ThicknessTest.ThicknessTestId = this._ThicknessTestManager.GetId();
//this._ThicknessTest.PCPGOnlineCheckDetailId = this._PCPGOnlineCheckDetailId;
this._ThicknessTest.ThicknessTestDate = DateTime.Now;
this._ThicknessTest.Employee = BL.V.ActiveOperator.Employee;
this._ThicknessTest.EmployeeId = BL.V.ActiveOperator.EmployeeId;
this._ThicknessTest.Details = new List <Model.ThicknessTestDetails>();
}
protected override void MoveFirst()
{
//this._ThicknessTest = this._ThicknessTestManager.Get(this._ThicknessTestManager.mGetFirst(this._PCPGOnlineCheckDetailId) == null ? "" : this._ThicknessTestManager.mGetFirst(this._PCPGOnlineCheckDetailId).ThicknessTestId);
if (this.sourceInvoice == 0)
{
this._ThicknessTest = this._ThicknessTestManager.mGetFirst(this._PCPGOnlineCheckDetailId);
}
else if (this.sourceInvoice == 1)
{
this._ThicknessTest = this._ThicknessTestManager.PFCGetFirst(this._PCFirstOnlineCheckDetailId);
}
}
private void bar_Copy_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//if (string.IsNullOrEmpty(this._PCPGOnlineCheckDetailId))
//{
// MessageBox.Show("複製功能只適用於\"光學/厚度表\"！", "提示", MessageBoxButtons.OK);
// return;
//}
try
{
//ThicknessTestCopyForm f = new ThicknessTestCopyForm(this._pCPGOnlineCheckDetail);
string fromId = string.Empty;
string pronoteHeaderId = string.Empty;
if (sourceInvoice == 0)
{
fromId = _PCPGOnlineCheckDetailId;
pronoteHeaderId = this._pCPGOnlineCheckDetail.FromInvoiceId;
}
else if (sourceInvoice == 1)
{
fromId = _PCFirstOnlineCheckDetailId;
pronoteHeaderId = this.PronoteHeaderId;
}
ThicknessTestCopyForm f = new ThicknessTestCopyForm(fromId, pronoteHeaderId, sourceInvoice);
if (f.ShowDialog(this) == DialogResult.OK)
{
this._ThicknessTest = null;
if (sourceInvoice == 0)
{
this._ThicknessTest = this._ThicknessTestManager.Get(this._ThicknessTestManager.mGetLast(this._PCPGOnlineCheckDetailId) == null ? "" : this._ThicknessTestManager.mGetLast(this._PCPGOnlineCheckDetailId).ThicknessTestId);
}
else if (sourceInvoice == 1)
{
this._ThicknessTest = this._ThicknessTestManager.Get(this._ThicknessTestManager.PFCGetLast(this._PCFirstOnlineCheckDetailId) == null ? "" : this._ThicknessTestManager.PFCGetLast(this._PCFirstOnlineCheckDetailId).ThicknessTestId);
}
if (this._ThicknessTest != null)
{
this.action = "view";
this.Refresh();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK);
}
}
public override void Refresh()
{
if (this._ThicknessTest == null)
{
this.AddNew();
this.action = "insert";
}
else
{
if (this.action == "view")
{
this._ThicknessTest = this._ThicknessTestManager.GetDetail(this._ThicknessTest.ThicknessTestId);
}
}
this.txtThicknessTestId.Text = this._ThicknessTest.ThicknessTestId;
//this.txtManualid.Text = this._ThicknessTest.manualId;
this.deThicknessTestDate.EditValue = this._ThicknessTest.ThicknessTestDate.Value;
this.txtThicknessDescript.Text = this._ThicknessTest.ThicknessDescript;
this.nccEmployee.EditValue = this._ThicknessTest.Employee;
this.spinPerspectiverateL.EditValue = this._ThicknessTest.Perspectiverate.HasValue ? this._ThicknessTest.Perspectiverate.Value : 0;
this.spinPerspectiverateR.EditValue = this._ThicknessTest.PerspectiverateRight.HasValue ? this._ThicknessTest.PerspectiverateRight.Value : 0;
this.bindingSource1.DataSource = this._ThicknessTest.Details;
base.Refresh();
switch (this.action)
{
case "insert":
this.barBtn_Search.Enabled = false;
this.gridView1.OptionsBehavior.Editable = true;
break;
case "update":
this.barBtn_Search.Enabled = false;
this.gridView1.OptionsBehavior.Editable = true;
break;
case "view":
this.barBtn_Search.Enabled = true;
this.gridView1.OptionsBehavior.Editable = false;
break;
}
this.txtThicknessTestId.Properties.ReadOnly = true;
}
private void barBtn_Search_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
ThicknessTestList f = new ThicknessTestList(this._PCPGOnlineCheckDetailId);
if (f.ShowDialog(this) == DialogResult.OK)
{
Model.ThicknessTest currentModel = f.SelectItem as Model.ThicknessTest;
if (currentModel != null)
{
this._ThicknessTest = currentModel;
this.Refresh();
}
}
f.Dispose();
GC.Collect();
}
private void TiGuiExists(Model.ThicknessTest model)
{
if (this.ExistsPrimary(model.ThicknessTestId))
{
//设置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.ThicknessTestId = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
}
}
protected override void AddNew()
{
this._ThicknessTest = new Model.ThicknessTest();
this._ThicknessTest.ThicknessTestId = this._ThicknessTestManager.GetId();
this._ThicknessTest.PCPGOnlineCheckDetailId = this._PCPGOnlineCheckDetailId;
this._ThicknessTest.ThicknessTestDate = DateTime.Now;
this._ThicknessTest.Details = new List <Model.ThicknessTestDetails>();
for (int i = 1; i < 9; i++)
{
Model.ThicknessTestDetails d = new Book.Model.ThicknessTestDetails();
d.ThicknessTestDetailsId = Guid.NewGuid().ToString();
d.ThicknessTestId = this._ThicknessTest.ThicknessTestId;
d.HouduBiao = "#" + i.ToString() + " No.";
this._ThicknessTest.Details.Add(d);
}
}
protected override void MovePrev()
{
//Model.ThicknessTest mThicknessTest = this._ThicknessTestManager.mGetPrev(this._ThicknessTest.InsertTime.Value, this._PCPGOnlineCheckDetailId);
Model.ThicknessTest mThicknessTest = null;
if (this.sourceInvoice == 0)
{
mThicknessTest = this._ThicknessTestManager.mGetPrev(this._ThicknessTest.InsertTime.Value, this._PCPGOnlineCheckDetailId);
}
else if (this.sourceInvoice == 1)
{
mThicknessTest = this._ThicknessTestManager.PFCGetPrev(this._ThicknessTest.InsertTime.Value, this._PCFirstOnlineCheckDetailId);
}
if (mThicknessTest == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._ThicknessTest = this._ThicknessTestManager.Get(mThicknessTest.ThicknessTestId);
}
private void Validate(Model.ThicknessTest thicknessTest)
{
if (string.IsNullOrEmpty(thicknessTest.ThicknessTestId))
{
throw new Helper.RequireValueException(Model.ThicknessTest.PRO_ThicknessTestId);
}
if (string.IsNullOrEmpty(thicknessTest.ThicknessTestDate.Value.ToString()))
{
throw new Helper.RequireValueException(Model.ThicknessTest.PRO_ThicknessTestDate);
}
if (string.IsNullOrEmpty(thicknessTest.EmployeeId))
{
throw new Helper.RequireValueException(Model.ThicknessTest.PRO_EmployeeId);
}
//if (string.IsNullOrEmpty(thicknessTest.manualId))
// throw new Helper.RequireValueException(Model.ThicknessTest.PRO_manualId);
if (accessor.ExistsManualId(thicknessTest.ThicknessTestId, thicknessTest.manualId))
{
throw new Helper.InvalidValueException(Model.ThicknessTest.PRO_manualId);
}
}
protected override void AddNew()
{
this._ThicknessTest = new Model.ThicknessTest();
this._ThicknessTest.ThicknessTestId = this._ThicknessTestManager.GetId();
this._ThicknessTest.PCPGOnlineCheckDetailId = this._PCPGOnlineCheckDetailId;
this._ThicknessTest.ThicknessTestDate = DateTime.Now;
this._ThicknessTest.Employee = BL.V.ActiveOperator.Employee;
this._ThicknessTest.EmployeeId = BL.V.ActiveOperator.EmployeeId;
this._ThicknessTest.Details = new List <Model.ThicknessTestDetails>();
//改为只添加一项
//for (int i = 1; i < 9; i++)
//{
Model.ThicknessTestDetails d = new Book.Model.ThicknessTestDetails();
d.ThicknessTestDetailsId = Guid.NewGuid().ToString();
d.ThicknessTestId = this._ThicknessTest.ThicknessTestId;
d.HouduBiao = "#1 號片";
this._ThicknessTest.Details.Add(d);
//}
}
public void Insert(Model.ThicknessTest thicknessTest)
{
Validate(thicknessTest);
try
{
BL.V.BeginTransaction();
thicknessTest.InsertTime = DateTime.Now;
thicknessTest.UpdateTime = DateTime.Now;
TiGuiExists(thicknessTest);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, thicknessTest.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, thicknessTest.InsertTime.Value.Year, thicknessTest.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, thicknessTest.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(thicknessTest);
foreach (Model.ThicknessTestDetails d in thicknessTest.Details)
{
d.ThicknessTestId = thicknessTest.ThicknessTestId;
detailManager.Insert(d);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public bool HasRowsBefore(Model.ThicknessTest e)
{
return(accessor.HasRowsBefore(e));
}
public bool HasRowsAfter(Model.ThicknessTest e)
{
return(accessor.HasRowsAfter(e));
}
public Model.ThicknessTest GetPrev(Model.ThicknessTest e)
{
return(accessor.GetPrev(e));
}
public Model.ThicknessTest GetNext(Model.ThicknessTest e)
{
return(accessor.GetNext(e));
}
public Model.ThicknessTest GetNext(Model.ThicknessTest e)
{
return(sqlmapper.QueryForObject <Model.ThicknessTest>("ThicknessTest.get_next", e));
}
public void Update(Model.ThicknessTest e)
{
this.Update <Model.ThicknessTest>(e);
}
public bool PFCHasRowsAfter(Model.ThicknessTest e, string PCFirstOnlineCheckDetailId)
{
return(accessor.PFCHasRowsAfter(e, PCFirstOnlineCheckDetailId));
}
public bool mHasRowsAfter(Model.ThicknessTest e, string PCPGOnlineCheckDetailId)
{
return(accessor.mHasRowsAfter(e, PCPGOnlineCheckDetailId));
}
public bool HasRowsBefore(Model.ThicknessTest e)
{
return(sqlmapper.QueryForObject <bool>("ThicknessTest.has_rows_before", e));
}
public bool HasRowsAfter(Model.ThicknessTest e)
{
return(sqlmapper.QueryForObject <bool>("ThicknessTest.has_rows_after", e));
}
protected override void MoveFirst()
{
this._ThicknessTest = this._ThicknessTestManager.Get(this._ThicknessTestManager.mGetFirst(this._PCPGOnlineCheckDetailId) == null ? "" : this._ThicknessTestManager.mGetFirst(this._PCPGOnlineCheckDetailId).ThicknessTestId);
}
public void Insert(Model.ThicknessTest e)
{
this.Insert <Model.ThicknessTest>(e);
}
public Model.ThicknessTest GetDetail(string thicknessTestId)
{
Model.ThicknessTest thicknessTest = accessor.Get(thicknessTestId);
thicknessTest.Details = detailManager.SelectByHeaderId(thicknessTestId);
return(thicknessTest);
}
public Model.ThicknessTest GetPrev(Model.ThicknessTest e)
{
return(sqlmapper.QueryForObject <Model.ThicknessTest>("ThicknessTest.get_prev", e));
}
