users.cs

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

                    str5 = " UserName in (select UserName from PE_Contacter where OfficePhone like '%" + keyword + "%')";
                    break;

                case 0x1b:
                    str5 = " UserName in (select UserName from PE_Contacter where HomePhone like '%" + keyword + "%')";
                    break;

                case 0x1c:
                    str5 = " UserName in (select UserName from PE_Contacter where PHS like '%" + keyword + "%')";
                    break;

                case 0x1d:
                    str5 = " UserName in (select UserName from PE_Contacter where Fax like '%" + keyword + "%')";
                    break;

                case 30:
                    str5 = " UserName in (select UserName from PE_Contacter where QQ like '%" + keyword + "%')";
                    break;

                case 0x1f:
                    str5 = " UserName in (select UserName from PE_Contacter where ICQ like '%" + keyword + "%')";
                    break;

                case 0x20:
                    str5 = " UserName in (select UserName from PE_Contacter where MSN like '%" + keyword + "%')";
                    break;

                case 0x21:
                    str5 = " UserName in (select UserName from PE_Contacter where Yahoo like '%" + keyword + "%')";
                    break;

                case 0x22:
                    str5 = " UserName in (select UserName from PE_Contacter where UC like '%" + keyword + "%')";
                    break;

                case 0x23:
                    str5 = " UserName in (select UserName from PE_Contacter where Aim like '%" + keyword + "%')";
                    break;

                case 0x24:
                    str5 = "IsInheritGroupRole = 0";
                    break;

                case 50:
                    str5 = " ClientID= " + keyword;
                    break;

                default:
                    str5 = "";
                    break;
            }
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand(storedProcedureName);
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32);
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String);
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String);
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String);
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String);
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String);
            database.SetParameterValue(storedProcCommand, "@StartRows", startRowIndexId);
            database.SetParameterValue(storedProcCommand, "@PageSize", maxNumberRows);
            database.SetParameterValue(storedProcCommand, "@SortColumn", str2);
            database.SetParameterValue(storedProcCommand, "@StrColumn", str3);
            database.SetParameterValue(storedProcCommand, "@Sorts", str4);
            database.SetParameterValue(storedProcCommand, "@TableName", "PE_Users");
            database.SetParameterValue(storedProcCommand, "@Filter", str5);
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    list.Add(UsersFromrdr(reader));
                }
            }
            this.m_NumUsers = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public int GetAuditingCompanyMemberCount(int companyId)
        {
            return DBHelper.ObjectToInt32(DBHelper.ExecuteScalarSql("select count(*) from PE_Users where UserType = 4 and CompanyID = @CompanyID", new Parameters("@CompanyID", DbType.Int32, companyId)));
        }

        public IList<UserInfo> GetListByCompanyId(int companyId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@CompanyID", DbType.Int32, companyId);
            IList<UserInfo> list = new List<UserInfo>();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("select * from PE_Users where CompanyID = @CompanyID order by UserType asc", cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(UsersFromrdr(reader));
                }
                return list;
            }
        }

        private static int GetMaxId()
        {
            return DBHelper.GetMaxId("PE_Users", "UserID");
        }

        private static int GetNewId()
        {
            return (GetMaxId() + 1);
        }

        public int GetNumberOfUsers()
        {
            return this.m_NumUsers;
        }

        public UserInfo GetUserById(int userId)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_UserManage_Users_GetById");
            database.AddInParameter(storedProcCommand, "@UserID", DbType.Int32, userId);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                if (reader.Read())
                {
                    return UsersFromrdr(reader);
                }
                return new UserInfo(true);
            }
        }

        public IList<UserInfo> GetUserByPost()
        {
            IList<UserInfo> list = new List<UserInfo>();
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql("SELECT * FROM PE_Users WHERE PostItems>0")))
            {
                while (reader.Read())
                {
                    list.Add(UsersFromrdr(reader));
                }
            }
            return list;
        }

        public IList<string> GetUserMailByGroupId(int groupId)
        {
            IList<string> list = new List<string>();
            string strSql = string.Empty;
            Parameters cmdParams = new Parameters();
            if (groupId == 0)
            {
                strSql = "select Email from PE_Users where Email like '%@%'";
                cmdParams = null;
            }
            else
            {
                strSql = "select Email from PE_Users where Email like '%@%' and GroupID=@GroupId";
                cmdParams.AddInParameter("@GroupId", DbType.Int32, groupId);
            }
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(reader.GetString("Email"));
                }
            }
            return list;
        }

        public IList<string[]> GetUserNameAndEmailList(int type, string value)
        {
            StringBuilder builder = new StringBuilder("");
            string strSql = "select UserName,Email from PE_Users ";
            IList<string[]> list = new List<string[]>();
            Parameters cmdParams = new Parameters();
            string[] strArray = value.Split(new char[] { ',' });
            switch (type)
            {
                case 0:
                    cmdParams = null;
                    break;

                case 1:
                    builder.Append(" where GroupID in (");
                    for (int i = 0; i < strArray.Length; i++)
                    {
                        cmdParams.AddInParameter("@value" + i.ToString(), DbType.Int32, Convert.ToInt32(strArray[i]));
                        builder.Append("@value" + i.ToString() + ",");
                    }
                    strSql = strSql + builder.ToString().TrimEnd(new char[] { ',' }) + ")";
                    break;

                case 2:
                    builder.Append(" where UserName in (");
                    for (int j = 0; j < strArray.Length; j++)
                    {
                        cmdParams.AddInParameter("@value" + j.ToString(), DbType.String, strArray[j]);
                        builder.Append("@value" + j.ToString() + ",");
                    }
                    strSql = strSql + builder.ToString().TrimEnd(new char[] { ',' }) + ")";
                    break;

                case 3:
                    builder.Append(" where Email in (");
                    for (int k = 0; k < strArray.Length; k++)
                    {
                        cmdParams.AddInParameter("@value" + k.ToString(), DbType.String, strArray[k]);
                        builder.Append("@value" + k.ToString() + ",");
                    }
                    strSql = strSql + builder.ToString().TrimEnd(new char[] { ',' }) + ")";
                    break;

                default:
                    cmdParams = null;
                    break;
            }
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(new string[] { reader.GetString("UserName"), reader.GetString("Email") });
                }
            }
            return list;
        }

        public IList<string> GetUserNameList(int startRowIndexId, int maxiNumRows, int searchType, string keyword)
        {
            IList<string> list = new List<string>();
            CommonListParameters cmdParams = new CommonListParameters(startRowIndexId, maxiNumRows);
            cmdParams.TableName = "PE_Users";
            cmdParams.StrColumn = "UserName";
            cmdParams.SortColumn = "UserId";
            cmdParams.Sorts = Sorts.Asc;
            switch (searchType)
            {
                case 0:
                    cmdParams.Filter = " GroupID=" + keyword;
                    break;

                case 1:
                    cmdParams.Filter = " UserName like '%" + keyword + "%'";
                    break;
            }
            cmdParams.CreateParameter();
            using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Common_GetList", cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(reader.GetString("UserName"));
                }
            }
            return list;
        }

        public int GetUserNameListTotal(int searchType, string keyword)
        {
            string strSql = "Select count(*) from PE_Users ";
            Parameters cmdParams = new Parameters();
            if (searchType == 1)
            {
                strSql = strSql + " where UserName like @UserName";
                cmdParams.AddInParameter("@UserName", DbType.String, "%" + keyword + "%");
            }
            else
            {
                strSql = strSql + "where GroupId = @GroupId";
                cmdParams.AddInParameter("@GroupId", DbType.Int32, Convert.ToInt32(keyword));
            }
            object objA = DBHelper.ExecuteScalarSql(strSql, cmdParams);
            if (!object.Equals(objA, null))
            {
                return Convert.ToInt32(objA);
            }
            return 0;
        }

        private static Parameters GetUserParameters(UserInfo usersInfo)
        {
            Parameters parameters = new Parameters();
            parameters.AddInParameter("@UserID", DbType.Int32, usersInfo.UserId);
            parameters.AddInParameter("@GroupID", DbType.Int32, usersInfo.GroupId);
            parameters.AddInParameter("@CompanyID", DbType.Int32, usersInfo.CompanyId);
            parameters.AddInParameter("@ClientID", DbType.Int32, usersInfo.ClientId);
            parameters.AddInParameter("@UserType", DbType.Int32, usersInfo.UserType);
            parameters.AddInParameter("@UserName", DbType.String, usersInfo.UserName);
            parameters.AddInParameter("@UserPassword", DbType.String, usersInfo.UserPassword);
            parameters.AddInParameter("@LastPassword", DbType.String, usersInfo.LastPassword);
            parameters.AddInParameter("@Question", DbType.String, usersInfo.Question);
            parameters.AddInParameter("@Answer", DbType.String, usersInfo.Answer);
            parameters.AddInParameter("@Email", DbType.String, usersInfo.Email);
            parameters.AddInParameter("@Sex", DbType.Int32, usersInfo.Sex);
            parameters.AddInParameter("@RegTime", DbType.DateTime, usersInfo.RegTime);
            parameters.AddInParameter("@JoinTime", DbType.DateTime, usersInfo.JoinTime);
            parameters.AddInParameter("@LoginTimes", DbType.Int32, usersInfo.LoginTimes);
            parameters.AddInParameter("@LastLoginTime", DbType.DateTime, usersInfo.LastLoginTime);
            parameters.AddInParameter("@LastPresentTime", DbType.DateTime, usersInfo.LastPresentTime);
            parameters.AddInParameter("@LastLoginIP", DbType.String, usersInfo.LastLoginIP);
            parameters.AddInParameter("@LastPasswordChangedTime", DbType.DateTime, usersInfo.LastPasswordChangedTime);
            parameters.AddInParameter("@LastLockoutTime", DbType.DateTime, usersInfo.LastLockoutTime);
            parameters.AddInParameter("@FailedPasswordAttemptCount", DbType.Int32, usersInfo.FailedPasswordAttemptCount);
            parameters.AddInParameter("@FirstFailedPasswordAttempTime", DbType.DateTime, usersInfo.FirstFailedPasswordAttempTime);
            parameters.AddInParameter("@FailedPasswordAnswerAttempCount", DbType.Int32, usersInfo.FailedPasswordAnswerAttempCount);