bas/xzgl/Wdyjx_View.aspx.cs

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

using System;
using System.Data.SqlClient;
using haoke365;

namespace hkpro.bas.xzgl
{
    public partial class Wdyjx_View : System.Web.UI.Page
    {
        public void Page_Load(object Sender, EventArgs E)
        {
            mydb hkdb = new mydb();
            hkdb.VeriSess("4");

            if (!IsPostBack)
            {
                hkdb.PassTo("10114", "0");

                SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM HK_WDYJ WHERE YJID='" + Request.QueryString["id"].ToString() + "'");
                if (datar.Read())
                {
                    yjbt.Text = datar["yjbt"].ToString();
                    nr.Value = datar["yjnr"].ToString();
                    fbsj.Text = string.Format("{0:d}", datar["fbsj"]);
                    fbr.Text = datar["fbr"].ToString();
                    savefj.Text = datar["fjmc"].ToString();
                    savelj.Text = datar["fjlj"].ToString();
                    savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"].ToString()) + (datar["fjmc"] == System.DBNull.Value ? "" : datar["fjmc"].ToString());
                    datar.Close();

                    //更改为已读 
                    SqlHelper.ExecuteSql("update hk_WDYJ set zt='1' where yjid='" + Request.QueryString["id"].ToString() + "'");
                }
                else
                {
                    datar.Close();
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该意见不存在，可能已被删除！'); window.close();<" + "/script>");
                }
            }
        }

        //删除 
        public void Del_Click(object Sender, EventArgs E)
        {
            if (!string.IsNullOrEmpty(savefj.Text))
            {
                System.IO.File.Delete(Server.MapPath(("../../" + savelj.Text + savefj.Text)));
            }

            SqlHelper.ExecuteSql("DELETE FROM HK_WDYJ WHERE YJID = '" + Request.QueryString["id"].ToString() + "'");
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('已成功删除数据！');window.opener.location.href='Wdyjx.aspx'; window.close();<" + "/script>");
        } 
    }
}