public static bool SaveSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT [id], [autoUpdate], [showConsole], [period] FROM Settings"; oleDb.oleDbCommandUpdate.CommandText = "UPDATE Settings SET " + "[autoUpdate] = @autoUpdate, " + "[showConsole] = @showConsole, " + "[period] = @period " + "WHERE ([id] = @id)"; oleDb.oleDbCommandUpdate.Parameters.Add("@autoUpdate", OleDbType.VarChar, 255, "autoUpdate"); oleDb.oleDbCommandUpdate.Parameters.Add("@showConsole", OleDbType.VarChar, 255, "showConsole"); oleDb.oleDbCommandUpdate.Parameters.Add("@period", OleDbType.VarChar, 255, "period"); oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id"); oleDb.ExecuteFill("Settings"); oleDb.dataSet.Tables["Settings"].Rows[0]["autoUpdate"] = DataConfig.autoUpdate.ToString(); oleDb.dataSet.Tables["Settings"].Rows[0]["showConsole"] = DataConfig.showConsole.ToString(); oleDb.dataSet.Tables["Settings"].Rows[0]["period"] = DataConfig.period; if (oleDb.ExecuteUpdate("Settings")) { oleDb.Dispose(); Utilits.Console.Log("Сохранение настроек программы прошло успешно."); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(true); } else { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] Настройки программы не сохранены.", false, true); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(false); } }catch (Exception ex) { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] " + ex.Message.ToString(), false, true); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(false); } }
public void TableRefresh() { try{ TableRefreshLocal(); }catch (Exception ex) { oleDb.Error(); Utilits.Console.LogError(ex.Message, false, true); } }
public static void ReadDatabaseSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM DatabaseSettings"; oleDb.ExecuteFill("DatabaseSettings"); DataConfig.localDatabase = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["localDatabase"].ToString(); DataConfig.typeDatabase = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeDatabase"].ToString(); DataConfig.typeConnection = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeConnection"].ToString(); DataConfig.serverConnection = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["serverConnection"].ToString(); oleDb.Dispose(); Utilits.Console.Log("Настройки соединения с базой данных успешно загружены."); }catch (Exception ex) { oleDb.Error(); MessageBox.Show("[ReadDatabaseSettings]: " + ex.ToString(), "Ошибка"); Application.Exit(); } DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; }
SqlServer sqlServer; // MSSQL void loadData() { //Подключение базы данных if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL && DataConfig.typeDatabase == DataConstants.TYPE_OLEDB) { // OLEDB try{ oleDb = new OleDb(DataConfig.localDatabase); oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Users"; oleDb.ExecuteFill("Users"); }catch (Exception ex) { oleDb.Error(); MessageBox.Show(ex.ToString()); Application.Exit(); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER && DataConfig.typeDatabase == DataConstants.TYPE_MSSQL) { // MSSQL SERVER try{ sqlServer = new SqlServer(); sqlServer.sqlCommandSelect.CommandText = "SELECT * FROM Users"; sqlServer.ExecuteFill("Users"); }catch (Exception ex) { sqlServer.Error(); MessageBox.Show(ex.ToString()); Application.Exit(); } } readData(); }
int selectTableLine = 0; // выбранная строка в таблице public void TableRefresh(String actionFolder = null) { try{ if (actionFolder == null) { TableRefreshLocal(openFolder); } else { TableRefreshLocal(actionFolder); } }catch (Exception ex) { oleDb.Error(); Utilits.Console.LogError(ex.Message, false, true); } }
void TableRefreshLocal() { oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Numeral"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Numeral ORDER BY ID ASC"; if (oleDb.ExecuteFill("Numeral")) { listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow rowElement in oleDb.dataSet.Tables[0].Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(rowElement["Numeral_English"].ToString()); ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(rowElement["Numeral_Translation"].ToString()); ListViewItem_add.SubItems.Add(rowElement["ID"].ToString()); listView1.Items.Add(ListViewItem_add); } } else { Utilits.Console.LogError("[ОШИБКА] Ошибка выполнения запроса.", false, true); oleDb.Error(); return; } // ВЫБОР: выдиляем ранее выбранный элемент. listView1.SelectedIndices.IndexOf(selectTableLine); }
void searchLocal() { oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "IrregularVerbs"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM IrregularVerbs WHERE (Verb_Translation LIKE '%" + toolStripComboBox1.Text + "%' OR V1_Infivitive LIKE '%" + toolStripComboBox1.Text + "%' OR V2_PastSimple LIKE '%" + toolStripComboBox1.Text + "%' OR V3_PastParticiple LIKE '%" + toolStripComboBox1.Text + "%' OR V4_PresentParticiple LIKE '%" + toolStripComboBox1.Text + "%' ) ORDER BY V1_Infivitive ASC"; if (oleDb.ExecuteFill("IrregularVerbs")) { listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow rowElement in oleDb.dataSet.Tables[0].Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(rowElement["V1_Infivitive"].ToString()); ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(rowElement["V2_PastSimple"].ToString()); ListViewItem_add.SubItems.Add(rowElement["V3_PastParticiple"].ToString()); ListViewItem_add.SubItems.Add(rowElement["V4_PresentParticiple"].ToString()); ListViewItem_add.SubItems.Add(rowElement["Verb_Translation"].ToString()); ListViewItem_add.SubItems.Add(rowElement["ID"].ToString()); listView1.Items.Add(ListViewItem_add); } } else { Utilits.Console.Log("[ОШИБКА] Ошибка выполнения запроса."); oleDb.Error(); return; } }
void searchLocal() { oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Numeral"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Numeral WHERE (Numeral_Translation LIKE '%" + toolStripComboBox1.Text + "%' OR Numeral_English LIKE '%" + toolStripComboBox1.Text + "%' ) ORDER BY ID ASC"; if (oleDb.ExecuteFill("Numeral")) { listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow rowElement in oleDb.dataSet.Tables[0].Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(rowElement["Numeral_English"].ToString()); ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(rowElement["Numeral_Translation"].ToString()); ListViewItem_add.SubItems.Add(rowElement["ID"].ToString()); listView1.Items.Add(ListViewItem_add); } } else { Utilits.Console.Log("[ОШИБКА] Ошибка выполнения запроса."); oleDb.Error(); return; } }
void searchLocal() { oleDb = new OleDb(DataConfig.localDatabase); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Units"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Units WHERE (name LIKE '%" + toolStripComboBox1.Text + "%') ORDER BY name ASC"; if (oleDb.ExecuteFill("Units")) { listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow rowElement in oleDb.dataSet.Tables[0].Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(rowElement["name"].ToString()); ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(""); ListViewItem_add.SubItems.Add(rowElement["id"].ToString()); listView1.Items.Add(ListViewItem_add); } } else { Utilits.Console.Log("[ОШИБКА] Ошибка выполнения запроса к таблице Единицы измерения."); oleDb.Error(); return; } }
void TableRefreshLocal() { oleDb = new OleDb(DataConfig.localDatabase); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Units"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Units ORDER BY name ASC"; if (oleDb.ExecuteFill("Units")) { listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow rowElement in oleDb.dataSet.Tables[0].Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(rowElement["name"].ToString()); ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(""); ListViewItem_add.SubItems.Add(rowElement["id"].ToString()); listView1.Items.Add(ListViewItem_add); } } else { Utilits.Console.Log("[ОШИБКА] Ошибка выполнения запроса к таблице Единицы измерения."); oleDb.Error(); return; } // ВЫБОР: выдиляем ранее выбранный элемент. listView1.SelectedIndices.IndexOf(selectTableLine); }
public static bool SaveDatabaseSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT [id], [name], [localDatabase], [typeDatabase], [typeConnection], [serverConnection] FROM DatabaseSettings"; oleDb.oleDbCommandUpdate.CommandText = "UPDATE DatabaseSettings SET " + "[name] = @name, " + "[localDatabase] = @localDatabase, " + "[typeDatabase] = @typeDatabase, " + "[typeConnection] = @typeConnection, " + "[serverConnection] = @serverConnection " + "WHERE ([id] = @id)"; oleDb.oleDbCommandUpdate.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandUpdate.Parameters.Add("@localDatabase", OleDbType.VarChar, 255, "localDatabase"); oleDb.oleDbCommandUpdate.Parameters.Add("@typeDatabase", OleDbType.VarChar, 255, "typeDatabase"); oleDb.oleDbCommandUpdate.Parameters.Add("@typeConnection", OleDbType.VarChar, 255, "typeConnection"); oleDb.oleDbCommandUpdate.Parameters.Add("@serverConnection", OleDbType.VarChar, 255, "serverConnection"); oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id"); oleDb.ExecuteFill("DatabaseSettings"); oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["localDatabase"] = DataConfig.localDatabase; oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeDatabase"] = DataConfig.typeDatabase; oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeConnection"] = DataConfig.typeConnection; oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["serverConnection"] = DataConfig.serverConnection; oleDb.ExecuteUpdate("DatabaseSettings"); oleDb.Dispose(); Utilits.Console.Log("Сохранение настроек соединения с базой данных прошло успешно."); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(true); }catch (Exception ex) { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] Сохранение настроек соединения с базой данных. " + ex.Message.ToString(), false, true); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(false); } }
void TableRefreshLocal() { oleDb = new OleDb(DataConfig.localDatabase); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Orders"; // Дата в формате: BETWEEN #месяц/день/год# AND #месяц/день/год# oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Orders WHERE (docDate BETWEEN #" + dateTimePicker1.Value.ToString("MM.dd.yyyy").Replace(".", "/") + "# AND #" + dateTimePicker2.Value.ToString("MM.dd.yyyy").Replace(".", "/") + "#) " + "AND (docNumber LIKE '%" + toolStripComboBox1.Text + "%' OR docSum LIKE '%" + toolStripComboBox1.Text + "%' OR docVat LIKE '%" + toolStripComboBox1.Text + "%' OR docTotal LIKE '%" + toolStripComboBox1.Text + "%' OR docAutor LIKE '%" + toolStripComboBox1.Text + "%' OR docCounteragent LIKE '%" + toolStripComboBox1.Text + "%') ORDER BY docDate DESC"; if (oleDb.ExecuteFill("Orders")) { listView1.Items.Clear(); DateTime dt; ListViewItem ListViewItem_add; foreach (DataRow rowElement in oleDb.dataSet.Tables[0].Rows) { ListViewItem_add = new ListViewItem(); dt = new DateTime(); DateTime.TryParse(rowElement["docDate"].ToString(), out dt); ListViewItem_add.SubItems.Add(dt.ToString("dd.MM.yyyy")); ListViewItem_add.StateImageIndex = 0; ListViewItem_add.SubItems.Add(rowElement["docNumber"].ToString()); ListViewItem_add.SubItems.Add(rowElement["docName"].ToString()); ListViewItem_add.SubItems.Add(Conversion.StringToMoney(Conversion.StringToDouble(rowElement["docSum"].ToString()).ToString())); ListViewItem_add.SubItems.Add(Conversion.StringToMoney(Conversion.StringToDouble(rowElement["docVat"].ToString()).ToString())); ListViewItem_add.SubItems.Add(Conversion.StringToMoney(Conversion.StringToDouble(rowElement["docTotal"].ToString()).ToString())); ListViewItem_add.SubItems.Add(rowElement["docCounteragent"].ToString()); ListViewItem_add.SubItems.Add(rowElement["docAutor"].ToString()); ListViewItem_add.SubItems.Add(rowElement["docPurchasePlan"].ToString()); ListViewItem_add.SubItems.Add(rowElement["id"].ToString()); listView1.Items.Add(ListViewItem_add); } } else { Utilits.Console.Log("[ОШИБКА] Ошибка выполнения запроса к таблице Заказы."); oleDb.Error(); return; } // ВЫБОР: выдиляем ранее выбранный элемент. listView1.SelectedIndices.IndexOf(selectTableLine); }
/* Обновить таблицы новыми данными */ private void refresh(String tableName, String tableRepresent) { try{ if (tableName == "Users" && DataForms.FUsers != null) { DataForms.FUsers.TableRefresh(); } Utilits.Console.Log("ИСТОРИЯ: Таблица " + tableRepresent + " была успешно обновлена."); }catch (Exception ex) { oleDb.Error(); Utilits.Console.Log("ОШИБКА: Обновление таблицы " + tableRepresent + "! " + ex.ToString(), false, true); } }
int selectTableLine = 0; // выбранная строка в таблице public void TableRefresh() { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { // OLEDB try{ TableRefreshLocal(); }catch (Exception ex) { oleDb.Error(); Utilits.Console.Log("[ОШИБКА]: " + ex.Message.ToString(), false, true); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { // MSSQL SERVER try{ TableRefreshServer(); }catch (Exception ex) { sqlServer.Error(); Utilits.Console.Log("[ОШИБКА]: " + ex.Message.ToString(), false, true); } } }
void initEditFile() { oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Practice"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Practice WHERE (ID = " + ID + ")"; oleDb.ExecuteFill("Practice"); textBox1.Text = oleDb.dataSet.Tables["Practice"].Rows[0]["ID"].ToString(); textBox2.Text = oleDb.dataSet.Tables["Practice"].Rows[0]["name"].ToString(); comboBox1.Text = oleDb.dataSet.Tables["Practice"].Rows[0]["parent"].ToString(); oldName = textBox2.Text; /* Загрузить вложенные тесты */ DataTable table; oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Tests"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Tests WHERE (IDPractice = " + textBox1.Text + ") ORDER BY ID ASC"; if (oleDb.ExecuteFill("Tests")) { table = oleDb.dataSet.Tables["Tests"]; listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow row in table.Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(row["condition"].ToString()); ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(row["question"].ToString()); ListViewItem_add.SubItems.Add(row["answer"].ToString()); ListViewItem_add.SubItems.Add(row["hint"].ToString()); ListViewItem_add.SubItems.Add(row["ID"].ToString()); listView1.Items.Add(ListViewItem_add); } } else { Utilits.Console.LogError("Ошибка загрузки вложенных тестов.", false, true); oleDb.Error(); return; } }
void readPrice() { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { // OLEDB oleDb = new OleDb(DataConfig.localDatabase); oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM " + PriceName; if (oleDb.ExecuteFill(PriceName)) { oleDb.dataSet.DataSetName = PriceName; renameColumn(); dataGrid1.CaptionText = PriceName; dataGrid1.DataSource = oleDb.dataSet; dataGrid1.DataMember = oleDb.dataSet.Tables[0].TableName; dataGrid1.Enabled = true; Utilits.Console.Log("Прайс " + PriceName + " был успешно загружен."); } else { oleDb.Error(); Utilits.Console.Log("[ПРЕДУПРЕЖДЕНИЕ] Прайс " + PriceName + " не удалось открыть."); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { // MSSQL SERVER sqlServer = new SqlServer(); sqlServer.sqlCommandSelect.CommandText = "SELECT * FROM " + PriceName; if (sqlServer.ExecuteFill(PriceName)) { sqlServer.dataSet.DataSetName = PriceName; renameColumn(); dataGrid1.CaptionText = PriceName; dataGrid1.DataSource = sqlServer.dataSet; dataGrid1.DataMember = sqlServer.dataSet.Tables[0].TableName; dataGrid1.Enabled = true; Utilits.Console.Log("Прайс " + PriceName + " был успешно загружен."); } else { sqlServer.Error(); Utilits.Console.Log("[ПРЕДУПРЕЖДЕНИЕ] Прайс " + PriceName + " не удалось открыть."); } } }
/* ================================================================================================= * РАЗДЕЛ: СОБЫТИЙ * ================================================================================================= */ bool openPrice() { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { // OLEDB oleDb = new OleDb(DataConfig.localDatabase); oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM " + textBox1.Text; if (oleDb.ExecuteFill(textBox1.Text)) { oleDb.dataSet.DataSetName = textBox1.Text; dataSet = oleDb.dataSet.Copy(); Utilits.Console.Log("Прайс " + textBox1.Text + " был успешно загружен."); return(true); } else { oleDb.Error(); Utilits.Console.Log("[ПРЕДУПРЕЖДЕНИЕ] Прайс " + textBox1.Text + " не удалось открыть."); return(false); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { // MSSQL SERVER sqlServer = new SqlServer(); sqlServer.sqlCommandSelect.CommandText = "SELECT * FROM " + textBox1.Text; if (sqlServer.ExecuteFill(textBox1.Text)) { sqlServer.dataSet.DataSetName = textBox1.Text; dataSet = sqlServer.dataSet.Copy(); Utilits.Console.Log("Прайс " + textBox1.Text + " был успешно загружен."); return(true); } else { sqlServer.Error(); Utilits.Console.Log("[ПРЕДУПРЕЖДЕНИЕ] Прайс " + textBox1.Text + " не удалось открыть."); return(false); } } Utilits.Console.Log("[ПРЕДУПРЕЖДЕНИЕ] Прайс " + textBox1.Text + " не удалось открыть."); return(false); }
public static void ReadSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Settings"; oleDb.ExecuteFill("Settings"); if (oleDb.dataSet.Tables["Settings"].Rows[0]["autoUpdate"].ToString() == "True") { DataConfig.autoUpdate = true; } else { DataConfig.autoUpdate = false; } if (oleDb.dataSet.Tables["Settings"].Rows[0]["showConsole"].ToString() == "True") { DataConfig.showConsole = true; } else { DataConfig.showConsole = false; } DataConfig.period = oleDb.dataSet.Tables["Settings"].Rows[0]["period"].ToString(); oleDb.Dispose(); Utilits.Console.Log("[Настройки]: Настройки программы успешно загружены."); }catch (Exception ex) { oleDb.Error(); MessageBox.Show("[Настройки]: " + ex.ToString(), "Ошибка"); Application.Exit(); } DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; }
void searchLocal() { DataTable table; oleDb = new OleDb(DataConfig.localDatabase); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Nomenclature"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nomenclature WHERE (name LIKE '%" + toolStripComboBox1.Text + "%') ORDER BY name ASC"; if (oleDb.ExecuteFill("Nomenclature")) { table = oleDb.dataSet.Tables["Nomenclature"]; } else { Utilits.Console.Log("[ОШИБКА] Ошибка поиска."); oleDb.Error(); return; } listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow row in table.Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(row["name"].ToString()); if (row["type"].ToString() == "folder") { ListViewItem_add.StateImageIndex = 0; ListViewItem_add.SubItems.Add("Папка"); } else { ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(""); } ListViewItem_add.SubItems.Add(row["id"].ToString()); ListViewItem_add.SubItems.Add(row["units"].ToString()); listView1.Items.Add(ListViewItem_add); } }
void searchLocal() { DataTable table; oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Practice"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Practice WHERE (name LIKE '%" + toolStripComboBox1.Text + "%') ORDER BY name ASC"; if (oleDb.ExecuteFill("Practice")) { table = oleDb.dataSet.Tables["Practice"]; } else { Utilits.Console.LogError("Ошибка поиска.", false, true); oleDb.Error(); return; } listView1.Items.Clear(); ListViewItem ListViewItem_add; foreach (DataRow row in table.Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(row["name"].ToString()); if (row["type"].ToString() == Constants.TYPE_FOLDER) { ListViewItem_add.StateImageIndex = 0; ListViewItem_add.SubItems.Add("Папка"); } else { ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(""); } ListViewItem_add.SubItems.Add(row["ID"].ToString()); ListViewItem_add.SubItems.Add(row["name"].ToString()); listView1.Items.Add(ListViewItem_add); } }
void saveNew() { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { // OLEDB oleDb = new OleDb(DataConfig.localDatabase); oleDb.oleDbCommandSelect.CommandText = "SELECT id, name, type, " + "code, series, article, manufacturer, price, units, parent " + "FROM Nomenclature WHERE (id = 0)"; oleDb.ExecuteFill("Nomenclature"); DataRow newRow = oleDb.dataSet.Tables["Nomenclature"].NewRow(); newRow["name"] = nameTextBox.Text; newRow["type"] = DataConstants.FILE; newRow["code"] = codeTextBox.Text; newRow["series"] = seriesTextBox.Text; newRow["article"] = articleTextBox.Text; newRow["manufacturer"] = manufacturerTextBox.Text; newRow["price"] = priceTextBox.Text; newRow["units"] = unitsTextBox.Text; newRow["parent"] = foldersComboBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows.Add(newRow); oleDb.oleDbCommandInsert.CommandText = "INSERT INTO Nomenclature " + "(name, type, code, series, article, manufacturer, price, units, parent) " + "VALUES (@name, @type, @code, @series, @article, @manufacturer, @price, @units, @parent)"; oleDb.oleDbCommandInsert.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandInsert.Parameters.Add("@type", OleDbType.VarChar, 255, "type"); oleDb.oleDbCommandInsert.Parameters.Add("@code", OleDbType.VarChar, 255, "code"); oleDb.oleDbCommandInsert.Parameters.Add("@series", OleDbType.VarChar, 255, "series"); oleDb.oleDbCommandInsert.Parameters.Add("@article", OleDbType.VarChar, 255, "article"); oleDb.oleDbCommandInsert.Parameters.Add("@manufacturer", OleDbType.VarChar, 255, "manufacturer"); oleDb.oleDbCommandInsert.Parameters.Add("@price", OleDbType.Double, 15, "price"); oleDb.oleDbCommandInsert.Parameters.Add("@units", OleDbType.VarChar, 255, "units"); oleDb.oleDbCommandInsert.Parameters.Add("@parent", OleDbType.VarChar, 255, "parent"); if (oleDb.ExecuteUpdate("Nomenclature")) { DataForms.FClient.updateHistory("Nomenclature"); Utilits.Console.Log("Создана новая номенклатура."); Close(); } else { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] Ошибка создания новой номенклатуры."); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { // MSSQL SERVER sqlServer = new SqlServer(); sqlServer.sqlCommandSelect.CommandText = "SELECT id, name, type, " + "code, series, article, manufacturer, price, units, parent " + "FROM Nomenclature WHERE (id = 0)"; sqlServer.ExecuteFill("Nomenclature"); DataRow newRow = sqlServer.dataSet.Tables["Nomenclature"].NewRow(); newRow["name"] = nameTextBox.Text; newRow["type"] = DataConstants.FILE; newRow["code"] = codeTextBox.Text; newRow["series"] = seriesTextBox.Text; newRow["article"] = articleTextBox.Text; newRow["manufacturer"] = manufacturerTextBox.Text; newRow["price"] = priceTextBox.Text; newRow["units"] = unitsTextBox.Text; newRow["parent"] = foldersComboBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows.Add(newRow); sqlServer.sqlCommandInsert.CommandText = "INSERT INTO Nomenclature " + "(name, type, code, series, article, manufacturer, price, units, parent) " + "VALUES (@name, @type, @code, @series, @article, @manufacturer, @price, @units, @parent)"; sqlServer.sqlCommandInsert.Parameters.Add("@name", SqlDbType.VarChar, 255, "name"); sqlServer.sqlCommandInsert.Parameters.Add("@type", SqlDbType.VarChar, 255, "type"); sqlServer.sqlCommandInsert.Parameters.Add("@code", SqlDbType.VarChar, 255, "code"); sqlServer.sqlCommandInsert.Parameters.Add("@series", SqlDbType.VarChar, 255, "series"); sqlServer.sqlCommandInsert.Parameters.Add("@article", SqlDbType.VarChar, 255, "article"); sqlServer.sqlCommandInsert.Parameters.Add("@manufacturer", SqlDbType.VarChar, 255, "manufacturer"); sqlServer.sqlCommandInsert.Parameters.Add("@price", SqlDbType.Float, 15, "price"); sqlServer.sqlCommandInsert.Parameters.Add("@units", SqlDbType.VarChar, 255, "units"); sqlServer.sqlCommandInsert.Parameters.Add("@parent", SqlDbType.VarChar, 255, "parent"); if (sqlServer.ExecuteUpdate("Nomenclature")) { DataForms.FClient.updateHistory("Nomenclature"); Utilits.Console.Log("Создана новая номенклатура."); Close(); } else { sqlServer.Error(); Utilits.Console.Log("[ОШИБКА] Ошибка создания новой номенклатуры."); } } }
void saveEdit() { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { // OLEDB oleDb = new OleDb(DataConfig.localDatabase); oleDb.oleDbCommandSelect.CommandText = "SELECT id, name, type, " + "code, series, article, manufacturer, price, units, parent " + "FROM Nomenclature WHERE (id = " + ID + ")"; oleDb.ExecuteFill("Nomenclature"); oleDb.dataSet.Tables["Nomenclature"].Rows[0]["name"] = nameTextBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["type"] = DataConstants.FILE; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["code"] = codeTextBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["series"] = seriesTextBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["article"] = articleTextBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["manufacturer"] = manufacturerTextBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["price"] = priceTextBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["units"] = unitsTextBox.Text; oleDb.dataSet.Tables["Nomenclature"].Rows[0]["parent"] = foldersComboBox.Text; oleDb.oleDbCommandUpdate.CommandText = "UPDATE Nomenclature SET " + "[name] = @name, [type] = @type, " + "[code] = @code, [series] = @series, [article] = @article, [manufacturer] = @manufacturer," + "[price] = @price, [units] = @units, [parent] = @parent " + "WHERE ([id] = @id)"; oleDb.oleDbCommandUpdate.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandUpdate.Parameters.Add("@type", OleDbType.VarChar, 255, "type"); oleDb.oleDbCommandUpdate.Parameters.Add("@code", OleDbType.VarChar, 255, "code"); oleDb.oleDbCommandUpdate.Parameters.Add("@series", OleDbType.VarChar, 255, "series"); oleDb.oleDbCommandUpdate.Parameters.Add("@article", OleDbType.VarChar, 255, "article"); oleDb.oleDbCommandUpdate.Parameters.Add("@manufacturer", OleDbType.VarChar, 255, "manufacturer"); oleDb.oleDbCommandUpdate.Parameters.Add("@price", OleDbType.Double, 15, "price"); oleDb.oleDbCommandUpdate.Parameters.Add("@units", OleDbType.VarChar, 255, "units"); oleDb.oleDbCommandUpdate.Parameters.Add("@parent", OleDbType.VarChar, 255, "parent"); oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id"); if (oleDb.ExecuteUpdate("Nomenclature")) { DataForms.FClient.updateHistory("Nomenclature"); Utilits.Console.Log("Номенклатура успешно изменена."); Close(); } else { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] Ошибка изменения номенклатуры."); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { // MSSQL SERVER sqlServer = new SqlServer(); sqlServer.sqlCommandSelect.CommandText = "SELECT id, name, type, " + "code, series, article, manufacturer, price, units, parent " + "FROM Nomenclature WHERE (id = " + ID + ")"; sqlServer.ExecuteFill("Nomenclature"); sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["name"] = nameTextBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["type"] = DataConstants.FILE; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["code"] = codeTextBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["series"] = seriesTextBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["article"] = articleTextBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["manufacturer"] = manufacturerTextBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["price"] = priceTextBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["units"] = unitsTextBox.Text; sqlServer.dataSet.Tables["Nomenclature"].Rows[0]["parent"] = foldersComboBox.Text; sqlServer.sqlCommandUpdate.CommandText = "UPDATE Nomenclature SET " + "[name] = @name, [type] = @type, " + "[code] = @code, [series] = @series, [article] = @article, [manufacturer] = @manufacturer," + "[price] = @price, [units] = @units, [parent] = @parent " + "WHERE ([id] = @id)"; sqlServer.sqlCommandUpdate.Parameters.Add("@name", SqlDbType.VarChar, 255, "name"); sqlServer.sqlCommandUpdate.Parameters.Add("@type", SqlDbType.VarChar, 255, "type"); sqlServer.sqlCommandUpdate.Parameters.Add("@code", SqlDbType.VarChar, 255, "code"); sqlServer.sqlCommandUpdate.Parameters.Add("@series", SqlDbType.VarChar, 255, "series"); sqlServer.sqlCommandUpdate.Parameters.Add("@article", SqlDbType.VarChar, 255, "article"); sqlServer.sqlCommandUpdate.Parameters.Add("@manufacturer", SqlDbType.VarChar, 255, "manufacturer"); sqlServer.sqlCommandUpdate.Parameters.Add("@price", SqlDbType.Float, 15, "price"); sqlServer.sqlCommandUpdate.Parameters.Add("@units", SqlDbType.VarChar, 255, "units"); sqlServer.sqlCommandUpdate.Parameters.Add("@parent", SqlDbType.VarChar, 255, "parent"); sqlServer.sqlCommandUpdate.Parameters.Add("@id", SqlDbType.Int, 10, "id"); if (sqlServer.ExecuteUpdate("Nomenclature")) { DataForms.FClient.updateHistory("Nomenclature"); Utilits.Console.Log("Номенклатура успешно изменена."); Close(); } else { sqlServer.Error(); Utilits.Console.Log("[ОШИБКА] Ошибка изменения номенклатуры."); } } }
void saveNew() { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { // OLEDB oleDb = new OleDb(DataConfig.localDatabase); oleDb.oleDbCommandSelect.CommandText = "SELECT id, name, type, " + "code, series, article, manufacturer, price, units, parent " + "FROM Nomenclature WHERE (id = 0)"; oleDb.ExecuteFill("Nomenclature"); DataRow newRow; int colsCount = dataSet.Tables[0].Columns.Count; foreach (DataRow row in dataSet.Tables[0].Rows) { newRow = oleDb.dataSet.Tables["Nomenclature"].NewRow(); if (colsCount > 0) { newRow["name"] = row[0]; } if (colsCount > 1) { newRow["code"] = row[1]; } if (colsCount > 2) { newRow["series"] = row[2]; } if (colsCount > 3) { newRow["article"] = row[3]; } if (colsCount > 4) { newRow["manufacturer"] = row[4]; } if (colsCount > 5) { if (row[5].ToString() == "") { newRow["price"] = 0; } else { newRow["price"] = row[5]; } } if (colsCount > 6) { newRow["units"] = row[6]; } newRow["type"] = DataConstants.FILE; newRow["parent"] = ParentFolder; oleDb.dataSet.Tables["Nomenclature"].Rows.Add(newRow); } oleDb.oleDbCommandInsert.CommandText = "INSERT INTO Nomenclature " + "(name, type, code, series, article, manufacturer, price, units, parent) " + "VALUES (@name, @type, @code, @series, @article, @manufacturer, @price, @units, @parent)"; oleDb.oleDbCommandInsert.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandInsert.Parameters.Add("@type", OleDbType.VarChar, 255, "type"); oleDb.oleDbCommandInsert.Parameters.Add("@code", OleDbType.VarChar, 255, "code"); oleDb.oleDbCommandInsert.Parameters.Add("@series", OleDbType.VarChar, 255, "series"); oleDb.oleDbCommandInsert.Parameters.Add("@article", OleDbType.VarChar, 255, "article"); oleDb.oleDbCommandInsert.Parameters.Add("@manufacturer", OleDbType.VarChar, 255, "manufacturer"); oleDb.oleDbCommandInsert.Parameters.Add("@price", OleDbType.Double, 15, "price"); oleDb.oleDbCommandInsert.Parameters.Add("@units", OleDbType.VarChar, 255, "units"); oleDb.oleDbCommandInsert.Parameters.Add("@parent", OleDbType.VarChar, 255, "parent"); if (oleDb.ExecuteUpdate("Nomenclature")) { DataForms.FClient.updateHistory("Nomenclature"); Utilits.Console.Log("Номенклатура успешно загружена из Excel файла."); Close(); } else { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] Ошибка загрузки данных из Excel файла."); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { // MSSQL SERVER sqlServer = new SqlServer(); sqlServer.sqlCommandSelect.CommandText = "SELECT id, name, type, " + "code, series, article, manufacturer, price, units, parent " + "FROM Nomenclature WHERE (id = 0)"; sqlServer.ExecuteFill("Nomenclature"); DataRow newRow; int colsCount = dataSet.Tables[0].Columns.Count; foreach (DataRow row in dataSet.Tables[0].Rows) { newRow = sqlServer.dataSet.Tables["Nomenclature"].NewRow(); if (colsCount > 0) { newRow["name"] = row[0]; } if (colsCount > 1) { newRow["code"] = row[1]; } if (colsCount > 2) { newRow["series"] = row[2]; } if (colsCount > 3) { newRow["article"] = row[3]; } if (colsCount > 4) { newRow["manufacturer"] = row[4]; } if (colsCount > 5) { if (row[5].ToString() == "") { newRow["price"] = 0; } else { newRow["price"] = row[5]; } } if (colsCount > 6) { newRow["units"] = row[6]; } newRow["type"] = DataConstants.FILE; newRow["parent"] = ParentFolder; sqlServer.dataSet.Tables["Nomenclature"].Rows.Add(newRow); } sqlServer.sqlCommandInsert.CommandText = "INSERT INTO Nomenclature " + "(name, type, code, series, article, manufacturer, price, units, parent) " + "VALUES (@name, @type, @code, @series, @article, @manufacturer, @price, @units, @parent)"; sqlServer.sqlCommandInsert.Parameters.Add("@name", SqlDbType.VarChar, 255, "name"); sqlServer.sqlCommandInsert.Parameters.Add("@type", SqlDbType.VarChar, 255, "type"); sqlServer.sqlCommandInsert.Parameters.Add("@code", SqlDbType.VarChar, 255, "code"); sqlServer.sqlCommandInsert.Parameters.Add("@series", SqlDbType.VarChar, 255, "series"); sqlServer.sqlCommandInsert.Parameters.Add("@article", SqlDbType.VarChar, 255, "article"); sqlServer.sqlCommandInsert.Parameters.Add("@manufacturer", SqlDbType.VarChar, 255, "manufacturer"); sqlServer.sqlCommandInsert.Parameters.Add("@price", SqlDbType.Float, 15, "price"); sqlServer.sqlCommandInsert.Parameters.Add("@units", SqlDbType.VarChar, 255, "units"); sqlServer.sqlCommandInsert.Parameters.Add("@parent", SqlDbType.VarChar, 255, "parent"); if (sqlServer.ExecuteUpdate("Nomenclature")) { DataForms.FClient.updateHistory("Nomenclature"); Utilits.Console.Log("Номенклатура успешно загружена из Excel файла."); Close(); } else { sqlServer.Error(); Utilits.Console.Log("[ОШИБКА] Ошибка загрузки данных из Excel файла."); } } }
void TableRefreshLocal(String actionFolder) { listView1.Items.Clear(); // Папки oleDb = new OleDb(DataConfig.localDatabase); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Nomenclature"; if (actionFolder == "") { oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nomenclature WHERE (type = 'folder') ORDER BY name ASC"; } else { oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nomenclature WHERE (type = 'folder' AND name = '" + actionFolder + "') ORDER BY name ASC"; } if (oleDb.ExecuteFill("Nomenclature")) { foldersTable = oleDb.dataSet.Tables["Nomenclature"].Copy(); } else { Utilits.Console.Log("[ОШИБКА] Ошибка выполнения запроса к таблице Номенклатура при отборе папок."); oleDb.Error(); return; } // Файлы oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Nomenclature"; if (actionFolder == "" && folderExplore == true) { oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nomenclature WHERE (type = 'file' AND parent = '') ORDER BY name ASC"; } else { if (folderExplore == false) { oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nomenclature WHERE (type = 'file') ORDER BY name ASC"; } else { oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nomenclature WHERE (type = 'file' AND parent = '" + actionFolder + "') ORDER BY name ASC"; } } if (oleDb.ExecuteFill("Nomenclature")) { filesTable = oleDb.dataSet.Tables["Nomenclature"].Copy(); } else { Utilits.Console.Log("[ОШИБКА] Ошибка выполнения запроса к таблице Номенклатура при отборе файлов."); oleDb.Error(); return; } // ОТОБРАЖЕНИЕ: "Папок" ListViewItem ListViewItem_add; foreach (DataRow rowFolder in foldersTable.Rows) { ListViewItem_add = new ListViewItem(); if (actionFolder == "") { ListViewItem_add.SubItems.Add(rowFolder["name"].ToString()); } else { ListViewItem_add.SubItems.Add(".."); } ListViewItem_add.StateImageIndex = 0; ListViewItem_add.SubItems.Add("Папка"); ListViewItem_add.SubItems.Add(rowFolder["id"].ToString()); ListViewItem_add.SubItems.Add(rowFolder["units"].ToString()); ListViewItem_add.SubItems.Add(rowFolder["price"].ToString()); listView1.Items.Add(ListViewItem_add); } // ОТОБРАЖЕНИЕ "Файлов" foreach (DataRow rowElement in filesTable.Rows) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(rowElement["name"].ToString()); ListViewItem_add.StateImageIndex = 1; ListViewItem_add.SubItems.Add(""); ListViewItem_add.SubItems.Add(rowElement["id"].ToString()); ListViewItem_add.SubItems.Add(rowElement["units"].ToString()); ListViewItem_add.SubItems.Add(rowElement["price"].ToString()); listView1.Items.Add(ListViewItem_add); } // ВЫБОР: выдиляем ранее выбранный элемент. listView1.SelectedIndices.IndexOf(selectTableLine); }
void savePrice() { returnNameColumn(); if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { // OLEDB oleDb.oleDbCommandInsert.CommandText = "INSERT INTO " + PriceName + " (" + "name, code, series, article, remainder, manufacturer, price, " + "discount1, discount2, discount3, discount4, term" + ") VALUES (" + "@name, @code, @series, @article, @remainder, @manufacturer, @price, " + "@discount1, @discount2, @discount3, @discount4, @term" + ")"; oleDb.oleDbCommandInsert.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandInsert.Parameters.Add("@code", OleDbType.VarChar, 255, "code"); oleDb.oleDbCommandInsert.Parameters.Add("@series", OleDbType.VarChar, 255, "series"); oleDb.oleDbCommandInsert.Parameters.Add("@article", OleDbType.VarChar, 255, "article"); oleDb.oleDbCommandInsert.Parameters.Add("@remainder", OleDbType.Double, 15, "remainder"); oleDb.oleDbCommandInsert.Parameters.Add("@manufacturer", OleDbType.VarChar, 255, "manufacturer"); oleDb.oleDbCommandInsert.Parameters.Add("@price", OleDbType.Double, 15, "price"); oleDb.oleDbCommandInsert.Parameters.Add("@discount1", OleDbType.Double, 15, "discount1"); oleDb.oleDbCommandInsert.Parameters.Add("@discount2", OleDbType.Double, 15, "discount2"); oleDb.oleDbCommandInsert.Parameters.Add("@discount3", OleDbType.Double, 15, "discount3"); oleDb.oleDbCommandInsert.Parameters.Add("@discount4", OleDbType.Double, 15, "discount4"); oleDb.oleDbCommandInsert.Parameters.Add("@term", OleDbType.Date, 15, "term"); oleDb.oleDbCommandUpdate.CommandText = "UPDATE " + PriceName + " SET " + "[name] = @name, " + "[code] = @code, " + "[series] = @series, " + "[article] = @article, " + "[remainder] = @remainder, " + "[manufacturer] = @manufacturer, " + "[price] = @price, " + "[discount1] = @discount1, " + "[discount2] = @discount2, " + "[discount3] = @discount3, " + "[discount4] = @discount4, " + "[term] = @term " + "WHERE ([id] = @id)"; oleDb.oleDbCommandUpdate.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandUpdate.Parameters.Add("@code", OleDbType.VarChar, 255, "code"); oleDb.oleDbCommandUpdate.Parameters.Add("@series", OleDbType.VarChar, 255, "series"); oleDb.oleDbCommandUpdate.Parameters.Add("@article", OleDbType.VarChar, 255, "article"); oleDb.oleDbCommandUpdate.Parameters.Add("@remainder", OleDbType.Double, 15, "remainder"); oleDb.oleDbCommandUpdate.Parameters.Add("@manufacturer", OleDbType.VarChar, 255, "manufacturer"); oleDb.oleDbCommandUpdate.Parameters.Add("@price", OleDbType.Double, 15, "price"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount1", OleDbType.Double, 15, "discount1"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount2", OleDbType.Double, 15, "discount2"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount3", OleDbType.Double, 15, "discount3"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount4", OleDbType.Double, 15, "discount4"); oleDb.oleDbCommandUpdate.Parameters.Add("@term", OleDbType.Date, 15, "term"); oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id"); oleDb.oleDbCommandDelete.CommandText = "DELETE * FROM " + PriceName + " WHERE ([id] = ?)"; oleDb.oleDbCommandDelete.Parameters.Add("id", OleDbType.Integer, 10, "id").SourceVersion = DataRowVersion.Original; if (oleDb.ExecuteUpdate(PriceName)) { Utilits.Console.Log("Прайс " + PriceName + " был успешно сохранён."); Close(); } else { oleDb.Error(); Utilits.Console.Log("[ПРЕДУПРЕЖДЕНИЕ] Прайс " + PriceName + " не удалось сохранить."); } } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { // MSSQL SERVER sqlServer.sqlCommandInsert.CommandText = "INSERT INTO " + PriceName + " (" + "name, code, series, article, remainder, manufacturer, price, " + "discount1, discount2, discount3, discount4, term" + ") VALUES (" + "@name, @code, @series, @article, @remainder, @manufacturer, @price, " + "@discount1, @discount2, @discount3, @discount4, @term" + ")"; sqlServer.sqlCommandInsert.Parameters.Add("@name", SqlDbType.VarChar, 255, "name"); sqlServer.sqlCommandInsert.Parameters.Add("@code", SqlDbType.VarChar, 255, "code"); sqlServer.sqlCommandInsert.Parameters.Add("@series", SqlDbType.VarChar, 255, "series"); sqlServer.sqlCommandInsert.Parameters.Add("@article", SqlDbType.VarChar, 255, "article"); sqlServer.sqlCommandInsert.Parameters.Add("@remainder", SqlDbType.Float, 15, "remainder"); sqlServer.sqlCommandInsert.Parameters.Add("@manufacturer", SqlDbType.VarChar, 255, "manufacturer"); sqlServer.sqlCommandInsert.Parameters.Add("@price", SqlDbType.Float, 15, "price"); sqlServer.sqlCommandInsert.Parameters.Add("@discount1", SqlDbType.Float, 15, "discount1"); sqlServer.sqlCommandInsert.Parameters.Add("@discount2", SqlDbType.Float, 15, "discount2"); sqlServer.sqlCommandInsert.Parameters.Add("@discount3", SqlDbType.Float, 15, "discount3"); sqlServer.sqlCommandInsert.Parameters.Add("@discount4", SqlDbType.Float, 15, "discount4"); sqlServer.sqlCommandInsert.Parameters.Add("@term", SqlDbType.Date, 15, "term"); sqlServer.sqlCommandUpdate.CommandText = "UPDATE " + PriceName + " SET " + "[name] = @name, " + "[code] = @code, " + "[series] = @series, " + "[article] = @article, " + "[remainder] = @remainder, " + "[manufacturer] = @manufacturer, " + "[price] = @price, " + "[discount1] = @discount1, " + "[discount2] = @discount2, " + "[discount3] = @discount3, " + "[discount4] = @discount4, " + "[term] = @term " + "WHERE ([id] = @id)"; sqlServer.sqlCommandUpdate.Parameters.Add("@name", SqlDbType.VarChar, 255, "name"); sqlServer.sqlCommandUpdate.Parameters.Add("@code", SqlDbType.VarChar, 255, "code"); sqlServer.sqlCommandUpdate.Parameters.Add("@series", SqlDbType.VarChar, 255, "series"); sqlServer.sqlCommandUpdate.Parameters.Add("@article", SqlDbType.VarChar, 255, "article"); sqlServer.sqlCommandUpdate.Parameters.Add("@remainder", SqlDbType.Float, 15, "remainder"); sqlServer.sqlCommandUpdate.Parameters.Add("@manufacturer", SqlDbType.VarChar, 255, "manufacturer"); sqlServer.sqlCommandUpdate.Parameters.Add("@price", SqlDbType.Float, 15, "price"); sqlServer.sqlCommandUpdate.Parameters.Add("@discount1", SqlDbType.Float, 15, "discount1"); sqlServer.sqlCommandUpdate.Parameters.Add("@discount2", SqlDbType.Float, 15, "discount2"); sqlServer.sqlCommandUpdate.Parameters.Add("@discount3", SqlDbType.Float, 15, "discount3"); sqlServer.sqlCommandUpdate.Parameters.Add("@discount4", SqlDbType.Float, 15, "discount4"); sqlServer.sqlCommandUpdate.Parameters.Add("@term", SqlDbType.Date, 15, "term"); sqlServer.sqlCommandUpdate.Parameters.Add("@id", SqlDbType.Int, 10, "id"); sqlServer.sqlCommandDelete.CommandText = "DELETE FROM " + PriceName + " WHERE ([id] = @id)"; sqlServer.sqlCommandDelete.Parameters.Add("@id", SqlDbType.Int, 10, "id").SourceVersion = DataRowVersion.Original; if (sqlServer.ExecuteUpdate(PriceName)) { Utilits.Console.Log("Прайс " + PriceName + " был успешно сохранён."); Close(); } else { sqlServer.Error(); Utilits.Console.Log("[ПРЕДУПРЕЖДЕНИЕ] Прайс " + PriceName + " не удалось сохранить."); } } }