using System;

using System.Windows.Forms;
using DevExpress.XtraBars;

using Uninpho.DBOperation;
using Uninpho.DBOperation.Operation;
using DevExpress.XtraEditors;
using Uninpho.Tools.components;
using DevExpress.XtraTab;
using Uninpho.Tools.components.TZFunc;
using Uninpho.Tools.components.MTLFF;
using Uninpho.Tools.components.XXXW;
using Uninpho.Tools.components.ZZJH;
using DevExpress.XtraTab.ViewInfo;
using Uninpho.DBOperation.Model;
using System.Collections.Generic;
using Uninpho.Tools.components.DataAnalysis;
using Uninpho.Tools.components.SomethingSetting;
using DevExpress.XtraBars.Ribbon;
using System.Threading.Tasks;
using System.Configuration;
using System.IO;
using Uninpho.Tools.components.SFZDH;
using Uninpho.Tools.components.DWForm;
using System.Runtime.InteropServices;


namespace Uninpho.Tools
{

    public partial class DevFrmMain : DevExpress.XtraBars.Ribbon.RibbonForm
    {
        
        //使用tabletools工具
        private Tabletools tabtools = new Tabletools();

        public DevFrmMain()
        {
             
            InitializeComponent();
            Config.zdhjc = true;
            DevExpress.XtraEditors.Controls.Localizer.Active = new MessboxClass();//使XtraMessageBox.Show的按钮都显示汉字
            this.StartPosition = FormStartPosition.CenterScreen;          
            Uninpho.Railway.Waveform.iniSetClass.loadAllPZ(ConfigurationManager.AppSettings["pzConfig"]);
        }


        private void barButtonImageTile_ItemClick(object sender, ItemClickEventArgs e)
        {
            try
            {
                Demo3_Insertable.Test();
                Demo1_Queryable.Test1();
                Demo1_Queryable.Test2();
                //Demo2_Updateable.Test();
                Demo4_Deleteable.Test();
                Demo5_SqlQueryable.Test();
                XtraMessageBox.Show("测试成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show("测试失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }


        }



        private void DevFrmMain_Load(object sender, EventArgs e)
        {
            #region 授权
            //SqlQueryable_QX.SelectJMInform(ref TZCommonFunc.Qxjm_List,ref TZCommonFunc.Dcjm_List,ref TZCommonFunc.Gjjm_List);
            //初始化台账信息数据
            try
            {
                this.data_binding();
                this.dcInform8.data_binding();            
                this.gjInform9.data_binding();
                MTLFCtrl mtlf = new MTLFCtrl();
                mtlf.Parent = xtraTabPageMTLF;
                mtlf.Dock = DockStyle.Fill;
                ZZJHCtrl zzjh = new ZZJHCtrl();
                zzjh.Parent = xtraTabPageZZJH;
                zzjh.Dock = DockStyle.Fill;
                XXXWCtrl xxxw = new XXXWCtrl();
                xxxw.Parent = xtraTabPageXXXW;
                xxxw.Dock = DockStyle.Fill;
                DMCtrl dmCtrl3 = new DMCtrl();
                dmCtrl3.Parent = xtraTabDataManager;
                dmCtrl3.Dock = DockStyle.Fill;
            }
            catch
            {
                UserInform.isconnect = false;
                XtraMessageBox.Show("数据库连接异常！请在设置中检查数据库相关配置", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);


            }

            try
            {
                UserInform.CPUID = sqClass.GetCpuID();
                UserInform.sqCode = ConfigurationManager.AppSettings["sqssrY"];
                string[] straa = sqClass.Decrypt(UserInform.sqCode, UserInform.sqkey).Split('灬');
                UserInform.sqDate = straa[1];
                //if (UserInform.CPUID == straa[0])
                //{
                if (straa[1] == "forever")
                {
                    UserInform.userinf.Pow = 1;
                    UserInform.sqType = "Long";
                }
                else
                {
                    UserInform.sqType = "Short";
                    DateTime nowtime = DateTime.Now;
                    DateTime timeLim = Convert.ToDateTime(straa[1]);
                    if (nowtime < timeLim)
                    {
                        UserInform.userinf.Pow = 1;
                    }
                    else
                    {
                        UserInform.userinf.Pow = 0;
                    }
                }
                //}
                //else
                //{
                //    UserInform.userinf.Pow = 0;
                //}
            }
            catch (Exception)
            {
                UserInform.userinf.Pow = 0;
            }

            this.Text = UserInform.userinf.Pow == 0 ? this.Text + "——未授权" : this.Text;
            #endregion

            gridView2.IndicatorWidth = 40;
            gridView3.IndicatorWidth = 40;
            if (ribbonPageGroup10.Visible == true)
            {
                DACommon.initZDHFun(StartZDHBtn);
            }
            DACommon.DirectoryInit(Application.StartupPath + "\\zzjh_temp");
            DACommon.DirectoryInit(Application.StartupPath + "\\mtlf_temp");
            DACommon.DirectoryInit(Application.StartupPath + "\\xxxw_temp");
            DACommon.DirectoryInit(Application.StartupPath + "\\result");
            DACommon.DirectoryInit(Application.StartupPath + "\\result");
            DACommon.DirectoryInitNoDel(Application.StartupPath + "\\log");
            //this.dmCtrl1.Initialize();
            jiancecheShowClass.comboboxShowMain(false, ref JHFXJCCcomboBoxEdit, ref LGLJCCcomboBoxEdit);
        }

        private void barButtonItem5_ItemClick(object sender, ItemClickEventArgs e)
        {

        }

        private void barButtonItem4_ItemClick(object sender, ItemClickEventArgs e)
        {

        }


        #region 曲线信息管理查看
        /// <summary>
        /// 曲线信息管理查看
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnQuXianinfo_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strQXtabname = "xtraTabPageQX";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strQXtabname);

        }

        #endregion

        #region 道岔信息管理查看
        /// <summary>
        /// 道岔信息管理查看
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnDaoChainfo_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageDC";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }

        #endregion

        #region 管界信息管理查看
        /// <summary>
        /// 管界信息管理查看
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnGuanJieinfo_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strGJtabname = "xtraTabPageGJ";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strGJtabname);
        }

        #endregion


        #region 导入表格信息数据
        /// <summary>
        /// 导入表格信息数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnInsertData(object sender, ItemClickEventArgs e)
        {
            string clickbtn = e.Item.Caption;
            try
            {
                switch (clickbtn)
                {
                    case "曲线数据":
                        //打开表格数据转成实体类
                        if (TZCommonFunc.GetTabledata(TableName.QX_Data))
                        {
                            //插入数据
                            SqlQueryable_QX.Insertdata_QX(TZCommonFunc.Listdata_qx);
                            this.data_binding();
                        }
                        break;
                    case "道岔数据":
                        //打开表格数据转成实体类
                        if (TZCommonFunc.GetTabledata(TableName.DC_Data))
                        {
                            //插入数据
                            SqlQueryable_QX.Insertdata_DC(TZCommonFunc.Listdata_dc);
                            this.dcInform8.data_binding();
                        }
                        break;
                    case "管界数据":
                        //打开表格数据转成实体类
                        if (TZCommonFunc.GetTabledata(TableName.GJ_Data))
                        {
                            //插入数据
                            SqlQueryable_QX.Insertdata_GJ(TZCommonFunc.Listdata_gj);
                            this.gjInform9.data_binding();
                        }
                        break;
                    default:
                        break;
                }

                if (TZCommonFunc.dataSsccess.Count != 0)
                {
                    string mess = string.Empty;
                    foreach (var item in TZCommonFunc.dataSsccess)
                    {
                        mess += item + "\r\n";
                    }
                    XtraMessageBox.Show(mess, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

        }
        #endregion



        private void serviceMgr1_Load(object sender, EventArgs e)
        {

        }

        private void barCheckItem1_CheckedChanged(object sender, ItemClickEventArgs e)
        {

        }

        private void barButtonItem5_ItemClick_1(object sender, ItemClickEventArgs e)
        {

        }

        private void barEditItem3_ItemClick(object sender, ItemClickEventArgs e)
        {

        }

        private void xtraTabPage2_Paint(object sender, PaintEventArgs e)
        {

        }

        /// <summary>
        /// 数据展示
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void barButtonItem_DataManager_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabDataManager";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }
        /// <summary>
        /// tab页关闭功能
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void xtraTabControl1_CloseButtonClick(object sender, EventArgs e)
        {
            XtraTabControl tabControl = sender as XtraTabControl;
            ClosePageButtonEventArgs arg = e as ClosePageButtonEventArgs;
            var page = arg.Page as XtraTabPage;
            if (page.HasChildren)
            {
                //tabControl.TabPages.Remove(page);
                //page.Controls.Clear();
                //page.Dispose();
                page.PageVisible = false;
            }

        }
        /// <summary>
        /// 数据绑定曲线数据
        /// </summary>
        private void data_binding()
        {
            List<T_quxian_account> daochaList = SqlQueryable_QX.Search_QX();
            this.gridControl1.DataSource = daochaList;

            List<T_gonglv_account> gonglvList = SqlQueryable_QX.Search_GLData();
            this.gridControl6.DataSource = gonglvList;

            List<T_quekou_account> quekouList = SqlQueryable_QX.Search_QKData();
            this.gridControl7.DataSource = quekouList;
            // 初始化查询功率分析数据列表
            List<T_dwfile_account> gl_dataList = DataAnalysisToPG.getDwfile("", new List<int>(), new List<string>()) as List<T_dwfile_account>;
            this.gridControl4.DataSource = gl_dataList;//电务功率

            List<T_dwqkfile_account> qk_dataList = DataAnalysisToPG.getDwqkfile("", new List<int>(), new List<string>()) as List<T_dwqkfile_account>;
            this.gridControl5.DataSource = qk_dataList;//电务缺口


            List<T_file_account> daochaListjhfx = DataAnalysisToPG.getfile("bny",new List<int>(),new List<string>()) as List<T_file_account>;
            this.gridControl3.DataSource = daochaListjhfx;

            List<T_file_account> daochaListlgl = DataAnalysisToPG.getfile("geo", new List<int>(), new List<string>()) as List<T_file_account>;
            this.gridControl2.DataSource = daochaListlgl;
        }
        /// <summary>
        /// 显示序号。
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridView1_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)
        {
            if (e.Info.Kind == DevExpress.Utils.Drawing.IndicatorKind.Header)
            {
                e.Appearance.DrawBackground(e.Cache, e.Bounds);
                e.Appearance.DrawString(e.Cache, "  序号", e.Bounds);
                e.Handled = true;
            }
            if (e.Info.IsRowIndicator && e.RowHandle >= 0)
            {
                e.Info.DisplayText = (e.RowHandle + 1).ToString();
            }
        }
        /// <summary>
        /// 轨道几何数据分析大按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GDJHbBtnI_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageJH";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }
        /// <summary>
        /// 轮轨力数据分析
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void LGLbBtnI_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageLGL";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }
        /// <summary>
        /// 轮轨力打开文件
        /// </summary>
        private void LGLOpenfileBtn_Click(object sender, EventArgs e)
        {
            List<int> indexid = new List<int>();
            List<string> indexzt = new List<string>();
            DACommon.getSFZT(gridView3, ref indexid, ref indexzt);
            DACommon.OpenFile("bny", LGLcheckEdit.Checked,gridView3);
            List<T_file_account> daochaLists = DataAnalysisToPG.getfile("bny", indexid, indexzt) as List<T_file_account>;
            this.gridControl3.DataSource = daochaLists;
            DACommon.repushSFZT(gridView3, indexid);
        }
        /// <summary>
        /// 几何分析打开文件
        /// </summary>
        private void JHFXopenfileBtn_Click(object sender, EventArgs e)
        {
            List<int> indexid = new List<int>();
            List<string> indexzt = new List<string>();
            DACommon.getSFZT(gridView2, ref indexid, ref indexzt);
            DACommon.OpenFile("geo", JHFXcheckEdit.Checked, gridView2);
            List<T_file_account> daochaLists = DataAnalysisToPG.getfile("geo", indexid, indexzt) as List<T_file_account>;
            this.gridControl2.DataSource = daochaLists;
            DACommon.repushSFZT(gridView2, indexid);

        }
        /// <summary>
        /// 表第一列加序号
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridView2_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)
        {
            DACommon.addXuHao(e);
        }

        /// <summary>
        /// 添加检测车文件、更新检测车信息
        /// </summary>
        private void updataJJCXXBtn_Click(object sender, EventArgs e)
        {
            jiancecheShowClass.comboboxShowMain(true, ref JHFXJCCcomboBoxEdit, ref LGLJCCcomboBoxEdit);
        }

        private void JHFXjiancecheBtn_Click(object sender, EventArgs e)
        {
            jiancecheShowClass.updataJccxx2PG(true, ref gridControl2, ref gridControl3,
                ref JHFXJCCcomboBoxEdit, ref gridView2, ref LGLJCCcomboBoxEdit, ref gridView3,
                xtraTabControl1.SelectedTabPage.Name);
        }
        /// <summary>
        /// 几何分析、道岔：删除选中
        /// </summary>
        private void DelJHFXBtn_Click(object sender, EventArgs e)
        {

            if (UserInform.userinf.Pow == 0)
            {
                XtraMessageBox.Show("您无权删除数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                jiancecheShowClass.updataJccxx2PG(false, ref gridControl2, ref gridControl3,
    ref JHFXJCCcomboBoxEdit, ref gridView2, ref LGLJCCcomboBoxEdit, ref gridView3,
    xtraTabControl1.SelectedTabPage.Name);
            }
        }

        /// <summary>
        /// 微小算法
        /// </summary>
        private void WXSFBtn_Click(object sender, EventArgs e)
        {
            new DataAnalysisClass("微小", gridView2.GetSelectedRows(), ref gridControl2, ref gridView2);
            //            DataAnalysisFun.resAsyncFun(1, gridView2.GetSelectedRows(),
            //ref gridControl2, ref gridControl3, ref gridView2, ref gridView3);
        }


        /// <summary>
        /// 几何分析算法
        /// </summary>
        private void JHTQBtn_Click(object sender, EventArgs e)
        {
            new DataAnalysisClass("几何", gridView2.GetSelectedRows(), ref gridControl2, ref gridView2);
    //            DataAnalysisFun.resAsyncFun(0, gridView2.GetSelectedRows(),
    //ref gridControl2, ref gridControl3, ref gridView2, ref gridView3);
        }

        /// <summary>
        /// 轮轨力提取
        /// </summary>
        private void LGLTQBtn_Click(object sender, EventArgs e)
        {
            new DataAnalysisClass("轮轨力", gridView3.GetSelectedRows(), ref gridControl3, ref gridView3);
    //        DataAnalysisFun.resAsyncFun(2, gridView3.GetSelectedRows(),
    //ref gridControl2, ref gridControl3, ref gridView2, ref gridView3);
        }
        /// <summary>
        /// 轮轨力分析
        /// </summary>
        private void LGLFXBtn_Click(object sender, EventArgs e)
        {
            DataAnalysisFun.resAsyncFun(3, gridView3.GetSelectedRows(),
    ref gridControl2, ref gridControl3, ref gridView2, ref gridView3);

        }

        private void JHFXJCCcomboBoxEdit_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        /// <summary>
        /// 删除选中行
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void deleteroebtnqx_Click(object sender, EventArgs e)
        {
            if (UserInform.userinf.Pow == 0)
            {
                XtraMessageBox.Show("您无权删除数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                var selectRowId = this.railwaybureau.GetSelectedRows();
                if (selectRowId.Length == 0)
                {
                    XtraMessageBox.Show("请选中删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    if (this.Confirm("是否删除") == DialogResult.OK)
                    {
                        List<T_quxian_account> deletelist = new List<T_quxian_account>();
                        foreach (var item in selectRowId)
                        {
                            deletelist.Add(new T_quxian_account() { Id = this.railwaybureau.GetRowCellValue(item, "Id").ToString() });
                        }

                        SqlQueryable_QX.QXDeleteRows(deletelist);
                        XtraMessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.data_binding();
                    }
                    else
                    {
                        return;
                    }
                }
            }

        }

        //弹出提示况
        public DialogResult Confirm(string strString)
        {
            return DevExpress.XtraEditors.XtraMessageBox.Show(strString, "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
        }

        private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
            
        }

        private void railwaybureau_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
            if (e.Value == null || e.Value == "")
            {
                XtraMessageBox.Show("请勿填写空值", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            T_quxian_account rowdata = this.railwaybureau.GetRow(e.RowHandle) as T_quxian_account;
            SqlQueryable_QX.QXUpdataRowData(rowdata);
        }

        private void gridControl1_Click(object sender, EventArgs e)
        {

        }

        private void barButtonItem10_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageMTLF";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }
        /// <summary>
        /// 关闭清除缓存
        /// </summary>
        private void DevFrmMain_FormClosing(object sender, FormClosingEventArgs e)
        {
            DACommon.DirectoryInit(Application.StartupPath + "\\zzjh_temp");
            DACommon.DirectoryInit(Application.StartupPath + "\\mtlf_temp");
            DACommon.DirectoryInit(Application.StartupPath + "\\xxxw_temp");
            DACommon.DirectoryInit(Application.StartupPath + "\\result");
        }
        /// <summary>
        /// 线形线位
        /// </summary>
        private void barButtonItem24_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageXXXW";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }
        /// <summary>
        /// 逐枕几何
        /// </summary>
        private void barButtonItem23_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageZZJH";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }

        /// <summary>
        /// 数据库设置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void barButtonItem25_ItemClick(object sender, ItemClickEventArgs e)
        {
            dbSettingFrom frm = new dbSettingFrom();
            frm.StartPosition = FormStartPosition.CenterParent;
            if (frm.ShowDialog(this) == DialogResult.OK)
            {
            }
        }
        /// <summary>
        /// 对外离线授权
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void barButtonItem27_ItemClick(object sender, ItemClickEventArgs e)
        {
            if (UserInform.userinf.Pow == 0 || UserInform.userinf.Pow != 0 && UserInform.sqType == "Short")
            {
                XtraMessageBox.Show("您无权对外授权！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
            }
            else
            {
                InviteOfflineFrom frm = new InviteOfflineFrom();
                frm.StartPosition = FormStartPosition.CenterParent;
                frm.MinimizeBox = false;
                frm.MaximizeBox = false;
                frm.FormBorderStyle = FormBorderStyle.FixedDialog;
                if (frm.ShowDialog(this) == DialogResult.OK)
                {
                }
            }
        }
        /// <summary>
        /// 软件授权
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void barButtonItem26_ItemClick(object sender, ItemClickEventArgs e)
        {
                InitInviteFrom frm = new InitInviteFrom();
                frm.StartPosition = FormStartPosition.CenterParent;
                frm.MinimizeBox = false;
                frm.MaximizeBox = false;
                frm.FormBorderStyle = FormBorderStyle.FixedDialog;
                if (frm.ShowDialog(this) == DialogResult.OK)
                {
                }
            
        }

        private void barButtonItem28_ItemClick(object sender, ItemClickEventArgs e)
        {
            DownloadDemoFrom frm = new DownloadDemoFrom();
            frm.StartPosition = FormStartPosition.CenterParent;
            frm.MinimizeBox = false;
            frm.MaximizeBox = false;
            frm.FormBorderStyle = FormBorderStyle.FixedDialog;
            if (frm.ShowDialog(this) == DialogResult.OK)
            {
            }
        }

        private void ribbon_Click(object sender, EventArgs e)
        {

        }

        private void barButtonItem29_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageDW";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }

        /// <summary>
        /// 尖心轨间距表
        /// </summary>
        private void btnJXGJJ_ItemClick(object sender, ItemClickEventArgs e)
        {
            JHjgjFrom frm = new JHjgjFrom();
            frm.StartPosition = FormStartPosition.CenterParent;
            frm.ShowDialog();
        }

        /// <summary>
        /// 自动化关闭
        /// </summary>
        private void barButtonItem30_ItemClick(object sender, ItemClickEventArgs e)
        {
            StartZDHBtn.ImageUri.Uri = "Prev"; //Refresh // Prev
            StartZDHBtn.Caption = "开启自动化";
            zdhSetClass.isStartZDH = 0;
            ZDHSetting.reWriteini();
            new AutoLoopClass(false);
        }

        /// <summary>
        /// 自动化开启
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void StartZDHBtn_ItemClick(object sender, ItemClickEventArgs e)
        {
            ZDHSetting frm = new ZDHSetting(StartZDHBtn);
            frm.StartPosition = FormStartPosition.CenterParent;
            frm.ShowDialog();
        }

        private void xtraTabPage2_Paint_1(object sender, PaintEventArgs e)
        {

        }
        /// <summary>
        /// 功率分析按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GLBtn_ItemClick_1(object sender, ItemClickEventArgs e)
        {

            //确定tab页名称
            string strDXtabname = "xtraTabPageGL";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }

        //导入功率文件
        private void DWGLopenfileBtn_Click(object sender, EventArgs e)
        {
            List<int> indexid = new List<int>();
            List<string> indexzt = new List<string>();
            DWCommon.getSFZT(gridView4, ref indexid, ref indexzt);

            ImportGLdatamanageForm frm = new ImportGLdatamanageForm(gridView4, "gl");
            frm.StartPosition = FormStartPosition.CenterParent;
            if (frm.ShowDialog(this) == DialogResult.OK)
            {
            }

            List<T_dwfile_account> gl_dataList = DataAnalysisToPG.getDwfile("txt", indexid, indexzt) as List<T_dwfile_account>;
            this.gridControl4.DataSource = gl_dataList;
            DWCommon.repushSFZT(gridView4, indexid);

        }
        //功率数据管理删除行
        private void DWGLdelBtn_Click(object sender, EventArgs e)
        {

            if (UserInform.userinf.Pow == 0)
            {
                XtraMessageBox.Show("您无权删除数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                var selectRowId = this.gridView4.GetSelectedRows();
                if (selectRowId.Length == 0)
                {
                    XtraMessageBox.Show("请选中删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    if (this.Confirm("是否删除") == DialogResult.OK)
                    {
                        List<T_dwfile_account> deletelist = new List<T_dwfile_account>();
                        foreach (var item in selectRowId)
                        {
                            deletelist.Add(new T_dwfile_account() { Id = Convert.ToInt32(this.gridView4.GetRowCellValue(item, "Id")) });
                        }

                        SqlQueryable_QX.DWGLDeleteRows(deletelist);
                        XtraMessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.data_binding();
                    }
                    else
                    {
                        return;
                    }
                }
            }

        }

        /// <summary>
        /// 缺口分析按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void QKBtn_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strDXtabname = "xtraTabPageQK";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }

        //导入缺口文件
        private void DWQKopenfileBtn_Click(object sender, EventArgs e)
        {
            List<int> indexid = new List<int>();
            List<string> indexzt = new List<string>();
            DWQKCommon.getSFZT(gridView5, ref indexid, ref indexzt);

            ImportGLdatamanageForm frm = new ImportGLdatamanageForm(gridView5,"qk");
            frm.StartPosition = FormStartPosition.CenterParent;
            if (frm.ShowDialog(this) == DialogResult.OK)
            {

            }
     
            List<T_dwqkfile_account> qk_dataList = DataAnalysisToPG.getDwqkfile("txt", indexid, indexzt) as List<T_dwqkfile_account>;
            this.gridControl5.DataSource = qk_dataList;
            DWQKCommon.repushSFZT(gridView5, indexid);
        }
        /// <summary>
        /// 缺口分析按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void DWSJBtn_ItemClick(object sender, ItemClickEventArgs e)
        {

            //确定tab页名称
            string strDXtabname = "xtraTabPageDWZS";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strDXtabname);
        }

        private void gridControl5_Click(object sender, EventArgs e)
        {

        }

        private void barButtonItem30_ItemClick_1(object sender, ItemClickEventArgs e)
        {

        }

        private void gjInform9_Load(object sender, EventArgs e)
        {

        }

        private void gjInform10_Load(object sender, EventArgs e)
        {

        }


        #region 功率数据管理查看
        private void barButtonItem30_ItemClick_2(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strGLDatatabname = "xtraTabPageGLData";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strGLDatatabname);

        }
        #endregion
        #region 缺口数据管理查看
        private void barButtonItem31_ItemClick(object sender, ItemClickEventArgs e)
        {
            //确定tab页名称
            string strQKDatatabname = "xtraTabPageQKData";
            //判断tab页是否已经创建，如果已创建直接显示
            tabtools.addTabmenu(xtraTabControl1, strQKDatatabname);
        }
        #endregion
        // 删除功率信息管理数据
        private void deleteGLdata_Click(object sender, EventArgs e)
        {

            if (UserInform.userinf.Pow == 0)
            {
                XtraMessageBox.Show("您无权删除数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                var selectRowId = this.gridView6.GetSelectedRows();
                if (selectRowId.Length == 0)
                {
                    XtraMessageBox.Show("请选中删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    if (this.Confirm("是否删除") == DialogResult.OK)
                    {
                        List<T_gonglv_account> deletelist = new List<T_gonglv_account>();
                        foreach (var item in selectRowId)
                        {
                            deletelist.Add(new T_gonglv_account() { Id = this.gridView6.GetRowCellValue(item, "Id").ToString() });
                        }

                        SqlQueryable_QX.GLDeleteRows(deletelist);
                        XtraMessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.data_binding();
                    }
                    else
                    {
                        return;
                    }
                }
            }
        }

        private void dcInform8_Load(object sender, EventArgs e)
        {

        }
        //删除缺口信息管理数据
        private void deleteQKdata_Click(object sender, EventArgs e)
        {


            if (UserInform.userinf.Pow == 0)
            {
                XtraMessageBox.Show("您无权删除数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                var selectRowId = this.gridView7.GetSelectedRows();
                if (selectRowId.Length == 0)
                {
                    XtraMessageBox.Show("请选中删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    if (this.Confirm("是否删除") == DialogResult.OK)
                    {
                        List<T_quekou_account> deletelist = new List<T_quekou_account>();
                        foreach (var item in selectRowId)
                        {
                            deletelist.Add(new T_quekou_account() { Id = this.gridView7.GetRowCellValue(item, "Id").ToString() });
                        }

                        SqlQueryable_QX.QKDeleteRows(deletelist);
                        XtraMessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.data_binding();
                    }
                    else
                    {
                        return;
                    }
                }
            }
        }

        private void importGLData_Click(object sender, EventArgs e)
        {
            ImportGLdataForm frm = new ImportGLdataForm();
            frm.StartPosition = FormStartPosition.CenterParent;
            if (frm.ShowDialog(this) == DialogResult.OK)
            {
            }
        }

        private void gridControl4_Click(object sender, EventArgs e)
        {

        }

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            ImportGLdataForm frm = new ImportGLdataForm();
            frm.StartPosition = FormStartPosition.CenterParent;
            frm.Text = "导入缺口配置文件";
            if (frm.ShowDialog(this) == DialogResult.OK)
            {
            }
        }

        //删除电务缺口数据选中行
        private void DWQKdelBtn_Click(object sender, EventArgs e)
        {

            if (UserInform.userinf.Pow == 0)
            {
                XtraMessageBox.Show("您无权删除数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                var selectRowId = this.gridView5.GetSelectedRows();
                if (selectRowId.Length == 0)
                {
                    XtraMessageBox.Show("请选中删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    if (this.Confirm("是否删除") == DialogResult.OK)
                    {
                        List<T_dwqkfile_account> deletelist = new List<T_dwqkfile_account>();
                        foreach (var item in selectRowId)
                        {
                            deletelist.Add(new T_dwqkfile_account() { Id = Convert.ToInt32(this.gridView5.GetRowCellValue(item, "Id")) });
                        }

                        SqlQueryable_QX.DWQKDeleteRows(deletelist);
                        XtraMessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.data_binding();
                    }
                    else
                    {
                        return;
                    }
                }
            }

        }

        private void DWGLanalysisBtn_Click(object sender, EventArgs e)
        {
            new DataAnalysisClass("功率", gridView4.GetSelectedRows(), ref gridControl4, ref gridView4);
        }

        private void DWQKanalysisBtn_Click(object sender, EventArgs e)
        {
            new DataAnalysisClass("缺口", gridView5.GetSelectedRows(), ref gridControl5, ref gridView5);
        }
    }
}