public override string CreateText(AppObject appobj, ConnectionPack connpack)
{
ObjectPath objpath = appobj.GetObjectPath();
IDatabaseSource db = appobj.FindDatabaseConnection(connpack);
IPhysicalConnection conn = appobj.FindPhysicalConnection(connpack);
ITableSource tbl = appobj.FindTableConnection(connpack);
if (conn != null && objpath != null)
{
string text = conn.InvokeR <string>((Func <string>) delegate()
{
if (conn.SystemConnection != null)
{
conn.SystemConnection.SafeChangeDatabase(objpath);
}
var sw = new StringWriter();
var gen = new GenSql_CreateTable();
gen.GenerateCreateTable(tbl, sw, conn.GetAnyDialect());
return(sw.ToString());
});
return(text);
}
return("");
}
public override string CreateHtml(AppObject appobj, ConnectionPack connpack, IDictionary <string, object> outnames)
{
ObjectPath objpath = appobj.GetObjectPath();
IPhysicalConnection conn = appobj.FindPhysicalConnection(connpack);
if (conn != null && conn.IsOpened)
{
return(conn.InvokeR <string>((Func <string>) delegate()
{
string rowcount = "???", colcount = "???";
if (conn.SystemConnection != null)
{
var dbcache = conn.Cache.Database(appobj.GetObjectPath().DbName);
var dialect = conn.GetAnyDialect();
bool dbset = false;
rowcount = (string)dbcache.Get("htmlinfowidget_rows", objpath.ObjectName.ToString());
if (rowcount == null)
{
if (!dbset)
{
conn.SystemConnection.SafeChangeDatabase(objpath);
dbset = true;
}
rowcount = conn.SystemConnection.ExecuteScalar("SELECT COUNT(*) FROM " + dialect.QuoteFullName(objpath.ObjectName)).ToString();
try
{
int ival = Int32.Parse(rowcount);
rowcount = ival.FormatInt();
}
catch { }
dbcache.Put("htmlinfowidget_rows", objpath.ObjectName.ToString(), rowcount);
}
colcount = (string)dbcache.Get("htmlinfowidget_cols", objpath.ObjectName.ToString());
if (colcount == null)
{
if (!dbset)
{
conn.SystemConnection.SafeChangeDatabase(objpath);
dbset = true;
}
using (var cmd = conn.SystemConnection.CreateCommand())
{
cmd.CommandText = "SELECT * FROM " + dialect.QuoteFullName(objpath.ObjectName);
using (var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))
{
colcount = reader.GetSchemaTable().Rows.Count.ToString();
}
dbcache.Put("htmlinfowidget_cols", objpath.ObjectName.ToString(), colcount);
}
}
}
else
{
var db = appobj.FindDatabaseConnection(connpack);
if (db != null)
{
var ts = db.InvokeLoadTableStructure(objpath.ObjectName, TableStructureMembers.ColumnNames);
colcount = ts.Columns.Count.ToString();
}
//var tbl = appobj.FindTableConnection(connpack);
//if (tbl != null)
//{
// var tabdata = tbl.GetTabularData();
// if (tabdata != null)
// {
// int? rcnt = tabdata.LoadRowCount(new TableDataSetProperties());
// if (rcnt != null) rowcount = rcnt.ToString();
// }
//}
}
HtmlGenerator gen = new HtmlGenerator();
gen.BeginHtml(objpath.ObjectName.ToString(), HtmlGenerator.HtmlObjectViewStyle);
if (ShowTableName)
{
gen.Heading(objpath.ObjectName.ToString(), 2);
}
gen.PropsTableBegin();
gen.PropTableRow("s_row_count", rowcount);
gen.PropTableRow("s_column_count", colcount);
gen.PropsTableEnd();
return gen.HtmlText;
}));
}
return("");
}
public static IDialectDataAdapter GetAnyDDA(this IPhysicalConnection conn)
{
return(conn.GetAnyDialect().CreateDataAdapter());
}