Hl.DataDalSql/Adm/AdmSafe.cs

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

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

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using Hl.Code;

namespace Hl.DataDalSql
{
    /// <summary>
    /// 系统安全[DAL]
    /// </summary>
    public class AdmSafe : DataDalInterface.AdmSafe
    {
        #region "访问"

        /// <summary>
        /// DbHelper
        /// </summary>
        private Hl.DataDbHelper.DbHelper DbHelper = Hl.DataDbHelper.DbUlitity.Instance();

        #endregion

        #region "命令"

        /// <summary>
        /// 安全登录
        /// </summary>
        private const string SafeLoginCmdText = "系统用户登录";

        /// <summary>
        /// 修改密码
        /// </summary>
        private const string UpdatePasswordCmdText = "Select * From [AdmUser] Where [ID]=@ID";

        #endregion

        #region "参数"

        /// <summary>
        /// 安全登录
        /// </summary>
        private IDbDataParameter[] SafeLoginParameters()
        {
            IDbDataParameter[] parameters = (IDbDataParameter[])Hl.DataDbHelper.DbUlitity.GetCacheParameters(SafeLoginCmdText);
            if (parameters == null)
            {
                parameters = new SqlParameter[]
                {
                    new SqlParameter("@userName", SqlDbType.NVarChar, 50),
                    new SqlParameter("@userPass", SqlDbType.NVarChar, 1000),
                    new SqlParameter("@loginMac", SqlDbType.NVarChar, 50),
                    new SqlParameter("@toShopId", SqlDbType.Int, 4),
                    new SqlParameter("@myUserId", SqlDbType.Int, 4),
                    new SqlParameter("@myUserNo", SqlDbType.NVarChar, 50),
                    new SqlParameter("@msgType", SqlDbType.NVarChar, 50),
                    new SqlParameter("@msgInfo", SqlDbType.NVarChar, 4000)
                };
                Hl.DataDbHelper.DbUlitity.SetCacheParameters(SafeLoginCmdText, parameters);
            }