//刷新仪器列表 private void initLvDevice() { string Return_Value; Return_Value = INIExists(inifile); if (!String.IsNullOrEmpty(Return_Value)) { MessageBox.Show(Return_Value); } StringBuilder objStrBd = new StringBuilder(256); GetPrivateProfileString("EQUIPMENT", "INSTRUMENTID", "", objStrBd, 256, FileName); instrument_id = objStrBd.ToString(); using (OracleConnection _connection = new OracleConnection(OracleHelper.GetConnectionstring())) { DataTable dt = new DataTable(); ListViewItem item = new ListViewItem(); try { _connection.Open(); OracleDataAdapter da = new OracleDataAdapter(); da.SelectCommand = new OracleCommand("select id,名称 from 检验仪器 where instr('" + instrument_id + "',id)>0", _connection); da.Fill(dt); bolLongin = true; } catch (Exception exs) { LoginForm log = new LoginForm(); if (log.ShowDialog() == DialogResult.OK) { bolLongin = true; } else { Application.Exit(); } } finally { _connection.Close(); } lv_Device.Items.Clear(); foreach (DataRow i in dt.Rows) { item = lv_Device.Items.Add(i["名称"].ToString(), 1); item.Tag = i["id"].ToString(); lv_Device.Columns[2].Text = "0"; } } }
public void Login_Load(object sender, EventArgs e) { System.Data.OracleClient.OracleConnection con = new System.Data.OracleClient.OracleConnection(); con.ConnectionString = OracleHelper.GetConnectionstring(); try { con.Open(); } catch (Exception ex) { con.Close(); return; } this.DialogResult = DialogResult.OK; }
//oracle连接 public void UpdateData() { System.Data.OracleClient.OracleTransaction sqltran; //将事务绑定到连接对像 //init.DBConnect(); try { //writeLog.Write("" + dtSave.Count, "log"); using (OracleConnection connection = new OracleConnection(OracleHelper.GetConnectionstring())) { sqltran = connection.BeginTransaction();// ConnectDB.con.BeginTransaction(); for (int i = 0; i < dtSave.Count; i++) { OracleDataAdapter adapter = new OracleDataAdapter(selectStr[i], connection); OracleCommandBuilder cmdBuilder = new OracleCommandBuilder(adapter); try { adapter.SelectCommand = new OracleCommand(selectStr[i], ConnectDB.con, sqltran); adapter.InsertCommand = cmdBuilder.GetInsertCommand(); adapter.UpdateCommand = cmdBuilder.GetUpdateCommand(); if (dtSave[i].Select(null, null, DataViewRowState.Deleted).Length > 0) { adapter.Update(dtSave[i].Select(null, null, DataViewRowState.Deleted)); } if (dtSave[i].Select(null, null, DataViewRowState.ModifiedCurrent).Length > 0) { adapter.Update(dtSave[i].Select(null, null, DataViewRowState.ModifiedCurrent)); } if (dtSave[i].Select(null, null, DataViewRowState.Added).Length > 0) { adapter.Update(dtSave[i].Select(null, null, DataViewRowState.Added)); } } catch (Exception ex) { writeLog.Write("UpdateData处理:" + ex.Message, "log"); } } try { sqltran.Commit(); } catch (Exception ex1) { sqltran.Rollback(); writeLog.Write("事务提交失败:" + ex1.Message, "log"); } finally { connection.Close(); connection.Dispose(); } } for (int i = 0; i < strGraph.Count; i++) { //writeLog.Write(strGraph[i].ToString(), "log"); System.IO.FileStream fs = new System.IO.FileStream(strGraph[i].ToString(), System.IO.FileMode.OpenOrCreate); byte[] blob = new byte[fs.Length]; fs.Read(blob, 0, blob.Length); fs.Close(); strUpdateSQL = "update test_graph_result set GRAPH_RESULT = :Photo where GRAPH_RESULT_ID = '" + strGraphID[i] + "'"; OracleCommand oraCmd = new OracleCommand(strUpdateSQL, ConnectDB.con); OracleParameter op = new OracleParameter("Photo", OracleType.Blob); op.Value = blob; oraCmd.Parameters.Add(op); try { oraCmd.ExecuteNonQuery(); } catch (Exception ex) { writeLog.Write("UpdateDataIO处理:" + ex.Message, "log"); } } } catch (System.Data.OracleClient.OracleException sqlex) { // sqltran.Rollback(); writeLog.Write("UpdateData_sqlex:" + sqlex.Message, "log"); //return sqlex.Message; } catch (Exception ex) { // sqltran.Rollback(); writeLog.Write("UpdateData_catch:" + ex.Message, "log"); //return ex.Message; } finally { sqltran = null; } }
public DataSet GetDataSet(string column, string tablename, string strwhere) { using (OracleConnection _connection = new OracleConnection(OracleHelper.GetConnectionstring())) { writelog = new Write_Log(); DataSet ds = new DataSet(); string sqlstr = "select " + column + " from " + tablename; if (!String.IsNullOrEmpty(strwhere)) { sqlstr = sqlstr + " where " + strwhere; } try { _connection.Open(); OracleDataAdapter da = new OracleDataAdapter(); da.SelectCommand = new OracleCommand(sqlstr, _connection); da.Fill(ds); } catch (Exception ex) { writelog.Write("填充数据时出错!" + ex.Message + System.Environment.NewLine + sqlstr, "log"); return(null); } finally { _connection.Close(); _connection.Dispose(); } writelog = null; return(ds); } //writelog = new Write_Log(); //if (ConnectDB.con.State != ConnectionState.Open) //{ // init = new ConnectDB(); // strError = init.DBConnect(); // if (!string.IsNullOrEmpty(strError)) // { // writelog.Write(strError, "log"); // return null; // } //} //string sqlstr = "select " + column + " from " + tablename; //if (!String.IsNullOrEmpty(strwhere)) //{ // sqlstr = sqlstr + " where " + strwhere; //} ////writelog.Write(sqlstr, "log"); //DataSet ds = new DataSet(); //writelog.Write("1连接状态:" + ConnectDB.con.State.ToString() + "\r\n 连接字符串:" + ConnectDB.con.ConnectionString, "log"); //OracleDataAdapter ada = new OracleDataAdapter(sqlstr, ConnectDB.con); //try //{ // writelog.Write("2连接状态:"+ConnectDB.con.State.ToString()+"\r\n 连接字符串:"+ ConnectDB.con.ConnectionString, "log"); // ada.Fill(ds, tablename); //} //catch (Exception ex) //{ // writelog.Write("填充数据时出错!" + ex.Message + System.Environment.NewLine + sqlstr, "log"); // return null; //} ////init.DisConnectDB(ConnectDB.con); //init = null; //writelog = null; //return ds; }
private void Form1_Load(object sender, EventArgs e) { string Return_Value; System.Windows.Forms.Form.CheckForIllegalCrossThreadCalls = false;//线程处理后的错误处理控件任然可以赋值 Return_Value = INIExists(inifile); if (!String.IsNullOrEmpty(Return_Value)) { MessageBox.Show(Return_Value); } StringBuilder objStrBd = new StringBuilder(256); GetPrivateProfileString("EQUIPMENT", "INSTRUMENTID", "", objStrBd, 256, FileName); instrument_id = objStrBd.ToString(); textBox2.Text = INIHelper.getInstance().IniReadValue("EQUIPMENT", "Encode"); string orgID = INIHelper.getInstance().IniReadValue("EQUIPMENT", "Agencies"); string sql = "select 资源id,简称 from 机构 where 资源id='in_机构id'"; sql = sql.Replace("in_机构id", orgID); DataTable orgName = OracleHelper.GetDataTable(sql); if (orgName.Rows.Count > 0) { textBox1.Text = orgName.Rows[0]["简称"].ToString(); } using (OracleConnection _connection = new OracleConnection(OracleHelper.GetConnectionstring())) { DataTable dt = new DataTable(); ListViewItem item = new ListViewItem(); try { _connection.Open(); OracleDataAdapter da = new OracleDataAdapter(); da.SelectCommand = new OracleCommand("select id,名称 from 检验仪器 where instr('" + instrument_id + "',id)>0", _connection); da.Fill(dt); bolLongin = true; } catch (Exception exs) { LoginForm log = new LoginForm(); if (log.ShowDialog() == DialogResult.OK) { bolLongin = true; } else { Application.Exit(); } } finally { _connection.Close(); } lv_Device.Items.Clear(); foreach (DataRow i in dt.Rows) { item = lv_Device.Items.Add(i["名称"].ToString(), 1); item.Tag = i["id"].ToString(); lv_Device.Columns[2].Text = "0"; } } if (lv_Device.Items.Count > 0) { but_begin.Enabled = false; but_end.Enabled = true; bolCon = true; backgroundWorker1.RunWorkerAsync(); } this.WindowState = FormWindowState.Minimized; this.Visible = false; this.notifyIcon1.Visible = true; this.SizeChanged += new System.EventHandler(this.Form1_SizeChanged); }