Beispiel #1
0
        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);
        }
Beispiel #2
0
        /// <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);
        }
Beispiel #3
0
        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);
        }
Beispiel #4
0
        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);
        }
Beispiel #5
0
 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);
 }
Beispiel #6
0
        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]);
        }
Beispiel #7
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);
        }
Beispiel #8
0
 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);
 }
Beispiel #9
0
        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);
        }
Beispiel #10
0
        /// <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);
        }
Beispiel #11
0
        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);
        }
Beispiel #12
0
        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);
        }