public List<Pratica> GetListaPratiche(string N_Pratica, int? IdStatoLavorazione, string N_Delibera, string RagSoc_Cognome, string Nome, string CF, string PIVA)
        {
            List<Pratica> ret;

            using (DBWorking db = new DBWorking(ProviderSql, "connFondoMafia"))
            {
                db.Open();

                DbCommand cmd = db.CreateCommand("USP_GET_Pratica", true);
                db.SetParameter(cmd, "N_Pratica", DbType.String, ParameterDirection.Input, N_Pratica);
                db.SetParameter(cmd, "IdStatoLavorazione", DbType.Int32, ParameterDirection.Input, IdStatoLavorazione);
                db.SetParameter(cmd, "N_Delibera", DbType.String, ParameterDirection.Input, N_Delibera);
                db.SetParameter(cmd, "RagSoc_Cognome", DbType.String, ParameterDirection.Input, RagSoc_Cognome);
                db.SetParameter(cmd, "Nome", DbType.String, ParameterDirection.Input, Nome);
                db.SetParameter(cmd, "CF", DbType.String, ParameterDirection.Input, CF);
                db.SetParameter(cmd, "PIVA", DbType.String, ParameterDirection.Input, PIVA);

                ret = base.LoadList(db, cmd);
            }

            return ret;
        }