SQLServerDAL/ManagerDAL.cs

（开头部分） 5KB

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;

using CheckOnWork.Model;
using CheckOnWork.WebConfig;
using CheckOnWork.DBHelper;
using CheckOnWork.IDAL;

namespace CheckOnWork.SQLServerDAL
{
    public class ManagerDAL : DBAccess, IManager
    {
        #region 得到Manager
        /// <summary>
        /// 得到Manager对象依据ID和PWD
        /// </summary>
        /// <param name="id">管理员ID</param>
        /// <param name="pwd">管理员密码</param>
        /// <returns></returns>
        public Manager GetManager(string id, string pwd)
        {
            Manager manager = new Manager();
            SqlParameter[] param = { 
                                    new SqlParameter("@ID",id),
                                    new SqlParameter("@Pwd",pwd),
                                   };
            SqlDataReader sqlRead = ExecuteReader(StoredProcedureName.managerLogin,param);
            if (sqlRead.Read())
            {
                manager.CMID = sqlRead.GetString(sqlRead.GetOrdinal("CMID"));
                manager.CMPwd = sqlRead.GetString(sqlRead.GetOrdinal("CMPwd"));
                manager.CMName = sqlRead.GetString(sqlRead.GetOrdinal("CMName"));
                manager.CMPhone = sqlRead.GetString(sqlRead.GetOrdinal("CMPhone"));
                manager.CMEmail = sqlRead.GetString(sqlRead.GetOrdinal("CMEmail"));

                sqlRead.Close();
                return manager;
            }
            else
                return manager;

        }
        #endregion

        #region 添加管理员
        /// <summary>
        /// 添加管理员
        /// </summary>
        /// <param name="manager">Manager对象</param>
        /// <returns></returns>
        public int InsertManager(Manager manager)
        {
            SqlParameter[] param = { 
                                    new SqlParameter("@cmdId",manager.CMID),
                                    new SqlParameter("@cmdPwd",manager.CMPwd),
后面还有 78 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。