public static string[] QueryFrequentSearchKeyword()
{
string[] items = new string[9] {
"", "", "", "", "", "", "", "", ""
};
using (IDbConnection conn = DbHelperMySQL.GetDbConnection())
{
//查最近9条经常被查询的关键字
string sql = @$ "select * from FrequentSearchKeyword where ESIndexName = '{ESTest.control.SSSourceFilesHelper.ESINDEXNAME}'
order by Count desc,LastSearchTime desc limit 9";
var kwList = conn.Query <FrequentSearchKeyword>(sql);
int i = 0;
foreach (var kw in kwList)
{
items[i++] = kw.KeyWord;
if (i >= 9)
{
break;
}
}
}
return(items);
}
public bool RegisterNewUser(string userID, string userName, string password, out string errMsg)
{
errMsg = string.Empty;
string createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string reserveString = $"创建时间:{createTime}";
using (IDbConnection conn = DbHelperMySQL.GetDbConnection())
{
UserInfo user = new UserInfo()
{
UserID = userID,
UserName = userName,
Password = password,
ReserveString = reserveString,
};
int cnt = conn.Execute(@"replace into UserInfo(UserID,UserName,Password,ReserveString) values(@UserID,@UserName,@Password,@ReserveString)", user);
if (cnt > 0)
{
return(true);
}
}
return(false);
}
public string GetEmptyUserID4Register()
{
using (IDbConnection conn = DbHelperMySQL.GetDbConnection())
{
string sql = @"select UserID from UserInfo where UserID not like '9%' order by UserID";
var userList = conn.Query <UserInfo>(sql);
var user = userList.LastOrDefault();
//maxUserID+1
int i = DTSTools.ConvertToInt(user.UserID, 0);
i++;
return(i.ToString("000"));
}
}
public bool LoginUser(string userID, string password, out string userName)
{
userName = string.Empty;
using (IDbConnection conn = DbHelperMySQL.GetDbConnection())
{
string sql = @"select * from UserInfo where UserID = @UserID";
var user = conn.Query <UserInfo>(sql, new { UserID = userID }).FirstOrDefault <UserInfo>();
if (string.IsNullOrEmpty(user.UserID))
{
log.InfoFormat("数据库中不存在{0}的用户信息", userID);
return(false);
}
userName = user.UserName;
return(user.Password.Equals(password));
}
}
public static Task <bool> SaveSearchKeyWordInfoAsync(string keyWord)
{
return(Task.Run(() =>
{
if (string.IsNullOrEmpty(keyWord))
{
return false;
}
using (IDbConnection conn = DbHelperMySQL.GetDbConnection())
{
string sql = @$ "select count(*) from FrequentSearchKeyword where ESIndexName = '{ESTest.control.SSSourceFilesHelper.ESINDEXNAME}'
and KeyWord='{keyWord}'";
int cnt = conn.Query <int>(sql).Single();
log.InfoFormat("sql:{0},cnt:{1}", sql, cnt);
if (cnt == 0)
{
sql = @$ "insert into FrequentSearchKeyword(ESIndexName,KeyWord,Count,LastSearchTime)
values('{ESTest.control.SSSourceFilesHelper.ESINDEXNAME}','{keyWord}',1,Now())";
}
