DAL/LoginDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Common;
using Entitry;
using System.Data.SqlClient;

namespace DAL
{
    public class LoginDAL
    {
        public static List<Customer> CheckCustomer(Customer cust)
        {
           
            string sql = "select * from Customer where Email='" + cust.Email + "' and Password='" + cust.Password + "'";
            SqlDataReader dr = DBHelp.SelectData(sql);
            List<Customer> list = new List<Customer>();
            while (dr.Read())
            {
                Customer c = new Customer();
                c.Cid = (int)dr["Cid"];
                c.Name = (string)dr["Name"];
                c.Email = (string)dr["Email"];
                c.Password = (string)dr["Password"];
                c.Roleid = (int)dr["Roleid"];
                list.Add(c);
                
            }
            dr.Close();
            return list;
        }


        public static int register(Customer customer)
        {
            int result = 0;

            string sql1 = "select * from Customer where Email='" + customer.Email + "'";
            SqlDataReader dr = DBHelp.SelectData(sql1);
           

           
            
                if(dr.HasRows){


                }
                else
                {
                    string sql = "insert into Customer(Email,Password,Roleid)values('" + customer.Email + "','" + customer.Password + "','" + customer.Roleid + "')";
                    result = DBHelp.AddData(sql);

                }

                
          
            return result;