uploadwenxian.aspx.cs

图书馆的图书管理

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

        if (Session["aname"] == null)
        {
            Response.Write("<script language='javascript'>alert('您还没有注册或登陆');location.href='../admin/AdminLogin.aspx'</script>");

        }
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        lb.Text = GetChineseSpell(this.txtname.Text);
        addwenxian();
       
    }
    private void addwenxian()//添加期刊
    {
        try
        {

            string Fullname = this.FileUpload1.FileName;
            string Type = Fullname.Substring(Fullname.LastIndexOf(".") + 1);
            string Wpath = "文献\\" + Fullname;
            if (Type == "pdf" || Type == "doc" || Type == "caj")
            {
                this.FileUpload1.SaveAs(Server.MapPath("文献") + "\\" + Fullname);



            }
            else
            {
                Response.Write("<script language='javascript'>alert('你上传的文献格式有错误！')</script>");
            }

            SqlConnection con = db.ceratcon();
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = (SqlConnection)con;
            cmd.CommandText = "insert into Book (Bookname,Author,Abstract,Keywords,Pubtime,Qkname,Location,Code,Class)values(@Bookname,@Author,@Abstract,@Keywords,@Pubtime,@Qkname,@Location,@Code,@Class)";
            cmd.Parameters.Add("@Bookname", SqlDbType.VarChar);
            cmd.Parameters.Add("@Author", SqlDbType.VarChar);
            cmd.Parameters.Add("@Abstract", SqlDbType.VarChar);
            cmd.Parameters.Add("@Keywords", SqlDbType.VarChar);
            cmd.Parameters.Add("@Pubtime", SqlDbType.DateTime);
            cmd.Parameters.Add("@Qkname", SqlDbType.VarChar);
            cmd.Parameters.Add("@Location", SqlDbType.VarChar);
            cmd.Parameters.Add("@Code", SqlDbType.Char);
            cmd.Parameters.Add("@Class", SqlDbType.VarChar);


            cmd.Parameters["@Bookname"].Value = this.txtname.Text;
            cmd.Parameters["@Author"].Value = txtauthor.Text;
            cmd.Parameters["@Abstract"].Value = txtabstract.Text;
            cmd.Parameters["@Keywords"].Value = txtkeywords.Text;
            cmd.Parameters["@Pubtime"].Value = txttime.Text;
            cmd.Parameters["@Qkname"].Value = txtqkname.Text;
            cmd.Parameters["@Location"].Value = Wpath.ToString();
            cmd.Parameters["@Code"].Value = this.lb.Text;
            cmd.Parameters["@Class"].Value = this.DropDownList1.SelectedItem.Text;
            cmd.ExecuteNonQuery();
            con.Close();

            Response.Write("<script language='javascript'>alert('添加成功！')</script>");

            this.txtname.Text = "";

            txtauthor.Text = "";
            txtabstract.Text = "";
            txtkeywords.Text = "";
            txttime.Text = "";
            txtqkname.Text = "";
        }
        catch(Exception ex)
        { Response.Write(ex.Message); }
    }
    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        this.txttime.Text = Convert.ToString(this.Calendar1.SelectedDate);
    }
    protected string GetChineseSpell(string strText)
    {
        //获得文献名字的首字母拼音
        int len =strText.Length;
        string myStr = "";
        if (len > 0)
        {

            for (int i = 0; i < len; i++)
            {
                myStr += getSpell(strText.Substring(i, 1));
            }
            //return myStr;可以返回每个字的首拼音 
            return (myStr.Substring(0, 1));
        }
        return myStr;
    }

    protected string getSpell(string cnChar)
    {
        byte[] arrCN = System.Text.Encoding.Default.GetBytes(cnChar);
        if (arrCN.Length > 1)
        {
            int area = (short)arrCN[0];
            int pos = (short)arrCN[1];
            int code = (area << 8) + pos;
            int[] areacode = { 45217, 45253, 45761, 46318, 46826, 47010, 47297, 47614, 48119, 48119, 49062, 49324, 49896, 50371, 50614, 50622, 50906, 51387, 51446, 52218, 52698, 52698, 52698, 52980, 53689, 54481 };
            for (int i = 0; i < 26; i++)
            {
                int max = 55290;
                if (i != 25)
                {
                    max = areacode[i + 1];
                }
                if (areacode[i] <= code && code < max)
                {
                    return System.Text.Encoding.Default.GetString(new byte[] { (byte)(65 + i) });
                }
            }
            return "*";
        }
        else return cnChar;
    }
   
}