Esempio n. 1
0
File: frmMain.cs Progetto: jolpr/MOP
        private void btnSearch_Click(object sender, EventArgs e)
        {
            SearchJob mySJob = null;
            string cnnstr = connectionString;
            string JobDescription = null;
            string customer = null;
            string customerTerms = null;
            string PONumber = "";

            try
            {

                dgvShipments.Columns.Clear();
                dgvItm.Columns.Clear();

                mySJob = new SearchJob(cnnstr);
                mySJob.getJobData(this.txtJobNum.Text.Trim(),
                                   ref JobDescription,
                                   ref customer,
                                   ref customerTerms, ref PONumber, dgvShipments
                                   );

                this.txtJobDes.Text = JobDescription;
                this.txtCustomer.Text = customer;
                this.txtCustomerTems.Text = customerTerms;
                this.txtCustomerPONum.Text  = PONumber;

                mySJob.getitem(txtJobNum.Text, myRowIndex, dgvItm);
                dgvShipments.Rows[0].Selected = true;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                mySJob = null;
            }
        }
Esempio n. 2
0
File: frmMain.cs Progetto: jolpr/MOP
 private void dgvShipments_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     SearchJob mySJob = null;
     try
     {
         mySJob = new SearchJob(connectionString);
         myRowIndex = dgvShipments.Rows[e.RowIndex].Cells[0].Value.ToString();
         mySJob.getitem(txtJobNum.Text, dgvShipments.Rows[e.RowIndex].Cells[0].Value.ToString(), dgvItm);
         mySJob.Dispose();
     }
     catch
     {
         //MessageBox.Show(ex.ToString());
     }
     finally
     {
         mySJob = null;
     }
 }