DAL/JianLiDAL.cs

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

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

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

namespace DAL
{
    public class JianLiDAL
    {
        public static List<ExperienceProject_Infp> SelectJianLiPr(int cid)
        {
            string sql = "select * from resume r,ExperienceProject_Infp e where r.ResumeID=e.ResumeID and Cid='" + cid + "'";
            SqlDataReader dr = DBHelp.SelectData(sql);
            List<ExperienceProject_Infp> list2 = new List<ExperienceProject_Infp>();
            while (dr.Read())
            {
                ExperienceProject_Infp e = new ExperienceProject_Infp();
                e.CompanyName = (string)dr["CompanyName"];
                e.CpPostion = (string)dr["CpPostion"];
                e.StartYear = (string)dr["StartYear"];
                e.StartMonth = (string)dr["StartMonth"];
                e.EndYear = (string)dr["EndYear"];
                e.EndMonth = (string)dr["EndMonth"];
                e.PrName = (string)dr["PrName"];
                e.Post = (string)dr["Post"];
                e.PStartYear = (string)dr["PStartYear"];
                e.PStartMonth = (string)dr["PStartMonth"];
                e.PEndYear = (string)dr["PEndYear"];
                e.PEndMonth = (string)dr["PEndMonth"];
                e.PText = (string)dr["PText"];
                list2.Add(e);
            }
            dr.Close();
            return list2;
        }
        public static List<Resume> SelectJianLi(int cid)
        {
            string sql = "select * from resume r,ExperienceProject_Infp e where r.ResumeID=e.ResumeID and Cid='" + cid + "'";
            SqlDataReader dr = DBHelp.SelectData(sql);
            List<Resume> list = new List<Resume>();

            while (dr.Read())
            {
                Resume r = new Resume();
                r.Cid=(int)dr["Cid"];
                r.Gender = (string)dr["Gender"];
                r.Educational = (string)dr["Educational"];
                r.Experience = (string)dr["Experience"];
                r.Phone = (string)dr["Phone"];
                r.Email = (string)dr["Email"];
                r.State = (string)dr["State"];
                r.City = (string)dr["City"];
                r.WorType = (string)dr["WorType"];
                r.Postion = (string)dr["Postion"];
                r.Price = (string)dr["Price"];
                r.School = (string)dr["School"];