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