SystemSetting_PrinterTest.cs 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231
  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 = (Prefix.Text + lpad(int.Parse(NumLength.Value.ToString()), (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 = (Prefix.Text + lpad(int.Parse(NumLength.Value.ToString()), (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;
  88. if (RePrintText.Text != "")
  89. {
  90. dt = (DataTable)dh.ExecuteSql("select msl_sncode from makesnlist where msl_makecode='" + ma_code.Text + "' and msl_sncode='" + RePrintText.Text + "' and msl_type='before' order by msl_sncode", "select");
  91. }
  92. else
  93. {
  94. dt = (DataTable)dh.ExecuteSql("select msl_sncode from makesnlist where msl_makecode='" + ma_code.Text + "' and msl_type='before' order by msl_sncode", "select");
  95. }
  96. for (int i = 0; i < dt.Rows.Count; i = i + 2)
  97. {
  98. int temp = i;
  99. for (int j = 0; j < format.SubStrings.Count; j++)
  100. {
  101. switch (format.SubStrings[j].Name)
  102. {
  103. case "SN":
  104. format.SubStrings[j].Value = dt.Rows[i]["msl_sncode"].ToString();
  105. break;
  106. case "SN2":
  107. if (i + 1 <= dt.Rows.Count - 1)
  108. {
  109. format.SubStrings[j].Value = dt.Rows[i + 1]["msl_sncode"].ToString();
  110. }
  111. break;
  112. default:
  113. break;
  114. }
  115. }
  116. format.PrintSetup.PrinterName = PrinterList.Text;
  117. format.PrintSetup.IdenticalCopiesOfLabel = 1;
  118. format.Print();
  119. }
  120. }
  121. else
  122. {
  123. format1.SubStrings["Mark"].Value = MachineType.Text;
  124. for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 3)
  125. {
  126. int temp = i;
  127. for (int j = 0; j < format1.SubStrings.Count; j++)
  128. {
  129. switch (format1.SubStrings[j].Name)
  130. {
  131. case "SN":
  132. format1.SubStrings[j].Value = (Prefix.Text/*+ lpad(4, (temp ).ToString())*/);
  133. break;
  134. case "SN2":
  135. format1.SubStrings[j].Value = (Prefix.Text /*+ lpad(4, (temp + 1).ToString())*/);
  136. break;
  137. case "SN3":
  138. format1.SubStrings[j].Value = (Prefix.Text /*+ lpad(4, (temp + 2).ToString())*/);
  139. break;
  140. default:
  141. break;
  142. }
  143. }
  144. format1.PrintSetup.PrinterName = PrinterList.Text;
  145. format1.PrintSetup.IdenticalCopiesOfLabel = 1;
  146. format1.Print();
  147. }
  148. }
  149. }
  150. private static string lpad(int length, string number)
  151. {
  152. while (number.Length < length)
  153. {
  154. number = "0" + number;
  155. }
  156. number = number.Substring(number.Length - length, length);
  157. return number;
  158. }
  159. private void SystemSetting_PrinterTest_Load(object sender, EventArgs e)
  160. {
  161. label5.Visible = true;
  162. engine.Start();
  163. format = engine.Documents.Open(Application.StartupPath + "/Label.btw");
  164. format1 = engine.Documents.Open(Application.StartupPath + "/Material.btw");
  165. }
  166. private void SN_CheckedChanged(object sender, EventArgs e)
  167. {
  168. if (SN.Checked)
  169. {
  170. label6.Text = "机型相关配置";
  171. label5.Text = "前缀";
  172. label5.Visible = true;
  173. label7.Visible = true;
  174. ma_code.Visible = true;
  175. label4.Visible = true;
  176. Prefix.Visible = true;
  177. Mark.Visible = true;
  178. Rn.Visible = true;
  179. label3.Visible = true;
  180. label8.Visible = true;
  181. NumLength.Visible = true;
  182. this.pictureBox1.Image = global::UAS_MES_NEW.Properties.Resources.SN;
  183. }
  184. else if (MakeSnList.Checked)
  185. {
  186. label6.Text = "机型相关配置";
  187. label5.Visible = false;
  188. label5.Text = "前缀";
  189. label7.Visible = true;
  190. ma_code.Visible = true;
  191. Prefix.Visible = false;
  192. label4.Visible = true;
  193. Mark.Visible = true;
  194. Rn.Visible = false;
  195. label3.Visible = false;
  196. this.pictureBox1.Image = null;
  197. label8.Visible = false;
  198. NumLength.Visible = false;
  199. }
  200. else
  201. {
  202. this.pictureBox1.Image = global::UAS_MES_NEW.Properties.Resources.Material;
  203. label6.Text = "标签部分(显示)";
  204. label5.Visible = true;
  205. Prefix.Visible = true;
  206. label7.Visible = false;
  207. ma_code.Visible = false;
  208. label4.Visible = false;
  209. Mark.Visible = false;
  210. label5.Text = "条码内容";
  211. }
  212. }
  213. private void RePrint_Click(object sender, EventArgs e)
  214. {
  215. }
  216. }
  217. }