protected void Page_Load(object sender, EventArgs e)
{
this.fun_id = get_fun_id("CCOM/ScoreManage/StudentList.aspx");
this.apply_id = long.Parse(DESEncrypt.Decrypt(MyRequest.GetQueryString("groupid")));
if (this.apply_id == 0)
{
JscriptMsg("传输参数不正确！", "back", "Error");
return;
}
Model.CCOM.Reply_group model = new BLL.CCOM.Reply_group().GetModel(apply_id);
if (model.Group_type == 0)
{
PageTitle = "口头答辩打分";
}
else if (model.Group_type == 1)
{
PageTitle = "软件验收打分";
}
else if (model.Group_type == 2)
{
PageTitle = "开题评审打分";
}
if (!Page.IsPostBack)
{
ShowApplyTitle();
RptBind(" User_id desc ");
}
}
//#region 组合SQL查询语句==========================
//protected string CombSqlTxt()
//{
// int flag = 0;
// int i = 0;
// var model = GetAdminInfo_CCOM();
// StringBuilder strTemp = new StringBuilder();
// BLL.CCOM.Reply_student rs_bll = new BLL.CCOM.Reply_student();
// BLL.CCOM.Reply_commission rc_bll = new BLL.CCOM.Reply_commission();
// BLL.CCOM.Reply_group rg_bll = new BLL.CCOM.Reply_group();
// strTemp.Append("(");
// //学生
// DataSet ds = rs_bll.GetList("User_id=" + model.User_id);
// //if (ds.Tables[0].Rows.Count > 0)
// //{
// // flag = 1;
// // strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
// // for ( i = 1; i < ds.Tables[0].Rows.Count; i++)
// // {
// // strTemp.Append(","+ds.Tables[0].Rows[i]["Group_id"]);
// // }
// //}
// //组长
// ds = rg_bll.GetList("User_id=" + model.User_id);
// if (ds.Tables[0].Rows.Count > 0)
// {
// if (flag == 0)
// {
// flag = 1;
// strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
// i = 1;
// }
// else
// i = 0;
// for (; i < ds.Tables[0].Rows.Count; i++)
// {
// strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
// }
// }
// //组员
// //ds = rc_bll.GetList("User_id=" + model.User_id);
// //if (ds.Tables[0].Rows.Count > 0)
// //{
// // if (flag == 0)
// // {
// // flag = 1;
// // strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
// // i = 1;
// // }
// // else
// // i = 0;
// // for (; i < ds.Tables[0].Rows.Count; i++)
// // {
// // strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
// // }
// //}
// //if (flag == 0)
// // strTemp.Append("-1");
// //strTemp.Append(")");
// return strTemp.ToString();
//}
//#endregion
#region 数据绑定=================================
private void RptBind(string _strWhere, string _order)
{
BLL.CCOM.Reply_group bll = new BLL.CCOM.Reply_group();
int pageSize = GetPageSize(15);//每页数量
int page = MyRequest.GetQueryInt("page", 1);
string keywords = MyRequest.GetQueryString("keywords");
int start_index = pageSize * (page - 1) + 1;
this.st_index = pageSize * (page - 1) + 1;
int end_index = pageSize * page;
if (_strWhere != "")
{
_strWhere = "Group_id in" + _strWhere;
}
//计算数量
int totalCount = bll.GetRecordCount(_strWhere);
//绑定当页
this.rptList.DataSource = bll.GetListByPage(_strWhere, _order, start_index, end_index);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("MyExamList.aspx", "fun_id={0}&keywords={1}&sort={2}&page={3}", this.fun_id, this.keywords, MyRequest.GetString("sort"), "__id__");
this.PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8, true);
}
//删除
protected void lbtSingleDelete_Click(object sender, EventArgs e)
{
BLL.CCOM.Reply_group bll = new BLL.CCOM.Reply_group();
var lbtn = sender as LinkButton;
if (lbtn != null)
{
var id = Int32.Parse(DESEncrypt.Decrypt(lbtn.ToolTip.ToString()));
bool result = true;
try
{
result = bll.Delete(id);
}
catch
{
result = false;
}
string keywords = this.keywords;
int page = MyRequest.GetQueryInt("page", 1);
if (result == true)
{
JscriptMsg("删除成功！", Utils.CombUrlTxt("ExamList.aspx", "fun_id={0}&keywords={1}&sort={2}&page={3}",
this.fun_id, this.keywords, MyRequest.GetString("sort"), "__id__"), "Success");
}
else
{
JscriptMsg("删除失败！", Utils.CombUrlTxt("ExamList.aspx", "fun_id={0}&keywords={1}&sort={2}&page={3}",
this.fun_id, this.keywords, MyRequest.GetString("sort"), "__id__"), "Error");
}
}
}
private void ShowApplyTitle()
{
var m = new BLL.CCOM.Reply_group().GetModel((int)this.apply_id);
title.HRef = "ExamList.aspx?fun_id=" + MyRequest.GetQueryString("fun_id");
this.lblTitle.Text += m.Group_name;
}
protected string CombSqlTxt(string _keywords)
{
StringBuilder strTemp = new StringBuilder();
//if (GetSonUOList(apply_id) != "") strTemp.Append(" Agency_id in (" + GetSonUOList(apply_id) + ")");
//else strTemp.Append(" Agency_id = 0");
//BLL.CCOM.Period per_bll = new BLL.CCOM.Period();
//Model.CCOM.Period per_model = per_bll.GetModel(" Period_state=1");
//if (per_model != null) strTemp.Append(" and Period_id='" + per_model.Period_id + "'");
//else strTemp.Append(" and Period_id='0'");
BLL.CCOM.Reply_group per_bll = new BLL.CCOM.Reply_group();
Model.CCOM.Reply_group per_model = per_bll.GetModel("Group_id=" + apply_id);
strTemp.Append(" Role_id != 3 and Role_id != 1 and Role_id != 4 and User_id !=" + per_model.User_id);//非学生，教学干事，系统管理员，组长
_keywords = _keywords.Replace("'", "");
if (!string.IsNullOrEmpty(_keywords))
{
strTemp.Append(" and (");
strTemp.Append(" User_realname like '%" + _keywords + "%' ");
strTemp.Append(" or User_number like '%" + _keywords + "%' ");
strTemp.Append(" or Agency_name like '%" + _keywords + "%' ");
strTemp.Append(")");
}
return(strTemp.ToString());
}
//保存
protected void btn_Submit_Click(object sender, EventArgs e)
{
var student_models = new BLL.CCOM.User_information().GetModelList(" Role_id=3");
foreach (var student_model in student_models)
{
if (!new BLL.CCOM.User_information().Delete(student_model.User_id))
{
JscriptMsg("删除学生：" + student_model.User_realname + "时，发生异常！", "", "Error");
return;
}
}
var topic_models = new BLL.CCOM.Topic().GetModelList("");
foreach (var topic_model in topic_models)
{
if (!new BLL.CCOM.Topic().Delete(topic_model.Topic_id))
{
JscriptMsg("删除选题：" + topic_model.Topic_name + "时，发生异常！", "", "Error");
return;
}
}
var teachweek_models = new BLL.CCOM.Teach_week().GetModelList("");
foreach (var teachweek_model in teachweek_models)
{
if (!new BLL.CCOM.Teach_week().Delete(teachweek_model.TeachWeek_id))
{
JscriptMsg("删除异常！", "", "Error");
return;
}
}
var reply_models = new BLL.CCOM.Reply_group().GetModelList("");
foreach (var reply_model in reply_models)
{
if (!new BLL.CCOM.Reply_group().Delete(reply_model.Group_id))
{
JscriptMsg("删除答辩组：" + reply_model.Group_name + "时，发生异常！", "", "Error");
return;
}
}
var user_models = new BLL.CCOM.User_information().GetModelList(" Role_id!=1");
foreach (var student_model in user_models)
{
if (!new BLL.CCOM.User_information().Delete(student_model.User_id))
{
JscriptMsg("删除用户：" + student_model.User_realname + "时，发生异常！", "", "Error");
return;
}
}
JscriptMsg("初始化成功！", "InitSystem.aspx?fun_id=" + DESEncrypt.Encrypt(this.fun_id), "Success");
}
protected void bindTitleInfo()
{
//Model.CCOM.Examination_arrangement exam_model = new BLL.CCOM.Examination_arrangement().GetModel(Group_id);
//Model.CCOM.Examination_room room_model = new BLL.CCOM.Examination_room().GetModel(exam_model.Ea_room);
//Model.CCOM.Examination_subject subject_model = new BLL.CCOM.Examination_subject().GetModel(" Ea_id='" + exam_model.Ea_id + "'");
//string year = "";
//if (subject_model != null)
//{
// Model.CCOM.Subject s_model = new BLL.CCOM.Subject().GetModel(subject_model.Esn_id);
// year = new BLL.CCOM.Period().GetModel(s_model.Period_id).Period_year;
//}
//if (year == "") year = Utils.ObjectToStr(DateTime.Now.Year);
//this.lbltime.Text = Convert.ToDateTime(exam_model.Ea_starttime).ToString("MM月dd日 HH:mm");
//this.lblplace.Text = room_model.Er_building + room_model.Er_floor + "层" + room_model.Er_room;
Model.CCOM.Reply_group rg_model = new BLL.CCOM.Reply_group().GetModel(Group_id);
this.lbltime.Text = rg_model.Reply_time.ToString("yyyy年MM月dd日 HH:mm");
this.lblplace.Text = rg_model.Reply_room;
this.lbltitle.Text = rg_model.Group_name;
if (rg_model.Group_type == 0)
{
page_title = "2017软件学院毕业设计答辩安排";
this.lbltype.Text = "口头答辩";
}
else if (rg_model.Group_type == 1)
{
page_title = "2017软件学院毕业设计软件验收安排";
this.lbltype.Text = "软件验收";
}
else if (rg_model.Group_type == 2)
{
page_title = "2017软件学院开题评审答辩安排";
this.lbltype.Text = "开题评审";
}
//绑定答辩委员会
var group_model = new BLL.CCOM.Reply_group().GetModel(" Group_id=" + Group_id);
var leader_model = new BLL.CCOM.View_User().GetModel(" User_id=" + group_model.User_id);
reviewTr1 = "<tr><td style=\"text-align:center\">" + leader_model.User_realname + "</td><td style=\"text-align:center\">" + leader_model.Role_name + "</td><td style=\"text-align:center\">主席</td></tr>";
var rcs = new BLL.CCOM.Reply_commission().GetModelList(" Group_id=" + Group_id);
foreach (var rc in rcs)
{
var u_model = new BLL.CCOM.View_User().GetModel(" User_id=" + rc.User_id);
reviewTr1 += "<tr><td style=\"text-align:center\">" + u_model.User_realname + "</td><td style=\"text-align:center\">" + u_model.Role_name + "</td><td style=\"text-align:center\">成员</td></tr>";
}
//绑定学生
var rss = new BLL.CCOM.Reply_student().GetModelList("Group_id=" + Group_id + " order by User_id");
BLL.CCOM.View_Selete_Topic user_bll = new BLL.CCOM.View_Selete_Topic();
foreach (var rs in rss)
{
var s_model = new BLL.CCOM.View_Selete_Topic().GetModel(" Student_id=" + rs.User_id);
reviewTr2 += "<tr><td style=\"text-align:center\">" + s_model.Student_name + "</td><td style=\"text-align:center\">" + s_model.User_number + "</td><td style=\"text-align:center\">" + s_model.Teacher_name + "</td><td style=\"text-align:center\">" + s_model.Topic_name + "</td></tr>";
}
}
public void ShowInfo()
{
// Model.CCOM.View_User user_model = new BLL.CCOM.View_User().GetModel(" User_id=" + UserID);
var group_model = new BLL.CCOM.Reply_group().GetModel(" Group_id=" + Group_id);
var leader_model = new BLL.CCOM.View_User().GetModel(" User_id=" + group_model.User_id);
long Topic_relation_id = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + UserID).Topic_relation_id;
var comment_model = new BLL.CCOM.Comment().GetModel(" Topic_relation_id=" + Topic_relation_id);
// PageTitle = user_model.User_realname + "的答辩评语表";
this.txtTeacherComment.Disabled = true;
this.txtTeacherScore.Disabled = true;
string score = "--";
if (comment_model != null)
{
score = comment_model.Reply_score.ToString();
}
reviewTr = "<tr><td class=\"firstTab\">" + leader_model.User_realname + "</td><td class=\"otherTab\">" + GetTitle(leader_model.User_id) + "</td><td class=\"otherTab\">主席</td><td class=\"otherTab\">" + score + "</td></tr>";
var rcs = new BLL.CCOM.Reply_commission().GetModelList(" Group_id=" + Group_id);
foreach (var rc in rcs)
{
var u_model = new BLL.CCOM.View_User().GetModel(" User_id=" + rc.User_id);
var mark_table_model = new BLL.CCOM.View_Mark_table().GetModel(" Teacher_id=" + rc.User_id + " and Student_id=" + UserID);
score = "--";
if (mark_table_model != null)
{
score = mark_table_model.Score.ToString();
}
reviewTr += "<tr><td class=\"firstTab\">" + u_model.User_realname + "</td><td class=\"otherTab\">" + GetTitle(u_model.User_id) + "</td><td class=\"otherTab\">成员</td><td class=\"otherTab\">" + score + "</td></tr>";
}
if (comment_model != null)
{
this.txtTeacherComment.InnerText = comment_model.Teacher_comment;
this.txtTeacherScore.Value = comment_model.Teacher_score.ToString();
this.txtProblem.InnerText = comment_model.problem;
this.txtReviewComment.InnerText = comment_model.Comment_content;
this.txtScore.Value = comment_model.Reply_score.ToString();
}
if (GetAdminInfo_CCOM().User_id != leader_model.User_id)
{
var mark_table_model = new BLL.CCOM.View_Mark_table().GetModel(" Teacher_id=" + GetAdminInfo_CCOM().User_id + "and student_id=" + UserID);
score = "";
if (mark_table_model != null)
{
score = mark_table_model.Score.ToString();
}
this.txtScore.Value = score;
this.txtProblem.Disabled = true;
this.txtReviewComment.Disabled = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.fun_id = MyRequest.GetQueryString("fun_id");
if (!Page.IsPostBack)
{
var model = GetAdminInfo_CCOM();
BLL.CCOM.Reply_group rg_bll = new BLL.CCOM.Reply_group();
BLL.CCOM.Reply_commission rc_bll = new BLL.CCOM.Reply_commission();
List <Model.CCOM.Reply_group> modellist1 = rg_bll.GetModelList("User_id=" + model.User_id);
List <Model.CCOM.Reply_commission> modellist2 = rc_bll.GetModelList("User_id=" + model.User_id);
if (modellist1.Count == 0 && modellist2.Count == 0)
{
string ht = "";
ht = " <div class=\"content\" align=\"center\"><h3>您尚无权限<h3><table class=\"table table-striped table-bordered dataTable\"></table></div>";
this.print_div.InnerHtml = ht;
}
else
{
string _order = MyRequest.GetString("sort").Replace(",", " ");
if (_order == "" || Tools.CheckParams(_order))
{
_order = " Group_id asc";
}
StringBuilder strTemp = new StringBuilder();
strTemp.Append("(");
string res = "";
foreach (Model.CCOM.Reply_group rg_model in modellist1)
{
res += rg_model.Group_id + ",";
}
foreach (Model.CCOM.Reply_commission rg_model in modellist2)
{
res += rg_model.Group_id + ",";
}
if (res != "")
{
strTemp.Append(Utils.DelLastComma(res) + ")");
}
else
{
strTemp.Append("0)");
}
RptBind(strTemp.ToString(), _order);
}
}
}
protected void InitView()
{
Model.CCOM.Reply_group model = new BLL.CCOM.Reply_group().GetModel(Group_id);
if (model != null)
{
try
{
BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information();
Model.CCOM.User_information user_model = new Model.CCOM.User_information();
this.txtGroupName.Text = model.Group_name;
this.txtReplyTime.Value = model.Reply_time.ToString("yyyy-MM-dd HH:mm:ss");
this.txtReplyRoom.Text = model.Reply_room;
user_model = user_bll.GetModel(model.User_id);
this.txtTeaNumber.Text = user_model.User_number;
this.ddltype.SelectedValue = model.Group_type.ToString();
}
catch { }
}
}
protected String GetHref()
{
Model.CCOM.Reply_group model = new BLL.CCOM.Reply_group().GetModel(apply_id);
if (model.Group_type == 1)
{
return("SoftwareScore");
}
else if (model.Group_type == 0)
{
return("CommentScore");
}
else if (model.Group_type == 2)//需要添加开题评审页面
{
return("ProposalReview");
}
else
{
return("");
}
}
protected String GetStudentStatus(long userId, long Group_id)
{
Model.CCOM.Reply_group model = new BLL.CCOM.Reply_group().GetModel(Group_id);
try
{
if (model.Group_type == 0)
{ //口头答辩
var group_model = new BLL.CCOM.Reply_group().GetModel(" Group_id=" + Group_id);
if (GetAdminInfo_CCOM().User_id != group_model.User_id) //组员
{
var mark_table_model = new BLL.CCOM.View_Mark_table().GetModel(" Teacher_id=" + GetAdminInfo_CCOM().User_id);
if (mark_table_model != null)
{
return("<b style=\"color: green;\">已评分</b>");
}
else
{
return("<b style=\"color: red;\">未评分</b>");
}
}
else
{
long Topic_relation_id = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + userId).Topic_relation_id;
var comment_model = new BLL.CCOM.Comment().GetModel(" Topic_relation_id=" + Topic_relation_id);
if (comment_model != null && comment_model.Reply_score != null)
{
return("<b style=\"color: green;\">已评分</b>");
}
else
{
return("<b style=\"color: red;\">未评分</b>");
}
}
}
else if (model.Group_type == 1) //软件验收
{
long Topic_relation_id = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + userId).Topic_relation_id;
var software_model = new BLL.CCOM.Software_accept().GetModel(" Topic_relation_id=" + Topic_relation_id);
if (software_model != null && software_model.Conclusion != null)
{
return("<b style=\"color: green;\">已评分</b>");
}
else
{
return("<b style=\"color: red;\">未评分</b>");
}
}
else if (model.Group_type == 2) //开题评审
{
long Topic_relation_id = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + userId).Topic_relation_id;
var proposal_model = new BLL.CCOM.Proposal().GetModel(" Topic_relation_id=" + Topic_relation_id);
if (proposal_model != null && proposal_model.Result > 0)
{
if (proposal_model.Result == 1)
{
return("<b style=\"color: green;\">已通过</b>");
}
else if (proposal_model.Result == 2)
{
return("<b style=\"color: red;\">未通过</b>");
}
else
{
return("");
}
}
else
{
return("<b>未审核</b>");
}
}
else
{
return("");
}
}
catch {
return("--");
}
}
private void ShowApplyTitle()
{
var m = new BLL.CCOM.Reply_group().GetModel((int)this.apply_id);
this.lblTitle.Text += m.Group_name;
}
private string DoAction()
{
string result = "";
BLL.CCOM.Reply_group bll = new BLL.CCOM.Reply_group();
Model.CCOM.Reply_group model;
if (action != MyEnums.ActionEnum.Edit.ToString())
{
model = new Model.CCOM.Reply_group();
}
else
{
model = bll.GetModel(Group_id);
}
string GroupName = this.txtGroupName.Text.Trim();
string TeaNumber = this.txtTeaNumber.Text.Trim();
// string Time = this.txtReplyTime.Text.Trim();
string Room = this.txtReplyRoom.Text.Trim();
string Goup_type = this.ddltype.SelectedValue;
//必填部分
if (Tools.CheckParams(GroupName + TeaNumber + Room))
{
return("请勿输入非法字符");
}
if (GroupName == "")
{
return("请填答辩组名称");
}
if (TeaNumber == "")
{
return("请填组长工号");
}
if (this.txtReplyTime.Value == "")
{
return("请填写答辩时间");
}
if (Room == "")
{
return("请填写答辩地点");
}
if (Goup_type == "#")
{
return("请选择答辩类型");
}
else if (Goup_type == "0")
{
model.Group_type = 0;
}
else if (Goup_type == "1")
{
model.Group_type = 1;
}
else if (Goup_type == "2")
{
model.Group_type = 2;
}
model.Group_name = GroupName;
model.Reply_time = Convert.ToDateTime(this.txtReplyTime.Value);;
model.Reply_room = Room;
BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information();
Model.CCOM.User_information uset_model;
uset_model = user_bll.GetModel("User_number='" + TeaNumber + "'and Role_id!=3");
if (uset_model == null)
{
return("该教师用户不存在");
}
else
{
model.User_id = uset_model.User_id;
}
try
{
if (action == MyEnums.ActionEnum.Edit.ToString()) //修改
{
bll.Update(model);
}
else
{
bll.Add(model);
}
}
catch (Exception ex)
{
result = action == MyEnums.ActionEnum.Edit.ToString() ? "修改失败" : "添加失败" + ex.Message.ToString();
}
return(result);
}
private string DoAction()
{
var group_model = new BLL.CCOM.Reply_group().GetModel(" Group_id=" + Group_id);
//var leader_model = new BLL.CCOM.View_User().GetModel(" User_id=" + group_model.User_id);
string score = this.txtScore.Value;
if (GetAdminInfo_CCOM().User_id != group_model.User_id)
{
if (score == "")
{
return("请添加给定的成绩");
}
int sc = int.Parse(score);
var student_model = new BLL.CCOM.Reply_student().GetModel(" Group_id=" + Group_id + "and User_id=" + UserID);
var comment_model = new BLL.CCOM.Reply_commission().GetModel(" Group_id=" + Group_id + "and User_id=" + GetAdminInfo_CCOM().User_id);
var mark_model = new BLL.CCOM.Mark_table().GetModel(" Rs_id=" + student_model.Rs_id + " and Rc_id=" + comment_model.Rc_id);
if (mark_model != null)
{
mark_model.Score = sc;
mark_model.Mark_date = DateTime.Now;
if (!new BLL.CCOM.Mark_table().Update(mark_model))
{
return("更新成绩异常");
}
}
else
{
Model.CCOM.Mark_table mk_model = new Model.CCOM.Mark_table();
mk_model.Rc_id = comment_model.Rc_id;
mk_model.Rs_id = student_model.Rs_id;
mk_model.Score = sc;
mk_model.Mark_date = DateTime.Now;
if (new BLL.CCOM.Mark_table().Add(mk_model) == 0)
{
return("添加成绩异常");
}
}
}
else
{
string problem = this.txtProblem.InnerText;
string comment = this.txtReviewComment.InnerText;
if (problem == "")
{
return("请添加答辩中提出的主要问题及回答的简要情况");
}
if (comment == "")
{
return("请添加答辩委员会（小组）的评语");
}
if (score == "")
{
return("请添加给定的成绩");
}
int sc = int.Parse(score);
long Topic_relation_id = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + UserID).Topic_relation_id;
var comment_model = new BLL.CCOM.Comment().GetModel(" Topic_relation_id=" + Topic_relation_id);
if (comment_model != null)
{
comment_model.problem = problem;
comment_model.Comment_content = comment;
comment_model.Reply_score = sc;
if (!new BLL.CCOM.Comment().Update(comment_model))
{
return("更新评语异常");
}
}
else
{
Model.CCOM.Comment com_model = new Model.CCOM.Comment();
com_model.problem = problem;
com_model.Comment_content = comment;
com_model.Reply_score = sc;
com_model.Topic_relation_id = Topic_relation_id;
if (new BLL.CCOM.Comment().Add(com_model) == 0)
{
return("添加评语异常");
}
}
}
return("");
}
public void ShowInfo()
{
Model.CCOM.View_User user_model = new BLL.CCOM.View_User().GetModel(" User_id=" + UserID);
long Group_id = GetGroupId(UserID);
if (Group_id == 0)
{
this.print_div.InnerHtml = " <div class=\"content\" align=\"center\"><h3>您尚未被分配到任何软件验收组<h3><table class=\"table table-striped table-bordered dataTable\"></table></div>";;
btnSubmit.Visible = false;
return;
}
var group_model = new BLL.CCOM.Reply_group().GetModel(" Group_id=" + Group_id);
var leader_model = new BLL.CCOM.View_User().GetModel(" User_id=" + group_model.User_id);
PageTitle = user_model.User_realname + "的软件验收表";
this.txtRunStatus.Disabled = true;
this.txtFeature.Disabled = true;
this.txtScore.Disabled = true;
this.lblName.InnerText = user_model.User_realname;
this.lblNumber.InnerHtml = user_model.User_number;
var relation_model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + UserID);
if (relation_model != null)
{
this.lblTeacher.InnerText = new BLL.CCOM.User_information().GetModel(relation_model.Teacher_id).User_realname;
this.lblTitle.InnerText = new BLL.CCOM.Topic().GetModel(relation_model.Topic_id).Topic_name;
}
else
{
return;
}
string leader_title = "--";
var leader_tutor_model = new BLL.CCOM.Tutor().GetModel(" User_id=" + leader_model.User_id);
if (leader_tutor_model != null)
{
if (leader_tutor_model.Title_id != null)
{
leader_title = new BLL.CCOM.Title().GetModel((int)leader_tutor_model.Title_id).Title_name;
}
else
{
leader_title = "--";
}
}
reviewTr = "<tr><td style=\"text-align:center;\">组长</td><td style=\"text-align:center;\">" + leader_model.User_realname + "</td><td style=\"text-align:center;\">" + leader_title + "</td><td colspan=\"3\" style=\"text-align:center;\">" + leader_model.Agency_name + "</td></tr>";
var rcs = new BLL.CCOM.Reply_commission().GetModelList(" Group_id=" + Group_id);
foreach (var rc in rcs)
{
var u_model = new BLL.CCOM.View_User().GetModel(" User_id=" + rc.User_id);
string title = "--";
var tutor_model = new BLL.CCOM.Tutor().GetModel(" User_id=" + rc.User_id);
if (tutor_model != null)
{
if (tutor_model.Title_id != null)
{
title = new BLL.CCOM.Title().GetModel((int)tutor_model.Title_id).Title_name;
}
else
{
title = "--";
}
}
reviewTr += "</tr><td style=\"text-align:center;\">组员</td><td style=\"text-align:center;\">" + u_model.User_realname + "</td><td style=\"text-align:center;\">" + title + "</td><td colspan=\"3\" style=\"text-align:center;\">" + u_model.Agency_name + "</td></tr>";
}
var software_model = new BLL.CCOM.Software_accept().GetModel(" Topic_relation_id=" + relation_model.Topic_relation_id);
if (software_model != null)
{
if (software_model.Time != null)
{
this.lblTime.InnerText = software_model.Time.Value.ToString("yyyy年MM月dd日 HH:mm:ss");
}
this.txtDataList.InnerText = software_model.Data_list;
this.txtAnguage.InnerText = software_model.anguage;
this.txtEnvironmental.InnerText = software_model.Environmental;
this.txtLineCount.InnerText = software_model.Line_count;
this.txtLineHand.InnerText = software_model.Line_hand;
this.txtRunStatus.InnerText = software_model.Run_status;
this.txtFeature.InnerText = software_model.Feature;
this.txtScore.Value = software_model.Conclusion.ToString();
}
}
protected string CombSqlTxt()
{
int flag = 0;
int i = 0;
var model = GetAdminInfo_CCOM();
StringBuilder strTemp = new StringBuilder();
BLL.CCOM.Reply_student rs_bll = new BLL.CCOM.Reply_student();
BLL.CCOM.Reply_commission rc_bll = new BLL.CCOM.Reply_commission();
BLL.CCOM.Reply_group rg_bll = new BLL.CCOM.Reply_group();
strTemp.Append("(");
//学生
DataSet ds = rs_bll.GetList("User_id=" + model.User_id);
if (ds.Tables[0].Rows.Count > 0)
{
flag = 1;
strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
for (i = 1; i < ds.Tables[0].Rows.Count; i++)
{
strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
}
}
//组长
ds = rg_bll.GetList("User_id=" + model.User_id);
if (ds.Tables[0].Rows.Count > 0)
{
if (flag == 0)
{
flag = 1;
strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
i = 1;
}
else
{
i = 0;
}
for (; i < ds.Tables[0].Rows.Count; i++)
{
strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
}
}
//组员
ds = rc_bll.GetList("User_id=" + model.User_id);
if (ds.Tables[0].Rows.Count > 0)
{
if (flag == 0)
{
flag = 1;
strTemp.Append(ds.Tables[0].Rows[0]["Group_id"]);
i = 1;
}
else
{
i = 0;
}
for (; i < ds.Tables[0].Rows.Count; i++)
{
strTemp.Append("," + ds.Tables[0].Rows[i]["Group_id"]);
}
}
if (flag == 0)
{
strTemp.Append("-1");
}
strTemp.Append(")");
return(strTemp.ToString());
}
public void ShowInfo()
{
Model.CCOM.View_User user_model = new BLL.CCOM.View_User().GetModel(" User_id=" + UserID);
var group_model = new BLL.CCOM.Reply_group().GetModel(" Group_id=" + Group_id);
var leader_model = new BLL.CCOM.View_User().GetModel(" User_id=" + group_model.User_id);
if (GetAdminInfo_CCOM().User_id != leader_model.User_id)
{
this.txtOpinion.Disabled = true;
this.ddlresult.Enabled = false;
this.btnSubmit.Visible = false;
}
this.lblName.InnerText = user_model.User_realname;
this.lblNumber.InnerHtml = user_model.User_number;
var relation_model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + UserID);
if (relation_model != null)
{
this.lblTeacher.InnerText = new BLL.CCOM.User_information().GetModel(relation_model.Teacher_id).User_realname;
var topic_model = new BLL.CCOM.Topic().GetModel(relation_model.Topic_id);
this.lblTitle.InnerText = topic_model.Topic_name;
this.lblNature.InnerText = topic_model.Topic_nature;
this.lblSource.InnerText = topic_model.Topic_source;
}
else
{
return;
}
string leader_title = "--";
var leader_tutor_model = new BLL.CCOM.Tutor().GetModel(" User_id=" + leader_model.User_id);
if (leader_tutor_model != null)
{
if (leader_tutor_model.Title_id != null)
{
leader_title = new BLL.CCOM.Title().GetModel((int)leader_tutor_model.Title_id).Title_name;
}
else
{
leader_title = "--";
}
}
reviewTr = "<tr><td style=\"text-align:center;\">组长</td><td style=\"text-align:center;\">" + leader_model.User_realname + "</td><td style=\"text-align:center;\">" + leader_title + "</td><td colspan=\"3\" style=\"text-align:center;\">" + leader_model.Agency_name + "</td></tr>";
var rcs = new BLL.CCOM.Reply_commission().GetModelList(" Group_id=" + Group_id);
foreach (var rc in rcs)
{
var u_model = new BLL.CCOM.View_User().GetModel(" User_id=" + rc.User_id);
string title = "--";
var tutor_model = new BLL.CCOM.Tutor().GetModel(" User_id=" + rc.User_id);
if (tutor_model != null)
{
if (tutor_model.Title_id != null)
{
title = new BLL.CCOM.Title().GetModel((int)tutor_model.Title_id).Title_name;
}
else
{
title = "--";
}
}
reviewTr += "</tr><td style=\"text-align:center;\">组员</td><td style=\"text-align:center;\">" + u_model.User_realname + "</td><td style=\"text-align:center;\">" + title + "</td><td colspan=\"3\" style=\"text-align:center;\">" + u_model.Agency_name + "</td></tr>";
}
var proposal_model = new BLL.CCOM.Proposal().GetModel(" Topic_relation_id=" + relation_model.Topic_relation_id);
if (proposal_model != null)
{
this.txtOpinion.InnerText = proposal_model.Review;
this.ddlresult.SelectedValue = proposal_model.Result.ToString();
}
}
protected string AddStudent()
{
JsonData data = new JsonData();
string Group_id = MyRequest.GetString("GroupID");
string User_id = MyRequest.GetString("StudentID");
string msg = "";
if (Tools.CheckParams(Group_id + User_id))
{
msg = "传输异常，存在非法字符！";
}
else
{
try
{
long userid = long.Parse(User_id);
long groupid = long.Parse(Group_id);
//判断学生是否已经选题
var topic_model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + userid + " and Accept_state=1");
if (topic_model == null)
{
msg = "该同学尚未选择毕设题目！";
}
BLL.CCOM.Reply_student bll = new BLL.CCOM.Reply_student();
Model.CCOM.Reply_student model = bll.GetModel(" Group_id=" + groupid + " and User_id=" + userid);
if (msg == "")
{
if (model != null)
{
msg = "学生已在该答辩组中";
}
else
{
bool isIn = true;
var student_models = new BLL.CCOM.Reply_student().GetModelList(" User_id=" + User_id);
var group_model = new BLL.CCOM.Reply_group().GetModel(long.Parse(Group_id));
Model.CCOM.Reply_group other_model = null;;
foreach (Model.CCOM.Reply_student student_model in student_models)
{
if (new BLL.CCOM.Reply_group().GetModel(student_model.Group_id).Group_type.Equals(group_model.Group_type))
{
isIn = false;
other_model = new BLL.CCOM.Reply_group().GetModel(student_model.Group_id);
break;
}
}
if (isIn)
{
model = new Model.CCOM.Reply_student();
model.Group_id = groupid;
model.User_id = userid;
if (bll.Add(model) <= 0)
{
msg = "添加失败";
}
}
else
{
string name = new BLL.CCOM.User_information().GetModel(userid).User_realname;
msg = "学生" + name + "已在" + other_model.Group_name + "答辩组中";
}
}
}
}
catch (Exception)
{
msg = "添加发生异常！";
}
}
if (msg == "")
{
data["msg"] = "添加成功";
data["code"] = 1;
}
else
{
data["msg"] = msg;
data["code"] = 0;
}
return(data.ToJson());
}