/// <summary> /// ���ݻID��������ID����������ID�ж�ij�����Ƿ��Ѿ���ij����� /// </summary> /// <param name="AccountID"></param> /// <param name="InviteID"></param> /// <param name="ActiveitesID"></param> /// <returns></returns> public IList<ActivitiesInvite> Get(long AccountID, long InviteID, int ActiveitesID) { IList<Core.Business.ActivitiesInvite> activitiesInvitelist = new List<Core.Business.ActivitiesInvite>(); SqlServerUtility sql = new SqlServerUtility(connectionString); string sqlwhere = "AccountID=" + AccountID + " and InviteID=" + InviteID + " and ActiveitesID=" + ActiveitesID + ""; sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, sqlwhere); sql.AddParameter("@OrderByExpression",SqlDbType.NVarChar,"InviteaTime desc"); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectActivitiesInvitesDynamic"); if (reader != null) { while (reader.Read()) { Core.Business.ActivitiesInvite activitiesInvite = new Core.Business.ActivitiesInvite(); if (!reader.IsDBNull(0)) activitiesInvite.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) activitiesInvite.AccountID = reader.GetInt64(1); if (!reader.IsDBNull(2)) activitiesInvite.InviteID = reader.GetInt64(2); if (!reader.IsDBNull(3)) activitiesInvite.InviteaTime = reader.GetDateTime(3); if (!reader.IsDBNull(4)) activitiesInvite.ActiveitesID = reader.GetInt32(4); activitiesInvite.MarkOld(); activitiesInvitelist.Add(activitiesInvite); } reader.Close(); } return activitiesInvitelist; }
public IList<Core.Business.ActivitiesInvite> GetAllActivitiesInvite() { IList<Core.Business.ActivitiesInvite> activitiesInvitelist = new List<Core.Business.ActivitiesInvite>(); SqlServerUtility sql = new SqlServerUtility(connectionString); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectActivitiesInvitesAll"); if(reader != null) { while(reader.Read()) { Core.Business.ActivitiesInvite activitiesInvite = new Core.Business.ActivitiesInvite(); if (!reader.IsDBNull(0)) activitiesInvite.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) activitiesInvite.AccountID = reader.GetInt64(1); if (!reader.IsDBNull(2)) activitiesInvite.InviteID = reader.GetInt64(2); if (!reader.IsDBNull(3)) activitiesInvite.InviteaTime = reader.GetDateTime(3); if (!reader.IsDBNull(4)) activitiesInvite.ActiveitesID = reader.GetInt32(4); activitiesInvite.MarkOld(); activitiesInvitelist.Add(activitiesInvite); } reader.Close(); } return activitiesInvitelist; }
public Core.Business.ActivitiesInvite Select(int id) { SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectActivitiesInvite"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.ActivitiesInvite activitiesInvite = new Core.Business.ActivitiesInvite(); if (!reader.IsDBNull(0)) activitiesInvite.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) activitiesInvite.AccountID = reader.GetInt64(1); if (!reader.IsDBNull(2)) activitiesInvite.InviteID = reader.GetInt64(2); if (!reader.IsDBNull(3)) activitiesInvite.InviteaTime = reader.GetDateTime(3); if (!reader.IsDBNull(4)) activitiesInvite.ActiveitesID = reader.GetInt32(4); reader.Close(); return activitiesInvite; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }