mes-client/UAS_MES_ZDXW/FunctionCode/Query/Query_MakeInfo.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_MakeInfo : Form
    {
        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();

        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataTable ComBoxData = new DataTable();

        DataTable Dbfind;
        public Query_MakeInfo()
        {
            InitializeComponent();
        }

        private void Query_OnlineTraceBack_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = SystemInf.dh;

            //工单号放大镜配置
            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,ma_status # 工单状态";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code" };
            ma_code.Condition = "ma_statuscode is not null";
            ma_code.DbChange += Ma_code_DbChange;
        }
        private void Ma_code_DbChange(object sender, EventArgs e)
        {

            Dbfind = ma_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
            Query.PerformClick();
        }

        private void Query_OnlineTraceBack_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void Query_Click(object sender, EventArgs e)
        {
            if (dh.CheckExist("make", "ma_code='" + ma_code.Text + "'") && ma_code.Text != "")
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select * from (select ma_code,ma_status,MA_STATUSCODE from make where ma_code='"+ma_code.Text+"'  order by ma_id desc) where rownum<1000", "select");
                BaseUtil.FillDgvWithDataTable(SnInf, dt);
            }
            else
            {
                MessageBox.Show("工单号" + ma_code.Text + "不存在");
                //BaseUtil.CleanDataGridView(SnInf);
                ma_code.Text = "";
            }
        }

        private void ms_status_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ma_code.Text != "")
                Query.PerformClick();
        }
    }
}