public IList<Core.Business.Visitor> GetAllVisitor() { IList<Core.Business.Visitor> visitorlist = new List<Core.Business.Visitor>(); SqlServerUtility sql = new SqlServerUtility(connectionString); SqlDataReader reader = sql.ExecuteSPReader("USP_Visitor_Select_All"); if (reader != null) { while (reader.Read()) { Core.Business.Visitor visitor = new Core.Business.Visitor(); if (!reader.IsDBNull(0)) visitor.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) visitor.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) visitor.VisitorId = reader.GetInt64(2); if (!reader.IsDBNull(3)) visitor.VisiteDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) visitor.IP = reader.GetString(4); visitor.MarkOld(); visitorlist.Add(visitor); } reader.Close(); } return visitorlist; }
public IList<CY.UME.Core.Business.Visitor> GetAllVisitorByAccountId(long userId, PagingInfo pagingInfo) { IList<Core.Business.Visitor> visitorList = new List<Core.Business.Visitor>(); SqlServerUtility sql = new SqlServerUtility(connectionString); #region ²ÎÊý string tables = "Visitor"; string pK = "Id"; string sort = "VisiteDate Desc"; int pageNum = pagingInfo.CurrentPage; int pageSize = pagingInfo.PageSize; string fields = "[Id], [AccountId],[VisitorId],[VisiteDate],[IP]"; string filter = "AccountId = " + userId; string group = String.Empty; #endregion sql.AddParameter("@Tables", SqlDbType.VarChar, tables); sql.AddParameter("@PK", SqlDbType.VarChar, pK); sql.AddParameter("@Sort", SqlDbType.VarChar, sort); sql.AddParameter("@PageNumber", SqlDbType.Int, pageNum); sql.AddParameter("@PageSize", SqlDbType.Int, pageSize); sql.AddParameter("@Fields", SqlDbType.VarChar, fields); sql.AddParameter("@Filter", SqlDbType.VarChar, filter); sql.AddParameter("@Group", SqlDbType.VarChar, group); SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount"); if (reader != null) { while (reader.Read()) { Core.Business.Visitor visitor = new Core.Business.Visitor(); if (!reader.IsDBNull(0)) visitor.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) visitor.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) visitor.VisitorId = reader.GetInt64(2); if (!reader.IsDBNull(3)) visitor.VisiteDate = reader.GetDateTime(3); if (!reader.IsDBNull(5)) visitor.IP = reader.GetString(4); visitor.MarkOld(); visitorList.Add(visitor); } reader.Close(); } return visitorList; }
public Core.Business.Visitor Select(long id) { SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Id", SqlDbType.BigInt, id); SqlDataReader reader = sql.ExecuteSPReader("USP_Visitor_Select_By_Id"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Visitor visitor = new Core.Business.Visitor(); if (!reader.IsDBNull(0)) visitor.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) visitor.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) visitor.VisitorId = reader.GetInt64(2); if (!reader.IsDBNull(3)) visitor.VisiteDate = reader.GetDateTime(3); if (!reader.IsDBNull(4)) visitor.IP = reader.GetString(5); reader.Close(); return visitor; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }