using System;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Drawing;
using System.Reflection;
using System.Windows.Forms;
namespace DPumpHydr.WinFrmUI.WenSkin.Controls
{
    [Designer(typeof(Design.Designer.WenDataTextBoxDesigner))]
    public class WenDataTextBox : WenControl
    {
        public WenDataTextBox() : base()
        {
            Size = new Size(300, 300);
            button = new WenButton("确定")
            {
                Location = new Point(238, 270),
                Size = new Size(60, 28),
                Anchor = AnchorStyles.Bottom | AnchorStyles.Right,
                BorderStyle = WenButton.WenButtonBorderStyle.RoRectangle,
            };
            button.Click += (s, e) =>
            {
                OnButtonClick(e);
            };

            flow = new FlowLayoutPanel()
            {
                Location = new Point(1, 1),
                Size = new Size(298, 298),
                Anchor = AnchorStyles.Bottom | AnchorStyles.Right | AnchorStyles.Top | AnchorStyles.Left,
                AutoScroll = true,
            };

            this.Controls.Add(button);
            this.Controls.Add(flow);
        }

        #region 私有属性

        private FlowLayoutPanel flow;
        private WenButton button;
        private object dataSource;
        private WenDataTextBoxColumnTextCollection items;

        #endregion

        #region 公有属性

        //绑定数据
        [Browsable(false)]
        public object DataSource
        {
            get => dataSource;
            set
            {
                dataSource = value;
                switch (value)
                {
                    case DataRow dw:
                        DataBind(dw);
                        break;
                    case DataTable dt:
                        DataBind(dt.Rows[0]);
                        break;
                }
            }
        }

        [Category("Wen"), Description("获取或设置输入框列数据"), DefaultValue(null)]
        [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
        [Editor(typeof(Design.Editor.WenCollectionEditor), typeof(System.Drawing.Design.UITypeEditor))]
        [EditorBrowsable(EditorBrowsableState.Always)]
        public WenDataTextBoxColumnTextCollection Items => items ?? (items = new WenDataTextBoxColumnTextCollection(this));

        #region WenSql

        [Category("WenSql"), Description("获取或设置数据库名称"), DefaultValue(null)]
        public string DataTabaleName { get; set; }

        [Category("WenSql"), Description("获取插入数据库数据语句"), DefaultValue(null)]
        [Browsable(false)]
        public string InsertSqlString
        {
            get
            {
                string insertName = "";
                string insertValue = "";
                foreach (WenDataTextBoxColumnText ct in Items)
                {

                    if (!ct.Updater)
                        continue;
                    insertName += ct.ColumnName + ",";
                    insertValue += $"'{ct.Text}',";
                }
                insertName = insertName.Remove(insertName.Length - 1);
                insertValue = insertValue.Remove(insertValue.Length - 1);
                string sql = $"insert into {DataTabaleName} ({insertName}) Values({insertValue})";
                return sql;
            }
        }
        [Category("WenSql"), Description("获取更新数据库数据语句"), DefaultValue(null)]
        [Browsable(false)]
        public string UpdateSqlString
        {
            get
            {
                string setValue = "";
                WenDataTextBoxColumnText identityCloumn = null;
                foreach (WenDataTextBoxColumnText ct in Items)
                {
                    if (ct.Identity)
                    {
                        identityCloumn = ct;
                        continue;
                    }
                    if (!ct.Updater)
                        continue;

                    setValue += $"{ct.ColumnName}=N'{ct.Text}',";
                }
                setValue = setValue.Remove(setValue.Length - 1);


                //获取主键列

                if (identityCloumn == null)
                    return null;

                string whereValue = identityCloumn.Text.ToString();
                string sql = $"update {DataTabaleName} set {setValue} where {identityCloumn.ColumnName}='{whereValue}'";
                return sql;
            }
        }

        #endregion


        #endregion

        #region 委托
        [Category("Wen"), Description("确定按钮点击事件")]
        public event EventHandler ButtonClick;

        protected virtual void OnButtonClick(EventArgs e)
        {
            foreach (WenDataTextBoxColumnText ct in Items)
            {
                if (ct.AutoUpdaterDateTime)
                {
                    ct.Text = DateTime.Now.ToString();
                }
            }
            ButtonClick?.Invoke(this, e);
        }

        #endregion

        private void DataBind(DataRow dw)
        {
            foreach (DataColumn column in dw.Table.Columns)
            {
                WenDataTextBoxColumnText cloumnText = Items[column.ColumnName];
                if (cloumnText != null)
                    cloumnText.WenChoiceTextBox.Text = dw[column]?.ToString();
            }
        }

        #region 重绘

        protected override void WenOnPaint(Graphics g, Rectangle rec, PaintEventArgs e)
        {
            base.WenOnPaint(g, rec, e);
            using Pen pen = new Pen(Color.White);
            g.DrawRectangle(pen, 0, 0, this.Width - 1, this.Height - 1);
        }

        #endregion

        #region 子类
        [ToolboxItem(false)]
        [DefaultProperty("TextLable")]
        [DesignTimeVisible(false)]
        public class WenDataTextBoxColumnText:Component
        {
            public WenDataTextBoxColumnText()
            {
                ReadOnly = false;
                Visible = true;
                Identity = false;
                Updater = true;
                AutoUpdaterDateTime = false;
            }

            public WenDataTextBoxColumnText(string text) : this()
            {
                TextLable = text;
            }

            #region 私有属性

            private bool identity;
            private string textLable;
            private string text;
            private bool readOnly;

            #endregion


            #region 公有属性   


            [Browsable(false)]
            public string Name { get; set; }

            [Category("WenInfo"), Description("显示文本"), DefaultValue(null)]
            public string Text
            {
                get => text;
                set { text = value; if (WenChoiceTextBox != null) WenChoiceTextBox.Text = value; }
            }

            [Category("WenInfo"), Description("数据列"), DefaultValue(null)]
            public string ColumnName { get; set; }
            [Category("WenInfo"), Description("数据列文本"), DefaultValue(null)]
            public string TextLable
            {
                get => textLable;
                set { textLable = value; if (WenChoiceTextBox != null) WenChoiceTextBox.TextLable = value; }
            }

            [Category("Wen设计"), Description("是否不允许编辑"), DefaultValue(false)]
            public bool ReadOnly
            {
                get => readOnly;
                set
                {
                    readOnly = value;
                    if (WenChoiceTextBox != null)
                        WenChoiceTextBox.ReadOnly = value;
                }
            }
            [Category("Wen设计"), Description("是否显示"), DefaultValue(true)]
            public bool Visible { get; set; }

            [Category("Wen设计"), Description("是否主键"), DefaultValue(false)]
            public bool Identity
            {
                get => identity; set
                {
                    identity = value;
                    if (value)
                    {
                        Updater = false;
                        ReadOnly = true;
                    }
                }
            }

            [Category("Wen设计"), Description("是否更新"), DefaultValue(true)]
            public bool Updater { get; set; }

            [Category("Wen设计"), Description("点击确定自动将内容更新为当前时间"), DefaultValue(false)]
            public bool AutoUpdaterDateTime { get; set; }

            [Browsable(false)]
            public WenLableTextBox WenChoiceTextBox { get; set; }

            #endregion
            public override string ToString()
            {
                return $"{ColumnName}[{TextLable}]";
            }
        }

        public class WenDataTextBoxColumnTextCollection : WenCollection
        {
            public WenDataTextBoxColumnTextCollection(WenDataTextBox owner)
            {
                this.owner = owner;
            }
            public WenDataTextBoxColumnText this[int index] { get => Items[index] as WenDataTextBoxColumnText; set => Items[index] = value; }
            public WenDataTextBoxColumnText this[string str]
            {
                get
                {
                    foreach (var item in Items)
                    {
                        if (item is WenDataTextBoxColumnText cloumnText)
                        {
                            if (cloumnText.ColumnName?.ToUpper() == str.ToUpper())
                                return cloumnText;
                        }
                    }
                    return null;
                }
            }
            #region 私有属性

            private WenDataTextBox owner { get; set; }

            #endregion

            public override int Add(object value)
            {
                if (value is WenDataTextBoxColumnText columnText)
                {
                    WenLableTextBox textBox = new WenLableTextBox()
                    {
                        TextLable = columnText.TextLable,
                        ReadOnly = columnText.ReadOnly,
                        Visible = columnText.Visible,
                        Width = 260,
                    };
                    textBox.TextChanged += (s, e) =>
                    {
                        columnText.Text = textBox.Text;
                        if (owner.dataSource is DataRow dw)
                        {
                            try
                            {
                                //Type type = dw.Table.Columns[columnText.ColumnName].DataType;
                                //dw[columnText.ColumnName] = new TypeConverter().ConvertTo(textBox.Text, type);
                                dw[columnText.ColumnName] = textBox.Text;
                            }
                            catch { }
                        }
                    };
                    columnText.WenChoiceTextBox = textBox;
                    owner.flow.Controls.Add(textBox);
                }
                return base.Add(value);
            }

            public override void Clear()
            {
                base.Clear();
                owner.flow.Controls.Clear();
            }
        }
        #endregion
    }
}