mes-client/UAS-MES/FunctionCode/Make/Make_Repair.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_Repair : Form
    {

        string caller = "Make!Repair";
        //记录维修结果的代码值
        string Repair_Result;
        //记录不良状态码
        string badcode;
        //记录不良组别
        string groupcode;
        //判断是否获取了下拉框的值 
        string mb_id1;
        //记录插入操作日志表的sql
        string cm_makecode;
        //执行插入日志的SQL
        string insert_makeprocess = "insert into makeprocess(mp_id,mp_makecode,mp_maid, mp_mscode,mp_sncode,mp_stepcode,mp_stepname,mp_craftcode,mp_craftname,mp_kind,mp_result,mp_indate,mp_inman,mp_wccode,mp_linecode,mp_sourcecode) select MakeProcess_seq.nextval, ma_code,ma_id,ms_code,ms_sncode,mcd_stepcode,mcd_stepname,ma_craftcode,'','维修作业','#',sysdate,'" + User.UserName + "',ma_wccode,ma_linecode,'' from make left join makecraftdetail on mcd_macode=ma_code left join makeserial on ms_makecode=ma_code where ms_sncode=:ms_sncode and ma_code=:ma_code";
        //是否获取过下拉框数据
        bool GetSelectData = false;

        DataHelper dh = null;

        LogStringBuilder sql = new LogStringBuilder();

        List<string> sqls = new List<string>();

        DataTable dt = null;

        AutoSizeFormClass asc = new AutoSizeFormClass();

        public Make_Repair()
        {
            InitializeComponent();
            //为DBFind配置Call和Form的名称
            cr_code.FormName = Name;
            cr_code.TableName = "craft";
            cr_code.SelectField = "cr_name # 工艺名称 ,cr_code # 工艺编号,cr_prodcode # 物料编号";
            cr_code.SetValueField = new string[] { "cr_code" };

            cd_stepcode.FormName = Name;
            cd_stepcode.TableName = "craftdetail left join step on st_code=cd_stepcode left join craft on cd_crid=cr_id";
            cd_stepcode.SetValueField = new string[] { "cd_stepcode" };
            cd_stepcode.SelectField = "cd_stepname # 工序名称 ,cd_stepcode # 工序编号,cd_stepno # 执行顺序";
            cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "'";
        }

        private void 维修作业_Load(object sender, EventArgs e)
        {
            //添加不良信息的静态数据
            asc.controllInitializeSize(this);
        }

        private void GetSNCode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            { }
        }

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

        private void BadCodeGrid_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {

        }
    }
}