private void vs_DoubleClick(object sender, EventArgs e)
{
if (vs.Row <= 0)
{
return;
}
if (MessageBox.Show(this, PublicFunction.L_Get_Msg("msg", 15), this.Text, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SqlConnection con = new SqlConnection(PublicFunction.C_con.ConnectionString);
con.Open();
SqlTransaction tran = con.BeginTransaction();
try
{
string sql = "";
sql = "Update FILB01A set DEL_BT=0 where EMP_ID=N'" + vs.Rows[vs.Row]["EMP_ID"] + "'";
SqlCommand cmd = new SqlCommand(sql, con, tran);
cmd.ExecuteNonQuery();
sql = "delete from FILB01AD where EMP_ID=N'" + vs.Rows[vs.Row]["EMP_ID"] + "'";
cmd = new SqlCommand(sql, con, tran);
cmd.ExecuteNonQuery();
vs.RemoveItem(vs.Row);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
MessageBox.Show(ex.Message);
con.Close();
return;
}
MessageBox.Show(PublicFunction.L_Get_Msg("Staff", 1));
con.Close();
}
}
