Master.CanYinWu.DAL/ProjectJoinPosterDAL.cs

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

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

using Dapper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Master.CanYinWu.Entity;
using Master.CanYinWu.Utility;

namespace Master.CanYinWu.DAL
{
  public  class ProjectJoinPosterDAL
    {
        public async Task<int> Insert(ProjectJoinPoster model)
        {
            string sql = @"INSERT INTO [ProjectJoinPoster]
                          (
                            [ProjectJoinId],
                            [CssFolder],
                            [ImageFolder],
                            [JavascriptFolder],
                            [Head],
                            [Body],
                            [ProjectTitle]
                          )
                        VALUES
                          (
                            @ProjectJoinId, 
                            @CssFolder,
                            @ImageFolder,
                            @JavascriptFolder,
                            @Head,
                            @Body,
                            @ProjectTitle
                          )";
            using (var conn= ConnectionFactory.Connection())
            {
                return await conn.ExecuteAsync(sql, model);
            }
        }
        public async Task<int> Update(ProjectJoinPoster model)
        {
            string sql = @"UPDATE [ProjectJoinPoster]
                           SET [ProjectJoinId] = @ProjectJoinId,
                              [CssFolder] = @CssFolder,
                              [ImageFolder] = @ImageFolder,
                              [JavascriptFolder] = @JavascriptFolder,
                              [Head] = @Head,
                              [Body] = @Body,
                              [UpdateTime] = @UpdateTime,
                              [ProjectTitle]=@ProjectTitle
                         WHERE Id=@Id";
            using (var conn = ConnectionFactory.Connection())
            {
                return await conn.ExecuteAsync(sql, model);
            }
        }
        public async Task<ProjectJoinPoster> GetModel(int id)
        {
            string sql = @"select top 1* from ProjectJoinPoster