コード例 #1
0
        public void IsReady_change(OneKeyItem okItem)
        {
            string          connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=root;Persist Security Info=True;Charset=utf8;";
            MySqlConnection connatl = new MySqlConnection(connectionString_ATL);

            connatl.Open();
            string sql = string.Format(@" update device_group set isready = {0}"
                                       , okItem.OneKey_flag);
            MySqlDataAdapter b  = new MySqlDataAdapter(sql, connatl);
            DataTable        bt = new DataTable();

            b.Fill(bt);
            connatl.Close();
        }
コード例 #2
0
        /// <summary>
        /// 获取OneKey2
        /// </summary>
        /// <returns></returns>
        public List <OneKeyItem> GetPagedOneKeyData2()
        {
            DataTable tb = getPagedOneKeyData2();

            List <OneKeyItem> lst = new List <OneKeyItem>();

            if (tb != null && tb.Rows.Count > 0)
            {
                foreach (DataRow row in tb.Rows)
                {
                    OneKeyItem info = new OneKeyItem();
                    info.OneKey_flag = int.Parse(row[0].ToString());

                    lst.Add(info);
                }
            }
            return(lst);
        }