Smokewinetea.DAL/ConnectionDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SmokewineteaModels;
using System.Data.SqlClient;
using System.Data;

namespace Smokewinetea.DAL
{
   public class ConnectionDAL
    {
       /// <summary>
       /// 加载
       /// </summary>
       /// <returns></returns>
       public static List<ConnectionModel> ConnectionModel()
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("select Number,CustomName,CustomId,CustomSex,Corporation,CustomPhone,Frequency from Custom");
           SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());
           List<ConnectionModel> Staff = new List<ConnectionModel>();
           ConnectionModel sta;
           while (dr.Read())
           {
               sta = new ConnectionModel();
               sta.Number = Convert.ToInt32(dr[0]);
               sta.CustomName = dr[1].ToString();
               sta.CustomId =Convert.ToString(dr[2]);
               sta.CustomSex = dr[3].ToString();
               sta.Corporation = dr[4].ToString();
               sta.CustomPhone = Convert.ToString(dr[5]);
               sta.Frequency =Convert.ToInt32(dr[6]);
               Staff.Add(sta);

           }
           dr.Close();
           DbHelper.ConClose();
           return Staff;
       }

       /// <summary>
       /// 添加
       /// </summary>
       /// <param name="staff"></param>
       /// <returns></returns>
       public static int ConnectInser(ConnectionModel staff)
       {

           StringBuilder sql = new StringBuilder();
           sql.Append("insert into Custom  values(@CustomName,@CustomId,@CustomSex,@Corporation,@CustomPhone,@Frequency)");
           SqlParameter[] sta = {
                                    
                                    new SqlParameter("CustomName",SqlDbType.VarChar,20),
                                    new SqlParameter("CustomId",SqlDbType.VarChar,20),
                                    new SqlParameter("CustomSex",SqlDbType.VarChar,20),
                                    new SqlParameter("Corporation",SqlDbType.VarChar,20),
                                    new SqlParameter("CustomPhone",SqlDbType.VarChar,20),
                                    new SqlParameter("Frequency",SqlDbType.VarChar,50)
                                };