/// <summary>
/// 今天为好友激活的次数
/// </summary>
/// <param name="clientId">int 客户端编号</param>
/// <param name="toClientId">int 激活客户端编号</param>
/// <returns>int 激活次数</returns>
public static int GetCountAtToday(int clientId, int toClientId)
{
string sql = "SELECT COUNT(*) FROM tc_client_live WHERE clientId=@0 AND toClientId=@1 AND createTime>@2";
using (MySqlADO ado = new MySqlADO())
{
return(ado.GetInt(sql, clientId, toClientId, DateTime.Now.ToString("yyyy-MM-dd")));
}
}
/// <summary>
/// 根据三方会话标识获取客户端编号
/// </summary>
/// <param name="session3rd">string 三方会话标识</param>
/// <returns>int 客户端编号</returns>
public static int GetClientIdBySession3rd(string session3rd)
{
string sql = "SELECT clientId FROM tc_client WHERE session3rd=@0";
using (MySqlADO ado = new MySqlADO())
{
return(ado.GetInt(sql, session3rd));
}
}
/// <summary>
/// 根据 OpenId 获取客户端编号
/// </summary>
/// <param name="openId">string 微信标识</param>
/// <returns>int 客户端编号</returns>
public static int GetClientIdByOpenId(string openId)
{
string sql = "SELECT clientId FROM tc_client WHERE openId=@0";
using (MySqlADO ado = new MySqlADO())
{
return(ado.GetInt(sql, openId));
}
}
/// <summary>
/// 判断两个客户端的关系类型
/// </summary>
/// <param name="fromClientId">int 邀请客户端编号</param>
/// <param name="toClientId">int 被邀请客户端编号</param>
/// <returns>int 关系类型</returns>
public static RelateType GetRelateType(int fromClientId, int toClientId)
{
string sql = "SELECT relateType FROM tc_client_relate WHERE fromClientId=@0 AND toClientId=@1";
using (MySqlADO ado = new MySqlADO())
{
return((RelateType)ado.GetInt(sql, fromClientId, toClientId));
}
}
