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(); }