BlueLight.ShortUrl/Services/ShortUrlInfoService.cs

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

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

using BlueLight.ShortUrl.Models;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using Dapper;
using DapperExtensions;
using BlueLight.ShortUrl.Common;
using BlueLight.ShortUrl.QueryParams;
using System.Web.Mvc;

namespace BlueLight.ShortUrl.Services
{
    public class ShortUrlInfoService : BaseService
    {
       
       
        public bool Create(ShortUrlInfo model)
        {
            using (var cn = new SqlConnection(ConnectionStr))
            {
                var result = cn.Insert<ShortUrlInfo>(model);
                return result > 0;
                    
            }
        }

        public ShortUrlInfo GetShortUrlInfo(int id)
        {
            using (var cn = new SqlConnection(ConnectionStr))
            {
                var user = cn.Get<ShortUrlInfo>(id);
                return user;
            }

        } 


        public RecordList<ShortUrlInfo> GetShortUrlInfos(ShortUrlInfoQueryParams query)
        {
            using (var cn = new SqlConnection(ConnectionStr))
            {  
                var datalist = cn.GetPage<ShortUrlInfo>(null, null, query.Page.Value, query.rows.Value).ToList();
                var count = cn.Count<ShortUrlInfo>(null);
                var result = new RecordList<ShortUrlInfo>(datalist);
                result.RecordCount = count;
                result.PageIndex = query.Page.Value;
                result.PageSize = query.rows.Value;

                return result;
            }
        }

        public RecordList<ShortUrlInfo> GetUsersUrlInfos(ShortUrlInfoQueryParams query)
        {
      
            using (var cn = new SqlConnection(ConnectionStr))
            {
                var predicate = Predicates.Field<ShortUrlInfo>(f => f.OwnId, Operator.Eq, query.OwnId);