jiance-analysis/DPTools/components/MTLFF/CreateNewTableMTLF.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
using Uninpho.Tools.components;
using Uninpho.DBOperation.Model;
using DevExpress.XtraEditors;

namespace Uninpho.Tools.components.MTLFF
{
    public partial class CreateNewTableMTLF : DevExpress.XtraEditors.XtraForm
    {
        public CreateNewTableMTLF()
        {
            InitializeComponent();
        }

        List<T_daocha_account> daochaData = new List<T_daocha_account>();
        private void NewcancelBtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void newCreateBtnSon_Click(object sender, EventArgs e)
        {
            MTLFFListFrom frm = new MTLFFListFrom();
            frm.StartPosition = FormStartPosition.CenterParent;
            ExcelTools.chezhan = zhanmingText.Text;
            ExcelTools.daocha = daochahaoText.Text;
            ExcelTools.zhecha  = zhechahaoText.Text;
            ExcelTools.shejituhao = shejituhaoText.Text;
            ExcelTools.jianceren = jiancharenText.Text;
            ExcelTools.jianceshijian = jianchashijianText.DateTime.ToShortDateString();
            ExcelTools.xianluming = xianlumingText.Text;
            ExcelTools.filenameall = Application.StartupPath + "\\mtlf_temp\\新建道岔全面检查记录表.xlsx";
            frm.ShowDialog();
            //DataAnalysis.DACommon.DirectoryInit(Application.StartupPath + "\\mtlf_temp");
            //DataAnalysis.DACommon.FileCopy(Application.StartupPath + "\\mtlfdemo.xlsx", ExcelTools.filenameall);
            //ExcelTools.sheetControldemo.LoadDocument(ExcelTools.filenameall);
            //if (frm.ShowDialog() == DialogResult.OK)
            //{
                this.Close();
            //}
        }

        /// <summary>
        /// 加载模糊查询的数据
        /// </summary>
        private void CreateNewTableMTLF_Load(object sender, EventArgs e)
        {
            daochaData = DBOperation.Operation.DataAnalysisToPG.QueryDCTZALL();
            //整理线路名集合
            var listtgXLMALL = daochaData.GroupBy(c => c.Xlm).Select(c => c.First()).ToList();
            foreach (var item in listtgXLMALL)
            {
                xianlumingText.Properties.Items.Add(item.Xlm);
            }
        }

        /// <summary>
        /// 线路名查询
        /// </summary>
        private void xianlumingText_TextChanged(object sender, EventArgs e)
        {
            zhanmingText.Properties.Items.Clear();
            var isInputTrueXLM = daochaData.FindAll(delegate (T_daocha_account dc)
            {
                return dc.Xlm == xianlumingText.Text;
            });
            //线路名
            if (isInputTrueXLM.Count != 0)
            {
                var listtg = isInputTrueXLM.GroupBy(c => c.Czm).Select(c => c.First()).ToList();
                foreach (var item in listtg)
                {
                    zhanmingText.Properties.Items.Add(item.Czm);
                }
                zhanmingText.Enabled = true;
            }
            else
            {
                zhanmingText.Enabled = false;
            }
            zhanmingText.Text = "";
            daochahaoText.Text = "";
            zhechahaoText.Text = "";
            shejituhaoText.Text = "";
        }



        private void zhanmingText_EditValueChanged(object sender, EventArgs e)
        {
            daochahaoText.Properties.Items.Clear();
            var isInputTrueZM = daochaData.FindAll(delegate (T_daocha_account dc)
            {
                return dc.Xlm == xianlumingText.Text && dc.Czm == zhanmingText.Text;
            });
            //线路名
            if (isInputTrueZM.Count != 0)
            {
                var listtg = isInputTrueZM.GroupBy(c => c.Dcbh).Select(c => c.First()).ToList();
                foreach (var item in listtg)
                {
                    daochahaoText.Properties.Items.Add(item.Dcbh);
                }
                daochahaoText.Enabled = true;
            }
            else
            {
                daochahaoText.Enabled = false;
            }
            daochahaoText.Text = "";
            zhechahaoText.Text = "";
            shejituhaoText.Text = "";
        }

        private void daochahaoText_EditValueChanged(object sender, EventArgs e)
        {
            var isInputTrueDC = daochaData.FindAll(delegate (T_daocha_account dc)
            {
                return dc.Xlm == xianlumingText.Text && dc.Czm == zhanmingText.Text && dc.Dcbh == daochahaoText.Text;
            });
            zhechahaoText.Text = "";
            shejituhaoText.Text = "";
            //线路名
            if (isInputTrueDC.Count != 0)
            {
                var listtg = isInputTrueDC.GroupBy(c => c.Zch).Select(c => c.First()).ToList();
                zhechahaoText.Text = listtg[0].Zch.ToString();
                shejituhaoText.Text = listtg[0].Dcth.ToString();
            }
        }

        #region keyup事件
        private void xianlumingText_KeyUp(object sender, KeyEventArgs e)
        {
            canelMH(e, xianlumingText);
        }
        private void zhanmingText_KeyUp(object sender, KeyEventArgs e)
        {
            canelMH(e, zhanmingText);
        }

        private void daochahaoText_KeyUp(object sender, KeyEventArgs e)
        {
            canelMH(e, daochahaoText);
        }


        private void canelMH(KeyEventArgs e, ComboBoxEdit CB)
        {
            var asa = e.KeyValue;
            var asaaa = e.KeyCode;
            if (asa == 13)
            {
                CB.ClosePopup();
            }
            else
            {
                CB.ShowPopup();
            }
        }


        #endregion


    }
}