コード例 #1
0
        private void textBox1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
        {
            Controles.CNDCTextBoxDateTime tb = (Controles.CNDCTextBoxDateTime)sender;

            if (tb.Text.Length == tb.MaxLength && tb.SelectedText == "")
            {
                tb.SelectionLength = 1;
            }
        }
コード例 #2
0
        public static void Validating_DateTime(object sender, System.ComponentModel.CancelEventArgs e)
        {
            Controles.CNDCTextBoxDateTime tb = (Controles.CNDCTextBoxDateTime)sender;
            string errorMsg;

            System.Text.RegularExpressions.Regex rTime = new System.Text.RegularExpressions.Regex(@"[0-2][0-9]\:[0-6][0-9]\:[0-6][0-9]");
            if (tb.Text.Length > 0)
            {
                if (!rTime.IsMatch(tb.Text))
                {
                    MessageBox.Show("Please provide the time in hh:mm:ss format", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
コード例 #3
0
        private void SetAtributesFromDb(string tableName, string columnName, System.Windows.Forms.Control control)
        {
            OracleCommand cmd = Sesion.Instancia.Conexion.CrearCommand();

            cmd.CommandText =
                @"SELECT DATA_TYPE, DATA_LENGTH, DATA_PRECISION , NULLABLE, DATA_SCALE
            FROM all_tab_columns
            WHERE owner IN (SELECT DB_SCHEMA FROM P_QUANTUM) 
            AND table_name = :pTableName AND column_name = :pColumnName   ";
            cmd.Parameters.Add("pTableName", tableName);
            cmd.Parameters.Add("pColumnName", columnName);

            OracleDataReader odr = cmd.ExecuteReader();

            if (odr.Read())
            {
                string  dataType      = odr.GetString(0);
                decimal dataLength    = odr.GetDecimal(1);
                decimal dataPrecision = -1;
                decimal dataScale     = -1;
                string  nullable      = odr.GetString(3);

                if (odr[2] != DBNull.Value)
                {
                    dataPrecision = odr.GetDecimal(2);
                }

                if (odr[4] != DBNull.Value)
                {
                    dataScale = odr.GetDecimal(4);
                }

                if (control is TextBox)
                {
                    TextBox tb = (TextBox)control;
                    tb.MaxLength = (int)dataLength;
                    switch (dataType)
                    {
                    case "CLOB":
                        tb.MaxLength = int.MaxValue;
                        break;

                    case "NUMBER":
                        tb.MaxLength = 32767;
                        if (tb is CNDCTextBoxNumerico)
                        {
                            CNDCTextBoxNumerico txtNum = (CNDCTextBoxNumerico)tb;
                            if (dataScale == -1)
                            {
                                txtNum.MaxDigitosEnteros = (int)dataPrecision;
                            }
                            else
                            {
                                txtNum.MaxDigitosEnteros = (int)dataPrecision - (int)dataScale;
                            }
                            txtNum.MaxDigitosDecimales = (int)dataScale;
                        }
                        break;

                    case "DATE":
                    case "TIMESTAMP(6)":
                        tb.Tag = "dd/mm/yyyy hh:mi:ss";
                        if (tb.Text.Length == 0)
                        {
                            tb.Text = "__/__/____ __:__:__";
                        }

                        tb.MaxLength = tb.Text.Length;
                        break;
                    }
                }

                if (control is Controles.CNDCTextBoxDateTime)
                {
                    Controles.CNDCTextBoxDateTime tb = (Controles.CNDCTextBoxDateTime)control;
                    tb.ValidadorFormatoFecha  = new Controles.ValidadorControlFecha((string)(tb.Tag));
                    tb.ValidadorIngresoOnline = new Controles.ValidadorControlFechaParte((string)(tb.Tag));
                    tb.KeyPress += new KeyPressEventHandler(tb_KeyPress);
                    tb.KeyDown  += new KeyEventHandler(tb_KeyDown);
                }
                //control.Visible = (visible == 1);
                //control.Enabled = (enabled == 1);
            }
            else
            {
                //control.Visible = false;
                //control.Enabled = false;
            }

            if (odr != null)
            {
                odr.Close();
                odr.Dispose();
            }
            Sesion.Instancia.Conexion.DisposeCommand(cmd);
        }