SystemSetting_PrinterTest.cs 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115
  1. using Seagull.BarTender.Print;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Drawing.Printing;
  8. using System.Linq;
  9. using System.Text;
  10. using System.Windows.Forms;
  11. using UAS_MES_NEW.DataOperate;
  12. using UAS_MES_NEW.Entity;
  13. namespace UAS_MES_NEW.SystemSetting
  14. {
  15. public partial class SystemSetting_PrinterTest : Form
  16. {
  17. Engine engine = new Engine();
  18. LabelFormatDocument format;
  19. DataHelper dh = SystemInf.dh;
  20. public SystemSetting_PrinterTest()
  21. {
  22. InitializeComponent();
  23. }
  24. private void PrintTest_Click(object sender, EventArgs e)
  25. {
  26. PrintDocument print = new PrintDocument();
  27. print.PrinterSettings.PrinterName = PrinterList.Text;
  28. print.PrintPage += Print_PrintPage;
  29. print.Print();
  30. }
  31. private void Print_PrintPage(object sender, PrintPageEventArgs e)
  32. {
  33. Graphics g = e.Graphics;
  34. float leftMargin = 10f; //左边距
  35. SolidBrush myBrush = new SolidBrush(Color.Black);//刷子
  36. float yPosition = 5f;//行定位
  37. Font printFont = new Font("微软雅黑", 20f, FontStyle.Bold);//设置字体
  38. yPosition += printFont.GetHeight(g);//另起一行
  39. g.DrawString("成功连接此打印机", printFont, myBrush, leftMargin, yPosition, new StringFormat());
  40. }
  41. private void Setting_Click(object sender, EventArgs e)
  42. {
  43. PrintDialog printd = new PrintDialog();
  44. printd.PrinterSettings.PrinterName = PrinterList.Text;
  45. printd.ShowDialog();
  46. }
  47. private void Export_Click(object sender, EventArgs e)
  48. {
  49. if (!dh.CheckExist("make", "ma_code='" + ma_code.Text + "'"))
  50. {
  51. MessageBox.Show("工单号不存在");
  52. return;
  53. }
  54. for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 4)
  55. {
  56. int temp = i;
  57. for (int j = 0; j < format.SubStrings.Count; j++)
  58. {
  59. switch (format.SubStrings[j].Name)
  60. {
  61. case "RN1":
  62. format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(4, (temp).ToString()));
  63. dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type)values(makesnlist_seq.nextval,sysdate,'"+ma_code.Text+"','"+ format.SubStrings[j].Value + "','before')", "insert");
  64. break;
  65. case "RN2":
  66. format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(4, (temp + 1).ToString()));
  67. dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before')", "insert");
  68. break;
  69. case "RN3":
  70. format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(4, (temp + 2).ToString()));
  71. dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before')", "insert");
  72. break;
  73. case "RN4":
  74. format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(4, (temp + 3).ToString()));
  75. dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before')", "insert");
  76. break;
  77. default:
  78. break;
  79. }
  80. }
  81. format.PrintSetup.PrinterName = PrinterList.Text;
  82. format.PrintSetup.IdenticalCopiesOfLabel = 1;
  83. format.Print();
  84. }
  85. }
  86. private static string lpad(int length, string number)
  87. {
  88. while (number.Length < length)
  89. {
  90. number = "0" + number;
  91. }
  92. number = number.Substring(number.Length - length, length);
  93. return number;
  94. }
  95. private void SystemSetting_PrinterTest_Load(object sender, EventArgs e)
  96. {
  97. engine.Start();
  98. format = engine.Documents.Open(Application.StartupPath + "/Label.btw");
  99. }
  100. }
  101. }