//插入
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;
}
}
}
