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("管理员和教师没有进度条");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string account = "", teaAccount = "";
int college = 0;
int state = Convert.ToInt32(Session["state"].ToString());
if (state == 1)
{
Teacher tea = (Teacher)Session["loginuser"];
account = tea.TeaAccount;
college = tea.college.ColID;
}
else if (state == 0 || state == 2)
{
Teacher admin = (Teacher)Session["user"];
account = admin.TeaAccount;
college = admin.college.ColID;
}
else if (state == 3)
{
Student stu = (Student)Session["loginuser"];
account = stu.StuAccount;
college = stu.college.ColID;
TitleRecordBll trBll = new TitleRecordBll();
bool flag = trBll.selectBystuId(account);
if (flag == true)
{
TableBuilder tbd = new TableBuilder()
{
StrTable = "V_TitleRecord",
StrColumn = "titleRecordId",
IntColType = 0,
IntOrder = 0,
StrColumnlist = "*",
IntPageSize = 1,
IntPageNum = 1,
StrWhere = "stuAccount ='" + account + "'"
};
dsTea = trBll.SelectBypage(tbd, out count);
teaAccount = dsTea.Tables[0].Rows[0]["teaAccount"].ToString();
}
}
if (!Page.IsPostBack)
{
roleId = Request.QueryString["roleId"];
if (roleId == "0")
{
strteaType = "teaType=0";
newsType = "学校公告";
}
else if (roleId == "1")
{
strteaType = "teaType=1 and teaAccount = '" + teaAccount + "'";
newsType = "学生公告";
}
else if (roleId == "2")
{
strteaType = "teaType=2 and collegeId=" + college;
newsType = "学院公告";
}
getdata(strteaType);
}
}