From 43d8efa0ce68be0a1ec60544cff7034c47ec743c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 06 一月 2024 11:31:28 +0800
Subject: [PATCH] 添加img操作接口
---
JiangSu/JiangSu.csproj | 1
JiangSu/cs/PostgreHelper.cs | 188 +++++++++++++++++++++++++++++++++++++++++++++++
JiangSu/Models/Img.cs | 20 +++++
JiangSu/cs/ImgDAL.cs | 11 ++
4 files changed, 220 insertions(+), 0 deletions(-)
diff --git a/JiangSu/JiangSu.csproj b/JiangSu/JiangSu.csproj
index 2720e5c..0c6c6b0 100644
--- a/JiangSu/JiangSu.csproj
+++ b/JiangSu/JiangSu.csproj
@@ -145,6 +145,7 @@
<Compile Include="cs\LogOut.cs" />
<Compile Include="cs\ModelDAL.cs" />
<Compile Include="cs\ModelHandler.cs" />
+ <Compile Include="cs\PostgreHelper.cs" />
<Compile Include="cs\SQLiteHelper.cs" />
<Compile Include="Global.asax.cs">
<DependentUpon>Global.asax</DependentUpon>
diff --git a/JiangSu/Models/Img.cs b/JiangSu/Models/Img.cs
new file mode 100644
index 0000000..baa866b
--- /dev/null
+++ b/JiangSu/Models/Img.cs
@@ -0,0 +1,20 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace JiangSu.Models
+{
+ public class Img
+ {
+ public Img() { }
+
+ public long id { set; get; }
+
+ public string name { set; get; }
+
+ public string path { set; get; }
+
+ public string geom { set; get; }
+ }
+}
diff --git a/JiangSu/cs/ImgDAL.cs b/JiangSu/cs/ImgDAL.cs
new file mode 100644
index 0000000..ea345d8
--- /dev/null
+++ b/JiangSu/cs/ImgDAL.cs
@@ -0,0 +1,11 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace JiangSu.cs
+{
+ public class ImgDAL
+ {
+ }
+}
diff --git a/JiangSu/cs/PostgreHelper.cs b/JiangSu/cs/PostgreHelper.cs
new file mode 100644
index 0000000..dd37132
--- /dev/null
+++ b/JiangSu/cs/PostgreHelper.cs
@@ -0,0 +1,188 @@
+锘縰sing Npgsql;
+using System;
+using System.Collections.Generic;
+using System.Configuration;
+using System.Data;
+using System.Data.Common;
+using System.Linq;
+using System.Text.RegularExpressions;
+using System.Web;
+
+namespace JiangSu.cs
+{
+ /// <summary>
+ /// Postgre甯姪绫�
+ /// </summary>
+ public class PostgreHelper
+ {
+ private const string StrRegex = @"<[^>]+?style=[\w]+?:expression\(|\b(alert|confirm|prompt)\b|^\+/v(8|9)|<[^>]*?=[^>]*?&#[^>]*?>|\b(and|or)\b.{1,6}?(=|>|<|\bin\b|\blike\b)|/\*.+?\*/|<\s*script\b|<\s*img\b|\bEXEC\b|UNION.+?SELECT|UPDATE.+?SET|INSERT\s+INTO.+?VALUES|(SELECT|DELETE).+?FROM|(CREATE|ALTER|DROP|TRUNCATE)\s+(TABLE|DATABASE)";
+
+ private string conStr = null;
+
+ public PostgreHelper()
+ {
+ this.conStr = ConfigurationManager.AppSettings["pgConn"];
+ }
+
+ /// <summary>
+ /// 杩炴帴瀛楃涓�
+ /// </summary>
+ public String ConStr
+ {
+ get
+ {
+ return this.conStr;
+ }
+ }
+
+ /// <summary>
+ /// 鑾峰彇DataTable
+ /// </summary>
+ public DataTable GetDataTable(string sql, params DbParameter[] args)
+ {
+ using (NpgsqlConnection con = new NpgsqlConnection(ConStr))
+ {
+ if (con.State != ConnectionState.Open)
+ {
+ con.Open();
+ }
+
+ using (NpgsqlCommand cmd = new NpgsqlCommand(sql, con))
+ {
+ if (args != null)
+ {
+ foreach (DbParameter arg in args)
+ {
+ //arg.ParameterName = arg.ParameterName.Replace("@", ":");
+ cmd.Parameters.Add(arg);
+ }
+ }
+
+ using (NpgsqlDataAdapter adapter = new NpgsqlDataAdapter(cmd))
+ {
+ DataTable dt = new DataTable();
+ adapter.Fill(dt);
+
+ return dt;
+ }
+ }
+ }
+ }
+
+ /// <summary>
+ /// 鑾峰彇璁板綍鏁�
+ /// </summary>
+ public int GetCount(string sql, params DbParameter[] args)
+ {
+ using (NpgsqlConnection con = new NpgsqlConnection(ConStr))
+ {
+ if (con.State != ConnectionState.Open)
+ {
+ con.Open();
+ }
+
+ using (NpgsqlCommand cmd = new NpgsqlCommand(sql, con))
+ {
+ if (args != null)
+ {
+ foreach (DbParameter arg in args)
+ {
+ //arg.ParameterName = arg.ParameterName.Replace("@", ":");
+ cmd.Parameters.Add(arg);
+ }
+ }
+
+ object obj = cmd.ExecuteScalar();
+
+ return obj == null ? 0 : Convert.ToInt32(obj);
+ }
+ }
+ }
+
+ public Object GetScalar(string sql, params DbParameter[] args)
+ {
+ using (NpgsqlConnection con = new NpgsqlConnection(ConStr))
+ {
+ if (con.State != ConnectionState.Open)
+ {
+ con.Open();
+ }
+
+ using (NpgsqlCommand cmd = new NpgsqlCommand(sql, con))
+ {
+ if (args != null)
+ {
+ foreach (DbParameter arg in args)
+ {
+ cmd.Parameters.Add(arg);
+ }
+ }
+
+ return cmd.ExecuteScalar();
+ }
+ }
+ }
+
+ public int GetIntScalar(string sql, params DbParameter[] args)
+ {
+ using (NpgsqlConnection con = new NpgsqlConnection(ConStr))
+ {
+ if (con.State != ConnectionState.Open)
+ {
+ con.Open();
+ }
+
+ using (NpgsqlCommand cmd = new NpgsqlCommand(sql, con))
+ {
+ if (args != null)
+ {
+ foreach (DbParameter arg in args)
+ {
+ cmd.Parameters.Add(arg);
+ }
+ }
+
+ object obj = cmd.ExecuteScalar();
+
+ return null == obj ? 0 : Convert.ToInt32(obj);
+ }
+ }
+ }
+
+ /// <summary>
+ /// 鎵цSQL锛岃繑鍥炲奖鍝嶈鏁�
+ /// </summary>
+ public int ExecuteNonQuery(string sql, params DbParameter[] args)
+ {
+ using (NpgsqlConnection con = new NpgsqlConnection(ConStr))
+ {
+ if (con.State != ConnectionState.Open)
+ {
+ con.Open();
+ }
+
+ using (NpgsqlCommand cmd = new NpgsqlCommand(sql, con))
+ {
+ if (args != null)
+ {
+ foreach (DbParameter arg in args)
+ {
+ //arg.ParameterName = arg.ParameterName.Replace("@", ":");
+ cmd.Parameters.Add(arg);
+ }
+ }
+
+ return cmd.ExecuteNonQuery();
+ }
+ }
+ }
+
+ /// <summary>
+ /// 妫�鏌ュ瓧绗︿覆
+ /// </summary>
+ public static bool CheckStr(string input)
+ {
+ return Regex.IsMatch(input, StrRegex, RegexOptions.IgnoreCase);
+ }
+ }
+}
--
Gitblit v1.9.3