//个人信息
public Teacher_list SelfInfo(string id)
{
Teacher_list t = new Teacher_list();
conn = new SqlConnection(str);
comd = new SqlCommand(String.Format(@"select teacherid,teaname,password from dbo.Teacher_list where teacherid='{0}'", id), conn);
try
{
conn.Open();
SqlDataReader dr = comd.ExecuteReader();
if (dr.Read())
{
t.name = dr["teaname"].ToString();
t.id = dr["teacherid"].ToString();
t.pwd = dr["password"].ToString();
}
dr.Close();
}
finally
{
conn.Close();
};
return(t);
}
public void FormTeacher_Load(object sender, EventArgs e)
{
t = db.SelfInfo(Pass.passData);
button2.BackgroundImage = Online_examination_system.Properties.Resources.QQ图片201912091545612;
string lastname = t.name.ToString();
Lab_Prompt.Text = "尊敬的" + lastname.Substring(0, 1) + "老师，欢迎使用本系统！！";
DGV_Test.DataSource = db.TestManger().Tables["Examination_list"];
DGV_Topic.DataSource = db.TopicManger().Tables["TheQuestionBank"];
DGV_Result.DataSource = db.TestManger().Tables["Examination_list"];
DGV_CheckTest.DataSource = db.CheckTestManger().Tables["EndExamSocre"];
this.Com_Subject.DataSource = db.Subject().Tables["class_schedule"];
this.Com_Subject.DisplayMember = "coursename";
}
