数据访问层——字段的封装

最新推荐文章于 2024-10-22 23:42:51 发布

Matrix_Designer

最新推荐文章于 2024-10-22 23:42:51 发布

阅读量598

点赞数

CC 4.0 BY-SA版权

分类专栏： .NET 文章标签： string object class

本文链接：https://blog.youkuaiyun.com/Matrix_Designer/article/details/5923961

.NET 专栏收录该内容

19 篇文章

订阅专栏

一个对表格字段的封装类
调试环境:Visual Stdio 2005,C#.net
/// <summary>
/// 字段类型数据
/// </summary>
public class DBFieldInfo
{
    private String fieldName;
    private SqlDbType fieldType;
    private int fieldSize;
    private object fieldValue;
    private bool isChanged;
    private static int index = 1;
    /// <summary>
    /// 构造默认字段(Name:field00001,Type:VarChar,Size:100,Value:"")
    /// </summary>
    public DBFieldInfo()
    {
        fieldName = "field" + index.ToString("00000");
        fieldType = SqlDbType.VarChar;
        fieldSize = 100;
        fieldValue = "";
        isChanged = false;
        index++;
    }
    /// <summary>
    /// 构造指定字段
    /// </summary>
    public DBFieldInfo(string fieldName, SqlDbType fieldType)
    {
        this.fieldName = fieldName;
        this.fieldType = fieldType;
        this.fieldValue = null;
        this.isChanged = false;
    }
    /// <summary>
    /// 构造指定字段
    /// </summary>
    public DBFieldInfo(string fieldName, SqlDbType fieldType, object fieldValue)
    {
        this.fieldName = fieldName;
        this.fieldType = fieldType;
        this.fieldValue = fieldValue;
        this.isChanged = false;
    }
    /// <summary>
    /// 构造指定字段
    /// </summary>
    public DBFieldInfo(string fieldName, SqlDbType fieldType, int fieldSize)
    {
        this.fieldName = fieldName;
        this.fieldType = fieldType;
        this.fieldSize = fieldSize;
        this.fieldValue = null;
        this.isChanged = false;
    }
    /// <summary>
    /// 构造指定字段
    /// </summary>
    public DBFieldInfo(string fieldName, SqlDbType fieldType, int fieldSize, object fieldValue)
    {
        this.fieldName = fieldName;
        this.fieldType = fieldType;
        this.fieldSize = fieldSize;
        this.fieldValue = fieldValue;
        this.isChanged = false;
    }
    /// <summary>
    /// 字段名
    /// </summary>
    public String FieldName
    {
        get {return this.fieldName;}
        set {this.fieldName=value;}
    }
    /// <summary>
    /// 字段类型
    /// </summary>
    public SqlDbType FieldType
    {
        get { return this.fieldType; }
        set { this.fieldType = value; }
    }
    /// <summary>
    /// 字段大小
    /// </summary>
    public int FieldSize
    {
        get { return this.fieldSize; }
        set { this.fieldSize = value; }
    }
    /// <summary>
    /// 字段值
    /// </summary>
    public object FieldValue
    {
        get { return this.fieldValue; }
        set
        {
            this.fieldValue = value;
            isChanged = true;
        }
    }
    /// <summary>
    /// 字段内容是否被修改
    /// </summary>
    public bool IsChanged
    {
        get { return this.isChanged; }
        set { this.isChanged = value; }
    }
}