public override void Run() { /// это пример использования /// Считали данные из таблицы /// Формируем для каждого изменения соответствующую отмену // заполняем if (Running) { string predsost = "select idGU, offGU, offText from UserBM"; QuerySelectOracle q = new QuerySelectOracle(); QueryExecOracle qe = new QueryExecOracle(); q.Select(predsost); List<DataRows> lst = q.GetRows(); foreach (DataRows rows in lst) { UserInfo userInfo = new UserInfo(); userInfo.idGU = int.Parse(rows.FieldByName("idGU")); userInfo.offGU = int.Parse(rows.FieldByName("offGu")); userInfo.offText = rows.FieldByName("offText"); FinallyStack.Add(RestoreUser, userInfo); } string running = "update UserBM set offGU=1, offText='Идет импорт'"; qe.Execute(running); // Удалять все сеансы кроме SYSTEM string showsessions = "SELECT s.sid,s.serial#,s.osuser,s.program FROM v$session s"; q.Select(showsessions); lst = q.GetRows(); foreach (DataRows rows in lst) { if(rows.FieldByName("osuser")!="SYSTEM") { string kill = "ALTER SYSTEM KILL SESSION '"+rows.FieldByName("sid")+","+rows.FieldByName("serial#")+"' IMMEDIATE"; qe.Execute(kill); } } //Реконнект DataBaseOracle.Disconnect(); DataBaseOracle.Get(); } }
private void button1_Click(object sender, EventArgs e) { QuerySelectOracle q=new QuerySelectOracle(); q.Select("select username, status, program, machine from gv$session where username is not null"); List<DataRows> rows = q.GetRows(); listView1.Items.Clear(); foreach (DataRows row in rows) { //listView1.Items.Add("Имя пользователя : " + row.FieldByName("username") + "; Статус : " + row.FieldByName("status") + "; Программа : " + row.FieldByName("program") + "; Компьютер : " + row.FieldByName("machine")); ListViewItem item = new ListViewItem(row.FieldByName("username")); item.SubItems.Add(row.FieldByName("status")); item.SubItems.Add(row.FieldByName("program")); item.SubItems.Add(row.FieldByName("machine")); listView1.Items.Add(item); } }
private void button1_Click(object sender, EventArgs e) { string SQL = "select tableName from Transfer2PDA"; QuerySelectPDA query=new QuerySelectPDA(); query.Select(SQL); List<DataRows> rows = query.GetRows(); PDATables.Items.Clear(); foreach (DataRows row in rows) { PDATables.Items.Add(row.FieldByName("tableName")); } SQL = "select distinct Table_Name from user_tables"; QuerySelectOracle Oraquery=new QuerySelectOracle(); Oraquery.Select(SQL); rows = Oraquery.GetRows(); OraTables.Items.Clear(); foreach (DataRows row in rows) { if (!PDATables.Items.Contains(row.FieldByName("Table_Name"))) OraTables.Items.Add(row.FieldByName("Table_Name")); } }
private void PDATables_SelectedIndexChanged(object sender, EventArgs e) { string SQL = "select * from Transfer2PDA where tableName='{0}'"; QuerySelectPDA query = new QuerySelectPDA(); query.Select(String.Format(SQL,PDATables.SelectedItem)); List<DataRows> rows = query.GetRows(); if (rows.Count > 0) { if (rows[0].FieldByName("isLight") == "1") checkBox1.Checked = true; else checkBox1.Checked = false; if (rows[0].FieldByName("needExport") == "1") checkBox2.Checked = true; else checkBox2.Checked = false; textBox1.Text = rows[0].FieldByName("idTransferTable"); SQL = "select fieldname from TransferFields where idTransferTable={0}"; query.Select(String.Format(SQL, textBox1.Text)); List<DataRows> rows1 = query.GetRows(); PDAFields.Items.Clear(); foreach (DataRows row in rows1) { PDAFields.Items.Add(row.FieldByName("fieldname")); } /// запросы /// SQL = "select text from QrySelect where idQrySelect={0}"; query.Select(String.Format(SQL, rows[0].FieldByName("idQrySelectBM"))); rows1 = query.GetRows(); SelectText.Text = rows1[0].FieldByName("text"); SQL = "select text from QrySelect where idQrySelect={0}"; query.Select(String.Format(SQL, rows[0].FieldByName("idQrySelectPDA"))); rows1 = query.GetRows(); SelectPDAText.Text = rows1[0].FieldByName("text"); SQL = "select text from QryDelete where idQryDelete={0}"; query.Select(String.Format(SQL, rows[0].FieldByName("idQryDelete"))); rows1 = query.GetRows(); DeleteText.Text = rows1[0].FieldByName("text"); SQL = "select text from QryClear where idQryClear={0}"; query.Select(String.Format(SQL, rows[0].FieldByName("idQryClear"))); rows1 = query.GetRows(); ClearText.Text = rows1[0].FieldByName("text"); SQL = "select text from QryInsert where idQryInsert={0}"; query.Select(String.Format(SQL, rows[0].FieldByName("idQryInsert"))); rows1 = query.GetRows(); InsertText.Text = rows1[0].FieldByName("text"); } else { checkBox2.Checked = false; checkBox1.Checked = false; PDAFields.Items.Clear(); textBox1.Text = ""; } SQL = "select Column_Name from user_tab_columns where Table_Name='{0}'"; QuerySelectOracle OraQuery=new QuerySelectOracle(); OraQuery.Select(String.Format(SQL, PDATables.SelectedItem)); rows = OraQuery.GetRows(); OraFields.Items.Clear(); foreach (DataRows row in rows) { if (!PDAFields.Items.Contains(row.FieldByName("Column_Name"))) OraFields.Items.Add(row.FieldByName("Column_Name")); } }
private void OraTables_SelectedIndexChanged(object sender, EventArgs e) { string SQL = "select Column_Name from user_tab_columns where Table_Name='{0}'"; QuerySelectOracle OraQuery = new QuerySelectOracle(); OraQuery.Select(String.Format(SQL, OraTables.SelectedItem)); List<DataRows> rows = OraQuery.GetRows(); FieldList.Items.Clear(); foreach (DataRows row in rows) { FieldList.Items.Add(row.FieldByName("Column_Name")); } }