using DevExpress.XtraEditors;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Gs.DevApp.DevFrm.Sys
{
    public partial class EasyCode : DevExpress.XtraEditors.XtraForm
    {
        public EasyCode()
        {
            InitializeComponent();
            this.txt_sqlconn.Text = "Data Source=2kn4sh70028.vicp.fun,26144;Initial Catalog=gs_Mes;User ID=sa;Password =admin110";
            getTable();
        }
        /// <summary>
        /// 读取数据库表
        /// </summary>
        private void getTable()
        {
            string strConn = txt_sqlconn.Text.Trim();
            DataSet dset = new DataSet();
            using (SqlConnection connection = new SqlConnection(strConn))
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = connection;
                cmd.CommandText = "SELECT '--请选择--' as TABLE_NAME union all SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' order by TABLE_NAME desc";
                using (SqlDataAdapter dt = new SqlDataAdapter(cmd))
                {
                    dt.Fill(dset, "0");
                }
            }
            if (dset != null && dset.Tables.Count > 0)
            {
                txt_table.DataSource = dset.Tables[0];
                txt_table.DisplayMember = "TABLE_NAME";
                txt_table.ValueMember = "TABLE_NAME";
                txt_category.SelectedIndex = txt_table.SelectedIndex = 0;
            }
        }

        /// <summary>
        /// 选择生成路径
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnToPath_Click(object sender, EventArgs e)
        {
            string _GetfilePath = FileSelector.BrowseFilePathForSave();
            txtCreateDBPath.Text = _GetfilePath;
        }

        private void btnOk_Click(object sender, EventArgs e)
        {
            if (txt_sqlconn.Text.Trim() == "")
            {
                MessageBox.Show("请输入数据库连接串");
                return;
            }
            if (txt_table.SelectedIndex <= 0)
            {
                MessageBox.Show("请选择表");
                return;
            }
            if (txt_category.SelectedIndex <= 0)
            {
                MessageBox.Show("请选择类型");
                return;
            }
            if (txtCreateDBPath.Text.Trim() == "")
            {
                MessageBox.Show("请选择生成路径");
                return;
            }
            DataTable dt = _getCol();
            string _strName = _getClassName();
            ReadMainFile(dt, _strName);
            ReadDesignerFile(dt, _strName);
            ReadResxFile(dt, _strName);
            string path = txtCreateDBPath.Text;
            lbMsg.Text = "生成成功，路径：" + path;
        }
        /// <summary>
        /// 读取列名
        /// </summary>
        /// <returns></returns>
        private DataTable _getCol()
        {
            string strConn = txt_sqlconn.Text.Trim();
            System.Text.StringBuilder sb = new StringBuilder();
            sb.Append("SELECT COLUMN_NAME = a.name, DATA_TYPE = b.name, REMARK = isnull(g.[value],a.name) ");
            sb.Append(" FROM syscolumns a  left join systypes b on a.xusertype = b.xusertype inner join sysobjects d on a.id = d.id and d.xtype = 'U'  and d.name<>'dtproperties' ");
            sb.Append(" left join syscomments e on a.cdefault = e.id ");
            sb.Append("  left join sys.extended_properties g on a.id = G.major_id and a.colid = g.minor_id ");
            sb.Append(" left join sys.extended_properties f on d.id = f.major_id and f.minor_id = 0 ");
            sb.Append(" where d.name = '" + txt_table.SelectedValue.ToString() + "'");
            sb.Append(" order by  a.id, a.colorder");
            DataSet dset = new DataSet();
            using (SqlConnection connection = new SqlConnection(strConn))
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = connection;
                cmd.CommandText = sb.ToString();
                using (SqlDataAdapter dt = new SqlDataAdapter(cmd))
                {
                    dt.Fill(dset, "0");
                }
            }
            if (dset != null && dset.Tables.Count > 0)
            {
                return dset.Tables[0];
            }
            return null;
        }
        /// <summary>
        /// 模版路径
        /// </summary>
        /// <param name="fileType">cs,Designer.cs</param>
        /// <returns></returns>
        private string _getTemple(string fileType)
        {
            return (@"\templeEasyCode\category1\category1." + fileType);
        }
        /// <summary>
        /// 读取类名
        /// </summary>
        /// <returns></returns>
        private string _getClassName()
        {
            return "Frm" + txt_table.SelectedValue.ToString();
        }
        /// <summary>
        /// 第一个文件
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="_FileName"></param>
        void ReadMainFile(DataTable dt, string _FileName)
        {
            string _Temppath = Application.StartupPath + _getTemple("cs");
            string contents = System.IO.File.ReadAllText(_Temppath);
            string line = Environment.NewLine;
            StringBuilder strbuilder = new StringBuilder();
            strbuilder.Append(contents);
            strbuilder.Replace("{clsName}", _getClassName());
            string _fullPath = txtCreateDBPath.Text + "\\" + _FileName + ".cs";
            if (System.IO.File.Exists(_fullPath))
                System.IO.File.Delete(_fullPath);
            System.IO.StreamWriter sw = System.IO.File.CreateText(_fullPath);
            sw.Write(strbuilder.ToString());
            sw.Close();
            sw.Dispose();
        }
        /// <summary>
        /// 第二个文件
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="_FileName"></param>
        void ReadDesignerFile(DataTable dt, string _FileName)
        {
            string _Temppath = Application.StartupPath + _getTemple("Designer.cs");
            string contents = System.IO.File.ReadAllText(_Temppath);
            StringBuilder strbuilder = new StringBuilder();
            string line = Environment.NewLine;
            strbuilder.Append(contents);
            strbuilder.Replace("{clsName}", _getClassName());
            int _RowCount = dt.Rows.Count;
            if (dt.Rows.Count > 0)
            {
                string _FieldName = "";//字段名
                string _FieldText = "";//字段文本
                string _prefix = "txt_";
                string _Lbfix = "lb_";
                string _gvFix = "gv_";
                int _x = 0, _y = 0, _Tabindex = 210;
                string _ControlType = "";
                string _lbType = "LabelControl";
                System.Text.StringBuilder _gvItemCol = new StringBuilder();
                for (int c = 0; c < _RowCount; c++)
                {
                    _x = 20 + c % 4 * 250;//计算控件在X轴位置
                    if (c % 4 == 0)
                    {
                        _y = 20 + 32 * c / 4;//计算控件在Y轴的位置
                    }
                    _Tabindex = c % 4 + c / 4 + _Tabindex;
                    //多控件类型 这边可以根据具体的需求进行控件的扩展，目前都是文本
                    switch (dt.Rows[c]["DATA_TYPE"].ToString())
                    {
                        case "1111":
                            break;
                        default:
                            string _tf = ToolBox.UtilityHelper.ToCamelCase(dt.Rows[c]["COLUMN_NAME"].ToString());
                            _FieldName = _tf;
                            _FieldText = dt.Rows[c]["REMARK"].ToString();
                            _ControlType = "TextEdit";
                            break;
                    }
                    string _labName = _Lbfix + _FieldName;//label名
                    string _ControlName = _prefix + _FieldName;//文本框名
                    string _gvName = _gvFix + _FieldName;//gv中的列名
                    if (_gvItemCol.Length > 0)
                        _gvItemCol.Append(",");
                    _gvItemCol.Append("this." + _gvName);
                    //BQSetControlObject  实例化控件
                    string BQSetControlObject = ("BQSetControlObject" + line + "this." + _labName + " =  new DevExpress.XtraEditors." + _lbType + "();" + line);
                    BQSetControlObject = (BQSetControlObject + "this." + _ControlName + " = new DevExpress.XtraEditors." + _ControlType + "(); " + line);
                    BQSetControlObject = (BQSetControlObject + "this." + _gvName + " = new DevExpress.XtraGrid.Columns.GridColumn(); " + line);
                    strbuilder.Replace("BQSetControlObject", BQSetControlObject);
                    //创建对象结束后     this.SuspendLayout();
                    //BQSetControlInfo  设置控件信息  位置 大小 名称
                    string _ControlName02 = "\"" + _labName + "\"";//给控件Text 赋值的是带有双引号的字符串 因此这个里要特殊处理下
                    string _FieldName02 = "\"" + _FieldName + "\"";
                    string _FieldText02 = "\"" + (_FieldText + "：") + "\"";
                    string BQSetControlInfo = "BQSetControlInfo" + line
                             //label
                             + "//" + line
                             + "//" + _labName + line
                             + "//" + line
                             + "this." + _labName + ".Location = new System.Drawing.Point(" + _x + ", " + _y + ");" + line//位置
                             + "this." + _labName + ".Name = " + _ControlName02 + ";" + line//给Name赋值
                             + "this." + _labName + ".Size = new System.Drawing.Size(150,21);" + line//大小
                             + "this." + _labName + ".TabIndex = " + _Tabindex + ";" + line
                             + "this." + _labName + ".Tag = " + _FieldName02 + ";" + line//Tag值
                             + "this." + _labName + ".Appearance.Font = new System.Drawing.Font(\"Tahoma\", 10F);" + line
                            + "this." + _labName + ".Text = " + (_FieldText02) + ";" + line
                            //文本 
                            + "//" + line
                            + "//" + _ControlName + line
                            + "//" + line
                            + "this." + _ControlName + ".Location = new System.Drawing.Point(" + (_x + 60) + ", " + _y + ");" + line//位置
                            + "this." + _ControlName + ".Name = " + _ControlName02 + ";" + line
                            + "this." + _ControlName + ".Size = new System.Drawing.Size(150,21);" + line
                            + "this." + _ControlName + ".TabIndex = " + _Tabindex + ";" + line
                            + "this." + _ControlName + ".Tag = " + _FieldName02 + ";" + line
                            + "this." + _ControlName + ".Properties.Appearance.Font = new System.Drawing.Font(\"Tahoma\", 10F);" + line
                           //gv
                           + "this." + _gvName + ".AppearanceCell.Font = new System.Drawing.Font(\"Tahoma\", 10F);" + line
                           + "this." + _gvName + ".AppearanceCell.Options.UseFont = true;" + line
                           + "this." + _gvName + ".FieldName = " + _FieldName02 + ";" + line
                           + "this." + _gvName + ".Caption = " + _FieldText02 .Replace("：","")+ ";" + line
                           + "this." + _gvName + ".MinWidth = 25;" + line
                           + "this." + _gvName + ".Visible = true;" + line
                           + "this." + _gvName + ".Width =94;" + line
                           + "this." + _gvName + ".OptionsColumn.AllowEdit = false;" + line
                           + "this." + _gvName + ".VisibleIndex = 0;" + line;


                    strbuilder.Replace("BQSetControlInfo", BQSetControlInfo);
                    //BQAddControltoMContainer//将控件添加到Form 容器中  这个容器可以是 panel 可以是groupbox 等等 
                    string BQAddControltoMContainer = "BQAddControltoMContainer" + line + "  this.panel1.Controls.Add(this." + _labName + ");" + line;
                    BQAddControltoMContainer += " this.panel1.Controls.Add(this." + _ControlName + ");" + line;
                    strbuilder.Replace("BQAddControltoMContainer", BQAddControltoMContainer);
                    //BQCreateConrolObejct //创建控件 
                    string BQCreateConrolObejct = "BQCreateConrolObejct" + line + "private DevExpress.XtraEditors." + _lbType + " " + _labName + ";" + line;
                    BQCreateConrolObejct += "private DevExpress.XtraEditors." + _ControlType + " " + _ControlName + ";" + line;
                    BQCreateConrolObejct += " private DevExpress.XtraGrid.Columns.GridColumn " + _gvName + ";" + line;
                    strbuilder.Replace("BQCreateConrolObejct", BQCreateConrolObejct);
                }
                strbuilder.Replace("{colList}", _gvItemCol.ToString());
                System.IO.File.Delete(txtCreateDBPath.Text + "\\" + _FileName + ".Designer.cs");
                string path = txtCreateDBPath.Text;
                System.IO.StreamWriter sw = System.IO.File.CreateText(path + "\\" + _FileName + ".Designer.cs");
                sw.Write(strbuilder.ToString());
                sw.Close();
                sw.Dispose();
            }
        }
        /// <summary>
        /// 第三个文件
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="_FileName"></param>
        void ReadResxFile(DataTable dt, string _FileName)
        {
            string _Temppath = Application.StartupPath + _getTemple("resx");
            string contents = System.IO.File.ReadAllText(_Temppath);
            StringBuilder strbuilder = new StringBuilder();
            string line = Environment.NewLine;
            strbuilder.Append(contents);
            System.IO.File.Delete(txtCreateDBPath.Text + "\\" + _FileName + ".resx");
            string path = txtCreateDBPath.Text;
            System.IO.StreamWriter sw = System.IO.File.CreateText(path + "\\" + _FileName + ".resx");
            sw.Write(strbuilder.ToString());
            sw.Close();
            sw.Dispose();
        }

        private void btnToPath_Click_1(object sender, EventArgs e)
        {
            string _GetfilePath = FileSelector.BrowseFilePathForSave();
            txtCreateDBPath.Text = _GetfilePath;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            EasyRpt frm = new EasyRpt("001");
            frm.Show();
        }
    }
}