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