优化 OP70读取数据

schangxiang@126.com

2024-08-22 96b262bf9aacdcf75ced36a55c4a9805474c2d9a

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
namespace iWare_SCADA_Model
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;
 
    [Table("WorkPieceInfoLog")]
    public partial class WorkPieceInfoLog
    {
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long Id { get; set; }
 
        public int WorkPieceInfoID { get; set; }
 
        [Required]
        [StringLength(32)]
        public string WorkPieceID { get; set; }
 
        public int WorkPieceState { get; set; }
 
        public int WorkPieceCurrentPositionOrder { get; set; }
 
        [StringLength(255)]
        public string WorkPieceCurrentPosition { get; set; }
 
        [StringLength(32)]
        public string EquipmentID { get; set; }
 
        [StringLength(255)]
        public string WorkingProcedureCompleted { get; set; }
 
        [StringLength(255)]
        public string WorkingProcedurePlan { get; set; }
 
        [StringLength(32)]
        public string WorkingProcedureCurrent { get; set; }
 
        [Column(TypeName = "datetime2")]
        public DateTime WorkingProcedureStartTime { get; set; }
 
        public int ProcessingDurationForCurrent { get; set; }
 
        public int ProcessingDurationTotal { get; set; }
 
        [Column(TypeName = "datetime2")]
        public DateTime WorkPieceinitOnlineTime { get; set; }
 
        public int Number { get; set; }
 
        [StringLength(2)]
        public string WorkPieceIDTo1 { get; set; }
 
        [StringLength(4)]
        public string WorkPieceIDTo2 { get; set; }
 
        [StringLength(6)]
        public string WorkPieceIDTo3 { get; set; }
 
        [StringLength(2)]
        public string WorkPieceIDTo4 { get; set; }
 
        [StringLength(4)]
        public string WorkPieceIDTo5 { get; set; }
 
        [StringLength(2)]
        public string WorkPieceIDTo6 { get; set; }
 
        [StringLength(2)]
        public string WorkPieceIDTo7 { get; set; }
 
        public int QualityState { get; set; }
 
        [StringLength(32)]
        public string QualityStateUpdateUser { get; set; }
 
        [Column(TypeName = "datetime2")]
        public DateTime QualityStateUpdateTime { get; set; }
 
        [StringLength(32)]
        public string QualityStateUpdateMode { get; set; }
 
        public int AlertType { get; set; }
 
        [StringLength(255)]
        public string AlertMsg { get; set; }
 
        [StringLength(255)]
        public string Remarks { get; set; }
 
        public DateTimeOffset? CreatedTime { get; set; }
 
        public DateTimeOffset? UpdatedTime { get; set; }
 
        public long? CreatedUserId { get; set; }
 
        [StringLength(50)]
        public string CreatedUserName { get; set; }
 
        public long? UpdatedUserId { get; set; }
 
        [StringLength(50)]
        public string UpdatedUserName { get; set; }
 
        public bool IsDeleted { get; set; }
    }
}