Essay/AuthorIndex.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 System.Data;

namespace Essay
{
    public partial class AuthorIndex : System.Web.UI.Page
    {
        public string sql = "Data Source=. ;Trusted_Connection=SSPI;Initial Catalog=Essay";
        protected void Page_Load(object sender, EventArgs e)
        {    
            string CID=Session["AuthorID"].ToString();
            SqlConnection conn = new SqlConnection(sql);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select Status from Authors where AuthorID='"+CID+"'";
            SqlDataReader dr = cmd.ExecuteReader();
            dr.Read();
            string status = dr["Status"].ToString();
                this.ApplyStatus.Visible = false;
                this.AbstractSatus.Visible = false;
                this.EssayStatus.Visible = false;
                this.LStatus.Text = status;
                if (status == "已报名")
                {
                    this.ApplyStatus.Visible = true;
                }
                else if (status == "已完成摘要投稿")
                {
                    this.AbstractSatus.Visible = true;
                }
                else {

                    this.EssayStatus.Visible = true;
                }


            
        }
 
    }
}