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);
}
}
