public Domain.ReleaseNote Query(Guid id) { string sql = "SELECT Id,CreateTime,Creator,UpdateTime,Title,Context,Type,ReleaseType FROM dbo.T_ReleaseNote WHERE Id = '" + id + "'"; using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString)) { using (var reader = dbOperator.ExecuteReader(sql)) { Domain.ReleaseNote note = null; if (reader.Read()) { note = new Domain.ReleaseNote(); note.Id = reader.GetGuid(0); note.CreateTime = reader.GetDateTime(1); note.Creator = reader.GetString(2); note.UpdateTime = reader.GetDateTime(3); note.Title = reader.GetString(4); note.Context = reader.GetString(5); note.Type = (ChinaPay.B3B.Common.Enums.CompanyType)reader.GetByte(6); note.ReleaseType = (ChinaPay.B3B.Common.Enums.ReleaseNoteType)reader.GetByte(7); } return(note); } } }
public IEnumerable <Domain.ReleaseNote> Query(Pagination paination, DateTime?startTime, DateTime?endTime, Common.Enums.CompanyType?type, ChinaPay.B3B.Common.Enums.ReleaseNoteType?releaseType) { using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString)) { List <Domain.ReleaseNote> list = new List <Domain.ReleaseNote>(); if (startTime.HasValue) { dbOperator.AddParameter("@iStartTime", startTime); } if (endTime.HasValue) { dbOperator.AddParameter("@iEndTime", endTime); } if (type != null) { dbOperator.AddParameter("@iType", type); } if (releaseType != null) { dbOperator.AddParameter("@iReleaseType", releaseType); } dbOperator.AddParameter("@iPageSize", paination.PageSize); dbOperator.AddParameter("@iPageIndex", paination.PageIndex); var totalCount = dbOperator.AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (var reader = dbOperator.ExecuteReader("dbo.P_QueryReleaseNote", System.Data.CommandType.StoredProcedure)) { while (reader.Read()) { Domain.ReleaseNote note = new Domain.ReleaseNote(); note.Id = reader.GetGuid(0); note.CreateTime = reader.GetDateTime(1); note.Creator = reader.GetString(2); note.UpdateTime = reader.GetDateTime(3); note.Title = reader.GetString(4); note.Context = reader.GetString(5); note.Type = (ChinaPay.B3B.Common.Enums.CompanyType)reader.GetByte(6); note.ReleaseType = (ChinaPay.B3B.Common.Enums.ReleaseNoteType)reader.GetByte(7); list.Add(note); } } if (list.Any()) { if (paination.GetRowCount) { paination.RowCount = (int)totalCount.Value; } } return(list); } }
public void Update(Domain.ReleaseNote note) { string sql = "UPDATE dbo.T_ReleaseNote SET CreateTime = @CreateTime ,Creator = @Creator ,UpdateTime = @UpdateTime ,Title = @Title ,Context = @Context ,Type = @Type ,ReleaseType = @ReleaseType WHERE Id = @Id"; using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("CreateTime", note.CreateTime); dbOperator.AddParameter("Creator", note.Creator); dbOperator.AddParameter("UpdateTime", note.UpdateTime); dbOperator.AddParameter("Title", note.Title); dbOperator.AddParameter("Context", note.Context); dbOperator.AddParameter("Type", note.Type); dbOperator.AddParameter("ReleaseType", note.ReleaseType); dbOperator.AddParameter("Id", note.Id); dbOperator.ExecuteNonQuery(sql); } }
public void Add(Domain.ReleaseNote note) { string sql = @"INSERT INTO dbo.T_ReleaseNote(Id,CreateTime,Creator,UpdateTime,Title,Context,Type,ReleaseType) VALUES(@Id,@CreateTime,@Creator,@UpdateTime,@Title,@Context,@Type,@ReleaseType)"; using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("CreateTime", note.CreateTime); dbOperator.AddParameter("Creator", note.Creator); dbOperator.AddParameter("UpdateTime", note.UpdateTime); dbOperator.AddParameter("Title", note.Title); dbOperator.AddParameter("Type", note.Type); dbOperator.AddParameter("Context", note.Context); dbOperator.AddParameter("ReleaseType", note.ReleaseType); dbOperator.AddParameter("Id", note.Id); dbOperator.ExecuteNonQuery(sql); } }