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)); }