private void btnHelp2_Click(object sender, EventArgs e)
        {
            clsASRS.gsHelpStyle = "LOC_E";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);
            clsASRS.gsHelpRtnData[0] = "";

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            if (clsASRS.gsHelpRtnData[0] != "")
            {
                string[] aData = new string[0];
                aData         = clsASRS.gsHelpRtnData[0].Split(',');
                txtLoc.Text   = aData[0];
                txtLocID.Text = aData[1];

                if (FunGetLoc() == true)
                {
                    txtLoc.Enabled   = false;
                    txtLocID.Enabled = false;
                    btnHelp1.Enabled = false;
                    btnHelp2.Enabled = false;
                    cmdQuery.Enabled = false;
                }
            }
        }
        private void btnQuery_Click(object sender, EventArgs e)
        {
            string strSql = ""; DbDataReader dbRS = null;

            clsASRS.gsHelpStyle = "ACCID";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);
            clsASRS.gsHelpRtnData[0] = "";

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            string sACCID = clsASRS.gsHelpRtnData[0];

            if (sACCID != "")
            {
                if (clsDB.FunOpenDB() == false)
                {
                    clsMSG.ShowErrMsg(clsMSG.MSG.OPEN_DB_NG); return;
                }
                ;

                strSql = "SELECT * FROM TRNTKT_ACC WHERE ACC_ID = '" + sACCID + "' ";
                if (clsDB.FunRsSql(strSql, ref dbRS))
                {
                    while (dbRS.Read())
                    {
                        Grid2.Rows.Add();
                        Grid2.Rows[Grid2.Rows.Count - 1].HeaderCell.Value  = "*";
                        Grid2[iCol2_ACCID, Grid2.Rows.Count - 1].Value     = dbRS["ACC_ID"].ToString();
                        Grid2[iCol2_STYLE, Grid2.Rows.Count - 1].Value     = dbRS["STORE"].ToString();
                        Grid2[iCol2_CUST, Grid2.Rows.Count - 1].Value      = dbRS["CUSTOMER"].ToString();
                        Grid2[iCol2_ITEM, Grid2.Rows.Count - 1].Value      = dbRS["ITEMNO"].ToString();
                        Grid2[iCol2_DEV, Grid2.Rows.Count - 1].Value       = dbRS["DEVICE"].ToString();
                        Grid2[iCol2_LotNo, Grid2.Rows.Count - 1].Value     = dbRS["LOTNO"].ToString();
                        Grid2[iCol2_OffQty, Grid2.Rows.Count - 1].Value    = dbRS["OFFQTY"].ToString();
                        Grid2[iCol2_WaferQty, Grid2.Rows.Count - 1].Value  = dbRS["WAFERQTY"].ToString();
                        Grid2[iCol2_ShipQty, Grid2.Rows.Count - 1].Value   = dbRS["SHIPQTY"].ToString();
                        Grid2[iCol2_Remark, Grid2.Rows.Count - 1].Value    = dbRS["REMARK"].ToString();
                        Grid2[iCol2_StrInDate, Grid2.Rows.Count - 1].Value = dbRS["TRANSACTION_DATE"].ToString();

                        Grid2[iCol2_Vendor, Grid2.Rows.Count - 1].Value  = dbRS["GIB_CUSTOMER"].ToString();
                        Grid2[iCol2_FabLot, Grid2.Rows.Count - 1].Value  = dbRS["FAB_LOT_NO"].ToString();
                        Grid2[iCol2_MASK, Grid2.Rows.Count - 1].Value    = dbRS["TYPENO"].ToString();
                        Grid2[iCol2_LotType, Grid2.Rows.Count - 1].Value = dbRS["LOT_TYPE"].ToString();
                        Grid2[iCol2_Size, Grid2.Rows.Count - 1].Value    = dbRS["WAFER_SIZE"].ToString();
                        Grid2[iCol2_Rate, Grid2.Rows.Count - 1].Value    = dbRS["YIELD"].ToString();

                        SubSetGridColor(ref Grid2, Grid2.Rows.Count - 1);
                    }
                    dbRS.Close();
                }

                clsDB.FunClsDB();
            }
        }
Exemple #3
0
        private void btnHelp_Device2_Click(object sender, EventArgs e)
        {
            clsASRS.gsHelpStyle = "DEVICE";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtDeviceT.Text = clsASRS.gsHelpRtnData[0];
        }
Exemple #4
0
        private void btnHelp_Item2_Click(object sender, EventArgs e)
        {
            clsASRS.gsHelpStyle = "ITEM";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtItemNoT.Text = clsASRS.gsHelpRtnData[0];
        }
Exemple #5
0
        private void btnHelp_LotNo1_Click(object sender, EventArgs e)
        {
            clsASRS.gsHelpStyle = "LOTNO";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtLotNoF.Text = clsASRS.gsHelpRtnData[0];
        }
Exemple #6
0
        private void btnHelp_LotNo2_Click(object sender, EventArgs e)
        {
            //clsTool.showForm(txtLotNo1, "LOTNO", "CMD_DTL");
            clsASRS.gsHelpStyle = "LOTNO";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtLotNo1.Text = clsASRS.gsHelpRtnData[0];
        }
Exemple #7
0
        private void btnHelp_Item1_Click(object sender, EventArgs e)
        {
            //clsTool.showForm(txtItem0, "ITEMNO", "CMD_DTL");
            clsASRS.gsHelpStyle = "ITEM";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtItem0.Text = clsASRS.gsHelpRtnData[0];
        }
Exemple #8
0
        private void btnHelp_FOSB2_Click(object sender, EventArgs e)
        {
            //clsTool.showForm(txtFosbID1, "FOSBID", "CMD_DTL");
            clsASRS.gsHelpStyle = "FOSB";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtFosbID1.Text = clsASRS.gsHelpRtnData[0];
        }
Exemple #9
0
        private void btnHelp_Click(object sender, EventArgs e)
        {
            clsASRS.gsHelpStyle      = "CYCLE_SET_TYPE";
            clsASRS.gsHelpStyle_Data = clsTool.FunGetComineData(cboCycType.Text);
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 2);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtTypeNo.Text = clsASRS.gsHelpRtnData[0];
            txtType.Text   = clsASRS.gsHelpRtnData[1];

            if (clsASRS.gsHelpRtnData[0] != "")
            {
                if (clsDB.FunOpenDB() == false)
                {
                    clsMSG.ShowErrMsg(clsMSG.MSG.OPEN_DB_NG); return;
                }
                ;

                string strSQL = ""; DbDataReader dbRS = null;
                strSQL = "SELECT * FROM CYCLE_SET ";
                strSQL = strSQL + "WHERE CYCLE_TYPE = '" + clsTool.FunGetComineData(cboCycType.Text) + "' ";
                strSQL = strSQL + "AND TYPE_NO = '" + clsASRS.gsHelpRtnData[0] + "' ";
                if (clsDB.FunRsSql(strSQL, ref dbRS))
                {
                    while (dbRS.Read())
                    {
                        cboCust.Text    = dbRS["CUST"].ToString();
                        cboCustGrp.Text = dbRS["CUST_GROUP"].ToString();
                        cboFabIn.Text   = FunGetFabInTime(dbRS["FAB_IN_TIME"].ToString());
                        if (dbRS["CIRCULATE"].ToString() == "Y")
                        {
                            rdbCir.Checked    = true;
                            rdbSingle.Checked = false;
                        }
                        else
                        {
                            rdbCir.Checked    = false;
                            rdbSingle.Checked = true;
                        }

                        txtTime.Text       = dbRS["CIR_CNT"].ToString();
                        cboTime.Text       = dbRS["CIR_TIME"].ToString();
                        txtTransDate1.Text = dbRS["START_TIME"].ToString();
                    }
                    dbRS.Close();
                }

                clsDB.FunClsDB();
            }
        }
Exemple #10
0
        private void btnHelp_Device2_Click(object sender, EventArgs e)
        {
            //clsTool.showForm(txtDevice2, "DEVICE", "LOC_DTL");

            clsASRS.gsHelpStyle = "DEVICE";
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 1);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtDevice2.Text = clsASRS.gsHelpRtnData[0];
        }
Exemple #11
0
        private void btnHelp2_Click(object sender, EventArgs e)
        {
            if (cboCrnNo.Text == "")
            {
                return;
            }

            clsASRS.gsHelpStyle      = "LOC_N";
            clsASRS.gsHelpStyle_Data = cboCrnNo.Text;
            Array.Resize <string>(ref clsASRS.gsHelpRtnData, 0);

            frmHelp frmHelp = new frmHelp();

            frmHelp.ShowDialog();

            txtLoc2.Text = clsASRS.gsHelpRtnData[0];
        }