From 87b782c2132c645b667032598403896518055f9a Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 03 八月 2023 15:39:34 +0800
Subject: [PATCH] 1
---
ExportMap/db/TaskDBHelper.cs | 20 ++++++++++++++++++--
1 files changed, 18 insertions(+), 2 deletions(-)
diff --git a/ExportMap/db/TaskDBHelper.cs b/ExportMap/db/TaskDBHelper.cs
index 85d97b5..1097eed 100644
--- a/ExportMap/db/TaskDBHelper.cs
+++ b/ExportMap/db/TaskDBHelper.cs
@@ -1,5 +1,6 @@
锘縰sing ExportMap.cs;
using ExportMap.Models;
+using Npgsql;
using System;
using System.Collections.Generic;
using System.Data;
@@ -11,6 +12,19 @@
{
public class TaskDBHelper
{
+ /// <summary>
+ /// 鏍规嵁鍋滅墝鑾峰彇鐢ㄦ埛ID
+ /// </summary>
+ public static int SelectUserIdByToken(string token)
+ {
+ string sql = "select create_user from lf.sys_token where token=@token order by create_time desc limit 1;";
+ DbParameter dp1 = new NpgsqlParameter("@token", token);
+
+ object obj = Tools.DBHelper.GetScalar(sql, dp1);
+
+ return null == obj ? 0 : int.Parse(obj.ToString());
+ }
+
/// <summary>
/// 鏍规嵁ID鏌ヨ
/// </summary>
@@ -66,12 +80,13 @@
/// <summary>
/// 鍒涘缓浠诲姟瀹炰綋绫�
/// </summary>
- public static SysTask CreateTask(XYZArgs args, string type)
+ public static SysTask CreateTask(XYZArgs args, string type, string descr)
{
SysTask task = new SysTask();
task.name = args.name;
task.status = 1;
task.type = type;
+ task.descr = descr;
task.ip = Tools.GetLocalIP();
task.gids = string.Join(",", args.ids.ToArray());
task.depcode = args.depcode;
@@ -84,12 +99,13 @@
/// <summary>
/// 鍒涘缓浠诲姟瀹炰綋绫�
/// </summary>
- public static SysTask CreateTask(XYZArgs args, SysMeta meta, string type)
+ public static SysTask CreateTask(XYZArgs args, SysMeta meta, string type, string descr)
{
SysTask task = new SysTask();
task.name = meta.name;
task.status = 1;
task.type = type;
+ task.descr = descr;
task.ip = Tools.GetLocalIP();
task.gids = meta.id.ToString();
task.depcode = args.depcode;
--
Gitblit v1.9.3