public void RefreshDataGridView() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.dataGridView1.Rows.Clear(); int inum = 0; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TEquipmentFaultRecord order by ID desc", connection).ExecuteReader(); this.dataGridView1.AllowUserToAddRows = true; while (dataReader.Read()) { this.dataGridView1.Rows.Add(1); int num = inum + 1; this.dataGridView1.Rows[inum].Cells[0].Value = System.Convert.ToString(num); this.dataGridView1.Rows[inum].Cells[1].Value = dataReader["EFaultTime"].ToString(); this.dataGridView1.Rows[inum].Cells[2].Value = dataReader["EFaultContent"].ToString(); inum = num; if (inum >= ctFormErrorQuery.MAX_SHOW_NUM) { break; } } this.dataGridView1.AllowUserToAddRows = false; dataReader.Close(); dataReader = null; connection.Close(); connection = null; if (this.dataGridView1.Rows.Count > 0) { this.dataGridView1.Rows[0].Selected = false; } } catch (System.Exception ex) { this.dataGridView1.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(ex.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception ex2) { KLineTestProcessor.ExceptionRecordFunc(ex2.StackTrace); } }
public void RefreshDataGridView() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.dataGridView1.Rows.Clear(); int inum = 0; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TConnectorLibrary order by ID", connection).ExecuteReader(); this.dataGridView1.AllowUserToAddRows = true; while (dataReader.Read()) { this.dataGridView1.Rows.Add(1); int num = inum + 1; this.dataGridView1.Rows[inum].Cells[0].Value = System.Convert.ToString(num); this.strIDArray[inum] = dataReader["ID"].ToString(); this.dataGridView1.Rows[inum].Cells[1].Value = dataReader["ConnectorName"].ToString(); this.dataGridView1.Rows[inum].Cells[2].Value = dataReader["ConverterType"].ToString(); this.dataGridView1.Rows[inum].Cells[3].Value = dataReader["PinNum"].ToString(); this.dataGridView1.Rows[inum].Cells[4].Value = dataReader["Remark"].ToString(); inum = num; if (inum >= 5000) { break; } } this.dataGridView1.AllowUserToAddRows = false; dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_1AD_0) { this.dataGridView1.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(arg_1AD_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_1D1_0) { KLineTestProcessor.ExceptionRecordFunc(arg_1D1_0.StackTrace); } }
public void xhglDealwithFunc() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.dataGridView2.Rows.Clear(); int inum2 = 0; string dbpath = Application.StartupPath + "\\ctsdb.mdb"; string ifNoStr = this.textBox_InterfaceNo.Text.ToString().Trim(); try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand((!string.IsNullOrEmpty(ifNoStr)) ? ("select * from TPlugLibrary where PlugNo like '%" + ifNoStr + "%' order by PlugNo") : "select * from TPlugLibrary order by PlugNo", connection).ExecuteReader(); this.dataGridView2.AllowUserToAddRows = true; while (dataReader.Read()) { this.dataGridView2.Rows.Add(1); int num = inum2 + 1; this.dataGridView2.Rows[inum2].Cells[0].Value = System.Convert.ToString(num); this.dataGridView2.Rows[inum2].Cells[1].Value = dataReader["PlugNo"].ToString(); this.dataGridView2.Rows[inum2].Cells[2].Value = dataReader["PinNum"].ToString(); inum2 = num; if (inum2 > 5000) { break; } } dataReader.Close(); dataReader = null; this.dataGridView2.AllowUserToAddRows = false; connection.Close(); connection = null; } catch (System.Exception arg_17C_0) { this.dataGridView2.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(arg_17C_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_1A0_0) { KLineTestProcessor.ExceptionRecordFunc(arg_1A0_0.StackTrace); } }
public void RefreshControlFunc() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.comboBox_jkdh.Items.Clear(); this.comboBox_jkdh.Items.Add("所有接口"); string tempStr = ""; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TLineStructLibrary where LineStructName='" + this.gtpsCableStr + "'", connection).ExecuteReader(); if (dataReader.Read()) { tempStr = dataReader["PlugInfo"].ToString(); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_A6_0) { KLineTestProcessor.ExceptionRecordFunc(arg_A6_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } string[] tempStrArray = tempStr.Split(new char[] { ',' }); for (int i = 0; i < tempStrArray.Length; i++) { if (!string.IsNullOrEmpty(tempStrArray[i])) { this.comboBox_jkdh.Items.Add(tempStrArray[i]); } } } catch (System.Exception arg_114_0) { KLineTestProcessor.ExceptionRecordFunc(arg_114_0.StackTrace); } this.comboBox_jkdh.SelectedIndex = 0; }
public void RefreshDataGridView() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.dataGridView1.Rows.Clear(); int inum = 0; string dbpath = Application.StartupPath + "\\ctsdb.mdb"; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TConnectorLibrary order by ConnectorName", connection).ExecuteReader(); while (dataReader.Read()) { string temp1Str = dataReader["ConnectorName"].ToString(); string temp2Str = dataReader["PinNum"].ToString(); this.dataGridView1.AllowUserToAddRows = true; this.dataGridView1.Rows.Add(1); int num = inum + 1; this.dataGridView1.Rows[inum].Cells[0].Value = System.Convert.ToString(num); this.dataGridView1.Rows[inum].Cells[1].Value = temp1Str; this.dataGridView1.Rows[inum].Cells[2].Value = temp2Str; this.dataGridView1.AllowUserToAddRows = false; inum = num; } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_144_0) { this.dataGridView1.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(arg_144_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_168_0) { KLineTestProcessor.ExceptionRecordFunc(arg_168_0.StackTrace); } }
public void RefreshDataGridView2() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.dataGridView2.Rows.Clear(); int inum2 = 0; string dbpath = Application.StartupPath + "\\ctsdb.mdb"; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select top " + 5000 + " * from TPlugLibrary order by PlugNo", connection).ExecuteReader(); this.dataGridView2.AllowUserToAddRows = true; while (dataReader.Read()) { this.dataGridView2.Rows.Add(1); int num = inum2 + 1; this.dataGridView2.Rows[inum2].Cells[0].Value = System.Convert.ToString(num); this.dataGridView2.Rows[inum2].Cells[1].Value = dataReader["PlugNo"].ToString(); this.dataGridView2.Rows[inum2].Cells[2].Value = dataReader["PinNum"].ToString(); inum2 = num; } dataReader.Close(); dataReader = null; this.dataGridView2.AllowUserToAddRows = false; connection.Close(); connection = null; } catch (System.Exception arg_155_0) { this.dataGridView2.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(arg_155_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_179_0) { KLineTestProcessor.ExceptionRecordFunc(arg_179_0.StackTrace); } }
public void QueryUpdateProjectInfoFunc(int iIndex, int iEditPid) { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select top 1 * from TProjectInfo where ID=" + iEditPid, connection).ExecuteReader(); if (dataReader.Read()) { string cpStr = dataReader["iCommonProject"].ToString(); if (cpStr == "1") { this.dataGridView1.Rows[iIndex].Cells[4].Value = "是"; } else { this.dataGridView1.Rows[iIndex].Cells[4].Value = "否"; } this.dataGridView1.Rows[iIndex].Cells[3].Value = dataReader["batchMumberStr"].ToString(); this.dataGridView1.Rows[iIndex].Cells[2].Value = dataReader["bcCableName"].ToString(); this.dataGridView1.Rows[iIndex].Cells[5].Value = dataReader["Remark"].ToString(); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_15F_0) { KLineTestProcessor.ExceptionRecordFunc(arg_15F_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_183_0) { KLineTestProcessor.ExceptionRecordFunc(arg_183_0.StackTrace); } }
private void FormEquipmentInfoManage_Load(object sender, System.EventArgs e) { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { byte readOnly = (!this.bIsAdminFlag) ? 1 : 0; this.textBox_DLCSY_Model.ReadOnly = (readOnly != 0); byte readOnly2 = (!this.bIsAdminFlag) ? 1 : 0; this.textBox_DLCSY_SN.ReadOnly = (readOnly2 != 0); byte enabled = (!this.bIsAdminFlag) ? 1 : 0; this.timer_move.Enabled = (enabled != 0); byte e2 = (!this.bIsAdminFlag) ? 1 : 0; this.label_note.Visible = (e2 != 0); string dbpath = Application.StartupPath + "\\ctsdb.mdb"; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select top 1 * from TTestEquipmentInfo", connection).ExecuteReader(); if (dataReader.Read()) { this.textBox_DLCSY_Model.Text = dataReader["TestEquipmentModel"].ToString(); this.textBox_DLCSY_SN.Text = dataReader["TestEquipmentSN"].ToString(); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_105_0) { if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } KLineTestProcessor.ExceptionRecordFunc(arg_105_0.StackTrace); } } catch (System.Exception arg_113_0) { KLineTestProcessor.ExceptionRecordFunc(arg_113_0.StackTrace); } }
private void FormLogin_Load(object sender, System.EventArgs e) { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.loginUser = ""; this.loginSecr = ""; this.loginName = ""; this.bIsAdminFlag = false; this.bLoginSuccFlag = false; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select top 1 * from TLoginRecord order by ID desc", connection).ExecuteReader(); if (dataReader.Read()) { string tempStr = dataReader["LoginUser"].ToString(); if (!string.IsNullOrEmpty(tempStr)) { this.textBox_UserName.Text = tempStr; } } dataReader.Close(); connection.Close(); dataReader = null; connection = null; } catch (System.Exception arg_BC_0) { if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } KLineTestProcessor.ExceptionRecordFunc(arg_BC_0.StackTrace); } this.textBox_Password.Focus(); } catch (System.Exception ex_D6) { } }
public void GLDealwithFunc() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.comboBox_it.Items.Clear(); this.connectorNameStrArray.Clear(); string cNameStr = this.textBox_Connector.Text.ToString().Trim(); try { connection = new OleDbConnection(); string dbpath = Application.StartupPath + "\\ctsdb.mdb"; connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand((!string.IsNullOrEmpty(cNameStr)) ? ("select * from TConnectorLibrary where ConnectorName like '%" + cNameStr + "%' order by ConnectorName") : "select * from TConnectorLibrary order by ConnectorName", connection).ExecuteReader(); while (dataReader.Read()) { this.connectorNameStrArray.Add(dataReader["ConnectorName"].ToString()); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_CA_0) { KLineTestProcessor.ExceptionRecordFunc(arg_CA_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } for (int i = 0; i < this.connectorNameStrArray.Count; i++) { this.comboBox_it.Items.Add(this.connectorNameStrArray[i]); } } catch (System.Exception arg_121_0) { KLineTestProcessor.ExceptionRecordFunc(arg_121_0.StackTrace); } }
private void ctFormInterfaceTypeImportPin_Load(object sender, System.EventArgs e) { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.comboBox_it.Items.Clear(); this.connectorNameStrArray.Clear(); try { connection = new OleDbConnection(); string dbpath = Application.StartupPath + "\\ctsdb.mdb"; connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TConnectorLibrary order by ConnectorName", connection).ExecuteReader(); while (dataReader.Read()) { this.connectorNameStrArray.Add(dataReader["ConnectorName"].ToString()); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_94_0) { KLineTestProcessor.ExceptionRecordFunc(arg_94_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } for (int i = 0; i < this.connectorNameStrArray.Count; i++) { this.comboBox_it.Items.Add(this.connectorNameStrArray[i]); } } catch (System.Exception arg_EB_0) { KLineTestProcessor.ExceptionRecordFunc(arg_EB_0.StackTrace); } }
private void btnOK_Click(object sender, EventArgs e) { if (frmBase.Me_Conn.State == ConnectionState.Open) { string format = "SELECT memb_guid FROM MEMB_INFO WHERE memb___id = '{0}'"; try { if (!Validator.UserName(this.txtAccount.Text.Trim())) { Utils.WarningMessage("Error: Account names must be between 4-10 characters, and only contain numbers, letters or underscores."); } else if (!Validator.PassWord(this.txtPwd.Text.Trim())) { Utils.WarningMessage("Error: Passwords must be between 4-10 characters."); } else { format = string.Format(format, this.txtAccount.Text.Trim()); OleDbDataReader reader = new OleDbCommand(format, frmBase.Me_Conn).ExecuteReader(); if (reader.Read()) { Utils.WarningMessage("Error: The account [" + this.txtAccount.Text.Trim() + "] already exists."); reader.Close(); } else { reader.Close(); object[] args = new object[] { this.txtAccount.Text.Trim(), this.txtPwd.Text.Trim(), this.txtAccount.Text.Trim() + "@email.pl", 0, 1 }; format = string.Format("INSERT INTO dbo.MEMB_INFO(memb___id, memb__pwd, memb_name, mail_addr, fpas_ques, fpas_answ, sno__numb, post_code, bloc_code, ctl1_code) VALUES ('{0}', '{1}', 'EMU','{2}', 'question', 'answer', 0, '{4}', 0, 0)", args); //format = string.Format("DECLARE @Result_Data tinyint; EXEC [dbo].[CreateAccount] @memb___id = N'{0}',@membwebid = N'{0}', @memb__pwd = N'{1}', @mail_addr = N'{2}', @Area_Code = {4}, @Result_Data = @Result_Data OUTPUT; SELECT @Result_Data as N'@Result_Data'", args); if (base.Me_ExecuteSQL(format)) { Utils.InfoMessage("Account created."); } else { Utils.WarningMessage("Error: Account creation failed."); } } } } catch (Exception exception) { Utils.WarningMessage("SQL:" + format + "\nError:" + exception.Message + "\nSource:" + exception.Source + "\nTrace:" + exception.StackTrace); } } }
public bool CableUsedQueryFunc(string queryStr) { OleDbConnection connection = null; OleDbDataReader dataReader = null; bool bExistFlag = false; try { try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TPlugLibrary where ConnectorName='" + queryStr + "'", connection).ExecuteReader(); if (dataReader.Read()) { this.usedPlugStr = dataReader["PlugNo"].ToString(); bExistFlag = true; } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_76_0) { KLineTestProcessor.ExceptionRecordFunc(arg_76_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_9A_0) { KLineTestProcessor.ExceptionRecordFunc(arg_9A_0.StackTrace); } return(bExistFlag); }
public object[] DLookupA(string table, string fieldName, string clauses, string[] orderByFieldNames, bool orderByAsc) { List <object> data = new List <object>(); bool connectedP = isConnectedDo; string query = ""; try { query = "SELECT " + fieldName + " FROM " + table + " WHERE (" + clauses + ")" + ((orderByFieldNames.Length > 0) ? " ORDER BY " + getOrderByData(orderByFieldNames) + " " + ((orderByAsc) ? "ASC" : "DESC") : ""); if (dbType == DatabaseType.MSSQL) { getQueryDbChanger(query, SqlTypes.SELECT); SqlDataReader Dr = new SqlCommand(query, MSSQLConn).ExecuteReader(); while (Dr.Read()) { data.Add(Dr[0]); } Dr.Close(); } else if (dbType == DatabaseType.MYSQL) { MySqlDataReader Dr = new MySqlCommand(query, MySQLConn).ExecuteReader(); while (Dr.Read()) { data.Add(Dr[0]); } Dr.Close(); } else if (dbType == DatabaseType.MSACCESS2003 | dbType == DatabaseType.MSACCESS2007) { OleDbDataReader Dr = new OleDbCommand(query, MSDBSQLConn).ExecuteReader(); while (Dr.Read()) { data.Add(Dr[0]); } Dr.Close(); } } catch (Exception eee) { OnError(eee); data.Clear(); data.Add("ERROR: " + eee.Message); data.Add("ERRORI: " + table); data.Add("ERRORI: " + fieldName); data.Add("ERRORI: " + clauses); data.Add("ERRORI: " + query); } finally { if (!connectedP) { closeConnection(); } } return(data.ToArray()); }
private void FormUpdateUser_Load(object sender, System.EventArgs e) { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.textBox_user.Text = this.userStr; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TUser where UEnabled=1 and UEID='" + KLineTestProcessor.EncrypDisposeFunc(this.userStr) + "'", connection).ExecuteReader(); if (dataReader.Read()) { this.textBox_name.Text = dataReader["UNAME"].ToString(); string tempStr = dataReader["UPWD"].ToString(); this.textBox_psw.Text = KLineTestProcessor.DecodeDisposeFunc(tempStr); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_BA_0) { KLineTestProcessor.ExceptionRecordFunc(arg_BA_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_E0_0) { KLineTestProcessor.ExceptionRecordFunc(arg_E0_0.StackTrace); } }
public void QueryUpdateConnectorInfoFunc(int iIndex, int iEditPid) { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select top 1 * from TConnectorLibrary where ID=" + iEditPid, connection).ExecuteReader(); if (dataReader.Read()) { this.dataGridView1.Rows[iIndex].Cells[2].Value = dataReader["ConverterType"].ToString(); this.dataGridView1.Rows[iIndex].Cells[3].Value = dataReader["PinNum"].ToString(); this.dataGridView1.Rows[iIndex].Cells[4].Value = dataReader["Remark"].ToString(); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_ED_0) { KLineTestProcessor.ExceptionRecordFunc(arg_ED_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_111_0) { KLineTestProcessor.ExceptionRecordFunc(arg_111_0.StackTrace); } }
public void RefreshFormControlFunc() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TConverterLibrary where ID = " + this.iEditPid, connection).ExecuteReader(); if (dataReader.Read()) { this.textBox_name.Text = dataReader["ConverterName"].ToString(); this.textBox_ConverterType.Text = dataReader["ConverterType"].ToString(); this.textBox_Remark.Text = dataReader["Remark"].ToString(); } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_AD_0) { KLineTestProcessor.ExceptionRecordFunc(arg_AD_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_D1_0) { KLineTestProcessor.ExceptionRecordFunc(arg_D1_0.StackTrace); } }
public object DLookup(string table, string fieldName, string clauses, string[] orderByFieldNames, bool orderByAsc) { object data = null; bool connectedP = isConnectedDo; try { string query = "SELECT TOP 1 " + fieldName + " FROM " + table + " WHERE (" + clauses + ")" + ((orderByFieldNames.Length > 0) ? " ORDER BY " + getOrderByData(orderByFieldNames) + " " + ((orderByAsc) ? "ASC" : "DESC") : ""); if (dbType == DatabaseType.MSSQL) { getQueryDbChanger(query, SqlTypes.SELECT); SqlDataReader Dr = new SqlCommand(query, MSSQLConn).ExecuteReader(); if (Dr.Read()) { data = Dr[0]; } Dr.Close(); } else if (dbType == DatabaseType.MYSQL) { MySqlDataReader Dr = new MySqlCommand(query, MySQLConn).ExecuteReader(); if (Dr.Read()) { data = Dr[0]; } Dr.Close(); } else if (dbType == DatabaseType.MSACCESS2003 | dbType == DatabaseType.MSACCESS2007) { OleDbDataReader Dr = new OleDbCommand(query, MSDBSQLConn).ExecuteReader(); if (Dr.Read()) { data = Dr[0]; } Dr.Close(); } } catch (Exception eee) { OnError(eee); data = eee.Message; } finally { if (!connectedP) { closeConnection(); } } return(data); }
static void ImportDataFromExcelEquity() { using (EdisRepository edisRepo = new EdisRepository()) { Console.WriteLine("Program start......"); //string excelFilePath = "C:/Users/ahksysuser06/Desktop/EDISData/Australian Equity Daily Closing Price 20131211.xlsx"; string excelFilePath = "C:/Users/ahksysuser06/Desktop/EDISData/International_Equity_Daily_Closing_Price_20131211.xlsx"; // make sure your sheet name is correct, here sheet name is sheet1, so you can change the sheet name if have different string excelQuery = "select SecId,Name,Symbol from [Sheet1$]"; try { string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilePath + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'"; OleDbConnection oleConn = new OleDbConnection(excelConnectionString); oleConn.Open(); OleDbDataReader oleReader = new OleDbCommand(excelQuery, oleConn).ExecuteReader(); //while (oleReader.Read()) //{ // Domain.Portfolio.AggregateRoots.Asset.Equity equity = new AustralianEquity(edisRepo) // { // Name = oleReader.GetString(1), // Sector = oleReader.GetString(0), // Ticker = oleReader.GetString(2), // EquityType = EquityTypes.AustralianEquity, // }; // Console.WriteLine("inserting"); // edisRepo.InsertEquityData(equity); //} while (oleReader.Read()) { Domain.Portfolio.AggregateRoots.Asset.Equity equity = new InternationalEquity(edisRepo) { Name = oleReader.GetString(1), Sector = oleReader.GetString(0), Ticker = oleReader.GetString(2), EquityType = EquityTypes.InternationalEquity, }; Console.WriteLine("inserting"); edisRepo.InsertEquityData(equity); } oleReader.Close(); oleConn.Close(); Console.WriteLine("Finished"); } catch (Exception ex) { Console.WriteLine(ex.Message); throw; } } }
static void Output(string title) { string sql = "SELECT empno id, ename name FROM emp order by id"; OleDbDataReader dr = new OleDbCommand(sql, cn).ExecuteReader(); Console.WriteLine(title + ":"); while (dr.Read()) { Console.WriteLine("{0, -10}\t{1, -10}", dr[0].ToString().Trim(), dr[1].ToString().Trim()); } Console.WriteLine(); dr.Close(); }
public List <ARCHIVE> GET_ARCHIVE() { OleDbDataReader reader = new OleDbCommand(SQL_GET_ARCHIVE_ALL, myConnection).ExecuteReader(); List <ARCHIVE> listArchive = new List <ARCHIVE>(); while (reader.Read()) { listArchive.Add(new ARCHIVE(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString())); } reader.Close(); return(listArchive); }
public object DLookup(string sqlQuery) { object data = null; bool connectedP = isConnectedDo; try { if (dbType == DatabaseType.MSSQL) { getQueryDbChanger(sqlQuery, SqlTypes.SELECT); SqlDataReader Dr = new SqlCommand(sqlQuery, MSSQLConn).ExecuteReader(); if (Dr.Read()) { data = Dr[0]; } Dr.Close(); } else if (dbType == DatabaseType.MYSQL) { MySqlDataReader Dr = new MySqlCommand(sqlQuery, MySQLConn).ExecuteReader(); if (Dr.Read()) { data = Dr[0]; } Dr.Close(); } else if (dbType == DatabaseType.MSACCESS2003 | dbType == DatabaseType.MSACCESS2007) { OleDbDataReader Dr = new OleDbCommand(sqlQuery, MSDBSQLConn).ExecuteReader(); if (Dr.Read()) { data = Dr[0]; } Dr.Close(); } } catch (Exception eee) { OnError(eee); data = eee.Message; } finally { if (!connectedP) { closeConnection(); } } return(data); }
public List <LOCATION> GET_LOCATION() { OleDbDataReader reader = new OleDbCommand(SQL_GET_LOCATION, myConnection).ExecuteReader(); List <LOCATION> listLocation = new List <LOCATION>(); while (reader.Read()) { listLocation.Add(new LOCATION(Convert.ToInt32(reader[0]), reader[1].ToString())); } reader.Close(); return(listLocation); }
public void UploadResourceFile(HttpPostedFile postedFile, string dataType) { var fileName = BusinessLayerParameters.UserDocumentFolderPrefix + postedFile.FileName; var filePath = HttpContext.Current.Server.MapPath(fileName); postedFile.SaveAs(filePath); string excelFilePath = filePath; string excelQuery = "select * from [Sheet1$]"; string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilePath + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'"; OleDbConnection oleConn = new OleDbConnection(excelConnectionString); oleConn.Open(); OleDbDataReader oleReader = new OleDbCommand(excelQuery, oleConn).ExecuteReader(); try { UploadDataTypes type = (UploadDataTypes)Int32.Parse(dataType); switch (type) { case UploadDataTypes.AssetPrice: FeedExcelDataForAssetPrice(oleReader); break; case UploadDataTypes.BondInfo: FeedExcelDataForBonds(oleReader); break; case UploadDataTypes.EquityInfo: FeedExcelDataForEquities(oleReader); break; case UploadDataTypes.ResearchValue: FeedExcelDataForResearchValue(oleReader); break; } }catch (Exception e) { throw e; } finally { oleReader.Close(); oleConn.Close(); File.Delete(HttpContext.Current.Server.MapPath(fileName)); } }
public int SelectData(out string errMessage) { int num = 0; errMessage = null; OleDbConnection connection = null; OleDbDataReader reader = null; try { connection = new OleDbConnection { ConnectionString = this.connectionString }; connection.Open(); string str = "SELECT * FROM DBINFO"; reader = new OleDbCommand { Connection = connection, CommandText = str }.ExecuteReader(); while (reader.Read()) { num++; } } catch (Exception exception) { errMessage = "errMessage:" + exception.Message + string.Format("\r\n\r\nMethod Name : SelectData", new object[0]); num = -1; } finally { reader.Close(); reader.Dispose(); connection.Close(); connection.Dispose(); } return(num); }
private void metroButton1_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(textBox1.Text) && !String.IsNullOrEmpty(textBox2.Text)) { OleDbConnection connection = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = ..\..\БДDeeplay.mdb"); connection.Open(); OleDbDataReader reader = new OleDbCommand("SELECT Пользователи.Код FROM Пользователи WHERE " + $"Пользователи.Логин='{textBox1.Text}' AND Пользователи.Пароль='{textBox2.Text}'", connection).ExecuteReader(); if (reader.HasRows) { Hide(); Form2 form2 = new Form2(); form2.ShowDialog(); Close(); } else { MessageBox.Show("Ошибка"); } reader.Close(); connection.Close(); } }
public void RefreshDataGridView() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.userIDStrList.Clear(); this.dataGridView1.Rows.Clear(); this.btnDelRecord.Visible = false; int inum = 0; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.mddbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from THistoryDataInfo ORDER BY ID DESC", connection).ExecuteReader(); this.dataGridView1.AllowUserToAddRows = true; while (dataReader.Read()) { this.dataGridView1.Rows.Add(1); int num = inum + 1; this.dataGridView1.Rows[inum].Cells[0].Value = System.Convert.ToString(num); this.strIDArray[inum] = dataReader["ID"].ToString(); this.dataGridView1.Rows[inum].Cells[1].Value = dataReader["ProjectName"].ToString(); this.dataGridView1.Rows[inum].Cells[3].Value = dataReader["batchMumberStr"].ToString(); this.dataGridView1.Rows[inum].Cells[2].Value = dataReader["bcCableName"].ToString(); this.dataGridView1.Rows[inum].Cells[4].Value = dataReader["TestTime"].ToString(); this.userIDStrList.Add(dataReader["Tester"].ToString()); this.dataGridView1.Rows[inum].Cells[5].Value = dataReader["Operator"].ToString(); this.dataGridView1.Rows[inum].Cells[6].Value = dataReader["TestResult"].ToString(); inum = num; if (inum >= 5000) { break; } } this.dataGridView1.AllowUserToAddRows = false; dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_241_0) { this.dataGridView1.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(arg_241_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_265_0) { KLineTestProcessor.ExceptionRecordFunc(arg_265_0.StackTrace); } }
public void RefreshDataGridView() { OleDbConnection connection = null; OleDbDataReader dataReader = null; try { this.dataGridView1.Rows.Clear(); int iUserCount = 0; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); dataReader = new OleDbCommand("select * from TUser where UEnabled=1 order by UID asc", connection).ExecuteReader(); while (dataReader.Read()) { string tempStr = dataReader["UEID"].ToString(); this.userStrArray[iUserCount] = KLineTestProcessor.DecodeDisposeFunc(tempStr); this.nameStrArray[iUserCount] = dataReader["UNAME"].ToString(); iUserCount++; if (iUserCount >= FormUserManage.MAX_USER_NUM) { break; } } dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception ex) { if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } KLineTestProcessor.ExceptionRecordFunc(ex.StackTrace); goto IL_19E; } if (iUserCount > 0) { this.dataGridView1.AllowUserToAddRows = true; int num; for (int i = 0; i < iUserCount; i = num) { this.dataGridView1.Rows.Add(1); num = i + 1; this.dataGridView1.Rows[i].Cells[0].Value = System.Convert.ToString(num); this.dataGridView1.Rows[i].Cells[1].Value = this.userStrArray[i]; this.dataGridView1.Rows[i].Cells[2].Value = this.nameStrArray[i]; } this.dataGridView1.AllowUserToAddRows = false; } IL_19E :; } catch (System.Exception ex2) { this.dataGridView1.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(ex2.StackTrace); } }
private void btnQuery_Click(object sender, System.EventArgs e) { OleDbConnection connection = null; string sqlcommand = null; OleDbDataReader dataReader = null; try { System.ValueType dt = this.dateTimePicker_start.Value; System.ValueType dt2 = this.dateTimePicker_stop.Value; System.ValueType valueType = default(System.DateTime); (System.DateTime)valueType = new System.DateTime(((System.DateTime)dt).Year, ((System.DateTime)dt).Month, ((System.DateTime)dt).Day, 0, 0, 0, 0); System.ValueType startdt = valueType; System.ValueType valueType2 = default(System.DateTime); (System.DateTime)valueType2 = new System.DateTime(((System.DateTime)dt2).Year, ((System.DateTime)dt2).Month, ((System.DateTime)dt2).Day, 23, 59, 59, 999); System.ValueType stopdt = valueType2; System.DateTime value = this.dateTimePicker_stop.Value; if (System.DateTime.Compare(this.dateTimePicker_start.Value, value) > 0) { MessageBox.Show("起始日期大于终止日期!", "提示", MessageBoxButtons.OK); } else { string _cablebhStr = this.textBox_cableName.Text.ToString(); string batchMumberStr = this.textBox_batchMumber.Text.ToString().Trim(); this.userIDStrList.Clear(); this.dataGridView1.Rows.Clear(); this.btnDelRecord.Visible = false; int inum = 0; try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.mddbPathStr; connection.Open(); if (string.IsNullOrEmpty(_cablebhStr) && string.IsNullOrEmpty(batchMumberStr)) { sqlcommand = "select * from THistoryDataInfo where TestTime Between #" + valueType + "# and #" + valueType2 + "# ORDER BY ID DESC"; } else if (!string.IsNullOrEmpty(_cablebhStr) && !string.IsNullOrEmpty(batchMumberStr)) { sqlcommand = "select * from THistoryDataInfo where batchMumberStr = '" + batchMumberStr + "' and bcCableName = '" + _cablebhStr + "' and TestTime Between #" + valueType + "# and #" + valueType2 + "# ORDER BY ID DESC"; } else if (string.IsNullOrEmpty(_cablebhStr) && !string.IsNullOrEmpty(batchMumberStr)) { sqlcommand = "select * from THistoryDataInfo where batchMumberStr = '" + batchMumberStr + "' and TestTime Between #" + valueType + "# and #" + valueType2 + "# ORDER BY ID DESC"; } else if (!string.IsNullOrEmpty(_cablebhStr) && string.IsNullOrEmpty(batchMumberStr)) { sqlcommand = "select * from THistoryDataInfo where bcCableName = '" + _cablebhStr + "' and TestTime Between #" + valueType + "# and #" + valueType2 + "# ORDER BY ID DESC"; } dataReader = new OleDbCommand(sqlcommand, connection).ExecuteReader(); this.dataGridView1.AllowUserToAddRows = true; while (dataReader.Read()) { this.dataGridView1.Rows.Add(1); int num = inum + 1; this.dataGridView1.Rows[inum].Cells[0].Value = System.Convert.ToString(num); this.strIDArray[inum] = dataReader["ID"].ToString(); this.dataGridView1.Rows[inum].Cells[1].Value = dataReader["ProjectName"].ToString(); this.dataGridView1.Rows[inum].Cells[3].Value = dataReader["batchMumberStr"].ToString(); this.dataGridView1.Rows[inum].Cells[2].Value = dataReader["bcCableName"].ToString(); this.dataGridView1.Rows[inum].Cells[4].Value = dataReader["TestTime"].ToString(); this.userIDStrList.Add(dataReader["Tester"].ToString()); this.dataGridView1.Rows[inum].Cells[5].Value = dataReader["Operator"].ToString(); this.dataGridView1.Rows[inum].Cells[6].Value = dataReader["TestResult"].ToString(); inum = num; if (inum >= 5000) { break; } } this.dataGridView1.AllowUserToAddRows = false; dataReader.Close(); dataReader = null; connection.Close(); connection = null; if (inum <= 0) { MessageBox.Show("查无记录!", "提示", MessageBoxButtons.OK); return; } } catch (System.Exception arg_4AE_0) { this.dataGridView1.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(arg_4AE_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } this.qCablebhStr = _cablebhStr; this.qStartdt = startdt; this.qStopdt = stopdt; this.qMethod = 0; } } catch (System.Exception arg_4F0_0) { KLineTestProcessor.ExceptionRecordFunc(arg_4F0_0.StackTrace); } }
public void GLDealwithFunc() { OleDbConnection connection = null; string sqlcommand = null; OleDbDataReader dataReader = null; try { this.dataGridView1.Rows.Clear(); int inum = 0; string cNameStr = this.textBox_Connector.Text.ToString().Trim(); try { connection = new OleDbConnection(); connection.ConnectionString = this.gLineTestProcessor.dbPathStr; connection.Open(); if (this.comboBox_sxtj.SelectedIndex == 0) { if (string.IsNullOrEmpty(cNameStr)) { sqlcommand = "select * from TConnectorLibrary order by ConnectorName"; } else { sqlcommand = "select * from TConnectorLibrary where ConnectorName like '%" + cNameStr + "%' order by ConnectorName"; } } else if (this.comboBox_sxtj.SelectedIndex == 1) { if (string.IsNullOrEmpty(cNameStr)) { sqlcommand = "select * from TConnectorLibrary order by ConverterType"; } else { sqlcommand = "select * from TConnectorLibrary where ConverterType like '%" + cNameStr + "%' order by ConverterType"; } } else if (this.comboBox_sxtj.SelectedIndex == 2) { if (string.IsNullOrEmpty(cNameStr)) { sqlcommand = "select * from TConnectorLibrary order by PinNum"; } else { sqlcommand = "select * from TConnectorLibrary where PinNum='" + cNameStr + "'"; } } dataReader = new OleDbCommand(sqlcommand, connection).ExecuteReader(); this.dataGridView1.AllowUserToAddRows = true; while (dataReader.Read()) { this.dataGridView1.Rows.Add(1); int num = inum + 1; this.dataGridView1.Rows[inum].Cells[0].Value = System.Convert.ToString(num); this.strIDArray[inum] = dataReader["ID"].ToString(); this.dataGridView1.Rows[inum].Cells[1].Value = dataReader["ConnectorName"].ToString(); this.dataGridView1.Rows[inum].Cells[2].Value = dataReader["ConverterType"].ToString(); this.dataGridView1.Rows[inum].Cells[3].Value = dataReader["PinNum"].ToString(); this.dataGridView1.Rows[inum].Cells[4].Value = dataReader["Remark"].ToString(); inum = num; if (inum >= 5000) { break; } } this.dataGridView1.AllowUserToAddRows = false; dataReader.Close(); dataReader = null; connection.Close(); connection = null; } catch (System.Exception arg_26D_0) { this.dataGridView1.AllowUserToAddRows = false; KLineTestProcessor.ExceptionRecordFunc(arg_26D_0.StackTrace); if (dataReader != null) { dataReader.Close(); dataReader = null; } if (connection != null) { connection.Close(); connection = null; } } } catch (System.Exception arg_291_0) { KLineTestProcessor.ExceptionRecordFunc(arg_291_0.StackTrace); } }