/// <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);
}
}
