/// <summary>
///
/// </summary>
/// <param name="tableName"></param>
/// <param name="mode"></param>
/// <param name="criteria"></param>
/// <returns></returns>
public int GetCountRows(string tableName, ExcelHelperReadMode mode, string criteria)
{
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
string cmdText = "Select Count(*) from [{0}]";
if (!string.IsNullOrEmpty(criteria))
{
cmdText += " Where " + criteria;
}
string tableNameSuffix = string.Empty;
if (mode == ExcelHelperReadMode.ReadWorkSheet)
{
tableNameSuffix = "$";
}
var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix))
{
Connection = Connection
};
var count = (int)cmd.ExecuteScalar();
return(count);
}
/// <summary>
///
/// </summary>
/// <param name="tableName"></param>
/// <param name="mode"></param>
/// <param name="criteria"></param>
/// <returns></returns>
public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode, string criteria)
{
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
string cmdText = "Select * from [{0}]";
if (!string.IsNullOrEmpty(criteria))
{
cmdText += " Where " + criteria;
}
string tableNameSuffix = string.Empty;
if (mode == ExcelHelperReadMode.ReadWorkSheet)
{
tableNameSuffix = "$";
}
var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix))
{
Connection = Connection
};
OleDbDataReader read = cmd.ExecuteReader();
//OleDbDataAdapter adpt = new OleDbDataAdapter(cmd);
//DataSet ds = new DataSet();
//adpt.Fill(ds, tableName);
//if (ds.Tables.Count >= 1)
//{
// return ds.Tables[0];
//}
//else
//{
// return null;
//}
return(read);
}
/// <summary>
///
/// </summary>
/// <param name="tableName"></param>
/// <param name="mode"></param>
/// <returns></returns>
public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode)
{
return(ReadTable(tableName, mode, ""));
}
/// <summary>
///
/// </summary>
/// <param name="tableName"></param>
/// <param name="mode"></param>
/// <param name="criteria"></param>
/// <returns></returns>
public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode, string criteria)
{
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
string cmdText = "Select * from [{0}]";
if (!string.IsNullOrEmpty(criteria))
{
cmdText += " Where " + criteria;
}
string tableNameSuffix = string.Empty;
if (mode == ExcelHelperReadMode.ReadWorkSheet)
tableNameSuffix = "$";
var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix)) { Connection = Connection };
OleDbDataReader read = cmd.ExecuteReader();
//OleDbDataAdapter adpt = new OleDbDataAdapter(cmd);
//DataSet ds = new DataSet();
//adpt.Fill(ds, tableName);
//if (ds.Tables.Count >= 1)
//{
// return ds.Tables[0];
//}
//else
//{
// return null;
//}
return read;
}
/// <summary>
///
/// </summary>
/// <param name="tableName"></param>
/// <param name="mode"></param>
/// <returns></returns>
public OleDbDataReader ReadTable(string tableName, ExcelHelperReadMode mode)
{
return ReadTable(tableName, mode, "");
}
/// <summary>
///
/// </summary>
/// <param name="tableName"></param>
/// <param name="mode"></param>
/// <param name="criteria"></param>
/// <returns></returns>
public int GetCountRows(string tableName, ExcelHelperReadMode mode, string criteria)
{
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
string cmdText = "Select Count(*) from [{0}]";
if (!string.IsNullOrEmpty(criteria))
{
cmdText += " Where " + criteria;
}
string tableNameSuffix = string.Empty;
if (mode == ExcelHelperReadMode.ReadWorkSheet)
tableNameSuffix = "$";
var cmd = new OleDbCommand(string.Format(cmdText, tableName + tableNameSuffix)) { Connection = Connection };
var count = (int) cmd.ExecuteScalar();
return count;
}
