public int UpdateStaff(StaffBean b)
{
int count = 0;
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@Id", b.Id),
para = new SqlParameter("@StaffNumber", b.StaffNumber),
para = new SqlParameter("@Name", b.Name),
para = new SqlParameter("@Phone", b.Phone),
para = new SqlParameter("@IdCard", b.IdCard),
para = new SqlParameter("@Sex", b.Sex),
para = new SqlParameter("@Birthday", b.Birthday),
para = new SqlParameter("@BankCard", b.BankCard),
para = new SqlParameter("@DepartmentId", b.BankCard),
para = new SqlParameter("@Status", b.BankCard),
para = new SqlParameter("@DateEntry", b.DateEntry),
para = new SqlParameter("@DateFormal", b.DateFormal),
para = new SqlParameter("@DateLeave", b.DateLeave),
};
count = sh.RunSql("PR_Staff_Update", sp);
}
catch (Exception ex)
{
throw ex;
}
return(count);
}
private SqlParameter para; //参数
public int AddStaff(StaffBean b)
{
int count = 0;
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@Id", SqlDbType.Int),
para = new SqlParameter("@StaffNumber", b.StaffNumber),
para = new SqlParameter("@Name", b.Name),
para = new SqlParameter("@Phone", b.Phone),
para = new SqlParameter("@IdCard", b.IdCard),
para = new SqlParameter("@Sex", b.Sex),
para = new SqlParameter("@Birthday", b.Birthday),
para = new SqlParameter("@BankCard", b.BankCard),
para = new SqlParameter("@DepartmentId", b.Department.Id),
para = new SqlParameter("@Status", b.Status),
para = new SqlParameter("@DateEntry", b.DateEntry),
};
sp[0].Direction = ParameterDirection.Output;
count = sh.RunSql("PR_Staff_Add", sp);
b.Id = Convert.ToInt32(sp[0].Value.ToString());
}
catch (Exception ex)
{
throw ex;
}
return(count);
}
private void buttonAdd_Click(object sender, EventArgs e)
{
if (!CheckData())
{
return;
}
DataRow[] matches = tablePost.Select("Name='" + name + "'");
if (matches.Length > 0)
{
return;
}
StaffBean b = new StaffBean();
AssignData(b);
b.Status = status;
if (status != "试用")
{
b.DateEntry = dateStatus;
}
StaffDAO dao = new StaffDAO();
dao.AddStaff(b);
LoadData();
}
public bool IsExistStaff(StaffBean b)
{
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@StaffNumber", b.StaffNumber),
};
ds = sh.GetDataSet("PR_Staff_IsExist", sp);
}
catch (Exception ex)
{
throw ex;
}
return(ds.Tables[0].Rows.Count != 0);
}
public int UpdateStaffSalary(StaffBean b)
{
int count = 0;
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@Id", b.Id),
para = new SqlParameter("@PostId", b.Post.Id),
para = new SqlParameter("@PerformanceId", b.Performance.Id),
para = new SqlParameter("@BenefitId", b.Benefit.Id),
para = new SqlParameter("@AttendanceSalary", b.AttendanceSalary),
para = new SqlParameter("@SenioritySalary", b.SenioritySalary),
};
count = sh.RunSql("PR_Staff_UpdateSalary", sp);
}
catch (Exception ex)
{
throw ex;
}
return(count);
}
private void AssignData(StaffBean b)
{
b.StaffNumber = staffNumber;
b.Name = name;
b.Sex = sex;
b.Phone = phone;
b.Birthday = birthday;
b.IdCard = idCard;
b.BankCard = bankCard;
b.Status = status;
if (status == "试用")
{
b.DateEntry = dateStatus;
}
else if (status == "转正")
{
b.DateFormal = dateStatus;
}
else if (status == "离职")
{
b.DateLeave = dateStatus;
}
b.Department.Id = departmentId;
}
private void repositoryItemButtonEditSave_Click(object sender, EventArgs e)
{
DataRowView r = (DataRowView)gridView.GetRow(gridView.FocusedRowHandle);
StaffBean b = new StaffBean();
try
{
b.Id = Convert.ToInt32(r["StaffId"].ToString());
}
catch
{
MessageBox.Show("出现错误", "信息提示", MessageBoxButtons.OK);
return;
}
b.StaffNumber = r["StaffNumber"].ToString();
string level = r["PostLevel"].ToString();
DataRow[] matches = tabPost.Select("Level='" + level + "'");
if (matches.Length == 0)
{
return;
}
try
{
b.Post.Id = Convert.ToInt32((matches[0]["Id"].ToString()));
}
catch
{
MessageBox.Show("请选择岗位层级", "信息提示", MessageBoxButtons.OK);
return;
}
level = r["PerformanceLevel"].ToString();
matches = tabPerformance.Select("Level='" + level + "'");
if (matches.Length == 0)
{
MessageBox.Show("请选择绩效层级", "信息提示", MessageBoxButtons.OK);
return;
}
try
{
b.Performance.Id = Convert.ToInt32((matches[0]["Id"].ToString()));
}
catch
{
MessageBox.Show("请选择绩效层级", "信息提示", MessageBoxButtons.OK);
return;
}
level = r["BenefitLevel"].ToString();
matches = tabBenefit.Select("Level='" + level + "'");
if (matches.Length == 0)
{
MessageBox.Show("请选择效益层级", "信息提示", MessageBoxButtons.OK);
return;
}
try
{
b.Benefit.Id = Convert.ToInt32((matches[0]["Id"].ToString()));
}
catch
{
MessageBox.Show("请选择效益层级", "信息提示", MessageBoxButtons.OK);
return;
}
b.AttendanceSalary = 0;
b.SenioritySalary = 0;
try
{
b.AttendanceSalary = Convert.ToInt32((r["AttendanceSalary"].ToString()));
b.SenioritySalary = Convert.ToInt32((r["SenioritySalary"].ToString()));
}
catch {}
if (DialogResult.OK != MessageBox.Show("是否保存修改", "信息提示", MessageBoxButtons.OKCancel))
{
return;
}
StaffDAO d = new StaffDAO();
d.UpdateStaffSalary(b);
}
