protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = dataconn.getcon();
con.Open();
SqlCommand mycom = new SqlCommand("select question from tb_Student where ID='"
+ Convert.ToString(Session["ID"]) + "'", con);
this.labQuePwd.Text = Convert.ToString(mycom.ExecuteScalar());
con.Close();
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = new SqlCommand("select count(*) from Student where ID='" + TextBox1.Text + "'", cn);
int count = Convert.ToInt32(com.ExecuteScalar());
if (TextBox1.Text == "")
{
Response.Write("<script>alert('用户名不能为空');</script>");
}
else if (count > 0)
{
Session["ID"] = TextBox1.Text;
Response.Redirect("getpwd2.aspx");
}
else
{
Response.Write("<script>alert('该用户名不存在');</script>");
return;
}
cn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = dataconn.getcon();
con.Open();
string sqlstr1 = "select count(*) from Score where UserID ='" + Session["ID"] + "' and PaperID='" + ddlQueName.SelectedValue + "'";
SqlCommand mycom = new SqlCommand(sqlstr1, con);
int intcount = Convert.ToInt32(mycom.ExecuteScalar());
Application["d1"] = ddlLesson.SelectedItem;
Session["PaperID"] = ddlQueName.SelectedValue;
Session["PaperName"] = ddlQueName.SelectedItem;
if (this.ddlQueName.Text == "")
{
Response.Write("<script lanuage=javascript>alert('您还没有选择考试套题，请重新选择！');location='javascript:history.go(-1)'</script>");
}
else if (intcount > 0)
{
Response.Write("<script lanuage=javascript>alert('此套题已经答过！');location='javascript:history.go(-1)'</script>");
}
else
{
Response.Redirect("wait.aspx");
}
}
public static string DeleteAll(string s)
{
string[] str = s.Split('*');
string Tsql = "delete from Chapter where ID='";
for (int i = 0; i < str.Length; i++)
{
Tsql += str[i] + "'";
if (i + 1 < str.Length)
{
Tsql += " or ID='";
}
}
Datacon dataconn = new Datacon();
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
com.CommandText = Tsql;
if (com.ExecuteNonQuery() > 0)
{
return("true");
}
else
{
return("false");
}
cn.Close();
}
protected void InitData()
{
int multiProblemID = int.Parse(Request["ID"].ToString()); //取出传递过来的试题编号
MultiProblem multiproblem = new MultiProblem(); //创建单选题对象
if (multiproblem.LoadData(multiProblemID)) //如果取出题目信息，分别放在相应控件显示
{
db.ecDropDownList(ddlCourse, "select *from Course where c_id=(select c_id from MultiProblem where ID='" + multiProblemID + " ')", "c_name", "c_id");
txtTitle.Text = multiproblem.Title;
txtAnswerA.Text = multiproblem.AnswerA;
txtAnswerB.Text = multiproblem.AnswerB;
txtAnswerC.Text = multiproblem.AnswerC;
txtAnswerD.Text = multiproblem.AnswerD;
string answer = multiproblem.Answer.ToString();
SqlConnection cn = db.getcon();
cn.Open();
string sqlstr1 = "select Answer from MultiProblem where ID='" + Request["ID"].ToString() + "'";
SqlCommand cmd1 = new SqlCommand(sqlstr1, cn);
Label1.Text = cmd1.ExecuteScalar().ToString();
}
else //查询出错，给出提示
{
Response.Write("<script>alert('加载数据错误！');</script>");
Response.Write("<script>window.location.href='ChangeDuoXuan'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection cn = dataconn.getcon();
cn.Open();
//string str = "select Question from tb_Student where ID='" + Convert.ToString(Session["ID"]) + "'";
if (!IsPostBack)
{
SqlCommand mycom = new SqlCommand("select question from Student where ID='"
+ Convert.ToString(Session["ID"]) + "'", cn);
this.Label2.Text = Convert.ToString(mycom.ExecuteScalar());
cn.Close();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection cn = dataconn.getcon();
cn.Open();
int id = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
string ID = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
string Name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
string PWD = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
string JoinTime = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString();
SqlDataReader dr;
string sql = "Update Admin Set ID='" + ID + "',Name='" + Name + "',PWD='" + PWD + "',JoinTime='" + JoinTime + "' Where ID=" + id + "";
SqlCommand myCommand = new SqlCommand(sql, cn);
dr = myCommand.ExecuteReader();
GridView1.EditIndex = -1;
cn.Close();
dataconn.bind(GridView1, "select * from Admin order by ID DESC");
}
private void getcom(int i)
{
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
switch (i)
{
case 1:
com.CommandText = "select count(*) from Student where ID='" + this.TextBox5.Text + "'and PWD='" + this.TextBox6.Text + "'";
int count1 = Convert.ToInt32(com.ExecuteScalar());
if (count1 > 0)
{
Session["ID"] = TextBox5.Text;
Session["PWD"] = TextBox6.Text;
Response.Redirect("User/or.aspx");
}
else
{
Response.Write("<script language=javascript>alert('用户名或密码错误！')</script>");
}
break;
case 2:
com.CommandText = "select count(*) from Admin where name='" + TextBox5.Text + "'and PWD='" + TextBox6.Text + "'";
int count2 = Convert.ToInt32(com.ExecuteScalar());
if (count2 > 0)
{
Session["ID"] = TextBox5.Text;
Session["PWD"] = TextBox6.Text;
Page.Response.Redirect("Admin/admin.aspx");
}
else
{
Response.Write("<script>alert('用户名或密码错误！')</script>");
Response.Write("<script language=javascript>window.location.href='Index.aspx'</script>");
}
break;
case 3:
com.CommandText = "select count(*) from Teacher where id='" + this.TextBox5.Text + "'and pwd='" + this.TextBox6.Text + "'";
int count3 = Convert.ToInt32(com.ExecuteScalar());
if (count3 > 0)
{
Session["ID"] = TextBox5.Text;
Session["PWD"] = TextBox6.Text;
Response.Redirect("Teacher/teacher.aspx");
}
else
{
Response.Write("<script language=javascript>alert('用户名或密码错误！')</script>");
Response.Write("<script language=javascript>window.location.href='Index.aspx'</script>");
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = dataconn.getcon();
con.Open();
SqlCommand mycom1 = new SqlCommand("select ID,Pwd from tb_Student where ID='" + Convert.ToString(Session["ID"]) + "'", con);
SqlCommand mycom2 = new SqlCommand("select PWD from tb_Student where ID='" + Convert.ToString(Session["ID"]) + "'", con);
this.txtStuID.Text = Convert.ToString(mycom1.ExecuteScalar());
this.txtStuPwd.Text = Convert.ToString(mycom2.ExecuteScalar());
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
Button4.Attributes.Add("onclick", "javascript:return window.confirm('您确定要删除吗?')");
if (!IsPostBack)
{
/*验证是否登陆了系统*/
if (Session["User_Row"] != "Admin")
{
Response.Write("<script>top.location.href='../404.html';</script>");
return;
}
dataconn.bindinfostring(GridView1, "select * from Major order by ID DESC", "ID");
//查询数据
SqlConnection cn = dataconn.getcon();
cn.Open();
string sqlstr1 = "select count(*) from Major";
SqlCommand cmd1 = new SqlCommand(sqlstr1, cn);
Label5.Text = cmd1.ExecuteScalar().ToString();
}
}
protected void Button_insertinto_Click(object sender, EventArgs e)
{
Datacon dataconn = new Datacon();
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
com.CommandText = "update TaoTi set PaperName='" + TextBox_PaperName.Text + "',PaperState='" + TextBox_PaperState.Text + "',AnswerTime='" + TextBox_AnswerTime.Text + "' where PaperID='" + PaperID + "'";
if (com.ExecuteNonQuery() > 0)
{
Response.Write("<script>alert('修改成功!');window.parent.location.reload();</script>");
}
}
protected void Button_insertinto_Click(object sender, EventArgs e)
{
Datacon dataconn = new Datacon();
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
com.CommandText = "update Course set c_name='" + TextBox_c_name.Text.ToString().Trim() + "' where c_id='" + TextBox_c_id.Text.ToString().Trim() + "'";
if (com.ExecuteNonQuery() > 0)
{
Response.Write("<script>alert('修改成功!" + TextBox_c_name.Text + TextBox_c_id.Text + "');window.parent.location.reload();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//在文本框中显示管理员信息
if (!IsPostBack)
{
SqlConnection con = dataconn.getcon();
con.Open();
SqlDataAdapter mydataadapter = new SqlDataAdapter("select * from tb_Administrator where ID=" + Request["id"], con);
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset, "tb_Administrator");
DataRowView rowview = mydataset.Tables["tb_Administrator"].DefaultView[0];
this.txtAdminName.Text = Convert.ToString(rowview["Name"]);
this.txtAdminPwd.Text = Convert.ToString(rowview["PWD"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
SqlConnection con = dataconn.getcon();
con.Open();
SqlDataAdapter mydataadapter = new SqlDataAdapter("select * from tb_Profession where id="
+ Request["id"], con);
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset, "tb_Profession");
DataRowView rowview = mydataset.Tables["tb_Profession"].DefaultView[0];
this.txtProName.Text = Convert.ToString(rowview["Name"]);
con.Close();
}
}
public int checkDel(string key)
{
Datacon dacon = new Datacon();
SqlConnection con = dacon.getcon();
string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//SqlCommand myCommand = new SqlCommand("INSERT INTO xxfb(NewsName, NewsContent, NewsDate) VALUES('" + caption + "','" + editor + "', '" + time + "')", con);
SqlCommand myCommand = new SqlCommand(" delete from xxfb where MessagesId=@NewsId", con);
myCommand.Parameters.Add(new SqlParameter("@NewsId", SqlDbType.Int, 50));
myCommand.Parameters["@NewsId"].Value = key;
myCommand.Connection.Open();
int i = (int)myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
return i;
}
public void ST_check_Login()
{
//打开数据库连接，并调用公共类中的getcon方法
SqlConnection con = dataconn.getcon();
con.Open();
string sqlstr1 = "select count(*) from tb_StuResult where stu_id ='" + Session["StuName"] + "'";
SqlCommand mycom = new SqlCommand(sqlstr1, con);
int intcount = Convert.ToInt32(mycom.ExecuteScalar());
if (intcount > 0)
{
Response.Write("<script>alert('对不起！您只能答一套题！');location='zaixian_kaoshi.aspx'</script>");
}
}
//自定义方法getcom方法，判断是否是管理员还是考生
private void getcom(int i)
{
//打开数据库连接，并调用公共类中的getcon方法
SqlConnection con = dataconn.getcon();
con.Open();
//创建一个新的SqlCommand实例对象
SqlCommand com = con.CreateCommand();
switch (i)
{
case 1:
com.CommandText = "select count(*) from tb_Administrator where Name='" + this.txtUserName.Text + "'and PWD='" + this.txtPwd.Text + "'";
//获取SQL语句的值 强制转换成数值类型
int count1 = Convert.ToInt32(com.ExecuteScalar());
//判断数据库中是否存在数据
if (count1 > 0)
{
Application["Name"] = txtUserName.Text; //成功
Application["PWD"] = txtPwd.Text; //成功
//如果登录成功，则跳转到管理员页面
Page.Response.Redirect("HouAdmin/admin.aspx");
}
else
{
//如果登录失败，则弹出错误信息
Response.Write("<script lanuage=javascript>alert('用户名或密码有误！');location='javascript:history.go(-1)'</script>");
}
break;
case 2:
com.CommandText = "select count(*) from tb_Student where ID='" + txtUserName.Text + "' and PWD='" + txtPwd.Text + "'";
int count2 = Convert.ToInt32(com.ExecuteScalar());
if (count2 > 0)
{
Application["ID"] = txtUserName.Text;
Application["PWD"] = txtPwd.Text;
Page.Response.Redirect("QianUser/zaixian_kaoshi.aspx");
}
else
{
Response.Write("<script lanuage=javascript>alert('用户名或密码有误！');location='javascript:history.go(-1)'</script>");
return;
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dataconn.ecDropDownList(ddlProfession, "select * from tb_Profession", "Name", "id");
SqlConnection con = dataconn.getcon();
con.Open();
SqlDataAdapter mydataadapter = new SqlDataAdapter("select * from tb_Lesson where ID="
+ Request["id"], con);
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset, "tb_lesson");
DataRowView rowview = mydataset.Tables["tb_lesson"].DefaultView[0];
this.txtLessName.Text = Convert.ToString(rowview["Name"]);
ddlProfession.Text = Convert.ToString(rowview["ofProfession"]);
con.Close();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection cn = dataconn.getcon();
cn.Open();
int id = int.Parse(((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString());
string c_name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
string c_date = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
SqlDataReader dr;
string sql = "Update Course Set c_name='" + c_name + "',c_date='" + c_date + "' Where c_id=" + id + "";
SqlCommand myCommand = new SqlCommand(sql, cn);
dr = myCommand.ExecuteReader();
GridView1.EditIndex = -1;
cn.Close();
dataconn.bind(GridView1, "select * from Course where teacher_id='" + Session["ID"] + "' order by c_id DESC");
}
protected void btnTest_Click(object sender, EventArgs e)
{
string sqlstr = "select * from tb_Profession";
//创建一个新的数据库连接对象
SqlConnection sqlconn = dataconn.getcon();
//打开数据库连接
sqlconn.Open();
//定义并初使化命令对象
SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
//创建一个数据阅读器
SqlDataReader read = sqlcom.ExecuteReader();
//如果记录不为空
read.Read();
if (read.HasRows)
{
if (this.txtProName.Text.Trim() == read["Name"].ToString().Trim())
{
Label2.Text = "该专业已经存在，请重新填写专业名称";
txtProName.Text = "";
txtProName.Focus();
btnAdd.Enabled = false;
Label2.Visible = true;
btnTest.Enabled = true;
return;
}
else
{
Label2.Visible = true;
Label2.Text = "该专业可以进行正常注册";
btnAdd.Enabled = true;
btnTest.Enabled = false;
}
}
else
{
Label2.Visible = true;
Label2.Text = "该专业可以进行正常注册";
btnAdd.Enabled = true;
btnTest.Enabled = false;
}
//关闭数据阅读器
read.Close();
}
protected void GridView1_RowUpdating1(object sender, GridViewUpdateEventArgs e)
{
SqlConnection cn = dataconn.getcon();
cn.Open();
int id = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
string PaperName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
string PaperState = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString();
string AnswerTime = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString();
SqlDataReader dr;
string sql = "Update TaoTi Set PaperName='" + PaperName + "',PaperState='" + PaperState + "',AnswerTime='" + AnswerTime + "' Where PaperID=" + id + "";
SqlCommand myCommand = new SqlCommand(sql, cn);
dr = myCommand.ExecuteReader();
GridView1.EditIndex = -1;
cn.Close();
dataconn.bind(GridView1, "select * from TaoTi where teacher_id='" + Session["ID"] + "' order by PaperID DESC");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["ID"] == null)
{
Response.Write("<script>alert('非法登录！');location='../Index.aspx'</script>");
}
else
{
SqlConnection cn = dataconn.getcon();
cn.Open();
string sqlstr1 = "select Name from Admin where name='" + Session["ID"] + "'";
SqlCommand cmd1 = new SqlCommand(sqlstr1, cn);
Label3.Text = cmd1.ExecuteScalar().ToString();
}
}
}
public static string Delete(string s)
{
Datacon dataconn = new Datacon();
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
com.CommandText = "delete from Chapter where ID='" + s + "'";
if (com.ExecuteNonQuery() > 0)
{
return("true");
}
else
{
return("false");
}
cn.Close();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection cn = dataconn.getcon();
cn.Open();
string id = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
string name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
string pwd = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
string JoinTime = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString();
string degree = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString();
SqlDataReader dr;
string sql = "Update Teacher Set name='" + name + "',pwd='" + pwd + "',JoinTime='" + JoinTime + "',degree='" + degree + "' Where id=" + id + "";
SqlCommand myCommand = new SqlCommand(sql, cn);
dr = myCommand.ExecuteReader();
GridView1.EditIndex = -1;
cn.Close();
dataconn.bind(GridView1, "select * from Teacher order by id DESC");
}
public static string Update(string s)
{
string[] str = s.Split('*');
Datacon dataconn = new Datacon();
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
com.CommandText = "update Chapter set Name='" + str[1] + "' where ID='" + str[0] + "'";
if (com.ExecuteNonQuery() > 0)
{
return("true");
}
else
{
return("false");
}
cn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (this.txtAdminName.Text != "")
{
SqlConnection con = dataconn.getcon();
con.Open();
string sqlstr1 = "select count(*) from tb_Teacher where Name='" + txtAdminName.Text.ToString() + "'";
SqlCommand mycom = new SqlCommand(sqlstr1, con);
int intcount = Convert.ToInt32(mycom.ExecuteScalar());
if (intcount > 0)
{
Response.Write("<script>alert('对不起！此教师已经添加！');location='teacherInsert.aspx'</script>");
}
else
{
dataconn.eccom("exec add_teacher '" + txtAdminName.Text + "','" + txtAdminPwd.Text + "'");
Response.Write("<script lanuage=javascript>alert('添加成功！');location='Teacher.aspx'</script>");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = dataconn.getcon();
con.Open();
SqlCommand com = new SqlCommand("select count(*) from tb_Student where ID='" + txtStuID.Text + "'", con);
int count = Convert.ToInt32(com.ExecuteScalar());
if (count > 0)
{
Session["ID"] = txtStuID.Text;
Page.Response.Redirect("InfoPwdd.aspx");
}
else
{
Response.Write("<script>alert('无此学生编号或输入有误');location='javascript:history.go(-1)'</script>");
return;
}
con.Close();
}
public void InitData()
{
int judgeProblemID = int.Parse(Request["ID"].ToString()); //取出传递过来的试题编号
JudgeProblem judgeproblem = new JudgeProblem(); //创建判断题对象
if (judgeproblem.LoadData(judgeProblemID)) //如果取出题目信息，分别放在相应控件显示
{
db.ecDropDownList(ddlCourse, "select * from Course where c_id=(select c_id from JudgeProblem where ID='" + judgeProblemID + "' )", "c_name", "c_id");
txtTitle.Text = judgeproblem.Title;
SqlConnection cn = db.getcon();
cn.Open();
string sqlstr1 = "select Answer from JudgeProblem where ID='" + Request["ID"].ToString() + "'";
SqlCommand cmd1 = new SqlCommand(sqlstr1, cn);
Label1.Text = cmd1.ExecuteScalar().ToString();
}
else //查询出错，给出提示
{
Response.Write("<script>alert('加载数据错误！');</script>");
Response.Write("<script>window.location.href='ChangePanDuan.aspx'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User_Name"] == null || Session["User_Row"].ToString() != "Teacher")
{
Response.Write("<script>alert('非法登录！')</script>");
Response.Write("<script language=javascript>top.location.href='../Login.aspx'</script>");
}
if (!IsPostBack)
{
Datacon dataconn = new Datacon();
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
com.CommandText = "select count(*) from student_score";
int count1 = Convert.ToInt32(com.ExecuteScalar());
Label1.Text = count1.ToString();
cn.Close();
SqlDataSource1.ConnectionString = ConfigurationSettings.AppSettings["connectionstring"].ToString();
SqlDataSource1.SelectCommand = "select * from student_score";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (this.txtAdminName.Text != "")
{
SqlConnection con = dataconn.getcon();
con.Open();
string sqlstr1 = "select count(*) from tb_Administrator where Name='" + txtAdminName.Text.ToString() + "'";
SqlCommand mycom = new SqlCommand(sqlstr1, con);
int intcount = Convert.ToInt32(mycom.ExecuteScalar());
if (intcount > 0)
{
Response.Write("<script>alert('对不起！此管理员已经添加！');location='AdminInsert.aspx'</script>");
}
else
{
dataconn.eccom("insert into tb_Administrator(Name,PWD)values('" + txtAdminName.Text + "','" + txtAdminPwd.Text + "')");
//Page.Response.Redirect("admin.aspx");
Response.Write("<script lanuage=javascript>alert('添加成功！');location='admin.aspx'</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["User_Name"] == null || Session["User_Row"].ToString() != "Teacher")
{
Response.Write("<script>alert('非法登录！')</script>");
Response.Write("<script language=javascript>top.location.href='../Login.aspx'</script>");
}
try
{
PaperID = Request.QueryString["PaperID"].ToString();
Datacon dataconn = new Datacon();
SqlConnection cn = dataconn.getcon();
cn.Open();
SqlCommand com = cn.CreateCommand();
com.CommandText = "select * from TaoTi where PaperID='" + PaperID + "'";
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
TextBox_PaperID.Text = PaperID;
TextBox_c_id.Text = dr["c_id"].ToString();
TextBox_PaperName.Text = dr["PaperName"].ToString();
TextBox_PaperState.Text = dr["PaperState"].ToString();
TextBox_AnswerTime.Text = dr["AnswerTime"].ToString();
TextBox_Score.Text = dr["Score"].ToString();
TextBox_teacher_id.Text = dr["teacher_id"].ToString();
}
else
{
Response.Write("<script>alert('信息获取失败!');window.parent.location.reload();</script>");
}
cn.Close();
}
catch
{
Response.Write("<script>window.parent.location.reload();</script>");
}
}
}
int SQLInsert(string filename1, string filename2, string path)
{
int i = 0;
try
{
Datacon dacon = new Datacon();
SqlConnection con = dacon.getcon();
SqlCommand myCommand = new SqlCommand("insert into checkRecord(username,filenameS,filenameC,date,QRString,QRLevel,QRVersion,path,IP) values('" + Session["username"] + "','" + filename1 + "','" + filename2 + "','" + DateTime.Now.ToString() + "','" + Label22.Text + "','" + Label26.Text + "','" + Label25.Text + "','" + path + "','" + Label27.Text + "')", con);
myCommand.Connection.Open();
i = (int)myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
staticCount(filename1, Session["username"].ToString());
}
catch (Exception e)
{
Label35.Text = "译码结果在查询信息过程出错。错误：" + e.Message;
}
return i;
}
