public static void SetJP_ZeKe_JPBX_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts, string yt)
{
ITable table = (ITable)sld.Shapes[index];
if (yt == "商铺")
{
table.Rows[0][6].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
table.Rows[0][9].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[2];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(2, false);
}
else
{
table.Rows[0][6].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
table.Rows[0][12].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[3];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(3, false);
}
}
public static void SetJP_HuaQiaoCheng_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
{
ITable table = (ITable)sld.Shapes[index];
table.Rows[0][6].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
table.Rows[0][10].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[2];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(2, false);
//for (int i = 0; i < chart.Columns.Count; i++)
//{
// if (dt != null && dt.Rows.Count > 0)
// {
// for (int j = 0; j < (xsts.HasValue ? xsts : dt.Rows.Count); j++)
// {
// chart.Columns[i][j + 3].TextFrame.Text = dt.Rows[j][i].ToString();
// //chart.Rows[i]
// }
// }
//}
}
public static void SetJP_YANGGUANGCHENG_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
{
ITable table = (ITable)sld.Shapes[index];
table.Rows[0][5].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[3];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(3, false);
}
public static void SetJP_XIANGYU_JINGPINGBEIAN_1_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
{
ITable table = (ITable)sld.Shapes[index];
table.Rows[1][2].TextFrame.Text = string.Format("备案套数（{0}）", Base_date.GET_ZCMC(Base_date.bn, Base_date.bz));
table.Rows[1][10].TextFrame.Text = string.Format("备案套数（{0}）", Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1));
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[2];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(2, false);
}
public static void SetJP_CHONGQINGGONGSIYINGXIAOBU_XIAOSHOUE_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
{
ITable table = (ITable)sld.Shapes[index];
table.Rows[1][2].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 3);
table.Rows[1][3].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 2);
table.Rows[1][4].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
table.Rows[1][5].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[2];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(2, false);
}
public static void SetJP_JINKESHICHANGZHOUBAO_1_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
{
ITable table = (ITable)sld.Shapes[index];
table.Rows[0][3].TextFrame.Text = string.Format("{0}年累计成交建筑面积（万方）", Base_date.bn);
table.Rows[0][4].TextFrame.Text = string.Format("{0}年累计成交金额（万元）", Base_date.bn);
table.Rows[0][5].TextFrame.Text = string.Format("{0}年累计成交套内均价（元/㎡）", Base_date.bn);
table.Rows[0][6].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
table.Rows[0][10].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[2];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(2, false);
}
public static void SetJP_CHONGQINGSHICHANGYINGXIAOBU_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
{
ITable table = (ITable)sld.Shapes[index];
table.Rows[1][3].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 3);
table.Rows[1][5].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 2);
table.Rows[1][7].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
table.Rows[1][9].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
table.Rows[1][11].TextFrame.Text = string.Format("{0}月备案", Base_date.sy_First.Month);
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[3];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(3, false);
}
public static void SetJP_JINGDIDICHAN_PT_Table(ISlide sld, System.Data.DataTable dt, int index, Office_ChartStyle style, int?xsts)
{
ITable table = (ITable)sld.Shapes[index];
table.Rows[1][2].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 3);
table.Rows[1][6].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 2);
table.Rows[1][8].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz - 1);
table.Rows[1][10].TextFrame.Text = Base_date.GET_ZCMC(Base_date.bn, Base_date.bz);
table.Rows[1][12].TextFrame.Text = string.Format("{0}月备案（{1}）", Base_date.sy_First.Month, Base_date.GET_NFYFMC(Base_date.bn, Base_date.sy_First.Month));
foreach (System.Data.DataRow item in dt.Rows)
{
IRow row = table.Rows[3];
for (int i = 0; i < dt.Columns.Count; i++)
{
row[i].TextFrame.Text = item[i].ToString();
}
table.Rows.AddClone(row, false);
}
table.Rows.RemoveAt(3, false);
}
public static string timeUpper(this DateTime target)
{
return(Base_date.dateToUpper(target));
}