Beispiel #1
0
        public void LoadDataNG()
        {
            frm_Loading loading = new frm_Loading();

            loading.ShowDialog();
            string    sql = "SELECT id,Wodate,shift,keycode,modelcode,modelcheck,checktime,linename,empname FROM tb_datamix where wodate between '" + fromdate + "' and '" + todate + "' and shift like '%" + GetShift() + "%' and modelcode like '%" + txtCheck.Text.Trim().ToUpper() + "%'";
            DataTable dt  = conn.GetDataTable(sql);

            dgvNG.DataSource = dt;
        }
Beispiel #2
0
        //DataTable datagood,datang;
        public void LoadData()
        {
            frm_Loading loading = new frm_Loading();

            loading.ShowDialog();
            string    sql = "SELECT Wodate,shift,keycode,modelcode,goodqty,defqty,mixqty,total,starttime,endtime,linename,empname FROM tb_datachecked where wodate between '" + fromdate + "' and '" + todate + "' and shift like '%" + GetShift() + "%' and modelcode like '%" + txtCheck.Text.Trim().ToUpper() + "%' order by wodate desc,starttime desc";
            DataTable dt  = conn.GetDataTable(sql);

            dgvData.DataSource = dt;
        }