mes-client/UAS_MES_ZT/FunctionCode/Query/Query_SOP.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Query
{
    public partial class Query_SOP : Form
    {

        DataHelper dh = SystemInf.dh;

        public Query_SOP()
        {
            InitializeComponent();
        }

        private void Export_Click(object sender, EventArgs e)
        {

        }

        //选择导出Excel时是选择导出数据的还是模板
        private void ExcelExport(string DataOrTemplet)
        {

        }

        private void Query_SpecialReport_Load(object sender, EventArgs e)
        {

        }

        private void Sn_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyData == Keys.Enter)
            {
                //dh.ExecuteSql("update craftmaterial set cm_status=-1 where cm_barcode='" + Sn.Text + "'", "update");
                //MessageBox.Show("解绑成功");
                DataTable dt = (DataTable)dh.ExecuteSql("select ms_prodcode from makeserial where ms_sncode='" + Sn.Text + "'", "select");
                if (dt.Rows.Count > 0)
                {
                    string prodcode = dt.Rows[0]["ms_prodcode"].ToString();
                    string FilePath = dh.getFieldDataByCondition("SOPDETAIL left join sop on so_id=sod_soid ", "sod_path", "so_prodcode='" + prodcode + "' and sod_stepcode='" + User.CurrentStepCode + "'").ToString();
                    if (FilePath == "")
                    {
                        MessageBox.Show("产品:"+prodcode+"在工序:"+User.CurrentStepName+"无SOP信息");
                    }
                    else
                    {
                        System.Diagnostics.Process.Start(FilePath);
                    }
                }
                else
                {
                    MessageBox.Show("序列号" + Sn.Text + "不存在");
                }
            }
        }
    }
}