Admins/AddTicket.aspx.cs

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

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

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 Admins_AddTicket : System.Web.UI.Page
{

    SqlHelper data = new SqlHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DropDownList1.DataSource = data.GetDataReader("select * from  JingDian ");
            DropDownList1.DataTextField = "Name";
            DropDownList1.DataValueField = "id";
            DropDownList1.DataBind();

            btn_value.Text = "添加";
            string action = Request.QueryString["Action"];
            if (action == "Add")
            {
                btn_value.Text = "添加";

            }
            else if (action == "Edit")
            {
                btn_value.Text = "编辑";
                // 当为编辑的时候取值
                string strID = Request["id"];
                SqlConnection SqlConn = new SqlConnection(SqlHelper.connstring);
                SqlConn.Open();
                SqlCommand comm = new SqlCommand("select * from Ticket WHERE id=" + strID, SqlConn);
                SqlDataReader dr = comm.ExecuteReader();
                if (dr.Read())
                DropDownList1.Items.FindByText(dr["JingDian"].ToString()).Selected = true;//选项Text  
                jiage.Text = dr["jiage"].ToString();
                ShuLiang.Text = dr["ShuLiang"].ToString();
                ArticleContent.Value = dr["Ds"].ToString();
                SqlConn.Close();
                dr.Close();
            }
        }
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string action = Request.QueryString["Action"].ToString();  // 判断Action


        if (action == "Add")  // 添加
        {
         
                SqlConnection SqlConn = new SqlConnection(SqlHelper.connstring);