Fin_DailyFeePaymentView.cs 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598
  1. using Npgsql.Replication.PgOutput;
  2. using OASystem.Domain.Entities.Financial;
  3. using OASystem.Domain.ViewModels.System;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. namespace OASystem.Domain.ViewModels.Financial
  10. {
  11. /// <summary>
  12. /// 日付申请 View
  13. /// </summary>
  14. public class Fin_DailyFeePaymentView : Fin_DailyFeePayment
  15. { }
  16. public class Fin_DailyFeePaymentPageCount
  17. {
  18. /// <summary>
  19. /// 总条数
  20. /// </summary>
  21. public int Count { get; set; }
  22. }
  23. /// <summary>
  24. /// 日付申请 分页查询View
  25. /// </summary>
  26. public class Fin_DailyFeePaymentPageListView
  27. {
  28. /// <summary>
  29. /// 是否选中
  30. /// </summary>
  31. public bool IsChecked { get; set; }
  32. /// <summary>
  33. /// 行号
  34. /// </summary>
  35. public int RowNumber { get; set; }
  36. /// <summary>
  37. /// Id
  38. /// </summary>
  39. public int Id { get; set; }
  40. /// <summary>
  41. /// 公司Id
  42. /// </summary>
  43. public int CompanyId { get; set; }
  44. /// <summary>
  45. /// 公司名称
  46. /// </summary>
  47. public string? CompanyName { get; set; }
  48. /// <summary>
  49. /// 费用描述
  50. /// </summary>
  51. public string? Instructions { get; set; }
  52. /// <summary>
  53. /// 费用总计
  54. /// </summary>
  55. public decimal? SumPrice { get; set; }
  56. /// <summary>
  57. /// 申请人Id
  58. /// </summary>
  59. public int CreateUserId { get; set; }
  60. /// <summary>
  61. /// 申请人姓名
  62. /// </summary>
  63. public string? CreateUser { get; set; }
  64. /// <summary>
  65. /// 申请时间
  66. /// </summary>
  67. public DateTime CreateTime { get; set; }
  68. /// <summary>
  69. /// 财务审核
  70. /// </summary>
  71. public int FAudit { get; set; }
  72. /// <summary>
  73. /// 财务 审核状态
  74. /// </summary>
  75. public string? FAuditDesc
  76. {
  77. get
  78. {
  79. string str = "未审核";
  80. if (FAudit == 0) str = "未审核";
  81. else if (FAudit == 1)
  82. {
  83. str = "已通过";
  84. FAuditName = "朱成梅";
  85. }
  86. else if (FAudit == 2)
  87. {
  88. str = "未通过";
  89. FAuditName = "朱成梅";
  90. }
  91. return str;
  92. }
  93. }
  94. /// <summary>
  95. /// 财务审核人姓名
  96. /// </summary>
  97. public string? FAuditName { get; set; } = "无";
  98. /// <summary>
  99. /// 总经理审核
  100. /// </summary>
  101. public int MAudit { get; set; }
  102. /// <summary>
  103. /// 总经理 审核状态
  104. /// </summary>
  105. public string? MAuditDesc
  106. {
  107. get
  108. {
  109. string str = "未审核";
  110. if (MAudit == 0) str = "未审核";
  111. else if (MAudit == 1) { str = "已通过"; MAuditName = "张海麟"; }
  112. else if (MAudit == 2) { str = "未通过"; MAuditName = "张海麟"; }
  113. return str;
  114. }
  115. }
  116. /// <summary>
  117. /// 总经理审核姓名
  118. /// </summary>
  119. public string? MAuditName { get; set; } = "无";
  120. /// <summary>
  121. /// 费用类型
  122. /// </summary>
  123. public int PriceTypeId { get; set; }
  124. /// <summary>
  125. /// 支付标识 0,1
  126. /// </summary>
  127. public int IsPay { get; set; }
  128. }
  129. /// <summary>
  130. /// 日服申请 分页
  131. /// </summary>
  132. public class Fin_DailyFeePaymentPage
  133. {
  134. /// <summary>
  135. /// 总条数
  136. /// </summary>
  137. public int? Rows { get; set; }
  138. public List<Fin_DailyFeePaymentPageListView> Data { get; set; }
  139. }
  140. /// <summary>
  141. /// 日付申请费用明细
  142. /// </summary>
  143. public class Fin_DailyFeePaymentContentInfolView
  144. {
  145. public int Id { get; set; }
  146. /// <summary>
  147. /// 费用名称
  148. /// </summary>
  149. public string PriceName { get; set; }
  150. /// <summary>
  151. /// 数量单价
  152. /// </summary>
  153. public decimal Quantity { get; set; }
  154. /// <summary>
  155. /// 费用单价
  156. /// </summary>
  157. public decimal Price { get; set; }
  158. /// <summary>
  159. /// 当前总计
  160. /// </summary>
  161. public decimal ItemTotal { get; set; }
  162. /// <summary>
  163. /// 备注
  164. /// </summary>
  165. public string Remark { get; set; }
  166. /// <summary>
  167. /// 备注描述
  168. /// </summary>
  169. public string RemaksDescription { get; set; }
  170. /// <summary>
  171. /// Excel备注描述
  172. /// </summary>
  173. public string ExcelRemaksDescription { get; set; }
  174. }
  175. public class Fin_DailyFeePaymentInfolView
  176. {
  177. public int Id { get; set; }
  178. public int CompanyId { get; set; }
  179. public int TransferTypeId { get; set; }
  180. public int PriceTypeId { get; set; }
  181. public string Instructions { get; set; }
  182. public decimal SumPrice { get; set; }
  183. public int CreateUserId { get; set; }
  184. /// <summary>
  185. /// 财务审核
  186. /// </summary>
  187. public int FAudit { get; set; }
  188. public string FAuditDesc
  189. {
  190. get
  191. {
  192. string str = "未审核";
  193. if (FAudit == 0) str = "未审核";
  194. else if (FAudit == 1) str = "已通过";
  195. else if (FAudit == 2) str = "未通过";
  196. return str;
  197. }
  198. }
  199. /// <summary>
  200. /// 总经理审核
  201. /// </summary>
  202. public int MAudit { get; set; }
  203. public string MAuditDesc
  204. {
  205. get
  206. {
  207. string str = "未审核";
  208. if (MAudit == 0) str = "未审核";
  209. else if (MAudit == 1) str = "已通过";
  210. else if (MAudit == 2) str = "未通过";
  211. return str;
  212. }
  213. }
  214. public DateTime CreateTime { get; set; }
  215. public List<Fin_DailyFeePaymentContentInfolView> FeeContents { get; set; }
  216. }
  217. /// <summary>
  218. /// android 详情
  219. /// </summary>
  220. public class Fin_DailyFeePaymentInfoAndroidlView
  221. {
  222. public int Id { get; set; }
  223. public int CompanyId { get; set; }
  224. public int TransferTypeId { get; set; }
  225. public int PriceTypeId { get; set; }
  226. public string Instructions { get; set; }
  227. public decimal SumPrice { get; set; }
  228. public int CreateUserId { get; set; }
  229. public List<Fin_DailyFeePaymentContentInfolView> FeeContents { get; set; }
  230. }
  231. /// <summary>
  232. /// 费用类型
  233. /// </summary>
  234. public class Fin_DailyFeePaymentPagePriceTypeView
  235. {
  236. /// <summary>
  237. /// 类型Id
  238. /// </summary>
  239. public int Id { get; set; }
  240. /// <summary>
  241. /// 名称
  242. /// </summary>
  243. public string Name { get; set; }
  244. }
  245. /// <summary>
  246. /// 费用子类型
  247. /// </summary>
  248. public class Fin_DailyFeePaymentPagePriceSubTypeView
  249. {
  250. /// <summary>
  251. /// 费用类型Id
  252. /// </summary>
  253. public int STid { get; set; }
  254. /// <summary>
  255. /// 子类型Id
  256. /// </summary>
  257. public int Id { get; set; }
  258. /// <summary>
  259. /// 子类型名称
  260. /// </summary>
  261. public string Name { get; set; }
  262. }
  263. /// <summary>
  264. /// 费用类型数据源
  265. /// </summary>
  266. public class Fin_DailyFeePaymentPagePriceTypeDataView
  267. {
  268. /// <summary>
  269. /// 费用类型
  270. /// </summary>
  271. public List<Fin_DailyFeePaymentPagePriceTypeView>? FeeTypeData { get; set; }
  272. /// <summary>
  273. /// 费用子类型
  274. /// </summary>
  275. public List<Fin_DailyFeePaymentPagePriceSubTypeView>? FeeSubTypeData { get; set; }
  276. /// <summary>
  277. /// 用户名称
  278. /// </summary>
  279. public List<UserNameView>? UserNameData { get; set; }
  280. /// <summary>
  281. /// 费用标识类型
  282. /// </summary>
  283. public List<Fin_DailyFeePaymentPagePriceTypeView>? FeeMarkTypeData { get; set; }
  284. /// <summary>
  285. /// 费用子类型
  286. /// </summary>
  287. public List<Fin_DailyFeePaymentPagePriceSubTypeView>? FeeMarkSubTypeData { get; set; }
  288. /// <summary>
  289. /// 公司名称
  290. /// </summary>
  291. public List<CompanyNameView>? CompanyNameData { get; set; }
  292. }
  293. /// <summary>
  294. /// 类型数据源
  295. /// </summary>
  296. public class DailyFeePaymentDataSourceView : Fin_DailyFeePaymentPagePriceTypeView
  297. {
  298. public List<Fin_DailyFeePaymentPagePriceSubTypeView> SubDatas { get; set; }
  299. }
  300. public class tree_Fin_DailyFeePaymentPageListView : Fin_DailyFeePaymentPageListView
  301. {
  302. public List<Fin_DailyFeePaymentContentInfolView> childList { get; set; }
  303. public string priceTypeStr { get; set; }
  304. public int transferTypeId { get; set; }
  305. public string transferTypeIdStr { get; set; }
  306. /// <summary>
  307. /// 公转:62,私转:63 --2024年4月9日 16:49:46 0,1
  308. /// </summary>
  309. public int transferParentId { get; set; }
  310. public string transferParentIdStr { get; set; }
  311. }
  312. public class tree_Fin_DailyFeePaymentResult : tree_Fin_DailyFeePaymentPageListView
  313. {
  314. public decimal gz { get; set; } = 0M;
  315. public decimal sz { get; set; } = 0M;
  316. public List<tree_Fin_DailyFeePaymentPageListView> dataList { get; set; }
  317. }
  318. /// <summary>
  319. /// 团组相关费用
  320. /// </summary>
  321. public class tree_Group_DailyFeePaymentResult
  322. {
  323. public decimal gz { get; set; } = 0M;
  324. public decimal sz { get; set; } = 0M;
  325. public List<tree_Group_DailyFeePaymentPageListView> dataList { get; set; }
  326. }
  327. /// <summary>
  328. /// 团组相关费用 List
  329. /// </summary>
  330. public class tree_Group_DailyFeePaymentPageListView
  331. {
  332. public string Id { get; set; }
  333. public string GroupName { get; set; }
  334. /// <summary>
  335. /// 费用所属公司Id
  336. /// </summary>
  337. public int CompanyId { get; set; }
  338. /// <summary>
  339. /// 费用所属公司
  340. /// </summary>
  341. public string ConpanyName { get; set; }
  342. /// <summary>
  343. /// 团组总计金额
  344. /// </summary>
  345. public decimal CNYTotalAmount { get; set; }
  346. public List<Group_DailyFeePaymentContentInfolView> ChildList { get; set; }
  347. }
  348. public class CompanyInfo
  349. {
  350. public int Id { get; set; }
  351. public string ConpanyName { get; set; }
  352. }
  353. public class Group_DailyFeePaymentContentInfolView
  354. {
  355. /// <summary>
  356. /// 是否选中
  357. /// </summary>
  358. public bool IsChecked { get; set; }
  359. public int Id { get; set; }
  360. /// <summary>
  361. /// 酒店费用子类 Id
  362. /// </summary>
  363. public int HotelSubId { get; set; } = -1;
  364. /// <summary>
  365. /// 支付方式
  366. /// </summary>
  367. public string PayType { get; set; }
  368. /// <summary>
  369. /// 转账标识
  370. /// </summary>
  371. public string TransferMark { get; set; }
  372. /// <summary>
  373. /// 序号
  374. /// </summary>
  375. public int RowNumber { get; set; }
  376. /// <summary>
  377. /// 申请人
  378. /// </summary>
  379. public string Applicant { get; set; }
  380. /// <summary>
  381. /// 申请时间
  382. /// </summary>
  383. public string ApplicantDt { get; set; }
  384. /// <summary>
  385. /// 收款方
  386. /// </summary>
  387. public string Payee { get; set; }
  388. /// <summary>
  389. /// 费用名称
  390. /// </summary>
  391. public string PriceName { get; set; }
  392. /// <summary>
  393. /// 费用所属模块
  394. /// </summary>
  395. public string ModuleName { get; set; }
  396. /// <summary>
  397. /// 付款币种
  398. /// </summary>
  399. public string PayCurrCode { get; set; }
  400. /// <summary>
  401. /// 付款金额
  402. /// </summary>
  403. public decimal PaymentAmount { get; set; }
  404. /// <summary>
  405. /// 付款汇率
  406. /// </summary>
  407. public decimal PayRate { get; set; }
  408. /// <summary>
  409. /// 小计人民币金额
  410. /// </summary>
  411. public decimal CNYSubTotalAmount { get; set; }
  412. /// <summary>
  413. /// 费用描述
  414. /// </summary>
  415. public string RemaksDescription { get; set; }
  416. /// <summary>
  417. /// 审核状态
  418. /// 0 未审核 1已通过 2未通过 3 自动审核
  419. /// </summary>
  420. public int AuditStatus { get; set; }
  421. }
  422. public class PaymentRequestCheckedView
  423. {
  424. public List<int> GroupIds { get; set; }
  425. public List<int> DailyPaymentIds { get; set; }
  426. public List<int> HotelSubIds { get; set; }
  427. }
  428. #region 日付报表
  429. [SqlSugar.SugarTable("Fin_DailyFeePayment")]
  430. public class DailyFeePaymentRangeView
  431. {
  432. public string ViewStr
  433. {
  434. get
  435. {
  436. return $"{RowIndex}、【{CompanyName}】【{TransferType}】【{FeeType}】【{Instructions}】【{SumPrice.ToString("#0.00")}】【申请人:{Applicant} 申请时间:{ApplicantDt.ToString("yyyy-MM-dd HH:mm:ss")}】";
  437. }
  438. }
  439. [SugarColumn(IsIgnore = true)]//需要加上
  440. public int RowIndex { get; set; } //行号 序号
  441. [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
  442. public int Id { get; set; }
  443. public string Instructions { get; set; }
  444. public int PriceTypeId { get; set; }
  445. public string FeeType { get; set; }
  446. public int TransferTypeId { get; set; }
  447. public string TransferType { get; set; }
  448. public decimal SumPrice { get; set; }
  449. public DateTime FAuditDate { get; set; }
  450. public DateTime MAuditDate { get; set; }
  451. public int CompanyId { get; set; }
  452. public string CompanyName { get; set; }
  453. public int ApplicantId { get; set; }
  454. public string Applicant { get; set; }
  455. public DateTime ApplicantDt { get; set; }
  456. [Navigate(NavigateType.OneToMany, nameof(DailyFeePaymentContentView.DFPId))]//BookA表中的studenId
  457. public List<DailyFeePaymentContentView> Contents { get; set; }
  458. //public string ContentStr { get; set; }
  459. }
  460. [SqlSugar.SugarTable("Fin_DailyFeePaymentContent")]
  461. public class DailyFeePaymentContentView
  462. {
  463. //[SugarColumn(IsIgnore = true)]//需要加上
  464. //public int RowIndex { get; set; } //行号 序号
  465. [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
  466. public int Id { get; set; }
  467. public int DFPId { get; set; }
  468. public string PriceName { get; set; }
  469. public int Quantity { get; set; }
  470. public decimal Price { get; set; }
  471. public decimal ItemTotal { get; set; }
  472. public string Remark { get; set; }
  473. //public int IsDel { get; set; }
  474. /// <summary>
  475. /// 示例:费用名称:[2024.07.11招商信用卡还款] 单价:[20000.00] 数量:[1.00] 小计:[20000.00] 备注:[]
  476. /// </summary>
  477. //public string ViewStr
  478. //{
  479. // get
  480. // {
  481. // return $"费用名称:[{PriceName}] 单价:[{Price.ToString("#0.00")}] 数量:[{Quantity.ToString("#0.00")}] 小计:[{ItemTotal.ToString("#0.00")}] 备注:[{Remark}]";
  482. // }
  483. //}
  484. //public string ViewSubStr { get; set; }
  485. }
  486. public class ExcelView : DailyFeePaymentRangeView
  487. {
  488. public string ContentStr { get; set; }
  489. }
  490. #endregion
  491. }