addlink.aspx.cs

内容管理 内容管理 内容管理 内容管理 内容管理

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 System.Data.SqlClient;

public partial class WebPage_AddLink : System.Web.UI.Page
{
    String VirtualPath = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        //验证用户功能-------------------------------------------------
        this.ValidUserStation();
        //-------------------------------------------------------------

        //初始化功能权限列表(临时放在这里)
        if (!IsPostBack)
        {
            string strID = Request["ID"];												//链接ID
            string strFunID = Request["FunID"];

            if (strID == null || strID == "") { strID = "-1"; }
            if (strFunID == null || strFunID == "")
            {
                if (strID == null || strID == "")
                { strFunID = "2"; }
                else
                { strFunID = "1"; }
            }

            this.FunID.Value = strFunID;

            setControlAttributes();

            switch (strFunID.Trim())
            {
                case "1":			//查看
                    EditData(strID);												
                    break;
                case "2":			//新建
                    NewData(strID);													
                    break;
                default:			//新建
                    NewData(strID);													
                    break;
            }
        }
    }

    #region	初始控件选择状态
    /// <summary>
    /// 初始控件选择状态
    /// </summary>
    private void setControlAttributes()
    {
        this.LinkTitle.Attributes["onfocus"] = "javascript:this.select();";
        this.LinkUrl.Attributes["onfocus"] = "javascript:this.select();";

    }
    #endregion


    protected void btnSave_Click(object sender, EventArgs e)
    {
        string strUrl = "";

        //保存前检查当前用户是否保存的权限[新建、修改]
        string strStateMsg = "";
        if (this.FunID.Value.Trim() == "1")
        {
            if (this.hidIsModify.Value.ToLower() != "modify")
            { strStateMsg = "修改"; }
        }
        else if (this.FunID.Value.Trim() == "2")
        {

            if (this.hidIsNew.Value.ToLower() != "new")
            { strStateMsg = "新建"; }
        }
        else
        { return; }

        if (strStateMsg != "")
        {
            strUrl = "<script language='javascript'>"
                + "window.setTimeout(\"alert('您没有保存[" + strStateMsg + "]权限,如有需要请与系统管理员联系！')\", 100);"
                + "</script>";
            Response.Write(strUrl);
            return;
        }



        SaveData();
    }


    #region	保存[新建或更新]的链接
    /// <summary>
    /// 保存[新建或更新]的链接
    /// </summary>
    private void SaveData()
    {
        bool m_blnCheckValue = true;
        string m_strSQL = "";
        DataSet ds = new DataSet();
        DAL.boBusiness bo = new DAL.boBusiness();
        DAL.MakeConnection Conn = new DAL.MakeConnection();
        DAL.clsDBConnkey ConnKey = new DAL.clsDBConnkey();
        ConnKey = bo.loadkey();//得到config数据库连接
        SqlCommand o_CommData = new SqlCommand();

        switch (this.FunID.Value.Trim())
        {
            case "1":																				//查看编辑状态，更新所做的改动
                //检查必要的参数正确性(链接ID，链接ID不允许为空)

                if (this.Table_ID.Value.Trim() == "")						//[链接]ID
                {
                    m_blnCheckValue = false;
                    break;
                }
                //为更新链接生成SQL脚本
                //获取(Link)数据-----------------------------------------------------------
                //ID,LinkTitle,LinkImgUrl,LinkUrl,User_ID,ReleaseTime
                m_strSQL = "Update Link"
                    + " Set "
                    + "LinkTitle=@LinkTitle,"
                    + "LinkUrl=@LinkUrl";

                m_strSQL += " Where"
                    + " ID=@ID";

                o_CommData.CommandText = m_strSQL;
                o_CommData.Parameters.Clear();
                o_CommData.Parameters.Add("@ID", SqlDbType.NVarChar).Value = Convert.ToInt32(this.Table_ID.Value.Trim());
                o_CommData.Parameters.Add("@LinkTitle", SqlDbType.NVarChar).Value = this.LinkTitle.Text.Trim();
                o_CommData.Parameters.Add("@LinkUrl", SqlDbType.NVarChar).Value = this.LinkUrl.Text.Trim();



                break;
            case "2":																				//新建状态，将新[链接]插入数据库
                //为新建链接生成SQL脚本
                //获取(Link)数据-----------------------------------------------------------
                //ID,LinkTitle,LinkImgUrl,LinkUrl,User_ID,ReleaseTime
                m_strSQL = "Insert Into Link("
                    + "LinkTitle,LinkUrl,ReleaseTime "
                    + ")"
                    + " Values("
                    + "@LinkTitle,@LinkUrl,@ReleaseTime "
                    + ")";

                o_CommData.CommandText = m_strSQL;
                o_CommData.Parameters.Clear();
                o_CommData.Parameters.Add("@LinkTitle", SqlDbType.NVarChar).Value = this.LinkTitle.Text.Trim();
                o_CommData.Parameters.Add("@LinkUrl", SqlDbType.NVarChar).Value = this.LinkUrl.Text.Trim();
                o_CommData.Parameters.Add("@ReleaseTime", SqlDbType.DateTime).Value = System.DateTime.Now;

                //----------------------------------------------------------
                break;
        }

        string strErrMsg = "";
        try
        {
            //执行保存(新建、更新)
            if (m_blnCheckValue)
            {
                ds = (DataSet)Conn.MakeConnectionSqlCommand(o_CommData, ConnKey, DAL.executeMethod.execute_NoneQuery, DAL.EnumDBType.Sql);
                DataView m_DV = ds.Tables[0].DefaultView;
            }

        }
        catch (Exception es)
        {
            strErrMsg = es.Message;
            m_blnCheckValue = false;
        }


        //当保存成功后刷新界面
        if (m_blnCheckValue)
        {
            if (this.FunID.Value.Trim() == "1")
            {
                Response.Redirect("Link.aspx");
            }
            else
            {
                Response.Redirect("AddLink.aspx?ID=&FunID=2", true);
            }
        }
    }
    #endregion


    protected void btnReturn_Click(object sender, EventArgs e)
    {
        Response.Redirect("Link.aspx", true);
    }


    #region 查看并编辑链接
    /// <summary>
    /// 查看并编辑链接
    /// </summary>
    /// <param name="str_ID">链接ID</param>
    private void EditData(string str_ID)
    {
        string m_strID = str_ID;
        DataSet ds = new DataSet();
        DAL.boBusiness bo = new DAL.boBusiness();
        DAL.MakeConnection Conn = new DAL.MakeConnection();
        DAL.clsDBConnkey ConnKey = new DAL.clsDBConnkey();
        ConnKey = bo.loadkey();//得到config数据库连接

        try
        {
           
            string m_strSQL = "Select * From Link  where ID=" + str_ID;
            //-------------------------------------------------------------------------------------------------------
            ds = (DataSet)Conn.MakeConnectionMethod(m_strSQL, ConnKey, DAL.executeMethod.execute_DataSet, DAL.EnumDBType.Sql, VirtualPath);
            DataView m_DV = ds.Tables[0].DefaultView;
            //-----------------------------------------------------------------------

            //初始化链接编辑界面-----------------------------------------------------
            if (m_DV.Count > 0)
            {
                this.labFunState.Text = "查看&编辑<font color='gray'>『" + m_DV[0].Row["LinkTitle"].ToString() + "』</font>";
                this.imgState.Src = "../../Images/Face/Modify.gif";
                //获取(Link)数据-----------------------------------------------------------
                //ID,LinkTitle,LinkImgUrl,LinkUrl,User_ID,ReleaseTime,ImgData
                this.FunID.Value = "1";
                this.Table_ID.Value = str_ID;

                this.LinkTitle.Text = m_DV[0].Row["LinkTitle"].ToString();
                this.LinkUrl.Text = m_DV[0].Row["LinkUrl"].ToString();

            }
            else
            {
                this.labFunState.Text = "查看&编辑<font color='gray'>『链接信息』</font>";
                this.imgState.Src = "../../Images/Face/Modify.gif";
            }
        }
        catch (System.Exception ex)
        {
            throw ex;
        }
        //-----------------------------------------------------------------------
    }
    #endregion

    #region 新建链接
    /// <summary>
    /// 新建链接
    /// </summary>
    private void NewData(string str_ID)
    {
        //初始化链接编辑界面-------------------------

        try
        {
            this.labFunState.Text = "新建<font color='gray'>『链接』</font>";
            this.imgState.Src = "../../Images/Face/New.gif";

            //获取(Link)数据-----------------------------------------------------------
            //ID,LinkTitle,LinkImgUrl,LinkUrl,User_ID,ReleaseTime
            this.FunID.Value = "2";
            this.Table_ID.Value = str_ID;

            this.LinkTitle.Text = "";
            this.LinkUrl.Text = "";
        }
        catch
        { }
        //-------------------------------------------
    }
    #endregion



    /// <summary>
    /// 验证用户身份
    /// </summary>
    /// <returns></returns>
    private void ValidUserStation()
    {
        string userid = "";
        HttpCookie Cookie = CheckLogin();

        if (Cookie != null)
        {
            userid = Cookie["User_ID"].ToString();

        }

        else
        {
            Response.Write("<script language='javascript'>window.setTimeout(\" alert('您必须登陆才可以留言！')\",100);</script>");
            return;

        }
        
        if (userid != "")
        {
            this.hidIsModify.Value = "modify";
            this.hidIsNew.Value = "new";
        }
        else
        {
            ShowPrompt();
        }
    }

    private void ShowPrompt()
    {
        string strUrl = "<script language='javascript'>"
            + "window.setTimeout(\"alert('系统检查到[会话已过期]或[您尚未登录],将自动转到登录页面！')\", 100);"
            + "</script>";
        Response.Write(strUrl);

        strUrl = "<script language='javascript'>"
            + "window.open("
            + "\"../default.aspx\","
            + "\"_top\","
            + "\"\""
            + ",true);"
            + "</script>";
        Response.Write(strUrl);
        Response.End();
        return;
    }

    #region CheckLogin()//个人用户是否登录<返回一个HttpCookie>
    /// <summary>
    /// 是否登录
    /// </summary>
    /// <returns></returns>
    private HttpCookie CheckLogin()
    {

        HttpCookie Cookie = Request.Cookies["Message"];
        HttpCookie retCookie = null;
        if (Cookie == null || Cookie.ToString() == "")
        {
            return retCookie;
        }
        else
        {
            retCookie = Request.Cookies["Message"];
            return retCookie;
        }

    }
    #endregion


}