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