/// <summary>
        /// ConditionBuilder 并不支持生成Like操作,如 字符串的 StartsWith,Contains,EndsWith 并不能生成这样的SQL: Like ‘xxx%’, Like ‘%xxx%’ , Like ‘%xxx’ . 只要override VisitMethodCall 这个方法即可实现上述功能。
        /// </summary>
        /// <param name="m"></param>
        /// <returns></returns>
        protected override Expression VisitMethodCall(MethodCallExpression m)
        {
            string connectorWords = GetLikeConnectorWords(m_dataBaseType); //获取like链接符

            if (m == null)
            {
                return(m);
            }
            string format;

            switch (m.Method.Name)
            {
            case "StartsWith":
                format = "({0} LIKE ''" + connectorWords + "{1}" + connectorWords + "'%')";
                break;

            case "Contains":
                format = "({0} LIKE '%'" + connectorWords + "{1}" + connectorWords + "'%')";
                break;

            case "EndsWith":
                format = "({0} LIKE '%'" + connectorWords + "{1}" + connectorWords + "'')";
                break;

            case "Equals":
                // not in 或者  in 或 not like
                format = "{0} {1} ";
                break;

            case "Parse":
                format = "{1}";
                break;

            case "IsNull":
                if (m.Method.ReflectedType == typeof(SqlColumnUtil))
                {
                    object obj = TypeUtil.GetSqlDataTypeValue(m.Arguments[1], m.Arguments[1].Type);
                    format = "isnull({1}," + obj.ToString().Replace("\"", "") + ")";
                }
                else
                {
                    format = "({1})";
                    throw new NotSupportedException(m.NodeType + " is not supported!");
                }
                break;

            default:
                if (m.Method.ReturnType == typeof(int))
                {
                    if (DataBaseType.SqlServer.Equals(m_dataBaseType))
                    {
                        format = "convert(int,{1})";
                        break;
                    }
                }
                throw new NotSupportedException(m.NodeType + " is not supported!");
            }
            if (m.Object != null)
            {
                this.Visit(m.Object);
            }
            this.Visit(m.Arguments[0]);
            string right = this.m_conditionParts.Pop();
            string left  = string.Empty;

            if (m.Object != null)
            {
                left = this.m_conditionParts.Pop();
            }

            this.m_conditionParts.Push(string.Format(format, left, right));
            return(m);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 实体列表转DataTable
        /// </summary>
        /// <typeparam name="T">实体类</typeparam>
        /// <param name="modelList">实体列表</param>
        /// <returns></returns>
        public static DataTable ModelList2DataTable <T>(List <T> modelList)
        {
            if (modelList == null)
            {
                return(null);
            }

            DataTable dataTable = new DataTable();
            var       model     = modelList[0];
            Type      t         = model.GetType();//获得该类的Type

            //创建表结构、设置字段信息
            foreach (PropertyInfo pi in t.GetProperties())
            {
                DataColumn     dataColumn = new DataColumn();
                ModelAttribute attr       = (ModelAttribute)Attribute.GetCustomAttribute(pi, typeof(ModelAttribute));// 属性值
                if (attr != null)
                {
                    dataColumn.ColumnName = attr.ColumnName;
                    dataColumn.DataType   = TypeUtil.GetType(attr.ColumnType);
                    dataColumn.Caption    = attr.ColumnTitle;
                    if (attr.IsPrimaryKey)
                    {
                        dataColumn.Unique = true;
                    }
                }
                else
                {
                    object value = pi.GetValue(model, null);

                    dataColumn.ColumnName = pi.Name;
                    if (value != null)
                    {
                        dataColumn.DataType = value.GetType();
                    }
                    //else
                    //{
                    //    dataColumn.DataType = typeof(string);
                    //}
                }
                dataTable.Columns.Add(dataColumn);
            }

            //添加行数据
            foreach (var m in modelList)
            {
                object[] values = new object[t.GetProperties().Length];
                int      idx    = 0;
                foreach (PropertyInfo pi in t.GetProperties())
                {
                    object value = pi.GetValue(model, null);
                    //ModelAttribute attr = (ModelAttribute)Attribute.GetCustomAttribute(pi, typeof(ModelAttribute));// 属性值
                    //if (attr != null && !string.IsNullOrEmpty(attr.ColumnType))
                    //{
                    //    value = pi.GetValue(model, null);
                    //}
                    //else
                    //{
                    //    value = pi.GetValue(model, null);
                    //}
                    values[idx] = value;
                    idx++;
                }
                dataTable.Rows.Add(values);
            }

            return(dataTable);
        }