public int Insert(ZuJuan zujuan)
{
string sql = "insert into ZuJuan values(@KaoJuanID,@TitleID,@Mark)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@KaoJuanID", zujuan.KaoJuanID),
new SqlParameter("@TitleID", zujuan.TitleID),
new SqlParameter("@Mark", zujuan.Mark)
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataReader sdr = KaoJuanService.SelectKaoJuanTop1();
if (sdr.Read())
{
int id = int.Parse(sdr["KaoJuanID"].ToString());
//单选题
foreach (GridViewRow dr in GridView1.Rows)
{
ZuJuan zj = new ZuJuan();
zj.KaoJuanID = id;
zj.TitleID = int.Parse(((Label)dr.FindControl("Label3")).Text);
zj.Mark = int.Parse(((Label)dr.FindControl("Label4")).Text);
ZuJuanService.Insert(zj);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('生成成功！');</script>");
}
}
public static int Insert(ZuJuan zujuan)
{
return(izujuan.Insert(zujuan));
}
