// Обработка файлов
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();
}
