WorkManage/Seal/SignetAudi_Do.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using haoke365;

namespace hkoa.WorkManage.Seal
{
    public partial class SignetAudi_Do : System.Web.UI.Page
    {
        mydb hkdb = new mydb();
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc FROM hk_Seal A LEFT OUTER JOIN yh B ON(A.sUser=B.ui_id) WHERE sID='" + hkdb.GetFormatStr(Request.QueryString["id"]) + "' AND sStatus='待审'");
            if (datar.Read())
            {
                lblsName.Text = datar["sName"].ToString();
                lblsType.Text = datar["sType"].ToString();
                lblsStatus.Text = datar["sStatus"].ToString();
                lbluID.Text = datar["sUser"].ToString();
                lblsUser.Text = (datar["ui_desc"] == System.DBNull.Value ? "" : datar["ui_desc"].ToString());
                lblsRemark.Text = hkdb.TbToLb(datar["sRemark"].ToString());
                sPicNewName.ImageUrl = "../../Attach/Seal/" + datar["sPicNewName"].ToString();
                datar.Close();
            }
        }

        public void AudiY_Click(object Sender, EventArgs E)
        {
            SqlDataReader dr = SqlHelper.ExecuteReader("Update hk_Seal SET sStatus='正常' WHERE sID='" + hkdb.GetFormatStr(Request.QueryString["id"]) + "'");

            SqlHelper.ExecuteSql("exec sp_Send_Mess 1,0,'" + this.Session["userid"] + "','" + lbluID.Text + "','请注意，您的[" + lblsName.Text + "]印章已经通过审批。'");

            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('审批成功！');location.href='SignetAudi.aspx';<" + "/script>");
        }

        public void AudiN_Click(object Sender, EventArgs E)
        {
            SqlDataReader dr = SqlHelper.ExecuteReader("Update hk_Seal SET sStatus='退回' WHERE sID='" + hkdb.GetFormatStr(Request.QueryString["id"]) + "'");

            SqlHelper.ExecuteSql("exec sp_Send_Mess 1,0,'" + this.Session["userid"] + "','" + lbluID.Text + "','请注意，您的[" + lblsName.Text + "]印章已经被审批退回。'");

            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('审批退回！');location.href='SignetAudi.aspx';<" + "/script>");
        }
    }
}