BN089-BS开发框架MVC4版/source20131023/Zephyr.Net/Zephyr.Core/Param/ParamQuery.cs

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

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

/*************************************************************************
 * 文件名称 ：ParamQuery.cs                          
 * 描述说明 ：查询参数构建
 * 
 * 创建信息 : create by liuhuisheng.xm@gmail.com on 2012-11-10
 * 修订信息 : modify by (person) on (date) for (reason)
 * 
 * 版权信息 : Copyright (c) 2013 厦门纵云信息科技有限公司 www.zoewin.com
**************************************************************************/

using System;
using System.Linq;

namespace Zephyr.Core
{
    public class ParamQuery
    {
        protected ParamQueryData data;

        public ParamQuery Select(string sql)
        {
            data.Select = sql;
            return this;
        }

        public ParamQuery From(string sql)
        {
            data.From = sql;
            return this;
        }
 
        //public ParamQuery AndWhere(string column, object value, Cp cp = Cp.equal, params object[] extend)
        //{
        //    data.Where.Add(new ParamWhere() { AndOr = "and", Column = column, Value = value, Compare = cp, Extend = extend });
        //    return this;
        //}

        public ParamQuery AndWhere(string column, object value, Func<WhereData, string> cp = null, params object[] extend)
        {
            data.Where.Add(new ParamWhere() { Data = new WhereData() { AndOr = "and", Column = column, Value = value, Extend = extend }, Compare = cp ?? Cp.Equal });
            return this;
        }

        //public ParamQuery OrWhere(string column, object value, Cp cp = Cp.equal, params object[] extend)
        //{
        //    data.Where.Add(new ParamWhere() { AndOr = "or", Column = column, Value = value, Compare = cp, Extend = extend });
        //    return this;
        //}

        public ParamQuery OrWhere(string column, object value, Func<WhereData, string> cp = null, params object[] extend)
        {
            data.Where.Add(new ParamWhere() { Data = new WhereData() { AndOr = "or", Column = column, Value = value, Extend = extend }, Compare = cp ?? Cp.Equal });
            return this;
        }

        public ParamQuery ClearWhere()
        {
            data.Where.Clear();
            return this;
        }