public static IEnumerable <string> SelectExsitWhiteList(BaseDbHelper dbhelper, IEnumerable <string> pids)
{
List <string> list = new List <string>();
using (var cmd = new SqlCommand(@"SELECT PID
FROM Tuhu_bi.dbo.TireStockWhiteList AS TWL WITH ( NOLOCK )
WHERE TWL.PID IN ( SELECT *
FROM Tuhu_bi.dbo.Split(@pids, ';') )"))
{
cmd.Parameters.AddWithValue("@pids", string.Join(";", pids));
return(dbhelper.ExecuteQuery(cmd, dt =>
{
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
list.Add(row[0].ToString());
}
}
return list;
}));
}
}
