//--------------------------------------------------------------用户功能---------------------------------------------
//一、成绩管理
private void 成绩管理ToolStripMenuItem_Click(object sender, EventArgs e)
{
panel3.Visible = false;
panel4.Visible = true; //隐藏成绩与课程信息
DBlink db = new DBlink(); //创建数据库连接对象
if (db.DBconn())
{ //创建数据库连接
string Str1 = "select Id from login_info WHERE username = '******'";
Globel.Id = db.Getstringsearch(Str1);
}
db.DBclose(); //关闭数据库连接
string sql = "SELECT score_info.Id as 学号, score_info.name as 姓名,score_info.course_name as 课程,score_info.score as 成绩 FROM score_info";
if (LoginInfo.id_tag.Equals("s"))
{
BindsocreData("select score_info.Id as 学号, score_info.name as 姓名,score_info.course_name as 课程,score_info.score as 成绩 from score_info where Id = '" + Globel.Id + "'");
}
else if (LoginInfo.id_tag.Equals("t"))
{
BindsocreData(sql);
panel5.Visible = true; //教师可以管理成绩
panel6.Visible = true; //教师可以查询成绩
}
else if (LoginInfo.id_tag.Equals("ts"))
{
BindsocreData(sql);
panel6.Visible = true;//教学秘书可以查询成绩
}
}
//2.删除用户
private void 除用户ToolStripMenuItem_Click(object sender, EventArgs e)
{
DBlink db = new DBlink(); //创建数据库连接实例
if (db.DBconn())
{ //打开数据库连接
db.GetUserInfoData("select * from login_info");
}
db.DBclose(); //关闭数据库连接
dataGridView2.Rows.Clear(); //初始化dataGridView
for (int i = 0; i < LoginInfo.idList.Count; i++) //循环将数据实体类的数据存放到dataGridView中
{
int index = this.dataGridView2.Rows.Add();
//实现隔行换色
if (i % 2 == 0)
{
this.dataGridView2.Rows[index].DefaultCellStyle.BackColor = Color.Gainsboro;//双数行
}
else
{
this.dataGridView2.Rows[index].DefaultCellStyle.BackColor = Color.GhostWhite; //单数行
}
this.dataGridView2.Rows[index].Cells[0].Value = LoginInfo.idList[i]; //填充序号
this.dataGridView2.Rows[index].Cells[1].Value = LoginInfo.usernameList[i]; //填充用户名
this.dataGridView2.Rows[index].Cells[2].Value = LoginInfo.passwordList[i]; //填充密码
if (LoginInfo.id_tagList[i].Equals("s")) //根据SF的值填充用户身份
{
this.dataGridView2.Rows[index].Cells[3].Value = "学生";
}
else if (LoginInfo.id_tagList[i].Equals("t"))
{
this.dataGridView2.Rows[index].Cells[3].Value = "教师";
}
else if (LoginInfo.id_tagList[i].Equals("ts"))
{
this.dataGridView2.Rows[index].Cells[3].Value = "教学秘书";
}
else
{
this.dataGridView2.Rows[index].Cells[3].Value = "管理员";
}
}
//控制显示用户信息数据的dataGridView出现的位置
dataGridView2.Top = 25;
dataGridView2.Left = 30;
dataGridView2.Height = 350;
dataGridView2.Visible = true;//显示数据集
//控制操作的出现位置，给控件赋值
panel1.Top = 400;
panel1.Left = 30;
panel1.Visible = true; //显示删除操作面板
panel2.Visible = false; //隐藏审核操作面板
RG.Visible = false; //隐藏注册窗体
}
//更新成绩
private void button6_Click(object sender, EventArgs e)
{
ScoreInfo.id = textBox6.Text;
ScoreInfo.course_id = textBox7.Text;
ScoreInfo.score = numericUpDown1.Value.ToString();
string Str3 = "select count(*) from score_info where Id = '" + ScoreInfo.id + "'and Course_Id = '" + ScoreInfo.course_id + "'";
string str5 = "update score_info set score = '" + ScoreInfo.score + "'where Course_Id = '" + ScoreInfo.course_id + "'and Id = '" + ScoreInfo.id + "'";
DBlink db = new DBlink(); //创建数据库连接对象
DBlink db4 = new DBlink(); //创建数据库连接对象
if (db4.DBconn())
{ //连接数据库
string Str1 = "select Course_name from course_information where Course_Id = " + ScoreInfo.course_id;
string Str2 = "select name from user_information where Id = " + ScoreInfo.id;
ScoreInfo.course_name = db4.Getstringsearch(Str1);
ScoreInfo.name = db4.Getstringsearch(Str2);
//MessageBox.Show(ScoreInfo.course_id + ScoreInfo.course_name);
int count = db4.GetIntsearch(Str3);
if (count == 0)
{
string str4 = "insert into score_info(name,Id,Course_name,Course_Id,score) " +
"values('" + ScoreInfo.name + "','" + ScoreInfo.id + "','" + ScoreInfo.course_name + "','" + ScoreInfo.course_id + "','"
+ ScoreInfo.score + "');";
bool bool6 = db4.UpdataDeletAdd(str4);// 执行查询
if (bool6)
{
MessageBox.Show("更新记录成功！");
}
else
{
MessageBox.Show("更新记录失败！");
}
}
else
{
bool bool7 = db4.UpdataDeletAdd(str5);// 执行查询
if (bool7)
{
MessageBox.Show("更新记录成功！");
}
else
{
MessageBox.Show("更新记录失败！");
}
}
}
db4.DBclose();//关闭数据连接
string sql = "SELECT score_info.Id as 学号, score_info.name as 姓名,score_info.course_name as 课程,score_info.score as 成绩 FROM score_info";
BindsocreData(sql);
}
//删除用户的按钮事件
private void button2_Click(object sender, EventArgs e)
{
string str = "delete from login_info where username='******' and SF!= 'a'";
DBlink db = new DBlink();
if (db.DBconn())
{
if (db.UpdataDeletAdd(str))//修改当前用户的tag标志
{
DialogResult dr = MessageBox.Show("用户" + textBox1.Text + "删除成功！", "标题", MessageBoxButtons.OK, MessageBoxIcon.Question);
除用户ToolStripMenuItem_Click(null, null); //重新加载数据
//将用户输入的内容和提示信息文本置空
textBox2.Text = "";
label5.Text = "";
}
}
}
//管理员输入审核用户名时验证该用户是否存在，并提示
private void textBox2_KeyUp(object sender, KeyEventArgs e)
{
DBlink db = new DBlink();
if (db.DBconn())
{
string str = "select * from login_info where username='******'";
if (db.search(str))
{
label5.Text = "*删除用户！" + textBox2.Text + "?请点击删除按钮";
button2.Enabled = true;
}
else
{
label5.Text = "*用户不存在！";
button2.Enabled = false;
}
}
}
//管理员输入审核用户名时验证该用户是否存在，并提示
private void textBox1_KeyUp(object sender, KeyEventArgs e)
{
DBlink db = new DBlink();
if (db.DBconn())
{
string str = "select * from login_info where tag=0 and username='******'";
if (db.search(str))
{
label3.Text = "*该用户未审核！";
button1.Enabled = true;
}
else
{
label3.Text = "*用户不存在！";
button1.Enabled = false;
}
}
}
//退出
//删除成绩
private void button7_Click(object sender, EventArgs e)
{
ScoreInfo.id = textBox6.Text;
ScoreInfo.course_id = textBox7.Text;
string delsql = "delete from score_info where Id= '" + ScoreInfo.id + "'and Course_Id = '" + ScoreInfo.course_id + "'";
DBlink db4 = new DBlink(); //创建数据库连接对象
if (db4.DBconn())
{ //连接数据库
if (db4.UpdataDeletAdd(delsql))
{
MessageBox.Show("删除记录成功！");
}
else
{
MessageBox.Show("删除失败！");
}
}
db4.DBclose();//关闭数据连接
string sql = "SELECT score_info.Id as 学号, score_info.name as 姓名,score_info.course_name as 课程,score_info.score as 成绩 FROM score_info";
BindsocreData(sql);
}
