FormDesign/system/elements/loaddata.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Text;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

using BLL;
using Model;
using Common;

namespace FormDesign.system.elements
{
    public partial class loaddata : System.Web.UI.Page
    {
        BllTbDatabase bllDB = new BllTbDatabase();

        protected void Page_Load(object sender, EventArgs e)
        {
            AjaxPro.Utility.RegisterTypeForAjax(typeof(loaddata));//注册
            DataSet ds = bllDB.GetAllList();
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                //加载库
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    ListItem li = new ListItem();
                    li.Value = dr["id"].ToString();
                    li.Text = dr["title"].ToString();
                    this.SelDB.Items.Add(li);
                }
                //加载表
                TbDatabase TbDB = new TbDatabase();
                TbDB = bllDB.GetModel(Convert.ToInt16(ds.Tables[0].Rows[0]["id"].ToString()));
                Dictionary<string, string> list = DataHelp.GetListTables(TbDB);
                if (list != null && list.Count > 0)
                {
                    string firstTB = "";
                    foreach (KeyValuePair<string, string> vp in list)
                    {
                        if (firstTB == "")
                        {
                            firstTB = vp.Key;
                        }
                        ListItem li = new ListItem();
                        li.Value = vp.Key;
                        li.Text = vp.Key;
                        this.SelTB.Items.Add(li);
                    }
                    //加载字段
                    List<string> lt =new  List<string>();
                    lt = DataHelp.GetListFileds(TbDB,firstTB);
                    if (lt != null && lt.Count > 0)
                    {
                        int cols = lt.Count / 4 + 1;
                        StringBuilder sb = new StringBuilder();
                        sb.Append("<table  width=\"100%\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"gridtable\">");
                        int j = 0;