public ISlideCollection _plus_jp_qidixiexin_1(string str, int cjbh) { try { var param = Cache_param_zb._param_jp.Where(m => m.cjid == cjbh); var p = new Presentation(); var t = p.Slides; t.RemoveAt(0); foreach (var item in param) { var query = from a in item.jpxmlb group a by new { jzgjid = a.jzgjid } into m select new { jzgjid = m.Key.jzgjid, }; List <List <JP_JPXM_INFO> > list = new List <List <JP_JPXM_INFO> >(); foreach (var jzgjid in query) { List <JP_JPXM_INFO> jpxm = item.jpxmlb.Where(m => m.jzgjid == jzgjid.jzgjid).ToList(); list.Add(jpxm); } foreach (var jpxmlb in list) { var tp = new Presentation(str); var temp = tp.Slides; var page1 = temp[0]; IAutoShape text1 = (IAutoShape)page1.Shapes[0]; text1.TextFrame.Text = string.Format(text1.TextFrame.Text, item.bamc); DataTable dt_jpbasj = new DataTable(); dt_jpbasj.Columns.Add(Base_Config_Jzgj.项目名称); dt_jpbasj.Columns.Add(Base_Config_Jzgj.业态); dt_jpbasj.Columns.Add(Base_Config_Rgsj.周_新开套数); dt_jpbasj.Columns.Add(Base_Config_Rgsj.周_认购套数); dt_jpbasj.Columns.Add(Base_Config_Rgsj.周_主力建面区间); dt_jpbasj.Columns.Add(Base_Config_Rgsj.周_认购建面均价); dt_jpbasj.Columns.Add(Base_Config_Rgsj.本周_新开套数); dt_jpbasj.Columns.Add(Base_Config_Rgsj.本周_认购套数); dt_jpbasj.Columns.Add(Base_Config_Rgsj.本周_主力建面区间); dt_jpbasj.Columns.Add(Base_Config_Rgsj.本周_认购建面均价); dt_jpbasj.Columns.Add("本周存量"); dt_jpbasj.Columns.Add("本月认购套数"); dt_jpbasj.Columns.Add("本月建面均价"); dt_jpbasj.Columns.Add(Base_Config_Rgsj.本周_营销动作); dt_jpbasj.Columns.Add(Base_Config_Rgsj.本周_本周到访量); dt_jpbasj.Columns.Add(Base_Config_Rgsj.本周_下周加推预计); dt_jpbasj.Columns.Add("加推套数建面均价"); if (jpxmlb.Count > 0) { //获取竞品项目数据 dt_jpbasj = GET_JPXM_BX_RG(dt_jpbasj, jpxmlb); Office_Tables.SetJP_QIDIXIEXIN_1_Table(page1, dt_jpbasj, 1, null, null); t.AddClone(page1); } } var tp1 = new Presentation(str); var temp1 = tp1.Slides; var page2 = temp1[1]; IAutoShape text2 = (IAutoShape)page2.Shapes[0]; text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc); DataTable dt_2 = new DataTable(); dt_2.Columns.Add(Base_Config_Jzgj.业态); dt_2.Columns.Add("推出库存"); dt_2.Columns.Add("推出区划周期"); dt_2.Columns.Add("未推库存"); dt_2.Columns.Add("中期库存"); dt_2.Columns.Add("中期去化周期"); var jpyt = from a in item.jpxmlb group a by new { ytcs = a.ytcs.Join() } into m select new { yt = m.Key.ytcs, }; foreach (var yt in jpyt) { DataRow dr = dt_2.NewRow(); dr[Base_Config_Jzgj.业态] = yt.yt; dt_2.Rows.Add(dr); } Office_Tables.SetJP_QIDIXIEXIN_2_Table(page2, dt_2, 1, null, null); t.AddClone(page2); } return(t); } catch (Exception e) { Base_Log.Log(e.Message); return(null); } }