Issues after clear
unknown
csharp
3 years ago
8.4 kB
7
Indexable
// ************************************************** // Custom code for VendorForm // Created: 3/17/2022 3:39:43 PM // ************************************************** using System; using System.ComponentModel; using System.Data; using System.Diagnostics; using System.Windows.Forms; using Erp.UI; using Ice.Lib; using Ice.BO; using Ice.Adapters; using Ice.Lib.Customization; using Ice.Lib.ExtendedProps; using Ice.Lib.Framework; using Ice.Lib.Searches; using Ice.UI.FormFunctions; using Ice.Lib.Broadcast; using System.Reflection; public class Script { // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! ** // Begin Wizard Added Module Level Variables ** // End Wizard Added Module Level Variables ** // Add Custom Module Level Variables Here ** BAQDataView baqViewDateRange; string pubBinding; IPublisher pub; public static bool IsDateMin(string input) { DateTime temp; return DateTime.TryParse(input, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out temp) && temp.Hour == 0 && temp.Minute == 0 && temp.Second == 0 && temp.Millisecond == 0 && temp > DateTime.MinValue; } public void InitializeCustomCode() { // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines ** // Begin Wizard Added Variable Initialization // End Wizard Added Variable Initialization // Begin Wizard Added Custom Method Calls this.btnAddDates.Click += new System.EventHandler(this.btnAddDates_Click); this.ugInvRange.InitializeLayout += new Infragistics.Win.UltraWinGrid.InitializeLayoutEventHandler(this.ugInvRange_InitializeLayout); this.txtVendID.TextChanged += new System.EventHandler(this.txtVendID_TextChanged); this.dtStartDate.AfterExitEditMode += new System.EventHandler(this.dtStartDate_AfterExitEditMode); this.dtEndDate.AfterExitEditMode += new System.EventHandler(this.dtEndDate_AfterExitEditMode); //this.VendorForm.AfterToolClick += new Ice.Lib.Framework.AfterToolClickEventHandler(this.VendorForm_AfterToolClick); CreateDateRangeBAQView(); // End Wizard Added Custom Method Calls } public void CreateDateRangeBAQView() { baqViewDateRange = new BAQDataView("JBIS-SupplierListQry"); oTrans.Add("JBIS-SupplierListQry",baqViewDateRange); string pubBinding = "VendorDetail.VendorID"; IPublisher pub = oTrans.GetPublisher(pubBinding); if(pub==null || string.IsNullOrEmpty(txtVendID.Text)) { //check if the pub exists oTrans.PublishColumnChange(pubBinding, "vendorNumPub"); pub = oTrans.GetPublisher(pubBinding); MessageBox.Show("Clearing pubBinding"); } if(pub != null) { baqViewDateRange.SubscribeToPublisher(pub.PublishName, "Vendor_VendorID"); } } public void DestroyCustomCode() { // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines ** // Begin Wizard Added Object Disposal this.btnAddDates.Click -= new System.EventHandler(this.btnAddDates_Click); this.ugInvRange.InitializeLayout -= new Infragistics.Win.UltraWinGrid.InitializeLayoutEventHandler(this.ugInvRange_InitializeLayout); this.txtVendID.TextChanged -= new System.EventHandler(this.txtVendID_TextChanged); this.dtEndDate.AfterExitEditMode -= new System.EventHandler(this.dtEndDate_AfterExitEditMode); this.dtStartDate.AfterExitEditMode -= new System.EventHandler(this.dtStartDate_AfterExitEditMode); //this.VendorForm.AfterToolClick -= new Ice.Lib.Framework.AfterToolClickEventHandler(this.VendorForm_AfterToolClick); // End Wizard Added Object Disposal // Begin Custom Code Disposal // End Custom Code Disposal } private void RefreshBAQDataView(BAQDataView iBaqView) { MethodInfo mi = iBaqView.GetType().GetMethod("invokeExecute", BindingFlags.Instance | BindingFlags.NonPublic); mi.Invoke(iBaqView, new object[]{ true }); } private void ClearBAQDataView(BAQDataView iBaqView) { FieldInfo dqAdapter = iBaqView.GetType().GetField("dqAdapter", BindingFlags.Instance | BindingFlags.NonPublic); Ice.Adapters.DynamicQueryAdapter dsQ = (Ice.Adapters.DynamicQueryAdapter)dqAdapter.GetValue(iBaqView); dsQ.QueryResults.Clear(); } private void btnAddDates_Click(object sender, System.EventArgs args) { // ** Place Event Handling Code Here ** if (string.IsNullOrEmpty(txtVendID.Text)) { MessageBox.Show("Please enter customer"); } else { DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans); dqa.BOConnect(); QueryExecutionDataSet qeds = dqa.GetQueryExecutionParametersByID("JBIS-SuppInvLkUp"); qeds.ExecutionParameter.Clear(); qeds.ExecutionParameter.AddExecutionParameterRow("ConfirmSupplier", txtVendID.Text, "nvarchar",false, Guid.NewGuid(),"A"); qeds.ExecutionParameter.AddExecutionParameterRow("FromDate", dtStartDate.Text, "date",false, Guid.NewGuid(),"d"); qeds.ExecutionParameter.AddExecutionParameterRow("ToDate", dtEndDate.Text, "date",false, Guid.NewGuid(),"d"); dqa.ExecuteByID("JBIS-SuppInvLkUp",qeds); MessageBox.Show("about to show results"); ugInvRange.DataSource = dqa.QueryResults.Tables["Results"]; } } private void ugInvRange_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs args) { // ** Place Event Handling Code Here ** args.Layout.Bands[0].Columns[3].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[4].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[7].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[10].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[11].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[12].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[27].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[40].Format = "###,###,##0.00"; args.Layout.Bands[0].Columns[41].Format = "###,###,##0.00"; } private void txtVendID_TextChanged(object sender, System.EventArgs args) { // ** Place Event Handling Code Here ** if (string.IsNullOrEmpty(txtVendID.Text)) { ugInvRange.DataSource = null; dtStartDate.Text = "12/31/2021"; dtEndDate.Text = "12/31/2021"; txtVendID.Text = ""; ClearBAQDataView(baqViewDateRange); string pubBinding = "VendorDetail.VendorID"; IPublisher pub = oTrans.GetPublisher(pubBinding); oTrans.PublishColumnChange(pubBinding, "vendorNumPub"); pub = oTrans.GetPublisher(pubBinding); MessageBox.Show("Clearing pubBinding after ttxtvendid textchanged"); } } private void dtStartDate_AfterExitEditMode(object sender, System.EventArgs args) { if (IsDateMin(dtStartDate.Text)) { DateTime? endDate = DateTime.Parse(dtEndDate.Text); DateTime? startDate = DateTime.Parse(dtStartDate.Text); //string eD = endDate.ToString(); //string sD = startDate.ToString(); // ** Place Event Handling Code Here ** if(DateTime.Parse(dtStartDate.Text)>(DateTime.Parse(dtEndDate.Text))) { MessageBox.Show("Start date is greater than end date, please fix this before continuing"); startDate = endDate.Value.AddDays(-1); string startDatePlusOne = startDate.ToString(); dtStartDate.Text = startDatePlusOne; } } else { MessageBox.Show("please enter an start date"); DateTime? endDate = DateTime.Parse(dtEndDate.Text); DateTime? startDate; startDate = endDate.Value.AddDays(-1); string startDatePlusOne = startDate.ToString(); dtStartDate.Text = startDatePlusOne; } } private void dtEndDate_AfterExitEditMode(object sender, System.EventArgs args) { // ** Place Event Handling Code Here ** if (IsDateMin(dtEndDate.Text)) { DateTime? endDate = DateTime.Parse(dtEndDate.Text); DateTime? startDate = DateTime.Parse(dtStartDate.Text); endDate = endDate.Value.AddDays(1); if(DateTime.Parse(dtEndDate.Text)<(DateTime.Parse(dtStartDate.Text))) { MessageBox.Show("End date is less than Start date, please fix this before continuing"); endDate = startDate.Value.AddDays(1); string endDatePlusOne = endDate.ToString(); dtEndDate.Text = endDatePlusOne; } } else { MessageBox.Show("please enter an end date"); DateTime? startDate= DateTime.Parse(dtStartDate.Text); DateTime? endDate; endDate = startDate.Value.AddDays(1); string endDatePlusOne = endDate.ToString(); dtEndDate.Text = endDatePlusOne; } } }
Editor is loading...