private void LoadData() { SalaryBillDAO d = new SalaryBillDAO(); DataSet set = d.GetAllSalaryBill(null); gridCtrl.DataSource = set.Tables[0]; }
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); } }