/// <summary>
/// 获取微信群信息
/// </summary>
/// <param name="title">The title.</param>
/// <returns>weChatGroupModel.</returns>
public weChatGroupModel FindByUserWeChatGroup(string title, int userid)
{
string strSql = @"select id,userid,title,pid from user_wechat_group where title=@title and userid=@userid limit 1;";
var param = new[] {
new SQLiteParameter("@title", title),
new SQLiteParameter("@userid", userid)
};
return(DBHelper.ExecQueryEntity <weChatGroupModel>(strSql, param));
}
/// <summary>
/// 查找用户当前淘宝账号是否存在指定的商品未同步
/// </summary>
/// <param name="goodsId">The goods identifier.</param>
/// <param name="userid">The userid.</param>
/// <param name="taobaoname">The taobaoname.</param>
/// <returns>GoodsModel.</returns>
public GoodsModel FindByUserSyncGoodsInfo(string goodsId, int userid, string taobaoname)
{
string strSql = @"select id,userid,taobaousername,goodsId,url from sync_goods_list where userid=@userid and goodsId=@goodsId and taobaousername=@taobaousername limit 1;";
var param = new[] {
new SQLiteParameter("@goodsId", goodsId),
new SQLiteParameter("@userid", userid),
new SQLiteParameter("@taobaousername", taobaoname)
};
return(DBHelper.ExecQueryEntity <GoodsModel>(strSql, param));
}