DAL/bank_Dal.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Model;
namespace DAL
{
    public class bank_Dal
    {
        //获取链接字符
        public string connSql = ConfigurationManager.ConnectionStrings["conn"].ToString();



        /// <summary>
        /// 添加用户
        /// </summary>
        /// <param name="model1"></param>
        /// <returns>bool</returns>
        public bool AddUserName(bank_Model model1)
        {
            string sql = "insert into UserInfo values(@id,@idName,@idPwd,@idper,@idSex,@idtell,@idEmail,@idBlance,@idType)";

            SqlConnection conn = new SqlConnection(connSql);

            conn.Open();

            SqlCommand cm = new SqlCommand(sql, conn);

            cm.Parameters.Add(new SqlParameter("@id", model1.Id));
            cm.Parameters.Add(new SqlParameter("@idName", model1.Name));
            cm.Parameters.Add(new SqlParameter("@idPwd", model1.Pwd)); 
            cm.Parameters.Add(new SqlParameter("@idper", model1.Persenid));
            cm.Parameters.Add(new SqlParameter("@idSex", model1.Sex));
            cm.Parameters.Add(new SqlParameter("@idtell", model1.Tell));
            cm.Parameters.Add(new SqlParameter("@idEmail", model1.Email));
            cm.Parameters.Add(new SqlParameter("@idBlance", model1.Blance));
            cm.Parameters.Add(new SqlParameter("@idType", model1.Type));

            int count = cm.ExecuteNonQuery();

            if (count > 0)
            {
                return true;

            }
            else
            {
                return false;
            }
            
        }


        /// <summary>
        /// 用户登陆、注册判断