protected void Page_Load(object sender, EventArgs e)
{
studentID = 0;
if (GetAdminInfo_CCOM().Role_id == 3)
{
studentID = GetAdminInfo_CCOM().User_id;
}
else
{
studentID = long.Parse(DESEncrypt.Decrypt(MyRequest.GetQueryString("studentID")));
}
this.MyUserID.Text = studentID.ToString();
if (!Page.IsPostBack)
{
if (studentID == 0)
{
JscriptMsg("传输参数不正确！", "back", "Error");
return;
}
string ht = "";
Model.CCOM.Topic_relation model = new Model.CCOM.Topic_relation();
model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + studentID + "and Accept_state=1");
if (model == null)
{
ht = " <div class=\"content\" align=\"center\"><h3>您尚无选题<h3></div>";
this.print_div.InnerHtml = ht;
}
else
{
AddSubmitButton();
ShowInfo();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserID = 0;
UserID = GetAdminInfo_CCOM().User_id;
if (!Page.IsPostBack)
{
if (UserID == 0)
{
JscriptMsg("传输参数不正确！", "back", "Error");
return;
}
string ht = "";
Model.CCOM.Topic_relation model = new Model.CCOM.Topic_relation();
model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + GetAdminInfo_CCOM().User_id + "and Accept_state=1");
if (model == null)
{
ht = " <div class=\"content\" align=\"center\"><h3>您尚无选题<h3><table class=\"table table-striped table-bordered dataTable\"></table></div>";
this.print_div.InnerHtml = ht;
btnSubmit.Visible = false;
//JscriptMsg("您尚无选题！", "back", "Error");
//return;
}
else
{
ShowInfo();
}
}
}
protected void btnSubmit_Error(object sender, EventArgs e)
{
BLL.CCOM.Topic_relation bll = new BLL.CCOM.Topic_relation();
for (int i = 0; i < topicrelation.Length; i++)
{
try
{
Model.CCOM.Topic_relation model = bll.GetModel(" Topic_relation_id=" + topicrelation[i]);
if (model != null)
{
model.Accept_state = 2;
if (bll.Update(model))
{
BLL.CCOM.Topic topic_bll = new BLL.CCOM.Topic();
Model.CCOM.Topic topic_model = topic_bll.GetModel(model.Topic_id);
topic_model.Selected_state = false;
topic_bll.Update(topic_model);
JscriptMsg("审核成功啦！", "TeacherChoose.aspx?fun_id=" + get_fun_id("CCOM/TopicManage/TeacherChoose.aspx"), "Success");
}
else
{
JscriptMsg("审核失败", "TeacherChoose.aspx?fun_id=" + get_fun_id("CCOM/TopicManage/TeacherChoose.aspx"), "Success");
}
}
}
catch
{
continue;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
relationID = 0;
studentID = 0;
if (GetAdminInfo_CCOM().Role_id == 3)
{
studentID = GetAdminInfo_CCOM().User_id;
this.btnSubmit.Visible = false;
}
else
{
studentID = long.Parse(DESEncrypt.Decrypt(MyRequest.GetQueryString("studentID")));
}
string ht = "";
Model.CCOM.Topic_relation model = new Model.CCOM.Topic_relation();
model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + studentID + "and Accept_state=1");
if (model != null)
{
relationID = model.Topic_relation_id;
}
if (!Page.IsPostBack)
{
if (studentID == 0)
{
JscriptMsg("传输参数不正确！", "back", "Error");
return;
}
//if(GetAdminInfo_CCOM().Role_id != 3)
//{
// JscriptMsg("只有学生用户才可以提交材料！", "back", "Error");
// return;
//}
if (model == null)
{
ht = " <div class=\"content\" align=\"center\"><h3>该学生尚无选题<h3><table class=\"table table-striped table-bordered dataTable\"></table></div>";
this.print_div.InnerHtml = ht;
}
else
{
ShowInfo();
}
}
}
public void Bind_Data()
{
BLL.CCOM.Teach_week week_bll = new BLL.CCOM.Teach_week();
List <university.Model.CCOM.Teach_week> week_models = week_bll.GetModelList("");
string ht = "";
foreach (university.Model.CCOM.Teach_week week_model in week_models)
{
if (week_model != null)
{
ht += "<li id=\"section-1\" class=\"mainTab\">";
ht += "<hr style=\"height:10px;border:none;border-top:10px groove skyblue;\" />";
ht += "<div class=\"content\">";
ht += "<div class=\"span4\">";
ht += "<h3 class=\"sectionname\"><span>" + GetDateString(week_model.Start_time) + " - " + GetDateString(week_model.End_time) + "</span></h3><hr /></div>";
ht += "<div class=\"span6\" style=\"padding:22px 0;\">";
ht += "</div><ul class=\"span12\">";
BLL.CCOM.Homework work_bll = new BLL.CCOM.Homework();
List <university.Model.CCOM.Homework> work_models = work_bll.GetModelList(" Week_id=" + week_model.TeachWeek_id);
foreach (university.Model.CCOM.Homework work_model in work_models)
{
if (work_model.DatumType_id == 2)//如果类型是提交开题报告
{
ht += "<li class=\"fileTab\"><div><div class=\"mod-indent-outer\"><div class=\"mod-indent\"></div><div><div class=\"activityinstance\">";
ht += "<a href=\"StudentSubmit.aspx?homeworkId=" + work_model.Homework_id + "&fun_id=<%=DESEncrypt.Encrypt(\"15\") %><img src=\"/images/sendfile.png\"/> 提交" + (new BLL.CCOM.Datum_type().GetModel(work_model.DatumType_id).DatumType_name) + "</a>";
ht += "</div></div></div></div></li>";
}
else
{
ht += "<li class=\"fileTab\"><div><div class=\"mod-indent-outer\"><div class=\"mod-indent\"></div><div><div class=\"activityinstance\">";
ht += "<a href=\"StudentSubmit.aspx?homeworkId=" + work_model.Homework_id + "&fun_id=<%=DESEncrypt.Encrypt(\"15\") %><img src=\"/images/sendfile.png\"/> 提交" + (new BLL.CCOM.Datum_type().GetModel(work_model.DatumType_id).DatumType_name) + "</a>";
ht += "</div></div></div></div></li>";
}
}
ht += "</ul></div></li>";
}
}
Model.CCOM.Topic_relation model = new Model.CCOM.Topic_relation();
model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + GetAdminInfo_CCOM().User_id + "and Accept_state=1");
if (model == null)
{
ht = " <div class=\"content\" align=\"center\"><h3>您尚无选题<h3></div>";
}
this.week_list.InnerHtml = ht;
}
protected string ImportDataItem(DataSet ds, ref int success, ref int error)//基础数据
{
string result = "";
BLL.CCOM.User_information stu_bll = new BLL.CCOM.User_information();
Model.CCOM.User_information stu_model = new Model.CCOM.User_information();
BLL.CCOM.Topic topic_bll = new BLL.CCOM.Topic();
Model.CCOM.Topic topic_model = new Model.CCOM.Topic();
BLL.CCOM.Topic_relation rela_bll = new BLL.CCOM.Topic_relation();
Model.CCOM.Topic_relation rela_model = new Model.CCOM.Topic_relation();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string checkmsg = null;
#region 添加学生信息==========================
//学号
string number = ds.Tables[0].Rows[i]["学号"].ToString().Trim();
if (!ValidDFValue(number, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，学号" + checkmsg + "<br/>";
error++;
continue;
}
else if (stu_bll.GetModel(" User_number='" + number + "'") != null)
{
stu_model = stu_bll.GetModel(" User_number='" + number + "'");
}
else if (number != "")
{
stu_model.User_number = number;
}
//姓名
string name = ds.Tables[0].Rows[i]["姓名"].ToString().Trim();
if (!ValidDFValue(name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，姓名" + checkmsg + "<br/>";
error++;
continue;
}
else if (name != "")
{
stu_model.User_realname = name;
}
//性别
//string gender = ds.Tables[0].Rows[i]["性别"].ToString().Trim();
//if (!ValidDFValue(gender, true, "男|女", ref checkmsg))
//{
// result += "×第" + (i + 1).ToString() + "行数据更新失败，性别" + checkmsg + "<br/>";
// error++;
// continue;
//}
//else if (gender == "男")
//{
// stu_model.User_gender = false;
//}
//else if (gender == "女")
//{
// stu_model.User_gender = true;
//}
//机构
stu_model.User_gender = false;
string angency = ds.Tables[0].Rows[i]["行政班"].ToString().Trim();
if (!ValidDFValue(angency, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，所在班号" + checkmsg + "<br/>";
error++;
continue;
}
BLL.CCOM.Agency agency_bll = new BLL.CCOM.Agency();
Model.CCOM.Agency agency_model = new Model.CCOM.Agency();
agency_model = agency_bll.GetModel(" Agency_name='" + angency + "'");
if (agency_model == null)
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，所在班号不存在<br/>";
error++;
continue;
}
stu_model.Agency_id = agency_model.Agency_id;
stu_model.Role_id = 3;
stu_model.User_password = DESEncrypt.MD5Encrypt(number);
if (stu_bll.GetModel(" User_number='" + number + "'") == null)
{
stu_model.User_id = stu_bll.Add(stu_model);
if (stu_model.User_id == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information();
Model.CCOM.User_information user_model = user_bll.GetModel("User_number='" + number + "'");
BLL.CCOM.Student student_bll = new BLL.CCOM.Student();
Model.CCOM.Student student_model = new Model.CCOM.Student();
student_model.User_id = user_model.User_id;
student_model.Period_id = 4;
student_bll.Add(student_model);
}
}
else
{
if (!stu_bll.Update(stu_model))
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
}
#endregion
#region 更新导师信息==========================
var tea_model = new Model.CCOM.Tutor();
//姓名
string tea_name = ds.Tables[0].Rows[i]["指导教师"].ToString().Trim();
if (!ValidDFValue(tea_name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，指导教师" + checkmsg + "<br/>";
error++;
continue;
}
else if (tea_name != "")
{
var tea_user_model = new BLL.CCOM.User_information().GetModel(" User_realname='" + tea_name + "'");
if (tea_user_model == null)
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，指导教师" + tea_name + "不存在<br/>";
error++;
continue;
}
tea_model = new BLL.CCOM.Tutor().GetModel(" User_id=" + tea_user_model.User_id);
string title_name = ds.Tables[0].Rows[i]["职称"].ToString().Trim();
if (!ValidDFValue(title_name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，职称" + checkmsg + "<br/>";
error++;
continue;
}
else if (title_name != "")
{
var title_model = new BLL.CCOM.Title().GetModel(" Title_name='" + title_name + "'");
if (title_model == null)
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，职称" + title_name + "不存在<br/>";
error++;
continue;
}
tea_model.Title_id = title_model.Title_id;
if (!new BLL.CCOM.Tutor().Update(tea_model))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，更新导师信息失败<br/>";
error++;
continue;
}
}
}
#endregion
#region 导入选题信息==========================
string topic_name = ds.Tables[0].Rows[i]["毕业设计题目"].ToString().Trim();
if (!ValidDFValue(topic_name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目名称" + checkmsg + "<br/>";
error++;
continue;
}
else if (topic_name != "")
{
topic_model.Topic_name = topic_name;
}
string Topic_nature = ds.Tables[0].Rows[i]["题目性质"].ToString().Trim();
if (!ValidDFValue(Topic_nature, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目性质" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_nature != "")
{
topic_model.Topic_nature = Topic_nature;
}
string Topic_source = ds.Tables[0].Rows[i]["题目来源"].ToString().Trim();
if (!ValidDFValue(Topic_source, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目来源" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_source != "")
{
topic_model.Topic_source = Topic_source;
}
string Topic_content = ds.Tables[0].Rows[i]["题目详情"].ToString().Trim();
if (!ValidDFValue(Topic_content, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目详情" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_content != "")
{
topic_model.Topic_content = Topic_content;
}
string Topic_task = ds.Tables[0].Rows[i]["任务书"].ToString().Trim();
if (!ValidDFValue(Topic_task, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，任务书" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_task != "")
{
topic_model.Topic_task = Topic_task;
}
topic_model.Selected_state = true;
topic_model.Check_state = 1;
topic_model.Teacher_id = tea_model.User_id;
topic_model.Company = "软件学院";
topic_model.Topic_id = topic_bll.Add(topic_model);
if (topic_model.Topic_id == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
#endregion
#region 题对应关系信息==========================
if (rela_bll.GetModel(" Student_id=" + stu_model.User_id) != null && rela_bll.GetModel(" Student_id=" + stu_model.User_id).Accept_state != 2)
{
result += "×第" + (i + 1).ToString() + "行学生选题对应关系更新异常，该学生已经在系统有选题记录！<br/>";
error++;
continue;
}
rela_model.Student_id = stu_model.User_id;
rela_model.Teacher_id = tea_model.User_id;
rela_model.Topic_id = topic_model.Topic_id;
rela_model.Accept_state = 1;
rela_model.Apply_time = DateTime.Now;
rela_model.Topic_relation_id = rela_bll.Add(rela_model);
if (rela_model.Topic_relation_id == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
#endregion
}
return(result);
}
protected string UpdateTopicState()
{
JsonData data = new JsonData();
string id = MyRequest.GetString("ID");
string myid = MyRequest.GetString("MYID");
string msg = "";
try
{
var bll = new BLL.CCOM.Topic();
var m = bll.GetModel("Topic_id=" + id);
Boolean isOn = m.Selected_state == true;
m.Selected_state = isOn ^ true;
Model.CCOM.Topic_relation rela_model;
rela_model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + myid);
if (rela_model == null)
{
rela_model = new Model.CCOM.Topic_relation();
rela_model.Student_id = Int64.Parse(myid);
rela_model.Teacher_id = m.Teacher_id;
rela_model.Topic_id = m.Topic_id;
rela_model.Apply_time = DateTime.Now;
rela_model.Accept_state = 0;
long rela_id = (new BLL.CCOM.Topic_relation()).Add(rela_model);
if (rela_id != 0)
{
if (bll.Update(m) == false)
{
new BLL.CCOM.Topic_relation().Delete(rela_id);
msg = "修改发生异常！";
}
}
else
{
msg = "选题发生异常！";
}
}
else
{
Model.CCOM.Topic last_model = new BLL.CCOM.Topic().GetModel(rela_model.Topic_id);
last_model.Selected_state = false;
bll.Update(last_model);
rela_model.Student_id = Int64.Parse(myid);
rela_model.Teacher_id = m.Teacher_id;
rela_model.Topic_id = m.Topic_id;
rela_model.Apply_time = DateTime.Now;
rela_model.Accept_state = 0;
if (new BLL.CCOM.Topic_relation().Update(rela_model))
{
if (bll.Update(m) == false)
{
new BLL.CCOM.Topic_relation().Delete(rela_model.Topic_relation_id);
msg = "修改发生异常！";
}
}
else
{
msg = "选题发生异常！";
}
}
}
catch
{
msg = "修改发生异常！";
}
if (msg == "")
{
data["msg"] = "修改成功";
data["code"] = 1;
}
else
{
data["msg"] = msg;
data["code"] = 0;
}
return(data.ToJson());
}
