public bool AddDeviceGroupRelateEX(string deviceIds, int groupId, int rank)
{
bool result = false;
string[] ids = deviceIds.Split(',');
//修改原有排序,从rank后所有的往后推ids的
ServDeviceRelateModel models = new ServDeviceRelateModel();
models.device_id = ids.Length;
models.rank = rank;
models.group_id = groupId;
int num = servDeviceRelateDAL.UpdateGroupRankBygroupidAndRank(models);
for (int i = 0; i < ids.Length; i++)
{
int deviceId = Convert.ToInt32(ids[i]);
ServDeviceRelateModel model = new ServDeviceRelateModel();
model.device_id = deviceId;
model.group_id = groupId;
model.rank = rank + i;
int relateId = servDeviceRelateDAL.AddEntity(model);
if (relateId != 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 绑定设备和组的关联
/// </summary>
/// <param name="deviceIds">设备id集合</param>
/// <param name="id">组id</param>
/// <returns></returns>
public bool AddDeviceGroupRelate(string deviceIds, int id)
{
try
{
bool result = false;
string[] ids = deviceIds.Split(',');
for (int i = 0; i < ids.Length; i++)
{
int deviceId = Convert.ToInt32(ids[i]);
//查询设备和组之前是否有绑定，如有先删除绑定
//servDeviceRelateDAL.DeleteDeviceRelateByDeviceId(deviceId);
//绑定设备和组的绑定
//if (id != 0)//如果id为0则拖入的是未分组设备只用删除之前的绑定即可
//{
ServDeviceRelateModel model = new ServDeviceRelateModel();
model.device_id = deviceId;
model.group_id = id;
int relateId = servDeviceRelateDAL.AddEntity(model);
//}
}
result = true;
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据设备id删除设备和组的绑定
/// </summary>
/// <param name="deviceId"></param>
/// <returns></returns>
public int DeleteDeviceRelateByDeviceIdAndGroupId(ServDeviceRelateModel model)
{
try
{
return(mapContext.Delete("DeleteDeviceRelateByDeviceIdAndGroupId", model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据分组id和排序rank修改分组的排序(用于添加分组设备使用)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateGroupRankBygroupidAndRank(ServDeviceRelateModel model)
{
try
{
return(mapContext.Update("UpdateGroupRankBygroupidAndRank", model));
}
catch (Exception ex)
{
throw ex;
}
}
public int AddEntity(ServDeviceRelateModel entity)
{
try
{
int id = (int)mapContext.Insert("InsertDeviceRelate", entity);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据设备id和组id删除设备和组的绑定
/// </summary>
/// <param name="deviceId"></param>
/// <param name="groupId"></param>
/// <returns></returns>
public bool DeleteDeviceAndGroupBind(int deviceId, int groupId)
{
try
{
ServDeviceRelateModel model = new ServDeviceRelateModel();
model.device_id = deviceId;
model.group_id = groupId;
servDeviceRelateDAL.DeleteDeviceRelateByDeviceIdAndGroupId(model);
return(true);
}
catch (Exception ex)
{
throw;
}
}
public bool UpdateEntity(int id, ServDeviceRelateModel newentity)
{
throw new NotImplementedException();
}
public int UpdateDeviceRelateById(ServDeviceRelateModel model)
{
int result = mapContext.Update("UpdateDeviceRelate", model);
return(result);
}
