/// <summary> /// /// </summary> /// <param name="objDiritti"></param> /// <returns></returns> public static System.Collections.ArrayList getListaRagioni(DocsPaVO.trasmissione.Diritti objDiritti, bool flgDaRicercaTrasm, bool sysExt = false) { #region Codice Commentato /* * System.Collections.ArrayList objListaRagioni = new System.Collections.ArrayList(); * DocsPa_V15_Utils.database.SqlServerAgent db = new DocsPa_V15_Utils.database.SqlServerAgent(); * db.openConnection(); * * try * { * string queryString = getQueryRagione(null); * queryString += " AND (ID_AMM IS NULL "; * if(objDiritti != null) * queryString += " OR ID_AMM = " + objDiritti.idAmministrazione; * queryString += ")"; * * try * { * if (objDiritti != null && objDiritti.accessRights != null && objDiritti.accessRights.Equals("45")) * { * queryString += " AND CHA_TIPO_DIRITTI IN ('R', 'C') "; * } * } * catch (Exception) {} * * logger.Debug(queryString); * IDataReader dr = db.executeReader(queryString); * while (dr.Read()) * { * objListaRagioni.Add(getDatiRagione(dr)); * } * dr.Close(); * } catch (Exception e) * { * logger.Debug (e.Message); * db.closeConnection(); * throw new Exception(e.Message); * } * // chiudo le connessioni * db.closeConnection(); * return objListaRagioni; */ #endregion DocsPaDB.Query_DocsPAWS.Trasmissione strDB = new DocsPaDB.Query_DocsPAWS.Trasmissione(); return(strDB.GetListRag(objDiritti, flgDaRicercaTrasm, sysExt)); }
/// <summary> /// /// </summary> /// <param name="objDiritti"></param> /// <returns></returns> public static System.Collections.ArrayList getListaRagioniATutti(DocsPaVO.trasmissione.Diritti objDiritti) { DocsPaDB.Query_DocsPAWS.Trasmissione strDB = new DocsPaDB.Query_DocsPAWS.Trasmissione(); return(strDB.GetListRagATutti(objDiritti)); }