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