mes-client/UAS_MES_YD/FunctionCode/Query/Query_SN.cs

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)
        {

        }
    }
}