System/Sys_Member_Add.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;

public partial class System_Sys_Member_Add : System.Web.UI.Page
{
    protected string con = CommonLib.SqlHelper.SqlConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //CommonLib.SqlHelper.islogin(Page);
            Bind();
        }
    }
    public void Bind()
    {
        if (Request.QueryString["id"] != null)
        {
            string sql = "select * from member where m_id="+Request.QueryString["id"].ToString()+"";
            DataSet ds = new DBExec().Exeds(sql);
            if (ds.Tables[0].Rows.Count != 0)
            {
                txt_user.Text = ds.Tables[0].Rows[0]["m_name"].ToString();
                tel.Text = ds.Tables[0].Rows[0]["m_tel"].ToString();
                add.Text = ds.Tables[0].Rows[0]["m_add"].ToString();
                qq.Text = ds.Tables[0].Rows[0]["m_qq"].ToString();
                jq.Text = ds.Tables[0].Rows[0]["jq"].ToString();
               
            }

        }
    }
    #region 添加
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "";
        string n_pwd = txt_pwd.Text.Trim();
        if (Request.QueryString["id"] != null)
        {
            sql = "update  member set m_name='" + CommonLib.CutString.UrnHtml(txt_user.Text.Trim()) + "',m_pwd='" + n_pwd
                + "',m_tel='" + CommonLib.CutString.UrnHtml(tel.Text.Trim()) + "',m_add='"
                + CommonLib.CutString.UrnHtml(add.Text.Trim()) + "',m_qq='" + CommonLib.CutString.UrnHtml(qq.Text.Trim()) + "',jq='" + CommonLib.CutString.UrnHtml(jq.Text.Trim()) + "' where m_id="+Request.QueryString["id"].ToString()+"";
           
        }
        else
        {
            sql = "insert into member (m_name,m_pwd,m_tel,m_add,m_qq,jq) values ";
            sql += "('" + CommonLib.CutString.UrnHtml(txt_user.Text.Trim()) + "','" + n_pwd
                + "','" + CommonLib.CutString.UrnHtml(tel.Text.Trim()) + "','"
                + CommonLib.CutString.UrnHtml(add.Text.Trim()) + "','" + CommonLib.CutString.UrnHtml(qq.Text.Trim()) + "','" + CommonLib.CutString.UrnHtml(jq.Text.Trim()) + "')";
        }