public DataSet GetImpostazioniDefault(S_ControlsCollection CollezioneControlli) { DataSet _Ds; S_Controls.Collections.S_Object s_UserName = new S_Object(); s_UserName.ParameterName = "p_UserName"; s_UserName.DbType = CustomDBType.VarChar; s_UserName.Direction = ParameterDirection.Input; s_UserName.Index = 4; s_UserName.Size = 50; s_UserName.Value = System.Web.HttpContext.Current.User.Identity.Name; CollezioneControlli.Add(s_UserName); 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 = 5; CollezioneControlli.Add(s_Cursor); string s_StrSql = "PACK_MAN_PROG.getImpostazioniDeafult"; _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy(); return(_Ds); }
/// <summary> /// Recupera le mail dei destinatari Xls ///</summary> private ArrayList GetDestinatariXls(int bl_id) { S_ControlsCollection _SColl = new S_ControlsCollection(); S_Controls.Collections.S_Object p = new S_Object(); p.ParameterName = "p_bl_id"; p.DbType = CustomDBType.Integer; p.Direction = ParameterDirection.Input; p.Index = _SColl.Count; p.Value = bl_id; _SColl.Add(p); p = new S_Object(); p.ParameterName = "IO_CURSOR"; p.DbType = CustomDBType.Cursor; p.Direction = ParameterDirection.Output; p.Index = _SColl.Count; _SColl.Add(p); string s_StrSql = "PACK_DETINATARIINVIO.SP_GETDESTINATARIXLS"; DataSet _Ds = _OraDl.GetRows(_SColl, s_StrSql); ArrayList li = new ArrayList(); foreach (DataRow riga in _Ds.Tables[0].Rows) { li.Add(riga["mail"].ToString()); } return(li); }
public DataSet GetComuni(int anno) { S_ControlsCollection CollezioneControlli = new S_ControlsCollection(); DataSet _Ds; S_Controls.Collections.S_Object s_Anno = new S_Object(); s_Anno.ParameterName = "p_Anno"; s_Anno.DbType = CustomDBType.Integer; s_Anno.Direction = ParameterDirection.Input; s_Anno.Index = 1; s_Anno.Size = 50; s_Anno.Value = anno; CollezioneControlli.Add(s_Anno); 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 = 2; CollezioneControlli.Add(s_Cursor); string s_StrSql = "PACK_SCHEDULA.Crea_WR_GetComuni"; _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy(); return(_Ds); }
public DataSet GetAllReparto(string descrizione) { S_ControlsCollection _SColl = new S_ControlsCollection(); S_Controls.Collections.S_Object s_p_descrizione = new S_Object(); s_p_descrizione.ParameterName = "p_descrizione"; s_p_descrizione.DbType = CustomDBType.VarChar; s_p_descrizione.Size = 225; s_p_descrizione.Direction = ParameterDirection.Input; s_p_descrizione.Index = 0; s_p_descrizione.Value = descrizione; _SColl.Add(s_p_descrizione); 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_RM.SP_GETALLREPARTO"; _Ds = _OraDl.GetRows(_SColl, s_StrSql).Copy(); return(_Ds); }
public override System.Data.DataSet GetData(S_Controls.Collections.S_ControlsCollection CollezioneControlli) { System.Data.DataSet _DSet; ApplicationDataLayer.OracleDataLayer _OraDl = new ApplicationDataLayer.OracleDataLayer(s_ConnStr); _DSet = _OraDl.GetRows(CollezioneControlli, _nomeSoredProcedure).Copy(); return(_DSet); }
private DataTable GetDataDIE() { S_ControlsCollection _SColl = new S_ControlsCollection(); S_Controls.Collections.S_Object p = new S_Object(); p.ParameterName = "p_wr_id"; p.DbType = CustomDBType.Integer; p.Direction = ParameterDirection.Input; p.Index = _SColl.Count; p.Value = this.wr_id; _SColl.Add(p); p = new S_Object(); p.ParameterName = "IO_CURSOR"; p.DbType = CustomDBType.Cursor; p.Direction = ParameterDirection.Output; p.Index = _SColl.Count; _SColl.Add(p); string s_StrSql = "PACK_MANCORRETIVA.SP_GETDATIDIE"; DataSet _Ds = _OraDl.GetRows(_SColl, s_StrSql); return(_Ds.Tables[0]); }
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 override System.Data.DataSet GetData(S_Controls.Collections.S_ControlsCollection CollezioneControlli) { System.Data.DataSet _DSet; ApplicationDataLayer.OracleDataLayer _OraDl = new ApplicationDataLayer.OracleDataLayer(s_ConnStr); //_DSet = _OraDl.GetRows(CollezioneControlli, "PACK_ANALISI_STATISTICHE.GET_RDL_MESE_COMPLETATA").Copy(); _DSet = _OraDl.GetRows(CollezioneControlli, _NameProcedure_Db).Copy(); return(_DSet); }
public DataSet GetComuni(int anno, string MeseDa, string MeseA) { S_ControlsCollection CollezioneControlli = new S_ControlsCollection(); DataSet _Ds; S_Controls.Collections.S_Object s_Anno = new S_Object(); s_Anno.ParameterName = "p_Anno"; s_Anno.DbType = CustomDBType.Integer; s_Anno.Direction = ParameterDirection.Input; s_Anno.Index = 0; s_Anno.Value = anno; CollezioneControlli.Add(s_Anno); S_Controls.Collections.S_Object s_Mese1 = new S_Object(); s_Mese1.ParameterName = "Mese1"; s_Mese1.DbType = CustomDBType.VarChar; s_Mese1.Direction = ParameterDirection.Input; s_Mese1.Index = 1; s_Mese1.Size = 50; s_Mese1.Value = MeseDa; CollezioneControlli.Add(s_Mese1); S_Controls.Collections.S_Object s_Mese2 = new S_Object(); s_Mese2.ParameterName = "Mese2"; s_Mese2.DbType = CustomDBType.VarChar; s_Mese2.Direction = ParameterDirection.Input; s_Mese2.Index = 2; s_Mese2.Size = 50; s_Mese2.Value = MeseA; CollezioneControlli.Add(s_Mese2); 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 = 3; CollezioneControlli.Add(s_Cursor); string s_StrSql = "PACK_SCHEDULA.Rapportino_GetComuni"; _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy(); return(_Ds); }
/// <summary> /// Ricerca le richieste Accorpante /// </summary> /// <param name="CollezioneControlli"></param> /// <returns></returns> public DataSet Accorpante(S_ControlsCollection CollezioneControlli) { S_Controls.Collections.S_Object s_p_utente = new S_Object(); s_p_utente.ParameterName = "p_utente"; s_p_utente.DbType = CustomDBType.VarChar; s_p_utente.Direction = ParameterDirection.Input; s_p_utente.Index = CollezioneControlli.Count + 1; s_p_utente.Value = this.username; s_p_utente.Size = 50; CollezioneControlli.Add(s_p_utente); 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_MAN_ORD.SP_GetAccorpante"; DataSet _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy(); return(_Ds); }
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); }
public DataSet GetDatiEdificio(int wr_id) { DataSet _Ds; S_ControlsCollection CollezioneControlli = 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 = CollezioneControlli.Count + 1; s_IdIn.Value = wr_id; CollezioneControlli.Add(s_IdIn); 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_MANCORRETIVA.SP_GETDATIBL"; _Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy(); return(_Ds); }