public DataTable GetTableStructure(string querySql, DateTime startTime, DateTime endTime)
{
string sql = DataBaseHelper.FilterSqlQuery(querySql);
SqlParameter[] prms = this.ConvetSqlParameter(startTime, endTime);
return(SQlServerHelper.ExecuteDataset(SQlServerHelper.MyConnectStr, CommandType.Text, sql, prms).Tables[0]);
}
public IDataReader ExecuteReader(string querySql, DateTime startTime, DateTime endTime)
{
SqlParameter[] prms = this.ConvetSqlParameter(startTime, endTime);
return(SQlServerHelper.ExecuteReader(SQlServerHelper.MyConnectStr, CommandType.Text, querySql, prms));
}
public DataTable ExcuteSqlForDataTable(string querySql, DateTime startTime, DateTime endTime)
{
SqlParameter[] prms = this.ConvetSqlParameter(startTime, endTime);
return(SQlServerHelper.ExecuteDataset(SQlServerHelper.MyConnectStr, CommandType.Text, querySql, prms).Tables[0]);
}
