user_add.aspx.cs

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

using System;
using System.Text;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;


	/// <summary>
	/// Reg 的摘要说明。
	/// </summary>
	public partial class User_add  : Sp.baseadmin
	{
	
		protected override void Page_Load(object sender, System.EventArgs e)
        {
            base.Page_Load(sender, e);
            if (!IsPostBack)
            {
                //binddr();
            }
		}
        //void binddr()
        //{
        //     Sp.predroplist pr = new Sp.predroplist();
        //    pr.bindGroup(this.DropDownList1,"0");
        //}
        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).ToString();
           AddCard(idname);
           MessageBox.ShowAndRedirect(this, "添加成功！", "user_add.aspx");

        }
        public void AddCard(string idname)
        {
            string strWhere = "idname='"+idname+"'";
            StringBuilder strSql1 = new StringBuilder();
            strSql1.Append("select [id]");
            strSql1.Append(" FROM Sp_user ");
            if (strWhere.Trim() != "")
            {
                strSql1.Append(" where " + strWhere);
            }
            DataSet ds = Sp.SQLServerDAL.DbHelperSQL.Query(strSql1.ToString());
            int uid = int.Parse(ds.Tables[0].Rows[0][0].ToString());
            
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Sp_card(");
            strSql.Append("foruserid,num,cardtype)");
            strSql.Append(" values (");
            strSql.Append("@foruserid,@num,@cardtype)");
            SqlParameter[] parameters = {
					new SqlParameter("@foruserid", SqlDbType.Int,4),
					new SqlParameter("@num", SqlDbType.Int,4),
					new SqlParameter("@cardtype", SqlDbType.Int,4)};
            parameters[0].Value = uid;
            parameters[1].Value = int.Parse(TextBoxnum.Text);
            parameters[2].Value = RadioButtonList1.SelectedValue;

            Sp.SQLServerDAL.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }

}