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())"; }