jiance-analysis/DPTools/components/ZZJH/ZZJHCtrl.cs

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

namespace Uninpho.Tools.components.ZZJH
{
    public partial class ZZJHCtrl : DevExpress.XtraEditors.XtraUserControl
    {
        public ZZJHCtrl()
        {
            InitializeComponent();
        }

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

        private void gridView1_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)
        {
            DataAnalysis.DACommon.addXuHao(e);
        }
        List<T_zhuzhenjihe_filelist> dataSource = null;
        private void ZZJHCtrl_Load(object sender, EventArgs e)
        {
            if (UserInform.isconnect)
            {
                dataSource = DataAnalysisToPG.getfilezzjh();
                gridControl1.DataSource = dataSource;
            }
            ExcelTools.gridControl02 = gridControl1;
            ExcelTools.gridView02 = gridView1;
        }
        int i = 1;
        private void repositoryItemHyperLinkEdit3_Click(object sender, EventArgs e)
        {
            string url = Application.StartupPath + "\\zzjh_temp\\templook" + i.ToString() + ".xlsx";
            int[] rowhandles = gridView1.GetSelectedRows();
            int rowhandle = gridView1.FocusedRowHandle;

            string btyearr = gridView1.GetRowCellValue(rowhandle, "Excelbytearr").ToString();
            ExcelTools.writeFile(btyearr, url);
            LookDataFromZZJH ldf = new LookDataFromZZJH(url, gridView1, rowhandle);
            ldf.StartPosition = FormStartPosition.CenterParent;
            ldf.ShowDialog();
            //System.Diagnostics.Process.Start(url);
            i++;
        }

        public void FilterDate(DateTime start, DateTime end)
        {
            List<T_zhuzhenjihe_filelist> filterDS = new List<T_zhuzhenjihe_filelist>();
            foreach (var item in dataSource)
            {
                DateTime riqi = DateTime.Parse(item.Riqi);
                if ((start <= riqi) && (riqi <= end))
                {
                    filterDS.Add(item);
                }
            }
            this.gridControl1.DataSource = filterDS;
            this.gridView1.BestFitColumns();
        }
        /// <summary>
        /// 重置
        /// </summary>
        private void simpleButton4_Click(object sender, EventArgs e)
        {
            this.dateEdit1.EditValue = null;
            this.dateEdit2.EditValue = null;
            this.gridControl1.DataSource = dataSource;
            this.gridView1.BestFitColumns();
        }
        /// <summary>
        /// 查询
        /// </summary>
        private void btn_dm_query_Click(object sender, EventArgs e)
        {
            FilterDate(this.dateEdit1.DateTime, this.dateEdit2.DateTime);
        }

        /// <summary>
        /// 删除
        /// </summary>
        private void delPGBtn_Click(object sender, EventArgs e)
        {
            if (UserInform.userinf.Pow == 0)
            {
                XtraMessageBox.Show("您无权删除数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                var row = gridView1.GetSelectedRows();
                if (row.Length == 0)
                {
                    XtraMessageBox.Show("请选中删除的行", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    if (XtraMessageBox.Show("是否删除所选？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                    {
                        for (int i = row.Length - 1; i >= 0; i--)
                        {
                            var va1 = gridView1.GetRowCellValue(row[i], "Id").ToString();
                            DataAnalysisToPG.DelToPGZZJH(new T_zhuzhenjihe_filelist()
                            {
                                Id = va1,
                            });
                            gridView1.DeleteRow(row[i]);
                        }
                        XtraMessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
        }
    }
}