//得到对应的课程名的课程号 public DataTable GetSelectedCourseCno(Model.Course course) { string SQL = "select * from Course where cname='" + course.Cname + "'"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); }
private void init_subAttandanceColumn(Model.Course course) { foreach (SubAttandance subAtt in course.allSubAttandances()) { mainGrid.Columns.Add(init_createColumn(subAtt)); } }
private void excelImport_Click(object sender, EventArgs e) { try { string fileName = HKOpenFileDialog.selectFile(HKDialogFilter.Excel); ExcelReader reader = ExcelReader.createReader(fileName); List <StuList> list = reader.stuListsClassifyByClass(); Model.Course course = courseRef; foreach (StuList item in list) { if (course.containsStuListByName(item.name)) { course.getStuListByName(item.name).appendStudents(item); } else { course.addStuList(item); } } GlobalStation.shareInstance.librarySave(delegate() { initTabsContent(); }, null); }catch (ExcelReader.ExcelOpenFailedException ex) { MessageBox.Show("文件打开失败:{0}", ex.Message); }catch (HKOpenFileDialog.CancelOpenFileException ex) { Console.WriteLine(ex.Message); } }
public static bool AddTermCourse(string courseID, string teacherID, out string error) { error = ""; Model.Course course = courses.RetrieveCourse(courseID); if (course == null) { error = "不存在课程ID为" + courseID + "的课程"; return(false); } else { Model.Person teacher = teachers.Retrieve(teacherID); if (teacher == null) { error = "不存在教师ID为" + teacherID + "的教师"; return(false); } else { if (termCourses.RetrieveTermCourse(courseID + teacherID) == null) { termCourses.AddNewTermCourse(new Model.TermCourse(courseID, teacherID)); error = "添加学期课程记录成功"; return(true); } else { error = "添加学期课程记录失败"; return(false); } } } }
/// <summary> /// 获取编辑时单个教师的信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public Model.Teacher GetTeacher(int Id) { Model.Teacher teacher = new Model.Teacher(); Model.Course course = new Model.Course(); Model.School school = new Model.School(); SqlConnection co = SQLSeverOpen(); SqlCommand cmd = new SqlCommand(); cmd.Connection = co; cmd.CommandText = "select * from V_Teacher_Course_School where Id = " + Id; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { teacher.Id = Convert.ToInt32(reader["Id"]); teacher.TeacherName = Convert.ToString(reader["TeacherName"]); teacher.TeacherWorkNum = Convert.ToString(reader["TeacherWorkNum"]); teacher.TeacherPWD = Convert.ToString(reader["TeacherPWD"]); teacher.SchoolId = Convert.ToInt32(reader["SchoolId"]); school.Id = Convert.ToInt32(reader["SchoolId"]); school.SchoolName = Convert.ToString(reader["SchoolName"]); school.SchoolNum = Convert.ToString(reader["SchoolNum"]); teacher.IsLeader = Convert.ToInt32(reader["IsLeader"]); teacher.Sex = Convert.ToInt32(reader["Sex"]); teacher.CourseId = Convert.ToInt32(reader["CourseId"]); course.Id = Convert.ToInt32(reader["CourseId"]); course.CourseName = Convert.ToString(reader["CourseName"]); teacher.Course = course; teacher.School = school; } co.Close(); return(teacher); }
private static void QueryCourse() { string error = ""; Console.WriteLine(); Console.Write("请选择(1--查询某门课程信息 2--查询所有课程信息):"); string cmd = Console.ReadLine(); if (cmd == "1") { Console.Write("请输入该课程的ID:"); string id = Console.ReadLine(); Model.Course course = BLL.AdminBLL.RetrieveCourse(id, out error); Console.WriteLine("课程信息:"); Console.WriteLine("课程ID\t 课程名"); Console.WriteLine("---------------"); Console.WriteLine("{0}\t {1}", course.CourseID, course.Name); } else if (cmd == "2") { Model.Course[] courses = BLL.AdminBLL.RetrieveAllCourse(); Console.WriteLine("课程信息"); Console.WriteLine("课程ID\t 课程名"); Console.WriteLine("---------------"); for (int i = 0; i < courses.Length; i++) { Console.WriteLine("{0}\t {1}", courses[i].CourseID, courses[i].Name); } } else { Console.WriteLine("无效的操作"); } }
//显示学生选的课程 public DataTable ShowCourse(Model.Course course) { string SQL = "select sc.id,sc.cno,course.cname,sc.sno,student.sclass,grade from sc,course,student where sc.cno=course.cno and student.sno=sc.sno"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); }
public void displayCourseHall(Model.Course course) { CourseHall hall = new CourseHall(); hall.libraryUUID = libraryUUID; hall.CourseId = course.id; GlobalStation.shareInstance.entrance.showPanel(hall); }
private void init_subExtraColumn(Model.Course course) { subExtraStartIndex = mainGrid.Columns.Count; foreach (subExtra extra in course.allExtras()) { mainGrid.Columns.Add(init_createColumn(extra)); } }
private StuList createStuList(string title) { Model.Course course = courseRef; StuList stuList = new StuList(); stuList.name = title; return(stuList); }
private void contentInit_addTableViewCell(Model.Course course) { CourseCell cell = new CourseCell(course.name, course.remark); cell.tableView = hkTableView1; cell.libHall = this; cell.courseId = course.id; hkTableView1.add(cell); }
/* ----- configuration ----- */ private void createNewSubAttandance() { Model.Course course = hall.courseRef; newSubAtt = new SubAttandance(DateTime.Now); course.addSubAttandance(newSubAtt); DataGridViewColumn column = hall.init_createColumn(newSubAtt); hall.mainGrid.Columns.Insert((int)mainGridCellIndex.subAttStartIndex + course.allSubAttandances().Count - 1, column); }
public static void showCourseReport(string title, StuList stuList, Model.Course course) { CourseReport report = new CourseReport(); report.isSingleButtonMode = true; report.titleLabel.Text = title; report.stuList = stuList; report.course = course; report.ShowDialog(); }
private void init_rows(Model.Course course, StuList stuList) { foreach (Student stu in stuList.allStudents()) { int newRowIndex = mainGrid.Rows.Add(); DataGridViewRow newRow = mainGrid.Rows[newRowIndex]; init_rows_baseAttributeInit(newRow, stu); init_rows_attandanceInit(newRow, course.allSubAttandances(), stu); init_rows_extrasInit(newRow, course.allExtras(), stu); } }
public static ScoreCal createForCourse(Model.Course course) { if (course == null) { throw new CalCreateFailedException("课程实例为空"); } ScoreCal cal = new ScoreCal(); cal.course = course; return(cal); }
private Model.Course createAndSaveCourse(NewCourseInfo courseInfo, Record[] records) { Model.Course course = new Model.Course(courseInfo.name, courseInfo.id, courseInfo.remark, records); libraryRef.addCourse(course); GlobalStation.shareInstance.librarySave(delegate() { }, delegate() { libraryRef.removeCourse(course); course = null; }); return(course); }
private void tabs_addNewStuList(string title) { Model.Course course = courseRef; StuList stuList = createStuList(title); course.addStuList(stuList); GlobalStation.shareInstance.librarySave(null, delegate() { course.removeStuList(stuList.UUID); }); initTabsContent(); }
public void maingrid_addRow(Student stu) { Model.Course course = courseRef; int rowIndex = mainGrid.Rows.Add(); DataGridViewRow row = mainGrid.Rows[rowIndex]; stopCellValueChanged(); init_rows_baseAttributeInit(row, stu); init_rows_attandanceInit(row, course.allSubAttandances(), stu); init_rows_extrasInit(row, course.allExtras(), stu); startCellValueChanged(); }
private void tabBtnMenuMethod_ChangeName(string uuid, string name) { Model.Course course = courseRef; StuList stuList = course.getStuList(uuid); string originName = stuList.name; stuList.name = name; GlobalStation.shareInstance.librarySave(null, delegate() { stuList.name = originName; }); initTabsContent(); }
/// <summary> /// 增加新课程 /// </summary> /// <param name="newCourse"></param> /// <returns></returns> public bool AddNewCourse(Model.Course course) { for (int i = 0; i < courses.Count; i++) { if (course.CourseID == courses[i].CourseID) { return(false); } } this.courses.Add(course); return(true); }
//查看课程编号是否存在 public int IsCnoExist(Model.Course course) { int count = 0; string SQL = "select * from Course where Cno='" + course.Cno + "'"; DataTable dt = new DataTable(); dt = db.SQLGetDataTable(SQL); if (dt.Rows.Count > 0) { count = 1; } return(count); }
private void tabBtnMenuMethod_DeleteStuList(string stuListUUID) { Model.Course course = null; StuList stuList = null; course = courseRef; stuList = course.removeStuList(stuListUUID); GlobalStation.shareInstance.librarySave(null, delegate() { course.addStuList(stuList); }); initTabsContent(); initTableViewContent(); }
private void showCourseHall(NewCourseInfo courseInfo) { Record[] records = produceRecordsArray(courseInfo.weight); Model.Course course = createAndSaveCourse(courseInfo, records); if (course != null) { displayCourseHall(course); } else { HKConfirmForm.showConfirmForm("课程存储失败,请重新尝试"); } }
public static ExcelExporter createExporter(List <StuList> lists, Model.Course course, string path) { try { ExcelExporter exporter = new ExcelExporter(); exporter.lists = lists; exporter.course = course; exporter.path = path; exporter.init(); return(exporter); } catch { throw new ParseException("文件解析失败"); } }
private void deleteTheCourseFromLibrary(string courseId) { AttandanceLibrary lib = libHall.libraryRef; if (lib.containsCourse(courseId)) { Model.Course course = lib[courseId]; lib.removeCourse(course); GlobalStation.shareInstance.librarySave(null, delegate() { lib.addCourse(course); }); libHall.contentInit(); } }
public async Task <Model> Handle(Query message, CancellationToken token) { var instructors = await _db.Instructors .Include(i => i.CourseAssignments) .ThenInclude(c => c.Course) .OrderBy(i => i.LastName) .ProjectTo <Model.Instructor>(_configuration) .ToArrayAsync(token); Model.Course[] courses; Model.Enrollment[] enrollments; if (message.Id != null) { courses = await _db.CourseAssignments .Where(ci => ci.InstructorId == message.Id) .Select(ci => ci.Course) .ProjectTo <Model.Course>(_configuration) .ToArrayAsync(token); } else { courses = new Model.Course[0]; } if (message.CourseId != null) { enrollments = await _db.Enrollments .Where(x => x.CourseId == message.CourseId) .ProjectTo <Model.Enrollment>(_configuration) .ToArrayAsync(token); } else { enrollments = new Model.Enrollment[0]; } var viewModel = new Model { Instructors = instructors, Courses = courses, Enrollments = enrollments, InstructorId = message.Id, CourseId = message.CourseId }; return(viewModel); }
private void overwriteOrCreateNew(AttandanceLibrary lib, Model.Course course) { HKConfirmForm form = new HKConfirmForm(); form.title = "已存在该课程Id,是否覆盖?"; if (form.showConfirm() == true) { lib.removeCourse(lib[course.id]); lib.addCourse(course); } else { course.id = Guid.NewGuid().ToString(); lib.addCourse(course); } }
private void yesButtonHandler(NewCourseInfo info) { Model.Course course = hall.courseRef; course.name = info.name; course.id = info.id; course.remark = info.remark; course.getRecord(Record.RType.attendance).weight = info.weight.attendance; course.getRecord(Record.RType.late).weight = info.weight.late; course.getRecord(Record.RType.sickLeave).weight = info.weight.sickLeave; course.getRecord(Record.RType.businessLeave).weight = info.weight.businessLeave; course.getRecord(Record.RType.absenteeism).weight = info.weight.absenteeism; GlobalStation.shareInstance.librarySave(delegate() { hall.updateCourseInfo(course.name, course.id, course.remark); }, null); Close(); }
//课程的添加 public bool AddCourse(Model.Course course) { bool flag = false; IDataParameter[] parameter = { new SqlParameter("@Cno", SqlDbType.VarChar, 50), new SqlParameter("@Cname", SqlDbType.VarChar, 50), new SqlParameter("@Tno", SqlDbType.VarChar, 50) }; parameter[0].Value = course.Cno; parameter[1].Value = course.Cname; parameter[2].Value = course.Tno; flag = pr.ExecuteProcedure("AddCourse", parameter); return(flag); }
/// <summary> /// 获取老师所教的所有课程 /// </summary> /// <param name="teacherId"></param> /// <param name="pageSize"></param> /// <param name="pageNumber"></param> /// <returns></returns> public List <Model.Teacher> GetList(int teacherId, int pageSize, int pageNumber) { List <Model.Teacher> list = new List <Model.Teacher>(); SqlConnection co = SQLSeverOpen(); SqlCommand cmd = new SqlCommand(); cmd.Connection = co; cmd.CommandText = "select * from V_Teacher_Course_Class_School where Id = " + teacherId; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Model.Teacher teacher = new Model.Teacher(); Model.Course course = new Model.Course(); Model.Class tempClass = new Model.Class(); Model.School school = new Model.School(); teacher.Id = Convert.ToInt32(reader["Id"]); teacher.TeacherName = Convert.ToString(reader["TeacherName"]); teacher.TeacherWorkNum = Convert.ToString(reader["TeacherWorkNum"]); teacher.SchoolId = Convert.ToInt32(reader["SchoolId"]); teacher.IsLeader = Convert.ToInt32(reader["IsLeader"]); teacher.Sex = Convert.ToInt32(reader["Sex"]); teacher.CourseId = Convert.ToInt32(reader["CourseId"]); course.Id = Convert.ToInt32(reader["CourseId"]); course.CourseName = Convert.ToString(reader["CourseName"]); try { tempClass.Id = Convert.ToInt32(reader["ClassId"]); tempClass.ClassName = Convert.ToString(reader["ClassName"]); tempClass.SchoolId = Convert.ToInt32(reader["SchoolId"]); } catch (Exception) { continue; } school.Id = Convert.ToInt32(reader["SchoolId"]); school.SchoolName = Convert.ToString(reader["SchoolName"]); school.SchoolNum = Convert.ToString(reader["SchoolNum"]); teacher.School = school; teacher.Course = course; teacher.TempClass = tempClass; list.Add(teacher); } return(list); }
/// <summary> /// 保存课程 /// </summary> /// <param name="context"></param> public void SaveCourse(HttpContext context) { var zwJson = new ZwJson(); var course = new Model.Course { Id = Guid.NewGuid().ToString(), Contents = context.Request.Params["content"], CreateDt = DateTime.Now, Title = context.Request.Params["title"], Creater = context.Session["UserName"].ToString(), ClickCount = 0 }; CourseService courseService = new CourseService(_session); courseService.Save(course); zwJson.IsSuccess = true; zwJson.JsExecuteMethod = "Ajax_SaveCourse"; context.Response.Write(_jss.Serialize(zwJson)); }