Help.SQLServerDAL/Help.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//===========================================================
//==                (c)2007 24xN Inc.                      ==
//==         QQ:6458450,Email:qwsf01115@163.com            ==
//==               Site:http://www.24xn.com                ==
//==               论坛:http://bbs.24xn.com                ==
//==                  Code By Xi.Deng                      ==
//==                     版权所有                          ==
//===========================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Help.Common;
using Help.Model;

namespace Help.SQLServerDAL
{
    public class Help
    {
        /// <summary>
        /// 取得帮助信息
        /// </summary>
        /// <param name="classid">帮助编号</param>
        /// <returns>返回数据表</returns>
        /// Code By DengXi
        public DataTable List(string classid)
        {
            string Sql = "Select * From Help Where ParentID='" + classid + "' Order By OrderID Desc";
            return SqlHelper.ExecuteTable(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 搜索(后台)
        /// </summary>
        /// <param name="key">关键字</param>
        /// <returns>返回数据表</returns>
        /// Code By DengXi
        public DataTable getSearchhelpList(string key)
        {
            if (key == "" || key == null || key == string.Empty)
                return null;
            string Sql = "Select * From Help Where Title like'%" + key + "%' Or Content like '%" + key + "%' Order By OrderID Desc";
            return SqlHelper.ExecuteTable(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 删除帮助信息
        /// </summary>
        /// <param name="id">帮助编号</param>
        /// Code By DengXi
        public void Del(string id)
        {
            SqlConnection Conn = new SqlConnection(SqlHelper.ConnectionString);
            Conn.Open();
            SqlTransaction tran = Conn.BeginTransaction();
            try
            {
                string idstr = getIDStr(id, "ClassID,ParentID", "Help");
                string Sql = "Delete From Help Where ClassID In(" + idstr + ")";