TEDAL/VideoDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using Tool;
using k2hTEWebApp;
using TEModel;

namespace TEDAL
{
    public class VideoDAL
    {
        SQLHelper db = new SQLHelper();

        /// <summary>
        /// 查询所有视频实体
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAllVideo()
        {
            string sql = @"SELECT [VideoID], [TrainingID], [Name], [Location], [State]， [Time], " +
                "[V5], [V6], [V7], [V8], [V9], [Content] " +
                "FROM [TrainingExam].[dbo].[Video]";
            return db.GetDataTable(sql);
        }
        /// <summary>
        /// 添加视频实体
        /// </summary>
        /// <param name="video"></param>
        /// <returns></returns>
        public int InsertVideo(VideoModel video)
        {
            string sql = @"INSERT INTO [TrainingExam].[dbo].[Video] " +
                "([VideoID], [TrainingID], [Name], [Location], [State], [Time], " +
                "[V5], [V6], [V7], [V8], [V9], [Content]) " +
                "VALUES(@VideoID, @TrainingID, @Name, @Location, @State, @Time, " +
                "@V5, @V6, @V7, @V8, @V9, @Content)";
            SqlParameter[] parameters = 
            {
                new SqlParameter("@VideoID", video.VideoID),
                new SqlParameter("@TrainingID", video.TrainingID),
                new SqlParameter("@Name", video.Name),
                new SqlParameter("@State", video.State),
                new SqlParameter("@Time", video.Time),
                new SqlParameter("@Content", video.Content)
            };
            return db.ExecuteNonQuery(sql, parameters);
        }
        /// <summary>
        /// 删除视频实体
        /// </summary>
        /// <param name="video"></param>
        /// <returns></returns>
        public int DeleteVideo(VideoModel video)
        {
            string sql = @"DELETE FROM Video WHERE VideoID=@VideoID";
            SqlParameter parameter = new SqlParameter("@VideoID", video.VideoID);