ActiveRecord使用文档

AcveRecord 代码示例文档

目录

AcveRecord 代码示例文档........................................................................................................... 1

目录........................................................................................................................................ 1

一． 数据库表结构............................................................................................................... 2

二． 数据持久化................................................................................................................... 2

三． 数据库操作................................................................................................................... 5

(1) 增加：...................................................................................................................... 5

主要操作、维护用户信息表（userinfo）同时进行电表关联操作

主键 字段名称 数据类型 长度 允许空 描述 备注

Guid uniqueidentier 16

唯一标识

GDSMC varchar 50 √

台区编号

YDDZ varchar 100 √

用电地址

BXBH varchar 12 √

表箱编号

BH varchar 30 √

表号（出厂编号）

BL bigint 8 √

二．数据持久化

首先把Userinfo进行持久化

[ActiveRecord]

public class UserInfo : ActiveRecordBase<UserInfo>{

private Guid guid = Guid.NewGuid();

[Property]

public Guid Guid

{

get { return guid; }

set { guid = value; }

/// <summary>

/// 供电所名称

/// </summary>

[Property("GDSMC")]

public string PowerSupplyBureau { get; set; }

/// <summary>

/// 台区编号

/// </summary>

[Property("BYQBH")]

public string RegionId { get; set; }

/// <summary>

/// </summary>

[PrimaryKey("HH")]

public string UserId { get; set; }

/// <summary>

/// 户名

/// </summary>

[Property("HM")]

public string UserName { get; set; }

/// <summary>

/// 用电地址

[Property("BXBH")]

public string MeterBoxId { get; set; }

/// 表号

/// </summary>

[Property("BH")]

public string MeterId { get; set; }

/// <summary>

/// 表位

/// </summary>

[Property("BW")]

public long MeterPosition { get; set; }

/// <summary>

/// 倍率

/// </summary>

/// 容量

public string Capacity { get; set; }

/// <summary>

/// 相位

/// </summary>

[Property("XW")]

public string Phase { get; set; }

/// <summary>

/// 施工状态

/// </summary>

[Property("SGZT")]

/// 施工时间

}