DAL/AdveDAL.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 AdveDAL
    {
        public static List<Adve> selectAdve()
        {
            string sql = "select * from Advertisement";
            List<Adve> alist = new List<Adve>();
            SqlDataReader sqlReader = DBHelp.SelectData(sql);
            while (sqlReader.Read())
            {
                Adve a = new Adve();
                a.id = (int)sqlReader["id"];
                a.imgUrl = (string)sqlReader["imgUrl"];
                alist.Add(a);
            }
            sqlReader.Close();
            return alist;
        }
        public static int DelAdve(int id)
        {
            string sql = "delete from Advertisement where id='"+id+"'";
            int num = DBHelp.DeleteDate(sql);
            return num;
        }
        public static  int AddEvde(string url)
        {
             string sql="insert into Advertisement values('"+url+"')";
            int num=DBHelp.AddData(sql);
            return num;
        }
    }
}