/// <summary>
/// 判断保存或删除的函数
/// </summary>
private void AddORSave()
{
if (AddSave == 0)
{
if (txtID.Text == "" || txtName.Text == "" || txtPwd.Text == "" || cobRole.SelectedValue == null)
{
MessageBox.Show("请填写完整的用户信息！");
}
else
{
if (UserBll.GetUser(txtID.Text))
{
try
{
UserInfo user = new UserInfo(txtID.Text, txtPwd.Text, txtName.Text, Convert.ToInt32(cobRole.SelectedValue));
UserBll.UserInsert(user);
MessageBox.Show("添加成功！");
}
catch (Exception ee)
{
MessageBox.Show("添加失败！" + ee);
throw;
}
}
else
{
MessageBox.Show("用户已存在！");
}
}
}
else
{
if (txtID.Text == "" || txtName.Text == "" || txtPwd.Text == "" || cobRole.SelectedValue == null)
{
MessageBox.Show("请填写完整的用户信息！");
}
else
{
if (UserBll.GetUser(txtID.Text))
{
try
{
UserInfo user = new UserInfo(txtID.Text, txtPwd.Text, txtName.Text, Convert.ToInt32(cobRole.SelectedValue));
UserBll.UserInsert(user);
MessageBox.Show("修改成功！");
}
catch (Exception ee)
{
MessageBox.Show("修改失败！" + ee);
throw;
}
}
else
{
MessageBox.Show("用户已存在！");
}
}
}
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="User">用户信息实体</param>
public void UserInsert(UserInfo User)
{
string str = "insert UserInfo(UserID,UserName,UserPwd,RoleId) values(@userID,@userName,@userPwd,@roleId)";
UserNCP(str, User, CommandType.Text);
SH.SqlPar("@userID", User.ID);
SH.SqlPar("@userName", User.UserName);
SH.SqlPar("@userPwd", User.UserPwd);
SH.SqlPar("@roleId", User.RoleId.ToString());
SH.SqlENQ();
}
/// <summary>
/// 登陆
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void labLogin_Click(object sender, EventArgs e)
{
if (txtUserID.Text==""||txtUserPwd.Text=="")
{
MessageBox.Show("请输入用户或密码！");
}
else
{
UserInfo User = new UserInfo(txtUserID.Text, txtUserPwd.Text);
try
{
if (UserBll.UserISNO(User) == 1)
{
frmStudentExam fse = new frmStudentExam(User);
User.UserName = UserBll.GetUserName(txtUserID.Text);
fse.Show();
}
else if (UserBll.UserISNO(User) == 2||UserBll.UserISNO(User)==3)
{
User.RoleId = UserBll.UserISNO(User);
User.UserName = UserBll.GetUserName(txtUserID.Text);
frmMainManage fmm = new frmMainManage(User);
fmm.Show();
}
else
{
MessageBox.Show("密码或用户名错误！");
i -= 1;
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
throw;
}
}
if (i==0)
{
this.Close();
}
}
/// <summary>
/// 更新用户密码
/// </summary>
/// <param name="User">用户信息实体</param>
public void UserPwdUpdate(UserInfo User)
{
string str = "update UserInfo set UserPwd=@userPwd where UserID=@userID";
UserNCP(str, User, CommandType.Text);
SH.SqlENQ();
}
/// <summary>
/// 获取Command和Parmeter
/// </summary>
/// <param name="str">Command语句</param>
/// <param name="User">用户信息实体</param>
void UserNCP(string str,UserInfo User,CommandType ct)
{
SH = new SqlHelp();
SH.SqlCom(str, ct);
SH.SqlPar("@userID", User.UserID);
SH.SqlPar("@userPwd", User.UserPwd);
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="User">用户信息实体</param>
/// <returns>int类型，0表示有用户，1表示没有用户</returns>
public int UserSelect(UserInfo User)
{
string str = "select RoleId from UserInfo where UserID=@userID and UserPwd=@userPwd";
UserNCP(str, User,CommandType.Text);
if (SH.SqlES()!=null)
{
return (int)SH.SqlES();
}
else
{
return 0;
}
}
/// <summary>
/// 读取用户信息
/// </summary>
/// <param name="UserID">用户编号</param>
/// <returns>UserInfo类型，存储用户信息实体</returns>
public UserInfo UserRead(string UserID)
{
SH = new SqlHelp();
string str = "select UserID,UserPwd,UserName,RoleId from UserInfo where UserID=@UserID";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserID", UserID);
DataSet ds= SH.SqlFillDs();
UserInfo user =new UserInfo( ds.Tables[0].Rows[0].ItemArray[0].ToString(), ds.Tables[0].Rows[0].ItemArray[1].ToString(), ds.Tables[0].Rows[0].ItemArray[2].ToString(), (int)ds.Tables[0].Rows[0].ItemArray[3] );
return user;
}
public frmChangePwd(UserInfo user)
{
InitializeComponent();
User = user;
}
UserInfo User; //用户实体
#endregion Fields
#region Constructors
public frmMainManage(UserInfo user)
{
User = user;
InitializeComponent();
}
/// <summary>
/// 更新用户密码
/// </summary>
/// <param name="User">用户信息实体</param>
public static void UserPwdUpdate(UserInfo User)
{
UserD = new UserDal();
UserD.UserPwdUpdate(User);
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="User">用户信息实体</param>
/// <returns>int类型，0表示有用户，1表示没有用户</returns>
public static int UserISNO(UserInfo User)
{
UserD = new UserDal();
return UserD.UserSelect(User);
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="User">用户信息实体</param>
public static void UserInsert(UserInfo User)
{
UserD = new UserDal();
UserD.UserInsert(User);
}
UserInfo User; //用户信息实体
#endregion Fields
#region Constructors
public frmStartExam(string str,UserInfo user)
{
selectPaper = str;
User = user;
InitializeComponent();
}
UserInfo User; //用户信息实体
#endregion Fields
#region Constructors
public frmStudentExam(UserInfo user)
{
InitializeComponent();
User = user;
}
