public void Insert(Core.Business.InstrumentRecommend instrumentRecommend) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Autor", SqlDbType.UniqueIdentifier, instrumentRecommend.Autor); sql.AddParameter("@RecommendDate", SqlDbType.DateTime, instrumentRecommend.RecommendDate); sql.AddParameter("@Commend", SqlDbType.NVarChar, instrumentRecommend.Commend); SqlDataReader reader = sql.ExecuteSqlReader(SqlInsertInstrumentRecommend); if (reader != null && !reader.IsClosed && reader.Read()) { if (!reader.IsDBNull(0)) { instrumentRecommend.Id = reader.GetGuid(0); } reader.Close(); } else { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public void Delete(Core.Business.InstrumentRecommend instrumentRecommend) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, instrumentRecommend.Id); sql.ExecuteSql(SqlDeleteInstrumentRecommend); }
public IList<Core.Business.InstrumentRecommend> GetAllInstrumentRecommend() { IList<Core.Business.InstrumentRecommend> instrumentRecommendlist = new List<Core.Business.InstrumentRecommend>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllInstrumentRecommend); if(reader != null) { while(reader.Read()) { Core.Business.InstrumentRecommend instrumentRecommend = new Core.Business.InstrumentRecommend(); if (!reader.IsDBNull(0)) instrumentRecommend.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) instrumentRecommend.Autor = reader.GetGuid(1); if (!reader.IsDBNull(2)) instrumentRecommend.RecommendDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) instrumentRecommend.Commend = reader.GetString(3); instrumentRecommend.MarkOld(); instrumentRecommendlist.Add(instrumentRecommend); } reader.Close(); } return instrumentRecommendlist; }
public void Update(Core.Business.InstrumentRecommend instrumentRecommend) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Autor", SqlDbType.UniqueIdentifier, instrumentRecommend.Autor); sql.AddParameter("@RecommendDate", SqlDbType.DateTime, instrumentRecommend.RecommendDate); sql.AddParameter("@Commend", SqlDbType.NVarChar, instrumentRecommend.Commend); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, instrumentRecommend.Id); sql.ExecuteSql(SqlUpdateInstrumentRecommend); }
public Core.Business.InstrumentRecommend Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectInstrumentRecommend); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.InstrumentRecommend instrumentRecommend = new Core.Business.InstrumentRecommend(); if (!reader.IsDBNull(0)) { instrumentRecommend.Id = reader.GetGuid(0); } if (!reader.IsDBNull(1)) { instrumentRecommend.Autor = reader.GetGuid(1); } if (!reader.IsDBNull(2)) { instrumentRecommend.RecommendDate = reader.GetDateTime(2); } if (!reader.IsDBNull(3)) { instrumentRecommend.Commend = reader.GetString(3); } reader.Close(); return(instrumentRecommend); } else { if (reader != null && !reader.IsClosed) { reader.Close(); } return(null); } }
public IList <Core.Business.InstrumentRecommend> GetAllInstrumentRecommend() { IList <Core.Business.InstrumentRecommend> instrumentRecommendlist = new List <Core.Business.InstrumentRecommend>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllInstrumentRecommend); if (reader != null) { while (reader.Read()) { Core.Business.InstrumentRecommend instrumentRecommend = new Core.Business.InstrumentRecommend(); if (!reader.IsDBNull(0)) { instrumentRecommend.Id = reader.GetGuid(0); } if (!reader.IsDBNull(1)) { instrumentRecommend.Autor = reader.GetGuid(1); } if (!reader.IsDBNull(2)) { instrumentRecommend.RecommendDate = reader.GetDateTime(2); } if (!reader.IsDBNull(3)) { instrumentRecommend.Commend = reader.GetString(3); } instrumentRecommend.MarkOld(); instrumentRecommendlist.Add(instrumentRecommend); } reader.Close(); } return(instrumentRecommendlist); }
public Core.Business.InstrumentRecommend Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectInstrumentRecommend); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.InstrumentRecommend instrumentRecommend = new Core.Business.InstrumentRecommend(); if (!reader.IsDBNull(0)) instrumentRecommend.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) instrumentRecommend.Autor = reader.GetGuid(1); if (!reader.IsDBNull(2)) instrumentRecommend.RecommendDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) instrumentRecommend.Commend = reader.GetString(3); reader.Close(); return instrumentRecommend; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }