using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Runtime.Serialization;
|
using System.Text;
|
|
namespace IStation
|
{
|
/// <summary>
|
/// Sql条件类
|
/// </summary>
|
[DataContract]
|
[Serializable]
|
public class SqlCondition
|
{
|
|
/// <summary>
|
/// 条件类型
|
/// </summary>
|
[DataMember]
|
public int ConditionType { get; set; }
|
|
/// <summary>
|
/// 前缀类型
|
/// </summary>
|
[DataMember]
|
public int Prefix { get; set; }
|
|
/// <summary>
|
/// 数据类型
|
/// </summary>
|
[DataMember]
|
public int DataType { get; set; }
|
|
/// <summary>
|
/// 属性名称
|
/// </summary>
|
[DataMember]
|
public string PropName { get; set; }
|
|
/// <summary>
|
/// 数据
|
/// </summary>
|
[DataMember]
|
public List<string> Data { get; set; }
|
|
/// <summary>
|
/// 排序码
|
/// </summary>
|
[DataMember]
|
public int SortCode { get; set; }
|
|
/// <summary>
|
/// 参数名称列表
|
/// </summary>
|
internal List<string> Parameters { get; set; }
|
|
|
|
//普通条件设置
|
private void SetGeneralCondition(eSqlConditionType conditionType, string propName, object data, eSqlDataType dataType= eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)conditionType;
|
this.PropName = propName;
|
this.Data = new List<string>() { Convert.ToString(data) };
|
this.DataType = (int)dataType;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 Equals
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetEqualsCondition(string propName, object data, eSqlDataType dataType= eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.SetGeneralCondition(eSqlConditionType.Equals,propName,data,dataType,prefix);
|
}
|
|
/// <summary>
|
/// 设置 NotEquals
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetNotEqualsCondition(string propName, object data, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.SetGeneralCondition(eSqlConditionType.NotEquals,propName,data,dataType,prefix);
|
}
|
|
/// <summary>
|
/// 设置 GreaterThan
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetGreaterThanCondition(string propName, object data, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.SetGeneralCondition(eSqlConditionType.GreaterThan, propName, data, dataType, prefix);
|
}
|
|
/// <summary>
|
/// 设置 GreaterThanOrEqual
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetGreaterThanOrEqualCondition(string propName, object data, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.SetGeneralCondition(eSqlConditionType.GreaterThanOrEqual, propName, data, dataType, prefix);
|
}
|
|
/// <summary>
|
/// 设置 LessThan
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetLessThanCondition(string propName, object data, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.SetGeneralCondition(eSqlConditionType.LessThan, propName, data, dataType, prefix);
|
}
|
|
/// <summary>
|
/// 设置 LessThanOrEqual
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetLessThanOrEqualCondition(string propName, object data, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.SetGeneralCondition(eSqlConditionType.LessThanOrEqual, propName, data, dataType, prefix);
|
}
|
|
/// <summary>
|
/// 设置 In
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="propValue"></param>
|
public void SetInCondition(string propName, List<object> data, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.In;
|
this.PropName = propName;
|
this.Data = data.Select(x => Convert.ToString(x)).ToList();
|
this.DataType = (int)dataType;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 Contains
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetContainsCondition(string propName, string data, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.Contains;
|
this.PropName = propName;
|
this.Data = new List<string>() { data };
|
this.DataType = (int)eSqlDataType.String;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 StartsWith
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetStartsWithCondition(string propName, string data, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.StartsWith;
|
this.PropName = propName;
|
this.Data = new List<string>() { data };
|
this.DataType = (int)eSqlDataType.String;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 EndsWith
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="data"></param>
|
public void SetEndsWithCondition(string propName, string data, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.EndsWith;
|
this.PropName = propName;
|
this.Data = new List<string>() { data };
|
this.DataType = (int)eSqlDataType.String;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 IsNull
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="propName"></param>
|
public void SetIsNullCondition(string propName, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.IsNull;
|
this.PropName = propName;
|
this.Data = null;
|
this.DataType = (int)eSqlDataType.String;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 IsNotNull
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="propName"></param>
|
public void SetIsNotNullCondition(string propName, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.IsNotNull;
|
this.PropName = propName;
|
this.Data = null;
|
this.DataType = (int)eSqlDataType.String;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 Between
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="firstValue"></param>
|
/// <param name="secondValue"></param>
|
public void SetBetweenCondition(string propName, object firstValue, object secondValue, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.Between;
|
this.PropName = propName;
|
this.Data = new List<string>() { Convert.ToString(firstValue), Convert.ToString(secondValue) };
|
this.DataType = (int)dataType;
|
this.Prefix = (int)prefix;
|
}
|
|
/// <summary>
|
/// 设置 NotBetween
|
/// </summary>
|
/// <param name="prefix"></param>
|
/// <param name="dataType"></param>
|
/// <param name="propName"></param>
|
/// <param name="firstValue"></param>
|
/// <param name="secondValue"></param>
|
public void SetNotBetweenCondition(string propName, object firstValue, object secondValue, eSqlDataType dataType = eSqlDataType.String, eSqlConditionPrefix prefix = eSqlConditionPrefix.And)
|
{
|
this.ConditionType = (int)eSqlConditionType.NotBetween;
|
this.PropName = propName;
|
this.Data = new List<string>() { Convert.ToString(firstValue), Convert.ToString(secondValue) };
|
this.DataType = (int)dataType;
|
this.Prefix = (int)prefix;
|
}
|
|
|
}
|
}
|
