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.Text.RegularExpressions; using System.Windows.Forms; using UAS_MES_NEW.DataOperate; using UAS_MES_NEW.Entity; using UAS_MES_NEW.PublicMethod; using UAS_MES_NEW.Query; using static System.Runtime.CompilerServices.RuntimeHelpers; namespace UAS_MES_NEW.Query { public partial class Query_SN : Form { int serialnum = 0; //客户的流水号 int custserialnum = 0; Engine engine = new Engine(); LabelFormatDocument format; DataHelper dh = SystemInf.dh; DataTable Dbfind; public Query_SN() { 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 msl_sncode from makesnlist where msl_makecode='" + ma_code.Text + "'", "select"); if (dt.Rows.Count == 0) { MessageBox.Show("工单号未生成SN"); return; } if (OneColumn.Checked) { format = engine.Documents.Open(Application.StartupPath + "/单排.btw"); for (int i = 0; i < dt.Rows.Count; i = i + 1) { int temp = i; for (int j = 0; j < format.SubStrings.Count; j++) { switch (format.SubStrings[j].Name) { case "SN": format.SubStrings[j].Value = dt.Rows[i]["msl_sncode"].ToString(); break; default: break; } } format.PrintSetup.PrinterName = PrinterList.Text; format.PrintSetup.IdenticalCopiesOfLabel = 1; format.Print(); } } if (TwoColumn.Checked) { format = engine.Documents.Open(Application.StartupPath + "/双排.btw"); for (int i = 0; i < dt.Rows.Count; i = i + 2) { int temp = i; for (int j = 0; j < format.SubStrings.Count; j++) { switch (format.SubStrings[j].Name) { case "SN": format.SubStrings[j].Value = dt.Rows[i]["msl_sncode"].ToString(); break; case "SN2": format.SubStrings[j].Value = dt.Rows[i + 1]["msl_sncode"].ToString(); break; default: break; } } format.PrintSetup.PrinterName = PrinterList.Text; format.PrintSetup.IdenticalCopiesOfLabel = 1; format.Print(); } } if (ThreeColumn.Checked) { format = engine.Documents.Open(Application.StartupPath + "/Label.btw"); for (int i = 0; i < dt.Rows.Count; i = i + 3) { int temp = i; for (int j = 0; j < format.SubStrings.Count; j++) { switch (format.SubStrings[j].Name) { case "SN": format.SubStrings[j].Value = dt.Rows[i]["msl_sncode"].ToString(); break; case "SN2": format.SubStrings[j].Value = dt.Rows[i + 1]["msl_sncode"].ToString(); break; case "SN3": format.SubStrings[j].Value = dt.Rows[i + 2]["msl_sncode"].ToString(); break; default: break; } } format.PrintSetup.PrinterName = PrinterList.Text; format.PrintSetup.IdenticalCopiesOfLabel = 1; format.Print(); } } if (FourColumn.Checked) { format = engine.Documents.Open(Application.StartupPath + "/四排.btw"); for (int i = 0; i < dt.Rows.Count; i = i + 4) { int temp = i; for (int j = 0; j < format.SubStrings.Count; j++) { switch (format.SubStrings[j].Name) { case "SN": format.SubStrings[j].Value = dt.Rows[i]["msl_sncode"].ToString(); break; case "SN2": format.SubStrings[j].Value = dt.Rows[i + 1]["msl_sncode"].ToString(); break; case "SN3": format.SubStrings[j].Value = dt.Rows[i + 2]["msl_sncode"].ToString(); break; case "SN4": format.SubStrings[j].Value = dt.Rows[i + 3]["msl_sncode"].ToString(); break; default: break; } } format.PrintSetup.PrinterName = PrinterList.Text; format.PrintSetup.IdenticalCopiesOfLabel = 1; format.Print(); } } } public string BarcodeMethod1(string Prefix, string Suffix, int Index, int Length, int radix) { string str = Prefix; //如果是流水则需要在前面加0 string serialcode = BaseUtil.DToAny(custserialnum, radix); for (int j = serialcode.ToString().Length; j < Length; j++) { serialcode = "0" + serialcode; } str += serialcode; str += Suffix; custserialnum = custserialnum + 1; return str; } 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(); ma_code.TableName = " make left join product on ma_prodcode=pr_code"; ma_code.SelectField = "ma_code # 工单编号,pr_code # 产品编号,pr_spec # 型号"; ma_code.FormName = Name; ma_code.SetValueField = new string[] { "ma_code" }; ma_code.Condition = "ma_statuscode='STARTED'"; ma_code.DbChange += pr_code_DbChange; } private void pr_code_DbChange(object sender, EventArgs e) { Dbfind = ma_code.ReturnData; BaseUtil.SetFormValue(this.Controls, Dbfind); DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,mil_makecode from makeimeilist where mil_printstatus=-1 group by mil_makecode) on mil_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select"); if (dt.Rows.Count > 0) { pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString(); ma_qty.Text = dt.Rows[0]["ma_qty"].ToString(); ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString(); pr_detail.Text = dt.Rows[0]["pr_detail"].ToString(); } } private void GenSN_Click(object sender, EventArgs e) { } } }