private void CalcTaskNum(int deptId, int courseId)
{
var studentList = DataAccess.Select(typeof(SysUser),
string.Format("IsDeleted=0 AND {0}='{1}' AND {2}='{3}'", SysUser.SQLCOL_DEPARTMENTID, deptId,
SysUser.SQLCOL_USERTYPE, (int)SysUserType.Student), SysUser.SQLCOL_USERNAME, true) as IList <SysUser>;
var taskList = DataAccess.Select(typeof(SysTask),
string.Format("{0}='{1}' AND {2}='{3}'", SysTask.SQLCOL_DEPARTMENTID, deptId,
SysTask.SQLCOL_COURSEID, courseId), true) as IList <SysTask>;
var list = new List <SysPerform>();
foreach (var student in studentList)
{
var preform = new SysPerform();
preform.UserName = student.UserName;
preform.RealName = student.RealName;
preform.TaskScore1 = GetTaskNum(taskList, student.ID, (int)TaskCategory.Task1);
preform.TaskScore2 = GetTaskNum(taskList, student.ID, (int)TaskCategory.Task2);
preform.TaskScore3 = GetTaskNum(taskList, student.ID, (int)TaskCategory.Task3);
preform.TaskScore4 = GetTaskNum(taskList, student.ID, (int)TaskCategory.Task4);
preform.TaskScore5 = GetTaskNum(taskList, student.ID, (int)TaskCategory.Task5);
preform.TaskScore6 = GetTaskNum(taskList, student.ID, (int)TaskCategory.Task6);
preform.TaskScore7 = GetTaskNum(taskList, student.ID, (int)TaskCategory.Task7);
list.Add(preform);
}
rpList.DataSource = list;
rpList.DataBind();
}
private void SaveData()
{
if (CourseID > 0 && StudentID > 0)
{
var preform = new SysPerform(CourseID, StudentID);
preform.Load();
SetData(preform);
preform.Update();
}
}
private void SetData(SysPerform preform)
{
preform.RoutineScore1 = tbxRoutineScore1.Text.ToInt32();
preform.RoutineScore2 = tbxRoutineScore2.Text.ToInt32();
preform.RoutineScore3 = tbxRoutineScore3.Text.ToInt32();
preform.RoutineScore4 = tbxRoutineScore4.Text.ToInt32();
preform.RoutineScoreTime = DateTime.Now;
preform.FinalScore = preform.RoutineScore1 +
preform.RoutineScore2 +
preform.RoutineScore3 +
preform.RoutineScore4 +
preform.TaskScore1 +
preform.TaskScore2 +
preform.TaskScore3 +
preform.TaskScore4 +
preform.TaskScore5 +
preform.TaskScore6 +
preform.TaskScore7;
preform.FinalScoreTime = DateTime.Now;
preform.UpdateTime = DateTime.Now;
}
private void LoadData()
{
if (StudentID < 0 || CourseID < 0)
{
return;
}
var preform = new SysPerform(CourseID, StudentID);
preform.Load();
phData.BindObjectToControls(preform, "tbx");
tbxRoutineScore1.Text = preform.RoutineScore1.ToString("0");
tbxRoutineScore2.Text = preform.RoutineScore2.ToString("0");
tbxRoutineScore3.Text = preform.RoutineScore3.ToString("0");
tbxRoutineScore4.Text = preform.RoutineScore4.ToString("0");
//默认
//if (preform.FinalScoreTime == DateTime.MinValue)
//{
// tbxRoutineScore3.Text = "0";
// tbxRoutineScore4.Text = "0";
//}
}
private void CalcPreform(int deptId, int courseId)
{
var report = new SysPerformReport(courseId, deptId);
if (!report.Load())
{
report.Status = 10;
}
report.TeacherID = CurrentUser.ID;
report.TeacherName = CurrentUser.RealName;
report.CourseName = searchCourseID.SelectedItem.Text;
report.DepartmentName = searchDepartmentID.SelectedItem.Text;
var dept = new SysDepartment(deptId);
dept.Load();
report.RegYear = dept.RegYear;
report.DepartmentType = dept.DepartmentType;
report.UpdateTime = DateTime.Now;
report.Save();
var studentList = DataAccess.Select(typeof(SysUser),
string.Format("IsDeleted=0 AND {0}='{1}' AND {2}='{3}'", SysUser.SQLCOL_DEPARTMENTID, deptId,
SysUser.SQLCOL_USERTYPE, (int)SysUserType.Student), true) as IList <SysUser>;
var taskList = DataAccess.Select(typeof(SysTask),
string.Format("{0}='{1}' AND {2}='{3}'", SysTask.SQLCOL_DEPARTMENTID, deptId,
SysTask.SQLCOL_COURSEID, courseId), true) as IList <SysTask>;
foreach (var student in studentList)
{
var preform = new SysPerform(courseId, student.ID);
if (!preform.Load())
{
preform.RoutineScore1 = 10;
preform.RoutineScore2 = 10;
preform.RoutineScore3 = 0; //5;
preform.RoutineScore4 = 0; //10;
}
preform.UserName = student.UserName;
preform.RealName = student.RealName;
preform.DepartmentID = student.DepartmentID;
preform.TaskScore1 = GetTaskScore(taskList, student.ID, (int)TaskCategory.Task1);
preform.TaskScore2 = GetTaskScore(taskList, student.ID, (int)TaskCategory.Task2);
preform.TaskScore3 = GetTaskScore(taskList, student.ID, (int)TaskCategory.Task3);
preform.TaskScore4 = GetTaskScore(taskList, student.ID, (int)TaskCategory.Task4);
preform.TaskScore5 = GetTaskScore(taskList, student.ID, (int)TaskCategory.Task5);
preform.TaskScore6 = GetTaskScore(taskList, student.ID, (int)TaskCategory.Task6);
preform.TaskScore7 = GetTaskScore(taskList, student.ID, (int)TaskCategory.Task7);
preform.FinalScore = preform.RoutineScore1 +
preform.RoutineScore2 +
preform.RoutineScore3 +
preform.RoutineScore4 +
preform.TaskScore1 +
preform.TaskScore2 +
preform.TaskScore3 +
preform.TaskScore4 +
preform.TaskScore5 +
preform.TaskScore6 +
preform.TaskScore7;
preform.UpdateTime = DateTime.Now;
preform.Save();
}
}
