//插入 public bool InsertUserInfo(UserInfoData data) { string sql = "insert into userinfo(userid," + "userpwd,userlevel) values('" + data.Userid + "','" + data.Userpwd + "','" + data.Userlevel + "')"; DataAccess da = new DataAccess(); return(da.ExecuteSQL(sql)); }
//修改 public bool UpdateUser(UserInfoData data) { string sql = "update userinfo set userid='" + data.Userid + "',userpwd='" + data.Userpwd + "',userlevel='" + data.Userlevel + "'" + " where userid='" + data.Userid + "'"; DataAccess da = new DataAccess(); return(da.ExecuteSQL(sql)); }
//未修改密码使用 public static DataSet GetUserInfoAll(UserInfoData data) { string sql = "select * from userinfo where 1=1"; string s = ""; if (data.Userid != "" && data.Userid != null) { s += " and userid='" + data.Userid + "'"; } if (data.Userlevel != "" && data.Userlevel != null) { s += " and userlevel='" + data.Userlevel + "'"; } sql += s; DataAccess da = new DataAccess(); return(da.GetDataSet(sql, "userinfo")); }
public Form1() { InitializeComponent(); Classes.UserInfoData data = new Classes.UserInfoData(); data.Userid = Classes.Constants.Username; DataSet ds = Classes.UserInfoOperation.GetUserInfoAll(data); if (ds.Tables[0].Rows.Count > 0) { //获取用户身份 Classes.Constants.Userlevel = ds.Tables[0].Rows[0]["Userlevel"].ToString(); //登陆身份是学生,设置某些模块不可用 if (Classes.Constants.Userlevel == "学生") { this.用户修改ToolStripMenuItem.Enabled = false; this.用户删除ToolStripMenuItem.Enabled = false; this.用户增加ToolStripMenuItem.Enabled = false; this.成绩信息添加ToolStripMenuItem.Enabled = false; this.成绩信息删除ToolStripMenuItem.Enabled = false; this.成绩信息修改ToolStripMenuItem.Enabled = false; this.课程信息删除ToolStripMenuItem.Enabled = false; this.课程信息添加ToolStripMenuItem.Enabled = false; this.课程信息修改ToolStripMenuItem.Enabled = false; this.班级信息删除ToolStripMenuItem.Enabled = false; this.班级信息添加ToolStripMenuItem.Enabled = false; this.班级信息修改ToolStripMenuItem.Enabled = false; this.学生信息删除ToolStripMenuItem.Enabled = false; this.学生信息增加ToolStripMenuItem.Enabled = false; this.学生信息修改ToolStripMenuItem.Enabled = false; this.专业信息删除ToolStripMenuItem.Enabled = false; this.专业信息添加ToolStripMenuItem.Enabled = false; this.专业信息修改ToolStripMenuItem.Enabled = false; this.教师信息删除ToolStripMenuItem.Enabled = false; this.教师信息添加ToolStripMenuItem.Enabled = false; this.教师信息修改ToolStripMenuItem.Enabled = false; } //登陆身份是任课教师,设置某些模块不可用 else if (Classes.Constants.Userlevel == "教师") { this.用户修改ToolStripMenuItem.Enabled = false; this.用户删除ToolStripMenuItem.Enabled = false; // this.用户增加ToolStripMenuItem.Enabled = false; this.成绩信息删除ToolStripMenuItem.Enabled = false; this.成绩信息修改ToolStripMenuItem.Enabled = false; //this.成绩信息添加ToolStripMenuItem.Enabled = false; this.课程信息删除ToolStripMenuItem.Enabled = false; // this.课程信息添加ToolStripMenuItem.Enabled = false; this.课程信息修改ToolStripMenuItem.Enabled = false; this.班级信息删除ToolStripMenuItem.Enabled = false; //this.班级信息添加ToolStripMenuItem.Enabled = false; this.班级信息修改ToolStripMenuItem.Enabled = false; this.学生信息删除ToolStripMenuItem.Enabled = false; //this.学生信息增加ToolStripMenuItem.Enabled = false; this.学生信息修改ToolStripMenuItem.Enabled = false; this.专业信息删除ToolStripMenuItem.Enabled = false; //this.专业信息添加ToolStripMenuItem.Enabled = false; this.专业信息修改ToolStripMenuItem.Enabled = false; this.教师信息删除ToolStripMenuItem.Enabled = false; // this.教师信息添加ToolStripMenuItem.Enabled = false; this.教师信息修改ToolStripMenuItem.Enabled = false; } } }