From db08e93569ee28f23bf0406dda112a5e3880b2a9 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 21 八月 2023 17:54:35 +0800 Subject: [PATCH] 给模型类添加注释 --- DataLoader/CS/PostgreHelper.cs | 3 DataLoader/DataLoader.csproj | 1 DataLoader/Model/SysDir.cs | 90 ++++++++++++++++++++++ DataLoader/CS/MetaHelper.cs | 27 ++++++ DataLoader/Model/SysMeta.cs | 97 +++++++++++++++++++++++ 5 files changed, 216 insertions(+), 2 deletions(-) diff --git a/DataLoader/CS/MetaHelper.cs b/DataLoader/CS/MetaHelper.cs index 825bca7..71edbf5 100644 --- a/DataLoader/CS/MetaHelper.cs +++ b/DataLoader/CS/MetaHelper.cs @@ -1,4 +1,5 @@ 锘縰sing DataLoader.Model; +using Npgsql; using System; using System.Collections.Generic; using System.Data.Common; @@ -32,5 +33,31 @@ return count; } + + /// <summary> + /// 鏍规嵁GUID鏌ヨ璺緞 + /// </summary> + public static string GetFilePathByGuid(string guid) + { + string sql = "select path from lf.sys_meta where guid = @guid limit 1"; + + DbParameter dp = new NpgsqlParameter("@guid", guid); + object obj = Tools.DBHelper.GetScalar(sql, dp); + + return obj == null ? null : obj.ToString(); + } + + /// <summary> + /// 鏂囦欢鏄�/鍚﹀瓨鍦� + /// </summary> + public static bool IsFileExists(string guid) + { + string sql = "select count(*) from lf.sys_meta where guid = @guid"; + + DbParameter dp = new NpgsqlParameter("@guid", guid); + object obj = Tools.DBHelper.GetScalar(sql, dp); + + return obj != null && Convert.ToInt32(obj) > 0; + } } } diff --git a/DataLoader/CS/PostgreHelper.cs b/DataLoader/CS/PostgreHelper.cs index 11f4ead..7d4d2fc 100644 --- a/DataLoader/CS/PostgreHelper.cs +++ b/DataLoader/CS/PostgreHelper.cs @@ -10,6 +10,9 @@ namespace DataLoader.CS { + /// <summary> + /// DB鏋氫妇 + /// </summary> public enum DbEnum { langfang = 0, diff --git a/DataLoader/DataLoader.csproj b/DataLoader/DataLoader.csproj index 0114832..cfd6f6f 100644 --- a/DataLoader/DataLoader.csproj +++ b/DataLoader/DataLoader.csproj @@ -142,6 +142,7 @@ <Compile Include="CS\ModelHandler.cs" /> <Compile Include="CS\NtstWeb.cs" /> <Compile Include="CS\PostgreHelper.cs" /> + <Compile Include="Model\SysDir.cs" /> <Compile Include="Model\ViewData.cs" /> <Compile Include="LoginWin.xaml.cs"> <DependentUpon>LoginWin.xaml</DependentUpon> diff --git a/DataLoader/Model/SysDir.cs b/DataLoader/Model/SysDir.cs new file mode 100644 index 0000000..3787004 --- /dev/null +++ b/DataLoader/Model/SysDir.cs @@ -0,0 +1,90 @@ +锘縰sing log4net.Core; +using System; +using System.Collections.Generic; +using System.Linq; +using System.Runtime.InteropServices.ComTypes; +using System.Security.Cryptography; +using System.Security.Policy; +using System.Text; +using System.Threading.Tasks; + +namespace DataLoader.Model +{ + /// <summary> + /// 鐩綍绫� + /// </summary> + public class SysDir + { + public SysDir() { } + + /// <summary> + /// 涓婚敭ID + /// </summary> + public int id { set; get; } + + /// <summary> + /// 鐖禝D锛�0-鏍硅妭鐐� + /// </summary> + public int pid { set; get; } + + /// <summary> + /// 鍚嶇О + /// </summary> + public string name { set; get; } + + /// <summary> + /// 鎵╁睍鍚� + /// </summary> + public string exts { set; get; } + + /// <summary> + /// 鐩綍璇存槑 + /// </summary> + public string descr { set; get; } + + /// <summary> + /// 灞傜骇锛�0-鏍硅妭鐐� + /// </summary> + public int level { set; get; } + + /// <summary> + /// 鎺掑簭鍙� + /// </summary> + public int order_num { set; get; } + + /// <summary> + /// 鍒涘缓浜篒D + /// </summary> + public int create_user { set; get; } + + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + public DateTime create_time { set; get; } + + /// <summary> + /// 鍒涘缓浜篒D + /// </summary> + public int update_user { set; get; } + + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + public DateTime update_time { set; get; } + + /// <summary> + /// 妫�鏌ラ」 + /// </summary> + public string checks { set; get; } + + /// <summary> + /// 澶囨敞 + /// </summary> + public string bak { set; get; } + + /// <summary> + /// 缂栫爜 + /// </summary> + public string code { set; get; } + } +} diff --git a/DataLoader/Model/SysMeta.cs b/DataLoader/Model/SysMeta.cs index f2e52f3..234db19 100644 --- a/DataLoader/Model/SysMeta.cs +++ b/DataLoader/Model/SysMeta.cs @@ -6,77 +6,170 @@ namespace DataLoader.Model { /// <summary> - /// 鍏冩暟鎹� + /// 鍏冩暟鎹被 /// </summary> public class SysMeta { public SysMeta() { } /// <summary> - /// + /// 涓婚敭ID /// </summary> public int id { set; get; } + /// <summary> + /// 璁板綍GUID + /// </summary> public string eventid { set; get; } + /// <summary> + /// 鐖跺厓鏁版嵁ID锛�0-娌℃湁 + /// </summary> public int metaid { set; get; } + /// <summary> + /// 鐗堟湰ID + /// </summary> public int verid { set; get; } + /// <summary> + /// 鍚嶇О + /// </summary> public string name { set; get; } + /// <summary> + /// 鏂囦欢绫诲瀷/鎵╁睍鍚� + /// </summary> public string type { set; get; } + /// <summary> + /// 鏂囦欢GUID + /// </summary> public string guid { set; get; } + /// <summary> + /// 瀛樺偍璺緞 + /// </summary> public string path { set; get; } + /// <summary> + /// 澶у皬锛氬崟浣峂B + /// </summary> public double sizes { set; get; } + /// <summary> + /// 琛ㄥ悕 + /// </summary> public string tab { set; get; } + /// <summary> + /// 琛屾暟 + /// </summary> public int rows { set; get; } + /// <summary> + /// 鍒涘缓浜篒D + /// </summary> public int create_user { set; get; } + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> public DateTime create_time { set; get; } + /// <summary> + /// 鏇存柊浜篒D + /// </summary> public int update_user { set; get; } + /// <summary> + /// 鏇存柊鏃堕棿 + /// </summary> public DateTime update_time { set; get; } + /// <summary> + /// 澶囨敞 + /// </summary> public string bak { set; get; } + /// <summary> + /// 绌洪棿浣嶇疆 + /// </summary> public string geom { set; get; } + /// <summary> + /// 鍥惧眰 + /// </summary> public string layer { set; get; } + /// <summary> + /// 鍗曚綅缂栫爜 + /// </summary> public string depcode { set; get; } + /// <summary> + /// 鐩綍缂栫爜 + /// </summary> public string dircode { set; get; } + /// <summary> + /// 鏄�/鍚︿负鍏冩暟鎹� + /// </summary> public int ismeta { set; get; } + /// <summary> + /// 浼犳劅鍣ㄧ被鍨� + /// </summary> public string sensortype { set; get; } + /// <summary> + /// 閲囬泦鏃堕棿 + /// </summary> public DateTime acq_time { set; get; } + /// <summary> + /// 鍒嗚鲸鐜� + /// </summary> public string resolution { set; get; } + /// <summary> + /// 琛屽垪鍙� + /// </summary> public string gridsize { set; get; } + /// <summary> + /// 鍧愭爣绯荤粺 + /// </summary> public string coor_sys { set; get; } + /// <summary> + /// EPSG缂栫爜 + /// </summary> public string epsg { set; get; } + /// <summary> + /// 楂樼▼鍩哄噯 + /// </summary> public string h_datum { set; get; } + /// <summary> + /// 鍏冩暟鎹被鍨� + /// </summary> public string mata_type { set; get; } + /// <summary> + /// 娉㈡鏁� + /// </summary> public string bands { set; get; } + /// <summary> + /// 娉㈡鏁版嵁绫诲瀷 + /// </summary> public string band_type { set; get; } + /// <summary> + /// 鏁版嵁棰滆壊琛� + /// </summary> public string ct { set; get; } } } -- Gitblit v1.9.3