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 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 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);
}