public DataSet GetDocImage(S_ControlsCollection CollezioneControlli)
{
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_DOCUMENTI.SP_GETDOCUMENTOIMAGE";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public override DataSet GetData(S_ControlsCollection CollezioneControlli)
{
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 = CollezioneControlli.Count;
CollezioneControlli.Add(S_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDL = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_ADDETTI.SP_GETLIVELLO";
_Ds = _OraDL.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
// Paolo
public int GetRDL1Count(S_ControlsCollection CollezioneControlli)
{
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_COMMON.SP_GET_RDLCount";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(int.Parse(_Ds.Tables[0].Rows[0][0].ToString()));
}
public DataSet GetAllCategoria()
{
S_ControlsCollection _SColl = new S_ControlsCollection();
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 = 1;
_SColl.Add(s_Cursor);
_OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_RPT_GESTIONE_SPAZI.SP_GETALLCATEGORIE";
_Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy();
return(_Ds);
}
private DataTable DataViste()
{
OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
S_ControlsCollection param = new S_ControlsCollection();
S_Object io_cursor = new S_Object();
io_cursor.ParameterName = "io_cursor";
io_cursor.Direction = ParameterDirection.Output;
io_cursor.DbType = ApplicationDataLayer.DBType.CustomDBType.Cursor;
io_cursor.Index = 1;
param.Add(io_cursor);
DataSet ds = _OraDl.ExecuteProcedure(param, "IL_PACK_INTERROGAZIONI.GetSchemaViste");
return(ds.Tables[0]);
}
/// <summary>
/// Ottine la lista delle contabilizzazioni
/// </summary>
/// <returns></returns>
public DataSet GetContabilizzazione()
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
string s_StrSql = "PACK_MAN_STRA.SP_GETCONTABILIZZAZIONE";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
/// <summary>
/// Restituisce l'elenco degli stati della richiesta
/// </summary>
/// <returns></returns>
public DataSet GetStatoLavoro()
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
string s_StrSql = "PACK_MAN_ORD.SP_GETSTATOLAVORO";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
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);
}
/// <summary>
/// Ricerca le Ferie gia inserite
/// </summary>
/// <param name="CollezioneControlli">
/// Accetta una collezioni di parametri
/// p_nome in varchar2,
/// p_cognome in varchar2,
/// p_dataInizio in varchar2,
/// p_dataFine in varchar2,
/// p_idMotivo in number,
/// </param>
/// <returns>Ritorna un DataSet</returns>
public override DataSet GetData(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_PIANOFERIE.SP_GETPIANOFERIEUSER";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet CompletaWO(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
string s_StrSql = "PACK_MAN_PROG.CompletaWO";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetDateServiziEdifici(S_ControlsCollection CollezioneControlli)
{
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_DATITECNICIAPP.SP_GETDATESERVIZIEDIFICI";
// string s_StrSql = "PACK_DATITECNICI_M.SP_GETDATESERVIZIEDIFICI";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
/// <summary>
/// Ritorna la Lista dei Macro Componenti
/// </summary>
/// <returns></returns>
public DataSet GetMacroComponenti()
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_DATITECNICIAPP.SP_GETMACROCOMPONENTI";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public int ExecuteUpdateFile(S_ControlsCollection CollezioneControlli)
{
int i_Result = 0;
S_Controls.Collections.S_Object p_id_out = new S_Object();
p_id_out.ParameterName = "p_id_out";
p_id_out.DbType = CustomDBType.Integer;
p_id_out.Direction = ParameterDirection.Output;
p_id_out.Index = CollezioneControlli.Count;
p_id_out.Value = 0;
CollezioneControlli.Add(p_id_out);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
i_Result = _OraDl.GetRowsAffected(CollezioneControlli, "PACK_CONTABILITA.UPD_FILE_CANONE");
return(i_Result);
}
public int ExecuteUpdateFile(S_ControlsCollection CollezioneControlli)
{
int i_Result = 0;
S_Controls.Collections.S_Object id_doc_norm_out = new S_Object();
id_doc_norm_out.ParameterName = "file_delete";
id_doc_norm_out.DbType = CustomDBType.VarChar;
id_doc_norm_out.Direction = ParameterDirection.Output;
id_doc_norm_out.Index = CollezioneControlli.Count;
id_doc_norm_out.Value = "";
CollezioneControlli.Add(id_doc_norm_out);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
i_Result = _OraDl.GetRowsAffected(CollezioneControlli, "PACK_CPERIODICI_SFOGLIA.UPD_FILE_DOC_NORM");
return(i_Result);
}
public int DEL_CP(S_ControlsCollection CollezioneControlli)
{
int i_Result = 0;
S_Controls.Collections.S_Object p_id_wr_cp_out = new S_Object();
p_id_wr_cp_out.ParameterName = "p_id_wr_cp_out";
p_id_wr_cp_out.DbType = CustomDBType.Integer;
p_id_wr_cp_out.Direction = ParameterDirection.Output;
p_id_wr_cp_out.Index = CollezioneControlli.Count;
p_id_wr_cp_out.Value = 0;
CollezioneControlli.Add(p_id_wr_cp_out);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
i_Result = _OraDl.GetRowsAffected(CollezioneControlli, "PACK_CPERIODICI_SFOGLIA.DEL_CP");
return(i_Result);
}
private void btnElimina_Click(object sender, System.EventArgs e)
{
OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
S_ControlsCollection param = new S_ControlsCollection();
S_Object pid = new S_Object();
pid.ParameterName = "pid";
pid.Direction = ParameterDirection.Input;
pid.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
pid.Size = 32;
pid.Index = 0;
pid.Value = IdVista;
param.Add(pid);
int RE = _OraDl.GetRowsAffected(param, "IL_PACK_INTERROGAZIONI.EliminaVista");
Server.Transfer("SelectSchema.aspx");
}
public DataSet GetFrazione(S_ControlsCollection CollezioneControlli)
{
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 = 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_COMMON.SP_GETFRAZIONI";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
// metodo che fa il count
public int getCount(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_SCHEDULA.Rapportino_RicercaCount";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(int.Parse(_Ds.Tables[0].Rows[0][0].ToString()));
}
protected override int ExecuteUpdate(S_ControlsCollection CollezioneControlli, ExecuteType Operazione, int itemId)
{
CollezioneControlli.RemoveAt(16);
CollezioneControlli.RemoveAt(15);
CollezioneControlli.RemoveAt(14);
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_ORDINARIA_SFOGLIA.SP_GETRDLODL3Count";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(int.Parse(_Ds.Tables[0].Rows[0][0].ToString()));
}
public DataSet GetDestinatariInvio(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_TRACCIA_DOC.SP_Destinatari";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetDataEmail(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count;
CollezioneControlli.Add(S_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDL = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_DETINATARIINVIO.SP_RICERCADESTINATARIEMAIL";
_Ds = _OraDL.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public int Update(S_ControlsCollection CollezioneControlli)
{
int i_MaxParametri = CollezioneControlli.Count + 1;
S_Controls.Collections.S_Object s_IdOut = new S_Object();
s_IdOut.ParameterName = "p_IdOut";
s_IdOut.DbType = CustomDBType.Integer;
s_IdOut.Direction = ParameterDirection.Output;
s_IdOut.Index = i_MaxParametri;
CollezioneControlli.Add(s_IdOut);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
int i_Result = _OraDl.GetRowsAffected(CollezioneControlli, "PACK_IMPOSTAZIONI_AUTOMATICHE.SP_EXECUTEIMPAUTO");
return(i_Result);
}
public DataSet RicercaApparecchiaturaPerStanza(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_APPARECCHIATURE.SP_GETAPPARECCHIATUREPERSTANZA";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
/// <summary>
/// Recupero i Livelli di Urgenza
/// </summary>
/// <returns></returns>
public DataSet GetUrgenza()
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_GEST_RDL.SP_GETURGENZA";
DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public int RicercaDataRoomSTDCount(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_APPARECCHIATURE.SP_DATAROOMSTDCount";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(int.Parse(_Ds.Tables[0].Rows[0][0].ToString()));;
}
public DataSet GetDataStanzeExcel(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_BUILDINGS.SP_RICERCASTANZAEXCEL";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetDataPaging(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_SCHEDULA.Crea_WR_RicercaPaging";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet DatiTestata_STR(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = CollezioneControlli.Count;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_APPARECCHIATURE.sp_dati_stanza_str";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
public DataSet GetSingleRdL(S_ControlsCollection CollezioneControlli)
{
DataSet _Ds;
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 = 1;
CollezioneControlli.Add(s_Cursor);
string s_StrSql = "PACK_GEST_RDL.SP_GETSINGLERDL";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
private void carica_record()
{
PageTitle1.Title += ": " + Request.QueryString["wr_id"];
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_IdIn = new S_Object();
s_IdIn.ParameterName = "p_wr_id";
s_IdIn.DbType = CustomDBType.Integer;
s_IdIn.Direction = ParameterDirection.Input;
s_IdIn.Index = 1;
s_IdIn.Size = 10;
s_IdIn.Value = Request.QueryString["wr_id"];
_SCollection.Add(s_IdIn);
Classi.ManOrdinaria.Richiesta _Richiesta = new TheSite.Classi.ManOrdinaria.Richiesta();
DataSet _MyDs = _Richiesta.GetHWR(_SCollection, Context.User.Identity.Name).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
// DataGridRicerca.Visible = true;
if (_MyDs.Tables[0].Rows.Count == 0)
{
DataGridRicerca.CurrentPageIndex = 0;
}
else
{
int Pagina = 0;
if ((_MyDs.Tables[0].Rows.Count % DataGridRicerca.PageSize) > 0)
{
Pagina++;
}
if (DataGridRicerca.PageCount != Convert.ToInt16((_MyDs.Tables[0].Rows.Count / DataGridRicerca.PageSize) + Pagina))
//if (DataGridRicerca.PageCount != DataGridRicerca.CurrentPageIndex)
{
DataGridRicerca.CurrentPageIndex = 0;
}
}
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}