mimi001

////dt 是需要返回星期几的具体日期
////下面的实现方式，是采用的默认每周的第一天是Sunday（星期日）
public static string CnWeekDayName(DateTime dt)
{
    string[] cnWeekDayNames = {"日", "一", "二", "三", "四", "五", "六"};

    return "星期" + cnWeekdayNames[(int)dt.DayOfWeek];
}

using System.Data;
using System.Data.SQLite;
//...

using (SQLiteConnection cn = new SQLiteConnection(
    "Data Source=Test.db3;Pooling=true;FailIfMissing=false")
    )
{
    //在打开数据库时，会判断数据库是否存在，如果不存在，则在当前目录下创建一个
    cn.Open();

    using (SQLiteCommand cmd = new SQLiteCommand())
    {
        cmd.Connection = cn;

        //建立表，如果表已经存在，则报错
        cmd.CommandText = "CREATE TABLE [test] (id int, name nvarchar(20))";
        cmd.ExecuteNonQuery();

        //插入测试数据
        for (int i = 2; i < 5; i++)
        {
            cmd.CommandText = string.Format("INSERT INTO [test] VALUES ({0}, '中文测试')", i);
            cmd.ExecuteNonQuery();
        }

        for (int i = 5; i < 10; i++)
        {
            cmd.CommandText = string.Format("INSERT INTO [test] VALUES ({0}, 'English Test')", i);
            cmd.ExecuteNonQuery();
        }

        //读取数据
        cmd.CommandText = "SELECT * FROM [test]";
        using (SQLiteDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
        {
            while (dr.Read())
            {
                Console.WriteLine("第{0} 条：{1}", dr.GetValue(0), dr.GetString(1));
            }
        }
    }
}

using NetFwTypeLib;

//创建firewall管理类的实例
INetFwMgr netFwMgr = (INetFwMgr)Activator.CreateInstance(Type.GetTypeFromProgID("HNetCfg.FwMgr"));

//创建一个认证程序类的实例
INetFwAuthorizedApplication app = (INetFwAuthorizedApplication)Activator.CreateInstance(
    Type.GetTypeFromProgID("HNetCfg.FwAuthorizedApplication"));

//在例外列表里，程序显示的名称
app.Name = "自定义"; 

//程序的决定路径，这里使用程序本身
app.ProcessImageFileName = Application.ExecutablePath;

//是否启用该规则
app.Enabled = true;

//加入到防火墙的管理策略
netFwMgr.LocalPolicy.CurrentProfile.AuthorizedApplications.Add(app);

INetFwMgr netFwMgr = (INetFwMgr)Activator.CreateInstance(Type.GetTypeFromProgID("HNetCfg.FwMgr"));
//参数为程序的绝对路径
netFwMgr.LocalPolicy.CurrentProfile.AuthorizedApplications.Remove(Application.ExecutablePath);

Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.InvariantCulture;

static bool IsWebResourceAvailable(string webResourceAddress)
{
    try
    {
        HttpWebRequest req = (HttpWebRequest)WebRequest.CreateDefault(new Uri(webResourceAddress));
        req.Method = "HEAD";
        req.Timeout = 1000;
        HttpWebResponse res = (HttpWebResponse)req.GetResponse();
        return (res.StatusCode == HttpStatusCode.OK);
    }
    catch (WebException wex)
    {
        System.Diagnostics.Trace.Write(wex.Message);
        return false;
    }
}

using System.Net;
using System.Net.Security;
using System.Security.Authentication;
using System.Security.Cryptography.X509Certificates;

public bool CheckValidationResult(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors errors)
{
    //直接确认，否则打不开
    return true;
}
    
private void button1_Click(object sender, EventArgs e)
{
    ServicePointManager.ServerCertificateValidationCallback = new System.Net.Security.RemoteCertificateValidationCallback(CheckValidationResult);
    HttpWebRequest req = (HttpWebRequest)WebRequest.CreateDefault(new Uri("https://zu14.cn/"));
    req.Method = "GET";
    HttpWebResponse res = (HttpWebResponse)req.GetResponse();
    //...正常使用了，和访问普通的 http:// 地址一样了

internal class AcceptAllCertificatePolicy : ICertificatePolicy
{
    public AcceptAllCertificatePolicy()
    {
    }

    public bool CheckValidationResult(ServicePoint sPoint, System.Security.Cryptography.X509Certificates.X509Certificate cert, WebRequest wRequest, int certProb)
    {
        //直接确认
        return true;
    }
}
    
private void button1_Click(object sender, EventArgs e)
{
    ServicePointManager.CertificatePolicy = new AcceptAllCertificatePolicy();
    HttpWebRequest req = (HttpWebRequest)WebRequest.CreateDefault(new Uri("https://zu14.cn/"));
    req.Method = "GET";
    HttpWebResponse res = (HttpWebResponse)req.GetResponse();
    //...正常使用了，和访问普通的 http:// 地址一样了