OrderSendExcelDto.cs 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. namespace ShwasherSys.Common.Dto
  7. {
  8. public class OrderSendItemExcelDto
  9. {
  10. public int Index { get; set; }
  11. public string StockNo { get; set; }
  12. public string PartNo { get; set; }
  13. public string ProductName { get; set; }
  14. public string Model { get; set; }
  15. public string SurfaceColor { get; set; }
  16. public string Material { get; set; }
  17. public string Rigidity { get; set; }
  18. public string Unit { get; set; }
  19. //发送数量
  20. public decimal SendQuantity { get; set; }
  21. //包数
  22. public decimal PackageCount { get; set; }
  23. //每包数量
  24. public decimal QuantityPerPack { get; set; }
  25. //剩余数量
  26. public decimal Sysl { get; set; }
  27. public decimal Price { get; set; }
  28. public decimal AfterTaxPrice { get; set; }
  29. public decimal TotalPrice { get; set; }
  30. public string ProductBatchNum { get; set; }
  31. //excel中特殊地方显示不同格式
  32. public DateTime? SendDate { get; set; }
  33. public string SendDateStr { get; set; }
  34. public string Desc { get; set; }
  35. public string Remark { get; set; }
  36. public string Ext1 { get; set; }
  37. public string MaterialHsCode { get; set; }
  38. public string ProductHsCode { get; set; }
  39. public string CustomerRowNo { get; set; }
  40. public decimal KgWeight { get; set; }
  41. public decimal AllWeight { get; set; }
  42. public string CurrentProductStoreHouseNo { get; set; }
  43. }
  44. public class OrderSendMiniExcelDto
  45. {
  46. //日期 yyyy-MM-dd
  47. public string Ex1 { get; set; }
  48. //日期 yyyy年MM月dd日
  49. public string Ex2 { get; set; }
  50. public string Ex3 { get; set; }
  51. public decimal AllPackageCount { get; set; }
  52. public decimal AllSendQuantity { get; set; }
  53. public decimal AllTotalPrice { get; set; }
  54. public string OrderSendBillNo { get; set; }
  55. public string CustomerName { get; set; }
  56. public string SendAddress { get; set; }
  57. public string ContactTels { get; set; }
  58. public string ContactMan { get; set; }
  59. public DateTime? SendDate { get; set; }
  60. public List<OrderSendItemExcelDto> send { get; set; }
  61. }
  62. }