using System; using System.Collections.Generic; using System.Text; using System.Windows.Forms; using System.Data; using System.Data.OleDb; namespace testAlarm { //==============一个基本的类以供其他窗口调用=================== class BaseClass { //==============全局变量,判定用户账号=================== public static String globalUserID = ""; public static OleDbConnection DBCon() { // String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=./data/Alarm.mdb"; String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/data/Alarm.mdb"; return new OleDbConnection(connectionString); } //==============检查用户账号和密码=================== public static bool checkUser(string userID, string userPwd) { OleDbConnection conn = BaseClass.DBCon(); conn.Open(); OleDbCommand cmd = new OleDbCommand("select count(*) from tb_user where userID='" + userID + "' and userPwd='" + userPwd + "'", conn); int i = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); if (i > 0) { return true; } else { return false; } } //===================判断是否是已经存在的用户=========== public static bool isUser(string userID) { OleDbConnection conn = BaseClass.DBCon(); conn.Open(); OleDbCommand cmd = new OleDbCommand("select count(*) from tb_user where userID='" + userID + "'", conn); int i = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); if (i > 0) { return true; } else { return false; } } //==============根据sql查询语句对用户表进行简单的操作=================== public static bool operateData(string strsql) { OleDbConnection conn = DBCon(); conn.Open(); OleDbCommand cmd = new OleDbCommand(strsql, conn); cmd.ExecuteNonQuery(); conn.Close(); return true; } //==============添加用户的全局函数=================== public static bool AddUser(string userID, string userName, string userRole, string userPwd) { String str = "insert into tb_user(userID,userName,userRole,userPwd) values ('" + userID + "','" + userName + "','" + userRole + "','" + userPwd +"')"; BaseClass.operateData(str); return true; } //==============改变用户密码=================== public static bool changePwd(string userID,string userPwd) { String str = "update tb_user set userPwd='" + userPwd + "' where userID='" + userID + "'"; BaseClass.operateData(str); return true; } //==============显示数据=================== public static void showData(DataGridView dataGV, string sql) { OleDbConnection conn = DBCon(); conn.Open(); DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(sql, conn); da.Fill(ds, "ds"); dataGV.DataSource = ds.Tables["ds"].DefaultView; } //==============判断特定用户的角色=================== public static string getRoleFromID(string ID) { string strSQL = "select userRole from tb_user where userID='"+ID+"'"; OleDbConnection conn = DBCon(); conn.Open(); OleDbCommand cmd = new OleDbCommand(strSQL, conn); OleDbDataReader sdr=cmd.ExecuteReader(); sdr.Read(); return sdr["userRole"].ToString().Trim(); } } }