DataLoader/CS/MetaHelper.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
DataLoader/CS/PostgreHelper.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
DataLoader/DataLoader.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
DataLoader/Model/SysDir.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
DataLoader/Model/SysMeta.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
DataLoader/CS/MetaHelper.cs
@@ -1,4 +1,5 @@ using 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; } } } DataLoader/CS/PostgreHelper.cs
@@ -10,6 +10,9 @@ namespace DataLoader.CS { /// <summary> /// DBæä¸¾ /// </summary> public enum DbEnum { langfang = 0, 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> DataLoader/Model/SysDir.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,90 @@ using 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> /// ç¶IDï¼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> /// å建人ID /// </summary> public int create_user { set; get; } /// <summary> /// å建æ¶é´ /// </summary> public DateTime create_time { set; get; } /// <summary> /// å建人ID /// </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; } } } 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> /// 大å°ï¼åä½MB /// </summary> public double sizes { set; get; } /// <summary> /// 表å /// </summary> public string tab { set; get; } /// <summary> /// è¡æ° /// </summary> public int rows { set; get; } /// <summary> /// å建人ID /// </summary> public int create_user { set; get; } /// <summary> /// å建æ¶é´ /// </summary> public DateTime create_time { set; get; } /// <summary> /// æ´æ°äººID /// </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; } } }