From 168fa6d53cf21bedeb65b299603b6961b93c1b41 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 21 八月 2023 16:43:29 +0800
Subject: [PATCH] 修改元数据实体类，添加数据插入方法
---
DataLoader/CS/MetaHelper.cs | 29 ++++++++++++++++++++++++++---
1 files changed, 26 insertions(+), 3 deletions(-)
diff --git a/DataLoader/CS/MetaHelper.cs b/DataLoader/CS/MetaHelper.cs
index 31427cc..825bca7 100644
--- a/DataLoader/CS/MetaHelper.cs
+++ b/DataLoader/CS/MetaHelper.cs
@@ -1,13 +1,36 @@
-锘縰sing System;
+锘縰sing DataLoader.Model;
+using System;
using System.Collections.Generic;
+using System.Data.Common;
using System.Linq;
-using System.Text;
-using System.Threading.Tasks;
namespace DataLoader.CS
{
+ /// <summary>
+ /// 鍏冩暟鎹府鍔╃被
+ /// </summary>
public class MetaHelper
{
+ // id, eventid, metaid, verid, name, type, guid, path, sizes, tab, rows, create_user, create_time, update_user, update_time, bak, geom, layer, depcode, dircode, ismeta, sensortype, acq_time, resolution, gridsize, coor_sys, epsg, h_datum, mata_type, bands, band_type, ct
+ public static string insertSql = "insert into lf.sys_meta (eventid, metaid, verid, name, type, guid, path, sizes, tab, rows, create_user, create_time, bak, geom, layer, depcode, dircode, ismeta, sensortype, acq_time, resolution, gridsize, coor_sys, epsg, h_datum, mata_type, bands, band_type, ct) values (@eventid, @metaid, @verid, @name, @type, @guid, @path, @sizes, @tab, @rows, @create_user, now(), @bak, @geom, @layer, @depcode, @dircode, @ismeta, @sensortype, @acq_time, @resolution, @gridsize, @coor_sys, @epsg, @h_datum, @mata_type, @bands, @band_type, @ct) returning id";
+ /// <summary>
+ /// 鎻掑叆鏁版嵁
+ /// </summary>
+ public int Insert(List<SysMeta> list)
+ {
+ PostgreHelper db = Tools.DBHelper;
+
+ int count = 0;
+ foreach (SysMeta meta in list)
+ {
+ List<DbParameter> args = Tools.GetParams<SysMeta>(insertSql, meta)
+ ;
+ int id = db.GetIntScalar(insertSql, args.ToArray());
+ if (id > 0) count++;
+ }
+
+ return count;
+ }
}
}
--
Gitblit v1.9.3