private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex > -1)
{
DataGridViewButtonCell btnCell = dataGridView1.CurrentCell as DataGridViewButtonCell;
if (btnCell != null)
{
if (MessageBox.Show("确定要删除该驻场人员吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
return;
}
CheckMan checkMan = getOneCheckManFromGrid();
try
{
int affected = checkManManage.DeleteOneWorker(checkMan.Name);
if (affected < 1)
{
MessageBox.Show("删除失败，请重试！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
WorkerListForm_Load(null, null);
}catch (Exception ex)
{
Console.WriteLine("失败" + ex.Message);
}
}
}
}
public CheckMan GetCheckManByName(string name)
{
string sql = $"select * from CheckMan where Name='{name}'";
SQLiteDataReader reader = SQLHelper.ReadTableBySql(sql);
CheckMan checkMan = new CheckMan();
if (!reader.HasRows)
{
reader.Close();
return(null);
}
while (reader.Read())
{
try
{
checkMan.Name = reader["Name"].ToString();
}
catch (Exception ex)
{
Console.WriteLine($"GetCheckManByName failed, error message is: {ex.Message}");
}
}
if (reader != null)
{
reader.Close();
}
return(checkMan);
}
