using Seagull.BarTender.Print; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Drawing.Printing; using System.Linq; using System.Text; using System.Windows.Forms; using UAS_MES_NEW.DataOperate; using UAS_MES_NEW.Entity; namespace UAS_MES_NEW.SystemSetting { public partial class SystemSetting_PrinterTest : Form { Engine engine = new Engine(); LabelFormatDocument format; DataHelper dh = SystemInf.dh; public SystemSetting_PrinterTest() { InitializeComponent(); } private void PrintTest_Click(object sender, EventArgs e) { PrintDocument print = new PrintDocument(); print.PrinterSettings.PrinterName = PrinterList.Text; print.PrintPage += Print_PrintPage; print.Print(); } private void Print_PrintPage(object sender, PrintPageEventArgs e) { Graphics g = e.Graphics; float leftMargin = 10f; //左边距 SolidBrush myBrush = new SolidBrush(Color.Black);//刷子 float yPosition = 5f;//行定位 Font printFont = new Font("微软雅黑", 20f, FontStyle.Bold);//设置字体 yPosition += printFont.GetHeight(g);//另起一行 g.DrawString("成功连接此打印机", printFont, myBrush, leftMargin, yPosition, new StringFormat()); } private void Setting_Click(object sender, EventArgs e) { PrintDialog printd = new PrintDialog(); printd.PrinterSettings.PrinterName = PrinterList.Text; printd.ShowDialog(); } private void Export_Click(object sender, EventArgs e) { if (!dh.CheckExist("make", "ma_code='" + ma_code.Text + "'")) { MessageBox.Show("工单号不存在"); return; } /*DataTable dt = (DataTable)dh.ExecuteSql("select pr_machinetype from make left join product on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'", "select"); if (dt.Rows.Count > 0) { string pr_machinetype = dt.Rows[0]["pr_machinetype"].ToString(); if (pr_machinetype != Prefix.Text) { MessageBox.Show("前缀和产品机型" + pr_machinetype + "不匹配"); return; } }*/ for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 4) { int temp = i; for (int j = 0; j < format.SubStrings.Count; j++) { switch (format.SubStrings[j].Name) { case "RN1": format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString())); 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"); break; case "RN2": format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString())); 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"); break; case "RN3": format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 2).ToString())); 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"); break; case "RN4": format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 3).ToString())); 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"); break; default: break; } } format.PrintSetup.PrinterName = PrinterList.Text; format.PrintSetup.IdenticalCopiesOfLabel = 1; format.Print(); } } private static string lpad(int length, string number) { while (number.Length < length) { number = "0" + number; } number = number.Substring(number.Length - length, length); return number; } private void SystemSetting_PrinterTest_Load(object sender, EventArgs e) { engine.Start(); format = engine.Documents.Open(Application.StartupPath + "/Label.btw"); } } }