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);
}
