public ActionResult Authority(FolderSearchModel model)
        {
            if (model == null)
                model = new FolderSearchModel();
            if (model.Search == null)
                model.Search = new FolderSearch();
            model = PicNode.Search(model.Search);

            ViewData["EventInfo"] = EventInfo.GetAllOrder().ToList();

            return View(model);
        }
        public ActionResult Search(FolderSearchModel model, int? id)
        {
            if (model == null)
                model = new FolderSearchModel();

            if (model.Search == null)
                model.Search = new FolderSearch();
            model.Search.Status = (int?)0;
            if (id != null && id.HasValue)
                model.Search.Id = id.Value;

            model = PicNode.Search(model.Search);

            ViewData["EventInfo"] = EventInfo.GetAllOrder().ToList();

            return View(model);
        }
        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;
        }