// // GET: /EnvironmentManagement/CreepingAndRollSpeedDataEdit/ public ActionResult Index(string environmentDate = "", Constants.EnvMode envMode = Constants.EnvMode.ControlLine, string machine = "") { DateTime dt1; var ListName = new List <SelectListItem>(); ListName.Add(new SelectListItem { Text = "12 Inch Mixing Roll Machine", Selected = machine.Equals("Roll_MC_12"), Value = "Roll_MC_12" }); ListName.Add(new SelectListItem { Text = "18 Inch Mixing Roll Machine", Selected = machine.Equals("Roll_MC_18"), Value = "Roll_MC_18" }); ViewBag.ListName = ListName; if (DateTime.TryParseExact(environmentDate, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt1)) { var model = new CreepingAndRollSpeedDataEditViewModel() { EnvironmentDate = dt1.ToString("dd/MM/yyyy"), EnvMode = envMode, Machine = machine }; return(View(model)); } else { var model = new CreepingAndRollSpeedDataEditViewModel() { EnvironmentDate = DateTime.Now.ToString("dd/MM/yyyy"), EnvMode = envMode }; return(View(model)); } }
public ActionResult Search(CreepingAndRollSpeedDataEditViewModel model) { var dt1 = DateTime.ParseExact(model.EnvironmentDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); var dt2 = dt1.AddDays(1); if (dt1 > DateTime.Now) { return(Json(new { Success = false, ErrorCode = -2, //Reset graph and all fields in the form Message = "This date cannot bigger than current date" }, JsonRequestBehavior.AllowGet)); } string left_high = string.Empty; string left_low = string.Empty; string left_range = string.Empty; string left_mean = string.Empty; string left_sigma = string.Empty; string left_yAxis = string.Empty; string left_fld_data = string.Empty; string left_fld_mean = string.Empty; string left_fld_upper = string.Empty; string left_fld_lower = string.Empty; string right_high = string.Empty; string right_low = string.Empty; string right_range = string.Empty; string right_mean = string.Empty; string right_sigma = string.Empty; string right_yAxis = string.Empty; string right_fld_data = string.Empty; string right_fld_mean = string.Empty; string right_fld_upper = string.Empty; string right_fld_lower = string.Empty; string spd_high = string.Empty; string spd_low = string.Empty; string spd_range = string.Empty; string spd_mean = string.Empty; string spd_sigma = string.Empty; string spd_yAxis = string.Empty; string spd_fld_data = string.Empty; string spd_fld_mean = string.Empty; string spd_fld_upper = string.Empty; string spd_fld_lower = string.Empty; //if (ModelState.IsValid) //{ for (int i = 1; i <= 3; i++) { var id = 6; if (model.Machine.Equals("Roll_MC_18") && (i != 3)) { id = i; } else if (model.Machine.Equals("Roll_MC_12") && (i != 3)) { id = i + 2; } else if (model.Machine.Equals("Roll_MC_18") && (i == 3)) { id = 5; } var envMespData = _environmentBaseDomain.GetMespVal(Constants.EnvType.TYPE_RS, id, model.EnvMode); if (!envMespData.Item1) { return(Json(new { Success = false, ErrorCode = -1, //Reset graph and all fields in the form Message = envMespData.Item2 }, JsonRequestBehavior.AllowGet)); } var data = new List <Graphtbl>(); double t_ucl; double t_lcl; double t_usl; double t_lsl; double t_dis_up; double h_dis_up; double t_dis_lo; double h_dis_lo; double h_ucl; double h_lcl; double h_usl; double h_lsl; double t_cal_up; double t_cal_lo; double h_cal_up; double h_cal_lo; double rl_upper; double rl_lower; double rl_max; double rl_min; _environmentBaseDomain.SetValueConfigFromTe80(envMespData.Item3, out t_ucl, out t_lcl, out t_usl, out t_lsl, out t_dis_up, out h_dis_up, out t_dis_lo, out h_dis_lo, out h_ucl, out h_lcl, out h_usl, out h_lsl, out t_cal_up, out t_cal_lo, out h_cal_up, out h_cal_lo); var totalRecord = 0; var calcData = _environmentBaseDomain.CalcData(Constants.EnvType.TYPE_RS, id, null, dt1, Constants.TypeOfTable.CALC_TE83, 1, model.EnvMode, t_ucl, t_lcl, t_usl, t_lsl, t_dis_up, h_dis_up, t_dis_lo, h_dis_lo, h_ucl, h_lcl, h_usl, h_lsl, t_cal_up, t_cal_lo, h_cal_up, h_cal_lo, true, data); if (!calcData) { return(Json(new { Success = false, ErrorCode = 0, //Nothing to do }, JsonRequestBehavior.AllowGet)); } var tcalcMean = _environmentBaseDomain.CalcMean(Constants.TypeOfTable.CALC_BUFFER, Constants.TypeOfTable.CALC_TE83, id, dt1, dt2, t_cal_up, t_cal_lo, h_cal_up, h_cal_lo, data); if (tcalcMean.Item1) { _environmentBaseDomain.UpdateBuffer(Constants.EnvActionBuffer.UPDATE_DB, Constants.TypeOfTable.CALC_TE83, dt1, tcalcMean.Item2, Constants.EnvFieldNo.FLD_MEAN, data); } else { return(Json(new { Success = false, ErrorCode = 0, //Nothing to do Message = tcalcMean.Item2 }, JsonRequestBehavior.AllowGet)); } var tsigma = _environmentBaseDomain.CalcSigma(Constants.TypeOfTable.CALC_BUFFER, Constants.TypeOfTable.CALC_TE83, id, dt1, dt2, t_cal_up, t_cal_lo, h_cal_up, h_cal_lo, data); rl_max = _environmentBaseDomain.GetMax(Constants.EnvType.TYPE_RS, Constants.TypeOfTable.CALC_BUFFER, Constants.TypeOfTable.CALC_TE83, id, dt1, dt2, t_dis_up, h_dis_up, data); rl_min = _environmentBaseDomain.GetMin(Constants.EnvType.TYPE_RS, Constants.TypeOfTable.CALC_BUFFER, Constants.TypeOfTable.CALC_TE83, id, dt1, dt2, t_dis_lo, h_dis_lo, data); if (model.EnvMode == Constants.EnvMode.ControlLine) { rl_upper = t_ucl; rl_lower = t_lcl; } else { rl_upper = t_usl; rl_lower = t_lsl; } _environmentBaseDomain.UpdateBuffer(Constants.EnvActionBuffer.UPDATE_DB, Constants.TypeOfTable.CALC_TE83, dt1, rl_upper, Constants.EnvFieldNo.FLD_UPPER, data); _environmentBaseDomain.UpdateBuffer(Constants.EnvActionBuffer.UPDATE_DB, Constants.TypeOfTable.CALC_TE83, dt1, rl_lower, Constants.EnvFieldNo.FLD_LOWER, data); var flds = _environmentBaseDomain.GrapData(Constants.TypeOfTable.CALC_TE83, data); switch (id) { case 1: case 3: left_high = rl_max.ToString("F"); left_low = rl_min.ToString("F"); left_range = (rl_max - rl_min).ToString("F"); left_mean = tcalcMean.Item2.ToString("F"); left_sigma = tsigma.Item2.ToString("F"); left_yAxis = JsonConvert.SerializeObject(flds.Item5); left_fld_data = JsonConvert.SerializeObject(flds.Item1); left_fld_mean = JsonConvert.SerializeObject(flds.Item2); left_fld_upper = JsonConvert.SerializeObject(flds.Item3); left_fld_lower = JsonConvert.SerializeObject(flds.Item4); break; case 2: case 4: right_high = rl_max.ToString("F"); right_low = rl_min.ToString("F"); right_range = (rl_max - rl_min).ToString("F"); right_mean = tcalcMean.Item2.ToString("F"); right_sigma = tsigma.Item2.ToString("F"); right_yAxis = JsonConvert.SerializeObject(flds.Item5); right_fld_data = JsonConvert.SerializeObject(flds.Item1); right_fld_mean = JsonConvert.SerializeObject(flds.Item2); right_fld_upper = JsonConvert.SerializeObject(flds.Item3); right_fld_lower = JsonConvert.SerializeObject(flds.Item4); break; case 5: case 6: spd_high = rl_max.ToString("F"); spd_low = rl_min.ToString("F"); spd_range = (rl_max - rl_min).ToString("F"); spd_mean = tcalcMean.Item2.ToString("F"); spd_sigma = tsigma.Item2.ToString("F"); spd_yAxis = JsonConvert.SerializeObject(flds.Item5); spd_fld_data = JsonConvert.SerializeObject(flds.Item1); spd_fld_mean = JsonConvert.SerializeObject(flds.Item2); spd_fld_upper = JsonConvert.SerializeObject(flds.Item3); spd_fld_lower = JsonConvert.SerializeObject(flds.Item4); break; } } //} return(Json(new { Success = true, left_high = left_high, left_low = left_low, left_range = left_range, left_mean = left_mean, left_sigma = left_sigma, left_yAxis = left_yAxis, left_fld_data = left_fld_data, left_fld_mean = left_fld_mean, left_fld_lower = left_fld_lower, left_fld_upper = left_fld_upper, right_high = right_high, right_low = right_low, right_range = right_range, right_mean = right_mean, right_sigma = right_sigma, right_yAxis = right_yAxis, right_fld_data = right_fld_data, right_fld_mean = right_fld_mean, right_fld_lower = right_fld_lower, right_fld_upper = right_fld_upper, spd_high = spd_high, spd_low = spd_low, spd_range = spd_range, spd_mean = spd_mean, spd_sigma = spd_sigma, spd_yAxis = spd_yAxis, spd_fld_data = spd_fld_data, spd_fld_mean = spd_fld_mean, spd_fld_lower = spd_fld_lower, spd_fld_upper = spd_fld_upper, }, JsonRequestBehavior.AllowGet)); }