From 994d438b4b06011eb7656357a367392bb30467c5 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 22 八月 2023 17:33:33 +0800
Subject: [PATCH] 处理数据导入流程-1
---
DataLoader/CS/DBHelper.cs | 18 ++++++++++++++----
1 files changed, 14 insertions(+), 4 deletions(-)
diff --git a/DataLoader/CS/DBHelper.cs b/DataLoader/CS/DBHelper.cs
index 13019a2..6d4fcbd 100644
--- a/DataLoader/CS/DBHelper.cs
+++ b/DataLoader/CS/DBHelper.cs
@@ -14,20 +14,30 @@
public class DBHelper
{
// 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 insertMeta = "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";
+ private const string insertMeta = "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 InsertMeta(List<SysMeta> list)
+ public static int InsertMeta(SysMeta meta)
+ {
+ List<DbParameter> args = Tools.GetParams<SysMeta>(insertMeta, meta);
+
+ return Tools.DBHelper.GetIntScalar(insertMeta, args.ToArray());
+ }
+
+ /// <summary>
+ /// 鎻掑叆鍏冩暟鎹�
+ /// </summary>
+ public static int InsertMetas(List<SysMeta> list)
{
PostgreHelper db = Tools.DBHelper;
int count = 0;
foreach (SysMeta meta in list)
{
- List<DbParameter> args = Tools.GetParams<SysMeta>(insertMeta, meta)
- ;
+ List<DbParameter> args = Tools.GetParams<SysMeta>(insertMeta, meta);
+
int id = db.GetIntScalar(insertMeta, args.ToArray());
if (id > 0) count++;
}
--
Gitblit v1.9.3