清雨小竹

利用Spire实现对Word模板的指定文字替换（文字、图片、表格）

【代码】EF数据类里面使用枚举类型enum。

宝塔IIS申请Let's Encrypt证书

using MongoDB.Bson;using MongoDB.Driver;using System;using System.Collections.Generic;using System.Configuration;using System.Linq;namespace YFMongoBD{ public class Db { privat

public ReturnNode exportReviewResult() { List<ReplaceExcelData> repData = new List<ReplaceExcelData>(); repData.Add(new ReplaceExcelData(3, 2, "名称1")); repData.Add(new ReplaceExcelData(3, 7, ...

App_Start目录下新建SwaggerCacheProvider.csusing Swashbuckle.Swagger;using System;using System.Collections.Concurrent;using System.Collections.Generic;using System.IO;using System.Linq;using System.Web;using System.Xml;namespace YFAPICommon.App_Start

private static object lockobj = new object();private test(){ lock (lockobj) { //........... }}

using Spire.Doc;using Spire.Doc.Documents;using System;using System.Collections.Generic;using System.ComponentModel;using System.Drawing;using System.Linq;using System.Web;namespace YFAPICommon.Libs{ public class WordTool { publi.

1.安装EntityFramework.Extended2.更改MyDBContext配置namespace EntityFrameworkCore{ [DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))] public class MyDBContext : DbContext { public MyDBContext() .

postman的RestClient引用库：RestSharp

在Action 上加[ApiExplorerSettings(IgnoreApi = true)][HttpGet][ApiExplorerSettings(IgnoreApi = true)]public ActionResult Index(string appKey , string username ){//todo}

@echo offset /p firststr="请输入文件名前缀："set /p kuozhan="请输入文件扩展名："set a=0setlocal EnableDelayedExpansiondir /b .\*.%kuozhan% | find /c /v "" >> .\tmp.txtset /p c=<.\tmp.txtdel /a /f /q .\tmp.txt for %%i in (*.%kuozhan%) do (set /a a+=1i.

例子：.Sum(d => d.money) //报错特殊处理：.Sum(d => ((decimal?)d.money))返回0.Select(d => d.count).DefaultIfEmpty().Sum();　　返回0.00

<httpProtocol> <customHeaders> <add name="Access-Control-Allow-Methods" value="OPTIONS,POST,GET"></add> <add name="Access-Control-Allow-Headers" value="x-requ...

1.从jexus官网下载最新版本的jexus，要是专业版的，解压到jexus目录下。default目录里面放的是网站文件。Dockerfile#base imageFROM centos# MAINTAINERMAINTAINER zzzili@qq.com# 拷贝jexus目录下所有内容到/usr目录下COPY jexus /usr/jexus/# 拷贝default目录下内容到网站根目录下COPY default /var/www/default/# 拷贝init.sh

using System;using System.Collections.Generic;using System.Linq;using System.Runtime.InteropServices;using System.Text;using System.Threading.Tasks;namespace 大屏Win{ public class WinMessageHelper { private struct COPYDATASTRUCT .

引入库：CefSharp.WinFormsusing CefSharp;using CefSharp.WinForms;using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namesp

System.Configuration.Configuration cfa = WebConfigurationManager.OpenWebConfiguration("~");string value = ConfigurationManager.AppSettings.Get("key");//获取key对应的valuecfa.AppSettings.Settings.Add("key", "value");//添加值cfa.AppSettings.Settings["ip"].Value .

using System;using System.Collections.Generic;using System.Drawing;using System.Drawing.Text;using System.IO;using System.Linq;using System.Net;using System.Web;using YFAPICommon.Controllers;namespace YFAPICommon.Libs{ public class YFFotoMi.

1.项目引用Senparc.Weixin.TenPay2.服务端代码using Senparc.Weixin.TenPay;using Senparc.Weixin.TenPay.V3;using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;namespace zzzili{ public class WXPay .

var t = Task.Run(() => { /////////////////////todo label2.Invoke(new Action(() => { ///////////////////todo })); });

public bool PHPSessionAuth(string phpsessionid) { try { string url = "http://xxxxxxxxxxxx/manage/administrator/getversion.html"; var request = (HttpWebRequest)WebRequest.Create(url); .

/////////////防暴力破解 string errornumkey = string.Format("errornum{0}", input.account); object errornum = HttpRuntime.Cache[errornumkey]; if (errornum != null && (int)errornum > 3) { ...

自己用到的：HttpRuntime.Cache.Insert("SchoolBindKcChangci", SchoolBindKcChangci, null, DateTime.MaxValue, TimeSpan.Zero);DateTime.MaxValue最大有效时间存Cache方法： 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 .

using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Web;/*HttpRuntime.Cache.Add( KeyName,//缓存名 KeyValue,//要缓存的对象 Dependencies,//依赖项 AbsoluteExpiration,//绝对过期时间 .

/// <summary> /// 数据字典内的key按照字典排序，常见于加密算法中 /// </summary> private static string sortKey(Dictionary<string, object> param) { StringBuilder str = new StringBuilder(); var keys...

Certify是带GUI的Let's Encrype证书申请工具Certify下载地址：https://certifytheweb.com/1.下载安装启动后，点击左上角新建证书。输入名称，添加域名2.点击右边Authorization，验证类型选择dns-01,因为我的域名是在阿里云上，所以DNS Update Method选择Aliyun DNS API。Credentials选择右边的New。3.去阿里云上申请一个AccessKey，配置到这里4.点击DNS Zo.

1.添加Newtonsoft.Json2.添加MySql EF支持3.开发Model类 using System;using System.Collections.Generic;using System.ComponentModel.DataAnnotations;using System.ComponentModel.DataAnnotations.Schema;usi

using Newtonsoft.Json;using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Web;namespace YFAPICommon.Libs{ public class MerchantConfig { ...

/// <summary> /// 计算md5 /// </summary> /// <param name="str"></param> /// <returns></returns> private string CalcMD...

using Newtonsoft.Json;using Newtonsoft.Json.Linq;using System;using System.Collections.Generic;using System.Linq;using System.Net.Http;using System.Net.Http.Headers;using System.Web;namespac...

h5调用第三方api时候经常遇到不允许跨域的问题，用webapi实现一个代理http接口，方便进行跨域请求。using Newtonsoft.Json;using Newtonsoft.Json.Linq;using System;using System.Collections.Generic;using System.IO;using System.Linq;using Sy...

1.建立.net core的webapi项目参看：http://blog.youkuaiyun.com/zzzili/article/details/753073082.在项目中添加MyDBContext类和实体类Userusing System;using System.Collections.Generic;using System.Linq;using System.Threading.Tasks...

一般自定义View       代码方式 有      在初始化的时候添加 子Views[cpp] view plaincopy- (id)initWithFrame:(CGRect)frame  {      self = [super initWithFrame:frame];      if (self) {

引用：Aliyun.Acs.Dysmsusing System;using System.Collections.Generic;using System.Linq;using System.Web;using Aliyun.Acs.Core;using Aliyun.Acs.Core.Profile;using Aliyun.Acs.Core.Exceptions;using...

VS 版本：VS2017，时间：2018-10-08。1：下载插件 mysql-for-visualstudio，地址：mysql-for-visualstudio-1.2.72：下载插件mysql-connector-net，地址：mysql-connector-net注意：最新版 mysql-connector-net 版本在6.10.x 以上，并不适用于vs2...

using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;using NPOI.XSSF.UserModel;using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Diagnostics...

一、创建拼音对照表-- 创建汉字拼音对照临时表CREATE TABLE IF NOT EXISTS `t_base_pinyin` ( `pin_yin_` varchar(255) CHARACTER SET gbk NOT NULL, `code_` int(11) NOT NULL, PRIMARY KEY (`code_`)) ENGINE=InnoDB DEFAULT

WebApi 技巧1.返回参数去掉xml格式，以纯json格式返回。在WebApiConfig.cs文件中配置 public static void Register(HttpConfiguration config) { //////////////设置不以xml格式返回 config.Formatters

/// <summary> /// 分页获取数据列表 /// </summary> public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex) { StringBuilder strSql = new StringBuilder();