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);
}
}
}
