public object GetStdFy(DM_CC_SONEntities ddb) { try { var myList = ((from t1 in ddb.DTM_QAQC_BLK_STD from t2 in ddb.DTM_STANDARDSASSAY.Where(x => t1.STANDARDID == x.STANDARDID && t1.ASSAYVALUE == x.STANDARDVALUE) select new { CHECKID = t1.CHECKID, STANDARDID = t1.STANDARDID, ASSAY_PRIORITY = t1.ASSAY_PRIORITY, ASSAYNAME = t1.ASSAYNAME, ASSAYVALUE = t1.ASSAYVALUE, STANDARDVALUE = t2.STANDARDVALUE, STANDARDDEVIATION = t2.STANDARDDEVIATION, NORMALIZACION = (t2.STANDARDVALUE - t1.ASSAYVALUE) / t2.STANDARDDEVIATION, LABJOBNO = t1.LABJOBNO, RETURNDATE = t1.RETURNDATE })).OrderBy(x => x.RETURNDATE).ToList(); return(myList); } catch (Exception) { throw new NotImplementedException(); } }
public object GetBlkFy(DM_CC_SONEntities ddb) { try { var myList = ((from l in ddb.DTM_QAQC_BLK_STD select new { CHECKID = l.CHECKID, STANDARDID = l.STANDARDID, PRIORITY = l.ASSAY_PRIORITY, NAME = l.ASSAYNAME, ASSAYVALUE = l.ASSAYVALUE, STANDARDVALUE = l.ASSAYVALUE, STANDARDDEVIATION = l.ASSAYVALUE, LABJOBNO = l.LABJOBNO, LOADDATE = l.SENDDATE })).OrderBy(x => x.LOADDATE).ToList(); return(myList); } catch (Exception) { throw new NotImplementedException(); } }