DAL/RecuitDAL.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Entitry;
using Common;
using System.Data.SqlClient;
namespace DAL
{
   public class RecuitDAL
    {
       public static List<Recuit> Recuit()
       {
           string sql = "select * from Recuit";
           SqlDataReader sqlReader = DBHelp.SelectData(sql);

           List<Recuit> Recuit = new List<Recuit>();
           while (sqlReader.Read())
           {
               Recuit f = new Recuit();
               f.companyID = (int)sqlReader["companyID"];
               f.Department = (string)sqlReader["Department"];
               f.Educational = (string)sqlReader["Educational"];
               f.Experience = (string)sqlReader["Experience"];
               f.MaxPrice = (int)sqlReader["MaxPrice"];
               f.MinPrice = (int)sqlReader["MinPrice"];
               f.PositionName = (string)sqlReader["PositionName"];
               f.PositionType = (string)sqlReader["PositionType"];
               f.Rid = (int)sqlReader["Rid"];
               f.Start = (int)sqlReader["Start"];
               f.tempt = (string)sqlReader["tempt"];
               f.WorkCity = (string)sqlReader["WorkCity"];
               f.WorkTxt = (string)sqlReader["WorkTxt"];
               f.WorkType = (string)sqlReader["WorkType"];
               Recuit.Add(f);
           }
           sqlReader.Close();
           return Recuit;
       }
    }
}