public void Insert(Core.Business.ExhibitionInstrument exhibitionInstrument) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@InstrumentID", SqlDbType.UniqueIdentifier, exhibitionInstrument.InstrumentID); sql.AddParameter("@ExhibitionDate", SqlDbType.DateTime, exhibitionInstrument.ExhibitionDate); sql.AddParameter("@SequenceNumber", SqlDbType.Int, exhibitionInstrument.SequenceNumber); sql.AddParameter("@IsShowinHomePage", SqlDbType.Int, exhibitionInstrument.IsShowinHomePage); sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier); SqlDataReader reader = sql.ExecuteSPReader("usp_InsertExhibitionInstrument"); if (reader != null && !reader.IsClosed && reader.Read()) { if (!reader.IsDBNull(0)) { exhibitionInstrument.Id = reader.GetGuid(0); } reader.Close(); } else { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public IList <Core.Business.ExhibitionInstrument> GetExhibitionInstrumentByPage(string sqlwhere, int pagenumber, int pagesize) { IList <Core.Business.ExhibitionInstrument> exhibitionInstrumentlist = new List <Core.Business.ExhibitionInstrument>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Tables", SqlDbType.VarChar, "ExhibitionInstrument"); sql.AddParameter("@PK", SqlDbType.VarChar, "Id"); sql.AddParameter("@PageNumber", SqlDbType.Int, pagenumber); sql.AddParameter("@PageSize", SqlDbType.Int, pagesize); //sql.AddParameter("@LawSortID", SqlDbType.UniqueIdentifier, sortId); sql.AddParameter("@Filter", SqlDbType.VarChar, sqlwhere); SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount"); if (reader != null) { while (reader.Read()) { Core.Business.ExhibitionInstrument exhibitionInstrument = new Core.Business.ExhibitionInstrument(); if (!reader.IsDBNull(0)) { exhibitionInstrument.Id = reader.GetGuid(0); } if (!reader.IsDBNull(1)) { exhibitionInstrument.InstrumentID = reader.GetGuid(1); } if (!reader.IsDBNull(2)) { exhibitionInstrument.ExhibitionDate = reader.GetDateTime(2); } if (!reader.IsDBNull(3)) { exhibitionInstrument.SequenceNumber = reader.GetInt32(3); } if (!reader.IsDBNull(4)) { exhibitionInstrument.IsShowinHomePage = reader.GetInt32(4); } exhibitionInstrument.MarkOld(); exhibitionInstrumentlist.Add(exhibitionInstrument); } reader.Close(); } return(exhibitionInstrumentlist); }
public Core.Business.ExhibitionInstrument Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectExhibitionInstrument"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.ExhibitionInstrument exhibitionInstrument = new Core.Business.ExhibitionInstrument(); if (!reader.IsDBNull(0)) { exhibitionInstrument.Id = reader.GetGuid(0); } if (!reader.IsDBNull(1)) { exhibitionInstrument.InstrumentID = reader.GetGuid(1); } if (!reader.IsDBNull(2)) { exhibitionInstrument.ExhibitionDate = reader.GetDateTime(2); } if (!reader.IsDBNull(3)) { exhibitionInstrument.SequenceNumber = reader.GetInt32(3); } if (!reader.IsDBNull(4)) { exhibitionInstrument.IsShowinHomePage = reader.GetInt32(4); } reader.Close(); return(exhibitionInstrument); } else { if (reader != null && !reader.IsClosed) { reader.Close(); } return(null); } }