918博天堂

Server : Microsoft-IIS/10.0
System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586
User : jxgj ( 0)
PHP Version : 7.0.33
Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server
Directory : D:/tmp_aspnet/root/cae6aa2e/15328683/

Upload File :

Current File : D:/tmp_aspnet/root/cae6aa2e/15328683/App_Code.vywp5zcy.55.cs

?#pragma checksum "D:\wwwroot\anlian2025\wwwroot\App_Code\QQ.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "03F45BFDBD57FF04F765D73D0D55B0DE51742886"

#line 1 "D:\wwwroot\anlian2025\wwwroot\App_Code\QQ.cs"
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace WebApp.Components
{
    /// <summary>
    /// 客服系统
    /// </summary>
    public class QQ
    {
        /// <summary>
        /// 获取所有QQ
        /// </summary>
        /// <returns></returns>
        public SqlDataReader GetQQ()
        {
            Database db = new Database();
            SqlDataReader dr = null;
            db.RunProc("Pr_GetQQ", out dr);

            return (dr);
        }
        /// <summary>
        /// 获取开启的QQ
        /// </summary>
        /// <returns></returns>
        public SqlDataReader GetQQState()
        {
            Database db = new Database();
            SqlDataReader dr = null;
            db.RunProc("Pr_GetQQState", out dr);

            return (dr);
        }
        /// <summary>
        /// 获取单个QQ
        /// </summary>
        /// <param name="intID"></param>
        /// <returns></returns>
        public SqlDataReader GetSingleQQ(int intID)
        {
            Database db = new Database();
            SqlDataReader dr = null;
            SqlParameter[] param = { db.CreateInParam("@Id", SqlDbType.Int, 4, intID) };
            db.RunProc("Pr_GetSingleQQ", param, out dr);

            return (dr);
        }
        /// <summary>
        /// 删除单个QQ
        /// </summary>
        /// <param name="intID"></param>
        public int DeleteSingleQQ(int intID)
        {
            Database db = new Database();
            SqlParameter[] param = { db.CreateInParam("@Id", SqlDbType.Int, 4, intID) };
            return (db.RunProc("Pr_DeleteSingleQQ", param));
        }
        /// <summary>
        /// 批改单个QQ
        /// </summary>
        /// <param name="intID"></param>
        /// <param name="strQQ"></param>
        /// <param name="strName"></param>
        public int UpdateSingleQQ(int intID, string strQQ, string strName)
        {
            Database db = new Database();
            SqlParameter[] param = {
                db.CreateInParam("@Id", SqlDbType.Int, 4, intID),
                db.CreateInParam("@qq", SqlDbType.NVarChar, 25, strQQ),
                db.CreateInParam("@name", SqlDbType.NVarChar, 25, strName)
            };
            return (db.RunProc("Pr_UpdateSingleQQ", param));
        }
        /// <summary>
        /// 增长新的QQ
        /// </summary>
        /// <param name="strQQ"></param>
        /// <param name="strName"></param>
        /// <returns></returns>
        public int AddSingleQQ(string strQQ, string strName)
        {
            Database db = new Database();
            SqlParameter[] param = { db.CreateInParam("@qq", SqlDbType.NVarChar, 25, strQQ), db.CreateInParam("@name", SqlDbType.NVarChar, 25, strName) };

            ///返回增长新QQ的ID
            return (db.RunProc("Pr_AddSingleQQ", param));
        }
        /// <summary>
        /// 设置QQ
        /// </summary>
        /// <param name="intID"></param>
        /// <returns></returns>
        public int SetQQ(int intID)
        {
            Database db = new Database();
            SqlParameter[] param = {
                db.CreateInParam("@ID", SqlDbType.Int, 4, intID)
            };

            ///返回受影响的行数
            return (db.RunProc("Pr_SetQQ", param));
        }
    }
}



#line default
#line hidden