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)); }