/// <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;
}
