public void Insert(Model.OpticsTest opticsTest)
{
Validate(opticsTest);
try
{
BL.V.BeginTransaction();
opticsTest.InsertTime = DateTime.Now;
opticsTest.UpdateTime = DateTime.Now;
TiGuiExists(opticsTest);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, opticsTest.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, opticsTest.InsertTime.Value.Year, opticsTest.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, opticsTest.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(opticsTest);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw new Helper.InvalidValueException(Model.OpticsTest.PRO_PCPGOnlineCheckDetailId);
}
}
protected override void Delete()
{
if (this._OpticsTest == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
if (this._FromPcFinishCheck == 0)
{
this._OpticsTestManager.Delete(this._OpticsTest.OpticsTestId);
this._OpticsTest = this._OpticsTestManager.mGetNext(this._OpticsTest.InsertTime.Value, this._PCPGOnlineCheckDetailId);
if (this._OpticsTest == null)
{
this._OpticsTest = this._OpticsTestManager.mGetLast(this._PCPGOnlineCheckDetailId);
}
}
else
{
this._OpticsTestManager.Delete(this._OpticsTest.OpticsTestId);
this._OpticsTest = this._OpticsTestManager.FGetNext(this._OpticsTest.InsertTime.Value, this._PCFinishCheckId);
if (this._OpticsTest == null)
{
this._OpticsTest = this._OpticsTestManager.FGetLast(this._PCFinishCheckId);
}
}
}
private void barBtn_Search_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
OpticsTestList f = null;
if (this._FromPcFinishCheck == 0)
{
f = new OpticsTestList(this._PCPGOnlineCheckDetailId);
}
else
{
f = new OpticsTestList(this._PCFinishCheckId, this._FromPcFinishCheck);
}
if (f.ShowDialog(this) == DialogResult.OK)
{
Model.OpticsTest currentModel = f.SelectItem as Model.OpticsTest;
if (currentModel != null)
{
this._OpticsTest = currentModel;
this.Refresh();
}
}
f.Dispose();
GC.Collect();
}
public ROOpticsTest(Model.OpticsTest opticsTest)
: this()
{
if (opticsTest == null)
{
return;
}
lblCompanyName.Text = BL.Settings.CompanyChineseName;
lblROPCOpticsCheck.Text = Book.UI.Properties.Resources.ROPCOpticsCheck;
lblTestId.Text = opticsTest.OpticsTestId;
lblManualTestId.Text = opticsTest.ManualId;
lblTestTime.Text = opticsTest.OptiscTestDate.Value.ToString("yyyy-MM-dd");
lblCheckModel.Text = opticsTest.MachineName;
lblCheckCondition.Text = opticsTest.Condition;
lblTestEmployee.Text = opticsTest.Employee.ToString();
lblPrintTime.Text += DateTime.Now.ToString("yyyy-MM-dd");
//lblRemarks.Text=opticsTest.
lblLeftA.Text = opticsTest.LattrA.ToString();
lblLeftC.Text = opticsTest.LattrC.ToString();
lblLeftDOWN.Text = opticsTest.LdownPSM.ToString();
lblLeftIN.Text = opticsTest.LinPSM.ToString();
lblLeftOUT.Text = opticsTest.LoutPSM.ToString();
lblLeftS.Text = opticsTest.LattrS.ToString();
lblLeftUP.Text = opticsTest.LupPSM.ToString();
lblRightA.Text = opticsTest.RattrA.ToString();
lblRightC.Text = opticsTest.RattrC.ToString();
lblRightDOWN.Text = opticsTest.RdowmPSM.ToString();
lblRightIN.Text = opticsTest.RinPSM.ToString();
lblRightOUT.Text = opticsTest.RoutPSM.ToString();
lblRightS.Text = opticsTest.RattrS.ToString();
lblRightUP.Text = opticsTest.RupPSM.ToString();
}
protected override void MoveFirst()
{
if (this._FromPcFinishCheck == 0)
{
this._OpticsTest = this._OpticsTestManager.Get(this._OpticsTestManager.mGetFirst(this._PCPGOnlineCheckDetailId) == null ? "" : this._OpticsTestManager.mGetFirst(this._PCPGOnlineCheckDetailId).OpticsTestId);
}
else
{
this._OpticsTest = this._OpticsTestManager.Get(this._OpticsTestManager.FGetFirst(this._PCFinishCheckId) == null ? "" : this._OpticsTestManager.FGetFirst(this._PCFinishCheckId).OpticsTestId);
}
}
protected override void AddNew()
{
this._OpticsTest = new Book.Model.OpticsTest();
this._OpticsTest.OpticsTestId = this._OpticsTestManager.GetId();
this._OpticsTest.PCPGOnlineCheckDetailId = null;
this._OpticsTest.PCFinishCheckId = null;
this._OpticsTest.OptiscTestDate = DateTime.Now;
this._OpticsTest.LattrA = 180;
this._OpticsTest.RattrA = 180;
this._OpticsTest.LattrC = 0;
this._OpticsTest.RattrC = 0;
}
private void bar_Copy_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//if (string.IsNullOrEmpty(this._PCPGOnlineCheckDetailId))
//{
// MessageBox.Show("複製功能只適用於\"光學/厚度表\"！", "提示", MessageBoxButtons.OK);
// return;
//}
try
{
//OpticsTestCopyForm f = new OpticsTestCopyForm(this._pCPGOnlineCheckDetail);
string fromId = string.Empty;
string pronoteHeaderId = string.Empty;
int invoiceType = 0;
if (sourceInvoice == 0)
{
fromId = _PCPGOnlineCheckDetailId;
pronoteHeaderId = this._pCPGOnlineCheckDetail.FromInvoiceId;
}
else if (sourceInvoice == 2)
{
fromId = _PCFirstOnlineCheckDetailId;
pronoteHeaderId = this.PronoteHeaderId;
invoiceType = 1;
}
OpticsTestCopyForm f = new OpticsTestCopyForm(fromId, pronoteHeaderId, invoiceType);
if (f.ShowDialog(this) == DialogResult.OK)
{
this._OpticsTest = null;
if (sourceInvoice == 0)
{
this._OpticsTest = this._OpticsTestManager.Get(this._OpticsTestManager.mGetLast(this._PCPGOnlineCheckDetailId) == null ? "" : this._OpticsTestManager.mGetLast(this._PCPGOnlineCheckDetailId).OpticsTestId);
}
else if (sourceInvoice == 2)
{
this._OpticsTest = this._OpticsTestManager.Get(this._OpticsTestManager.PFCGetLast(this._PCFirstOnlineCheckDetailId) == null ? "" : this._OpticsTestManager.PFCGetLast(this._PCFirstOnlineCheckDetailId).OpticsTestId);
}
if (this._OpticsTest != null)
{
this.action = "view";
this.Refresh();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK);
}
}
protected override void MoveFirst()
{
if (this.sourceInvoice == 0)
{
this._OpticsTest = this._OpticsTestManager.Get(this._OpticsTestManager.mGetFirst(this._PCPGOnlineCheckDetailId) == null ? "" : this._OpticsTestManager.mGetFirst(this._PCPGOnlineCheckDetailId).OpticsTestId);
}
else if (this.sourceInvoice == 1)
{
this._OpticsTest = this._OpticsTestManager.Get(this._OpticsTestManager.FGetFirst(this._PCFinishCheckId) == null ? "" : this._OpticsTestManager.FGetFirst(this._PCFinishCheckId).OpticsTestId);
}
else if (this.sourceInvoice == 2)
{
this._OpticsTest = this._OpticsTestManager.Get(this._OpticsTestManager.PFCGetFirst(this._PCFirstOnlineCheckDetailId) == null ? "" : this._OpticsTestManager.PFCGetFirst(this._PCFirstOnlineCheckDetailId).OpticsTestId);
}
}
protected override void AddNew()
{
this._OpticsTest = new Book.Model.OpticsTest();
this._OpticsTest.OpticsTestId = this._OpticsTestManager.GetId();
this._OpticsTest.PCPGOnlineCheckDetailId = null;
this._OpticsTest.PCFinishCheckId = null;
this._OpticsTest.OptiscTestDate = DateTime.Now;
this._OpticsTest.LattrA = 180;
this._OpticsTest.RattrA = 180;
this._OpticsTest.LattrC = 0;
this._OpticsTest.RattrC = 0;
this._OpticsTest.Employee = BL.V.ActiveOperator.Employee;
this._OpticsTest.EmployeeId = BL.V.ActiveOperator.EmployeeId;
this._OpticsTest.MachineName = "TOPCON CL-2800"; //默认此机型
}
protected override void MoveNext()
{
Model.OpticsTest mOpticsTest = null;
if (this._FromPcFinishCheck == 0)
{
mOpticsTest = this._OpticsTestManager.mGetNext(this._OpticsTest.InsertTime.Value, this._PCPGOnlineCheckDetailId);
}
else
{
mOpticsTest = this._OpticsTestManager.FGetNext(this._OpticsTest.InsertTime.Value, this._PCFinishCheckId);
}
if (mOpticsTest == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._OpticsTest = this._OpticsTestManager.Get(mOpticsTest.OpticsTestId);
}
private void TiGuiExists(Model.OpticsTest model)
{
if (this.ExistsPrimary(model.OpticsTestId))
{
//设置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.OpticsTestId = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
}
}
protected override void MovePrev()
{
Model.OpticsTest mOpticsTest = null;
if (this.sourceInvoice == 0)
{
mOpticsTest = this._OpticsTestManager.mGetPrev(this._OpticsTest.InsertTime.Value, this._PCPGOnlineCheckDetailId);
}
else if (this.sourceInvoice == 1)
{
mOpticsTest = this._OpticsTestManager.FGetPrev(this._OpticsTest.InsertTime.Value, this._PCFinishCheckId);
}
else if (this.sourceInvoice == 2)
{
mOpticsTest = this._OpticsTestManager.PFCGetPrev(this._OpticsTest.InsertTime.Value, this._PCFirstOnlineCheckDetailId);
}
if (mOpticsTest == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._OpticsTest = this._OpticsTestManager.Get(mOpticsTest.OpticsTestId);
}
private void Validate(Model.OpticsTest opticsTest)
{
if (string.IsNullOrEmpty(opticsTest.OpticsTestId))
{
throw new Helper.RequireValueException(Model.OpticsTest.PRO_OpticsTestId);
}
if (string.IsNullOrEmpty(opticsTest.OptiscTestDate.Value.ToString()))
{
throw new Helper.RequireValueException(Model.OpticsTest.PRO_OptiscTestDate);
}
if (string.IsNullOrEmpty(opticsTest.EmployeeId))
{
throw new Helper.RequireValueException(Model.OpticsTest.PRO_EmployeeId);
}
if (string.IsNullOrEmpty(opticsTest.MachineName))
{
throw new Helper.RequireValueException(Model.OpticsTest.PRO_MachineName);
}
//if (string.IsNullOrEmpty(opticsTest.ManualId))
// throw new Helper.RequireValueException(Model.OpticsTest.PRO_ManualId);
//if (accessor.ExistsManualId(opticsTest.OpticsTestId, opticsTest.ManualId))
// throw new Helper.InvalidValueException(Model.OpticsTest.PRO_ManualId);
}
public void Update(Model.OpticsTest opticsTest)
{
Validate(opticsTest);
opticsTest.UpdateTime = DateTime.Now;
accessor.Update(opticsTest);
}
public bool HasRowsAfter(Model.OpticsTest e)
{
return(sqlmapper.QueryForObject <bool>("OpticsTest.has_rows_after", e));
}
public Model.OpticsTest GetPrev(Model.OpticsTest e)
{
return(accessor.GetPrev(e));
}
public bool HasRowsAfter(Model.OpticsTest e)
{
return(accessor.HasRowsAfter(e));
}
public void Update(Model.OpticsTest e)
{
this.Update <Model.OpticsTest>(e);
}
public Model.OpticsTest GetPrev(Model.OpticsTest e)
{
return(sqlmapper.QueryForObject <Model.OpticsTest>("OpticsTest.get_prev", e));
}
public Model.OpticsTest GetNext(Model.OpticsTest e)
{
return(sqlmapper.QueryForObject <Model.OpticsTest>("OpticsTest.get_next", e));
}
public Model.OpticsTest GetNext(Model.OpticsTest e)
{
return(accessor.GetNext(e));
}
public bool PFCHasRowsAfter(Model.OpticsTest e, string PCFirstOnlineCheckDetailId)
{
return(accessor.PFCHasRowsAfter(e, PCFirstOnlineCheckDetailId));
}
public void Insert(Model.OpticsTest e)
{
this.Insert <Model.OpticsTest>(e);
}
public bool mHasRowsAfter(Model.OpticsTest e, string PCPGOnlineCheckDetailId)
{
return(accessor.mHasRowsAfter(e, PCPGOnlineCheckDetailId));
}
public bool HasRowsBefore(Model.OpticsTest e)
{
return(sqlmapper.QueryForObject <bool>("OpticsTest.has_rows_before", e));
}
public bool FHasRowsAfter(Model.OpticsTest e, string PCFinishCheckId)
{
return(accessor.FHasRowsAfter(e, PCFinishCheckId));
}
public bool HasRowsBefore(Model.OpticsTest e)
{
return(accessor.HasRowsBefore(e));
}
