Esempio n. 1
0
        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();
            }
        }
Esempio n. 2
0
        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();
            }
        }