让APACHE2支持PHP7：
sudo apt-get install libapache2-mod-phpservice apache2 restartfor php5.5
apt-get install libapache2-mod-php5PHP安装 sqlite
sudo apt-get install php7.0-sqlitesudo service apache2 restartPHP安装 mbstring
sudo apt-get install php7.0-mbstringsudo service apache2 restartPHP安装 curl
sudo apt-get install php7.0-curlsudo service apache2 restartEntity framework 中比较日期 ，使用linq的写法：
var totalCount = db.CallLog.Where(x => x.CallTime.Year == DateTime.Now.Year && x.CallTime.Month == DateTime.Now.Month && x.CallTime.Day == DateTime.Now.Day).Count();分别比较年月日，虽然不好看，但是可以正常工作。
EntityFramework Linq 查询中不能使用int.parse，否则报错，报错信息如下：
报错信息：LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method
var data = from v in db.Vip
join b in db.Business on v.BusinessId equals b.Id
where v.Level == int.Parse(level) // 这样写会报错
select new VipInfoModel
{
VipName = v.VipName,
Level = v.Level.Value,
BusinessId = v.BusinessId.Value,
BusinessName = b.Name,
DisplayName = b.DisplayName
};解决方案：把int.parse拿到外面
var _level = int.Parse(level);
var data = from v in db.Vip
join b in db.Business on v.BusinessId equals b.Id
where v.Level == _level
select new VipInfoModel
{
VipName = v.VipName,
Level = v.Level.Value,
BusinessId = v.BusinessId.Value,
BusinessName = b.Name,
DisplayName = b.DisplayName
};安卓4.4及4.4以上 全屏代码，加在onCreate中：
//全屏开始
supportActionBar?.hide() // 隐藏标题栏
window.setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN) //设置全屏
//设置屏幕长亮
window.setFlags(WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON,
WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON)
setContentView(R.layout.activity_main)
// 这个组合不好用，当在触摸屏幕时还是会出现系统导航栏（home, back等）
val mUIFlag = (View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
or View.SYSTEM_UI_FLAG_LAYOUT_STABLE
or View.SYSTEM_UI_FLAG_LOW_PROFILE
or View.SYSTEM_UI_FLAG_FULLSCREEN
or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION)
// 4.4以及上全屏
val mUIFlag2 =(
View.SYSTEM_UI_FLAG_LAYOUT_STABLE
or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION // hide nav bar
or View.SYSTEM_UI_FLAG_FULLSCREEN // hide status bar
or View.SYSTEM_UI_FLAG_IMMERSIVE)
//取消全屏
val cancelFullScreenFlag = (View.SYSTEM_UI_FLAG_LAYOUT_STABLE
or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN)
window.decorView.systemUiVisibility = mUIFlag2
// 全屏结束项目中的代码
override fun onCreate(savedInstanceState: Bundle?) {
super.onCreate(savedInstanceState)
//全屏开始
supportActionBar?.hide() // 隐藏标题栏
window.setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN) //设置全屏
//设置屏幕长亮
window.setFlags(WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON,
WindowManager.LayoutParams.FLAG_KEEP_SCREEN_ON)
setContentView(R.layout.activity_main)
// 这个组合不好用，当在触摸屏幕时还是会出现系统导航栏（home, back等）
val mUIFlag = (View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
or View.SYSTEM_UI_FLAG_LAYOUT_STABLE
or View.SYSTEM_UI_FLAG_LOW_PROFILE
or View.SYSTEM_UI_FLAG_FULLSCREEN
or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION)
// 4.4以及上全屏
val mUIFlag2 =(
View.SYSTEM_UI_FLAG_LAYOUT_STABLE
or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN
or View.SYSTEM_UI_FLAG_HIDE_NAVIGATION // hide nav bar
or View.SYSTEM_UI_FLAG_FULLSCREEN // hide status bar
or View.SYSTEM_UI_FLAG_IMMERSIVE)
//取消全屏
val cancelFullScreenFlag = (View.SYSTEM_UI_FLAG_LAYOUT_STABLE
or View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION
or View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN)
window.decorView.systemUiVisibility = mUIFlag2
// 全屏结束
//注册onLongClick监听器
super.findViewById<LinearLayout>(R.id.changeBkgArea).setOnLongClickListener(PicOnLongClick())
super.findViewById<LinearLayout>(R.id.settingArea).setOnLongClickListener(OnLongClickSetting())
loadConfig()
loadBackgroundImage()
startGetCommandLoop()
}如何用SQL SERVER内置的函数把NULL转换成空字符串
isnull(字段名,'')如果字段为null，会得到空字符串；如果字段不为null，则会得到字段值
ASP.NET MVC在Controller中，把JsonResult转为JSON字符串
string json = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(jsonResult.Data);
Response.Write(json);使用System.IO.File.Create(path);创建的文件如何关闭
FileStream fs = System.IO.File.Create(path);
fs.Close();使用下面的命令查看Hello.exe所依赖的DLL:
windeployqt Hello.exe如果还有缺少的DLL，可以根据报错提示用 Everything 工具进行查找，然后放进程序目录就行了。
qt quick 的程序要这样发布
-qmldir 后面是qt的qml目录
windeployqt daolan.exe -qmldir "D:\Qt\Qt5.8.0\5.8\mingw53_32\qml"一个 VC++ 中使用的 HttpClient 类，可以进行HTTP GET和POST，代码如下：
HttpClient.h
#pragma once
#include <string>
#include <vector>
using namespace std;
class CHttpClient
{
public:
CHttpClient(void);
~CHttpClient(void);
BOOL Get(LPCSTR url, string &result);
};
HttpClient.cpp
#include "stdafx.h"
#include "HttpClient.h"
#include <wininet.h>
#pragma comment(lib, "wininet.lib")
CHttpClient::CHttpClient(void)
{
}
CHttpClient::~CHttpClient(void)
{
}
BOOL CHttpClient::Get(LPCSTR url, string &result)
{
result.clear();
vector<char> v;
const CHAR * szUrl = url;
CHAR szAgent[] = "";
HINTERNET hInternet1 =
InternetOpen(NULL,INTERNET_OPEN_TYPE_PRECONFIG,NULL,NULL,NULL);
if (NULL == hInternet1)
{
InternetCloseHandle(hInternet1);
return FALSE;
}
HINTERNET hInternet2 =
InternetOpenUrl(hInternet1,szUrl,NULL,NULL,INTERNET_FLAG_NO_CACHE_WRITE,NULL);
if (NULL == hInternet2)
{
InternetCloseHandle(hInternet2);
InternetCloseHandle(hInternet1);
return FALSE;
}
DWORD dwMaxDataLength = 500;
PBYTE pBuf = (PBYTE)malloc(dwMaxDataLength*sizeof(TCHAR));
if (NULL == pBuf)
{
InternetCloseHandle(hInternet2);
InternetCloseHandle(hInternet1);
return FALSE;
}
DWORD dwReadDataLength = NULL;
BOOL bRet = TRUE;
do
{
ZeroMemory(pBuf,dwMaxDataLength*sizeof(TCHAR));
bRet = InternetReadFile(hInternet2,pBuf,dwMaxDataLength,&dwReadDataLength);
for (DWORD dw = 0;dw < dwReadDataLength;dw++)
{
v.push_back(pBuf[dw]);
}
} while (NULL != dwReadDataLength);
vector<char>::iterator i;
for(i=v.begin(); i!=v.end(); i++)
result += *i;
return TRUE;
}ProcessStartInfo 一定要写全路径，不然会出现一些莫明其妙的错误，比如开机自动启动时打不开。
ProcessStartInfo p1 = new ProcessStartInfo($"{Application.StartupPath}\\PD101AHelper.exe", $"{address} \"{windowShowMsg.Trim()}\" \"{zhShowMsg2 ?? ""}\"");
p1.WindowStyle = ProcessWindowStyle.Hidden;
Process.Start(p1);