public int ExecuteNonQuery(string sqlStr) { lock (_obj) { using (TAdoDbxConnection conn = new TAdoDbxConnection(_connectionString)) { int NonQuery = 0; TAdoDbxCommand cmd = new TAdoDbxCommand(); cmd.Connection = conn; cmd.CommandText = sqlStr; try { cmd.Connection.Open(); NonQuery = cmd.ExecuteNonQuery(); } catch (Exception ex) { if (ex.Message != "message length error (encountered 0, expected 8)" && ex.Message != "message length error (encountered 0, expected 12)") { _logger.Error(string.Format("执行SQL错误:{0}.", ex)); } return(NonQuery); } finally { cmd.Connection.Close(); cmd.Connection.Dispose(); cmd.Dispose(); } return(NonQuery); } } }
public object ExecuteScalar(string sqlStr) { lock (_obj) { using (TAdoDbxConnection conn = new TAdoDbxConnection(_connectionString)) { TAdoDbxCommand cmd = new TAdoDbxCommand(); cmd.Connection = conn; cmd.CommandText = sqlStr; try { cmd.Connection.Open(); return(cmd.ExecuteScalar()); } catch (Exception ex) { _logger.Error(string.Format("执行SQL错误:{0}.", ex)); return(null); } finally { cmd.Connection.Close(); cmd.Connection.Dispose(); cmd.Dispose(); } } } }
public List <Ordr> ReadOrdrData(string queryString) { List <Ordr> ordrs = new List <Ordr>(); try { using (TAdoDbxConnection connection = new TAdoDbxConnection(_connectionString)) { using (TAdoDbxCommand cmd = new TAdoDbxCommand()) { cmd.Connection = connection; cmd.CommandText = queryString; cmd.Connection.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { ordrs.Add(new Ordr { Cnt = Convert.ToInt32(reader["CNT"]), Amt = Convert.ToDouble(reader["AMT"]) }); } } } } } catch (Exception) { } return(ordrs); }
public List <FolioPayment> ReadFolioPaymentData(string queryString) { List <FolioPayment> folioPayments = new List <FolioPayment>(); try { using (TAdoDbxConnection connection = new TAdoDbxConnection(_connectionString)) { using (TAdoDbxCommand cmd = new TAdoDbxCommand()) { cmd.Connection = connection; cmd.CommandText = queryString; cmd.Connection.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { folioPayments.Add(new FolioPayment { PaymentDes = reader["PAYMENTDES"].ToString(), Amt = Convert.ToDouble(reader["AMT"]) }); } } } } } catch (Exception) { } return(folioPayments); }
public List <Folio> ReadFolioData(string queryString) { List <Folio> folios = new List <Folio>(); try { using (TAdoDbxConnection connection = new TAdoDbxConnection(_connectionString)) { using (TAdoDbxCommand cmd = new TAdoDbxCommand()) { cmd.Connection = connection; cmd.CommandText = queryString; cmd.Connection.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { folios.Add(new Folio { Serial = reader["SERIAL"].ToString(), StartTim = Convert.ToDateTime(reader["STARTTIM"]), Amt = reader["AMT"].ToString(), UploadResult = "" }); } } } } } catch (Exception) { } return(folios); }
public DataTable GetData(string sqlStr) { lock (_obj) { using (TAdoDbxConnection conn = new TAdoDbxConnection(_connectionString)) { DataSet ds = new DataSet(); TAdoDbxCommand cmd = new TAdoDbxCommand(); cmd.Connection = conn; cmd.CommandText = sqlStr; try { cmd.Connection.Open(); DbDataReader myreader = cmd.ExecuteReader(); DataTable dt = new DataTable(); if (myreader.HasRows) { if (!Convert.IsDBNull(myreader)) { dt.Load(myreader); ds.Tables.Add(dt); ds.Load(myreader, LoadOption.PreserveChanges, ds.Tables[0]); } else { ds.Tables.Add(dt); } } else { ds.Tables.Add(dt); } myreader.Close(); myreader.Dispose(); } catch (Exception ex) { _logger.Error(string.Format("执行SQL错误:{0}.", ex)); } finally { cmd.Connection.Close(); cmd.Connection.Dispose(); cmd.Dispose(); } if (ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(new DataTable()); } } } }
/// <summary> /// 测试数据库是否连接成功 /// </summary> /// <returns></returns> public async Task <bool> TestConnectAsync() { return(await Task.Factory.StartNew(() => { try { TAdoDbxCommand cmd = new TAdoDbxCommand(); cmd.Connection = new TAdoDbxConnection(_connectionString); cmd.Connection.Open(); cmd.Connection.Close(); return true; } catch (Exception ex) { _logger.Error(string.Format("测试数据库连接失败:{0}.", ex)); return false; } })); }
/// <summary> /// 测试数据库是否连接成功 /// </summary> /// <returns></returns> public bool TestConnect() { lock (_obj) { try { TAdoDbxCommand cmd = new TAdoDbxCommand(); cmd.Connection = new TAdoDbxConnection(_connectionString); cmd.Connection.Open(); cmd.Connection.Close(); return(true); } catch (Exception ex) { _logger.Error(string.Format("测试数据库连接失败:{0}.", ex)); return(false); } } }