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);
}
}
