public void getData() { PathBll pathBll = new PathBll(); MedtermQualityBll mqBll = new MedtermQualityBll(); ScoreBll scoreBll = new ScoreBll(); GuideRecordBll guideBll = new GuideRecordBll(); CrossBll crossBll = new CrossBll(); DefenceBll dfBll = new DefenceBll(); state = Session["state"].ToString(); if (state == "3") { student = (Student)Session["loginuser"]; stuNO = student.StuAccount; recordResult = Record.selectBystuId(stuNO); if (recordResult) { ds = Record.GetByAccount(stuNO); title = ds.Tables[0].Rows[0]["title"].ToString(); //获取标题 planId = ds.Tables[0].Rows[0]["planId"].ToString(); //获取批次ID Plan plan = planBll.Select(int.Parse(planId)); //获取批次信息 startTime = plan.StartTime; //批次开始时间 endTime = plan.EndTime; //批次结束时间 string dsTime = ds.Tables[0].Rows[0]["createTime"].ToString(); selectTime = Convert.ToDateTime(dsTime); //学生选定题目时间 //获取选题记录ID来取得学生开题报告的信息 titleRecordId = ds.Tables[0].Rows[0]["titleRecordId"].ToString(); if (opBll.selectByRecordId(int.Parse(titleRecordId)) == true) { opReport = opBll.Select(int.Parse(titleRecordId)); opTime = opReport.reportTime; teacherOpenning = opReport.teacherOpinion; pathRe = pathBll.selectByTitleRecordId(titleRecordId); if (pathRe == Result.记录存在) { Path pathRecordId = pathBll.getTitleRecordId(stuNO); TitleRecord tr = pathRecordId.titleRecord; pathds = pathBll.getModel(tr.TitleRecordId, stuNO); //遍历路径信息(type为0时) checkReport = pathBll.getCheckReport(tr.TitleRecordId); //查重 mq = mqBll.Select(tr.TitleRecordId); //遍历中期质量报告 scoreDs = scoreBll.Select(stuNO, int.Parse(planId)); //获取学生成绩 crossGuideDs = crossBll.Select(tr.TitleRecordId); //遍历交叉指导信息 corssDs = crossBll.SelectByStu(stuNO); defenceDs = dfBll.getModel(tr.TitleRecordId.ToString()); //遍历答辩记录信息 } } } //else //{ // Response.Write("你还没有选题,请先进行选题"); //} } else { Response.Write("管理员和教师没有进度条"); } }
public Result updateState(MedtermQuality medterm) { int row = mdao.updateState(medterm); if (row > 0) { return(Result.更新成功); } return(Result.更新失败); }
/// <summary> /// 督导处、指导小组提交评阅中期质量意见 /// </summary> /// <param name="medterm">中期质量报告对象</param> /// <returns>成功返回Result.添加成功,失败返回Result.添加失败</returns> public Result superInsert(MedtermQuality medterm) { int row = mdao.superInsert(medterm); if (row > 0) { return(Result.添加成功); } return(Result.添加失败); }
/// <summary> /// 督导处给出中期质量报告评语意见 /// </summary> /// <param name="medterm">中期质量报告实体</param> /// <returns>受影响行数</returns> public int superInsert(MedtermQuality medterm) { try { string cmdText = "insert into T_MedtermQuality(titleRecordId,supervisionOpinion,guideGroupOpinion,dateTime) values(@titleRecordId,@supervisionOpinion,@guideGroupOpinion,@dateTime)"; string[] param = { "@titleRecordId", "@supervisionOpinion,", "@guideGroupOpinion", "@dateTime" }; object[] values = { medterm.titleRecord.TitleRecordId, medterm.supervisionOpinion, medterm.guideGroupOpinion, medterm.dateTime }; int row = db.ExecuteNoneQuery(cmdText.ToString(), param, values); return(row); } catch (Exception ex) { throw ex; } }
/// <summary> /// 教师给出中期质量报告评语意见 /// </summary> /// <param name="medterm">中期质量报告实体</param> /// <returns>受影响行数</returns> public int teaInsert(MedtermQuality medterm) { try { string cmdText = "update T_MedtermQuality set teacherOpinion = @teacherOpinion,dateTime= @dateTime,state=@state where titleRecordId=@titleRecordId"; string[] param = { "@titleRecordId", "@teacherOpinion", "@dateTime", "@state" }; object[] values = { medterm.titleRecord.TitleRecordId, medterm.teacherOpinion, medterm.dateTime, medterm.state }; int row = db.ExecuteNoneQuery(cmdText.ToString(), param, values); return(row); } catch (Exception ex) { throw ex; } }
/// <summary> /// 学生提交中期质量报告 /// </summary> /// <param name="medterm">中期质量报告实体</param> /// <returns>受影响行数</returns> public int stuInsert(MedtermQuality medterm) { try { string cmdText = "insert into T_MedtermQuality(titleRecordId,planFinishSituation,dateTime,state) values(@titleRecordId,@planFinishSituation,@dateTime,@state)"; string[] param = { "@titleRecordId", "@planFinishSituation", "@dateTime", "@state" }; object[] values = { medterm.titleRecord.TitleRecordId, medterm.planFinishSituation, medterm.dateTime, medterm.state }; int row = db.ExecuteNoneQuery(cmdText.ToString(), param, values); return(row); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新state /// </summary> /// <param name="path"></param> /// <returns></returns> public int updateState(MedtermQuality medtermQuality) { try { string cmdText = "UPDATE T_MedtermQuality SET state = @state WHERE midId IN(SELECT TOP 1 midId FROM T_MedtermQuality WHERE titleRecordId = @titleRecordId ORDER BY midId DESC)"; string[] param = { "@state", "@titleRecordId" }; object[] values = { medtermQuality.state, medtermQuality.titleRecord.TitleRecordId }; int row = db.ExecuteNoneQuery(cmdText.ToString(), param, values); return(row); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据选题记录id获取中期检查对象 /// </summary> /// <param name="titleRecordId"></param> /// <returns></returns> public MedtermQuality Select(int titleRecordId) { DataSet ds = mdao.Select(titleRecordId); MedtermQuality or = new MedtermQuality(); if (ds != null && ds.Tables[0].Rows.Count > 0) { int i = ds.Tables[0].Rows.Count - 1; or.planFinishSituation = ds.Tables[0].Rows[i]["planFinishSituation"].ToString(); or.teacherOpinion = ds.Tables[0].Rows[i]["teacherOpinion"].ToString(); or.supervisionOpinion = ds.Tables[0].Rows[i]["supervisionOpinion"].ToString(); or.guideGroupOpinion = ds.Tables[0].Rows[i]["guideGroupOpinion"].ToString(); or.dateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["dateTime"].ToString()); or.state = Convert.ToInt32(ds.Tables[0].Rows[i]["state"].ToString()); return(or); } else { return(null); } }
/// <summary> /// 获取中期质量完成状态state /// </summary> /// <param name="titleRecordId">选题记录id</param> /// <returns></returns> public MedtermQuality getState(int titleRecordId) { string sql = "select top 1 state from T_MedtermQuality where titleRecordId=@titleRecordId order by midId desc"; string[] param = { "@titleRecordId" }; object[] values = { titleRecordId }; MedtermQuality medtermQuality = new MedtermQuality(); SqlDataReader reader = db.ExecuteReader(sql, param, values); while (reader.Read()) { if (reader.GetInt32(0) == 0) { medtermQuality = null; } else { medtermQuality.state = reader.GetInt32(0); } } reader.Close(); return(medtermQuality); }
protected void Page_Load(object sender, EventArgs e) { TitleRecordBll trbll = new TitleRecordBll(); MedtermQualityBll mqbll = new MedtermQualityBll(); MedtermQuality medterm = new MedtermQuality(); state = Convert.ToInt32(Session["state"].ToString()); int titleRecordId = 0; string op = Request["op"]; if (!IsPostBack) { string stuAccount = Request.QueryString["stuAccount"]; if (stuAccount != null) { Session["stuAccount"] = stuAccount; } else { if (state == 3) { Student student = (Student)Session["loginuser"]; stuAccount = student.StuAccount; } else { stuAccount = Session["stuAccount"].ToString(); } } } if (state == 1) { Teacher teacher = (Teacher)Session["loginuser"]; string teaAccount = teacher.TeaAccount; string acount = Session["stuAccount"].ToString(); TitleRecord titleRecord = trbll.getRtIdByTea(acount, teaAccount); TitleRecord stuTitle = trbll.GetTitleRecord(titleRecord.TitleRecordId); mq = mqbll.Select(titleRecord.TitleRecordId); if (mq == null) { content = "学生未提交中期质量检查"; } else { planFinishSituation = mq.planFinishSituation; stuAccount = acount; stuName = stuTitle.student.RealName; proName = stuTitle.profession.ProName; title = stuTitle.title.title; collegeName = teacher.college.ColName; teaName = teacher.TeaName; MedtermQuality medtermQuality = mqbll.getState(titleRecord.TitleRecordId); mstate = medtermQuality.state; if (mstate == 3) { teacherOpinion = mq.teacherOpinion; } } if (op == "teacher") { try { string opinion = Request["teacher"]; medterm.teacherOpinion = opinion; medterm.dateTime = DateTime.Now; medterm.titleRecord = titleRecord; medterm.state = 3; Result row = mqbll.teaInsert(medterm); if (row == Result.添加成功) { LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师提交 - " + stuTitle.student.StuAccount + " - " + stuTitle.student.RealName + " - 学生的中期质量报告意见"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } catch (Exception ex) { LogHelper.Error(this.GetType(), ex); } } } else if (state == 3) { try { Student student = (Student)Session["loginuser"]; stuAccount = student.StuAccount; stuName = student.RealName; proName = student.profession.ProName; collegeName = student.college.ColName; DataSet ds = trbll.GetByAccount(stuAccount); TitleRecordBll titleRecordBll = new TitleRecordBll(); TitleRecord titleRecord = titleRecordBll.getRtId(stuAccount); int rtId = titleRecord.TitleRecordId; Result result = pathBll.selectByTitleRecordId(rtId.ToString()); if (ds == null) { content = "暂未选题"; } else { if (result == Result.记录存在) { mq = mqbll.Select(titleRecord.TitleRecordId); if (mq != null) { planFinishSituation = mq.planFinishSituation; } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string stuaccount = ds.Tables[0].Rows[i]["stuAccount"].ToString(); if (stuaccount == stuAccount) { title = ds.Tables[0].Rows[0]["title"].ToString(); teaName = ds.Tables[0].Rows[0]["teaName"].ToString(); titleRecordId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString()); break; } } MedtermQuality medtermQuality = mqbll.getState(titleRecordId); mstate = medtermQuality.state; if (mstate == 3) { teacherOpinion = mq.teacherOpinion; } } else { content = "暂未提交论文"; } } if (op == "student") { string plan = Request["student"]; medterm.planFinishSituation = plan; medterm.dateTime = DateTime.Now; titleRecord.TitleRecordId = titleRecordId; medterm.titleRecord = titleRecord; medterm.state = 2; Result row = mqbll.stuInsert(medterm); if (row == Result.添加成功) { LogHelper.Info(this.GetType(), student.StuAccount + " - " + student.RealName + " - 学生提交中期质量报告"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } } catch (Exception ex) { LogHelper.Error(this.GetType(), ex); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { stuAccount = Request.QueryString["stuAccount"]; titleRecordId = Convert.ToInt32(Request.QueryString["titleRecordId"]); if (stuAccount != null) { Session["stuAccount"] = stuAccount; Session["titleRecordId"] = titleRecordId; } else { stuAccount = Session["stuAccount"].ToString(); titleRecordId = Convert.ToInt32(Session["titleRecordId"].ToString()); } } //获取查重报告状态 Path path = pathBll.getState(titleRecordId, 1); if (path == null) { checkState = 0; } else { checkState = path.state; } //获取中期质量报告状态 MedtermQualityBll qualityBll = new MedtermQualityBll(); MedtermQuality medterm = qualityBll.getState(titleRecordId); if (medterm == null) { midState = 0; } else { midState = medterm.state; } //获取论文完成状态 Path pathPaper = pathBll.getState(titleRecordId, 0); if (pathPaper == null) { paperState = 0; } else { paperState = pathPaper.state; } getData = titlebll.GetByAccount(stuAccount); int i = getData.Tables[0].Rows.Count - 1; planId = Convert.ToInt32(getData.Tables[0].Rows[i]["planId"]); int proId = Convert.ToInt32(getData.Tables[0].Rows[i]["proId"]); teacher = (Teacher)Session["loginuser"]; TeacherBll teaBll = new TeacherBll(); int a = teacher.college.ColID; dsTitle = teaBll.getByColl(teacher.college.ColID, teacher.TeaAccount); string op = Request["op"]; if (op == "submit") { insert(); } }