public void BeforeGetList(IWebEasRepositoryBase repository, HierarchyNode node, ref string sql, ref Filter filter, ref string sqlFromAlias, string sqlOrderPart)
{
if (filter?.Parameters != null)
{
var parameters = filter.Parameters;
var newFilter = new Filter(nameof(D_Tenant_Id), repository.Session.TenantIdGuid);
if (sqlFromAlias.Contains("@Rok"))
{
string sRok = (parameters.ContainsKey(nameof(Rok).ToUpper())) ? parameters[nameof(Rok).ToUpper()].ToString() : DateTime.Now.Year.ToString();
sqlFromAlias = sqlFromAlias.Replace("@Rok", sRok);
}
//ObdobieOd sa pri FIN 1-12 do funkcie nevyžíva - od je iba na ilustraciu pre usera na FE
if (sqlFromAlias.Contains("@Obdobie"))
{
string sObdobie = parameters.ContainsKey("OBDOBIEDO") ? parameters["OBDOBIEDO"].ToString() : DateTime.Now.Month.ToString();
sqlFromAlias = sqlFromAlias.Replace("@Obdobie", sObdobie);
}
bool showP = parameters.ContainsKey("SHOWP");
bool showV = parameters.ContainsKey("SHOWV");
if ((showP || showV) && !(showP && showV))
{
newFilter.AndEq(nameof(PrijemVydaj), showP ? 1 : 2);
}
bool ShowB = parameters.ContainsKey("SHOWB");
bool ShowK = parameters.ContainsKey("SHOWK");
bool ShowF = parameters.ContainsKey("SHOWF");
if ((ShowB || ShowK || ShowF) && !(ShowB && ShowK & ShowF))
{
//1 - 'Bežný'; 2 - 'Kapitálový', 3 - 'Finančné operácie'
newFilter.And(FilterElement.Custom($"{nameof(C_RzpTyp_Id)} IN ({(ShowB ? 1 : -1)}, {(ShowK ? 2 : -1)}, {(ShowF ? 3 : -1)})"));
}
filter = BookFilterGenerator.AddNoDialogFilters(filter, newFilter);
}
}
public void BeforeGetList(IWebEasRepositoryBase repository, HierarchyNode node, ref string sql, ref Filter filter, ref string sqlFromAlias, string sqlOrderPart)
{
BookFilterGenerator.UctDennik_BeforeGetList(repository, node, ref sql, ref filter, ref sqlFromAlias, sqlOrderPart);
}
