private void Button3_Click(object sender, EventArgs e)
{
string sqlphoto = "select photo from student where scode = '" + this.stu.scode + "';";
SqlDataReader sqlData = YRHelper.GetDataReader(sqlphoto);
sqlData.Read();
this.picPath = Application.StartupPath.Replace("bin\\Debug", "") + sqlData["photo"].ToString().Replace("~", "Resources");
FileStream fs = new FileStream(this.picPath, FileMode.Open, FileAccess.Read);
fs.Close();
fs.Dispose();
try
{
pictureBox1.Image = Image.FromStream(fs);
}
catch { }
if (this.newPath != this.picPath && newPath != null)
{
File.Copy(newPath, picPath, true);
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("对不起，修改失败！");
}
}
private void OpenForm(string sql, string type)
{
SqlDataReader sqlData = YRHelper.GetDataReader(sql);
if (sqlData.HasRows)
{
switch (type)
{
case "student":
FrmStudent stu = new FrmStudent(txtAccount.Text);
stu.Show();
this.Hide();
break;
case "teacher":
FrmTeacher tea = new FrmTeacher(txtAccount.Text);
tea.Show();
this.Hide();
break;
case "admin":
FrmAdmin admin = new FrmAdmin(txtAccount.Text);
admin.Show();
this.Hide();
break;
}
}
else
{
MessageBox.Show("登录失败，请检查账号或密码！");
}
sqlData.Close();
}
private void Button1_Click(object sender, EventArgs e)
{
string strselect = "SELECT \n" +
" course.number 课程号, \n" +
" course.cname 课程中文名, \n" +
" course.ename 课程英文名, \n" +
" course.score 学分, \n" +
" course.chour 周理论学时, \n" +
" course.lhour 周实验学时, \n" +
" course.tchour 理论总学时, \n" +
" course.tlhour 实验总学时 \n" +
" FROM course \n" +
" WHERE";
if (comboBox2.Text == "模糊查询")
{
if (comboBox1.Text == "课程号")
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " number like '%" + textBox1.Text.Trim() + "%'";
}
}
else
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " cname like '%" + textBox1.Text.Trim() + "%'";
}
}
}
else
{
if (comboBox1.Text == "课程号")
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " number = '" + textBox1.Text.Trim() + "'";
}
}
else
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " cname = '" + textBox1.Text.Trim() + "'";
}
}
}
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
dataGridView1.DataSource = YRHelper.GetFillData(strselect);
}
else
{
MessageBox.Show("不可为空");
textBox1.Clear();
}
}
private void PictureBox2_Click(object sender, EventArgs e)
{
string sqlphoto = "select photo from student where scode = '" + this.Stu.scode + "';";
SqlDataReader sqlData = YRHelper.GetDataReader(sqlphoto);
sqlData.Read();
string s = Application.StartupPath.Replace("bin\\Debug", "") + sqlData["photo"].ToString().Replace("~", "Resources");
pictureBox1.Image = Image.FromFile(s);
}
private void Button5_Click(object sender, EventArgs e)
{
string selectid = "select id from student where scode = '" + stu.scode + "';";
SqlDataReader sqlData1 = YRHelper.GetDataReader(selectid);
sqlData1.Read();
string strselect = "select course.id,cname,ename,score from plan_study_course,course where course.id=plan_study_course.course_id and student_id = '" + sqlData1["id"] + "' and semester_id='" + semester_id + "';";
dataGridView2.DataSource = YRHelper.GetFillData(strselect);
}
private void Button1_Click(object sender, EventArgs e)
{
string strselect = "SELECT \n" +
" student.name 姓名, \n" +
"student.scode 学号, \n" +
"student.gender 性别, \n" +
"class.name 班级 \n" +
"FROM \n" +
"student,class \n" +
"WHERE student.class_id = class.id and";
if (comboBox2.Text == "模糊")
{
if (comboBox1.Text == "学号")
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " scode like '%" + textBox1.Text.Trim() + "%'";
}
}
else
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " name like '%" + textBox1.Text.Trim() + "%'";
}
}
}
else
{
if (comboBox1.Text == "学号")
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " scode = '" + textBox1.Text.Trim() + "'";
}
}
else
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " name = '" + textBox1.Text.Trim() + "'";
}
}
}
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
dataGridView1.DataSource = YRHelper.GetFillData(strselect);
}
else
{
MessageBox.Show("不可为空");
textBox1.Clear();
}
}
private void CourseInfo_Update()
{
this.dataGridView1.DataSource = DBHelper.GetFillData("select * from course;");
string selectid = "select id from student where scode = '" + stu.scode + "';";
SqlDataReader sqlData1 = YRHelper.GetDataReader(selectid);
sqlData1.Read();
string strselect = "select course.id,cname,ename,score from plan_study_course,course where course.id=plan_study_course.course_id and student_id = '" + sqlData1["id"] + "' and semester_id='" + semester_id + "';";
dataGridView2.DataSource = YRHelper.GetFillData(strselect);
sqlData1.Close();
}
private void FrmStudent_Load(object sender, EventArgs e)
{
string sqlphoto = "select photo from student where scode = '" + this.Stu.scode + "';";
SqlDataReader sqlData = YRHelper.GetDataReader(sqlphoto);
sqlData.Read();
string s = Application.StartupPath.Replace("bin\\Debug", "") + sqlData["photo"].ToString().Replace("~", "Resources");
FileStream fs = new FileStream(s, FileMode.Open, FileAccess.Read);
pictureBox1.Image = Image.FromStream(fs);
fs.Close();
fs.Dispose();
pictureBox2.Image = Image.FromFile(Application.StartupPath.Replace("bin\\Debug", "") + "Resources\\images\\student\\timg.jpg");
}
private void Button1_Click(object sender, EventArgs e)
{
string strselect = "SELECT \n" +
" education_program.name 专业, \n" +
" education_program.objective 培养目标, \n" +
" education_program.duration 标准学制, \n" +
" education_program.degree 授予学位, \n" +
" education_program.min_credit 毕业学分要求, \n" +
" education_program.publish_year 制定年份 \n" +
" FROM \n" +
"education_program \n" +
"WHERE name = '" + comboBox1.Text + "' and publish_year = '" + comboBox2.Text + "'";
dataGridView1.DataSource = YRHelper.GetFillData(strselect);
}
private void Button1_Click(object sender, EventArgs e)
{
string strselect;
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect = "select * from course where cname like '%" + textBox1.Text.Trim() + "%'";
dataGridView1.DataSource = YRHelper.GetFillData(strselect);
}
else
{
MessageBox.Show("不可为空");
textBox1.Clear();
}
}
/// <summary>
/// 删除按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button4_Click(object sender, EventArgs e)
{
string id = this.dataGridView2.CurrentRow.Cells[0].Value.ToString();
string student_id = DBHelper.ExecuteScalar <int>("select id from student where scode='" + this.stu.scode + "';").ToString();
string strdel = "delete from plan_study_course where course_id='" + id + "' and student_id='" + student_id + "';";
if (DialogResult.Yes == MessageBox.Show("您确定要删除该门课程?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
if (YRHelper.GetExcuteNonQuery(strdel) > 0)
{
MessageBox.Show("删除成功");
}
else
{
MessageBox.Show("删除失败");
}
}
CourseInfo_Update();
}
private void UpdateStuInfo_Load(object sender, EventArgs e)
{
string s = "select * from student where scode='" + stu.scode + "';";
SqlDataReader sqlData = YRHelper.GetDataReader(s);
sqlData.Read();
this.label5.Text = sqlData["name"].ToString();
this.label6.Text = sqlData["scode"].ToString();
this.label9.Text = sqlData["gender"].ToString();
string l = "select class.name from class,student where class.id='" + sqlData["class_id"].ToString() + "' and student.class_id = class.id";
SqlDataReader sqlData2 = YRHelper.GetDataReader(l);
sqlData2.Read();
this.label7.Text = sqlData2["name"].ToString();
string k = "select major.name from class,major where class.id='" + sqlData["class_id"].ToString() + "' and major.id = class.major_id";
SqlDataReader sqlData3 = YRHelper.GetDataReader(k);
sqlData3.Read();
this.label8.Text = sqlData3["name"].ToString();
//显示学生个人信息
}
private void Button2_Click(object sender, EventArgs e)
{
string SqlStr = "Data Source=DESKTOP-R5GQMVG\\SQLEXPRESS;Initial Catalog=xk;Integrated Security=True";
con = new SqlConnection(SqlStr);
string s = "select * from student where scode='" + stu.scode + "';";
SqlDataReader sqlData = YRHelper.GetDataReader(s);
sqlData.Read();
string strsql = "Update student set password ='******' where scode='" + sqlData["scode"].ToString() + "'";
SqlCommand cmd = new SqlCommand(strsql, con);
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
int num = cmd.ExecuteNonQuery();
if (num > 0)
{
MessageBox.Show("修改成功");
textBox1.Clear();
textBox3.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("修改错误，错误原因:" + ex.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void StudentIfoQuery_Load(object sender, EventArgs e)
{
string s = "select * from student where scode='" + stu.scode + "';";
SqlDataReader sqlData = YRHelper.GetDataReader(s);
sqlData.Read();
this.label5.Text = sqlData["name"].ToString();
this.label6.Text = sqlData["scode"].ToString();
this.label9.Text = sqlData["gender"].ToString();
string l = "select class.name from class,student where class.id='" + sqlData["class_id"].ToString() + "' and student.class_id = class.id";
SqlDataReader sqlData2 = YRHelper.GetDataReader(l);
sqlData2.Read();
this.label7.Text = sqlData2["name"].ToString();
string k = "select major.name from class,major where class.id='" + sqlData["class_id"].ToString() + "' and major.id = class.major_id";
SqlDataReader sqlData3 = YRHelper.GetDataReader(k);
sqlData3.Read();
this.label8.Text = sqlData3["name"].ToString();
//显示学生个人信息
dataGridView1.DataSource = YRHelper.GetFillData(s);
Style.DgvUI(dataGridView1);
}
private void Button1_Click(object sender, EventArgs e)
{
string strselect = " SELECT\n" +
"teacher.name 姓名,\n" +
"teacher.tcode 工号,\n" +
"teacher.gender 性别,\n" +
"teacher.degree 学位,\n" +
"teacher.title 职称 \n" +
"FROM\n" +
"teacher\n" +
"WHERE ";
if (comboBox2.Text == "模糊")
{
if (comboBox1.Text == "工号")
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " tcode like '%" + textBox1.Text.Trim() + "%'";
}
}
else
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " name like '%" + textBox1.Text.Trim() + "%'";
}
}
}
else
{
if (comboBox1.Text == "工号")
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " tcode = '" + textBox1.Text.Trim() + "'";
}
}
else
{
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
strselect += " name = '" + textBox1.Text.Trim() + "'";
}
}
}
if (!string.IsNullOrWhiteSpace(textBox1.Text.Trim()))
{
dataGridView1.DataSource = YRHelper.GetFillData(strselect);
}
else
{
MessageBox.Show("不可为空");
textBox1.Clear();
}
string intro = "select * from teacher where";
if (comboBox1.Text == "姓名")
{
intro += " name = '" + textBox1.Text.Trim() + "' ";
}
else
{
intro += " tcode= '" + textBox1.Text.Trim() + "'";
}
SqlDataReader reader = YRHelper.GetDataReader(intro);
if (reader.HasRows)
{
reader.Read();
richTextBox1.Text = reader["introduction"].ToString();
}
else
{
richTextBox1.Clear();
MessageBox.Show("查询条件模糊，个人简介失败");
}
}
private void Button3_Click(object sender, EventArgs e)
{
string strselect = "select * from course";
dataGridView1.DataSource = YRHelper.GetFillData(strselect);
}
