冲突

duheng

2024-07-23 3fec42c6383aa3b8d65f744a93b8a918d7cc6e02

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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
using Yw.DAL.PostgreSql;
 
namespace HStation.DAL.PostgreSql
{
    /// <summary>
    /// 泵曲线映射
    /// </summary>
    public partial class XhsPhartGraph : BaseDAL_Paras_Flags_Sorter<Entity.XhsPhartGraph>, IXhsPhartGraph
    {
        /// <summary>
        /// 
        /// </summary>
        public override ConnectionConfig ConnectionConfig
        {
            get { return Xhs.ConfigHelper.PostgreSqlConnectionConfig; }
        }
 
        /// <summary>
        /// 通过 DiagramID 获取
        /// </summary>
        public List<Entity.XhsPhartGraph> GetByDiagramID(long DiagramID)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.XhsPhartGraph>()
                    .Where(x => x.DiagramID == DiagramID)
                    .OrderBy(x => x.SortCode).ToList();
            }
        }
 
        /// <summary>
        /// 通过 DiagramIds 获取
        /// </summary>
        public List<Entity.XhsPhartGraph> GetByDiagramIds(List<long> DiagramIds)
        {
            if (DiagramIds == null || DiagramIds.Count < 1)
            {
                return default;
            }
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.XhsPhartGraph>()
                    .Where(x => DiagramIds.Contains(x.DiagramID))
                    .OrderBy(x => x.SortCode).ToList();
            }
        }
 
        /// <summary>
        /// 更新 GraphParas
        /// </summary>
        public bool UpdateGraphParas(long ID, string GraphParas)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.XhsPhartGraph>()
                    .SetColumns(x => x.GraphParas == GraphParas)
                    .Where(x => x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
 
        /// <summary>
        /// 更新 GraphInfo
        /// </summary>
        public bool UpdateGraphInfo(long ID, string GraphInfo)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.XhsPhartGraph>()
                    .SetColumns(x => x.GraphInfo == GraphInfo)
                    .Where(x => x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
 
        /// <summary>
        /// 更新 GeometryParas 
        /// </summary>
        public bool UpdateGeometryParas(long ID, string GeometryParas)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.XhsPhartGraph>()
                    .SetColumns(x => x.GeometryParas == GeometryParas)
                    .Where(x => x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
 
        /// <summary>
        /// 更新 GeometryInfo 
        /// </summary>
        public bool UpdateGeometryInfo(long ID, string GeometryInfo)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.XhsPhartGraph>()
                    .SetColumns(x => x.GeometryInfo == GeometryInfo)
                    .Where(x => x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
 
        /// <summary>
        /// 更新 DispParas 
        /// </summary>
        public bool UpdateDispParas(long ID, string DispParas)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.XhsPhartGraph>()
                    .SetColumns(x => x.DispParas == DispParas)
                    .Where(x => x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
 
        /// <summary>
        /// 更新 ExtraParas  
        /// </summary>
        public bool UpdateExtraParas(long ID, string ExtraParas)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.XhsPhartGraph>()
                    .SetColumns(x => x.ExtraParas == ExtraParas)
                    .Where(x => x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
 
        /// <summary>
        /// 通过 DiagramID 删除
        /// </summary>
        public bool DeleteByDiagramID(long DiagramID)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<Entity.XhsPhartGraph>()
                    .Where(x => x.DiagramID == DiagramID)
                    .ExecuteCommandHasChange();
            }
        }
 
 
 
 
 
 
 
 
 
 
 
 
    }
}