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