public MenuInfo GetById(int id)
{
MenuInfo menu = new MenuInfo();
StringBuilder sql = new StringBuilder();
sql.Append("Select Menu_Id,Menu_Name,Menu_Father_Id,Published,PreferedId,Prefered");
return menu;
}
/// <summary>
/// 添加菜单
/// </summary>
/// <param name="menu"></param>
/// <returns></returns>
public bool Add(MenuInfo menu)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into BigDog_Menu(Menu_Name,Father_Id,Link_Url)");
sql.Append("values(@Menu_Name,@Father_Id,@Link_Url)");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@Menu_Name",SqlDbType.NVarChar,50),
new SqlParameter("@Father_Id",SqlDbType.Int),
new SqlParameter("@Link_Url",SqlDbType.NVarChar,200),
};
return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}
/// <summary>
/// 添加菜单
/// </summary>
/// <param name="menu"></param>
/// <returns></returns>
public bool Add(MenuInfo menu)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into Menu(Id,MenuName,MenuFatherId,Published,PreferedId,Prefered,Link,Created_Date,Creator)");
sql.Append("values(treemenu_seq.nextval,@MenuFatherId,@Published,@PreferedId,@Prefered,@Link,@Created_Date,@Creator)");
OleDbParameter[] parms = new OleDbParameter[] {
new OleDbParameter("@MenuFatherId",OleDbType.Integer),
new OleDbParameter("@Published",OleDbType.VarChar,20),
new OleDbParameter("@PreferedId",OleDbType.Integer),
new OleDbParameter("@Link",OleDbType.VarChar,100),
new OleDbParameter("@Created_Date",OleDbType.Date),
new OleDbParameter("@Creator",OleDbType.Date)
};
return OracleHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}
/// <summary>
///根据Id获取菜单实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public MenuInfo GetById(int id)
{
MenuInfo menu = new MenuInfo();
StringBuilder sql = new StringBuilder();
sql.Append("select Id,Menu_Name,Father_Id,Link_Url,Description from BigDog_Menu");
sql.Append(" where Id=@Id");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@Id",SqlDbType.Int)
};
parms[0].Value = id;
DataTable dt = new DataTable();
dt = SQLHelper.GetDs(sql.ToString(),parms).Tables[0];
if (dt.Rows.Count > 0)
{
menu.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
menu.Menu_Name = dt.Rows[0]["Menu_Name"].ToString();
menu.Father_Id = Convert.ToInt32(dt.Rows[0]["Father_Id"].ToString());
menu.Link_Url = dt.Rows[0]["Link_Url"].ToString();
menu.Description = dt.Rows[0]["Description"].ToString();
return menu;
}
return null;
}
public static bool Update(MenuInfo menu)
{
return Dal.Update(menu);
}
public static bool Add(MenuInfo menu)
{
return Dal.Add(menu);
}
/// <summary>
/// 更新菜单实体
/// </summary>
/// <param name="menu"></param>
/// <returns></returns>
public bool Update(MenuInfo menu)
{
StringBuilder sql = new StringBuilder();
sql.Append("upate BigDog_Menu set Menu_Name=@Menu_Name,Father_Id=@Father_Id,Link_Url=@Link_Url,Description=@Description");
sql.Append(" where Id=@Id");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@Menu_Name",SqlDbType.Int),
new SqlParameter("@Father_Id",SqlDbType.VarChar,100),
new SqlParameter("@Link_Url",SqlDbType.Date),
new SqlParameter("@Description",SqlDbType.Date)
};
parms[0].Value = menu.Menu_Name;
parms[1].Value = menu.Father_Id;
parms[2].Value = menu.Link_Url;
parms[3].Value = menu.Description;
return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}