bas/yjgl/Mini_Xyj_W.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Data.SqlClient;
using System.Net.Mail;
using System.Web.UI;
using System.Web.UI.WebControls;
using haoke365;

namespace hkpro.bas.yjgl
{
    public partial class Mini_Xyj_W : System.Web.UI.Page
    {
        BindData bd = new BindData();

        protected void Page_Load(object Sender, EventArgs E)
        {
            mydb hkdb = new mydb();
            hkdb.VeriSess("4");

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

                DropDownListBind();

                lblAttachSize.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT P_STRING FROM hk_CSDA WHERE PARAMT='fj_size'"));

                //邮箱
                SqlDataReader drMail = SqlHelper.ExecuteReader("SELECT * FROM hk_MySet WHERE FK_uid='" + this.Session["userid"] + "'");
                if (drMail.Read())
                {
                    lblQc.Text = drMail["mail_qc"].ToString();
                    lblSmtp.Text = drMail["mail_smtp"].ToString();
                    lblUser.Text = drMail["mail_dlyh"].ToString();
                    lblPwd.Text = drMail["mail_dlmm"].ToString();
                    lblPort.Text = drMail["mail_port"].ToString();
                    lblSender.Text = drMail["mail_fsr"].ToString();
                }
                drMail.Close();

                //判断调用页面
                switch (Request.QueryString["lx"])
                {
                    case "hy":
                        //从会员相关页面调用
                        string str1 = "";
                        if (!string.IsNullOrEmpty(Request.QueryString["tj"]))
                        {
                            SqlDataReader dr = SqlHelper.ExecuteReader("SELECT QTJ FROM HK_QUERY WHERE QID=" + Request.QueryString["tj"]);
                            if (dr.Read())
                            {
                                str1 = str1 + dr["qtj"].ToString();
                            }
                            dr.Close();
                        }

                        SqlDataReader datar = SqlHelper.ExecuteReader("SELECT TOP 1000 DZYJ FROM CR_HYDA A LEFT OUTER JOIN HK_ZDYLX B ON(A.HYLX=B.ID) WHERE DZYJ<>''" + str1);
                        while (datar.Read())
                        {
                            if (string.IsNullOrEmpty(sjr.Text))
                            {