/// <summary> /// 插入新的二级菜单 /// </summary> /// <param name="newMenuID"></param> public void insertNewSecondMenu(int newMenuID, MenuSecond ms , int parentID) { MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); try { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @"INSERT INTO `sh_data`.`menu` (`menu_id`, `menu_parent_id`, `menu_cn_name`, `menu_power`, `menu_url`) VALUES (?newMenuID, ?parentID, ?menuCnName, ?menuPower, ?menuUrl);"; cmd.Parameters.Add("?newMenuID", MySqlDbType.Int32).Value = newMenuID; cmd.Parameters.Add("?menuCnName", MySqlDbType.VarChar).Value = ms.secondMenuName; cmd.Parameters.Add("?menuPower", MySqlDbType.VarChar).Value = ms.secondMenuPower; cmd.Parameters.Add("?menuUrl", MySqlDbType.VarChar).Value = ms.secondMenuNameUrl; cmd.Parameters.Add("?parentID", MySqlDbType.Int32).Value = parentID; cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } }
/// <summary> /// 更新二级菜单 /// </summary> /// <param name="newMenuID"></param> public void UpdateSecondMenu(MenuSecond ms,int parentID) { MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); try { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @"UPDATE `sh_data`.`menu` SET `menu_cn_name`=?menuCnName, `menu_power`=?menuPower, `menu_url`=?menuUrl, `freeze`=?freeze WHERE `menu_cn_name`=?menuCnName and menu_parent_id =?parentID;"; cmd.Parameters.Add("?menuCnName", MySqlDbType.VarChar).Value = ms.secondMenuName; cmd.Parameters.Add("?menuPower", MySqlDbType.VarChar).Value = ms.secondMenuPower; cmd.Parameters.Add("?menuUrl", MySqlDbType.VarChar).Value = ms.secondMenuNameUrl; cmd.Parameters.Add("?parentID", MySqlDbType.Int32).Value = parentID; cmd.Parameters.Add("?freeze", MySqlDbType.Int16).Value = ms.freezeMenu; cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } }
public void insertNewSecondMenu(string form) { Dictionary<string, string> formDictionary = JsonTools.jsonToDictionary(form); MenuSecond menuSecond = new MenuSecond(); menuSecond = JsonTools.PopulateEntityFromCollection(menuSecond, formDictionary); //取得一级菜单 DataTable dtParentMenu = gd.getSameNameMenu(menuSecond.secondMenuLevelName, 0); int parentID = 0; if (dtParentMenu.Rows.Count > 0) { parentID = Convert.ToInt32(dtParentMenu.Rows[0]["menu_id"]); } //取得二级菜单 DataTable dtSameMenuName = gd.getSameNameMenu(menuSecond.secondMenuName,parentID); if (dtSameMenuName.Rows.Count > 0) { gd.UpdateSecondMenu(menuSecond, parentID); } else { int newID = gd.GetNewMenuID(); gd.insertNewSecondMenu(newID, menuSecond, parentID); } }