Ejemplo n.º 1
0
 private void BindData()
 {
     KB.DAL.DBHelper db = new KB.DAL.DBHelper();
     try
     {
         KB.BLL.DATA0395BLL bll = new KB.BLL.DATA0395BLL(db);
         var tb = bll.QueryMirForMaintenanceOrder(textBoxCode.Text.Trim());
         dataGridView1.DataSource = null;
         dataGridView1.DataSource = tb;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
     finally
     {
         db.CloseConnection();
     }
 }
Ejemplo n.º 2
0
        private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (dataGridView1.CurrentCell != null && e.RowIndex >= 0)
            {
                KB.DAL.DBHelper db = new KB.DAL.DBHelper();
                try
                {
                    KB.BLL.DATA0172BLL data0172BLL = new KB.BLL.DATA0172BLL(db);
                    KB.BLL.DATA0395BLL data0395BLL = new KB.BLL.DATA0395BLL(db);
                    Data0172 = data0172BLL.getDATA0172ByRECORD_KEY_MO(decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()));
                    Data0395 = data0395BLL.getDATA0395ByRKEY(decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()));

                    this.DialogResult = DialogResult.OK;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
                finally
                {
                    db.CloseConnection();
                }
            }
        }