public void slide20(ISlide slide)
{
// var a = from a in [email protected]()
// group a by
//Charts.SingleAxexchart(slide, Cache_data_cjjl.by., 2);
var query = from t in [email protected]()
group t by new { t1 = t.Field <string>("lpmc") } into m
select new
{
lpmc = m.Key.t1,
cjje = m.Sum(n => n.Field <long>("cjje"))
};
DataTable dt = new DataTable();
dt.Columns.Add("lpmc");
dt.Columns.Add("cjje");
foreach (var item in query.OrderByDescending(m => m.cjje).Take(10).ToList())
{
DataRow dr = dt.NewRow();
dr[0] = item.lpmc;
dr[1] = item.cjje.je_yy();
dt.Rows.Add(dr);
}
Office_ChartStyle style = new Office_ChartStyle();
style.坐标方向 = Base_Config.坐标方向.纵向;
style.文字位置 = Aspose.Slides.Charts.LegendDataLabelPosition.OutsideEnd;
style.文字旋转方向 = TextVerticalType.Horizontal;
style.是否显示文字 = true;
Office_Charts.SingleAxexchart(slide, dt, 1, style);
}
public void slide18(ISlide slide)
{
Office_ChartStyle style = new Office_ChartStyle();
style.坐标方向 = Base_Config.坐标方向.横向;
style.文字位置 = Aspose.Slides.Charts.LegendDataLabelPosition.Center;
style.文字旋转方向 = TextVerticalType.Vertical270;
style.是否显示文字 = true;
Office_Charts.SingleAxexchart(slide, Cache_Result_yb.jsjg_scjgfx, 2, style);
IAutoShape itf = (IAutoShape)slide.Shapes[5];
itf.TextFrame.Paragraphs[0].Text = thread5();
itf.TextFrame.Paragraphs[1].Text = thread6();
ITextFrame tf = itf.TextFrame;
foreach (var item in tf.Paragraphs)
{
IPortion port = item.Portions[0];
port.PortionFormat.LatinFont = new FontData("微软雅黑");
port.PortionFormat.FontBold = NullableBool.NotDefined;
port.PortionFormat.FontHeight = 12;
}
}
