protected void Page_Load(object sender, EventArgs e)
{
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
int shijuanid = int.Parse(Request.QueryString["shijuanid"]);
lbl_xuehao.Text = username;
lbl_shijuanname.Text = CeshiInfo.GetCeshiName(shijuanid);
lbl_xingming.Text = StudentInfo.GetStuXingming(username);
Jianchashijuan(username, shijuanid);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Labelstuusername.Text = Request.QueryString["studentusername"];
Labelbanji.Text = BanjiInfo.GetBanjiName(int.Parse(Request.QueryString["banjiid"]));
Labelxingming.Text = StudentInfo.GetStuXingming(Request.QueryString["studentusername"]);
BindZyoye();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string banjiid = Request.QueryString["banjiid"];
string stuun = Request.QueryString["studentusername"];
Labelbj.Text = BanjiInfo.GetBanjiName(int.Parse(banjiid));
Labelxm.Text = StudentInfo.GetStuXingming(stuun);
Labelstuun.Text = stuun;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string kechengid = Session["kechengid"].ToString();
string banjiid = Request.QueryString["banjiid"];
string stuun = Request.QueryString["studentusername"];
Labelkc.Text = KechengInfo.getKechengname(kechengid);
Labelbj.Text = BanjiInfo.GetBanjiName(int.Parse(banjiid));
Labelxm.Text = StudentInfo.GetStuXingming(stuun);
Labelun.Text = stuun;
BindDianMingStu();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string banjiid = Request.QueryString["banjiid"];
string kechengid = Session["kechengid"].ToString();
Labelbj.Text = BanjiInfo.GetBanjiName(int.Parse(banjiid));
string stuusername = Request.QueryString["studentusername"];
Labelxm.Text = StudentInfo.GetStuXingming(stuusername);
Labelstuun.Text = stuusername;
BindStuCeshiInfo();
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (Session["kechengid"] == null)
{
if (KechengInfo.GetKechengCount() > 0)
{
Session["kechengid"] = KechengInfo.MinKechengid().ToString();
}
else
{
Response.Redirect("default.aspx");
}
}
if (!IsPostBack)
{
string stuusername = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
Literalxingming.Text = StudentInfo.GetStuXingming(stuusername);
}
lbl_kecheng.Text = KechengInfo.getKechengname(Session["kechengid"].ToString());
CheckCeshi();//判断学生有无未完成的测试，如果有，不允许进行其他学习活动，只能进行测试
}
//读取测试名称、测试时间长度等
protected void GetCeshiJibenInfo()// 设置课程名,测试名，姓名，学号
{
int timushuliang = 0;
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
Labelusername.Text = username;
Literalxingming.Text = StudentInfo.GetStuXingming(username);
int shijuanid = int.Parse(Request.QueryString["shijuanid"]);
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["kecheng2012ConnectionString"].ConnectionString))
{
SqlCommand comm = conn.CreateCommand();
comm.CommandText = "select tb_Teachershijuan.ceshiname,tb_kecheng.kechengname,tb_student.xingming,tb_banji.banjiname,tb_studentkaoshi.kechengid,tb_Teachershijuan.timelength from tb_studentkaoshi inner join tb_Teachershijuan on tb_studentkaoshi.shijuanid=tb_Teachershijuan.shijuanid inner join tb_kecheng on tb_kecheng.kechengid=tb_studentkaoshi.kechengid inner join tb_student on tb_student.username=tb_studentkaoshi.studentusername inner join tb_banji on tb_banji.banjiid=tb_studentkaoshi.banjiid where tb_studentkaoshi.shijuanid=" + shijuanid + " and tb_studentkaoshi.studentusername='******'";
SqlDataReader reader;
conn.Open();
reader = comm.ExecuteReader();
if (reader.Read())
{
Labelkecheng.Text = reader.GetString(1).Trim(); //课程名称
Literal1.Text = reader.GetString(0); //测试名称
Labelxingming.Text = reader.GetString(2); //姓名
Labelbanji.Text = reader.GetString(3); //班级
HFkechengid.Value = reader.GetInt32(4).ToString(); //课程ID
Labelshichang.Text = reader.GetInt32(5).ToString(); //时间长度（分钟）
}
reader.Close();
comm.CommandText = "select count(*) from tb_studentkaoshiti where studentusername='******' and shijuanid=" + shijuanid;
timushuliang = (int)comm.ExecuteScalar();
lbl_timushuliang.Text = timushuliang.ToString();
}
if (ddl_tihaoliebiao.Items.Count > 0)
{
ddl_tihaoliebiao.Items.Clear();
}
for (int i = 1; i <= timushuliang; i++)
{
ddl_tihaoliebiao.Items.Add(i.ToString());
}
}
