companygai.aspx.cs

大中型酒店管理系统

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class companygai : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection Conn = db.createconn();

        Conn.Open();
        SqlCommand cmd1 = new SqlCommand("select count(*) from company",Conn);
        int count = Convert.ToInt32(cmd1.ExecuteScalar());
        if (count > 0)
        {

            SqlCommand Cmd = new SqlCommand("select * from company", Conn);



            SqlDataReader Dr = Cmd.ExecuteReader();

            if (Dr.Read())
            {
                txtname.Text = Dr["name"].ToString();
                txtcontent.Text = Dr["content"].ToString();
            }
        }
        else
        {
            Response.Write("<script language='javascript'>alert('请您先添加信息');history.back(-1);</script>");

        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string nm = txtname.Text;
        string neirong = txtcontent.Text;

        string fullFileName = this.File1.PostedFile.FileName;
        string fileName = fullFileName.Substring(fullFileName.LastIndexOf("\\") + 1);

        SqlConnection Conn = db.createconn();

        Conn.Open();
        if (fileName != "")
        {
            this.File1.PostedFile.SaveAs(Server.MapPath("logo") + "\\" + fileName);
            SqlCommand Cmd = new SqlCommand("update company set name='" + nm + "',content='" + neirong + "',pic='" + fileName + "'", Conn);

            Cmd.ExecuteNonQuery();

            Response.Write("<script language='javascript'>alert('修改成功');history.back(-1);</script>");

            Conn.Close();
        }
        else
        {

            SqlCommand Cmd = new SqlCommand("update company set name='" + nm + "',content='" + neirong + "'", Conn);

            Cmd.ExecuteNonQuery();

            Response.Write("<script language='javascript'>alert('修改成功');history.back(-1);</script>");
            Conn.Close();
        }
    }
}