public static InputDeliveries GetList(HashOidList oidList, bool childs, int sessionCode)
{
QueryConditions conditions = new QueryConditions
{
OidList = oidList.ToList()
};
return(GetList(InputDelivery.SELECT(conditions), childs, sessionCode));
}
public static ProductList GetList(HashOidList oidList, bool childs)
{
QueryConditions conditions = new QueryConditions
{
OidList = oidList.ToList()
};
return(GetList(ProductList.SELECT(conditions), childs));
}
public static Stores GetList(HashOidList oidList, bool childs)
{
QueryConditions conditions = new QueryConditions
{
OidList = oidList.ToList()
};
return(GetList(Almacen.SELECT(conditions, false), childs));
}
public static Expedients GetList(HashOidList oidList, bool childs)
{
QueryConditions conditions = new QueryConditions
{
OidList = oidList.ToList()
};
return(GetList(Expedient.SELECT(conditions, false), childs));
}
public static OutputDeliveries GetList(HashOidList oidList, bool childs, int sessionCode)
{
QueryConditions conditions = new QueryConditions
{
TipoEntidad = Common.ETipoEntidad.Cliente,
OidList = oidList.ToList()
};
return(GetList(OutputDelivery.SELECT(conditions, false), childs, sessionCode));
}
public static string GET_IN_BRANCHES_LIST_CONDITION(HashOidList oidList, string tableAlias)
{
if (oidList == null)
{
return(string.Empty);
}
string list = string.Empty;
if (oidList.List.Count == 0)
{
list = "(0)";
}
else
{
list = GET_IN_STRING(oidList.ToList());
}
return(@"
AND " + tableAlias + @".""OID_BRANCH"" IN " + list);
}
