/// <summary> /// Ritorna la lista degli id dei documenti /// </summary> /// <param name="idObject"></param> /// <param name="filter"></param> /// <returns></returns> public List <string> GetDocumentByNotificationsFilters(string[] idObject, DocsPaVO.Notification.NotificationsFilters filter) { List <string> listIdObject = new List <string>(); try { DataSet ds = new DataSet(); string query = string.Empty; string condition = string.Empty; DocsPaUtils.Query q = DocsPaUtils.InitQuery.getInstance().getQuery("S_PROFILE_SYSTEM_ID_BY_FILTER_NOTIFICATION"); condition = BuildConditionNotificationsFilters(idObject, filter); q.setParam("condition", condition); query = q.getSQL(); if (this.ExecuteQuery(out ds, "idObject", query)) { if (ds.Tables["idObject"] != null && ds.Tables["idObject"].Rows.Count > 0) { foreach (DataRow row in ds.Tables["idObject"].Rows) { listIdObject.Add(row["SYSTEM_ID"].ToString()); } } } } catch (Exception e) { throw e; } return(listIdObject); }
public static List <string> GetDocumentByNotificationsFilters(string[] idObject, DocsPaVO.Notification.NotificationsFilters filter) { List <string> listIdObject = new List <string>(); try { DocsPaDB.Query_DocsPAWS.NotificationDB notificationDB = new DocsPaDB.Query_DocsPAWS.NotificationDB(); listIdObject = notificationDB.GetDocumentByNotificationsFilters(idObject, filter); } catch (Exception e) { logger.Debug("Errore in BusinessLogic.ServiceNotifications.Notification - metodo: GetDocumentByNotificationsFilters ", e); } return(listIdObject); }