修改“加载”功能

13693261870

2023-08-22 9f300514a23b1e008a3314c0b782ef67f190e7af

修改“加载”功能

 DataLoader/App.config

@@ -2,7 +2,7 @@
<configuration>
  <appSettings>
    <add key="StartPath" value="1"/>
    <add key="SourcePath" value="D:\LF\import"/>
    <add key="SourcePath" value="D:\Moon\data"/>
    <add key="TargetPath" value="D:\LF\upload"/>
    <!--<add key="pgConn" value="Server=127.0.0.1;Port=5433;Database=langfang;User Id=postgres;Password=postgres;"/>-->
    <add key="pgConn" value="Server=192.168.20.83;Port=5433;Database=moon;User Id=postgres;Password=Postgres!_14_moon;"/>

 DataLoader/CS/DBHelper.cs

@@ -76,7 +76,7 @@
        /// </summary>
        public static List<SysDir> GetDirList()
        {
            string sql = "select a.*, fn_get_fullname(a.code, 2) fullName from lf.sys_dir a";
            string sql = "select a.*, fn_get_fullname(a.code, 2) fullName from lf.sys_dir a order by pid, order_num, id";
            DataTable dt = Tools.DBHelper.GetDataTable(sql);
            if (null == dt || dt.Rows.Count == 0) return null;


 DataLoader/CS/Importor.cs

@@ -15,18 +15,62 @@
        /// </summary>
        public static void GetFiles(ObservableCollection<ViewData> viewDatas)
        {
            string[] files = Directory.GetFiles(CommonProp.SourcePath);
            string[] files = Directory.GetFiles(CommonProp.SourcePath, "*", SearchOption.AllDirectories);
            for (int i = 0, c = files.Length; i < c; i++)
            {
                string file = files[i];
                string ext = Path.GetExtension(file).ToLower();
                if (!StaticData.ALL_EXTENSION.Contains(ext) || IsExcludFile(file))
                {
                    continue;
                }

                ViewData vd = new ViewData();
                vd.ID = i + 1;
                vd.FilePath = files[i];
                vd.Ext = System.IO.Path.GetExtension(files[i]);
                vd.FilePath = file;
                vd.Ext = ext;
                vd.Status = "准备";
                viewDatas.Add(vd);

                SetSysMeta(vd);
            }
        }

        /// <summary>
        /// 设置元数据
        /// </summary>
        private static void SetSysMeta(ViewData vd)
        {
            FileInfo fi = new FileInfo(vd.FilePath);

            vd.Meta = new SysMeta();
            vd.Meta.name = fi.Name;
            //vd.Meta.dirid = Common.DirId;
            //vd.Meta.depid = 1;
            vd.Meta.verid = 0;
            vd.Meta.type = fi.Extension.ToLower().Replace(".", "");
            vd.Meta.sizes = Tools.SizeToMb(fi.Length);
            vd.Meta.create_user = CommonProp.UserId;
        }

        /// <summary>
        /// 是/否为排除文件
        /// </summary>
        private static bool IsExcludFile(string file)
        {
            bool isExclud = false;

            string name = Path.GetFileName(file).ToLower();
            foreach (string ss in StaticData.MAPPER_EXCLUDE_EXT)
            {
                if (name.EndsWith(ss))
                {
                    isExclud = true;
                    break;
                }
            }

            return isExclud;
        }

        /// <summary>
@@ -79,20 +123,6 @@

                SetSysMeta(vd);
            }
        }

        private static void SetSysMeta(ViewData vd)
        {
            FileInfo fi = new FileInfo(vd.FilePath);

            vd.Meta = new SysMeta();
            vd.Meta.name = fi.Name;
            //vd.Meta.dirid = Common.DirId;
            //vd.Meta.depid = 1;
            vd.Meta.verid = 0;
            vd.Meta.type = fi.Extension.ToLower().Replace(".", "");
            vd.Meta.sizes = Tools.SizeToMb(fi.Length);
            vd.Meta.create_user = CommonProp.UserId;
        }

        public static void ImportFiles(ObservableCollection<ViewData> viewDatas, string target, int start)

 DataLoader/MainWindow.xaml.cs

@@ -134,11 +134,13 @@
                MessageBox.Show("请选择资源目录！", "提示");
                return;
            }
            CommonProp.SourcePath = this.tbSource.Text.Trim();
            if (string.IsNullOrEmpty(CommonProp.SourcePath) || !Directory.Exists(CommonProp.SourcePath))
            {
                MessageBox.Show("请选择数据目录或数据目录不存在！", "提示");
                return;
            }
            CommonProp.TargetPath = this.tbTarget.Text.Trim();
            if (string.IsNullOrEmpty(CommonProp.TargetPath) || !Directory.Exists(CommonProp.TargetPath))
            {
                MessageBox.Show("请选择入库目录或入库目录不存在！", "提示");