menus.cs

这个是个未完成品 演示地址：http://www.yyzyq.com 仅以此例给正在学习编程爱好.net的朋友 希望能给大家带来帮助

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Menu 的摘要说明
/// </summary>
public class Menus:SqlDataBase
{
	public Menus()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 返回类别视图
    /// </summary>
    /// <returns></returns>
    public DataView Dv_Menu()
    {
        return GetDv("select * from v_menu_small order by orderby");
    }

    /* --------------------------------- 大类 -----------------------------*/

    /// <summary>
    /// 返回大类菜单
    /// </summary>
    /// <returns></returns>
    public DataView Dv_BigMenu()
    {
        return GetDv("select * from v_menu_big order by orderby");
    }    

    /// <summary>
    /// 通过大类ID返回大类内容
    /// </summary>
    /// <param name="BigId"></param>
    /// <returns></returns>
    public DataView GetMenu_Big(string BigId)
    {
        return GetDv("select * from v_menu_Small where bigid=" + BigId);
    }
       

    /// <summary>
    /// 通过大类ID获取管理ID
    /// </summary>
    /// <param name="BigId"></param>
    /// <returns></returns>
    public string GetBigAdmin(string BigId)
    {
        return RunSqlReturn("select admin from menu_big where id=" + BigId);
    }

    /// <summary>
    /// 添加大类菜单
    /// </summary>
    /// <param name="name">名称</param>
    /// <param name="order">顺序</param>
    public void AddBig(string name, string order)
    {
        string strSql = "insert into Menu_Big (name,orderby)values('" + name + "','" + order + "')";
        RunSql(strSql);
    }

    /// <summary>
    /// 修改大类菜单
    /// </summary>
    /// <param name="id">编号</param>
    /// <param name="name">名称</param>
    /// <param name="order">顺序</param>
    public void ChangeBig(string id, string name, string order)
    {
        string strSql = "update Menu_Big set name='" + name + "',orderby='" + order + "' where id =" + id;
        RunSql(strSql);
    }

    /// <summary>
    /// 删除大类菜单
    /// </summary>
    /// <param name="id">编号</param>
    public void DelBig(string id)
    {
        string strSql = "delete Menu_Big where id=" + id;
        RunSql(strSql);
    }

    /// <summary>
    /// 添加大类管理
    /// </summary>
    /// <param name="bigid">大类ID</param>
    /// <param name="id">用户ID</param>
    public void AddBigAdmin(string bigid, string id)
    {
        SqlParameter[] prams ={
									   MakeInParam("@bigid",SqlDbType.Int ,4,bigid),
									   MakeInParam("@id",SqlDbType.Int,4,id)
							    };
        RunProc("Up_AddBigAdmin", prams);
        
    }


    /* ---------------------------- 小类 --------------------------*/
     
    /// <summary>
    /// 添加小类管理
    /// </summary>
    /// <param name="bigid">小类ID</param>
    /// <param name="id">用户ID</param>
    public void AddSmallAdmin(string smallid, string id)
    {
        SqlParameter[] prams ={
									   MakeInParam("@smallid",SqlDbType.Int ,4,smallid),
									   MakeInParam("@id",SqlDbType.Int,4,id)
							    };
        RunProc("Up_AddSmallAdmin", prams);
        
    }
    /// <summary>
    /// 删除小类菜单
    /// </summary>
    /// <param name="id"></param>
    public void delSmall(string id)
    {
        string strSql = "delete Menu_Small where id =" + id;
        RunSql(strSql);
    }

    /// <summary>
    /// 通过小类ID返回小类内容
    /// </summary>
    /// <param name="SmallId">小类ID</param>
    /// <returns></returns>
    public DataView GetMenu_Small(string SmallId)
    {
        return GetDv("select * from v_menu_Small where id=" + SmallId);
    }

    /// <summary>
    /// 通过小类ID获取管理ID
    /// </summary>
    /// <param name="SmallId">小类ID</param>
    /// <returns></returns>
    public string GetAdmin(string SmallId)
    {
        return RunSqlReturn("select admin from menu_small where id=" + SmallId);
    }

    /// <summary>
    /// 返回小类菜单
    /// </summary>
    /// <returns></returns>
    public DataView DvSmallMenu()
    {
        return GetDv("select * from v_menu_small order by orderby,bigid");
    }

    /// <summary>
    /// 添加小类
    /// </summary>
    /// <param name="name">名称</param>
    /// <param name="description">描述</param>
    /// <param name="pic">图片地址</param>
    /// <param name="bigid">大类ID</param>
    public void AddSmall(string name, string description, string pic, string bigid)
    {
        string strSql = "insert into menu_small (name,description,pic,bigid)values('" + name + "','" + description + "','" + pic + "','" + bigid + "')";
        RunSql(strSql);
    }

    /// <summary>
    /// 修改小类
    /// </summary>
    /// <param name="id">编号</param>
    /// <param name="name">名称</param>
    /// <param name="description">描述</param>
    /// <param name="pic">图片地址</param>
    /// <param name="bigid">大类ID</param>
    public void ChangeSmall(string id ,string name,string description,string pic,string bigid)
    {
        string strSql = "update menu_small set name ='" + name + "',description='" + description + "',pic='" + pic + "',bigid=" + bigid + " where id =" + id;
        RunSql(strSql);
    }

    /// <summary>
    /// 通过大类ID返回小类
    /// </summary>
    /// <param name="bigid">大类ID</param>
    /// <returns></returns>
    public DataView DvSmall_Big(string bigid)
    {
        return GetDv("select * from menu_small where bigid=" + bigid);
    }

}