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 + " не удалось сохранить.");
}
}
}
