//数据插入 public static bool insertUserInfo(UserInfoData data) { string sql = "insert into User_Login(UserID,UserName,UserPwd,UserRight) VALUE('" + data.UserID + "','" + data.UserName + "','" + data.UserPwd + "','" + "'" + data.UserRight + "')"; return(dataAccess.ExecuteSQL(sql)); }
public main() { InitializeComponent(); User.UserInfoData data = new User.UserInfoData(); data.UserName = User.Constants.UserName; ds = User.UserInfoOperation.getUserInfoAll(data); if (ds.Tables[0].Rows.Count > 0) { User.Constants.UserRight = ds.Tables[0].Rows[0]["用户权限"].ToString(); string str = "Welcome Back! \n" + "Dear:" + User.Constants.UserName + "\n Your Authority: " + User.Constants.UserRight; MessageBox.Show(str, "Welcome to WestWorld", MessageBoxButtons.OK); } if (User.Constants.UserRight.Trim() == "学生") { this.teacherUpdateToolStripMenuItem.Enabled = false; this.teacherInsertToolStripMenuItem1.Enabled = false; this.teacherDeleteToolStripMenuItem.Enabled = false; this.scoreUpdateToolStripMenuItem.Enabled = false; this.scoreDeleteToolStripMenuItem.Enabled = false; this.scoreInsertToolStripMenuItem.Enabled = false; this.courseUpdateToolStripMenuItem.Enabled = false; this.courseDeleteToolStripMenuItem.Enabled = false; this.courseInsertToolStripMenuItem.Enabled = false; this.TCUpdateToolStripMenuItem.Enabled = false; this.TCDeleteToolStripMenuItem.Enabled = false; this.studentDeleteToolStripMenuItem.Enabled = false; this.studentUpdateToolStripMenuItem.Enabled = false; this.TCInsertToolStripMenuItem.Enabled = false; this.userInfoToolStripMenuItem.Enabled = false; this.overviewToolStripMenuItem.Enabled = false; this.editRightToolStripMenuItem.Enabled = false; } if (User.Constants.UserRight.Trim() == "教师") { this.userInfoToolStripMenuItem.Enabled = false; this.editRightToolStripMenuItem.Enabled = false; this.overviewToolStripMenuItem.Enabled = false; this.teacherUpdateToolStripMenuItem.Enabled = false; this.teacherDeleteToolStripMenuItem.Enabled = false; this.TCInsertToolStripMenuItem.Enabled = false; this.TCDeleteToolStripMenuItem.Enabled = false; this.scoreInsertToolStripMenuItem.Enabled = false; this.scoreQueryToolStripMenuItem.Enabled = false; this.studentUpdateToolStripMenuItem.Enabled = false; this.studentQueryToolStripMenuItem.Enabled = false; this.studentDeleteToolStripMenuItem.Enabled = false; } }
public static DataSet GetUserInfoAll(UserInfoData data) { string sql = ""; if (data.UserName != null && data.UserName != "") { sql += "UserName='******'"; } if (data.UserRight != null && data.UserRight != "") { sql += "and UserRight='" + data.UserRight + "'"; } string sql1 = "select UserName 用户名,UserPwd 用户密码,UserRight 用户权限 from User_Login where " + sql; return(dataAccess.GetDataSet(sql1, "User_Login")); }
//数据更新 public static bool updateUserInfo(UserInfoData data) { string sql = "update User_Login set UserPwd='" + data.UserPwd + "',UserRight='" + data.UserRight + "' where UserName='******'"; return(dataAccess.ExecuteSQL(sql)); }