public bool saveRoleRelUser(RoleRelUser roleRelUser)
{
bool saveMark = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_role_reluser (uuid,role_no,user_id,op_user,create_time)");
strSql.Append("values(@uuid,@roleno,@userid,@opuser,@createtime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900),
new MySqlParameter("@roleno", MySqlDbType.VarChar, 900),
new MySqlParameter("@userid", MySqlDbType.VarChar, 900),
new MySqlParameter("@opuser", MySqlDbType.VarChar, 900),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 900)
};
parameters[0].Value = roleRelUser.Uuid;
parameters[1].Value = roleRelUser.Roleno;
parameters[2].Value = roleRelUser.Userid;
parameters[3].Value = roleRelUser.Opuser;
parameters[4].Value = roleRelUser.Createtime;
int rows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
saveMark = true;
}
else
{
saveMark = false;
}
return(saveMark);
}
/// <summary>
/// 保存roleRelUser
/// </summary>
/// <param name="roleRelUser"></param>
/// <returns></returns>
public bool saveRoleRelUser(RoleRelUser roleRelUser)
{
RoleRelUser reRoleRelUser = null;
roleRelUser.Uuid = Auxiliary.Get_UUID();
roleRelUser.Opuser = Auxiliary.loginName;
roleRelUser.Createtime = Auxiliary.Get_CurrentTime();
return(roleRelUserDao.saveRoleRelUser(roleRelUser));
}
private void button1_Click(object sender, EventArgs e)
{
RoleRelUser roleRelUser = new RoleRelUser();
roleRelUser.Userid = this.textBox3.Text.ToString().Trim();
roleRelUser.Roleno = this.comboBox1.SelectedValue.ToString().Trim();
if (!roleRelUserService.checkAdd(roleRelUser))
{
if (roleRelUserService.saveRoleRelUser(roleRelUser))
{
this.displayList(roleRelUser.Userid);
MessageBox.Show("角色分配成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("該用戶已經存在該角色！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool exists(RoleRelUser roleRelUser)
{
bool repeatJudge = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_role_reluser where role_no=@roleNo and user_id=@userID and del_flag is null");
MySqlParameter[] parameters =
{
new MySqlParameter("@roleNo", MySqlDbType.VarChar, 900),
new MySqlParameter("@userID", MySqlDbType.VarChar, 900),
};
parameters[0].Value = roleRelUser.Roleno;
parameters[1].Value = roleRelUser.Userid;
int rows = int.Parse(SQLHelper.ExecuteScalar(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters).ToString().Trim());
if (rows > 0)
{
repeatJudge = true;
}
return(repeatJudge);
}
/// <summary>
/// 檢查該用戶角色是否存在
/// </summary>
/// <param name="roleRelUser"></param>
/// <returns></returns>
public bool checkAdd(RoleRelUser roleRelUser)
{
return(roleRelUserDao.exists(roleRelUser));
}
