// Šù‘¶ƒŒƒR[ƒh‚Ìíœ
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvTester.Rows.Count > 0)
{
int rowIndex = dgvTester.CurrentRow.Index;
DialogResult dialog = MessageBox.Show("Do you want to delete Measure item no " + dgvTester.Rows[rowIndex].Cells["item_measure"].Value.ToString(), "Note !", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialog == DialogResult.Yes)
{
TfSQL tfsql = new TfSQL();
int item_measure = int.Parse(dgvTester.Rows[rowIndex].Cells["item_measure"].Value.ToString());
string sqlDelete = @"delete from m_item where dwr_id = (select dwr_id from m_drawing where dwr_cd = '" + DrawingCd +
"') and item_measure = " + item_measure;
bool del = tfsql.sqlExecuteNonQuery(sqlDelete, true);
LoadItem();
}
}
}
private void dgvTester_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvTester.RowCount > 0)
{
if (dgvTester.Columns[e.ColumnIndex] == colDel)
{
TfSQL tf = new TfSQL();
int itemId = int.Parse(dgvTester.Rows[e.RowIndex].Cells["item_id"].Value.ToString());
string sqlDelete = "delete from m_item where item_id = " + itemId;
DialogResult dialog = MessageBox.Show("Do you want to delete Measure item no " + dgvTester.Rows[e.RowIndex].Cells["item_measure"].Value.ToString(), "Note !", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialog == DialogResult.Yes)
{
tf.sqlExecuteNonQuery(sqlDelete, false);
LoadItem();
}
}
}
}
