public IList <t_EE_EnerUserProject> UpdatEnerNode(t_V_EnerProjectType data)
{
this.Database.Log = new Action <string>((string text) => { System.Diagnostics.Debug.WriteLine(text); });
string sql = $"UPDATE t_EE_EnerUserProject SET child_id = {data.child_id} WHERE child_id = {data.child_id} and unit_id = {data.unit_id} ;UPDATE t_EE_EnerUserProject SET parent_id = {data.parent_id} output inserted.* WHERE parent_id = {data.parent_id} and unit_id = {data.unit_id}";
return(SQLQuery <t_EE_EnerUserProject>(sql));
}
public IList <t_EE_EnerUserProject> updataTreeNode(t_V_EnerProjectType data)
{
this.Database.Log = new Action <string>((string text) => { System.Diagnostics.Debug.WriteLine(text); });
string sql = $"UPDATE t_EE_EnerUserProject SET unit_head = '{data.unit_head}',unit_note='{data.unit_note}',addCid='{data.addCid}',delCid='{data.delCid}',unit_area={data.unit_area},unit_people={data.unit_people} output inserted.* WHERE parent_id = {data.parent_id} and child_id = {data.ID} and unit_id = {data.unit_id}";
return(SQLQuery <t_EE_EnerUserProject>(sql));
}
public IList <t_EE_EnerUserProject> addTreeNode(t_V_EnerProjectType data)
{
this.Database.Log = new Action <string>((string text) => { System.Diagnostics.Debug.WriteLine(text); });
string sql = $"INSERT INTO t_EE_EnerUserProject(child_id,parent_id,unit_id,unit_head,unit_note,addCid,delCid,unit_area,unit_people) output inserted.* " +
$" VALUES({ data.ID},{data.parent_id},{data.unit_id},'{data.unit_head}','{data.unit_note}','{data.addCid}','{data.delCid}',{data.unit_area},{data.unit_people})";
return(SQLQuery <t_EE_EnerUserProject>(sql));
}
public IList <t_EE_EnerUserProject> updataTreeNodeId(t_V_EnerProjectType data)
{
IList <t_EE_EnerUserProject> list = new List <t_EE_EnerUserProject>();
try
{
list = _dbFactory.enerUserProject.updataTreeNodeId(data);
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public IList <t_EE_CircuitInfoEnerType> getCidEneeruseType(t_V_EnerProjectType data)
{
var arr = data.addCid.Split(',');
string sql = "";
if (data.item_type == 1)
{
sql = $"select PID,CID,ener_use_type,ener_use_type_area FROM t_DM_CircuitInfo " +
$" WHERE CHARINDEX (',{data.ID},', ener_use_type)>0";
}
else if (data.item_type == 2)
{
sql = $"select PID,CID,ener_use_type,ener_use_type_area FROM t_DM_CircuitInfo " +
$" WHERE CHARINDEX (',{data.ID},', ener_use_type_area)>0";
}
for (int a = 0; a < arr.Count(); a++)
{
var cid = arr[a].Split('-');
sql += $" or (PID = {cid[0]} and CID = {cid[1]})";
}
return(SQLQuery <t_EE_CircuitInfoEnerType>(sql));
}
public IList <t_EE_CircuitInfoEnerType> setCidEneeruseType(t_V_EnerProjectType data)
{
IList <t_EE_CircuitInfoEnerType> list = new List <t_EE_CircuitInfoEnerType>();
if (data.addCid == null)
{
return(list);
}
try
{
list = _dbFactory.enerUserProject.getCidEneeruseType(data);
var add = data.addCid.Split(',');
string addcid = $",{data.addCid},";
if (data.item_type == 1)
{
for (int a = 0; a < list.Count(); a++)
{
if (addcid.Contains($",{list[a].PID}-{list[a].CID},"))
{
//该电表没有这个区域ID
if (list[a].ener_use_type == null || !list[a].ener_use_type.Contains($",{data.ID},"))
{
list[a].ener_use_type += $",{data.ID},";
}
}
else
{
//该点表有区域ID 但是未绑定电表
if (list[a].ener_use_type != null && list[a].ener_use_type.Contains($",{data.ID},"))
{
var str = $",{data.ID},";
//list[a].ener_use_type = list[a].ener_use_type.Remove(list[a].ener_use_type.IndexOf(str), str.Length);
}
}
}
}
else
{
for (int a = 0; a < list.Count(); a++)
{
if (addcid.Contains($",{list[a].PID}-{list[a].CID},"))
{
//该电表没有这个区域ID
if (list[a].ener_use_type_area == null || !list[a].ener_use_type_area.Contains($",{data.ID},"))
{
list[a].ener_use_type_area += $",{data.ID},";
}
}
else
{
//该点表有区域ID 但是未绑定电表
if (list[a].ener_use_type_area != null && list[a].ener_use_type_area.Contains($",{data.ID},"))
{
var str = $",{data.ID},";
//list[a].ener_use_type = list[a].ener_use_type.Remove(list[a].ener_use_type.IndexOf(str), str.Length);
}
}
}
}
list = _dbFactory.enerUserProject.setCidEneeruseType(list);
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
