private void deleteStaff(object sender, RoutedEventArgs e)
{
try
{
int id = (dataTest.SelectedItem as staff).s_Id;
try
{
string strconn = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=F:\\VsProject\\高级人事管理系统\\高级人事管理系统\\bin\\Debug\\MSDSecond.mdf;Integrated Security=True";
SqlConnection sqlconn = new SqlConnection(strconn);
sqlconn.Open();
string sql = "delete from staff where s_id = " + id + " ";
SqlCommand sqlcmd = new SqlCommand(sql, sqlconn);
sqlcmd.ExecuteNonQuery();
MessageBox.Show("删除成功!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "删除失败");
}
using (var c = new MSDSecondEntities())
{
var x = from t in c.staff select t;
dataTest.ItemsSource = x.ToList();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "删除失败");
}
}
private void RefreshBtn_Click(object sender, RoutedEventArgs e)
{
try
{
using (var c = new MSDSecondEntities())
{
var q = from t in c.staff select t;
dataTest.ItemsSource = q.ToList();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "刷新失败");
}
}
public void identifyDepartment(string username)
{
this.username = username;
using (var db = new MSDSecondEntities()) {
var idDpartment = from x in db.staff
where x.s_username == username
select x.s_department;
List <string> list = idDpartment.ToList();
if (list[0].Trim().Equals("人事管理部"))
{
PersonnelDepartment pd = new PersonnelDepartment();
pd.ShowDialog();
}
else
{
otherDepartment od = new otherDepartment(list[0].Trim());
od.ShowDialog();
}
}
}
private void SaveDetail_Click(object sender, RoutedEventArgs e)
{
using (var db = new MSDSecondEntities()) {
staff stf = new staff();
stf.s_name = nameBox.Text;
ComboBoxItem item = genderCombox.SelectedItem as ComboBoxItem;
stf.s_gender = item.Content.ToString();
stf.s_birthday = datePickerBirthDate.SelectedDate.Value.Date;
stf.s_phone = phoneBox.Text;
stf.s_email = emailBox.Text;
stf.s_post = postBox.Text;
stf.s_salary = int.Parse(salaryBox.Text);
stf.s_major = majorBox.Text;
ComboBoxItem item1 = departmentCombox.SelectedItem as ComboBoxItem;
stf.s_department = item1.Content.ToString();
stf.s_username = usernameBox.Text;
stf.s_password = passwordBox.Text;
while (db.staff.Any(u => u.s_username == usernameBox.Text))
{
MessageBox.Show("数据库已存在相同用户名的");
MessageBox.Show(stf.s_username + " " + stf.s_password);
usernameBox.Clear();
passwordBox.Clear();
stf.s_username = usernameBox.Text;
stf.s_password = passwordBox.Text;
return;
}
try {
db.staff.Add(stf);
db.SaveChanges();
MessageBox.Show("保存成功!");
}
catch (Exception ex) {
MessageBox.Show("保存失败。");
}
}
}
private void loginOn_click(object sender, RoutedEventArgs e)
{
Button btn = (Button)sender;
ComboBoxItem item = comBox.SelectedItem as ComboBoxItem;
string username = usernameBox.Text.ToString();
this.username = username;
string password = passBox.Password;
string type = item.Content.ToString();
if (type.Equals("系统管理员"))
{
using (var db = new MSDSecondEntities())
{
var isExsit = db.Admin.Any(u => u.a_User.Trim() == username.Trim() && u.a_Pass.Trim() == password.Trim());
if (isExsit)
{
this.DialogResult = Convert.ToBoolean(1);
this.Close();
}
else
{
usernameBox.Text = String.Empty;
passBox.Clear();
MessageBox.Show("不存在此用户");
}
}
}
else if (type.Equals("部门经理"))
{
using (var db = new MSDSecondEntities())
{
var isExsit = db.staff.Any(u => u.s_username.Trim() == username.Trim() && u.s_password.Trim() == password.Trim() && u.s_post.Trim() == "部门经理");
if (isExsit)
{
ManagerChecking mc = new ManagerChecking();
this.Close();
mc.identifyDepartment(this.username);
}
else
{
usernameBox.Text = String.Empty;
passBox.Clear();
MessageBox.Show("不存在此用户");
}
}
}
else if (type.Equals("普通职员"))
{
using (var db = new MSDSecondEntities())
{
var isExsit = db.staff.Any(u => u.s_username.Trim() == username.Trim() && u.s_password.Trim() == password.Trim() && u.s_post.Trim() == "普通职员");
if (isExsit)
{
Check ck = new Check(username.Trim());
this.Close();
ck.ShowDialog();
}
else
{
usernameBox.Text = String.Empty;
passBox.Clear();
MessageBox.Show("不存在此用户");
}
}
}
}
