/// <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 }