crm快速开发之QueryExpression
来源:互联网 发布:简述java垃圾回收机制 编辑:程序博客网 时间:2024/06/05 04:20
/* 创建者:菜刀居士的博客
* 创建日期:2014年07月06号
*/
namespace Net.CRM.OrganizationService
{
using System;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Query;
using System.Collections.Generic;
/// <summary>
/// QueryExpression
/// </summary>
public class QueryExpressionDemo
{
/// <summary>
/// 基本模式,构造查询--QueryExpression
/// </summary>
public void CreateQueryExpression()
{
QueryExpression query = new QueryExpression();
//查询的实体名称
query.EntityName = "new_accountproduct";
//查询实体的属性集合
query.ColumnSet = new ColumnSet("new_product","new_name","new_price");
//查询条件
query.Criteria.AddCondition(new ConditionExpression("statecode",ConditionOperator.Equal,0));
query.Criteria.AddCondition(new ConditionExpression("new_name", ConditionOperator.Like, "水果" + "%"));
List<Guid> list = new List<Guid>();
list.Add(new Guid("27BB1B31-09BB-E311-B590-D89D671782D3"));
list.Add(new Guid("E8F8D412-31BB-E311-B590-D89D671782D3"));
query.Criteria.AddCondition(new ConditionExpression("new_product",ConditionOperator.In,list.ToArray()));
query.Criteria.AddCondition(new ConditionExpression("new_name", ConditionOperator.NotNull));
query.Criteria.AddCondition(new ConditionExpression("new_price", ConditionOperator.Null));
}
/// <summary>
/// 快速模式,构造查询--QueryExpression
/// </summary>
public void CreateQuickQueryExpression()
{
QueryExpression query = "new_accountproduct".ToQuery("new_product", "new_name", "new_price");
query.AddEqual("statecode", 0);
query.AddLike("new_name", "水果" + "%");
List<Guid> list = new List<Guid>();
list.Add(new Guid("27BB1B31-09BB-E311-B590-D89D671782D3"));
list.Add(new Guid("E8F8D412-31BB-E311-B590-D89D671782D3"));
query.AddIn("new_product", list.ToArray());
query.AddNotNull("new_name");
query.AddNull("new_price");
}
}
public static class ExtensionFunction
{
public static QueryExpression ToQuery(this string entityName)
{
QueryExpression query = new QueryExpression();
query.EntityName = entityName;
return query;
}
public static QueryExpression ToQuery(this string entityName,params string[] Attrs)
{
QueryExpression query = new QueryExpression();
query.EntityName = entityName;
query.ColumnSet = new ColumnSet(Attrs);
return query;
}
public static void AddEqual<T>(this QueryExpression query,string name,T value)
{
query.Criteria.AddCondition(new ConditionExpression(name,ConditionOperator.Equal,value));
}
public static void AddLike(this QueryExpression query, string name,string value)
{
query.Criteria.AddCondition(new ConditionExpression(name,ConditionOperator.Like,value));
}
public static void AddIn<T>(this QueryExpression query, string name,T[] values)
{
query.Criteria.AddCondition(new ConditionExpression(name, ConditionOperator.In, values));
}
public static void AddNotNull(this QueryExpression query,params string[] attrs)
{
if (attrs != null && attrs.Length > 0)
{
foreach(string name in attrs)
{
query.Criteria.AddCondition(new ConditionExpression(name, ConditionOperator.NotNull));
}
}
}
public static void AddNull(this QueryExpression query, params string[] attrs)
{
if (attrs != null && attrs.Length > 0)
{
foreach (string name in attrs)
{
query.Criteria.AddCondition(new ConditionExpression(name, ConditionOperator.Null));
}
}
}
}
}
对比:
- crm快速开发之QueryExpression
- crm快速开发之Entity
- crm快速开发之OrganizationService
- crm快速开发之EntityCollection
- 如何快速的进行CRM 模板开发
- 快速开发平台与移动CRM
- .net快速开发平台、快速开发平台,帮你快速开发OA、CRM、ERP等系统
- CRM-Solution系统之单据开发感想
- 快速复制CRM系统
- 五指CRM快速部署
- Winform开发框架之客户关系管理系统(CRM)
- 转:CRM UI开发之组件视图复用
- fetchxml分页和QueryExpression分页
- CRM开发框架分析
- CRM系统开发经验谈
- Sage CRM SDK 开发
- CRM WEB page 开发
- ssh开发CRM
- 魔族密码
- openstack之nova-api服务流程分析
- C++代码注释规范
- javax.mail.MessagingException: 501 Syntax: HELO hostname Linux端异常解决
- 多选select框从左边的复选框移到右边复选框
- crm快速开发之QueryExpression
- QTP实现简易定时器--完成定时脚本测试工作
- Apache + Tomcat集群配置
- cocos2dx sqlite3封装使用
- 在Excel中将数字转换为人民币大写风格的公式
- Java IO File 文件管理 Java编程思想读书笔记
- Eclipse快捷键大全(转载)
- js判断选择不同的样式文件
- UIApplication深入研究