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