public List <DeviceModelInfo> GetAllByBrandKeys(int brandId = 0, string keyword = null)
{
var allList = DalDeviceBrand.GetAllInfo();
var query = allList;
if (brandId > 0)
{
query = query.Where(m => m.BrandID == brandId);
}
keyword = keyword?.Trim();
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(m =>
!string.IsNullOrEmpty(m.DeviceType) && m.DeviceType.ToLower().Contains(keyword.ToLower()) ||
!string.IsNullOrEmpty(m.DeviceModel) && m.DeviceModel.ToLower().Contains(keyword.ToLower()));
}
return(query.ToList());
}
public bool DeleteModel(int pkid)
{
return(DalDeviceBrand.DeleteModel(pkid));
}
public IEnumerable <DeviceBrandEntity> GetAllBrandList()
{
return(DalDeviceBrand.GetAllBrandList());
}
public bool DeleteType(int pkid)
{
return(DalDeviceBrand.DeleteType(pkid));
}
/// <summary>
/// </summary>
/// <param name="data"></param>
/// <param name="userName"></param>
/// <returns></returns>
public bool BatchHandleDeviceModel(DeviceModelFormList data, string userName)
{
var list = GetAllByBrandKeys();
CheckBasicInfo(data, list);
var typeIdInfo = list.FirstOrDefault(m => m.TypeID == data.TypeID && m.TypeID > 0);
if (typeIdInfo != null)
{// 修改机型信息
typeIdInfo.BrandID = data.BrandID;
typeIdInfo.DeviceType = data.DeviceType;
typeIdInfo.UpdateUser = userName;
var result = DalDeviceBrand.UpdateType(new DeviceTypeEntity()
{
PKID = data.TypeID,
BrandId = data.BrandID,
DeviceType = data.DeviceType,
UpdateUser = userName,
});
if (!result)
{
throw new Exception($"修改机型({data.TypeID}),出错!");
}
}
else
{// 新增机型信息
var result = DalDeviceBrand.InsertType(new DeviceTypeEntity()
{
BrandId = data.BrandID,
DeviceType = data.DeviceType,
CreateUser = userName
});
if (result > 0)
{
typeIdInfo = new DeviceModelInfo()
{
BrandID = data.BrandID,
DeviceBrand = data.DeviceBrand,
TypeID = result,
DeviceType = data.DeviceType,
};
}
else
{
throw new Exception($"添加机型信息出错");
}
}
if (data.Models != null && data.Models.Any())
{
foreach (var item in data.Models)
{
//var modelInfo = list.FirstOrDefault(m => m.ModelID == item.ModelId);
if (item.ModelId > 0)
{//更新
var result = DalDeviceBrand.UpdateModel(new DeviceModelEntity()
{
PKID = item.ModelId,
TypeId = typeIdInfo.TypeID,
DeviceModel = item.ModelName,
UpdateUser = userName,
});
if (!result)
{
throw new Exception($"修改机型({data.TypeID}),出错!");
}
}
else
{//新增
var result = DalDeviceBrand.InsertModel(new DeviceModelEntity()
{
DeviceModel = item.ModelName,
TypeId = typeIdInfo.TypeID,
CreateUser = userName,
});
if (result <= 0)
{
throw new Exception($"添加机型信息({item.ModelName})出错");
}
}
}
}
return(true);
}
