Beispiel #1
0
        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);
        }
Beispiel #2
0
        /// <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);
        }
Beispiel #3
0
        /// <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();
            }
        }
Beispiel #4
0
        /// <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");
        }
Beispiel #5
0
        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);
        }
Beispiel #6
0
        /// <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);
        }
Beispiel #7
0
        /// <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);
        }
Beispiel #8
0
        /// <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);
        }
Beispiel #9
0
        /// <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);
        }
Beispiel #10
0
        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);
        }
Beispiel #11
0
        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);
        }
Beispiel #12
0
        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);
        }
Beispiel #13
0
        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);
        }
Beispiel #14
0
        /// <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);
        }
Beispiel #15
0
        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);
        }
Beispiel #16
0
        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);
        }
Beispiel #17
0
        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);
        }
Beispiel #18
0
        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);
        }
Beispiel #19
0
        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);
        }
Beispiel #20
0
        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);
        }
Beispiel #21
0
        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);
        }