DAL/CollectionsDAL.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 CollectionsDAL
    {
       public static List<Collection> Collection(int cid)
       {
           string sql = "select * from Customer c,[Collection] co,Recuit r where c.cid=co.cid and co.rid=r.rid and c.cid=8";
           SqlDataReader sqlReader = DBHelp.SelectData(sql);
           List<Recuit> Recuit = RecuitDAL.Recuit();
           List<Collection> fs = new List<Collection>();
           while (sqlReader.Read())
           {
               Collection f = new Collection();
               f.Cid = (int)sqlReader["Cid"];
               f.Rid = (int)sqlReader["Rid"];
               f.Recuit = Recuit.Where(a => a.Rid == f.Rid).SingleOrDefault();
               fs.Add(f);
           }
           sqlReader.Close();
           return fs;
       }

       public static void delete(int cid)
       {
           string sql = "delete from [Collection] where cid="+cid;
           DBHelp.DeleteDate(sql);
       }
     
    }
}