System/UserManager.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using ExtAspNet;

public partial class System_UserManager : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindDataGridView();
        }
    }
    protected void butQuery_Click(object sender, EventArgs e)
    {
        string strUserName = txtBoxUserName.Text.Trim();

        string strPwd = txtBoxPwd.Text.Trim();

        string strTrueName=txtBoxTrueName.Text.Trim();

        string strQX = userType.SelectedItem.Text;

        if (strUserName == "")
        {
            Alert.ShowInTop("请输入著作名字！");
            return;
        }

        if (strPwd == "")
        {
            Alert.ShowInTop("请输入用户密码！");
            return;
        }

        if (userType.SelectedIndex == 0)
        {
            Alert.ShowInTop("请选择用户类型！");
            return;
        }

        ExecuteSql exe = new ExecuteSql();

        DataTable dt = exe.execSQLTable(string.Format("select * from dbo.userList where username='{0}'", strUserName));

        if (dt!=null&& dt.Rows.Count>0)
        {
            Alert.ShowInTop("用户名已经存在，请换个用户名！");
            return;
        }

        string strSql = "INSERT INTO [userList]([UserLoginName],[UserPasswd],[userName],[specialColumn])";
        strSql = strSql + string.Format(" VALUES ('{0}','{1}','{2}','{3}')", strUserName, strPwd, strTrueName, strQX);

        if (exe.exeSQL(strSql) == 1)