Manage/TableInfo.aspx.cs

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

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

using System;
using System.Data;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using EKETEAM.Data;
using EKETEAM.FrameWork;
using System.Xml;


namespace eFrameWork.Manage
{
    public partial class TableInfo : System.Web.UI.Page
    {
        public string id = eParameters.Request("id");
        public string act = eParameters.Request("act");
        public string value = eParameters.Request("value");
        public string tbname = eParameters.Request("tbname");
        
        public string sql = "";
        public eUser user;
        protected void Page_Load(object sender, EventArgs e)
        {
            user = new eUser("Manage");
            #region 生成框架结构信息
            if (act == "createschema")
            {
                string basePath = Server.MapPath("~/upload/temp");
                if (!System.IO.Directory.Exists(basePath)) System.IO.Directory.CreateDirectory(basePath);
                basePath += "\\database_schema.xml";
                XmlDocument doc = new XmlDocument();
                DataTable dt = eBase.DataBase.getSchemaTables();
                foreach (DataRow dr in dt.Rows)
                {
                    string name = dr["value"].ToString();
                    if (!name.ToLower().StartsWith("a_eke_sys") && "organizationals,dictionaries".IndexOf(name.ToLower()) == -1) continue;
                    DataTable dt2 = eBase.DataBase.getSchemaColumns(name);
                    doc.appendModel(dt2);
                }
                eBase.WriteFile(basePath, doc.InnerXml);                
                Response.Redirect("TableInfo.aspx", true);
            }
            #endregion
            if (act == "delalltable")
            {
                foreach (DataRow dr in eBase.DataBase.getTables().Rows)
                {
                    //eOleDB.Execute("drop table " + dr["name"].ToString());
                }

                Response.Redirect("TableInfo.aspx", true);
            }
            if (act == "settabledescription")
            {
                eBase.DataBase.Execute("EXEC sys.sp_addextendedproperty N'MS_Description',N'" + value + "','user','dbo','table','" + tbname + "',NULL,NULL");
                eBase.DataBase.Execute("EXEC sys.sp_updateextendedproperty N'MS_Description',N'" + value + "','user','dbo','table','" + tbname + "',NULL,NULL");               
                eBase.End();
            }