protected override HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport) { HeaderColumnCollection header = new HeaderColumnCollection(); //header = base.GenerateReportHeaderFromDataSet(dataSet); //aggiunta colonne per report header.Add(new HeaderProperty() { ColumnName = "ISTANZA", ColumnSize = 50, OriginalName = "id_oggetto", Export = true, DataType = HeaderProperty.ContentDataType.Integer }); header.Add(new HeaderProperty() { ColumnName = "UTENTE", ColumnSize = 120, OriginalName = "userid_operatore", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DATA AZIONE", ColumnSize = 120, OriginalName = "dta_azione", Export = true, DataType = HeaderProperty.ContentDataType.DateTime }); header.Add(new HeaderProperty() { ColumnName = "ESITO", ColumnSize = 50, OriginalName = "cha_esito", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "AZIONE", ColumnSize = 350, OriginalName = "var_desc_oggetto", Export = true, DataType = HeaderProperty.ContentDataType.String }); return(header); }
/// <summary> /// Metodo per la generazione dell'header del report /// </summary> /// <param name="dataSet"></param> /// <param name="fieldsToExport"></param> /// <returns></returns> protected override HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport) { HeaderColumnCollection header = new HeaderColumnCollection(); // Inizializzazione dell'header a partire dal dataset header = base.GenerateReportHeaderFromDataSet(dataSet); // Modifica delle descrizioni di interesse header["IdDoc"].ColumnName = "Segn. proto. / Id doc."; header["Oggetto_Documento"].ColumnName = "Oggetto"; header.Add(new HeaderProperty() { ColumnName = "Segn. repertorio", OriginalName = "Segn. repertorio" }); header["Data_Di_Repertorio"].ColumnName = "Data repertorio"; header["Data_Annullamento"].ColumnName = "Data annullamento"; // Rimozione delle colonne con la descrizione del nome del campo e con l'id dell'amministrazione header.Remove(header["Descrizione_Campo_Profilato"]); // Ogni colonna un campo header.Remove(header["Valore"]); header.Remove(header["IdAmm"]); header.Remove(header["DocNumber"]); header.Remove(header["ObjType"]); header.Remove(header["EnabledHistory"]); header.Remove(header["ObjectId"]); return(header); }
/// <summary> /// Funzione per l'aggiornamento di una riga del report /// </summary> /// <param name="row">Riga da aggiornare</param> /// <param name="reportHeader"></param> /// <param name="dataRow">DataRow da cui estrarre i dati con cui aggiornare la riga</param> private void UpdateRow(ReportMapRowProperty row, DataRow dataRow, HeaderColumnCollection reportHeader) { // Se non esiste già una colonna per un dato campo profilato, viene aggiunta if (reportHeader[dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString()] == null) { reportHeader.Add(new HeaderProperty() { ColumnName = dataRow["Descrizione_Campo_Profilato"].ToString(), OriginalName = dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString() }); } // Se non esiste già un mapping di colonna, viene aggiunto if (row[dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString()] == null) { row.Columns.Add(new ReportMapColumnProperty() { ColumnName = dataRow["Descrizione_Campo_Profilato"].ToString(), OriginalName = dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString() }); } // Aggiunta della data di annullamento //row[dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString()].Value = dataRow["Data_Annullamento"].ToString(); // Aggiornamento del valore per il dato campo if (String.IsNullOrEmpty(row[dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString()].Value)) { String value = dataRow["ObjType"].ToString().ToLower() == "corrispondente" && !String.IsNullOrEmpty(dataRow["Valore"].ToString()) ? BusinessLogic.Utenti.UserManager.GetRoleDescriptionByIdCorrGlobali(dataRow["Valore"].ToString()) : dataRow["Valore"].ToString(); row[dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString()].Value = value; } else { row[dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString()].Value += ", " + dataRow["Valore"].ToString(); } }
/// <summary> /// Metodo per l'aggiunta dei nomi dei campi profilati alle colonne del report /// </summary> /// <param name="dataSet"></param> /// <param name="header"></param> private void GenerateAdditionalColumns(DataSet dataSet, HeaderColumnCollection header) { logger.Debug("BEGIN"); String firstFolderId = string.Empty; foreach (DataRow dataRow in dataSet.Tables[0].Rows) { if (string.IsNullOrEmpty(dataRow["ID_PROJECT"].ToString())) { // Le prime righe con id_project = null contengono solo i campi profilati della tipologia if (dataRow["NOME_CAMPO"] != null) { header.Add(new HeaderProperty() { ColumnName = dataRow["NOME_CAMPO"].ToString(), OriginalName = dataRow["NOME_CAMPO"].ToString(), ColumnSize = 80 }); logger.Debug("Aggiunta colonna " + dataRow["NOME_CAMPO"].ToString()); } } else { // Se il valore della riga cambia sono passato all'elemento successivo e devo fermarmi break; } } logger.Debug("END"); }
protected override HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport) { logger.Debug("BEGIN"); HeaderColumnCollection header = new HeaderColumnCollection(); // Creo le colonne base #region Creazione colonne header.Add(new HeaderProperty() { ColumnName = "PROGRESSIVO", OriginalName = "Progressivo", ColumnSize = 70, Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DESCRIZIONE", OriginalName = "DESCRIZIONE", ColumnSize = 120, Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "UFFICIO", OriginalName = "UFFICIO", ColumnSize = 140, Export = true, DataType = HeaderProperty.ContentDataType.String }); #endregion // Aggiungo le colonne relative alla tipologia in esame this.GenerateAdditionalColumns(dataSet, header); logger.Debug("END"); return(header); }
/// <summary> /// Questo report prevede la possibilità di selezionare i campi da esportare /// </summary> /// <returns>Collezione con la lista dei campi che costituiscono il report</returns> protected override HeaderColumnCollection GetExportableFieldsCollection() { HeaderColumnCollection retList = new HeaderColumnCollection(); retList.Add(this.GetHeaderColumn("Cod. Modello", 108, "Codice")); retList.Add(this.GetHeaderColumn("Descr. Modello", 320, "Descrizione")); retList.Add(this.GetHeaderColumn("Visibilità", 390, "Mittenti")); retList.Add(this.GetHeaderColumn("Doc. o Fasc", 158, "DocOrFasc")); retList.Add(this.GetHeaderColumn("Registro", 180, "Registro")); retList.Add(this.GetHeaderColumn("Ragione Tram. - Destinatari", 390, "Destinatari")); retList.Add(this.GetHeaderColumn("Ruoli disabilitati", 390, "Disabled")); retList.Add(this.GetHeaderColumn("Ruoli inibiti alla ricezione di trasmissione", 390, "Inhibited")); return(retList); }
/// <summary> /// Questo report prevede la possibilità di selezionare i campi da esportare /// </summary> /// <returns>Collezione con la lista dei campi che costituiscono il report</returns> protected override HeaderColumnCollection GetExportableFieldsCollection() { HeaderColumnCollection retList = new HeaderColumnCollection(); retList.Add(this.GetHeaderColumn("Tipo", 150, "Type")); retList.Add(this.GetHeaderColumn("Mittente", 200, "From")); retList.Add(this.GetHeaderColumn("Oggetto", 420, "Subject")); retList.Add(this.GetHeaderColumn("Data Invio", 200, "Date")); retList.Add(this.GetHeaderColumn("Allegati", 30, "CountAttatchments")); retList.Add(this.GetHeaderColumn("Esito Controllo Messaggio", 420, "CheckResult")); return(retList); }
/// <summary> /// Funzione per la generazione di una nuova riga del report /// </summary> /// <param name="dataRow">DataRow da cui estrarre i dati per inizializzare la riga</param> /// <param name="reportHeader">Header del report</param> /// <returns>Riga inizializzata</returns> private ReportMapRowProperty GenerateNewRow(DataRow dataRow, HeaderColumnCollection reportHeader) { ReportMapRowProperty row = new ReportMapRowProperty(); // Aggiunta dell'id del documento row.Columns.Add(this.GenerateHeaderColumn(dataRow["IdDoc"].ToString(), "Segn. proto. / Id doc.", "IDDOC")); // Aggiunta dell'oggetto row.Columns.Add(this.GenerateHeaderColumn(dataRow["Oggetto_Documento"].ToString(), "Oggetto", "oggetto_documento")); String dataAnnullamento = String.Empty; // Aggiunta della segnatura di repertorio row.Columns.Add(this.GenerateHeaderColumn( DocManager.GetSegnaturaRepertorio(dataRow["DocNumber"].ToString(), dataRow["IdAmm"].ToString(), false, out dataAnnullamento), "Segn. repertorio", "Segn. repertorio")); // Aggiunta della data di repertorio row.Columns.Add(this.GenerateHeaderColumn(dataRow["Data_Di_Repertorio"].ToString(), "Data repertorio", "data_di_repertorio")); // Aggiunta della data di annullamento row.Columns.Add(this.GenerateHeaderColumn(dataAnnullamento, "Data annullamento", "data_annullamento")); // Aggiunta dell'impronta row.Columns.Add(this.GenerateHeaderColumn(dataRow["Impronta"].ToString(), "Impronta", "Impronta")); // Aggiunta del campo profilato con rispettivo valore (solo se il campo ha lo storico attivo) if (dataRow["EnabledHistory"].ToString() == "1") { if (reportHeader[dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString()] == null) { reportHeader.Add(new HeaderProperty() { ColumnName = dataRow["Descrizione_Campo_Profilato"].ToString(), OriginalName = dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString() }); } String value = dataRow["ObjType"].ToString().ToLower() == "corrispondente" && !String.IsNullOrEmpty(dataRow["Valore"].ToString()) ? BusinessLogic.Utenti.UserManager.GetRoleDescriptionByIdCorrGlobali(dataRow["Valore"].ToString()) : dataRow["Valore"].ToString(); row.Columns.Add(this.GenerateHeaderColumn(value, dataRow["Descrizione_Campo_Profilato"].ToString(), dataRow["Descrizione_Campo_Profilato"].ToString() + dataRow["ObjectId"].ToString())); } return(row); }
/// <summary> /// Metodo per la costruzione dell'header a partire da un dataset. /// </summary> /// <param name="dataSet">Dataset da utilizzare per la generazione dell'header</param> /// <returns>Lista delle proprietà dell'header</returns> protected HeaderColumnCollection GenerateReportHeaderFromDataSet(DataSet dataSet) { HeaderColumnCollection header = new HeaderColumnCollection(); foreach (DataColumn row in dataSet.Tables[0].Columns) { header.Add(new HeaderProperty() { ColumnName = row.ColumnName, OriginalName = row.ColumnName, ColumnSize = 0, Export = true, DataType = HeaderProperty.ContentDataType.String }); } return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, string contextName) { HeaderColumnCollection header = new HeaderColumnCollection(); //genero le colonne di interesse header.Add(new HeaderProperty() { ColumnName = "Tipo Doc.", ColumnSize = 40, OriginalName = "TIPO_DOC", Export = true, DataType = HeaderProperty.ContentDataType.Integer }); header.Add(new HeaderProperty() { ColumnName = "Oggetto", ColumnSize = 250, OriginalName = "OGGETTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Fasc.", ColumnSize = 40, OriginalName = "COD_FASC", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Data Ins.", ColumnSize = 100, OriginalName = "DATA_INS", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Id/Segn. Data", ColumnSize = 160, OriginalName = "ID_SEGN_DATA", Export = true, DataType = HeaderProperty.ContentDataType.String }); if (contextName == "NotificheRifiutoVerifiche") { header.Add(new HeaderProperty() { ColumnName = "Size Byte", ColumnSize = 70, OriginalName = "SIZE_ITEM", Export = true, DataType = HeaderProperty.ContentDataType.Integer }); header.Add(new HeaderProperty() { ColumnName = "Firma", ColumnSize = 40, OriginalName = "ESITO_FIRMA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Marca", ColumnSize = 40, OriginalName = "VALIDAZIONE_MARCA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Formato", ColumnSize = 40, OriginalName = "VALIDAZIONE_FORMATO", Export = true, DataType = HeaderProperty.ContentDataType.String }); } if (contextName == "NotificheRifiutoPolicy") { header.Add(new HeaderProperty() { ColumnName = "Criteri di verifica della Policy", ColumnSize = 1000, OriginalName = "MASK_VALIDAZIONE_POLICY", Export = true, DataType = HeaderProperty.ContentDataType.String }); } return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, string contextName) { HeaderColumnCollection header = new HeaderColumnCollection(); //genero le colonne di interesse header.Add(new HeaderProperty() { ColumnName = "Tipo Doc.", ColumnSize = 40, OriginalName = "TIPO_DOC", Export = true, DataType = HeaderProperty.ContentDataType.Integer }); header.Add(new HeaderProperty() { ColumnName = "Oggetto", ColumnSize = 250, OriginalName = "OGGETTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Fasc.", ColumnSize = 40, OriginalName = "COD_FASC", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Data Ins.", ColumnSize = 100, OriginalName = "DATA_INS", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Id/Segn. Data", ColumnSize = 160, OriginalName = "ID_SEGN_DATA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Size Byte", ColumnSize = 70, OriginalName = "SIZE_ITEM", Export = true, DataType = HeaderProperty.ContentDataType.Integer }); return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, string type) { HeaderColumnCollection header = new HeaderColumnCollection(); #region Policy documenti if (type.Equals("DOC")) { header.Add(new HeaderProperty() { ColumnName = "CODICE", ColumnSize = 50, OriginalName = "VAR_CODICE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DESCRIZIONE", ColumnSize = 300, OriginalName = "VAR_DESCRIZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "RUOLO RESPONSABILE", ColumnSize = 200, OriginalName = "RUOLO_RESP", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "STATO POLICY", ColumnSize = 50, OriginalName = "STATO_POLICY", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "PERIODICITA'", ColumnSize = 150, OriginalName = "PERIODICITA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "STATO CONSERVAZIONE", ColumnSize = 100, OriginalName = "STATO_CONS", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "TIPO DOC.", ColumnSize = 150, OriginalName = "TIPO_DOC", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "TIPOLOGIA", ColumnSize = 200, OriginalName = "TIPOLOGIA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "STATO", ColumnSize = 100, OriginalName = "STATO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "REGISTRO/AOO", ColumnSize = 100, OriginalName = "REGISTRO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "RF", ColumnSize = 100, OriginalName = "RF", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "UO CREATRICE", ColumnSize = 100, OriginalName = "UO_CREATRICE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "CLASSIFICAZIONE", ColumnSize = 200, OriginalName = "CLASSIFICAZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "TITOLARIO", ColumnSize = 200, OriginalName = "TITOLARIO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "SOLO DOC. DIGITALI", ColumnSize = 100, OriginalName = "DOC_DIGITALI", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "FORMATI DOCUMENTO", ColumnSize = 200, OriginalName = "FORMATI_DOC", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "FIRMATI", ColumnSize = 100, OriginalName = "FIRMATI", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "MARCATI", ColumnSize = 100, OriginalName = "MARCATI", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DATA CREAZIONE", ColumnSize = 150, OriginalName = "DATA_CREAZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DATA PROTOCOLLAZIONE", ColumnSize = 150, OriginalName = "DATA_PROTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "CAMPI PROFILATI", ColumnSize = 300, OriginalName = "CAMPI_PROFILATI", Export = true, DataType = HeaderProperty.ContentDataType.String }); } #endregion #region Policy stampe if (type.Equals("ST")) { header.Add(new HeaderProperty() { ColumnName = "CODICE", ColumnSize = 50, OriginalName = "VAR_CODICE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DESCRIZIONE", ColumnSize = 300, OriginalName = "VAR_DESCRIZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "RUOLO RESPONSABILE", ColumnSize = 200, OriginalName = "RUOLO_RESP", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "STATO POLICY", ColumnSize = 50, OriginalName = "STATO_POLICY", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "PERIODICITA'", ColumnSize = 150, OriginalName = "PERIODICITA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "STATO CONSERVAZIONE", ColumnSize = 100, OriginalName = "STATO_CONS", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "TIPO REGISTRO STAMPA", ColumnSize = 100, OriginalName = "TIPO_REG_PRINT", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "REPERTORIO", ColumnSize = 200, OriginalName = "REPERTORIO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "REGISTRO/AOO", ColumnSize = 100, OriginalName = "REGISTRO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "RF", ColumnSize = 100, OriginalName = "RF", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "ANNO STAMPA", ColumnSize = 50, OriginalName = "ANNO_STAMPA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DATA STAMPA", ColumnSize = 150, OriginalName = "DATA_STAMPA", Export = true, DataType = HeaderProperty.ContentDataType.String }); } #endregion return(header); }
protected HeaderColumnCollection GenerateReportHeader(System.Data.DataSet dataSet, HeaderColumnCollection fieldsToExport, string tipo) { HeaderColumnCollection header = new HeaderColumnCollection(); header.Add(new HeaderProperty() { ColumnName = "ID Doc. / Num. Protocollo", ColumnSize = 50, OriginalName = "ID", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tipo", ColumnSize = 100, OriginalName = "TIPO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Data creazione / protocollazione", ColumnSize = 100, OriginalName = "DATA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Oggetto", ColumnSize = 200, OriginalName = "OGGETTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); if (tipo.Equals("F")) { header.Add(new HeaderProperty() { ColumnName = "Data ultimo versamento", ColumnSize = 100, OriginalName = "DATA_ULTIMO_VERS", Export = true, DataType = HeaderProperty.ContentDataType.String }); } header.Add(new HeaderProperty() { ColumnName = "Codice Policy", ColumnSize = 100, OriginalName = "COD_POLICY", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "N. esecuzione Policy", ColumnSize = 50, OriginalName = "NUM_POLICY", Export = true, DataType = HeaderProperty.ContentDataType.String }); if (tipo.Equals("R")) { header.Add(new HeaderProperty() { ColumnName = "Messaggio di rifiuto", ColumnSize = 300, OriginalName = "MESS_RIFIUTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); } return(header); }
/// <summary> /// Questo report prevede la possibilità di selezionare i campi da esportare /// </summary> /// <returns>Collezione con la lista dei campi che costituiscono il report</returns> protected override HeaderColumnCollection GetExportableFieldsCollection() { HeaderColumnCollection retList = new HeaderColumnCollection(); retList.Add(this.GetHeaderColumn("Protocollo", 100, "PROTOCOLLO")); retList.Add(this.GetHeaderColumn("Descr. Oggetto", 400, "OGGETTO")); retList.Add(this.GetHeaderColumn("Nominativo Destinatario", 400, "NOMINATIVO_DESTINATARIO")); retList.Add(this.GetHeaderColumn("Tipo Dest.", 100, "TIPO_DESTINATARIO")); retList.Add(this.GetHeaderColumn("Mezzo Spedizione", 200, "MEZZO_SPEDIZIONE")); retList.Add(this.GetHeaderColumn("Mail Mittente", 200, "MAIL_MITTENTE")); retList.Add(this.GetHeaderColumn("Mail Destinatario", 200, "MAIL_DESTINATARIO")); retList.Add(this.GetHeaderColumn("Data Spedizione", 100, "DATA_SPEDIZIONE")); retList.Add(this.GetHeaderColumn("Accettazione", 100, "ACCETTAZIONE")); retList.Add(this.GetHeaderColumn("Consegna", 100, "CONSEGNA")); retList.Add(this.GetHeaderColumn("Conferma", 100, "CONFERMA")); retList.Add(this.GetHeaderColumn("Annullamento", 100, "ANNULLAMENTO")); retList.Add(this.GetHeaderColumn("Eccezione", 100, "ECCEZIONE")); retList.Add(this.GetHeaderColumn("Azione", 100, "AZIONE_INFO")); return(retList); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, string reportType) { HeaderColumnCollection header = new HeaderColumnCollection(); switch (reportType) { case "ExportProcessiFirma": header.Add(new HeaderProperty() { ColumnName = "Nome processo", ColumnSize = 400, OriginalName = "NOME_PROCESSO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Utente Disegnatore", ColumnSize = 100, OriginalName = "DESC_UTENTE_CREATORE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Ruolo Disegnatore", ColumnSize = 300, OriginalName = "DESC_RUOLO_CREATORE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Diagramma stato", ColumnSize = 400, OriginalName = "DESC_DIAGRAMMA_STATO", Export = true, DataType = HeaderProperty.ContentDataType.String }); break; case "ExportIstanzeProcessiFirma": header.Add(new HeaderProperty() { ColumnName = "Nome Processo", ColumnSize = 400, OriginalName = "NOME_PROCESSO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Utente Proponente", ColumnSize = 100, OriginalName = "DESC_UTENTE_PROPONENTE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Ruolo Proponente", ColumnSize = 300, OriginalName = "DESC_RUOLO_PROPONENTE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Data Avvio", ColumnSize = 90, OriginalName = "DATO_AVVIO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Id. Documento", ColumnSize = 70, OriginalName = "ID_DOCUMENTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tipo documento", ColumnSize = 70, OriginalName = "TIPO_DOCUMENTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); break; case "ExportProcessiDiFirmaInvalidati": header.Add(new HeaderProperty() { ColumnName = "Nome", ColumnSize = 400, OriginalName = "NOME_PROCESSO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Disegnatore", ColumnSize = 400, OriginalName = "CREATORE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Titolare modificato", ColumnSize = 400, OriginalName = "TITOLARE", Export = true, DataType = HeaderProperty.ContentDataType.String }); break; } return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, string contextName) { HeaderColumnCollection header = new HeaderColumnCollection(); //genero le colonne di interesse header.Add(new HeaderProperty() { ColumnName = "Segnatura/ID Documento", ColumnSize = 90, OriginalName = "Segnatura", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "ID Doc./Allegato", ColumnSize = 80, OriginalName = "idDoc", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Oggetto", ColumnSize = 200, OriginalName = "Oggetto", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Data Crezione/Proto", ColumnSize = 100, OriginalName = "DataCrezioneOProto", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tipo Doc.", ColumnSize = 40, OriginalName = "TipoDoc", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tipo File", ColumnSize = 40, OriginalName = "TipoFile", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Principale/Allegato", ColumnSize = 60, OriginalName = "PrincipaleAllegato", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Ammesso", ColumnSize = 40, OriginalName = "Ammesso", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Valido", ColumnSize = 40, OriginalName = "Valido", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Consolidato", ColumnSize = 40, OriginalName = "Consolidato", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Firmato", ColumnSize = 40, OriginalName = "Firmato", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Con Timestamp", ColumnSize = 40, OriginalName = "ConTimestamp", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Convertibile", ColumnSize = 50, OriginalName = "Convertibile", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tipo Diritto", ColumnSize = 40, OriginalName = "TipoDiritto", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Utente Proprietario", ColumnSize = 80, OriginalName = "UtenteProprietario", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Ruolo Proprietario", ColumnSize = 200, OriginalName = "RuoloProprietario", Export = true, DataType = HeaderProperty.ContentDataType.String }); return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, string reportType) { HeaderColumnCollection header = new HeaderColumnCollection(); switch (reportType) { case "AmmExportMacroFunzioni_Micro": header.Add(new HeaderProperty() { ColumnName = "Codice", ColumnSize = 100, OriginalName = "COD_FUNZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione", ColumnSize = 500, OriginalName = "VAR_DESC_FUNZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); break; case "AmmExportMacroFunzioni_Ruoli": header.Add(new HeaderProperty() { ColumnName = "Codice ruolo", ColumnSize = 80, OriginalName = "COD_RUOLO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione ruolo", ColumnSize = 200, OriginalName = "DESC_RUOLO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cod. UO", ColumnSize = 50, OriginalName = "COD_UO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione UO", ColumnSize = 200, OriginalName = "DESC_RUOLO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Reg. / RF", ColumnSize = 50, OriginalName = "REG_RF", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Utenti", ColumnSize = 400, OriginalName = "UTENTI", Export = true, DataType = HeaderProperty.ContentDataType.String }); break; } return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, string reportType) { HeaderColumnCollection header = new HeaderColumnCollection(); switch (reportType) { case "ExportTrasmissioniPendentiDoc": header.Add(new HeaderProperty() { ColumnName = "Trasm. il", ColumnSize = 100, OriginalName = "DTA_INVIO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Mittente Trasm. (Ruolo)", ColumnSize = 300, OriginalName = "MITTENTE_TRASM", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Ragione", ColumnSize = 200, OriginalName = "VAR_DESC_RAGIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Scadenza", ColumnSize = 100, OriginalName = "DTA_SCADENZA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Doc.", ColumnSize = 100, OriginalName = "ID_DOCUMENTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Segnatura", ColumnSize = 200, OriginalName = "VAR_SEGNATURA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Oggetto", ColumnSize = 400, OriginalName = "OGGETTO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Mittente", ColumnSize = 400, OriginalName = "MITTENTE", Export = true, DataType = HeaderProperty.ContentDataType.String }); break; case "ExportTrasmissioniPendentiFasc": header.Add(new HeaderProperty() { ColumnName = "Trasm. il", ColumnSize = 100, OriginalName = "DTA_INVIO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Mittente Trasm. (Ruolo)", ColumnSize = 300, OriginalName = "MITTENTE_TRASM", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Ragione", ColumnSize = 200, OriginalName = "VAR_DESC_RAGIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Scadenza", ColumnSize = 100, OriginalName = "DTA_SCADENZA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione", ColumnSize = 400, OriginalName = "DESCRIPTION", Export = true, DataType = HeaderProperty.ContentDataType.String }); break; } return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport, bool store) { HeaderColumnCollection header = new HeaderColumnCollection(); if (store) { header.Add(new HeaderProperty() { ColumnName = "Storicizza", ColumnSize = 60, OriginalName = "STORICIZZA", Export = true, DataType = HeaderProperty.ContentDataType.String }); } header.Add(new HeaderProperty() { ColumnName = "Cod. Registro", ColumnSize = 50, OriginalName = "VAR_CODICE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cod. Rubrica", ColumnSize = 80, OriginalName = "VAR_COD_RUBRICA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cod. Amm.", ColumnSize = 60, OriginalName = "VAR_CODICE_AMM", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cod. AOO", ColumnSize = 60, OriginalName = "VAR_CODICE_AOO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tipo", ColumnSize = 40, OriginalName = "CHA_TIPO_URP", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione", ColumnSize = 180, OriginalName = "VAR_DESC_CORR", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cognome", ColumnSize = 70, OriginalName = "VAR_COGNOME", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Nome", ColumnSize = 70, OriginalName = "VAR_NOME", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Indirizzo", ColumnSize = 120, OriginalName = "VAR_INDIRIZZO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "CAP", ColumnSize = 40, OriginalName = "VAR_CAP", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Città", ColumnSize = 60, OriginalName = "VAR_CITTA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Provincia", ColumnSize = 50, OriginalName = "VAR_PROVINCIA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Nazione", ColumnSize = 50, OriginalName = "VAR_NAZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cod. Fiscale", ColumnSize = 80, OriginalName = "VAR_COD_FISC", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "P. IVA", ColumnSize = 80, OriginalName = "VAR_COD_PI", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tel 1", ColumnSize = 60, OriginalName = "VAR_TELEFONO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Tel 2", ColumnSize = 60, OriginalName = "VAR_TELEFONO2", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Fax", ColumnSize = 60, OriginalName = "VAR_FAX", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Email", ColumnSize = 100, OriginalName = "VAR_EMAIL", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Località", ColumnSize = 60, OriginalName = "VAR_LOCALITA", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Note", ColumnSize = 120, OriginalName = "VAR_NOTE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Nuovo registro", ColumnSize = 80, OriginalName = "NUOVO_REGISTRO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Canale preferenziale", ColumnSize = 100, OriginalName = "DESCRIPTION", Export = true, DataType = HeaderProperty.ContentDataType.String }); return(header); }
protected override HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport) { HeaderColumnCollection header = new HeaderColumnCollection(); header.Add(new HeaderProperty() { ColumnName = "CODICE AMM.", ColumnSize = 100, OriginalName = "VAR_CODICE_AMM", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DESCRIZIONE AMM.", ColumnSize = 300, OriginalName = "VAR_DESC_AMM", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "CODICE POLICY", ColumnSize = 100, OriginalName = "VAR_CODICE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "DESCRIZIONE POLICY", ColumnSize = 300, OriginalName = "VAR_DESCRIZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "TIPO", ColumnSize = 30, OriginalName = "CHA_TIPO_POLICY", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "ULTIMA ESECUZIONE", ColumnSize = 100, OriginalName = "ULTIMA_ESECUZIONE", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "N.ESECUZIONI", ColumnSize = 50, OriginalName = "NUM_ESECUZIONI_PERIODO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "PRESI IN CARICO", ColumnSize = 100, OriginalName = "PRESI_CARICO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "RIFIUTATI", ColumnSize = 100, OriginalName = "RIFIUTATI", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "FALLITI", ColumnSize = 100, OriginalName = "FALLITI", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "ALTRI", ColumnSize = 100, OriginalName = "ALTRI", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "TOTALE", ColumnSize = 100, OriginalName = "TOT", Export = true, DataType = HeaderProperty.ContentDataType.String }); return(header); }
protected HeaderColumnCollection GenerateReportHeader(DataSet dataSet, HeaderColumnCollection fieldsToExport) { HeaderColumnCollection header = new HeaderColumnCollection(); header.Add(new HeaderProperty() { ColumnName = "Codice ruolo", ColumnSize = 80, OriginalName = "COD_RUOLO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione ruolo", ColumnSize = 200, OriginalName = "DESC_RUOLO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cod. tipo funzione", ColumnSize = 100, OriginalName = "COD_TIPO_FUNZ", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione tipo funzione", ColumnSize = 250, OriginalName = "DESC_TIPO_FUNZ", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Cod. UO", ColumnSize = 50, OriginalName = "COD_UO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Descrizione UO", ColumnSize = 200, OriginalName = "DESC_RUOLO", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Reg. / RF", ColumnSize = 50, OriginalName = "REG_RF", Export = true, DataType = HeaderProperty.ContentDataType.String }); header.Add(new HeaderProperty() { ColumnName = "Utenti", ColumnSize = 400, OriginalName = "UTENTI", Export = true, DataType = HeaderProperty.ContentDataType.String }); return(header); }