protected void lbtnSubmit_Click(object sender, EventArgs e) { int teacher_id = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString()); string oldpwd = txtOld.Text; string newpwd = txtNew.Text; string checkpwd = txtCheck.Text; using (var db = new TeachingCenterEntities()) { Teacher teacher = (from it in db.Teacher where it.id == teacher_id select it).FirstOrDefault(); if (oldpwd.Length == 0 || newpwd.Length == 0 || checkpwd.Length == 0) { Response.Write("<script>alert('输入不能为空!');</script>"); } else if (PwdHelper.MD5(oldpwd) != teacher.password) { Response.Write("<script>alert('原密码错误!');</script>"); } else if (newpwd != checkpwd) { Response.Write("<script>alert('两次输入密码不一致!');</script>"); } else { teacher.password = PwdHelper.MD5(newpwd); db.SaveChanges(); Server.Transfer("EditInfo.aspx"); //JSHelper.AlertThenRedirect("修改成功!", "EditInfo.aspx"); } } }
public override void Loaded() { base.Loaded(); Caption.Value = pageCaption; Description.Value = pageDescription; Title.Value = Caption.Value; List <TblGroups> groups = ServerModel.DB.Query <TblGroups>(null); IList <TblCurriculums> curriculums = TeacherHelper.CurrentUserCurriculums(FxCurriculumOperations.Use); if (curriculums.Count == 0) { MainTableVisible.Value = false; if (groups.Count == 0) { Message.Value = neitherCurriculumsNorGroup; } else { Message.Value = noCurriculums; } } else { if (groups.Count == 0) { MainTableVisible.Value = false; Message.Value = noGroups; } } }
private void fillOperationsTable() { Operations.Rows.Clear(); foreach (FxCourseOperations operation in TeacherHelper.CourseOperations()) { TableRow operationRow = new TableRow(); TableCell operationCell = new TableCell(); CheckBox operationCheckBox = new CheckBox(); operationCheckBox.Text = operation.Name; operationCheckBox.ID = operation.ID.ToString(); TblPermissions permission = TeacherHelper.GetPermissionForCourse(course, operation); if (permission == null || !permission.CanBeDelagated) { operationCheckBox.Enabled = false; } else { operationCheckBox.Checked = TeacherHelper.AreParentAndChildByCourse(permission, teacher, course); } operationCell.Controls.Add(operationCheckBox); operationRow.Cells.Add(operationCell); Operations.Rows.Add(operationRow); } }
private void buildStageTable(TblStages stage) { foreach (TblPermissions permission in TeacherHelper.GroupPermissionsForStage(group, stage)) { Table_Operations.Rows.AddAt(Table_Operations.Rows.Count - 1, buildPermissionRow(permission)); } }
protected void lbtnSubmit_Click(object sender, EventArgs e) { string message = txtMessage.Text; int judge_id = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString()); int project_id = Convert.ToInt32(Request.QueryString["id"]); int stage = Convert.ToInt32(Request.QueryString["stage"]); int is_pass = 0; HtmlInputHidden result = FindControl("result") as HtmlInputHidden; if (result.Value == "") { Response.Write("<script>alert('请选择是否通过!');</script>"); } else { is_pass = Convert.ToInt32(result.Value); using (var db = new TeachingCenterEntities()) { var record = (from it in db.ProjectJudge where it.judge_id == judge_id && it.project_id == project_id && it.stage == stage select it).FirstOrDefault(); record.comment = message; record.is_pass = is_pass; db.SaveChanges(); //Server.Transfer("MyJudgePro.aspx?pageNumber=1"); Response.Write("<script>location.href='MyJudgePro.aspx?pageNumber=1';</script>"); } } }
private void buildCurriculumTable(TblCurriculums curriculum) { foreach (TblPermissions permission in TeacherHelper.GroupPermissionsForCurriculum(group, curriculum)) { Table_Operations.Rows.AddAt(Table_Operations.Rows.Count - 1, buildPermissionRow(permission)); } }
// 获取评审未评判的项目数量 public int getJudgeNumber() { try { int judge_id = Convert.ToInt32(TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString())); using (var db = new TeachingCenterEntities()) { var project = from it in db.ProjectJudge where it.judge_id == judge_id && it.is_pass == -1 select it; int number = project.Count(); foreach (ProjectJudge item in project) { var category = (from it in db.ProjectCategory where it.id == item.category select it).FirstOrDefault(); DateTime now = DateTime.Now; DateTime end = Convert.ToDateTime(category.judge_end_time); if (DateTime.Compare(now, end) > 0) { number = number - 1; } } return(number); } } catch { return(0); } }
private ControlInfo BuildStages(TblCurriculums curriculum, TreeNode node, DateTime?date) { IList <TblStages> stages = TeacherHelper.StagesOfCurriculum(curriculum); ControlInfo controlInfo = new ControlInfo(); foreach (TblStages stage in stages) { var child = new IdendtityNode(stage); if (StudentPermissionsHelper.IsDateAllowed(date, _userId, stage.ID, NodeType.Stage, GetOperationType)) { controlInfo = BuildThemes(stage, child); if (controlInfo.IsControlStartsNow) { controlInfo.AddCurriculumnToInfo(curriculum); return(controlInfo); } if (child.ChildNodes.Count != 0) { node.ChildNodes.Add(child); } } } return(controlInfo); }
/*protected void lbtSendCode_Click(object sender, EventArgs e) * { * string number = txtNumber.Text; * if (number.Length == 0) * JSHelper.ShowAlert("请输入工号!"); * else if (TeacherHelper.checkNumber(number)) * JSHelper.ShowAlert("工号不存在!"); * else * { * using (var db = new TeachingCenterEntities()) * { * string email = (from it in db.Teacher where it.number == number select it.email).ToString(); * if((from it in db.PasswordCode where it.teacher_number == number select it).Any()) * { * PasswordCode pwdcode = (from it in db.PasswordCode where it.teacher_number == number select it).FirstOrDefault(); * string code = MailHelper.Random_check(email); * pwdcode.code = code; * pwdcode.send_time = DateTime.Now; * db.SaveChanges(); * } * else * { * string code = MailHelper.Random_check(email); * PasswordCode pwdcode = new PasswordCode(); * pwdcode.teacher_number = number; * pwdcode.code = code; * pwdcode.send_time = DateTime.Now; * db.PasswordCode.Add(pwdcode); * db.SaveChanges(); * } * JSHelper.ShowAlert("验证码发送成功,请至邮箱查收!"); * } * } * }*/ /*protected void lbtSubmit_Click(object sender, EventArgs e) * { * string number = txtNumber.Text; * string code = txtCode.Text; * DateTime time = DateTime.Now; * if(number.Length == 0 || code.Length == 0) * JSHelper.ShowAlert("输入不能为空!"); * else if (TeacherHelper.checkNumber(number)) * JSHelper.ShowAlert("工号不存在!"); * else * { * using (var db = new TeachingCenterEntities()) * { * var pwdcode = (from it in db.PasswordCode where it.teacher_number == number && it.code == code select it).FirstOrDefault(); * DateTime send_time = pwdcode.send_time; * if((time - send_time).TotalMinutes > 15) * JSHelper.ShowAlert("验证码已超时,请重新获取验证码!"); * else * { * var teacher = (from it in db.Teacher where it.number == number select it).FirstOrDefault(); * teacher.password = PwdHelper.MD5("ouc123"); * db.PasswordCode.Remove(pwdcode); * db.SaveChanges(); * JSHelper.AlertThenRedirect("重置密码成功,您的新密码为ouc123!", "main-index.aspx"); * } * } * } * }*/ //protected void GetCode_Click(object sender, EventArgs e) //{ // string number = inputNumber.Value; // if (number.Length == 0) // JSHelper.ShowAlert("请输入工号!"); // else if (TeacherHelper.checkNumber(number)) // JSHelper.ShowAlert("工号不存在!"); // else // { // using (var db = new TeachingCenterEntities()) // { // string email = (from it in db.Teacher where it.number == number select it.email).ToString(); // if ((from it in db.PasswordCode where it.teacher_number == number select it).Any()) // { // PasswordCode pwdcode = (from it in db.PasswordCode where it.teacher_number == number select it).FirstOrDefault(); // string code = MailHelper.Random_check(email); // pwdcode.code = code; // pwdcode.send_time = DateTime.Now; // db.SaveChanges(); // } // else // { // string code = MailHelper.Random_check(email); // PasswordCode pwdcode = new PasswordCode(); // pwdcode.teacher_number = number; // pwdcode.code = code; // pwdcode.send_time = DateTime.Now; // db.PasswordCode.Add(pwdcode); // db.SaveChanges(); // } // JSHelper.ShowAlert("验证码发送成功,请至邮箱查收!"); // } // } protected void codesubmit_Click(object sender, EventArgs e) { string number = inputNumber.Text; string code = inputCode.Text; DateTime time = DateTime.Now; if (number.Length == 0 || code.Length == 0) { JSHelper.ShowAlert("输入不能为空!"); } else if (TeacherHelper.checkNumber(number)) { JSHelper.ShowAlert("工号不存在!"); } else { using (var db = new TeachingCenterEntities()) { var pwdcode = (from it in db.PasswordCode where it.teacher_number == number && it.code == code select it).FirstOrDefault(); DateTime send_time = pwdcode.send_time; if ((time - send_time).TotalMinutes > 15) { JSHelper.ShowAlert("验证码已超时,请重新获取验证码!"); } else { var teacher = (from it in db.Teacher where it.number == number select it).FirstOrDefault(); teacher.password = PwdHelper.MD5("ouc123"); db.PasswordCode.Remove(pwdcode); db.SaveChanges(); JSHelper.AlertThenRedirect("重置密码成功,您的新密码为ouc123!", "main-index.aspx"); } } } }
protected void Page_Load(object sender, EventArgs e) { try { //判断是不是评审 if (!TeacherHelper.isJudge(Session["TeacherNumber"].ToString())) { liJudge.Visible = false; } int teacher = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString()); if (!IsPostBack) { using (var db = new TeachingCenterEntities()) { int id = Convert.ToInt32(Request.QueryString["id"].ToString()); Service ser = db.Service.Single(a => a.Service_id == id); ltType.Text = ServiceHelper.getCategoryName(ser.Service_category); ltTeacher.Text = TeacherHelper.getTeacherNameByID(teacher); txtPhone.Value = ser.Service_phone; txtIntroduction.Value = ser.Service_remarks; } } //判断是不是评审 if (!TeacherHelper.isJudge(Session["TeacherNumber"].ToString())) { liJudge.Visible = false; } } catch { JSHelper.AlertThenRedirect("请先登录!", "main-index.aspx"); } }
protected void btnExport_Click(object sender, EventArgs e) { List <ProjectJudge> ls = new List <ProjectJudge>(); if (Session["ds"] != null) { ls = (List <ProjectJudge>)Session["ds"]; } DataTable dt = new DataTable(); DataColumn dc1 = new DataColumn("评审姓名", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("备注", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("是否通过", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); foreach (ProjectJudge item in ls) { DataRow row = dt.NewRow(); row["评审姓名"] = TeacherHelper.getTeacherNameByID(item.judge_id); row["备注"] = item.comment.Length == 0?"无":item.comment; row["是否通过"] = item.is_pass == 1?"是":"否"; dt.Rows.Add(row); } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "评审意见列表.xlsx"); }
public String UpdateStudentChange(String sc_id, String org_tg_id, String s_id, String t_id, String thesis_state, String sc_allapproval, int accept) { tid = User.Identity.GetUserId(); TeacherHelper teacherHelper = new TeacherHelper(); //update teacher accpet according to allapprove JObject update_change = teacherHelper.UpdateChange(sc_id, s_id, t_id, thesis_state, sc_allapproval, accept); System.Diagnostics.Debug.Print((String)update_change["status"]); /*check if all original teacher agree for change advisor*/ // if they all agree then add new pair if (sc_allapproval.Equals("0") && teacherHelper.CheckOrgChange(sc_id) == 0) { // CheckAllApply get 0 means all student_apply is accepted // then update student apply allapprove to 1 teacherHelper.UpdateStudentChangeApproval(sc_id); } else if (sc_allapproval.Equals("1") && teacherHelper.CheckNewChange(sc_id) == 0) { //remove original pair teacherHelper.removePair(s_id); //add new paired teacherHelper.AddChangePair(sc_id, s_id); //update student change history teacherHelper.UpdateStudentChangeHistory(org_tg_id, state: 1); //state=1 means success } //todo - remove student_change - another query to check is all change checked return(update_change["status"].ToString(Formatting.None)); }
public String UpdateStudentApply(String tg_id, String s_id, int accept) { tid = User.Identity.GetUserId(); TeacherHelper teacherHelper = new TeacherHelper(); JObject update_apply = teacherHelper.UpdateApply(tid, tg_id, accept); //check if all teacher agree for application, /* CheckAllApply get 0 means all student apply in accept */ if (teacherHelper.CheckAllApply(tg_id) == 0) { //add new pair teacherHelper.AddApplyPair(tg_id, s_id); //update student apply history teacherHelper.UpdateStudentApplyHistory(tg_id, state: 1); //state=1 means success } else { //全部都完成了,而且有老師拒絕 //check if all teacher are check and there's rejection to apply //todo - update history student apply (state and ...?) //remove - } return(update_apply["status"].ToString(Formatting.None)); //if ((bool)change["status"]) // return change["status"].ToString(Formatting.None); //else // return change["msg"].ToString(); }
public void UpdateButton_Click() { foreach (TableRow operationRow in Operations.Rows) { CheckBox operationCheckBox = operationRow.Cells[0].Controls[0] as CheckBox; if (operationCheckBox.Enabled) { FxCourseOperations operation = ServerModel.DB.Load <FxCourseOperations>(int.Parse(operationCheckBox.ID)); if (operationCheckBox.Checked) { if (!TeacherHelper.HavePermissionForCourse(teacher.ID, course, operation)) { TeacherHelper.Share(TeacherHelper.GetPermissionForCourse(course, operation), teacher.ID, false); } } else { if (TeacherHelper.HavePermissionForCourse(teacher.ID, course, operation)) { TeacherHelper.RemovePermissionForCourse(course, operation, teacher); } } } } }
public DataTable GetDependencies() { DataTable dependenciesData = new DataTable(); dependenciesData.Columns.Add(Translations.CourseDeleteConfirmationController_GetDependencies_Theme); dependenciesData.Columns.Add(Translations.CourseDeleteConfirmationController_GetDependencies_is_used_in_Curriculum); dependenciesData.Columns.Add(Translations.CourseDeleteConfirmationController_GetDependencies_by); foreach (TblThemes Theme in TeacherHelper.ThemesOfCourse(course)) { TblStages Stage = ServerModel.DB.Load <TblStages>(Theme.StageRef); TblCurriculums Curriculum = ServerModel.DB.Load <TblCurriculums>(Stage.CurriculumRef); IList <TblUsers> CurriculumOwners = TeacherHelper.GetCurriculumOwners(Curriculum); string[] owners = new string[CurriculumOwners.Count]; for (int i = 0; i < owners.Length; i++) { owners[i] = CurriculumOwners[i].DisplayName; } dependenciesData.Rows.Add(Theme.Name, Curriculum.Name, String.Join(", ", owners)); } if (dependenciesData.Rows.Count == 0) { Message.Value = noneMessage; } return(dependenciesData); }
protected void btnCheck_Click(object sender, EventArgs e) { if (txtNum.Text.Length == 0) { Response.Write(JSHelper.ShowAlert("输入不能为空!")); } else { var user = UserHelper.Select(txtNum.Text); if (user == null) { lblName.Text = "不存在该老师或学生<br/>"; } else { var teac = TeacherHelper.Select(user.UserID); if (teac != null) { lblName.Text = teac.Name; } else { var stu = StudentHelper.Select(user.UserID); if (stu != null) { lblName.Text = stu.Name; } else { lblName.Text = "不存在该老师或学生<br/>"; } } } } }
public DataTable GetDependencies() { DataTable dependenciesData = new DataTable(); dependenciesData.Columns.Add("Theme"); dependenciesData.Columns.Add("is used in Curriculum"); dependenciesData.Columns.Add("by"); foreach (TblThemes theme in TeacherHelper.ThemesOfCourse(course)) { IList <TblStages> relatedStages = TeacherHelper.StagesForTheme(theme); foreach (TblStages relatedStage in relatedStages) { TblCurriculums relatedCurriculum = ServerModel.DB.Load <TblCurriculums>((int)relatedStage.CurriculumRef); IList <TblUsers> curriculumOwners = TeacherHelper.GetCurriculumOwners(relatedCurriculum); string owners = ""; foreach (TblUsers curriculumOwner in curriculumOwners) { owners += curriculumOwner.DisplayName + ", "; } owners = owners.TrimEnd(' ', ','); dependenciesData.Rows.Add(theme.Name, relatedCurriculum.Name, owners); } } if (dependenciesData.Rows.Count == 0) { Message.Value = noneMessage; } return(dependenciesData); }
private void fillCurriculumsList() { CurriculumsTable.Rows.Clear(); foreach (TblCurriculums curriculum in TeacherHelper.CurrentUserCurriculums()) { TableRow curriculumRow = new TableRow(); TableCell curriculumCell = new TableCell(); HyperLink curriculumHyperLink = new HyperLink(); curriculumHyperLink.Text = curriculum.Name; curriculumHyperLink.NavigateUrl = ServerModel.Forms.BuildRedirectUrl <TeachersListController>( new TeachersListController { CourseId = -1, CurriculumId = curriculum.ID, BackUrl = RawUrl }); curriculumCell.Controls.Add(curriculumHyperLink); curriculumRow.Cells.Add(curriculumCell); CurriculumsTable.Rows.Add(curriculumRow); } if (CurriculumsTable.Rows.Count == 0) { TableRow curriculumRow = new TableRow(); TableCell curriculumCell = new TableCell(); HyperLink curriculumLink = new HyperLink(); curriculumLink.Text = noCurriculums; curriculumLink.NavigateUrl = ServerModel.Forms.BuildRedirectUrl <CurriculumEditController> (new CurriculumEditController { BackUrl = RawUrl }); curriculumCell.Controls.Add(curriculumLink); curriculumRow.Cells.Add(curriculumCell); CurriculumsTable.Rows.Add(curriculumRow); } }
private void fillCoursesList() { CoursesTable.Rows.Clear(); foreach (TblCourses course in TeacherHelper.CurrentUserCourses()) { TableRow courseRow = new TableRow(); TableCell courseCell = new TableCell(); HyperLink courseHyperLink = new HyperLink(); courseHyperLink.Text = course.Name; courseHyperLink.NavigateUrl = ServerModel.Forms.BuildRedirectUrl <TeachersListController>( new TeachersListController { CourseId = course.ID, CurriculumId = -1, BackUrl = RawUrl }); courseCell.Controls.Add(courseHyperLink); courseRow.Cells.Add(courseCell); CoursesTable.Rows.Add(courseRow); } if (CoursesTable.Rows.Count == 0) { TableRow courseRow = new TableRow(); TableCell courseCell = new TableCell(); HyperLink courseLink = new HyperLink(); courseLink.Text = noCourses; courseLink.NavigateUrl = ServerModel.Forms.BuildRedirectUrl <CourseEditController> (new CourseEditController { BackUrl = RawUrl }); courseCell.Controls.Add(courseLink); courseRow.Cells.Add(courseCell); CoursesTable.Rows.Add(courseRow); } }
protected void btnExport_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); using (var db = new TeachingCenterEntities()) { List <Service> service; DateTime min = new DateTime(1900, 1, 1); DateTime max = new DateTime(2300, 12, 31); if (logmin.Value != "") { min = Convert.ToDateTime(logmin.Value); } if (logmax.Value != "") { max = Convert.ToDateTime(logmax.Value).AddDays(1); } if (dropCategory.SelectedValue != "全部分类") { int category = ServiceHelper.getCategoryID(dropCategory.SelectedValue); service = db.Service.Where(a => a.Service_isdeleted == 0 && a.Service_category == category && a.Service_time >= min && a.Service_time <= max).OrderBy(a => a.Service_isdeal).ThenByDescending(a => a.Service_time).ToList(); } else { service = db.Service.Where(a => a.Service_isdeleted == 0 && a.Service_time >= min && a.Service_time <= max).OrderBy(a => a.Service_isdeal).ThenByDescending(a => a.Service_time).ToList(); } DataColumn dc1 = new DataColumn("序号", System.Type.GetType("System.String")); DataColumn dc2 = new DataColumn("申请人", System.Type.GetType("System.String")); DataColumn dc3 = new DataColumn("申请时间", System.Type.GetType("System.DateTime")); DataColumn dc4 = new DataColumn("联系方式", System.Type.GetType("System.String")); DataColumn dc5 = new DataColumn("备注", System.Type.GetType("System.String")); DataColumn dc6 = new DataColumn("审核状态", System.Type.GetType("System.String")); dt.Columns.Add(dc1); dt.Columns.Add(dc2); dt.Columns.Add(dc3); dt.Columns.Add(dc4); dt.Columns.Add(dc5); dt.Columns.Add(dc6); int count = 1; foreach (var i in service) { DataRow row = dt.NewRow(); row["序号"] = count.ToString(); row["申请人"] = TeacherHelper.getTeacherNameByID(i.Service_teacher); row["申请时间"] = i.Service_time.ToString(); row["联系方式"] = i.Service_phone.ToString(); row["备注"] = i.Service_remarks.ToString(); row["审核状态"] = i.Service_isdeal == 0 ? "未处理" : "已处理"; dt.Rows.Add(row); } } ExcleHelper.ExportDataGrid(dt, "application/ms-excel", "教师服务申请.xls"); }
protected void lbtAdd_Click(object sender, EventArgs e) { try { string alert; int teacher = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString()); //int teacher = 1; int id; //int teacher = 1, id = 3; try { id = Convert.ToInt32(Request.QueryString["id"].ToString()); } catch { id = 3; } using (var db = new TeachingCenterEntities()) { Activity ac = db.Activity.Single(a => a.Activity_id == id); if (ac.Activity_nowcount >= ac.Activity_limitcount) { alert = "操作失败,人数已达到上限。"; } else if (ac.Activity_hold_time < DateTime.Now) { alert = "该活动已结束!"; } else { var acs = from it in db.ActivityTeacher where it.teacher_id == teacher && it.activity_id == id select it; if (acs.Count() > 0) { alert = "您已参加了该项目!"; } else { ac.Activity_nowcount++; db.SaveChanges(); ActivityTeacher at = new ActivityTeacher(); at.activity_id = id; at.teacher_id = teacher; db.ActivityTeacher.Add(at); db.SaveChanges(); alert = "参与成功!"; } } } JSHelper.ShowAlert(alert); } catch { JSHelper.ShowAlert("请先登录!"); } }
private void deleteCurriculum(TblCurriculums curriculum) { foreach (TblStages stage in TeacherHelper.StagesOfCurriculum(curriculum)) { deleteStage(stage); } //remove permissions ServerModel.DB.Delete <TblPermissions>(TeacherHelper.AllPermissionsForCurriculum(curriculum)); ServerModel.DB.Delete <TblCurriculums>(curriculum.ID); }
public IList <TblCourses> GetCourses() { IList <TblCourses> result = TeacherHelper.CurrentUserCourses(FxCourseOperations.Use); if (result.Count == 0) { Message.Value = noCourses; } return(result); }
public void AddThemeButton_Click() { if (CourseTree.CheckedNodes.Count == 0) { Message.Value = noThemesSelected; return; } IdendtityNode stageNode = CurriculumTree.SelectedNode as IdendtityNode; Message.Value = alreadyHaveTheme.Replace("{0}", stageNode.Text); bool alreadyHaveSomeTheme = false; for (int i = 0; i < CourseTree.CheckedNodes.Count; i++) { IdendtityNode orgNode = CourseTree.CheckedNodes[i] as IdendtityNode; if (TeacherHelper.StageContainsTheme(stageNode.ID, orgNode.ID)) { Message.Value += orgNode.Text + ", "; alreadyHaveSomeTheme = true; } else { TblOrganizations org = ServerModel.DB.Load <TblOrganizations>(orgNode.ID); TblThemes t = new TblThemes { Name = org.Title, CourseRef = org.CourseRef, OrganizationRef = org.ID, StageRef = stageNode.ID }; ServerModel.DB.Insert(t); /*ServerModel.DB.Link( * ServerModel.DB.Load<TblStages>(stageNode.ID), * ServerModel.DB.Load<TblThemes>(t.ID));*/ stageNode.ChildNodes.Add(new IdendtityNode(ServerModel.DB.Load <TblThemes>(t.ID))); } CourseTree.CheckedNodes[i].Checked = false; i--; } if (alreadyHaveSomeTheme) { Message.Value = Message.Value.Remove(Message.Value.Length - 2) + "."; } else { Message.Value = string.Empty; } }
public void DeleteButton_Click() { foreach (TblThemes theme in TeacherHelper.ThemesOfCourse(course)) { ServerModel.DB.Delete <TblPermissions>(TeacherHelper.AllPermissionsForTheme(theme)); } ServerModel.DB.Delete <TblPermissions>(TeacherHelper.AllPermissionsForCourse(course)); CourseCleaner.DeleteCourse(course.ID); Redirect(BackUrl); }
public void Button_Sort_Click() { StatisticTable_constant.Rows.Clear(); StatisticTable_constant = TeacherHelper.Sort(StatisticTable, curriculum); StatisticTable.Rows.Clear(); for (int i = 0; i < StatisticTable_constant.Rows.Count; i++) { StatisticTable.Rows.Add(StatisticTable_constant.Rows[i]); i--; } }
private void unsignButton_Click(object sender, EventArgs e) { Button button = sender as Button; int groupID = int.Parse(button.ID.Split(unsignChar)[0]); int curriculumID = int.Parse(button.ID.Split(unsignChar)[1]); TblCurriculums curriculum = ServerModel.DB.Load <TblCurriculums>(curriculumID); TblGroups group = ServerModel.DB.Load <TblGroups>(groupID); TeacherHelper.UnSignGroupFromCurriculum(group, curriculum); buildAssignTable(); }
public void Button_FindStud_Click() { StatisticTable_constant = TeacherHelper.Search_Function(StatisticTable, Find_StudName.Value, null, curriculums, GroupID, RawUrl); StatisticTable.Rows.Clear(); for (int i = 0; i < StatisticTable_constant.Rows.Count; i++) { StatisticTable.Rows.Add(StatisticTable_constant.Rows[i]); i--; } }
protected void Page_Load(object sender, EventArgs e) { try { //判断是不是评审 if (!TeacherHelper.isJudge(Session["TeacherNumber"].ToString())) { liJudge.Visible = false; } int project_id = 5; int stage = 0; if (Request.QueryString["id"] != null && Request.QueryString["stage"] != null) { project_id = Convert.ToInt32(Request.QueryString["id"]); stage = Convert.ToInt32(Request.QueryString["stage"]); } else { Response.Redirect("main-index.aspx"); } if (Session["TeacherNumber"] == null) { Response.Redirect("main-index.aspx"); } else { this.FileUp.Attributes.Add("onchange", "javascript:return Check_FilePath();"); if (!IsPostBack) { using (var db = new TeachingCenterEntities()) { var projectinfo = (from it in db.ProjectInfo where it.project_id == project_id select it).FirstOrDefault(); txtName.Text = projectinfo.name; txtCategory.Text = projectinfo.category_name; txtDuty.Text = projectinfo.teacher_name; DateTime time = Convert.ToDateTime(projectinfo.submit_time); txtYear.Text = time.Year.ToString(); txtMonth.Text = time.Month.ToString(); txtDay.Text = time.Day.ToString(); var project = (from it in db.Project where it.project_id == project_id select it).FirstOrDefault(); txtMoney.Text = project.fund; string department = (from it in db.Teacher where it.id == project.teacher_id select it).FirstOrDefault().department; txtDepartment.Text = department; var project_stage = (from it in db.ProjectStage where it.project_id == project_id select it).FirstOrDefault(); } } } } catch { JSHelper.AlertThenRedirect("请先登录!", "main-index.aspx"); } }
private void deleteStage(TblStages stage) { foreach (TblThemes theme in TeacherHelper.ThemesOfStage(stage)) { deleteTheme(theme, stage); } //remove permissions ServerModel.DB.Delete <TblPermissions>(TeacherHelper.AllPermissionsForStage(stage)); ServerModel.DB.Delete <TblStages>(stage.ID); }