public void Emit(LogEvent logEvent)
{
string id = string.Empty;
try
{
id = IdHelper.GetId();
}
catch
{
id = Guid.NewGuid().ToString();
}
Base_Log base_Log = new Base_Log
{
Id = id,
CreateTime = DateTime.Now,
Level = (int)logEvent.Level,
LogContent = logEvent.RenderMessage(_formatProvider) + logEvent.Exception
};
Task.Factory.StartNew(async() =>
{
using (var db = DbFactory.GetRepository(_conString, _databaseType))
{
await db.InsertAsync(base_Log);
}
}, TaskCreationOptions.LongRunning);
}
/// <summary>
/// 保存用户登录日志 注册日志
/// </summary>
/// <param name="content"></param>
/// <param name="user"></param>
/// <returns></returns>
public Result <Base_Log> WriteLoginLog(string content, Base_User user)
{
Result <Base_Log> result = new Result <Base_Log>();
try
{
Base_Log log = new Base_Log();
log.ClientIP = ApplicationContext.Current.ClientIP;
log.WebServerIP = ApplicationContext.Current.WebIP;
log.ServiceServerIP = ApplicationContext.Current.ServiceIP;
log.ActionDesc = "用户登录";
log.ModuleName = "用户管理";
log.Contents = content;
log.UserAcct = user.UserAcct;
log.UserId = user.Id;//登录失败则写入id为0
log.CreateUserId = user.Id;
log.CreateUserName = user.UserAcct;
log.CreateTime = DateTime.Now;
log.OperateUserId = user.Id;
log.OperateUserName = user.UserAcct;
log.OperateTime = DateTime.Now;
var rows = DataOperateBasic <Base_Log> .Get().Add(log);
result.Data = log;
result.Flag = EResultFlag.Success;
}
catch (Exception ex)
{
result.Data = null;
result.Flag = EResultFlag.Failure;
result.Exception = new ExceptionEx(ex, "WriteLoginLog");
}
return(result);
}
public ISlideCollection _plus_jp_yangguangcheng_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 tp = new Presentation(str);
var temp = tp.Slides;
var page1 = temp[0];
IAutoShape text0_1 = (IAutoShape)page1.Shapes[0];
text0_1.TextFrame.Text = string.Format(text0_1.TextFrame.Text, item.bamc);
DataTable dt1_0 = new DataTable();
dt1_0.Columns.Add(Base_Config_Jzgj.项目名称);
dt1_0.Columns.Add(Base_Config_Jzgj.业态);
dt1_0.Columns.Add(Base_Config_Rgsj.周_本周到访量);
dt1_0.Columns.Add(Base_Config_Rgsj.本周_本周到访量);
dt1_0.Columns.Add(Base_Config_Jzgj.竞争格局_主力面积区间);
dt1_0.Columns.Add(Base_Config_Rgsj.本周_新开套数);
dt1_0.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt1_0.Columns.Add(Base_Config_Cjba.本周_建面均价);
dt1_0.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt1_0.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt1_0.Columns.Add(Base_Config_Rgsj.本周_优惠);
dt1_0.Columns.Add("认购库存套数");
dt1_0.Columns.Add("本周动态");
dt1_0.Columns.Add(Base_Config_Rgsj.本周_活动);
dt1_0.Columns.Add(Base_Config_Rgsj.本周_营销动作);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt1_0 = GET_JPXM_BX_1(dt1_0, item.jpxmlb);
Office_Tables.SetJP_YANGGUANGCHENG_Table(page1, dt1_0, 1, null, null);
t.AddClone(page1);
foreach (var jpitem in item.jpxmlb)
{
var tp1 = new Presentation(str);
var temp1 = tp1.Slides;
var page2 = temp1[1];
IAutoShape text1_1 = (IAutoShape)page2.Shapes[0];
text1_1.TextFrame.Text = string.Format(text1_1.TextFrame.Text, string.Join(",", jpitem.lpcs));
t.AddClone(page2);
}
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_wanhua_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 tp = new Presentation(str);
var temp = tp.Slides;
#region 竞品分布
var page1 = temp[0];
IAutoShape text1 = (IAutoShape)page1.Shapes[1];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, item.bamc);
#endregion
t.AddClone(page1);
#region 格局统计
var page2 = temp[1];
DataTable dt = new DataTable();
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Jzgj.竞争格局_主力面积区间);
dt.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt.Columns.Add(Base_Config_Cjba.本周_套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_活动);
IAutoShape text2 = (IAutoShape)page2.Shapes[1];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc);
#endregion
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_WanHua_JPBX_Table(page2, dt, 2, null, null);
t.AddClone(page2);
}
foreach (var page3 in _plus_jp_dyt_tgtp(item))
{
t.AddClone(page3);
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
/// <summary>
/// 日志列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public IEnumerable <LogEntity> GetPageList(Pagination pagination, string queryJson)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Log where 1=1");
var queryParam = queryJson.ToJObject();
//日志分类
if (!queryParam["Category"].IsEmpty())
{
int categoryId = queryParam["CategoryId"].ToInt();
sql.Append(" and CategoryId=@0", categoryId);
}
//操作时间
if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty())
{
DateTime startTime = queryParam["StartTime"].ToDate();
DateTime endTime = queryParam["EndTime"].ToDate().AddDays(1);
sql.Append(" and OperateTime>=@0", startTime);
sql.Append(" and OperateTime<=@0", endTime);
}
//操作用户Id
if (!queryParam["OperateUserId"].IsEmpty())
{
string operateUserId = queryParam["OperateUserId"].ToString();
sql.Append(" and OperateUserId=@0", operateUserId);
}
//操作用户账户
if (!queryParam["OperateAccount"].IsEmpty())
{
string OperateAccount = queryParam["OperateAccount"].ToString();
sql.Append(" and (charindex(@0,OperateAccount)>0)", OperateAccount);
}
//操作类型
if (!queryParam["OperateType"].IsEmpty())
{
string operateType = queryParam["OperateType"].ToString();
sql.Append(" and OperateType=@0", operateType);
}
//功能模块
if (!queryParam["Module"].IsEmpty())
{
string module = queryParam["Module"].ToString();
sql.Append(" and (charindex(@0,Module)>0)", module);
}
if (!string.IsNullOrWhiteSpace(pagination.sidx))
{
sql.OrderBy(new object[] { pagination.sidx + " " + pagination.sord });
}
var currentpage = Base_Log.Page(pagination.page, pagination.rows, sql);
//数据对象
var pageList = currentpage.Items;
//分页对象
pagination.records = Converter.ParseInt32(currentpage.TotalItems);
return(EntityConvertTools.CopyToList <Base_Log, LogEntity>(pageList));
}
public void Create_zb1()
{
if (dqrw != null)
{
Aspose_Crack.SlideCrack();
DataTable dt = Dal.CJGL_DataProvider.GET_CJLB_BB(dqrw.mbid);
Presentation p1 = SlideFactory.GetInstance().ppt;
p1.Slides.RemoveAt(0);
Base_date.init_zb(dqrw.nf, dqrw.zc);
Cache_param_zb.ini_zb(dqrw.mbid, dqrw.nf, dqrw.zc);
Base_Log.Log("开始任务");
try
{
foreach (DataRow row in dt.Rows)
{
Base_Log.Log("第" + row["cjbh"].ints().ToString() + "号插件");
Type type = Type.GetType(row["cjclass"].ToString()); //
var obj = System.Activator.CreateInstance(type); // 创建实例
MethodInfo method = type.GetMethod(row["cjmethod"].ToString(), new Type[] { typeof(string), typeof(int) }); // 获取方法信息
object[] parameters = new object[] { row["cjdz"], row["cjbh"].ints() };
var slide = method.Invoke(obj, parameters);
if (slide != null && ((SlideCollection)slide).Count > 0)
{
foreach (var item in (SlideCollection)slide)
{
if (item != null)
{
p1.Slides.AddClone(item);
}
} // 调用方法，参数为空
}
}
string path = "E:\\zb\\" + dqrw.mbid + "\\" + dqrw.nf + "\\" + dqrw.zc + "\\";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string filename = path + Base.Base_date.bz + ".pptx";
p1.Save(filename, Aspose.Slides.Export.SaveFormat.Pptx);
if (!new Dal.RWGL_DataProvider().SET_RWZT(dqrw.mbid, dqrw.nf, dqrw.zc, RW_ZT.完成可下载, filename))
{
Base_Log.Log("创建文件成功，插入数据失败");
}
dqrw.zt = Models.Enums.ZX_ZT.生成完毕;
}
catch (Exception e)
{
Base_Log.Log("插件生成报错:" + e.Message);
dqrw.zt = Models.Enums.ZX_ZT.生成完毕;
}
}
else
{
Base_Log.Log("没有当前任务");
}
}
public ISlideCollection _plus_jp_zhaoshangyiyunwan_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 tp = new Presentation(str);
var temp = tp.Slides;
if (item.ytcs == null || item.ytcs[0] != "商铺")
{
var page2 = temp[1];
DataTable dt = new DataTable();
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开销售套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套内均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数环比);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价环比);
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
dt.Columns.Add(Base_Config_Rgsj.本周_优惠);
dt.Columns.Add(Base_Config_Rgsj.本周_活动);
IAutoShape text2 = (IAutoShape)page2.Shapes[0];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, Base_date.GET_ZCMC(Base_date.bn, Base_date.bz));
dt = GET_JPBA_BX(dt, item);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_ZeKe_JPBX_Table(page2, dt, 0, null, null, null);
t.AddClone(page2);
}
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_junfeng_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 tp = new Presentation(str);
var temp = tp.Slides;
var page = temp[0];
IAutoShape text1 = (IAutoShape)page.Shapes[0];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, item.bamc);
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(Base_Config_Jzgj.组团);
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Jzgj.竞争格局_主力面积区间); // 主力套内面积区间
dt.Columns.Add(Base_Config_Cjba.本周_备案套数); //
dt.Columns.Add(Base_Config_Cjba.本周_套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套数); //新开套数
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数); //认购套数
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价); //认购套内均价
dt.Columns.Add(Base_Config_Rgsj.本周_活动); //本周表现及近期动作
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
}
Office_Tables.SetJP_JUNFENG_Table(page, dt, 1, null, null);
t.AddClone(page);
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_xianggangzhidi_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 tp = new Presentation(str);
var temp = tp.Slides;
#region 格局统计
var page = temp[1];
DataTable dt = new DataTable();
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Jzgj.组团);
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_套均总价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.周_套均总价);
dt.Columns.Add("ssz_rgts"); //上上周_备案套数
dt.Columns.Add("ssz_rgtnjj"); //上上周_套内均价
dt.Columns.Add("ssz_tjzj"); //上上周_套内均价
dt.Columns.Add("sssz_rgts"); //上上上周_备案套数
dt.Columns.Add("sssz_rgtnjj"); //上上上周_套内均价
dt.Columns.Add("sssz_tjzj"); //上上上周_套内均价
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
#endregion
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_XiangGangZhiDi_JPBX_Table(page, dt, 1, null, null);
t.AddClone(page);
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.StackTrace);
return(null);
}
}
/// <summary>
/// 写日志
/// </summary>
/// <param name="logEntity">对象</param>
public void WriteLog(LogEntity logEntity)
{
logEntity.LogId = Guid.NewGuid().ToString();
logEntity.OperateTime = DateTime.Now;
logEntity.DeleteMark = 0;
logEntity.EnabledMark = 1;
logEntity.IPAddress = Net.Ip;
logEntity.Host = Net.Host;
logEntity.Browser = Net.Browser;
Base_Log log = EntityConvertTools.CopyToModel <LogEntity, Base_Log>(logEntity, null);
log.Insert();
}
public void execute_rw()
{
try
{
if (rwlb != null && rwlb.Count > 0)
{
if (dqrw == null || dqrw.zt == Models.Enums.ZX_ZT.生成完毕)
{
dqrw = rwlb.FirstOrDefault();
lock (s_lock) {
rwlb.Remove(dqrw);
}
}
}
if (dqrw != null)
{
if (dqrw.zt == Models.Enums.ZX_ZT.未开始)
{
try
{
Base_Log.Log("执行任务开始：");
dqrw.zt = Models.Enums.ZX_ZT.生成中;
Thread th = new Thread(new ThreadStart(Create_zb1));
th.Start();
}
catch (Exception)
{
if (keys == null)
{
keys = new List <string>();
}
keys.Add(dqrw.key);
dqrw.zt = Models.Enums.ZX_ZT.生成完毕;
}
}
else if (dqrw.zt == Models.Enums.ZX_ZT.生成完毕)
{
if (keys == null)
{
keys = new List <string>();
}
keys.Add(dqrw.key);
dqrw = null;
}
}
}
catch (Exception e)
{
throw;
}
}
public bool par(string str, string key)
{
var par = str.Split(',');
if (par.Length == 3)
{
TemplateManage.add_rw(str, key);
Base_Log.Log("任务已经加入队列");
return(true);
}
else
{
return(false);
}
}
protected Base_Log GetBase_SysLogInfo(LogEventInfo logEventInfo)
{
Base_Log newLog = new Base_Log
{
Id = IdHelper.GetId(),
Data = logEventInfo.Properties[LoggerConfig.Data] as string,
Level = logEventInfo.Level.ToString(),
LogContent = logEventInfo.Message,
LogType = logEventInfo.Properties[LoggerConfig.LogType] as string,
CreateTime = logEventInfo.TimeStamp,
CreatorId = logEventInfo.Properties[LoggerConfig.CreatorId] as string,
CreatorRealName = logEventInfo.Properties[LoggerConfig.CreatorRealName] as string
};
return(newLog);
}
public string Create_zb(int mbid, int year, int zc)
{
Aspose_Crack.SlideCrack();
DataTable dt = Dal.CJGL_DataProvider.GET_CJLB_BB(mbid);
Presentation p1 = SlideFactory.GetInstance().ppt;
p1.Slides.RemoveAt(0);
Base_date.init_zb(year, zc);
Cache_param_zb.ini_zb(mbid, year, zc);
Base_Log.Log("开始任务");
try
{
foreach (DataRow row in dt.Rows)
{
Base_Log.Log("第" + row["cjbh"].ints().ToString() + "号插件");
Type type = Type.GetType(row["cjclass"].ToString()); //
var obj = System.Activator.CreateInstance(type); // 创建实例
MethodInfo method = type.GetMethod(row["cjmethod"].ToString(), new Type[] { typeof(string), typeof(int) }); // 获取方法信息
object[] parameters = new object[] { row["cjdz"], row["cjbh"].ints() };
var slide = method.Invoke(obj, parameters);
if (slide != null && ((SlideCollection)slide).Count > 0)
{
foreach (var item in (SlideCollection)slide)
{
if (item != null)
{
p1.Slides.AddClone(item);
}
} // 调用方法，参数为空
}
}
string path = "E:\\zb\\" + mbid + "\\" + year + "\\" + zc + "\\";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string filename = path + Base.Base_date.bz + ".pptx";
p1.Save(filename, Aspose.Slides.Export.SaveFormat.Pptx);
return(filename);
}
catch (Exception e)
{
Base_Log.Log("插件生成报错:" + e.Message);
}
return(null);
}
/// <summary>
/// 清空日志
/// </summary>
/// <param name="categoryId">日志分类Id</param>
/// <param name="keepTime">保留时间段内</param>
public void RemoveLog(int categoryId, string keepTime)
{
DateTime operateTime = DateTime.Now;
if (keepTime == "7")//保留近一周
{
operateTime = DateTime.Now.AddDays(-7);
}
else if (keepTime == "1")//保留近一个月
{
operateTime = DateTime.Now.AddMonths(-1);
}
else if (keepTime == "3")//保留近三个月
{
operateTime = DateTime.Now.AddMonths(-3);
}
Base_Log.Delete("where CategoryId=@0 and OperateTime<=@1", categoryId, operateTime);
}
/// <summary>
/// 写日志
/// </summary>
/// <param name="module">模块</param>
/// <param name="action">功能</param>
/// <param name="content">描述</param>
/// <returns></returns>
public virtual Result <Base_Log> WriteLog(string module, string action, string content)
{
Result <Base_Log> result = new Result <Base_Log>();
try
{
Base_Log log = new Base_Log();
log.ClientIP = ApplicationContext.Current.ClientIP;
log.WebServerIP = ApplicationContext.Current.WebIP;
log.ServiceServerIP = ApplicationContext.Current.ServiceIP;
log.ActionDesc = action;
log.ModuleName = module;
log.Contents = content;
log.UserAcct = CurrentUserName;
log.CreateUserId = CurrentUser.Id;
log.CreateUserName = CurrentUser.UserAcct;
log.CreateTime = DateTime.Now;
log.OperateUserId = CurrentUser.Id;
log.OperateUserName = CurrentUser.UserAcct;
log.OperateTime = DateTime.Now;
try
{
log.UserId = CurrentUser.Id;
}
catch
{
log.UserId = 0;
}
var rows = DataOperateBasic <Base_Log> .Get().Add(log);
result.Data = log;
result.Flag = EResultFlag.Success;
}
catch (Exception ex)
{
result.Data = null;
result.Flag = EResultFlag.Failure;
result.Exception = new ExceptionEx(ex, "WriteLog");
}
return(result);
}
public ISlideCollection _plus_jp_beimengzhidi_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)
{
#region 市场量价
if (item.qtcs == "市场量价")
{
var tp = new Presentation(str);
var temp = tp.Slides;
var page1 = temp[0];
#region 商品房
var jbz_cjba_spf = (from a in Cache_data_cjjl.jbz.AsEnumerable()
where a["zt"].ToString() == item.ztcs[0]
group a by new { zc = a["zc"], zcmc = a["zcmc"] } into s
select new
{
zc = s.Key.zc,
zcmc = s.Key.zcmc,
cjje = s.Sum(a => a["cjje"].longs()),
jzmj = s.Sum(a => a["jzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var jbz_xzys_spf = (from a in Cache_data_xzys.jbz.AsEnumerable()
where a["zt"].ToString() == item.ztcs[0]
group a by new { zc = a["zc"] } into s
select new
{
zc = s.Key.zc,
xzgy = s.Sum(a => a["jzmj"].doubls()) + s.Sum(a => a["fzzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var temp_spf = (from a in jbz_cjba_spf
join b in jbz_xzys_spf on a.zc equals b.zc into tempdata
from tt in tempdata.DefaultIfEmpty()
select new
{
zcmc = a.zcmc,
xzgyl = tt == null ? 0 : tt.xzgy, //这里主要第二个集合有可能为空。需要判断
cjmj = a.jzmj,
jmjj = a.cjje / a.jzmj
}).ToList();
DataTable dt_spf = new DataTable();
dt_spf.Columns.Add("周次名称");
dt_spf.Columns.Add("供应体量(万方）");
dt_spf.Columns.Add("成交体量(万方）");
dt_spf.Columns.Add("建面均价");
foreach (var item_spf in temp_spf)
{
DataRow dr = dt_spf.NewRow();
dr["周次名称"] = item_spf.zcmc;
dr["供应体量(万方）"] = item_spf.xzgyl.mj_wf();
dr["成交体量(万方）"] = item_spf.cjmj.mj_wf();
dr["建面均价"] = item_spf.jmjj.je_y();
dt_spf.Rows.Add(dr);
}
Office_Charts.Chart_gxfx(page1, dt_spf, 3);
#endregion
#region 商品住宅
var jbz_cjba_zz = (from a in Cache_data_cjjl.jbz.AsEnumerable()
where a["zt"].ToString() == item.ztcs[0] && (a["yt"].ToString() == "别墅" || a["yt"].ToString() == "高层" || a["yt"].ToString() == "小高层" || a["yt"].ToString() == "洋房" || a["yt"].ToString() == "洋楼")
group a by new { zc = a["zc"], zcmc = a["zcmc"] } into s
select new
{
zc = s.Key.zc,
zcmc = s.Key.zcmc,
cjje = s.Sum(a => a["cjje"].longs()),
jzmj = s.Sum(a => a["jzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var jbz_xzys_zz = (from a in Cache_data_xzys.jbz.AsEnumerable()
where a["zt"].ToString() == item.ztcs[0] && (a["tyyt"].ToString() == "别墅" || a["tyyt"].ToString() == "高层" || a["tyyt"].ToString() == "小高层" || a["tyyt"].ToString() == "洋房" || a["tyyt"].ToString() == "洋楼")
group a by new { zc = a["zc"] } into s
select new
{
zc = s.Key.zc,
xzgy = s.Sum(a => a["jzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var temp_zz = (from a in jbz_cjba_zz
join b in jbz_xzys_zz on a.zc equals b.zc into tempdata
from tt in tempdata.DefaultIfEmpty()
select new
{
zcmc = a.zcmc,
xzgyl = tt == null ? 0 : tt.xzgy, //这里主要第二个集合有可能为空。需要判断
cjmj = a.jzmj,
jmjj = a.cjje / a.jzmj
}).ToList();
DataTable dt_zz = new DataTable();
dt_zz.Columns.Add("周次名称");
dt_zz.Columns.Add("供应体量(万方）");
dt_zz.Columns.Add("成交体量(万方）");
dt_zz.Columns.Add("建面均价");
foreach (var item_zz in temp_zz)
{
DataRow dr = dt_zz.NewRow();
dr["周次名称"] = item_zz.zcmc;
dr["供应体量(万方）"] = item_zz.xzgyl.mj_wf();
dr["成交体量(万方）"] = item_zz.cjmj.mj_wf();
dr["建面均价"] = item_zz.jmjj.je_y();
dt_zz.Rows.Add(dr);
}
Office_Charts.Chart_gxfx(page1, dt_zz, 4);
#endregion
IAutoShape text0_1 = (IAutoShape)page1.Shapes[0];
text0_1.TextFrame.Text = string.Format(text0_1.TextFrame.Text, item.ztcs[0], temp_spf[temp_spf.Count - 1].xzgyl.mj_wf(), temp_spf[temp_spf.Count - 1].cjmj.mj_wf(), temp_spf[temp_spf.Count - 1].jmjj.je_y());
IAutoShape text0_2 = (IAutoShape)page1.Shapes[1];
text0_2.TextFrame.Text = string.Format(text0_2.TextFrame.Text, item.ztcs[0], temp_zz[temp_zz.Count - 1].xzgyl.mj_wf(), temp_zz[temp_zz.Count - 1].cjmj.mj_wf(), temp_zz[temp_zz.Count - 1].jmjj.je_y());
IAutoShape text0_3 = (IAutoShape)page1.Shapes[2];
text0_3.TextFrame.Text = string.Format(text0_3.TextFrame.Text, item.bamc);
t.AddClone(page1);
}
#endregion
else
{
var tp = new Presentation(str);
var temp = tp.Slides;
var page2 = temp[1];
IAutoShape text1_1 = (IAutoShape)page2.Shapes[0];
text1_1.TextFrame.Text = string.Format(text1_1.TextFrame.Text, item.bamc);
IAutoShape text1_2 = (IAutoShape)page2.Shapes[2];
text1_2.TextFrame.Text = string.Format(text1_2.TextFrame.Text, item.bamc);
#region 市场成交走势
#region 商务
if (item.ytcs[0] == "商务")
{
var jbz_cjba_sw = (from a in Cache_data_cjjl.jbz.AsEnumerable()
where (a["yt"].ToString() == "商务" && a["xfyt"].ToString() == "商务公寓" && a["hx"].ToString() == "LOFT")
group a by new { zc = a["zc"], zcmc = a["zcmc"] } into s
select new
{
zc = s.Key.zc,
zcmc = s.Key.zcmc,
cjje = s.Sum(a => a["cjje"].longs()),
jzmj = s.Sum(a => a["jzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var jbz_xzys_sw = (from a in Cache_data_xzys.jbz.AsEnumerable()
where a["wylx"].ToString() == "SOHO" || a["wylx"].ToString() == "LOFT"
group a by new { zc = a["zc"] } into s
select new
{
zc = s.Key.zc,
xzgy = s.Sum(a => a["jzmj"].doubls()) + s.Sum(a => a["fzzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var temp_spf = (from a in jbz_cjba_sw
join b in jbz_xzys_sw on a.zc equals b.zc into tempdata
from tt in tempdata.DefaultIfEmpty()
select new
{
zcmc = a.zcmc,
xzgyl = tt == null ? 0 : tt.xzgy, //这里主要第二个集合有可能为空。需要判断
cjmj = a.jzmj,
jmjj = a.cjje / a.jzmj
}).ToList();
DataTable dt_spf = new DataTable();
dt_spf.Columns.Add("周次名称");
dt_spf.Columns.Add("供应体量（㎡）");
dt_spf.Columns.Add("成交体量（㎡）");
dt_spf.Columns.Add("建面均价（元/㎡）");
foreach (var item_spf in temp_spf)
{
DataRow dr = dt_spf.NewRow();
dr["周次名称"] = item_spf.zcmc;
dr["供应体量（㎡）"] = item_spf.xzgyl.mj();
dr["成交体量（㎡）"] = item_spf.cjmj.mj();
dr["建面均价（元/㎡）"] = item_spf.jmjj.je_y();
dt_spf.Rows.Add(dr);
}
Office_Charts.Chart_gxfx(page2, dt_spf, 1);
var bz_cjba_sw_pm = (from a in Cache_data_cjjl.jbz.AsEnumerable()
where (a["yt"].ToString() == "商务" && a["xfyt"].ToString() == "商务公寓" && a["hx"].ToString() == "LOFT" && a["zc"].ints() == Base_date.bz && a["nf"].ints() == Base_date.bn)
group a by new { lpmc = a["lpmc"], qy = a["qy"] } into s
select new
{
lpmc = s.Key.lpmc,
qy = s.Key.qy,
cjts = s.Count(),
jzmj = s.Sum(a => a["jzmj"].doubls()).mj(),
cjje = s.Sum(a => a["cjje"].doubls()).je_wy(),
jmjj = (s.Sum(a => a["cjje"].doubls()) / s.Sum(a => a["jzmj"].doubls())).je_y()
}).OrderByDescending(m => m.cjje).Take(10).ToList();
DataTable pm_tb = new DataTable();
pm_tb.Columns.Add("排名");
pm_tb.Columns.Add("项目名称");
pm_tb.Columns.Add("区域");
pm_tb.Columns.Add("成交套数");
pm_tb.Columns.Add("成交面积");
pm_tb.Columns.Add("成交金额");
pm_tb.Columns.Add("成交建均");
for (int i = 0; i < bz_cjba_sw_pm.Count(); i++)
{
DataRow drss = pm_tb.NewRow();
drss["排名"] = i + 1;
drss["项目名称"] = bz_cjba_sw_pm[i].lpmc;
drss["区域"] = bz_cjba_sw_pm[i].qy;
drss["成交套数"] = bz_cjba_sw_pm[i].cjts;
drss["成交面积"] = bz_cjba_sw_pm[i].jzmj;
drss["成交金额"] = bz_cjba_sw_pm[i].cjje;
drss["成交建均"] = bz_cjba_sw_pm[i].jmjj;
pm_tb.Rows.Add(drss);
}
Office_Tables.SetTable(page2, pm_tb, 3, null, null);
t.AddClone(page2);
}
#endregion
#region 商铺
else if (item.ytcs[0] == "商铺")
{
var jbz_cjba_spf = (from a in Cache_data_cjjl.jbz.AsEnumerable()
where a["yt"].ToString() == item.ytcs[0]
group a by new { zc = a["zc"], zcmc = a["zcmc"] } into s
select new
{
zc = s.Key.zc,
zcmc = s.Key.zcmc,
cjje = s.Sum(a => a["cjje"].longs()),
jzmj = s.Sum(a => a["jzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var jbz_xzys_spf = (from a in Cache_data_xzys.jbz.AsEnumerable()
where a["tyyt"].ToString() == item.ytcs[0]
group a by new { zc = a["zc"] } into s
select new
{
zc = s.Key.zc,
xzgy = s.Sum(a => a["jzmj"].doubls()) + s.Sum(a => a["fzzmj"].doubls()),
}).OrderBy(m => m.zc).ToList();
var temp_spf = (from a in jbz_cjba_spf
join b in jbz_xzys_spf on a.zc equals b.zc into tempdata
from tt in tempdata.DefaultIfEmpty()
select new
{
zcmc = a.zcmc,
xzgyl = tt == null ? 0 : tt.xzgy, //这里主要第二个集合有可能为空。需要判断
cjmj = a.jzmj,
jmjj = a.cjje / a.jzmj
}).ToList();
DataTable dt_spf = new DataTable();
dt_spf.Columns.Add("周次名称");
dt_spf.Columns.Add("供应体量(万方）");
dt_spf.Columns.Add("成交体量(万方）");
dt_spf.Columns.Add("建面均价");
foreach (var item_spf in temp_spf)
{
DataRow dr = dt_spf.NewRow();
dr["周次名称"] = item_spf.zcmc;
dr["供应体量(万方）"] = item_spf.xzgyl.mj_wf();
dr["成交体量(万方）"] = item_spf.cjmj.mj_wf();
dr["建面均价"] = item_spf.jmjj.je_y();
dt_spf.Rows.Add(dr);
}
Office_Charts.Chart_gxfx(page2, dt_spf, 1);
var bz_cjba_sw_pm = (from a in Cache_data_cjjl.jbz.AsEnumerable()
where a["yt"].ToString() == item.ytcs[0] && a["zc"].ints() == Base_date.bz && a["nf"].ints() == Base_date.bn
group a by new { lpmc = a["lpmc"], zt = a["zt"] } into s
select new
{
lpmc = s.Key.lpmc,
zt = s.Key.zt,
cjts = s.Count(),
jzmj = s.Sum(a => a["jzmj"].doubls()).mj(),
cjje = s.Sum(a => a["cjje"].doubls()).je_wy(),
jmjj = (s.Sum(a => a["cjje"].doubls()) / s.Sum(a => a["jzmj"].doubls())).je_y()
}).OrderByDescending(m => m.cjje).Take(10).ToList();
DataTable pm_tb = new DataTable();
pm_tb.Columns.Add("排名");
pm_tb.Columns.Add("项目名称");
pm_tb.Columns.Add("区域");
pm_tb.Columns.Add("成交套数");
pm_tb.Columns.Add("成交面积");
pm_tb.Columns.Add("成交金额");
pm_tb.Columns.Add("成交建均");
for (int i = 0; i < bz_cjba_sw_pm.Count(); i++)
{
DataRow drss = pm_tb.NewRow();
drss["排名"] = i + 1;
drss["项目名称"] = bz_cjba_sw_pm[i].lpmc;
drss["区域"] = bz_cjba_sw_pm[i].zt;
drss["成交套数"] = bz_cjba_sw_pm[i].cjts;
drss["成交面积"] = bz_cjba_sw_pm[i].jzmj;
drss["成交金额"] = bz_cjba_sw_pm[i].cjje;
drss["成交建均"] = bz_cjba_sw_pm[i].jmjj;
pm_tb.Rows.Add(drss);
}
Office_Tables.SetTable(page2, pm_tb, 3, null, null);
t.AddClone(page2);
}
#endregion
#endregion
#region 典型竞争项目
var page3 = temp[2];
DataTable dt_jzxm = new DataTable();
dt_jzxm.Columns.Add(Base_Config_Jzgj.项目名称);
dt_jzxm.Columns.Add(Base_Config_Jzgj.业态);
dt_jzxm.Columns.Add(Base_Config_Jzgj.竞争格局_主力面积区间);
dt_jzxm.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt_jzxm.Columns.Add(Base_Config_Cjba.本周_建面均价);
dt_jzxm.Columns.Add(Base_Config_Cjba.本周_套均总价);
dt_jzxm.Columns.Add("产品、配置及营销");
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
IAutoShape text2 = (IAutoShape)page3.Shapes[0];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc);
dt_jzxm = GET_JPXM_BX(dt_jzxm, item.jpxmlb);
Office_Tables.SetJP_BEIMENGZHIDI_JINGZHENGXIANGMU_Table(page3, dt_jzxm, 1, null, null);
t.AddClone(page3);
}
#endregion
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public int DeleteLog(Base_Log user)
{
user.DeleteMark = 1;
return(dbUtil._myDb.Update(user));
}
public int UpdateLog(Base_Log user)
{
return(dbUtil._myDb.Update(user));
}
public int AddLog(Base_Log user)
{
return(dbUtil._myDb.Insert(user));
}
/// <summary>
/// 大业态循环
/// </summary>
/// <param name="str"></param>
/// <param name="cjbh"></param>
/// <returns></returns>
public ISlideCollection _plus_jp_jiazhaoye_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);
#region P2
foreach (var item in param)
{
var tp = new Presentation(str);
var temp = tp.Slides;
var page = temp[0];
IAutoShape text1 = (IAutoShape)page.Shapes[0];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, item.bamc);
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(Base_Config_Jzgj.竞争格局名称);
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开销售套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套内均价);
dt.Columns.Add(Base_Config_Cjba.周_备案套数);
dt.Columns.Add(Base_Config_Cjba.周_套内均价);
dt.Columns.Add(Base_Config_Cjba.周_建面均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt.Columns.Add(Base_Config_Cjba.本周_套内均价);
dt.Columns.Add(Base_Config_Cjba.本周_建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数环比);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价环比);
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
dt.Columns.Add(Base_Config_Rgsj.本周_营销动作);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
}
Office_Tables.SetJP_JiaZhaoYe_Table(page, dt, 3, null, null);
t.AddClone(page);
}
#endregion
#region P3
foreach (var item in _plus_jp_dyt_tgtp(cjbh))
{
if (item != null)
{
t.AddClone(item);
}
}
#endregion
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_huaqiaocheng_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);
//#region P1
//foreach (var item in _plus_jp_dyt_jzgj(cjbh))
//{
// if (item != null)
// t.AddClone(item);
//}
//#endregion
foreach (var item in param)
{
var tp = new Presentation(str);
var temp = tp.Slides;
#region 竞品分布
foreach (var jpfb in _plus_jp_dyt_jzgj(item))
{
t.AddClone(jpfb);
}
#endregion
// t.AddClone(page1);
#region 格局统计
var page1 = temp[0];
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开销售套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套内均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购套内体量);
dt.Columns.Add(Base_Config_Rgsj.周_认购金额);
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内体量);
dt.Columns.Add(Base_Config_Rgsj.本周_认购金额);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_营销动作);
IAutoShape text1 = (IAutoShape)page1.Shapes[4];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, item.bamc, item.ytcs[0]);
dt = GET_JPXM_BX(dt, item.jpxmlb);
#endregion
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_HuaQiaoCheng_Table(page1, dt, 2, null, null);
t.AddClone(page1);
}
foreach (var page3 in _plus_jp_dyt_tgtp(item))
{
t.AddClone(page3);
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_yangguang100ximalaya_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 _plus_jp_dyt_jzgj(cjbh))
{
if (item != null)
{
t.AddClone(item);
}
}
#region 竞争格局
foreach (var item in param)
{
var tp = new Presentation(str);
var temp = tp.Slides;
#region 格局图片
#endregion
#region 格局统计
var page = temp[1];
IAutoShape text = (IAutoShape)page.Shapes[2];
text.TextFrame.Text = string.Format(text.TextFrame.Text, item.lpcs[0], item.ytcs[0]);
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(Base_Config_Jzgj.竞争格局名称);
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开销售套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套内均价);
dt.Columns.Add(Base_Config_Cjba.周_备案套数);
dt.Columns.Add(Base_Config_Cjba.周_套内均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价);
dt.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt.Columns.Add(Base_Config_Cjba.本周_套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_成交套数环比);
dt.Columns.Add(Base_Config_Rgsj.本周_套内均价环比);
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_RUIAN_JPBX_Table(page, dt.AsEnumerable().OrderBy(m => m["jzgjmc"]).CopyToDataTable(), 4, null, null);
t.AddClone(page);
}
#endregion
#region 竞争格局
var page1 = temp[2];
IAutoShape text1 = (IAutoShape)page1.Shapes[1];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, item.lpcs[0], item.ytcs[0]);
System.Data.DataTable dt1 = new System.Data.DataTable();
dt1.Columns.Add("xm");
dt1.Columns.Add("yt");
dt1.Columns.Add("yh");
dt1.Columns.Add("yxdz");
dt1.Columns.Add("xzjtyj");
dt1.Columns.Add("bkfs");
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_JQDZ(dt1, item.jpxmlb);
Office_Tables.SetJP_RUIAN_JQHD_Table(page1, dt, 0, null, null);
t.AddClone(page1);
}
#endregion
#region 周度排名
ISlide sld1 = new Presentation(str).Slides[3];
t.AddClone(this._plus_jp_zdpm(sld1, item.bamc, new string[] { "高层" }));
ISlide sld2 = new Presentation(str).Slides[3];
t.AddClone(this._plus_jp_zdpm(sld2, item.bamc, new string[] { "洋房", "别墅" }));
ISlide sld3 = new Presentation(str).Slides[3];
t.AddClone(this._plus_jp_zdpm(sld3, item.bamc, new string[] { "商铺" }));
#endregion
}
#endregion
#region 推广图片
foreach (var item in _plus_jp_dyt_tgtp(cjbh))
{
if (item != null)
{
t.AddClone(item);
}
}
#endregion
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_yangguang100aerle_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 tp = new Presentation(str);
var temp = tp.Slides;
var page1 = temp[0];
IAutoShape text0_1 = (IAutoShape)page1.Shapes[1];
text0_1.TextFrame.Text = string.Format(text0_1.TextFrame.Text, item.bamc, item.ytcs[0]);
var page2 = temp[1];
DataTable dt2_0 = new DataTable();
dt2_0.Columns.Add(Base_Config_Jzgj.项目名称);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_新开套数);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_新开销售套数);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_新开建面均价);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_本周来电);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_本周到访量);
dt2_0.Columns.Add(Base_Config_Cjba.周_备案套数);
dt2_0.Columns.Add(Base_Config_Cjba.周_建面均价);
dt2_0.Columns.Add(Base_Config_Cjba.周_套均总价);
dt2_0.Columns.Add(Base_Config_Cjba.周_建筑面积);
dt2_0.Columns.Add(Base_Config_Cjba.周_成交金额);
dt2_0.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt2_0.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt2_0.Columns.Add(Base_Config_Rgsj.周_认购金额);
dt2_0.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt2_0.Columns.Add(Base_Config_Cjba.本周_建面均价);
dt2_0.Columns.Add(Base_Config_Cjba.本周_套均总价);
dt2_0.Columns.Add(Base_Config_Cjba.本周_建筑面积);
dt2_0.Columns.Add(Base_Config_Cjba.本周_成交金额);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt2_0.Columns.Add(Base_Config_Rgsj.本周_认购金额);
dt2_0.Columns.Add("剩余套数");
dt2_0.Columns.Add(Base_Config_Rgsj.本周_变化原因);
dt2_0 = GET_JPBA_BX(dt2_0, item);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
IAutoShape text2 = (IAutoShape)page2.Shapes[1];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc, item.ytcs[0]);
dt2_0 = GET_JPXM_BX(dt2_0, item.jpxmlb);
Office_Tables.SetJP_CHONGQING18TI_Table(page2, dt2_0, 2, null, null);
t.AddClone(page2);
}
var page3 = temp[2];
IAutoShape text3 = (IAutoShape)page3.Shapes[1];
text3.TextFrame.Text = string.Format(text3.TextFrame.Text, item.bamc, item.ytcs[0]);
DataTable dt1 = new DataTable();
dt1.Columns.Add(Base_Config_Jzgj.项目名称);
dt1.Columns.Add(Base_Config_Rgsj.本周_优惠);
dt1.Columns.Add(Base_Config_Rgsj.本周_活动);
dt1.Columns.Add(Base_Config_Rgsj.本周_优惠);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt1 = GET_JPXM_BX(dt1, item.jpxmlb);
Office_Tables.SetTable(page3, dt1, 2, null, null);
}
t.AddClone(page3);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
foreach (var jpitem in item.jpxmlb)
{
var tp1 = new Presentation(str);
var temp1 = tp1.Slides;
var page4 = temp1[3];
DataTable dttemp = Cache_data_cjjl.jbz.Select("zc>=" + (Base_date.bz - 3)).CopyToDataTable();
var data = from a in dttemp.AsEnumerable()
where a["lpmc"].ToString() == jpitem.lpcs[0] && a["yt"].ToString() == jpitem.ytcs[0]
group a by new { zc = a["zc"], zcmc = a["zcmc"] } into s
select new
{
zc = s.Key.zc,
zcmc = s.Key.zcmc,
ts = s.Sum(m => m["ts"].ints()),
jmjj = s.Sum(m => m["cjje"].longs()) / s.Sum(m => m["jzmj"].doubls())
};
DataTable dt4_0 = new DataTable();
dt4_0.Columns.Add("周次名称");
dt4_0.Columns.Add("精装成交套数");
dt4_0.Columns.Add("精装成交均价");
foreach (var tempitem in data)
{
DataRow dr = dt4_0.NewRow();
dr["周次名称"] = tempitem.zcmc;
dr["精装成交套数"] = tempitem.ts;
dr["精装成交均价"] = tempitem.jmjj.je_y();
dt4_0.Rows.Add(dr);
}
IAutoShape text4_0 = (IAutoShape)page4.Shapes[0];
text4_0.TextFrame.Text = string.Format(text4_0.TextFrame.Text, item.bamc, item.ytcs[0]);
IAutoShape text4_1 = (IAutoShape)page4.Shapes[1];
text4_1.TextFrame.Text = string.Format(text4_1.TextFrame.Text, jpitem.lpcs[0], jpitem.ytcs[0]);
//无法将类型为“Aspose.Slides.OleObjectFrame”的对象强制转换为类型“Aspose.Slides.Charts.IChart”。
//Office_Charts.Chart_gxfx(pag4, dt4_0, 2);
t.AddClone(page4);
var pag5 = temp1[4];
IAutoShape text5_0 = (IAutoShape)pag5.Shapes[1];
text5_0.TextFrame.Text = string.Format(text5_0.TextFrame.Text, item.bamc, item.ytcs[0]);
IAutoShape text5_1 = (IAutoShape)pag5.Shapes[2];
text5_1.TextFrame.Text = string.Format(text5_1.TextFrame.Text, jpitem.lpcs[0], jpitem.ytcs[0]);
t.AddClone(pag5);
}
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
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);
}
}
public ISlideCollection _plus_jp_lvdi_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 tp = new Presentation(str);
var temp = tp.Slides;
if (item.ytcs[0] != "商务")
{
#region 格局统计
var page1 = temp[0];
DataTable dt = new DataTable();
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价环比);
dt.Columns.Add("bzcl");
dt.Columns.Add();
dt.Columns.Add("bybajmjj");
dt.Columns.Add(Base_Config_Rgsj.本周_营销动作);
IAutoShape text2 = (IAutoShape)page1.Shapes[0];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc);
#endregion
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_LVDI_PUTONG_Table(page1, dt, 1, null, null);
t.AddClone(page1);
}
foreach (var page3 in _plus_jp_dyt_tgtp(item))
{
t.AddClone(page3);
}
}
else
{
#region 格局统计
var page2 = temp[1];
DataTable dt = new DataTable();
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Cjba.周_备案套数);
dt.Columns.Add(Base_Config_Cjba.周_建面均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Cjba.周_备案套数);
dt.Columns.Add(Base_Config_Cjba.周_建面均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Cjba.周_备案套数);
dt.Columns.Add(Base_Config_Cjba.周_建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt.Columns.Add(Base_Config_Cjba.本周_建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_营销动作);
IAutoShape text2 = (IAutoShape)page2.Shapes[0];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_LVDI_PUTONG_Table(page2, dt, 1, null, null);
t.AddClone(page2);
}
#endregion
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_shouchuang_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 tp = new Presentation(str);
var temp = tp.Slides;
#region 格局统计
DataTable dt = new DataTable();
if (item.ytcs[0] == "商铺" || item.ytcs[0] == "商务")
{
var page = temp[1];
dt.Columns.Add(Base_Config_Jzgj.竞争格局名称);
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Jzgj.竞争格局_主力面积区间);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt.Columns.Add(Base_Config_Cjba.周_备案套数); //上上上周_备案套数
dt.Columns.Add(Base_Config_Cjba.周_套内均价); //上上上周_套内均价
dt.Columns.Add(Base_Config_Cjba.周_备案套数); //上上周_备案套数
dt.Columns.Add(Base_Config_Cjba.周_套内均价); //上上周_套内均价
dt.Columns.Add(Base_Config_Cjba.周_备案套数);
dt.Columns.Add(Base_Config_Cjba.周_建面均价);
dt.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt.Columns.Add(Base_Config_Cjba.本周_建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
dt.Columns.Add(Base_Config_Rgsj.本周_营销动作);
IAutoShape text2 = (IAutoShape)page.Shapes[0];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc, item.ytcs != null ? item.ytcs[0] : "");
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_ShouChuang_JPBX_swsp_Table(page, dt, 1, null, null);
t.AddClone(page);
}
}
else
{
var page = temp[0];
dt.Columns.Add(Base_Config_Jzgj.竞争格局名称);
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Jzgj.竞争格局_主力面积区间);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套内均价);
dt.Columns.Add(Base_Config_Rgsj.本周_新开套数);
dt.Columns.Add(Base_Config_Rgsj.本周_新开销售套数);
dt.Columns.Add(Base_Config_Rgsj.新开套内均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数); //上上上周_备案套数
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价); //上上上周_套内均价
dt.Columns.Add(Base_Config_Rgsj.周_认购套数); //上上上周_备案套数
dt.Columns.Add(Base_Config_Rgsj.周_认购套内均价); //上上上周_套内均价
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
dt.Columns.Add(Base_Config_Rgsj.本周_营销动作);
IAutoShape text2 = (IAutoShape)page.Shapes[2];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc, item.ytcs != null ? item.ytcs[0] : "");
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_ShouChuang_JPBX_Table(page, dt, 1, null, null);
t.AddClone(page);
}
}
#endregion
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_nanquyingxiao_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);
var tp1 = new Presentation(str);
var temp1 = tp1.Slides;
#region 竞品首页
var page1 = temp1[0];
IAutoShape text1 = (IAutoShape)page1.Shapes[2];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, Base_date.GET_ZCMC(Base_date.bn, Base_date.bz));
#endregion
t.AddClone(page1);
#region 竞品分布
var page2 = temp1[1];
#endregion
t.AddClone(page2);
foreach (var item in param)
{
var tp = new Presentation(str);
var temp = tp.Slides;
t.AddClone(page2);
var page3 = temp[3];
DataTable dt = new DataTable();
#region 格局统计
if (item.ytcs[0] == "商务" || item.ytcs[0] == "商铺")
{
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面体量);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建筑面积环比);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数环比);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价环比);
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
IAutoShape text2 = (IAutoShape)page2.Shapes[2];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_BiGuiYuan_JPBX_Table(page3, dt, 5, null, null);
t.AddClone(page2);
}
}
#endregion
else
{
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Cjba.本周_建筑面积);
dt.Columns.Add(Base_Config_Cjba.本周_建筑面积环比);
dt.Columns.Add(Base_Config_Cjba.本周_备案套数);
dt.Columns.Add(Base_Config_Cjba.本周_备案套数环比);
dt.Columns.Add(Base_Config_Cjba.本周_建面均价);
dt.Columns.Add(Base_Config_Cjba.本周_建面均价环比);
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
IAutoShape text2 = (IAutoShape)page2.Shapes[2];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_BiGuiYuan_JPBX_Table(page3, dt, 5, null, null);
t.AddClone(page2);
}
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_ruian_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 tp = new Presentation(str);
var temp = tp.Slides;
var page = temp[0];
IAutoShape text = (IAutoShape)page.Shapes[2];
text.TextFrame.Text = string.Format(text.TextFrame.Text, item.bamc, item.ytcs[0]);
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("qy");
dt.Columns.Add("lpmc");
dt.Columns.Add("yt");
dt.Columns.Add("xkts");
dt.Columns.Add("xkxsts");
dt.Columns.Add("xktnjj");
dt.Columns.Add("szbats");
dt.Columns.Add("szbatnjj");
dt.Columns.Add("szrgts");
dt.Columns.Add("szrgtnjj");
dt.Columns.Add("bzbats");
dt.Columns.Add("bzbatnjj");
dt.Columns.Add("bzrgts");
dt.Columns.Add("bzrgtnjj");
dt.Columns.Add("thb");
dt.Columns.Add("jghb");
dt.Columns.Add("bhyy");
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_RUIAN_JPBX_Table(page, dt.AsEnumerable().OrderBy(m => m["qy"]).CopyToDataTable(), 4, null, null);
t.AddClone(page);
}
var page1 = temp[1];
IAutoShape text1 = (IAutoShape)page1.Shapes[1];
text1.TextFrame.Text = string.Format(text1.TextFrame.Text, item.bamc, item.ytcs[0]);
System.Data.DataTable dt1 = new System.Data.DataTable();
dt1.Columns.Add("xm");
dt1.Columns.Add("yh");
dt1.Columns.Add("yxdz");
dt1.Columns.Add("xzjtyj");
dt1.Columns.Add("bkfs");
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_JQDZ(dt1, item.jpxmlb);
Office_Tables.SetJP_RUIAN_JQHD_Table(page1, dt, 3, null, null);
t.AddClone(page1);
}
}
foreach (var item in _plus_jp_dyt_tgtp(cjbh))
{
if (item != null)
{
t.AddClone(item);
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
public ISlideCollection _plus_jp_hejingfutai_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)
{
if (string.IsNullOrEmpty(item.qtcs))
{
var tp = new Presentation(str);
var temp = tp.Slides;
#region 持销项目销售
var page2 = temp[1];
DataTable dt = new DataTable();
dt.Columns.Add(Base_Config_Jzgj.业态);
dt.Columns.Add(Base_Config_Jzgj.组团);
dt.Columns.Add(Base_Config_Jzgj.项目名称);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.周_认购建面均价);
dt.Columns.Add(Base_Config_Rgsj.本周_认购套数);
dt.Columns.Add(Base_Config_Rgsj.本周_认购建面均价);
dt.Columns.Add("sybats");
dt.Columns.Add("sybajj");
dt.Columns.Add(Base_Config_Rgsj.本周_变化原因);
IAutoShape text2 = (IAutoShape)page2.Shapes[0];
text2.TextFrame.Text = string.Format(text2.TextFrame.Text, item.bamc);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
dt = GET_JPXM_BX(dt, item.jpxmlb);
Office_Tables.SetJP_XUHUICHENG_CHIXUXIAOSHOUXIANGMU_Table(page2, dt, 1, null, null);
t.AddClone(page2);
}
#endregion
}
else
{
var tp = new Presentation(str);
var temp = tp.Slides;
var page3 = temp[2];
t.AddClone(page3);
var page4 = temp[3];
DataTable dt4 = new DataTable();
dt4.Columns.Add("kfs");
dt4.Columns.Add("hj");
dt4.Columns.Add("sssz_cjje");
dt4.Columns.Add("ssz_cjje");
dt4.Columns.Add("sz_cjje");
dt4.Columns.Add("bz_cjje");
dt4 = GET_JPXM_ZT_CJJE(dt4, item.jpxmlb);
dt4 = GET_JPBA_CJJE(dt4, item);
Office_Tables.SetJP_XUHUICHENG_XIAOSHOUE_Table(page4, dt4, 1, null, null);
IAutoShape text4 = (IAutoShape)page4.Shapes[0];
text4.TextFrame.Text = string.Format(text4.TextFrame.Text, item.bamc);
t.AddClone(page4);
foreach (var item_jp in item.jpxmlb)
{
DataTable dt5 = new DataTable();
dt5.Columns.Add("kfs");
dt5.Columns.Add("hj");
dt5.Columns.Add("sssz");
dt5.Columns.Add("ssz");
dt5.Columns.Add("sz");
dt5.Columns.Add("bz");
dt5 = GET_JPXM_XF_CJJE(dt5, item_jp);
var page5 = new Presentation(str).Slides[4];
Office_Tables.SetJP_XUHUICHENG_XIAOSHOUE_Table(page5, dt5, 0, null, null);
IAutoShape text5 = (IAutoShape)page5.Shapes[1];
text5.TextFrame.Text = string.Format(text5.TextFrame.Text, item_jp.kfs);
t.AddClone(page5);
}
}
}
return(t);
}
catch (Exception e)
{
Base_Log.Log(e.Message);
return(null);
}
}
