123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574 |
- 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
- {
- /// <summary>
- /// 日付申请 View
- /// </summary>
- public class Fin_DailyFeePaymentView : Fin_DailyFeePayment
- { }
- public class Fin_DailyFeePaymentPageCount
- {
- /// <summary>
- /// 总条数
- /// </summary>
- public int Count { get; set; }
- }
- /// <summary>
- /// 日付申请 分页查询View
- /// </summary>
- public class Fin_DailyFeePaymentPageListView
- {
- /// <summary>
- /// 是否选中
- /// </summary>
- public bool IsChecked { get; set; }
- /// <summary>
- /// 行号
- /// </summary>
- public int RowNumber { get; set; }
- /// <summary>
- /// Id
- /// </summary>
- public int Id { get; set; }
- /// <summary>
- /// 公司Id
- /// </summary>
- public int CompanyId { get; set; }
- /// <summary>
- /// 公司名称
- /// </summary>
- public string? CompanyName { get; set; }
- /// <summary>
- /// 费用描述
- /// </summary>
- public string? Instructions { get; set; }
- /// <summary>
- /// 费用总计
- /// </summary>
- public decimal? SumPrice { get; set; }
- /// <summary>
- /// 申请人Id
- /// </summary>
- public int CreateUserId { get; set; }
- /// <summary>
- /// 申请人姓名
- /// </summary>
- public string? CreateUser { get; set; }
- /// <summary>
- /// 申请时间
- /// </summary>
- public DateTime CreateTime { get; set; }
- /// <summary>
- /// 财务审核
- /// </summary>
- public int FAudit { get; set; }
- /// <summary>
- /// 财务 审核状态
- /// </summary>
- public string? FAuditDesc
- {
- get
- {
- string str = "未审核";
- if (FAudit == 0) str = "未审核";
- else if (FAudit == 1)
- {
- str = "已通过";
- FAuditName = "朱成梅";
- }
- else if (FAudit == 2)
- {
- str = "未通过";
- FAuditName = "朱成梅";
- }
- return str;
- }
- }
- /// <summary>
- /// 财务审核人姓名
- /// </summary>
- public string? FAuditName { get; set; } = "无";
- /// <summary>
- /// 总经理审核
- /// </summary>
- public int MAudit { get; set; }
- /// <summary>
- /// 总经理 审核状态
- /// </summary>
- public string? MAuditDesc
- {
- get
- {
- string str = "未审核";
- if (MAudit == 0) str = "未审核";
- else if (MAudit == 1) { str = "已通过"; MAuditName = "张海麟"; }
- else if (MAudit == 2) { str = "未通过"; MAuditName = "张海麟"; }
- return str;
- }
- }
- /// <summary>
- /// 总经理审核姓名
- /// </summary>
- public string? MAuditName { get; set; } = "无";
- /// <summary>
- /// 费用类型
- /// </summary>
- public int PriceTypeId { get; set; }
- /// <summary>
- /// 支付标识 0,1
- /// </summary>
- public int IsPay { get; set; }
- }
- /// <summary>
- /// 日服申请 分页
- /// </summary>
- public class Fin_DailyFeePaymentPage
- {
- /// <summary>
- /// 总条数
- /// </summary>
- public int? Rows { get; set; }
- public List<Fin_DailyFeePaymentPageListView> Data { get; set; }
- }
- /// <summary>
- /// 日付申请费用明细
- /// </summary>
- public class Fin_DailyFeePaymentContentInfolView
- {
- public int Id { get; set; }
- /// <summary>
- /// 费用名称
- /// </summary>
- public string PriceName { get; set; }
- /// <summary>
- /// 数量单价
- /// </summary>
- public decimal Quantity { get; set; }
- /// <summary>
- /// 费用单价
- /// </summary>
- public decimal Price { get; set; }
- /// <summary>
- /// 当前总计
- /// </summary>
- public decimal ItemTotal { get; set; }
- /// <summary>
- /// 备注
- /// </summary>
- public string Remark { get; set; }
- /// <summary>
- /// 备注描述
- /// </summary>
- public string RemaksDescription { get; set; }
- /// <summary>
- /// Excel备注描述
- /// </summary>
- 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; }
- /// <summary>
- /// 财务审核
- /// </summary>
- 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;
- }
- }
- /// <summary>
- /// 总经理审核
- /// </summary>
- 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<Fin_DailyFeePaymentContentInfolView> FeeContents { get; set; }
- }
- /// <summary>
- /// android 详情
- /// </summary>
- 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<Fin_DailyFeePaymentContentInfolView> FeeContents { get; set; }
- }
- /// <summary>
- /// 费用类型
- /// </summary>
- public class Fin_DailyFeePaymentPagePriceTypeView
- {
- /// <summary>
- /// 类型Id
- /// </summary>
- public int Id { get; set; }
- /// <summary>
- /// 名称
- /// </summary>
- public string Name { get; set; }
- }
- /// <summary>
- /// 费用子类型
- /// </summary>
- public class Fin_DailyFeePaymentPagePriceSubTypeView
- {
- /// <summary>
- /// 费用类型Id
- /// </summary>
- public int STid { get; set; }
- /// <summary>
- /// 子类型Id
- /// </summary>
- public int Id { get; set; }
- /// <summary>
- /// 子类型名称
- /// </summary>
- public string Name { get; set; }
- }
- /// <summary>
- /// 费用类型数据源
- /// </summary>
- public class Fin_DailyFeePaymentPagePriceTypeDataView
- {
- /// <summary>
- /// 费用类型
- /// </summary>
- public List<Fin_DailyFeePaymentPagePriceTypeView>? FeeTypeData { get; set; }
- /// <summary>
- /// 费用子类型
- /// </summary>
- public List<Fin_DailyFeePaymentPagePriceSubTypeView>? FeeSubTypeData { get; set; }
- /// <summary>
- /// 用户名称
- /// </summary>
- public List<UserNameView>? UserNameData { get; set; }
- /// <summary>
- /// 费用标识类型
- /// </summary>
- public List<Fin_DailyFeePaymentPagePriceTypeView>? FeeMarkTypeData { get; set; }
- /// <summary>
- /// 费用子类型
- /// </summary>
- public List<Fin_DailyFeePaymentPagePriceSubTypeView>? FeeMarkSubTypeData { get; set; }
- /// <summary>
- /// 公司名称
- /// </summary>
- public List<CompanyNameView>? CompanyNameData { get; set; }
- }
- /// <summary>
- /// 类型数据源
- /// </summary>
- public class DailyFeePaymentDataSourceView : Fin_DailyFeePaymentPagePriceTypeView
- {
- public List<Fin_DailyFeePaymentPagePriceSubTypeView> SubDatas { get; set; }
- }
- public class tree_Fin_DailyFeePaymentPageListView : Fin_DailyFeePaymentPageListView
- {
- public List<Fin_DailyFeePaymentContentInfolView> childList { get; set; }
- public string priceTypeStr { get; set; }
- public int transferTypeId { get; set; }
- public string transferTypeIdStr { get; set; }
- /// <summary>
- /// 公转:62,私转:63 --2024年4月9日 16:49:46 0,1
- /// </summary>
- 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<tree_Fin_DailyFeePaymentPageListView> dataList { get; set; }
- }
- /// <summary>
- /// 团组相关费用
- /// </summary>
- public class tree_Group_DailyFeePaymentResult
- {
- public decimal gz { get; set; } = 0M;
- public decimal sz { get; set; } = 0M;
- public List<tree_Group_DailyFeePaymentPageListView> dataList { get; set; }
- }
- /// <summary>
- /// 团组相关费用 List
- /// </summary>
- public class tree_Group_DailyFeePaymentPageListView
- {
- public string Id { get; set; }
- public string GroupName { get; set; }
- /// <summary>
- /// 费用所属公司Id
- /// </summary>
- public int CompanyId { get; set; }
- /// <summary>
- /// 费用所属公司
- /// </summary>
- public string ConpanyName { get; set; }
- /// <summary>
- /// 团组总计金额
- /// </summary>
- public decimal CNYTotalAmount { get; set; }
- public List<Group_DailyFeePaymentContentInfolView> ChildList { get; set; }
- }
- public class CompanyInfo
- {
- public int Id { get; set; }
- public string ConpanyName { get; set; }
- }
- public class Group_DailyFeePaymentContentInfolView
- {
- /// <summary>
- /// 是否选中
- /// </summary>
- public bool IsChecked { get; set; }
- public int Id { get; set; }
- /// <summary>
- /// 酒店费用子类 Id
- /// </summary>
- public int HotelSubId { get; set; } = -1;
- /// <summary>
- /// 支付方式
- /// </summary>
- public string PayType { get; set; }
- /// <summary>
- /// 转账标识
- /// </summary>
- public string TransferMark { get; set; }
- /// <summary>
- /// 序号
- /// </summary>
- public int RowNumber { get; set; }
- /// <summary>
- /// 申请人
- /// </summary>
- public string Applicant { get; set; }
- /// <summary>
- /// 申请时间
- /// </summary>
- public string ApplicantDt { get; set; }
- /// <summary>
- /// 收款方
- /// </summary>
- public string Payee { get; set; }
- /// <summary>
- /// 费用名称
- /// </summary>
- public string PriceName { get; set; }
- /// <summary>
- /// 费用所属模块
- /// </summary>
- public string ModuleName { get; set; }
- /// <summary>
- /// 付款币种
- /// </summary>
- public string PayCurrCode { get; set; }
- /// <summary>
- /// 付款金额
- /// </summary>
- public decimal PaymentAmount { get; set; }
- /// <summary>
- /// 付款汇率
- /// </summary>
- public decimal PayRate { get; set; }
- /// <summary>
- /// 小计人民币金额
- /// </summary>
- public decimal CNYSubTotalAmount { get; set; }
- /// <summary>
- /// 费用描述
- /// </summary>
- public string RemaksDescription { get; set; }
- /// <summary>
- /// 审核状态
- /// 0 未审核 1已通过 2未通过 3 自动审核
- /// </summary>
- public int AuditStatus { get; set; }
- }
- public class PaymentRequestCheckedView
- {
- public List<int> GroupIds { get; set; }
- public List<int> DailyPaymentIds { get; set; }
- public List<int> HotelSubIds { get; set; }
- }
- #region 日付报表
- [SqlSugar.SugarTable("Fin_DailyFeePayment")]
- public class DailyFeePaymentRangeView
- {
- [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<DailyFeePaymentContentView> Contents { 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; }
- }
- public class ExcelView : DailyFeePaymentRangeView
- {
- public string ContentStr { get; set; }
- }
- #endregion
- }
|