RM.Web/RMBase/SysDataCenter/SQLQuery.aspx.cs

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

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

using RM.Busines;
using RM.Common.DotNetUI;
using RM.Web.App_Code;
using System;
using System.Data;
using System.Text;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
namespace RM.Web.RMBase.SysDataCenter
{
    public class SQLQuery : PageBase
    {
        public string _Table_Name;
        protected HtmlForm form1;
        protected HtmlSelect Execute_Type;
        protected LinkButton ExeOuter;
        protected HtmlTextArea txtSql;
        protected GridView Grid;
        protected void Page_Load(object sender, EventArgs e)
        {
            this._Table_Name = base.Server.UrlDecode(base.Request["Table_Name"]);
            if (!base.IsPostBack)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("消息提示", Type.GetType("System.String"));
                DataRow row = dt.NewRow();
                row["消息提示"] = "未执行SQL命令!";
                dt.Rows.Add(row);
                ControlBindHelper.BindGridViewList(dt, this.Grid);
            }
        }
        protected void ExeOuter_Click(object sender, EventArgs e)
        {
            StringBuilder strSql = new StringBuilder(this.txtSql.Value);
            if (this.Execute_Type.Value == "1")
            {
                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);
                if (dt != null)
                {
                    if (dt.Rows.Count != 0)
                    {
                        ControlBindHelper.BindGridViewList(dt, this.Grid);
                    }
                    else
                    {
                        dt = new DataTable();
                        dt.Columns.Add("消息提示", Type.GetType("System.String"));
                        DataRow row = dt.NewRow();
                        row["消息提示"] = "没有找到您要的相关数据";
                        dt.Rows.Add(row);
                        ControlBindHelper.BindGridViewList(dt, this.Grid);
                    }
                }
                else
                {
                    dt = new DataTable();
                    dt.Columns.Add("消息提示", Type.GetType("System.String"));
                    DataRow row = dt.NewRow();
                    row["消息提示"] = "执行SQL命令,有错误!";
                    dt.Rows.Add(row);