一切福田，不離方寸，從心而覓，感無不通。

Category Archives: C#

C#与Java互通AES算法加密解密

利用AES加密算法对报文进行加密解密，实现C#与Java互通，网上查了一堆也许是因为版本的原因都用不了，于是还是静心下来自己写个

龙生   11 Mar 2022
View Details

解决出现“未能加载文件或程序集“System.Net.Http.Formatting, Version=5.2.3.0”的问题

我们在使用C#开发WebApi等相关程序时，可能因为某些原因会出现如下图所示的错误，原因就是我们在编译的时候，使用的dll库可能和最初的发生了改变，导致版本不一致造成的。

龙生   23 Feb 2022
View Details

Allow Zero Datetime=True产生的问题

MySQL连接字符串里加上了“Allow Zero Datetime=True”，导致错误：

1
System.Data.DataException: Error parsing column 15 (ADDDATE= - Object) ---> System.InvalidCastException: 指定的转换无效。

纠基原因，这句配置允许零日期后，MySQL与.Net的日期类型是不一样的，导致转换失败。去掉就正常了，默认值是False。

1
MySql.Data.Types.MySqlDateTime -> System.DateTime

 

龙生   17 Feb 2022
View Details

C#根据WSDL文件生成WebService服务端代码

虽然现在已经进入了.NET FrameWork 4.0的时代，WebService也已经逐渐被淘汰，取而代之的是WCF。 但在工作中难免遇到需要兼容旧版本程序和按照以前的文档进行开发。   一般一个已经实现功能的WebService会发布自己的WSDL文件，供客户端调用生成代理类。 但有时是先有server与client交互的接口定义（WSDL）文件，然后由server和client端分别写程序，一个提供web服务，一个使用web服务。 最近，我也遇到了这个问题。由于业务方仅提供了WSDL文件并确定了其规范，需要我们开发服务端供调用。   1、使用VS2010提供的工具wsdl.exe由WSDL文件生成cs文件 使用wsdl.exe的/serverInterface选项（或缩写的 /si）指定输入的wsdl文件（注意，如果要转换的wsdl文件中import了其他wsdl文件，则所有文件都应列出，包括使用到的xsd文件也应列出）。输出将是 一个代码文件（默认是C#的，如果需要别的语言，参考MSDN中wsdl.exe的使用说明），其中包含每个 wsdl 绑定的接口。 示例：假设有ServerInterfaceSample.wsdl wsdl.exe /si ServerInterfaceSample.wsdl 如果使用Service.xsd作为schema文件,则改为 wsdl.exe /si ServerInterfaceSample.wsdl  Service.xsd 生成代码如下:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
//------------------------------------------------------------------------------
// <auto-generated>
//     此代码由工具生成。
//     运行时版本:4.0.30319.239
//
//     对此文件的更改可能会导致不正确的行为，并且如果
//     重新生成代码，这些更改将会丢失。
// </auto-generated>
//------------------------------------------------------------------------------
  
using System;
using System.ComponentModel;
using System.Diagnostics;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Serialization;
  
// 
// 此源代码由 wsdl 自动生成, Version=4.0.30319.1。
// 
  
/// <remarks/>
[System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "4.0.30319.1")]
[System.Web.Services.WebServiceBindingAttribute(Name="WebServiceSoap", Namespace="http://tempuri.org/")]
public interface IWebServiceSoap {
      
    /// <remarks/>
    [System.Web.Services.WebMethodAttribute()]
    [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/sendSMS", RequestNamespace="http://tempuri.org/", ResponseNamespace="http://tempuri.org/", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
    long sendSMS(InfoHeader header, string sessionId, string sender, string smsContent, string receiverList, string productCode, string pseudoFlag);
}

2、使用以上生成的文件进行修改，实现你的WebService方法即可.   from:https://www.cnblogs.com/anbylau2130/p/3481804.html   2、使用以上生成的文件进行修改，实现你的WebService方法即可.

龙生   19 Nov 2021
View Details

c# + mysql防SQL注入方法

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
        /// <summary>
        /// 替换SQL注入的危险字符
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static string ReplaceInjectString(string param)
        {
            if (string.IsNullOrEmpty(param))
                return string.Empty;
 
            var result = new StringBuilder(param);
            return result
                    .Replace("'", "&#39;")
                    .Replace(",", "&#44;")
                    .Replace(";", "&#59;")
                    .Replace("(", "&#40;")
                    .Replace("=", "&#61;")
                    .Replace("*", "&#42;")
                    .Replace("&", "&#38;")
                    .ToString();
        }

 

龙生   05 Nov 2021
View Details

NuGet修改默认包保存的位置

NuGet默认的全局包下载地址一般为:C:\Users\{username}\.nuget\packages     修改方法：  

1
2
3
4
5
6
7
8
9
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <packageSources>
    <add key="Microsoft Visual Studio Offline Packages" value="C:\Program Files (x86)\Microsoft SDKs\NuGetPackages\"/>
  </packageSources>
  <config>
     <add key="globalPackagesFolder" value="D:\Nuget\.nuget\packages" />
  </config>
</configuration>

  from:https://www.cnblogs.com/sword88/p/11490304.html

龙生   19 Oct 2021
View Details

Asp.Net中强制文件下载

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
public HttpResponseMessage ImportTemplate(string fileName)
{
var context = HttpContext.Current;
var response = new HttpResponseMessage(HttpStatusCode.OK);
 
var path = context.Server.MapPath("~/App_Data/" + fileName);
if (string.IsNullOrEmpty(fileName) || !File.Exists(path))
{
response = new HttpResponseMessage(HttpStatusCode.NotFound)
{
Content = new StringContent($"<meta charset=\"utf-8\"><h3>【{fileName}】不存在。</h3>", Encoding.UTF8)
};
response.Content.Headers.ContentType = new MediaTypeHeaderValue("text/html");
return response;
}
 
var stream = new FileStream(path, FileMode.Open, FileAccess.Read);
response.Content = new StreamContent(stream);
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = HttpUtility.UrlEncode(fileName)
};
response.Headers.Add("Access-Control-Expose-Headers", "FileName");
response.Headers.Add("FileName", HttpUtility.UrlEncode(fileName));
 
return response;
}

 

龙生   17 Aug 2021
View Details

C# WebRequest请求

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
using System;
using System.IO;
using System.Net;
using System.Text;
 
namespace w3cnet.Utils
{
    /// <summary>
    /// Web请求相关
    /// </summary>
    public class WebUtil
    {
        /// <summary>
        /// 获取公网url内容
        /// </summary>
        /// <param name="url"></param>
        /// <returns></returns>
        public static string GetPage(string url)
        {
            return RequestGet(url);
        }
 
        /// <summary>
        /// Post请求
        /// </summary>
        /// <returns></returns>
        public static string RequestGet(string url)
        {
            //请求
            var request = (HttpWebRequest)WebRequest.Create(url);
            request.Timeout = 3600000; //3600秒
 
            //接收
            var response = request.GetResponse();
            var responseStream = response.GetResponseStream();
            if (responseStream != null)
            {
                var reader = new StreamReader(responseStream);
                var result = reader.ReadToEnd();
                reader.Close();
                response.Close();
 
                return result;
            }
 
            return string.Empty;
        }
 
        /// <summary>
        /// Post请求
        /// </summary>
        /// <returns></returns>
        public static string RequestPost(string url, string data = null, Encoding encoding = null)
        {
            if (encoding == null) encoding = Encoding.UTF8;
 
            //请求
            var request = (HttpWebRequest)WebRequest.Create(url);
            request.Method = "POST";
            request.ContentType = "application/x-www-form-urlencoded";
 
            //参数
            if (!string.IsNullOrEmpty(data))
            {
                var byteArray = encoding.GetBytes(data);
 
                request.ContentLength = byteArray.Length;
 
                var requestStream = request.GetRequestStream();
                requestStream.Write(byteArray, 0, byteArray.Length);
                requestStream.Close();
            }
 
            //接收
            var response = request.GetResponse();
            var responseStream = response.GetResponseStream();
            if (responseStream != null)
            {
                var reader = new StreamReader(responseStream, encoding);
                var result = reader.ReadToEnd();
                reader.Close();
                response.Close();
 
                return result;
            }
 
            return string.Empty;
        }
    }
}

 

龙生   04 Jul 2021
View Details

MySQLHelper/Util类

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
using System;
using System.Collections.Generic;
using System.Configuration;
using MySql.Data.MySqlClient;
using System.Data;
 
namespace Utils
{
    /// <summary>
    /// MySQL数据库工具类
    /// </summary>
    public abstract class MySQLUtil
    {
        /// <summary>
        /// 数据库连接字符串
        /// </summary>
        public static readonly string ConnStr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
 
        /// <summary>
        /// 执行语句并返回影响的行数
        /// </summary>
        /// <param name="connStr">数据库连接字符串</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>影响的行数</returns>
        public static int ExecuteNonQuery(string connStr, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            using (var conn = new MySqlConnection(connStr))
            {
                return ExecuteNonQuery(conn, cmdType, cmdText, parameters);
            }
        }
 
        /// <summary>
        /// 执行语句并返回影响的行数
        /// </summary>
        /// <param name="conn">数据库连接</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>影响的行数</returns>
        public static int ExecuteNonQuery(MySqlConnection conn, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            using (var cmd = new MySqlCommand())
            {
                PrepareCommand(cmd, conn, null, cmdType, cmdText, parameters);
 
                var val = cmd.ExecuteNonQuery();
                cmd.Parameters.Clear();
 
                return val;
            }
        }
 
        /// <summary>
        /// 执行语句并返回影响的行数
        /// </summary>
        /// <param name="trans">事务</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>影响的行数</returns>
        public static int ExecuteNonQuery(MySqlTransaction trans, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            using (var cmd = new MySqlCommand())
            {
                PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, parameters);
                var val = cmd.ExecuteNonQuery();
                cmd.Parameters.Clear();
 
                return val;
            }
        }
 
        /// <summary>
        /// 执行语句并返回DataReader对象
        /// </summary>
        /// <param name="connStr">数据库连接字符串</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>执行语句并返回DataReader对象</returns>
        /// <remarks>P.S：DataReader使用后要手动释放</remarks>
        public static MySqlDataReader ExecuteReader(string connStr, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            var cmd = new MySqlCommand();
            var conn = new MySqlConnection(connStr);
 
            try
            {
                PrepareCommand(cmd, conn, null, cmdType, cmdText, parameters);
                var dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                cmd.Parameters.Clear();
 
                return dr;
            }
            catch
            {
                conn.Close();
                throw;
            }
        }
 
        /// <summary>
        /// 执行语句并返回DataSet对象
        /// </summary>
        /// <param name="cmdText"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public static DataSet ExecuteDataSet(string cmdText, params MySqlParameter[] parameters)
        {
            return ExecuteDataSet(ConnStr, CommandType.Text, cmdText, parameters);
        }
 
        /// <summary>
        /// 执行语句并返回DataSet对象
        /// </summary>
        /// <param name="connStr">数据库连接字符串</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>执行语句并返回DataSet对象</returns>
        /// <returns></returns>
        public static DataSet ExecuteDataSet(string connStr, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            using (var conn = new MySqlConnection(connStr))
            {
                return ExecuteDataSet(conn, cmdType, cmdText, parameters);
            }
        }
 
        /// <summary>
        /// 执行语句并返回DataSet对象
        /// </summary>
        /// <param name="connStr">数据库连接字符串</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>执行语句并返回DataSet对象</returns>
        /// <returns></returns>
        public static DataSet ExecuteDataSet(MySqlConnection conn, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            using (var cmd = new MySqlCommand())
            {
                PrepareCommand(cmd, conn, null, cmdType, cmdText, parameters);
                using (var da = new MySqlDataAdapter(cmd))
                {
                    var ds = new DataSet();
                    try
                    {
                        da.Fill(ds, "ds");
                        cmd.Parameters.Clear();
                    }
                    catch (MySqlException ex)
                    {
                        throw new Exception(ex.Message);
                    }
                    return ds;
                }
            }
        }
 
        /// <summary>
        /// 执行语句并返回一个对象
        /// </summary>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>返回一个object对象，对象中只包含一列。</returns>
        public static object ExecuteScalar(string cmdText, params MySqlParameter[] parameters)
        {
            return ExecuteScalar(ConnStr, CommandType.Text, cmdText, parameters);
        }
 
        /// <summary>
        /// 执行语句并返回一个对象
        /// </summary>
        /// <param name="connStr">数据库连接字符串</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>返回一个object对象，对象中只包含一列。</returns>
        public static object ExecuteScalar(string connStr, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            using (var conn = new MySqlConnection(connStr))
            {
                return ExecuteScalar(conn, cmdType, cmdText, parameters);
            }
        }
 
        /// <summary>
        /// 执行语句并返回一个对象
        /// </summary>
        /// <param name="conn">数据库连接</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="parameters">参数集</param>
        /// <returns>返回一个object对象，对象中只包含一列。</returns>
        public static object ExecuteScalar(MySqlConnection conn, CommandType cmdType, string cmdText, params MySqlParameter[] parameters)
        {
            using (var cmd = new MySqlCommand())
            {
                PrepareCommand(cmd, conn, null, cmdType, cmdText, parameters);
                var val = cmd.ExecuteScalar();
                cmd.Parameters.Clear();
                return val;
            }
        }
 
        /// <summary>
        /// 为执行准备命令对象
        /// </summary>
        /// <param name="cmd">command 对象</param>
        /// <param name="conn">连接对象</param>
        /// <param name="trans">事务对象</param>
        /// <param name="cmdType">命令类型</param>
        /// <param name="cmdText">命令字符串</param>
        /// <param name="cmdParms">参数集</param>
        private static void PrepareCommand(MySqlCommand cmd, MySqlConnection conn, MySqlTransaction trans, CommandType cmdType, string cmdText, IEnumerable<MySqlParameter> parameters)
        {
 
            if (conn.State != ConnectionState.Open)
                conn.Open();
 
            cmd.Connection = conn;
            cmd.CommandText = cmdText;
 
            if (trans != null)
                cmd.Transaction = trans;
 
            cmd.CommandType = cmdType;
 
            if (parameters == null) return;
            foreach (var parm in parameters)
                cmd.Parameters.Add(parm);
        }
    }
}

 

龙生   30 Jun 2021
View Details

log4net独立文件配置

🥝 NuGet引用log4net 🥝 Configs文件夹下创建log4net.config

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
</configSections>
 
<log4net>
<appender name="InfoRollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
<file value="Logs\\" />
<lockingModel type="log4net.Appender.FileAppender+MinimalLock" />
<appendToFile value="true" />
<rollingStyle value="Date" />
<datePattern value="yyyyMM\\&quot;info_&quot;yyyy-MM-dd&quot;.log&quot;" />
<staticLogFileName value="false" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="***************************************************************************************************************************************************%n[%d] [%p] [%F Line:%L] %m%n" />
</layout>
<filter type="log4net.Filter.LevelRangeFilter">
<param name="LevelMin" value="INFO" />
<param name="LevelMax" value="INFO" />
</filter>
</appender>
<appender name="DebugRollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
<file value="Logs\\" />
<lockingModel type="log4net.Appender.FileAppender+MinimalLock" />
<appendToFile value="true" />
<rollingStyle value="Date" />
<datePattern value="yyyyMM\\&quot;debug_&quot;yyyy-MM-dd&quot;.log&quot;" />
<staticLogFileName value="false" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="***************************************************************************************************************************************************%n[%d] [%p] [%F Line:%L] %m%n" />
</layout>
<filter type="log4net.Filter.LevelRangeFilter">
<param name="LevelMin" value="DEBUG" />
<param name="LevelMax" value="DEBUG" />
</filter>
</appender>
<appender name="WarnRollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
<file value="Logs\\" />
<lockingModel type="log4net.Appender.FileAppender+MinimalLock" />
<appendToFile value="true" />
<rollingStyle value="Date" />
<datePattern value="yyyyMM\\&quot;warn_&quot;yyyy-MM-dd&quot;.log&quot;" />
<staticLogFileName value="false" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="***************************************************************************************************************************************************%n[%d] [%p] [%F Line:%L] %m%n" />
</layout>
<filter type="log4net.Filter.LevelRangeFilter">
<param name="LevelMin" value="WARN" />
<param name="LevelMax" value="WARN" />
</filter>
</appender>
<appender name="ErrorRollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
<file value="Logs\\" />
<lockingModel type="log4net.Appender.FileAppender+MinimalLock" />
<appendToFile value="true" />
<rollingStyle value="Date" />
<datePattern value="yyyyMM\\&quot;error_&quot;yyyy-MM-dd&quot;.log&quot;" />
<staticLogFileName value="false" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="***************************************************************************************************************************************************%n[%d] [%p] [%F Line:%L] %m%n" />
</layout>
<filter type="log4net.Filter.LevelRangeFilter">
<param name="LevelMin" value="Error" />
<param name="LevelMax" value="FATAL" />
</filter>
</appender>
<root>
<appender-ref ref="InfoRollingLogFileAppender" />
<appender-ref ref="DebugRollingLogFileAppender" />
<appender-ref ref="WarnRollingLogFileAppender" />
<appender-ref ref="ErrorRollingLogFileAppender" />
</root>
</log4net>
</configuration>

  🥝 AssemblyInfo.cs文件下添加

1
[assembly: log4net.Config.XmlConfigurator(ConfigFile = @"Configs\log4net.config", Watch = true)]

  🥝 类中引用

1
private ILog log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);

 

龙生   25 Jun 2021
View Details
1 … 3 4 5 … 43

Copyright © 2024 Longsheng All rights reserved