public CommentRelation()
{
FieldInfoList.Add(new TableFieldInfo("CommentRelationID", true, typeof(System.Int64), 8, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("CommentID", false, typeof(System.Int64), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("TableName", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("TableID", false, typeof(System.Int64), 8, true, "", ""));
}
public CustomerContact()
{
TableName = "CustomerContact";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", "序号"));
FieldInfoList.Add(new TableFieldInfo("IsMainContact", false, typeof(System.Boolean), 1, true, "", "是否主联系人"));
FieldInfoList.Add(new TableFieldInfo("Name", false, typeof(System.String), 100, true, "", "姓名"));
FieldInfoList.Add(new TableFieldInfo("CustomerCode", false, typeof(System.Int32), 4, true, "", "客户编码"));
FieldInfoList.Add(new TableFieldInfo("Position", false, typeof(System.String), 100, true, "", "职务"));
FieldInfoList.Add(new TableFieldInfo("Email", false, typeof(System.String), 50, true, "", "电子邮箱"));
FieldInfoList.Add(new TableFieldInfo("MobilePhone", false, typeof(System.String), 50, true, "", "手机"));
FieldInfoList.Add(new TableFieldInfo("ProjectRoles", false, typeof(System.String), 100, true, "", "项目角色"));
FieldInfoList.Add(new TableFieldInfo("QQ", false, typeof(System.String), 50, true, "", "QQ"));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 100, true, "", "备注"));
FieldInfoList.Add(new TableFieldInfo("Department", false, typeof(System.String), 100, true, "", "部门"));
FieldInfoList.Add(new TableFieldInfo("MicroBlog", false, typeof(System.String), 150, true, "", "微博"));
FieldInfoList.Add(new TableFieldInfo("WeChat", false, typeof(System.String), 50, true, "", "微信"));
FieldInfoList.Add(new TableFieldInfo("NativePlace", false, typeof(System.String), 100, true, "", "籍贯"));
FieldInfoList.Add(new TableFieldInfo("GraduateSchool", false, typeof(System.String), 100, true, "", "毕业学校"));
FieldInfoList.Add(new TableFieldInfo("Sex", false, typeof(System.String), 100, true, "", "性别"));
FieldInfoList.Add(new TableFieldInfo("Birthdate", false, typeof(System.DateTime), 3, true, "", "出生日期"));
FieldInfoList.Add(new TableFieldInfo("LoverWorkUnit", false, typeof(System.String), 300, true, "", "爱人工作单位"));
FieldInfoList.Add(new TableFieldInfo("PreviousWorkUnits", false, typeof(System.String), 300, true, "", "之前的工作单位"));
FieldInfoList.Add(new TableFieldInfo("MaritalStatus", false, typeof(System.Boolean), 1, true, "", "婚否"));
FieldInfoList.Add(new TableFieldInfo("HaveAnyChildren", false, typeof(System.Boolean), 1, true, "", "是否有小孩"));
FieldInfoList.Add(new TableFieldInfo("HomeAddress", false, typeof(System.String), 300, true, "", "家庭地址"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", "创建时间"));
FieldInfoList.Add(new TableFieldInfo("EditTime", false, typeof(System.DateTime), 8, true, "", "编辑时间"));
FieldInfoList.Add(new TableFieldInfo("Creator", false, typeof(System.String), 50, true, "", "创建者"));
}
public Users()
{
TableName = "Users";
PKey = "UserID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("UserID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("LoginID", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("UserPwd", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("RealName", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("DepartmentID", false, typeof(System.Int32), 4, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Mobile", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Email", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("QQ", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("CreatTime", false, typeof(System.DateTime), 8, true, "(getdate())", ""));
FieldInfoList.Add(new TableFieldInfo("ModifyTime", false, typeof(System.DateTime), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Creator", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Editor", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("LastLoginIP", false, typeof(System.String), 23, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("LastLoginTime", false, typeof(System.DateTime), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("IsEnabled", false, typeof(System.Boolean), 1, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("IsLocked", false, typeof(System.Boolean), 1, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 500, true, "", "备注"));
FieldInfoList.Add(new TableFieldInfo("ordernum", false, typeof(System.Double), 8, true, "", ""));
}
public Customer()
{
TableName = "Customer";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("CustomerCode", false, typeof(System.Int32), 4, true, "", "客户编码"));
FieldInfoList.Add(new TableFieldInfo("CustomerName", false, typeof(System.String), 200, true, "", "客户名称"));
FieldInfoList.Add(new TableFieldInfo("CustomerType", false, typeof(System.String), 100, true, "", "客户类型"));
FieldInfoList.Add(new TableFieldInfo("CustomerOwner", false, typeof(System.String), 50, true, "", "客户所有人"));
FieldInfoList.Add(new TableFieldInfo("Region", false, typeof(System.String), 100, true, "", "所属区域"));
FieldInfoList.Add(new TableFieldInfo("Contact", false, typeof(System.String), 100, true, "", "联系人"));
FieldInfoList.Add(new TableFieldInfo("CompanyTel", false, typeof(System.String), 50, true, "", "公司电话"));
FieldInfoList.Add(new TableFieldInfo("MobilePhone", false, typeof(System.String), 50, true, "", "手机"));
FieldInfoList.Add(new TableFieldInfo("QQ", false, typeof(System.String), 50, true, "", "QQ号码"));
FieldInfoList.Add(new TableFieldInfo("EMail", false, typeof(System.String), 50, true, "", "电子邮箱"));
FieldInfoList.Add(new TableFieldInfo("DocumentaryContent", false, typeof(System.String), 16, true, "", "跟单内容"));
FieldInfoList.Add(new TableFieldInfo("Remarks", false, typeof(System.String), 16, true, "", "备注"));
FieldInfoList.Add(new TableFieldInfo("WorkingField", false, typeof(System.String), 100, true, "", "所属行业"));
FieldInfoList.Add(new TableFieldInfo("CustomerLevel", false, typeof(System.String), 50, true, "", "客户级别"));
FieldInfoList.Add(new TableFieldInfo("Address", false, typeof(System.String), 200, true, "", "地址"));
FieldInfoList.Add(new TableFieldInfo("CompanyWebsite", false, typeof(System.String), 150, true, "", "公司网址"));
FieldInfoList.Add(new TableFieldInfo("MicroBlog", false, typeof(System.String), 250, true, "", "微博"));
FieldInfoList.Add(new TableFieldInfo("OfficialAccounts", false, typeof(System.String), 50, true, "", "公众号"));
FieldInfoList.Add(new TableFieldInfo("RegisteredCapital", false, typeof(System.String), 100, true, "", "注册资本"));
FieldInfoList.Add(new TableFieldInfo("CompanyIntroduction", false, typeof(System.String), 16, true, "", "公司简介"));
FieldInfoList.Add(new TableFieldInfo("TotalStaff", false, typeof(System.Int32), 4, true, "", "总人数"));
FieldInfoList.Add(new TableFieldInfo("Sales", false, typeof(System.Decimal), 8, true, "", "销售额"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", "创建时间"));
FieldInfoList.Add(new TableFieldInfo("EditTime", false, typeof(System.DateTime), 8, true, "", "编辑时间"));
FieldInfoList.Add(new TableFieldInfo("Creator", false, typeof(System.String), 50, true, "", "创建者"));
}
public Comment()
{
FieldInfoList.Add(new TableFieldInfo("CommentID", true, typeof(System.Int64), 8, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("CommentTitle", false, typeof(System.String), 150, true, "", "评论标题"));
FieldInfoList.Add(new TableFieldInfo("CommentContent", false, typeof(System.String), 16, true, "", "评论内容"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ModifyTime", false, typeof(System.DateTime), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Owner", false, typeof(System.String), 50, true, "", "所有者"));
}
public SystemRoleUsersRelation()
{
TableName = "SystemRoleUsersRelation";
PKey = "SystemRoleUsersRelationID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("SystemRoleUsersRelationID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("SystemRoleID", false, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("SystemUserID", false, typeof(System.Int32), 4, false, "", ""));
}
public SystemRole() {
TableName = "SystemRole";
PKey = "SystemRoleID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("SystemRoleID",true,typeof(System.Int32),4,false,"",""));
FieldInfoList.Add(new TableFieldInfo("SystemRoleName",false,typeof(System.String),50,true,"","角色名称"));
FieldInfoList.Add(new TableFieldInfo("RoleDesc",false,typeof(System.String),300,true,"",""));
FieldInfoList.Add(new TableFieldInfo("IsSystem",false,typeof(System.Boolean),1,true,"","是否系统角色"));
}
public DataDictionaryCategory()
{
TableName = "DataDictionaryCategory";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("CategoryCode", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("CategoryName", false, typeof(System.String), 50, true, "", ""));
}
public ADClass()
{
TableName = "ADClass";
PKey = "ADClassID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ADClassID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADClassName", false, typeof(System.String), 100, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Description", false, typeof(System.String), 100, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ParentId", false, typeof(System.Int32), 4, true, "", ""));
}
public SystemRight()
{
TableName = "SystemRight";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("RightCode", false, typeof(System.String), 50, true, "", "权限编号"));
FieldInfoList.Add(new TableFieldInfo("RightName", false, typeof(System.String), 50, true, "", "权限名称"));
FieldInfoList.Add(new TableFieldInfo("RightDesc", false, typeof(System.String), 50, true, "", "说明"));
}
public AttachRelation()
{
TableName = "AttachRelation";
PKey = "AttachRelationID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("AttachRelationID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("AttachID", false, typeof(System.Int32), 4, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("TableName", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("TableID", false, typeof(System.Int32), 4, true, "", "图片分类"));
FieldInfoList.Add(new TableFieldInfo("AttachType", false, typeof(System.String), 50, true, "", ""));
}
public SystemSetup()
{
TableName = "SystemSetup";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("KeyCode", false, typeof(System.String), 100, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("SetupValue", false, typeof(System.String), 1000, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("SetupType", false, typeof(System.String), 100, true, "", "分类"));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 1000, true, "", ""));
}
public DataDictionary()
{
TableName = "DataDictionary";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("CategoryCode", false, typeof(System.String), 40, true, "", "分类ID"));
FieldInfoList.Add(new TableFieldInfo("DataKey", false, typeof(System.String), 40, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("DataValue", false, typeof(System.String), 40, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("OrderNumber", false, typeof(System.Int32), 4, true, "", ""));
}
public SystemLog()
{
TableName = "SystemLog";
PKey = "LogID";
PKeyDataType = typeof(System.Int64);
FieldInfoList.Add(new TableFieldInfo("LogID", true, typeof(System.Int64), 8, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("LogClass", false, typeof(System.String), 50, true, "", "日志类别"));
FieldInfoList.Add(new TableFieldInfo("LogTitle", false, typeof(System.String), 150, true, "", "日志标题"));
FieldInfoList.Add(new TableFieldInfo("LogContent", false, typeof(System.String), 16, true, "", "日志内容"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Operator", false, typeof(System.String), 50, true, "", "操作者"));
}
/// <summary>
/// Map field name (could be meta column name) to FieldInfo. Return null if not found
/// </summary>
public FieldInfo MapFieldDef(string fieldName)
{
string colName = MapColumnName(fieldName);
if (colName == null)
{
return(null);
}
FieldInfoList fields = _formInfo.FieldDefs;
return(fields[fieldName]);
}
public WF_EventDelegate()
{
TableName = "WF_EventDelegate";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("WorkFlowID", false, typeof(System.Int32), 4, true, "", "所属流程ID"));
FieldInfoList.Add(new TableFieldInfo("NodeID", false, typeof(System.Int32), 4, true, "", "节点ID"));
FieldInfoList.Add(new TableFieldInfo("EventName", false, typeof(System.String), 100, true, "", "事件名称"));
FieldInfoList.Add(new TableFieldInfo("DelegatePath", false, typeof(System.String), 150, true, "", "代理方法路径"));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 16, true, "", "备注说明"));
FieldInfoList.Add(new TableFieldInfo("Enabled", false, typeof(System.Boolean), 1, true, "", "是否启用"));
}
public WF_NodeContent()
{
TableName = "WF_NodeContent";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("WorkFlowID", false, typeof(System.Int32), 4, true, "", "所属流程ID"));
FieldInfoList.Add(new TableFieldInfo("NodeID", false, typeof(System.Int32), 4, true, "", "节点ID"));
FieldInfoList.Add(new TableFieldInfo("ContentName", false, typeof(System.String), 300, true, "", "内容名称"));
FieldInfoList.Add(new TableFieldInfo("ContentEditPageUrl", false, typeof(System.String), 250, true, "", "内容编辑页面地址"));
FieldInfoList.Add(new TableFieldInfo("ContentViewPageUrl", false, typeof(System.String), 250, true, "", "内容查看页面地址"));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 16, true, "", "备注"));
}
public WF_NodeOnLine()
{
TableName = "WF_NodeOnLine";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("WorkFlowID", false, typeof(System.Int32), 4, true, "", "流程标识"));
FieldInfoList.Add(new TableFieldInfo("LineID", false, typeof(System.Int32), 4, true, "", "线条标识"));
FieldInfoList.Add(new TableFieldInfo("LineName", false, typeof(System.String), 100, true, "", "线名称"));
FieldInfoList.Add(new TableFieldInfo("StartNodeID", false, typeof(System.Int32), 4, true, "", "开始结点"));
FieldInfoList.Add(new TableFieldInfo("EndNodeID", false, typeof(System.Int32), 4, true, "", "结束结点"));
FieldInfoList.Add(new TableFieldInfo("PassTickets", false, typeof(System.String), 100, true, "", "通行票，为字符串，多个由分号隔开"));
}
public WF_ApprovalLog()
{
TableName = "WF_ApprovalLog";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("InstanceID", false, typeof(System.Int32), 4, true, "", "所属实例ID"));
FieldInfoList.Add(new TableFieldInfo("ApprovalNodeID", false, typeof(System.Int32), 4, true, "", "审批环节ID"));
FieldInfoList.Add(new TableFieldInfo("Approver", false, typeof(System.String), 50, true, "", "审批人"));
FieldInfoList.Add(new TableFieldInfo("AppTime", false, typeof(System.DateTime), 8, true, "", "审批时间"));
FieldInfoList.Add(new TableFieldInfo("ApprovalOpinion", false, typeof(System.String), 16, true, "", "审批意见"));
FieldInfoList.Add(new TableFieldInfo("TheNextStep", false, typeof(System.String), 250, true, "", "下一步，动作路线与节点"));
}
public ADDisplayMode()
{
TableName = "ADDisplayMode";
PKey = "ADDisplayModeCode";
PKeyDataType = typeof(System.String);
FieldInfoList.Add(new TableFieldInfo("ADDisplayModeCode", true, typeof(System.String), 50, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("DisplayModeName", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("IsSystem", false, typeof(System.Boolean), 1, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADType", false, typeof(System.Int32), 4, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("JsCode", false, typeof(System.String), 16, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("CSSCode", false, typeof(System.String), 16, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("DisplayModeTemplateCode", false, typeof(System.String), 16, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Description", false, typeof(System.String), 1000, true, "", ""));
}
public WF_WorkFlow()
{
TableName = "WF_WorkFlow";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("WorkFlowID", false, typeof(System.Int32), 4, true, "", "工作流标识"));
FieldInfoList.Add(new TableFieldInfo("WorkFlowName", false, typeof(System.String), 200, true, "", "工作流名称"));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 1000, true, "", "备注"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", "创建时间"));
FieldInfoList.Add(new TableFieldInfo("Creator", false, typeof(System.String), 50, true, "", "创建者"));
FieldInfoList.Add(new TableFieldInfo("WFAdministrator", false, typeof(System.String), 150, true, "", "流程管理员"));
FieldInfoList.Add(new TableFieldInfo("Enabled", false, typeof(System.Boolean), 1, true, "", "是否启用"));
}
public FieldInfoRow FetchFieldInfoRow(String paColumnName)
{
DataRow[] lcDataRows;
if (!String.IsNullOrEmpty(paColumnName))
{
lcDataRows = FieldInfoList.Select(ctFILColumnName.Replace("$COLUMNNAME", paColumnName));
if ((lcDataRows != null) && (lcDataRows.Length > 0))
{
return(new FieldInfoRow(lcDataRows[0]));
}
}
return(null);
}
public ADContentList()
{
TableName = "ADContentList";
PKey = "ADContentListID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ADContentListID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADID", false, typeof(System.Int32), 4, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADText", false, typeof(System.String), 8000, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("PicUrl", false, typeof(System.String), 250, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("FlashUrl", false, typeof(System.String), 250, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ToolTip", false, typeof(System.String), 250, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("LinkUrl", false, typeof(System.String), 500, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Description", false, typeof(System.String), 500, true, "", ""));
}
public WF_Thread()
{
TableName = "WF_Thread";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("ThreadName", false, typeof(System.String), 50, true, "", "线程名称"));
FieldInfoList.Add(new TableFieldInfo("InstanceID", false, typeof(System.Int32), 4, true, "", "所属实例ID"));
FieldInfoList.Add(new TableFieldInfo("CurrentNodeID", false, typeof(System.Int32), 4, true, "", "当前节点ID"));
FieldInfoList.Add(new TableFieldInfo("CurrentNodeTime", false, typeof(System.DateTime), 8, true, "", "进入当前环节的时间"));
FieldInfoList.Add(new TableFieldInfo("NodeVariableValueXML", false, typeof(System.String), 16, true, "", "结点局部变量值"));
FieldInfoList.Add(new TableFieldInfo("AllApprovers", false, typeof(System.String), 500, true, "", "所有审批人"));
FieldInfoList.Add(new TableFieldInfo("PassedApprovers", false, typeof(System.String), 500, true, "", "已经审批通过的人"));
FieldInfoList.Add(new TableFieldInfo("PassedCount", false, typeof(System.Int32), 4, true, "", "已经通过审批的人数"));
}
public WF_WaitForHandling()
{
TableName = "WF_WaitForHandling";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("HandleCode", false, typeof(System.String), 50, true, "", "待办码 实例ID加顺序码"));
FieldInfoList.Add(new TableFieldInfo("WorkFlowID", false, typeof(System.Int32), 4, true, "", "所属流程ID"));
FieldInfoList.Add(new TableFieldInfo("InstanceID", false, typeof(System.Int32), 4, true, "", "所属实例ID"));
FieldInfoList.Add(new TableFieldInfo("InstanceName", false, typeof(System.String), 500, true, "", "实例名称"));
FieldInfoList.Add(new TableFieldInfo("HandleUrl", false, typeof(System.String), 500, true, "", "办理地址"));
FieldInfoList.Add(new TableFieldInfo("Approver", false, typeof(System.String), 50, true, "", "审批人"));
FieldInfoList.Add(new TableFieldInfo("NodeID", false, typeof(System.Int32), 4, true, "", "待办环节ID"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", "创建时间"));
}
/*
* Create string from single definition entry.
*/
public static string TableToString(GuidTypeInfo guid, FieldInfoList description)
{
string result = "";
using (var stream = new MemoryStream()) {
XmlExporter exporter = new XmlExporter(stream);
TypeInfo info = new TypeInfo(description)
{
Name = guid.TypeName,
Version = guid.Version
};
exporter.WriteTable(info, new GuidTableInfoFormatter());
stream.Position = 0;
result = new StreamReader(stream).ReadToEnd();
}
return(result);
}
public OfficeSupplies()
{
TableName = "OfficeSupplies";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", "序号"));
FieldInfoList.Add(new TableFieldInfo("Code", false, typeof(System.String), 50, true, "", "物品编号"));
FieldInfoList.Add(new TableFieldInfo("GoodsName", false, typeof(System.String), 100, true, "", "物品名称"));
FieldInfoList.Add(new TableFieldInfo("GoodsCateogory", false, typeof(System.String), 100, true, "", "物品类别"));
FieldInfoList.Add(new TableFieldInfo("Specification", false, typeof(System.String), 100, true, "", "规格"));
FieldInfoList.Add(new TableFieldInfo("Unit", false, typeof(System.String), 100, true, "", "单位"));
FieldInfoList.Add(new TableFieldInfo("IndicativePrice", false, typeof(System.Decimal), 8, true, "", "参考价格"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", "创建时间"));
FieldInfoList.Add(new TableFieldInfo("EditTime", false, typeof(System.DateTime), 8, true, "", "修改时间"));
FieldInfoList.Add(new TableFieldInfo("Creator", false, typeof(System.String), 50, true, "", "创建者"));
}
public WF_AlreadyHandled()
{
TableName = "WF_AlreadyHandled";
PKey = "ID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("WorkFlowID", false, typeof(System.Int32), 4, true, "", "所属流程ID"));
FieldInfoList.Add(new TableFieldInfo("InstanceID", false, typeof(System.Int32), 4, true, "", "所属实例ID"));
FieldInfoList.Add(new TableFieldInfo("InstanceName", false, typeof(System.String), 500, true, "", "实例名称"));
FieldInfoList.Add(new TableFieldInfo("ViewUrl", false, typeof(System.String), 500, true, "", "查看地址"));
FieldInfoList.Add(new TableFieldInfo("Approver", false, typeof(System.String), 50, true, "", "审批人"));
FieldInfoList.Add(new TableFieldInfo("NodeID", false, typeof(System.Int32), 4, true, "", "办理环节ID"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", "创建时间"));
FieldInfoList.Add(new TableFieldInfo("HandleDuration", false, typeof(System.Int64), 8, true, "", "办理时长(百奈秒)"));
FieldInfoList.Add(new TableFieldInfo("HandleStatus", false, typeof(System.String), 100, true, "", "办理状况，如及时、延时、异常等"));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 16, true, "", "备注"));
}
public WF_Instance()
{
TableName = "WF_Instance";
PKey = "InstanceID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("InstanceID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("InstanceName", false, typeof(System.String), 500, true, "", "实例名称"));
FieldInfoList.Add(new TableFieldInfo("WorkFlowID", false, typeof(System.Int32), 4, true, "", "所属工作流程标识"));
FieldInfoList.Add(new TableFieldInfo("Status", false, typeof(System.Int32), 4, true, "", "流程实例状态"));
FieldInfoList.Add(new TableFieldInfo("Threads", false, typeof(System.String), 100, true, "", "实例线程集"));
FieldInfoList.Add(new TableFieldInfo("ThreadCount", false, typeof(System.Int32), 4, true, "", "线程数量"));
FieldInfoList.Add(new TableFieldInfo("VariableValueXML", false, typeof(System.String), 16, true, "", "实例全局变量值"));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", "创建时间"));
FieldInfoList.Add(new TableFieldInfo("FinishTime", false, typeof(System.DateTime), 8, true, "", "实例结束时间"));
FieldInfoList.Add(new TableFieldInfo("MaxHandleCode", false, typeof(System.String), 50, true, "", "最大待办码"));
FieldInfoList.Add(new TableFieldInfo("Remark", false, typeof(System.String), 16, true, "", "备注"));
}
public AD()
{
TableName = "AD";
PKey = "ADID";
PKeyDataType = typeof(System.Int32);
FieldInfoList.Add(new TableFieldInfo("ADID", true, typeof(System.Int32), 4, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADName", false, typeof(System.String), 300, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADClassID", false, typeof(System.Int32), 4, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("DisplayPrickle", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("DisplayWidth", false, typeof(System.Double), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("DisplayHeight", false, typeof(System.Double), 8, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADType", false, typeof(System.Int32), 4, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("ADDisplayModeCode", false, typeof(System.String), 50, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("Description", false, typeof(System.String), 300, true, "", ""));
FieldInfoList.Add(new TableFieldInfo("IsDisplay", false, typeof(System.Boolean), 1, false, "", ""));
FieldInfoList.Add(new TableFieldInfo("CreateTime", false, typeof(System.DateTime), 8, true, "", ""));
}
