コード例 #1
0
        // кнопка "Обновить общую статистику (быстро)"
        private void button7_Click(object sender, EventArgs e)
        {
            BookDBConnect currentBookDBConnect = new BookDBConnect();

            currentBookDBConnect.SetSQLConnectionToAzureDBLitClassicBooks();
            currentBookDBConnect.UpdateTotalStatisticsShort();
        }
コード例 #2
0
        private void backgroundWorker2_DeleteParticles(object sender, DoWorkEventArgs e)
        {
            if (listBox3.Items.Count != 0)
            {
                SetProgressMaximumValue(listBox3.Items.Count);

                System.Timers.Timer currentTimer = new System.Timers.Timer(1000);
                //currentTimer.Elapsed += async (sender, e) => await HandleTimer();
                currentTimer.Elapsed += OnTimedEvent;
                //progressBar2.Maximum = listBox3.Items.Count;

                currentTimer.Start();

                //foreach (int ID in listBox3.Items)
                for (int iListBox3 = 0; iListBox3 < listBox3.Items.Count; iListBox3++)
                {
                    var currentConnect = new BookDBConnect();

                    currentConnect.SetSQLConnectionToAzureDBLitClassicBooks();
                    currentConnect.DeleteParticles(Convert.ToInt32(listBox3.Items[iListBox3]));
                    currentProgress++;
                }

                currentTimer.Stop();

                //if (textBox1.Text.IndexOf(",") != -1)
                //{
                //    string[] idsString = textBox1.Text.Split(',');
                //    List<int> listIDs = new List<int>();

                //    progressBar2.Maximum = idsString.Length;

                //    foreach (string ID in idsString)
                //    {
                //        //listIDs.Add(Convert.ToInt32(ID));

                //        var currentConnect = new BookDBConnect();

                //        currentConnect.DeleteParticals(Convert.ToInt32(ID));

                //        progressBar2.Value++;
                //    }
                //}
                //else
                //{
                //    var currentConnect = new BookDBConnect();

                //    currentConnect.DeleteParticals(Convert.ToInt32(textBox1.Text));

                //    progressBar2.Value++;
                //}
            }

            backgroundWorker2.CancelAsync();
        }