Форум программистов [Powered by Invision Power Board]

Код

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;

namespace LovCell
{
    public partial class LovCell : UserControl
    {
        public string DisplayText
        {
            get
            {
                return txt.Text;
            }
            set
            {
                txt.Text = value;
            }
        }
        public string ValueText
        {
            get
            {
                if (txt.Tag == null)
                {
                    return "";
                }
                else
                {
                    return txt.Tag.ToString();
                }
            }
            set
            {
                txt.Tag = value;
            }
        }
        private int columnText;
        public int ColumnText
        {
            get
            {
                return columnText;
            }
            set
            {
                columnText = value;
            }
        }
        private int columnValue;
        public int ColumnValue
        {
            get
            {
                return columnValue;
            }
            set
            {
                columnValue = value;
            }
        }
        private int[] columnHide;
        public int[] ColunmHide
        {
            get
            {
                return columnHide;
            }
            set
            {
                columnHide = value;
            }
        }
        private string selectCommand;
        public string SelectCommand
        {
            get
            {
                return selectCommand;
            }
            set
            {
                selectCommand = value;
            }
        }
        private string connectionString;
        public string ConnectionString
        {
            get
            {
                return connectionString;
            }
            set
            {
                connectionString = value;
            }
        }

        public LovCell()
        {
            InitializeComponent();
        }

        private void btn_Click(object sender, EventArgs e)
        {
            LOVForm.showLov(connectionString, selectCommand, txt, columnText, columnValue, columnHide);
        }

        protected override void OnTextChanged(EventArgs e)
        {
            base.OnTextChanged(e);
        }

        private void txt_TextChanged(object sender, EventArgs e)
        {
            OnTextChanged(e);
        }
    }
}

namespace LovColumn
{
    public class LovColumn : DataGridViewColumn
    {
        private int columnText;
        public int ColumnText
        {
            get
            {
                return columnText;
            }
            set
            {
                columnText = value;
            }
        }
        private int columnValue;
        public int ColumnValue
        {
            get
            {
                return columnValue;
            }
            set
            {
                columnValue = value;
            }
        }
        private int[] columnHide;
        public int[] ColunmHide
        {
            get
            {
                return columnHide;
            }
            set
            {
                columnHide = value;
            }
        }
        private string selectCommand;
        public string SelectCommand
        {
            get
            {
                return selectCommand;
            }
            set
            {
                selectCommand = value;
            }
        }
        private string connectionString;
        public string ConnectionString
        {
            get
            {
                return connectionString;
            }
            set
            {
                connectionString = value;
            }
        }


        public LovColumn()
            : base(new MyCell())
        {
        }

        public override DataGridViewCell CellTemplate
        {
            get
            {
                return base.CellTemplate;
            }
            set
            {
                if (value != null &&
                    !value.GetType().IsAssignableFrom(typeof(MyCell)))
                {
                    throw new InvalidCastException("Must be a MyCell");
                }
                base.CellTemplate = value;
            }
        }
    }

    public class MyCell : DataGridViewTextBoxCell
    {
        public override void InitializeEditingControl(int rowIndex, object
            initialFormattedValue, DataGridViewCellStyle dataGridViewCellStyle)
        {
            base.InitializeEditingControl(rowIndex, initialFormattedValue,
                       dataGridViewCellStyle);
            MyEditingControl ctl =
                DataGridView.EditingControl as MyEditingControl;
            ctl.DisplayText = Convert.ToString(initialFormattedValue);

        }

        public override Type EditType
        {
            get
            {
                return typeof(MyEditingControl);
            }
        }

        public override Type ValueType
        {
            get
            {
                return typeof(System.String);
            }
        }

        public override object DefaultNewRowValue
        {
            get
            {
                return "";
            }
        }
    }

    class MyEditingControl : LovCell.LovCell, IDataGridViewEditingControl
    {
        DataGridView dataGridView;
        private bool valueChanged = false;
        int rowIndex;

        protected override void OnCreateControl()
        {
            base.OnCreateControl();
            this.ColumnText = (this.EditingControlDataGridView.Columns[this.EditingControlDataGridView.CurrentCell.ColumnIndex] as LovColumn).ColumnText;
            this.ColumnValue = (this.EditingControlDataGridView.Columns[this.EditingControlDataGridView.CurrentCell.ColumnIndex] as LovColumn).ColumnValue;
            this.ColunmHide = (this.EditingControlDataGridView.Columns[this.EditingControlDataGridView.CurrentCell.ColumnIndex] as LovColumn).ColunmHide;
            this.SelectCommand = (this.EditingControlDataGridView.Columns[this.EditingControlDataGridView.CurrentCell.ColumnIndex] as LovColumn).SelectCommand;
            this.ConnectionString = (this.EditingControlDataGridView.Columns[this.EditingControlDataGridView.CurrentCell.ColumnIndex] as LovColumn).ConnectionString;
        }

        public object EditingControlFormattedValue
        {
            get
            {
                return this.DisplayText;
            }
            set
            {
                this.DisplayText = (String)value;
            }
        }

        public object GetEditingControlFormattedValue(
            DataGridViewDataErrorContexts context)
        {
            return this.DisplayText;
        }

        public void ApplyCellStyleToEditingControl(
            DataGridViewCellStyle dataGridViewCellStyle)
        {
            this.Font = dataGridViewCellStyle.Font;
            this.ForeColor = dataGridViewCellStyle.ForeColor;
            this.BackColor = SystemColors.Control;
        }

        public int EditingControlRowIndex
        {
            get
            {
                return rowIndex;
            }
            set
            {
                rowIndex = value;
            }
        }

        public bool EditingControlWantsInputKey(
            Keys key, bool dataGridViewWantsInputKey)
        {
            switch (key & Keys.KeyCode)
            {
                case Keys.Left:
                case Keys.Up:
                case Keys.Down:
                case Keys.Right:
                case Keys.Home:
                case Keys.End:
                case Keys.PageDown:
                case Keys.PageUp:
                    return true;
                default:
                    return false;
            }
        }

        public void PrepareEditingControlForEdit(bool selectAll)
        {

        }

        public bool RepositionEditingControlOnValueChange
        {
            get
            {
                return true;
            }
        }

        public DataGridView EditingControlDataGridView
        {
            get
            {
                return dataGridView;
            }
            set
            {
                dataGridView = value;
            }
        }

        public bool EditingControlValueChanged
        {
            get
            {
                return valueChanged;
            }
            set
            {
                valueChanged = value;
            }
        }

        public Cursor EditingPanelCursor
        {
            get
            {
                return base.Cursor;
            }
        }

        protected override void OnTextChanged(EventArgs e)
        {
            valueChanged = true;
            this.EditingControlDataGridView.NotifyCurrentCellDirty(true);
            base.OnTextChanged(e);
        }
    }
}