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

Category Archives: C#

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

一个Asp.Net项目，不能编辑并继续，总提示引用的其他项目版本不允许变更

1
2
Severity Code Description Project File Line Suppression State
Error CS7038 Failed to emit module 'JTHY.Web': Changing the version of an assembly reference is not allowed during debugging: 'RUC.Base, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' changed version to '0.0.0.0'. JTHY.Web 1 Active

如题，公司的一个项目。 原因：由于未知的原因，被引用项目的GUID和引用的GUID不一致引起的这个问题。 解决：重新引用也无效，那只有手动编辑项目文件了~

龙生   20 May 2021
View Details

Dapper中条件为In的写法

今天用Dapper更新是用到了IN写法，园子里找了篇文章这样写到 传统sql in (1,2,3) 用dapper就这样写

1
2
3
conn.Query<Users>("SELECT * FROM Users s WHERE s.id IN (@ids) ",new { ids = new int[]{1,2,3}})
 
conn.Query<Users>("SELECT * FROM Users s WHERE s.id IN (@ids) ",new { ids = IDs.ToArray()})

用了之后出现， System.Data.SqlClient.SqlException:““,”附近有语法错误。” 这样的提示， 跟踪SQL语句时发现按以上方法生成的SQL语句是这样的：

1
exec sp_executesql N'update WebSiteChanelListPage set status=0 where ID IN ((@ilist1,@ilist2))',N'@ilist1 int,@ilist2 int',@ilist1=1,@ilist2=2

我们不难发现生成的语句中多了一层括号，于是果段修改代码：

1
2
string UpdateString = "update WebSiteChanelListPage set status=0 where ID IN @ilist";
connection.Execute(UpdateString,new { ilist = idlist.ToArray() });

执行成功！问题解决！ 当然也有可能是我的Dapper的版本问题，我用得是：Dapper 1.50.4.0   from:https://www.cnblogs.com/cmt/p/14580194.html?from=https%3A%2F%2Fwww.cnblogs.com%2Fxwei%2Fp%2F8794384.html&blogId=121045&postId=8794384

龙生   06 May 2021
View Details

vs 启用非托管调试时不允许更改

解决方案： 项目->右键属性->调试->启用本机代码调试，去掉勾选!   from:http://www.csframework.com/archive/1/arc-1-20170923-2353.htm

龙生   19 Apr 2021
View Details

如何：启用非托管代码调试

提示 Visual Studio 学习版（如 Visual C# 速成版）不支持调试非托管代码， 只有完整的 Visual Studio 产品才支持此操作。 位于**“项目设计器”的“调试”页上的“非托管代码调试”**属性确定是否支持本机代码调试。 如果要调用 COM 对象，或启动调用您的项目的、以本机代码编写的自定义程序，并且需要调试本机代码，请选定此选项。 启用对非托管代码的调试 在**“解决方案资源管理器”中选定一个项目，然后在“项目”菜单中单击“属性”**。 单击**“调试”**选项卡。 选中**“启用非托管代码调试”**复选框。 禁用对非托管代码的调试 在**“解决方案资源管理器”中选定一个项目，然后在“项目”菜单中单击“属性”**。 单击**“调试”**选项卡。 单击以清除**“启用非托管代码调试”**复选框。   from:https://docs.microsoft.com/zh-cn/previous-versions/visualstudio/visual-studio-2010/tdw0c6sf(v=vs.100)

龙生   19 Apr 2021
View Details

C#生成Guid的几种方式

1
2
3
4
5
6
var uuid = Guid.NewGuid().ToString(); // 9af7f46a-ea52-4aa3-b8c3-9fd484c2af12
var uuidN = Guid.NewGuid().ToString("N"); // e0a953c3ee6040eaa9fae2b667060e09
var uuidD = Guid.NewGuid().ToString("D"); // 9af7f46a-ea52-4aa3-b8c3-9fd484c2af12
var uuidB = Guid.NewGuid().ToString("B"); // {734fd453-a4f8-4c5d-9c98-3fe2d7079760}
var uuidP = Guid.NewGuid().ToString("P"); // (ade24d16-db0f-40af-8794-1e08e2040df3)
var uuidX = Guid.NewGuid().ToString("X"); // {0x3fa412e3,0x8356,0x428f,{0xaa,0x34,0xb7,0x40,0xda,0xaf,0x45,0x6f}}

  from:https://www.cnblogs.com/shiyh/p/10966059.html

龙生   19 Apr 2021
View Details

C#实现新建文件并写入内容

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
using System;
using System.IO;
 
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
 
            // 创建文件
            FileStream fs = new FileStream("test.doc", FileMode.OpenOrCreate, FileAccess.ReadWrite); //可以指定盘符，也可以指定任意文件名，还可以为word等文件
            StreamWriter sw = new StreamWriter(fs); // 创建写入流
            sw.WriteLine("bob hu"); // 写入Hello World
            sw.Close(); //关闭文件
 
        
        }
    }
}

  from:https://www.cnblogs.com/thingk/p/3363880.html

龙生   11 Mar 2021
View Details
1 … 4 5 6 … 47

Copyright © 2024 Longsheng All rights reserved.