public ActionResult GetHighchartsResultForCTM(WIPIVTestDataViewModel model) { DataTable dtIVData = new DataTable(); string strx = string.Empty, stry = string.Empty, strup = string.Empty, strlow = string.Empty; using (WIPIVTestServiceClient client = new WIPIVTestServiceClient()) { MethodReturnResult <DataSet> rst = client.GetIVDataForCTM(new WIPIVTestGetParameter() { EquipmentCode = AssembleChar(model.EquipmentCode == "Select options" ? "" : model.EquipmentCode), Attr_1 = AssembleChar(model.Attr_1), StartDate = model.StartDate, EndDate = model.EndDate }); if (rst.Code <= 0 && rst.Data != null && rst.Data.Tables.Count > 0) { dtIVData = rst.Data.Tables[0]; } } if (dtIVData != null && dtIVData.Rows.Count > 0) { sl = AssembleSplineForCTM(dtIVData, new WIPIVTestGetParameter() { EquipmentCode = (model.EquipmentCode == "Select options" ? "" : model.EquipmentCode), Attr_1 = (model.Attr_1), StartDate = model.StartDate, EndDate = model.EndDate }); } return(Json(sl, JsonRequestBehavior.AllowGet)); }
public IEnumerable <SelectListItem> GetBaseDataList(string type) { List <SelectListItem> list = new List <SelectListItem>(); MethodReturnResult <DataSet> rst = null; using (WIPIVTestServiceClient client = new WIPIVTestServiceClient()) { rst = client.GetBaseDataForIVTest(type); if (rst.Code > 0 || rst.Data == null) { return(null); } } var query = from t in rst.Data.Tables[0].AsEnumerable() group t by new { t1 = t.Field <string>("DATA") } into m select new { EquipmentCode = m.First().Field <string>("DATA") }; return(from item in query select new SelectListItem() { Text = string.Format("{0}", item.EquipmentCode), Value = item.EquipmentCode }); }
public ActionResult GetHighchartsResultForJZ(WIPIVTestDataViewModel model) { DataTable dtIVData = new DataTable(); string strx = string.Empty, stry = string.Empty, strup = string.Empty, strlow = string.Empty; using (WIPIVTestServiceClient client = new WIPIVTestServiceClient()) { MethodReturnResult <DataTable> rst = client.GetIVDataForJZ(new WIPIVTestGetParameter() { //EquipmentCode = AssembleChar(model.EquipmentCode == "Select options" ? "" : model.EquipmentCode), CalibrationId = model.CalibrationPlateID, LineCode = model.LineCode, Lot_Number = "JZ", StartDate = model.StartDate, EndDate = model.EndDate }); if (rst.Code <= 0 && rst.Data != null && rst.Data.Rows.Count > 0) { dtIVData = rst.Data; } } if (dtIVData != null && dtIVData.Rows.Count > 0) { sl = AssembleSpline(dtIVData, new WIPIVTestGetParameter() { Lot_Number = "JZ", EquipmentCode = (model.EquipmentCode == "Select options" ? "" : model.EquipmentCode), StartDate = model.StartDate, EndDate = model.EndDate, CalibrationId = model.CalibrationPlateID, LineCode = model.LineCode }); } return(Json(sl, JsonRequestBehavior.AllowGet)); }