WebUI/AdminM/Sys/ManageDB.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.IO;
using System.Data.SqlClient;

namespace WebUI.AdminM.back
{
    public partial class ManageDB : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            { 

                DataTable dt = Common.DBHelper.CreateInsert("Conn").SelectDs("select name from sysobjects where type = 'U'").Tables[0];
                TreeNode t = new TreeNode();
                t.Text = "全部";
                t.Value = "0";

                foreach (DataRow d in dt.Rows)
                {
                    TreeNode tc = new TreeNode();
                    tc.Text = d[0].ToString(); ;
                    tc.Value = d[0].ToString(); ;
                    t.ChildNodes.Add(tc);
                }
                treeNode.Nodes.Add(t);

            }
        }

        protected void treeNode_SelectedNodeChanged(object sender, EventArgs e)
        {


            string sql = @" SELECT 
表名       = CASE WHEN A.COLORDER=1 THEN D.NAME ELSE '' END,
表說明     = CASE WHEN A.COLORDER=1 THEN ISNULL(F.VALUE,'') ELSE '' END,
字段号   = A.COLORDER,
字段名     = A.NAME,
标识      = CASE WHEN COLUMNPROPERTY( A.ID,A.NAME,'ISIDENTITY')=1 THEN '√'ELSE '' END,
主鍵       = CASE WHEN EXISTS(SELECT 1 FROM SYSOBJECTS WHERE XTYPE='PK' AND PARENT_OBJ=A.ID AND NAME IN (
SELECT NAME FROM SYSINDEXES WHERE INDID IN(
SELECT INDID FROM SYSINDEXKEYS WHERE ID = A.ID AND COLID=A.COLID))) THEN '√' ELSE '' END,
类型       = B.NAME,
占用元素 = A.LENGTH,
长度       = COLUMNPROPERTY(A.ID,A.NAME,'PRECISION'),
小数位数   = ISNULL(COLUMNPROPERTY(A.ID,A.NAME,'SCALE'),0),
允許空     = CASE WHEN A.ISNULLABLE=1 THEN '√'ELSE '' END,
预设值     = ISNULL(E.TEXT,''),
字段說明   = ISNULL(G.[VALUE],'')
FROM 
SYSCOLUMNS A
LEFT JOIN 
SYSTYPES B