public static void ModifyT_Menu(T_Menu t_Menu)
{
string sql =
"UPDATE T_Menu " +
"SET " +
"menu_name = @menu_name, " +
"menu_url = @menu_url, " +
"status = @status, " +
"parent_menu_id = @parent_menu_id " +
"WHERE Id = @Id";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Id", t_Menu.Id),
new SqlParameter("@menu_name", DBHelper.GetValueByWhetherNull(t_Menu.Menu_name)),
new SqlParameter("@menu_url", DBHelper.GetValueByWhetherNull(t_Menu.Menu_url)),
new SqlParameter("@status", DBHelper.GetValueByWhetherNull(t_Menu.Status)),
new SqlParameter("@parent_menu_id", DBHelper.GetValueByWhetherNull(t_Menu.Parent_menu_id))
};
DBHelper.ExecuteCommand(sql, para);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static T_Menu AddT_Menu(T_Menu t_Menu)
{
string sql =
"INSERT T_Menu (menu_name, menu_url, status, parent_menu_id)" +
"VALUES (@menu_name, @menu_url, @status, @parent_menu_id)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@menu_name", DBHelper.GetValueByWhetherNull(t_Menu.Menu_name)),
new SqlParameter("@menu_url", DBHelper.GetValueByWhetherNull(t_Menu.Menu_url)),
new SqlParameter("@status", DBHelper.GetValueByWhetherNull(t_Menu.Status)),
new SqlParameter("@parent_menu_id", DBHelper.GetValueByWhetherNull(t_Menu.Parent_menu_id))
};
int newId = DBHelper.GetScalar(sql, para);
return(GetT_MenuById(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static T_Menu GetT_MenuById(int id)
{
string sql = "SELECT * FROM T_Menu WHERE Id = @Id";
try
{
SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@Id", id));
if (reader.Read())
{
T_Menu t_Menu = new T_Menu();
try{
t_Menu.Id = (int)reader["Id"];
}catch
{}
try{
t_Menu.Menu_name = (string)reader["menu_name"];
}catch
{}
try{
t_Menu.Menu_url = (string)reader["menu_url"];
}catch
{}
try{
t_Menu.Status = (bool)reader["status"];
}catch
{}
try{
t_Menu.Parent_menu_id = (int)reader["parent_menu_id"];
}catch
{}
reader.Close();
return(t_Menu);
}
else
{
reader.Close();
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private static List <T_Menu> GetT_MenusBySql(string sql, params SqlParameter[] values)
{
List <T_Menu> list = new List <T_Menu>();
try
{
DataTable table = DBHelper.GetDataSet(sql, values);
foreach (DataRow row in table.Rows)
{
T_Menu t_Menu = new T_Menu();
try{
t_Menu.Id = (int)row["Id"];
}catch
{}
try{
t_Menu.Menu_name = (string)row["menu_name"];
}catch
{}
try{
t_Menu.Menu_url = (string)row["menu_url"];
}catch
{}
try{
t_Menu.Status = (bool)row["status"];
}catch
{}
try{
t_Menu.Parent_menu_id = (int)row["parent_menu_id"];
}catch
{}
list.Add(t_Menu);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static void DeleteT_Menu(T_Menu t_Menu)
{
DeleteT_MenuById(t_Menu.Id);
}
public static void DeleteT_Menu(T_Menu t_Menu)
{
DeleteT_MenuByMenu_url(t_Menu.Menu_url);
}
