예제 #1
0
        private void bt_complete_Click(object sender, EventArgs e)
        {
            if (Public.Sum_of_percent_complete == 1)
            {
                MessageBox.Show("This door is marked as complete!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            DialogResult complete = MessageBox.Show("Mark Job As Complete?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (complete == DialogResult.Yes)
            {
                Public.order_database.Open();
                SqlCommand job_complete    = new SqlCommand("Update dbo.door SET " + Public.date_op_complete + " = @date, " + Public.operation_remaining_name + " = 0, complete_" + Public.Operation + " = -1 WHERE id = @door_id", Public.order_database);
                SqlCommand completion_log  = new SqlCommand(Public.insert_completion_log, Public.order_database);
                SqlCommand department_goal = new SqlCommand(Public.update_department_goal, Public.order_database);

                job_complete.Parameters.AddWithValue("@date", DateTime.Now);
                job_complete.Parameters.AddWithValue("@door_id", Public.second_validation_door_id);


                completion_log.Parameters.AddWithValue("@id", Public.second_validation_door_id);
                completion_log.Parameters.AddWithValue("@date", DateTime.Now);
                completion_log.Parameters.AddWithValue("@part_time", Public.operation_time + ".0");
                completion_log.Parameters.AddWithValue("@part", Public.Operation);
                completion_log.Parameters.AddWithValue("@part_status", "Complete");
                completion_log.Parameters.AddWithValue("@op", Public.Operation_log);
                completion_log.Parameters.AddWithValue("@staff_id", cmb_staff.SelectedValue.ToString());
                completion_log.Parameters.AddWithValue("@percent", 1 - (Public.Sum_of_percent_complete));

                department_goal.Parameters.AddWithValue("@date", Public.sqlFormattedDate);
                department_goal.Parameters.AddWithValue("@time_for_part", (Convert.ToDouble(Public.operation_time)) / 60);

                completion_log.ExecuteNonQuery();
                job_complete.ExecuteNonQuery();
                department_goal.ExecuteNonQuery();
                this.Hide();
                if (Public.Operation == "pack")
                {
                    additional_info info = new additional_info();
                    info.Show();
                }
                if (Public.Operation == "SL_buff")
                {
                    //Stock_door_check();
                }

                Public.order_database.Close();
            }
            if (complete == DialogResult.No)

            {
                Public.staff_selection = cmb_staff.SelectedIndex.ToString();
                Part_complete form = new Part_complete();
                form.Show();
                this.Hide();
            }
        }
예제 #2
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            additional_info info = new additional_info();

            info.Show();
        }