public void UpdateImageURL(string uuid, string type, string imageURL) { switch (type.ToUpper()) { case "ITEM": InventoryManager im = new InventoryManager(Globals.DBConnectionKey, Request.Headers?.Authorization?.Parameter); InventoryItem i = (InventoryItem)im.GetBy(uuid); if (i != null) { i.Image = imageURL; im.Update(i); } break; case "PLANT": case "BALLAST": case "BULB": case "CUSTOM": case "FAN": case "FILTER": case "PUMP": case "VEHICLE": Debug.Assert(false, "TODO MAKE SURE CORRECT TABLE IS UPDATED"); EquipmentManager em = new EquipmentManager(Globals.DBConnectionKey, Request.Headers?.Authorization?.Parameter); dynamic d = em.GetAll(type).FirstOrDefault(w => w.UUID == uuid); if (d != null) { d.Image = imageURL; em.Update(d); } break; } }
public ServiceResult GetEquipment(string type = "") { EquipmentManager equipmentManager = new EquipmentManager(Globals.DBConnectionKey, this.GetAuthToken(Request)); List <dynamic> Equipment = (List <dynamic>)equipmentManager.GetAll(type).Cast <dynamic>().ToList(); DataFilter filter = this.GetFilter(Request); Equipment = Equipment.Filter(ref filter); return(ServiceResponse.OK("", Equipment, filter.TotalRecordCount)); }
public ServiceResult GetEquipment(string type = "", string filter = "") { EquipmentManager equipmentManager = new EquipmentManager(Globals.DBConnectionKey, Request.Headers?.Authorization?.Parameter); List <dynamic> Equipment = (List <dynamic>)equipmentManager.GetAll(type).Cast <dynamic>().ToList(); int count; DataFilter tmpFilter = this.GetFilter(filter); Equipment = FilterEx.FilterInput(Equipment, tmpFilter, out count); return(ServiceResponse.OK("", Equipment, count)); }
public void UpdateImageURL(string uuid, string type, string imageURL) { switch (type.ToUpper()) { case "EVENT": EventManager evtManager = new EventManager(Globals.DBConnectionKey, this.GetAuthToken(Request)); var eres = evtManager.Get(uuid); if (eres.Code != 200) { return; } Event e = (Event)eres.Result; if (e != null) { e.Image = imageURL; evtManager.Update(e); } break; case "PROFILEMEMBER": break; case "PROFILE": ProfileManager profileManager = new ProfileManager(Globals.DBConnectionKey, Request.Headers.Authorization?.Parameter); var res2 = profileManager.Get(uuid); if (res2.Code != 200) { return; } var tmp = (Profile)res2.Result; tmp.Image = imageURL; profileManager.UpdateProfile(tmp); break; case "ACCOUNT": AccountManager am = new AccountManager(Globals.DBConnectionKey, this.GetAuthToken(Request)); var res = am.Get(uuid); if (res.Code != 200) { return; } Account a = (Account)res.Result; if (a != null) { a.Image = imageURL; am.Update(a); } break; case "USER": UserManager um = new UserManager(Globals.DBConnectionKey, this.GetAuthToken(Request)); var res52 = um.Get(uuid); if (res52.Code != 200) { return; } User u = (User)res52.Result; u.Image = imageURL; um.UpdateUser(u, true); break; case "ITEM": InventoryManager im = new InventoryManager(Globals.DBConnectionKey, this.GetAuthToken(Request)); var res3 = im.Get(uuid); if (res3.Code != 200) { return; } InventoryItem i = (InventoryItem)res3.Result; i.Image = imageURL; im.Update(i); break; case "PLANT": case "BALLAST": case "BULB": case "CUSTOM": case "FAN": case "FILTER": case "PUMP": case "VEHICLE": Debug.Assert(false, "TODO MAKE SURE CORRECT TABLE IS UPDATED"); EquipmentManager em = new EquipmentManager(Globals.DBConnectionKey, this.GetAuthToken(Request)); dynamic d = em.GetAll(type)?.FirstOrDefault(w => w.UUID == uuid); if (d != null) { d.Image = imageURL; em.Update(d); } break; } }
/// <summary> /// 加工点 设备批量添加或修改 /// </summary> /// <param name="Equipmentlist"></param> /// <returns></returns> public virtual async Task ProcessEquipmentSaves(List <EquipmentDto> Equipmentlist) { var equipments = await EquipmentManager.GetAll().Include(o => o.EquipmentProcessTypes).ToListAsync(); foreach (var EquipmentDto in Equipmentlist) { var Equipment = equipments.Where(o => o.Id == EquipmentDto.Id).SingleOrDefault(); if (Equipment != null) { EquipmentDto.MapTo(Equipment); } else { Equipment = EquipmentDto.MapTo <Equipment>(); } var imgpath = EquipmentDto.EquipmentPicPath; if (!string.IsNullOrEmpty(imgpath)) { var file = FileManager.GetAll().Where(o => o.FilePath == imgpath).FirstOrDefault(); if (file == null) { file = new File { TenantId = AbpSession.TenantId, FileName = Equipment.EquipmentSN, FilePath = imgpath, FileSize = 1 }; await FileManager.InsertAsync(file); } else { Equipment.EquipmentPic = file.Id; } } await EquipmentManager.SaveAsync(Equipment); //添加设备工艺类型 var typeids = EquipmentDto.TypeID; foreach (var typeid in typeids) { var eqType = Equipment.EquipmentProcessTypes.Where(o => o.ProcessTypeId == typeid).FirstOrDefault(); if (eqType == null) { eqType = new EquipmentProcessType { TenantId = Convert.ToInt32(AbpSession.TenantId), EquipmentId = Equipment.Id, ProcessTypeId = typeid }; Equipment.EquipmentProcessTypes.Add(eqType); } } //删除设备工艺类型 foreach (var type in Equipment.EquipmentProcessTypes) { int?eqType = typeids.Where(o => o == type.Id).FirstOrDefault(); if (eqType == null) { Equipment.EquipmentProcessTypes.Remove(type); } } } }