public bool Update(Gage Gage) { int API = 3; string token = HttpContext.Current.Request.Headers.Get("token"); if (Models.UniversalModels.User.IsValidToken(token)) { User CurrentUser = Models.UniversalModels.User.GetUserByToken(token); if (Models.UniversalModels.User.IsContainsCurrentAPIPermission(CurrentUser.UserID, API)) { Log log = new Log(API, CurrentUser); log.Add(token + "|" + nameof(Gage) + ":" + JsonConvert.SerializeObject(Gage)); try { bool s = new GageServiceImpl().Update(Gage); return(s); } catch (Exception ex) { log.Add("Exception:" + ex.Message + "|" + ex.StackTrace); return(false); } } } throw new HttpResponseException(HttpStatusCode.Forbidden); }//3
public ActionResult ChangeState(Gage model, int id = 0) { Gage gage = dataManager.Gages.GetGageById(id); gage.State = model.State; dataManager.Gages.SaveGage(gage); return(RedirectToAction("Index", "Metrology")); }
void Nouveau_Client_Pret() { client = new Client(); prets = new Prets(); gage = new Gage(); code_cli = client.Nouveau(); code_pret = prets.Nouveau(); code_gage = gage.Nouveau(); }
public bool AddAdjustSlip(GageAdjustSlip adjustSlip, User CurrentUser) { using (SqlConnection conn = new SqlConnection(Common.SQLHelper.Asset_strConn)) { conn.Open(); SqlTransaction sqlTransaction = conn.BeginTransaction(); try { Asset gage = Asset.GetBy(adjustSlip.AssetID); if (gage == null) { throw new Exception("资产不存在"); } if (!"在库领用".Contains(gage.Status.Substring(gage.Status.Length - 2))) { throw new Exception("资产未处于在库或领用状态"); } Gage gageDetail = Gage.GetBy(gage.AssetID).First(); if (gageDetail.StandardAdjustType == "免校") { throw new Exception("无法为免校的资产做校准"); } gageDetail.NextAdjustDate = null; adjustSlip.AssetName = gage.AssetName; adjustSlip.AdjustDate = DateTime.Now; adjustSlip.TransactorName = CurrentUser.Name; gage.Status = gage.AddStatus("在校"); gage.CurrentWhereSpot = adjustSlip.Spot; gage.CurrentWhereOrganization = adjustSlip.Organization; gageDetail.sqlTransaction = gage.sqlTransaction = adjustSlip.sqlTransaction = sqlTransaction; adjustSlip.Add(); gage.Update(); gageDetail.Update(); sqlTransaction.Commit(); return(true); } catch { sqlTransaction.Rollback(); throw; } } }
public bool Update(Gage paras) { using (SqlConnection conn = new SqlConnection(Common.SQLHelper.Asset_strConn)) { conn.Open(); SqlTransaction sqlTransaction = conn.BeginTransaction(); try { Asset gage = Asset.GetBy(paras.AssetID); if (gage == null) { throw new Exception("资产不存在"); } paras.CopyTo(gage, false); Gage gageDetail = Gage.GetBy(gage.AssetID).First(); ////填充前的检测 //if(!gageDetail.Status.Contains(paras.StandardAdjustType)) // throw new Exception(""); //使用新数据填充 paras.CopyTo(gageDetail, false); if (gageDetail.StandardAdjustType == "免校") { gageDetail.AdjustPeriod = null; gageDetail.NextAdjustDate = null; gageDetail.AdjustNoticeDays = null; gageDetail.DefaultAdjustRequirement = null; } gageDetail.sqlTransaction = gage.sqlTransaction = sqlTransaction; gage.Update(); gageDetail.Update(); sqlTransaction.Commit(); return(true); } catch { sqlTransaction.Rollback(); throw; } } }
public bool Add(Gage gage) { using (SqlConnection conn = new SqlConnection(Common.SQLHelper.Asset_strConn)) { conn.Open(); SqlTransaction sqlTransaction = conn.BeginTransaction(); try { if (Asset.GetBy(gage.AssetID) != null) { throw new Exception("资产编号已存在"); } Asset asset = new Asset(); asset.AssetID = gage.AssetID.Trim(); asset.AssetName = gage.AssetName; asset.AssetCategory = "Gage"; asset.CurrentWhereOrganization = gage.CurrentWhereOrganization; asset.Status = "在库"; asset.Remark = gage.Remark; asset.StorageDate = DateTime.Now; asset.CurrentWhereSpot = gage.CurrentWhereSpot; asset.Department = gage.Department; gage.FK_AssetID = asset.AssetID; //if (gageDetail.StandardAdjustType == "外校" || gageDetail.StandardAdjustType == "内校") // gageDetail.NextAdjustDate = ((DateTime)gageDetail.AdjustBaseDate).AddDays(Convert.ToDouble(gageDetail.AdjustPeriod)); asset.sqlTransaction = gage.sqlTransaction = sqlTransaction; asset.Add(); gage.Add(); sqlTransaction.Commit(); return(true); } catch { sqlTransaction.Rollback(); throw; } } }
public IEnumerable <Gage> SelectBy(GageFilter Filter) { List <Gage> result1 = Gage.CombineSelectByStatuses(Filter.Statuses); List <Gage> result2 = Gage.RangeSelectByNextAdjustDate(Filter.NextAdjustDate); List <Gage> result3 = Gage.CombineSelectByStandardAdjustType(Filter.StandardAdjustType); if (result1 == null || result2 == null || result3 == null) { return(null); } result1 = result1.Where(a => result2.Exists(t => a.AssetID == t.AssetID)).ToList(); result1 = result1.Where(a => result3.Exists(t => a.AssetID == t.AssetID)).ToList(); IEnumerable <Gage> final_result = result1; return(final_result.Count() == 0 ? null : final_result); }
void Save_Gage(bool btn) { try { gage = new Gage(); for (int i = 0; i < dataGridView2.Rows.Count; i++) { gage.Id = Convert.ToInt32(dataGridView2[0, i].Value.ToString()); gage.Designation = dataGridView2[1, i].Value.ToString(); gage.Valeur = float.Parse(dataGridView2[2, i].Value.ToString()); gage.Refpret = code_pret; gage.Nombre = Convert.ToInt32(dataGridView2[3, i].Value.ToString()); gage.Save(gage); } } catch (Exception ex) { MessageBox.Show("Error " + ex.Message, "Error...", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ActionResult Protocol(int id = 0) { Result result = _dataManager.Results.GetResultById(id); if (result == null) { return(View("Error")); } Sample sample = _dataManager.Samples.GetSampleByNumber(result.SampleId); TechnicalRegulation techniqueOfTests = _dataManager.TechnicalRegulations.GetTechnicalRegulationById(result.TechniqueOfTestsId); Indicator indicator = _dataManager.Indicators.GetIndicatorById(result.IndicatorId); AdmissibleLevel admissibleLevel = _dataManager.AdmissibleLevels.GetAdmissibleLevelById(result.AdmissibleLevelId); TechnicalRegulation technicalRegulation = _dataManager.TechnicalRegulations.GetTechnicalRegulationById(admissibleLevel.TechnicalRegulationId); Gage gage = _dataManager.Gages.GetGageById(result.GageId); Indicator temperatureIndicator = _dataManager.Indicators.GetIndicators().FirstOrDefault(x => x.Name == "температура"); Indicator humidityIndicator = _dataManager.Indicators.GetIndicators().FirstOrDefault(x => x.Name == "влажность"); Indicator pressureIndicator = _dataManager.Indicators.GetIndicators().FirstOrDefault(x => x.Name == "атмосферное давление"); Indicator radiationIndicator = _dataManager.Indicators.GetIndicators().FirstOrDefault(x => x.Name == "мощность экспозиционной дозы"); var model = new ProtocolViewModel { SampleId = sample.RegistrationNumber, SampleName = sample.Name, ResultDate = result.ResultDate.ToShortDateString(), Applicant = sample.Applicant, Temperature = _dataManager.Conditions.GetConditions().FirstOrDefault( x => x.ResultId == result.Id && x.IndicatorId == temperatureIndicator.Id). ConditionValue, Humidity = _dataManager.Conditions.GetConditions().FirstOrDefault( x => x.ResultId == result.Id && x.IndicatorId == humidityIndicator.Id). ConditionValue, Pressure = _dataManager.Conditions.GetConditions().FirstOrDefault( x => x.ResultId == result.Id && x.IndicatorId == pressureIndicator.Id). ConditionValue, Radiation = _dataManager.Conditions.GetConditions().FirstOrDefault( x => x.ResultId == result.Id && x.IndicatorId == radiationIndicator.Id). ConditionValue, TechniqueOfTestsDesignation = techniqueOfTests.Designation, TechniqueOfTestsName = techniqueOfTests.Name, ResultValue = result.ResultValue, LevelValue = admissibleLevel.LevelValue, Units = indicator.Units, TechnicalRegulationDesignation = technicalRegulation.Designation, TechnicalRegulationName = technicalRegulation.Name, GageName = gage.Name, SerialNumber = gage.SerialNumber, IndicatorName = indicator.Name }; SelectedSample selectedSample = _dataManager.SelectedSamples.GetSelectedSampleByRegNumb(sample.RegistrationNumber); if (selectedSample != null) { TechnicalRegulation samplingTechnique = _dataManager.TechnicalRegulations.GetTechnicalRegulationById(selectedSample.SamplingTechnique); model.Manufacturer = selectedSample.Manufacturer; model.SamplingDate = selectedSample.SamplingDate.ToShortDateString(); model.SamplingTechniqueDesignation = samplingTechnique.Designation; model.SamplingTechniqueName = samplingTechnique.Name; } else { model.Manufacturer = "-"; model.SamplingDate = "-"; model.SamplingTechniqueDesignation = "-"; model.SamplingTechniqueName = ""; } return(View(model)); }
public IEnumerable <Gage> GetBy(string AssetID) { return(Gage.GetBy(AssetID)); }
public double GetGageMaxValue(Gage gage, double[] data) { return(waveChart.GetGageData(gage.gageTpye, data).Max()); }
public void DrawGage(Gage gage) { waveChart.SetGage(gage.gageTpye, new Point(gage.InitIndexX, gage.InitIndexY), gage.IndexLength); }