SystemSetting_PrinterTest.cs 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201
  1. using Seagull.BarTender.Print;
  2. using System;
  3. using System.Data;
  4. using System.Drawing;
  5. using System.Drawing.Printing;
  6. using System.Windows.Forms;
  7. using UAS_MES_NEW.DataOperate;
  8. using UAS_MES_NEW.Entity;
  9. namespace UAS_MES_NEW.SystemSetting
  10. {
  11. public partial class SystemSetting_PrinterTest : Form
  12. {
  13. Engine engine = new Engine();
  14. LabelFormatDocument format;
  15. LabelFormatDocument format1;
  16. DataHelper dh = SystemInf.dh;
  17. public SystemSetting_PrinterTest()
  18. {
  19. InitializeComponent();
  20. }
  21. private void PrintTest_Click(object sender, EventArgs e)
  22. {
  23. PrintDocument print = new PrintDocument();
  24. print.PrinterSettings.PrinterName = PrinterList.Text;
  25. print.PrintPage += Print_PrintPage;
  26. print.Print();
  27. }
  28. private void Print_PrintPage(object sender, PrintPageEventArgs e)
  29. {
  30. Graphics g = e.Graphics;
  31. float leftMargin = 10f; //左边距
  32. SolidBrush myBrush = new SolidBrush(Color.Black);//刷子
  33. float yPosition = 5f;//行定位
  34. Font printFont = new Font("微软雅黑", 20f, FontStyle.Bold);//设置字体
  35. yPosition += printFont.GetHeight(g);//另起一行
  36. g.DrawString("成功连接此打印机", printFont, myBrush, leftMargin, yPosition, new StringFormat());
  37. }
  38. private void Setting_Click(object sender, EventArgs e)
  39. {
  40. PrintDialog printd = new PrintDialog();
  41. printd.PrinterSettings.PrinterName = PrinterList.Text;
  42. printd.ShowDialog();
  43. }
  44. private void Export_Click(object sender, EventArgs e)
  45. {
  46. if (!dh.CheckExist("make", "ma_code='" + ma_code.Text + "'"))
  47. {
  48. MessageBox.Show("工单号不存在");
  49. return;
  50. }
  51. if (SN.Checked)
  52. {
  53. format.SubStrings["Type"].Value = MachineType.Text;
  54. format.SubStrings["Mark"].Value = Mark.Text;
  55. for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 2)
  56. {
  57. int temp = i;
  58. for (int j = 0; j < format.SubStrings.Count; j++)
  59. {
  60. switch (format.SubStrings[j].Name)
  61. {
  62. case "SN":
  63. format.SubStrings[j].Value = (ma_code.Text.Replace("XX-", "") + lpad(5, (temp).ToString()));
  64. if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "'"))
  65. {
  66. 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");
  67. };
  68. break;
  69. case "SN2":
  70. format.SubStrings[j].Value = (ma_code.Text.Replace("XX-", "") + lpad(5, (temp + 1).ToString()));
  71. if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "'"))
  72. {
  73. 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");
  74. };
  75. break;
  76. default:
  77. break;
  78. }
  79. }
  80. format.PrintSetup.PrinterName = PrinterList.Text;
  81. format.PrintSetup.IdenticalCopiesOfLabel = 1;
  82. format.Print();
  83. }
  84. }
  85. else if (MakeSnList.Checked)
  86. {
  87. DataTable dt = (DataTable)dh.ExecuteSql("select msl_sncode from makesnlist where msl_makecode='" + ma_code.Text + "' and msl_type='before' order by msl_sncode", "select");
  88. for (int i = 0; i < dt.Rows.Count; i = i + 2)
  89. {
  90. int temp = i;
  91. for (int j = 0; j < format.SubStrings.Count; j++)
  92. {
  93. switch (format.SubStrings[j].Name)
  94. {
  95. case "SN":
  96. format.SubStrings[j].Value = dt.Rows[i]["msl_sncode"].ToString();
  97. break;
  98. case "SN2":
  99. if (i + 1 <= dt.Rows.Count - 1)
  100. {
  101. format.SubStrings[j].Value = dt.Rows[i + 1]["msl_sncode"].ToString();
  102. }
  103. break;
  104. default:
  105. break;
  106. }
  107. }
  108. format.PrintSetup.PrinterName = PrinterList.Text;
  109. format.PrintSetup.IdenticalCopiesOfLabel = 1;
  110. format.Print();
  111. }
  112. }
  113. else
  114. {
  115. format1.SubStrings["Mark"].Value = MachineType.Text;
  116. for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 3)
  117. {
  118. int temp = i;
  119. for (int j = 0; j < format1.SubStrings.Count; j++)
  120. {
  121. switch (format1.SubStrings[j].Name)
  122. {
  123. case "SN":
  124. format1.SubStrings[j].Value = (Prefix.Text/*+ lpad(4, (temp ).ToString())*/);
  125. break;
  126. case "SN2":
  127. format1.SubStrings[j].Value = (Prefix.Text /*+ lpad(4, (temp + 1).ToString())*/);
  128. break;
  129. case "SN3":
  130. format1.SubStrings[j].Value = (Prefix.Text /*+ lpad(4, (temp + 2).ToString())*/);
  131. break;
  132. default:
  133. break;
  134. }
  135. }
  136. format1.PrintSetup.PrinterName = PrinterList.Text;
  137. format1.PrintSetup.IdenticalCopiesOfLabel = 1;
  138. format1.Print();
  139. }
  140. }
  141. }
  142. private static string lpad(int length, string number)
  143. {
  144. while (number.Length < length)
  145. {
  146. number = "0" + number;
  147. }
  148. number = number.Substring(number.Length - length, length);
  149. return number;
  150. }
  151. private void SystemSetting_PrinterTest_Load(object sender, EventArgs e)
  152. {
  153. label5.Visible = false;
  154. Prefix.Visible = false;
  155. engine.Start();
  156. format = engine.Documents.Open(Application.StartupPath + "/Label.btw");
  157. format1 = engine.Documents.Open(Application.StartupPath + "/Material.btw");
  158. }
  159. private void SN_CheckedChanged(object sender, EventArgs e)
  160. {
  161. if (SN.Checked)
  162. {
  163. label6.Text = "机型相关配置";
  164. label5.Visible = false;
  165. Prefix.Visible = false;
  166. label7.Visible = true;
  167. ma_code.Visible = true;
  168. label4.Visible = true;
  169. Mark.Visible = true;
  170. Rn.Visible = true;
  171. label3.Visible = true;
  172. this.pictureBox1.Image = global::UAS_MES_NEW.Properties.Resources.SN;
  173. }
  174. else
  175. {
  176. this.pictureBox1.Image = global::UAS_MES_NEW.Properties.Resources.Material;
  177. label6.Text = "标签部分(显示)";
  178. label5.Visible = true;
  179. Prefix.Visible = true;
  180. Rn.Visible = false;
  181. label3.Visible = false;
  182. label7.Visible = false;
  183. ma_code.Visible = false;
  184. label4.Visible = false;
  185. Mark.Visible = false;
  186. }
  187. }
  188. }
  189. }