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; })); }