Example #1
0
        //=================================
        //
        //=================================
        /*
        private EDGAMenu buildMenu()
        {
            EDGAMenu menu = new EDGAMenu();
            menu.MenuWidth = "";
            EDGAMenuItem item  = new EDGAMenuItem();
            item.Text = "Reports";
            item.HREF = "reportpicker.aspx";
            menu.AddMenuItem(item);
            item = new EDGAMenuItem();
            item.Text = "Change Dates";
            item.HREF = "default.aspx?RID=" + this.m_report.OTCReportId;
            menu.AddMenuItem(item);
            item = new EDGAMenuItem();
            item.Text = "<img src=\"/edga/images/icons/csv.gif\" border=\"0\">";
            string qstring = "report.aspx?RID=" + this.m_report.OTCReportId + "&thread=csv&STD=" + this.m_startDate.ToShortDateString() + "&EDT=" + this.m_endDate.ToShortDateString();
            if(this.m_lineOrderId > 0)
                qstring += "&LID=" + this.m_lineOrderId;
            item.HREF = qstring;
            menu.AddMenuItem(item);
            return(menu);
        }
        */
        //==================================
        //
        //==================================
        private void buildGrid(DataTable dt, DataRow[] rows)
        {
            string className = "gridRowAlt";

            Response.Write("<br><table class=\"tableWrapper\" cellpadding=\"3\" cellspacing=\"0\" width=\"100%\" border=\"0\">"
                + CR + " <tr>"
                + CR + "  <td colspan=\"" + ((dt.Columns.Count / 2) + 2) + "\" class=\"gridHeader\"><b>" + this.m_report.OTCReportName + "</b> " + this.m_startDate.ToShortDateString()+ "<i> thru </i>" + this.m_endDate.ToShortDateString() + " - " + this.m_report.OTCReportDescription + " : <b>" + rows.Length + " : Records</b></td>"
                + CR + "  <td align=\"right\" class=\"gridHeader\" nowrap colspan=\"" + ((dt.Columns.Count / 2) - 2)+ "\">[ <a href=\"default.aspx?RID=" + this.m_reportId + "\">change dates</a> ] &nbsp; [ <a href=\"reportpicker.aspx\">change report</a> ]</td>"
                + CR + " <tr>"
                );

            foreach(DataColumn dc in dt.Columns)
            {
                string qstring = "reporter.aspx?sort=" + dc.ColumnName + "&dir=" + (this.m_sortDirection == "DESC" ? "ASC" : "DESC") + "&STD=" + this.m_startDate.ToShortDateString() + "&EDT=" + this.m_endDate.ToShortDateString() + "&RID=" + this.m_reportId;
                if(this.m_lineOrderId > 0)
                    qstring += "&LID=" + this.m_lineOrderId;

                if(dc.ColumnName != "SortEm" && dc.ColumnName.IndexOf("NO_DISPLAY") == -1)
                    Response.Write("  <td class=\"gridHeader\" nowrap><b><a href=\"" + qstring + "\">" + dc.ColumnName + "</a></td>" + CR);
            }

            Response.Write(" </tr>" + CR);

            OTCEncryption crypt = new OTCEncryption(7);

            foreach(DataRow dr in rows)
            {
                className = className == "gridRow" ? "gridRowAlt" : "gridRow";
                Response.Write(" <tr class=\"" + className + "\" valign=\"top\">" + CR);
                foreach(DataColumn dc in dt.Columns)
                {
                    string columnData  = "";
                    string columnAlign = "";

                    switch(dc.DataType.Name)
                    {
                        case "DateTime" :
                            columnData  = Convert.ToDateTime(dr[dc.ColumnName]).ToShortDateString() != "1/1/1900" ? Convert.ToDateTime(dr[dc.ColumnName]).ToShortDateString() : "NEVER";
                            columnAlign = "left";
                            break;
                        case "String" :
                            columnData  = dr[dc.ColumnName].ToString();
                            columnAlign = "left";
                            break;
                        default :
                            columnData  = dr[dc.ColumnName].ToString();
                            columnAlign = "right";
                            break;
                    }

                    if(dc.ColumnName != "SortEm" && dc.ColumnName.IndexOf("NO_DISPLAY") == -1)
                    {
                        if(dc.ColumnName.IndexOf("DECRYPT") > -1)
                        {
                            //USED FOR SRS ONLY
                            if(dc.ColumnName != "DECRYPT_EXPIRES")
                                columnData = crypt.Decrypt(columnData.Replace("DECRYPT_",""));
                            else
                            {
                                string month = crypt.Decrypt(columnData.Split(' ')[0]);
                                string year  = crypt.Decrypt(columnData.Split(' ')[1]);
                                columnData = (month.Length < 2 ? "0" + month : month) + "/" + year.Substring(2,2);
                            }
                        }
                        Response.Write(" <td class=\"formFont\" align=\"" + columnAlign + "\" nowrap>" + columnData.Replace(":^~^:","<br>") + "</td>" + CR);
                    }
                }
                Response.Write(" </tr>");
            }

            Response.Write("</table>" + CR);
        }