mes-client/UAS_MES_ZT/FunctionCode/Query/Query_Employee.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_Employee : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();
        DataHelper dh;

        public Query_Employee()
        {
            InitializeComponent();
        }

        private void Query_Employee_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh  = SystemInf.dh;
            LogStringBuilder sql = new LogStringBuilder();
            sql.Clear();
            sql.Append("select WC_NAME,HOURTIME,投入,产出,不良,直通率 from MES_MAKEEMHOUR_VIEW where sp_ymd = trunc(sysdate) and sp_linecode = '"+User.UserLineCode+"' AND SP_STEPCODE = '"+User.CurrentStepCode+"' AND SP_INMAN = '"+User.UserCode+"' ");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BaseUtil.FillDgvWithDataTable(BOM, dt);
        }

        private void Query_Employee_SizeChanged(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
        }
    }
}