protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "EXECTASKDATAID", "执行标识号", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "CREATETIME", "创建时间")
{
DataType = LibDataType.Int64, ControlType = LibControlType.DateTime
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "RESULTDATA", "结果数据")
{
DataType = LibDataType.Binary, ControlType = LibControlType.NText
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["EXECTASKDATAID"] };
this.DataSet.Tables.Add(masterTable);
}
///<summary>
///构建数据库模型
///</summary>
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable comType = new DataTable(tableName);
//构建表结构
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONID", "原因代码", FieldSize.Size20)
{
AllowCopy = false, AllowEmpty = false, DataType = LibDataType.Text
});
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONNAME", "原因名称", FieldSize.Size50)
{
AllowEmpty = false, DataType = LibDataType.NText
});
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONTYPEID", "原因类别", FieldSize.Size20)
{
AllowEmpty = false,
DataType = LibDataType.Text,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.AbnormalReasonType")
{
RelFields = new RelFieldCollection()
{
new RelField("ABNORMALREASONTYPENAME", LibDataType.NText, FieldSize.Size50, "原因类别名称")
}
}
}
});
DataSourceHelper.AddFixColumn(comType, this.BillType); //系统自动创建的内容
comType.PrimaryKey = new DataColumn[] { comType.Columns["ABNORMALREASONID"] }; //定义表的主键
this.DataSet.Tables.Add(comType);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUSINESSTASKID", "任务代码", FieldSize.Size50)
{
AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUSINESSTASKNAME", "任务名称", FieldSize.Size50)
{
ControlType = LibControlType.NText
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["PROGID"], masterTable.Columns["BUSINESSTASKID"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable headTable = new DataTable();
DataSourceHelper.AddColumn(new DefineField(headTable, "KEY", "主键", FieldSize.Size20));
headTable.PrimaryKey = new DataColumn[] { headTable.Columns["KEY"] };
this.DataSet.Tables.Add(headTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "EXCEL", "Excel", FieldSize.Size50));
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["EXCEL"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "ABNORMALID";
DataTable dt = new DataTable(tableName);
DataSourceHelper.AddColumn(new DefineField(dt, primaryName, "异常代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(dt, "ABNORMALNAME", "异常名称", FieldSize.Size50)
{
DataType = LibDataType.NText, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(dt, "ABNORMALTYPEID", "异常类别", FieldSize.Size20)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.AbnormalType")
{
RelFields = new RelFieldCollection()
{
new RelField("ABNORMALTYPENAME", LibDataType.NText, FieldSize.Size50, "异常类别名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(dt, "BIZATTR", "业务属性")
{
DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, TextOption = new string[] { "生产计划", "生产过程", "采购", "仓储物流" }
});
DataSourceHelper.AddColumn(new DefineField(dt, "DEPTID", "责任部门", FieldSize.Size20)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Dept")
{
RelFields = new RelFieldCollection()
{
new RelField("DEPTNAME", LibDataType.NText, FieldSize.Size50, "责任部门名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(dt, "CHANGETYPE", "所属类型")
{
DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, TextOption = new string[] { "设计", "班组", "设备", "物料", "品质", "其它" }
});
DataSourceHelper.AddFixColumn(dt, this.BillType);
dt.PrimaryKey = new DataColumn[] { dt.Columns[primaryName] };
this.DataSet.Tables.Add(dt);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "RPTSEARCHID", "条件代码", FieldSize.Size20)
{
AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ISON", "是否启用")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, DefaultValue = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "USERID", "账户ID", FieldSize.Size20)
{
DataType = LibDataType.Text, ControlType = LibControlType.NText
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["RPTSEARCHID"] };
this.DataSet.Tables.Add(masterTable);
DataTable bodyTable = new DataTable(bodyTableName);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "RPTSEARCHID", "条件代码", FieldSize.Size20));
DataSourceHelper.AddRowId(bodyTable);
DataSourceHelper.AddRowNo(bodyTable);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "SEARCHFIELD", "选择字段", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource()
{
}
}
});
bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns["RPTSEARCHID"], bodyTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(bodyTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", masterTableName, bodyTableName), masterTable.Columns["RPTSEARCHID"], bodyTable.Columns["RPTSEARCHID"]);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "NEWSID", "消息代码", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "USERID", "用户账号", FieldSize.Size20));
DataSourceHelper.AddColumn(new DefineField(masterTable, "TITLE", "主题", FieldSize.Size200)
{
DataType = LibDataType.NText, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "MAINCONTENT", "主要内容", FieldSize.Size1000)
{
DataType = LibDataType.Binary, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "INFOID", "附带信息", FieldSize.Size100)
{
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "CREATETIME", "时间")
{
DataType = LibDataType.Int64, ControlType = LibControlType.DateTime
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PERSONID", "发送人", FieldSize.Size20)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Person")
{
RelFields = new RelFieldCollection()
{
new RelField("PERSONNAME", LibDataType.NText, FieldSize.Size50, "发送人名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ISREAD", "已读")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DBIndexCollection dbList = new DBIndexCollection();
dbList.Add(new DBIndex("NEWS_CREATETIME_IDX", new DBIndexFieldCollection()
{
new DBIndexField("CREATETIME")
}));
masterTable.ExtendedProperties.Add(TableProperty.DBIndex, dbList);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["NEWSID"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "ROLEID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "角色代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ROLENAME", "角色名称", FieldSize.Size50)
{
AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ISUNLIMITED", "无限制")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
DataTable bodyTable = new DataTable(bodyTableName);
DataSourceHelper.AddColumn(new DefineField(bodyTable, primaryName, "角色代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(bodyTable);
DataSourceHelper.AddRowNo(bodyTable);
DataSourceHelper.AddRemark(bodyTable);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "PERMISSIONGROUPID", "权限组", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.PermissionGroup")
{
RelFields = new RelFieldCollection()
{
new RelField("PERMISSIONGROUPNAME", LibDataType.NText, FieldSize.Size50, "权限组名称")
}
}
}
});
bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(bodyTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", masterTableName, bodyTableName), masterTable.Columns[primaryName], bodyTable.Columns[primaryName]);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "INTERNALID", "单据内码", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "FROMROWID", "行标识号")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "CREATETIME", "创建时间")
{
DataType = LibDataType.Int64, ControlType = LibControlType.DateTime
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "REASONID", "变动原因", FieldSize.Size20)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.ChangeDataReason")
{
RelFields = new RelFieldCollection()
{
new RelField("REASONNAME", LibDataType.NText, FieldSize.Size50, "变动原因名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "VERSIONDATA", "版本数据")
{
DataType = LibDataType.Binary, ControlType = LibControlType.NText
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["INTERNALID"], masterTable.Columns["FROMROWID"], masterTable.Columns["CREATETIME"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "TASKID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "任务代码", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUSINESSTASKID", "任务代码", FieldSize.Size100)
{
AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "EXECDATE", "执行日期")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Date
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "EXECTIME", "执行时间")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Time
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "EXECCONDITION", "执行条件")
{
DataType = LibDataType.Binary, ControlType = LibControlType.Text, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "INTERNALID", "内码", FieldSize.Size50)
{
DataType = LibDataType.Text, ControlType = LibControlType.Text
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "REASONID";
DataTable masterTable = new DataTable(TableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "原因编号", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "REASONNAME", "原因名称", FieldSize.Size50)
{
DataType = LibDataType.NText, AllowEmpty = false
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
}
///<summary>
///构建数据库模型
///</summary>
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable comType = new DataTable(tableName);
//构建表结构
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONTYPEID", "原因类别编号", FieldSize.Size50)
{
AllowCopy = false, AllowEmpty = false, DataType = LibDataType.Text
});
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONTYPENAME", "原因类别名称", FieldSize.Size20)
{
DataType = LibDataType.NText, AllowEmpty = false
});
DataSourceHelper.AddFixColumn(comType, this.BillType); //系统自动创建的内容
comType.PrimaryKey = new DataColumn[] { comType.Columns["ABNORMALREASONTYPEID"] }; //定义表的主键
this.DataSet.Tables.Add(comType);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "PROGID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "功能标识", FieldSize.Size50)
{
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGNAME", "功能名称", FieldSize.Size50)
{
DataType = LibDataType.NText, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "CONFIGPACK", "配置包", FieldSize.Size20)
{
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "CANMENU", "允许挂菜单")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "KEYCODE", "快捷码", FieldSize.Size20)
{
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PERMISSION", "权限标识")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BILLTYPE", "功能种类")
{
DataType = LibDataType.Int32,
ControlType = LibControlType.TextOption,
TextOption = new string[] { "主数据", "单据", "数据维护功能", "自定义功能", "报表", "日报表" },
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGTAG", "功能标签", FieldSize.Size100)
{
ReadOnly = true
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
}
///<summary>
///构建数据库模型
///</summary>
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable table = new DataTable(tableName);
//构建表结构
DataSourceHelper.AddColumn(new DefineField(table, "TYPEID", "单据类型代码", FieldSize.Size50)
{
DataType = LibDataType.Text, AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(table, "TYPENAME", "单据类型名称", FieldSize.Size20)
{
DataType = LibDataType.NText, AllowEmpty = false
});
DataSourceHelper.AddDefaultCreateState(table);
DataSourceHelper.AddFixColumn(table, this.BillType);
table.PrimaryKey = new DataColumn[] { table.Columns["TYPEID"] };
this.DataSet.Tables.Add(table);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "MENUITEM", "清单名称", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGNAME", "功能名称", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "BILLTYPE", "功能种类")
{
DataType = LibDataType.Int32,
ControlType = LibControlType.TextOption,
TextOption = new string[] { "主数据", "单据", "数据维护功能", "自定义功能", "报表", "日报表" },
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ENTRYPARAM", "入口参数", FieldSize.Size200));
DataSourceHelper.AddColumn(new DefineField(masterTable, "PUBLISHDATE", "发布日期", FieldSize.Size200));
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["PROGID"], masterTable.Columns["ENTRYPARAM"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "PROGID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "功能标识", FieldSize.Size50)
{
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUTTONID", "按钮标识", FieldSize.Size50)
{
ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUTTONNAME", "按钮名称", FieldSize.Size50)
{
ReadOnly = true, ControlType = LibControlType.NText, DataType = LibDataType.NText
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName], masterTable.Columns["BUTTONID"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable comPost = new DataTable(comPostName);
DataSourceHelper.AddColumn(new DefineField(comPost, "DUTYID", "职务代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(comPost, "DUTYNAME", "职务名称", FieldSize.Size50)
{
DataType = LibDataType.NText, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(comPost, "DUTYLEVEL", "职务级别")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, QtyLimit = LibQtyLimit.GreaterOrEqualThanZero, Precision = 0, DefaultValue = 0, AllowEmpty = false
});
DataSourceHelper.AddFixColumn(comPost, BillType);
comPost.PrimaryKey = new DataColumn[] { comPost.Columns["DUTYID"] };
this.DataSet.Tables.Add(comPost);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "USERID", "账号", FieldSize.Size20));
DataSourceHelper.AddColumn(new DefineField(masterTable, "CREATETIME", "句柄创建时间")
{
DataType = LibDataType.Int64, ControlType = LibControlType.DateTime
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "HANDLETYPE", "终端类型")
{
DataType = LibDataType.Int32
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "FREETIME", "句柄释放时间")
{
DataType = LibDataType.Int64, ControlType = LibControlType.DateTime
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["USERID"], masterTable.Columns["CREATETIME"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "PURCHASERID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "客户代码", FieldSize.Size20));
DataSourceHelper.AddColumn(new DefineField(masterTable, "PURCHASERNAME", "客户名称", FieldSize.Size50)
{
DataType = LibDataType.NText
});
//-1为不限制使用数
DataSourceHelper.AddColumn(new DefineField(masterTable, "MAXUSERCOUNT", "最大用户数")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, DefaultValue = -1
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "MAXWORKSTATIONCOUNT", "最大站点数")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, DefaultValue = -1
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "SITEID", "站点代码", FieldSize.Size20)
{
AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "SITENAME", "站点名称", FieldSize.Size100)
{
AllowEmpty = false, DataType = LibDataType.NText, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "SHORTNAME", "简称", FieldSize.Size10)
{
AllowEmpty = false, DataType = LibDataType.NText, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "SITEURL", "站点地址", FieldSize.Size200)
{
AllowEmpty = false, DataType = LibDataType.NText, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "SVCURL", "服务地址", FieldSize.Size200)
{
AllowEmpty = true, DataType = LibDataType.NText, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ISSLAVE", "是否从站")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, AllowEmpty = false, DefaultValue = true
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ISSENDTO", "是否向其发送同步数据")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, AllowEmpty = false, DefaultValue = true
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["SITEID"] };
this.DataSet.Tables.Add(masterTable);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "BILLNO";
DataTable headTable = new DataTable(tableName);
DataSourceHelper.AddColumn(new DefineField(headTable, primaryName, "单据编号", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false, DataType = LibDataType.Text
});
DataSourceHelper.AddColumn(new DefineField(headTable, "TYPEID", "单据类型", FieldSize.Size20)
{
AllowEmpty = false,
DataType = LibDataType.Text,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.LiaisonType")
{
RelFields = new RelFieldCollection()
{
new RelField("TYPENAME", LibDataType.NText, FieldSize.Size50, "单据类型名称")
}
}
}
});
DataSourceHelper.AddBillDate(headTable);
DataSourceHelper.AddColumn(new DefineField(headTable, "PRIORITYSTATE", "急缓程度")
{
DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, DefaultValue = 1, TextOption = new string[] { "轻缓", "普通", "紧急" }
});
DataSourceHelper.AddColumn(new DefineField(headTable, "PERSONID", "接收人", FieldSize.Size20)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Person")
{
RelFields = new RelFieldCollection()
{
new RelField("PERSONNAME", LibDataType.NText, FieldSize.Size50, "接收人名称")
},
SetValueFields = new SetValueFieldCollection()
{
new SetValueField("DEPTID"),
new SetValueField("DEPTNAME")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(headTable, "DEPTID", "接收部门", FieldSize.Size20)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Dept")
{
RelFields = new RelFieldCollection()
{
new RelField("DEPTNAME", LibDataType.NText, FieldSize.Size50, "接收部门名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(headTable, "TITLE", "主题", FieldSize.Size200)
{
ColumnSpan = 3, RowSpan = 1
});
DataSourceHelper.AddColumn(new DefineField(headTable, "MAINCONTENT", "主要内容", FieldSize.Size1000)
{
ColumnSpan = 2, RowSpan = 4
});
DataSourceHelper.AddColumn(new DefineField(headTable, "REPLYCONTENT", "回执情况", FieldSize.Size1000)
{
ColumnSpan = 2, RowSpan = 4
});
DataSourceHelper.AddColumn(new DefineField(headTable, "SENDPERSONID", "签发人", FieldSize.Size20)
{
AllowEmpty = false,
DataType = LibDataType.Text,
ControlType = LibControlType.NText,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Person")
{
RelFields = new RelFieldCollection()
{
new RelField("PERSONNAME", LibDataType.NText, FieldSize.Size50, "签发人名称", "SENDPERSONNAME"),
new RelField("DEPTID", LibDataType.Text, FieldSize.Size50, "签发部门", "SENDDEPTID")
{
ControlType = LibControlType.IdName
},
new RelField("DEPTNAME", LibDataType.NText, FieldSize.Size50, "签发部门名称", "SENDDEPTNAME")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(headTable, "INFOID", "附带信息", FieldSize.Size100)
{
ColumnSpan = 1, ReadOnly = true
});
DataSourceHelper.AddFixColumn(headTable, this.BillType);
headTable.PrimaryKey = new DataColumn[] { headTable.Columns[primaryName] };
this.DataSet.Tables.Add(headTable);
}
///<summary>
///异常报告单单据类型 数据模型
///</summary>
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
#region 异常报告单单据类型 主表
DataTable masterTable = new DataTable(tableName);
string primaryName = "TYPEID";
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "单据类型代码", FieldSize.Size50)
{
DataType = LibDataType.Text, AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "TYPENAME", "单据类型名称", FieldSize.Size20)
{
DataType = LibDataType.NText, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "ISREPULSE", "可拒绝")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "DEFAULTCREATESTATE", "缺省创建状态")
{
AllowEmpty = false, DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, DefaultValue = 1, TextOption = new string[] { "未生效", "生效" }
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["TYPEID"] };
this.DataSet.Tables.Add(masterTable);
#endregion
#region 异常报告单单据类型 子表 消息传递流程规则配置
DataTable bodyTable = new DataTable(bodyTableName);
DataSourceHelper.AddColumn(new DefineField(bodyTable, primaryName, "单据类型代码", FieldSize.Size50)
{
DataType = LibDataType.Text, AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(bodyTable);
DataSourceHelper.AddRowNo(bodyTable);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "USECONDITION", "使用条件", FieldSize.Size500)
{
DataType = LibDataType.Text, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "USECONDITIONDESC", "使用条件说明", FieldSize.Size200)
{
DataType = LibDataType.Text
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "FLOWDETAIL", "消息传递流程明细")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true, SubTableIndex = 2
});
DataSourceHelper.AddRemark(bodyTable);
bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(bodyTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", tableName, bodyTableName), masterTable.Columns[primaryName], bodyTable.Columns[primaryName]);
#endregion
#region 异常报告单单据类型 消息传递流程规则配置 子子表 消息传递流程明细
DataTable subTable = new DataTable(subTableName);
DataSourceHelper.AddColumn(new DefineField(subTable, primaryName, "单据类型代码", FieldSize.Size50)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(subTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(subTable);
DataSourceHelper.AddRowNo(subTable);
DataSourceHelper.AddColumn(new DefineField(subTable, "TRANSMITLEVEL", "传递层级")
{
DefaultValue = 1, DataType = LibDataType.Int32, ControlType = LibControlType.Number, QtyLimit = LibQtyLimit.GreaterThanZero
});
DataSourceHelper.AddColumn(new DefineField(subTable, "PERSONID", "接收人代码", FieldSize.Size20)
{
#region 人员
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Person")
{
RelFields = new RelFieldCollection()
{
new RelField("PERSONNAME", LibDataType.NText, FieldSize.Size50, "接收人名称"),
new RelField("POSITION", LibDataType.NText, FieldSize.Size50, "职位"),
new RelField("PHONENO", LibDataType.Text, FieldSize.Size20, "电话"),
new RelField("WECHAT", LibDataType.NText, FieldSize.Size50, "微信")
}
}
}
#endregion
});
DataSourceHelper.AddColumn(new DefineField(subTable, "NEEDSMS", "发短信")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddColumn(new DefineField(subTable, "SENDWECHAT", "发微信")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddColumn(new DefineField(subTable, "CONTROLTIME", "响应时效")
{
DataType = LibDataType.Double, ControlType = LibControlType.Double
});
DataSourceHelper.AddColumn(new DefineField(subTable, "TIMEUNIT", "时间单位")
{
DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, TextOption = new string[] { "小时", "分钟" }
});
DataSourceHelper.AddRemark(subTable);
subTable.PrimaryKey = new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"], subTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(subTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", bodyTableName, subTableName), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"] });
#endregion
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
#region 单据业务流配置 主表
string primaryName = "BUSINESSFLOWCONFIGID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "业务流配置代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false, ControlType = LibControlType.Text
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUSINESSFLOWCONFIGNAME", "业务流配置名称", FieldSize.Size50)
{
AllowEmpty = false, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
#region 功能清单
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
#endregion
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
#endregion
#region 单据业务流配置 子表 单据业务流配置规则配置
DataTable bodyTable = new DataTable(bodyTableName);
DataSourceHelper.AddColumn(new DefineField(bodyTable, primaryName, "业务流配置代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false, ControlType = LibControlType.Text
});
DataSourceHelper.AddRowId(bodyTable);
DataSourceHelper.AddRowNo(bodyTable);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "USECONDITION", "使用条件", FieldSize.Size500)
{
DataType = LibDataType.Text, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "USECONDITIONDESC", "使用条件说明", FieldSize.Size200)
{
DataType = LibDataType.Text
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "BUSINESSPUSHFLOWDETAIL", "业务流配置明细")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true, SubTableIndex = 2
});
DataSourceHelper.AddRemark(bodyTable);
bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(bodyTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", masterTableName, bodyTableName), masterTable.Columns[primaryName], bodyTable.Columns[primaryName]);
#endregion
#region 单据业务流配置 单据业务流配置规则配置 子子表 业务流配置明细
DataTable subTable = new DataTable(subTableName);
DataSourceHelper.AddColumn(new DefineField(subTable, primaryName, "业务流配置代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false, ControlType = LibControlType.Text
});
DataSourceHelper.AddRowId(subTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(subTable);
DataSourceHelper.AddRowNo(subTable);
DataSourceHelper.AddColumn(new DefineField(subTable, "PERSONID", "接收人代码", FieldSize.Size20)
{
#region 人员
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Person")
{
RelFields = new RelFieldCollection()
{
new RelField("PERSONNAME", LibDataType.NText, FieldSize.Size50, "接收人名称"),
new RelField("POSITION", LibDataType.NText, FieldSize.Size50, "职位"),
new RelField("PHONENO", LibDataType.Text, FieldSize.Size20, "电话"),
new RelField("WECHAT", LibDataType.NText, FieldSize.Size50, "微信")
}
}
}
#endregion
});
DataSourceHelper.AddColumn(new DefineField(subTable, "NEEDSMS", "发短信")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddColumn(new DefineField(subTable, "SENDWECHAT", "发微信")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddRemark(subTable);
subTable.PrimaryKey = new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"], subTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(subTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", bodyTableName, subTableName), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"] });
#endregion
}
/// <summary>
/// 创建数据集合
/// </summary>
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
#region 文档目录
//文档目录
DataTable dmDir = new DataTable(dmDirTableName);
//目录代码ReadOnly为true是为了通过前台功能按钮来设置
DataSourceHelper.AddColumn(new DefineField(dmDir, dmDirPKID, "目录代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(dmDir, "DIRNAME", "目录名称", FieldSize.Size100)
{
DataType = LibDataType.NText, AllowEmpty = false,
});
//此项仅后台统计本级目录下的文档数，不包含子目录下的文档数
DataSourceHelper.AddColumn(new DefineField(dmDir, "DOCCOUNT", "文档数")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(dmDir, "PARENTDIRID", "父目录代码", FieldSize.Size20)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("dm.Directory")
{
RelFields = new RelFieldCollection()
{
new RelField("DIRNAME", LibDataType.NText, FieldSize.Size50, "父目录名称", "PARENTDIRNAME"),
new RelField("DIRPATH", LibDataType.NText, FieldSize.Size2000, "父目录存储路径", "PARENTDIRPATH")
},
SelConditions = new SelConditionCollection()
{
//必须是相同目录类型的才能作为父目录,不能引用自身或自身的子目录(BeforeUpdate时再判断)
new SelCondition()
{
Condition = "A.DIRTYPE = @A.DIRTYPE AND A.DIRID<> @A.DIRID "
}
}
}
}
});
//目录类型只能在创建时根据其对应的根目录类型确定，不可直接修改
DataSourceHelper.AddColumn(new DefineField(dmDir, "DIRTYPE", "目录类型")
{
DataType = LibDataType.Int32,
AllowEmpty = false,
ReadOnly = true,
ControlType = LibControlType.TextOption,
TextOption = new string[] { "公共", "个人" },
DefaultValue = DirTypeEnum.Public,
});
//目录在文档库磁盘上的文件夹名称（不包含路径）
DataSourceHelper.AddColumn(new DefineField(dmDir, "DIRPATH", "存储路径", FieldSize.Size2000)
{
DataType = LibDataType.NText, ControlType = LibControlType.NText, ReadOnly = true
});
//虚字段 目录链接，根据目录的父目录关系，构造形如"\公共文档\财务部文档"的目录链接地址样式。前端不可修改
DataSourceHelper.AddColumn(new DefineField(dmDir, "DIRLINKADDRESS", "目录链接", FieldSize.Size2000)
{
ControlType = LibControlType.Id, ReadOnly = true, FieldType = FieldType.Virtual
});
//用于同一级目录下的子目录排序
DataSourceHelper.AddColumn(new DefineField(dmDir, "SORTORDER", "目录排序")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number
});
DataSourceHelper.AddFixColumn(dmDir, BillType);
#region 为显示目录下的文档信息添加的虚字段
DataSourceHelper.AddColumn(new DefineField(dmDir, "DOCID", "文档编号", FieldSize.Size50)
{
DataType = LibDataType.Text, AllowCopy = false, FieldType = FieldType.Virtual
});
DataSourceHelper.AddColumn(new DefineField(dmDir, "DOCNAME", "文档名称", FieldSize.Size200)
{
DataType = LibDataType.NText, ReadOnly = true, FieldType = FieldType.Virtual
}); //如果类型是目录，则为目录名
//是否是目录，此字段为虚字段，后台设置，用于向前端传递信息
DataSourceHelper.AddColumn(new DefineField(dmDir, "ISDIR", "是否目录")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true, FieldType = FieldType.Virtual
});
//如txt,doc等，如果用于展示目录信息则此项固定为“目录”
DataSourceHelper.AddColumn(new DefineField(dmDir, "DOCTYPE", "类型", FieldSize.Size20)
{
DataType = LibDataType.NText, ReadOnly = true, FieldType = FieldType.Virtual
});
DataSourceHelper.AddColumn(new DefineField(dmDir, "LOCKSTATE", "锁定状态")
{
DataType = LibDataType.Int32, ReadOnly = true, ControlType = LibControlType.TextOption, TextOption = new string[] { "未锁定", "已锁定" }, FieldType = FieldType.Virtual
});
//此项仅后台设置的文档的大小，以M为单位，保留2位小数
DataSourceHelper.AddColumn(new DefineField(dmDir, "DOCSIZE", "大小(M)")
{
DataType = LibDataType.Numeric, ControlType = LibControlType.Double, Precision = 2, ReadOnly = true, FieldType = FieldType.Virtual
});
//此路径为文档的多个修订版和设定版文件所在的目录名称（不包含其他路径）
DataSourceHelper.AddColumn(new DefineField(dmDir, "SAVEPATH", "文档存储路径", FieldSize.Size2000)
{
DataType = LibDataType.NText, ControlType = LibControlType.NText, ReadOnly = true, FieldType = FieldType.Virtual
});
#endregion
dmDir.PrimaryKey = new DataColumn[] { dmDir.Columns[dmDirPKID] };
this.DataSet.Tables.Add(dmDir);
#endregion
#region 文档目录的权限
//文档目录的权限
DataTable dmDirPermission = new DataTable(dmDirPermissionTableName);
DataSourceHelper.AddColumn(new DefineField(dmDirPermission, "DIRID", "目录代码", FieldSize.Size20)
{
ControlType = LibControlType.Id, AllowEmpty = false, ReadOnly = true
});
DataSourceHelper.AddRowId(dmDirPermission);
DataSourceHelper.AddRowNo(dmDirPermission);
//权限拥有者类型，如部门、用户组、个人，如果此权限是属于部门的，则部门下的所有人都有相应的权限
DataSourceHelper.AddColumn(new DefineField(dmDirPermission, "BELONGTYPE", "拥有者类型")
{
DataType = LibDataType.Int32, AllowEmpty = false, ControlType = LibControlType.TextOption, TextOption = new string[] { "部门", "用户组", "个人" }
});
//此项根据拥有者类型确定是部门代码，还是个人或用户组代码(后续扩展)
DataSourceHelper.AddColumn(new DefineField(dmDirPermission, "BELONGID", "拥有者代码", FieldSize.Size20)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Dept")
{
GroupCondation = "B.BELONGTYPE=0",
GroupIndex = 0,
//RelPK="A.DEPTID",
RelFields = new RelFieldCollection()
{
new RelField("DEPTNAME", LibDataType.NText, FieldSize.Size50, "部门名称") //如果拥有者类型是部门的则代码是部门代码，名称显示部门名称
}
//,
////测试更多列属性用于关键字筛选
//IdNameFilterFields=new RelFieldCollection()
//{
// new RelField("CREATORID",LibDataType.NText,FieldSize.Size20,"创建者标识"),
// new RelField("CREATETIME",LibDataType.Int32,FieldSize.Size20,"时间"),
//}
},
new RelativeSource("com.Person")
{
GroupCondation = "B.BELONGTYPE=2",
GroupIndex = 1,
//RelPK="A.PERSONID",
RelFields = new RelFieldCollection()
{
new RelField("PERSONNAME", LibDataType.NText, FieldSize.Size50, "人员名称")//如果拥有者类型是个人的则代码是个人代码，名称显示人员名称
}
}
}
});
//是否设置了操作权限
DataSourceHelper.AddColumn(new DefineField(dmDirPermission, "ISOPERATEPOWER", "操作权限")
{
ReadOnly = true, DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, SubTableIndex = 2
});
//权限值，是权限项组合的按位与 得出的Int32值。通过SubBill的页面获得
DataSourceHelper.AddColumn(new DefineField(dmDirPermission, "OPERATEMARK", "操作权限标识")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
dmDirPermission.PrimaryKey = new DataColumn[] { dmDirPermission.Columns["DIRID"], dmDirPermission.Columns["ROW_ID"] };
this.DataSet.Tables.Add(dmDirPermission);
this.DataSet.Relations.Add(string.Format("{0}_{1}", dmDirTableName, dmDirPermissionTableName), new DataColumn[] { dmDir.Columns[dmDirPKID] }, new DataColumn[] { dmDirPermission.Columns[dmDirPKID] });
#endregion
#region 操作权限SubBill
DataTable subTable = new DataTable(dmSubTableName);
DataSourceHelper.AddColumn(new DefineField(subTable, dmDirPKID, "目录代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(subTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(subTable);
DataSourceHelper.AddRowNo(subTable);
DataSourceHelper.AddColumn(new DefineField(subTable, "OPERATEPOWERID", "操作代码")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(subTable, "OPERATEPOWERNAME", "操作", FieldSize.Size50)
{
DataType = LibDataType.NText, ControlType = LibControlType.NText, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(subTable, "CANUSE", "具备权限")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddRemark(subTable);
subTable.PrimaryKey = new DataColumn[] { subTable.Columns[dmDirPKID], subTable.Columns["PARENTROWID"], subTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(subTable);
this.DataSet.Relations.Add(PermissionDetailSubRelationName,
new DataColumn[] { dmDirPermission.Columns[dmDirPKID], dmDirPermission.Columns["ROW_ID"] },
new DataColumn[] { subTable.Columns[dmDirPKID], subTable.Columns["PARENTROWID"] });
#endregion
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "PRINTTPLID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "打印模板代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PRINTTPLNAME", "打印模板名称", FieldSize.Size50)
{
AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
DataTable bodyTable = new DataTable(bodyTableName);
DataSourceHelper.AddColumn(new DefineField(bodyTable, primaryName, "打印模板代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(bodyTable);
DataSourceHelper.AddRowNo(bodyTable);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "USECONDITION", "使用条件", FieldSize.Size500));
DataSourceHelper.AddColumn(new DefineField(bodyTable, "USECONDITIONDESC", "使用条件说明", FieldSize.Size200));
DataSourceHelper.AddColumn(new DefineField(bodyTable, "PRINTDETAIL", "打印明细")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true, SubTableIndex = 2
});
DataSourceHelper.AddRemark(bodyTable);
bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(bodyTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", masterTableName, bodyTableName), masterTable.Columns[primaryName], bodyTable.Columns[primaryName]);
DataTable subTable = new DataTable(subTableName);
DataSourceHelper.AddColumn(new DefineField(subTable, primaryName, "打印模板代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(subTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(subTable);
DataSourceHelper.AddRowNo(subTable);
DataSourceHelper.AddColumn(new DefineField(subTable, "ISTPL", "模板设计")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(subTable, "FIELDDETAIL", "字段明细")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true, SubTableIndex = 3
});
DataSourceHelper.AddColumn(new DefineField(subTable, "TPLJS", "模板脚本")
{
DataType = LibDataType.Binary, ControlType = LibControlType.NText, ReadOnly = true
});
DataSourceHelper.AddRemark(subTable);
subTable.PrimaryKey = new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"], subTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(subTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", bodyTableName, subTableName), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"] });
DataTable mapTable = new DataTable(mapTableName);
DataSourceHelper.AddColumn(new DefineField(mapTable, primaryName, "打印模板代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(mapTable, "GRANDFATHERROWID", "主行标识");
DataSourceHelper.AddRowId(mapTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(mapTable);
DataSourceHelper.AddRowNo(mapTable);
DataSourceHelper.AddColumn(new DefineField(mapTable, "TPLPARAM", "参数", FieldSize.Size50)
{
DataType = LibDataType.Text, ControlType = LibControlType.Text, ReadOnly = true, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(mapTable, "TABLEINDEX", "对应表索引")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, QtyLimit = LibQtyLimit.GreaterOrEqualThanZero
});
DataSourceHelper.AddColumn(new DefineField(mapTable, "FIELDNAME", "对应字段", FieldSize.Size50)
{
ControlType = LibControlType.FieldControl, RelProgId = "A.PROGID", AllowEmpty = false, RelTableIndex = "C.TABLEINDEX"
});
DataSourceHelper.AddRemark(mapTable);
mapTable.PrimaryKey = new DataColumn[] { mapTable.Columns[primaryName], mapTable.Columns["GRANDFATHERROWID"], mapTable.Columns["PARENTROWID"], mapTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(mapTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", subTableName, mapTableName), new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"], subTable.Columns["ROW_ID"] }, new DataColumn[] { mapTable.Columns[primaryName], mapTable.Columns["GRANDFATHERROWID"], mapTable.Columns["PARENTROWID"] });
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "CALENDARID";
DataTable mainTable = new DataTable(mainTableName);
DataSourceHelper.AddColumn(new DefineField(mainTable, primaryName, "行事历代码", FieldSize.Size20)
{
AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(mainTable, "CALENDARNAME", "行事历名称", FieldSize.Size50)
{
AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(mainTable, "ISWORKSATURDAY", "周六上班")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddColumn(new DefineField(mainTable, "ISWORKSUNDAY", "周日上班")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddFixColumn(mainTable, this.BillType);
mainTable.PrimaryKey = new DataColumn[] { mainTable.Columns[primaryName] };
this.DataSet.Tables.Add(mainTable);
DataTable subTable = new DataTable(subTableName);
DataSourceHelper.AddColumn(new DefineField(subTable, primaryName, "行事历代码", FieldSize.Size20)
{
AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddRowId(subTable);
DataSourceHelper.AddRowNo(subTable);
DataSourceHelper.AddColumn(new DefineField(subTable, "YEAR", "年份")
{
DataType = LibDataType.Int32, AllowEmpty = false, ControlType = LibControlType.Number
});
DataSourceHelper.AddColumn(new DefineField(subTable, "MONTH", "月份")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number
});
DataSourceHelper.AddColumn(new DefineField(subTable, "WEEKDAY", "工作日")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(subTable, "NONWORKDAY", "非工作日")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(subTable, "HOLIDAYDETAIL", "节假日明细")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true, SubTableIndex = 2
});
DataSourceHelper.AddColumn(new DefineField(subTable, "WORKMARK", "工作日标识")
{
DataType = LibDataType.Int32, ReadOnly = true
});
subTable.PrimaryKey = new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["ROW_ID"] };
subTable.ExtendedProperties.Add(TableProperty.AllowEmpt, false);
this.DataSet.Tables.Add(subTable);
this.DataSet.Relations.Add(new DataRelation(string.Format("{0}_{1}", mainTableName, subTableName), mainTable.Columns[primaryName], subTable.Columns[primaryName]));
DataTable holidayDetailTable = new DataTable(holidayTableName);
DataSourceHelper.AddColumn(new DefineField(holidayDetailTable, primaryName, "行事历代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(holidayDetailTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(holidayDetailTable);
DataSourceHelper.AddRowNo(holidayDetailTable);
DataSourceHelper.AddColumn(new DefineField(holidayDetailTable, "HOLIDAYDATE", "日期")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Date, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(holidayDetailTable, "ISWORK", "是否上班")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddRemark(holidayDetailTable);
holidayDetailTable.PrimaryKey = new DataColumn[] { holidayDetailTable.Columns[primaryName], holidayDetailTable.Columns["PARENTROWID"], holidayDetailTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(holidayDetailTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", subTableName, holidayTableName), new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["ROW_ID"] }, new DataColumn[] { holidayDetailTable.Columns[primaryName], holidayDetailTable.Columns["PARENTROWID"] });
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable comPerson = new DataTable(comPersonName);
DataSourceHelper.AddColumn(new DefineField(comPerson, primaryName, "人员代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "PERSONNAME", "人员名称", FieldSize.Size50)
{
DataType = LibDataType.NText, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "POSITION", "职位", FieldSize.Size50)
{
DataType = LibDataType.NText
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "NOWPERSON", "员工号", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "GENDER", "性别")
{
DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, TextOption = new string[] { "男", "女" }
});
Dictionary <string, bool> orderBys = new Dictionary <string, bool>();
orderBys.Add("SORTORDER", true);
DataSourceHelper.AddColumn(new DefineField(comPerson, "DEPTID", "部门", FieldSize.Size20)
{
#region 部门
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.Dept")
{
RelFields = new RelFieldCollection()
{
new RelField("DEPTNAME", LibDataType.NText, FieldSize.Size50, "部门名称")
},
//ContainsSub = true,
//ExpandAll=true,//默认全部展开
//SearchFilterCount = 200,//筛选200条
//ParentColumnName = "SUPERDEPTID", //在关联的表中表示父数据的列
//OrderbyColumns = orderBys
}
},
//ControlType = LibControlType.IdNameTree //以树形结构展示,需要在RelativeSource属性后设置，否则会重置为IdName
#endregion
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "WECHAT", "微信", FieldSize.Size50)
{
DataType = LibDataType.NText
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "MAIL", "邮箱", FieldSize.Size50)
{
AllowCopy = false, InputType = InputType.Email
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "PHONENO", "手机", FieldSize.Size20)
{
DataType = LibDataType.Text, ControlType = LibControlType.Text
});
//施卢威 20170214 用于集团内部通讯
DataSourceHelper.AddColumn(new DefineField(comPerson, "CORNET", "短号", FieldSize.Size20)
{
DataType = LibDataType.Text, ControlType = LibControlType.Text
});
//施卢威 20170214 用于APP用户头像展示
DataSourceHelper.AddColumn(new DefineField(comPerson, "HEADPORTRAIT", "头像", FieldSize.Size500)
{
DataType = LibDataType.NText
});
DataSourceHelper.AddColumn(new DefineField(comPerson, "ROLETYPE", "人员类型")
{
AllowCopy = false, DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, TextOption = new string[] { "普通工人", "班组长" }, DefaultValue = 0
});
DataSourceHelper.AddFixColumn(comPerson, this.BillType);
comPerson.PrimaryKey = new DataColumn[] { comPerson.Columns["PERSONID"] };
this.DataSet.Tables.Add(comPerson);
//#region 人员消息订阅
//DataTable bodyTable = new DataTable(bodyTableName);
//DataSourceHelper.AddColumn(new DefineField(bodyTable, primaryName, "人员代码", FieldSize.Size20) { AllowEmpty = false, ReadOnly = true });
//DataSourceHelper.AddRowId(bodyTable);
//DataSourceHelper.AddRowNo(bodyTable);
//DataSourceHelper.AddColumn(new DefineField(bodyTable, "PROGID", "功能代码", FieldSize.Size50)
//{
// AllowEmpty = false,
// ControlType = LibControlType.IdName,
// RelativeSource = new RelativeSourceCollection(){
// new RelativeSource("axp.FuncList"){
// RelFields = new RelFieldCollection(){
// new RelField("PROGNAME", LibDataType.NText,FieldSize.Size50,"功能名称")
// }
// }
// }
//});
//DataSourceHelper.AddColumn(new DefineField(bodyTable, "SUBSCRIBETYPE", "订阅类型")
//{
// DataType = LibDataType.Int32,
// AllowEmpty = false,
// ControlType = LibControlType.TextOption,
// TextOption = new string[] { "订阅", "拒收" },
// DefaultValue = 0
//});
//DataSourceHelper.AddColumn(new DefineField(bodyTable, "NOTICETYPE", "渠道类型")
//{
// DataType = LibDataType.Int32,
// AllowEmpty = false,
// ControlType = LibControlType.KeyValueOption,
// KeyValueOption = GetNoticeTypeKeyValue(),//根据渠道类型的枚举生成键值对
// DefaultValue = 0
//});
//DataSourceHelper.AddColumn(new DefineField(bodyTable, "CONDITION", "生效条件") { DataType = LibDataType.Binary, ControlType = LibControlType.Text, ReadOnly = true });
//DataSourceHelper.AddColumn(new DefineField(bodyTable, "HASCONDITION", "存在生效条件") { DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, FieldType = FieldType.Virtual, ReadOnly = true });
//DataSourceHelper.AddColumn(new DefineField(bodyTable, "ISBILLACTION", "操作种类") { ReadOnly = true, DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, SubTableIndex = 2 });
//DataSourceHelper.AddRemark(bodyTable);
//bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns["PERSONID"], bodyTable.Columns["ROW_ID"] };
//this.DataSet.Tables.Add(bodyTable);
//this.DataSet.Relations.Add(string.Format("{0}_{1}", comPerson, bodyTable), comPerson.Columns["PERSONID"], bodyTable.Columns["PERSONID"]);
////DataTable subTable = new DataTable(subDetailTableName);
////DataSourceHelper.AddColumn(new DefineField(subTable, primaryName, "人员代码", FieldSize.Size20) { AllowEmpty = false, AllowCopy = false });
////DataSourceHelper.AddRowId(subTable, "PARENTROWID", "父行标识");
////DataSourceHelper.AddRowId(subTable);
////DataSourceHelper.AddRowNo(subTable);
////DataSourceHelper.AddColumn(new DefineField(subTable, "OPERATE", "表单操作") { DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true });
////DataSourceHelper.AddColumn(new DefineField(subTable, "OPERATEPOWERNAME", "操作", FieldSize.Size50)
////{
//// DataType = LibDataType.NText, ControlType = LibControlType.NText, ReadOnly = true
////});
////DataSourceHelper.AddColumn(new DefineField(subTable, "CHECK", "选择") { DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo });
////DataSourceHelper.AddRemark(subTable);
////subTable.PrimaryKey = new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"], subTable.Columns["ROW_ID"] };
////this.DataSet.Tables.Add(subTable);
////this.DataSet.Relations.Add(string.Format("{0}_{1}", bodyTableName, subTableName), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"] });
//#endregion
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "PERMISSIONGROUPID";
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, primaryName, "权限组代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PERMISSIONGROUPNAME", "权限组名称", FieldSize.Size50)
{
AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PARENTGROUPID", "父权限组", FieldSize.Size50)
{
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.PermissionGroup")
{
RelFields = new RelFieldCollection()
{
new RelField("PERMISSIONGROUPNAME", LibDataType.NText, FieldSize.Size50, "父权限组名称", "PARENTGROUPNAME")
}
}
}
});
DataSourceHelper.AddFixColumn(masterTable, this.BillType);
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns[primaryName] };
this.DataSet.Tables.Add(masterTable);
DataTable bodyTable = new DataTable(bodyTableName);
DataSourceHelper.AddColumn(new DefineField(bodyTable, primaryName, "权限组代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(bodyTable);
DataSourceHelper.AddRowNo(bodyTable);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "SHOWCONDITION", "浏览条件")
{
DataType = LibDataType.Binary, ControlType = LibControlType.Text, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "HASSHOWCONDITION", "存在浏览条件")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, FieldType = FieldType.Virtual, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "ISOPERATEPOWER", "操作权限")
{
ReadOnly = true, DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, SubTableIndex = 2
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "ISFIELDPOWER", "字段权限")
{
ReadOnly = true, DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, SubTableIndex = 3
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "ISBUTTONPOWER", "功能权限")
{
ReadOnly = true, DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, SubTableIndex = 4
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "OPERATEMARK", "操作权限标识")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
DataSourceHelper.AddRemark(bodyTable);
bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(bodyTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", masterTableName, bodyTableName), masterTable.Columns[primaryName], bodyTable.Columns[primaryName]);
DataTable subTable = new DataTable(subTableName);
DataSourceHelper.AddColumn(new DefineField(subTable, primaryName, "权限组代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(subTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(subTable);
DataSourceHelper.AddRowNo(subTable);
DataSourceHelper.AddColumn(new DefineField(subTable, "OPERATEPOWERID", "操作代码")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(subTable, "OPERATEPOWERNAME", "操作", FieldSize.Size50)
{
DataType = LibDataType.NText, ControlType = LibControlType.NText, ReadOnly = true
});
DataSourceHelper.AddColumn(new DefineField(subTable, "CANUSE", "具备权限")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo
});
DataSourceHelper.AddRemark(subTable);
subTable.PrimaryKey = new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"], subTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(subTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", bodyTableName, subTableName), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { subTable.Columns[primaryName], subTable.Columns["PARENTROWID"] });
DataTable fieldTable = new DataTable(fieldTableName);
DataSourceHelper.AddColumn(new DefineField(fieldTable, primaryName, "权限组代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(fieldTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(fieldTable);
DataSourceHelper.AddRowNo(fieldTable);
DataSourceHelper.AddColumn(new DefineField(fieldTable, "TABLEINDEX", "表索引")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, QtyLimit = LibQtyLimit.GreaterOrEqualThanZero
});
DataSourceHelper.AddColumn(new DefineField(fieldTable, "FIELDNAME", "字段名", FieldSize.Size50)
{
ControlType = LibControlType.FieldControl, RelProgId = "B.PROGID", AllowEmpty = false, RelTableIndex = "D.TABLEINDEX"
});
DataSourceHelper.AddColumn(new DefineField(fieldTable, "FIELDPOWER", "权限选项")
{
DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, TextOption = new string[] { "不能查看", "不能编辑" }
});
DataSourceHelper.AddColumn(new DefineField(fieldTable, "USECONDITION", "控制条件", FieldSize.Size500));
DataSourceHelper.AddRemark(fieldTable);
fieldTable.PrimaryKey = new DataColumn[] { fieldTable.Columns[primaryName], fieldTable.Columns["PARENTROWID"], fieldTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(fieldTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", bodyTableName, fieldTable), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { fieldTable.Columns[primaryName], fieldTable.Columns["PARENTROWID"] });
DataTable buttonTable = new DataTable(buttonTableName);
DataSourceHelper.AddColumn(new DefineField(buttonTable, primaryName, "权限组代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(buttonTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(buttonTable);
DataSourceHelper.AddRowNo(buttonTable);
DataSourceHelper.AddColumn(new DefineField(buttonTable, "BUTTONID", "功能按钮", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncButton")
{
RelPK = "B.PROGID",
RelFields = new RelFieldCollection()
{
new RelField("BUTTONNAME", LibDataType.NText, FieldSize.Size50, "功能按钮名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(buttonTable, "CANUSE", "具备权限")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, DefaultValue = true
});
DataSourceHelper.AddRemark(buttonTable);
buttonTable.PrimaryKey = new DataColumn[] { buttonTable.Columns[primaryName], buttonTable.Columns["PARENTROWID"], buttonTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(buttonTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", bodyTableName, buttonTable), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { buttonTable.Columns[primaryName], buttonTable.Columns["PARENTROWID"] });
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
string primaryName = "CODINGRULEID";
DataTable headTable = new DataTable(tableName);
DataSourceHelper.AddColumn(new DefineField(headTable, primaryName, "规则代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddColumn(new DefineField(headTable, "CODINGRULENAME", "规则名称", FieldSize.Size50)
{
DataType = LibDataType.NText, ControlType = LibControlType.NText, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(headTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(headTable, "CODINGRULELENGTH", "编码长度")
{
DataType = LibDataType.Int32, ReadOnly = true
});
DataSourceHelper.AddFixColumn(headTable, this.BillType);
headTable.PrimaryKey = new DataColumn[] { headTable.Columns[primaryName] };
this.DataSet.Tables.Add(headTable);
DataTable bodyTable = new DataTable(tableDetailName);
DataSourceHelper.AddColumn(new DefineField(bodyTable, primaryName, "规则代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(bodyTable);
DataSourceHelper.AddRowNo(bodyTable);
DataSourceHelper.AddColumn(new DefineField(bodyTable, "SECTIONEXPLAIN", "编码段说明", FieldSize.Size50)
{
DataType = LibDataType.NText, ControlType = LibControlType.NText
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "SECTIONTYPE", "编码段类型")
{
DataType = LibDataType.Int32, ControlType = LibControlType.TextOption, TextOption = new string[] { "固定值", "流水号", "动态段", "日期（yyyymmdd）", "日期（yymmdd）", "日期（ddmmyy）", "日期（ABmmdd）", "日期(yymm)" }
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "SECTIONLENGTH", "编码段长度")
{
DataType = LibDataType.Int32, ControlType = LibControlType.Number, QtyLimit = LibQtyLimit.GreaterThanZero
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "FIELDNAME", "字段名", FieldSize.Size50)
{
ControlType = LibControlType.FieldControl, RelProgId = "A.PROGID"
});
DataSourceHelper.AddColumn(new DefineField(bodyTable, "SECTIONVALUE", "编码段内容", FieldSize.Size20));
DataSourceHelper.AddColumn(new DefineField(bodyTable, "DYRULEDETAIL", "动态规则明细")
{
DataType = LibDataType.Boolean, ControlType = LibControlType.YesNo, ReadOnly = true, SubTableIndex = 2
});
DataSourceHelper.AddRemark(bodyTable);
bodyTable.PrimaryKey = new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] };
bodyTable.ExtendedProperties.Add(TableProperty.AllowEmpt, false);
this.DataSet.Tables.Add(bodyTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", tableName, tableDetailName), headTable.Columns[primaryName], bodyTable.Columns[primaryName]);
DataTable dyRuleDetailTable = new DataTable(dyRuleDetailName);
DataSourceHelper.AddColumn(new DefineField(dyRuleDetailTable, primaryName, "规则代码", FieldSize.Size20)
{
AllowEmpty = false, AllowCopy = false
});
DataSourceHelper.AddRowId(dyRuleDetailTable, "PARENTROWID", "父行标识");
DataSourceHelper.AddRowId(dyRuleDetailTable);
DataSourceHelper.AddRowNo(dyRuleDetailTable);
DataSourceHelper.AddColumn(new DefineField(dyRuleDetailTable, "FIELDVALUE", "字段值", FieldSize.Size100)
{
ControlType = LibControlType.Text, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(dyRuleDetailTable, "SECTIONVALUE", "编码值", FieldSize.Size10)
{
ControlType = LibControlType.Text, AllowEmpty = false
});
DataSourceHelper.AddRemark(dyRuleDetailTable);
dyRuleDetailTable.PrimaryKey = new DataColumn[] { dyRuleDetailTable.Columns[primaryName], dyRuleDetailTable.Columns["PARENTROWID"], dyRuleDetailTable.Columns["ROW_ID"] };
this.DataSet.Tables.Add(dyRuleDetailTable);
this.DataSet.Relations.Add(string.Format("{0}_{1}", tableDetailName, dyRuleDetailName), new DataColumn[] { bodyTable.Columns[primaryName], bodyTable.Columns["ROW_ID"] }, new DataColumn[] { dyRuleDetailTable.Columns[primaryName], dyRuleDetailTable.Columns["PARENTROWID"] });
}