private void SystematicsSelectButton_Click(object sender, EventArgs e)
{
OdbcDataReader rd;
string IDs = DataManip.DataManip.GenerateSearchIDs();
if (ObrebSelectCombo.Text != "")
{
rd = SqlConnect.ExecuteDataReader("SELECT Count(*) AS c_liczba FROM ObjectTbl, RemarkTbl WHERE ObjectTbl.c_ID = RemarkTbl.c_object_ID AND ObjectTbl.c_code_ID=" + cCodeID + " AND ObjectTbl.c_syst_ID IN (" + IDs + ") AND RemarkTbl.c_value LIKE '#%'");
}
else
{
MessageBox.Show("Wybierz obręb do dodania plików");
rd = null;
}
if (rd != null && rd.HasRows)
{
ObjectCountTBox.Text = rd["c_liczba"].ToString();
progressBar1.Maximum = int.Parse(rd["c_liczba"].ToString());
rd.Close();
GoButton.Enabled = progressBar1.Maximum != 0;
}
else
{
MessageBox.Show("rd.HasRows == 0 ");
}
}
public static DataTable FillDataTable(int ObrebID, int cCodeID)
{
string IDs = GenerateSearchIDs();
OdbcDataReader rd = SqlConnect.ExecuteDataReader("ObjectTbl.c_ID, RemarkTbl.c_value", "ObjectTbl, RemarkTbl", "ObjectTbl.c_ID = RemarkTbl.c_object_ID AND ObjectTbl.c_code_ID = " + cCodeID + " AND ObjectTbl.c_syst_ID IN (" + IDs + ") AND RemarkTbl.c_value LIKE '#%'");
DataTable dt = new DataTable();
dt.Load(rd);
return(dt);
}
private void button1_Click(object sender, EventArgs e)
{
if (SqlConnect.GetConnectionState() == ConnectionState.Closed)
{
try
{
if (SQLSrvNameTBox.Text != "" && SQLPasswdTBox.Text != "" && DBSelectCombo.Text != "")
{
Cursor = Cursors.WaitCursor;
SqlConnect.OpenConnection(SQLSrvNameTBox.Text, DBSelectCombo.Text, SQLPasswdTBox.Text);
Cursor = Cursors.Default;
if (SqlConnect.GetConnectionState() == ConnectionState.Open)
{
StateLabel.Text = "Połączono z bazą danych\n" + SQLSrvNameTBox.Text;
EnableWork();
}
if (!Directory.Exists(Environment.GetEnvironmentVariable("TEMP") + "\\SQLChanger"))
{
Directory.CreateDirectory(Environment.GetEnvironmentVariable("TEMP") + "\\SQLChanger");
}
StreamWriter writer = File.CreateText(Environment.GetEnvironmentVariable("TEMP") + "\\SQLChanger\\data");
writer.Write(SQLSrvNameTBox.Text);
writer.Close();
writer.Dispose();
PowiatSelectCombo.Items.Clear();
PowiatSelectCombo.Text = "";
JEwidencyjnaSelectCombo.Items.Clear();
JEwidencyjnaSelectCombo.Text = "";
ObrebSelectCombo.Items.Clear();
ObrebSelectCombo.Text = "";
DataManip.DataManip.FillPowiatSelectCombo(PowiatSelectCombo);
OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID", "ClassTbl", "c_name LIKE 'GOSZZG'");
rd.Read();
cCodeID = int.Parse(rd["c_ID"].ToString());
rd.Close();
DataManip.DataManip.initDictionaryIDs();
}
else
{
MessageBox.Show("Wpisz nazwę serwera, nazwę bazy i hasło do konta (sa)", "Połączenie SQL", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception exept)
{
MessageBox.Show(exept.Message, "Wystąpił błąd");
}
}
else
{
SqlConnect.CloseConnection();
DisableWork();
StateLabel.Text = "Rozłączono";
SQLPasswdTBox.Text = "";
}
Cursor = Cursors.Arrow;
}
public static void initDictionaryIDs()
{
OdbcDataReader data = SqlConnect.ExecuteDataReader("c_ordering_number, c_ID", "DictionaryEntryTbl", "c_dictionary_def_ID = 1 ORDER BY c_ordering_number");
while (data.Read())
{
SłownikIDTypow.Add(int.Parse(data["c_ordering_number"].ToString()), int.Parse(data["c_ID"].ToString()));
}
data.Close();
}
public static void WyszukajArkusze()
{
ListaIDArkuszy.Clear();
OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID", "SystematicsTbl", "c_parent_ID = " + Obreb.id);
while (rd.Read())
{
ListaIDArkuszy.Add(int.Parse(rd["c_ID"].ToString()));
}
rd.Close();
}
private void button1_Click(object sender, EventArgs e)
{
OdbcDataReader dr = SqlConnect.ExecuteDataReader("*", "ObjectTbl, G_SZKICE", "ObjectTbl.c_ID = G_SZKICE.c_object_ID AND ObjectTbl.c_ID = " + c_ID);
DataTable table = new DataTable();
table.Load(dr);
ObjectDetail objectDetail = new ObjectDetail(table.Rows[0], new System.Drawing.Point(this.Location.X - 352, this.Location.Y));
objectDetail.Show(this);
dr.Close();
}
private void ObrebSelectCombo_SelectedIndexChanged(object sender, EventArgs e)
{
GoButton.Enabled = false;
string temp = ObrebSelectCombo.Text.Remove(0, ObrebSelectCombo.Text.IndexOf(' '));
temp = temp.Remove(0, 3);
OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID,c_name,c_description,c_parent_ID", "SystematicsTbl", "c_description LIKE '" + temp + "'");
rd.Read();
Obreb.Fill(int.Parse(rd["c_ID"].ToString()), int.Parse(rd["c_parent_ID"].ToString()), rd["c_name"].ToString(), rd["c_description"].ToString());
rd.Close();
DataManip.DataManip.WyszukajArkusze();
}
public ObjectDetail(DataRow row, Point location)
{
InitializeComponent();
label5.Text = row["c_ID"].ToString();
label6.Text = row["c_Identifier"].ToString();
OdbcDataReader read = SqlConnect.ExecuteDataReader("*", "DictionaryEntryTbl", "c_ID = " + row["OPT"].ToString());
read.Read();
label7.Text = read["c_value"].ToString();
read.Close();
read = SqlConnect.ExecuteDataReader("*", "DictionaryEntryTbl", "c_ID = " + row["KRG"].ToString());
read.Read();
label8.Text = read["c_value"].ToString();
read.Close();
this.Location = location;
}
public static void FillObrebSelectCombo(string JEwidencyjnaText, ComboBox ObrebSelectCombo)
{
if (ObrebSelectCombo.Items.Count < 1)
{
OdbcDataReader rd = SqlConnect.ExecuteDataReader("SystematicsTbl.c_ID,c_parent_ID,c_name,c_description", "SystematicsTbl, (SELECT c_ID FROM SystematicsTbl WHERE c_name LIKE '" + JEwidencyjnaText + "') AS querry", "SystematicsTbl.c_parent_ID = querry.c_ID ORDER BY c_name;");
if (rd.HasRows)
{
string name;
while (rd.Read())
{
name = rd["c_name"].ToString() + " - " + rd["c_description"].ToString();
ObrebSelectCombo.Items.Add(name);
}
}
rd.Close();
}
}
public static void FillPowiatSelectCombo(ComboBox PowiatSelectCombo)
{
if (PowiatSelectCombo.Items.Count < 1)
{
OdbcDataReader rd1 = SqlConnect.ExecuteDataReader("c_ID", "SystematicsTbl", "c_name LIKE '30'");
rd1.Read();
string test = rd1["c_ID"].ToString();
rd1.Close();
OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID,c_name,c_description", "SystematicsTbl", "c_parent_ID = " + test);
if (rd.HasRows)
{
string name;
while (rd.Read())
{
name = rd["c_name"].ToString() + " - " + rd["c_description"].ToString();
PowiatSelectCombo.Items.Add(name);
}
}
rd.Close();
PowiatSelectCombo.SelectedIndex = 0;
}
}
