private void SaveData()
{
var user = new SysUser();
if (UserID > 0)
{
user.LoadByIdentity(UserID);
SetData(user);
user.Update();
}
else
{
SetData(user);
//学生初始化
user.UserType = (int)SysUserType.Student;
user.Password = SysConsts.InitPassword.MD5Hash().ToUpper();
user.RoleIDs = "1";
user.IsDeleted = false;
var deptId = Convert.ToInt32(tbxDepartmentID.SelectedValue);
var dept = new SysDepartment(deptId);
dept.Load();
user.DepartmentID = dept.ID;
user.DepartmentName = dept.Name;
user.BaseDeptID = dept.BaseDeptID;
user.BaseDeptName = dept.BaseDeptName;
user.DepartmentType = dept.DepartmentType;
user.Add();
}
}
private void SaveData()
{
var dept = new SysDepartment();
if (DeptID > 0)
{
dept.LoadByIdentity(DeptID);
SetData(dept);
dept.Update();
}
else
{
SetData(dept);
//班级初始化
dept.IsDeleted = false;
var rootDept = new SysDepartment(SysConsts.RootDeptID);
rootDept.Load();
dept.BaseDeptName = rootDept.Name;
dept.BaseDeptID = rootDept.ID;
dept.ParentID = rootDept.ID;
dept.ParentName = rootDept.Name;
dept.Add();
}
}
/// <summary>
/// 登陆
/// </summary>
public static BaseUser UserLogin(SysUser user)
{
var dept = new SysDepartment(user.DepartmentID);
dept.Load();
user.DepartmentName = dept.Name;
user.BaseDeptName = dept.BaseDeptName;
user.LastLoginTime = DateTime.Now;
user.UpdateTime = DateTime.Now;
user.Update();
return(new BaseUser
{
ID = user.ID,
UserName = user.UserName,
UserType = user.UserType,
RoleIDs = user.RoleIDs,
RealName = user.RealName,
Sex = user.Sex,
Binrthday = user.Binrthday,
Tel = user.Tel,
Mobile = user.Mobile,
Email = user.Email,
Duty = user.Duty,
BaseDeptID = user.BaseDeptID,
BaseDeptName = user.BaseDeptName,
DepartmentID = user.DepartmentID,
DepartmentName = user.DepartmentName,
DeptPath = user.DeptPath,
Status = user.Status,
});
}
private void SaveData()
{
var user = new SysUser();
if (UserID > 0)
{
user.LoadByIdentity(UserID);
SetData(user);
user.Update();
}
else
{
SetData(user);
//老师初始化
user.UserType = (int)SysUserType.Teacher;
user.Password = SysConsts.InitPassword.MD5Hash().ToUpper();
user.RoleIDs = "2";
user.IsDeleted = false;
var dept = new SysDepartment(SysConsts.TeacherDeptID);
dept.Load();
user.DepartmentID = dept.ID;
user.DepartmentName = dept.Name;
user.BaseDeptID = dept.BaseDeptID;
user.BaseDeptName = dept.BaseDeptName;
user.DepartmentType = dept.DepartmentType;
user.Add();
}
}
private void LoadData()
{
if (DeptID < 0)
{
return;
}
var dept = new SysDepartment(DeptID);
dept.Load();
phData.BindObjectToControls(dept, "tbx");
}
protected void rpList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = int.Parse(e.CommandArgument.ToString());
if (e.CommandName == "Delete")
{
var dept = new SysDepartment(id);
dept.Load();
dept.IsDeleted = true;
dept.Update();
LoadData();
}
}
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();
}
}
private void ExportPreform(int courseId, int deptId)
{
var course = new SysCourse(courseId);
course.Load();
var dept = new SysDepartment(deptId);
dept.Load();
var orderby = SysPerform.SQLCOL_USERNAME;
var sb = new StringBuilder("1=1");
sb.AppendFormat(" AND {0}='{1}' ", SysPerform.SQLCOL_COURSEID, courseId);
sb.AppendFormat(" AND {0}='{1}' ", SysPerform.SQLCOL_DEPARTMENTID, deptId);
var list = DataAccess.Select(typeof(SysPerform), sb.ToString(), orderby, true) as IList <SysPerform>;
var book = new Workbook(Server.MapPath("PerformReportTmpl.xls"));
var sheet = book.Worksheets[0];
var cells = sheet.Cells;
if (list.Count > 1)
{
sheet.Cells.InsertRows(5, list.Count - 1);
}
//标题
//var report = new SysPerformReport(courseId, deptId);
//report.Load();
//var rowTitle = cells.Rows[0];
//rowTitle[1].Value = EnumTypeHelper.GetDescriptionFromEnum(typeof(SysDeptType), report.DepartmentType);
//rowTitle[4].Value = report.DepartmentName;
//rowTitle[7].Value = report.CourseName;
//rowTitle[12].Value = report.TeacherName;
var cellStyle = book.Styles[book.Styles.Add()];
cellStyle.IsTextWrapped = true;
cellStyle.VerticalAlignment = TextAlignmentType.Center;
cellStyle.Font.Name = "宋体";
cellStyle.Font.Size = 10;
cellStyle.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
cellStyle.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
cellStyle.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
cellStyle.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
var centerStyle = book.Styles[book.Styles.Add()];
centerStyle.IsTextWrapped = true;
centerStyle.HorizontalAlignment = TextAlignmentType.Center;
centerStyle.VerticalAlignment = TextAlignmentType.Center;
centerStyle.Font.Name = "宋体";
centerStyle.Font.Size = 10;
centerStyle.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
centerStyle.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
centerStyle.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
centerStyle.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
for (int i = 0; i < list.Count; i++)
{
var rowIndex = i + 4;
var row = cells.Rows[rowIndex];
var data = list[i];
row[0].SetStyle(cellStyle);
row[0].Value = string.Format("{0}", data.UserName);
row[1].SetStyle(cellStyle);
row[1].Value = string.Format("{0}", data.RealName);
row[2].SetStyle(centerStyle);
row[2].Value = string.Format("{0}", data.RoutineScore1.ToString("0"));
cells.Merge(rowIndex, 2, 1, 2);
row[4].SetStyle(centerStyle);
row[4].Value = string.Format("{0}", data.RoutineScore2.ToString("0"));
cells.Merge(rowIndex, 4, 1, 3);
row[7].SetStyle(centerStyle);
row[7].Value = string.Format("{0}", data.RoutineScore3.ToString("0"));
cells.Merge(rowIndex, 7, 1, 4);
row[11].SetStyle(centerStyle);
row[11].Value = string.Format("{0}", data.TaskScore1.ToString("0"));
cells.Merge(rowIndex, 11, 1, 3);
row[14].SetStyle(centerStyle);
row[14].Value = string.Format("{0}", data.TaskScore2.ToString("0"));
cells.Merge(rowIndex, 14, 1, 3);
row[17].SetStyle(centerStyle);
row[17].Value = string.Format("{0}", data.TaskScore3.ToString("0"));
cells.Merge(rowIndex, 17, 1, 3);
row[20].SetStyle(centerStyle);
row[20].Value = string.Format("{0}", data.RoutineScore4.ToString("0"));
cells.Merge(rowIndex, 20, 1, 3);
row[23].SetStyle(centerStyle);
row[23].Value = string.Format("{0}", data.TaskScore4.ToString("0"));
cells.Merge(rowIndex, 23, 1, 3);
row[26].SetStyle(centerStyle);
row[26].Value = string.Format("{0}", data.TaskScore5.ToString("0"));
cells.Merge(rowIndex, 26, 1, 3);
row[29].SetStyle(centerStyle);
row[29].Value = string.Format("{0}", data.TaskScore6.ToString("0"));
cells.Merge(rowIndex, 29, 1, 3);
row[32].SetStyle(centerStyle);
row[32].Value = string.Format("{0}", data.TaskScore7.ToString("0"));
cells.Merge(rowIndex, 32, 1, 3);
row[35].SetStyle(centerStyle);
row[35].Value = string.Format("{0}", data.FinalScore.ToString("0"));
}
book.Save(Response, HttpUtility.UrlEncode(string.Format("{0}-{1}.xls", dept.Name, course.Name)),
ContentDisposition.Attachment, new XlsSaveOptions(SaveFormat.Auto));
}
