/// <summary>
/// 修改按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void editButton_Click(object sender, EventArgs e)
{
string id = grid1[grid1.Selection.ActivePosition.Row, 0].ToString();//选中行的id
EqstatusEditForm editForm = new EqstatusEditForm(id);
try
{
if (editForm.ShowDialog() == DialogResult.OK)
{
Account acc = new Account();
DataSet ds = acc.queryInfomation("eq_status");
BindSourceGrid(grid1, ds.Tables[0], "设备状态名称");
grid1.Selection.SelectRow(1, true);
grid1.Selection.FocusFirstCell(true);
}
///MessageBox.Show(grid1[grid1.Selection.ActivePosition.Row, 0].ToString());
}
catch (Exception mye)
{
log.Error(mye.Message);
}
}
/// <summary>
/// 添加按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void addButton_Click(object sender, EventArgs e)
{
EqstatusAddForm addForm = new EqstatusAddForm();
if (addForm.ShowDialog() == DialogResult.OK)
{
//重新绑定DataGridView;
Account acc = new Account();
DataSet ds = acc.queryInfomation("eq_status");
BindSourceGrid(grid1, ds.Tables[0], "设备状态名称");
grid1.Selection.SelectRow(1, true);
grid1.Selection.FocusFirstCell(true);
}
}
/// <summary>
/// 删除按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void delButton_Click(object sender, EventArgs e)
{
DialogResult dr;
Boolean flag = false;
if (grid1[grid1.Selection.ActivePosition.Row, 0] != null)
{
dr = MessageBox.Show("您确认删除此条记录？", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
Account acc = new Account();
//flag = acc.deleteFaultById(grid1[grid1.Selection.ActivePosition.Row, 0].ToString());
flag = acc.deleteInfomation(grid1[grid1.Selection.ActivePosition.Row, 0].ToString(), "eq_status");
if (flag)
{
MessageBox.Show("删除成功！");
DataSet ds = acc.queryInfomation("eq_status");
BindSourceGrid(grid1, ds.Tables[0], "设备状态名称");
grid1.Selection.SelectRow(1, true);
grid1.Selection.FocusFirstCell(true);
}
else
{
MessageBox.Show("删除失败！");
}
}
}
}
//窗体初始化
private void AccountForm_Load(object sender, EventArgs e)
{
Cursor cr = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;//将光标置为等待状态
//this.WindowState = FormWindowState.Maximized;
//数据格
Account acc = new Account();
DataSet ds = acc.queryInfomation("eq_status");
BindSourceGrid(grid1, ds.Tables[0],"设备状态名称");
grid1.Selection.SelectRow(1, true);
grid1.Selection.FocusFirstCell(true);
Cursor.Current = cr;//将光标置回原来状态
}
