/// <summary>
/// 根據roleNo 查詢角色對應的菜單
/// </summary>
/// <param name="roleNo"></param>
/// <returns></returns>
public List <RoleRelMenu> queryRoleRelMenuList(string roleNo)
{
List <RoleRelMenu> roleRelMenuList = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,role_no,menu_name,menu_desc,op_user,create_time,update_user,update_time FROM t_role_relmemu where role_no=@roleNo where del_flag is null");
MySqlParameter[] parameters =
{
new MySqlParameter("@roleNo", MySqlDbType.VarChar, 900),
};
parameters[0].Value = roleNo;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
roleRelMenuList = new List <RoleRelMenu>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
RoleRelMenu roleRelMenu = new RoleRelMenu();
roleRelMenu.Uuid = dr["uuid"].ToString();
roleRelMenu.Roleno = dr["role_no"].ToString();
roleRelMenu.MenuName = dr["menu_name"].ToString();
roleRelMenu.MenuDesc = dr["menu_desc"].ToString();
roleRelMenu.Opuser = dr["op_user"].ToString();
roleRelMenu.Createtime = dr["create_time"].ToString();
roleRelMenu.UpdateUser = dr["update_user"].ToString();
roleRelMenu.Updatetime = dr["update_time"].ToString();
roleRelMenuList.Add(roleRelMenu);
}
}
return(roleRelMenuList);
}
/// <summary>
/// 根據id查詢 roleRelMenu
/// </summary>
/// <param name="uuid"></param>
/// <returns></returns>
public RoleRelMenu queryMenuInfoById(string uuid)
{
RoleRelMenu roleRelMenu = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,role_no,menu_name,menu_desc,op_user,create_time FROM t_role_relmemu where uuid=@uuid AND del_flag is null");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900),
};
parameters[0].Value = uuid;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
roleRelMenu = new RoleRelMenu();
roleRelMenu.Uuid = ds.Tables[0].Rows[0]["uuid"].ToString();
roleRelMenu.Roleno = ds.Tables[0].Rows[0]["role_no"].ToString();
roleRelMenu.MenuName = ds.Tables[0].Rows[0]["menu_name"].ToString();
roleRelMenu.MenuDesc = ds.Tables[0].Rows[0]["menu_desc"].ToString();
roleRelMenu.Opuser = ds.Tables[0].Rows[0]["op_user"].ToString();
roleRelMenu.Createtime = ds.Tables[0].Rows[0]["create_time"].ToString();
}
return(roleRelMenu);
}
/// <summary>
/// 增加角色對應的菜單
/// </summary>
/// <param name="roleRelMenu"></param>
/// <returns></returns>
public bool saveRoleRelMenu(RoleRelMenu roleRelMenu)
{
bool saveMark = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_role_relmemu (uuid,role_no,menu_name,menu_desc,op_user,create_time)");
strSql.Append("values(@uuid,@roleno,@menuName,@menuDesc,@opuser,@createtime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900),
new MySqlParameter("@roleno", MySqlDbType.VarChar, 900),
new MySqlParameter("@menuName", MySqlDbType.VarChar, 900),
new MySqlParameter("@menuDesc", MySqlDbType.VarChar, 900),
new MySqlParameter("@opuser", MySqlDbType.VarChar, 900),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 900)
};
parameters[0].Value = roleRelMenu.Uuid;
parameters[1].Value = roleRelMenu.Roleno;
parameters[2].Value = roleRelMenu.MenuName;
parameters[3].Value = roleRelMenu.MenuDesc;
parameters[4].Value = roleRelMenu.Opuser;
parameters[5].Value = roleRelMenu.Createtime;
int rows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
saveMark = true;
}
else
{
saveMark = false;
}
return(saveMark);
}
public RoleRelMenu saveRoleRelMenu(RoleRelMenu roleRelMenu)
{
RoleRelMenu reRoleRelMenu = null;
roleRelMenu.Uuid = Auxiliary.Get_UUID();
roleRelMenu.Opuser = Auxiliary.loginName;
roleRelMenu.Createtime = Auxiliary.Get_CurrentTime();
if (roleRelMenuDao.saveRoleRelMenu(roleRelMenu))
{
reRoleRelMenu = roleRelMenuDao.queryMenuInfoById(roleRelMenu.Uuid);
}
return(reRoleRelMenu);
}
/// <summary>
/// 檢查該角色是否存在該菜單
/// </summary>
/// <param name="menuNo"></param>
/// <returns></returns>
public bool exists(RoleRelMenu roleRelMenu)
{
bool repeatJudge = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_role_relmemu where role_no=@roleNo and menu_name=@menuName and del_flag is null");
MySqlParameter[] parameters =
{
new MySqlParameter("@roleNo", MySqlDbType.VarChar, 900),
new MySqlParameter("@menuName", MySqlDbType.VarChar, 900),
};
parameters[0].Value = roleRelMenu.Roleno;
parameters[1].Value = roleRelMenu.MenuName;
int rows = int.Parse(SQLHelper.ExecuteScalar(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters).ToString().Trim());
if (rows > 0)
{
repeatJudge = true;
}
return(repeatJudge);
}
private void button1_Click(object sender, EventArgs e)
{
RoleRelMenu roleRelMenu = new RoleRelMenu();
roleRelMenu.Roleno = this.comboBox1.SelectedValue.ToString().Trim();
roleRelMenu.MenuName = this.comboBox2.SelectedValue.ToString().Trim();
roleRelMenu.MenuDesc = this.comboBox2.Text;
if (!roleRelMenuService.checkAdd(roleRelMenu))
{
RoleRelMenu reRoleRelMenu = roleRelMenuService.saveRoleRelMenu(roleRelMenu);
if (reRoleRelMenu != null)
{
this.displayList(roleRelMenu.Roleno);
MessageBox.Show("菜單添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("該角色已經存在該菜單！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 檢查該菜單是否已經添加
/// </summary>
/// <param name="roleRelMenu"></param>
/// <returns></returns>
public bool checkAdd(RoleRelMenu roleRelMenu)
{
return(roleRelMenuDao.exists(roleRelMenu));
}
