public static Hashtable GetTableColumn(string tableName)
{
if (hastableName.Contains(tableName))
{
return((Hashtable)hastableName[tableName]);
}
else
{
Hashtable hast = new Hashtable();
string sql = "";
//switch (DataBaseTypeString.ToLower())
//{
// case "oracle":
// sql = "SELECT COLUMN_NAME AS NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = '" + tableName + "' ORDER BY NAME";
// break;
// case "sqlserver":
// sql = "select name from syscolumns where id=object_id('" + tableName + "')";
// break;
// default:
// return null;
//}
sql = "select * from " + tableName + " where 1=0";
SMT.DataResult dresult = SMT.DataProvider.GetDataTable(sql);
DataTable dt = dresult.DataTable;
//if (dt != null)
//{
// int n = dt.Rows.Count;
// for (int i = 0; i < n; i++)
// {
// string name = dt.Rows[i]["NAME"].ToString().ToUpper();
// if (!hast.Contains(name))
// {
// hast.Add(name, name);
// }
// //parmCache.Add(name, name);
// }
// hastableName.Add(tableName, hast);
//}
if (dt != null)
{
int n = dt.Columns.Count;
for (int i = 0; i < n; i++)
{
string name = dt.Columns[i].ToString().ToUpper();
if (!hast.Contains(name))
{
hast.Add(name, name);
}
//parmCache.Add(name, name);
}
hastableName.Add(tableName, hast);
}
return(hast);
}
}
private EntityResult GetEntityResult(SMT.DataResult dresult)
{
EntityResult result = new EntityResult();
result.DataSet = dresult.DataSet;
result.DataTable = dresult.DataTable;
result.Sql = dresult.Sql;
result.IDataReader = dresult.IDataReader;
result.IDbDataParameter = dresult.IDbDataParameter;
result.RecordCount = dresult.RecordCount;
result.Error = dresult.Error;
return(result);
}
private EntityResult GetEntityResult(SMT.DataResult dresult)
{
//EntityResult Result = new EntityResult();
Result.DataSet = dresult.DataSet;
Result.DataTable = dresult.DataTable;
if (Result.Sql == null || Result.Sql.IndexOf(dresult.Sql) < 0)
{
Result.Sql += (string.IsNullOrEmpty(dresult.Sql)) ? "" : dresult.Sql + " ";
}
//Result.Sql += (string.IsNullOrEmpty(dresult.Sql)) ? "" : dresult.Sql + " ";
Result.IDataReader = dresult.IDataReader;
Result.IDbDataParameter = dresult.IDbDataParameter;
Result.RecordCount += dresult.RecordCount;
Result.Error += (string.IsNullOrEmpty(dresult.Error)) ? "" : dresult.Error + " ";
return(Result);
}
