/// <summary> /// 获取渠道列表 /// </summary> /// <returns></returns> public List <ChannelEntity> GetEntities() { var entities = new ChannelDll().LoadEntities(p => p.ID > 0).ToList(); var viewEntity = new ChannelEntity(); return(entities.Select(p => viewEntity.GetViewModel(p)).ToList()); }
/// <summary> /// 根据ID获取渠道 /// </summary> /// <param name="id">渠道ID</param> /// <returns></returns> public ChannelEntity GetEntityById(int id) { var entity = new ChannelDll().LoadEntity(p => p.ID == id); var viewEntity = new ChannelEntity(); return(viewEntity.GetViewModel(entity)); }
/// <summary> /// 找出没有用的最小SceneId /// </summary> /// <returns></returns> private int GetNotUsedSmallSceneId() { var listSceneId = new ChannelDll().LoadEntities(p => p.ID > 0).Select(p => p.SceneId).OrderBy(p => p); for (int i = 1; i <= 100000; i++) { var sceneId = listSceneId.Any(e => e == i); if (!sceneId) { return(i); } } return(0); }
/// <summary> /// 添加或修改渠道 /// </summary> /// <param name="viewEntity">渠道实体</param> /// <returns></returns> public bool UpdateOrInsertEntity(ChannelEntity viewEntity) { if (viewEntity.ID > 0) { var entity = viewEntity.GetDataEntity(viewEntity); var dbEntity = new ChannelDll().LoadEntity(p => p.ID == entity.ID); entity.SceneId = dbEntity.SceneId; entity.Qrcode = dbEntity.Qrcode; return(new ChannelDll().UpdateEntity(entity)); } else { //新增渠道时,需要获取渠道的二维码 GetQrcode(viewEntity); var entity = viewEntity.GetDataEntity(viewEntity); return(new ChannelDll().AddEntity(entity).ID > 0); } }
/// <summary> /// 根据SceneId获取二维码id /// </summary> /// <param name="sceneId">扫描的二维码的参数</param> /// <returns></returns> public int GetChannelIdBySceneId(int sceneId) { var entity = new ChannelDll().LoadEntity(p => p.SceneId == sceneId); return(entity == null ? 0 : entity.ID); }
/// <summary> /// 根据ID删除渠道 /// </summary> /// <param name="id">渠道ID</param> /// <returns></returns> public bool DeleteEntityById(int id) { var entity = new ChannelDll().LoadEntity(p => p.ID == id); return(new ChannelDll().DeleteEntity(entity)); }
/// <summary> /// 添加或修改渠道 /// </summary> /// <param name="viewEntity">渠道实体</param> /// <returns></returns> public bool UpdateOrInsertEntity(ChannelEntity viewEntity) { if (viewEntity.ID > 0) { var entity = viewEntity.GetDataEntity(viewEntity); var dbEntity = new ChannelDll().LoadEntity(p => p.ID == entity.ID); entity.SceneId = dbEntity.SceneId; entity.Qrcode = dbEntity.Qrcode; return new ChannelDll().UpdateEntity(entity); } else { //新增渠道时,需要获取渠道的二维码 GetQrcode(viewEntity); var entity = viewEntity.GetDataEntity(viewEntity); return new ChannelDll().AddEntity(entity).ID > 0; } }
/// <summary> /// 根据ID获取渠道 /// </summary> /// <param name="id">渠道ID</param> /// <returns></returns> public ChannelEntity GetEntityById(int id) { var entity = new ChannelDll().LoadEntity(p => p.ID == id); var viewEntity = new ChannelEntity(); return viewEntity.GetViewModel(entity); }
/// <summary> /// 获取渠道列表 /// </summary> /// <returns></returns> public List<ChannelEntity> GetEntities() { var entities = new ChannelDll().LoadEntities(p => p.ID > 0).ToList(); var viewEntity = new ChannelEntity(); return entities.Select(p => viewEntity.GetViewModel(p)).ToList(); }
/// <summary> /// 根据SceneId获取二维码id /// </summary> /// <param name="sceneId">扫描的二维码的参数</param> /// <returns></returns> public int GetChannelIdBySceneId(int sceneId) { var entity = new ChannelDll().LoadEntity(p=>p.SceneId == sceneId); return entity == null ? 0 : entity.ID; }
/// <summary> /// 根据ID删除渠道 /// </summary> /// <param name="id">渠道ID</param> /// <returns></returns> public bool DeleteEntityById(int id) { var entity = new ChannelDll().LoadEntity(p => p.ID == id); return new ChannelDll().DeleteEntity(entity); }
/// <summary> /// 找出没有用的最小SceneId /// </summary> /// <returns></returns> private int GetNotUsedSmallSceneId() { var listSceneId = new ChannelDll().LoadEntities(p => p.ID > 0).Select(p => p.SceneId).OrderBy(p => p); for (int i = 1; i <= 100000; i++) { var sceneId = listSceneId.Any(e => e == i); if (!sceneId) { return i; } } return 0; }