regedit.aspx.cs

网博Fms在线直播系统 本程序基于fms2.0为核心的实时直播系统

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
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 regedit : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        Add();
    }
    /// <summary>
    /// 增加一条数据
    /// </summary>
    public void Add()
    {
        /******************************增加窗体代码********************************/
        string idname = this.txtidname.Text;
        string idpass = this.txtidpass.Text;
        string username = this.txtusername.Text;
        int ParentId = 0;

        decimal gufen = 0;
        decimal pay = 0;
        DateTime EndTime = DateTime.Now;

        Sp.BLL.Sp_user userdll = new Sp.BLL.Sp_user();

        string strErr = "";
        if (idname == "")
        {
            strErr += "用户名不能为空！\\n";
        }
        if (idpass == "")
        {
            strErr += "密码不能为空！\\n";
        }
        if (username == "")
        {
            strErr += "会员名称不能为空！\\n";
        }

        if (userdll.ExistsUser(idname))
        {
            strErr += "您要添加的用户名已经存在，请重新输入！\\n";
        }
        if (strErr != "")
        {
            MessageBox.Show(this, strErr);
            return;
        }

        idpass = Sp.Functions.Encrypt(idpass, 1);
        int Jb = 0;


        StringBuilder strSql = new StringBuilder();
        strSql.Append("insert into Sp_user(");
        strSql.Append("idname,idpass,username,ParentId,Jb,Rank,zhuangtai,gufen,pay,Truemoney,EndTime)");
        strSql.Append(" values (");
        strSql.Append("@idname,@idpass,@username,@ParentId,@Jb,@Rank,@zhuangtai,@gufen,@pay,@Truemoney,@EndTime)");
        SqlParameter[] parameters = {
					new SqlParameter("@idname", SqlDbType.VarChar,50),
					new SqlParameter("@idpass", SqlDbType.VarChar,50),
					new SqlParameter("@username", SqlDbType.VarChar,50),
					new SqlParameter("@ParentId", SqlDbType.Int,4),
					new SqlParameter("@Jb", SqlDbType.Int,4),
					new SqlParameter("@Rank", SqlDbType.Int,4),
					new SqlParameter("@zhuangtai", SqlDbType.Bit,1),
					new SqlParameter("@gufen", SqlDbType.Float,8),
					new SqlParameter("@pay", SqlDbType.Float,8),
					new SqlParameter("@Truemoney", SqlDbType.Float,8),
					new SqlParameter("@EndTime", SqlDbType.DateTime)};
        parameters[0].Value = idname;
        parameters[1].Value = idpass;
        parameters[2].Value = username;
        parameters[3].Value = ParentId;
        parameters[4].Value = Jb;
        parameters[5].Value = 0;
        parameters[6].Value = 1;
        parameters[7].Value = gufen;
        parameters[8].Value = pay;
        parameters[9].Value = 0;
        parameters[10].Value = EndTime;

        Sp.SQLServerDAL.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        MessageBox.ShowAndRedirect(this, "添加成功！", "Default.aspx");

    }
}