SJA工艺
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

100 lines
7.9 KiB

3 years ago
  1. package models
  2. import (
  3. "LAPP_SJA_ME/db"
  4. "LAPP_SJA_ME/utils"
  5. )
  6. // 项目对象
  7. type MeProject struct {
  8. Finr int `xorm:"pk" json:"me_project-finr"`
  9. Projectid string `xorm:"pk" json:"me_project-projectid"`
  10. Descr string `xorm:"comment('描述') VARCHAR(40)" json:"me_project-descr"`
  11. Enabled int `xorm:"comment('tod')" json:"me_project-enabled"`
  12. Plantsitecode int `xorm:"comment('tod')" json:"me_project-plantsitecode"`
  13. Parse_tod int `xorm:"comment('tod')" json:"me_project-parse_tod"`
  14. Parse_seq int `xorm:"comment('seq')" json:"me_project-parse_seq"`
  15. Parse_reorder int `xorm:"comment('seq')" json:"me_project-parse_reorder"`
  16. Parse_calloff int `xorm:"comment('seq')" json:"me_project-parse_calloff"`
  17. Fileserver_host string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-fileserver_host"`
  18. Tod_folder string `xorm:"comment('名称') VARCHAR(150)" json:"me_project-tod_folder"`
  19. Seq_folder string `xorm:"comment('名称') VARCHAR(150)" json:"me_project-seq_folder"`
  20. Reorder_folder string `xorm:"comment('名称') VARCHAR(150)" json:"me_project-reorder_folder"`
  21. Calloff_folder string `xorm:"comment('名称') VARCHAR(150)" json:"me_project-calloff_folder"`
  22. Tod_filename_regexp string `xorm:"comment('是否共用字段') VARCHAR(150)" json:"me_project-tod_filename_regexp"`
  23. Seq_filename_regexp string `xorm:"comment('是否共用字段') VARCHAR(150)" json:"me_project-seq_filename_regexp"`
  24. Reorder_filename_regexp string `xorm:"comment('是否共用字段') VARCHAR(150)" json:"me_project-reorder_filename_regexp"`
  25. Calloff_filename_regexp string `xorm:"comment('是否共用字段') VARCHAR(150)" json:"me_project-calloff_filename_regexp"`
  26. Tod_verify_part int `xorm:"comment('是否共用字段') int(0)" json:"me_project-tod_verify_part"`
  27. Tod_verify_partfamily int `xorm:"comment('是否共用字段') int(0)" json:"me_project-tod_verify_partfamily"`
  28. Tod_verify_supplygroup int `xorm:"comment('是否共用字段') int(0)" json:"me_project-tod_verify_supplygroup"`
  29. Tod_verify_partfamilyattribute int `xorm:"comment('是否共用字段') int(0)" json:"me_project-tod_verify_partfamilyattribute"`
  30. Tod_verify_supplygroupattribute int `xorm:"comment('是否共用字段') int(0)" json:"me_project-tod_verify_supplygroupattribute"`
  31. Seq_verify_sequence int `xorm:"comment('是否共用字段') int(0)" json:"me_project-seq_verify_sequence"`
  32. Seq_verfiy_partfamily string `xorm:"comment('是否共用字段') VARCHAR(60)" json:"me_project-seq_verfiy_partfamily"`
  33. Seq_verify_carmodelattribute int `xorm:"comment('是否共用字段') int(0)" json:"me_project-seq_verify_carmodelattribute"`
  34. Reorder_email_alert int `xorm:"comment('是否共用字段') int(0)" json:"me_project-reorder_email_alert"`
  35. Calloff_verify_checksequence int `xorm:"comment('是否共用字段') int(0)" json:"me_project-calloff_verify_checksequence"`
  36. Calloff_verify_orderstatus int `xorm:"comment('是否共用字段') int(0)" json:"me_project-calloff_verify_orderstatus"`
  37. Calloff_verify_orderspec int `xorm:"comment('是否共用字段') int(0)" json:"me_project-calloff_verify_orderspec"`
  38. Emailserver_host string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-emailserver_host"`
  39. Emailserver_port int `xorm:"comment('是否共用字段') int(0)" json:"me_project-emailserver_port"`
  40. From_email string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-from_email"`
  41. From_pwd string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-from_pwd"`
  42. Tod_error_to_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-tod_error_cc_recievers"`
  43. Tod_error_cc_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-tod_error_cc_recievers"`
  44. Seq_error_to_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-seq_error_to_recievers"`
  45. Seq_error_cc_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-seq_error_cc_recievers"`
  46. Reorder_picktemplateid string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-reorder_picktemplateid"`
  47. Reorder_pickorder_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-reorder_pickorder_snr"`
  48. Reorder_error_to_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-reorder_error_to_recievers"`
  49. Reorder_error_cc_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-reorder_error_cc_recievers"`
  50. Calloff_error_to_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-calloff_error_to_recievers"`
  51. Calloff_error_cc_recievers string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-calloff_error_cc_recievers"`
  52. Log_url string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-log_url"`
  53. Log_table string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-log_table"`
  54. Custorder_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-custorder_snr"`
  55. Workorder_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-workorder_snr"`
  56. Manualwo_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-manualwo_snr"`
  57. Ordermsg_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-ordermsg_snr"`
  58. Reorder_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-reorder_snr"`
  59. Shippack_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-shippack_snr"`
  60. Shippacksync_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-shippacksync_snr"`
  61. Shipcar_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-shipcar_snr"`
  62. Asn_file_prefix string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-asn_file_prefix"`
  63. Asn_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-asn_snr"`
  64. Asn_pfmapper string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-asn_pfmapper"`
  65. Asn_file_type string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-asn_file_type"`
  66. Asn_folder string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-asn_folder"`
  67. Backflush_folder string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-backflush_folder"`
  68. Shipfile_folder string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-shipfile_folder"`
  69. Tier2_folder string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-tier2_folder"`
  70. Shipfile_snr string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-shipfile_snr"`
  71. Lastmodif string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-lastmodif"`
  72. Lastuser string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-lastuser"`
  73. Credatuz string `xorm:"comment('名称') VARCHAR(60)" json:"me_project-credatuz"`
  74. }
  75. func (t *MeProject) TableName() string {
  76. return "me_project"
  77. }
  78. // 清除string字段的右侧空格
  79. func (t *MeProject) Clipped() {
  80. utils.TrimStruct(t, *t)
  81. }
  82. //查
  83. func (t *MeProject) SelectAll() ([]MeProject, error) {
  84. e := db.Eloquent.Master()
  85. var data []MeProject
  86. err := e.Where("finr = ? ", t.Finr).Find(&data)
  87. if err != nil {
  88. return data, err
  89. }
  90. for k, _ := range data {
  91. data[k].Clipped()
  92. }
  93. return data, nil
  94. }