mes-client/UAS-MES/FunctionCode/Query/Query_MakeInf.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.DataOperate;
using UAS_MES.PublicMethod;

namespace UAS_MES.Query
{
    public partial class Query_MakeInf : Form
    {

        AutoSizeFormClass asc = new AutoSizeFormClass();
        DataHelper dh;

        public Query_MakeInf()
        {
            InitializeComponent();
        }

        private void Query_MakeInf_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = new DataHelper();
        }

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

        private void Search_Click(object sender, EventArgs e)
        {
            LogStringBuilder sql = new LogStringBuilder();
            sql.Clear();
            sql.Append("select ma_prodcode,ma_qty,ma_craftcode,ma_wccode,ma_salecode,ma_custname,ma_unlimitageqty");
            sql.Append(",ma_softversion,ma_bomversion from make where ma_code='" + MakeCode.Text + "'");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count > 0)
            {
                BaseUtil.SetFormValue(this.Controls, dt);
                string ma_prodcode = dt.Rows[0]["ma_prodcode"].ToString();
                string ma_craftcode = dt.Rows[0]["ma_craftcode"].ToString();
                string ma_bomversion = dt.Rows[0]["ma_bomversion"].ToString();
                string ma_salecode = dt.Rows[0]["ma_salecode"].ToString();
                sql.Clear();
                sql.Append("select pr_code,pr_outboxinnerqty,case pr_sendchecktype when 'SaleCode' then '按合同送检' when 'LineCode' then '按线别送检' end pr_sendchecktype,pr_detail,pr_agingtime");
                sql.Append(",(pr_colorboxminw||'-'||pr_colorboxmaxw||' '||pr_colorboxunit)pr_colorboxweight,");
                sql.Append("(pr_cartonminw||'-'||pr_cartonmaxw||' '||pr_cartonunit)pr_cartonweight from product where pr_code='" + ma_prodcode + "'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.SetFormValue(this.Controls, dt);
                }
                sql.Clear();
                sql.Append("select * from craftdetail left join craft on cd_crid=cr_id where cr_code='" + ma_craftcode + "' and cr_prodcode='" + ma_prodcode + "' order by cd_detno");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.FillDgvWithDataTable(Carft, dt);
                }
                sql.Clear();
                sql.Append("select (msr_startno||'-'||msr_endno) beforesnrange,msr_qty beforesnqty from makesnrule where msr_makecode='" + MakeCode.Text + "' and msr_type='before'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.SetFormValue(this.Controls, dt);
                }
                sql.Clear();
                sql.Append("select (msr_startno||'-'||msr_endno) aftersnrange,msr_qty aftersnqty from makesnrule where msr_makecode='" + MakeCode.Text + "' and msr_type='after'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.SetFormValue(this.Controls, dt);
                }
                //获取SN关联信息
                MacNum.Text = dh.getFieldDataByCondition("Makeaddresslist", "count(1)", "mal_makecode='" + MakeCode.Text + "' and mal_mac is not null").ToString();
                BTNum.Text = dh.getFieldDataByCondition("Makeaddresslist", "count(1)", "mal_makecode='" + MakeCode.Text + "' and mal_bt is not null").ToString();
                IMEINum.Text = dh.getFieldDataByCondition("Makeimeilist", "count(1)", "mil_makecode='" + MakeCode.Text + "' and mil_imei1 is not null").ToString();
                sql.Clear();
                sql.Append("select * from StepProduct left join product on pr_code=sp_soncode where sp_bomversion='" + ma_bomversion + "' and sp_mothercode='" + ma_prodcode + "' and sp_craftcode='" + ma_craftcode + "'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.FillDgvWithDataTable(BOM, dt);
                }
                sql.Clear();
                sql.Append("select * from label where la_prodcode='" + ma_prodcode + "'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.FillDgvWithDataTable(Label, dt);
                }
            }
            else MessageBox.Show("工单号不存在");
        }
    }
}