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