示例#1
0
        public static string MakeTableRotate(List <object[]> dt, string caption, string footer, string style, int maxColumn, int maxCounter, int pco, int counter, int LastCounter)
        {
            StringBuilder html          = new StringBuilder();
            bool          isCustomStyle = false;

            if (style.Contains("<style type"))
            {
                isCustomStyle = true;
            }


            //????
            if (counter.Equals(0))
            {
                html.Append("<html><head><meta charset='utf-8'/>");
                html.Append(DetermineStyle.GetStyle(style));
                html.Append("</head><body>");
            }
            //???
            if (isCustomStyle == false)
            {
                string appendName = style.Equals(string.Empty) ? DetermineStyle.ST_BLUE : style;
                html.Append("<div class='datagrid" + appendName + "'>");
                html.Append("<table>");
            }
            else
            {
                string styleName = DetermineStyle.DetermineStyleName(style);
                html.Append("<table class='" + styleName + "'>");
            }
            if (caption != null && caption.Trim() != "")
            {
                html.Append("<caption>" + caption + "</caption>");
            }

            html.Append("<thead>");

            if (pco > maxColumn)
            {
                pco = 0;
            }


            html.Append("<tr>");


            for (int r1 = 0; r1 < maxCounter; r1++)
            {
                string newName = dt[r1][pco].ToString();
                html.Append("<th>");
                html.Append(newName);
                html.Append("</th>");
            }



            html.Append("</tr>");
            html.Append("</thead>");
            html.Append("<tbody>");



            //int i = 0;
            for (int i1 = 0; i1 < maxColumn; i1++)
            {
                if (i1 == pco)
                {
                    continue;
                }

                html.Append("<tr>");
                html.Append("<td>");
                html.Append(dt[0][i1]);
                html.Append("</td>");

                for (int i2 = 1; i2 < maxCounter; i2++)
                {
                    html.Append("<td>");
                    if (dt[i2][i1].ToString().Trim().Contains("<"))
                    {
                        html.Append(dt[i2][i1].ToString().Replace("<", "&lt;").Replace(">", "&gt;"));
                    }
                    else
                    {
                        html.Append(dt[i2][i1]);
                    }
                    html.Append("</td>");
                }
                html.Append("</tr>");
            }
            html.Append("</tbody>");

            string customFooter = footer;

            if (footer == "#")
            {
                customFooter = "Total records : " + maxCounter.ToString();
            }
            html.Append("<tfoot><tr><td colspan='" + maxColumn.ToString() + "'>" + customFooter + "</td></tr></tfoot>");

            html.Append("</table>");

            if (isCustomStyle == false)
            {
                html.Append("</div>");
            }

            if (counter == LastCounter)
            {
                html.Append("</body>");
                html.Append("</html>");
            }

            string retvalu = html.ToString();

            html = null;
            return(retvalu);
        }
示例#2
0
        public static string MakeTable(List <object[]> dt, string caption, string footer, string style, int maxColumn, int maxCounter, int counter, int lastCounter)
        {
            var html          = new StringBuilder();
            var isCustomStyle = style.Contains("<style type");

            if (counter.Equals(0))
            {
                html.Append("<html><head><meta charset='utf-8'/>");
                html.Append(DetermineStyle.GetStyle(style));
                html.Append("</head><body>");
            }
            //???
            if (isCustomStyle == false)
            {
                var appendName = style.Equals(string.Empty) ? DetermineStyle.StBlue : style;
                html.Append("<div class='datagrid" + appendName + "'>");
                html.Append("<table>");
            }
            else
            {
                var styleName = DetermineStyle.DetermineStyleName(style);
                html.Append("<table class='" + styleName + "'>");
            }
            if (caption != null && caption.Trim() != "")
            {
                html.Append("<caption>" + caption + "</caption>");
            }

            html.Append("<thead>");


            html.Append("<tr>");


            //Apply column headers
            for (var i1 = 0; i1 < maxColumn; i1++)
            {
                html.Append("<th>");
                html.Append(dt[0][i1].ToString());
                html.Append("</th>");
            }
            html.Append("</tr>");
            html.Append("</thead>");
            html.Append("<tbody>");



            //int i = 0;
            for (var i1 = 1; i1 < maxCounter; i1++)
            {
                html.Append("<tr>");

                for (var i2 = 0; i2 < maxColumn; i2++)
                {
                    html.Append("<td>");
                    if (dt[i1][i2].ToString().Trim().Contains("<"))
                    {
                        html.Append(dt[i1][i2].ToString().Replace("<", "&lt;").Replace(">", "&gt;"));
                    }
                    else
                    {
                        html.Append(dt[i1][i2]);
                    }

                    html.Append("</td>");
                }

                html.Append("</tr>");
            }
            html.Append("</tbody>");

            string customFooter = footer;

            if (footer == "#")
            {
                customFooter = "Total records : " + maxCounter;
            }
            html.Append("<tfoot><tr><td colspan='" + maxColumn + "'>" + customFooter + "</td></tr></tfoot>");

            html.Append("</table>");

            if (isCustomStyle == false)
            {
                html.Append("</div>");
            }

            if (counter == lastCounter)
            {
                html.Append("</body>");
                html.Append("</html>");
            }

            string retvalu = html.ToString();

            html = null;
            return(retvalu);
        }
示例#3
0
        public static string MakeTableRotate(List <object[]> dt, string caption, string footer, string style,
                                             int maxColumn, int maxCounter, int pco, int counter, int lastCounter)
        {
            var html          = new StringBuilder();
            var isCustomStyle = style.Contains("<style type");


            //????
            if (counter.Equals(0))
            {
                html.Append("<html><head><meta charset='utf-8'/>");
                html.Append(DetermineStyle.GetStyle(style));
                html.Append("</head><body>");
            }
            //???
            if (isCustomStyle == false)
            {
                string appendName = style.Equals(string.Empty) ? DetermineStyle.StBlue : style;
                html.Append($"<div class=\'datagrid{appendName}\'>");
                html.Append("<table>");
            }
            else
            {
                string styleName = DetermineStyle.DetermineStyleName(style);
                html.Append($"<table class=\'{styleName}\'>");
            }
            if (caption != null && caption.Trim() != "")
            {
                html.Append($"<caption>{caption}</caption>");
            }

            html.Append("<thead>");

            if (pco > maxColumn)
            {
                pco = 0;
            }


            html.Append("<tr>");


            for (int r1 = 0; r1 < maxCounter; r1++)
            {
                string newName = dt[r1][pco].ToString();
                html.Append("<th>");
                html.Append(newName);
                html.Append("</th>");
            }



            html.Append("</tr>");
            html.Append("</thead>");
            html.Append("<tbody>");



            //int i = 0;
            for (int i1 = 0; i1 < maxColumn; i1++)
            {
                if (i1 == pco)
                {
                    continue;
                }

                html.Append("<tr>");
                html.Append("<td>");
                html.Append(dt[0][i1]);
                html.Append("</td>");

                for (int i2 = 1; i2 < maxCounter; i2++)
                {
                    html.Append("<td>");
                    if (dt[i2][i1].ToString().Trim().Contains("<"))
                    {
                        html.Append(dt[i2][i1].ToString().Replace("<", "&lt;").Replace(">", "&gt;"));
                    }
                    else
                    {
                        html.Append(dt[i2][i1]);
                    }
                    html.Append("</td>");
                }
                html.Append("</tr>");
            }
            html.Append("</tbody>");

            var customFooter = footer;

            if (footer == "#")
            {
                customFooter = $"Total records : {maxCounter}";
            }
            html.Append($"<tfoot><tr><td colspan=\'{maxColumn}\'>{customFooter}</td></tr></tfoot>");

            html.Append("</table>");

            if (isCustomStyle == false)
            {
                html.Append("</div>");
            }

            if (counter == lastCounter)
            {
                html.Append("</body>");
                html.Append("</html>");
            }

            var retvalu = html.ToString();

            // ReSharper disable once RedundantAssignment
            html = null;
            return(retvalu);
        }