From 27ab93a470434571e1148a282ac4f513c640c0c9 Mon Sep 17 00:00:00 2001
From: lch <luluchen515@163.com>
Date: 星期二, 20 八月 2024 14:17:01 +0800
Subject: [PATCH] 添加项目文件。
---
SQLHelperClass.cs | 604 ++++++++++++++++++++++++++++
Properties/AssemblyInfo.cs | 35 +
WebserviceGS.csproj | 116 +++++
WebService1.asmx | 1
Web.Release.config | 32 +
Web.config | 87 ++++
WebService1.asmx.cs | 97 ++++
Web.Debug.config | 31 +
DBorl.cs | 203 +++++++++
WebserviceGS.sln | 25 +
packages.config | 4
11 files changed, 1,235 insertions(+), 0 deletions(-)
diff --git a/DBorl.cs b/DBorl.cs
new file mode 100644
index 0000000..d8d83db
--- /dev/null
+++ b/DBorl.cs
@@ -0,0 +1,203 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Data;
+using System.Data.OracleClient;
+using System.Linq;
+using System.Web;
+
+namespace WebserviceGS
+{
+ public class DBorl
+ {
+ public static string connectionString = "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.3.21)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ORCL)));Persist Security Info=True;User Id = bgmes;Password=bg_mes";
+
+ #region 鍏敤鏂规硶
+
+ public static int GetMaxID(string FieldName, string TableName)
+ {
+ string strsql = "select max(" + FieldName + ")+1 from " + TableName;
+ object obj = GetSingle(strsql);
+ if (obj == null)
+ {
+ return 1;
+ }
+ else
+ {
+ return int.Parse(obj.ToString());
+ }
+ }
+ public static bool Exists(string strSql)
+ {
+ object obj = GetSingle(strSql);
+ int cmdresult;
+ if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
+ {
+ cmdresult = 0;
+ }
+ else
+ {
+ cmdresult = int.Parse(obj.ToString());
+ }
+ if (cmdresult == 0)
+ {
+ return false;
+ }
+ else
+ {
+ return true;
+ }
+ }
+
+ public static bool Exists(string strSql, params OracleParameter[] cmdParms)
+ {
+ object obj = GetSingle(strSql, cmdParms);
+ int cmdresult;
+ if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
+ {
+ cmdresult = 0;
+ }
+ else
+ {
+ cmdresult = int.Parse(obj.ToString());
+ }
+ if (cmdresult == 0)
+ {
+ return false;
+ }
+ else
+ {
+ return true;
+ }
+ }
+
+ #endregion
+
+
+ /// <summary>
+ /// 鎵ц涓�鏉¤绠楁煡璇㈢粨鏋滆鍙ワ紝杩斿洖鏌ヨ缁撴灉锛坥bject锛夈��
+ /// </summary>
+ /// <param name="SQLString">璁＄畻鏌ヨ缁撴灉璇彞</param>
+ /// <returns>鏌ヨ缁撴灉锛坥bject锛�</returns>
+ public static object GetSingle(string SQLString)
+ {
+ using (OracleConnection connection = new OracleConnection(connectionString))
+ {
+ using (OracleCommand cmd = new OracleCommand(SQLString, connection))
+ {
+ try
+ {
+ connection.Open();
+ object obj = cmd.ExecuteScalar();
+ if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
+ {
+ return null;
+ }
+ else
+ {
+ return obj;
+ }
+ }
+ catch (System.Data.OracleClient.OracleException e)
+ {
+ connection.Close();
+ throw new Exception(e.Message);
+ }
+ }
+ }
+ }
+
+ /// <summary>
+ /// 鎵ц涓�鏉¤绠楁煡璇㈢粨鏋滆鍙ワ紝杩斿洖鏌ヨ缁撴灉锛坥bject锛夈��
+ /// </summary>
+ /// <param name="SQLString">璁＄畻鏌ヨ缁撴灉璇彞</param>
+ /// <returns>鏌ヨ缁撴灉锛坥bject锛�</returns>
+ public static object GetSingle(string SQLString, params OracleParameter[] cmdParms)
+ {
+ using (OracleConnection connection = new OracleConnection(connectionString))
+ {
+ using (OracleCommand cmd = new OracleCommand())
+ {
+ try
+ {
+ PrepareCommand(cmd, connection, null, SQLString, cmdParms);
+ object obj = cmd.ExecuteScalar();
+ cmd.Parameters.Clear();
+ if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
+ {
+ return null;
+ }
+ else
+ {
+ return obj;
+ }
+ }
+ catch (System.Data.OracleClient.OracleException e)
+ {
+ throw new Exception(e.Message);
+ }
+ }
+ }
+ }
+
+ private static void PrepareCommand(OracleCommand cmd, OracleConnection conn, OracleTransaction trans, string cmdText, OracleParameter[] cmdParms)
+ {
+ if (conn.State != ConnectionState.Open)
+ conn.Open();
+ cmd.Connection = conn;
+ cmd.CommandText = cmdText;
+ if (trans != null)
+ cmd.Transaction = trans;
+ cmd.CommandType = CommandType.Text;//cmdType;
+ if (cmdParms != null)
+ {
+ foreach (OracleParameter parm in cmdParms)
+ cmd.Parameters.Add(parm);
+ }
+ }
+
+ public static int ExecuteSql(string SQLString)
+ {
+ using (OracleConnection connection = new OracleConnection(connectionString))
+ {
+ using (OracleCommand cmd = new OracleCommand(SQLString, connection))
+ {
+ try
+ {
+ connection.Open();
+ int rows = cmd.ExecuteNonQuery();
+ return rows;
+ }
+ catch (System.Data.OracleClient.OracleException E)
+ {
+ connection.Close();
+ throw new Exception(E.Message);
+ }
+ }
+ }
+ }
+
+ public static int ExecuteSql(string SQLString,string clob)
+ {
+ using (OracleConnection connection = new OracleConnection(connectionString))
+ {
+ using (OracleCommand cmd = new OracleCommand(SQLString, connection))
+ {
+ try
+ {
+ connection.Open();
+ OracleParameter op = new OracleParameter("clob", OracleType.Clob);
+ op.Value = clob;
+ cmd.Parameters.Add(op);
+ int rows = cmd.ExecuteNonQuery();
+ return rows;
+ }
+ catch (System.Data.OracleClient.OracleException E)
+ {
+ connection.Close();
+ throw new Exception(E.Message);
+ }
+ }
+ }
+ }
+ }
+}
\ No newline at end of file
diff --git a/Properties/AssemblyInfo.cs b/Properties/AssemblyInfo.cs
new file mode 100644
index 0000000..095a13d
--- /dev/null
+++ b/Properties/AssemblyInfo.cs
@@ -0,0 +1,35 @@
+锘縰sing System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// 鏈夊叧绋嬪簭闆嗙殑甯歌淇℃伅閫氳繃涓嬪垪鐗规�ч泦
+// 鎺у埗銆傛洿鏀硅繖浜涚壒鎬у�煎彲淇敼
+// 涓庣▼搴忛泦鍏宠仈鐨勪俊鎭��
+[assembly: AssemblyTitle("WebserviceGS")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("")]
+[assembly: AssemblyProduct("WebserviceGS")]
+[assembly: AssemblyCopyright("Copyright 漏 2021")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// 灏� ComVisible 璁剧疆涓� false 浼氫娇姝ょ▼搴忛泦涓殑绫诲瀷
+// 瀵� COM 缁勪欢涓嶅彲瑙併�傚鏋滈渶瑕�
+// 浠� COM 璁块棶姝ょ▼搴忛泦涓殑鏌愪釜绫诲瀷锛岃閽堝璇ョ被鍨嬪皢 ComVisible 鐗规�ц缃负 true銆�
+[assembly: ComVisible(false)]
+
+// 濡傛灉姝ら」鐩悜 COM 鍏紑锛屽垯涓嬪垪 GUID 鐢ㄤ簬 typelib 鐨� ID
+[assembly: Guid("1e975db8-481f-471c-81f7-be45fe9eb702")]
+
+// 绋嬪簭闆嗙殑鐗堟湰淇℃伅鐢变笅鍒楀洓涓�肩粍鎴�:
+//
+// 涓荤増鏈�
+// 娆＄増鏈�
+// 鍐呴儴鐗堟湰鍙�
+// 淇鐗堟湰
+//
+// 鍙互鎸囧畾鎵�鏈夊�硷紝涔熷彲浠ヤ娇鐢ㄢ�滀慨璁㈠彿鈥濆拰鈥滃唴閮ㄧ増鏈彿鈥濈殑榛樿鍊硷紝
+// 鏂规硶鏄寜濡備笅鎵�绀轰娇鐢� "*":
+[assembly: AssemblyVersion("1.0.0.0")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
diff --git a/SQLHelperClass.cs b/SQLHelperClass.cs
new file mode 100644
index 0000000..9004d5a
--- /dev/null
+++ b/SQLHelperClass.cs
@@ -0,0 +1,604 @@
+锘縰sing System;
+using System.Collections;
+using System.Collections.Generic;
+using System.Data;
+using System.Data.SqlClient;
+using System.IO;
+
+namespace Common
+{
+ /// <summary>
+ /// 鐢ㄤ簬SQL Server鏁版嵁搴撹闂殑甯姪绫�
+ /// </summary>
+ public class SQLHelperClass
+ {
+ private string _connectionString = "";
+
+ public string connectionString
+ {
+ get { return _connectionString; }
+ set { _connectionString =value; }
+ }
+
+ private SqlConnection _connection4Tran;
+ private SqlTransaction _transaction;
+ private readonly Queue<SqlTask> _transactionTaskList;
+
+ /// <summary>
+ /// 鍒涘缓涓�涓柊鐨凷QLHelper骞舵寚瀹氳繛鎺ュ瓧绗︿覆
+ /// </summary>
+ public SQLHelperClass()
+ {
+ _transactionTaskList = new Queue<SqlTask>();
+ }
+
+ ///// <summary>
+ ///// 鍒涘缓涓�涓柊鐨凷QLHelper骞舵寚瀹氳繛鎺ヤ俊鎭�
+ ///// </summary>
+ ///// <param name="server"></param>
+ ///// <param name="userID"></param>
+ ///// <param name="password"></param>
+ ///// <param name="database"></param>
+ // SQLHelper(string server, string userID, string password, string database)
+ //{
+ // _transactionTaskList = new Queue<SqlTask>();
+ // if (database == string.Empty)
+ // {
+ // _connectionString = "Data Source=" + server + ";User ID=" + userID + ";Password=" + password;
+ // }
+ // else
+ // {
+ // _connectionString = "Data Source=" + server + ";User ID=" + userID + ";Password=" + password + ";Initial Catalog=" + database;
+ // }
+
+ //}
+
+ /// <summary>
+ /// 娴嬭瘯杩炴帴
+ /// </summary>
+ /// <returns></returns>
+ public bool TestConnection()
+ {
+ try
+ {
+ using (var connection = new SqlConnection(_connectionString))
+ {
+ connection.Open();
+ connection.Close();
+ return true;
+ }
+ }
+ catch (Exception)
+ {
+ return false;
+ }
+
+ }
+
+ /// <summary>
+ /// ExecuteNonQuery鎿嶄綔锛屽鏁版嵁搴撹繘琛� 澧炪�佸垹銆佹敼 鎿嶄綔(1锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <returns> </returns>
+ public int ExecuteNonQuery(string sql)
+ {
+ return ExecuteNonQuery(sql, CommandType.Text, null);
+ }
+ /// <summary>
+ /// ExecuteNonQuery鎿嶄綔锛屽鏁版嵁搴撹繘琛� 澧炪�佸垹銆佹敼 鎿嶄綔锛�2锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <returns> </returns>
+ public int ExecuteNonQuery(string sql, CommandType commandType)
+ {
+ return ExecuteNonQuery(sql, commandType, null);
+ }
+ /// <summary>
+ /// ExecuteNonQuery鎿嶄綔锛屽鏁版嵁搴撹繘琛� 澧炪�佸垹銆佹敼 鎿嶄綔锛�3锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <param name="parameters">鍙傛暟鏁扮粍 </param>
+ /// <returns> </returns>
+ public int ExecuteNonQuery(string sql, CommandType commandType, SqlParameter[] parameters)
+ {
+ return ExecuteNonQuery(sql, commandType, parameters, false);
+ }
+
+ /// <summary>
+ /// ExecuteNonQuery鎿嶄綔锛屽鏁版嵁搴撹繘琛� 澧炪�佸垹銆佹敼 鎿嶄綔(4锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞</param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛�</param>
+ /// <param name="parameters">鍙傛暟鏁扮粍</param>
+ /// <param name="joinTransaction">鏄惁鍔犲叆浜嬪姟澶勭悊锛涘鏋滀负true锛屽墠鎻愭槸蹇呴』浣跨敤BeginTransaction寮�濮嬩簡涓�涓簨鍔★紝濡傛灉涓篺alse,涓嶄娇鐢ㄤ簨鍔°��</param>
+ /// <returns></returns>
+ public int ExecuteNonQuery(string sql, CommandType commandType, SqlParameter[] parameters, bool joinTransaction)
+ {
+ int count = 0;
+ if (joinTransaction)
+ {
+ if (_transaction == null || _connection4Tran == null)
+ {
+ throw new Exception("浜嬪姟鏈垵濮嬪寲锛�");
+ }
+ //using (var command = new SqlCommand(sql, _connection4Tran))
+ //{
+ // command.CommandType = commandType;
+ // if (parameters != null)
+ // {
+ // foreach (SqlParameter parameter in parameters)
+ // {
+ // command.Parameters.Add(parameter);
+ // }
+ // }
+ // command.Transaction = _transaction;
+ // count = command.ExecuteNonQuery();
+ //}
+ _transactionTaskList.Enqueue(new SqlTask(sql, commandType, parameters));
+ }
+ else
+ {
+ using (var connection = new SqlConnection(_connectionString))
+ {
+ using (var command = new SqlCommand(sql, connection))
+ {
+ command.CommandType = commandType;
+ if (parameters != null)
+ {
+ foreach (SqlParameter parameter in parameters)
+ {
+ command.Parameters.Add(parameter);
+ }
+ }
+ connection.Open();
+ count = command.ExecuteNonQuery();
+ }
+ }
+ }
+ return count;
+ }
+
+ /// <summary>
+ /// SqlDataAdapter鐨凢ill鏂规硶鎵ц涓�涓煡璇紝骞惰繑鍥炰竴涓狣ataSet绫诲瀷缁撴灉锛�1锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <returns> </returns>
+ public DataSet ExecuteDataSet(string sql)
+ {
+ return ExecuteDataSet(sql, CommandType.Text, null);
+ }
+ /// <summary>
+ /// SqlDataAdapter鐨凢ill鏂规硶鎵ц涓�涓煡璇紝骞惰繑鍥炰竴涓狣ataSet绫诲瀷缁撴灉锛�2锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <returns> </returns>
+ public DataSet ExecuteDataSet(string sql, CommandType commandType)
+ {
+ return ExecuteDataSet(sql, commandType, null);
+ }
+ /// <summary>
+ /// SqlDataAdapter鐨凢ill鏂规硶鎵ц涓�涓煡璇紝骞惰繑鍥炰竴涓狣ataSet绫诲瀷缁撴灉锛�3锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <param name="parameters">鍙傛暟鏁扮粍 </param>
+ /// <returns> </returns>
+ public DataSet ExecuteDataSet(string sql, CommandType commandType, SqlParameter[] parameters)
+ {
+ var ds = new DataSet();
+ using (var connection = new SqlConnection(_connectionString))
+ {
+ using (var command = new SqlCommand(sql, connection))
+ {
+ command.CommandType = commandType;
+ if (parameters != null)
+ {
+ foreach (SqlParameter parameter in parameters)
+ {
+ command.Parameters.Add(parameter);
+ }
+ }
+ var adapter = new SqlDataAdapter(command);
+ adapter.Fill(ds);
+ command.Parameters.Clear();//灏嗕娇鐢ㄥ畬涔嬪悗鐨凜ommand鍛戒护鐨凱arameters闆嗗悎娓呯┖
+ }
+ }
+ return ds;
+ }
+ /// <summary>
+ /// SqlDataAdapter鐨凢ill鏂规硶鎵ц涓�涓煡璇紝骞惰繑鍥炰竴涓狣ataTable绫诲瀷缁撴灉锛�1锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <returns> </returns>
+ public DataTable ExecuteDataTable(string sql)
+ {
+ return ExecuteDataTable(sql, CommandType.Text, null);
+ }
+ /// <summary>
+ /// SqlDataAdapter鐨凢ill鏂规硶鎵ц涓�涓煡璇紝骞惰繑鍥炰竴涓狣ataTable绫诲瀷缁撴灉锛�2锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <returns> </returns>
+ public DataTable ExecuteDataTable(string sql, CommandType commandType)
+ {
+ return ExecuteDataTable(sql, commandType, null);
+ }
+ /// <summary>
+ /// SqlDataAdapter鐨凢ill鏂规硶鎵ц涓�涓煡璇紝骞惰繑鍥炰竴涓狣ataTable绫诲瀷缁撴灉锛�3锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <param name="parameters">鍙傛暟鏁扮粍 </param>
+ /// <returns> </returns>
+ public DataTable ExecuteDataTable(string sql, CommandType commandType, SqlParameter[] parameters)
+ {
+ var data = new DataTable();
+ using (var connection = new SqlConnection(_connectionString))
+ {
+ using (var command = new SqlCommand(sql, connection))
+ {
+ command.CommandType = commandType;
+ if (parameters != null)
+ {
+ foreach (SqlParameter parameter in parameters)
+ {
+ command.Parameters.Add(parameter);
+ }
+ }
+ var adapter = new SqlDataAdapter(command);
+ adapter.Fill(data);
+ command.Parameters.Clear();//灏嗕娇鐢ㄥ畬涔嬪悗鐨凜ommand鍛戒护鐨凱arameters闆嗗悎娓呯┖
+ }
+ }
+ return data;
+ }
+ /// <summary>
+ /// ExecuteReader鎵ц涓�鏌ヨ锛岃繑鍥炰竴SqlDataReader瀵硅薄瀹炰緥锛�1锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <returns> </returns>
+ public SqlDataReader ExecuteReader(string sql)
+ {
+ return ExecuteReader(sql, CommandType.Text, null);
+ }
+ /// <summary>
+ /// ExecuteReader鎵ц涓�鏌ヨ锛岃繑鍥炰竴SqlDataReader瀵硅薄瀹炰緥锛�2锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <returns> </returns>
+ public SqlDataReader ExecuteReader(string sql, CommandType commandType)
+ {
+ return ExecuteReader(sql, commandType, null);
+ }
+ /// <summary>
+ /// ExecuteReader鎵ц涓�鏌ヨ锛岃繑鍥炰竴SqlDataReader瀵硅薄瀹炰緥锛�3锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <param name="parameters">鍙傛暟鏁扮粍 </param>
+ /// <returns> </returns>
+ public SqlDataReader ExecuteReader(string sql, CommandType commandType, SqlParameter[] parameters)
+ {
+ var connection = new SqlConnection(_connectionString);
+ var command = new SqlCommand(sql, connection) { CommandType = commandType };
+ if (parameters != null)
+ {
+ foreach (SqlParameter parameter in parameters)
+ {
+ command.Parameters.Add(parameter);
+ }
+ }
+ connection.Open();
+ return command.ExecuteReader(CommandBehavior.CloseConnection);
+ }
+ /// <summary>
+ /// ExecuteScalar鎵ц涓�鏌ヨ锛岃繑鍥炴煡璇㈢粨鏋滅殑绗竴琛岀涓�鍒楋紙1锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <returns> </returns>
+ public Object ExecuteScalar(string sql)
+ {
+ return ExecuteScalar(sql, CommandType.Text, null);
+ }
+ /// <summary>
+ /// ExecuteScalar鎵ц涓�鏌ヨ锛岃繑鍥炴煡璇㈢粨鏋滅殑绗竴琛岀涓�鍒楋紙2锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <returns> </returns>
+ public Object ExecuteScalar(string sql, CommandType commandType)
+ {
+ return ExecuteScalar(sql, commandType, null);
+ }
+
+ /// <summary>
+ /// ExecuteScalar鎵ц涓�鏌ヨ锛岃繑鍥炴煡璇㈢粨鏋滅殑绗竴琛岀涓�鍒楋紙3锛�
+ /// </summary>
+ /// <param name="sql">瑕佹墽琛岀殑SQL璇彞 </param>
+ /// <param name="commandType">瑕佹墽琛岀殑鏌ヨ绫诲瀷锛堝瓨鍌ㄨ繃绋嬨�丼QL鏂囨湰锛� </param>
+ /// <param name="parameters">鍙傛暟鏁扮粍</param>
+ /// <returns> </returns>
+ public Object ExecuteScalar(string sql, CommandType commandType, SqlParameter[] parameters)
+ {
+ object result;
+ using (var connection = new SqlConnection(_connectionString))
+ {
+ using (var command = new SqlCommand(sql, connection))
+ {
+ command.CommandType = commandType;
+ if (parameters != null)
+ {
+ foreach (SqlParameter parameter in parameters)
+ {
+ command.Parameters.Add(parameter);
+ }
+ }
+ connection.Open();
+ result = command.ExecuteScalar();
+ command.Parameters.Clear();//灏嗕娇鐢ㄥ畬涔嬪悗鐨凜ommand鍛戒护鐨凱arameters闆嗗悎娓呯┖
+ }
+ }
+ return result;
+ }
+ /// <summary>
+ /// 杩斿洖褰撳墠杩炴帴鐨勬暟鎹簱涓墍鏈夌敱鐢ㄦ埛鍒涘缓鐨勬暟鎹〃
+ /// </summary>
+ /// <returns> </returns>
+ public DataTable GetTables()
+ {
+ DataTable data;
+ using (var connection = new SqlConnection(_connectionString))
+ {
+ connection.Open();
+ data = connection.GetSchema("Tables");
+ }
+ return data;
+ }
+
+ /// <summary>
+ /// 杩斿洖褰撳墠杩炴帴鐨勬暟鎹簱鍒楄〃
+ /// </summary>
+ /// <returns> </returns>
+ public DataTable GetDatabases()
+ {
+ DataTable data;
+ using (var connection = new SqlConnection(_connectionString))
+ {
+ connection.Open();
+ data = connection.GetSchema("Databases");
+ }
+ return data;
+ }
+
+ /// <summary>
+ /// 鑾峰彇SQL Server鏈嶅姟鍣ㄥ垪琛�
+ /// </summary>
+ /// <returns></returns>
+ public ArrayList GetServerList()
+ {
+ var arrayList = new ArrayList();
+ foreach (DataRow dr in System.Data.Sql.SqlDataSourceEnumerator.Instance.GetDataSources().Rows)
+ {
+ arrayList.Add(dr[0].ToString());
+ }
+ return arrayList;
+ }
+
+ /// <summary>
+ /// 寮�濮嬩竴涓簨鍔″鐞�
+ /// <para/>
+ /// <para>璋冪敤鏍煎紡鏍蜂緥锛�</para>
+ /// <para/>
+ /// <para><code>SQLHelper.BeginTransaction</code></para>
+ /// <para><code>SQLHelper.ExecuteNoneQuery(command1)</code></para>
+ /// <para><code>SQLHelper.ExecuteNoneQuery(command2)</code></para>
+ /// <para><code>SQLHelper.ExecuteNoneQuery(...)</code></para>
+ /// <para><code>SQLHelper.CommitTransaction</code></para>
+ /// <para/>
+ /// <para>鍦ㄤ簨鍔℃彁浜や箣鍓嶏紝鍙殢鏃朵娇鐢ㄦ柟娉旵ancelTransaction鍙栨秷浜嬪姟;</para>
+ /// <para>濡傛灉浜嬪姟鍦ㄦ彁浜ょ殑杩囩▼涓彂鐢熼敊璇紝灏嗚嚜鍔ㄥ洖婊氫簨鍔°��</para>
+ /// </summary>
+ /// <param name="isolationLevel">浜嬪姟闅旂绾у埆</param>
+ public void BeginTransaction(IsolationLevel isolationLevel)
+ {
+ if ((_transaction != null) || (_connection4Tran != null))
+ {
+ throw new Exception("瑕佸紑濮嬩竴涓柊鐨勪簨鍔★紝璇峰厛瀹屾垚褰撳墠浜嬪姟!");
+ }
+ _connection4Tran = new SqlConnection(_connectionString);
+ _connection4Tran.Open();
+ _transaction = _connection4Tran.BeginTransaction(isolationLevel);
+ _transactionTaskList.Clear();
+ }
+
+ /// <summary>
+ /// 鎻愪氦浜嬪姟
+ /// </summary>
+ public void CommitTransaction()
+ {
+ try
+ {
+ if (_transactionTaskList.Count > 0)
+ {
+ foreach (SqlTask sqlTask in _transactionTaskList)
+ {
+ using (var command = new SqlCommand(sqlTask.Text, _connection4Tran))
+ {
+ command.CommandType = sqlTask.CommandType;
+ if (sqlTask.Parameters != null)
+ {
+ foreach (SqlParameter parameter in sqlTask.Parameters)
+ {
+ command.Parameters.Add(parameter);
+ }
+ }
+ command.Transaction = _transaction;
+ command.ExecuteNonQuery();
+ }
+ }
+ }
+ _transaction.Commit();
+ }
+ catch (Exception)
+ {
+ _transaction.Rollback();
+ throw;
+ }
+ finally
+ {
+ if (_transaction != null)
+ {
+ _transaction.Dispose();
+ }
+ if (_connection4Tran != null)
+ {
+ _connection4Tran.Close();
+ }
+ if (_connection4Tran != null)
+ {
+ _connection4Tran.Dispose();
+ }
+ _transaction = null;
+ _connection4Tran = null;
+ _transactionTaskList.Clear();
+ }
+ }
+
+ /// <summary>
+ /// 閫氳繃瀛樺偍杩囩▼杩斿洖缁撴灉闆嗘柟娉�
+ /// </summary>
+ /// <param name="procedureName">瀛樺偍杩囩▼鍚嶇О</param>
+ /// <param name="param">鍙傛暟缁�</param>
+ /// <returns>杩斿洖SqlDataReader鏁版嵁缁撴灉闆�</returns>
+ public SqlDataReader GetReaderByProcedure(string procedureName, SqlParameter[] param)
+ {
+ SqlConnection conn = new SqlConnection(_connectionString);
+ SqlCommand cmd = new SqlCommand();
+ try
+ {
+ conn.Open();
+ cmd.Connection = conn;
+ cmd.CommandType = CommandType.StoredProcedure;
+ cmd.CommandText = procedureName;
+ cmd.Parameters.AddRange(param);
+ return cmd.ExecuteReader(CommandBehavior.CloseConnection);
+ }
+ catch (Exception ex)
+ {
+ WritterError("鎵ц GetReaderByProcedure(string procedureName,SqlParameter[] param)鍑虹幇寮傚父:", ex.Message);
+ conn.Close();
+ throw;
+ }
+ }
+
+ /// <summary>
+ /// 閫氳繃瀛樺偍杩囩▼杩斿洖涓�涓狣ataSet鏁版嵁闆�
+ /// </summary>
+ /// <param name="procedureName">瀛樺偍杩囩▼鍚嶇О</param>
+ /// <param name="param">瀛樺偍杩囩▼鎵�闇�鍙傛暟</param>
+ /// <returns>DataSet鏁版嵁闆�</returns>
+ public DataSet GetDataSetByProcedure(string procedureName, SqlParameter[] param)
+ {
+ SqlConnection conn = new SqlConnection(_connectionString);
+ SqlCommand cmd = new SqlCommand(procedureName, conn);
+ SqlDataAdapter da = new SqlDataAdapter(cmd);
+ try
+ {
+ conn.Open();
+ cmd.CommandType = CommandType.StoredProcedure;
+ cmd.Parameters.AddRange(param);
+ DataSet ds = new DataSet();
+ da.Fill(ds);
+ return ds;
+
+ }
+ catch (Exception ex)
+ {
+ //WritterError("鎵цGetTableByProcedure(string procedureName,SqlParameter[] param)鍑虹幇寮傚父:", ex.Message);
+ throw ex;
+ }
+ finally
+ {
+ conn.Close();
+ }
+ }
+
+ #region 閿欒淇℃伅鍐欏叆鏃ュ織
+ public void WritterError(string errorObjName, string exMessage)
+ {
+ FileStream fs = new FileStream("libraryError.log", FileMode.Append);
+ StreamWriter sw = new StreamWriter(fs);
+ sw.WriteLine(string.Format("{0}{1}", errorObjName, exMessage + GetServerTime()));
+ sw.Close();
+ fs.Close();
+ }
+ #endregion
+
+ #region 鑾峰彇鏈嶅姟鍣ㄦ椂闂�
+ public DateTime GetServerTime()
+ {
+ return Convert.ToDateTime(ExecuteScalar("select getdate()"));
+ }
+
+ #endregion
+
+ /// <summary>
+ /// 鍙栨秷浜嬪姟
+ /// </summary>
+ public void CancelTransaction()
+ {
+ if (_transaction != null)
+ {
+ _transaction.Dispose();
+ }
+ if (_connection4Tran != null)
+ {
+ _connection4Tran.Close();
+ }
+ if (_connection4Tran != null)
+ {
+ _connection4Tran.Dispose();
+ }
+ _transaction = null;
+ _connection4Tran = null;
+ }
+
+ #region ICloneable 鎴愬憳
+
+ //public object Clone()
+ //{
+ // return (new SQLHelper(_connectionString));
+ //}
+
+ #endregion
+
+ #region IDisposable 鎴愬憳
+
+ //public void Dispose()
+ //{
+ // _connection4Tran = null;
+ // _transaction = null;
+ //}
+
+ #endregion
+
+ public class SqlTask
+ {
+ public string Text { get; private set; }
+ public CommandType CommandType { get; private set; }
+ public SqlParameter[] Parameters { get; private set; }
+
+ public SqlTask(string text, CommandType commandType, SqlParameter[] paras)
+ {
+ Text = text;
+ CommandType = commandType;
+ Parameters = paras;
+ }
+ }
+ }
+}
diff --git a/Web.Debug.config b/Web.Debug.config
new file mode 100644
index 0000000..b9a9fde
--- /dev/null
+++ b/Web.Debug.config
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!-- 鏈夊叧浣跨敤 web.config 杞崲鐨勮缁嗕俊鎭紝璇疯闂� https://go.microsoft.com/fwlink/?LinkId=125889 -->
+
+<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
+ <!--
+ 鍦ㄤ笅渚嬩腑锛屸�淪etAttributes鈥濊浆鎹㈠皢鏇存敼
+ 鈥渃onnectionString鈥濈殑鍊硷紝浠ヤ粎鍦ㄢ�淢atch鈥濆畾浣嶅櫒
+ 鎵惧埌鍊间负鈥淢yDB鈥濈殑鐗规�р�渘ame鈥濇椂浣跨敤鈥淩eleaseSQLServer鈥濄��
+
+ <connectionStrings>
+ <add name="MyDB"
+ connectionString="Data Source=ReleaseSQLServer;Initial Catalog=MyReleaseDB;Integrated Security=True"
+ xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
+ </connectionStrings>
+ -->
+ <system.web>
+ <!--
+
+ 鍦ㄤ笅渚嬩腑锛屸�淩eplace鈥濊浆鎹㈠皢鏇挎崲
+ web.config 鏂囦欢鐨勬暣涓� <customErrors> 鑺傘��
+ 璇锋敞鎰忥紝鐢变簬
+ 鍦� <system.web> 鑺傜偣涓嬩粎鏈変竴涓� customErrors 鑺傦紝鍥犳涓嶉渶瑕佷娇鐢ㄢ�渪dt:Locator鈥濈壒鎬с��
+
+ <customErrors defaultRedirect="GenericError.htm"
+ mode="RemoteOnly" xdt:Transform="Replace">
+ <error statusCode="500" redirect="InternalError.htm"/>
+ </customErrors>
+ -->
+ </system.web>
+</configuration>
\ No newline at end of file
diff --git a/Web.Release.config b/Web.Release.config
new file mode 100644
index 0000000..755e745
--- /dev/null
+++ b/Web.Release.config
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!-- 鏈夊叧浣跨敤 web.config 杞崲鐨勮缁嗕俊鎭紝璇疯闂� https://go.microsoft.com/fwlink/?LinkId=125889 -->
+
+<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
+ <!--
+ 鍦ㄤ笅渚嬩腑锛屸�淪etAttributes鈥濊浆鎹㈠皢鏇存敼
+ 鈥渃onnectionString鈥濈殑鍊硷紝浠ヤ粎鍦ㄢ�淢atch鈥濆畾浣嶅櫒
+ 鎵惧埌鍊间负鈥淢yDB鈥濈殑鐗规�р�渘ame鈥濇椂浣跨敤鈥淩eleaseSQLServer鈥濄��
+
+ <connectionStrings>
+ <add name="MyDB"
+ connectionString="Data Source=ReleaseSQLServer;Initial Catalog=MyReleaseDB;Integrated Security=True"
+ xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
+ </connectionStrings>
+ -->
+ <system.web>
+ <compilation xdt:Transform="RemoveAttributes(debug)" />
+ <!--
+
+ 鍦ㄤ笅渚嬩腑锛屸�淩eplace鈥濊浆鎹㈠皢鏇挎崲
+ web.config 鏂囦欢鐨勬暣涓� <customErrors> 鑺傘��
+ 璇锋敞鎰忥紝鐢变簬
+ 鍦� <system.web> 鑺傜偣涓嬩粎鏈変竴涓� customErrors 鑺傦紝鍥犳涓嶉渶瑕佷娇鐢ㄢ�渪dt:Locator鈥濈壒鎬с��
+
+ <customErrors defaultRedirect="GenericError.htm"
+ mode="RemoteOnly" xdt:Transform="Replace">
+ <error statusCode="500" redirect="InternalError.htm"/>
+ </customErrors>
+ -->
+ </system.web>
+</configuration>
\ No newline at end of file
diff --git a/Web.config b/Web.config
new file mode 100644
index 0000000..d526a48
--- /dev/null
+++ b/Web.config
@@ -0,0 +1,87 @@
+锘�<?xml version="1.0"?>
+<!--
+ 鏈夊叧濡備綍閰嶇疆 ASP.NET 搴旂敤绋嬪簭鐨勮缁嗕俊鎭紝璇疯闂�
+ https://go.microsoft.com/fwlink/?LinkId=169433
+-->
+<configuration>
+ <configSections>
+ <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
+ <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
+ <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
+ <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
+ <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
+ <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
+ <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
+ <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
+ </sectionGroup>
+ </sectionGroup>
+ </sectionGroup>
+ </configSections>
+ <system.web>
+ <compilation debug="true">
+ <assemblies>
+ <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
+ <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
+ <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
+ </assemblies>
+ </compilation>
+ <httpRuntime/>
+ <pages>
+ <controls>
+ <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ </controls>
+ </pages>
+ <httpHandlers>
+ <remove verb="*" path="*.asmx"/>
+ <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ <add verb="GET,HEAD" path="ScriptResource.axd" validate="false" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ </httpHandlers>
+ <httpModules>
+ <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ </httpModules>
+ </system.web>
+ <system.codedom>
+ <compilers>
+ <compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4" compilerOptions="/langversion:default /nowarn:1659;1699;1701">
+ <providerOption name="CompilerVersion" value="v3.5"/>
+ <providerOption name="WarnAsError" value="false"/>
+ </compiler>
+ <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4" compilerOptions="/langversion:default /nowarn:41008 /define:_MYTYPE=\"Web\" /optionInfer+">
+ <providerOption name="CompilerVersion" value="v3.5"/>
+ <providerOption name="OptionInfer" value="true"/>
+ <providerOption name="WarnAsError" value="false"/>
+ </compiler>
+ </compilers>
+ </system.codedom>
+ <system.webServer>
+ <validation validateIntegratedModeConfiguration="false"/>
+ <modules>
+ <remove name="ScriptModule"/>
+ <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ </modules>
+ <handlers>
+ <remove name="WebServiceHandlerFactory-Integrated"/>
+ <remove name="ScriptHandlerFactory"/>
+ <remove name="ScriptHandlerFactoryAppServices"/>
+ <remove name="ScriptResource"/>
+ <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ <add name="ScriptResource" verb="GET,HEAD" path="ScriptResource.axd" preCondition="integratedMode" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
+ </handlers>
+ </system.webServer>
+ <runtime>
+ <assemblyBinding appliesTo="v2.0.50727" xmlns="urn:schemas-microsoft-com:asm.v1">
+ <dependentAssembly>
+ <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
+ <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
+ </dependentAssembly>
+ <dependentAssembly>
+ <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
+ <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
+ </dependentAssembly>
+ </assemblyBinding>
+ </runtime>
+</configuration>
\ No newline at end of file
diff --git a/WebService1.asmx b/WebService1.asmx
new file mode 100644
index 0000000..6083e85
--- /dev/null
+++ b/WebService1.asmx
@@ -0,0 +1 @@
+锘�<%@ WebService Language="C#" CodeBehind="WebService1.asmx.cs" Class="WebserviceGS.WebService1" %>
diff --git a/WebService1.asmx.cs b/WebService1.asmx.cs
new file mode 100644
index 0000000..bab6283
--- /dev/null
+++ b/WebService1.asmx.cs
@@ -0,0 +1,97 @@
+锘縰sing Common;
+using Newtonsoft.Json;
+using Newtonsoft.Json.Linq;
+using System;
+using System.Collections.Generic;
+using System.Data;
+using System.Data.OracleClient;
+using System.Data.SqlClient;
+using System.Linq;
+using System.Web;
+using System.Web.Services;
+using System.Xml.Linq;
+
+namespace WebserviceGS
+{
+ /// <summary>
+ /// WebService1 鐨勬憳瑕佽鏄�
+ /// </summary>
+ [WebService(Namespace = "http://tempuri.org/")]
+ [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
+ [System.ComponentModel.ToolboxItem(false)]
+ // 鑻ヨ鍏佽浣跨敤 ASP.NET AJAX 浠庤剼鏈腑璋冪敤姝� Web 鏈嶅姟锛岃鍙栨秷娉ㄩ噴浠ヤ笅琛屻��
+ // [System.Web.Script.Services.ScriptService]
+ public class WebService1 : System.Web.Services.WebService
+ {
+
+
+ [WebMethod]
+ public string ERP_TO_MES_DataTransport(string task_name,string create_time, string creator, string operatype,
+ string version, string imagenumber, string imagenumnew, string baseimage)
+ {
+ SQLHelperClass SQLHelper = new SQLHelperClass();
+
+ SQLHelper.connectionString = "Data Source=192.168.1.198;Initial Catalog=CSFrameworkV5_Normal;User Id=sa;Password=Weaver@2001;Pooling=False;Pooling=true;Min Pool Size=10;Max Pool Size=50;Connect Timeout=500";
+ string res = "";
+ string sql = "";
+ if (task_name == null || create_time == null || creator == null || operatype == null || version == null || imagenumber == null )
+ {
+ res = "ERROR:杈撳叆鍙傛暟涓嶈兘涓虹┖";
+
+ return res;
+ }
+ if (operatype!="INSERT"&& operatype != "UPDATE" && operatype != "DELETE")
+ {
+ res = "ERROR:鎿嶄綔绫诲瀷operatype閿欒";
+
+ return res;
+ }
+ //瀵笿SON鏍煎紡鍒ゆ柇姝ｇ‘鎬� 閮戒互DataSet浣滃簭鍒楀寲鏉ヤ紶鍊�
+ //DataSet ds=new DataSet();
+ //JsonConvert.SerializeObject(ds, new DataSetConverter());
+ //DataSet api_DatSet = JsonConvert.DeserializeObject(data, typeof(DataSet)) as DataSet;
+ //if (api_DatSet == null || api_DatSet.Tables.Count == 0)
+ //{
+ // res = "ERROR:鏁版嵁鏃犳晥锛屾垨鑰匤SON鏍煎紡鏈夎锛岃鏌ヨ瘉锛�";
+ // return res;
+ //}
+
+ //灏嗘暟鎹瓨鍏ユ暟鎹腑闂磋〃涓�
+
+ try
+ {
+ // sql = string.Format(@"
+ //insert into sysdec(task_id,task_name,descript,create_time,creator,operatype,source_table,target_table,data,data_inserted,data_deleted,states)
+ // values(newid(),'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','NEW')",
+ // task_name, descript, create_time, creator, operatype, source_table, target_table, data, data_inserted, data_deleted);
+ // int i = SQLHelper.ExecuteNonQuery(sql);
+ // res = i > 0 ? "OK" : "ERROR";
+ string currentTime = DateTime.Now.ToString();
+ List<SqlParameter> list = new List<SqlParameter>();
+ list.Add(new SqlParameter("@task_name", task_name));
+ list.Add(new SqlParameter("@create_time", create_time));
+ list.Add(new SqlParameter("@down_time", currentTime));
+ list.Add(new SqlParameter("@creator", creator));
+ list.Add(new SqlParameter("@operatype", operatype));
+ list.Add(new SqlParameter("@version", version));
+
+ list.Add(new SqlParameter("@imagenumnew", imagenumnew));
+ list.Add(new SqlParameter("@imagenumber", imagenumber));
+ list.Add(new SqlParameter("@baseimage", baseimage));
+
+
+ sql = string.Format(@"
+insert into sysdectu(task_id,task_name,create_time,down_time,creator,operatype,version,imagenumber,imagenumnew,baseimage,states)
+values(newid(),@task_name,@create_time,@down_time,@creator,@operatype,@version,@imagenumber,@imagenumnew,@baseimage,'NEW')");
+ int i = SQLHelper.ExecuteNonQuery(sql, CommandType.Text, list.ToArray());
+ res = i > 0 ? "OK" : "ERROR";
+ }
+ catch (Exception ex)
+ {
+ res = "ERROR:" + ex.Message;
+ }
+ return res;
+ }
+
+ }
+}
diff --git a/WebserviceGS.csproj b/WebserviceGS.csproj
new file mode 100644
index 0000000..3796f9d
--- /dev/null
+++ b/WebserviceGS.csproj
@@ -0,0 +1,116 @@
+锘�<Project ToolsVersion="15.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+ <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
+ <PropertyGroup>
+ <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+ <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+ <ProductVersion>
+ </ProductVersion>
+ <SchemaVersion>2.0</SchemaVersion>
+ <ProjectGuid>{1E975DB8-481F-471C-81F7-BE45FE9EB702}</ProjectGuid>
+ <ProjectTypeGuids>{349c5851-65df-11da-9384-00065b846f21};{fae04ec0-301f-11d3-bf4b-00c04f79efbc}</ProjectTypeGuids>
+ <OutputType>Library</OutputType>
+ <AppDesignerFolder>Properties</AppDesignerFolder>
+ <RootNamespace>WebserviceGS</RootNamespace>
+ <AssemblyName>WebserviceGS</AssemblyName>
+ <TargetFrameworkVersion>v3.5</TargetFrameworkVersion>
+ <UseIISExpress>true</UseIISExpress>
+ <Use64BitIISExpress />
+ <IISExpressSSLPort>44347</IISExpressSSLPort>
+ <IISExpressAnonymousAuthentication />
+ <IISExpressWindowsAuthentication />
+ <IISExpressUseClassicPipelineMode />
+ <UseGlobalApplicationHostFile />
+ <TargetFrameworkProfile />
+ </PropertyGroup>
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
+ <DebugSymbols>true</DebugSymbols>
+ <DebugType>full</DebugType>
+ <Optimize>false</Optimize>
+ <OutputPath>bin\</OutputPath>
+ <DefineConstants>DEBUG;TRACE</DefineConstants>
+ <ErrorReport>prompt</ErrorReport>
+ <WarningLevel>4</WarningLevel>
+ <PlatformTarget>AnyCPU</PlatformTarget>
+ <Prefer32Bit>false</Prefer32Bit>
+ </PropertyGroup>
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
+ <DebugType>pdbonly</DebugType>
+ <Optimize>true</Optimize>
+ <OutputPath>bin\</OutputPath>
+ <DefineConstants>TRACE</DefineConstants>
+ <ErrorReport>prompt</ErrorReport>
+ <WarningLevel>4</WarningLevel>
+ <Prefer32Bit>false</Prefer32Bit>
+ </PropertyGroup>
+ <ItemGroup>
+ <Reference Include="Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed, processorArchitecture=MSIL">
+ <HintPath>packages\Newtonsoft.Json.13.0.3\lib\net35\Newtonsoft.Json.dll</HintPath>
+ </Reference>
+ <Reference Include="System" />
+ <Reference Include="System.Data" />
+ <Reference Include="System.Data.DataSetExtensions" />
+ <Reference Include="System.Data.OracleClient" />
+ <Reference Include="System.Web.Extensions" />
+ <Reference Include="System.Drawing" />
+ <Reference Include="System.Web" />
+ <Reference Include="System.Xml" />
+ <Reference Include="System.Configuration" />
+ <Reference Include="System.Web.Services" />
+ <Reference Include="System.EnterpriseServices" />
+ <Reference Include="System.Xml.Linq" />
+ </ItemGroup>
+ <ItemGroup>
+ <None Include="packages.config" />
+ <None Include="Web.Debug.config">
+ <DependentUpon>Web.config</DependentUpon>
+ </None>
+ <None Include="Web.Release.config">
+ <DependentUpon>Web.config</DependentUpon>
+ </None>
+ </ItemGroup>
+ <ItemGroup>
+ <Content Include="Web.config" />
+ <Content Include="WebService1.asmx" />
+ </ItemGroup>
+ <ItemGroup>
+ <Compile Include="DBorl.cs" />
+ <Compile Include="Properties\AssemblyInfo.cs" />
+ <Compile Include="SQLHelperClass.cs" />
+ <Compile Include="WebService1.asmx.cs">
+ <DependentUpon>WebService1.asmx</DependentUpon>
+ <SubType>Component</SubType>
+ </Compile>
+ </ItemGroup>
+ <PropertyGroup>
+ <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>
+ <VSToolsPath Condition="'$(VSToolsPath)' == ''">$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion)</VSToolsPath>
+ </PropertyGroup>
+ <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
+ <Import Project="$(VSToolsPath)\WebApplications\Microsoft.WebApplication.targets" Condition="'$(VSToolsPath)' != ''" />
+ <Import Project="$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v10.0\WebApplications\Microsoft.WebApplication.targets" Condition="false" />
+ <ProjectExtensions>
+ <VisualStudio>
+ <FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}">
+ <WebProjectProperties>
+ <UseIIS>True</UseIIS>
+ <AutoAssignPort>True</AutoAssignPort>
+ <DevelopmentServerPort>57264</DevelopmentServerPort>
+ <DevelopmentServerVPath>/</DevelopmentServerVPath>
+ <IISUrl>https://localhost:44347/</IISUrl>
+ <NTLMAuthentication>False</NTLMAuthentication>
+ <UseCustomServer>False</UseCustomServer>
+ <CustomServerUrl>
+ </CustomServerUrl>
+ <SaveServerSettingsInUserFile>False</SaveServerSettingsInUserFile>
+ </WebProjectProperties>
+ </FlavorProperties>
+ </VisualStudio>
+ </ProjectExtensions>
+ <!-- To modify your build process, add your task inside one of the targets below and uncomment it.
+ Other similar extension points exist, see Microsoft.Common.targets.
+ <Target Name="BeforeBuild">
+ </Target>
+ <Target Name="AfterBuild">
+ </Target>
+ -->
+</Project>
\ No newline at end of file
diff --git a/WebserviceGS.sln b/WebserviceGS.sln
new file mode 100644
index 0000000..ad599c9
--- /dev/null
+++ b/WebserviceGS.sln
@@ -0,0 +1,25 @@
+锘�
+Microsoft Visual Studio Solution File, Format Version 12.00
+# Visual Studio Version 17
+VisualStudioVersion = 17.5.33414.496
+MinimumVisualStudioVersion = 10.0.40219.1
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "WebserviceGS", "WebserviceGS.csproj", "{1E975DB8-481F-471C-81F7-BE45FE9EB702}"
+EndProject
+Global
+ GlobalSection(SolutionConfigurationPlatforms) = preSolution
+ Debug|Any CPU = Debug|Any CPU
+ Release|Any CPU = Release|Any CPU
+ EndGlobalSection
+ GlobalSection(ProjectConfigurationPlatforms) = postSolution
+ {1E975DB8-481F-471C-81F7-BE45FE9EB702}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+ {1E975DB8-481F-471C-81F7-BE45FE9EB702}.Debug|Any CPU.Build.0 = Debug|Any CPU
+ {1E975DB8-481F-471C-81F7-BE45FE9EB702}.Release|Any CPU.ActiveCfg = Release|Any CPU
+ {1E975DB8-481F-471C-81F7-BE45FE9EB702}.Release|Any CPU.Build.0 = Release|Any CPU
+ EndGlobalSection
+ GlobalSection(SolutionProperties) = preSolution
+ HideSolutionNode = FALSE
+ EndGlobalSection
+ GlobalSection(ExtensibilityGlobals) = postSolution
+ SolutionGuid = {61F17D80-25A2-4520-B1C0-4AE3008870E1}
+ EndGlobalSection
+EndGlobal
diff --git a/packages.config b/packages.config
new file mode 100644
index 0000000..772efce
--- /dev/null
+++ b/packages.config
@@ -0,0 +1,4 @@
+锘�<?xml version="1.0" encoding="utf-8"?>
+<packages>
+ <package id="Newtonsoft.Json" version="13.0.3" targetFramework="net35" />
+</packages>
\ No newline at end of file
--
Gitblit v1.9.3