operationuser.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 56 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace DataAccess.TableAccessor
{
    public class OperationUser
    {
        private Database db = null;
        public OperationUser()
        {
            db = DatabaseFactory.CreateDatabase("Connection String");
        }

        public bool UserLogin(string userID, string password,out string userName,out int rulesID)
        {
            userName = "";
            rulesID = 0;
            string strSql = string.Format("SELECT RulesID, UserName FROM OperationUser WHERE Password = " +
                "CONVERT(binary(64), '{0}') AND UserID = '{1}' AND IsValid <> 0", password, userID);

            SqlDataReader dr = (SqlDataReader)db.ExecuteReader(CommandType.Text, strSql);
 
            try
            {
                rulesID = int.Parse(dr[0].ToString());
                userName = dr[1].ToString();
                return true;
            }
            catch
            {
                userName = "";
                rulesID = 0;
                return false;
            }
        }

        public bool UserLogin(string userID, string password)
        {
            string strSql = string.Format("SELECT RulesID, UserName FROM OperationUser WHERE Password = " +
                "CONVERT(binary(64), '{0}') AND UserID = '{1}' AND IsValid <> 0", password, userID);

            object returnValue = db.ExecuteScalar(CommandType.Text, strSql);

            if (returnValue == null)
                return false;
            else
                return true;
        }
    }
}