// Обработка файлов private void bw_DoWork(object sender, DoWorkEventArgs e) { FB2Validator fv2Validator = new FB2Validator(); m_lvResult.BeginUpdate(); if (m_GroupAnalyzeMode == GroupAnalyzeModeEnum.AllGroup) { // все книги всех Групп this.Text += ": Все книги всех Групп"; ProgressBar.Maximum = m_lvResult.Items.Count; ProgressBar.Value = 0; int i = 0; foreach (ListViewItem lvi in m_lvResult.Items) { if ((m_bw.CancellationPending)) { e.Cancel = true; return; } validateFile(lvi, ref fv2Validator); m_bw.ReportProgress(++i); ProgressBar.Update(); } } else { // все книги выбранной Группы ListView.SelectedListViewItemCollection si = m_lvResult.SelectedItems; this.Text += ": Все книги Группы '" + si[0].Group.Header + "'"; if (si.Count > 0) { // группа для выделенной книги ListViewGroup lvg = si[0].Group; ProgressBar.Maximum = lvg.Items.Count; ProgressBar.Value = 0; int i = 0; foreach (ListViewItem lvi in lvg.Items) { if ((m_bw.CancellationPending)) { e.Cancel = true; return; } validateFile(lvi, ref fv2Validator); m_bw.ReportProgress(++i); ProgressBar.Update(); } } } m_lvResult.EndUpdate(); }
private void panel1_DragDrop(object sender, System.Windows.Forms.DragEventArgs e) { if (!e.Data.GetDataPresent(DataFormats.FileDrop)) { return; } string[] filenames = (string[])e.Data.GetData(DataFormats.FileDrop); int nFiles = filenames.Length; ColorFormat dstFmt = (ColorFormat)FormatTo.SelectedIndex; Invite.Visible = false; FrameProgress.Visible = true; Progress.Visible = true; Progress.Minimum = 0; Progress.Maximum = nFiles; Progress.Step = 1; Progress.Value = 0; foreach (string s in filenames) { if (Path.GetExtension(s) == ".rbs" || Path.GetExtension(s) == ".rspr") { FileStream ins = File.OpenRead(s); if (ins == null) { continue; } SPack.Clear(); SPack.Read(ins, Path.GetFileNameWithoutExtension(s)); ins.Close(); FrameProgress.Minimum = 0; FrameProgress.Maximum = SPack.Sprites.Count; FrameProgress.Step = 1; FrameProgress.Value = 0; foreach (Sprite sp in SPack.Sprites) { FrameProgress.Value++; FrameProgress.Update(); sp.Convert(dstFmt); } File.Move(s, s + ".bak"); FileStream outs = File.OpenWrite(s); if (outs == null) { continue; } SPack.Write(outs); outs.Close(); } Progress.Value++; Progress.Update(); } Invite.Visible = true; Progress.Visible = false; FrameProgress.Visible = false; }
public void UpdateProgress(int thePercentComplete) { if (thePercentComplete < 0) { thePercentComplete = 0; } if (thePercentComplete > 100) { thePercentComplete = 100; } progressBar1.Value = thePercentComplete; progressBar1.Update(); }
private void UpdateProgressBar(ProgressBar bar, int maxValue, int current) { if (bar.InvokeRequired) { bar.BeginInvoke(new Action<ProgressBar, int, int>(UpdateProgressBar), bar, maxValue, current); } else { bar.Maximum = maxValue; bar.Value = current; bar.Update(); bar.Parent.Update(); } }
public void checkOpFinished(Object obj, System.EventArgs arg) { timer1.Stop(); progressBar1.PerformStep(); Invalidate(); progressBar1.Update(); if (Finished) { timer1.Dispose(); return; } timer1.Enabled = true; }
/// <summary> /// Used to circumvent the animations used on progress bars in Windows 7 and up. /// Includes a Update() call to take care of redraw. /// </summary> /// <param name="pb">The progress bar to be updated</param> /// <param name="value">Value from 0 to 100 for the progress bar</param> public static void SetProgressNoAnimation(ProgressBar pb, int value) { // To get around the progressive animation, we need to move the // progress bar backwards. if (value == pb.Maximum) { // Special case as value can't be set greater than Maximum. pb.Maximum = value + 1; // Temporarily Increase Maximum pb.Value = value + 1; // Move past pb.Maximum = value; // Reset maximum } else { pb.Value = value + 1; // Move past } pb.Value = value; // Move to correct value pb.Update(); }
public void checkOpFinished(Object obj, System.EventArgs arg) { timer1.Stop(); progressBar1.PerformStep(); Invalidate(); progressBar1.Update(); if (CheckTool.isFinished) { timer1.Dispose(); progressBar1.Value = 0; progressBar1.Visible = false; //this.Close(); return; } timer1.Enabled = true; }
private void ExecuteScript(string[] script) { progressBar1.Minimum = 0; progressBar1.Maximum = script.Length; #if (DEBUG) using (IDbCommand _command = BDPPCDatabase.DebugDBConnection().Connection.CreateCommand()) #else using (IDbCommand _command = BDPPCDatabase.DBConnection.Connection.CreateCommand()) #endif { foreach (string sql in script) { _command.CommandText = sql; _command.ExecuteNonQuery(); progressBar1.Value++; if (progressBar1.Value % 100 == 0) { progressBar1.Update(); } } } MessageBox.Show("Ok"); }
private void ProgressTimer_Tick(object sender, EventArgs e) { this.APCServiceController.Refresh(); if (this.APCServiceController.Status != FinalState && (DateTime.Now > DueTime)) { DialogResult = DialogResult.Cancel; return; } if (this.APCServiceController.Status == FinalState) { switch (this.APCServiceAction) { case ServiceAction.Restart: if (FinalState == ServiceControllerStatus.Stopped) { this.StartService(); } else { DialogResult = DialogResult.OK; } return; case ServiceAction.Start: DialogResult = DialogResult.OK; return; case ServiceAction.Stop: DialogResult = DialogResult.OK; return; } } ServiceActionProgressBar.Value = this.DueTime.Subtract(DateTime.Now).Seconds; ServiceActionProgressBar.Update(); this.APCServiceController.Refresh(); }
} // GenerateFontBitmap void GetFontFromBitmap() { int border = (int)BorderSize.Value; ImportProgress.Visible = true; ImportProgress.Minimum = MinChar; ImportProgress.Maximum = MaxChar; ImportProgress.Value = MinChar; ImportProgress.Step = 1; for (int i = MinChar; i <= MaxChar; i++) { FontChar c = (FontChar)Chars[i - MinChar]; Rectangle rct = new Rectangle(c.X, c.Y, c.Width, c.Height); if (rct.Width == 0) { continue; } c.Bmp = Bmp.Clone(rct, PixelFormat.Format32bppArgb); ImportProgress.PerformStep(); ImportProgress.Update(); } ImportProgress.Visible = false; Update(); } // GetFontFromBitmap
private void InvokeProgressBarUpdate2(ProgressBar Object) { Object.Update(); }
private void Loadbaza() { this.label1.Text = "PRZYGOTOWANIE DO KONWERSJI"; label1.Refresh(); string connectionString; connectionString = "DataSource=Baza.sdf; Password=matrix1"; SqlCeConnection cn = new SqlCeConnection(connectionString); string delimeter = ";"; string filename = dfile; StreamReader sr = new StreamReader(filename); string allData = sr.ReadToEnd(); string[] rows = allData.Split("\r\n".ToCharArray()); allData = "empty"; sr.DiscardBufferedData(); sr.Close(); cn.Open(); //if (firstimport == 1) //{ SqlCeCommand delete = cn.CreateCommand(); delete.CommandText = "DROP TABLE dane"; delete.Prepare(); delete.ExecuteNonQuery(); SqlCeCommand cmd4 = new SqlCeCommand("CREATE TABLE dane (typ nvarchar (7), kod nvarchar (15) not null, nazwa nvarchar(40), stan nvarchar(10), cenazk nvarchar(10), cenasp nvarchar(10), vat nvarchar(5), devstat nvarchar(10), bad_cena bit, bad_stan bit, cenapolka numeric(6,3), zliczono numeric(6,3), datazmian DateTime, cenahurt nvarchar(10), cenaoryg nvarchar(10))", cn); cmd4.ExecuteNonQuery(); cmd4 = new SqlCeCommand("CREATE INDEX kod ON dane (kod)", cn); cmd4.ExecuteNonQuery(); //} // SqlCeCommand cmdtest = cn.CreateCommand(); // cmdtest.CommandText = "SELECT count(*) FROM dane WHERE kod = ?"; // cmdtest.Parameters.Add("@k", SqlDbType.NVarChar, 15); // cmdtest.Prepare(); // SqlCeCommand cmd = cn.CreateCommand(); //cmd.CommandText = "UPDATE dane SET nazwa = ?, stan = ?, cenazk = ?, cenasp = ?, vat = ?, datazmian = ?, cenahurt = ?, cenaoryg = ? WHERE kod = ?"; // cmd.CommandText = "UPDATE dane SET nazwa = ?, stan = ?, cenazk = ?, cenasp = ?, vat = ? WHERE kod = ?"; // cmd.Parameters.Add("@n", SqlDbType.NVarChar, 40); // cmd.Parameters.Add("@s", SqlDbType.NVarChar, 20); // cmd.Parameters.Add("@cz", SqlDbType.NVarChar, 20); // cmd.Parameters.Add("@cs", SqlDbType.NVarChar, 20); // cmd.Parameters.Add("@v", SqlDbType.NVarChar, 20); //cmd.Parameters.Add("@d", SqlDbType.DateTime); //cmd.Parameters.Add("@ch", SqlDbType.NVarChar, 20); //cmd.Parameters.Add("@co", SqlDbType.NVarChar, 20); // cmd.Parameters.Add("@k1", SqlDbType.NVarChar, 20); // cmd.Prepare(); SqlCeCommand cmd1 = cn.CreateCommand(); SqlCeTransaction transaction; transaction = cn.BeginTransaction(); cmd1.Connection = cn; cmd1.Transaction = transaction; try { //cmd1.CommandText = "INSERT INTO dane (typ, kod, nazwa, stan, cenazk, cenasp, vat, bad_cena, bad_stan, cenapolka, zliczono, datazmian, cenahurt, cenaoryg) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; cmd1.CommandText = "INSERT INTO dane (typ, kod, nazwa, stan, cenazk, cenasp, vat, bad_cena, bad_stan, cenapolka, zliczono) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; cmd1.Parameters.Add("@t", SqlDbType.NVarChar, 7); cmd1.Parameters.Add("@k", SqlDbType.NVarChar, 15); cmd1.Parameters.Add("@n", SqlDbType.NVarChar, 40); cmd1.Parameters.Add("@s", SqlDbType.NVarChar, 10); cmd1.Parameters.Add("@cz", SqlDbType.NVarChar, 10); cmd1.Parameters.Add("@cs", SqlDbType.NVarChar, 10); cmd1.Parameters.Add("@v", SqlDbType.NVarChar, 5); cmd1.Parameters.Add("@bc", SqlDbType.Bit); cmd1.Parameters.Add("@bs", SqlDbType.Bit); cmd1.Parameters.Add("@cp", SqlDbType.Decimal, 10); cmd1.Parameters["@cp"].Precision = 10; cmd1.Parameters["@cp"].Scale = 3; cmd1.Parameters.Add("@zl", SqlDbType.Decimal, 10); cmd1.Parameters["@zl"].Precision = 10; cmd1.Parameters["@zl"].Scale = 3; //cmd1.Parameters.Add("@d", SqlDbType.DateTime); // cmd1.Parameters.Add("@ch", SqlDbType.NVarChar, 10); // cmd1.Parameters.Add("@co", SqlDbType.NVarChar, 10); cmd1.Prepare(); /*SqlCeCommand cmd3 = cn.CreateCommand(); * cmd3.CommandText = "DELETE FROM dane WHERE kod = ?"; * cmd3.Parameters.Add("@t", SqlDbType.NVarChar, 20); */ label1.Text = "KONWERTOWANIE DANYCH"; label1.Refresh(); progressBar1.Maximum = (rows.Length / 2); progressBar1.Minimum = 0; bool val; string input; input = bool.FalseString; val = bool.Parse(input); int i = 0; //if (firstimport == 1) //{ foreach (string r in rows) { string[] items = r.Split(delimeter.ToCharArray()); if (items[0] != "") { /* if (items[7] == "Update") * { * i += 1; * progressBar1.Value = i; * progressBar1.Update(); * cmd.Parameters["@t"].Value = items[0]; * cmd.Parameters["@k"].Value = items[1]; * cmd.Parameters["@n"].Value = items[2]; * cmd.Parameters["@s"].Value = items[3]; * cmd.Parameters["@cz"].Value = items[4]; * cmd.Parameters["@cs"].Value = items[5]; * cmd.Parameters["@v"].Value = items[6]; * cmd.Parameters["@k1"].Value = items[1]; * cmd.ExecuteNonQuery(); * } */ //else if (items[7] == "New") //{ i += 1; progressBar1.Value = i; progressBar1.Update(); cmd1.Parameters["@t"].Value = items[0]; cmd1.Parameters["@k"].Value = items[1]; cmd1.Parameters["@n"].Value = items[2]; cmd1.Parameters["@s"].Value = items[3]; cmd1.Parameters["@cz"].Value = items[4]; cmd1.Parameters["@cs"].Value = items[5]; cmd1.Parameters["@v"].Value = items[6]; cmd1.Parameters["@bc"].Value = val; cmd1.Parameters["@bs"].Value = val; cmd1.Parameters["@cp"].Value = "0"; cmd1.Parameters["@zl"].Value = "0"; //cmd1.Parameters["@d"].Value = Convert.ToDateTime(items[7]); //cmd1.Parameters["@ch"].Value = items[8]; //cmd1.Parameters["@co"].Value = items[9]; cmd1.ExecuteNonQuery(); } } transaction.Commit(); } catch (Exception ex) { // Attempt to roll back the transaction. try { transaction.Rollback(); } catch (Exception ex2) { // This catch block will handle any errors that may have occurred // on the server that would cause the rollback to fail, such as // a closed connection. } } //} // else //{ /* foreach (string r in rows) * { * * string[] items = r.Split(delimeter.ToCharArray()); * if (items[0] != "") * { * i += 1; * progressBar1.Value = i; * progressBar1.Update(); * * * int count = 0; * cmdtest.Parameters["@k"].Value = items[1]; * * SqlCeDataReader dr = cmdtest.ExecuteReader(); * * while (dr.Read()) * { * count = dr.GetInt32(0); * } * dr.Close(); * if (count > 0) * { * * cmd.Parameters["@n"].Value = items[2]; * cmd.Parameters["@s"].Value = items[3]; * cmd.Parameters["@cz"].Value = items[4]; * cmd.Parameters["@cs"].Value = items[5]; * cmd.Parameters["@v"].Value = items[6]; * cmd.Parameters["@d"].Value = Convert.ToDateTime(items[7]); * cmd.Parameters["@ch"].Value = items[8]; * cmd.Parameters["@co"].Value = items[9]; * cmd.Parameters["@k1"].Value = items[1]; * cmd.ExecuteNonQuery(); * } * else * { * * * * * //cmd3.Parameters["@k"].Value = items[1]; * //cmd3.ExecuteNonQuery(); * * * cmd1.Parameters["@t"].Value = items[0]; * cmd1.Parameters["@k"].Value = items[1]; * cmd1.Parameters["@n"].Value = items[2]; * cmd1.Parameters["@s"].Value = items[3]; * cmd1.Parameters["@cz"].Value = items[4]; * cmd1.Parameters["@cs"].Value = items[5]; * cmd1.Parameters["@v"].Value = items[6]; * cmd1.Parameters["@bc"].Value = val; * cmd1.Parameters["@bs"].Value = val; * cmd1.Parameters["@cp"].Value = "0"; * cmd1.Parameters["@zl"].Value = "0"; * cmd1.Parameters["@d"].Value = Convert.ToDateTime(items[7]); * cmd1.Parameters["@ch"].Value = items[8]; * cmd1.Parameters["@co"].Value = items[9]; * cmd1.ExecuteNonQuery(); * * * } * } * } * * * } //} * /* else if (items[7] == "Err") * { * i += 1; * progressBar1.Value = i; * progressBar1.Update(); * * cmd3.Parameters["@k"].Value = items[1]; * cmd3.ExecuteNonQuery(); * * progressBar1.Value = i; * progressBar1.Update(); * cmd1.Parameters["@t"].Value = items[0]; * cmd1.Parameters["@k"].Value = items[1]; * cmd1.Parameters["@n"].Value = items[2]; * cmd1.Parameters["@s"].Value = items[3]; * cmd1.Parameters["@cz"].Value = items[4]; * cmd1.Parameters["@cs"].Value = items[5]; * cmd1.Parameters["@v"].Value = items[6]; * cmd1.ExecuteNonQuery(); * } */ /*SqlCeCommand cmd6 = new SqlCeCommand("UPDATE opcje SET devstat = 'Ok')", cn); * cmd.Prepare(); * * cmd6.ExecuteNonQuery(); */ cn.Close(); //catch //{ // SqlCeCommand cmd6 = new SqlCeCommand("UPDATE opcje SET devstat = 'Err')", cn); // cmd6.Prepare(); // // cmd6.ExecuteNonQuery(); // cn.Close(); // //} }
private void Loadbaza() { this.label1.Text = "PRZYGOTOWANIE DO KONWERSJI"; label1.Refresh(); string connectionString; connectionString = "DataSource=Baza.sdf; Password=matrix1"; SqlCeConnection cn = new SqlCeConnection(connectionString); string delimeter = ";"; string filename = dfile; StreamReader sr = new StreamReader(filename); string allData = sr.ReadToEnd(); string[] rows = allData.Split("\r\n".ToCharArray()); allData = "empty"; sr.DiscardBufferedData(); sr.Close(); cn.Open(); if (datebuf == "1/1/1999 12:00:00 AM") { SqlCeCommand delete = cn.CreateCommand(); delete.CommandText = "DROP TABLE stany"; delete.Prepare(); delete.ExecuteNonQuery(); SqlCeCommand cmd4 = new SqlCeCommand("CREATE TABLE stany (id int identity not null primary key, kod nvarchar (15), stan nvarchar(20), MagId nvarchar(20), Nazwa nvarchar(20))", cn); cmd4.ExecuteNonQuery(); } SqlCeCommand cmdtest = cn.CreateCommand(); cmdtest.CommandText = "SELECT count(*) FROM stany WHERE kod = ? AND MagId = ?"; cmdtest.Parameters.Add("@k", SqlDbType.NVarChar, 15); cmdtest.Parameters.Add("@m", SqlDbType.NVarChar, 20); cmdtest.Prepare(); SqlCeCommand cmd = cn.CreateCommand(); cmd.CommandText = "UPDATE stany SET stan = ? WHERE kod = ? AND MagId = ?"; cmd.Parameters.Add("@s", SqlDbType.NVarChar, 20); cmd.Parameters.Add("@k", SqlDbType.NVarChar, 20); cmd.Parameters.Add("@m", SqlDbType.NVarChar, 20); cmd.Prepare(); SqlCeCommand cmd1 = cn.CreateCommand(); cmd1.CommandText = "INSERT INTO stany (kod, stan, MagId, Nazwa) VALUES (?, ?, ?, ?)"; cmd1.Parameters.Add("@t", SqlDbType.NVarChar, 15); cmd1.Parameters.Add("@k", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@n", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@s", SqlDbType.NVarChar, 40); cmd1.Prepare(); /*SqlCeCommand cmd3 = cn.CreateCommand(); * cmd3.CommandText = "DELETE FROM dane WHERE kod = ?"; * cmd3.Parameters.Add("@t", SqlDbType.NVarChar, 20); */ label1.Text = "KONWERTOWANIE DANYCH"; label1.Refresh(); progressBar1.Maximum = (rows.Length / 2); progressBar1.Minimum = 0; bool val; string input; //input = bool.FalseString; //val = bool.Parse(input); int i = 0; foreach (string r in rows) { string[] items = r.Split(delimeter.ToCharArray()); if (items[0] != "") { i += 1; progressBar1.Value = i; progressBar1.Update(); if (datebuf == "1/1/1999 12:00:00 AM") { cmd1.Parameters["@t"].Value = items[0]; cmd1.Parameters["@k"].Value = items[1]; cmd1.Parameters["@n"].Value = items[2]; cmd1.Parameters["@s"].Value = items[3]; cmd1.ExecuteNonQuery(); } else { /* if (items[7] == "Update") * { * i += 1; * progressBar1.Value = i; * progressBar1.Update(); * cmd.Parameters["@t"].Value = items[0]; * cmd.Parameters["@k"].Value = items[1]; * cmd.Parameters["@n"].Value = items[2]; * cmd.Parameters["@s"].Value = items[3]; * cmd.Parameters["@cz"].Value = items[4]; * cmd.Parameters["@cs"].Value = items[5]; * cmd.Parameters["@v"].Value = items[6]; * cmd.Parameters["@k1"].Value = items[1]; * cmd.ExecuteNonQuery(); * } */ //else if (items[7] == "New") //{ //cmd3.Parameters["@k"].Value = items[1]; //cmd3.ExecuteNonQuery(); cmdtest.Parameters["@k"].Value = items[0]; cmdtest.Parameters["@m"].Value = items[2]; int count = 0; SqlCeDataReader dr = cmdtest.ExecuteReader(); while (dr.Read()) { count = dr.GetInt32(0); } dr.Close(); if (count > 0) { cmd.Parameters["@s"].Value = items[1]; cmd.Parameters["@k"].Value = items[0]; cmd.Parameters["@m"].Value = items[2]; cmd.ExecuteNonQuery(); } else { cmd1.Parameters["@t"].Value = items[0]; cmd1.Parameters["@k"].Value = items[1]; cmd1.Parameters["@n"].Value = items[2]; cmd1.Parameters["@s"].Value = items[3]; cmd1.ExecuteNonQuery(); } } //} /* else if (items[7] == "Err") * { * i += 1; * progressBar1.Value = i; * progressBar1.Update(); * * cmd3.Parameters["@k"].Value = items[1]; * cmd3.ExecuteNonQuery(); * * progressBar1.Value = i; * progressBar1.Update(); * cmd1.Parameters["@t"].Value = items[0]; * cmd1.Parameters["@k"].Value = items[1]; * cmd1.Parameters["@n"].Value = items[2]; * cmd1.Parameters["@s"].Value = items[3]; * cmd1.Parameters["@cz"].Value = items[4]; * cmd1.Parameters["@cs"].Value = items[5]; * cmd1.Parameters["@v"].Value = items[6]; * cmd1.ExecuteNonQuery(); * } */ } } /*SqlCeCommand cmd6 = new SqlCeCommand("UPDATE opcje SET devstat = 'Ok')", cn); * cmd.Prepare(); * * cmd6.ExecuteNonQuery(); */ SqlCeDataAdapter da = new SqlCeDataAdapter("SELECT * FROM opcje", cn); DataTable table = new DataTable(); da.Fill(table); da.UpdateCommand = new SqlCeCommand("UPDATE opcje SET impdata = ? WHERE id = 1", cn); da.UpdateCommand.Parameters.Add("@dat", SqlDbType.NVarChar, 120); da.UpdateCommand.Parameters["@dat"].Value = DateTime.Now; da.UpdateCommand.ExecuteNonQuery(); da.Dispose(); cn.Close(); this.Close(); //catch //{ // SqlCeCommand cmd6 = new SqlCeCommand("UPDATE opcje SET devstat = 'Err')", cn); // cmd6.Prepare(); // // cmd6.ExecuteNonQuery(); // cn.Close(); // //} }
/* INICIO DA VERIFICAÇÃO E LIMPEZA */ public void progressBarVerificacao(int valor, ProgressBar a) { a.Value = 0; a.Update(); a.Visible = true; a.Maximum = valor; }
private void Loadbaza() { this.label1.Text = "PRZYGOTOWANIE DO KONWERSJI"; label1.Refresh(); string connectionString; connectionString = "DataSource=Baza.sdf; Password=matrix1"; SqlCeConnection cn = new SqlCeConnection(connectionString); string delimeter = ";"; string filename = dfile; StreamReader sr = new StreamReader(filename); string allData = sr.ReadToEnd(); string[] rows = allData.Split("\r\n".ToCharArray()); allData = "empty"; sr.DiscardBufferedData(); sr.Close(); cn.Open(); SqlCeCommand delete = cn.CreateCommand(); delete.CommandText = "DROP TABLE dane"; delete.Prepare(); delete.ExecuteNonQuery(); SqlCeCommand cmd = new SqlCeCommand("CREATE TABLE dane (typ nvarchar (7), kod nvarchar (15), nazwa nvarchar(100), stan nvarchar(10), cenazk nvarchar(20), cenasp nvarchar(20), vat nvarchar(5), devstat nvarchar(20), bad_cena bit, bad_stan bit, cenapolka numeric(10,3), zliczono numeric(10,3))", cn); cmd.ExecuteNonQuery(); /*SqlCeCommand cmd = new SqlCeCommand("UPDATE dane SET typ = ? kod = ?, nazwa = ?, stan = ?, cenazk = ?, cenasp = ?, vat = ? WHERE kod = ?)", cn); * cmd.Parameters.Add("@t", SqlDbType.NVarChar, 20); * cmd.Parameters.Add("@k", SqlDbType.NVarChar, 20); * cmd.Parameters.Add("@n", SqlDbType.NVarChar, 100); * cmd.Parameters.Add("@s", SqlDbType.NVarChar, 20); * cmd.Parameters.Add("@cz", SqlDbType.NVarChar, 20); * cmd.Parameters.Add("@cs", SqlDbType.NVarChar, 20); * cmd.Parameters.Add("@v", SqlDbType.NVarChar, 20); * cmd.Parameters.Add("@k1", SqlDbType.NVarChar, 20); */ SqlCeCommand cmd1 = cn.CreateCommand(); cmd1.CommandText = "INSERT INTO dane (typ, kod, nazwa, stan, cenazk, cenasp, vat, bad_cena, bad_stan, cenapolka, zliczono) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; cmd1.Parameters.Add("@t", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@k", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@n", SqlDbType.NVarChar, 120); cmd1.Parameters.Add("@s", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@cz", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@cs", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@v", SqlDbType.NVarChar, 20); cmd1.Parameters.Add("@bc", SqlDbType.Bit); cmd1.Parameters.Add("@bs", SqlDbType.Bit); cmd1.Parameters.Add("@cp", SqlDbType.Decimal, 10); cmd1.Parameters["@cp"].Precision = 10; cmd1.Parameters["@cp"].Scale = 3; cmd1.Parameters.Add("@zl", SqlDbType.Decimal, 10); cmd1.Parameters["@zl"].Precision = 10; cmd1.Parameters["@zl"].Scale = 3; /*SqlCeCommand cmd3 = cn.CreateCommand(); * cmd3.CommandText = "DELETE FROM dane WHERE kod = ?"; * cmd3.Parameters.Add("@t", SqlDbType.NVarChar, 20); */ label1.Text = "KONWERTOWANIE DANYCH"; label1.Refresh(); progressBar1.Maximum = (rows.Length / 3); progressBar1.Minimum = 0; bool val; string input; input = bool.FalseString; val = bool.Parse(input); int i = 0; foreach (string r in rows) { string[] items = r.Split(delimeter.ToCharArray()); if (items[0] != "") { /* if (items[7] == "Update") * { * i += 1; * progressBar1.Value = i; * progressBar1.Update(); * cmd.Parameters["@t"].Value = items[0]; * cmd.Parameters["@k"].Value = items[1]; * cmd.Parameters["@n"].Value = items[2]; * cmd.Parameters["@s"].Value = items[3]; * cmd.Parameters["@cz"].Value = items[4]; * cmd.Parameters["@cs"].Value = items[5]; * cmd.Parameters["@v"].Value = items[6]; * cmd.Parameters["@k1"].Value = items[1]; * cmd.ExecuteNonQuery(); * } */ //else if (items[7] == "New") //{ i += 1; progressBar1.Value = i; progressBar1.Update(); //cmd3.Parameters["@k"].Value = items[1]; //cmd3.ExecuteNonQuery(); cmd1.Parameters["@t"].Value = items[0]; cmd1.Parameters["@k"].Value = items[1]; cmd1.Parameters["@n"].Value = items[2]; cmd1.Parameters["@s"].Value = items[3]; cmd1.Parameters["@cz"].Value = items[4]; cmd1.Parameters["@cs"].Value = items[5]; cmd1.Parameters["@v"].Value = items[6]; cmd1.Parameters["@bc"].Value = val; cmd1.Parameters["@bs"].Value = val; cmd1.Parameters["@cp"].Value = "0"; cmd1.Parameters["@zl"].Value = "0"; cmd1.ExecuteNonQuery(); //} /* else if (items[7] == "Err") * { * i += 1; * progressBar1.Value = i; * progressBar1.Update(); * * cmd3.Parameters["@k"].Value = items[1]; * cmd3.ExecuteNonQuery(); * * progressBar1.Value = i; * progressBar1.Update(); * cmd1.Parameters["@t"].Value = items[0]; * cmd1.Parameters["@k"].Value = items[1]; * cmd1.Parameters["@n"].Value = items[2]; * cmd1.Parameters["@s"].Value = items[3]; * cmd1.Parameters["@cz"].Value = items[4]; * cmd1.Parameters["@cs"].Value = items[5]; * cmd1.Parameters["@v"].Value = items[6]; * cmd1.ExecuteNonQuery(); * } */ } } /*SqlCeCommand cmd6 = new SqlCeCommand("UPDATE opcje SET devstat = 'Ok')", cn); * cmd.Prepare(); * * cmd6.ExecuteNonQuery(); */ cn.Close(); //catch //{ // SqlCeCommand cmd6 = new SqlCeCommand("UPDATE opcje SET devstat = 'Err')", cn); // cmd6.Prepare(); // // cmd6.ExecuteNonQuery(); // cn.Close(); // //} this.Close(); }
private void UpdateProgress(int thePercentComplete) { progressBar1.Value = thePercentComplete; progressBar1.Update(); }