private void dataGridView2_CellValueChanged(object sender, DataGridViewCellEventArgs e) { int col = dataGridView2.SelectedCells[0].ColumnIndex; int row = dataGridView2.SelectedCells[0].RowIndex; Console.WriteLine("col:" + col); Console.WriteLine("row:" + row); if (col == 4) { if (dataGridView2.Columns[col].Name.ToUpper() == "MATHUOC") { string mathuoc = dataGridView2.SelectedCells[0].Value.ToString(); string madsdt = dataGridView2.Rows[row].Cells[0].Value.ToString(); string sql = "UPDATE DBA_USER.DANH_SACH_DON_THUOC SET MATHUOC= " + mathuoc + " WHERE ID_DANHSACHDONTHUOC=" + madsdt; Console.Write(sql); BacSi.runSQL(conn, sql); } } if (col == 5) { if (dataGridView2.Columns[col].Name.ToUpper() == "SOLUONG") { string soluong = dataGridView2.SelectedCells[0].Value.ToString(); string mast = dataGridView2.Rows[row].Cells[0].Value.ToString(); string sql = "UPDATE DBA_USER.DANH_SACH_DON_THUOC SET SOLUONG=" + soluong + " WHERE ID_DANHSACHDONTHUOC=" + mast; Console.Write(sql); BacSi.runSQL(conn, sql); } } }
private void button5_Click(object sender, EventArgs e) { BacSi a = new BacSi(); a.themthuocvaodonthuoc(conn); string iddonthuoc = textBox7.Text; string mathuoc = textBox8.Text; string soluong = textBox9.Text; string sqlInsert = "INSERT INTO DBA_USER.DANH_SACH_DON_THUOC(ID_DANHSACHDONTHUOC, MADT, MATHUOC, SOLUONG, DONGIA) VALUES ((SELECT MAX(ID_DANHSACHDONTHUOC) FROM DBA_USER.DANH_SACH_DON_THUOC)+1, " + iddonthuoc + ", " + mathuoc + "," + soluong + ", 15000)"; // string sqlInsert = "INSERT INTO DBA_USER.DANH_SACH_DON_THUOC(ID_DANHSACHDONTHUOC, MADT, MATHUOC, SOLUONG, DONGIA) VALUES ( (SELECT MAX(ID_DANHSACHDONTHUOC) FROM DBA_USER.DANH_SACH_DON_THUOC ) + 1,"+iddonthuoc+", "+mathuoc+", "+soluong+", '30000')"; Console.Write(sqlInsert); BacSi.runSQL(conn, sqlInsert); MessageBox.Show("Đã thêm thành công!"); }
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { int col = dataGridView1.SelectedCells[0].ColumnIndex; int row = dataGridView1.SelectedCells[0].RowIndex; Console.WriteLine("col:" + col); Console.WriteLine("row:" + row); if (col == 3) { if (dataGridView1.Columns[col].Name.ToUpper() == "TRIEUCHUNGBENH") { string trieuchungUpdate = dataGridView1.SelectedCells[0].Value.ToString(); string mabenhnhan = dataGridView1.Rows[row].Cells[0].Value.ToString(); string sql = "UPDATE DBA_USER.BENH_NHAN_BAC_SI_VIEW SET TRIEUCHUNGBENH = '" + trieuchungUpdate + "' WHERE MABENHNHAN=" + mabenhnhan; Console.Write(sql); BacSi.runSQL(conn, sql); } } }