operationuser.cs

该服务平台解决了计算机网络与移动网络之间信息交换问题

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 int AddOpUser(string UserID, int AreaID, int CountyID, int VillageID, int RulesID, string UserName, string password)
        {

            string strSql = string.Format("Insert into OperationUser(UserID,CountyID,VillageID,RulesID,UserName,Password)VALUES" +
                " ('{0}',{1},{2},{3},{4},'{5}',CONVERT(binary(64), '{6}'))", UserID, AreaID, CountyID, VillageID, RulesID, UserName, password);
            return db.ExecuteNonQuery(CommandType.Text, strSql);
        }

        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;
        }
    }
}