public DataTable GET_JPBA_CJJE(DataTable dt, JP_BA_INFO ba)
{
var temp_sssz = Cache_data_rgsj.sssz.AsEnumerable().Where(m => ba.kfs.Contains(m["qymc"])).Sum(m => m["rgje"].longs());
var temp_ssz = Cache_data_rgsj.ssz.AsEnumerable().Where(m => ba.kfs.Contains(m["qymc"])).Sum(m => m["rgje"].longs());
var temp_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => ba.kfs.Contains(m["qymc"])).Sum(m => m["rgje"].longs());
var temp_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => ba.kfs.Contains(m["qymc"])).Sum(m => m["rgje"].longs());
DataRow dr = dt.NewRow();
dr["kfs"] = string.Join(",", ba.kfs);
dr["hj"] = temp_sssz + temp_ssz + temp_sz + temp_bz;
dr["sssz_cjje"] = temp_sssz;
dr["ssz_cjje"] = temp_ssz;
dr["sz_cjje"] = temp_sz;
dr["bz_cjje"] = temp_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 System.Data.DataTable GET_JPBA_BX(System.Data.DataTable dt, JP_BA_INFO item)
{
if (item.ytcs[0] == "别墅")
{
if (item.xfytcs != null)
{
for (int i = 0; i < item.xfytcs.Length; i++)
{
DataRow dr1 = dt.NewRow();
#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 temp_ba_bz = temp_rgsj_bz.FirstOrDefault();
var temp_ba_sz = temp_rgsj_sz.FirstOrDefault();
#endregion
dt.Rows.Add(GET_ROW_BA(item.xfytcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, item));
}
}
else
{
DataRow dr1 = dt.NewRow();
#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_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].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_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].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_BA(item.ytcs[0], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, item));
}
}
else if (item.ytcs[0] == "商务")
{
for (int i = 0; i < item.hxcs.Length; i++)
{
DataRow dr1 = dt.NewRow();
#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.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["hx"].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_BA(item.xfytcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, item));
}
}
else if (item.ytcs[0] == "商业")
{
}
else
{
DataRow dr1 = dt.NewRow();
#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_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].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_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].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_BA(item.ytcs[0], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, item));
}
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("指定周次没有设置参数"));
}
}
