//初始化试卷表格
protected void InitData()
{
Papermr paper = new Papermr();
DataSet ds = paper.QueryUserPaperList();
GridView1.DataSource = ds;
GridView1.DataBind();
LabelPageInfo.Text = "当前（第" + (GridView1.PageIndex + 1).ToString() + "页 共" + GridView1.PageCount.ToString() + "页）";
}
protected void InitData()
{
Papermr paper = new Papermr();
DataSet ds = paper.QueryAllPaper();
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
lblMessage.Text = "没有试卷!";
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string UserID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值1
int PaperID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[1].ToString().Trim()); //取出要删除记录的主键值2
Papermr paper = new Papermr();
if (paper.DeleteByProc(UserID, PaperID))
{
Response.Write("<script language=javascript>alert('成功删除！')</script>");
}
else
{
Response.Write("<script language=javascript>alert('删除失败！')</script>");
}
InitData();
}
//GridView控件RowDeleting事件
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Papermr paper = new Papermr(); //创建Papermr对象
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
if (paper.DeleteByStr(ID))
{
Response.Write("<script language=javascript>alert('成功删除该试卷！')</script>");
}
else
{
Response.Write("<script language=javascript>alert('删除试卷失败！')</script>");
}
//InitData();
Response.Redirect("PaperLists.aspx");
}
//初始化考试科目下拉列表框
protected void InitData()
{
Papermr paper = new Papermr(); //创建Papermr对象
DataSet ds = paper.QueryPaper(); //查询所有可用试卷
if (ds.Tables[0].Rows.Count >= 1)
{
ddlPaper.DataSource = ds; //指名考试科目列表框数据源
ddlPaper.DataTextField = "PaperName"; //DataTextField显示Name字段值
ddlPaper.DataValueField = "PaperID"; //DataValueField显示ID字段值
ddlPaper.DataBind(); //绑定数据
}
else
{
ddlPaper.Enabled = false;
ImgStartExam.Enabled = false;
lblMessage.Text = "没有试卷！";
}
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
Scoresmr insertExamScore = new Scoresmr(); //创建Scoresmr类对象
insertExamScore.UserID = Request.QueryString["UserID"].ToString();
insertExamScore.ExamTime = Convert.ToDateTime(lblExamtime.Text);
insertExamScore.PaperID = int.Parse(Request.QueryString["PaperID"].ToString());
if (queScore.Text.Trim() != "")
{
insertExamScore.Score = Convert.ToInt32(sumScore.Text);
}
insertExamScore.PingYu = tbxPingyu.Text;
//实例化公共类Papermr
Papermr mypaper = new Papermr();
mypaper.UserID = Request.QueryString["UserID"].ToString();
mypaper.PaperID = int.Parse(Request.QueryString["PaperID"].ToString());
mypaper.state = "已评阅";
//使用CheckScore方法验证成绩是否存在
if (!insertExamScore.CheckScore(insertExamScore.UserID, insertExamScore.PaperID))
{
//调用InsertByProc方法向数据库中插入成绩
if (insertExamScore.InsertByProc())
{
mypaper.UpdateByProc(mypaper.UserID, mypaper.PaperID, mypaper.state);
//给出成功提示信息
lblMessage.Text = "考生成绩保存成功!";
}
else
{
lblMessage.Text = "考生成绩保存失败!";
}
}
else
{
lblMessage.Text = "该用户的成绩已存在,请先删除成绩再评阅!";
}
}
//GridView控件RowUpdating事件
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//取出要删除记录的主键值
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
//创建Papermr对象
Papermr paper = new Papermr();
//应用FindControl查找GridView控件中的DropDownList，并将其列表中的值转换成byte类型赋予公共类Papermr中的PaperState试卷状态变量
paper.PaperState = byte.Parse(((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlPaperState")).SelectedValue);
//使用Papermr类UpdateByProc方法修改试卷状态
if (paper.UpdateByStr(ID))
{
Response.Write("<script language=javascript>alert('试卷状态修改成功!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('试卷状态修改失败!')</script>");
}
//取消编辑操作
GridView1.EditIndex = -1;
//调用自定义方法InitData()重新绑定GridView控件中信息
InitData();
}
