private void button2_Click(object sender, EventArgs e) { if (!PanDuan()) { DialogResult dialogResult = MessageBox.Show(tex_yuangongbianhao.Text, "确认删除员工:", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk); if (dialogResult == DialogResult.OK) { string sql = string.Format("select * from staff where staffno = {0}", int.Parse(tex_yuangongbianhao.Text)); SqlDataReader sdr = db.GetSet(sql); sdr.Read(); if (Convert.ToInt32(sdr["Wages"]) > 0 || Convert.ToInt32(sdr["KuaiDiJian"]) > 0) { MessageBox.Show("该员工还有工资未结算,请先结算工资!", "提示"); YuanGongJieSuan ygjs = new YuanGongJieSuan(); ygjs.Show(); } else { string lingshistr1 = string.Format("delete from staff where staffno = {0}", int.Parse(tex_yuangongbianhao.Text)); int lingshi1 = db.JiRu(lingshistr1); if (lingshi1 > 0) { MessageBox.Show("已删除该员工", "提示"); listView1.Items.Clear(); } } } } }
private void 工资结算FToolStripMenuItem_Click(object sender, EventArgs e) { YuanGongJieSuan ygjs = new YuanGongJieSuan(); ygjs.Show(); }