Exemplo n.º 1
0
        public override object create(String sqlStr)
        {
            con_inf ci    = con_inf.getci();
            int     count = 0;

            ci.conn_master.Open();
            MySqlCommand cmd = new MySqlCommand(sqlStr, ci.conn_master);

            count = cmd.ExecuteNonQuery();
            ci.conn_master.Close();
            return(count);
        }
Exemplo n.º 2
0
        public override object create(string str)
        {
            con_inf ci = con_inf.getci();

            if (IsImportant(str))
            {
                //计时
                Stopwatch st = new Stopwatch();
                st.Start();


                DataTable dt = new DataTable();

                ci.conn_master.Open();

                ci.myDataAdapter_master.SelectCommand = new MySqlCommand(str, ci.conn_master);

                ci.myDataAdapter_master.Fill(dt);

                ci.conn_master.Close();

                st.Stop();
                return(dt);
            }
            else
            {
                Stopwatch st = new Stopwatch();
                st.Start();


                DataTable dt = new DataTable();

                ci.conn_node_1.Open();

                ci.myDataAdapter_node_1.SelectCommand = new MySqlCommand(str, ci.conn_node_1);

                ci.myDataAdapter_node_1.Fill(dt);

                ci.conn_node_1.Close();

                st.Stop();
                return(dt);
            }
        }