jiance-analysis/DPTools/components/DWForm/ImportGLdatamanageForm.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using Uninpho.DBOperation.Model;
using System.IO;
using Uninpho.DBOperation.Operation;
using System.Text.RegularExpressions;
using System.Reflection;
using Uninpho.Tools.components.DWForm;
using Uninpho.Tools.components.DataAnalysis;
using DevExpress.XtraGrid.Views.Grid;

namespace Uninpho.Tools.components.DWForm
{
    public partial class ImportGLdatamanageForm : DevExpress.XtraEditors.XtraForm
    {
        bool ch;
        GridView grid;
        public ImportGLdatamanageForm(bool ischecked, GridView GV)
        {
            InitializeComponent();
             ch = ischecked;
             grid = GV;


        }
      
       /// 浏览文件目录
        private void simpleButton2_Click(object sender, EventArgs e)
        {
            DWCommon.OpenFile("txt", ch, grid);
            txtindir.Text = DWCommon.lj;


        }

        /// 导入数据
        private void newCreateBtnSon_Click(object sender, EventArgs e)
        {
            this.Close();
        }


        ///取消
        private void NewcancelBtn_Click(object sender, EventArgs e)
        {
            this.Close();//记得改，现在取不取消都是导入成功
        }

        ///关联数据库
        /// 电务/缺口
        List<T_dwfile_account> dwglData = new List<T_dwfile_account>();
      
        private void xianlumingText_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        ///初始界面加载
        private void ImportGLdatamanageForm_Load(object sender, EventArgs e)
        {
            dwglData = DBOperation.Operation.DataAnalysisToPG.QueryDWGLALL();
            //整理线路名集合
            var listtgXLMALL = dwglData.GroupBy(c => c.Xianlu).Select(c => c.First()).ToList();
            foreach (var item in listtgXLMALL)
            {
                xianlumingText.Properties.Items.Add(item.Xianlu);
            }
        }

        ///线路名下拉选择
        private void xianlumingText_EditValueChanged(object sender, EventArgs e)
        {
            zhanmingText.Properties.Items.Clear();
            var isInputTrueXLM = dwglData.FindAll(delegate (T_dwfile_account dwgl)
            {
                return dwgl.Xianlu == xianlumingText.Text;
            });
            //线路名
            if (isInputTrueXLM.Count != 0)
            {
                var listtg = isInputTrueXLM.GroupBy(c => c.Chezhan).Select(c => c.First()).ToList();
                foreach (var item in listtg)
                {
                    zhanmingText.Properties.Items.Add(item.Chezhan);
                }
                zhanmingText.Enabled = true;
            }
            else
            {
                zhanmingText.Enabled = false;
            }
            zhanmingText.Text = "";
        }
    
    }
}