shengaodetils.aspx.cs

毕业设计内容： 1、 作者投稿功能 2、 专家审稿 3、 系统管理员对所有稿件的管理功能 管理权限设置:分为三级权限。包括用户:添加文章、查询自己稿件的审稿情况、审稿意见、查看个人资料等 专家:审批文

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 admin_shengaodetils : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            if (Session["Expert_name"] != null)
            {
                this.Label1.Text = "你好" + Session["Expert_name"] + "欢迎你审理该类别的稿件";
               
                list();
            }
            else
            {
                Response.Write("<script language='javascript'>alert('你还没有登录或注册请和管理员联系获得登录帐号');location.href='../admin/ZhuanjiaLogin.aspx'</script>");

            }
            
        }

    }
    private void list()//显示详细信息
    {
        string id;//定义一个变量接收传过来的变量
        id = Request["id"].ToString();//给他副传过来的变量值
        SqlConnection con = db.ceratcon();
        con.Open();
        SqlCommand cmd = new SqlCommand("select *  from Efile  where Book_id='" + id + "'", con);//wher条件取出相应的内容
        cmd.Parameters.Add("@Bookid", SqlDbType.VarChar);
        cmd.Parameters["@Bookid"].Value = Request.QueryString["id"].ToString();
        SqlDataReader sdr = cmd.ExecuteReader();

        if (sdr.Read())
        {
            this.Laauthor.Text = Convert.ToString(sdr["Author"]);
            this.lablname.Text = Convert.ToString(sdr["Title"]);
            this.Labemal.Text = Convert.ToString(sdr["Author_email"]);
            this.Labdespristion.Text = Convert.ToString(sdr["Description"]);
            this.Laqclass.Text = Convert.ToString(sdr["File_class"]);


            Session["download"] = Convert.ToString(".." + "/" + sdr["File_path"]);


        }
        con.Close();

    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {

    }
    private void updata()//审核稿件
    {
        string name = this.lablname.Text;
        SqlConnection con = db.ceratcon();
        con.Open();
        SqlCommand cmd = new SqlCommand("update Efile set filepinglun=@filepinglun ,fileshenhe=@fileshenhe,filehege=@filehege  where Title='" + name + "'", con);
        cmd.Parameters.Add("@filepinglun",SqlDbType.VarChar);
        cmd.Parameters.Add("@fileshenhe",SqlDbType.VarChar);
        cmd.Parameters.Add("@filehege", SqlDbType.VarChar);
        cmd.Parameters["@filepinglun"].Value = this.TextBox1.Text;
        cmd.Parameters["@fileshenhe"].Value = "是";
        cmd.Parameters["@filehege"].Value = this.DropDownList1.SelectedItem.Text;
        cmd.ExecuteNonQuery();
       
        con.Close();
        Response.Write("<script language='javascript'>alert('审稿成功继续审稿');location.href='../admin/Zhuanjiashengao.aspx'</script>");

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        updata();
    }
}