userpointlog.cs

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

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

    public class UserPointLog : IUserPointLog
    {
        private int m_CountNumber;

        public bool Add(PowerEasy.Model.UserManage.UserPointLogInfo userPointLogInfo)
        {
            return DBHelper.ExecuteProc("PR_UserManage_UserPointLog_Add", GetProcdbComm(userPointLogInfo));
        }

        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 = '" + 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_UserPointLog_Delete", cmdParams);
        }

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

        public bool Exists(string userName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@UserName", DbType.String, userName);
            return DBHelper.ExistsSql("select count(UserName) from PE_PointLog where UserName=@UserName", cmdParams);
        }

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

        private static ArrayList GetIncomeAndPayout(string sql)
        {
            ArrayList list = new ArrayList();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql(sql))
            {
                if (reader.Read())
                {
                    list.Add(reader[0]);
                }
                if (reader.NextResult() && reader.Read())
                {
                    list.Add(reader[0]);
                }
            }
            return list;
        }

        public IList<PowerEasy.Model.UserManage.UserPointLogInfo> GetPointList(int startRowIndexId, int maxNumberRows, int scopesType, int field, string keyword)
        {
            Database database = DatabaseFactory.CreateDatabase();
            IList<PowerEasy.Model.UserManage.UserPointLogInfo> list = new List<PowerEasy.Model.UserManage.UserPointLogInfo>();
            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,ModuleType,InfoID,Point,LogTime,Times,IncomePayOut,Remark,IP,Inputer");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_PointLog");
            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 4:
                    database.SetParameterValue(storedProcCommand, "@Filter", " Income_Payout <=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(UserPointLogInfo(reader));
                }
            }
            this.m_CountNumber = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public PowerEasy.Model.UserManage.UserPointLogInfo GetPointLogById(int logId)
        {
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("select * from PE_PointLog where LogID = @LogID", new Parameters("@LogID", DbType.String, logId)))
            {
                if (reader.Read())
                {
                    PowerEasy.Model.UserManage.UserPointLogInfo info = UserPointLogInfo(reader);