public int NoReadCount() { string dbPath = $@"{AntSdkService.SqliteLocalDbPath}{AntSdkService.AntSdkLoginOutput.userId}\{ AntSdkService.AntSdkLoginOutput.userId}.db"; string strCount = "select max(unreadcount) as count from T_Session"; return(Convert.ToInt32(AntSdkSqliteHelper.ExecuteScalar(strCount, dbPath))); }
public int GetPreOneChatIndex(string userId, string sessionid) { int result = 0; var selectStr = "select max(cast(chatindex as int)) from t_chat_message where sessionid='" + sessionid + "'"; string dbpath = $@"{AntSdkService.SqliteLocalDbPath}{userId}\{userId}.db"; if (File.Exists(dbpath)) { var maxChatIndex = AntSdkSqliteHelper.ExecuteScalar(selectStr, dbpath) + "".Trim(); result = maxChatIndex == "" ? 0 : Convert.ToInt32(maxChatIndex); } return(result); }
/// <summary> /// 查询记录总条数 /// </summary> /// <param name="session_id"></param> /// <param name="userId"></param> /// <param name="companyCode"></param> /// <returns></returns> public int GetMaxCount(string session_id, string userId, string companyCode) { string selectStr = "select count(*) from t_chat_message where sessionid='" + session_id + "'"; string dbPath = $@"{AntSdkService.SqliteLocalDbPath}{userId}\{userId}.db"; if (File.Exists(dbPath)) { return(Convert.ToInt32(AntSdkSqliteHelper.ExecuteScalar(selectStr, dbPath))); } else { return(0); } }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public string Select() { const string sqlStr = "select VERSION from C_Version"; string dbPath = $@"{AntSdkService.SqliteLocalDbPath}{AntSdkService.AntSdkLoginOutput.userId}\{AntSdkService.AntSdkLoginOutput.userId}.db"; var checkStr = AntSdkSqliteHelper.ExecuteScalar(sqlStr, dbPath); if (checkStr == null) { return(string.Empty); } var s = checkStr.ToString(); return(s); }
/// <summary> /// 根据messsageID查询对应的数据是否存在 /// </summary> /// <param name="messageid"></param> /// <returns></returns> public bool MsgExit(string messageid) { string exitStr = "select count(messageid) from t_chat_message A where messageid='" + messageid + "'"; string dbPath = $@"{AntSdkService.SqliteLocalDbPath}{AntSdkService.AntSdkLoginOutput.userId}\{AntSdkService.AntSdkLoginOutput.userId}.db"; if (File.Exists(dbPath)) { var count = Convert.ToInt32(AntSdkSqliteHelper.ExecuteScalar(exitStr, dbPath)); return(count > 0); } else { return(false); } }
/// <summary> /// 查询选中日期返回的记录最后一条之后的记录条数 /// </summary> /// <param name="session_id"></param> /// <param name="end_index"></param> /// <returns></returns> public int GetHistoryCountNext(string session_id, string end_index) { string selectStr = "select count(*) from t_chat_message_group where sessionid='" + session_id + "' and chatindex>'" + end_index + "'"; string dbPath = $@"{AntSdkService.SqliteLocalDbPath}{AntSdkService.AntSdkCurrentUserInfo.userId}\{ AntSdkService.AntSdkCurrentUserInfo.userId}.db"; if (File.Exists(dbPath)) { return(Convert.ToInt32(AntSdkSqliteHelper.ExecuteScalar(selectStr, dbPath))); } else { return(0); } }
/// <summary> /// 查询当前会话为unreadCount不为0情况时候chatindex的值 /// </summary> /// <param name="session_id"></param> /// <param name="companyCode"></param> /// <param name="userId"></param> /// <param name="unreadCount"></param> /// <returns></returns> public string getQueryNotZeroChatIndex(string session_id, string companyCode, string userId, string unreadCount) { string selectStr = "select chatindex from t_chat_message_group where sessionid='" + session_id + "' order by cast (chatindex as int) desc limit " + unreadCount + ",1;"; string dbPath = $@"{AntSdkService.SqliteLocalDbPath}{userId}\{userId}.db"; if (File.Exists(dbPath)) { var result = AntSdkSqliteHelper.ExecuteScalar(selectStr, dbPath); if (result == null || (result + "").Trim() == "") { return("0"); } else { return(result.ToString()); } } else { return("0"); } }
/// <summary> /// 查询当前会话为unreadCount为0情况时候chatindex的值 /// </summary> /// <param name="session_id"></param> /// <param name="companyCode"></param> /// <param name="userId"></param> /// <returns></returns> public string getQueryZeroChatIndex(string session_id, string companyCode, string userId) { string selectStr = "select max(cast(chatindex as int)) as chatindex from t_chat_message_group where sessionid='" + session_id + "'"; string dbPath = $@"{AntSdkService.SqliteLocalDbPath}{userId}\{userId}.db"; if (File.Exists(dbPath)) { var result = AntSdkSqliteHelper.ExecuteScalar(selectStr, dbPath); if (result == null) { return("0"); } else { return(result.ToString()); } } else { return("0"); } }