private void 薪酬管理ToolStripMenuItem_Click(object sender, EventArgs e) { if (gzgl == null) { gzgl = new 工资管理(); gzgl.MdiParent = this; gzgl.setGzandGl(gzgl, this); } if (sjshou == null) { sjshou = new 数据显示(); sjshou.MdiParent = this; } sjshou.setWz(3); sjshou.setGzgl(gzgl); string sql = "SELECT id as 工资号,staff_id as 员工号,basis as 基础工资,attendance as 出勤,performance as 效绩,other as 其他,reason as 原因,total as 总额,createdate as 更新时间 FROM wage_info "; sjshou.show(sql); sjshou.BringToFront(); sjshou.Show(); }
private void 员工管理ToolStripMenuItem_Click(object sender, EventArgs e) { if (glyg == null) { glyg = new 管理员工(); glyg.MdiParent = this; glyg.setGl(this); } if (sjshou == null) { sjshou = new 数据显示(); sjshou.MdiParent = this; } sjshou.setWz(2); sjshou.setGlyg(glyg); string sql = "SELECT id as 员工号, name as 姓名,department_id as 部门号,password as 查询密码,sex as 性别,age as 年龄,createdate as 更新时间,post as 职位 FROM staff_info "; sjshou.show(sql); sjshou.BringToFront(); sjshou.Show(); }
private void 部门管理ToolStripMenuItem_Click(object sender, EventArgs e) { if (bmtj == null) { bmtj = new 管理部门(); bmtj.MdiParent = this; bmtj.setGuanli(this); } if (sjshou == null) { sjshou = new 数据显示(); sjshou.MdiParent = this; sjshou.setBmtj(bmtj); } sjshou.setBmtj(bmtj); sjshou.setWz(1); string sql = "select id as '部门号',name as '部门名称',basis as '基本工资' from department_info"; sjshou.show(sql); sjshou.BringToFront(); sjshou.Show(); }