public override void Process(HttpContext context)
{
string connectionString = ConfigurationManager.ConnectionStrings["db"].ConnectionString;
string database = RegexHelper.Search(connectionString, @"Initial Catalog=(?<Cata>\w*)", "Cata");
string owner = "dbo";
string title = "数据字典";
context.Response.ContentType = "text/html";
Write("<h1>{0}</h1>", title);
Write("<p>{0:yyyy-MM-dd HH:mm:ss}</p>", System.DateTime.Now);
SqlServerFetcher f = new SqlServerFetcher(connectionString);
foreach (var t in f.GetTables())
{
var fullName = string.Format("{0}.{1}", t.Schema, t.Name);
Write("<h1><a href='DbGrid.aspx?table={0}' style='text-decoration:none'>{1}</a></h1>", fullName, fullName);
Write("<table border=1 style='border-collapse:collapse' width='100%' cellpadding='2' cellspacing='0'>");
Write("<tr><td width='200'>名称</td><td width='150'>类型</td><td width='150'>可为空</td><td width='150'>字符长度</td><td width='150'>数字精度</td><td>主键</td><td>备注</td></tr>");
foreach (var c in f.GetColumns2008(database, owner, t.Name))
{
Write("<tr><td>{0} </td><td>{1} </td><td>{2} </td><td>{3} </td><td>{4} </td><td>{5} </td><td>{6} </td></tr>",
c.Name,
c.DataType,
c.IsNullbable,
c.CharacterMaximumLength,
c.NumericPrecision,
c.Identity,
c.Description
);
}
Write("</table>");
}
}
