예제 #1
0
        // Ticket History area:
        public WebReply TicketHistory()
        {
            //Id,TicketId,Body,Added,updated,deleted
            SQLDetective s  = Sys.GetSectionSQL("Ticket History", "TicketHistory", this.ViewGuid);
            Weblist      w  = new Weblist(Sys);
            WebReply     wr = w.GetWebList(s.GenerateQuery(), "Ticket History", "tickethistory", "Body", "TicketHistory", this, false);

            return(wr);
        }
예제 #2
0
        public WebReply PictureList()
        {
            SQLDetective s = Sys.GetSectionSQL("Picture List", "Picture", string.Empty);

            if (WhereClause.Length > 0)
            {
                s.WhereClause = WhereClause;
            }
            else
            {
                s.WhereClause = "Picture.Organization='" + Sys.Organization.ToString() + "' and Picture.Deleted=0  and Picture.ParentID = '" + this.ParentID.ToString() + "'";
            }
            string   sql = s.GenerateQuery();
            Weblist  w   = new Weblist(Sys);
            WebReply wr  = w.GetWebList(sql, "Picture List", "Picture List", "", "Picture", this, false);

            return(wr);
        }
예제 #3
0
        public WebReply DocumentList()
        {
            SQLDetective s = Sys.GetSectionSQL("Document List", "Documents", string.Empty);

            // If they are coming in from the search page
            if (WhereClause.Length > 0)
            {
                s.WhereClause = WhereClause;
            }
            else
            {
                s.WhereClause = "Documents.Organization='" + Sys.Organization.ToString() + "' and Documents.deleted=0  and Documents.ParentID = '" + this.ParentID.ToString() + "'";
            }
            string   sql = s.GenerateQuery();
            Weblist  w   = new Weblist(Sys);
            WebReply wr  = w.GetWebList(sql, "Document List", "Document List", "", "Documents", this, false);

            return(wr);
        }
예제 #4
0
        public WebReply TicketList()
        {
            //Produces a web list of Tickets assigned to the current user
            SQLDetective s = Sys.GetSectionSQL("Ticket List", "Ticket", string.Empty);

            // If they are coming in from the search page
            if (WhereClause.Length > 0)
            {
                s.WhereClause = WhereClause;
            }
            else
            {
                if (ParentID == "")
                {
                    ParentID = Sys.Organization.ToString();
                }
                s.WhereClause = "AssignedTo='" + Sys.UserGuid.ToString() + "' and Ticket.deleted=0  and Ticket.ParentID = '" + this.ParentID.ToString() + "'";
            }
            string   sql = s.GenerateQuery();
            Weblist  w   = new Weblist(Sys);
            WebReply wr  = w.GetWebList(sql, "My Tickets", "Ticket List", "", "Ticket", this, false);

            return(wr);
        }