private void BtnStaffDelete_Click(object sender, EventArgs e)
{
if (DgvStaffData.SelectedRows.Count == 1)
{
int index = DgvStaffData.SelectedRows[0].Index;
Staff = staffs[index];
StringBuilder sb = new StringBuilder();
sb.Append("确定删除当前员工？\n");
sb.Append("员工编号：" + Staff.StaffID.ToString() + "\n");
sb.Append("员工姓名：" + Staff.StaffName + "\n");
sb.Append("联系方式：" + Staff.StaffPhone + "\n");
sb.Append("员工职称：" + Staff.Role);
if (DialogResult.OK == MsgBoxUtil.QuestionMsgBox(sb.ToString()))
{
StaffDao.DeleteByStaffID(Staff.StaffID);
staffs.RemoveAt(index);
DgvStaffData.Rows.RemoveAt(index);
Staff = null;
}
}
else
{
MsgBoxUtil.ErrMsgBox("请选择要删除的员工！");
}
}
private static List <EtStaff> GetListByDataReader(MySqlDataReader dr)
{
List <EtStaff> staffs = new List <EtStaff>();
try
{
while (dr.Read())
{
EtStaff staff = new EtStaff
{
StaffID = dr.GetInt32("staffID"),
StaffName = dr["staffName"] is DBNull ? null : dr.GetString("staffName"),
Pwd = dr["pwd"] is DBNull ? null : dr.GetString("pwd"),
StaffPhone = dr["staffPhone"] is DBNull ? null : dr.GetString("staffPhone"),
Role = (ERole)(dr["role"] is DBNull ? 0 : dr.GetInt32("role"))
};
staffs.Add(staff);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return(staffs);
}
public FrmStaff()
{
InitializeComponent();
CmbStaffRole.SelectedIndex = 0;
Staff = null;
staffs = StaffDao.QueryAll();
hasUpdated = false;
//foreach (EtStaff staff in staffs)
// DgvStaffData.Rows.Add(new object[] {
// staff.StaffID,
// staff.StaffName,
// staff.StaffPhone,
// staff.Role
// });
}
public static int UpdateOrInsert(EtStaff staff)
{
List <EtStaff> staffs = QueryByStaffID(staff.StaffID);
if (staffs.Count > 0)
{
DBHelper helper = new DBHelper();
string sql = "UPDATE staff SET staffName = @staffName," +
"pwd = @pwd,staffPhone = @staffPhone," +
"role = @role " +
"WHERE staffID = @staffID";
MySqlParameter[] prams =
{
new MySqlParameter("@staffName", staff.StaffName),
new MySqlParameter("@pwd", staff.Pwd),
new MySqlParameter("@staffPhone", staff.StaffPhone),
new MySqlParameter("@role", staff.Role),
new MySqlParameter("@staffID", staff.StaffID)
};
return(helper.RunNonQuerySQL(sql, prams));
}
else
{
DBHelper helper = new DBHelper();
string sql = "INSERT INTO " +
"staff(staffID,staffName,pwd,staffPhone,role) " +
"VALUE(@staffID,@staffName,@pwd,@staffPhone,@role)";
MySqlParameter[] prams =
{
new MySqlParameter("@staffID", staff.StaffID),
new MySqlParameter("@staffName", staff.StaffName ?? (object)DBNull.Value),
new MySqlParameter("@pwd", staff.Pwd ?? (object)DBNull.Value),
new MySqlParameter("@staffPhone", staff.StaffPhone ?? (object)DBNull.Value),
new MySqlParameter("@role", staff.Role)
};
return(helper.RunNonQuerySQL(sql, prams));
}
}
public static int InsertStaff(EtStaff staff)
{
List <EtStaff> staffs = QueryByStaffID(staff.StaffID);
if (staffs.Count > 0)
{
return(-1);
}
DBHelper helper = new DBHelper();
string sql = "INSERT INTO " +
"staff(staffID,staffName,pwd,staffPhone,role) " +
"VALUE(@staffID,@staffName,@pwd,@staffPhone,@role)";
MySqlParameter[] prams =
{
new MySqlParameter("@staffID", staff.StaffID),
new MySqlParameter("@staffName", staff.StaffName ?? (object)DBNull.Value),
new MySqlParameter("@pwd", staff.Pwd ?? (object)DBNull.Value),
new MySqlParameter("@staffPhone", staff.StaffPhone ?? (object)DBNull.Value),
new MySqlParameter("@role", staff.Role)
};
return(helper.RunNonQuerySQL(sql, prams));
}
private void BtnStaffUpdate_Click(object sender, EventArgs e)
{
if (DgvStaffData.SelectedRows.Count == 1)
{
int index = DgvStaffData.SelectedRows[0].Index;
Staff = staffs[index];
FrmStaffUpdate fsu = new FrmStaffUpdate {
StartPosition = FormStartPosition.CenterParent
};
fsu.ShowDialog();
if (Staff != null)
{
DgvStaffData.Rows[index].Cells["ClnStaffName"].Value = Staff.StaffName;
DgvStaffData.Rows[index].Cells["ClnStaffPhone"].Value = Staff.StaffPhone;
DgvStaffData.Rows[index].Cells["ClnStaffRole"].Value = Staff.Role;
Staff = null;
}
hasUpdated = true;
}
else
{
MsgBoxUtil.ErrMsgBox("请选择要修改的员工信息！");
}
}
private void BtnStaffInsert_Click(object sender, EventArgs e)
{
FrmStaffInsert fsi = new FrmStaffInsert {
StartPosition = FormStartPosition.CenterParent
};
fsi.ShowDialog();
if (Staff != null)
{
staffs.Add(Staff);
Staff = null;
if (staffs.Count > 1)
{
staffs[staffs.Count - 1].StaffID = staffs[staffs.Count - 2].StaffID + 1;
}
DgvStaffData.Rows.Add(new object[] {
staffs[staffs.Count - 1].StaffID,
staffs[staffs.Count - 1].StaffName,
staffs[staffs.Count - 1].StaffPhone,
staffs[staffs.Count - 1].Role
});
hasUpdated = true;
}
}
public static int UpdateStaff(EtStaff staff)
{
List <EtStaff> staffs = QueryByStaffID(staff.StaffID);
if (staffs.Count == 0)
{
return(-1);
}
DBHelper helper = new DBHelper();
string sql = "UPDATE staff SET staffName = @staffName," +
"pwd = @pwd,staffPhone = @staffPhone," +
"role = @role " +
"WHERE staffID = @staffID";
MySqlParameter[] prams =
{
new MySqlParameter("@staffName", staff.StaffName),
new MySqlParameter("@pwd", staff.Pwd),
new MySqlParameter("@staffPhone", staff.StaffPhone),
new MySqlParameter("@role", staff.Role),
new MySqlParameter("@staffID", staff.StaffID)
};
return(helper.RunNonQuerySQL(sql, prams));
}
