using System.Runtime.Serialization; namespace SuperMap.RealEstate.Finance.Running.Interface { #region T_COSTPLANBILL ICOSTPLANBILL 接口 /// /// T_COSTPLANBILL 接口 /// public interface ICOSTPLANBILL { /// /// 内码 /// System.Int32? COSTPLANBILL_ID { get; set; } /// /// 内码 的加密字符串 /// string COSTPLANBILL_ID_Encrypt { get; set; } /// /// 项目内码 /// System.Int32? FINANCEPROINST_ID { get; set; } /// /// 报销编码 /// System.String COSTPLANBILL_CODE { get; set; } /// /// 财务类型 /// System.Int16? COSTPLANBILL_TYPE { get; set; } /// /// 单据状态 /// System.Int16? COSTPLANBILL_STATE { get; set; } /// /// 作废人员 /// System.String OBSOLETE_PERSON { get; set; } /// /// 作废时间 /// System.DateTime? OBSOLETE_DATE { get; set; } /// /// 报销部门 /// System.String DEPARTMENT_NAME { get; set; } /// /// 申请服务区 /// System.String SERVERPATH_NAME { get; set; } /// /// 报销时间 /// System.DateTime? COSTPLANBILL_DATE { get; set; } /// /// 业务名称 /// System.String COSTPLANBILL_NAME { get; set; } /// /// 申请原因 /// System.String APPLICATIONREASON { get; set; } /// /// 预算情况 /// System.Int16? BUDGETSITUATION { get; set; } /// /// 车号 /// System.String CARDCODE { get; set; } /// /// 上次保养时间 /// System.DateTime? LASTMAINTENANCE_DATE { get; set; } /// /// 上次行驶里程 /// System.Double? LAST_MILEAGE { get; set; } /// /// 本次保养时间 /// System.DateTime? MAINTENANCE_DATE { get; set; } /// /// 本次行驶里程 /// System.Double? MILEAGE { get; set; } /// /// 上次剩余预算 /// System.Double? LASTSURPLUS_BUDGET { get; set; } /// /// 本次剩余预算 /// System.Double? SURPLUS_BUDGET { get; set; } /// /// 上月总电量 /// System.Double? LASTTOTAL_ELECTRICITY { get; set; } /// /// 单价 /// System.Int64? LASTTOTAL_PRICR { get; set; } /// /// 本月总电量 /// System.Double? TOTAL_ELECTRICITY { get; set; } /// /// 单价 /// System.Double? TOTAL_PRICR { get; set; } /// /// 上月总水量 /// System.Double? LASTTOTAL_WATER { get; set; } /// /// 单价 /// System.Double? LASTTOTAL_WATERPRICE { get; set; } /// /// 本月总水量 /// System.Double? TOTAL_WATER { get; set; } /// /// 单价 /// System.Double? TOTAL_WATERPRICE { get; set; } /// /// 本月损耗 /// System.Double? ELECTRICITY_LOSS { get; set; } /// /// 计划金额 /// System.Double? PAYMENT_LOWER { get; set; } /// /// 计划金额大写 /// System.String PAYMENT_CAP { get; set; } /// /// 审核金额 /// System.Double? AUDITAMOUNT_LOWER { get; set; } /// /// 审核金额大写 /// System.String AUDITAMOUNT_CAP { get; set; } /// /// 打印次数 /// System.Int16? PRINT_COUNT { get; set; } /// /// 操作人内码 /// System.Int32? STAFF_ID { get; set; } /// /// 操作人名 /// System.String STAFF_NAME { get; set; } /// /// 操作时间 /// System.DateTime? OPERATE_DATE { get; set; } /// /// 收款人名 /// System.String RECEIVABLES_NAME { get; set; } /// /// 联系人 /// System.String CONTACTS { get; set; } /// /// 联系电话 /// System.String CONTACTS_TEL { get; set; } /// /// 收款人账号 /// System.String RECEIVABLES_NUM { get; set; } /// /// 开户行名 /// System.String BANK_NAME { get; set; } /// /// 收款联网行号 /// System.String BANK_CODE { get; set; } /// /// 备注 /// System.String COSTPLANBILL_DESC { get; set; } } #endregion #region T_COSTPLANBILL IModifyCOSTPLANBILL 接口 /// /// T_COSTPLANBILL 接口 /// public interface IModifyCOSTPLANBILL { /// /// 内码 是否被修改,不建议直接对其赋值操作 /// bool Modify_COSTPLANBILL_ID { get; set; } /// /// 项目内码 是否被修改,不建议直接对其赋值操作 /// bool Modify_FINANCEPROINST_ID { get; set; } /// /// 报销编码 是否被修改,不建议直接对其赋值操作 /// bool Modify_COSTPLANBILL_CODE { get; set; } /// /// 财务类型 是否被修改,不建议直接对其赋值操作 /// bool Modify_COSTPLANBILL_TYPE { get; set; } /// /// 单据状态 是否被修改,不建议直接对其赋值操作 /// bool Modify_COSTPLANBILL_STATE { get; set; } /// /// 作废人员 是否被修改,不建议直接对其赋值操作 /// bool Modify_OBSOLETE_PERSON { get; set; } /// /// 作废时间 是否被修改,不建议直接对其赋值操作 /// bool Modify_OBSOLETE_DATE { get; set; } /// /// 报销部门 是否被修改,不建议直接对其赋值操作 /// bool Modify_DEPARTMENT_NAME { get; set; } /// /// 申请服务区 是否被修改,不建议直接对其赋值操作 /// bool Modify_SERVERPATH_NAME { get; set; } /// /// 报销时间 是否被修改,不建议直接对其赋值操作 /// bool Modify_COSTPLANBILL_DATE { get; set; } /// /// 业务名称 是否被修改,不建议直接对其赋值操作 /// bool Modify_COSTPLANBILL_NAME { get; set; } /// /// 申请原因 是否被修改,不建议直接对其赋值操作 /// bool Modify_APPLICATIONREASON { get; set; } /// /// 预算情况 是否被修改,不建议直接对其赋值操作 /// bool Modify_BUDGETSITUATION { get; set; } /// /// 车号 是否被修改,不建议直接对其赋值操作 /// bool Modify_CARDCODE { get; set; } /// /// 上次保养时间 是否被修改,不建议直接对其赋值操作 /// bool Modify_LASTMAINTENANCE_DATE { get; set; } /// /// 上次行驶里程 是否被修改,不建议直接对其赋值操作 /// bool Modify_LAST_MILEAGE { get; set; } /// /// 本次保养时间 是否被修改,不建议直接对其赋值操作 /// bool Modify_MAINTENANCE_DATE { get; set; } /// /// 本次行驶里程 是否被修改,不建议直接对其赋值操作 /// bool Modify_MILEAGE { get; set; } /// /// 上次剩余预算 是否被修改,不建议直接对其赋值操作 /// bool Modify_LASTSURPLUS_BUDGET { get; set; } /// /// 本次剩余预算 是否被修改,不建议直接对其赋值操作 /// bool Modify_SURPLUS_BUDGET { get; set; } /// /// 上月总电量 是否被修改,不建议直接对其赋值操作 /// bool Modify_LASTTOTAL_ELECTRICITY { get; set; } /// /// 单价 是否被修改,不建议直接对其赋值操作 /// bool Modify_LASTTOTAL_PRICR { get; set; } /// /// 本月总电量 是否被修改,不建议直接对其赋值操作 /// bool Modify_TOTAL_ELECTRICITY { get; set; } /// /// 单价 是否被修改,不建议直接对其赋值操作 /// bool Modify_TOTAL_PRICR { get; set; } /// /// 上月总水量 是否被修改,不建议直接对其赋值操作 /// bool Modify_LASTTOTAL_WATER { get; set; } /// /// 单价 是否被修改,不建议直接对其赋值操作 /// bool Modify_LASTTOTAL_WATERPRICE { get; set; } /// /// 本月总水量 是否被修改,不建议直接对其赋值操作 /// bool Modify_TOTAL_WATER { get; set; } /// /// 单价 是否被修改,不建议直接对其赋值操作 /// bool Modify_TOTAL_WATERPRICE { get; set; } /// /// 本月损耗 是否被修改,不建议直接对其赋值操作 /// bool Modify_ELECTRICITY_LOSS { get; set; } /// /// 计划金额 是否被修改,不建议直接对其赋值操作 /// bool Modify_PAYMENT_LOWER { get; set; } /// /// 计划金额大写 是否被修改,不建议直接对其赋值操作 /// bool Modify_PAYMENT_CAP { get; set; } /// /// 审核金额 是否被修改,不建议直接对其赋值操作 /// bool Modify_AUDITAMOUNT_LOWER { get; set; } /// /// 审核金额大写 是否被修改,不建议直接对其赋值操作 /// bool Modify_AUDITAMOUNT_CAP { get; set; } /// /// 打印次数 是否被修改,不建议直接对其赋值操作 /// bool Modify_PRINT_COUNT { get; set; } /// /// 操作人内码 是否被修改,不建议直接对其赋值操作 /// bool Modify_STAFF_ID { get; set; } /// /// 操作人名 是否被修改,不建议直接对其赋值操作 /// bool Modify_STAFF_NAME { get; set; } /// /// 操作时间 是否被修改,不建议直接对其赋值操作 /// bool Modify_OPERATE_DATE { get; set; } /// /// 收款人名 是否被修改,不建议直接对其赋值操作 /// bool Modify_RECEIVABLES_NAME { get; set; } /// /// 联系人 是否被修改,不建议直接对其赋值操作 /// bool Modify_CONTACTS { get; set; } /// /// 联系电话 是否被修改,不建议直接对其赋值操作 /// bool Modify_CONTACTS_TEL { get; set; } /// /// 收款人账号 是否被修改,不建议直接对其赋值操作 /// bool Modify_RECEIVABLES_NUM { get; set; } /// /// 开户行名 是否被修改,不建议直接对其赋值操作 /// bool Modify_BANK_NAME { get; set; } /// /// 收款联网行号 是否被修改,不建议直接对其赋值操作 /// bool Modify_BANK_CODE { get; set; } /// /// 备注 是否被修改,不建议直接对其赋值操作 /// bool Modify_COSTPLANBILL_DESC { get; set; } } #endregion #region T_COSTPLANBILL 的表明、字段名、字段描述 /// /// T_COSTPLANBILL_费用计划审批 的字段类 /// public class TableSchema_COSTPLANBILL { /// /// 序列名 (用于Oracle主键) /// public const string SequenceName = "seq_costplanbill"; /// /// 表名 /// public const string TableName = "T_COSTPLANBILL"; /// /// 表注释 /// public const string Comment_TableName = "费用计划审批"; /// /// 主键 /// public const string KeyFieldName = "COSTPLANBILL_ID"; /// /// 内码 /// public const string COSTPLANBILL_ID = "COSTPLANBILL_ID"; /// /// 项目内码 /// public const string FINANCEPROINST_ID = "FINANCEPROINST_ID"; /// /// 报销编码 /// public const string COSTPLANBILL_CODE = "COSTPLANBILL_CODE"; /// /// 财务类型 /// public const string COSTPLANBILL_TYPE = "COSTPLANBILL_TYPE"; /// /// 单据状态 /// public const string COSTPLANBILL_STATE = "COSTPLANBILL_STATE"; /// /// 作废人员 /// public const string OBSOLETE_PERSON = "OBSOLETE_PERSON"; /// /// 作废时间 /// public const string OBSOLETE_DATE = "OBSOLETE_DATE"; /// /// 报销部门 /// public const string DEPARTMENT_NAME = "DEPARTMENT_NAME"; /// /// 申请服务区 /// public const string SERVERPATH_NAME = "SERVERPATH_NAME"; /// /// 报销时间 /// public const string COSTPLANBILL_DATE = "COSTPLANBILL_DATE"; /// /// 业务名称 /// public const string COSTPLANBILL_NAME = "COSTPLANBILL_NAME"; /// /// 申请原因 /// public const string APPLICATIONREASON = "APPLICATIONREASON"; /// /// 预算情况 /// public const string BUDGETSITUATION = "BUDGETSITUATION"; /// /// 车号 /// public const string CARDCODE = "CARDCODE"; /// /// 上次保养时间 /// public const string LASTMAINTENANCE_DATE = "LASTMAINTENANCE_DATE"; /// /// 上次行驶里程 /// public const string LAST_MILEAGE = "LAST_MILEAGE"; /// /// 本次保养时间 /// public const string MAINTENANCE_DATE = "MAINTENANCE_DATE"; /// /// 本次行驶里程 /// public const string MILEAGE = "MILEAGE"; /// /// 上次剩余预算 /// public const string LASTSURPLUS_BUDGET = "LASTSURPLUS_BUDGET"; /// /// 本次剩余预算 /// public const string SURPLUS_BUDGET = "SURPLUS_BUDGET"; /// /// 上月总电量 /// public const string LASTTOTAL_ELECTRICITY = "LASTTOTAL_ELECTRICITY"; /// /// 单价 /// public const string LASTTOTAL_PRICR = "LASTTOTAL_PRICR"; /// /// 本月总电量 /// public const string TOTAL_ELECTRICITY = "TOTAL_ELECTRICITY"; /// /// 单价 /// public const string TOTAL_PRICR = "TOTAL_PRICR"; /// /// 上月总水量 /// public const string LASTTOTAL_WATER = "LASTTOTAL_WATER"; /// /// 单价 /// public const string LASTTOTAL_WATERPRICE = "LASTTOTAL_WATERPRICE"; /// /// 本月总水量 /// public const string TOTAL_WATER = "TOTAL_WATER"; /// /// 单价 /// public const string TOTAL_WATERPRICE = "TOTAL_WATERPRICE"; /// /// 本月损耗 /// public const string ELECTRICITY_LOSS = "ELECTRICITY_LOSS"; /// /// 计划金额 /// public const string PAYMENT_LOWER = "PAYMENT_LOWER"; /// /// 计划金额大写 /// public const string PAYMENT_CAP = "PAYMENT_CAP"; /// /// 审核金额 /// public const string AUDITAMOUNT_LOWER = "AUDITAMOUNT_LOWER"; /// /// 审核金额大写 /// public const string AUDITAMOUNT_CAP = "AUDITAMOUNT_CAP"; /// /// 打印次数 /// public const string PRINT_COUNT = "PRINT_COUNT"; /// /// 操作人内码 /// public const string STAFF_ID = "STAFF_ID"; /// /// 操作人名 /// public const string STAFF_NAME = "STAFF_NAME"; /// /// 操作时间 /// public const string OPERATE_DATE = "OPERATE_DATE"; /// /// 收款人名 /// public const string RECEIVABLES_NAME = "RECEIVABLES_NAME"; /// /// 联系人 /// public const string CONTACTS = "CONTACTS"; /// /// 联系电话 /// public const string CONTACTS_TEL = "CONTACTS_TEL"; /// /// 收款人账号 /// public const string RECEIVABLES_NUM = "RECEIVABLES_NUM"; /// /// 开户行名 /// public const string BANK_NAME = "BANK_NAME"; /// /// 收款联网行号 /// public const string BANK_CODE = "BANK_CODE"; /// /// 备注 /// public const string COSTPLANBILL_DESC = "COSTPLANBILL_DESC"; /// /// 内码 /// public const string Comment_COSTPLANBILL_ID = "内码"; /// /// 项目内码 /// public const string Comment_FINANCEPROINST_ID = "项目内码"; /// /// 报销编码 /// public const string Comment_COSTPLANBILL_CODE = "报销编码"; /// /// 财务类型 /// public const string Comment_COSTPLANBILL_TYPE = "财务类型"; /// /// 单据状态 /// public const string Comment_COSTPLANBILL_STATE = "单据状态"; /// /// 作废人员 /// public const string Comment_OBSOLETE_PERSON = "作废人员"; /// /// 作废时间 /// public const string Comment_OBSOLETE_DATE = "作废时间"; /// /// 报销部门 /// public const string Comment_DEPARTMENT_NAME = "报销部门"; /// /// 申请服务区 /// public const string Comment_SERVERPATH_NAME = "申请服务区"; /// /// 报销时间 /// public const string Comment_COSTPLANBILL_DATE = "报销时间"; /// /// 业务名称 /// public const string Comment_COSTPLANBILL_NAME = "业务名称"; /// /// 申请原因 /// public const string Comment_APPLICATIONREASON = "申请原因"; /// /// 预算情况 /// public const string Comment_BUDGETSITUATION = "预算情况"; /// /// 车号 /// public const string Comment_CARDCODE = "车号"; /// /// 上次保养时间 /// public const string Comment_LASTMAINTENANCE_DATE = "上次保养时间"; /// /// 上次行驶里程 /// public const string Comment_LAST_MILEAGE = "上次行驶里程"; /// /// 本次保养时间 /// public const string Comment_MAINTENANCE_DATE = "本次保养时间"; /// /// 本次行驶里程 /// public const string Comment_MILEAGE = "本次行驶里程"; /// /// 上次剩余预算 /// public const string Comment_LASTSURPLUS_BUDGET = "上次剩余预算"; /// /// 本次剩余预算 /// public const string Comment_SURPLUS_BUDGET = "本次剩余预算"; /// /// 上月总电量 /// public const string Comment_LASTTOTAL_ELECTRICITY = "上月总电量"; /// /// 单价 /// public const string Comment_LASTTOTAL_PRICR = "单价"; /// /// 本月总电量 /// public const string Comment_TOTAL_ELECTRICITY = "本月总电量"; /// /// 单价 /// public const string Comment_TOTAL_PRICR = "单价"; /// /// 上月总水量 /// public const string Comment_LASTTOTAL_WATER = "上月总水量"; /// /// 单价 /// public const string Comment_LASTTOTAL_WATERPRICE = "单价"; /// /// 本月总水量 /// public const string Comment_TOTAL_WATER = "本月总水量"; /// /// 单价 /// public const string Comment_TOTAL_WATERPRICE = "单价"; /// /// 本月损耗 /// public const string Comment_ELECTRICITY_LOSS = "本月损耗"; /// /// 计划金额 /// public const string Comment_PAYMENT_LOWER = "计划金额"; /// /// 计划金额大写 /// public const string Comment_PAYMENT_CAP = "计划金额大写"; /// /// 审核金额 /// public const string Comment_AUDITAMOUNT_LOWER = "审核金额"; /// /// 审核金额大写 /// public const string Comment_AUDITAMOUNT_CAP = "审核金额大写"; /// /// 打印次数 /// public const string Comment_PRINT_COUNT = "打印次数"; /// /// 操作人内码 /// public const string Comment_STAFF_ID = "操作人内码"; /// /// 操作人名 /// public const string Comment_STAFF_NAME = "操作人名"; /// /// 操作时间 /// public const string Comment_OPERATE_DATE = "操作时间"; /// /// 收款人名 /// public const string Comment_RECEIVABLES_NAME = "收款人名"; /// /// 联系人 /// public const string Comment_CONTACTS = "联系人"; /// /// 联系电话 /// public const string Comment_CONTACTS_TEL = "联系电话"; /// /// 收款人账号 /// public const string Comment_RECEIVABLES_NUM = "收款人账号"; /// /// 开户行名 /// public const string Comment_BANK_NAME = "开户行名"; /// /// 收款联网行号 /// public const string Comment_BANK_CODE = "收款联网行号"; /// /// 备注 /// public const string Comment_COSTPLANBILL_DESC = "备注"; } #endregion }