freelabel_test.aspx.cs

来自「这也是关于论坛的一个源代码」· CS 代码 · 共 78 行

//===========================================================
//==     (c)2007 Foosun Inc. by dotNETCMS 1.0              ==
//==             Forum:bbs.foosun.net                      ==
//==            website:www.foosun.net                     ==
//==     Address:NO.109 HuiMin ST.,Chengdu ,China          ==
//==         TEL:[phone]                   ==
//==         TEL:[phone]                   ==
//==         qq:655071,MSN:[e-mail]               ==
//==               Code By JiangDong                       ==
//===========================================================
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 : Foosun.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
            {
                Foosun.CMS.FreeLabel fb = new Foosun.CMS.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();
        }
    }
}