admin/type_one/sisu_up.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;

namespace web.admin.type_one
{
    public partial class sisu_up : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                if (Request.QueryString["id"] != null)
                {
                    int uid = Convert.ToInt32(Request.QueryString["id"]);
                    string sqlstring = "select * from type where id=" + uid.ToString();
                    using (DataTable dt = new AcsHelper().ExecuteDataTable(sqlstring))
                    {
                        foreach (DataRow r in dt.Rows)
                        {
                            this.TextBox3.Text = r["type_name"].ToString();
                        }
                    }
                }
                else 
                {
                    this.Button1.Text = " 增加 ";
                }
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string t1 = this.TextBox3.Text;

            int px = 1;

            string stg = "select MAX(px) FROM type";
            string ob = new AcsHelper().ExecuteScalar(stg);
            if (ob != "")
            {
                px = (Convert.ToInt32(ob)) + 1;
            }

            OleDbParameter[] sp = new OleDbParameter[] { 
                new OleDbParameter("@type_name",t1),
                new OleDbParameter("@px",px.ToString()),
            };
            string sqlstring = string.Empty;

            if (Request.QueryString["id"] != null)
            {
                int uid = Convert.ToInt32(Request.QueryString["id"]);
                sqlstring = "update type set type_name=@type_name where id=" + uid.ToString();
            }
            else