freelabel_test.aspx.cs

最好用的站点内容管理系统 全部源代码都有

//======================================================
//==     (c)2008 aspxcms inc by NeTCMS v1.0              ==
//==          Forum:bbs.aspxcms.com                   ==
//==         Website:www.aspxcms.com                  ==
//======================================================
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;

public partial class manage_label_FreeLabel_Test : NetCMS.Web.UI.ManagePage
{
    public manage_label_FreeLabel_Test()
    {
        Authority_Code = "T008";
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.ServerVariables["HTTP_REFERER"] != null && !Request.ServerVariables["HTTP_REFERER"].ToString().Equals(""))
        {
            string Path = Request.ServerVariables["HTTP_REFERER"].ToString();
            string Pg = Path.Substring(Path.LastIndexOf("/") + 1);
            if (Pg.IndexOf("?") > 0)
                Pg = Pg.Substring(0, Pg.IndexOf("?"));
            if (!Pg.Equals("FreeLabel_Add.aspx"))
            {
                Response.End();
            }
            if (Request.Form["TxtSQL"] == null)
            {
                Response.End();
            }
            string sql = Request.Form["TxtSQL"].Trim();
            if (sql.Equals(""))
            {
                this.LblError.Text = "错误,SQL语句为空!";
            }
            else
            {
                NetCMS.Content.FreeLabel fb = new NetCMS.Content.FreeLabel();
                try
                {
                    DataTable tb = fb.TestSQL(sql);
                    if (tb == null || tb.Rows.Count < 1)
                    {
                        this.LblError.Text = "记录数为0";
                    }
                    else
                    {
                        this.GrvData.DataSource = tb;
                        this.GrvData.DataBind();
                        this.LblError.Visible = false;
                    }
                }
                catch (Exception ex)
                {
                    this.LblError.Text = ex.Message;
                }
            }
        }
        else
        {
            Response.End();
        }
    }
}