#region
|
|
using System;
|
|
#endregion
|
|
namespace CSFrameworkV5.Interfaces.InterfaceModels
|
{
|
/// <summary>
|
/// 字段定义实体类
|
/// </summary>
|
[Serializable]
|
public class FieldNameDef
|
{
|
public FieldNameDef()
|
{
|
FieldName = "";
|
Caption = "";
|
}
|
|
/// <summary>
|
/// 构造器
|
/// </summary>
|
/// <param name="fieldName"></param>
|
/// <param name="caption"></param>
|
/// <param name="isStringType">对应SQL脚本，字符匹配类型</param>
|
public FieldNameDef(string fieldName, string caption, string fieldType)
|
{
|
FieldName = fieldName;
|
Caption = caption;
|
FieldType = fieldType;
|
}
|
|
/// <summary>
|
/// 预设字段标题
|
/// </summary>
|
public string Caption { get; set; }
|
|
/// <summary>
|
/// DB物理字段名
|
/// </summary>
|
public string FieldName { get; set; }
|
|
public string FieldType { get; set; }
|
|
/// <summary>
|
/// 排序，1升序，2降序,对应ImageIndex的图片序号
|
/// </summary>
|
public int OrderBy { get; set; }
|
|
public FieldNameDef Copy()
|
{
|
var o = new FieldNameDef();
|
o.Caption = Caption;
|
o.FieldName = FieldName;
|
o.FieldType = FieldType;
|
o.OrderBy = OrderBy;
|
return o;
|
}
|
|
/// <summary>
|
/// 拼接SQL需要加单引号的字段类型，如：varchar,datetime等
|
/// </summary>
|
/// <returns></returns>
|
public bool IsStringType()
|
{
|
if (string.IsNullOrEmpty(FieldType)) return true;
|
|
var stringTypes =
|
",VarChar,Char,Date,DateTime,DateTime2,NChar,NText,NVarchar,SmallDateTime,Text,Time,Timestamp,UniqueIdentifier,Xml,";
|
return stringTypes.ToLower()
|
.IndexOf("," + FieldType.ToLower() + ",") >= 0;
|
}
|
}
|
}
|
