DAL/CreateDAL.cs

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

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

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 CreateDAL
    {
        public List<Recuit> GetSelectIndex()
        {
            string sql = "select * from recuit, company  where Recuit.companyID=company.companyID";
            SqlDataReader sqlReader = DBHelp.SelectData(sql);
            List<Recuit> fs = new List<Recuit>();
            while (sqlReader.Read())
            {
                Recuit f = new Recuit();
                f.Rid = (int)sqlReader["Rid"];
                f.PositionType = (string)sqlReader["PositionType"];
                f.PositionName = (string)sqlReader["PositionName"];
                f.Department = (string)sqlReader["Department"];
                f.WorkType = (string)sqlReader["WorkType"];
                f.MinPrice = (int)sqlReader["MinPrice"];
                f.MaxPrice = (int)sqlReader["MaxPrice"];
                f.WorkCity = (string)sqlReader["WorkCity"];
                f.Experience = (string)sqlReader["Experience"];
                f.Educational = (string)sqlReader["Educational"];
                f.tempt = (string)sqlReader["tempt"];
                f.WorkTxt = (string)sqlReader["WorkTxt"];
                f.Start = (int)sqlReader["Start"];
                f.companyID = (int)sqlReader["companyID"];
                fs.Add(f);
            }
            sqlReader.Close();
            return fs;
        }
        public List<company> GetSelectcompany(int id)
        {
            string sql = "select * from company  where companyID='"+id+"'";
            SqlDataReader sqlReader = DBHelp.SelectData(sql);
            List<company> fs = new List<company>();
            while (sqlReader.Read())
            {
                company f = new company();
                f.companyID = (int)sqlReader["companyID"];
                f.CText = (string)sqlReader["CText"];
                f.CName = (string)sqlReader["CName"];
                f.Lable = (string)sqlReader["Lable"];
                f.ProductPic = (string)sqlReader["ProductPic"];
                f.ProductName = (string)sqlReader["ProductName"];
                f.ProductUrl = (string)sqlReader["ProductUrl"];
                f.ProductTxt = (string)sqlReader["ProductTxt"];
                f.Address = (string)sqlReader["Address"];
                f.Count = (string)sqlReader["Count"];
                f.IndexUrl = (string)sqlReader["IndexUrl"];
                f.ThisFinacncing = (string)sqlReader["ThisFinacncing"];
                f.Finacning = (string)sqlReader["Finacning"];