Make_RePrintLabel.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588
  1. using LabelManager2;
  2. using System;
  3. using System.Data;
  4. using System.Diagnostics;
  5. using System.Drawing;
  6. using System.IO;
  7. using System.Text;
  8. using System.Threading;
  9. using System.Windows.Forms;
  10. using UAS_MES_NEW.DataOperate;
  11. using UAS_MES_NEW.Entity;
  12. using UAS_MES_NEW.PublicForm;
  13. using UAS_MES_NEW.PublicMethod;
  14. namespace UAS_MES_NEW.Make
  15. {
  16. public partial class Make_RePrintLabel : Form
  17. {
  18. DataHelper dh;
  19. public BarTender.Application engine;
  20. LogStringBuilder sql = new LogStringBuilder();
  21. AutoSizeFormClass asc = new AutoSizeFormClass();
  22. ApplicationClass lbl;
  23. Document doc;
  24. Thread InitPrint;//实例化打印进程
  25. DataTable dt;
  26. ftpOperater ftp;
  27. DataTable listA;
  28. string getlabel = "";
  29. DataTable mapB;
  30. String TSN = "";//记录第一次输入的SN
  31. DataTable infoc;
  32. string re_ms_id = "";
  33. string ms_id = "";
  34. DataTable formValue;//界面赋值
  35. string type = "";
  36. string errorMessage = "";
  37. public Make_RePrintLabel()
  38. {
  39. InitializeComponent();
  40. }
  41. private void Make_RePrintLabel_Load(object sender, EventArgs e)
  42. {
  43. asc.controllInitializeSize(this);
  44. Process[] processes = System.Diagnostics.Process.GetProcessesByName("lppa");
  45. Process[] processes1 = System.Diagnostics.Process.GetProcessesByName("bartend");
  46. for (int i = 0; i < processes1.Length; i++)
  47. {
  48. processes1[i].Kill();
  49. }
  50. for (int i = 0; i < processes.Length; i++)
  51. {
  52. processes[i].Kill();
  53. }
  54. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  55. InitPrint = new Thread(InPrint);
  56. SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
  57. BaseUtil.SetFormCenter(stw);
  58. stw.ShowDialog();
  59. inputText.Focus();
  60. dh = SystemInf.dh;
  61. }
  62. private void InPrint()
  63. {
  64. try
  65. {
  66. //engine = new BarTender.Application();
  67. //lbl = new ApplicationClass();
  68. BaseUtil.WriteLbl();
  69. COMObjManage.Initialize();
  70. }
  71. catch (Exception ex)
  72. {
  73. OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
  74. }
  75. }
  76. private void Make_RePrintLabel_SizeChanged(object sender, EventArgs e)
  77. {
  78. //窗体大小变化的时候
  79. asc.controlAutoSize(this);
  80. }
  81. private void Make_RePrintLabel_FormClosing(object sender, FormClosingEventArgs e)
  82. {
  83. //窗口关闭的时候
  84. BaseUtil.ClosePrint(lbl);
  85. if (engine != null)
  86. engine.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges);
  87. XmlWatcher.EnableRaisingEvents = false;
  88. }
  89. private void radioButton_CheckedChange(object sender, EventArgs e)
  90. {
  91. RadioButton btn = sender as RadioButton;
  92. if ((btn.Name == "giftBox" || btn.Name == "flBox") && btn.Checked)
  93. {
  94. //如果是切换成彩盒或者机身标提示用户 输入SN
  95. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  96. clearAll();
  97. }
  98. else if (btn.Name == "CartonBox" && btn.Checked)
  99. {
  100. OperateResult.AppendText(">>请输入卡通箱号\n", Color.Black);
  101. clearAll();
  102. }
  103. else if (btn.Name == "fuselagel" && btn.Checked)
  104. {
  105. OperateResult.AppendText(">>请输入栈板号\n", Color.Black);
  106. clearAll();
  107. }
  108. }
  109. private void inputText_KeyDown(object sender, KeyEventArgs e)
  110. {
  111. //按下enter键
  112. if (e.KeyCode == Keys.Enter)
  113. {
  114. if (inputText.Text == "")
  115. {
  116. OperateResult.AppendText("<<输入不能为空\n", Color.Red);
  117. return;
  118. }
  119. OperateResult.AppendText(">>" + inputText.Text + "\n", Color.Black);
  120. //打印类型为彩盒或者机身标
  121. if (giftBox.Checked || flBox.Checked)
  122. {
  123. //select max(ms_id)ms_id from makeserial where ms_sncode=?
  124. ms_id = dh.getFieldDataByCondition("makeserial", "max(ms_id) ms_id", "ms_sncode='" + inputText.Text + "'").ToString();
  125. //如果ms_id 无值或者为空,提示用户SN不存在,请输入SN
  126. if (ms_id == "")
  127. {
  128. OperateResult.AppendText("<<SN:" + inputText.Text + "不存在\n", Color.Red, inputText);
  129. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  130. return;
  131. }
  132. ////判断是否装箱通过
  133. //if (checkPacked())
  134. //{
  135. // return;
  136. //}
  137. //界面赋值
  138. formValue = (DataTable)dh.ExecuteSql("select ms_makecode,pr_code,pr_detail from makeserial left join product on MS_PRODCODE=pr_code where ms_id='" + ms_id + "'", "select");
  139. BaseUtil.SetFormValue(this.Controls, formValue);
  140. //无值,可补打
  141. inputValue.Text = inputText.Text;
  142. inputText.Text = "";
  143. }
  144. //打印类型为卡通箱
  145. else if (CartonBox.Checked)
  146. {
  147. //查询箱号是否存在
  148. dt = (DataTable)dh.ExecuteSql("select pa_id,pa_prodcode pr_code,pa_makecode ms_makecode,pr_detail from package left join product on pr_code=pa_prodcode where pa_outboxcode='" + inputText.Text + "' and pa_type=1", "select");
  149. if (dt.Rows.Count == 0)
  150. {
  151. //无值,返回提示用户“箱号不存在”, “>>请输入卡通箱号”
  152. OperateResult.AppendText("<<箱号:" + inputText.Text + "不存在\n", Color.Red, inputText);
  153. OperateResult.AppendText(">>请输入卡通箱号\n", Color.Black);
  154. return;
  155. }
  156. //界面赋值
  157. BaseUtil.SetFormValue(this.Controls, dt);
  158. //有值,可以打
  159. //展示产品编号和标签模板到界面
  160. inputValue.Text = inputText.Text;
  161. inputText.Text = "";
  162. }//打印类型为栈板
  163. else if (fuselagel.Checked)
  164. {
  165. //查询箱号是否存在
  166. dt = (DataTable)dh.ExecuteSql("select pa_id,pa_prodcode pr_code,pa_makecode ms_makecode,pr_detail from package left join product on pr_code=pa_prodcode where pa_outboxcode='" + inputText.Text + "' and pa_type=3", "select");
  167. if (dt.Rows.Count == 0)
  168. {
  169. //无值,返回提示用户“箱号不存在”, “>>请输入卡通箱号”
  170. OperateResult.AppendText("<<栈板号:" + inputText.Text + "不存在\n", Color.Red, inputText);
  171. OperateResult.AppendText(">>请输入栈板号\n", Color.Black);
  172. return;
  173. }
  174. //界面赋值
  175. BaseUtil.SetFormValue(this.Controls, dt);
  176. //有值,可以打
  177. //展示产品编号和标签模板到界面
  178. inputValue.Text = inputText.Text;
  179. inputText.Text = "";
  180. }
  181. print_Click(sender, new EventArgs());
  182. }
  183. }
  184. private void PrintLabel_TextChanged(object sender, EventArgs e)
  185. {
  186. if (pr_code.Text == "")
  187. {
  188. return;
  189. }
  190. if (fuselagel.Checked)
  191. type = "栈板标";
  192. else if (flBox.Checked)
  193. type = "机身标";
  194. else if (giftBox.Checked)
  195. type = "彩盒标";
  196. else
  197. type = "卡通箱标";
  198. getlabel = "select la_id,substr(la_url,instr(la_url,'\\',-1)+1)la_name,la_url,la_isdefault from label where la_prodcode='" + pr_code.Text + "' and la_templatetype='" + type + "' and la_statuscode='AUDITED' order by la_isdefault";
  199. listA = (DataTable)dh.ExecuteSql(getlabel, "select");
  200. if (listA.Rows.Count == 0)
  201. {
  202. OperateResult.AppendText("<<产品:" + pr_code.Text + "未维护" + type + "模板\n", Color.Red);
  203. }
  204. PrintLabel.DataSource = listA;
  205. PrintLabel.DisplayMember = "la_url";
  206. PrintLabel.ValueMember = "la_id";
  207. }
  208. private void print_Click(object sender, EventArgs e)
  209. {
  210. //输入值字段值不为空,打印不为空,有选中打印模板,才可以进行打印,打印前再次判断
  211. if (inputValue.Text == "")
  212. {
  213. OperateResult.AppendText("<<无箱号或者序列号\n", Color.Red);
  214. return;
  215. }
  216. if (PrintLabel.Text == "")
  217. {
  218. OperateResult.AppendText("<<无打印模板\n", Color.Red);
  219. return;
  220. }
  221. //打印类型 彩盒或者标签,再次判断是否已装箱,未转号
  222. if (giftBox.Checked || flBox.Checked)
  223. {
  224. mapB = (DataTable)dh.ExecuteSql("select ms_outboxcode, nvl(ms_downstatus,0) ms_downstatus from makeserial where ms_id='" + ms_id + "' and ms_sncode='" + inputValue.Text + "'", "select");
  225. if (mapB.Rows.Count == 0)
  226. {
  227. //无值提示用户序列号错误,不存在或者已经发生转号
  228. OperateResult.AppendText("<<序列号错误,不存在或已经发生转号\n", Color.Red);
  229. return;
  230. }
  231. ////如果ms_outboxcode 不为空,则提示用户,已经装箱不允许单独打印
  232. //if (mapB.Rows[0]["ms_outboxcode"].ToString() != "")
  233. //{
  234. // OperateResult.AppendText("<<SN:" + inputValue.Text + "已经装箱" + mapB.Rows[0]["ms_outboxcode"].ToString() + "不允许单独补打\n", Color.Red);
  235. // return;
  236. //}
  237. //判定通过进行打印
  238. //doc = lbl.Documents.Open(PrintLabel.Text);
  239. if (PrintLabel.Text.ToUpper().Contains(".BTW"))
  240. {
  241. /*if (Print.SinglePrint(Tag.ToString(), engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, giftBox.Checked ? "彩盒标" : "机身标", "-1", out errorMessage))
  242. {
  243. //按照打印张数打印
  244. OperateResult.AppendText("<<打印成功\n", Color.Green);
  245. }
  246. else
  247. {
  248. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  249. }*/
  250. if (COMObjManage.SinglePrint(Tag.ToString(), PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, giftBox.Checked ? "彩盒标" : "机身标", "-1", out errorMessage))
  251. {
  252. //按照打印张数打印
  253. OperateResult.AppendText("<<打印成功\n", Color.Green);
  254. }
  255. else
  256. {
  257. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  258. }
  259. }
  260. else
  261. {
  262. /*if (Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, giftBox.Checked ? "彩盒标" : "机身标", "-1", out errorMessage))
  263. {
  264. //按照打印张数打印
  265. OperateResult.AppendText("<<打印成功\n", Color.Green);
  266. }
  267. else
  268. {
  269. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  270. }*/
  271. if (COMObjManage.CodeSoft(Tag.ToString(), PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, giftBox.Checked ? "彩盒标" : "机身标", "-1", out errorMessage))
  272. {
  273. //按照打印张数打印
  274. OperateResult.AppendText("<<打印成功\n", Color.Green);
  275. }
  276. else
  277. {
  278. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  279. }
  280. }
  281. //打印成功,记录日志commandlog , cl_operate彩盒或者机身标补打印,cl_result补打印成功
  282. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, giftBox.Checked ? "彩盒标补打印" : "机身标补打印", "补打印成功", inputValue.Text, "");
  283. ////如果ms_downstatus<>0,则更新ms_downstatus=-1 where ms_id=?id,同时插入记录至表 MAKEDOWN
  284. //if (mapB.Rows[0]["ms_downstatus"].ToString() == "0")
  285. //{
  286. // dh.ExecuteSql("update makeserial set ms_downstatus='-1' where ms_id='" + ms_id + "'", "update");
  287. // //插入数据
  288. // putInfo2MakeDown();
  289. //}
  290. }
  291. //打印类型为卡通箱标签
  292. else if (CartonBox.Checked)
  293. {
  294. //select pa_downstatus from package where pa_outboxcode=? 输入值code
  295. mapB = (DataTable)dh.ExecuteSql("select pa_downstatus from package where pa_outboxcode='" + inputValue.Text + "'", "select");
  296. //无值提示用户箱号错误,不存在。
  297. if (mapB.Rows.Count == 0)
  298. {
  299. OperateResult.AppendText("<<箱号:" + inputValue.Text + "错误,不存在\n", Color.Red);
  300. return;
  301. }
  302. //doc = lbl.Documents.Open(PrintLabel.Text);
  303. if (PrintLabel.Text.ToUpper().Contains(".BTW"))
  304. {
  305. /*if (Print.SinglePrint(Tag.ToString(), engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "卡通箱标", "-1", out errorMessage))
  306. {
  307. //判断通过,打印
  308. OperateResult.AppendText("<<打印成功\n", Color.Green);
  309. }
  310. else
  311. {
  312. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  313. }*/
  314. if (COMObjManage.SinglePrint(Tag.ToString(), PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "卡通箱标", "-1", out errorMessage))
  315. {
  316. //判断通过,打印
  317. OperateResult.AppendText("<<打印成功\n", Color.Green);
  318. }
  319. else
  320. {
  321. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  322. }
  323. }
  324. else
  325. {
  326. /*if (Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "卡通箱标", "-1", out errorMessage))
  327. {
  328. //判断通过,打印
  329. OperateResult.AppendText("<<打印成功\n", Color.Green);
  330. }
  331. else
  332. {
  333. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  334. }*/
  335. if (COMObjManage.CodeSoft(Tag.ToString(), PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "卡通箱标", "-1", out errorMessage))
  336. {
  337. //判断通过,打印
  338. OperateResult.AppendText("<<打印成功\n", Color.Green);
  339. }
  340. else
  341. {
  342. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  343. }
  344. }
  345. //打印成功,记录日志commandlog , cl_operate彩盒或者机身标补打印,cl_result补打印成功
  346. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "卡通箱标签补打印,箱号:" + inputValue.Text, "补打印成功", inputValue.Text, "");
  347. ////如果pa_downstatus<>0,则更新pa_downstatus=-1 where pa_outboxcode=?code,同时插入记录至表 MAKEDOWN
  348. //if (mapB.Rows[0]["pa_downstatus"].ToString() == "0")
  349. //{
  350. // dh.ExecuteSql("update package set pa_downstatus='-1' where pa_outboxcode='" + inputValue.Text + "'", "update");
  351. // //插入MakeDown表
  352. // putInfo2MakeDown();
  353. //}
  354. }
  355. //打印类型为栈板标签
  356. else if (fuselagel.Checked)
  357. {
  358. //select pa_downstatus from package where pa_outboxcode=? 输入值code
  359. mapB = (DataTable)dh.ExecuteSql("select pa_downstatus from package where pa_outboxcode='" + inputValue.Text + "'", "select");
  360. //无值提示用户箱号错误,不存在。
  361. if (mapB.Rows.Count == 0)
  362. {
  363. OperateResult.AppendText("<<栈板标号:" + inputValue.Text + "错误,不存在\n", Color.Red);
  364. return;
  365. }
  366. //doc = lbl.Documents.Open(PrintLabel.Text);
  367. if (PrintLabel.Text.ToUpper().Contains(".BTW"))
  368. {
  369. /*if (Print.SinglePrint(Tag.ToString(), engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "栈板标", "-1", out errorMessage))
  370. {
  371. //判断通过,打印
  372. OperateResult.AppendText("<<打印成功\n", Color.Green);
  373. }
  374. else
  375. {
  376. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  377. }*/
  378. if (COMObjManage.SinglePrint(Tag.ToString(), PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "栈板标", "-1", out errorMessage))
  379. {
  380. //判断通过,打印
  381. OperateResult.AppendText("<<打印成功\n", Color.Green);
  382. }
  383. else
  384. {
  385. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  386. }
  387. }
  388. else
  389. {
  390. /*if (Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "栈板标", "-1", out errorMessage))
  391. {
  392. //判断通过,打印
  393. OperateResult.AppendText("<<打印成功\n", Color.Green);
  394. }
  395. else
  396. {
  397. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  398. }*/
  399. if (COMObjManage.CodeSoft(Tag.ToString(), PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), ms_makecode.Text, pr_code.Text, "栈板标", "-1", out errorMessage))
  400. {
  401. //判断通过,打印
  402. OperateResult.AppendText("<<打印成功\n", Color.Green);
  403. }
  404. else
  405. {
  406. OperateResult.AppendText(errorMessage + "\n", Color.Red);
  407. }
  408. }
  409. //打印成功,记录日志commandlog , cl_operate彩盒或者机身标补打印,cl_result补打印成功
  410. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "栈板标标签补打印,栈板标号:" + inputValue.Text, "补打印成功", inputValue.Text, "");
  411. ////如果pa_downstatus<>0,则更新pa_downstatus=-1 where pa_outboxcode=?code,同时插入记录至表 MAKEDOWN
  412. //if (mapB.Rows[0]["pa_downstatus"].ToString() == "0")
  413. //{
  414. // dh.ExecuteSql("update package set pa_downstatus='-1' where pa_outboxcode='" + inputValue.Text + "'", "update");
  415. // //插入MakeDown表
  416. // putInfo2MakeDown();
  417. //}
  418. }
  419. }
  420. /// <summary>
  421. /// 判断彩盒和机身标序列是否已经装箱
  422. /// </summary>
  423. /// <returns></returns>
  424. private bool checkPacked()
  425. {
  426. //如果存在,则判断是否装箱
  427. dt = (DataTable)dh.ExecuteSql("select ms_id,ms_prodcode,ms_makecode,pr_detail, ms_outboxcode from makeserial left join product on pr_code=ms_prodcode where ms_id='" + ms_id + "'", "select");
  428. //判断ms_outboxcode 是否为空,如果有值,则返回提示用户“已经装箱
  429. if (dt.Rows.Count == 0)
  430. {
  431. OperateResult.AppendText("<<SN:" + inputText.Text + "不存在\n", Color.Red, inputText);
  432. return true;
  433. }
  434. if (dt.Rows[0]["ms_outboxcode"].ToString() != "")
  435. {
  436. OperateResult.AppendText("<<SN:" + inputText.Text + "已经装箱" + dt.Rows[0]["ms_outboxcode"].ToString() + "不允许单独补打\n", Color.Red, inputText);
  437. return true;
  438. }
  439. return false;
  440. }
  441. /// <summary>
  442. /// 插入表MAKEDOWN
  443. /// </summary>
  444. private void putInfo2MakeDown()
  445. {
  446. //插入数据至表MAKEDOWN
  447. string md_code = "";
  448. LogicHandler.GetSerialNumByCaller("MakeDown", out md_code);
  449. sql.Clear();
  450. sql.Append("INSERT INTO MAKEDOWN (MD_ID,MD_LINECODE,MD_SCCODE,MD_STEPCODE,");
  451. sql.Append((CartonBox.Checked ? "MD_OUTBOXCODE" : "MD_SNCODE") + ",MD_PRODCODE,MD_MACODE, MD_DOWNREASON, MD_CODE,");
  452. sql.Append("MD_DOWNDATE,MD_DOWNMAN,MD_STATUS) values (MAKEDOWN_seq.nextval,'" + User.UserLineCode + "','" + User.UserSourceCode + "',");
  453. sql.Append("'" + User.CurrentStepCode + "','" + inputValue.Text + "','" + pr_code.Text + "','" + ms_makecode.Text + "','补打标签','" + md_code + "',sysdate,'" + User.UserCode + "','-1')");
  454. dh.ExecuteSql(sql.GetString(), "insert");
  455. }
  456. private void rePrintCheck_KeyDown(object sender, KeyEventArgs e)
  457. {
  458. }
  459. /// <summary>
  460. /// 清除信息
  461. /// </summary>
  462. private void clearAll()
  463. {
  464. //清除输入值、工单代码、产品编号,名称、打印模板、核对第一次输入的SN
  465. inputValue.Text = "";
  466. ms_makecode.Text = "";
  467. pr_code.Text = "";
  468. pr_detail.Text = "";
  469. TSN = "";
  470. if (listA != null)
  471. {
  472. listA.Clear();
  473. }
  474. }
  475. private void XmlWatcher_Created(object sender, System.IO.FileSystemEventArgs e)
  476. {
  477. while (true)
  478. {
  479. try
  480. {
  481. using (Stream stream = File.Open(e.FullPath, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))
  482. {
  483. if (stream != null)
  484. break;
  485. }
  486. }
  487. catch (Exception ex)
  488. {
  489. Console.WriteLine(ex.Message);
  490. }
  491. }
  492. string test_date = "";
  493. string test_result = "";
  494. string test_sn = "";
  495. string imageurl = "";
  496. string oMSID = "";
  497. string oErrMessage = "";
  498. StreamReader _Sr = new StreamReader(FolderPath.Text + @"\" + e.Name, Encoding.UTF8);
  499. OperateResult.AppendText("读取文件" + e.Name + "\n");
  500. _Sr.Close();
  501. //获取文件名的序列号,如SA123456.xml,如果开头为-表示无条码需要自动获取
  502. string sn_code = e.Name.Split('.')[0].Replace("test", "");
  503. inputText.Text = sn_code;
  504. inputText_KeyDown(this, new KeyEventArgs(Keys.Enter));
  505. File.Delete(e.FullPath);
  506. }
  507. private void ChooseFolder_Click(object sender, EventArgs e)
  508. {
  509. FolderBrowserDialog folder = new FolderBrowserDialog();
  510. folder.Description = "选择监控文件夹";
  511. DialogResult result = folder.ShowDialog();
  512. if (result == DialogResult.OK)
  513. {
  514. FolderPath.Text = folder.SelectedPath;
  515. }
  516. }
  517. private void StartWatch_Click(object sender, EventArgs e)
  518. {
  519. if (FolderPath.Text == "")
  520. {
  521. OperateResult.AppendText("请选择监控文件夹\n");
  522. return;
  523. }
  524. else
  525. {
  526. if (!Directory.Exists(FolderPath.Text))
  527. {
  528. OperateResult.AppendText("监控文件夹不存在\n");
  529. return;
  530. }
  531. }
  532. XmlWatcher.Path = FolderPath.Text;
  533. XmlWatcher.Filter = "*.txt";
  534. XmlWatcher.EnableRaisingEvents = true;
  535. //设置缓存数据
  536. BaseUtil.SetCacheData("FolderPath", FolderPath.Text);
  537. //设置按钮不可点击
  538. StartWatch.Enabled = false;
  539. ChooseFolder.Enabled = false;
  540. StopWatch.Enabled = true;
  541. OperateResult.AppendText("开始执行监控\n");
  542. }
  543. private void StopWatch_Click(object sender, EventArgs e)
  544. {
  545. XmlWatcher.EnableRaisingEvents = false;
  546. StartWatch.Enabled = true;
  547. ChooseFolder.Enabled = true;
  548. StopWatch.Enabled = false;
  549. OperateResult.AppendText("停止执行监控\n");
  550. }
  551. }
  552. }