Пример #1
0
        private void dateTimePicker2_Leave(object sender, EventArgs e)
        {
            try
            {
                List <Entidades.Ent_CalidadMuestro> Reader = new List <Entidades.Ent_CalidadMuestro>();

                DateTime dateValue = new DateTime(dtpEvent.Value.Year, dtpEvent.Value.Month, dtpEvent.Value.Day);

                Reader = ConsultaEntidades.ObtenerMuestroDia("SpConsulta_Tablas", "CalidadMuestreoPMDia", dateValue, 0, "0");

                if (Reader != null && Reader.Count() > 0)
                {
                    dataGridView3.Visible = true;

                    label2.Visible = true;
                    //label4.Visible = true;

                    //label4.Text = Reader.Count().ToString();
                    dataGridView3.DataSource = Reader;
                    dataGridView3.Columns["Total"].DefaultCellStyle.Format           = "##,##.00";
                    dataGridView3.Columns["Total"].DefaultCellStyle.Alignment        = DataGridViewContentAlignment.MiddleRight;
                    dataGridView3.Columns["cboDuplicado"].DefaultCellStyle.NullValue = "(0)";

                    dataGridView3.Columns[2].ReadOnly = true;
                    dataGridView3.Columns[3].ReadOnly = true;
                    dataGridView3.Columns[4].ReadOnly = true;
                    dataGridView3.AutoResizeColumns();
                }
                else
                {
                    //label2.Visible = false;
                    ////label4.Visible = false;

                    //dataGridView2.Visible = false;
                }

                Reader = ConsultaEntidades.ObtenerMuestroDia("SpConsulta_Tablas", "CalidadMuestreoPMP", dateValue, 0, "0");
                if (Reader != null && Reader.Count() > 0)
                {
                    //label5.Text = Reader.Count().ToString();
                    //label3.Visible = true;
                    //label5.Visible = true;
                    //dataGridView3.Visible = true;
                    //label5.Text = Reader.Count().ToString();
                    //dataGridView3.DataSource = Reader;
                    //dataGridView3.Columns.Remove("SelloControl");
                    //dataGridView3.Columns["Total"].DefaultCellStyle.Format = "##,##.00";
                    //dataGridView3.Columns["Total"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;

                    //dataGridView3.AutoResizeColumns();
                }
                else
                {
                    //dataGridView3.Visible = false;
                    //label3.Visible = false;
                    //label5.Visible = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error :", ex.Message);
            }
        }