Make_ParseLog.cs 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938
  1. using DevExpress.Utils.CodedUISupport;
  2. using DevExpress.Xpo.Logger;
  3. using HslCommunication;
  4. using NPOI.POIFS.NIO;
  5. using NPOI.SS.Formula.Functions;
  6. using System;
  7. using System.Collections.Generic;
  8. using System.ComponentModel;
  9. using System.Data;
  10. using System.Drawing;
  11. using System.IO;
  12. using System.Linq;
  13. using System.Net;
  14. using System.Security.AccessControl;
  15. using System.Security.Principal;
  16. using System.Text;
  17. using System.Web.Services.Description;
  18. using System.Web.UI.WebControls;
  19. using System.Windows.Forms;
  20. using UAS_MES_NEW.CustomControl.ButtonUtil;
  21. using UAS_MES_NEW.DataOperate;
  22. using UAS_MES_NEW.Entity;
  23. using UAS_MES_NEW.PublicMethod;
  24. namespace UAS_MES_NEW.Make
  25. {
  26. public partial class Make_ParseLog : Form
  27. {
  28. public Make_ParseLog()
  29. {
  30. InitializeComponent();
  31. }
  32. FileSystemWatcher watcher;
  33. LogStringBuilder sql = new LogStringBuilder();
  34. DataTable Dbfind;
  35. DataTable dt;
  36. DataHelper dh;
  37. string currFileType = "", equiType = "";
  38. string SN, omakeCode, oMsid, oErrorMessage = "";
  39. List<string> fileList = new List<string>();
  40. Timer ChangeWoTimer;
  41. string outFileMsg;
  42. private void Make_ParseLog_Load(object sender, EventArgs e)
  43. {
  44. dh = SystemInf.dh;
  45. Choose.Enabled = false;
  46. fileList.Add("E:\\AOIMes\\Mes");
  47. fileList.Add("C:\\Users\\MI\\Desktop");
  48. fileList.Add("C:\\Users\\MI\\Desktop");
  49. ChangeWoTimer = new Timer();
  50. ChangeWoTimer.Interval = 30000;
  51. ChangeWoTimer.Tick += ChangeWoFunc;
  52. watcher = new FileSystemWatcher();
  53. watcher.NotifyFilter = NotifyFilters.FileName | NotifyFilters.LastWrite;
  54. watcher.Created += OnFileCreated;
  55. watcher.Changed += OnFileChanged;
  56. /*watcher.Deleted += OnFileChanged;
  57. watcher.Renamed += OnFileChanged;*/
  58. //设置锁定工单
  59. LockMakeCode.GetMakeCodeCtl(ma_code);
  60. ma_code.SetLockCheckBox(LockMakeCode);
  61. //工单号放大镜配置
  62. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  63. ma_code.SelectField = "ma_code # 工单号,pr_code # 产品编号,pr_detail # 产品名称";
  64. ma_code.FormName = Name;
  65. ma_code.SetValueField = new string[] { "ma_code", "pr_code", "pr_detail" };
  66. ma_code.Condition = "ma_statuscode='STARTED'";
  67. ma_code.DbChange += Ma_code_DbChange;
  68. }
  69. private void Ma_code_DbChange(object sender, EventArgs e)
  70. {
  71. Dbfind = ma_code.ReturnData;
  72. BaseUtil.SetFormValue(this.Controls, Dbfind);
  73. //获取工单的其他信息
  74. sql.Clear();
  75. sql.Append("select ma_code,nvl(mcd_okqty,0) mcd_okqty,ma_prodcode as pr_code ,pr_detail,");
  76. sql.Append("pr_spec,ma_qty - nvl(mcd_inqty, 0) mcd_remainqty from make left join makecraftdetail on ");
  77. sql.Append("mcd_maid=ma_id left join product on pr_code=ma_prodcode where ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  78. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  79. if (dt.Rows.Count > 0)
  80. {
  81. BaseUtil.SetFormValue(this.Controls, dt);
  82. }
  83. }
  84. private void Device_SelectedIndexChanged(object sender, EventArgs e)
  85. {
  86. if (Device.SelectedIndex == -1) return;
  87. if(ChangeWoTimer.Enabled) ChangeWoTimer.Stop();
  88. onWatch.Enabled = true;
  89. FileBox.Visible = false;
  90. switch (Device.SelectedIndex)
  91. {
  92. case 0:
  93. currFileType = "Txt";
  94. equiType = "AOI";
  95. /*ChangeWoTimer.Start();
  96. ChangeWoFunc(null, null);*/
  97. break;
  98. case 1:
  99. currFileType = "bmp";
  100. equiType = "Xray";
  101. onWatch.Enabled = false;
  102. FileBox.Visible = true;
  103. break;
  104. case 2:
  105. currFileType = "jpg";
  106. equiType = "CCD";
  107. break;
  108. }
  109. txtPath.Text = fileList[Device.SelectedIndex];
  110. txtPath.Focus();
  111. txtPath.SelectAll();
  112. ma_code.Enabled = true;
  113. Choose.Enabled = true;
  114. txtPath.Enabled = false;
  115. }
  116. private void Choose_Click(object sender, EventArgs e)
  117. {
  118. using (var dialog = new FolderBrowserDialog())
  119. {
  120. if (dialog.ShowDialog() == DialogResult.OK)
  121. {
  122. txtPath.Text = dialog.SelectedPath;
  123. txtPath.Enabled = false;
  124. Device.Enabled = false;
  125. watcher.EnableRaisingEvents = false;
  126. }
  127. }
  128. }
  129. private void claerBtn_Click(object sender, EventArgs e)
  130. {
  131. lstFiles.Items.Clear();
  132. }
  133. private void allParse_Click(object sender, EventArgs e)
  134. {
  135. if (Device.SelectedIndex == -1)
  136. {
  137. Device.Focus();
  138. Device.SelectAll();
  139. MessageBox.Show(this.ParentForm, "请选择设备", "提示");
  140. return;
  141. }
  142. if (String.IsNullOrEmpty(txtPath.Text))
  143. {
  144. txtPath.Focus();
  145. txtPath.SelectAll();
  146. MessageBox.Show(this.ParentForm, "请选择解析路径", "提示");
  147. return;
  148. }
  149. string[] txtFiles;
  150. if (equiType == "Xray")
  151. {
  152. txtFiles = Directory.GetDirectories(txtPath.Text);
  153. if (txtFiles.Length == 0)
  154. {
  155. LogMessage(0, $"当前路径{txtPath.Text},没有{equiType}设备输出的文件夹");
  156. return;
  157. }
  158. }
  159. else
  160. {
  161. txtFiles = Directory.GetFiles(txtPath.Text, $"*.{currFileType}");
  162. if (txtFiles.Length == 0)
  163. {
  164. LogMessage(0, $"当前{txtPath.Text},没有{equiType}设备输出的{currFileType.ToLower()}文件");
  165. return;
  166. }
  167. }
  168. RefreshFileList();
  169. }
  170. private void onWatch_Click(object sender, EventArgs e)
  171. {
  172. if (Device.SelectedIndex == -1)
  173. {
  174. Device.Focus();
  175. Device.SelectAll();
  176. MessageBox.Show(this.ParentForm, "请选择设备", "提示");
  177. return;
  178. }
  179. if (String.IsNullOrEmpty(txtPath.Text))
  180. {
  181. txtPath.Focus();
  182. txtPath.SelectAll();
  183. MessageBox.Show(this.ParentForm, "请选择解析路径", "提示");
  184. return;
  185. }
  186. try
  187. {
  188. watcher.Path = txtPath.Text;
  189. watcher.Filter = $"*.{currFileType}";
  190. if (onWatch.Text == "开启解析")
  191. {
  192. watcher.EnableRaisingEvents = true;
  193. onWatch.Text = "关闭解析";
  194. }
  195. else
  196. {
  197. watcher.EnableRaisingEvents = false;
  198. onWatch.Text = "开启解析";
  199. }
  200. }
  201. catch (Exception ex)
  202. {
  203. MessageBox.Show(this.ParentForm, ex.Message, "警告");
  204. }
  205. }
  206. private void OnFileCreated(object sender, FileSystemEventArgs e)
  207. {
  208. RefreshFileList();
  209. }
  210. private void OnFileChanged(object sender, FileSystemEventArgs e)
  211. {
  212. if (e.ChangeType == WatcherChangeTypes.Changed)
  213. {
  214. RefreshFileList();
  215. }
  216. }
  217. private void RefreshFileList()
  218. {
  219. if (lstFiles.InvokeRequired)
  220. {
  221. lstFiles.Invoke(new Action(RefreshFileList));
  222. lstFiles.BeginInvoke(new Action(RefreshFileList));
  223. return;
  224. }
  225. try
  226. {
  227. if (!Directory.Exists(txtPath.Text))
  228. {
  229. LogMessage(0, $"目录不存在: {txtPath.Text}");
  230. return;
  231. }
  232. string[] txtFiles;
  233. if (equiType == "Xray")
  234. {
  235. txtFiles = Directory.GetDirectories(txtPath.Text);
  236. }
  237. else
  238. {
  239. txtFiles = Directory.GetFiles(txtPath.Text, $"*.{currFileType}");
  240. }
  241. if (txtFiles.Length == 0)
  242. {
  243. return;
  244. }
  245. foreach (string file in txtFiles)
  246. {
  247. if (equiType == "Xray")
  248. {
  249. if (Path.GetFileName(file).Contains("Log_"))
  250. {
  251. continue;
  252. }
  253. if (!Directory.Exists(file))
  254. {
  255. LogMessage(0, $"文件夹不存在: {file}");
  256. }
  257. outFileMsg = CheckFolderPermissions(file);
  258. if (outFileMsg != "OK")
  259. {
  260. if(!outFileMsg.Contains("文件被占用"))
  261. {
  262. LogMessage(0, outFileMsg);
  263. }
  264. continue;
  265. }
  266. }
  267. else
  268. {
  269. if (!File.Exists(file))
  270. {
  271. LogMessage(0, $"文件不存在: {file}");
  272. }
  273. outFileMsg = CheckFileAccess(file);
  274. if (outFileMsg != "OK")
  275. {
  276. LogMessage(0, outFileMsg);
  277. continue;
  278. }
  279. if (File.ReadAllText(file).Length == 0)
  280. {
  281. continue;
  282. }
  283. }
  284. if (equiType == "AOI")
  285. {
  286. using (StreamReader SR = new StreamReader(file, Encoding.GetEncoding("GBK")))
  287. {
  288. string Content = SR.ReadToEnd();
  289. SR.Close();
  290. SR.Dispose();
  291. List<Log> logArr = new List<Log>() { };
  292. string[] lines = Content.Split(new string[] { "\r\n" }, StringSplitOptions.None);
  293. int fileNum = string.IsNullOrEmpty(lines[lines.Length - 1]) ? lines.Length - 1 : lines.Length;
  294. Log itemLog = new Log() { };
  295. foreach (var item in lines)
  296. {
  297. if (string.IsNullOrEmpty(item)) continue;
  298. if (Array.IndexOf(lines, item) == 1) itemLog.SN = item.Split(':')[1].ToString().Trim().Replace(";", ";");
  299. if (Array.IndexOf(lines, item) == 2) itemLog.TestTime = item.Split(':')[1].Split('.')[0].ToString().Trim();
  300. if (Array.IndexOf(lines, item) == 3) itemLog.Result = item.Split(':')[1].ToString().Trim();
  301. if (Array.IndexOf(lines, item) == 4) itemLog.Side = item.Split(':')[1].ToString().Trim();
  302. if (item.IndexOf("元件位置") > -1)
  303. {
  304. LogItem list = new LogItem();
  305. int ind = Array.IndexOf(lines, item);
  306. list.Location = lines[ind].Split(':')[1].ToString().Trim();
  307. list.ReelNo = lines[ind + 1].Split(':')[1].ToString().Trim();
  308. list.FirstType = lines[ind + 2].Split(':')[1].ToString().Trim();
  309. list.SceondType = lines[ind + 3].Split(':')[1].ToString().Trim();
  310. list.Name = lines[ind + 4].Split(':')[1].ToString().Trim();
  311. itemLog.LogItemList.Add(list);
  312. }
  313. }
  314. logArr.Add(itemLog);
  315. if (logArr.Count == 0)
  316. {
  317. break;
  318. }
  319. if (InsertDb(logArr, file, fileNum))
  320. {
  321. if (ConsoleLog(Content, file, logArr[0].SN))
  322. {
  323. File.WriteAllText(file, string.Empty);
  324. File.Delete(file);
  325. }
  326. }
  327. }
  328. }
  329. else if (equiType == "Xray")
  330. {
  331. string[] floderFile = Directory.GetFiles(file, $"*.{currFileType}");
  332. foreach(string floderFileItem in floderFile)
  333. {
  334. SN = Path.GetFileName(floderFileItem).Split('_')[1];
  335. if (UploadImageToFtp(floderFileItem, SN))
  336. {
  337. if (!LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, SN, User.UserCode, out omakeCode, out oMsid, out oErrorMessage))
  338. {
  339. LogMessage(0, $"核对NG:{oErrorMessage}");
  340. }
  341. dh.ExecuteSql($@"INSERT INTO steptestmain (sm_id, sm_sn,sm_makecode,sm_stepcode,sm_indate,sm_machinecode,sm_result)
  342. VALUES ( steptestmain_seq.NEXTVAL,'{SN}','{omakeCode}','{User.UserSourceCode}', sysdate,'Xray', 'http://192.168.1.5:8099/ftp/xray/{DateTime.Now.ToString("yyyyMMdd")}/{Path.GetFileName(floderFileItem)}' )", "insert");
  343. if (Array.IndexOf(floderFile, floderFileItem) == floderFile.Length - 1)
  344. {
  345. string newFloderName = Path.GetDirectoryName(file);
  346. Directory.Move(file, Path.Combine(newFloderName, "Log_" + Path.GetFileName(file)));
  347. }
  348. }
  349. }
  350. }
  351. else if(equiType == "CCD")
  352. {
  353. if (txtFiles.Length != 2) break;
  354. foreach (var fileItem in txtFiles)
  355. {
  356. string imageName = Path.GetFileName(fileItem);
  357. SN = imageName.Split('_')[0].ToString();
  358. if (imageName.ToUpper().Contains("NG"))
  359. {
  360. if (UploadImageToFtp(fileItem, SN))
  361. {
  362. dh.ExecuteSql($@"INSERT INTO steptestmain (sm_id, sm_sn,sm_makecode,sm_stepcode,sm_indate,sm_machinecode,sm_result)
  363. VALUES ( steptestmain_seq.NEXTVAL,'{SN}','{ma_code.Text}','{User.UserSourceCode}', sysdate,'CCD', 'http://192.168.1.5:8088/ftp/ccd/{SN}/{Path.GetFileName(fileItem)}' )", "insert");
  364. }
  365. }
  366. string parentPath = Path.GetDirectoryName(file);
  367. string changeName = Path.Combine(parentPath, SN);
  368. if (!Directory.Exists(changeName))
  369. {
  370. Directory.CreateDirectory(changeName);
  371. }
  372. File.Move(file, changeName);
  373. }
  374. }
  375. }
  376. }
  377. catch (Exception ex)
  378. {
  379. LogMessage(0, $"Error: 解析文件列表失败: {ex.Message}");
  380. }
  381. }
  382. private bool InsertDb(List<Log> logs, string PathName, int fileNum)
  383. {
  384. try
  385. {
  386. StringBuilder sql = new StringBuilder();
  387. StringBuilder details = new StringBuilder();
  388. List<string> param = new List<string>() { };
  389. foreach (var item in logs)
  390. {
  391. dt = (DataTable)dh.ExecuteSql($"SELECT mp_id FROM makeprocess WHERE mp_sncode = '{item.SN}' AND mp_sourcecode = 'AOI'", "select");
  392. if (dt.Rows.Count > 0)
  393. {
  394. LogMessage(1, $"序列号:{item.SN}已经过站并记录测试信息");
  395. continue;
  396. }
  397. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, item.SN, User.UserCode, out omakeCode, out oMsid, out oErrorMessage))
  398. {
  399. if (LogicHandler.SetStepResult(omakeCode, User.UserSourceCode, item.SN, "日志解析", item.Result.ToUpper() == "PASS" ? "OK" :"NG", User.UserCode, out oErrorMessage))
  400. {
  401. string outMsg = "";
  402. param.Add(omakeCode);
  403. param.Add(item.SN);
  404. param.Add(User.UserSourceCode);
  405. param.Add(User.UserName);
  406. param.Add(User.CurrentStepCode);
  407. param.Add(item.Result.ToUpper());
  408. param.Add(item.TestTime);
  409. param.Add(item.Side);
  410. param.Add(equiType);
  411. details.Clear();
  412. foreach (LogItem LI in item.LogItemList)
  413. {
  414. details.Append($"{LI.Location}/{LI.ReelNo}/{LI.FirstType}/{LI.SceondType}/{LI.Name};");
  415. }
  416. param.Add(details.ToString());
  417. param.Add(outMsg);
  418. string[] paramList = param.ToArray();
  419. dh.CallProcedure("CS_INSERT_TESTDETAILS", ref paramList);
  420. if (paramList[8].Substring(0, 2) == "OK")
  421. {
  422. LogMessage(1, $"文件: {item.SN} 采集成功, 测试结果为{item.Result},共{item.LogItemList.Count}条信息");
  423. }
  424. else
  425. {
  426. LogMessage(1, paramList[8]);
  427. }
  428. param.Clear();
  429. if (logs.IndexOf(item) == logs.Count - 1)
  430. {
  431. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, omakeCode, User.UserLineCode, User.UserSourceCode, "日志解析", "日志解析过站成功", item.SN, "");
  432. return true;
  433. }
  434. }
  435. else
  436. {
  437. LogMessage(0, $"处理过站NG:{oErrorMessage}");
  438. break;
  439. }
  440. }
  441. else
  442. {
  443. LogMessage(0, $"过站核对NG:{oErrorMessage}");
  444. break;
  445. }
  446. }
  447. return false;
  448. }
  449. catch (Exception ex)
  450. {
  451. LogMessage(0, $"Error,处理解析写入: {ex.Message}");
  452. return false;
  453. }
  454. }
  455. private void ChangeWoFunc(object sender, EventArgs e)
  456. {
  457. try
  458. {
  459. sql.Clear();
  460. sql.Append($"SELECT dl_macode FROM deviceline WHERE dl_linecode = '{User.UserLineCode}'");
  461. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  462. if (dt.Rows.Count > 0 && !String.IsNullOrEmpty(dt.Rows[0]["dl_macode"].ToString()))
  463. {
  464. ma_code.Text = dt.Rows[0]["dl_macode"].ToString().Trim();
  465. return;
  466. }
  467. LogMessage(0, $"NG,自动识别更新工单");
  468. }
  469. catch (Exception ex)
  470. {
  471. LogMessage(0, $"Error,自动切换工单: {ex.Message}");
  472. }
  473. }
  474. private bool ConsoleLog(string Content, string PathName,string SN)
  475. {
  476. try
  477. {
  478. string sourcePaht = Path.GetDirectoryName(PathName);
  479. string changeName = Path.Combine(sourcePaht, $"{SN}.{currFileType}");
  480. string newFolderName = "Logs";
  481. string newFolderPath = Path.Combine(sourcePaht, newFolderName);
  482. if (!Directory.Exists(newFolderPath))
  483. {
  484. Directory.CreateDirectory(newFolderPath);
  485. }
  486. string newFileName = "Log_" + Path.GetFileName(changeName);
  487. string newFilePath = Path.Combine(newFolderPath, newFileName);
  488. File.AppendAllText(newFilePath, Content + Environment.NewLine);
  489. return true;
  490. }
  491. catch (Exception ex)
  492. {
  493. MessageBox.Show(this.ParentForm, ex.Message, "警告");
  494. return false;
  495. }
  496. }
  497. private void LogMessage(int type, string message)
  498. {
  499. if (type == 0)
  500. {
  501. if (lstFiles.InvokeRequired)
  502. {
  503. lstFiles.Invoke(new Action<int, string>(LogMessage), new object[] { type, message });
  504. return;
  505. }
  506. lstFiles.Items.Add($"[{DateTime.Now:yyyy-MM-dd HH:mm:ss}] {message}");
  507. lstFiles.TopIndex = lstFiles.Items.Count - 1;
  508. }
  509. else
  510. {
  511. if (lstOk.InvokeRequired)
  512. {
  513. lstOk.Invoke(new Action<int, string>(LogMessage), new object[] { type, message });
  514. return;
  515. }
  516. lstOk.Items.Add($"[{DateTime.Now:yyyy-MM-dd HH:mm:ss}] {message}");
  517. lstOk.TopIndex = lstOk.Items.Count - 1;
  518. }
  519. }
  520. private void lstFiles_DrawItem(object sender, DrawItemEventArgs e)
  521. {
  522. if (e.Index < 0) return;
  523. e.DrawBackground();
  524. string txt = lstFiles.Items[e.Index].ToString().ToUpper();
  525. Brush color = Brushes.Black;
  526. if (txt.Contains("NG"))
  527. {
  528. color = Brushes.Red;
  529. }
  530. else if (txt.Contains("ERROR"))
  531. {
  532. color = Brushes.Red;
  533. }
  534. else
  535. {
  536. color = Brushes.Green;
  537. }
  538. e.DrawFocusRectangle();
  539. e.Graphics.DrawString(lstFiles.Items[e.Index].ToString(), e.Font, color, e.Bounds, StringFormat.GenericDefault);
  540. }
  541. public bool UploadImageToFtp(string localFilePath, string Sn)
  542. {
  543. string ftpServer;
  544. ftpServer = equiType == "Xray" ? "ftp://10.8.0.215:21/xray/" : "ftp://10.8.0.215:21/ccd/";
  545. ftpServer = equiType == "Xray" ? "ftp://192.168.1.5:21/xray/" : "ftp://192.168.1.5:21/ccd/";
  546. string username = "vsftpd";
  547. string password = "vsftpd3ef41637hy";
  548. string currentDate = DateTime.Now.ToString("yyyyMMdd");
  549. string ftpFullPath = $"{ftpServer.TrimEnd('/')}/{currentDate}";
  550. /*string ftpFullPath = $"{ftpServer.TrimEnd('/')}/{Sn}";*/
  551. string outResult = CreateFtpDirectoryIfNotExists(ftpFullPath, username, password);
  552. if (outResult.Substring(0, 2) == "NG")
  553. {
  554. LogMessage(0, outResult);
  555. return false;
  556. }
  557. string remoteFileName = Path.GetFileName(localFilePath);
  558. string uri = $"{ftpFullPath}/{remoteFileName}";
  559. try
  560. {
  561. var request = (FtpWebRequest)WebRequest.Create(uri);
  562. request.Method = WebRequestMethods.Ftp.UploadFile;
  563. request.Credentials = new NetworkCredential(username, password);
  564. request.UsePassive = true;
  565. request.UseBinary = true;
  566. request.KeepAlive = false;
  567. using (var fileStream = File.OpenRead(localFilePath))
  568. using (var requestStream = request.GetRequestStream())
  569. {
  570. byte[] buffer = new byte[4096];
  571. int bytesRead;
  572. while ((bytesRead = fileStream.Read(buffer, 0, buffer.Length)) > 0)
  573. {
  574. requestStream.Write(buffer, 0, bytesRead);
  575. }
  576. }
  577. using (var response = (FtpWebResponse)request.GetResponse())
  578. {
  579. LogMessage(1, $"文件: {localFilePath}上传成功,状态{response.StatusDescription}");
  580. return true;
  581. }
  582. }
  583. catch (WebException ex)
  584. {
  585. if (ex.Response is FtpWebResponse response)
  586. {
  587. LogMessage(0, $"NG,FTP 错误码: {(int)response.StatusCode} - {response.StatusDescription}");
  588. }
  589. else
  590. {
  591. LogMessage(0, $"NG,Web异常: {ex.Message}");
  592. }
  593. return false;
  594. }
  595. catch (Exception ex)
  596. {
  597. LogMessage(0, $"NG,上传失败: {ex.Message}");
  598. return false;
  599. }
  600. }
  601. private string CreateFtpDirectoryIfNotExists(string ftpDirectoryPath, string username, string password)
  602. {
  603. try
  604. {
  605. FtpWebRequest request = (FtpWebRequest)WebRequest.Create(ftpDirectoryPath);
  606. request.Method = WebRequestMethods.Ftp.MakeDirectory;
  607. request.Credentials = new NetworkCredential(username, password);
  608. request.UsePassive = true;
  609. request.UseBinary = true;
  610. request.KeepAlive = false;
  611. using (FtpWebResponse response = (FtpWebResponse)request.GetResponse())
  612. {
  613. response.Close();
  614. return "OK,目录创建成功: " + response.StatusDescription;
  615. }
  616. }
  617. catch (WebException ex)
  618. {
  619. if (ex.Response is FtpWebResponse response && response.StatusCode == FtpStatusCode.ActionNotTakenFileUnavailable)
  620. {
  621. return "OK,目录已存在: " + response.StatusDescription;
  622. }
  623. else
  624. {
  625. return "NG,创建目录时发生错误: " + ex.Message;
  626. }
  627. }
  628. }
  629. private void Delete_Click(object sender, EventArgs e)
  630. {
  631. if (!Directory.Exists(txtPath.Text))
  632. {
  633. LogMessage(0, $"删除路径不存在: {txtPath.Text}");
  634. return;
  635. }
  636. List<string> DeleteList = new List<string>() { };
  637. DeleteList.Add("1-1_" + SN1.Text);
  638. DeleteList.Add("1-2_" + SN2.Text);
  639. DeleteList.Add("1-3_" + SN3.Text);
  640. DeleteList.Add("2-1_" + SN4.Text);
  641. DeleteList.Add("2-2_" + SN5.Text);
  642. DeleteList.Add("2-3_" + SN6.Text);
  643. string DeletePath;
  644. int DeleteCount = 0;
  645. foreach (var item in DeleteList)
  646. {
  647. DeletePath = Path.Combine(txtPath.Text, item);
  648. if (DeletePath == txtPath.Text)
  649. {
  650. LogMessage(0, $"NG,路径{DeletePath}中,没有 {item} 文件夹");
  651. continue;
  652. }
  653. if (Directory.Exists(DeletePath))
  654. {
  655. try
  656. {
  657. Directory.Delete(DeletePath);
  658. }
  659. catch (IOException ex)
  660. {
  661. LogMessage(0, $"NG,文件夹{item}存有文件,{ex.Message}");
  662. continue;
  663. }
  664. catch (Exception ex)
  665. {
  666. LogMessage(0, $"NG,删除异常,{ex.Message}");
  667. continue;
  668. }
  669. DeleteCount++;
  670. if (SN1.Text == item) SN1.Text = "";
  671. if (SN2.Text == item) SN2.Text = "";
  672. if (SN3.Text == item) SN3.Text = "";
  673. if (SN4.Text == item) SN4.Text = "";
  674. if (SN5.Text == item) SN5.Text = "";
  675. if (SN6.Text == item) SN6.Text = "";
  676. }
  677. }
  678. if(DeleteCount != 0)
  679. {
  680. LogMessage(0, $"一键删除文件夹成功,共 {DeleteCount}个");
  681. return;
  682. }
  683. else
  684. {
  685. LogMessage(0, $"NG,请扫描SN序列号删除文件夹");
  686. }
  687. }
  688. private void Clear_Click(object sender, EventArgs e)
  689. {
  690. SN1.Text = "";
  691. SN2.Text = "";
  692. SN3.Text = "";
  693. SN4.Text = "";
  694. SN5.Text = "";
  695. SN6.Text = "";
  696. SN1.Focus();
  697. SN1.SelectAll();
  698. }
  699. private void Generate_Click(object sender, EventArgs e)
  700. {
  701. if (!Directory.Exists(txtPath.Text))
  702. {
  703. LogMessage(0, $"NG,生成路径不存在: {txtPath.Text}");
  704. return;
  705. }
  706. List<string> GenerateList = new List<string>() { };
  707. GenerateList.Add("1-1_" + SN1.Text);
  708. GenerateList.Add("1-2_" + SN2.Text);
  709. GenerateList.Add("1-3_" + SN3.Text);
  710. GenerateList.Add("2-1_" + SN4.Text);
  711. GenerateList.Add("2-2_" + SN5.Text);
  712. GenerateList.Add("2-3_" + SN6.Text);
  713. string GeneratePath;
  714. int GenerateCount = 0;
  715. foreach (var item in GenerateList)
  716. {
  717. GeneratePath = Path.Combine(txtPath.Text, item);
  718. if (GeneratePath == txtPath.Text)
  719. {
  720. LogMessage(0, $"NG,请扫描SN序列号创建文件夹");
  721. continue;
  722. }
  723. if (Directory.Exists(GeneratePath))
  724. {
  725. LogMessage(0, $"NG,路径{txtPath.Text}已有{item}文件夹");
  726. continue;
  727. }
  728. Directory.CreateDirectory(GeneratePath);
  729. GenerateCount++;
  730. }
  731. if(GenerateCount != 0) LogMessage(0, $"一键生成文件夹成功,共 {GenerateCount}个");
  732. }
  733. private void SN1_KeyDown(object sender, KeyEventArgs e)
  734. {
  735. if (e.KeyCode != Keys.Enter) return;
  736. if (string.IsNullOrEmpty(SN1.Text)) return;
  737. SN2.Focus();
  738. SN2.SelectAll();
  739. }
  740. private void SN2_KeyDown(object sender, KeyEventArgs e)
  741. {
  742. if (e.KeyCode != Keys.Enter) return;
  743. if (string.IsNullOrEmpty(SN2.Text)) return;
  744. SN3.Focus();
  745. SN3.SelectAll();
  746. }
  747. private void SN3_KeyDown(object sender, KeyEventArgs e)
  748. {
  749. if (e.KeyCode != Keys.Enter) return;
  750. if (string.IsNullOrEmpty(SN3.Text)) return;
  751. SN4.Focus();
  752. SN4.SelectAll();
  753. }
  754. private void SN4_KeyDown(object sender, KeyEventArgs e)
  755. {
  756. if (e.KeyCode != Keys.Enter) return;
  757. if (string.IsNullOrEmpty(SN4.Text)) return;
  758. SN5.Focus();
  759. SN5.SelectAll();
  760. }
  761. private void SN5_KeyDown(object sender, KeyEventArgs e)
  762. {
  763. if (e.KeyCode != Keys.Enter) return;
  764. if (string.IsNullOrEmpty(SN5.Text)) return;
  765. SN6.Focus();
  766. SN6.SelectAll();
  767. }
  768. private void SN6_KeyDown(object sender, KeyEventArgs e)
  769. {
  770. if (e.KeyCode != Keys.Enter) return;
  771. if (string.IsNullOrEmpty(SN6.Text)) return;
  772. Generate.Focus();
  773. }
  774. public string CheckFileAccess(string filePath)
  775. {
  776. try
  777. {
  778. using (FileStream fileStream = File.Open(filePath, FileMode.Open, FileAccess.Read, FileShare.None))
  779. {
  780. return "OK";
  781. }
  782. }
  783. catch (IOException ex)
  784. {
  785. return "NG,文件被占用: " + ex.Message;
  786. }
  787. catch (UnauthorizedAccessException ex)
  788. {
  789. return "NG,权限不足,无法访问文件: " + ex.Message;
  790. }
  791. catch (Exception ex)
  792. {
  793. return "NG," + ex.Message;
  794. }
  795. }
  796. public string CheckFolderPermissions(string path)
  797. {
  798. try
  799. {
  800. DirectorySecurity security = Directory.GetAccessControl(path);
  801. AuthorizationRuleCollection rules = security.GetAccessRules(true, true, typeof(NTAccount));
  802. WindowsIdentity currentUser = WindowsIdentity.GetCurrent();
  803. foreach (FileSystemAccessRule rule in rules)
  804. {
  805. if (rule.IdentityReference.Value == currentUser.Name || currentUser.Groups.Contains(rule.IdentityReference))
  806. {
  807. Console.WriteLine($" {rule.IdentityReference.Value}");
  808. Console.WriteLine($"权限类型: {rule.AccessControlType}");
  809. Console.WriteLine($"具体权限: {rule.FileSystemRights}");
  810. Console.WriteLine($"是否继承: {rule.IsInherited}");
  811. }
  812. }
  813. return "OK";
  814. }
  815. catch (UnauthorizedAccessException ex)
  816. {
  817. return $"NG,无权限访问文件夹: {ex.Message}";
  818. }
  819. catch (DirectoryNotFoundException)
  820. {
  821. return "NG,文件夹不存在";
  822. }
  823. catch (Exception ex)
  824. {
  825. return "NG," + ex.Message;
  826. }
  827. }
  828. public class Log
  829. {
  830. public string SN { set; get; }
  831. public string Result { set; get; }
  832. public string TestTime { set; get; }
  833. public string Side { set; get; }
  834. public List<LogItem> LogItemList { set; get; } = new List<LogItem>();
  835. }
  836. public class LogItem
  837. {
  838. public string Location { set; get; }
  839. public string ReelNo { set; get; }
  840. public string FirstType { set; get; }
  841. public string SceondType { set; get; }
  842. public string Name { set; get; }
  843. }
  844. }
  845. }