public PicNode FindByPath(string path) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Path", SqlDbType.NVarChar, path); sql.AddParameter("@Status", SqlDbType.Int, 0); SqlDataReader reader = sql.ExecuteSqlReader(SqlFindByPath); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.PicNode picNode = new Core.Business.PicNode(); if (!reader.IsDBNull(0)) picNode.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) picNode.Status = reader.GetInt32(1); if (!reader.IsDBNull(2)) picNode.IsFile = reader.GetBoolean(2); if (!reader.IsDBNull(3)) picNode.Root = reader.GetString(3); if (!reader.IsDBNull(4)) picNode.Path = reader.GetString(4); if (!reader.IsDBNull(5)) picNode.Name = reader.GetString(5); reader.Close(); return picNode; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.PicNode> GetAllPicNode() { IList<Core.Business.PicNode> picNodelist = new List<Core.Business.PicNode>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllPicNode); if (reader != null) { while (reader.Read()) { Core.Business.PicNode picNode = new Core.Business.PicNode(); if (!reader.IsDBNull(0)) picNode.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) picNode.Status = reader.GetInt32(1); if (!reader.IsDBNull(2)) picNode.IsFile = reader.GetBoolean(2); if (!reader.IsDBNull(3)) picNode.Root = reader.GetString(3); if (!reader.IsDBNull(4)) picNode.Path = reader.GetString(4); if (!reader.IsDBNull(5)) picNode.Name = reader.GetString(5); picNode.MarkOld(); picNodelist.Add(picNode); } reader.Close(); } return picNodelist; }
public FolderSearchModel Search(FolderSearch packet) { FolderSearchModel result = new FolderSearchModel(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@id", SqlDbType.Int, GetSqlValue(packet.Id > 0 ? (object)packet.Id : null)); sql.AddParameter("@foldername", SqlDbType.NVarChar, GetSqlValue(packet.FolderName)); sql.AddParameter("@keyword", SqlDbType.NVarChar, GetSqlValue(packet.KeyWord)); sql.AddParameter("@photographer", SqlDbType.NVarChar, GetSqlValue(packet.Photographer)); sql.AddParameter("@leader", SqlDbType.NVarChar, GetSqlValue(packet.Leader)); sql.AddParameter("@otherleader", SqlDbType.NVarChar, GetSqlValue(packet.OtherLeader)); sql.AddParameter("@guest", SqlDbType.NVarChar, GetSqlValue(packet.Guest)); sql.AddParameter("@location", SqlDbType.NVarChar, GetSqlValue(packet.Location)); sql.AddParameter("@eventinfo", SqlDbType.Int, GetSqlValue(packet.EventInfo > 0 ? (object)packet.EventInfo : null)); sql.AddParameter("@eventdesc", SqlDbType.NVarChar, GetSqlValue(packet.EventInfoDesc)); sql.AddParameter("@status", SqlDbType.Int, packet.Status != null ? (object)packet.Status.Value : (object)DBNull.Value); SqlDataReader reader = sql.ExecuteSqlReader(SqlSearch); IList<Folder> folders = new List<Folder>(); if (reader != null) { while (reader.Read()) { Core.Business.PicNode picNode = new Core.Business.PicNode(); if (!reader.IsDBNull(0)) picNode.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) picNode.Status = reader.GetInt32(1); if (!reader.IsDBNull(2)) picNode.IsFile = reader.GetBoolean(2); if (!reader.IsDBNull(3)) picNode.Root = reader.GetString(3); if (!reader.IsDBNull(4)) picNode.Path = reader.GetString(4); if (!reader.IsDBNull(5)) picNode.Name = reader.GetString(5); picNode.MarkOld(); FolderDesc folderDesc = new FolderDesc(); if (!reader.IsDBNull(6)) folderDesc.Id = reader.GetInt32(6); if (!reader.IsDBNull(7)) folderDesc.EventInfo = reader.GetInt32(7); if (!reader.IsDBNull(8)) folderDesc.StartDate = reader.GetDateTime(8); if (!reader.IsDBNull(9)) folderDesc.EndDate = reader.GetDateTime(9); if (!reader.IsDBNull(10)) folderDesc.KeyWord = reader.GetString(10); if (!reader.IsDBNull(11)) folderDesc.Photographer = reader.GetString(11); if (!reader.IsDBNull(12)) folderDesc.Leader = reader.GetString(12); if (!reader.IsDBNull(13)) folderDesc.OtherLeader = reader.GetString(13); if (!reader.IsDBNull(14)) folderDesc.Guest = reader.GetString(14); if (!reader.IsDBNull(15)) folderDesc.InnerLocation = reader.GetString(15); if (!reader.IsDBNull(16)) folderDesc.OuterLocation = reader.GetString(16); if (!reader.IsDBNull(17)) folderDesc.EventDesc = reader.GetString(17); folders.Add(new Folder(picNode, folderDesc)); } reader.Close(); } result.Folders = folders; result.Search = packet; return result; }