private SqlParameter para; //参数 public int AddSalaryBill(SalaryBillBean b) { int count = 0; try { SqlParameter[] sp = { para = new SqlParameter("@BillNumber", SqlDbType.VarChar, 30), para = new SqlParameter("@StaffId", b.StaffId), para = new SqlParameter("@StaffNumber", b.StaffNumber), para = new SqlParameter("@PostSalary", b.PostSalary), para = new SqlParameter("@PerformanceSalary", b.PerformanceSalary), para = new SqlParameter("@BenefitSalary", b.BenefitSalary), para = new SqlParameter("@AttendanceSalary", b.AttendanceSalary), para = new SqlParameter("@SenioritySalary", b.SenioritySalary), para = new SqlParameter("@ReissueSalary", b.ReissueSalary), para = new SqlParameter("@SalaryTotal", b.SalaryTotal), para = new SqlParameter("@BelongMonth", b.BelongMonth), para = new SqlParameter("@DateBegin", b.DateBegin), para = new SqlParameter("@DateEnd", b.DateEnd), para = new SqlParameter("@InputStaffNumber", b.InputStaffNumber), }; sp[0].Direction = ParameterDirection.Output; count = sh.RunSql("PR_SalaryBill_Add", sp); b.BillNumber = sp[0].Value.ToString(); } catch (Exception ex) { return((int)ErrorMessage.ErrorCode.ERROR_DB_ADD_FAIL); } return(count); }
public int UpdateSalaryBill(SalaryBillBean b) { int count = 0; try { SqlParameter[] sp = { para = new SqlParameter("@BillNumber", b.BillNumber), para = new SqlParameter("@PostSalary", b.PostSalary), para = new SqlParameter("@PerformanceSalary", b.PerformanceSalary), para = new SqlParameter("@BenefitSalary", b.BenefitSalary), para = new SqlParameter("@AttendanceSalary", b.AttendanceSalary), para = new SqlParameter("@SenioritySalary", b.SenioritySalary), para = new SqlParameter("@ReissueSalary", b.ReissueSalary), para = new SqlParameter("@SalaryTotal", b.SalaryTotal), para = new SqlParameter("@InputStaffNumber", b.InputStaffNumber), }; count = sh.RunSql("PR_SalaryBill_Update", sp); } catch (Exception ex) { throw ex; } return(count); }
private void repositoryItemButtonEditSave_Click(object sender, EventArgs e) { DataRowView r = (DataRowView)gridView.GetRow(gridView.FocusedRowHandle); SalaryBillBean b = new SalaryBillBean(); b.StaffNumber = r["StaffNumber"].ToString(); //b.BillNumber = r["BillNumber"].ToString(); try { b.StaffId = Convert.ToInt32((r["StaffId"].ToString())); b.PostSalary = Convert.ToInt32((r["PostSalary"].ToString())); b.PerformanceSalary = Convert.ToInt32((r["PerformanceSalary"].ToString())); b.BenefitSalary = Convert.ToInt32((r["BenefitSalary"].ToString())); b.AttendanceSalary = Convert.ToInt32((r["AttendanceSalary"].ToString())); b.SenioritySalary = Convert.ToInt32((r["SenioritySalary"].ToString())); b.ReissueSalary = Convert.ToInt32((r["ReissueSalary"].ToString())); b.SalaryTotal = Convert.ToInt32((r["SalaryTotal"].ToString())); b.DateBegin = dateEdit.Text; b.DateEnd = dateEdit.Text; b.BelongMonth = dateEdit.Text; b.InputStaffNumber = "hehe"; } catch { MessageBox.Show("工资输入有误", "信息提示", MessageBoxButtons.OK); return; } if (DialogResult.OK != MessageBox.Show("是否保存修改", "信息提示", MessageBoxButtons.OKCancel)) { return; } SalaryBillDAO d = new SalaryBillDAO(); if (string.IsNullOrEmpty(b.BillNumber)) { d.AddSalaryBill(b); r["BillNumber"] = b.BillNumber; } else { d.UpdateSalaryBill(b); } }