/// <summary>
/// 返回查询的对象
/// </summary>
/// <returns></returns>
public Modle showInfoSingle(string sql)
{
Modle model = new Modle();
conn = new SqlConnection(strConnect);
SqlCommand comd = new SqlCommand(sql, conn);
try
{
conn.Open();
SqlDataReader dr = comd.ExecuteReader();
while (dr.Read())
{
//管理员信息
if (sql.Substring(0, 15).Equals("select * from A"))
{
model.adminid = dr["adminid"].ToString();
model.adminname = dr["adminname"].ToString();
}
//学生信息
if (sql.Substring(0, 15).Equals("select * from S"))
{
model.stuid = dr["stuid"].ToString();
model.stuname = dr["stuname"].ToString();
model.stuclass = dr["stuclass"].ToString();
model.stuage = dr["stuage"].ToString();
model.major = dr["major"].ToString();
model.dapartment = dr["dapartment"].ToString();
model.note = dr["note"].ToString();
}
//老师信息
if (sql.Substring(0, 15).Equals("select * from T"))
{
model.teacherid = dr["teacherid"].ToString();
model.teaname = dr["teaname"].ToString();
model.department = dr["department"].ToString();
model.teacherage = dr["teacherage"].ToString();
model.note = dr["note"].ToString();
}
//公共信息
model.password = dr["password"].ToString();
// model.purviewid = dr["purviewid"].ToString();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
conn.Close();
}
return(model);
}
/// <summary>
/// 窗口加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void Admin_Load(object sender, EventArgs e)
{
//主内容控件跟随窗口变大而变大事件
AutoScale(this);
this.DialogResult = DialogResult.OK;
//一开始就把数据库的学生、老师、管理员表值添加到学生页面的DataGridView中
Baind();
//把当前管理员的基本信息显示出来
Modle modle = dl.showInfoSingle(static_SQL_CRUD.AdminId());
this.ID_txt.Text = modle.adminid;
this.Name_txt.Text = modle.adminname;
this.password_txt.Text = modle.password;
this.UserType_txt.Text = "管理员";
//显示当前课程管理的科目
this.CourseChoose_cob.DataSource = dl.ShowInfo(static_SQL_CRUD.AllInfoOfCourse).Tables["info"];
this.CourseChoose_cob.DisplayMember = "coursename";
this.CourseChoose_cob.ValueMember = "courseid";
//把文本框圆角化
//this.TeacherSearchBar_txt.Region = Round(this.TeacherSearchBar_txt.Width, this.TeacherSearchBar_txt.Height, 20);
//0this.StudentSearchBar_txt.Region = Round(this.StudentSearchBar_txt.Width, this.StudentSearchBar_txt.Height, 20);
//创建考试时，要添加试题，一开始把所有题都显示再在这个dataview里面
this.questions_dataView.DataSource = dl.ShowInfo(static_SQL_CRUD.AllInfoOfQuestionsBank).Tables["info"];
//录题库时，要显示当前题库已存在的题
this.questionsDisplay.DataSource = dl.ShowInfo(static_SQL_CRUD.AllInfoOfQuestionsBank).Tables["info"];
//显示考试数据
this.examDisplay_data.DataSource = dl.ShowInfo(static_SQL_CRUD.AllInfoOfExam).Tables["info"];
if (this.examDisplay_data.RowCount > 0)
{
this.examDisplay_data.Visible = true;
this.isDisplayExam_txt.Visible = false;
}
else
{
this.examDisplay_data.Visible = false;
this.isDisplayExam_txt.Visible = true;
}
}
/// <summary>
/// 加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddStudent_Load(object sender, EventArgs e)
{
//窗口圆角化
this.Region = new Admin(null, null).Round(this.Width, this.Height, 20);
//当修改页面显示时，在加载相应的信息 如果是添加信息时，该页面就不会加载信息
if (this.AddStudent_pal.Visible && this.Updata_btn.Visible)
{
//修改页面加载学生的信息
Modle model = dl.showInfoSingle(static_SQL_CRUD.StudentInfoSingle());
//学生信息
this.stuid_txt.Text = model.stuid;
this.stuname_txt.Text = model.stuname;
this.stuclass_txt.Text = model.stuclass;
this.stuage_txt.Text = model.stuage;
this.major_txt.Text = model.major;
this.dapartment_txt.Text = model.dapartment;
this.Studentpassword_txt.Text = model.password;
this.StudentNote_txt.Text = model.note;
}
if (this.AddTeacher_pal.Visible && this.Updata_btn.Visible)
{
//修改页面加载老师的信息
Modle teacherInfo = dl.showInfoSingle(static_SQL_CRUD.TeacherInfoSingle());
//老师信息
this.teacherid_txt.Text = teacherInfo.teacherid;
this.teaname_txt.Text = teacherInfo.teaname;
this.teacherage_txt.Text = teacherInfo.teacherage;
this.department_txt.Text = teacherInfo.department;
this.teacherage_txt.Text = teacherInfo.teacherage;
this.Teacherpassword_txt.Text = teacherInfo.password;
this.Teachernote_txt.Text = teacherInfo.note;
}
}