//刷新仪器列表
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);
}
