public IEnumerable <ClassStudent> GetClass() { List <ClassStudent> LoginData = new List <ClassStudent>(); string conString = ConfigurationManager.ConnectionStrings["getConnection"].ToString(); conn = new SqlConnection(conString); SqlCommand cmd = new SqlCommand("spCLASS", conn); cmd.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ClassStudent classStudent = new ClassStudent(); classStudent.ID_CLass = reader["ID_CLass"].ToString(); classStudent.NameClass = reader["NameClass"].ToString(); classStudent.StartDay = reader["StartDay"].ToString(); classStudent.LeavingDay = reader["LeavingDay"].ToString(); classStudent.Image = reader["IMAGE"].ToString(); LoginData.Add(classStudent); } conn.Close(); return(LoginData); }
private void Show() { table.Items.Clear(); StudentInterface a = new ClassStudent(); a.ShowGroups(table); }
private void Show() { tablePersStudent.Items.Clear(); Operations a = new ClassStudent(); a.ShowPers(tablePersStudent); }
private void ShowSpec(string speciality) { table.Items.Clear(); StudentInterface a = new ClassStudent(); a.ShowGroupSpec(table, speciality); }
public ClassStudent GetStudentBySno(string sno, out string strMessage) { strMessage = ""; string strSQL = "SELECT Sno,Sname,Clno,Stel,Ptel,Ttel,Spwd FROM Student WHERE Sno =" + sno; DataTable dt = Global.dbHelp.GetDataTablebySQL(strSQL, out strMessage); if (dt == null) { return(null); } if (dt.Rows.Count < 1) { strMessage = "没有该用户!"; return(null); } //构建一个用户 string sno1 = dt.Rows[0].ItemArray[0].ToString(); string sname = dt.Rows[0].ItemArray[1].ToString(); string clno = dt.Rows[0].ItemArray[2].ToString(); string stel = dt.Rows[0].ItemArray[3].ToString(); string ptel = dt.Rows[0].ItemArray[4].ToString(); string ttel = dt.Rows[0].ItemArray[5].ToString(); string spwd = dt.Rows[0].ItemArray[6].ToString(); ClassStudent student = new ClassStudent(sno1, sname, clno, stel, ptel, ttel, spwd); return(student); }
public AddStudent() { InitializeComponent(); StudentInterface a = new ClassStudent(); group.ItemsSource = a.GetGroup(); }
private void Button_Click_2(object sender, RoutedEventArgs e) { if (number.Text == "") { a1.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (spec1.Text == "") { a2.Visibility = Visibility.Visible; } } else { if (spec1.Text == "") { a2.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; } else { StudentInterface a = new ClassStudent(); a.InsertGroup(number.Text, spec1.Text); table.Items.Clear(); Show(); number.Clear(); spec1.SelectedIndex = -1; } } }
public void RemoveStudentClass(ClassStudent classStudent) { using (var context = new StudentManagementDBContext()) { var entity = context.ClassStudentEntities.SingleOrDefault(m => m.ClassID == classStudent.ClassID && m.StudentID == classStudent.StudentID); context.ClassStudentEntities.Remove(entity); context.SaveChanges(); } }
public ActionResult StudentInsert(FormCollection f) { ClassStudent s = new ClassStudent(); s.Name = f["Name"]; s.DateOfBirth = f["DateOfBirth"]; s.Gender = f["Gender"]; dblayer.InsertStudent(s); return(RedirectToAction("StudentDisplay")); }
public void AddStudentClass(ClassStudent classStudent) { using (var context = new StudentManagementDBContext()) { var entity = Mapper.Map <ClassStudent, ClassStudentEntity>(classStudent); entity.ID = Guid.NewGuid(); context.ClassStudentEntities.Add(entity); context.SaveChanges(); } }
public ActionResult StudentUpdate(int id, FormCollection f) { ClassStudent s = new ClassStudent(); s.StudentID = id; s.Name = f["Name"]; s.DateOfBirth = f["DateOfBirth"]; s.Gender = f["Gender"]; dblayer.UpdateStudent(s); return(RedirectToAction("StudentDisplay")); }
public AddRating() { InitializeComponent(); StudentInterface a = new ClassStudent(); group.ItemsSource = a.GetGroup(); mark.ItemsSource = mas; student.ItemsSource = mas1; Discipline.ItemsSource = mas2; string[] mas3 = { "1", "2", "3", "4", "5", "6", "7", "8" }; semester.ItemsSource = mas3; }
public ActionResult DeleteConfirmed([Bind(Include = "ClassID,StudentID")] ClassStudent student) { student.ClassID = Convert.ToInt32(Request["ClassID"]); if (ModelState.IsValid) { db.ClassStudents.Remove(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Current", "Students")); }
public ActionResult Edit([Bind(Include = "ClassID,StudentID")] ClassStudent classStudent) { if (ModelState.IsValid) { db.Entry(classStudent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.Classes, "ID", "Name", classStudent.ClassID); ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", classStudent.StudentID); return(View(classStudent)); }
public List() { InitializeComponent(); Show(); StudentInterface a = new ClassStudent(); group.ItemsSource = a.GetGroup(); TeacherInterface t = new ClassTeacher(); teacher.ItemsSource = t.GetTeacher(); string[] mas1 = { "1", "2", "3", "4", "5", "6", "7", "8" }; semester.ItemsSource = mas1; }
public AcademicRecord() { InitializeComponent(); Show(); StudentInterface g = new ClassStudent(); group.ItemsSource = g.GetGroup(); string[] mas1 = { "1", "2", "3", "4", "5", "6", "7", "8" }; semester.ItemsSource = mas1; string[] mas2 = { "Зачет", "Экзамен", "Дифференцированный зачет" }; type.ItemsSource = mas2; disc.ItemsSource = mas3; }
public ActionResult Create([Bind(Include = "ClassID,StudentID")] ClassStudent classStudent) { if (ModelState.IsValid) { db.ClassStudents.Add(classStudent); db.SaveChanges(); return(RedirectToAction("Current", "Students")); } ViewBag.ClassID = new SelectList(db.Classes, "ID", "Name", classStudent.ClassID); ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", classStudent.StudentID); return(View(classStudent)); }
// GET: ClassStudents/Delete/5 public ActionResult Delete(int?studentID) { if (studentID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClassStudent student = db.ClassStudents.Where(cs => cs.StudentID == studentID).FirstOrDefault(); if (student == null) { return(View("NoJunction")); } return(View(student)); }
// GET: ClassStudents/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClassStudent classStudent = db.ClassStudents.Find(id); if (classStudent == null) { return(HttpNotFound()); } return(View(classStudent)); }
private void Button_Click(object sender, RoutedEventArgs e) { if (group.Text == "") { a1.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; } else { tablePersStudent.Items.Clear(); StudentInterface a = new ClassStudent(); a.ShowPersGroup(tablePersStudent, group.Text); group.SelectedIndex = -1; } }
public AddList() { InitializeComponent(); StudentInterface g = new ClassStudent(); group.ItemsSource = g.GetGroup(); TeacherInterface t = new ClassTeacher(); teacher.ItemsSource = t.GetTeacher(); string[] mas1 = { "1", "2", "3", "4", "5", "6", "7", "8" }; semester.ItemsSource = mas1; string[] mas2 = { "Зачет", "Экзамен", "Дифференцированный зачет" }; type.ItemsSource = mas2; disc.ItemsSource = mas3; }
// GET: ClassStudents/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClassStudent classStudent = db.ClassStudents.Find(id); if (classStudent == null) { return(HttpNotFound()); } ViewBag.ClassID = new SelectList(db.Classes, "ID", "Name", classStudent.ClassID); ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", classStudent.StudentID); return(View(classStudent)); }
public void InsertStudent(ClassStudent s) { try { SqlCommand com = new SqlCommand("Sp_InsertStudent", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@prm_snam", s.Name); com.Parameters.AddWithValue("@prm_sdob", s.DateOfBirth); com.Parameters.AddWithValue("@prm_sgen", s.Gender); con.Open(); com.ExecuteNonQuery(); con.Close(); } catch (Exception e) { Console.WriteLine("Catch error: " + e); } }
///<summary> ///登录 ///</summary> ///<param name = "sno"></param> ///<param name = "spwd"></param> ///<param name = "strMessage"></param> ///<returns>登录成功后,返回一个用户对象,否则NULL</returns> public ClassStudent Login(string sno, string spwd, out string strMessage) { strMessage = ""; //构建一个学生对象 ClassStudent student = GetStudentBySno(sno, out strMessage); if (student == null) { return(null); } if (student.Spwd != spwd) { strMessage = "用户密码错误!"; return(null); } return(student); }
// string LeavingDay = Preferences.Get("my_key5", "default_value"); public AddClassViewModel(INavigation _navigation, ClassStudent classStudent) { Navigation = _navigation; _class = classStudent; if (_class != null) { NameClass = _class.NameClass; ID_Teacher = _class.ID_Teacher; StartDay = _class.StartDay; LeavingDay = _class.LeavingDay; ClassTittle = "Sửa thông tin lớp"; IsVisibleDeleteBtn = true; } else { ClassTittle = "Thêm thông tin lớp"; } }
private void group_SelectionChanged(object sender, SelectionChangedEventArgs e) { student.SelectedItem = null; StudentInterface s = new ClassStudent(); ListInterface d = new ClassList(); student.ItemsSource = s.GetStudents(group.SelectedItem.ToString()); if (type.Text != "" && semester.Text != "") { Discipline.SelectedItem = null; Discipline.ItemsSource = d.GetDisciplineGroup(group.SelectedItem.ToString(), type.Text, semester.Text); } a3.Visibility = Visibility.Hidden; if (type.Text != "" && semester.Text != "" && Discipline.Text != "" && student.Text != "" && mark.Text != "") { p.Visibility = Visibility.Hidden; } }
private void AddClasses() { // Create a class year SchoolYear year = new SchoolYear(); year.Name = "2015-2016"; year.Start = DateTime.Parse("8-15-2015"); year.End = DateTime.Parse("5-15-2016"); db.SchoolYears.InsertOnSubmit(year); db.SubmitChanges(); // Create a class for each teacher // Get the teachers and students with their IDs var teachers = db.Users.Where(x => x.UserType == UserType.Teacher); User[] students = db.Users.Where(x => x.UserType == UserType.Student).ToArray(); int nextStudent = 0; foreach (User teacher in teachers) { Class clss = new Class(); clss.Year = 1; // we know there is only one year ID clss.ClassName = string.Format("{0} {1} First Grade", teacher.FirstName, teacher.LastName); clss.TeacherID = teacher.UserID; db.Classes.InsertOnSubmit(clss); db.SubmitChanges(); // Get the class ID clss = db.Classes.Where(x => x.TeacherID == teacher.UserID).First(); // Assign students to the class for (int idx = 0; idx < students.Length / teachers.Count(); nextStudent++, idx++) { User student = students[nextStudent]; ClassStudent tie = new ClassStudent(); tie.UserID = student.UserID; tie.ClassID = clss.ClassID; db.ClassStudents.InsertOnSubmit(tie); } } }
/// <summary> /// 注册一个学生信息 /// </summary> /// <param name="student">一个需要注册的学生对象</param> /// <param name="strMessage">返回执行信息</param> /// <returns>注册成功返回真</returns> public bool Register(ClassStudent student, out string strMessage) { strMessage = ""; //写入数据库的的SQL语句 string[] StrSQL = new string[1]; //SQL语句数组 StrSQL[0] = "INSERT INTO Student(Sno,Sname,Clno,Stel,Ptel,Ttel,Spwd) VALUES('"; StrSQL[0] += student.Sno + "','"; StrSQL[0] += student.Sname + "','"; StrSQL[0] += student.Clno + "','"; StrSQL[0] += student.Stel + "','"; StrSQL[0] += student.Ptel + "','"; StrSQL[0] += student.Ttel + "','"; StrSQL[0] += student.Spwd + "')"; if (Global.dbHelp.ExcuteSQLbyTrans(StrSQL, out strMessage)) { return(true); } else { return(false); } }
/// <summary> /// /// </summary> public override void Sync() { if (this.Source == null) return; List<Unit> listUnits = this.unitsEntity.LoadAllowSyncData(); if (listUnits == null || listUnits.Count == 0) { this.Log.ContentLog("没有允许同步学生的学校!"); return; } for (int i = 0; i < listUnits.Count; i++) { try { List<Entity.Class> listClasses = this.classesEntity.LoadAllowSyncData(listUnits[i].UnitID); if (listClasses == null || listClasses.Count == 0) { this.Log.ContentLog(string.Format("学校[{0},{1}]下没有允许同步学生的班级!", i + 1, listUnits[i])); continue; } for (int j = 0; j < listClasses.Count; j++) { try { int count = this.classStusEntity.DeleteClassStudents(listClasses[j].ClassID); this.Log.ContentLog(string.Format("删除班级[{0}]下关联的学生[{1}]人!", listClasses[j], count)); SyncStudents sources = this.Source.SyncAllStudents(listUnits[i].UnitName, string.Format("{0}", listClasses[j].JoinYear), listClasses[j].ClassName); if (sources == null || sources.Count == 0) { this.Log.ContentLog(string.Format("第[{0},{1}]条学校[{2}]下班级[{3}]下没有学生同步!", i + 1, j + 1, listUnits[i], listClasses[j])); continue; } Entity.Student data = null; for (int k = 0; k < sources.Count; k++) { try { data = new Entity.Student(); data.StudentID = this.stusEntity.LoadStudentIDByCode(sources[k].Code); if (data.StudentID.IsValid && this.stusEntity.LoadRecord(ref data)) { if (data.SyncStatus == 0x00) { continue; } } data.StudentCode = sources[k].Code; data.StudentName = sources[k].Name; data.IDNumber = sources[k].IDCard; data.JoinYear = int.Parse(sources[k].JoinYear); data.Gender = this.TransGender(sources[k].Gender); data.LastSyncTime = DateTime.Now; data.SyncStatus = 0x02; bool isInsert = false; if (!data.StudentID.IsValid) { data.StudentID = GUIDEx.New; isInsert = true; } string log = string.Format("同步第[{0},{1},{2}]条数据[{3}]", i + 1, j + 1, k + 1, data); if (this.stusEntity.UpdateRecord(data)) { this.Log.ContentLog(log + "[成功]"); if (isInsert)//新生插入权限。 { this.SetStudentAccessRole(data, this.roleId); } //建立班级学生关系。 ClassStudent cs = new ClassStudent(); cs.ClassID = listClasses[j].ClassID; cs.StudentID = data.StudentID; cs.LastSyncTime = DateTime.Now; log = string.Format("[{0},{1},{2}]建立学校[{3}]班级({4})学生({5})关联关系[{6}]", i + 1, j + 1, k + 1, listUnits[i], listClasses[j], sources[k], cs); if (this.classStusEntity.UpdateRecord(cs)) { this.Log.ContentLog(log + "[成功]"); } else { this.Log.ContentLog(log + "[失败]"); } } else { this.Log.ContentLog(log + "[失败]"); } } catch (Exception x) { string err = string.Format("同步[{0},{1},{2}]学生数据[{2}]异常:{3}", i + 1, j + 1, k + 1, data, x.Message); this.Log.ContentLog(err); this.Log.ErrorLog(new Exception(err, x)); } } } catch (Exception ex) { string err = string.Format("同步第[{0},{1}]条学校[{2}]下班级[{3}]下学生数据时发生异常:{4}", i + 1, j + 1, listUnits[i], listClasses[j], ex.Message); this.Log.ContentLog(err); this.Log.ErrorLog(new Exception(err, ex)); } } } catch (Exception e) { string err = string.Format("同步学校[{0},{1}]下的学生发生异常:{2}", i + 1, listUnits[i], e.Message); this.Log.ContentLog(err); this.Log.ErrorLog(new Exception(err, e)); } } }
private void add_Click(object sender, RoutedEventArgs e) { if (surname.Text == "") { a1.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (name.Text == "") { a2.Visibility = Visibility.Visible; } if (middle_name.Text == "") { a3.Visibility = Visibility.Visible; } if (series.Text == "") { a4.Visibility = Visibility.Visible; } if (number.Text == "") { a5.Visibility = Visibility.Visible; } if (group.Text == "") { a6.Visibility = Visibility.Visible; } if (phone.Text == "") { a8.Visibility = Visibility.Visible; } if (year.Text == "") { a9.Visibility = Visibility.Visible; } if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (name.Text == "") { a2.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (middle_name.Text == "") { a3.Visibility = Visibility.Visible; } if (series.Text == "") { a4.Visibility = Visibility.Visible; } if (number.Text == "") { a5.Visibility = Visibility.Visible; } if (group.Text == "") { a6.Visibility = Visibility.Visible; } if (phone.Text == "") { a8.Visibility = Visibility.Visible; } if (year.Text == "") { a9.Visibility = Visibility.Visible; } if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (middle_name.Text == "") { a3.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (series.Text == "") { a4.Visibility = Visibility.Visible; } if (number.Text == "") { a5.Visibility = Visibility.Visible; } if (group.Text == "") { a6.Visibility = Visibility.Visible; } if (phone.Text == "") { a8.Visibility = Visibility.Visible; } if (year.Text == "") { a9.Visibility = Visibility.Visible; } if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (series.Text == "") { a4.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (number.Text == "") { a5.Visibility = Visibility.Visible; } if (group.Text == "") { a6.Visibility = Visibility.Visible; } if (phone.Text == "") { a8.Visibility = Visibility.Visible; } if (year.Text == "") { a9.Visibility = Visibility.Visible; } if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (number.Text == "") { a5.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (group.Text == "") { a6.Visibility = Visibility.Visible; } if (phone.Text == "") { a8.Visibility = Visibility.Visible; } if (year.Text == "") { a9.Visibility = Visibility.Visible; } if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (group.Text == "") { a6.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (phone.Text == "") { a8.Visibility = Visibility.Visible; } if (year.Text == "") { a9.Visibility = Visibility.Visible; } if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (phone.Text == "") { a8.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (year.Text == "") { a9.Visibility = Visibility.Visible; } if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (year.Text == "") { a9.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (city.Text == "") { a10.Visibility = Visibility.Visible; } if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (city.Text == "") { a10.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (street.Text == "") { a11.Visibility = Visibility.Visible; } if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (street.Text == "") { a11.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (home.Text == "") { a12.Visibility = Visibility.Visible; } if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (home.Text == "") { a12.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; } } else { if (male.IsChecked == false && female.IsChecked == false) { a14.Visibility = Visibility.Visible; p.Visibility = Visibility.Visible; } else { string sex = ""; if (male.IsChecked == true) { sex = male.Content.ToString(); } else { sex = female.Content.ToString(); } StudentInterface a = new ClassStudent(); a.Insert(series, number, sex, city, street, home, flat, phone, surname, name, middle_name, group, year); Cleanning(); } } } } } } } } } } } } }
public static ClassStudentDTO GetClassStudentDTOFromClassStudent(ClassStudent s) { return(Copy <ClassStudentDTO, ClassStudent>(s)); }