/// <summary>
/// 根据群id，获取群数据
/// </summary>
/// <param name="userid">The userid.</param>
/// <param name="ids">The ids.</param>
/// <returns>weChatGroupModel.</returns>
public List <weChatGroupModel> FindByUserWeChatGroup(int userid, List <int> ids)
{
string strSql = string.Format(@"select id,userid,title,pid from user_wechat_group where userid=@userid and id in ({0});", string.Join(",", ids));
var param = new[] {
new SQLiteParameter("@userid", userid)
};
return(DBHelper.ExecQueryList <weChatGroupModel>(strSql, param));
}
/// <summary>
/// 获取商品列表
/// </summary>
/// <param name="userid">The userid.</param>
/// <param name="taobaoname">The taobaoname.</param>
/// <returns>List<GoodsModel>.</returns>
public List <SyncGoodsList> FindByUserSyncGoodsList(int userid, string taobaoname)
{
string strSql = @"select id,userid,taobaousername,goodsId,url from sync_goods_list where userid=@userid and taobaousername=@taobaousername";
var param = new[] {
new SQLiteParameter("@userid", userid),
new SQLiteParameter("@taobaousername", taobaoname)
};
return(DBHelper.ExecQueryList <SyncGoodsList>(strSql, param));
}