public GestioneMateriali GetTipizzato()
{
GestioneMateriali ds = new GestioneMateriali();
ds = TblGestioneMateriali(ds);
return(ds);
}
private void GeneraRptPdf(int WrId, int IdMateriale, string DataIniziale, string DataFinale, int Stato)
{
MaterialiWrDb DatiRpt = new MaterialiWrDb(WrId, IdMateriale, Stato, DataIniziale, DataFinale);
GestioneMateriali ds = DatiRpt.GetTipizzato();
string pathRptSource = Server.MapPath(Request.ApplicationPath + ConfigurationSettings.AppSettings["SourceReports"]);
crReportDocument.Load(pathRptSource + "RptGestioneMateriali_V9.rpt");
crReportDocument.SetDataSource(ds);
string Fname = pathRptSource + Session.SessionID.ToString() + ".pdf";
crDiskFileDestinationOptions = new DiskFileDestinationOptions();
crDiskFileDestinationOptions.DiskFileName = Fname;
crExportOptions = crReportDocument.ExportOptions;
crExportOptions.DestinationOptions = crDiskFileDestinationOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crReportDocument.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(Fname);
Response.Flush();
Response.Close();
System.IO.File.Delete(Fname);
}
private GestioneMateriali TblGestioneMateriali(GestioneMateriali ds)
{
///Istanzio un nuovo oggetto Collection per aggiungere i parametri
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
//Id_WR
S_Controls.Collections.S_Object s_p_wrid = new S_Controls.Collections.S_Object();
s_p_wrid.ParameterName = "p_wrid";
s_p_wrid.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_wrid.Direction = ParameterDirection.Input;
s_p_wrid.Size = 50;
s_p_wrid.Index = _SCollection.Count;
s_p_wrid.Value = Convert.ToInt32(_Wr_id);
_SCollection.Add(s_p_wrid);
//id_materiale
S_Controls.Collections.S_Object s_p_id_materiale = new S_Controls.Collections.S_Object();
s_p_id_materiale.ParameterName = "p_id_materiale";
s_p_id_materiale.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_materiale.Direction = ParameterDirection.Input;
s_p_id_materiale.Size = 50;
s_p_id_materiale.Index = _SCollection.Count;
s_p_id_materiale.Value = Convert.ToInt32(_Materiali_Id);
_SCollection.Add(s_p_id_materiale);
//data aggiornamento Dal
S_Controls.Collections.S_Object s_p_dataaggiornamentoDal = new S_Controls.Collections.S_Object();
s_p_dataaggiornamentoDal.ParameterName = "p_dataaggiornamentoDal";
s_p_dataaggiornamentoDal.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataaggiornamentoDal.Direction = ParameterDirection.Input;
s_p_dataaggiornamentoDal.Size = 50;
s_p_dataaggiornamentoDal.Index = _SCollection.Count;
s_p_dataaggiornamentoDal.Value = _DataIniziale.ToString();
_SCollection.Add(s_p_dataaggiornamentoDal);
//data aggiornamento Al
S_Controls.Collections.S_Object s_p_dataaggiornamentoAl = new S_Controls.Collections.S_Object();
s_p_dataaggiornamentoAl.ParameterName = "p_dataaggiornamentoAl";
s_p_dataaggiornamentoAl.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataaggiornamentoAl.Direction = ParameterDirection.Input;
s_p_dataaggiornamentoAl.Size = 50;
s_p_dataaggiornamentoAl.Index = _SCollection.Count;
s_p_dataaggiornamentoAl.Value = _DataFinale.ToString();
_SCollection.Add(s_p_dataaggiornamentoAl);
//Id stato
S_Controls.Collections.S_Object s_p_stato = new S_Controls.Collections.S_Object();
s_p_stato.ParameterName = "p_stato";
s_p_stato.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_stato.Direction = ParameterDirection.Input;
s_p_stato.Size = 50;
s_p_stato.Index = _SCollection.Count;
s_p_stato.Value = Convert.ToInt32(_Stato);
_SCollection.Add(s_p_stato);
S_Controls.Collections.S_Object s_Cursor = new S_Object();
s_Cursor.ParameterName = "io_cursor";
s_Cursor.DbType = CustomDBType.Cursor;
s_Cursor.Direction = ParameterDirection.Output;
s_Cursor.Index = _SCollection.Count;
_SCollection.Add(s_Cursor);
OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
DataSet GenericDs = _OraDl.GetRows(_SCollection, "Pack_WrMateriali.getMateriali").Copy();
if (GenericDs.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < GenericDs.Tables[0].Rows.Count; i++)
{
ds.Tables["TblGestioneMateriali"].ImportRow(GenericDs.Tables[0].Rows[i]);
}
}
return(ds);
}
