CRM_DAL/Customers_Dal.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using CRM_Model;

namespace CRM_DAL
{
    public class Customers_Dal
    {
        static string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

        //public static DataTable GetData(string sql)
        //{
        //    SqlConnection conn = new SqlConnection(constr);
        //    SqlCommand cmd = new SqlCommand(sql, conn); 
        //    SqlDataAdapter da = new SqlDataAdapter(cmd);
        //    DataTable dt = new DataSet();
        //    da.Fill(dt);
        //    return dt;
        //}

        /// <summary>
        /// 查询所有数据
        /// </summary>
        /// <returns></returns>
        public static List<Customers> GetData()
        {
            string sql = "select * from customers";
            List<Customers> list = new List<Customers>();
            SqlConnection conn = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand(sql, conn);
            conn.Open();
            SqlDataReader dr = cmd.ExecuteReader();

            //while (dr.HasRows)
            while (dr.Read())
            {
              
                Customers c = new Customers();
                c.CustomerID = dr["CustomerID"].ToString();
                
                c.CompanyName = dr["CompanyName"].ToString();
                c.ContactName = dr["ContactName"].ToString();
                c.ContactTitle = dr["ContactTitle"].ToString();
                list.Add(c);
                
            }
            
            dr.Close();
            conn.Close();
            return list;
        }



        //public static int SqlExecute(string sql)
        //{