protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)//设置作业列表中各控件的可用状态，自动编号
{
if (e.Row.RowIndex != -1)
{
((Label)(e.Row.Cells[0].FindControl("Lbl_zybh"))).Text = (e.Row.RowIndex + 1).ToString();
string zuoyeid = GridView1.DataKeys[e.Row.RowIndex].Value.ToString().Trim();
if (ZuoyeInfo.IsZuoyeUsed(zuoyeid))//如果作业已布置，则不允许修改题目
{
((HyperLink)(e.Row.Cells[5].FindControl("HyperLink1"))).Enabled = false;
((LinkButton)(e.Row.Cells[4].FindControl("LinkButton1"))).Enabled = false;
}
else
{
((HyperLink)(e.Row.Cells[5].FindControl("HyperLink1"))).Enabled = true;
((LinkButton)(e.Row.Cells[4].FindControl("LinkButton1"))).Enabled = true;
}
if (ZuoyeInfo.GetTimuCount(zuoyeid) <= 0)
{
((LinkButton)(e.Row.Cells[7].FindControl("LinkButton3"))).Enabled = false;
}
else
{
((LinkButton)(e.Row.Cells[7].FindControl("LinkButton3"))).Enabled = true;
}
}
}
protected void btn_buzhizuoye_Click(object sender, EventArgs e)//将作业布置给某个班
{
lbl_fankui.Text = "";
string zuoyeid = Request.QueryString["zuoyeid"];
if (ZuoyeInfo.GetTimuCount(zuoyeid) <= 0)//判断作业中有无题目
{
lbl_fankui.Text = "该作业中没有题目，无法布置该作业。";
return;
}
string banjiid = DropDownList1.SelectedValue.Trim();
if (BanjiInfo.GetStudentCount(int.Parse(banjiid)) <= 0)
{
lbl_fankui.Text = DropDownList1.SelectedItem.Text + "班没有学生，无法布置作业。";
return;
}
string shangjiaoqixian = TextBox1.Text;
string yunxu = RadioButtonList1.SelectedValue;
string yunxuchakan = RadioButtonList2.SelectedValue;
string kechengid = ZuoyeInfo.getZuoye_Kechengid(int.Parse(zuoyeid));
DataTable studt = BanjiInfo.GetStudentUserName(int.Parse(banjiid));
DataTable ZuoyeTimuTb = ZuoyeInfo.GetZuoyeTimuIdAndFenzhi(int.Parse(zuoyeid));
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["kecheng2012ConnectionString"].ConnectionString;
SqlCommand comm = conn.CreateCommand();
conn.Open();
SqlTransaction st = conn.BeginTransaction();
comm.Transaction = st;
comm.CommandText = "insert into tb_zuoyebuzhi(zuoyeid,banjiid,yunxuzuoti,yunxuchakan,buzhishijian,shangjiaoqixian,teacherusername,shuoming,kechengid) values(@zuoyeid,@banjiid,@yunxuzuoti,@yunxuchakan,@buzhishijian,@shangjiaoqixian,@teacherusername,@shuoming,@kechengid)";
comm.Parameters.AddWithValue("@zuoyeid", zuoyeid);
comm.Parameters.AddWithValue("@banjiid", banjiid);
comm.Parameters.AddWithValue("@yunxuzuoti", yunxu);
comm.Parameters.AddWithValue("@yunxuchakan", yunxuchakan);
comm.Parameters.AddWithValue("@buzhishijian", DateTime.Now);
comm.Parameters.AddWithValue("@shangjiaoqixian", TextBox1.Text);
comm.Parameters.AddWithValue("@teacherusername", ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name);
comm.Parameters.AddWithValue("@shuoming", TextBox2.Text);
comm.Parameters.AddWithValue("@kechengid", kechengid);
try
{
comm.ExecuteNonQuery();
//将作业分发给学生,写入学生作业表
//删除以前布置给学生的该作业
//comm.CommandText = "delete from tb_studentzuoye where zuoyeid=@zuoyeid and studentusername in(select studentusername from tb_banjistudent where banjiid=@banjiid)";
//comm.ExecuteNonQuery();
//删除题目
//comm.CommandText = "delete from tb_stuzuoyetimu where zuoyeid=@zuoyeid and studentusername in(select studentusername from tb_banjistudent where banjiid=@banjiid)";
//comm.ExecuteNonQuery();
//写入学生作业表
comm.CommandText = "insert into tb_studentzuoye(zuoyeid,kechengid,studentusername,wancheng,zongfen,buzhishijian,shangjiaoqixian,shuoming,yunxuzuoti,yunxuchakan,teacherusername) values(@zuoyeid,@kechengid,@studentusername,'未完成',0,@buzhishijian,@shangjiaoqixian,@shuoming,@yunxuzuoti,@yunxuchakan,@teacherusername)";
comm.Parameters.Add("@studentusername", SqlDbType.VarChar);
foreach (DataRow sdr in studt.Rows)
{
comm.Parameters[9].Value = sdr[0].ToString();
comm.ExecuteNonQuery();
}
//将题目写入学生作业题目表
comm.Parameters.Clear();
comm.CommandText = "insert into tb_stuzuoyetimu(zuoyeid,studentusername,questionid,defen,fenzhi) values(@zuoyeid,@studentusername,@questionid,0,@fenzhi)";
comm.Parameters.AddWithValue("@zuoyeid", zuoyeid);
comm.Parameters.Add("@studentusername", SqlDbType.VarChar);
comm.Parameters.Add("@questionid", SqlDbType.Int);
comm.Parameters.Add("@fenzhi", SqlDbType.Int);
foreach (DataRow sdr in studt.Rows)
{
comm.Parameters[1].Value = sdr[0].ToString();
foreach (DataRow dr in ZuoyeTimuTb.Rows)
{
comm.Parameters[2].Value = Convert.ToInt32(dr[0]);
comm.Parameters[3].Value = Convert.ToInt32(dr[1]);
comm.ExecuteNonQuery();
}
}
st.Commit();
lbl_fankui.Text = "将作业布置给" + DropDownList1.SelectedItem.Text + ", 成功！";
}
catch
{
st.Rollback();
lbl_fankui.Text = "布置失败！您是否已经给该班布置过该作业？";
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}