private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
int col = dataGridView1.SelectedCells[0].ColumnIndex;
int row = dataGridView1.SelectedCells[0].RowIndex;
if (col == 5)
{
if (dataGridView1.Columns[col].Name.ToUpper() == "GIATIEN")
{
string GiaTienUpdate = dataGridView1.SelectedCells[0].Value.ToString();
string IDSuDungDichVu = dataGridView1.Rows[row].Cells[4].Value.ToString();
string sql = "UPDATE DBA_USER.DANH_SACH_SU_DUNG_DICH_VU SET GIATIEN=" + GiaTienUpdate + " WHERE ID_SUDUNGDICHVU=" + IDSuDungDichVu;
TaiVu.runSQL(conn, sql);
}
}
}
private void label13_Click(object sender, EventArgs e)
{
string Ma = dataGridView1.Rows[rowInsert].Cells[0].Value.ToString();
string Ten = dataGridView1.Rows[rowInsert].Cells[1].Value.ToString();
string Gia = dataGridView1.Rows[rowInsert].Cells[2].Value.ToString();
if (num == 1)
{
sqlInsert = "INSERT INTO DBA_USER.THUOC VALUES(" + Ma + ",'" + Ten + "'," + Gia + ")";
}
else if (num == 5)
{
sqlInsert = "INSERT INTO DBA_USER.DICH_VU_KHAM_BENH VALUES(" + Ma + ",'" + Ten + "'," + Gia + ")";
}
TaiVu.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;
if (col == 2)
{
if (dataGridView1.Columns[col].Name.ToUpper() == "GIATHUOC")
{
string GiaThuocUpdate = dataGridView1.SelectedCells[0].Value.ToString();
string MaThuoc = dataGridView1.Rows[row].Cells[0].Value.ToString();
string sql = "UPDATE DBA_USER.THUOC SET GIATHUOC=" + GiaThuocUpdate + " WHERE MATHUOC=" + MaThuoc;
TaiVu.runSQL(conn, sql);
}
else if (dataGridView1.Columns[col].Name.ToUpper() == "GIADV")
{
string GiaDVUpdate = dataGridView1.SelectedCells[0].Value.ToString();
string MaDV = dataGridView1.Rows[row].Cells[0].Value.ToString();
string sql = "UPDATE DBA_USER.DICH_VU_KHAM_BENH SET GIADV=" + GiaDVUpdate + " WHERE MADV=" + MaDV;
TaiVu.runSQL(conn, sql);
}
}
}
