/// <summary>
/// 删除节点
/// </summary>
/// <param name="ji"></param>
/// <returns></returns>
public bool DeleteBumen(JJBumenInfo ji)
{
string str_sql = $"update jjdbrenwutaizhang.部门信息表 set 删除=1 where 名称='{ji._mingcheng}'";
int num = _mysql.ExecuteNonQuery(str_sql);
return(num > 0 ? true : false);
}
/// <summary>
/// 保存新的部门信息
/// </summary>
/// <param name="ji"></param>
/// <returns></returns>
public bool SaveBumen(JJBumenInfo ji)
{
string str_sql = $"insert into jjdbrenwutaizhang.部门信息表 values('{ji._mingcheng}','{ji._jibie}','{ji._suoshubumen}',0)";
int num = _mysql.ExecuteNonQuery(str_sql);
return(num > 0 ? true : false);
}
/// <summary>
/// 点击删除部门按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_shanchubumen_Click(object sender, EventArgs e)
{
//删除选中节点
string node = tv_my.SelectedNode.Text;
JJBumenInfo ji = new JJBumenInfo()
{
_mingcheng = node
};
bool b = _myc.DeleteBumen(ji);
if (b)
{
MessageBox.Show("删除部门成功！");
}
//更新界面
UpdateBumen();
}
/// <summary>
/// 获得所有的部门信息
/// </summary>
/// <returns></returns>
public List <JJBumenInfo> GetBumeninfos()
{
List <JJBumenInfo> list = new List <JJBumenInfo>();
JJBumenInfo ji = new JJBumenInfo();
string str_sql = $"select * from jjdbrenwutaizhang.部门信息表 where 删除=0";
DataTable mydt = _mysql.ExecuteDataTable(str_sql);
foreach (DataRow mydr in mydt.Rows)
{
ji = new JJBumenInfo()
{
_mingcheng = mydr["名称"].ToString(),
_jibie = mydr["级别"].ToString(),
_suoshubumen = mydr["所属部门"].ToString()
};
list.Add(ji);
}
return(list);
}
private void btn_queding_Click(object sender, EventArgs e)
{
//判断是否有为输入的文本，名称，级别，所属部门
//如果是二级标题，需要判断2个内容
//如果是一级标题，需要判断1个内容
bool _mingcheng = tb_mingcheng.Text.Trim().Equals(string.Empty);
bool _bumen = cbb_suoshubumen.Text.Trim().Equals(string.Empty);
if (cbb_jibie.Text.Trim().Equals("一级部门"))
{
if (_mingcheng)
{
MessageBox.Show("请完善信息！");
}
}
else if (cbb_jibie.Text.Trim().Equals("二级部门"))
{
if (_mingcheng || _bumen)
{
MessageBox.Show("请完善信息！");
}
}
JJBumenInfo ji = new JJBumenInfo()
{
_mingcheng = tb_mingcheng.Text,
_jibie = cbb_jibie.Text,
_suoshubumen = cbb_suoshubumen.Text
};
bool b = _mycontroller.SaveBumen(ji);
if (b)
{
MessageBox.Show("部门已添加！");
this.DialogResult = DialogResult.OK;
}
}
