484 lines
16 KiB
C#
484 lines
16 KiB
C#
using System.Runtime.Serialization;
|
|
|
|
namespace SuperMap.RealEstate.Finance.Running.Interface
|
|
{
|
|
#region T_EXPENSEDETAIL IEXPENSEDETAIL 接口
|
|
/// <summary>
|
|
/// T_EXPENSEDETAIL 接口
|
|
/// </summary>
|
|
public interface IEXPENSEDETAIL
|
|
{
|
|
/// <summary>
|
|
/// 内码
|
|
/// </summary>
|
|
System.Int32? EXPENSEDETAIL_ID { get; set; }
|
|
/// <summary>
|
|
/// 内码 的加密字符串
|
|
/// </summary>
|
|
string EXPENSEDETAIL_ID_Encrypt { get; set; }
|
|
/// <summary>
|
|
/// 报销单内码
|
|
/// </summary>
|
|
System.Int32? EXPENSEBILL_ID { get; set; }
|
|
/// <summary>
|
|
/// 出发时间
|
|
/// </summary>
|
|
System.DateTime? START_DATE { get; set; }
|
|
/// <summary>
|
|
/// 出发地点
|
|
/// </summary>
|
|
System.String START_PLACE { get; set; }
|
|
/// <summary>
|
|
/// 到达时间
|
|
/// </summary>
|
|
System.DateTime? ARRIVE_DATE { get; set; }
|
|
/// <summary>
|
|
/// 到达地点
|
|
/// </summary>
|
|
System.String ARRIVE_PLACE { get; set; }
|
|
/// <summary>
|
|
/// 出差天数
|
|
/// </summary>
|
|
System.String TRAVEL_DAY { get; set; }
|
|
/// <summary>
|
|
/// 交通工具
|
|
/// </summary>
|
|
System.String VEHICLE_TYPE { get; set; }
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
System.Int32? BILL_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
System.Double? BILL_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 补贴人数
|
|
/// </summary>
|
|
System.Int32? SUBSIDY_POPULATION { get; set; }
|
|
/// <summary>
|
|
/// 补贴天数
|
|
/// </summary>
|
|
System.Int32? SUBSIDY_DAY { get; set; }
|
|
/// <summary>
|
|
/// 补贴金额
|
|
/// </summary>
|
|
System.Double? SUBSIDY_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 其他费用
|
|
/// </summary>
|
|
System.String OTHER_COST { get; set; }
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
System.Int32? OTHERBILL_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
System.Double? OTHERBILL_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 费用日期
|
|
/// </summary>
|
|
System.DateTime? EXPENSEDETAIL_DATE { get; set; }
|
|
/// <summary>
|
|
/// 报销内容
|
|
/// </summary>
|
|
System.String EXPENSE_DETAIL { get; set; }
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
System.Int32? EXPENSEDETAIL_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
System.Double? EXPENSEDETAIL_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 市内交通补贴
|
|
/// </summary>
|
|
System.Double? URBAN_TRAFFIC_ALLOWANCE { get; set; }
|
|
/// <summary>
|
|
/// 路途交通费
|
|
/// </summary>
|
|
System.Double? TRAFFIC_EXPENSE { get; set; }
|
|
/// <summary>
|
|
/// 住宿费
|
|
/// </summary>
|
|
System.Double? HOTEL_EXPENSE { get; set; }
|
|
/// <summary>
|
|
/// 审核金额
|
|
/// </summary>
|
|
System.Double? AUDIT_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 审核数量
|
|
/// </summary>
|
|
System.Double? AUDIT_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 费用项目
|
|
/// </summary>
|
|
System.String EXPENSE_ITEM { get; set; }
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
System.String EXPENSEDETAIL_DESC { get; set; }
|
|
}
|
|
#endregion
|
|
|
|
#region T_EXPENSEDETAIL IModifyEXPENSEDETAIL 接口
|
|
/// <summary>
|
|
/// T_EXPENSEDETAIL 接口
|
|
/// </summary>
|
|
public interface IModifyEXPENSEDETAIL
|
|
{
|
|
/// <summary>
|
|
/// 内码 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSEDETAIL_ID { get; set; }
|
|
/// <summary>
|
|
/// 报销单内码 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSEBILL_ID { get; set; }
|
|
/// <summary>
|
|
/// 出发时间 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_START_DATE { get; set; }
|
|
/// <summary>
|
|
/// 出发地点 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_START_PLACE { get; set; }
|
|
/// <summary>
|
|
/// 到达时间 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_ARRIVE_DATE { get; set; }
|
|
/// <summary>
|
|
/// 到达地点 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_ARRIVE_PLACE { get; set; }
|
|
/// <summary>
|
|
/// 出差天数 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_TRAVEL_DAY { get; set; }
|
|
/// <summary>
|
|
/// 交通工具 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_VEHICLE_TYPE { get; set; }
|
|
/// <summary>
|
|
/// 单据张数 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_BILL_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 金额 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_BILL_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 补贴人数 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_SUBSIDY_POPULATION { get; set; }
|
|
/// <summary>
|
|
/// 补贴天数 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_SUBSIDY_DAY { get; set; }
|
|
/// <summary>
|
|
/// 补贴金额 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_SUBSIDY_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 其他费用 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_OTHER_COST { get; set; }
|
|
/// <summary>
|
|
/// 单据张数 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_OTHERBILL_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 金额 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_OTHERBILL_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 费用日期 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSEDETAIL_DATE { get; set; }
|
|
/// <summary>
|
|
/// 报销内容 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSE_DETAIL { get; set; }
|
|
/// <summary>
|
|
/// 单据张数 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSEDETAIL_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 金额 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSEDETAIL_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 市内交通补贴 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_URBAN_TRAFFIC_ALLOWANCE { get; set; }
|
|
/// <summary>
|
|
/// 路途交通费 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_TRAFFIC_EXPENSE { get; set; }
|
|
/// <summary>
|
|
/// 住宿费 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_HOTEL_EXPENSE { get; set; }
|
|
/// <summary>
|
|
/// 审核金额 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_AUDIT_AMOUNT { get; set; }
|
|
/// <summary>
|
|
/// 审核数量 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_AUDIT_COUNT { get; set; }
|
|
/// <summary>
|
|
/// 费用项目 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSE_ITEM { get; set; }
|
|
/// <summary>
|
|
/// 备注 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_EXPENSEDETAIL_DESC { get; set; }
|
|
}
|
|
#endregion
|
|
|
|
#region T_EXPENSEDETAIL 的表明、字段名、字段描述
|
|
/// <summary>
|
|
/// T_EXPENSEDETAIL_报销详情 的字段类
|
|
/// </summary>
|
|
public class TableSchema_EXPENSEDETAIL
|
|
{
|
|
/// <summary>
|
|
/// 序列名 (用于Oracle主键)
|
|
/// </summary>
|
|
public const string SequenceName = "seq_expensedetail";
|
|
/// <summary>
|
|
/// 表名
|
|
/// </summary>
|
|
public const string TableName = "T_EXPENSEDETAIL";
|
|
/// <summary>
|
|
/// 表注释
|
|
/// </summary>
|
|
public const string Comment_TableName = "报销详情";
|
|
/// <summary>
|
|
/// 主键
|
|
/// </summary>
|
|
public const string KeyFieldName = "EXPENSEDETAIL_ID";
|
|
/// <summary>
|
|
/// 内码
|
|
/// </summary>
|
|
public const string EXPENSEDETAIL_ID = "EXPENSEDETAIL_ID";
|
|
/// <summary>
|
|
/// 报销单内码
|
|
/// </summary>
|
|
public const string EXPENSEBILL_ID = "EXPENSEBILL_ID";
|
|
/// <summary>
|
|
/// 出发时间
|
|
/// </summary>
|
|
public const string START_DATE = "START_DATE";
|
|
/// <summary>
|
|
/// 出发地点
|
|
/// </summary>
|
|
public const string START_PLACE = "START_PLACE";
|
|
/// <summary>
|
|
/// 到达时间
|
|
/// </summary>
|
|
public const string ARRIVE_DATE = "ARRIVE_DATE";
|
|
/// <summary>
|
|
/// 到达地点
|
|
/// </summary>
|
|
public const string ARRIVE_PLACE = "ARRIVE_PLACE";
|
|
/// <summary>
|
|
/// 出差天数
|
|
/// </summary>
|
|
public const string TRAVEL_DAY = "TRAVEL_DAY";
|
|
/// <summary>
|
|
/// 交通工具
|
|
/// </summary>
|
|
public const string VEHICLE_TYPE = "VEHICLE_TYPE";
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
public const string BILL_COUNT = "BILL_COUNT";
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
public const string BILL_AMOUNT = "BILL_AMOUNT";
|
|
/// <summary>
|
|
/// 补贴人数
|
|
/// </summary>
|
|
public const string SUBSIDY_POPULATION = "SUBSIDY_POPULATION";
|
|
/// <summary>
|
|
/// 补贴天数
|
|
/// </summary>
|
|
public const string SUBSIDY_DAY = "SUBSIDY_DAY";
|
|
/// <summary>
|
|
/// 补贴金额
|
|
/// </summary>
|
|
public const string SUBSIDY_AMOUNT = "SUBSIDY_AMOUNT";
|
|
/// <summary>
|
|
/// 其他费用
|
|
/// </summary>
|
|
public const string OTHER_COST = "OTHER_COST";
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
public const string OTHERBILL_COUNT = "OTHERBILL_COUNT";
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
public const string OTHERBILL_AMOUNT = "OTHERBILL_AMOUNT";
|
|
/// <summary>
|
|
/// 费用日期
|
|
/// </summary>
|
|
public const string EXPENSEDETAIL_DATE = "EXPENSEDETAIL_DATE";
|
|
/// <summary>
|
|
/// 报销内容
|
|
/// </summary>
|
|
public const string EXPENSE_DETAIL = "EXPENSE_DETAIL";
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
public const string EXPENSEDETAIL_COUNT = "EXPENSEDETAIL_COUNT";
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
public const string EXPENSEDETAIL_AMOUNT = "EXPENSEDETAIL_AMOUNT";
|
|
/// <summary>
|
|
/// 市内交通补贴
|
|
/// </summary>
|
|
public const string URBAN_TRAFFIC_ALLOWANCE = "URBAN_TRAFFIC_ALLOWANCE";
|
|
/// <summary>
|
|
/// 路途交通费
|
|
/// </summary>
|
|
public const string TRAFFIC_EXPENSE = "TRAFFIC_EXPENSE";
|
|
/// <summary>
|
|
/// 住宿费
|
|
/// </summary>
|
|
public const string HOTEL_EXPENSE = "HOTEL_EXPENSE";
|
|
/// <summary>
|
|
/// 审核金额
|
|
/// </summary>
|
|
public const string AUDIT_AMOUNT = "AUDIT_AMOUNT";
|
|
/// <summary>
|
|
/// 审核数量
|
|
/// </summary>
|
|
public const string AUDIT_COUNT = "AUDIT_COUNT";
|
|
/// <summary>
|
|
/// 费用项目
|
|
/// </summary>
|
|
public const string EXPENSE_ITEM = "EXPENSE_ITEM";
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
public const string EXPENSEDETAIL_DESC = "EXPENSEDETAIL_DESC";
|
|
/// <summary>
|
|
/// 内码
|
|
/// </summary>
|
|
public const string Comment_EXPENSEDETAIL_ID = "内码";
|
|
/// <summary>
|
|
/// 报销单内码
|
|
/// </summary>
|
|
public const string Comment_EXPENSEBILL_ID = "报销单内码";
|
|
/// <summary>
|
|
/// 出发时间
|
|
/// </summary>
|
|
public const string Comment_START_DATE = "出发时间";
|
|
/// <summary>
|
|
/// 出发地点
|
|
/// </summary>
|
|
public const string Comment_START_PLACE = "出发地点";
|
|
/// <summary>
|
|
/// 到达时间
|
|
/// </summary>
|
|
public const string Comment_ARRIVE_DATE = "到达时间";
|
|
/// <summary>
|
|
/// 到达地点
|
|
/// </summary>
|
|
public const string Comment_ARRIVE_PLACE = "到达地点";
|
|
/// <summary>
|
|
/// 出差天数
|
|
/// </summary>
|
|
public const string Comment_TRAVEL_DAY = "出差天数";
|
|
/// <summary>
|
|
/// 交通工具
|
|
/// </summary>
|
|
public const string Comment_VEHICLE_TYPE = "交通工具";
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
public const string Comment_BILL_COUNT = "单据张数";
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
public const string Comment_BILL_AMOUNT = "金额";
|
|
/// <summary>
|
|
/// 补贴人数
|
|
/// </summary>
|
|
public const string Comment_SUBSIDY_POPULATION = "补贴人数";
|
|
/// <summary>
|
|
/// 补贴天数
|
|
/// </summary>
|
|
public const string Comment_SUBSIDY_DAY = "补贴天数";
|
|
/// <summary>
|
|
/// 补贴金额
|
|
/// </summary>
|
|
public const string Comment_SUBSIDY_AMOUNT = "补贴金额";
|
|
/// <summary>
|
|
/// 其他费用
|
|
/// </summary>
|
|
public const string Comment_OTHER_COST = "其他费用";
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
public const string Comment_OTHERBILL_COUNT = "单据张数";
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
public const string Comment_OTHERBILL_AMOUNT = "金额";
|
|
/// <summary>
|
|
/// 费用日期
|
|
/// </summary>
|
|
public const string Comment_EXPENSEDETAIL_DATE = "费用日期";
|
|
/// <summary>
|
|
/// 报销内容
|
|
/// </summary>
|
|
public const string Comment_EXPENSE_DETAIL = "报销内容";
|
|
/// <summary>
|
|
/// 单据张数
|
|
/// </summary>
|
|
public const string Comment_EXPENSEDETAIL_COUNT = "单据张数";
|
|
/// <summary>
|
|
/// 金额
|
|
/// </summary>
|
|
public const string Comment_EXPENSEDETAIL_AMOUNT = "金额";
|
|
/// <summary>
|
|
/// 市内交通补贴
|
|
/// </summary>
|
|
public const string Comment_URBAN_TRAFFIC_ALLOWANCE = "市内交通补贴";
|
|
/// <summary>
|
|
/// 路途交通费
|
|
/// </summary>
|
|
public const string Comment_TRAFFIC_EXPENSE = "路途交通费";
|
|
/// <summary>
|
|
/// 住宿费
|
|
/// </summary>
|
|
public const string Comment_HOTEL_EXPENSE = "住宿费";
|
|
/// <summary>
|
|
/// 审核金额
|
|
/// </summary>
|
|
public const string Comment_AUDIT_AMOUNT = "审核金额";
|
|
/// <summary>
|
|
/// 审核数量
|
|
/// </summary>
|
|
public const string Comment_AUDIT_COUNT = "审核数量";
|
|
/// <summary>
|
|
/// 费用项目
|
|
/// </summary>
|
|
public const string Comment_EXPENSE_ITEM = "费用项目";
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
public const string Comment_EXPENSEDETAIL_DESC = "备注";
|
|
}
|
|
#endregion
|
|
}
|