internal static bool AddByWorkID(string sWorkID) { int nWorkID = int.Parse(sWorkID); if (0 == nWorkID) { return(false); } if (null != GetByWorkID(sWorkID)) { return(true); } using (var context = new FlexDevCommonEntities()) { var people = from p in context.EmployeeInfo where p.WD_EmpNo.HasValue && p.WD_EmpNo.Value == nWorkID select p; if (!people.Any()) { return(false); } var item = people.First(); if (!item.WD_EmpNo.HasValue) { return(false); } var serr = string.Empty; return(InsertLector(item.WD_EmpNo.Value.ToString(), item.EName, item.CName, out serr)); } }
public static EmployeeInfo GetEmployeeInfoByWorkID(string sWorkID) { int nWorkID = int.Parse(sWorkID); using (var context = new FlexDevCommonEntities()) { var people = from p in context.EmployeeInfo where p.WD_EmpNo.HasValue && p.WD_EmpNo.Value == nWorkID select p; if (people.Any()) { return(people.First()); } return(null); } }