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)
{
Score scoreRatio = scoreBll.getRatio();
if (scoreRatio == null)
{
sguide = 0;
scross = 0;
sdedence = 0;
sexcellent = 0;
}
else
{
sguide = scoreRatio.guideRatio;
scross = scoreRatio.crossRatio;
sdedence = scoreRatio.defenceRatio;
sexcellent = scoreRatio.excellent;
}
string op = Request["op"];
if (op == "submit")
{
string guide = Request["guide"];
string cross = Request["cross"];
string defence = Request["defence"];
string excellent = Request["excellent"];
ScoreBll scoreBll = new ScoreBll();
Score score = new Score();
try
{
score.guideRatio = Convert.ToDouble(guide);
score.crossRatio = Convert.ToDouble(cross);
score.defenceRatio = Convert.ToDouble(defence);
score.excellent = Convert.ToInt32(excellent);
Result row = scoreBll.updateRatio(score);
if (row == Result.更新成功)
{
Teacher teacher = (Teacher)Session["user"];
LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 更新成绩占比信息");
Response.Write("更新成功");
Response.End();
}
else
{
Response.Write("更新失败");
Response.End();
}
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), ex);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtSum.Text != "")
{
Score score = new Score();
score.PaperID = ScoreBll.GetPaperID(lblPaper.Text);
score.ExamTime = Convert.ToDateTime(lblTime.Text);
score.JudgeTime = DateTime.Now;
score.Score0 = Convert.ToDouble(txtSum.Text);
score.UserID = UserID;
ScoreBll.ScoreAdd(score);
MessageBox.Show("保存成功！");
this.Close();
}
else
{
MessageBox.Show("请计算总分！");
}
}
public void insert()
{
string txtAreReportContent = Request["ReportContent"];
string txtAreReportTime = Request["ReportTime"];
string txtAreDefence = Request["Defence"];
string txtAreInnovate = Request["Innovate"];
double txtAreDefenceScore = double.Parse(Request["DefenceScore"]);
string txtAreEvaluate = Request["txtAreEvaluate"];
Plan plan = new Plan();
try
{
StudentBll studentBll = new StudentBll();
Student stu = studentBll.GetModel(stuAccount);
plan.PlanId = planId;
scoreModel.student = stu;
scoreModel.plan = plan;
scoreModel.reportContent = txtAreReportContent;
scoreModel.reportTime = txtAreReportTime;
scoreModel.defence = txtAreDefence;
scoreModel.defenInnovate = txtAreInnovate;
scoreModel.defenceScore = txtAreDefenceScore;
scoreModel.defenEvaluate = txtAreEvaluate;
ScoreBll scorebll = new ScoreBll();
Result row = scorebll.updatereplyPanelsOpinion(scoreModel);
if (row == Result.添加成功)
{
Teacher teacher = (Teacher)Session["loginuser"];
LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师添加 - " + stu.StuAccount + " - " + stu.RealName + " - 学生的答辩成绩及评定");
Response.Write("提交成功");
Response.End();
}
else
{
Response.Write("提交失败");
Response.End();
}
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), ex);
}
}
public void insert()
{
double score = Convert.ToDouble(Request["score"]);
string material = Request["material"];
string paperDesign = Request["quality"];
string workload = Request["workload"];
string innovate = Request["innovate"];
string evaluate = Request["evaluate"];
StudentBll stuBll = new StudentBll();
Student student = stuBll.GetModel(Session["stuAccount"].ToString());
ScoreBll sbll = new ScoreBll();
Score scoreModel = new Score();
try
{
scoreModel.material = material;
scoreModel.paperDesign = paperDesign;
scoreModel.workload = workload;
scoreModel.crossInnovate = innovate;
scoreModel.crossEvaluate = evaluate;
scoreModel.crossScore = score;
scoreModel.student = student;
Plan plan = new Plan();
plan.PlanId = Convert.ToInt32(Session["planId"]);
scoreModel.plan = plan;
Result row = sbll.updateCrossGuide(scoreModel);
if (row == Result.添加成功)
{
LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师对 - " + student.StuAccount + " - " + student.RealName + " - 学生的交叉指导意见");
Response.Write("提交成功");
Response.End();
}
else
{
Response.Write("提交失败");
Response.End();
}
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), ex);
}
}
private void tsbtnDel_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentCell != null)
{
if (MessageBox.Show("是否删除记录？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
try
{
ScoreBll.ScoreDel(dataGridView1.CurrentRow.Cells[2].Value.ToString());
MessageBox.Show("删除成功");
dataGridView1.DataSource = ScoreBll.ScoreFillDs("").Tables[0];
getcolumn();
}
catch (Exception ee)
{
MessageBox.Show("删除失败！" + ee);
throw;
}
}
}
}
private void btnSerch_Click(object sender, EventArgs e)
{
if (txtSerch.Text == "")
{
MessageBox.Show("请输入查询内容！");
}
else
{
if (cboSerch.SelectedText == "请选择查询条件")
{
MessageBox.Show("请选择查询条件！");
}
else if (cboSerch.SelectedText == "考试时间")
{
dataGridView1.DataSource = ScoreBll.UserScoreFillDs(txtSerch.Text, "ExamTime", UserID).Tables[0];
}
else if (cboSerch.SelectedText == "试卷名称")
{
dataGridView1.DataSource = ScoreBll.UserScoreFillDs(txtSerch.Text, "PaperID", UserID).Tables[0];
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
TitleRecordBll trbll = new TitleRecordBll();
ScoreBll sbll = new ScoreBll();
Student student = (Student)Session["loginuser"];
stuAccount = student.StuAccount;
stuName = student.RealName;
proName = student.profession.ProName;
DataSet dsTR = trbll.GetByAccount(stuAccount);
if (dsTR == null)
{
content = "暂未选题";
}
else
{
int planId = 0;
for (int i = 0; i < dsTR.Tables[0].Rows.Count; i++)
{
string stuaccount = dsTR.Tables[0].Rows[i]["stuAccount"].ToString();
if (stuaccount == stuAccount)
{
titleRecordId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["titleRecordId"].ToString());
title = dsTR.Tables[0].Rows[0]["title"].ToString();
planId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["planId"].ToString());
break;
}
}
Score _score = sbll.getState(titleRecordId.ToString());
state = _score.state;
if (state == 0 || state == 1 || state == 2)
{
content = "暂无成绩";
}
else
{
//获取成绩
DataSet ds = sbll.Select(stuAccount, planId);
int openState = Convert.ToInt32(ds.Tables[0].Rows[0]["openState"].ToString());
if (openState == 0)
{
Response.Write("成绩还未开放查询，请耐心等待");
Response.End();
}
else
{
double guideScore = 0, crossScore = 0, defenceScore = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string remarks = ds.Tables[0].Rows[i]["remarks"].ToString();
if (remarks == "指导成绩")
{
guideScore = Convert.ToDouble(ds.Tables[0].Rows[i]["score"].ToString());
}
else if (remarks == "交叉评阅")
{
crossScore = Convert.ToDouble(ds.Tables[0].Rows[i]["score"].ToString());
}
else if (remarks == "答辩成绩")
{
defenceScore = Convert.ToDouble(ds.Tables[0].Rows[i]["score"].ToString());
}
}
score = guideScore * 0.4 + crossScore * 0.3 + defenceScore * 0.3;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string op = Request["op"];
ScoreBll scoreBll = new ScoreBll();
TeacherBll teacherBll = new TeacherBll();
PlanBll planBll = new PlanBll();
Teacher teacher = new Teacher();
College college = new College();
Score score = new Score();
Teacher tea = (Teacher)Session["user"];
int collegeId = tea.college.ColID;
string startTime = DateTime.Now.ToString("yyyy-MM");
Plan plan = planBll.getPlanId(collegeId, startTime + "%");
int planId = plan.PlanId;
try
{
if (op == "open")
{
int state = 1;
teacher.state = 0;
college.ColID = collegeId;
teacher.college = college;
Result result = scoreBll.openScore(state, planId);
Result row = teacherBll.updateState(teacher);
if (result == Result.更新成功 && row == Result.更新成功)
{
LogHelper.Info(this.GetType(), tea.TeaAccount + " - " + tea.TeaName + " - 开放查看成绩");
Response.Write("成绩已开放");
Response.End();
}
else
{
Response.Write("成绩开放失败，可能当前批次没有可开放成绩");
Response.End();
}
}
else if (op == "close")
{
int state = 0;
Result result = scoreBll.openScore(state, planId);
if (result == Result.更新成功)
{
LogHelper.Info(this.GetType(), tea.TeaAccount + " - " + tea.TeaName + " - 关闭查看成绩");
Response.Write("成绩已关闭查询");
Response.End();
}
else
{
Response.Write("关闭查询失败，可能当前批次没有可开放成绩");
Response.End();
}
}
else
{
int openState = 1;
Result result = scoreBll.selectSate(openState, planId);
//按钮开关
if (result == Result.记录存在)
{
status = 1;//开
}
else
{
status = 0;//关
}
}
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), ex);
}
}
private void tsbtnSerch_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = ScoreBll.ScoreFillDs(tscboPaper.ComboBox.SelectedValue.ToString()).Tables[0];
getcolumn();
}
private void frmScoreManage_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = ScoreBll.ScoreFillDs("").Tables[0];
getcolumn();
PaperBll.FillcboPaper(tscboPaper.ComboBox);
}
