private void GetDataEUSqlLite(string EU)
{
//Загружаем по новому
try
{
using (SQLiteConnection connection = new SQLiteConnection())
{
;//(SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + SqLiteDB.pathDBFull_EU;
SQLiteCommand command = new SQLiteCommand(connection);
SQLiteCommand insert = new SQLiteCommand("select * from EU e WHERE e.RELMUCH_LABEL = '" + EU + "';", connection);
connection.Open();
SQLiteDataReader reader = insert.ExecuteReader();
while (reader.Read())
{
lblID.Text = "ID: " + _getReaderByName(reader, "RELMUCH_PRM");
labelMark.Text = "Марка: " + _getReaderByName(reader, "MARKA_NAME");
labelPart.Text = "Партия: " + _getReaderByName(reader, "RPRT_NOM");
labelplav.Text = "Плавка: " + _getReaderByName(reader, "RPRT_PLVNOM");
labelUnitWegth.Text = "Вес факт: " + _getReaderByName(reader, "RELMUCH_FVES");
labelUnitWegthASUP.Text = "Вес АСУП: " + _getReaderByName(reader, "RELMUCH_VES");
string Tehuzx_kod = _getReaderByName(reader, "TEHUZ_KOD");
if (_getReaderByName(reader, "SIGN") == "1")
{
//EU.SIGN='1' - Факт
//EU.SIGN='2' - План
labelFactMX.Text = "Факт МХ: " + SqlLiteQuery.GetNameMXByKod(Tehuzx_kod);
labelPlanMX.Text = "План МХ: -";
}
else
{
labelFactMX.Text = "Факт МХ: -";
labelPlanMX.Text = "План МХ: " + SqlLiteQuery.GetNameMXByKod(Tehuzx_kod);;
}
}
reader.Close();
connection.Close();
command.Dispose();
insert.Dispose();
reader.Dispose();
}
}
catch (Exception ex)
{
CLog.WriteException("EU_Action.cs", "GetDataEUSqlLite", ex.Message);
}
}
private void initRZDNForPGA()
{
using (SQLiteConnection connection = new SQLiteConnection())
{
string SQL = "SELECT EU.TEHUZ_KOD, EU.RPRT_NOM FROM EU, TaskList, RZDN_MARKA WHERE EU.MARKA_NAME = RZDN_MARKA.MARKA AND EU.RELMUCH_THICKNESS = TaskList.TASK_THICKNESS AND EU.RELMUCH_WIDTH= TaskList.TASK_WIDTH AND TaskList.RZDN_PRM = '" + RZDN + "' AND RZDN_MARKA.RZDN_PRM = TaskList.RZDN_PRM AND EU.SIGN <> '2'";
// SQL += "AND TaskList.RZDN_PRM = '" + RZDN + "'";
/*
* SELECT EU.TEHUZ_KOD, EU.RPRT_NOM FROM EU, TaskList, RZDN_MARKA WHERE
* EU.MARKA_NAME = RZDN_MARKA.MARKA
* AND EU.RELMUCH_THICKNESS = TaskList.TASK_THICKNESS
* AND EU.RELMUCH_WIDTH= TaskList.TASK_WIDTH
* AND TaskList.RZDN_PRM = "234557"
* AND RZDN_MARKA.RZDN_PRM = TaskList.RZDN_PRM
* AND EU.SIGN <> "2"
* */
;//(SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + SqLiteDB.pathDBFull_EU;
SQLiteCommand command = new SQLiteCommand(connection);
SQLiteCommand insert = new SQLiteCommand(SQL, connection);
connection.Open();
SQLiteDataReader reader = insert.ExecuteReader();
while (reader.Read())
{
DataRow row1 = _tblEU.NewRow();
//Запроск К БД
string TEHUZ = SqlLiteQuery.getReaderByName(reader, "TEHUZ_KOD");
row1["УЕ"] = SqlLiteQuery.getReaderByName(reader, "RPRT_NOM");
row1["MX"] = SqlLiteQuery.GetNameMXByKod(TEHUZ, false);
row1["Склад"] = SqlLiteQuery.GetNameAgrByMX(TEHUZ);
_tblEU.Rows.Add(row1);
}
reader.Close();
connection.Close();
command.Dispose();
insert.Dispose();
reader.Dispose();
}
dataGridEu.BeginInvoke(new Action(() =>
{
dataGridEu.DataSource = _tblEU;
}));
}
