コード例 #1
0
        private void btnRemove_Click(object sender, EventArgs e)
        {
            if (cmdOp.SelectedIndex > -1)
            {
                Operations    op        = new Operations();
                SqlStatements sqlUpdate = new SqlStatements();
                //NEEDS TO CHECK CELL VALUE
                Boolean checkGrid = GridCheck(cmdOp.Text);
                if (checkGrid == true)
                {
                    MessageBox.Show("This operation has not been completed so cannot be removed.", "Cannot Remove", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    int    finishType = Int32.Parse(this.txtFinishID.Text);
                    string short_op   = "";

                    //DELETE FROM COMPLETION LOG
                    sqlUpdate.DeletePartCompletion(Int32.Parse(txtSearch.Text), cmdOp.Text.ToString());


                    //ADD BACK TO DOOR

                    switch (cmdOp.SelectedItem)
                    {
                    case "Up":
                        short_op = "up";
                        break;

                    case "Wash/Wipe":
                        short_op = "ww";
                        break;

                    case "Etch":
                        short_op = "etch";
                        break;

                    case "Sand":
                        short_op = "sand";
                        break;

                    case "Powder Prime":
                        short_op = "pp";
                        break;

                    case "Powder Coat":
                        short_op = "pc";
                        break;

                    case "Oven":
                        short_op = "oven";
                        break;

                    case "Wet Prep":
                        short_op = "wp";
                        break;

                    case "Wet Paint":
                        short_op = "wet";
                        break;

                    case "Oven 2":
                        short_op = "oven1";
                        break;

                    default:
                        MessageBox.Show("No operation has been selected!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        break;
                    }

                    sqlUpdate.AddToDoor(Int32.Parse(txtSearch.Text), op.CalcTimeRemaining(Int32.Parse(txtSearch.Text), cmdOp.Text.ToString(), finishType) / int.Parse(txtQuantitySame.Text), short_op);


                    //Remove from daily goals

                    sqlUpdate.DeductDailyGoals(op.CalcTimeRemaining(Int32.Parse(txtSearch.Text), cmdOp.Text.ToString(), finishType));
                    //btnSearch_Click(sender, e);

                    //REFRESH THE MAIN DATAGRID
                    RefreshMainGrid();
                }
            }
            else
            {
                MessageBox.Show("You must select an operation to continue!", "No operation", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }