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 }));
}
