NuGet修改默认包保存的位置

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

<?xml version="1.0" encoding="utf-8"?>

</packageSources>

</config>

</configuration>

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

Asp.Net中强制文件下载

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;

}

C# WebRequest请求

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;

}

MySQLHelper/Util类

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);

}

log4net独立文件配置

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

<?xml version="1.0" encoding="utf-8" ?>

</configSections>

</layout>

</filter>

</appender>

</layout>

</filter>

</appender>

</layout>

</filter>

</appender>

</layout>

</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);

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

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不一致引起的这个问题。解决：重新引用也无效，那只有手动编辑项目文件了~

Dapper中条件为In的写法

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

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

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

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

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

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

C#生成Guid的几种方式

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

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

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

PadLeft,PadRight用法

补位 string str = "100"; str.PadLeft(5,’0′) 输出：00100 str.PadRight(5, '0') 输出：10000 from:https://www.cnblogs.com/daviddong/p/5949794.html

October 2021
M	T	W	T	F	S	S
« Sep
				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