private void buttonUpdate_Click(object sender, EventArgs e) { if (!CheckData()) { return; } if (id == -1) { MessageBox.Show("未选择", "信息提示", MessageBoxButtons.OK); return; } if (tabData != null) { DataRow[] matchs = tabData.Select("Id<>" + id + " AND Level='" + level + "'"); if (matchs.Length > 0) { MessageBox.Show("效益层级已经存在", "信息提示", MessageBoxButtons.OK); return; } } BenefitBean b = new BenefitBean(); b.Id = id; b.Level = level; b.BaseSalary = salary; BenefitDAO d = new BenefitDAO(); d.UpdateBenefit(b); LoadData(); }
private void buttonAdd_Click(object sender, EventArgs e) { if (!CheckData()) { return; } if (tabData != null) { DataRow[] matchs = tabData.Select("Level='" + level + "'"); if (matchs.Length > 0) { MessageBox.Show("效益层级已经存在", "信息提示", MessageBoxButtons.OK); return; } } BenefitBean b = new BenefitBean(); b.Level = level; b.BaseSalary = salary; BenefitDAO d = new BenefitDAO(); if (ReturnStatus.OK == d.AddBenefit(b)) { MessageBox.Show("添加成功", "信息提示", MessageBoxButtons.OK); } LoadData(); }
public StaffBean() { post = new PostBean(); performance = new PerformanceBean(); benefit = new BenefitBean(); department = new DepartmentBean(); }
public void AddBenefit_Test() { BenefitBean b = new BenefitBean(); b.Level = "Cc"; b.BaseSalary = 200; Assert.IsTrue(dao.AddBenefit(b) == ReturnStatus.OK); DataSet set = dao.GetAllBenefit(); Assert.IsTrue(set.Tables.Count > 0); DataRow[] matches = set.Tables[0].Select(""); Assert.IsTrue(matches.Length == 1); }
private void buttonDelete_Click(object sender, EventArgs e) { if (id == -1) { return; } BenefitBean b = new BenefitBean(); b.Id = id; BenefitDAO d = new BenefitDAO(); d.DeleteBenefit(b); LoadData(); }
public ReturnStatus DeleteBenefit(BenefitBean b) { int count = 0; try { SqlParameter[] sp = { para = new SqlParameter("@Id", b.Id), }; count = sh.RunSql("PR_Benefit_Delete", sp); } catch (Exception ex) { return(ReturnStatus.ERROR_DB_DELETE_FAIL); } return(ReturnStatus.OK); }
private SqlParameter para; //参数 public ReturnStatus AddBenefit(BenefitBean b) { int count = 0; try { SqlParameter[] sp = { para = new SqlParameter("@Level", b.Level), para = new SqlParameter("@BaseSalary", b.BaseSalary), }; count = sh.RunSql("PR_Benefit_Add", sp); } catch (Exception ex) { return(ReturnStatus.ERROR_DB_ADD_FAIL); } return(ReturnStatus.OK); }