コード例 #1
0
        public bool hasBeenDeletedServer(Dictionary <string, object> datos, string condition)
        {
            string server   = datos["server"].ToString();
            string database = "multidb_datos";
            string uid      = datos["user"].ToString();
            string pass     = datos["pass"].ToString();
            string port     = datos["port"].ToString();

            ServerConnect db = new ServerConnect(server, database, uid, pass, port);

            try
            {
                List <Dictionary <string, object> > select = db.SelectListDictionary(datos["column_type"].ToString(), "data_id = " + datos["ID_data"] + " AND data " + condition + ";");
                bool exist = false;
                if (select.Count > 0)
                {
                    exist = true;
                }

                /*if (exist)
                 * {
                 *  db.NonQuery("DELETE FROM " + datos["column_type"].ToString() + " WHERE data_id = '" + datos["ID_data"].ToString() + "';");
                 * }*/

                return(exist);
            }

            catch
            {
                return(false);
            }
        }
コード例 #2
0
        public List <Dictionary <string, object> > executeQueryServer(Dictionary <string, object> datos, string condition)
        {
            string server   = datos["server"].ToString();
            string database = "multidb_datos";
            string uid      = datos["user"].ToString();
            string pass     = datos["pass"].ToString();
            string port     = datos["port"].ToString();

            ServerConnect db = new ServerConnect(server, database, uid, pass, port);

            return(db.SelectListDictionary(datos["column_type"].ToString(), "data_id = " + datos["ID_data"] + condition + ";"));
        }