public DataTable GetDataTableFromSql(HttpRequestBase request, string sql)
{
Stopwatch sw = new Stopwatch();
sw.Start();
string sqlTableName = request["Sheetname"];
string providerName = ConfigInfo.ProviderName;
string serverName = ConfigInfo.ServerName;
string validataType = ConfigInfo.ValidateType;
string userName = ConfigInfo.UserName;
string userPwd = ConfigInfo.UserPwd;
string dataBase = ConfigInfo.DataBase;
string fileName = request["fileName"];
//string sql = "SELECT [UserID],[UserCode],[UserName],[ParentID],[Position],[Mobile],[Email],[Levels],[AttentionTime]FROM Users WHERE CreateStatus = 1 AND(AttentionState = 1); ";
DbConfig.Db.ProviderName = ConfigInfo.ProviderName;
DbConfig.Db.DataBase = ConfigInfo.DataBase;
string conString = DbConfig.Db.GetConstring(providerName, validataType, userName, userPwd, dataBase, serverName);
DbConfig.Db.DbProvider = DbUtility.GetConnectstring(conString);
return(DataTabletoExcel.GetDataTableFromSql(sql));
}
