public Result <int> Create(AssetCate cate, IAppUser user)
{
try
{
var error = Validate(cate);
if (!string.IsNullOrWhiteSpace(error))
{
return(ResultUtil.Do(ResultCodes.验证失败, 0, error));
}
cate.BeforeCreate(user);
var id = _db.Create(cate);
if (id > 0)
{
AssetCateUtil.Clear();
return(ResultUtil.Success(id));
}
return(ResultUtil.Do(ResultCodes.数据库操作失败, 0, "数据写入失败"));
}
catch (Exception ex)
{
return(ResultUtil.Exception(ex, 0));
}
}
public List <AssetGroupDto> GetCateGroup(AssetSearchParam param)
{
var all = ListDto(param).ToList();
var groups = all.Select(a => a.AssetCateId).Distinct();
var cates = AssetCateUtil.All();
return(groups.Select(g => new AssetGroupDto
{
GroupId = g,
GroupName = cates.SingleOrDefault(c => c.Id == g)?.Name,
Assets = all.Where(a => a.AssetCateId == g).ToList()
}).ToList());
}
public Result Delete(int id, IAppUser user)
{
try
{
var entity = _db.Load <AssetCate>(id);
if (entity == null)
{
return(ResultUtil.Do(ResultCodes.数据不存在, "请求的数据不存在"));
}
var childrenCount = _db.GetCount <AssetCate>(MySearchUtil.New()
.AndEqual("ParentId", id)
.AndEqual("IsDel", false));
if (childrenCount > 0)
{
return(ResultUtil.Do(ResultCodes.验证失败, "下属类别不为空，禁止删除"));
}
var assetsCount = _db.GetCount <Asset>(MySearchUtil.New()
.AndEqual("AssetCateId", id)
.AndEqual("IsDel", false));
if (assetsCount > 0)
{
return(ResultUtil.Do(ResultCodes.验证失败, "下属资产不为空，禁止删除"));
}
var row = _db.Remove <AssetCate>(id);
if (row > 0)
{
AssetCateUtil.Clear();
return(ResultUtil.Success());
}
return(ResultUtil.Do(ResultCodes.数据库操作失败, "数据库写入失败"));
}
catch (Exception ex)
{
return(ResultUtil.Exception(ex));
}
}
public Result <int> Update(AssetCate cate, IAppUser user)
{
try
{
var error = Validate(cate);
if (!string.IsNullOrWhiteSpace(error))
{
return(ResultUtil.Do(ResultCodes.验证失败, 0, error));
}
if (cate.ParentId == cate.Id)
{
return(ResultUtil.Do(ResultCodes.验证失败, 0, "不能将自身设置为上级"));
}
var children = AssetCateUtil.GetSelfAndChildrenIds(cate.Id);
if (children.Contains(cate.ParentId))
{
return(ResultUtil.Do(ResultCodes.验证失败, 0, "不能将上级分类指定为其下属"));
}
cate.BeforeUpdate(user);
var row = _db.Update(cate);
if (row > 0)
{
AssetCateUtil.Clear();
return(ResultUtil.Success(cate.Id));
}
return(ResultUtil.Do(ResultCodes.数据库操作失败, 0, "数据写入失败"));
}
catch (Exception ex)
{
return(ResultUtil.Exception(ex, 0));
}
}
public MySearchUtil ToSearchUtil()
{
var util = MySearchUtil.New().AndEqual("IsDel", false);
if (!string.IsNullOrWhiteSpace(Key))
{
util.AndContains(new[] { "Name", "Code", "FinancialCode", "Band", "Imei", "Model", "Source", "Remark", "Position", "DeptName", "AccountName" }, Key.Trim());
}
if (!string.IsNullOrWhiteSpace(Position))
{
util.AndContains("Position", Position.Trim());
}
if (!string.IsNullOrWhiteSpace(State))
{
util.AndEqual("State", State.Trim());
}
if (DeptId.HasValue)
{
if (!IsContainSubDept)
{
util.AndEqual("DeptId", (int)DeptId);
}
else
{
var depts = DeptUtil.GetSelfAndChildrenIds((int)DeptId);
util.AndIn("DeptId", depts);
}
}
if (CateId.HasValue && CateId > 0)
{
var cate = AssetCateUtil.Get((int)CateId);
if (cate == null)
{
util.And("1=2");
}
else
{
var ids = AssetCateUtil.GetSelfAndChildrenIds(cate.Id);
util.AndIn("AssetCateId", ids);
}
}
if (AccountId.HasValue && AccountId > 0)
{
util.AndEqual("AccountId", (int)AccountId);
}
if (!IncludeScrap)
{
util.AndNotEqual("State", "报废");
}
if (!string.IsNullOrWhiteSpace(Healthy))
{
util.AndEqual("Healthy", Healthy);
}
if (Sort.HasValue)
{
switch (Sort)
{
case 1:
util.OrderBy("Code");
break;
case 2:
util.OrderBy("Name");
break;
case 3:
util.OrderBy("DeptName");
break;
case 4:
util.OrderBy("AccountName");
break;
default:
util.OrderByDesc("UpdateAt");
break;
}
}
else
{
util.OrderByDesc("UpdateAt");
}
return(util);
}
