FLOWER/Admin/Content/AddType.aspx.cs

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

using Common;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace FLOWER.Admin.Content
{
    public partial class AddType : System.Web.UI.Page
    {
        SQLHelper sqlhelper = new SQLHelper();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                if (Request["action"].ToString() == "edit")
                {

                    string constring = SQL.constr;
                    SqlConnection str = new SqlConnection(constring);
                    str.Open();
                    string sqlstr = "select * from CurtainType where CurtainTypeId='" + Request["id"].ToString() + "'";
                    SqlDataAdapter myda = new SqlDataAdapter(sqlstr, str);
                    DataSet myds = new DataSet();
                    myda.Fill(myds, "CurtainType");
                    DataRowView mydrv = myds.Tables["CurtainType"].DefaultView[0];
                    TextBox1.Text = Convert.ToString(mydrv.Row["CurtainTypeName"]); 
                    str.Close();
                }
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (Request["action"].ToString() == "edit")
            {
                string sqlstr = "update CurtainType set CurtainTypeName='" + TextBox1.Text.Trim() + "' where CurtainTypeId='" + Request["id"].ToString() + "'";
                sqlhelper.ExecuteSql(sqlstr);
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), System.DateTime.Now.Ticks.ToString(), "layer.alert('操作成功！', {icon: 1,kin: 'layer-ext-moon',closeBtn: 0}, function () { location.href = 'TypeManage.aspx';})", true);

            }
            else
            {

                string sqlstr = "insert into CurtainType(CurtainTypeName)"
                        + " values('" + TextBox1.Text.Trim() + "')";
                    sqlhelper.ExecuteSql(sqlstr);
                    ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), System.DateTime.Now.Ticks.ToString(), "layer.alert('操作成功！', {icon: 1,kin: 'layer-ext-moon',closeBtn: 0}, function () { location.href = 'TypeManage.aspx';})", true);
                
            }
        }
    }
}