public override DocumentVO ReadRecord(SqlDataReader reader) { DocumentVO result = new DocumentVO(); result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName)); result.InDateTime = reader.GetDateTime(reader.GetOrdinal(documentInDate)); result.InNumber = reader.GetInt32(reader.GetOrdinal(documentInNumber)); result.OutDateTime = reader.GetDateTime(reader.GetOrdinal(documentOutDate)); result.OutNumber = reader.GetInt32(reader.GetOrdinal(documentOutNumber)); result.CreationDate = reader.GetDateTime(reader.GetOrdinal(documentCreationDate)); result.Creator = udao.GetItem(reader.GetInt32(reader.GetOrdinal(documentCreatorId))); result.LastEditDateTime = reader.GetDateTime(reader.GetOrdinal(documentLastEditDate)); result.LastEditor = udao.GetItem(reader.GetInt32(reader.GetOrdinal(documentLastEditorId))); udao.CloseConnection(); result.Destination = ddao.GetItem(reader.GetInt32(reader.GetOrdinal(documentDestinationId))); ddao.CloseConnection(); result.Folder = gdao.GetItem(reader.GetInt32(reader.GetOrdinal(documentFolderId))); gdao.CloseConnection(); result.Title = reader[documentTitle].ToString(); result.Process = reader[documentProcess].ToString(); result.Subject = reader[documentSubject].ToString(); result.Party = pdao.GetItem(reader.GetInt32(reader.GetOrdinal(documentPartyId))); pdao.CloseConnection(); result.IsDeleted = ReadBool(reader, documentIsDeleted); return(result); }
public override FolderVO ReadRecord(SqlDataReader reader) { FolderVO result = new FolderVO(); fDao = new FolderDAO(); result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName)); result.Name = reader[folderName].ToString(); result.IsPermanent = reader.GetBoolean(reader.GetOrdinal(folderIsPermanent)); int?baseFolderid = ReadIntOrNull(reader, baseFolderId); if (baseFolderid != null) { result.BaseFolder = fDao.GetItem(baseFolderid.Value); } else { result.BaseFolder = null; } fDao.CloseConnection(); return(result); }