private void btnDelete_Click(object sender, EventArgs e) { if (grid.CurrentRow.Index < 0) { MessageBoxEx.Show("请选择一条数据,在进行操作"); return; } DialogResult result = MessageBoxEx.Show(this, "确认要删除吗?", "", MessageBoxButtons.YesNo); //如果点击的是"YES"按钮,将form关闭. if (result == DialogResult.Yes) { HRDept dept = list[grid.CurrentRow.Index]; try { dao.Delete(dept.Id); } catch (Exception ex) { MessageBoxEx.Show(this, "删除失败!" + ex.StackTrace, "报错提示", MessageBoxButtons.YesNo); return; } list.RemoveAt(grid.CurrentRow.Index); InitData(); } }
private void btnSave_Click(object sender, EventArgs e) { if (!validateInput()) { return; } btnSaveEnbaled(false); if (opration == OP_ADD) { HRDept dept = new HRDept(); dept.Id = txtId.Text; dept.Name = txtName.Text; int ret = dao.Add(dept); if (ret > 0) { listSource.Add(dept); } } else if (opration == OP_UPDATE) { HRDept dept = list[grid.CurrentRow.Index]; dept.Name = txtName.Text; dao.Update(dept); grid.Refresh(); } CleanData(); }
/// <summary> /// 新增 /// </summary> /// <param name="deptVo"></param> public int Add(HRDept deptVo) { int ret = conn.Execute(@"insert HR_DEPT(ID, NAME ) values (@id, @name)", new[] { new { id = deptVo.Id, name = deptVo.Name } }); Console.WriteLine(string.Format("插入数据库成功{0}", ret)); return(ret); }
private void btnFind_Click(object sender, EventArgs e) { HRDept dept = new HRDept(); dept.Id = txtId.Text; dept.Name = txtName.Text; list = dao.FindByWhere(dept); var bindingList = new BindingList <HRDept>(list); listSource = new BindingSource(bindingList, null); grid.DataSource = listSource; }
private void grid_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } HRDept dept = list[e.RowIndex]; txtId.Text = dept.Id; txtName.Text = dept.Name; btnDelete.Enabled = true; btnUpdate.Enabled = true; }
public List <HRDept> FindByWhere(HRDept vo) { string whereSql = ""; if (!EmptyUtils.EmptyStr(vo.Id)) { whereSql += " and id=@Id"; } if (!EmptyUtils.EmptyStr(vo.Name)) { whereSql += " and Name=@Name"; } return(conn.Query <HRDept>("SELECT d.* FROM HR_DEPT d where 1=1 " + whereSql, new { Id = vo.Id, Name = vo.Name, }).ToList()); }
/// <summary> /// 更新 /// </summary> /// <param name="deptVo"></param> /// <returns></returns> public int Update(HRDept deptVo) { return(conn.Execute(@"update HR_DEPT SET NAME=@name WHERE id =@id", new { id = deptVo.Id, name = deptVo.Name })); }