mes-client/UAS-MES/FunctionCode/Make/Make_CustomLabelPrint.cs

using LabelManager2;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.PublicForm;
using UAS_MES.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_CustomLabelPrint : Form
    {
        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();

        AutoSizeFormClass asc = new AutoSizeFormClass();

        ApplicationClass lbl;

        Thread InitPrint;
        //存放产品信息
        DataTable dt;
        //存放标签信息
        DataTable listA;
        //存放标签参数列表信息
        DataTable paramsInfo;
        //记录当前的步骤数
        int currentIndex = 0;

        Document doc;

        FileInfo info;

        ftpOperater ftp;

        System.DateTime[] indate;

        StringBuilder sb = new StringBuilder();
        public Make_CustomLabelPrint()
        {
            InitializeComponent();
        }

        private void Make_CustomLablePrint_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            inputText.Focus();
            asc.controllInitializeSize(this);
            OperateResult.AppendText(">>请输入产品代码\n", Color.Black);
            InitPrint = new Thread(InPrint);
            SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();
        }
        private void InPrint()
        {
            try
            {
                lbl = new ApplicationClass();
                BaseUtil.WriteLbl(lbl);
            }
            catch (Exception ex)
            {
                OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
            }
        }

        private void pr_code_KeyDown(object sender, KeyEventArgs e)
        {
            //按下enter键
            if (e.KeyCode == Keys.Enter)
            {
                //判断产品是否存在
                dt = (DataTable)dh.ExecuteSql("select pr_code,pr_detail,pr_spec from product where pr_code='" + pr_code.Text + "'  and pr_statuscode ='AUDITED'", "select");
                //查询没有值，返回提示用户“产品：XXX,不存在或者为审核”，清空产品代码输入框中的值 
                if (dt.Rows.Count == 0)
                {
                    OperateResult.AppendText("<<产品：" + pr_code.Text + ",不存在或者为审核\n", Color.Red);
                    pr_code.Text = "";
                    return;
                }
                //查询产品是否有自定义的标签模板
                listA = (DataTable)dh.ExecuteSql("select pl_labelcode ||':'||pl_labelname pl_name,pl_id,pl_labeltype,pl_labelcode,pl_labelurl,pl_isdefault,pl_detno,pl_labelsoft,pl_status,pl_statuscode,pl_labelname,pl_indate from  productlabel where pl_prodcode='" + pr_code.Text + "' and pl_labeltype='自定义' order by pl_isdefault desc", "select");
                if (listA.Rows.Count == 0)
                {
                    OperateResult.AppendText("<<产品：" + pr_code.Text + ",没有维护自定义模板\n", Color.Red);
                    pr_code.Text = "";
                    return;
                }
                if (listA.Rows[0]["pl_isdefault"].ToString() != "1") {
                    //说明没有默认的模板，那就取pl_id最大的
                    listA = (DataTable)dh.ExecuteSql("select pl_labelcode ||':'||pl_labelname pl_name,pl_id,pl_labeltype,pl_labelcode,pl_labelurl,pl_isdefault,pl_detno,pl_labelsoft,pl_status,pl_statuscode,pl_labelname,pl_indate from  productlabel where pl_prodcode='" + pr_code.Text + "' and pl_labeltype='自定义' order by pl_id desc", "select");
                }
                //标签显示
                PrintLabel.DataSource = listA;
                PrintLabel.DisplayMember = "pl_name";
                PrintLabel.ValueMember = "pl_labelcode";
                //下载标签
                getLabels();
                //有值，填充界面
                BaseUtil.SetFormValue(this.Controls, dt);
                //paramsInfo = (DataTable)dh.ExecuteSql("select lp_detno, lp_name, lp_valuetype,lp_sql from label left join labelparameter on lp_laid=la_id where la_code='"+ listA.Rows[0]["pl_labelcode"].ToString() + "' order by lp_detno asc", "select");
                if (paramsInfo.Rows.Count > 0)
                {
                    //根据查询出来的参数，一次提示用户, “<<SN001 “, 
                    //“>> 请输入自定义模板的(XXXX参数名称)lp_name”
                    OperateResult.AppendText("<<" + listA.Rows[0]["pl_labelcode"].ToString() + "\n", Color.Black);
                    OperateResult.AppendText(">>请输入自定义模板参数名为:" + paramsInfo.Rows[0]["lp_name"].ToString() + "的值\n", Color.Green);
                    //打开模板路径
                    doc = lbl.Documents.Open(ftpOperater.DownLoadTo + PrintLabel.Text.Split(':')[1]);
                    currentIndex = 1;
                }
                else
                {
                    OperateResult.AppendText("<<标签编号：" + listA.Rows[0]["pl_labelcode"].ToString() + "无标签参数\n", Color.Red);
                }
            }
        }

        private void inputText_KeyDown(object sender, KeyEventArgs e)
        {
            //按下enter键
            if (e.KeyCode == Keys.Enter)
            {
                //产品编号为空
                if (pr_code.Text.Trim() == "")
                {
                    OperateResult.AppendText("<<请先输入产品编号\n", Color.Red);
                    return;
                }
                if (inputText.Text.Trim() == "")
                {
                    OperateResult.AppendText("<<输入不能为空\n", Color.Red);
                    return;
                }
                if (paramsInfo == null || paramsInfo.Rows.Count == 0)
                {
                    OperateResult.AppendText("<<未维护标签参数\n", Color.Red);
                }
                else
                {
                    if (doc==null) {
                        OperateResult.AppendText(">>标签无效\n", Color.Red);
                        return;
                    }
                    //将值赋到doc对应的变量
                    for (int i = 0; i < doc.Variables.FormVariables.Count; i++)
                    {
                        //找到对应的变量名
                        if (doc.Variables.FormVariables.Item(i + 1).Name == paramsInfo.Rows[currentIndex - 1]["lp_name"].ToString())
                        {
                            //如果当时采集行的 lp_valuetype=’INPUT’,并且lp_sql 为空，则直接将采集的值赋给标签打印
                            if (paramsInfo.Rows[currentIndex - 1]["lp_valuetype"].ToString() == "INPUT" && paramsInfo.Rows[currentIndex - 1]["lp_sql"].ToString() == "")
                            {
                                doc.Variables.FormVariables.Item(i + 1).Value = inputText.Text;
                            }
                            else
                            {
                                //取sql拿值赋给变量
                                string sql = paramsInfo.Rows[currentIndex - 1]["lp_sql"].ToString();
                                sql = sql.Substring(0, sql.IndexOf("{")) + "'" + inputText.Text + "'";
                                doc.Variables.FormVariables.Item(i + 1).Value = dh.GetLabelParam(sql).ToString();
                                sb.AppendLine("打印参数【" + doc.Variables.FormVariables.Item(i + 1).Name + "】赋值，" + "取值SQL:" + sql + "，取到值" + doc.Variables.FormVariables.Item(i + 1).Value);
                            }
                        }
                    }
                    if (currentIndex == paramsInfo.Rows.Count)
                    {
                        OperateResult.AppendText("<<输入完成，正在打印\n", Color.Black);
                        //打印
                        LogManager.DoLog(sb.ToString());
                        //保存本次赋值进行打印
                        doc.Save();
                        doc.Printer.SwitchTo(Printer.Text);
                        doc.PrintDocument(int.Parse(printNum.Text));
                        doc.Close();
                        //讲文件最后写入时间改成数据库中拿到的时间
                        info = new FileInfo(ftpOperater.DownLoadTo + PrintLabel.Text.Split(':')[1]);
                        info.LastWriteTime = indate[PrintLabel.SelectedIndex];
                        //打印成功
                        OperateResult.AppendText("<<打印成功\n", Color.Green);
                        //重置currenIndex为1
                        currentIndex = 1;
                        OperateResult.AppendText(">>请输入自定义模板参数名为:" + paramsInfo.Rows[0]["lp_name"].ToString() + "的值\n", Color.Green);
                    }
                    else
                    {
                        currentIndex++;
                        OperateResult.AppendText("<<请输入模板参数名为:" + paramsInfo.Rows[currentIndex - 1]["lp_name"].ToString() + "的值\n", Color.Green);
                    }
                }
            }
        }

        private void getLabels()
        {
            ftp = new ftpOperater();
            indate = new System.DateTime[listA.Rows.Count];
            for (int i = 0; i < listA.Rows.Count; i++)
            {
                BaseUtil.GetPrintLabel(listA.Rows[i]["pl_labelname"].ToString(), listA.Rows[i]["pl_labelurl"].ToString(), listA.Rows[i]["pl_indate"].ToString());
                indate[i] = Convert.ToDateTime(listA.Rows[i]["pl_indate"].ToString());
            }
        }

        private void PrintLabel_TextChanged(object sender, EventArgs e)
        {
            paramsInfo = (DataTable)dh.ExecuteSql("select lp_detno, lp_name, lp_valuetype,lp_sql from label left join labelparameter on lp_laid=la_id where la_code='" + PrintLabel.SelectedValue.ToString() + "' order by lp_detno asc", "select");
        }
    }
}