src/Library/NetPro.Dapper/Parameters/Parameter.cs

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

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

using Dapper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace NetPro.Dapper.Parameters
{
    /// <summary>
    /// 自定义sql参数
    /// </summary>
    [Serializable]
    public class Parameter
    {
        public Parameter() { }

        public Parameter(string name, object value)
        {
            Name = name;
            Value = value;
        }

        public Parameter(string name, object value, OperateType operateType = OperateType.Equal)
        {
            Name = name;
            OperateType = operateType;
            Value = value;
        }

        public Parameter(string name, object value, OperateType operateType = OperateType.Equal, LogicType logicType = LogicType.And) : this(name, value, operateType)
        {
            LogicType = logicType;
        }

        public string Name { get; set; }
        public object Value { get; set; } = null;
        public OperateType OperateType { get; set; }
        public LogicType LogicType { get; set; }
        public bool EmpytToDBNull { get; set; }

    }

    /// <summary>
    /// sql查询条件构造器
    /// </summary>
    public static class BuildSqlParameter
    {
        /// <summary>
        /// 添加查询条件
        /// （不包含【WHERE】关键字）
        /// </summary>
        /// <param name="pars"></param>
        /// <returns></returns>
        [Obsolete("为兼容老项目，不推荐使用！！")]
        public static string GetSqlParameter(this Parameter[] pars)
        {
            StringBuilder sbJoin = new StringBuilder();
            string wheres = "";
            if (pars == null || pars.Length == 0)
                return "";