jiance-analysis/DPTools/components/DataAnalysis/DWCommon.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Uninpho.DBOperation.Model;
using Uninpho.DBOperation.Operation;
using System.IO;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraGrid;
using DevExpress.XtraBars;

namespace Uninpho.Tools.components.DataAnalysis
{
  
    class DWCommon
    {
        /// <summary>
        /// 高速还是低速
        /// 0：高速  1：低速  2：全选
        /// </summary>
        public static int gdsBool = 0;
        /// <summary>
        /// 是否进行里程修正
        /// </summary>
        public static bool xzlcBool = true;
        /// <summary>
        /// 检测车
        /// </summary>
        public static List<string> jccList = new List<string>();
        public static string lj;
        /// <summary>
        /// 打开文件夹公共函数
        /// </summary>
        public static void OpenFile(string houzhui,bool ischecked,GridView GV)
        {
            List<T_dwfile_account> filelist = new List<T_dwfile_account>();
            //批量
            //if (ischecked)
            //{

            //    var dialog = new FolderBrowserDialog();
            //    if (dialog.ShowDialog() == DialogResult.OK)
            //    {
            //        DirectoryInfo DirInfo = new DirectoryInfo(dialog.SelectedPath);
            //        houzhui = "." + houzhui;
            //        var files = from f in DirInfo.EnumerateFiles()
            //                    where houzhui.Contains(f.Extension.ToLower())
            //                    select f;

            //        // Show results.
            //        foreach (var f in files)
            //        {
            //            T_dwfile_account tfa= GLFileNameSplit1(f.FullName);

            //            var isfile = DataAnalysisToPG.DWQueryToPGByNameFile(tfa.Filename) as List<T_dwfile_account>;
            //            if (isfile.Count == 0)
            //            {
            //                filelist.Add(tfa);
            //            }
            //            else
            //            {
            //                if (XtraMessageBox.Show("检测到数据库内存在同名数据:\n" + tfa.Filename+"，\n是否覆盖数据库内数据?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
            //                {
            //                    filejiancedel(tfa);
            //                    filelist.Add(tfa);
            //                }
            //            }
            //        }
            //        DataAnalysisToPG.GLInsertToPG(filelist);
            //    }
            //}
            //else
            //{
            var dialog = new OpenFileDialog();
                dialog.Multiselect = true;
                dialog.Title = "请选择文件夹";
                dialog.Filter = houzhui+"文件(*." + houzhui + ")|*." + houzhui;
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    string[] file = dialog.FileNames;

                    for (int i = 0; i < file.Length; i++)
                    {
                        T_dwfile_account tfa = GLFileNameSplit1(file[i]);
                       //获取数据后
                        var isfile = DataAnalysisToPG.DWQueryToPGByNameFile(tfa.Filename) as List<T_dwfile_account>;
                         lj = file[i]; //传路径
                        if (isfile.Count == 0)
                        {
                            filelist.Add(tfa);
                        }
                        else
                        {
                            if (XtraMessageBox.Show("检测到数据库内存在同名数据:\n" + tfa.Filename + "，\n是否覆盖数据库内数据?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
                            {
                                filejiancedel(tfa);
                                filelist.Add(tfa);
                            }
                        }

                    }
                    DataAnalysisToPG.GLInsertToPG(filelist);
                }
            //}


        }
    

        /// 清理数据库同名数据
        private static void filejiancedel(T_dwfile_account file)
        {
            lj = "";
             
        }

        /// 解析电务功率数据
        private static T_dwfile_account GLFileNameSplit1(string filename)
        {
            string ysname = Path.GetFileName(filename);
            //string[] xlbh = HBXLSplit(filearr[2].Split('.')[0]);// 解析线路编号和行车方向
            string wjdx = Math.Ceiling(new FileInfo(filename).Length / 1024.0 / 1024.0) + " MB";//文件大小
            //T_luxianming_sf xlpg = DataAnalysisToPG.QueryToXlm(xlbh[0]) as T_luxianming_sf;//获取线路名
            string lj = filename;
            return new T_dwfile_account()
            {
              
                Xianlu = "襄阳",
                Chezhan = "三坝",
                Starttime = "xx年xx月xx日",
                Endtime = "xx时xx分xx秒",
                Filename = ysname,
                Filesize = wjdx,
                Filestatus = "正常",
                Taskstatus = "算法未执行",
                Srlj = lj,
               
            };
        }
       
        /// <summary>
        /// 解析方向
        /// </summary>
        private static string getZF(string ZF)
        {
            string zf = ZF.Split('_')[0];
            if (zf == "0")
            {
                return "反向";
            }
            else
            {
                return "正向";
            }
        }
        /// <summary>
        /// 解析时间
        /// </summary>
        private static string getYMDHMS(string ymd,string hms)
        {
            //如果这里以后修改，轮轨力输入检测日期那块也要改！！！
            Char[] ymdcha = ymd.ToCharArray();//年月日
            Char[] hmscha = hms.ToCharArray();//时分秒
            string year = ymdcha[4].ToString() + ymdcha[5].ToString() + ymdcha[6].ToString() + ymdcha[7].ToString();
            string mouth = ymdcha[2].ToString() + ymdcha[3].ToString();
            string day = ymdcha[0].ToString() + ymdcha[1].ToString();
            string hour = hmscha[0].ToString() + hmscha[1].ToString();
            string minite = hmscha[2].ToString() + hmscha[3].ToString();
            string second = hmscha[4].ToString() + hmscha[5].ToString();
            return year+ "年"  +mouth + "月" + day + "日" + hour + "时" + minite + "分" + second + "秒";
        }
        private static string getYMDHMS(string ymd)
        {
            //如果这里以后修改，轮轨力输入检测日期那块也要改！！！
            Char[] ymdcha = ymd.ToCharArray();//年月日
            string year = ymdcha[0].ToString() + ymdcha[3].ToString();
            string mouth = ymdcha[6].ToString() + ymdcha[7].ToString();
            string day = ymdcha[4].ToString() + ymdcha[5].ToString();
            return year + "年" + mouth + "月" + day + "日";
        }
        /// <summary>
        /// 解析行别和线路编号
        /// </summary>
        private static string[] HBXLSplit(string arr0)
        {
            Char[] cha = arr0.ToCharArray();
            string hb = "", xl = "";
            for (int i = 0; i < cha.Length; i++)
            {
                if (i != cha.Length-1)
                {
                    xl += cha[i];
                }
                else
                {
                    if (cha[i] == 'X')
                    {
                        hb = "下";
                    }
                    else if (cha[i] == 'S')
                    {
                        hb = "上";

                    }
                    else
                    {
                        hb = "未知";
                    }
                }
            }
            return new string[] {xl,hb };
        }
        /// <summary>
        /// 表前加序号
        /// </summary>
        /// <param name="e"></param>
        public static void addXuHao(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;
            }
            e.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
            if (e.Info.IsRowIndicator)
            {
                if (e.RowHandle >= 0)
                {
                    e.Info.DisplayText = (e.RowHandle + 1).ToString().Trim();
                }
                else if (e.RowHandle < 0 && e.RowHandle > -1000)
                {
                    e.Info.DisplayText = "G" + e.RowHandle.ToString();
                }
            }
        }
        
        /// <summary>
        /// 自动化初始化
        /// </summary>
        public static void initZDHFun(BarButtonItem barButtonItem)
        {
            initFile(zdhSetClass.path, zdhSetClass.initStr);
            StreamReader sr = new StreamReader(zdhSetClass.path);
            while (!sr.EndOfStream)
            {
                string[] str = sr.ReadLine().Split('灬');
                if (str[0] == "Interval")
                {
                    zdhSetClass.Interval = Convert.ToInt32(str[1]);
                    continue;
                }
                else if (str[0] == "folder")
                {
                    if (Directory.Exists(str[1]))
                    {
                        zdhSetClass.folder = str[1];
                    }
                    continue;
                }
                else if (str[0] == "startdate")
                {
                    zdhSetClass.startdate = str[1];
                    continue;
                }
                else if (str[0] == "taskName")
                {
                    zdhSetClass.taskName = str[1];
                    continue;
                }
                else if (str[0] == "isStartZDH")
                {
                    zdhSetClass.isStartZDH = Convert.ToInt32(str[1]);
                    continue;
                }
            }
            DirectoryInitNoDelNoHidde(zdhSetClass.folder + "geoData");
            DirectoryInitNoDelNoHidde(zdhSetClass.folder + "bnyData");

            if (zdhSetClass.isStartZDH == 0)
            {
                barButtonItem.ImageUri.Uri = "Prev"; //Refresh // Prev
                barButtonItem.Caption = "开启自动化";
            }
            else
            {
                barButtonItem.ImageUri.Uri = "Refresh"; //Refresh // Prev
                barButtonItem.Caption = "重启自动化";
            }
        }
        /// <summary>
        /// 创建文件
        /// </summary>
        public static void initFile(string path,string data)
        {
            if (!File.Exists(path))
            {
                File.WriteAllText(path, data);
            }
        }
        /// <summary>
        /// 复制文件
        /// </summary>
        /// <param name="filename">原始文件路径</param>
        /// <param name="newfilename">目的地文件路径</param>
        public static void FileCopy(string filename,string newfilename)
        {
            if (File.Exists(filename))
            {
                if (File.Exists(newfilename))
                {
                    File.Delete(newfilename);
                }
                File.Copy(filename, newfilename);
            }
        }
        /// <summary>
        /// 按文件夹删除（删除临时文件夹）
        /// </summary>
        /// <param name="DirectoryPath">文件夹路径</param>
        public static void DirectoryInit(string DirectoryPath)
        {
            if (Directory.Exists(DirectoryPath))
            {
                Directory.Delete(DirectoryPath, true); //删除文件夹及内容
            }
            DirectoryInfo di = Directory.CreateDirectory(DirectoryPath);
            di.Attributes = FileAttributes.Directory | FileAttributes.Hidden;
        }
        public static void DirectoryInitNoDel(string DirectoryPath)
        {
            if (!Directory.Exists(DirectoryPath))
            {
                DirectoryInfo di = Directory.CreateDirectory(DirectoryPath);
                di.Attributes = FileAttributes.Directory | FileAttributes.Hidden;
            }
        }
        public static void DirectoryInitNoDelNoHidde(string DirectoryPath)
        {
            if (!Directory.Exists(DirectoryPath))
            {
                DirectoryInfo di = Directory.CreateDirectory(DirectoryPath);
                di.Attributes = FileAttributes.Directory;
            }
        }
        /// <summary>
        /// 刷新后恢复选中
        /// </summary>
        /// <param name="gv"></param>
        /// <param name="selectid"></param>
        public static void repushSFZT(GridView gv,List<int> selectid)
        {
            for (int i = 0; i < gv.RowCount; i++)
            {
                for (int j = 0; j < selectid.Count; j++)
                {
                    if (gv.GetRowCellValue(i, "Id").ToString() == selectid[j].ToString())
                    {
                        gv.SelectRow(i);
                        break;
                    }
                }

            }
        }
        /// <summary>
        /// 获取刷新前id和状态
        /// </summary>
        /// <param name="gv"></param>
        /// <param name="selectid"></param>
        /// <param name="selectrowzt"></param>
        public static void getSFZT(GridView gv,ref List<int> selectid,ref List<string> selectrowzt)
        {
            var sele = gv.GetSelectedRows();
            foreach (var i in sele)
            {
                selectid.Add(Convert.ToInt32(gv.GetRowCellValue(i, "Id").ToString()));
                selectrowzt.Add(gv.GetRowCellValue(i, "Taskstatus").ToString());
            }
        }
    }
}