public ISlide _plus_jp_zdpm(ISlide sld, string bamc, string[] yt)
{
#region 准备数据
var data_zd = (from a in Cache_data_cjjl.bz.AsEnumerable()
where yt.Contains(a["yt"])
group a by new
{
lpmc = a["lpmc"],
zt = a["zt"]
} into g
select new
{
lpmc = g.Key.lpmc,
zt = g.Key.zt,
cjts = g.Sum(m => m["ts"].ints()),
cjje = g.Sum(m => m["cjje"].longs()).je_y(),
jzmj = g.Sum(m => m["jzmj"].doubls()).mj(),
tnmj = g.Sum(m => m["tnmj"].doubls()).mj(),
}
into b
orderby b.cjje descending
select b).Take(5).ToList();
#endregion
#region 生成页面
if (data_zd != null & data_zd.Count > 0)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("pm");
dt.Columns.Add("lpmc");
dt.Columns.Add("cjts");
dt.Columns.Add("cjje");
dt.Columns.Add("jzmj");
dt.Columns.Add("tnmj");
dt.Columns.Add("jmjj");
dt.Columns.Add("tnjj");
dt.Columns.Add("tjzj");
dt.Columns.Add("rxyy");
for (int i = 0; i < data_zd.Count; i++)
{
DataRow dr = dt.NewRow();
dr["pm"] = i + 1;
dr["lpmc"] = data_zd[i].lpmc;
dr["cjts"] = data_zd[i].cjts;
dr["cjje"] = data_zd[i].cjje.je_wy();
dr["jzmj"] = data_zd[i].jzmj.mj();
dr["tnmj"] = data_zd[i].tnmj.mj();
dr["jmjj"] = (data_zd[i].cjje / data_zd[i].jzmj).je_y();
dr["tnjj"] = (data_zd[i].cjje / data_zd[i].tnmj).je_y();
dr["tjzj"] = (data_zd[i].cjje / data_zd[i].cjts).je_wy();
dr["rxyy"] = "自填";
dt.Rows.Add(dr);
}
IAutoShape text1 = (IAutoShape)sld.Shapes[1];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, bamc, string.Join(",", yt));
Office_Tables.SetJP_YG100XMLY_ZDYTPM_Table(sld, dt, 2, null, null);
IAutoShape text2 = (IAutoShape)sld.Shapes[3];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, string.Join(",", yt), Base_date.GET_ZCMC(Base_date.bn, Base_date.bz));
return(sld);
}
#endregion
return(null);
}
