Exemple #1
0
        /// <summary>
        /// </summary>
        /// <param name="db"></param>
        /// <param name="idProfile"></param>
        /// <param name="tipoCorr"></param>
        /// <param name="infoUtente"></param>
        /// <param name="debug"></param>
        private static void deleteDocArrivoPar(string idPeople, string idCorrGlobali, string idProfile, string tipoCorr)
        {
            DocsPaDB.Query_DocsPAWS.Documenti doc = new DocsPaDB.Query_DocsPAWS.Documenti();
            doc.DeleteDocArrivoPar(idPeople, idCorrGlobali, idProfile, tipoCorr);

            #region Codice Commentato

            /*string deleteString;
             *          // Cancellazione da DPA_STATO_INVIO
             *          deleteString =
             *                  "DELETE FROM DPA_STATO_INVIO WHERE ID_DOC_ARRIVO_PAR IN " +
             *                  "(SELECT SYSTEM_ID FROM DPA_DOC_ARRIVO_PAR WHERE CHA_TIPO_MITT_DEST='" +
             *                  tipoCorr + "' AND ID_PROFILE =" + idProfile + ")";
             *          logger.Debug(deleteString);
             *          db.executeLocked(deleteString);
             *
             *          //string now = DocsPaWS.Utils.DateControl.getDate(true);
             *          //string data = DocsPaWS.Utils.dbControl.toDate(now, true);
             *          //aggiornamento tabella storico
             *          string insertString =
             *                  "INSERT INTO DPA_CORR_STO " +
             *                  "(" + DocsPaWS.Utils.dbControl.getSystemIdColName() +
             *                  " ID_PROFILE, ID_MITT_DEST, CHA_TIPO_MITT_DEST, DTA_MODIFICA, ID_PEOPLE, ID_RUOLO_IN_UO) " +
             *                  "SELECT " + DocsPaWS.Utils.dbControl.getSystemIdNextVal("DPA_CORR_STO") +
             *                  "ID_PROFILE, ID_MITT_DEST, CHA_TIPO_MITT_DEST, " + Utils.dbControl.getDate() + ", " + infoUtente.idPeople + "," + infoUtente.idCorrGlobali +
             *                  " FROM DPA_DOC_ARRIVO_PAR WHERE CHA_TIPO_MITT_DEST='" +
             *                  tipoCorr + "' AND ID_PROFILE =" + idProfile;
             *          logger.Debug(insertString);
             *          db.executeNonQuery(insertString);
             *
             *
             *          deleteString =
             *                  "DELETE FROM DPA_DOC_ARRIVO_PAR WHERE CHA_TIPO_MITT_DEST='" +
             *                  tipoCorr + "' AND ID_PROFILE =" + idProfile;
             *          logger.Debug(deleteString);
             *          db.executeLocked(deleteString);*/
            #endregion
        }