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 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 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());
}
}
}
}
public static DbConnection getConnection()
{
DbConnection c = new TAdoDbxConnection();
c.ConnectionString = "DriverName=Interbase;Database=192.168.1.250:C:\\Mansur\\zemotdel.gdb;RoleName=RoleName;User_Name=sysdba;Password=masterkey;lc_ctype=UTF-8;SQLDialect=3;MetaDataAssemblyLoader=Borland.Data.TDBXInterbaseMetaDataCommandFactory,Borland.Data.DbxReadOnlyMetaData,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b;GetDriverFunc=getSQLDriverINTERBASE;LibraryName=dbxint30.dll;VendorLib=GDS32.DLL";
return c;
}
