Ejemplo n.º 1
0
        public static void SetTable(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[1];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(1, false);
        }
Ejemplo n.º 2
0
        public static void SetChart(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable chart = (ITable)sld.Shapes[index];

            for (int i = 0; i < chart.Columns.Count; i++)
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    for (int j = 0; j < (xsts.HasValue ? xsts : dt.Rows.Count); j++)
                    {
                        chart.Columns[i][j + 1].TextFrame.Text = dt.Rows[j][i].ToString();
                    }
                }
            }
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 生成单列图表
        /// </summary>
        /// <param name="sld">当前ppt页面</param>
        /// <param name="dt">数据</param>
        /// <param name="index">图表所属表格排序(当前slide)</param>
        public static void SingleAxexchart(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style)
        {
            IChart chart = (IChart)sld.Shapes[index];

            string range = "Sheet1!$A$1:$" + Base_ColumnsHelper.GET_INDEX(dt.Columns.Count) + "$" + (dt.Rows.Count + 1);
            //实例化图表数据表
            IChartDataWorkbook fact = chart.ChartData.ChartDataWorkbook;

            chart.ChartData.ChartDataWorkbook.Clear(0);

            Workbook workbook = Office_TableToWork.GetWorkBooxFromDataTable(dt);

            MemoryStream mem = new MemoryStream();

            workbook.Save(mem, Aspose.Cells.SaveFormat.Xlsx);
            chart.ChartData.WriteWorkbookStream(mem);

            //设置数据区域
            chart.ChartData.SetRange(range);
            //交换横纵坐标
            if (style.坐标方向 == Base_Config.坐标方向.横向)
            {
                chart.ChartData.SwitchRowColumn();
            }

            IChartSeries series = chart.ChartData.Series[0];

            series.Labels.DefaultDataLabelFormat.ShowValue = style.是否显示文字;
            series.Labels.DefaultDataLabelFormat.Position  = style.文字位置;
            series.Labels.DefaultDataLabelFormat.TextFormat.TextBlockFormat.TextVerticalType = style.文字旋转方向;
        }
Ejemplo n.º 4
0
        public static void SetJP_JINKESHICHANGZHOUBAO_2_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            table.Rows[0][3].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
            table.Rows[0][7].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[2];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(2, false);
        }
Ejemplo n.º 5
0
        public static void SetJP_QIDIXIEXIN_1_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            table.Rows[0][2].TextFrame.Text = string.Format("{0}(认购)", Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1));
            table.Rows[0][6].TextFrame.Text = string.Format("{0}(认购)", Base_date.GET_ZCMC(Base_date.bn, Base_date.bz));


            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[2];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(2, false);
        }
Ejemplo n.º 6
0
        public static void SetJP_JINHUIJIANBAO_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            table.Rows[1][2].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 3);
            table.Rows[1][4].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 2);
            table.Rows[1][6].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
            table.Rows[1][8].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[3];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(3, false);
        }
Ejemplo n.º 7
0
        public static void SetJP_CHONGQINGSHICHANGYINGXIAOBU_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            table.Rows[1][3].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 3);
            table.Rows[1][5].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 2);
            table.Rows[1][7].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
            table.Rows[1][9].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
            table.Rows[1][11].TextFrame.Text = string.Format("{0}月备案", Base_date.sy_First.Month);
            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[3];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(3, false);
        }
Ejemplo n.º 8
0
        public static void SetJP_XIANGYU_JINGPINGBEIAN_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            table.Rows[1][2].TextFrame.Text  = string.Format("备案套数({0})", Base_date.GET_ZCMC(Base_date.bn, Base_date.bz));
            table.Rows[1][10].TextFrame.Text = string.Format("备案套数({0})", Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1));
            table.Rows[1][14].TextFrame.Text = string.Format("累计套数({0})", Base_date.GET_NFYFMC(Base_date.by_First, Base_date.bz_Last));
            table.Rows[1][18].TextFrame.Text = string.Format("累计套数({0})", "1.1-" + Base_date.bz_Last.ToString("M.d"));
            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[2];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(2, false);
        }
Ejemplo n.º 9
0
        public static void SetJP_JINGDIDICHAN_PT_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            table.Rows[1][2].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 3);
            table.Rows[1][6].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 2);
            table.Rows[1][8].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
            table.Rows[1][10].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
            table.Rows[1][12].TextFrame.Text = string.Format("{0}月备案({1})", Base_date.sy_First.Month, Base_date.GET_NFYFMC(Base_date.bn, Base_date.sy_First.Month));
            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[3];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(3, false);
        }
Ejemplo n.º 10
0
        public static void SetJP_ZeKe_JPBX_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts, string yt)
        {
            ITable table = (ITable)sld.Shapes[index];

            if (yt == "商铺")
            {
                table.Rows[0][6].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
                table.Rows[0][9].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
                foreach (System.Data.DataRow item in dt.Rows)
                {
                    IRow row = table.Rows[2];
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        row[i].TextFrame.Text = item[i].ToString();
                    }
                    table.Rows.AddClone(row, false);
                }
                table.Rows.RemoveAt(2, false);
            }
            else
            {
                table.Rows[0][6].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
                table.Rows[0][12].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
                foreach (System.Data.DataRow item in dt.Rows)
                {
                    IRow row = table.Rows[3];
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        row[i].TextFrame.Text = item[i].ToString();
                    }
                    table.Rows.AddClone(row, false);
                }
                table.Rows.RemoveAt(3, false);
            }
        }
Ejemplo n.º 11
0
        public static void SetJP_HuaQiaoCheng_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
        {
            ITable table = (ITable)sld.Shapes[index];

            table.Rows[0][6].TextFrame.Text  = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
            table.Rows[0][10].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
            foreach (System.Data.DataRow item in dt.Rows)
            {
                IRow row = table.Rows[2];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    row[i].TextFrame.Text = item[i].ToString();
                }
                table.Rows.AddClone(row, false);
            }
            table.Rows.RemoveAt(2, false);
            //for (int i = 0; i < chart.Columns.Count; i++)
            //{
            //    if (dt != null && dt.Rows.Count > 0)
            //    {
            //        for (int j = 0; j < (xsts.HasValue ? xsts : dt.Rows.Count); j++)
            //        {
            //            chart.Columns[i][j + 3].TextFrame.Text = dt.Rows[j][i].ToString();
            //            //chart.Rows[i]
            //        }
            //    }
            //}
        }