Asp.Net添加信息的几种方法

第一种

DAL层
        public static void AddUserMessage(string name,string pwd)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into My_UserMessage(");
                strSql.Append("uname,password)");
                strSql.Append(" values (");
                strSql.Append("'" + name + "',");
                strSql.Append("'" + pwd + "'");
                strSql.Append(")");
                DBHelper.ExecuteCommand(strSql.ToString());
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

BLL层
public static void AddUserMessage(string name, string pwd)
{
UserService.AddUserMessage(name,pwd);
}

Web层
string Uname = this.txtUsername.Text.Trim();
string Password = this.txtPWD.Text.Trim();
UserManager.AddUserMessage(Uname, Password);

*********************************************************************************************************************************************
第二种

DAL层
        public static int AddUser(UserMessage message)
        {
            string sql ="INSERT My_UserMessage (uname, password) VALUES (@uname, @password)";
            sql += " ; SELECT @@IDENTITY";
            try
            {
                SqlParameter[] para = new SqlParameter[]
                {
                    new SqlParameter("@uname", message.Uname),
                    new SqlParameter("@password", message.Password)
                };
                int newId = DBHelper.GetScalar(sql, para);
                return newId;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }

BLL层
public static void AddUser(UserMessage u)
{
UserService.AddUser(u);
}      
Web层
UserMessage u = new UserMessage();
u.Uname = this.txtUsername.Text.Trim();
u.Password = this.txtPWD.Text.Trim();
UserManager.AddUser(u);

*********************************************************************************************************************************************
第三种

DAL层
        public static void AddUser(UserMessage message)
        {
            string sql = "INSERT My_UserMessage (uname, password) VALUES (@uname, @password)";
            sql += " ; SELECT @@IDENTITY";
            try
            {
                SqlParameter[] para = new SqlParameter[]
                {
                    new SqlParameter("@uname", message.Uname),
                    new SqlParameter("@password", message.Password)
                };
                DBHelper.GetScalar(sql, para);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }

BLL层
public static void AddUser(UserMessage message)
{
        UserService.AddUser(message);
}
Web层
UserMessage u = new UserMessage();
u.Uname = this.txtUsername.Text.Trim();
u.Password = this.txtPWD.Text.Trim();
UserManager.AddUser(u);

*********************************************************************************************************************************************
第四种

DAL层
        public static void AddUser(UserMessage message)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into My_UserMessage(");
                strSql.Append("uname,password)");
                strSql.Append(" values (");
                strSql.Append("@uname,@password)");

                SqlParameter[] parameters =
                {
                         new SqlParameter("@uname", SqlDbType.VarChar,100),
                         new SqlParameter("@password", SqlDbType.VarChar,100)
                };
                parameters[0].Value = message.Uname;
                parameters[1].Value = message.Password;

                DBHelper.GetScalar(strSql.ToString(), parameters);
            }
            catch (Exception ex)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }

BLL层
public static void AddUser(UserMessage message)
{
      UserService.AddUser(message);
}
Web层
UserMessage u = new UserMessage();
u.Uname = this.txtUsername.Text.Trim();
u.Password = this.txtPWD.Text.Trim();
UserManager.AddUser(u);

*********************************************************************************************************************************************
第五种

DAL层

        public static void Add(UserMessage message)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into My_UserMessage(");
                strSql.Append("uname,password)");
                strSql.Append(" values (");
                strSql.Append("@uname,@password)");
                SqlParameter[] parameters =
                {
                       new SqlParameter("@uname", SqlDbType.VarChar,100),
                       new SqlParameter("@password", SqlDbType.VarChar,100)
                };
                parameters[0].Value = message.Uname;
                parameters[1].Value = message.Password;

                DBHelper.ExecuteCommand(strSql.ToString(), parameters);
            }
            catch (Exception ex)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }

BLL层
public static void Add(UserMessage message)
{

      UserService.Add(message);

}
Web层
UserMessage u = new UserMessage();
u.Uname = this.txtUsername.Text.Trim();
u.Password = this.txtPWD.Text.Trim();
UserManager.Add(u);