/// <summary>
/// 根据选题记录id获取开题报告对象
/// </summary>
/// <param name="titleRecordId"></param>
/// <returns></returns>
public OpenReport Select(int titleRecordId)
{
DataSet ds = odao.Select(titleRecordId);
OpenReport or = new OpenReport();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
int i = ds.Tables[0].Rows.Count - 1;
or.openId = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"].ToString());
or.meaning = ds.Tables[0].Rows[i]["meaning"].ToString();
or.content = ds.Tables[0].Rows[i]["openContent"].ToString();
or.method = ds.Tables[0].Rows[i]["method"].ToString();
or.outline = ds.Tables[0].Rows[i]["outline"].ToString();
or.plan = ds.Tables[0].Rows[i]["openPlan"].ToString();
or.reference = ds.Tables[0].Rows[i]["reference"].ToString();
TitleRecord titleRecord = new TitleRecord();
titleRecord.TitleRecordId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString());
or.titleRecord = titleRecord;
or.reportTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["reportTime"].ToString());
or.trend = ds.Tables[0].Rows[i]["trend"].ToString();
or.teacherOpinion = ds.Tables[0].Rows[i]["teacherOpinion"].ToString();
or.deanOpinion = ds.Tables[0].Rows[i]["deanOpinion"].ToString();
or.state = Convert.ToInt32(ds.Tables[0].Rows[i]["state"]);
return(or);
}
else
{
return(null);
}
}
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 void PrintOpenBox(Turno t)
{
OpenReport invoiceReportPOS = new OpenReport();
invoiceReportPOS.initDate(t);
// documentViewer1.DocumentSource = invoiceReportPOS; // Para Preview
// autoPrintDocument(invoiceReportPOS);
autoPrintDocument(invoiceReportPOS);
}
/// <summary>
/// 学生提交开题报告
/// </summary>
/// <param name="report">开题报告对象</param>
/// <returns>成功返回Result.添加成功，失败返回Result.添加失败</returns>
public Result stuInsert(OpenReport report)
{
int row = odao.stuInsert(report);
if (row > 0)
{
return(Result.添加成功);
}
return(Result.添加失败);
}
protected void Page_Load(object sender, EventArgs e)
{
Student student = (Student)Session["loginuser"];
string stuAccount = student.StuAccount;
TitleRecordBll titleRecordBll = new TitleRecordBll();
PathBll pathBll = new PathBll();
TitleRecord titleRecord = titleRecordBll.getRtId(stuAccount);
int titleRecordId = titleRecord.TitleRecordId;
OpenReport openReport = titleRecordBll.getState(titleRecordId);
Path path = pathBll.getState(titleRecordId, 0);
openState = openReport.state;
state = path.state;
}
protected void Page_Load(object sender, EventArgs e)
{
TitleRecordBll trbll = new TitleRecordBll();
student = (Student)Session["loginuser"];
stuAccount = student.StuAccount;
stuName = student.RealName;
profession = student.profession.ProName;
dsTR = trbll.GetByAccount(stuAccount);
if (dsTR == null)
{
opinion = "暂未选题";
}
else
{
for (int i = 0; i < dsTR.Tables[0].Rows.Count; i++)
{
string stuaccount = dsTR.Tables[0].Rows[i]["stuAccount"].ToString();
if (stuaccount == stuAccount)
{
title = dsTR.Tables[0].Rows[0]["title"].ToString();
teaName = dsTR.Tables[0].Rows[0]["teaName"].ToString();
planId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["planId"].ToString());
titleRecordId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["titleRecordId"].ToString());
break;
}
}
OpenReport openReport = trbll.getState(titleRecordId);
state = openReport.state;
or = orbll.Select(titleRecordId);
open = orbll.Select(titleRecordId);
if (open == null)
{
opinion = "教师未回复，请耐心等待";
}
else
{
opinion = open.teacherOpinion;
deanOpinion = open.deanOpinion;
}
}
Result result = orbll.isOpenReport(stuAccount, planId);
if (result == Result.记录存在)
{
insert();
}
}
/// <summary>
/// 学生提交开题报告
/// </summary>
/// <param name="openReport">开题报告实体</param>
/// <returns>返回受影响行数</returns>
public int stuInsert(OpenReport openReport)
{
try
{
string cmdText = "insert into T_OpeningReport(titleRecordId,meaning,trend,openContent,openPlan,method,outline,reference,reportTime) values(@titleRecordId, @meaning, @trend, @content, @plan, @method, @outline, @reference, @reportTime)";
string[] param = { "@titleRecordId", "@meaning", "@trend", "@content", "@plan", "@method", "@outline", "@reference", "@reportTime" };
object[] values = { openReport.titleRecord.TitleRecordId, openReport.meaning, openReport.trend, openReport.content, openReport.plan, openReport.method, openReport.outline, openReport.reference, openReport.reportTime };
int row = db.ExecuteNoneQuery(cmdText.ToString(), param, values);
return(row);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取开题报告的state
/// </summary>
/// <param name="titleRecordId">选题记录id</param>
/// <returns></returns>
public OpenReport getState(int titleRecordId)
{
string sql = "select top 1 state from T_OpeningReport where titleRecordId=@titleRecordId order by ID desc";
string[] param = { "@titleRecordId" };
object[] values = { titleRecordId };
OpenReport openReport = new OpenReport();
SqlDataReader reader = db.ExecuteReader(sql, param, values);
while (reader.Read())
{
openReport.state = reader.GetInt32(0);
}
reader.Close();
return(openReport);
}
//添加开题报告
private void insert()
{
try
{
string op = Context.Request["op"];
if (op == "add")
{
string meaning = Request["meaning"];
string trend = Request["trend"];
string content = Request["content"];
string plan = Request["plan"];
string method = Request["method"];
string outline = Request["outline"];
string reference = Request["reference"];
OpenReport open = new OpenReport();
TitleRecord titleRecord = new TitleRecord();
titleRecord.TitleRecordId = titleRecordId;
open.titleRecord = titleRecord;
open.meaning = meaning;
open.trend = trend;
open.content = content;
open.plan = plan;
open.method = method;
open.outline = outline;
open.reference = reference;
open.reportTime = DateTime.Now;
Result row = orbll.stuInsert(open);
Result result = orbll.updateState(2, titleRecordId);
if (row == Result.添加成功 && result == 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)
{
TitleRecordBll trbll = new TitleRecordBll();
OpenReportBll orbll = new OpenReportBll();
Teacher teacher = (Teacher)Session["loginuser"];
string teaAccount = teacher.TeaAccount;
DataSet ds = trbll.GetByAccount(teaAccount);
int titleRecordId = 0;
string account = Request.QueryString["stuAccount"];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string stuaccount = ds.Tables[0].Rows[i]["stuAccount"].ToString();
if (stuaccount == account)
{
stuAccount = stuaccount;
stuName = ds.Tables[0].Rows[i]["realName"].ToString();
proName = ds.Tables[0].Rows[i]["proName"].ToString();
title = ds.Tables[0].Rows[i]["title"].ToString();
titleRecordId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString());
break;
}
}
or = orbll.Select(titleRecordId);
teaName = teacher.TeaName;
string op = Request["op"];
string teacherOpinion = Request["teacherOpinion"];
string deanOpinion = Request["deanOpinion"];
try
{
if (op == "no")
{
int openId = or.openId;
Result row = orbll.teaInsert(openId, teacherOpinion);
Result state = orbll.updateState(1, titleRecordId);
if (deanOpinion != "")
{
Result dean = orbll.deanInsert(openId, teacherOpinion);
if (row == Result.添加成功 && dean == Result.添加成功)
{
LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师不同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告");
Response.Write("提交成功");
Response.End();
}
else
{
Response.Write("提交失败");
Response.End();
}
}
if (row == Result.添加成功)
{
LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师不同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告");
Response.Write("提交成功");
Response.End();
}
else
{
Response.Write("提交失败");
Response.End();
}
}
else if (op == "yes")
{
int openId = or.openId;
Result row = orbll.teaInsert(openId, teacherOpinion);
Result state = orbll.updateState(3, titleRecordId);
if (deanOpinion != "")
{
Result dean = orbll.deanInsert(openId, teacherOpinion);
if (row == Result.添加成功 && dean == Result.添加成功 && state == Result.更新成功)
{
LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告");
Response.Write("提交成功");
Response.End();
}
else
{
Response.Write("提交失败");
Response.End();
}
}
if (row == Result.添加成功 && state == Result.更新成功)
{
LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告");
Response.Write("提交成功");
Response.End();
}
else
{
Response.Write("提交失败");
Response.End();
}
}
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), ex);
}
}
