paperop.cs

学术会议在线投稿系统 fghgfhgfhgfhfgh

using System;
using System.Data;
using System.Configuration;
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.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

/// <summary>
/// Summary description for PaperOp
/// </summary>
public class PaperOp : DataAccess
{
    public int articleid;
    public PaperOp()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public int select_articleid_envoyer()
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_SelectArticleId";
        comm.Connection = conn;

        SqlDataAdapter sda = new SqlDataAdapter(comm);
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        try
        {
            sda.Fill(ds, "ArticleId_Submitpaper");
            dt = ds.Tables["ArticleId_Submitpaper"];
            foreach (DataRow dr in dt.Rows)
            {
                TableRow tr = new TableRow();
                for (int j = 0; j < dt.Columns.Count - 1; j++)
                    articleid = Convert.ToInt32(dr[0].ToString());



            }
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return 0;
        }
        conn.Close();

        return articleid;
    }

  // ArticleName, Subject, Writer, Abstract, Discipline, Keywords, ArticleUrl, Statics,
//ModNumber, SubmitDate

    public int insert_articles_envoyers(String ArticleName, String Subject,String Writer, String Abstract,String Discipline,
String Keywords, String ArticleUrl, String Statics, Int32 ModNumber,DateTime SubmitDate)
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_InsertPaper_Envoyers";
        comm.Connection = conn;
        comm.Parameters.Add("@ArticleName", SqlDbType.NVarChar).Value = ArticleName;
        comm.Parameters.Add("@Subject", SqlDbType.NVarChar).Value = Subject;
        comm.Parameters.Add("@Writer", SqlDbType.NVarChar).Value = Writer;
        comm.Parameters.Add("@Abstract", SqlDbType.NVarChar).Value = Abstract;
        comm.Parameters.Add("@Discipline", SqlDbType.NVarChar).Value = Discipline;
        comm.Parameters.Add("@Keywords", SqlDbType.NVarChar).Value = Keywords;
        comm.Parameters.Add("@ArticleUrl", SqlDbType.NVarChar).Value = ArticleUrl;
        comm.Parameters.Add("@Statics", SqlDbType.NVarChar).Value = Statics;
        comm.Parameters.Add("@ModNumber", SqlDbType.Int).Value = ModNumber;
        //comm.Parameters.Add("@ReturnMessage", SqlDbType.NVarChar).Value = ReturnMessage;
        comm.Parameters.Add("@SubmitDate", SqlDbType.DateTime).Value = SubmitDate;

        try
        {
            comm.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return 0;
        }

        conn.Close();
        return 1;
    }

    public int update_article_experts(String Statics,String ReturnMessage,DateTime FinishDate,Int32 ArticleId )
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_UpdateArticle_Experts";
        comm.Connection = conn;
        comm.Parameters.Add("@Statics", SqlDbType.NVarChar).Value = Statics;
        comm.Parameters.Add("@ReturnMessage", SqlDbType.NVarChar).Value = ReturnMessage;
        comm.Parameters.Add("@FinishDate", SqlDbType.DateTime).Value =FinishDate;
        comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
        try
        {
            comm.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return 0;
        }

        conn.Close();
        return 1;
    }
    public int update_articlestatic_experts(Int32 ArticleId)
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_UpdateArticle_Checking_Experts";
        comm.Connection = conn;;
        comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
        try
        {
            comm.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return 0;
        }

        conn.Close();
        return 1;

    }
    public int update_articlesassign_admin(Int32 ArticleId)
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_UpdatepaperAssign_Admin";
        comm.Connection = conn; ;
        comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
        try
        {
            comm.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return 0;
        }

        conn.Close();
        return 1;

    }

    public DataTable select_paperinformation_static(int ArticleId)
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_SelectPaperInformation_Static";
        comm.Connection = conn;
        SqlDataAdapter sda = new SqlDataAdapter(comm);
        sda.SelectCommand.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
        //定义一个数据集对象，并填充数据集
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        try
        {
            sda.Fill(ds, "PaperInformation");
            dt = ds.Tables["PaperInformation"];

        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return dt;
        }

        conn.Close();
        return dt;
    }

    public DataTable select_paperinformation_dynamic(int ArticleId)
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_SelectPaperInformation_Dynomic";
        comm.Connection = conn;
        SqlDataAdapter sda = new SqlDataAdapter(comm);
        sda.SelectCommand.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
        //定义一个数据集对象，并填充数据集
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        try
        {
            sda.Fill(ds, "PaperInformation");
            dt = ds.Tables["PaperInformation"];

        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return dt;
        }
        conn.Close();
        return dt;
  
    
    }

    public int update_article_envoyers(int ArticleId,String ArticleName, String Subject, String Writer, String Abstract, String Discipline,
String Keywords, String ArticleUrl, String Statics, Int32 ModNumber,DateTime SubmitDate)
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_UpdatePaper_Envoyers";
        comm.Connection = conn;
        comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value =ArticleId;
        comm.Parameters.Add("@ArticleName", SqlDbType.NVarChar).Value = ArticleName;
        comm.Parameters.Add("@Subject", SqlDbType.NVarChar).Value = Subject;
        comm.Parameters.Add("@Writer", SqlDbType.NVarChar).Value =Writer;
        comm.Parameters.Add("@Abstract", SqlDbType.NVarChar).Value =Abstract;
        comm.Parameters.Add("@Discipline", SqlDbType.NVarChar).Value = Discipline;
        comm.Parameters.Add("@Keywords", SqlDbType.NVarChar).Value =Keywords;
        comm.Parameters.Add("@ArticleUrl", SqlDbType.NVarChar).Value = ArticleUrl;
        comm.Parameters.Add("@Statics", SqlDbType.NVarChar).Value =Statics;
        comm.Parameters.Add("@ModNumber", SqlDbType.Int).Value = ModNumber;
        comm.Parameters.Add("@SubmitDate", SqlDbType.DateTime).Value =SubmitDate;
        try
        {
            comm.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return 0;
        }

        conn.Close();
        return 1;
    }
    public int  delete_paper_admin(int ArticleId)
    {
        SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_DeletePapers_Admin";
        comm.Connection = conn;
       comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
        try
        {
            comm.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return 0;
        }

        conn.Close();
        return 1;
           
    }
}