public virtual ActionResult CreatEquip(PrjEquipmentsView tosave)
{
var js = " $('.info_div').hide();$('#success').fadeIn('slow');";
try
{
SavePrjEquipments(tosave);
return JavaScript(js);
}
catch
{
js = " $('.info_div').hide();$('#fail').fadeIn('slow');";
return JavaScript(js);
}
}
//Get
public virtual ActionResult GetEquipMents(int stationid)
{
var substation = _entities.SubStations.SingleOrDefault(x => x.StationID == stationid);
var viewmodel = new PrjEquipmentsView(substation);
ViewData["TranEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 1).ToList();
ViewData["ZZEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 2).ToList();
//低压开关柜
ViewData["LVGearEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 9).ToList();
ViewData["HWEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 3).ToList();
ViewData["GYEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 4).ToList();
ViewData["RelayEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 5).ToList();
ViewData["DYEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 6).ToList();
ViewData["DYDREquipments"] = _entities.Equipments.Where(x => x.ETypeID == 7).ToList();
ViewData["DYHEquipments"] = _entities.Equipments.Where(x => x.ETypeID == 8).ToList();
ViewData["FlowStep"] = substation.Layout.FlowState;
ViewData["UserGroup"] =
_entities.Users.SingleOrDefault(x => x.UserName == User.Identity.Name.Trim()).UserGroup.GroupName.Trim(); ;
return PartialView(Views._Equipment, viewmodel);
}
private void SavePrjEquipments(PrjEquipmentsView tosave)
{
var transfromer =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 1);
if (transfromer==null)
{ if (tosave.TransformerID>0) _entities.Prj_Equipment.AddObject(new Prj_Equipment(){StationID = tosave.StationId,EID = tosave.TransformerID});
}
else
{
if (tosave.TransformerID > 0)
transfromer.EID = tosave.TransformerID;
}
var HVzz =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 2);
if (HVzz == null)
{
if (tosave.HVGearID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.HVGearID });
}
else
{
if (tosave.HVGearID > 0)
HVzz.EID = tosave.HVGearID;
}
var zz =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 9);
if (zz == null)
{
if (tosave.LVGearID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.LVGearID });
}
else
{
if (tosave.LVGearID > 0)
zz.EID = tosave.LVGearID;
}
var hw =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 3);
if (hw == null)
{
if (tosave.HwID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.HwID });
}
else
{
if (tosave.HwID > 0)
hw.EID = tosave.HwID;
}
var gy =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 4);
if (gy == null)
{
if (tosave.GYSwitchID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.GYSwitchID });
}
else
{
if (tosave.GYSwitchID > 0)
gy.EID = tosave.GYSwitchID;
}
var relay =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 5);
if (relay == null)
{
if (tosave.ComputerRelayID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.ComputerRelayID });
}
else
{
if (tosave.ComputerRelayID > 0)
relay.EID = tosave.ComputerRelayID;
}
var dyh =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 8);
if (dyh == null)
{
if (tosave.DYSwitchHID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.DYSwitchHID});
}
else
{
if (tosave.DYSwitchHID > 0)
dyh.EID = tosave.DYSwitchHID;
}
var dy =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 6);
if (dy == null)
{
if (tosave.DYSwitchLID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.DYSwitchLID });
}
else
{
if (tosave.DYSwitchLID > 0)
dy.EID = tosave.DYSwitchLID;
}
var dr =
_entities.Prj_Equipment.SingleOrDefault(x => x.StationID == tosave.StationId & x.Equipment.ETypeID == 7);
if (dr == null)
{
if (tosave.DYDRID > 0)
_entities.Prj_Equipment.AddObject(new Prj_Equipment() { StationID = tosave.StationId, EID = tosave.DYDRID });
}
else
{
if (tosave.DYDRID > 0)
dr.EID = tosave.DYDRID;
}
var staion = _entities.SubStations.SingleOrDefault(x => x.StationID == tosave.StationId);
staion.SpecialReqirement = tosave.SpecialMemo;
_entities.SaveChanges();
}
