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);
                    LoadData();
                }
                else {
                    ms_id = null;
                    OperateResult.AppendText(">>序列号"+ms_sncode.Text+"不存在\n",Color.Red);
                    sn_code.Text = "";
                    BaseUtil.CleanForm(this);
                    sn_code.Focus();
                    return;
                }
            }
        }


        private void LoadData()
        {
           //如果没有任何筛选条件直接选取productlabel的数据
            sql.Clear();
            sql.Append("select cm_sncode,cm_maprodcode,cm_id,cm_soncode,cm_barcode,pr_detail from craftmaterial left join product on pr_code=cm_soncode where");
            sql.Append(" cm_sncode='" + ms_sncode.Text + "' and cm_maprodcode='" + ms_prodcode.Text + "' and  nvl(cm_status,0)='0'");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count > 0)
            {
                BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt);
            }
            else {
                OperateResult.AppendText(">>序列号"+sn_code.Text+"无上料数据\n", Color.Red);              
            }
        }


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

        private void LabelDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
          
        }

        private void LabelDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (LabelDataGridView.Columns[e.ColumnIndex].HeaderText == "拆解更料")
            {
                if (LabelDataGridView.Rows[e.RowIndex].Cells["Choose2"].Value != null)
                {
                    if (LabelDataGridView.Rows[e.RowIndex].Cells["Choose2"].Value is Boolean)
                    {
                        LabelDataGridView.Rows[e.RowIndex].Cells["Choose2"].Value = 1;
                    }
                    if (LabelDataGridView.Rows[e.RowIndex].Cells["Choose2"].Value is int)
                    {
                        LabelDataGridView.Rows[e.RowIndex].Cells["Choose2"].Value = 0;
                    }
                }
            }
            else if (LabelDataGridView.Columns[e.ColumnIndex].HeaderText == "拆解")
            {
                if (LabelDataGridView.Rows[e.RowIndex].Cells["Choose"].Value != null)
                {
                    if (LabelDataGridView.Rows[e.RowIndex].Cells["Choose"].Value is Boolean)
                    {
                        LabelDataGridView.Rows[e.RowIndex].Cells["Choose"].Value = 1;
                    }
                    if (LabelDataGridView.Rows[e.RowIndex].Cells["Choose"].Value is int)
                    {
                        LabelDataGridView.Rows[e.RowIndex].Cells["Choose"].Value = 0;
                    }
                }
            }
            else if (LabelDataGridView.Columns[e.ColumnIndex].Name == "AddBad")
            {
                MessageBox.Show("点击");
            }
        }
    }
}