uservalidlog.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

namespace PowerEasy.SqlServerDal.UserManage
{
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using PowerEasy.IDal.UserManage;
    using PowerEasy.Model.UserManage;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;

    public class UserValidLog : IUserValidLog
    {
        private int m_CountNumber;

        public bool Add(PowerEasy.Model.UserManage.UserValidLogInfo userValidLogInfo)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@LogID", DbType.Int32, userValidLogInfo.LogId);
            cmdParams.AddInParameter("@UserName", DbType.String, userValidLogInfo.UserName);
            cmdParams.AddInParameter("@ValidNum", DbType.Int32, userValidLogInfo.ValidNum);
            cmdParams.AddInParameter("@IncomePayout", DbType.Int32, userValidLogInfo.IncomePayout);
            cmdParams.AddInParameter("@LogTime", DbType.DateTime, userValidLogInfo.LogTime);
            cmdParams.AddInParameter("@Remark", DbType.String, userValidLogInfo.Remark);
            cmdParams.AddInParameter("@IP", DbType.String, userValidLogInfo.IP);
            cmdParams.AddInParameter("@Inputer", DbType.String, userValidLogInfo.Inputer);
            cmdParams.AddInParameter("@Memo", DbType.String, userValidLogInfo.Memo);
            return DBHelper.ExecuteProc("PR_UserManage_UserValidLog_Add", cmdParams);
        }

        private static string ComplexSearch(string keyword)
        {
            string str = "1=1";
            if (!string.IsNullOrEmpty(keyword))
            {
                string[] strArray = keyword.Split(new char[] { '|' });
                string str2 = strArray[0];
                string str3 = strArray[1];
                string str4 = strArray[2];
                string str5 = strArray[3];
                string str6 = strArray[4];
                string str7 = strArray[5];
                string str8 = strArray[6];
                string str9 = strArray[7];
                if (!string.IsNullOrEmpty(str2) && !string.IsNullOrEmpty(str3))
                {
                    string str10 = str;
                    str = str10 + " and ( LogID Between " + str2 + " and " + str3 + ") ";
                }
                if (!string.IsNullOrEmpty(str4) && !string.IsNullOrEmpty(str5))
                {
                    string str11 = str;
                    str = str11 + " and ( LogTime Between '" + str4 + "' and '" + str5 + "') ";
                }
                if (!string.IsNullOrEmpty(str6))
                {
                    str = str + " and UserName like '%" + str6 + "%' ";
                }
                if (!string.IsNullOrEmpty(str7))
                {
                    str = str + " and datediff( dd ,LogTime,'" + str7 + "') = 0 ";
                }
                if (!string.IsNullOrEmpty(str8))
                {
                    str = str + " and Inputer like '%" + str8 + "%' ";
                }
                if (!string.IsNullOrEmpty(str9))
                {
                    str = str + " and IP like '%" + str9 + "%' ";
                }
            }
            return str;
        }

        public bool Delete(DateTime tempDate)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@Date", DbType.DateTime, tempDate);
            return DBHelper.ExecuteProc("PR_UserManage_UserValidLog_Delete", cmdParams);
        }

        public bool Delete(string userName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@UserName", DbType.String, userName);
            return DBHelper.ExecuteProc("PR_UserManage_UserValidLog_DeleteUser", cmdParams);
        }

        public bool Exists(string userName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@UserName", DbType.String, userName);
            return DBHelper.ExistsProc("PR_UserManage_UserValidLog_Exists", cmdParams);
        }

        public int GetCountNumber()
        {
            return this.m_CountNumber;
        }

        public IList<PowerEasy.Model.UserManage.UserValidLogInfo> GetValidList(int startRowIndexId, int maxNumberRows, int scopesType, int field, string keyword)
        {
            Database database = DatabaseFactory.CreateDatabase();
            IList<PowerEasy.Model.UserManage.UserValidLogInfo> list = new List<PowerEasy.Model.UserManage.UserValidLogInfo>();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList");
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "LogID");
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "LogID,UserName,ValidNum,IncomePayout,LogTime,Remark,IP,Inputer");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_ValidLog");
            switch (scopesType)
            {
                case 0:
                    database.SetParameterValue(storedProcCommand, "@Filter", " datediff(dd,LogTime,GetDate()) < 10 ");
                    break;

                case 1:
                    database.SetParameterValue(storedProcCommand, "@Filter", " datediff(dd,LogTime,GetDate()) < " + DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + "");
                    break;

                case 2:
                    database.SetParameterValue(storedProcCommand, "@Filter", " IncomePayout=1 ");
                    break;

                case 3:
                    database.SetParameterValue(storedProcCommand, "@Filter", " IncomePayout=2 ");
                    break;

                case 10:
                    if (field != 1)
                    {
                        database.SetParameterValue(storedProcCommand, "@Filter", " datediff( dd ,LogTime,'" + keyword + "') = 0 ");
                        break;
                    }
                    database.SetParameterValue(storedProcCommand, "@Filter", " UserName = '" + keyword + "' ");
                    break;

                case 11:
                    database.SetParameterValue(storedProcCommand, "@Filter", ComplexSearch(keyword));
                    break;
            }
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    list.Add(UserValidLogInfo(reader));
                }
            }
            this.m_CountNumber = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public PowerEasy.Model.UserManage.UserValidLogInfo GetValidLogById(int logId)
        {
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("select * from PE_ValidLog where LogID = @LogID", new Parameters("@LogID", DbType.String, logId)))
            {
                if (reader.Read())
                {
                    PowerEasy.Model.UserManage.UserValidLogInfo info = UserValidLogInfo(reader);
                    info.Memo = reader.GetString("Memo");
                    return info;
                }
                return new PowerEasy.Model.UserManage.UserValidLogInfo(true);
            }
        }

        public PowerEasy.Model.UserManage.UserValidLogInfo GetValidLogByIdAndUserName(int logId, string userName)
        {
            string strSql = "select * from PE_ValidLog where LogID = @LogID AND UserName=@UserName";
            Parameters cmdParams = new Parameters("@LogID", DbType.Int32, logId);
            cmdParams.AddInParameter("@UserName", DbType.String, userName);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
            {
                if (reader.Read())
                {
                    PowerEasy.Model.UserManage.UserValidLogInfo info = UserValidLogInfo(reader);
                    info.Memo = reader.GetString("Memo");
                    return info;
                }
                return new PowerEasy.Model.UserManage.UserValidLogInfo(true);
            }
        }

        private static PowerEasy.Model.UserManage.UserValidLogInfo UserValidLogInfo(NullableDataReader rdr)
        {
            PowerEasy.Model.UserManage.UserValidLogInfo info = new PowerEasy.Model.UserManage.UserValidLogInfo();
            info.LogId = rdr.GetInt32("LogID");
            info.UserName = rdr.GetString("UserName");
            info.ValidNum = rdr.GetInt32("ValidNum");
            info.LogTime = rdr.GetDateTime("LogTime");
            info.IncomePayout = rdr.GetInt32("IncomePayout");
            info.Remark = rdr.GetString("Remark");
            info.IP = rdr.GetString("IP");
            info.Inputer = rdr.GetString("Inputer");
            return info;
        }
    }
}