Admin/webset.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;

public partial  class Admin_webset : System.Web.UI.Page
{
    SqlData da = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            setWebSite();
        }
    }

    private void setWebSite()
    {
        string sql = @"select * from [dbo].[websit]";
        SqlDataReader read = da.ExecuteRead(sql);
        if (read.Read())
        {
            jifen1.Value = "" + read["jifen1"];
            jifen2.Value = "" + read["jifen2"];
            hidid.Value = "" + read["id"];
        }
        read.Close();
    }

    protected void BtnBookTypeSave_Click(object sender, EventArgs e)
    {
        var id = hidid.Value;
        string sql = @"insert into [dbo].[websit] values(" + jifen1.Value + "," + jifen2.Value + ")";
        if (id != "0")
        {
            sql = @"update websit set jifen1=" + jifen1.Value + ",jifen2=" + jifen2.Value + " where id = " + id;
        }
        da.ExecuteSQL(sql);

        Common.ShowMessage.Show(Page, "Suess", "设置成功..");
    }
}