/// <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;//将光标置回原来状态 }