using Npgsql.Replication.PgOutput; using OASystem.Domain.Entities.Financial; using OASystem.Domain.ViewModels.System; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace OASystem.Domain.ViewModels.Financial { /// /// 日付申请 View /// public class Fin_DailyFeePaymentView : Fin_DailyFeePayment { } public class Fin_DailyFeePaymentPageCount { /// /// 总条数 /// public int Count { get; set; } } /// /// 日付申请 分页查询View /// public class Fin_DailyFeePaymentPageListView { /// /// 是否选中 /// public bool IsChecked { get; set; } /// /// 行号 /// public int RowNumber { get; set; } /// /// Id /// public int Id { get; set; } /// /// 公司Id /// public int CompanyId { get; set; } /// /// 公司名称 /// public string? CompanyName { get; set; } /// /// 费用描述 /// public string? Instructions { get; set; } /// /// 费用总计 /// public decimal? SumPrice { get; set; } /// /// 申请人Id /// public int CreateUserId { get; set; } /// /// 申请人姓名 /// public string? CreateUser { get; set; } /// /// 申请时间 /// public DateTime CreateTime { get; set; } /// /// 财务审核 /// public int FAudit { get; set; } /// /// 财务 审核状态 /// public string? FAuditDesc { get { string str = "未审核"; if (FAudit == 0) str = "未审核"; else if (FAudit == 1) { str = "已通过"; FAuditName = "朱成梅"; } else if (FAudit == 2) { str = "未通过"; FAuditName = "朱成梅"; } return str; } } /// /// 财务审核人姓名 /// public string? FAuditName { get; set; } = "无"; /// /// 总经理审核 /// public int MAudit { get; set; } /// /// 总经理 审核状态 /// public string? MAuditDesc { get { string str = "未审核"; if (MAudit == 0) str = "未审核"; else if (MAudit == 1) { str = "已通过"; MAuditName = "张海麟"; } else if (MAudit == 2) { str = "未通过"; MAuditName = "张海麟"; } return str; } } /// /// 总经理审核姓名 /// public string? MAuditName { get; set; } = "无"; /// /// 费用类型 /// public int PriceTypeId { get; set; } /// /// 支付标识 0,1 /// public int IsPay { get; set; } } /// /// 日服申请 分页 /// public class Fin_DailyFeePaymentPage { /// /// 总条数 /// public int? Rows { get; set; } public List Data { get; set; } } /// /// 日付申请费用明细 /// public class Fin_DailyFeePaymentContentInfolView { public int Id { get; set; } /// /// 费用名称 /// public string PriceName { get; set; } /// /// 数量单价 /// public decimal Quantity { get; set; } /// /// 费用单价 /// public decimal Price { get; set; } /// /// 当前总计 /// public decimal ItemTotal { get; set; } /// /// 备注 /// public string Remark { get; set; } /// /// 备注描述 /// public string RemaksDescription { get; set; } /// /// Excel备注描述 /// public string ExcelRemaksDescription { get; set; } } public class Fin_DailyFeePaymentInfolView { public int Id { get; set; } public int CompanyId { get; set; } public int TransferTypeId { get; set; } public int PriceTypeId { get; set; } public string Instructions { get; set; } public decimal SumPrice { get; set; } public int CreateUserId { get; set; } /// /// 财务审核 /// public int FAudit { get; set; } public string FAuditDesc { get { string str = "未审核"; if (FAudit == 0) str = "未审核"; else if (FAudit == 1) str = "已通过"; else if (FAudit == 2) str = "未通过"; return str; } } /// /// 总经理审核 /// public int MAudit { get; set; } public string MAuditDesc { get { string str = "未审核"; if (MAudit == 0) str = "未审核"; else if (MAudit == 1) str = "已通过"; else if (MAudit == 2) str = "未通过"; return str; } } public DateTime CreateTime { get; set; } public List FeeContents { get; set; } } /// /// android 详情 /// public class Fin_DailyFeePaymentInfoAndroidlView { public int Id { get; set; } public int CompanyId { get; set; } public int TransferTypeId { get; set; } public int PriceTypeId { get; set; } public string Instructions { get; set; } public decimal SumPrice { get; set; } public int CreateUserId { get; set; } public List FeeContents { get; set; } } /// /// 费用类型 /// public class Fin_DailyFeePaymentPagePriceTypeView { /// /// 类型Id /// public int Id { get; set; } /// /// 名称 /// public string Name { get; set; } } /// /// 费用子类型 /// public class Fin_DailyFeePaymentPagePriceSubTypeView { /// /// 费用类型Id /// public int STid { get; set; } /// /// 子类型Id /// public int Id { get; set; } /// /// 子类型名称 /// public string Name { get; set; } } /// /// 费用类型数据源 /// public class Fin_DailyFeePaymentPagePriceTypeDataView { /// /// 费用类型 /// public List? FeeTypeData { get; set; } /// /// 费用子类型 /// public List? FeeSubTypeData { get; set; } /// /// 用户名称 /// public List? UserNameData { get; set; } /// /// 费用标识类型 /// public List? FeeMarkTypeData { get; set; } /// /// 费用子类型 /// public List? FeeMarkSubTypeData { get; set; } /// /// 公司名称 /// public List? CompanyNameData { get; set; } } /// /// 类型数据源 /// public class DailyFeePaymentDataSourceView : Fin_DailyFeePaymentPagePriceTypeView { public List SubDatas { get; set; } } public class tree_Fin_DailyFeePaymentPageListView : Fin_DailyFeePaymentPageListView { public List childList { get; set; } public string priceTypeStr { get; set; } public int transferTypeId { get; set; } public string transferTypeIdStr { get; set; } /// /// 公转:62,私转:63 --2024年4月9日 16:49:46 0,1 /// public int transferParentId { get; set; } public string transferParentIdStr { get; set; } } public class tree_Fin_DailyFeePaymentResult : tree_Fin_DailyFeePaymentPageListView { public decimal gz { get; set; } = 0M; public decimal sz { get; set; } = 0M; public List dataList { get; set; } } /// /// 团组相关费用 /// public class tree_Group_DailyFeePaymentResult { public decimal gz { get; set; } = 0M; public decimal sz { get; set; } = 0M; public List dataList { get; set; } } /// /// 团组相关费用 List /// public class tree_Group_DailyFeePaymentPageListView { public string Id { get; set; } public string GroupName { get; set; } /// /// 费用所属公司Id /// public int CompanyId { get; set; } /// /// 费用所属公司 /// public string ConpanyName { get; set; } /// /// 团组总计金额 /// public decimal CNYTotalAmount { get; set; } public List ChildList { get; set; } } public class CompanyInfo { public int Id { get; set; } public string ConpanyName { get; set; } } public class Group_DailyFeePaymentContentInfolView { /// /// 是否选中 /// public bool IsChecked { get; set; } public int Id { get; set; } /// /// 酒店费用子类 Id /// public int HotelSubId { get; set; } = -1; /// /// 支付方式 /// public string PayType { get; set; } /// /// 转账标识 /// public string TransferMark { get; set; } /// /// 序号 /// public int RowNumber { get; set; } /// /// 申请人 /// public string Applicant { get; set; } /// /// 申请时间 /// public string ApplicantDt { get; set; } /// /// 收款方 /// public string Payee { get; set; } /// /// 费用名称 /// public string PriceName { get; set; } /// /// 费用所属模块 /// public string ModuleName { get; set; } /// /// 付款币种 /// public string PayCurrCode { get; set; } /// /// 付款金额 /// public decimal PaymentAmount { get; set; } /// /// 付款汇率 /// public decimal PayRate { get; set; } /// /// 小计人民币金额 /// public decimal CNYSubTotalAmount { get; set; } /// /// 费用描述 /// public string RemaksDescription { get; set; } /// /// 审核状态 /// 0 未审核 1已通过 2未通过 3 自动审核 /// public int AuditStatus { get; set; } } public class PaymentRequestCheckedView { public List GroupIds { get; set; } public List DailyPaymentIds { get; set; } public List HotelSubIds { get; set; } } #region 日付报表 [SqlSugar.SugarTable("Fin_DailyFeePayment")] public class DailyFeePaymentRangeView { public string ViewStr { get { return $"{RowIndex}、【{CompanyName}】【{TransferType}】【{FeeType}】【{Instructions}】【{SumPrice.ToString("#0.00")}】【申请人:{Applicant} 申请时间:{ApplicantDt.ToString("yyyy-MM-dd HH:mm:ss")}】"; } } [SugarColumn(IsIgnore = true)]//需要加上 public int RowIndex { get; set; } //行号 序号 [SugarColumn(IsPrimaryKey = true, IsIdentity = true)] public int Id { get; set; } public string Instructions { get; set; } public int PriceTypeId { get; set; } public string FeeType { get; set; } public int TransferTypeId { get; set; } public string TransferType { get; set; } public decimal SumPrice { get; set; } public DateTime FAuditDate { get; set; } public DateTime MAuditDate { get; set; } public int CompanyId { get; set; } public string CompanyName { get; set; } public int ApplicantId { get; set; } public string Applicant { get; set; } public DateTime ApplicantDt { get; set; } [Navigate(NavigateType.OneToMany, nameof(DailyFeePaymentContentView.DFPId))]//BookA表中的studenId public List Contents { get; set; } //public string ContentStr { get; set; } } [SqlSugar.SugarTable("Fin_DailyFeePaymentContent")] public class DailyFeePaymentContentView { //[SugarColumn(IsIgnore = true)]//需要加上 //public int RowIndex { get; set; } //行号 序号 [SugarColumn(IsPrimaryKey = true, IsIdentity = true)] public int Id { get; set; } public int DFPId { get; set; } public string PriceName { get; set; } public int Quantity { get; set; } public decimal Price { get; set; } public decimal ItemTotal { get; set; } public string Remark { get; set; } //public int IsDel { get; set; } /// /// 示例:费用名称:[2024.07.11招商信用卡还款] 单价:[20000.00] 数量:[1.00] 小计:[20000.00] 备注:[] /// //public string ViewStr //{ // get // { // return $"费用名称:[{PriceName}] 单价:[{Price.ToString("#0.00")}] 数量:[{Quantity.ToString("#0.00")}] 小计:[{ItemTotal.ToString("#0.00")}] 备注:[{Remark}]"; // } //} //public string ViewSubStr { get; set; } } public class ExcelView : DailyFeePaymentRangeView { public string ContentStr { get; set; } } #endregion }