/*################################## DUP #################################### */ public object GetDupFy(DM_CC_SONEntities ddb) { var myList = ((from l in ddb.DTM_QAQC_DUP where l.HOLEID.StartsWith("RC-18-") select new { ID_OR = l.ID_OR, ID_CK = l.ID_CK, HOLEID = l.HOLEID, Desde = l.SAMPFROM, Hasta = l.SAMPTO, T_MIN = l.T_MIN, SAMPLE_DRILLTYPE = l.SAMPLE_DRILLTYPE, ASSAYNAME = l.ASSAYNAME, ASSAYVALUE_OR = l.ASSAYVALUE_OR, ASSAYVALUE_CK = l.ASSAYVALUE_CK, ASSAYPRIORITY_OR = l.PRIORITY_OR, ASSAYPRIORITY_CK = l.PRIORITY_CK, LABCODE_OR = l.LABJOBNO_OR, LABCODE_CK = l.LABJOBNO_CK, SENDDATE = l.SENDDATE, ANALYSISSUITE = l.ANALYSISSUITE, LABJOBNO_OR = l.LABJOBNO_OR, LABJOBNO_CK = l.LABJOBNO_CK, RETURNDATE = l.RETURNDATE })).ToList().Take(80000); return(myList); }
/*########################## DEFINITION STANDARD #################################### */ public object GetDefinitionSTD(DM_CC_SONEntities ddb) { var myList = ((from t1 in ddb.DTM_STANDARDSDEFINITION select new { STANDARDID = t1.STANDARDID, STANDARDDATE = t1.STANDARDDATE, DESCRIPTION = t1.DESCRIPTION, STANDARDTYPE = t1.STANDARDTYPE })).OrderBy(x => x.STANDARDID).ToList(); return(myList); }
public JsonResult elementosList(string suite) { //System.Diagnostics.Debug.WriteLine(suite.ToList()); using (ddb = new DM_CC_SONEntities()) { IOrderedEnumerable <DTM_SUITEDEFINITION> elementySuite; elementySuite = ddb.DTM_SUITEDEFINITION.ToList().OrderBy(x => x.ANALYSISSUITE); List <String> elementList = new List <string>(); foreach (var item in elementySuite.Where(x => suite.Contains(x.ANALYSISSUITE)).Select(x => x.NAME).Distinct().ToList()) { elementList.Add(item.ToString()); } return(Json(elementList, JsonRequestBehavior.AllowGet)); } }
/*################################## BLK #################################### */ public object GetBlkFy(DM_CC_SONEntities ddb) { var myList = ((from l in ddb.DTM_QAQC_BLK_STD where l.STANDARDID.StartsWith("B") 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); }
/*################################## STANDARD #################################### */ public object GetStdFy(DM_CC_SONEntities ddb) { 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, PRIORITY = t1.ASSAY_PRIORITY, NAME = t1.ASSAYNAME, ASSAYVALUE = t1.ASSAYVALUE, STANDARDVALUE = t2.STANDARDVALUE, STANDARDDEVIATION = t2.STANDARDDEVIATION, LABJOBNO = t1.LABJOBNO, RETURNDATE = t1.RETURNDATE, NORMALIZACION = (t2.STANDARDVALUE - t1.ASSAYVALUE) / t2.STANDARDDEVIATION })).OrderBy(x => x.RETURNDATE).ToList(); return(myList); }
public DataDuplicados() { ddb = new DM_CC_SONEntities(); opdup = new OperacionesMatematicasDUP(); }
/************************************************Graphics/Dup **************************************************/ public DDLData() { ddb = new DM_CC_SONEntities(); }