public IList<EmailAdditional> GetEmailInfo(string sqlWhere) { SqlServerUtility sql = new SqlServerUtility(); IList<Core.Business.EmailAdditional> emailAdditionallist = new List<Core.Business.EmailAdditional>(); string strSql = "select EmailAdditional.Id,ReceiverID,ReceiveStatus,MailID from Email,EmailAdditional where Email.Id =EmailAdditional.MailID and " + sqlWhere; strSql += " and Email.Status =1 order by ReceiveStatus desc , SendTime desc"; SqlDataReader reader = sql.ExecuteSqlReader(strSql); if (reader != null) { while (reader.Read()) { Core.Business.EmailAdditional emailAdditional = new Core.Business.EmailAdditional(); if (!reader.IsDBNull(0)) emailAdditional.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) emailAdditional.ReceiverID = reader.GetGuid(1); if (!reader.IsDBNull(2)) emailAdditional.ReceiveStatus = reader.GetInt32(2); if (!reader.IsDBNull(3)) emailAdditional.MailID = reader.GetGuid(3); emailAdditional.MarkOld(); emailAdditionallist.Add(emailAdditional); } reader.Close(); } return emailAdditionallist; }
public IList<Core.Business.EmailAdditional> GetAllEmailAdditional() { IList<Core.Business.EmailAdditional> emailAdditionallist = new List<Core.Business.EmailAdditional>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectEmailAdditionalsAll"); if(reader != null) { while(reader.Read()) { Core.Business.EmailAdditional emailAdditional = new Core.Business.EmailAdditional(); if (!reader.IsDBNull(0)) emailAdditional.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) emailAdditional.ReceiverID = reader.GetGuid(1); if (!reader.IsDBNull(2)) emailAdditional.ReceiveStatus = reader.GetInt32(2); if (!reader.IsDBNull(3)) emailAdditional.MailID = reader.GetGuid(3); emailAdditional.MarkOld(); emailAdditionallist.Add(emailAdditional); } reader.Close(); } return emailAdditionallist; }
public Core.Business.EmailAdditional Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectEmailAdditional"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.EmailAdditional emailAdditional = new Core.Business.EmailAdditional(); if (!reader.IsDBNull(0)) emailAdditional.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) emailAdditional.ReceiverID = reader.GetGuid(1); if (!reader.IsDBNull(2)) emailAdditional.ReceiveStatus = reader.GetInt32(2); if (!reader.IsDBNull(3)) emailAdditional.MailID = reader.GetGuid(3); reader.Close(); return emailAdditional; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.EmailAdditional> SelectByCondition(string strWhere, string strOrder) { SqlServerUtility sql = new SqlServerUtility(); IList<Core.Business.EmailAdditional> emailAdditionallist = new List<Core.Business.EmailAdditional>(); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, strWhere); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, strOrder); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectEmailAdditionalsDynamic"); if (reader != null) { while (reader.Read()) { Core.Business.EmailAdditional emailAdditional = new Core.Business.EmailAdditional(); if (!reader.IsDBNull(0)) emailAdditional.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) emailAdditional.ReceiverID = reader.GetGuid(1); if (!reader.IsDBNull(2)) emailAdditional.ReceiveStatus = reader.GetInt32(2); if (!reader.IsDBNull(3)) emailAdditional.MailID = reader.GetGuid(3); emailAdditional.MarkOld(); emailAdditionallist.Add(emailAdditional); } reader.Close(); } return emailAdditionallist; }