private void eliminaRecordDb()
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
io_db.NameProcedureDb = "pack_CostiGestioneCumulativi.del_Download_Reports_An_Co_Op";
int result = io_db.Delete();
}
private DataSet riempiDatasetDownload()
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiRicerca = new S_ControlsCollection();
S_Object Cursor = new S_Object();
Cursor.ParameterName = "RSCursor";
Cursor.DbType = CustomDBType.Cursor;
Cursor.Direction = ParameterDirection.Output;
Cursor.Index = 0;
clDatiRicerca.Add(Cursor);
io_db.NameProcedureDb = "pack_CostiGestioneCumulativi.get_Download_Reports_An_Co_Op";
DataSet dsDatiRicerca = io_db.GetData(clDatiRicerca).Copy();
// DatasetReport DsTipizzato = new DatasetReport();
// int i=0;
// for(i=0; i<=dsDatiRicerca.Tables[0].Rows.Count-1;i++)
// {
// DsTipizzato.Tables["DownloadFile"].ImportRow(dsDatiRicerca.Tables[0].Rows[i]);
// }
//
// if(i==0)
// {
//
// }
return(dsDatiRicerca);
}
private DataSet riempiDatasetDettaglioOdl(string id)
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiRicerca = new S_ControlsCollection();
int index = 0;
S_Object Pid = new S_Object();
Pid.ParameterName = "Pid";
Pid.DbType = CustomDBType.Integer;
Pid.Direction = ParameterDirection.Input;
Pid.Index = index++;
Pid.Value = Convert.ToInt32(id);
clDatiRicerca.Add(Pid);
S_Object Cursor = new S_Object();
Cursor.ParameterName = "RSCursor";
Cursor.DbType = CustomDBType.Cursor;
Cursor.Direction = ParameterDirection.Output;
Cursor.Index = index++;
clDatiRicerca.Add(Cursor);
io_db.NameProcedureDb = "rapportipdf.RecuperaOdl";
DataSet dsDatiRicerca = io_db.GetData(clDatiRicerca).Copy();
return(dsDatiRicerca);
}
private void deleteTblNorm(int idFile)
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiUpDb = new S_ControlsCollection();
int pIndex = 0;
S_Object pIddFile = new S_Object();
pIddFile.ParameterName = "p_idFile";
pIddFile.DbType = CustomDBType.Integer;
pIddFile.Direction = ParameterDirection.Input;
pIddFile.Size = 16;
pIddFile.Index = pIndex++;
pIddFile.Value = idFile;
clDatiUpDb.Add(pIddFile);
S_Object pOdl = new S_Object();
pOdl.ParameterName = "p_Odl";
pOdl.DbType = CustomDBType.Integer;
pOdl.Direction = ParameterDirection.Input;
pOdl.Size = 16;
pOdl.Index = pIndex++;
pOdl.Value = DBNull.Value;
clDatiUpDb.Add(pOdl);
io_db.NameProcedureDb = "RapportiPdf.inserisciTblNorm";
int result = io_db.Delete(clDatiUpDb, 0);
}
private TheSite.StampaRapportiPDF.Schemixsd.DatasetReport riempiDatasetDownload()
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiRicerca = new S_ControlsCollection();
S_Object Cursor = new S_Object();
Cursor.ParameterName = "RSCursor";
Cursor.DbType = CustomDBType.Cursor;
Cursor.Direction = ParameterDirection.Output;
Cursor.Index = 0;
clDatiRicerca.Add(Cursor);
io_db.NameProcedureDb = "rapportipdf.get_Download_Reports";
DataSet dsDatiRicerca = io_db.GetData(clDatiRicerca).Copy();
TheSite.StampaRapportiPDF.Schemixsd.DatasetReport DsTipizzato = new TheSite.StampaRapportiPDF.Schemixsd.DatasetReport();
int i = 0;
for (i = 0; i <= dsDatiRicerca.Tables[0].Rows.Count - 1; i++)
{
DsTipizzato.Tables["DownloadFile"].ImportRow(dsDatiRicerca.Tables[0].Rows[i]);
}
if (i == 0)
{
}
return(DsTipizzato);
}
private void eliminaRecordDb()
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiUpDb = new S_ControlsCollection();
S_Object pFinto = new S_Object();
pFinto.ParameterName = "p_finto";
pFinto.DbType = CustomDBType.VarChar;
pFinto.Direction = ParameterDirection.Input;
pFinto.Size = 16;
pFinto.Index = 0;
pFinto.Value = DBNull.Value;
clDatiUpDb.Add(pFinto);
io_db.NameProcedureDb = "RapportiPdf.svutaTbelleAppoggio";
int result = io_db.Delete(clDatiUpDb, 0);
}
// private DataSet riempiDatasetDettaglioOdl(string id)
// {
// AgganciaDatalayer io_db = new AgganciaDatalayer();
// S_ControlsCollection clDatiRicerca = new S_ControlsCollection();
// int index=0;
//
// S_Object Pid = new S_Object();
// Pid.ParameterName = "Pid";
// Pid.DbType = CustomDBType.Integer;
// Pid.Direction = ParameterDirection.Input;
// Pid.Index = index++;
// Pid.Value = Convert.ToInt32(id);
// clDatiRicerca.Add(Pid);
//
// S_Object Cursor = new S_Object();
// Cursor.ParameterName = "RSCursor";
// Cursor.DbType = CustomDBType.Cursor;
// Cursor.Direction = ParameterDirection.Output;
// Cursor.Index = index++;
// clDatiRicerca.Add(Cursor);
// io_db.NameProcedureDb = "rapportipdf.RecuperaOdl";
// DataSet dsDatiRicerca = io_db.GetData(clDatiRicerca).Copy();
// return dsDatiRicerca;
// }
// private void riempiSchedaDettaglioOdl(DataSet dsOdl)
// {
// string tmpOdl = string.Empty;
// StringBuilder sb = new StringBuilder();
// for(int i =0; i<=dsOdl.Tables[0].Rows.Count -1; i++)
// {
// sb.Append(dsOdl.Tables[0].Rows[i][0].ToString());
// sb.Append("-");
// }
// tmpOdl = sb.ToString();
// string resultOdl = tmpOdl.Remove(tmpOdl.Length-1,1);
// lblIntervalloOdl.Text = resultOdl;
// }
private DataSet riempiDatasetDettaglio(string id)
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiRicerca = new S_ControlsCollection();
int index = 0;
S_Object Pid = new S_Object();
Pid.ParameterName = "P_id";
Pid.DbType = CustomDBType.Integer;
Pid.Direction = ParameterDirection.Input;
Pid.Index = index++;
Pid.Value = Convert.ToInt32(id);
clDatiRicerca.Add(Pid);
S_Object Cursor = new S_Object();
Cursor.ParameterName = "RSCursor";
Cursor.DbType = CustomDBType.Cursor;
Cursor.Direction = ParameterDirection.Output;
Cursor.Index = index++;
clDatiRicerca.Add(Cursor);
io_db.NameProcedureDb = "pack_CostiGestioneCumulativi.get_Dettaglio_Report_An_Co_Op";
DataSet dsDatiRicerca = io_db.GetData(clDatiRicerca).Copy();
// DataSet Ds = new DataSet();
// int i=0;
// for(i=0; i<=dsDatiRicerca.Tables[0].Rows.Count-1;i++)
// {
// DsTipizzato.Tables["DownloadFile"].ImportRow(dsDatiRicerca.Tables[0].Rows[i]);
// }
// if(i==0)
// {
//
// }
return(dsDatiRicerca);
}
private TheSite.StampaRapportiPDF.Schemixsd.DatasetReport riempiDatasetDettaglio(string id)
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiRicerca = new S_ControlsCollection();
int index = 0;
S_Object Pid = new S_Object();
Pid.ParameterName = "Pid";
Pid.DbType = CustomDBType.Integer;
Pid.Direction = ParameterDirection.Input;
Pid.Index = index++;
Pid.Value = Convert.ToInt32(id);
clDatiRicerca.Add(Pid);
S_Object Cursor = new S_Object();
Cursor.ParameterName = "RSCursor";
Cursor.DbType = CustomDBType.Cursor;
Cursor.Direction = ParameterDirection.Output;
Cursor.Index = index++;
clDatiRicerca.Add(Cursor);
io_db.NameProcedureDb = "rapportipdf.RecuperaDettagli";
DataSet dsDatiRicerca = io_db.GetData(clDatiRicerca).Copy();
DatasetReport DsTipizzato = new DatasetReport();
int i = 0;
for (i = 0; i <= dsDatiRicerca.Tables[0].Rows.Count - 1; i++)
{
DsTipizzato.Tables["DownloadFile"].ImportRow(dsDatiRicerca.Tables[0].Rows[i]);
}
if (i == 0)
{
}
return(DsTipizzato);
}
private TheSite.StampaRapportiPDF_new.Schemixsd.DatasetReport riempiDatasetDownload()
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiRicerca = new S_ControlsCollection();
S_Object pusername = new S_Object();
pusername.ParameterName = "p_utente";
pusername.DbType = CustomDBType.VarChar;
pusername.Direction = ParameterDirection.Input;
pusername.Size = 50;
pusername.Index = 0;
pusername.Value = System.Web.HttpContext.Current.User.Identity.Name;
clDatiRicerca.Add(pusername);
S_Object Cursor = new S_Object();
Cursor.ParameterName = "RSCursor";
Cursor.DbType = CustomDBType.Cursor;
Cursor.Direction = ParameterDirection.Output;
Cursor.Index = 0;
clDatiRicerca.Add(Cursor);
io_db.NameProcedureDb = "rapportipdf.get_Download_Reports_";
DataSet dsDatiRicerca = io_db.GetData(clDatiRicerca).Copy();
TheSite.StampaRapportiPDF_new.Schemixsd.DatasetReport DsTipizzato = new TheSite.StampaRapportiPDF_new.Schemixsd.DatasetReport();
int i = 0;
for (i = 0; i <= dsDatiRicerca.Tables[0].Rows.Count - 1; i++)
{
DsTipizzato.Tables["DownloadFile"].ImportRow(dsDatiRicerca.Tables[0].Rows[i]);
}
if (i == 0)
{
}
return(DsTipizzato);
}
private void riempiSchedaDettaglio(DataSet ds)
{
AgganciaDatalayer io_db = new AgganciaDatalayer();
lblDataDiCreazione.Text = ds.Tables[0].Rows[0]["data_created"].ToString();
lblRichiestaLavoro.Text = ds.Tables[0].Rows[0]["RICHIESTA_DI_LAVORO"].ToString();
lblEdificio.Text = ds.Tables[0].Rows[0]["CODICE_EDIFICIO"].ToString();
if (lblEdificio.Text != "tutti")
{
DataSet dsBuilding = io_db.GetEdificio(lblEdificio.Text);
lblComune.Text = dsBuilding.Tables[0].Rows[0]["desccomune"].ToString();
lblDitta.Text = dsBuilding.Tables[0].Rows[0]["referente"].ToString();
}
else
{
DataSet dsBuilding = io_db.GetEdificio(lblEdificio.Text);
lblComune.Text = "tutti";
lblDitta.Text = "tutte";
}
// lblCategoria.Text = ds.Tables[0].Rows[0]["categoria"].ToString();
lblOdl.Text = ds.Tables[0].Rows[0]["ORDINE_LAVORO"].ToString();
lblIntervalloRdl.Text = ds.Tables[0].Rows[0]["STRINGARDL"].ToString();
lblGruppo.Text = ds.Tables[0].Rows[0]["richidenti_tipo_id"].ToString();
lblRichiedenti.Text = ds.Tables[0].Rows[0]["EM_ID"].ToString();
lblServizio.Text = ds.Tables[0].Rows[0]["SERVIZIO_ID"].ToString();
lblTipoManutenzione.Text = ds.Tables[0].Rows[0]["TIPOMANUTENZIONE_ID"].ToString();
lblAddetto.Text = ds.Tables[0].Rows[0]["ADDETTO_ID"].ToString();
lblUrgenza.Text = ds.Tables[0].Rows[0]["ID_PRIORITY"].ToString();
lblStatoRichiesta.Text = ds.Tables[0].Rows[0]["STATO_RICHIESTA"].ToString();
lblDataDa.Text = ds.Tables[0].Rows[0]["DATA_DA"].ToString();
lblDataA.Text = ds.Tables[0].Rows[0]["DATA_A"].ToString();
lblDimensioneFilePdf.Text = ds.Tables[0].Rows[0]["dimensione_file"].ToString();
lblDimensioneFileZip.Text = ds.Tables[0].Rows[0]["dimensione_file_zip"].ToString();
lblDataPrevistaInizio.Text = ds.Tables[0].Rows[0]["data_assegnazione_init"].ToString();
lblDataPrevistaFine.Text = ds.Tables[0].Rows[0]["data_assegnazione_end"].ToString();
// lblDataCompletamentoIniziale.Text = ds.Tables["DownloadFile"].Rows[0]["data_completamento_init"].ToString();
// lblDataCompletamentoFinale.Text = ds.Tables["DownloadFile"].Rows[0]["data_completamento_end"].ToString();
}
private int deleteDb(int idFile)
{
int pIndex = 0;
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiUpDb = new S_ControlsCollection();
S_Object pNomeFile = new S_Object();
pNomeFile.ParameterName = "p_NOME_FILE";
pNomeFile.DbType = CustomDBType.VarChar;
pNomeFile.Direction = ParameterDirection.Input;
pNomeFile.Index = pIndex++;
pNomeFile.Value = DBNull.Value;;
clDatiUpDb.Add(pNomeFile);
S_Object pStringaRdl = new S_Object();
pStringaRdl.ParameterName = "P_STRINGARDL";
pStringaRdl.DbType = CustomDBType.VarChar;
pStringaRdl.Direction = ParameterDirection.Input;
pStringaRdl.Index = pIndex++;
pStringaRdl.Value = DBNull.Value;;
clDatiUpDb.Add(pStringaRdl);
S_Object pDataCreated = new S_Object();
pDataCreated.ParameterName = "P_DATA_CREATED";
pDataCreated.DbType = CustomDBType.VarChar;
pDataCreated.Direction = ParameterDirection.Input;
pDataCreated.Index = pIndex++;
pDataCreated.Value = DBNull.Value;;
clDatiUpDb.Add(pDataCreated);
S_Object pDataAssegnazioneIn = new S_Object();
pDataAssegnazioneIn.ParameterName = "P_DATA_ASSEGNAZIONE_INIT";
pDataAssegnazioneIn.DbType = CustomDBType.VarChar;
pDataAssegnazioneIn.Direction = ParameterDirection.Input;
pDataAssegnazioneIn.Index = pIndex++;
pDataAssegnazioneIn.Value = DBNull.Value; ////DBNull.Value;
clDatiUpDb.Add(pDataAssegnazioneIn);
S_Object pDataAssegnazioneEnd = new S_Object();
pDataAssegnazioneEnd.ParameterName = "P_DATA_ASSEGNAZIONE_END";
pDataAssegnazioneEnd.DbType = CustomDBType.VarChar;
pDataAssegnazioneEnd.Direction = ParameterDirection.Input;
pDataAssegnazioneEnd.Index = pIndex++;
pDataAssegnazioneEnd.Value = DBNull.Value; ////DBNull.Value;
clDatiUpDb.Add(pDataAssegnazioneEnd);
S_Object pDataCompletamentoIn = new S_Object();
pDataCompletamentoIn.ParameterName = "P_DATA_COMPLETAMENTO_INIT";
pDataCompletamentoIn.DbType = CustomDBType.VarChar;
pDataCompletamentoIn.Direction = ParameterDirection.Input;
pDataCompletamentoIn.Index = pIndex++;
pDataCompletamentoIn.Value = DBNull.Value; ////DBNull.Value;
clDatiUpDb.Add(pDataCompletamentoIn);
S_Object pDataCompletamentoEnd = new S_Object();
pDataCompletamentoEnd.ParameterName = "P_DATA_COMPLETAMENTO_END";
pDataCompletamentoEnd.DbType = CustomDBType.VarChar;
pDataCompletamentoEnd.Direction = ParameterDirection.Input;
pDataCompletamentoEnd.Index = pIndex++;
pDataCompletamentoEnd.Value = DBNull.Value; ////DBNull.Value;
clDatiUpDb.Add(pDataCompletamentoEnd);
S_Object pEdificio = new S_Object();
pEdificio.ParameterName = "P_EDIFICIO";
pEdificio.DbType = CustomDBType.VarChar;
pEdificio.Direction = ParameterDirection.Input;
pEdificio.Size = 8;
pEdificio.Index = pIndex++;
pEdificio.Value = DBNull.Value;; //S_cmbComune.SelectedItem.Text;
clDatiUpDb.Add(pEdificio);
S_Object pRichiestaLavoro = new S_Object();
pRichiestaLavoro.ParameterName = "P_RICHIESTA_DI_LAVORO";
pRichiestaLavoro.DbType = CustomDBType.Integer;
pRichiestaLavoro.Direction = ParameterDirection.Input;
pRichiestaLavoro.Index = pIndex++;
pRichiestaLavoro.Value = DBNull.Value; //txtsRichiesta.Text; //S_cmbEdificio.SelectedItem.Text;
clDatiUpDb.Add(pRichiestaLavoro);
S_Object pAddetto = new S_Object();
pAddetto.ParameterName = "P_ADDETTO";
pAddetto.DbType = CustomDBType.VarChar;
pAddetto.Direction = ParameterDirection.Input;
pAddetto.Index = pIndex++;
pAddetto.Value = DBNull.Value; //Addetti1.NomeCompleto; //S_cmbDitta.SelectedItem.Text;
clDatiUpDb.Add(pAddetto);
S_Object pDataDa = new S_Object();
pDataDa.ParameterName = "P_DATA_DA";
pDataDa.DbType = CustomDBType.VarChar;
pDataDa.Size = 64;
pDataDa.Direction = ParameterDirection.Input;
pDataDa.Index = pIndex++;
pDataDa.Value = DBNull.Value;; //S_cmbCategoria.SelectedItem.Text;
clDatiUpDb.Add(pDataDa);
S_Object pDataA = new S_Object();
pDataA.ParameterName = "P_DATA_A";
pDataA.DbType = CustomDBType.VarChar;
pDataA.Size = 64;
pDataA.Direction = ParameterDirection.Input;
pDataA.Index = pIndex++;
pDataA.Value = DBNull.Value;; //S_cmbAddetto.SelectedItem.Text;
clDatiUpDb.Add(pDataA);
S_Object pOrdineDiLavoro = new S_Object();
pOrdineDiLavoro.ParameterName = "P_ORDINE_LAVORO";
pOrdineDiLavoro.DbType = CustomDBType.VarChar;
pOrdineDiLavoro.Direction = ParameterDirection.Input;
pOrdineDiLavoro.Size = 256;
pOrdineDiLavoro.Index = pIndex++;
pOrdineDiLavoro.Value = DBNull.Value;
clDatiUpDb.Add(pOrdineDiLavoro);
S_Object pStatoRichiesta = new S_Object();
pStatoRichiesta.ParameterName = "P_STATO_RICHIESTA";
pStatoRichiesta.DbType = CustomDBType.VarChar;
pStatoRichiesta.Size = 256;
pStatoRichiesta.Direction = ParameterDirection.Input;
pStatoRichiesta.Index = pIndex++;
pStatoRichiesta.Value = DBNull.Value;;
clDatiUpDb.Add(pStatoRichiesta);
S_Object pServizioId = new S_Object();
pServizioId.ParameterName = "P_SERVIZIO_ID";
pServizioId.DbType = CustomDBType.VarChar;
pServizioId.Size = 256;
pServizioId.Direction = ParameterDirection.Input;
pServizioId.Index = pIndex++;
pServizioId.Value = DBNull.Value;
clDatiUpDb.Add(pServizioId);
S_Object pRichiedentiTipoId = new S_Object();
pRichiedentiTipoId.ParameterName = "P_RICHIEDENTI_TIPO_ID";
pRichiedentiTipoId.DbType = CustomDBType.VarChar;
pRichiedentiTipoId.Direction = ParameterDirection.Input;
pRichiedentiTipoId.Size = 256;
pRichiedentiTipoId.Index = pIndex++;
pRichiedentiTipoId.Value = DBNull.Value;;
clDatiUpDb.Add(pRichiedentiTipoId);
S_Object pEm_Id = new S_Object();
pEm_Id.ParameterName = "P_EM_ID";
pEm_Id.DbType = CustomDBType.VarChar;
pEm_Id.Size = 256;
pEm_Id.Direction = ParameterDirection.Input;
pEm_Id.Index = pIndex++;
pEm_Id.Value = DBNull.Value;; //Richiedenti1.txtRichiedente;
clDatiUpDb.Add(pEm_Id);
S_Object pIdPriority = new S_Object();
pIdPriority.ParameterName = "P_ID_PRIORITY";
pIdPriority.DbType = CustomDBType.VarChar;
pIdPriority.Size = 256;
pIdPriority.Direction = ParameterDirection.Input;
pIdPriority.Index = pIndex++;
pIdPriority.Value = DBNull.Value; // strOdl.Replace(",","-");
clDatiUpDb.Add(pIdPriority);
S_Object pDescrizione = new S_Object();
pDescrizione.ParameterName = "P_DESCRIZIONE";
pDescrizione.DbType = CustomDBType.VarChar;
pDescrizione.Size = 256;
pDescrizione.Direction = ParameterDirection.Input;
pDescrizione.Index = pIndex++;
pDescrizione.Value = DBNull.Value;
clDatiUpDb.Add(pDescrizione);
S_Object pTipoManutenzioneId = new S_Object();
pTipoManutenzioneId.ParameterName = "P_TIPOMANUTENZIONE_ID";
pTipoManutenzioneId.DbType = CustomDBType.VarChar;
pDescrizione.Size = 256;
pTipoManutenzioneId.Direction = ParameterDirection.Input;
pTipoManutenzioneId.Index = pIndex++;
pTipoManutenzioneId.Value = DBNull.Value;;
clDatiUpDb.Add(pTipoManutenzioneId);
S_Object pDimensioneFile = new S_Object();
pDimensioneFile.ParameterName = "P_DIMENSIONE_FILE";
pDimensioneFile.DbType = CustomDBType.Integer;
pDimensioneFile.Direction = ParameterDirection.Input;
pDimensioneFile.Index = pIndex++;
pDimensioneFile.Value = 0;
clDatiUpDb.Add(pDimensioneFile);
S_Object pDimensioneZip = new S_Object();
pDimensioneZip.ParameterName = "P_DIMENSIONE_FILE_ZIP";
pDimensioneZip.DbType = CustomDBType.Integer;
pDimensioneZip.Direction = ParameterDirection.Input;
pDimensioneZip.Index = pIndex++;
pDimensioneZip.Value = 0;
clDatiUpDb.Add(pDimensioneZip);
S_Object pTipologiaReport = new S_Object();
pTipologiaReport.ParameterName = "P_TIPOLOGIA_REPORT";
pTipologiaReport.DbType = CustomDBType.VarChar;
pTipologiaReport.Direction = ParameterDirection.Input;
pTipologiaReport.Index = pIndex++;
pTipologiaReport.Value = DBNull.Value;
clDatiUpDb.Add(pTipologiaReport);
S_Object pDimensionePdfZip = new S_Object();
pDimensionePdfZip.ParameterName = "p_DIMENSIONEFILE_PDF_ZIP";
pDimensionePdfZip.DbType = CustomDBType.Integer;
pDimensionePdfZip.Direction = ParameterDirection.Input;
pDimensionePdfZip.Index = pIndex++;
pDimensionePdfZip.Value = 0;
clDatiUpDb.Add(pDimensionePdfZip);
io_db.NameProcedureDb = "pack_CostiGestioneCumulativi.UpdAnalisiCostiOperativi";
int result = io_db.Delete(clDatiUpDb, idFile);
return(result);
}
private int deleteDb(int idFile)
{
int pIndex = 0;
AgganciaDatalayer io_db = new AgganciaDatalayer();
S_ControlsCollection clDatiUpDb = new S_ControlsCollection();
S_Object pNomeFile = new S_Object();
pNomeFile.ParameterName = "p_NOME_FILE";
pNomeFile.DbType = CustomDBType.VarChar;
pNomeFile.Direction = ParameterDirection.Input;
pNomeFile.Size = 128;
pNomeFile.Index = pIndex;
pNomeFile.Value = DBNull.Value;
clDatiUpDb.Add(pNomeFile);
S_Object pDataAssegnazioneIn = new S_Object();
pDataAssegnazioneIn.ParameterName = "P_DATA_ASSEGNAZIONE_INIT";
pDataAssegnazioneIn.DbType = CustomDBType.VarChar;
pDataAssegnazioneIn.Direction = ParameterDirection.Input;
pDataAssegnazioneIn.Size = 10;
pDataAssegnazioneIn.Index = pIndex++;
pDataAssegnazioneIn.Value = DBNull.Value;
clDatiUpDb.Add(pDataAssegnazioneIn);
S_Object pDataAssegnazioneEnd = new S_Object();
pDataAssegnazioneEnd.ParameterName = "P_DATA_ASSEGNAZIONE_END";
pDataAssegnazioneEnd.DbType = CustomDBType.VarChar;
pDataAssegnazioneEnd.Direction = ParameterDirection.Input;
pDataAssegnazioneEnd.Size = 10;
pDataAssegnazioneEnd.Index = pIndex++;
pDataAssegnazioneEnd.Value = DBNull.Value;
clDatiUpDb.Add(pDataAssegnazioneEnd);
S_Object pDataCompletamentoIn = new S_Object();
pDataCompletamentoIn.ParameterName = "P_DATA_COMPLETAMENTO_INIT";
pDataCompletamentoIn.DbType = CustomDBType.VarChar;
pDataCompletamentoIn.Direction = ParameterDirection.Input;
pDataCompletamentoIn.Size = 10;
pDataCompletamentoIn.Index = pIndex++;
pDataCompletamentoIn.Value = DBNull.Value;
clDatiUpDb.Add(pDataCompletamentoIn);
S_Object pDataCompletamentoEnd = new S_Object();
pDataCompletamentoEnd.ParameterName = "P_DATA_COMPLETAMENTO_END";
pDataCompletamentoEnd.DbType = CustomDBType.VarChar;
pDataCompletamentoEnd.Direction = ParameterDirection.Input;
pDataCompletamentoEnd.Size = 10;
pDataCompletamentoEnd.Index = pIndex++;
pDataCompletamentoEnd.Value = DBNull.Value;
clDatiUpDb.Add(pDataCompletamentoEnd);
S_Object pComune = new S_Object();
pComune.ParameterName = "P_COMUNE";
pComune.DbType = CustomDBType.VarChar;
pComune.Direction = ParameterDirection.Input;
pComune.Size = 64;
pComune.Index = pIndex++;
pComune.Value = DBNull.Value;
clDatiUpDb.Add(pComune);
S_Object pEdificio = new S_Object();
pEdificio.ParameterName = "P_EDIFICIO";
pEdificio.DbType = CustomDBType.VarChar;
pEdificio.Direction = ParameterDirection.Input;
pEdificio.Size = 255;
pEdificio.Index = pIndex++;
pEdificio.Value = DBNull.Value;
clDatiUpDb.Add(pEdificio);
S_Object pDitta = new S_Object();
pDitta.ParameterName = "P_DITTA";
pDitta.DbType = CustomDBType.VarChar;
pDitta.Direction = ParameterDirection.Input;
pDitta.Size = 32;
pDitta.Index = pIndex++;
pDitta.Value = DBNull.Value;
clDatiUpDb.Add(pDitta);
S_Object pCategoria = new S_Object();
pCategoria.ParameterName = "P_CATEGORIA";
pCategoria.DbType = CustomDBType.VarChar;
pCategoria.Direction = ParameterDirection.Input;
pCategoria.Size = 32;
pCategoria.Index = pIndex++;
pCategoria.Value = DBNull.Value;
clDatiUpDb.Add(pCategoria);
S_Object pAddetto = new S_Object();
pAddetto.ParameterName = "P_ADDETTO";
pAddetto.DbType = CustomDBType.VarChar;
pAddetto.Direction = ParameterDirection.Input;
pAddetto.Size = 128;
pAddetto.Index = pIndex++;
pAddetto.Value = DBNull.Value;
clDatiUpDb.Add(pAddetto);
S_Object pSoloNonCompletate = new S_Object();
pSoloNonCompletate.ParameterName = "P_SOLO_NON_COMPLETATE";
pSoloNonCompletate.DbType = CustomDBType.VarChar;
pSoloNonCompletate.Direction = ParameterDirection.Input;
pSoloNonCompletate.Size = 8;
pSoloNonCompletate.Index = pIndex++;
pSoloNonCompletate.Value = DBNull.Value;
clDatiUpDb.Add(pSoloNonCompletate);
S_Object pSoloCompletate = new S_Object();
pSoloCompletate.ParameterName = "P_SOLO_COMPLETATE";
pSoloCompletate.DbType = CustomDBType.VarChar;
pSoloCompletate.Direction = ParameterDirection.Input;
pSoloCompletate.Size = 8;
pSoloCompletate.Index = pIndex++;
pSoloCompletate.Value = DBNull.Value;
clDatiUpDb.Add(pSoloCompletate);
S_Object pDataDiCompletamento = new S_Object();
pDataDiCompletamento.ParameterName = "P_DATA_DI_COMPLETAMENTO";
pDataDiCompletamento.DbType = CustomDBType.VarChar;
pDataDiCompletamento.Direction = ParameterDirection.Input;
pDataDiCompletamento.Size = 8;
pDataDiCompletamento.Index = pIndex++;
pDataDiCompletamento.Value = DBNull.Value;
clDatiUpDb.Add(pDataDiCompletamento);
S_Object pDimensioneFile = new S_Object();
pDimensioneFile.ParameterName = "P_DIMENSIONE_FILE";
pDimensioneFile.DbType = CustomDBType.Integer;
pDimensioneFile.Direction = ParameterDirection.Input;
pDimensioneFile.Size = 32;
pDimensioneFile.Index = pIndex++;
pDimensioneFile.Value = DBNull.Value;
clDatiUpDb.Add(pDimensioneFile);
S_Object pDimensioneFileZip = new S_Object();
pDimensioneFileZip.ParameterName = "P_DIMENSIONE_FILE_ZIP";
pDimensioneFileZip.DbType = CustomDBType.Integer;
pDimensioneFileZip.Direction = ParameterDirection.Input;
pDimensioneFileZip.Size = 32;
pDimensioneFileZip.Index = pIndex++;
pDimensioneFileZip.Value = DBNull.Value;
clDatiUpDb.Add(pDimensioneFileZip);
S_Object pOdlSelezionati = new S_Object();
pOdlSelezionati.ParameterName = "P_INTERVALLO_ODL_SELEZIONATI";
pOdlSelezionati.DbType = CustomDBType.VarChar;
pOdlSelezionati.Direction = ParameterDirection.Input;
pOdlSelezionati.Size = 256;
pOdlSelezionati.Index = pIndex++;
pOdlSelezionati.Value = DBNull.Value;
clDatiUpDb.Add(pOdlSelezionati);
S_Object pTipologiaReport = new S_Object();
pTipologiaReport.ParameterName = "P_TIPOLOGIA_REPORT";
pTipologiaReport.DbType = CustomDBType.VarChar;
pTipologiaReport.Direction = ParameterDirection.Input;
pTipologiaReport.Size = 16;
pTipologiaReport.Index = pIndex++;
pTipologiaReport.Value = DBNull.Value;
clDatiUpDb.Add(pTipologiaReport);
S_Object pDimensionePdfZip = new S_Object();
pDimensionePdfZip.ParameterName = "p_DIMENSIONEFILE_PDF_ZIP";
pDimensionePdfZip.DbType = CustomDBType.VarChar;
pDimensionePdfZip.Direction = ParameterDirection.Input;
pDimensionePdfZip.Size = 128;
pDimensionePdfZip.Index = pIndex++;
pDimensionePdfZip.Value = DBNull.Value;
clDatiUpDb.Add(pDimensionePdfZip);
S_Object pCompletate = new S_Object();
pCompletate.ParameterName = "p_COMPLETATE";
pCompletate.DbType = CustomDBType.VarChar;
pCompletate.Direction = ParameterDirection.Input;
pCompletate.Size = 128;
pCompletate.Index = pIndex++;
pCompletate.Value = DBNull.Value;
clDatiUpDb.Add(pCompletate);
S_Object pDataAssInOut = new S_Object();
pDataAssInOut.ParameterName = "P_Data_ass_in_out";
pDataAssInOut.DbType = CustomDBType.VarChar;
pDataAssInOut.Direction = ParameterDirection.Input;
pDataAssInOut.Size = 30;
pDataAssInOut.Index = pIndex++;
pDataAssInOut.Value = DBNull.Value;
clDatiUpDb.Add(pDataAssInOut);
io_db.NameProcedureDb = "RapportiPdf.inserisciTabellaDwn";
int result = io_db.Delete(clDatiUpDb, idFile);
return(result);
}
