public Create3(Guid JZID) { var db = new EiSDbContext(); var dbTrasen = new TrasenLib.TrasenDbContext("TrasenConnection"); var MZYS_JZJL = dbTrasen.MZYS_JZJL.Where(c => c.JZID == JZID).FirstOrDefault(); var YY_KDJB = dbTrasen.YY_KDJB.Where(c => c.BRXXID == MZYS_JZJL.BRXXID).FirstOrDefault(); this.JZID = JZID; this.ListObserveRoomInfos = db.ObserveRoomInfos.Where(c => c.OutPatientNumber == YY_KDJB.KH && c.OutDepartmentTime.HasValue && c.OutDepartmentTime <= DateTime.Now).OrderByDescending(c => c.OutDepartmentTime).Take(1).ToList().Select(c => new ItemObserveRoomInfo(c, JZID)).ToList(); }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { var result = new List <ValidationResult>(); var dbTrasen = new TrasenLib.TrasenDbContext("TrasenConnection"); //1.检测卡号存在。 if (!dbTrasen.YY_KDJB.Any(c => c.KH == this.OutPatientNumber)) { result.Add(new ValidationResult("卡号不存在", new string[] { "OutPatientNumber" })); } return(result); }
public static string FromEmployeeNumberToName(string employeeNumber) { if (employeeNumber == null) { return(employeeNumber); } var tempEmployeeNumber = employeeNumber.Trim(); var i = new int(); if (tempEmployeeNumber.Length == 4 && int.TryParse(tempEmployeeNumber, out i)) { var dbTrasen = new TrasenLib.TrasenDbContext("TrasenConnection"); var itemJC_EMPLOYEE_PROPERTY = dbTrasen.JC_EMPLOYEE_PROPERTY.Where(c => c.D_CODE == tempEmployeeNumber).FirstOrDefault(); if (itemJC_EMPLOYEE_PROPERTY != null) { return(itemJC_EMPLOYEE_PROPERTY.NAME); } } return(employeeNumber); }