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("不存在此用户"); } } } }