public List <ViewTraderType> getList()
{
var queryTrader = TradersRepository.GetQuery();
var queryType = TraderTypeRepository.GetQuery();
var query = from x in queryType
let o = from y in queryTrader where y.TraderTypeId == x.TraderTypeId select y
select new ViewTraderType
{
TraderTypeId = x.TraderTypeId,
Title = x.Title,
Count = o.Count()
};
var list = query.ToList();
return(list);
}
public Utility.OpResult SaveOrUpdate(TraderType model)
{
model.CreateDT = DateTime.Now;
model.CreateUID = CurrentUser.UID;
if (model.Id == 0)
{
model.TraderTypeId = CommonService.GUID.ToUpper();
TraderTypeRepository.Add(model);
}
else
{
var source = TraderTypeRepository.Get(model.Id);
model.ToCopyProperty(source);
}
if (TraderTypeRepository.SaveChanges())
{
LogEngine.WriteUpdate(model.Id + "," + model.Title, LogModule.商户分类);
}
return(OpResult.Success());
}
/// <summary>
/// 删除
/// </summary>
public Utility.OpResult Delete(string TraderTypeId)
{
var op = new OpResult();
try
{
var Traders = TradersRepository.GetQuery(o => o.TraderTypeId == TraderTypeId.ToUpper());
if (Traders.Any())
{
op.Message = "无法删除，该类别已经在商户中使用";
return(op);
}
var type = TraderTypeRepository.GetQuery(o => o.TraderTypeId == TraderTypeId);
TraderTypeRepository.RemoveRange(type.ToList());
op.Successed = true;
LogEngine.WriteDelete("删除商户分类", LogModule.商户分类);
}
catch (Exception ex)
{
op.Message = ex.Message;
LogEngine.WriteError(ex);
}
return(op);
}
