//得到对应的课程名的课程号
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));
}
