예제 #1
0
        private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            t_lcball t_Lcball = new t_lcball();


            if (ISDataGridLoaded == true)
            {
                if (ItemIndx != int.Parse(dataGridView1.Rows[e.RowIndex].Cells["ItemIndex"].Value.ToString()) && (dataGridView1.Rows[e.RowIndex].Cells["ItemIndex"].Value.ToString() != "-1" || dataGridView1.Rows[e.RowIndex].Cells["ItemIndex"].Value.ToString() != "0"))
                {
                    ItemIndx = int.Parse(dataGridView1.Rows[e.RowIndex].Cells["ItemIndex"].Value.ToString());

                    if (ISFinished != true)
                    {
                        //if the column value isnt equal to the list set true then give a image otherwise its  false until true;
                        ISFinished = true;


                        dataGridView1.Rows[e.RowIndex].SetValues(new Bitmap(databaseHandle.IconFast(ItemIndx), 20, 20));
                    }
                    else if (ISDataGridLoaded == true && ISFinished == true)
                    {
                        dataGridView1.Rows[e.RowIndex].SetValues(new Bitmap(databaseHandle.IconFast(ItemIndx), 20, 20));
                    }
                }
            }
        }
예제 #2
0
        public void LoadDG(int LacaballItemidx) //dethunter12 add test lacaball code.
        {
            Stopwatch stopwatch = new Stopwatch();

            stopwatch.Start();

            dataGridView1.Rows.Clear(); string str1 = "select a_item_order, a_tocken_index, a_course_code, a_order, a_item_index, a_item_count, a_item_max, a_item_remain from t_lcball WHERE a_tocken_index = " + LacaballItemidx + " order by a_course_code ASC, a_order ASC ;";
            MySqlConnection mySqlConnection         = new MySqlConnection("datasource=" + Host + ";port=3306;username="******";password="******";database=" + DB_Database);
            MySqlCommand    command = mySqlConnection.CreateCommand();

            command.CommandText = str1;
            mySqlConnection.Open();
            MySqlDataReader mySqlDataReader = command.ExecuteReader();

            if (mySqlDataReader.HasRows == false) //dethunter12 adjust 6/1/2020
            {
                ISNullValue = true;
            }
            else
            {
                ISNullValue = false;
            }

            while (mySqlDataReader.Read())
            {
                t_lcball t_Lcball = new t_lcball();
                t_Lcball.a_item_order   = Convert.ToInt32(mySqlDataReader.GetValue(0).ToString());
                t_Lcball.a_tocken_index = Convert.ToInt32(mySqlDataReader.GetValue(1).ToString());
                t_Lcball.a_course_code  = Convert.ToInt32(mySqlDataReader.GetValue(2).ToString());
                t_Lcball.a_order        = Convert.ToInt32(mySqlDataReader.GetValue(3).ToString());
                t_Lcball.a_item_index   = Convert.ToInt32(mySqlDataReader.GetValue(4).ToString());
                t_Lcball.a_item_count   = Convert.ToInt32(mySqlDataReader.GetValue(5).ToString());
                t_Lcball.a_item_max     = Convert.ToInt32(mySqlDataReader.GetValue(6).ToString());
                t_Lcball.a_item_remain  = Convert.ToInt32(mySqlDataReader.GetValue(7).ToString());
                LcBallList.Add(t_Lcball);
                string item_id  = mySqlDataReader.GetValue(4).ToString();
                int    ItemIndx = t_Lcball.a_item_index;
                dataGridView1.Rows.Add(new Bitmap(databaseHandle.IconFast(Int32.Parse(item_id)), 20, 20), t_Lcball.a_item_order, t_Lcball.a_course_code, t_Lcball.a_order, t_Lcball.a_item_index, databaseHandle.ItemNameFast(Int32.Parse(item_id)), t_Lcball.a_item_count);
                tbItemMax.Text    = t_Lcball.a_item_max.ToString();
                tbItemRemain.Text = t_Lcball.a_item_remain.ToString();
            }
            mySqlConnection.Close();
            ISDataGridLoaded = true;
            stopwatch.Stop();
            TimeSpan elapsed = stopwatch.Elapsed;

            string.Format("{0:00}:{1:00}:{2:00}.{3:00}", elapsed.Hours, elapsed.Minutes, elapsed.Seconds, (elapsed.Milliseconds / 10));
            toolStripStatusLabel1.Text      = "Ready";
            toolStripStatusLabel1.ForeColor = Color.LimeGreen;
        }