//验证用户登录
private void DoLogin_Click(object sender, EventArgs e)
{
DBlink db = new DBlink(); //创建数据库连接对象
PuanDuanSF.panduanshenfen(identity.SelectedIndex); //根据用户选择的值判断用户身份
if (db.DBconn())
{
//数据库连接成功
if (db.GetLoginData("select * from login_info where SF='" + quanju.sf + "'and username='******'"))
{
//用户存在
if (LoginInfo.tag == 1) //账号已被审核允许登录
{
if (Tpass.Text.Equals(LoginInfo.password)) //登录成功
{
ZhuChaiDan zcd = new ZhuChaiDan();
zcd.Show(); //显示主菜单界面
}
else //密码错误
{
label6.Text = "密码错误！";
}
}
else //账号未审核
{
label6.Text = "该账号未审核，请联系管理员";
}
}
else
{
label6.Text = "登录失败，用户名不存在！";
}
}
db.DBclose();//关闭数据库连接
}
//删除按钮
private void button2_Click(object sender, EventArgs e)
{
string delsql = "delete from user_information where Id= " + Globel.Id;
//delete from user_information where Id= 266;
DBlink db4 = new DBlink(); //创建数据库连接对象
if (db4.DBconn())
{ //连接数据库
string Str1 = "select Id from login_info WHERE username = '******'";
Globel.Id = db4.Getstringsearch(Str1);
string Str2 = "select name from user_information WHERE Id = '" + Globel.Id + "'";
if (db4.Getstringsearch(Str2).Equals(textBox2.Text))
{
if (db4.UpdataDeletAdd(delsql) && MaxValue > 0)
{
MessageBox.Show("删除记录成功！");
this.Close();
}
else
{
MessageBox.Show("删除失败！");
this.Close();
}
}
else
{
MessageBox.Show("您不能删除其他用户信息");
this.Close();
}
}
db4.DBclose();//关闭数据连接
}
//执行检查
private void textBox1_Leave(object sender, EventArgs e)
{
DBlink db = new DBlink(); //创建数据库连接对象
if (db.DBconn())
{ //连接数据库
string Str1 = "select count(*) from user_information where Id = " + textBox1.Text;
string count = db.Getstringsearch(Str1);
string Str2 = "select Id from login_info where username ='******'";
Globel.Id = db.Getstringsearch(Str2);
if (count.Equals("1"))
{
MessageBox.Show("您的信息已经录入，请移步信息维护界面");
this.Close();
}
else if (!Globel.Id.Equals(textBox1.Text))
{
MessageBox.Show("您的学号输入错误，请核对");
}
else if (Globel.Id.Equals(textBox1.Text) && count.Equals("0"))
{
bool1 = true;
}
}
db.DBclose();//关闭数据连接
}
//注册事件
private void button1_Click_1(object sender, EventArgs e)
{
DBlink db = new DBlink(); //创建数据库连接对象
if (db.DBconn()) //连接数据库
{
string str = "insert into login_info(Id,username,password,id_tag) values('" + RGnumber.Text + "','" + RGname.Text + "','" + RGpass.Text + "','" + Globel.id_tag + "');";
string info = "注册成功，请等待管理员审核！";
//如果是管理员执行的添加用户时tag直接为1,即不用审核
if (LoginInfo.isadmin)
{
info = "添加用户成功，该用户可以直接登录！";
str = "insert into login_info(Id,username,password,id_tag,tag) values('" + RGnumber.Text + "','" + RGname.Text + "','" + RGpass.Text + "','" + Globel.id_tag + "','" + 1 + "');";
}
if (db.UpdataDeletAdd(str))
{
DialogResult dr = MessageBox.Show(info, "标题", MessageBoxButtons.OK, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
this.Visible = false;//隐藏当前窗口
}
}
}
db.DBclose();//关闭数据连接
}
double[] y = new double[50]; //备纤衰耗，作为y轴
public BeiXianShuaiHao()
{
InitializeComponent();
try
{
#region 得到光纤链路表
DBlink db = new DBlink();
if (db.DBcon()) //填充Pname 数组 删除后显示combox1.text
{
db.Get_route1(); //得到光纤链路名称
}
db.DBclose();
// 已有节点显示下拉列表3.Items.Clear();//清空再刷新
route_comboBox3.Items.Clear();
for (int i = 0; i < route.route_list.Count; i++)
{
route_comboBox3.Items.Add(route.route_list[i].ToString());
}
// 已有节点显示下拉列表3.Items.Add(point_data.pname[i].ToString());
#endregion
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error");
}
}
//选择线路
private void route_comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
date1_comboBox1.Items.Clear();
date2_comboBox1.Items.Clear();
DBlink db = new DBlink();
rn = route_comboBox3.Text;
if (db.DBcon()) //填充日期
{
db.Get_date1(rn); //得到某一线路光纤衰耗日期信息
}
db.DBclose();
date1_comboBox1.Items.Clear();//清空日期再刷新
date2_comboBox1.Items.Clear();
for (int i = 0; i < date.dateset.Count; i++)
{
date1_comboBox1.Items.Add(date.dateset[i]);
date2_comboBox1.Items.Add(date.dateset[i]);
}
// 已有节点显示下拉列表3.Items.Clear();//清空再刷新
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button5_Click_1(object sender, EventArgs e)
{
course_info.course_id = textBox5.Text;
course_info.course_name = textBox6.Text;
course_info.course_type = comboBox2.SelectedItem.ToString();
course_info.Obligatory = radioButton3.Checked ? "必修" : "选修";
course_info.credit = domainUpDown4.Text;
course_info.Theoretical_hours = domainUpDown5.Text;
course_info.Experimental_hours = domainUpDown6.Text;
course_info.id = textBox7.Text;
string uptsql;
uptsql = "update course_information set course_name='" + course_info.course_name + "', course_type='" + course_info.course_type + "', Obligatory='" + course_info.Obligatory +
"', credit='" + course_info.credit + "', Theoretical_hours='" + course_info.Theoretical_hours + "', Experimental_hours ='" + course_info.Experimental_hours +
"', Id='" + course_info.id + "'where Course_Id=" + course_info.course_id;
DBlink db3 = new DBlink(); //创建数据库连接对象
if (db3.DBconn())
{ //连接数据库
if (db3.UpdataDeletAdd(uptsql))
{
MessageBox.Show("课程信息更新成功", "更新成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("未更新，请检查！", "无更新", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
db3.DBclose();//关闭数据连接
}
private void button6_Click_1(object sender, EventArgs e)
{
course_info.course_id = textBox5.Text;
course_info.course_name = textBox6.Text;
course_info.course_type = comboBox2.SelectedItem.ToString();
course_info.Obligatory = radioButton3.Checked ? "必修" : "选修";
course_info.credit = domainUpDown4.Text;
course_info.Theoretical_hours = domainUpDown5.Text;
course_info.Experimental_hours = domainUpDown6.Text;
course_info.id = textBox7.Text;
string delsql = "delete from course_information where Course_Id= " + course_info.course_id;
//delete from user_information where Id= 266;
DBlink db4 = new DBlink(); //创建数据库连接对象
if (db4.DBconn())
{ //连接数据库
if (db4.UpdataDeletAdd(delsql))
{
MessageBox.Show("删除记录成功！");
this.Close();
}
else
{
MessageBox.Show("删除失败！");
this.Close();
}
}
db4.DBclose();//关闭数据连接
}
public List <User> getList()
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
List <User> list = dBLink.getUserList();
dBLink.DBclose();
return(list);
}
public List <Department> getDepartmentListByAdminId(String AdminId)
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
List <Department> list = dBLink.getDepartList(AdminId);
dBLink.DBclose();
return(list);
}
public List <Member> getList(int id)
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
List <Member> list = dBLink.getMemberListByDepartmentId(id);
dBLink.DBclose();
return(list);
}
public List <Department> getList()
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
List <Department> list = dBLink.getDepartList(null);
dBLink.DBclose();
return(list);
}
public User login(String username, String password)
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
User user = dBLink.getUserByUserNamePwd(username, password);
dBLink.DBclose();
return(user);
}
private void button1_Click(object sender, EventArgs e)
{
ScoreInfo.id = textBox1.Text;
ScoreInfo.course_id = textBox2.Text;
ScoreInfo.score = textBox3.Text;
Boolean DBtag = false;
MySqlConnection sqlCnn = new MySqlConnection(); //创建数据库连接对象
MySqlCommand sqlCmd1 = new MySqlCommand(); //创建执行sql的对象
MySqlCommand sqlCmd2 = new MySqlCommand(); //创建执行sql的对象
sqlCnn.ConnectionString = "server = localhost; uid = root; pwd = 052398; database = student_manage_system;"; //连接字符串
string Str1 = "select Course_name from course_information where Course_Id = " + textBox2.Text;
string Str2 = "select name from user_information where Id = " + textBox1.Text;
try
{
sqlCnn.Open();
DBtag = true;
if (DBtag)
{
sqlCmd1.Connection = sqlCnn;
sqlCmd1.CommandText = Str1;
ScoreInfo.course_name = Convert.ToString(sqlCmd1.ExecuteScalar());// 执行查询
sqlCmd2.Connection = sqlCnn;
sqlCmd2.CommandText = Str2;
ScoreInfo.name = Convert.ToString(sqlCmd2.ExecuteScalar());// 执行查询
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error");
}
sqlCnn.Close();
//提交信息
DBlink db = new DBlink(); //创建数据库连接对象
if (db.DBconn())
{ //连接数据库
string str1 = "insert into score_info(name,Id,course_name,Course_Id,score) " +
"values('" + ScoreInfo.name + "','" + ScoreInfo.id + "','" + ScoreInfo.course_name + "','" + ScoreInfo.course_id + "','"
+ ScoreInfo.score + "');";
string info = "提交成功！";
if (db.UpdataDeletAdd(str1))
{
DialogResult dr = MessageBox.Show(info, "标题", MessageBoxButtons.OK, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
this.Visible = false;//隐藏当前窗口
}
}
}
db.DBclose();//关闭数据连接
}
public Boolean delete(String username)
{
String sql = "DELETE FROM USER WHERE username='******'";
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean update(String username, String password)
{
String sql = "UPDATE `departmental_manage_system`.`user` SET `password`='" + password + "' WHERE (`username`='" + username + "');";
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean add(String username, String password)
{
String sql = "INSERT INTO `departmental_manage_system`.`user` (`username`, `password`, `authority`,`activated`) VALUES ('" + username + "', '" + password + "', '1','1');";
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean deleteAllByDepemtId(int id)
{
String sql = "delete from member where department_id=" + id;
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean isExist(String username)
{
String sql = "select * from user where username='******'";
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.search(sql);
dBLink.DBclose();
return(res);
}
public Boolean update(int id, String name, String sex, String position, String phone, int depmtId)
{
String sql = "UPDATE `departmental_manage_system`.`member` SET `name`='" + name + "', `sex`='" + sex + "', `position`='" + position + "', `phone`='" + phone + "', `department_id`='" + depmtId + "' WHERE (`id`='" + id + "');";
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean delete(String id)
{
String sql = "delete from member where id=" + id;
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean active(String Id)
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
String sql = "UPDATE `departmental_manage_system`.`department` SET `activated`='1' WHERE (`id`='" + Id + "');";
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean delete(String Id)
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
String sql = "delete from department where id=" + Id + "";
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean add(String name, String sex, String position, String phone, int depmtId)
{
String sql = "INSERT INTO `departmental_manage_system`.`member` (`name`, `sex`, `position`, `phone`, `department_id`) " +
"VALUES ('" + name + "', '" + sex + "', '" + position + "', '" + phone + "', '" + depmtId + "');";
DBlink dBLink = new DBlink();
dBLink.DBconn();
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
private void textBox4_Leave(object sender, EventArgs e)
{
DBlink db3 = new DBlink(); //创建数据库连接对象
if (db3.DBconn())
{ //连接数据库
string Str1 = "select count(*) from course_information where Id = " + textBox7.Text;
string count = db3.Getstringsearch(Str1); // 执行查询
if (count.Equals("0"))
{
MessageBox.Show("该老师不存在，请重新输入");
}
}
db3.DBclose();//关闭数据连接
}
public Boolean apply(String Name, String Admin, String adminId)
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
if (adminId != "NULL")
{
adminId = "'" + adminId + "'";
}
String sql = "INSERT INTO `departmental_manage_system`.`department` (`name`, `admin`,`admin_id`,`activated`) VALUES ('" + Name + "', '" + Admin + "'," + adminId + ",'0');";
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
public Boolean update(int Id, String Name, String Admin, String adminId)
{
DBlink dBLink = new DBlink();
dBLink.DBconn();
if (adminId != "NULL")
{
adminId = "'" + adminId + "'";
}
String sql = "UPDATE `departmental_manage_system`.`department` SET `name`='" + Name + "', `admin`='" + Admin + "', `admin_id`=" + adminId + " WHERE (`id`='" + Id + "');";
Boolean res = dBLink.UpdataDeletAdd(sql);
dBLink.DBclose();
return(res);
}
private void RbtnSelectedcheckBox1_CheckedChanged(object sender, EventArgs e)
{
// 添加线路
DBlink db = new DBlink();
if (db.DBcon()) //填充Pname 数组
{
db.Get_guzhang_route(); //得到故障线路
}
db.DBclose();
route_comboBox1.Items.Clear();//需要修改
int i;
for (i = 0; i < guzhang.rn.Count; i++)
{
route_comboBox1.Items.Add(guzhang.rn[i].ToString());//添加线路名
}
}
//用户注册输入编号时动态检验该编号是否可用
private void RGnumber_KeyUp(object sender, KeyEventArgs e)
{
DBlink db = new DBlink(); //创建数据库连接对象
if (db.DBconn())
{ //连接数据库
string str = "select * from login_info where Id='" + RGnumber.Text + "'";
if (db.search(str))
{
label11.Text = "*该编号不可用";
}
else
{
label11.Text = "*编号可以使用";
}
}
db.DBclose();//关闭数据连接
}
//当用户输入用户名完成时验证用户名是否可以注册
private void RGname_Leave(object sender, EventArgs e)
{
DBlink db = new DBlink(); //创建数据库连接对象
if (db.DBconn()) //创建数据库连接
{
string str = "select * from login_info where id_tag='" + Globel.id_tag + "'and username='******'";
if (db.GetLoginData(str))//执行sql检测该用户是否已经被注册
{
label9.Text = "该用户已经存在!";
}
else
{
label9.Text = "恭喜，可以注册!";
}
}
db.DBclose(); //关闭数据库连接
}
