public DataTable GET_JPXM_XF_CJJE(DataTable dt, JP_JPXM_INFO jpxm)
{
string sql = "zc >=" + (Base_date.bz - 3) + " and zc<=" + Base_date.bz;
var query = (from t in Cache_data_rgsj.jbz.Select(sql).AsEnumerable()
where jpxm.kfs.Contains(t["qymc"])
group t by new { xm = t["xm"], yt = t["yt"] } into m
select new
{
xm = m.Key.xm + "(" + m.Key.yt + ")",
hj = m.Sum(n => n["rgje"].longs()),
sssz = m.Where(a => a["zc"].ints() == (Base_date.bz - 3)).Sum(n => n["rgje"].longs()),
ssz = m.Where(a => a["zc"].ints() == (Base_date.bz - 2)).Sum(n => n["rgje"].longs()),
sz = m.Where(a => a["zc"].ints() == (Base_date.bz - 1)).Sum(n => n["rgje"].longs()),
bz = m.Where(a => a["zc"].ints() == Base_date.bz).Sum(n => n["rgje"].longs()),
}).ToList();
foreach (var item in query)
{
DataRow dr = dt.NewRow();
dr["kfs"] = item.xm;
dr["hj"] = item.hj;
dr["sssz"] = item.sssz;
dr["ssz"] = item.ssz;
dr["sz"] = item.sz;
dr["bz"] = item.bz;
dt.Rows.Add(dr);
}
return(dt);
}
private static List <JP_BA_INFO> _param_jp_helper(int mbid, int nf, int zc)
{
DataTable batable = Dal.Param_DataProvider.GET_JP_BAXX(mbid, nf, zc);
DataTable jptable = Dal.Param_DataProvider.GET_JP_JPXMXX(mbid, nf, zc);
List <JP_BA_INFO> list = new List <JP_BA_INFO>();
foreach (DataRow item in batable.Rows)
{
JP_BA_INFO jp = new JP_BA_INFO();
jp.cjid = item["cjid"].ints();
jp.id = item["id"].ints();
jp.bamc = item["bamc"].ToString();
jp.rwid = item["rwid"].ints();
jp.qycs = item["qycs"] == null || string.IsNullOrEmpty(item["qycs"].ToString()) ? null : item["qycs"].ToString().Split(',');
jp.kfs = item["kfs"] == null || string.IsNullOrEmpty(item["kfs"].ToString()) ? null : item["kfs"].ToString().Split(',');
jp.ztcs = item["ztcs"] == null || string.IsNullOrEmpty(item["ztcs"].ToString()) ? null : item["ztcs"].ToString().Split(',');
jp.lpcs = item["lpcs"] == null || string.IsNullOrEmpty(item["lpcs"].ToString()) ? null : item["lpcs"].ToString().Split(',');
jp.ytcs = item["ytcs"] == null || string.IsNullOrEmpty(item["ytcs"].ToString()) ? null : item["ytcs"].ToString().Split(',');
jp.xfytcs = item["xfytcs"] == null || string.IsNullOrEmpty(item["xfytcs"].ToString()) ? null : item["xfytcs"].ToString().Split(',');
jp.hxcs = item["hxcs"] == null || string.IsNullOrEmpty(item["hxcs"].ToString()) ? null : item["hxcs"].ToString().Split(',');
jp.zlmjqj = item["zlmjqj"] == null || string.IsNullOrEmpty(item["zlmjqj"].ToString()) ? null : item["zlmjqj"].ToString().Split(',');
jp.qtcs = item["qtcs"].ToString();
jp.jpxmlb = new List <JP_JPXM_INFO>();
var xmlist = jptable.AsEnumerable().Where(m => m["baid"].ints() == item["id"].ints()).OrderBy(m => m["px"]);
foreach (var xm in xmlist)
{
JP_JPXM_INFO jpxm = new JP_JPXM_INFO();
jpxm.id = xm["id"].ints();
jpxm.baid = xm["baid"].ints();
jpxm.jzgjid = xm["jzgjid"].ints();
jpxm.jzgjmc = xm["jzgjmc"].ToString();
jpxm.px = xm["px"].ints();
jpxm.qycs = xm["qycs"] == null || string.IsNullOrEmpty(xm["qycs"].ToString()) ? null : xm["qycs"].ToString().Split(',');
jpxm.kfs = xm["kfs"] == null || string.IsNullOrEmpty(xm["kfs"].ToString()) ? null : xm["kfs"].ToString().Split(',');
jpxm.ztcs = xm["ztcs"] == null || string.IsNullOrEmpty(xm["ztcs"].ToString()) ? null : xm["ztcs"].ToString().Split(',');
jpxm.lpcs = xm["lpcs"] == null || string.IsNullOrEmpty(xm["lpcs"].ToString()) ? null : xm["lpcs"].ToString().Split(',');
jpxm.ytcs = xm["ytcs"] == null || string.IsNullOrEmpty(xm["ytcs"].ToString()) ? null : xm["ytcs"].ToString().Split(',');
jpxm.xfytcs = xm["xfytcs"] == null || string.IsNullOrEmpty(xm["xfytcs"].ToString()) ? null : xm["xfytcs"].ToString().Split(',');
jpxm.hxcs = xm["hxcs"] == null || string.IsNullOrEmpty(xm["hxcs"].ToString()) ? null : xm["hxcs"].ToString().Split(',');
jpxm.zlmjqj = xm["zlmjqj"] == null || string.IsNullOrEmpty(xm["zlmjqj"].ToString()) ? null : xm["zlmjqj"].ToString().Split(',');
jp.jpxmlb.Add(jpxm);
}
list.Add(jp);
}
return(list);
}
public DataRow GET_ROW(string yt, DataRow dr1, System.Data.DataTable dt,
DataRow temp_rgsj_bz,
DataRow temp_rgsj_sz,
DataRow temp_rgsj_ssz,
DataRow temp_rgsj_sssz,
EnumerableRowCollection <DataRow> temp_cjba_bz,
EnumerableRowCollection <DataRow> temp_cjba_sz,
EnumerableRowCollection <DataRow> temp_cjba_ssz,
EnumerableRowCollection <DataRow> temp_cjba_sssz,
JP_JPXM_INFO item)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
try
{
#region 认购
if (Base_Config_Rgsj._认购数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Rgsj.周_新开套数:
case Base_Config_Rgsj.周_新开销售套数:
case Base_Config_Rgsj.周_新开建面均价:
case Base_Config_Rgsj.周_新开套内均价:
case Base_Config_Rgsj.周_认购套数:
case Base_Config_Rgsj.周_认购套内体量:
case Base_Config_Rgsj.周_认购套内均价:
case Base_Config_Rgsj.周_认购建面体量:
case Base_Config_Rgsj.周_认购建面均价:
case Base_Config_Rgsj.周_认购金额:
{
if (temp_rgsj_sz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_sz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Rgsj.本周_新开套数:
case Base_Config_Rgsj.本周_新开销售套数:
case Base_Config_Rgsj.本周_新开建面均价:
case Base_Config_Rgsj.本周_新开套内均价:
case Base_Config_Rgsj.本周_认购套数:
case Base_Config_Rgsj.本周_认购套内体量:
case Base_Config_Rgsj.本周_认购套内均价:
case Base_Config_Rgsj.本周_认购建面体量:
case Base_Config_Rgsj.本周_认购建面均价:
case Base_Config_Rgsj.本周_认购金额:
{
if (temp_rgsj_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_bz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Rgsj.周_新开套数:
case Base_Config_Rgsj.周_新开销售套数:
case Base_Config_Rgsj.周_新开建面均价:
case Base_Config_Rgsj.周_新开套内均价:
case Base_Config_Rgsj.周_认购套数:
case Base_Config_Rgsj.周_认购套内体量:
case Base_Config_Rgsj.周_认购套内均价:
case Base_Config_Rgsj.周_认购建面体量:
case Base_Config_Rgsj.周_认购建面均价:
case Base_Config_Rgsj.周_认购金额:
{
if (temp_rgsj_ssz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_ssz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Rgsj.周_新开套数:
case Base_Config_Rgsj.周_新开销售套数:
case Base_Config_Rgsj.周_新开建面均价:
case Base_Config_Rgsj.周_新开套内均价:
case Base_Config_Rgsj.周_认购套数:
case Base_Config_Rgsj.周_认购套内体量:
case Base_Config_Rgsj.周_认购套内均价:
case Base_Config_Rgsj.周_认购建面体量:
case Base_Config_Rgsj.周_认购建面均价:
case Base_Config_Rgsj.周_认购金额:
{
if (temp_rgsj_sssz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_ssz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Rgsj.本周_认购套数环比: { dr1[dt.Columns[j].ColumnName] = temp_rgsj_sz["rgts"] != null && temp_rgsj_sz["rgts"].ints() != 0 ? ((temp_rgsj_bz["rgts"].ints() - temp_rgsj_sz["rgts"].ints()) / temp_rgsj_sz["rgts"].ints()).doubls().ss_bfb() : "0%"; }; break;
case Base_Config_Rgsj.本周_认购金额环比: { dr1[dt.Columns[j].ColumnName] = temp_rgsj_sz["rgje"] != null && temp_rgsj_sz["rgje"].ints() != 0 ? ((temp_rgsj_bz["rgts"].ints() - temp_rgsj_sz["rgts"].ints()) / temp_rgsj_sz["rgts"].ints()).doubls().ss_bfb() : "0%"; }; break;
case Base_Config_Rgsj.本周_认购建筑面积环比: { dr1[dt.Columns[j].ColumnName] = temp_rgsj_sz["rgjmtl"] != null && temp_rgsj_sz["rgjmtl"].ints() != 0 ? ((temp_rgsj_bz["rgjmtl"].ints() - temp_rgsj_sz["rgjmtl"].ints()) / temp_rgsj_sz["rgjmtl"].ints()).doubls().ss_bfb() : "0%"; }; break;
case Base_Config_Rgsj.本周_认购套内面积环比: { }; break;
case Base_Config_Rgsj.本周_认购建面均价环比: { dr1[dt.Columns[j].ColumnName] = temp_rgsj_sz["rgjmjj"] != null && temp_rgsj_sz["rgjmjj"].ints() != 0 ? ((temp_rgsj_bz["rgjmjj"].ints() - temp_rgsj_sz["rgjmjj"].ints()) / temp_rgsj_sz["rgjmjj"].ints()).doubls().ss_bfb() : "0%"; }; break;
case Base_Config_Rgsj.本周_认购套内均价环比: { }; break;
case Base_Config_Rgsj.本周_认购套均总价环比: { }; break;
default:
{
try
{
if (temp_rgsj_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_bz[dt.Columns[j].ColumnName];
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}
catch (Exception)
{
dr1[dt.Columns[j].ColumnName] = "-";
}
}; break;
}
}
#endregion
#region 备案
else if (Base_Config_Cjba._备案数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
#region 本周
case Base_Config_Cjba.本周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz != null?temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_备案套数._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.本周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz != null?temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()) : 0; }; break;
case Base_Config_Cjba.本周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz != null?temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls()) : 0; }; break;
case Base_Config_Cjba.本周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz != null?temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.本周_建面均价:
{
if ((temp_cjba_bz != null && temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.本周_套内均价:
{
if ((temp_cjba_bz != null && temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
#endregion
#region 周
case Base_Config_Cjba.周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz != null?temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz != null?temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) : 0; }; break;
case Base_Config_Cjba.周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz != null?temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls()) : 0; }; break;
case Base_Config_Cjba.周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz != null?temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.周_建面均价:
{
if ((temp_cjba_sz != null && temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.周_套内均价:
{
if ((temp_cjba_sz != null && temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
#endregion
#region 周
case Base_Config_Cjba.周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_cjba_ssz != null?temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_cjba_ssz != null?temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) : 0; }; break;
case Base_Config_Cjba.周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_ssz != null?temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls()) : 0; }; break;
case Base_Config_Cjba.周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_ssz != null?temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.周_建面均价:
{
if ((temp_cjba_ssz != null && temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].longs()) / temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.周_套内均价:
{
if ((temp_cjba_ssz != null && temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].longs()) / temp_cjba_ssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
#endregion
#region 周
case Base_Config_Cjba.周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sssz != null?temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sssz != null?temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) : 0; }; break;
case Base_Config_Cjba.周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sssz != null?temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls()) : 0; }; break;
case Base_Config_Cjba.周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sssz != null?temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.周_建面均价:
{
if ((temp_cjba_sssz != null && temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].longs()) / temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.周_套内均价:
{
if ((temp_cjba_sssz != null && temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].longs()) / temp_cjba_sssz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
#endregion
#region 其他
case Base_Config_Cjba.本周_备案套数环比:
{
dr1[dt.Columns[j].ColumnName] = ((temp_cjba_bz.Sum(m => m["ts"].ints()) - temp_cjba_sz.Sum(m => m["ts"].ints())) / temp_cjba_sz.Sum(m => m["ts"].ints())).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_套内均价环比:
{
long bz_cjje = temp_cjba_bz.Sum(m => m["cjje"].ints());
long bz_tnmj = temp_cjba_bz.Sum(m => m["tnmj"].ints());
long sz_cjje = temp_cjba_sz.Sum(m => m["cjje"].ints());
long sz_tnmj = temp_cjba_sz.Sum(m => m["tnmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_tnmj - sz_cjje / sz_tnmj) / (sz_cjje / sz_tnmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_套内面积环比:
{
long bz_tnmj = temp_cjba_bz.Sum(m => m["tnmj"].ints());
long sz_tnmj = temp_cjba_sz.Sum(m => m["tnmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_tnmj - sz_tnmj) / (sz_tnmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_套均总价环比:
{
long bz_cjje = temp_cjba_bz.Sum(m => m["cjje"].ints());
long bz_ts = temp_cjba_bz.Sum(m => m["ts"].ints());
long sz_cjje = temp_cjba_sz.Sum(m => m["cjje"].ints());
long sz_ts = temp_cjba_sz.Sum(m => m["ts"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_ts - sz_cjje / sz_ts) / (sz_cjje / sz_ts)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_建筑面积环比:
{
long bz_cjje = temp_cjba_bz.Sum(m => m["cjje"].ints());
long bz_jzmj = temp_cjba_bz.Sum(m => m["jzmj"].ints());
long sz_cjje = temp_cjba_sz.Sum(m => m["cjje"].ints());
long sz_jzmj = temp_cjba_sz.Sum(m => m["jzmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_jzmj - sz_cjje / sz_jzmj) / (sz_cjje / sz_jzmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_建面均价环比:
{
long bz_cjje = temp_cjba_bz.Sum(m => m["cjje"].ints());
long bz_jzmj = temp_cjba_bz.Sum(m => m["jzmj"].ints());
long sz_cjje = temp_cjba_sz.Sum(m => m["cjje"].ints());
long sz_jzmj = temp_cjba_sz.Sum(m => m["jzmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_jzmj - sz_cjje / sz_jzmj) / (sz_cjje / sz_jzmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_成交金额环比:
{
long bz_cjje = temp_cjba_bz.Sum(m => m["cjje"].ints());
long sz_cjje = temp_cjba_sz.Sum(m => m["cjje"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje - sz_cjje) / sz_cjje).doubls().ss_bfb();
}; break;
#endregion
default: { dr1[dt.Columns[j].ColumnName] = ""; }; break;
}
}
#endregion
#region 竞争格局
else if (Base_Config_Jzgj._竞争格局参数名称.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Jzgj.项目名称:
{
dr1[dt.Columns[j].ColumnName] = item.lpcs[0];
}; break;
case Base_Config_Jzgj.业态:
{
dr1[dt.Columns[j].ColumnName] = yt;
}; break;
case Base_Config_Jzgj.组团:
{
dr1[dt.Columns[j].ColumnName] = item != null && item.ztcs != null?string.Join(",", item.ztcs) : "";
}; break;
case Base_Config_Jzgj.竞争格局_主力面积区间:
{
dr1[dt.Columns[j].ColumnName] = item.zlmjqj;
}; break;
case Base_Config_Jzgj.竞争格局名称:
{
dr1[dt.Columns[j].ColumnName] = item.jzgjmc;
}; break;
}
}
#endregion
}
catch (Exception e)
{
throw e;
}
}
return(dr1);
}
public DataRow GET_ROW_BA(string yt, DataRow dr1, System.Data.DataTable dt,
DataRow temp_ba_bz,
EnumerableRowCollection <DataRow> temp_cjba_bz,
EnumerableRowCollection <DataRow> temp_cjba_sz,
EnumerableRowCollection <DataRow> temp_cjba_ssz,
EnumerableRowCollection <DataRow> temp_cjba_sssz,
JP_JPXM_INFO item)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (Base_Config_Rgsj._认购数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Rgsj.本周_新开销售套数:
case Base_Config_Rgsj.本周_新开套数:
case Base_Config_Rgsj.本周_认购套数:
case Base_Config_Rgsj.本周_认购套内均价:
case Base_Config_Rgsj.本周_认购建面均价:
case Base_Config_Rgsj.本周_认购套内体量:
case Base_Config_Rgsj.本周_认购建面体量:
case Base_Config_Rgsj.本周_认购金额:
{
if (temp_ba_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
default:
{
if (temp_ba_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bz[dt.Columns[j].ColumnName];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
}
}
else if (Base_Config_Cjba._备案数据.Contains(dt.Columns[j].ColumnName))
{
if (temp_cjba_bz != null)
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Cjba.本周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_备案套数._ConfigCjbaMc()].ints()); }; break;
case Base_Config_Cjba.本周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()); }; break;
case Base_Config_Cjba.本周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls()); }; break;
case Base_Config_Cjba.本周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].ints()); }; break;
case Base_Config_Cjba.本周_建面均价: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls()) != 0 ? (temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls())).je_y() : 0; }; break;
case Base_Config_Cjba.本周_套内均价: { dr1[dt.Columns[j].ColumnName] = temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].doubls()) != 0 ? (temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].doubls())).je_y() : 0; }; break;
}
}
if (temp_cjba_sz != null)
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Cjba.周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].ints()); }; break;
case Base_Config_Cjba.周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()); }; break;
case Base_Config_Cjba.周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls()); }; break;
case Base_Config_Cjba.周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].ints()); }; break;
case Base_Config_Cjba.周_建面均价:
{
var cjje = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs());
var jzmj = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls());
//var jmjj = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.上周_建筑面积._ConfigCjbaMc()].doubls()) != 0 ? (temp_cjba_bz.Sum(m => m[Base_Config_Cjba.上周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_bz.Sum(m => m[Base_Config_Cjba.上周_建筑面积._ConfigCjbaMc()].doubls())).je_y() : 0;
dr1[dt.Columns[j].ColumnName] = jzmj != 0 ? (cjje / jzmj).je_y() : 0;
}; break;
case Base_Config_Cjba.周_套内均价: { dr1[dt.Columns[j].ColumnName] = temp_cjba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].doubls()) != 0 ? (temp_cjba_bz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) / temp_cjba_bz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].doubls())).je_y() : 0; }; break;
}
}
}
else if (Base_Config_Jzgj._竞争格局参数名称.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Jzgj.项目名称: { dr1[dt.Columns[j].ColumnName] = item.lpcs[0]; }; break;
case Base_Config_Jzgj.业态: { dr1[dt.Columns[j].ColumnName] = yt; }; break;
case Base_Config_Jzgj.竞争格局名称: { dr1[dt.Columns[j].ColumnName] = item.jzgjmc; }; break;
case Base_Config_Jzgj.竞争格局_主力面积区间: { dr1[dt.Columns[j].ColumnName] = item.zlmjqj; }; break;
default: { dr1[dt.Columns[j].ColumnName] = ""; }; break;
}
}
else
{
switch (dt.Columns[j].ColumnName)
{
case "sssz_ts": { dr1[dt.Columns[j].ColumnName] = temp_cjba_sssz.Sum(m => m["ts"].ints()); }; break;
case "sssz_jmjj": { dr1[dt.Columns[j].ColumnName] = temp_cjba_sssz.Sum(m => m["jzmj"].doubls()) != 0 ? (temp_cjba_sssz.Sum(m => m["cjje"].longs()) / temp_cjba_sssz.Sum(m => m["jzmj"].doubls())).je_y() : 0; }; break;
case "ssz_ts": { dr1[dt.Columns[j].ColumnName] = temp_cjba_ssz.Sum(m => m["ts"].doubls()); }; break;
case "ssz_jmjj": { dr1[dt.Columns[j].ColumnName] = temp_cjba_ssz.Sum(m => m["jzmj"].doubls()) != 0 ? (temp_cjba_ssz.Sum(m => m["cjje"].longs()) / temp_cjba_ssz.Sum(m => m["jzmj"].doubls())).je_y() : 0; }; break;
}
}
}
return(dr1);
}
public DataRow GET_ROW(string yt, DataRow dr1, System.Data.DataTable dt,
DataRow temp_rgsj_bz,
DataRow temp_rgsj_sz,
DataRow temp_rgsj_ssz,
DataRow temp_rgsj_sssz,
JP_JPXM_INFO item)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (Base_Config_Rgsj._认购数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Rgsj.本周_新开销售套数:
case Base_Config_Rgsj.本周_新开套数:
case Base_Config_Rgsj.本周_认购套数:
case Base_Config_Rgsj.本周_认购套内均价:
case Base_Config_Rgsj.本周_认购建面均价:
case Base_Config_Rgsj.本周_认购套内体量:
case Base_Config_Rgsj.本周_认购建面体量:
case Base_Config_Rgsj.本周_认购金额:
{
if (temp_rgsj_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_bz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
case Base_Config_Rgsj.周_新开销售套数:
case Base_Config_Rgsj.周_新开套数:
case Base_Config_Rgsj.周_认购套数:
case Base_Config_Rgsj.周_认购套内均价:
case Base_Config_Rgsj.周_认购建面均价:
case Base_Config_Rgsj.周_认购套内体量:
case Base_Config_Rgsj.周_认购建面体量:
case Base_Config_Rgsj.周_认购金额:
{
if (temp_rgsj_sz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_sz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
default:
{
if (temp_rgsj_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_bz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
}
}
else if (Base_Config_Jzgj._竞争格局参数名称.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Jzgj.项目名称: { dr1[dt.Columns[j].ColumnName] = item.lpcs[0]; }; break;
case Base_Config_Jzgj.业态: { dr1[dt.Columns[j].ColumnName] = yt; }; break;
case Base_Config_Jzgj.竞争格局名称: { dr1[dt.Columns[j].ColumnName] = item.jzgjmc; }; break;
case Base_Config_Jzgj.竞争格局_主力面积区间: { dr1[dt.Columns[j].ColumnName] = item.zlmjqj.Join(); }; break;
default: { dr1[dt.Columns[j].ColumnName] = ""; }; break;
}
}
else
{
switch (dt.Columns[j].ColumnName)
{
case "sssz_rgts":
{
if (temp_rgsj_sssz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_sssz["rgts"].ints();
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
case "sssz_rgjmjj":
{
if (temp_rgsj_sssz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_sssz["rgtnjj"].ints();
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
case "ssz_rgts":
{
if (temp_rgsj_ssz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_ssz["rgts"].ints();
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
case "ssz_rgjmjj":
{
if (temp_rgsj_ssz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_rgsj_ssz["rgtnjj"].ints();
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
}
}
}
return(dr1);
}
public DataRow GET_ROW(string yt, DataRow dr1, System.Data.DataTable dt, DataRow temp_ba_bz, DataRow temp_ba_sz, JP_JPXM_INFO item)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].ColumnName == "heji")
{
dr1[dt.Columns[j].ColumnName] = (temp_ba_sz != null ? temp_ba_sz[Base_Config_Rgsj.周_新开套数._ConfigRgsjMc()].ints() : 0) + (temp_ba_bz != null ? temp_ba_bz[Base_Config_Rgsj.本周_新开套数._ConfigRgsjMc()].ints() : 0);
}
else if (dt.Columns[j].ColumnName == "bz" + Base_Config_Rgsj.本周_认购建面均价)
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null? temp_ba_bz[Base_Config_Rgsj.本周_认购建面均价._ConfigRgsjMc()]:0;
}
else if (Base_Config_Rgsj._认购数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Rgsj.周_新开套数:
case Base_Config_Rgsj.周_新开销售套数:
case Base_Config_Rgsj.周_认购套数:
case Base_Config_Rgsj.周_认购套内体量:
case Base_Config_Rgsj.周_认购套内均价:
case Base_Config_Rgsj.周_认购建面体量:
case Base_Config_Rgsj.周_认购建面均价:
case Base_Config_Rgsj.周_认购金额:
{
if (temp_ba_sz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_ba_sz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
case Base_Config_Rgsj.本周_新开套数:
case Base_Config_Rgsj.本周_新开销售套数:
case Base_Config_Rgsj.本周_认购套数:
case Base_Config_Rgsj.本周_认购套内体量:
case Base_Config_Rgsj.本周_认购套内均价:
case Base_Config_Rgsj.本周_认购建面体量:
case Base_Config_Rgsj.本周_认购建面均价:
case Base_Config_Rgsj.本周_认购金额:
{
if (temp_ba_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bz[dt.Columns[j].ColumnName._ConfigRgsjMc()];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
default:
{
if (temp_ba_bz != null)
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bz[dt.Columns[j].ColumnName];
}
else
{
dr1[dt.Columns[j].ColumnName] = "";
}
}; break;
}
}
else if (Base_Config_Cjba._备案数据.Contains(dt.Columns[j].ColumnName))
{
}
else if (Base_Config_Jzgj._竞争格局参数名称.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Jzgj.项目名称:
{
dr1[dt.Columns[j].ColumnName] = item.lpcs[0];
}; break;
case Base_Config_Jzgj.业态:
{
dr1[dt.Columns[j].ColumnName] = yt;
}; break;
case Base_Config_Jzgj.组团:
{
dr1[dt.Columns[j].ColumnName] = string.Join(",", item.ztcs);
}; break;
case Base_Config_Jzgj.竞争格局_主力面积区间:
{
dr1[dt.Columns[j].ColumnName] = item.zlmjqj;
}; break;
case Base_Config_Jzgj.竞争格局名称:
{
dr1[dt.Columns[j].ColumnName] = item.jzgjmc;
}; break;
}
}
}
return(dr1);
}
public DataRow GET_ROW(string yt, DataRow dr1, System.Data.DataTable dt,
DataRow temp_ba_bz,
DataRow temp_ba_sz,
DataRow temp_ba_ssz,
DataRow temp_ba_sssz,
JP_JPXM_INFO item)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (Base_Config_Rgsj._认购数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Rgsj.本周_新开销售套数:
case Base_Config_Rgsj.本周_新开套数:
case Base_Config_Rgsj.本周_认购套数:
case Base_Config_Rgsj.本周_认购套内均价:
case Base_Config_Rgsj.本周_认购建面均价:
case Base_Config_Rgsj.本周_认购套内体量:
case Base_Config_Rgsj.本周_认购建面体量:
case Base_Config_Rgsj.本周_认购金额:
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null? temp_ba_bz[dt.Columns[j].ColumnName._ConfigRgsjMc()]:0;
}; break;
case Base_Config_Rgsj.本周_套均总价: {
dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null && temp_ba_bz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls() != 0? (temp_ba_bz[Base_Config_Rgsj.本周_认购套内均价._ConfigRgsjMc()].doubls() * temp_ba_bz[Base_Config_Rgsj.本周_认购套内体量._ConfigRgsjMc()].doubls() / temp_ba_bz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls()).je_wy():0;
}; break;
case Base_Config_Rgsj.周_新开销售套数:
case Base_Config_Rgsj.周_新开套数:
case Base_Config_Rgsj.周_认购套数:
case Base_Config_Rgsj.周_认购套内均价:
case Base_Config_Rgsj.周_认购建面均价:
case Base_Config_Rgsj.周_认购套内体量:
case Base_Config_Rgsj.周_认购建面体量:
case Base_Config_Rgsj.周_认购金额:
{
dr1[dt.Columns[j].ColumnName] = temp_ba_sz != null ? temp_ba_sz[dt.Columns[j].ColumnName._ConfigRgsjMc()]:0;
}; break;
case Base_Config_Rgsj.周_套均总价:
{
dr1[dt.Columns[j].ColumnName] = temp_ba_sz != null && temp_ba_sz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls() != 0 ? (temp_ba_sz[Base_Config_Rgsj.本周_认购套内均价._ConfigRgsjMc()].doubls() * temp_ba_sz[Base_Config_Rgsj.本周_认购套内体量._ConfigRgsjMc()].doubls() / temp_ba_sz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls()).je_wy() : 0;
}; break;
default:
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null? temp_ba_bz[dt.Columns[j].ColumnName]:"-";
}; break;
}
}
else if (Base_Config_Cjba._备案数据.Contains(dt.Columns[j].ColumnName))
{
}
else if (Base_Config_Jzgj._竞争格局参数名称.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Jzgj.组团: { dr1[dt.Columns[j].ColumnName] = item.ztcs[0]; }; break;
case Base_Config_Jzgj.项目名称: { dr1[dt.Columns[j].ColumnName] = item.lpcs[0]; }; break;
case Base_Config_Jzgj.业态: { dr1[dt.Columns[j].ColumnName] = yt; }; break;
case Base_Config_Jzgj.竞争格局名称: { dr1[dt.Columns[j].ColumnName] = item.jzgjmc; }; break;
case Base_Config_Jzgj.竞争格局_主力面积区间: { dr1[dt.Columns[j].ColumnName] = item.zlmjqj; }; break;
default: { dr1[dt.Columns[j].ColumnName] = ""; }; break;
}
}
else
{
switch (dt.Columns[j].ColumnName)
{
case "sssz_rgts": { dr1[dt.Columns[j].ColumnName] = temp_ba_sssz != null ? temp_ba_sssz["rgts"].ints():0; }; break;
case "sssz_rgtnjj": { dr1[dt.Columns[j].ColumnName] = temp_ba_sssz != null ? temp_ba_sssz["rgtnjj"].ints():0; }; break;
case "sssz_tjzj": { dr1[dt.Columns[j].ColumnName] = temp_ba_sssz != null && temp_ba_sssz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls() != 0 ? temp_ba_sssz[Base_Config_Rgsj.本周_认购套内均价._ConfigRgsjMc()].doubls() * temp_ba_sssz[Base_Config_Rgsj.本周_认购套内体量._ConfigRgsjMc()].doubls() / temp_ba_sssz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls() : 0; }; break;
case "ssz_rgts": { dr1[dt.Columns[j].ColumnName] = temp_ba_ssz != null?temp_ba_ssz["rgts"].ints():0; }; break;
case "ssz_rgtnjj": { dr1[dt.Columns[j].ColumnName] = temp_ba_ssz != null ? temp_ba_ssz["rgtnjj"].ints():0; }; break;
case "ssz_tjzj": { dr1[dt.Columns[j].ColumnName] = temp_ba_ssz != null && temp_ba_ssz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls() != 0 ? temp_ba_ssz[Base_Config_Rgsj.本周_认购套内均价._ConfigRgsjMc()].doubls() * temp_ba_ssz[Base_Config_Rgsj.本周_认购套内体量._ConfigRgsjMc()].doubls() / temp_ba_ssz[Base_Config_Rgsj.本周_认购套数._ConfigRgsjMc()].doubls() : 0; }; break;
}
}
}
return(dr1);
}
public DataRow GET_ROW_BA1(string yt, DataRow dr1, System.Data.DataTable dt,
EnumerableRowCollection <DataRow> temp_ba_bz,
EnumerableRowCollection <DataRow> temp_ba_sz,
EnumerableRowCollection <DataRow> temp_ba_ssz,
EnumerableRowCollection <DataRow> temp_ba_sssz,
EnumerableRowCollection <DataRow> temp_ba_bn,
JP_JPXM_INFO item)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
try
{
#region _备案数据
if (Base_Config_Cjba._备案数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Cjba.本周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null?temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_备案套数._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.本周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null?temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()).je_wy() : 0; }; break;
case Base_Config_Cjba.本周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null?temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls()).mj() : 0; }; break;
case Base_Config_Cjba.本周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_ba_bz != null?temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].doubls()).mj() : 0; }; break;
case Base_Config_Cjba.本周_建面均价:
{
if ((temp_ba_bz != null && temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()) / temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_建筑面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.本周_套内均价:
{
if ((temp_ba_bz != null && temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_成交金额._ConfigCjbaMc()].longs()) / temp_ba_bz.Sum(m => m[Base_Config_Cjba.本周_套内面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.周_备案套数: { dr1[dt.Columns[j].ColumnName] = temp_ba_sz != null?temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_备案套数._ConfigCjbaMc()].ints()) : 0; }; break;
case Base_Config_Cjba.周_成交金额: { dr1[dt.Columns[j].ColumnName] = temp_ba_sz != null?temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()).je_wy() : 0; }; break;
case Base_Config_Cjba.周_建筑面积: { dr1[dt.Columns[j].ColumnName] = temp_ba_sz != null?temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls()).mj() : 0; }; break;
case Base_Config_Cjba.周_套内面积: { dr1[dt.Columns[j].ColumnName] = temp_ba_sz != null?temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].doubls()).mj() : 0; }; break;
case Base_Config_Cjba.周_建面均价:
{
if ((temp_ba_sz != null && temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) / temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_建筑面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.周_套内均价:
{
if ((temp_ba_sz != null && temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].doubls()) != 0))
{
dr1[dt.Columns[j].ColumnName] = (temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_成交金额._ConfigCjbaMc()].longs()) / temp_ba_sz.Sum(m => m[Base_Config_Cjba.周_套内面积._ConfigCjbaMc()].doubls())).je_y();
}
else
{
dr1[dt.Columns[j].ColumnName] = "0";
}
}; break;
case Base_Config_Cjba.本周_备案套数环比:
{
dr1[dt.Columns[j].ColumnName] = ((temp_ba_bz.Sum(m => m["ts"].ints()) - temp_ba_sz.Sum(m => m["ts"].ints())) / temp_ba_sz.Sum(m => m["ts"].ints())).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_套内均价环比:
{
long bz_cjje = temp_ba_bz.Sum(m => m["cjje"].ints());
long bz_tnmj = temp_ba_bz.Sum(m => m["tnmj"].ints());
long sz_cjje = temp_ba_sz.Sum(m => m["cjje"].ints());
long sz_tnmj = temp_ba_sz.Sum(m => m["tnmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_tnmj - sz_cjje / sz_tnmj) / (sz_cjje / sz_tnmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_套内面积环比:
{
long bz_tnmj = temp_ba_bz.Sum(m => m["tnmj"].ints());
long sz_tnmj = temp_ba_sz.Sum(m => m["tnmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_tnmj - sz_tnmj) / (sz_tnmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_套均总价环比:
{
long bz_cjje = temp_ba_bz.Sum(m => m["cjje"].ints());
long bz_ts = temp_ba_bz.Sum(m => m["ts"].ints());
long sz_cjje = temp_ba_sz.Sum(m => m["cjje"].ints());
long sz_ts = temp_ba_sz.Sum(m => m["ts"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_ts - sz_cjje / sz_ts) / (sz_cjje / sz_ts)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_建筑面积环比:
{
long bz_cjje = temp_ba_bz.Sum(m => m["cjje"].ints());
long bz_jzmj = temp_ba_bz.Sum(m => m["jzmj"].ints());
long sz_cjje = temp_ba_sz.Sum(m => m["cjje"].ints());
long sz_jzmj = temp_ba_sz.Sum(m => m["jzmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_jzmj - sz_cjje / sz_jzmj) / (sz_cjje / sz_jzmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_建面均价环比:
{
long bz_cjje = temp_ba_bz.Sum(m => m["cjje"].ints());
long bz_jzmj = temp_ba_bz.Sum(m => m["jzmj"].ints());
long sz_cjje = temp_ba_sz.Sum(m => m["cjje"].ints());
long sz_jzmj = temp_ba_sz.Sum(m => m["jzmj"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje / bz_jzmj - sz_cjje / sz_jzmj) / (sz_cjje / sz_jzmj)).doubls().ss_bfb();
}; break;
case Base_Config_Cjba.本周_成交金额环比:
{
long bz_cjje = temp_ba_bz.Sum(m => m["cjje"].ints());
long sz_cjje = temp_ba_sz.Sum(m => m["cjje"].ints());
dr1[dt.Columns[j].ColumnName] = ((bz_cjje - sz_cjje) / sz_cjje).doubls().ss_bfb();
}; break;
default: { dr1[dt.Columns[j].ColumnName] = "0"; }; break;
}
}
#endregion
#region _竞争格局参数名称
else if (Base_Config_Jzgj._竞争格局参数名称.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Jzgj.项目名称:
{
dr1[dt.Columns[j].ColumnName] = item.lpcs[0];
}; break;
case Base_Config_Jzgj.业态:
{
dr1[dt.Columns[j].ColumnName] = yt;
}; break;
case Base_Config_Jzgj.组团:
{
dr1[dt.Columns[j].ColumnName] = item != null && item.ztcs != null?string.Join(",", item.ztcs) : "";
}; break;
case Base_Config_Jzgj.竞争格局_主力面积区间:
{
dr1[dt.Columns[j].ColumnName] = item.zlmjqj;
}; break;
case Base_Config_Jzgj.竞争格局名称:
{
dr1[dt.Columns[j].ColumnName] = item.jzgjmc;
}; break;
}
}
#endregion
else if (Base_Config_Cjba_Qn._全年备案数据.Contains(dt.Columns[j].ColumnName))
{
switch (dt.Columns[j].ColumnName)
{
case Base_Config_Cjba_Qn.全年_累计套内均价:
{
double tnmj = temp_ba_bn.Sum(m => m["tnmj"].doubls());
dr1[dt.Columns[j].ColumnName] = tnmj != 0 ? (temp_ba_bn.Sum(m => m["cjje"].longs()) / tnmj).je_y().ToString() : "-";
}; break;
case Base_Config_Cjba_Qn.全年_累计成交建面:
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bn.Sum(m => m["jzmj"].doubls()).mj_wf();
}; break;
case Base_Config_Cjba_Qn.全年_累计成交金额:
{
dr1[dt.Columns[j].ColumnName] = temp_ba_bn.Sum(m => m["cjje"].longs()).je_wy();
}; break;
}
}
}
catch (Exception e)
{
throw e;
}
}
return(dr1);
}
public System.Data.DataTable GET_JPXM_BX(System.Data.DataTable dt, List <JP_JPXM_INFO> jpxm)
{
foreach (var item in jpxm)
{
if (item.ytcs == null || item.ytcs.Length <= 0)
{
Base_Log.Log("业态参数为空！跳过！竞品项目ID：" + item.id);
continue;
}
if (item.ytcs[0] == "别墅")
{
for (int i = 0; i < item.xfytcs.Length; i++)
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]);
var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]);
//本周本案认购数据
var temp_ba_bz = temp_rgsj_bz.FirstOrDefault();
var temp_ba_sz = temp_rgsj_sz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, null, null, jp));
}
}
}
else if (item.ytcs[0] == "商务")
{
if (item.hxcs != null && item.hxcs.Length > 0)
{
for (int i = 0; i < item.hxcs.Length; i++)
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]);
var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["hx"].ToString() == item.hxcs[i]);
var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]);
var temp_cjba_sz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["hx"].ToString() == item.hxcs[i]);
var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]);
//本周本案认购数据
var temp_ba_bz = temp_rgsj_bz.FirstOrDefault();
var temp_ba_sz = temp_rgsj_sz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(item.hxcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp));
}
}
}
else if (item.xfytcs != null && item.xfytcs.Length > 0)
{
for (int i = 0; i < item.xfytcs.Length; i++)
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]);
var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]);
var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]);
var temp_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]);
var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]);
//本周本案认购数据
var temp_ba_bz = temp_rgsj_bz.FirstOrDefault();
var temp_ba_sz = temp_rgsj_sz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(item.xfytcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp));
}
}
}
else
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var temp_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
//本周本案认购数据
var temp_ba_bz = temp_rgsj_bz.FirstOrDefault();
var temp_ba_sz = temp_rgsj_sz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp));
}
}
}
else if (item.ytcs[0] == "商铺")
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var temp_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
//本周本案认购数据
var temp_ba_bz = temp_rgsj_bz.FirstOrDefault();
var temp_ba_sz = temp_rgsj_sz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp));
}
}
else
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]);
var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]);
//本周本案认购数据
var temp_ba_bz = temp_rgsj_bz.FirstOrDefault();
var temp_ba_sz = temp_rgsj_sz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, null, null, jp));
}
}
}
return(dt);
}
public static SResult jcszsz(int rwid, int mbid, int nf, int zc)
{
//查询指定周次本案信息
DataTable batable = GET_JP_BAXX_REAL(mbid, nf, zc);
//查询指定周次竞品项目信息
DataTable jptable = GET_JP_JPXMXX_REAL(mbid, nf, zc);
List <JP_BA_INFO> list = new List <JP_BA_INFO>();
#region 查询上周参数
foreach (DataRow item in batable.Rows)
{
JP_BA_INFO jp = new JP_BA_INFO();
jp.id = item["id"].ints();
jp.bamc = item["bamc"].ToString();
jp.rwid = item["rwid"].ints();
jp.qycs = item["qycs"] == null || string.IsNullOrEmpty(item["qycs"].ToString()) ? null : item["qycs"].ToString().Split(',');
jp.kfs = item["kfs"] == null || string.IsNullOrEmpty(item["kfs"].ToString()) ? null : item["kfs"].ToString().Split(',');
jp.ztcs = item["ztcs"] == null || string.IsNullOrEmpty(item["ztcs"].ToString()) ? null : item["ztcs"].ToString().Split(',');
jp.lpcs = item["lpcs"] == null || string.IsNullOrEmpty(item["lpcs"].ToString()) ? null : item["lpcs"].ToString().Split(',');
jp.ytcs = item["ytcs"] == null || string.IsNullOrEmpty(item["ytcs"].ToString()) ? null : item["ytcs"].ToString().Split(',');
jp.xfytcs = item["xfytcs"] == null || string.IsNullOrEmpty(item["xfytcs"].ToString()) ? null : item["xfytcs"].ToString().Split(',');
jp.hxcs = item["hxcs"] == null || string.IsNullOrEmpty(item["hxcs"].ToString()) ? null : item["hxcs"].ToString().Split(',');
jp.zlmjqj = item["zlmjqj"] == null || string.IsNullOrEmpty(item["zlmjqj"].ToString()) ? null : item["zlmjqj"].ToString().Split(',');
jp.qtcs = item["qtcs"].ToString();
jp.jpxmlb = new List <JP_JPXM_INFO>();
var xmlist = jptable.AsEnumerable().Where(m => m["baid"].ints() == item["id"].ints());
foreach (var xm in xmlist)
{
JP_JPXM_INFO jpxm = new JP_JPXM_INFO();
jpxm.id = xm["id"].ints();
jpxm.baid = xm["baid"].ints();
jpxm.jzgjid = xm["jzgjid"].ints();
jpxm.qycs = xm["qycs"] == null || string.IsNullOrEmpty(xm["qycs"].ToString()) ? null : xm["qycs"].ToString().Split(',');
jpxm.kfs = xm["kfs"] == null || string.IsNullOrEmpty(xm["kfs"].ToString()) ? null : xm["kfs"].ToString().Split(',');
jpxm.ztcs = xm["ztcs"] == null || string.IsNullOrEmpty(xm["ztcs"].ToString()) ? null : xm["ztcs"].ToString().Split(',');
jpxm.lpcs = xm["lpcs"] == null || string.IsNullOrEmpty(xm["lpcs"].ToString()) ? null : xm["lpcs"].ToString().Split(',');
jpxm.ytcs = xm["ytcs"] == null || string.IsNullOrEmpty(xm["ytcs"].ToString()) ? null : xm["ytcs"].ToString().Split(',');
if (xm["xfytcs"] == null || string.IsNullOrEmpty(xm["xfytcs"].ToString()))
{
jpxm.xfytcs = null;
}
else
{
jpxm.xfytcs = xm["xfytcs"].ToString().Split(',');
};
jpxm.hxcs = xm["hxcs"] == null || string.IsNullOrEmpty(xm["hxcs"].ToString()) ? null : xm["hxcs"].ToString().Split(',');
jpxm.zlmjqj = xm["zlmjqj"] == null || string.IsNullOrEmpty(xm["zlmjqj"].ToString()) ? null : xm["zlmjqj"].ToString().Split(',');;
jp.jpxmlb.Add(jpxm);
}
list.Add(jp);
}
#endregion
if (list.Count > 0)
{
#region 清空本周参数
del_jp_jpxx(rwid);
del_jp_ba(rwid);
#endregion
foreach (var item in list)
{
string sql = "insert into calculation.xtgl_param_jpba (rwid,bamc,qycs,kfs,ztcs,lpcs,ytcs,xfytcs,hxcs,zlmjqj,qtcs) values(@rwid,@bamc,@qycs,@kfs,@ztcs,@lpcs,@ytcs,@xfytcs,@hxcs,@zlmjqj,@qtcs)";
MySqlParameter[] p = { new MySqlParameter("rwid", rwid),
new MySqlParameter("bamc", item.bamc),
new MySqlParameter("qycs", item.qycs == null?"":string.Join(",", item.qycs)),
new MySqlParameter("kfs", item.kfs == null?"":string.Join(",", item.kfs)),
new MySqlParameter("ztcs", item.ztcs == null?"":string.Join(",", item.ztcs)),
new MySqlParameter("lpcs", item.lpcs == null?"":string.Join(",", item.lpcs)),
new MySqlParameter("ytcs", item.ytcs == null?"":string.Join(",", item.ytcs)),
new MySqlParameter("xfytcs", item.xfytcs == null?"":string.Join(",", item.xfytcs)),
new MySqlParameter("hxcs", item.hxcs == null?"":string.Join(",", item.hxcs)),
new MySqlParameter("zlmjqj", item.zlmjqj == null?"":string.Join(",", item.zlmjqj)),
new MySqlParameter("qtcs", item.qtcs == null?"": item.qtcs) };
MySqlDbhelper.ExecuteNonQuery(sql, p);
if (item.jpxmlb != null && item.jpxmlb.Count > 0)
{
StringBuilder sqlbuilder = new StringBuilder("insert into calculation.xtgl_param_jpgj(baid,jzgjid,qycs,kfs,ztcs,lpcs,ytcs,xfytcs,hxcs,zlmjqj) values ");
foreach (var item_jp in item.jpxmlb)
{
sqlbuilder.Append(string.Format(@"((select max(id) from calculation.xtgl_param_jpba),'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}'),",
item_jp.jzgjid,
item_jp.qycs == null ? "" : string.Join(",", item_jp.qycs),
item_jp.kfs == null ? "" : string.Join(",", item_jp.kfs),
item_jp.ztcs == null ? "" : string.Join(",", item_jp.ztcs),
item_jp.lpcs == null ? "" : string.Join(",", item_jp.lpcs),
item_jp.ytcs == null ? "" : string.Join(",", item_jp.ytcs),
item_jp.xfytcs == null ? "" : string.Join(",", item_jp.xfytcs),
item_jp.hxcs == null ? "" : string.Join(",", item_jp.hxcs),
item_jp.zlmjqj == null ? "" : string.Join(",", item_jp.zlmjqj))
);
}
string sql1 = sqlbuilder.ToString();
MySqlDbhelper.ExecuteNonQuery(sql1.Substring(0, sql1.Length - 1));
}
}
return(SResult.Success);
}
else
{
return(SResult.Error("指定周次没有设置参数"));
}
}
public System.Data.DataTable GET_JPXM_BX_1(System.Data.DataTable dt, List <JP_JPXM_INFO> jpxm)
{
foreach (var item in jpxm)
{
if (item.ytcs == null || item.ytcs.Length <= 0)
{
Base_Log.Log("业态参数为空！跳过！竞品项目ID：" + item.id);
continue;
}
if (item.ytcs[0] == "别墅")
{
for (int i = 0; i < item.xfytcs.Length; i++)
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
string[] p = mjitem.Split('-');
DataTable dt_bz = new DataTable();
DataTable dt_sz = new DataTable();
if (p[1] != "∞")
{
dt_bz = Cache_data_cjjl.bz.Select("tnmj >=" + p[0] + " and tnmj<=" + p[1]).CopyToDataTable();
dt_sz = Cache_data_cjjl.sz.Select("tnmj >=" + p[0] + " and tnmj<=" + p[1]).CopyToDataTable();
}
else
{
dt_bz = Cache_data_cjjl.bz.Select("tnmj >=" + p[0]).CopyToDataTable();
dt_sz = Cache_data_cjjl.sz.Select("tnmj >=" + p[0]).CopyToDataTable();
}
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_cjba_bz = dt_bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]);
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]);
var temp_rg_bz = temp_rgsj_bz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(item.xfytcs[i], dr1, dt, temp_rg_bz, temp_cjba_bz, jp));
}
}
}
else if (item.ytcs[0] == "商务")
{
for (int i = 0; i < item.hxcs.Length; i++)
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
string[] p = mjitem.Split('-');
DataTable dt_bz = new DataTable();
DataTable dt_sz = new DataTable();
if (p[1] != "∞")
{
dt_bz = Cache_data_cjjl.bz.Select("tnmj >=" + p[0] + " and tnmj<=" + p[1]).CopyToDataTable();
dt_sz = Cache_data_cjjl.sz.Select("tnmj >=" + p[0] + " and tnmj<=" + p[1]).CopyToDataTable();
}
else
{
dt_bz = Cache_data_cjjl.bz.Select("tnmj >=" + p[0]).CopyToDataTable();
dt_sz = Cache_data_cjjl.sz.Select("tnmj >=" + p[0]).CopyToDataTable();
}
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_cjba_bz = dt_bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["hx"].ToString() == item.hxcs[i]);
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]);
var temp_rg_bz = temp_rgsj_bz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(item.hxcs[0], dr1, dt, temp_rg_bz, temp_cjba_bz, jp));
}
}
}
else
{
//这里根据要求来设置（若不需要计算面积区间，这里需要注释）
if (item.zlmjqj == null || item.zlmjqj.Length <= 0)
{
Base_Log.Log("主力面积区间为空！跳过！竞品项目ID：" + item.id);
continue;
}
foreach (var mjitem in item.zlmjqj)
{
#region 计算主力面积区间
string[] p = mjitem.Split('-');
DataTable dt_bz = new DataTable();
DataTable dt_sz = new DataTable();
if (p[1] != "∞")
{
dt_bz = Cache_data_cjjl.bz.Select("tnmj >=" + p[0] + " and tnmj<=" + p[1]).CopyToDataTable();
dt_sz = Cache_data_cjjl.sz.Select("tnmj >=" + p[0] + " and tnmj<=" + p[1]).CopyToDataTable();
}
else
{
dt_bz = Cache_data_cjjl.bz.Select("tnmj >=" + p[0]).CopyToDataTable();
dt_sz = Cache_data_cjjl.sz.Select("tnmj >=" + p[0]).CopyToDataTable();
}
DataRow dr1 = dt.NewRow();
JP_JPXM_INFO jp = new JP_JPXM_INFO();
jp = item;
jp.zlmjqj = new string[] { mjitem };
#endregion
#region 数据准备
//竞品业态
var temp_cjba_bz = dt_bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]);
var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString()));
var temp_rg_bz = temp_rgsj_bz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW(item.ytcs[0], dr1, dt, temp_rg_bz, temp_cjba_bz, jp));
}
}
}
return(dt);
}
