提交 | 用户 | age
|
1063f3
|
1 |
using DIXPad.DataProtocol; |
J |
2 |
using DIXPadWPF.Helper; |
|
3 |
using DIXWeb.Business.MySQLBiz; |
|
4 |
using DIXWeb.DataRepository; |
|
5 |
using DIXWeb.Entity.MySQLEntity; |
|
6 |
using DIXWeb.Util; |
|
7 |
using System; |
|
8 |
using System.Collections.Generic; |
|
9 |
using System.Data; |
|
10 |
using System.Linq; |
|
11 |
using System.Text; |
|
12 |
using System.Threading.Tasks; |
|
13 |
using System.Windows; |
|
14 |
using System.Windows.Controls; |
|
15 |
using System.Windows.Data; |
|
16 |
using System.Windows.Documents; |
|
17 |
using System.Windows.Input; |
|
18 |
using System.Windows.Media; |
|
19 |
using System.Windows.Media.Imaging; |
|
20 |
using System.Windows.Navigation; |
|
21 |
using System.Windows.Shapes; |
|
22 |
|
|
23 |
namespace DIXPadWPF |
|
24 |
{ |
|
25 |
/// <summary> |
|
26 |
/// DixPadUpLoad.xaml 的交互逻辑 |
|
27 |
/// </summary> |
|
28 |
public partial class DixPadUpLoad : Page |
|
29 |
{ |
|
30 |
MySQLInspectAreaBiz ABIZ = null; |
|
31 |
MySQLInspectObjectTypeBiz BIZ = null; |
|
32 |
MySQLInspectObjectBiz OBIZ = null; |
|
33 |
MySQLInspectBaseBiz BBIZ = null; |
|
34 |
MySQLInspectFrequencyBiz BFZ = null; |
|
35 |
string _ServiceUrl { get; set; } = ""; |
|
36 |
public DixPadUpLoad() |
|
37 |
{ |
|
38 |
InitializeComponent(); |
|
39 |
_ServiceUrl = System.Configuration.ConfigurationManager.AppSettings["ServiceUrl"].ToString(); |
|
40 |
ABIZ = new MySQLInspectAreaBiz(); |
|
41 |
OBIZ = new MySQLInspectObjectBiz(); |
|
42 |
BBIZ = new MySQLInspectBaseBiz(); |
|
43 |
BIZ = new MySQLInspectObjectTypeBiz(); |
|
44 |
BFZ = new MySQLInspectFrequencyBiz(); |
|
45 |
} |
|
46 |
|
|
47 |
private void btnSearch_Click(object sender, RoutedEventArgs e) |
|
48 |
{ |
|
49 |
string inspectobjecttype = cbInspectObjectType.Text; |
|
50 |
string inspectArea = cbInspectArea.Text; |
|
51 |
string inspectFreq = cbInspectFreq.Text; |
|
52 |
DataTable dt = OBIZ.GetAllInspectedItem(inspectobjecttype, inspectArea, inspectFreq); |
|
53 |
UploadDataGrid.ItemsSource = dt.DefaultView; |
|
54 |
cbInspectObjectType.SelectedIndex = -1; |
|
55 |
cbInspectArea.SelectedIndex = -1; |
|
56 |
cbInspectFreq.SelectedIndex = -1; |
|
57 |
} |
|
58 |
public void GetInspectObjectType() |
|
59 |
{ |
|
60 |
cbInspectObjectType.Items.Clear(); |
|
61 |
cbInspectObjectType.Items.Add("全选"); |
|
62 |
List<MySQLInspectObjectType> list = BIZ.GetDataList("", "", new Pagination()); |
|
63 |
if (list.Count > 0) |
|
64 |
{ |
|
65 |
for (int i = 0; i < list.Count; i++) |
|
66 |
{ |
|
67 |
string typename = list[i].Name; |
|
68 |
cbInspectObjectType.Items.Add(typename); |
|
69 |
} |
|
70 |
} |
|
71 |
} |
|
72 |
public void GetInspectArea() |
|
73 |
{ |
|
74 |
cbInspectArea.Items.Clear(); |
|
75 |
cbInspectArea.Items.Add("全选"); |
|
76 |
List<MySQLInspectArea> list = ABIZ.GetDataList(0, new Pagination()); |
|
77 |
if (list.Count > 0) |
|
78 |
{ |
|
79 |
for (int i = 0; i < list.Count; i++) |
|
80 |
{ |
|
81 |
string typename = list[i].Name; |
|
82 |
cbInspectArea.Items.Add(typename); |
|
83 |
} |
|
84 |
} |
|
85 |
} |
|
86 |
public void GetInspectFreq() |
|
87 |
{ |
|
88 |
cbInspectFreq.Items.Clear(); |
|
89 |
cbInspectFreq.Items.Add("全选"); |
|
90 |
List<MySQLInspectFrequency> list = BFZ.GetDataList(0, new Pagination()); |
|
91 |
if (list.Count > 0) |
|
92 |
{ |
|
93 |
for (int i = 0; i < list.Count; i++) |
|
94 |
{ |
|
95 |
string typename = list[i].Frequency; |
|
96 |
cbInspectFreq.Items.Add(typename); |
|
97 |
} |
|
98 |
} |
|
99 |
} |
|
100 |
private void btnUpLoad_Click(object sender, RoutedEventArgs e) |
|
101 |
{ |
b347b1
|
102 |
try |
1063f3
|
103 |
{ |
b347b1
|
104 |
ResultMessage r = NetWorkCheck.NetWorkCheckResult(); |
J |
105 |
if (r.Count < 0) |
a70742
|
106 |
{ |
b347b1
|
107 |
MessageBox.Show(r.Msg, "Warning!", MessageBoxButton.OK, MessageBoxImage.Warning); |
J |
108 |
} |
|
109 |
else |
|
110 |
{ |
|
111 |
DataTable dtinfo = BBIZ.GetInspectedItems(); |
|
112 |
if (dtinfo.Rows.Count > 0) |
a70742
|
113 |
{ |
b347b1
|
114 |
string sn = Guid.NewGuid().ToString(); |
J |
115 |
DIXPad.RSLC.BizServiceProxy localProxy = new DIXPad.RSLC.BizServiceProxy(_ServiceUrl); |
|
116 |
DataTable table = new DataTable(Guid.NewGuid().ToString()); |
|
117 |
table.Columns.Add("sn", typeof(string)); |
|
118 |
table.Columns.Add("InspectObjectId", typeof(int)); |
|
119 |
table.Columns.Add("InspectItemId", typeof(int)); |
|
120 |
table.Columns.Add("CheckType", typeof(string)); |
|
121 |
table.Columns.Add("InspectLimit", typeof(double)); |
|
122 |
table.Columns.Add("NGReason", typeof(string)); |
|
123 |
table.Columns.Add("TotalJudge", typeof(bool)); |
|
124 |
table.Columns.Add("InspectTimes", typeof(int)); |
|
125 |
table.Columns.Add("CreateTime", typeof(DateTime)); |
|
126 |
table.Columns.Add("InspectOperator", typeof(string)); |
|
127 |
table.Columns.Add("IsImprovedOnSite", typeof(bool)); |
|
128 |
table.Columns.Add("DealDetial", typeof(string)); |
|
129 |
table.Columns.Add("ReInspectTimes", typeof(int)); |
|
130 |
table.Columns.Add("ImgString", typeof(string)); |
|
131 |
table.Columns.Add("IsBackup", typeof(int)); |
|
132 |
for (int i = 0; i < dtinfo.Rows.Count; i++) |
a70742
|
133 |
{ |
b347b1
|
134 |
DataRow dr = table.NewRow(); |
J |
135 |
dr["sn"] = sn; |
|
136 |
dr["InspectObjectId"] = Convert.ToInt32(dtinfo.Rows[i]["InspectObjectId"].ToString()); |
|
137 |
dr["InspectItemId"] = Convert.ToInt32(dtinfo.Rows[i]["InspectItemId"].ToString()); |
|
138 |
dr["CheckType"] = dtinfo.Rows[i]["CheckType"].ToString(); |
|
139 |
dr["InspectLimit"] = double.Parse(dtinfo.Rows[i]["InspectLimit"].ToString()); |
|
140 |
dr["NGReason"] = dtinfo.Rows[i]["NGReason"].ToString(); |
|
141 |
string judge = dtinfo.Rows[i]["TotalJudge"].ToString(); |
|
142 |
if (judge == "True") |
|
143 |
{ |
|
144 |
dr["TotalJudge"] = true; |
|
145 |
} |
|
146 |
else |
|
147 |
{ |
|
148 |
dr["TotalJudge"] = false; |
|
149 |
} |
|
150 |
dr["InspectTimes"] = Convert.ToInt32(dtinfo.Rows[i]["InspectTimes"].ToString()); |
|
151 |
dr["CreateTime"] = Convert.ToDateTime(dtinfo.Rows[i]["CreateTime"].ToString()); |
|
152 |
dr["InspectOperator"] = dtinfo.Rows[i]["InspectOperator"]; |
|
153 |
string improved = dtinfo.Rows[i]["IsImprovedOnSite"].ToString(); |
|
154 |
if (improved == "1") |
|
155 |
{ |
|
156 |
dr["IsImprovedOnSite"] = true; |
|
157 |
} |
|
158 |
else |
|
159 |
{ |
|
160 |
dr["IsImprovedOnSite"] = false; |
|
161 |
} |
|
162 |
dr["DealDetial"] = dtinfo.Rows[i]["DealDetial"]; |
|
163 |
dr["ReInspectTimes"] = Convert.ToInt32(dtinfo.Rows[i]["ReInspectTimes"]); |
|
164 |
if (dtinfo.Rows[i]["ImgString"].ToString() == "") |
|
165 |
{ |
|
166 |
dr["ImgString"] = ""; |
|
167 |
} |
|
168 |
else |
|
169 |
{ |
|
170 |
dr["ImgString"] = dtinfo.Rows[i]["ImgString"].ToString(); |
|
171 |
} |
|
172 |
dr["IsBackup"] = Convert.ToInt32(dtinfo.Rows[i]["isbackup"].ToString()); |
|
173 |
table.Rows.Add(dr); |
a70742
|
174 |
} |
J |
175 |
|
b347b1
|
176 |
Dictionary<string, string> dir = new Dictionary<string, string>(); |
J |
177 |
dir.Add("sn", "sn"); |
|
178 |
dir.Add("InspectObjectId", "InspectObjectId"); |
|
179 |
dir.Add("InspectItemId", "InspectItemId"); |
|
180 |
dir.Add("CheckType", "CheckType"); |
|
181 |
dir.Add("InspectLimit", "InspectLimit"); |
|
182 |
dir.Add("NGReason", "NGReason"); |
|
183 |
dir.Add("TotalJudge", "TotalJudge"); |
|
184 |
dir.Add("InspectTimes", "InspectTimes"); |
|
185 |
dir.Add("CreateTime", "CreateTime"); |
|
186 |
dir.Add("InspectOperator", "InspectOperator"); |
|
187 |
dir.Add("IsImprovedOnSite", "IsImprovedOnSite"); |
|
188 |
dir.Add("DealDetial", "DealDetial"); |
|
189 |
dir.Add("ReInspectTimes", "ReInspectTimes"); |
|
190 |
dir.Add("ImgString", "ImgString"); |
|
191 |
dir.Add("IsBackup", "IsBackup"); |
|
192 |
Dictionary<string, object> pdir = new Dictionary<string, object>(); |
|
193 |
pdir.Add("@sn", sn); |
a70742
|
194 |
|
b347b1
|
195 |
string imgsn = Guid.NewGuid().ToString(); |
J |
196 |
DataTable dtimg = BBIZ.GetImageItems(); |
|
197 |
DataTable imgtable = new DataTable(Guid.NewGuid().ToString()); |
|
198 |
imgtable.Columns.Add("TableSN", typeof(string)); |
|
199 |
imgtable.Columns.Add("SN", typeof(string)); |
|
200 |
imgtable.Columns.Add("ImgId", typeof(int)); |
|
201 |
imgtable.Columns.Add("ImgString", typeof(string)); |
|
202 |
for (int i = 0; i < dtimg.Rows.Count; i++) |
a70742
|
203 |
{ |
b347b1
|
204 |
DataRow dr = imgtable.NewRow(); |
J |
205 |
dr["TableSN"] = imgsn; |
|
206 |
dr["SN"] = dtimg.Rows[i]["SN"].ToString(); |
|
207 |
dr["ImgId"] = Convert.ToInt32(dtimg.Rows[i]["ImgId"].ToString()); |
|
208 |
dr["ImgString"] = dtimg.Rows[i]["ImgString"].ToString(); |
|
209 |
imgtable.Rows.Add(dr); |
|
210 |
} |
|
211 |
Dictionary<string, string> imgdir = new Dictionary<string, string>(); |
|
212 |
imgdir.Add("TableSN", "TableSN"); |
|
213 |
imgdir.Add("SN", "SN"); |
|
214 |
imgdir.Add("ImgId", "ImgId"); |
|
215 |
imgdir.Add("ImgString", "ImgString"); |
|
216 |
Dictionary<string, object> idir = new Dictionary<string, object>(); |
|
217 |
idir.Add("@sn", imgsn); |
|
218 |
|
|
219 |
MsgObject msg = localProxy.WSBulkCopyDataToDBWithHook(table, "InspectItemInfoDetial", dir, pdir, "yp_InspectItemInfo_bk2", DIXPad.RSLC.DBKeys.DIX); |
|
220 |
if (msg.Count > 0) |
|
221 |
{ |
|
222 |
MsgObject msg1 = localProxy.WSBulkCopyDataToDBWithHook(imgtable, "ItemImgDetial", imgdir, idir, "yp_GetImageList", DIXPad.RSLC.DBKeys.DIX); |
|
223 |
if (msg1.Count > 0) |
|
224 |
{ |
|
225 |
BBIZ.UpdateInspectedItems(); |
|
226 |
MessageBox.Show("点检数据上传至服务端成功!", "上传成功", MessageBoxButton.OK, MessageBoxImage.Information); |
|
227 |
DataTable dt = OBIZ.GetAllInspectedItem("", "", ""); |
|
228 |
UploadDataGrid.ItemsSource = dt.DefaultView; |
|
229 |
} |
|
230 |
else |
|
231 |
{ |
|
232 |
MessageBox.Show("点检数据上传至服务端失败!" + msg1.Msg, "上传失败", MessageBoxButton.OK, MessageBoxImage.Error); |
|
233 |
} |
a70742
|
234 |
} |
J |
235 |
else |
|
236 |
{ |
b347b1
|
237 |
MessageBox.Show("点检数据上传至服务端失败!" + msg.Msg, "上传失败", MessageBoxButton.OK, MessageBoxImage.Error); |
a70742
|
238 |
} |
J |
239 |
} |
|
240 |
else |
|
241 |
{ |
b347b1
|
242 |
MessageBox.Show("当前无可上传的点检数据!请点检其他设备后再进行上传!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); |
a70742
|
243 |
} |
J |
244 |
} |
|
245 |
} |
b347b1
|
246 |
catch (Exception er) |
J |
247 |
{ |
|
248 |
MessageBox.Show(er.Message, "Warning!", MessageBoxButton.OK, MessageBoxImage.Warning); |
|
249 |
} |
|
250 |
} |
a70742
|
251 |
|
J |
252 |
private void Page_Loaded(object sender, RoutedEventArgs e) |
|
253 |
{ |
|
254 |
try |
|
255 |
{ |
1063f3
|
256 |
DataTable dt = OBIZ.GetAllInspectedItem("", "", ""); |
J |
257 |
UploadDataGrid.ItemsSource = dt.DefaultView; |
a70742
|
258 |
} |
J |
259 |
catch (Exception ex) |
|
260 |
{ |
|
261 |
MessageBox.Show(ex.Message); |
1063f3
|
262 |
} |
J |
263 |
} |
|
264 |
|
|
265 |
private void btnChange_Click(object sender, RoutedEventArgs e) |
|
266 |
{ |
|
267 |
var a = UploadDataGrid.CurrentItem as DataRowView; |
|
268 |
if (a != null) |
|
269 |
{ |
|
270 |
MySQLInspectTypeBiz TBIZ = new MySQLInspectTypeBiz(); |
a70742
|
271 |
string inspecttypes = a.Row[3].ToString(); |
8a90d9
|
272 |
string loadstatus= a.Row[0].ToString(); |
a70742
|
273 |
string code = a.Row[5].ToString(); |
J |
274 |
int times = Convert.ToInt32(a.Row[11].ToString()); |
1063f3
|
275 |
List<MySQLInspectObject> list = OBIZ.GetDataList("InspectObjectCode", code, new Pagination()); |
J |
276 |
if (list.Count > 0) |
|
277 |
{ |
d95063
|
278 |
for (int i = 0; i < list.Count; i++) |
J |
279 |
{ |
|
280 |
int inspecttypeid = list[i].InspectTypeId; |
|
281 |
List<MySQLInspectType> tlist = TBIZ.GetDataList(inspecttypeid, new Pagination()); |
|
282 |
string inspecttypestr = tlist[0].Name; |
|
283 |
if (inspecttypestr == inspecttypes) |
|
284 |
{ |
edc224
|
285 |
DIXPadInspectItemPage dpi = new DIXPadInspectItemPage(); |
J |
286 |
dpi.mpcObject = list[i]; |
d95063
|
287 |
dpi.InspectTimes = times; |
J |
288 |
dpi.Code = "Update"; |
|
289 |
dpi.loadstatus = loadstatus; |
a70742
|
290 |
dpi.createtime = Convert.ToDateTime(a.Row[12].ToString()); |
edc224
|
291 |
this.NavigationService.Navigate(dpi); |
d95063
|
292 |
} |
J |
293 |
} |
1063f3
|
294 |
} |
J |
295 |
} |
|
296 |
} |
|
297 |
|
|
298 |
private void cbInspectObjectType_DropDownOpened(object sender, EventArgs e) |
|
299 |
{ |
|
300 |
GetInspectObjectType(); |
|
301 |
} |
|
302 |
|
|
303 |
private void cbInspectArea_DropDownOpened(object sender, EventArgs e) |
|
304 |
{ |
|
305 |
GetInspectArea(); |
|
306 |
} |
|
307 |
|
|
308 |
private void cbInspectFreq_DropDownOpened(object sender, EventArgs e) |
|
309 |
{ |
|
310 |
GetInspectFreq(); |
|
311 |
} |
|
312 |
} |
|
313 |
} |