ad88/sys/DbExec.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CSA.DAL;
public partial class admin_sys_DbExec : AdminPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        checkUserGoLogin();
        if (!Page.IsPostBack)
        {
            string type = Request.QueryString["type"];
            string sql = "";
            switch (type)
            {
                case "log":
                    sql = "DUMP TRANSACTION " + SqlHelper.getDataBaseName() + " WITH NO_LOG";
                    break;
                case "compress":
                    sql="DBCC SHRINKDATABASE("+SqlHelper.getDataBaseName()+")";
                    break;
            }
            this.txtSQL.Text = sql;
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        lblMsg.Text = "";
        string sql = txtSQL.Text.Trim();
        bool select = false;
        if (sql.StartsWith("select"))
        {
            select = true;
        }
        if (sql.StartsWith("Select"))
        {
            select = true;
        }
        if (sql.StartsWith("SELECT"))
        {
            select= true;
        }
        BLL.Sys.AdminLog.AddLog(Request.QueryString["mid"],Header.Title, "", null, "执行SQL", sql);
        if (select)
        {
            DataTable dt = DBAccess.getRS(sql);
            this.gvList.DataSource = dt;
            this.gvList.DataBind();
        }
        else
        {
            this.lblMsg.Text = "执行成功,影响行数:" + DBAccess.ExecuteNonQuery(sql);
        }