protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
string zuoyeid = GridView1.SelectedValue.ToString();
string studentusername = Request.QueryString["studentusername"];
DataTable dt = StudentInfo.GetStuZuoyeTimu(int.Parse(zuoyeid), studentusername);
GridView2.DataSource = dt;
GridView2.DataBind();
}
protected void xianshiTimu()//在PlaceHolder1中显示题目
{
int zuoyeid = int.Parse(Request.QueryString["zuoyeid"]);
string stuusername = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
DataTable timutable = StudentInfo.GetStuZuoyeTimu(zuoyeid, stuusername);
Literal tihaoliteral; //显示题号
Literal templiteral;
RadioButtonList danxuanrbl; //显示单项选择
RadioButtonList panduanrbl; //判断
CheckBoxList duoxuancbl; //多选
TextBox tikongtbx; //填空
FileUpload caozuofuld; //文件上传
Button btn_uploadfile; //上传文件按钮
RequiredFieldValidator filevalidator;
if (timutable.Rows.Count > 0)
{
int tihao = 1;
#region 显示题目
foreach (DataRow timurow in timutable.Rows)
{
tihaoliteral = new Literal();
tihaoliteral.Text = tihao.ToString() + "(" + timurow[2].ToString() + "," + timurow[7].ToString() + "分)、" + timurow[3].ToString() + "<br/>";
PlaceHolder1.Controls.Add(tihaoliteral);
switch (timurow[2].ToString().Trim())
{
case "单项选择题":
danxuanrbl = new RadioButtonList();
danxuanrbl.ID = "timu" + timurow[0].ToString().Trim();
danxuanrbl.Items.Add("A");
danxuanrbl.Items.Add("B");
danxuanrbl.Items.Add("C");
danxuanrbl.Items.Add("D");
if (timurow[5].ToString().Trim() != "") //设置单选题答案
{
danxuanrbl.SelectedValue = timurow[5].ToString().Trim();
}
danxuanrbl.RepeatDirection = RepeatDirection.Horizontal;
danxuanrbl.Width = Unit.Pixel(240);
templiteral = new Literal();
templiteral.Text = "<table><tr><td> 请选择(四选一)：</td><td>";
PlaceHolder1.Controls.Add(templiteral);
PlaceHolder1.Controls.Add(danxuanrbl);
templiteral = new Literal();
templiteral.Text = "</td></tr></table>";
PlaceHolder1.Controls.Add(templiteral);
break;
case "判断题":
panduanrbl = new RadioButtonList();
panduanrbl.ID = "timu" + timurow[0].ToString().Trim();
panduanrbl.Items.Add(new ListItem("正确", "T"));
panduanrbl.Items.Add(new ListItem("错误", "F"));
if (timurow[5].ToString().Trim() != "")
{
panduanrbl.SelectedValue = timurow[5].ToString().Trim().ToUpper();
}
panduanrbl.RepeatDirection = RepeatDirection.Horizontal;
panduanrbl.Width = Unit.Pixel(150);
templiteral = new Literal();
templiteral.Text = "<table><tr><td> 请选择(二选一)：</td><td>";
PlaceHolder1.Controls.Add(templiteral);
PlaceHolder1.Controls.Add(panduanrbl);
templiteral = new Literal();
templiteral.Text = "</td></tr></table>";
PlaceHolder1.Controls.Add(templiteral);
break;
case "多项选择题":
duoxuancbl = new CheckBoxList();
duoxuancbl.ID = "timu" + timurow[0].ToString().Trim();
duoxuancbl.Items.Add("A");
duoxuancbl.Items.Add("B");
duoxuancbl.Items.Add("C");
duoxuancbl.Items.Add("D");
duoxuancbl.Items.Add("E");
if (timurow[5].ToString().Trim() != "") //设置多选题答案
{
if (timurow[5].ToString().IndexOf('A') >= 0)
{
duoxuancbl.Items[0].Selected = true;
}
if (timurow[5].ToString().IndexOf('B') >= 0)
{
duoxuancbl.Items[1].Selected = true;
}
if (timurow[5].ToString().IndexOf('C') >= 0)
{
duoxuancbl.Items[2].Selected = true;
}
if (timurow[5].ToString().IndexOf('D') >= 0)
{
duoxuancbl.Items[3].Selected = true;
}
if (timurow[5].ToString().IndexOf('E') >= 0)
{
duoxuancbl.Items[4].Selected = true;
}
}
templiteral = new Literal();
templiteral.Text = "<table><tr><td> 请选择(可多选)：</td><td>";
PlaceHolder1.Controls.Add(templiteral);
duoxuancbl.Width = Unit.Pixel(300);
duoxuancbl.RepeatDirection = RepeatDirection.Horizontal;
PlaceHolder1.Controls.Add(duoxuancbl);
templiteral = new Literal();
templiteral.Text = "</td></tr></table>";
PlaceHolder1.Controls.Add(templiteral);
break;
case "操作题":
templiteral = new Literal();
templiteral.Text = "<font color='red'><b>注意：作业文件要用'提交作业文件'按钮进行提交,各题分别提交,用'提交作业'按钮不能提交作业文件！</b></font><br/>";
PlaceHolder1.Controls.Add(templiteral);
if (timurow[9].ToString().Length > 0)
{
HyperLink ziyuanfile = new HyperLink();
ziyuanfile.ID = "ziyuanfile" + timurow[0].ToString().Trim();
ziyuanfile.Text = "下载本题资源文件";
ziyuanfile.NavigateUrl = timurow[10].ToString().Trim();
PlaceHolder1.Controls.Add(ziyuanfile);
}
//显示文件上传控件
caozuofuld = new FileUpload();
caozuofuld.ID = "timu" + timurow[0].ToString().Trim();
caozuofuld.ToolTip = "不要上传程序文件,文件大小不要超过2MB,最好压缩后上传。";
templiteral = new Literal();
templiteral.Text = " 请选择要上传的作业文件：";
PlaceHolder1.Controls.Add(templiteral);
PlaceHolder1.Controls.Add(caozuofuld);
//添加文件验证
filevalidator = new RequiredFieldValidator();
filevalidator.Text = "请选择作业文件！";
filevalidator.ControlToValidate = "timu" + timurow[0].ToString().Trim();
filevalidator.ID = "fv" + timurow[0].ToString().Trim();
filevalidator.EnableClientScript = true;
filevalidator.Display = ValidatorDisplay.Dynamic;
filevalidator.ValidationGroup = "g" + timurow[0].ToString().Trim();
PlaceHolder1.Controls.Add(filevalidator);
//显示上传文件按钮
btn_uploadfile = new Button();
btn_uploadfile.Text = "提交作业文件";
btn_uploadfile.ID = "timu" + timurow[0].ToString().Trim() + "upload";
btn_uploadfile.CommandArgument = timurow[0].ToString();
//btn_uploadfile.CommandName = "UploadZuoyeFile";
btn_uploadfile.Command += new CommandEventHandler(UploadZuoyeFile);
btn_uploadfile.CausesValidation = true;
btn_uploadfile.ValidationGroup = "g" + timurow[0].ToString().Trim();
PlaceHolder1.Controls.Add(btn_uploadfile);
templiteral = new Literal();
templiteral.Text = "<br/>";
PlaceHolder1.Controls.Add(templiteral);
//if (timurow[7].ToString().Length > 0)
//{
HyperLink benrenzuoyefile = new HyperLink();
benrenzuoyefile.ID = "zuoyefile" + timurow[0].ToString().Trim();
benrenzuoyefile.Text = "下载我的作业文件";
benrenzuoyefile.NavigateUrl = timurow[6].ToString().Trim();
benrenzuoyefile.Target = "_blank";
PlaceHolder1.Controls.Add(benrenzuoyefile);
//}
templiteral = new Literal();
templiteral.Text = "<br/>";
PlaceHolder1.Controls.Add(templiteral);
break;
case "填空题":
tikongtbx = new TextBox();
tikongtbx.ID = "timu" + timurow[0].ToString().Trim();
tikongtbx.TextMode = TextBoxMode.SingleLine;
tikongtbx.MaxLength = 100;
if (timurow[5].ToString().Trim() != "") //设置单选题答案
{
tikongtbx.Text = timurow[5].ToString().Trim();
}
templiteral = new Literal();
templiteral.Text = " 请在此框中填写答案：";
PlaceHolder1.Controls.Add(templiteral);
PlaceHolder1.Controls.Add(tikongtbx);
templiteral = new Literal();
templiteral.Text = "<br/>";
PlaceHolder1.Controls.Add(templiteral);
break;
default:
tikongtbx = new TextBox();
tikongtbx.ID = "timu" + timurow[0].ToString().Trim();
tikongtbx.TextMode = TextBoxMode.MultiLine;
tikongtbx.Rows = 5;
tikongtbx.Columns = 80;
tikongtbx.MaxLength = 500;
if (timurow[5].ToString().Trim() != "") //设置简答题答案
{
tikongtbx.Text = timurow[5].ToString().Trim();
}
templiteral = new Literal();
templiteral.Text = " 请在此框中填写答案：<br/>";
PlaceHolder1.Controls.Add(templiteral);
PlaceHolder1.Controls.Add(tikongtbx);
templiteral = new Literal();
templiteral.Text = "<br/>";
PlaceHolder1.Controls.Add(templiteral);
break;
}
tihao++;
}
#endregion
}
else
{
Button1.Enabled = false;
}
}
protected void xianshiTimu()//在PlaceHolder1中显示题目
{
int zuoyeid = int.Parse(Request.QueryString["zuoyeid"]);
string stuusername = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
DataTable timutable = StudentInfo.GetStuZuoyeTimu(zuoyeid, stuusername);
Literal tihaoliteral;//显示题号
Literal templiteral;
if (timutable.Rows.Count > 0)
{
int tihao = 1;
foreach (DataRow timurow in timutable.Rows)
{
tihaoliteral = new Literal();
tihaoliteral.Text = "<br/>" + tihao.ToString() + "、(" + timurow[2].ToString() + ",分值:" + timurow[7] + "分，您得" + timurow[8].ToString() + "分)" + timurow[3].ToString() + "<br/>";
PlaceHolder1.Controls.Add(tihaoliteral);
switch (timurow[2].ToString().Trim())
{
case "单项选择题":
case "判断题":
case "多项选择题":
case "填空题":
templiteral = new Literal();
templiteral.Text = "本题的参考答案是:<font color='red'><b>" + timurow[4].ToString() + "</b></font>；<br/>您的回答是:<font color='blue'><b>" + timurow[5].ToString() + "</b></font>。<br/>";
PlaceHolder1.Controls.Add(templiteral);
break;
case "操作题":
if (timurow[9].ToString().Length > 0)
{
HyperLink ziyuanfile = new HyperLink();
ziyuanfile.ID = "ziyuanfile" + timurow[0].ToString().Trim();
ziyuanfile.Text = "下载本题资源文件";
ziyuanfile.NavigateUrl = timurow[9].ToString().Trim();
PlaceHolder1.Controls.Add(ziyuanfile);
}
//显示文件上传控件
if (timurow[6].ToString().Length > 0)
{
HyperLink benrenzuoyefile = new HyperLink();
benrenzuoyefile.ID = "zuoyefile" + timurow[0].ToString().Trim();
benrenzuoyefile.Text = "下载我的作业文件";
benrenzuoyefile.NavigateUrl = timurow[6].ToString().Trim();
benrenzuoyefile.Target = "_blank";
PlaceHolder1.Controls.Add(benrenzuoyefile);
}
else
{
HyperLink benrenzuoyefile = new HyperLink();
benrenzuoyefile.Text = "<font color='red'>没有找到您的作业文件。</font>";
PlaceHolder1.Controls.Add(benrenzuoyefile);
}
break;
default:
templiteral = new Literal();
templiteral.Text = "本题的参考答案是:<font color='red'><b>" + timurow[4].ToString() + "</b></font>；<br/>您的回答是:<font color='blue'>" + timurow[5].ToString() + "</font>。";
PlaceHolder1.Controls.Add(templiteral);
break;
}
tihao++;
}
}
}
protected void Button1_Click(object sender, EventArgs e)//交作业
{
//保存答案
int zuoyeid = int.Parse(Request.QueryString["zuoyeid"]);
string stuusername = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
DataTable timutable = StudentInfo.GetStuZuoyeTimu(zuoyeid, stuusername);
string daan = "";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["kecheng2012ConnectionString"].ConnectionString;
SqlCommand comm = conn.CreateCommand();
conn.Open();
SqlTransaction st = conn.BeginTransaction();
comm.Transaction = st;
try
{
foreach (DataRow timurow in timutable.Rows)
{
switch (timurow[2].ToString().Trim())
{
case "单项选择题":
daan = ((RadioButtonList)(PlaceHolder1.FindControl("timu" + timurow[0].ToString().Trim()))).SelectedValue;
if (daan != "")
{
comm.CommandText = "update [tb_stuzuoyetimu] set answer='" + daan + "' where [stuzuoyetimuid]=" + (int)(timurow[0]);
comm.ExecuteNonQuery();
}
break;
case "判断题":
daan = ((RadioButtonList)(PlaceHolder1.FindControl("timu" + timurow[0].ToString().Trim()))).SelectedValue;
if (daan != "")
{
comm.CommandText = "update [tb_stuzuoyetimu] set answer='" + daan + "' where [stuzuoyetimuid]=" + (int)(timurow[0]);
comm.ExecuteNonQuery();
}
break;
case "多项选择题":
daan = "";
CheckBoxList duoxuancbl = (CheckBoxList)(PlaceHolder1.FindControl("timu" + timurow[0].ToString().Trim()));
for (int i = 0; i < 5; i++)
{
if (duoxuancbl.Items[i].Selected)
{
daan += duoxuancbl.Items[i].Value.Trim();
}
}
if (daan != "")
{
comm.CommandText = "update [tb_stuzuoyetimu] set answer='" + daan + "' where [stuzuoyetimuid]=" + (int)(timurow[0]);
comm.ExecuteNonQuery();
}
break;
case "操作题":
break;
case "填空题":
daan = ((TextBox)(PlaceHolder1.FindControl("timu" + timurow[0].ToString().Trim()))).Text.Trim();
if (daan != "")
{
comm.CommandText = "update [tb_stuzuoyetimu] set answer='" + daan + "' where [stuzuoyetimuid]=" + (int)(timurow[0]);
comm.ExecuteNonQuery();
}
break;
default:
daan = ((TextBox)(PlaceHolder1.FindControl("timu" + timurow[0].ToString().Trim()))).Text.Trim();
if (daan != "")
{
comm.CommandText = "update [tb_stuzuoyetimu] set answer='" + daan + "' where [stuzuoyetimuid]=" + (int)(timurow[0]);
comm.ExecuteNonQuery();
}
break;
}
}
comm.CommandText = "update [tb_stuzuoyetimu] set defen=fenzhi where studentusername='******' and zuoyeid=" + zuoyeid + " and (answer is not null and answer<>'') and answer=(select answer from tb_tiku where questionid=tb_stuzuoyetimu.questionid)";
comm.ExecuteNonQuery();
comm.CommandText = "update [tb_stuzuoyetimu] set defen=0 where studentusername='******' and zuoyeid=" + zuoyeid + " and (answer is null or answer='' or answer<>(select answer from tb_tiku where questionid=tb_stuzuoyetimu.questionid))";
comm.ExecuteNonQuery();
comm.CommandText = "update [tb_studentzuoye] set shangjiaoriqi='" + DateTime.Now.ToString() + "',zongfen=(select sum(defen) from tb_stuzuoyetimu where zuoyeid=" + zuoyeid + " and studentusername='******') where zuoyeid=" + zuoyeid + " and studentusername='******'";
comm.ExecuteNonQuery();
st.Commit();
FormView1.DataBind();
ScriptManager.RegisterClientScriptBlock(this, typeof(string), "", "<script language='javascript'>alert('作业上交成功!');</script>", false);
}
catch (Exception ex)
{
st.Rollback();
Label2.Text = ex.Message;
ScriptManager.RegisterClientScriptBlock(this, typeof(string), "", "<script language='javascript'>alert('作业上交失败!');</script>", false);
}
finally
{
conn.Close();
}
}
