public List <RespondHeadButtonsViewModel> QueryHeadButtonsViewModelsByMenuID(RequestHeadButtonsViewModel request)
{
//TODO 配置每个单据的按钮权限后需清除缓存
return(MemcacheHelper.Get(new RequestMemcacheParameter <List <RespondHeadButtonsViewModel> >
{
CacheKey = string.Format(PRE_CACHE_KEY, "QueryHeadButtonsViewModelsByMenuID"),
#region ====================================
CallBackFunc = () =>
{
var parameter = new HeadButtonsParameter
{
MenuID = request.MenuID,
UserId = this.mSigninUser.UserID
};
var dataModels = this.mHeadButtonsDataAccess.QueryHeadButtonsViewModelsByMenuID(parameter);
var viewModels = dataModels.Select(model => new RespondHeadButtonsViewModel
{
ButtonDisabled = model.ButtonDisabled,
ButtonIconCls = model.ButtonIconCls,
ButtonName = model.ButtonName,
ButtonText = model.ButtonText
}).ToList();
return viewModels;
},
#endregion
ExpiresAt = DateTime.Now.AddMinutes(WebConfigHelper.MemCachedExpTime()),
ManageCacheKeyForKey = THISSERVICE_PRE_CACHE_KEY_MANAGE,
ParamsKeys = new object[]
{
request.MenuID,
this.mSigninUser.UserID
}
}));
}
public IList <HeadButtonsDataModel> QueryHeadButtonsViewModelsByMenuID(HeadButtonsParameter parameter)
{
this.ExecuteSQL = "SELECT title ButtonText,buttonid ButtonName, isenabled ButtonDisabled, iconcls ButtonIconCls FROM dbo.menu WHERE parentid IN(SELECT classid FROM dbo.menu WHERE menuid = @menuid) ORDER BY classid ASC";
this.DataParameter = new IDbDataParameter[]
{
new SqlParameter("@menuid", parameter.MenuID)
};
return(this.ExecuteReadSqlToHeadButtonsDataModelList());
}
