/// <summary>
/// 查询过滤
/// </summary>
/// <param name="whereLambda"></param>
/// <returns></returns>
public async Task <ServiceResponse> GetModels(Expression <Func <T, bool> > whereLambda)
{
try
{
var Task = Db.Set <T>().Where <T>(whereLambda).ToListAsync();
var List = await Task;
return(new ServiceResponse()
{
Success = true, Results = List
});
}
catch (Exception ex)
{
LoggerHelper.WriteLog("查询数据", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 新增更新模块信息
/// </summary>
/// <param name="tb_Menus"></param>
/// <returns></returns>
public async Task <ServiceResponse> UpdateMenus(List <tb_Menu> tb_Menus)
{
try
{
using (var db = new ZFSConfig())
{
tb_Menus.ForEach(q =>
{
var row = db.tb_Menu.FirstOrDefault(x => x.MenuCode.Equals(q.MenuCode));
if (row != null)
{
row.MenuName = q.MenuName;;
row.MenuNameSpace = q.MenuNameSpace;
row.MenuCaption = q.MenuCaption;
row.MenuAuthorities = q.MenuAuthorities;
DbEntityEntry dbEntity = db.Entry <tb_Menu>(row);
dbEntity.State = System.Data.Entity.EntityState.Modified;
}
else
{
db.Set <tb_Menu>().Add(q);
}
});
var task = await db.SaveChangesAsync();
bool result = task > 0 ? true : false;
return(new ServiceResponse()
{
Success = result
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("批量更新", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}