Beispiel #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (_Request.IsClick("search"))
            {
                m_Filter = UserIPSearchFilter.GetFromForm();

                m_Filter.Apply("filter", "page");
            }

            m_Filter = UserIPSearchFilter.GetFromFilter("filter");

            int page = _Request.Get <int>("page", 0);

            m_UserIPLogList = LogManager.GetUserIPLogsBySearch(Filter, page);

            m_UserIPLogListCount = m_UserIPLogList.TotalRecords;
        }
Beispiel #2
0
 public static UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber)
 {
     return(OperationLogDao.Instance.GetUserIPLogsBySearch(filter, pagenumber));
 }
Beispiel #3
0
        public override UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber)
        {
            using (SqlQuery query = new SqlQuery())
            {
                StringBuilder condition = new StringBuilder();
                string SortField = "CreateDate";

                if (filter != null)
                {

                    switch (filter.OrderBy)
                    {
                        case UserIPLogSortOrder.Username:
                            SortField = "Username";
                            break;
                        case UserIPLogSortOrder.NewIP:
                            SortField = "NewIP";
                            break;
                    }

                    if (!string.IsNullOrEmpty(filter.Username))
                    {
                        condition.Append(" AND Username = @Username");
                        query.CreateParameter<string>("@Username", filter.Username, SqlDbType.NVarChar, 50);
                    }

                    if (filter.UserID != null)
                    {
                        condition.Append(" AND UserID=@UserID");
                        query.CreateParameter<int>("@UserID", filter.UserID.Value, SqlDbType.Int);
                    }

                    if (!string.IsNullOrEmpty(filter.NewIP))
                    {
                        condition.Append(" AND NewIP=@NewIP");
                        query.CreateParameter<string>("@NewIP", filter.NewIP, SqlDbType.VarChar, 50);
                    }

                    if (filter.BeginDate != null)
                    {
                        condition.Append(" AND CreateDate>=@BeginDate");
                        query.CreateParameter<DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime);
                    }

                    if (filter.EndDate != null)
                    {
                        condition.Append(" AND CreateDate<=@EndDate");
                        query.CreateParameter<DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime);
                    }

                }

                query.Pager.SortField = SortField;
                query.Pager.TableName = "bx_IPLogs";
                query.Pager.PageSize = filter.PageSize;
                query.Pager.PageNumber = pagenumber;
                query.Pager.PrimaryKey = "LogID";
                query.Pager.IsDesc = filter != null ? filter.IsDesc : true;
                if (condition.Length > 0)
                    query.Pager.Condition = condition.ToString().Substring(4);
                query.Pager.SelectCount = true;

                using (XSqlDataReader reader = query.ExecuteReader())
                {
                    UserIPLogCollection iploglist = new UserIPLogCollection(reader);
                    if (reader.NextResult())
                    {
                        while (reader.Next)
                            iploglist.TotalRecords = reader.Get<int>(0);
                    }

                    return iploglist;

                }

            }
        }
Beispiel #4
0
 public static UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber)
 {
     return OperationLogDao.Instance.GetUserIPLogsBySearch(filter, pagenumber);
 }
Beispiel #5
0
 public abstract UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber);
Beispiel #6
0
        public override UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber)
        {
            using (SqlQuery query = new SqlQuery())
            {
                StringBuilder condition = new StringBuilder();
                string        SortField = "CreateDate";

                if (filter != null)
                {
                    switch (filter.OrderBy)
                    {
                    case UserIPLogSortOrder.Username:
                        SortField = "Username";
                        break;

                    case UserIPLogSortOrder.NewIP:
                        SortField = "NewIP";
                        break;
                    }

                    if (!string.IsNullOrEmpty(filter.Username))
                    {
                        condition.Append(" AND Username = @Username");
                        query.CreateParameter <string>("@Username", filter.Username, SqlDbType.NVarChar, 50);
                    }

                    if (filter.UserID != null)
                    {
                        condition.Append(" AND UserID=@UserID");
                        query.CreateParameter <int>("@UserID", filter.UserID.Value, SqlDbType.Int);
                    }

                    if (!string.IsNullOrEmpty(filter.NewIP))
                    {
                        condition.Append(" AND NewIP=@NewIP");
                        query.CreateParameter <string>("@NewIP", filter.NewIP, SqlDbType.VarChar, 50);
                    }

                    if (filter.BeginDate != null)
                    {
                        condition.Append(" AND CreateDate>=@BeginDate");
                        query.CreateParameter <DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime);
                    }

                    if (filter.EndDate != null)
                    {
                        condition.Append(" AND CreateDate<=@EndDate");
                        query.CreateParameter <DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime);
                    }
                }

                query.Pager.SortField  = SortField;
                query.Pager.TableName  = "bx_IPLogs";
                query.Pager.PageSize   = filter.PageSize;
                query.Pager.PageNumber = pagenumber;
                query.Pager.PrimaryKey = "LogID";
                query.Pager.IsDesc     = filter != null ? filter.IsDesc : true;
                if (condition.Length > 0)
                {
                    query.Pager.Condition = condition.ToString().Substring(4);
                }
                query.Pager.SelectCount = true;

                using (XSqlDataReader reader = query.ExecuteReader())
                {
                    UserIPLogCollection iploglist = new UserIPLogCollection(reader);
                    if (reader.NextResult())
                    {
                        while (reader.Next)
                        {
                            iploglist.TotalRecords = reader.Get <int>(0);
                        }
                    }

                    return(iploglist);
                }
            }
        }