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