From 8482a6fef58c0d699795435ef525a8f188e502a1 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 21 八月 2023 13:44:11 +0800 Subject: [PATCH] 修改Postgres数据库帮助类 --- DataLoader/CS/StaticData.cs | 110 ++++++++++++++++++++++++++++++++++++++++--------------- 1 files changed, 80 insertions(+), 30 deletions(-) diff --git a/DataLoader/CS/StaticData.cs b/DataLoader/CS/StaticData.cs index 5fa5089..07e157c 100644 --- a/DataLoader/CS/StaticData.cs +++ b/DataLoader/CS/StaticData.cs @@ -1,8 +1,6 @@ 锘縰sing System; using System.Collections.Generic; using System.Linq; -using System.Text; -using System.Threading.Tasks; namespace DataLoader.CS { @@ -10,39 +8,91 @@ { public static String BasePath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase; - /** - * JP2鏂囦欢鎵╁睍鍚� - */ - public static List<String> JP2_EXT = new List<String> { "jp2.aux.xml" }; + public static String ADMIN = "admin"; - /** - * MPT鏂囦欢鎵╁睍鍚� - */ - public static List<String> MPT_EXT = new List<String> { ".midx", ".strmi" }; + public readonly static String ZIP = ".zip"; - /** - * IMG鏂囦欢鎵╁睍鍚� - */ - public static List<String> IMG_EXT = new List<String> { ".rrd", ".img.aux.xml", ".hdr", ".img.enp", ".img.xml" }; + public readonly static String XLS = ".xls"; - /** - * TIF鏂囦欢鎵╁睍鍚� - */ - public static List<String> TIF_EXT = new List<String> { ".prj", ".tfw", ".tif.ovr", ".tif.aux.xml", ".tif.enp", ".tif.xml" }; + public readonly static String XLSX = ".xlsx"; - /** - * TIFF鏂囦欢鎵╁睍鍚� - */ - public static List<String> TIFF_EXT = new List<String> { ".prj", ".tfw", ".tiff.ovr", ".tiff.aux.xml", ".tiff.enp", ".tiff.xml" }; + public readonly static String MDB = ".mdb"; - /** - * SHP鏂囦欢鎵╁睍鍚� - */ - public static List<String> SHP_EXT = new List<String> { ".shx", ".dbf", ".prj", ".cpg" }; + public readonly static String SHP = ".shp"; - /** - * 鎵�鏈夋枃浠舵墿灞曞悕 - */ - public static List<String> ALL_EXTENSION = new List<String> { ".pdf", ".xls", ".xlsx", ".doc", ".docx", ".ppt", ".pptx", ".shp", ".gdb", ".mdb", ".dwg", ".las", ".laz", ".cpt", ".mpt", ".fly", ".efb", ".g3d", ".fbx", ".obj", ".3dm", ".3dml", ".osgb", ".rvt", ".ifc", ".jpg", ".png", ".img", ".tif", ".tiff", ".bmp", ".gif", ".rmvb", ".rm", ".mp3", ".mp4", ".avi", ".wma", ".wmv", ".7z", ".rar", ".zip", ".db", ".jp2", ".txt", ".xml" }; + public readonly static String NGDB = "gdb"; + + public readonly static String GDB = ".gdb"; + + public readonly static String JPG = ".jpg"; + + public readonly static String IMG = ".img"; + + public readonly static String MPT = ".mpt"; + + public readonly static String D3DML = ".3dml"; + + public readonly static String TIF = ".tif"; + + public readonly static String TIFF = ".tiff"; + + public readonly static String LAS = ".las"; + + public readonly static String OSGB = ".osgb"; + + /// <summary> + /// 16杩涘埗 + /// </summary> + public static readonly char[] HEX_DIGITS = { '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f' }; + + /// <summary> + /// 瀵嗙爜姝e垯琛ㄨ揪寮� + /// </summary> + public readonly static String PWD_REG = "^(?![a-zA-Z]+$)(?![A-Z0-9]+$)(?![A-Z\\W!@#$%^&*`~()\\-_+=,.?;<>]+$)(?![a-z0-9]+$)(?![a-z\\W!@#$%^&*`~()\\-_+=,.?;<>]+$)(?![0-9\\W!@#$%^&*`~()\\-_+=,.?;<>]+$)[a-zA-Z0-9\\W!@#$%^&*`~()\\-_+=,.?;<>]{12,20}$"; + + /// <summary> + /// MPT鏂囦欢鎵╁睍鍚� + /// </summary> + public readonly static List<String> MPT_EXT = new List<String> { ".midx", ".strmi", ".ei.midx", ".ei.mpt", ".ei.strmi" }; + + /// <summary> + /// JPG鏂囦欢鎵╁睍鍚� + /// </summary> + public readonly static List<String> JPG_EXT = new List<String> { ".jpg.aux.xml", ".jpg.ovr", ".jpg.xml", ".jgw", ".prj" }; + + /// <summary> + /// JP2鏂囦欢鎵╁睍鍚� + /// </summary> + public readonly static List<String> JP2_EXT = new List<String> { ".jp2.aux.xml", ".jp2.ovr", ".jp2.xml", ".jgw", ".prj", ".jp2.html", ".jp2.txt" }; + + /// <summary> + /// IMG鏂囦欢鎵╁睍鍚� + /// </summary> + public readonly static List<String> IMG_EXT = new List<String> { ".rrd", ".img.aux.xml", ".hdr", ".img.enp", ".img.xml" }; + + /// <summary> + /// TIF鏂囦欢鎵╁睍鍚� + /// </summary> + public readonly static List<String> TIF_EXT = new List<String> { ".prj", ".tfw", ".aux", ".tif.ovr", ".tif.aux.xml", ".tif.xml" }; + + /// <summary> + /// TIFF鏂囦欢鎵╁睍鍚� + /// </summary> + public readonly static List<String> TIFF_EXT = new List<String> { ".prj", ".tfw", ".aux", ".tiff.ovr", ".tiff.aux.xml", ".tiff.xml" }; + + /// <summary> + /// SHP鏂囦欢鎵╁睍鍚� + /// </summary> + public readonly static List<String> SHP_EXT = new List<String> { ".shx", ".dbf", ".prj", ".cpg" }; + + /// <summary> + /// Mapper鎺掗櫎鎵╁睍鍚� + /// </summary> + public readonly static List<String> MAPPER_EXCLUDE_EXT = new List<String> { ".jpg.aux.xml", ".jpg.xml", ".jp2.aux.xml", ".jp2.xml", ".jp2.html", ".jp2.txt", ".img.aux.xml", ".img.xml", ".tif.aux.xml", ".tif.xml", ".tiff.aux.xml", ".tiff.xml", ".shp.xml" }; + + /// <summary> + /// 鎵�鏈夋枃浠舵墿灞曞悕 + /// </summary> + public readonly static List<String> ALL_EXTENSION = new List<String> { ".txt", ".xml", ".pdf", ".xls", ".xlsx", ".doc", ".docx", ".ppt", ".pptx", ".shp", ".gdb", ".mdb", ".dwg", ".las", ".laz", ".cpt", ".mpt", ".ei.mpt", ".fly", ".efb", ".g3d", ".fbx", ".obj", ".3dm", ".3dml", ".osgb", ".rvt", ".ifc", ".jpg", ".jp2", ".png", ".img", ".tif", ".tiff", ".dem", ".bmp", ".gif", ".rmvb", ".rm", ".mp3", ".mp4", ".avi", ".wma", ".wmv", ".7z", ".rar", ".zip" }; } } -- Gitblit v1.9.3