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