public static Customer GetICInfoByWorkID(string sWorkID)
{
using (var context = new KQXTEntities())
{
var recs = from p in context.Customer
where 0 == string.Compare(p.OutID, sWorkID, StringComparison.InvariantCultureIgnoreCase)
select p;
if (recs.Any())
{
return(recs.First());
}
return(null);
}
}
public static Customer GetICInfoBySNR(string ICCardNo)
{
using (var context = new KQXTEntities())
{
var recs = from p in context.Customer
where 0 == string.Compare(p.SCardSNR, ICCardNo, StringComparison.InvariantCultureIgnoreCase)
select p;
if (recs.Any())
{
return(recs.First());
}
return(null);
}
}
