mes-client/UAS-MES/FunctionCode/Make/Make_Decompose.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.Make
{
    public partial class Make_Decompose : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataTable dt;

        LogStringBuilder sql = new LogStringBuilder();

        DataHelper dh;
        //记录当前序列号的ms_id
        string ms_id;

        //采集计数
        int count;

        public Make_Decompose()
        {
            InitializeComponent();
        }

        private void Make_Decompose_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = new DataHelper();
            sn_code.Focus();
            OperateResult.AppendText(">>请输入序列号\n");
            count = 0;
            deccount.Text = count + "";
        }

        private void sn_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                sql.Clear();
                sql.Append("select max(ms_id) from makeserial where ms_sncode ='"+sn_code.Text+"' or  exists (select 1");
                sql.Append(" from  makesnrelation where beforesn='"+ sn_code.Text + "'  and ms_makecode=makecode)");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                ms_id = dt.Rows[0][0].ToString();
                if (ms_id != "")
                {  
                    sql.Clear();
                    sql.Append("select ms_id,ms_status,ms_makecode,ms_prodcode,pr_detail ||',' || pr_spec pr_name ,ms_sncode from makeserial left join product on pr_code=ms_prodcode where ms_id='" + ms_id + "'");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    BaseUtil.SetFormValue(this.Controls, dt);
                    sql.Clear();
                    sql.Append("");
                }
                else {
                    ms_id = null;
                    OperateResult.AppendText(">>序列号不存在\n",Color.Red);
                    sn_code.Text = "";
                    BaseUtil.CleanForm(this);
                    sn_code.Focus();
                    return;
                }
            }
        }


        private void LoadData()
        {
           //如果没有任何筛选条件直接选取productlabel的数据
           sql.Clear();
           sql.Append("select la_id,pl_labelname,pl_labelurl,pl_labeltype,pl_isdefault,pl_prodcode,pl_id,pl_labelcode,pl_detno,pl_labelsoft,pr_detail,pr_spec,");
           sql.Append("pr_code from productlabel left join product on pl_prodcode=pr_code left join label on pl_labelcode=la_code");
           dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");         
           BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt);
           string Field = BaseUtil.GetGridViewSelectContent(LabelDataGridView);
        }


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

     
    }
}