public BindingList <CCustom_method_solution> GetMethodsByMrcPattern(int idelement, short idmr_detail, int?idreactive_medium, int?idreactive_modif, int?idgroup_solution) { List <CTemplate_method_aa> lstTemplate_method_aa = new CTemplate_method_aaFactory() .GetAll() .Where(c => c.Mrorpattern == idmr_detail && c.Medium == idreactive_medium && c.Modif == idreactive_modif).ToList(); List <CTemplate_method> lstTemplate_method = new CTemplate_methodFactory() .GetAll() .Where(c => c.Idelement == idelement).ToList(); var query_group_methods = new CGroup_solution_methodsFactory().GetAll().Where(c => c.Idgroup_solution == idgroup_solution).ToList(); BindingList <CCustom_method_solution> query = new BindingList <CCustom_method_solution>( (from m in lstTemplate_method join n in lstTemplate_method_aa on m.Idtemplate_method equals n.Idtemplate_method join p in query_group_methods on n.Idtemplate_method equals p.Idtemplate_method into ps from q in ps.DefaultIfEmpty() select new CCustom_method_solution { Sel = q == null ? false : Convert.ToBoolean(q.Status), Idtemplate_method = n.Idtemplate_method, Cod_template_method = m.Cod_template_method, Title = m.Title } ).ToList()); return(query); }
public BindingList <CCustom_method_solution> GetMethodsBySolution(int idelement, int idsolution, int?idreactive_medium, int?idreactive_modif, int?idgroup_solution) { List <CTemplate_method_aa> lstTemplate_method_aa = new CTemplate_method_aaFactory() .GetAll() .Where(c => /*c.Sol_intermedia == idsolution &&*/ c.Medium == idreactive_medium && c.Modif == idreactive_modif).ToList(); List <CTemplate_method> lstTemplate_method = new CTemplate_methodFactory() .GetAll() .Where(c => c.Idelement == idelement).ToList(); var query_group_methods = new CGroup_solution_methodsFactory().GetAll().Where(c => c.Idgroup_solution == idgroup_solution).ToList(); BindingList <CCustom_method_solution> query = new BindingList <CCustom_method_solution>( (from m in lstTemplate_method join n in lstTemplate_method_aa on m.Idtemplate_method equals n.Idtemplate_method join p in query_group_methods on n.Idtemplate_method equals p.Idtemplate_method into ps from q in ps.DefaultIfEmpty() select new CCustom_method_solution { Sel = q == null ? false : true, Idtemplate_method = n.Idtemplate_method, Cod_template_method = m.Cod_template_method, Title = m.Title } ).ToList()); return(query); }
public List <CAbsorcionAtomica> GetMethodsAbsorcionAtomica(int idtemplate_method) { List <CTemplate_method> lstTemplate_method = new CTemplate_methodFactory().GetAll().Where(c => c.Idtemplate_method == idtemplate_method).ToList(); List <CTemplate_method_aa> lstTemplate_method_aa = new CTemplate_method_aaFactory().GetAll().Where(c => c.Idtemplate_method == idtemplate_method).ToList(); return((from t1 in lstTemplate_method join t2 in lstTemplate_method_aa on t1.Idtemplate_method equals t2.Idtemplate_method where t1.Idtemplate_method == t2.Idtemplate_method select new CAbsorcionAtomica { Idtemplate_method = t1.Idtemplate_method, Num_version = t1.Num_version, Cod_template_method = t1.Cod_template_method, Name_repetition = CaseRepetition(t1.Cod_repetition), Title = t1.Title, Abbreviation = t1.Abbreviation, Name_type_analysis = CaseTypeAnalysis(t1.Type_analisys), Name_type_sample = CaseTypeSample(t1.Cod_type_sample), Name_digestion = CaseDigestion(t1.Cod_digestion_method), Name_unit_result = CaseUnitMeasure(t2.Idunit_result), Weight = t2.Weight, Volumen = t2.Volumen, Reading_min = t2.Reading_min, Reading_max = t2.Reading_max, Dilution2 = t2.Dilution2, Dilution3 = t2.Dilution3, Reason_rep = t2.Reason_rep, Law_limit_bottom = t2.Law_limit_bottom, Law_limit_top = t2.Law_limit_top, Name_unit_calib = CaseUnitMeasure(t2.Idunit_calib) } ).ToList <CAbsorcionAtomica>()); }
public bool Is_law_right() { CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); CTemplate_method_aa oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); // --- recorring law columns for (int i = 0; i < ListSamples.Count; i++) { CBatch_detail_aa_twofold row = ListSamples[i]; decimal law1 = Convert.ToDecimal(row.Law1); decimal law2 = Convert.ToDecimal(row.Law2); if (law1 <= oTemplate_method_aa.Law_limit_bottom || law1 >= oTemplate_method_aa.Law_limit_top) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la ley esta fuera de los límites permitidos."); return(false); } if (law2 <= oTemplate_method_aa.Law_limit_bottom || law1 >= oTemplate_method_aa.Law_limit_top) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la ley esta fuera de los límites permitidos."); return(false); } } return(true); }
public List <CTemplate_method> GetMethodsCalib(int idelement, short idmr_detail) { var lstTemplate_method = new CTemplate_methodFactory() .GetAll() .Where(c => c.Idelement == idelement).ToList(); var lsTemplate_method_aa = new CTemplate_method_aaFactory() .GetAll() .Where(c => c.Mrorpattern == idmr_detail).ToList(); var lst = (from t1 in lstTemplate_method join t2 in lsTemplate_method_aa on t1.Idtemplate_method equals t2.Idtemplate_method select t1 ).ToList <CTemplate_method>(); foreach (var item in lst) { item.Cod_template_method = item.Cod_template_method + " - " + item.Title; } return(lst); }
private int GetNumFreePlacesInBatch(long idbatch, int idtemplate_method) { List <CBatch_detail_aa_twofold> lst = new CBatch_detail_aa_twofoldFactory().GetAll().Where(c => c.Idbatch == idbatch).ToList(); Methods oMethods = new Methods(); CTemplate_method_aa template_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); return(Convert.ToInt32(template_method_aa.Limit_samples) - lst.Count); }
public void SaveControlSample(int idtemplate_method_aa, long idbatch) { CTemplate_method template_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(idtemplate_method_aa)); CCorrelative correlative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(template_method.Cod_type_sample)); CTemplate_method_aa templaate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method_aa)); control_sample.Idtemplate_method = templaate_method_aa.Idtemplate_method; //control_sample.Idrecep_sample = idrecep_sample; //control_sample.Idrecep_sample_detail = idrecep_sample_detail; //control_sample.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; control_sample.Weight1 = templaate_method_aa.Weight; control_sample.Weight2 = templaate_method_aa.Weight; control_sample.Volumen1 = templaate_method_aa.Volumen; control_sample.Volumen2 = templaate_method_aa.Volumen; control_sample.Dilu2 = templaate_method_aa.Dilution2; control_sample.Dilu3 = templaate_method_aa.Dilution3; control_sample.Flag_dilu2 = false; control_sample.Flag_dilu3 = false; control_sample.Flag_mri = 1; control_sample.Fum = methods.GetFactorConvertionUM(templaate_method_aa.Idtemplate_method); control_sample.Qaqc_blk = 3; control_sample.Qaqc_par = 3; control_sample.Qaqc_mr = 3; control_sample.Qaqc_error = 0; control_sample.Qaqc_approve = false; control_sample.Qaqc_review = false; control_sample.Qaqc_has_retest = 0; control_sample.Qaqc_tmp_retest = 0; control_sample.Qaqc_tmp_retest_idmethod = 0; control_sample.Qaqc_approve_text = ""; control_sample.Qaqc_review_text = ""; // --- insert mri CBatch oBatch = new CBatchFactory().GetByPrimaryKey(new CBatchKeys(idbatch)); int num_free_places = GetNumFreePlacesInBatch(idbatch, templaate_method_aa.Idtemplate_method); if (num_free_places >= 1) { if (!Convert.ToBoolean(oBatch.Has_sample_control)) // batch no tiene mri { long index_mri = GetIndexMriPosition(idbatch); if (index_mri > 0) { // --- insert mri control_sample.Cod_interno = index_mri; control_sample.Idbatch = idbatch; control_sample.Cod_sample = Comun.FormatCorrelativeCode(correlative.Prefix + correlative.Cod_serie, index_mri, Convert.ToInt32(correlative.Num_digits)); if (faBatch_detail_aa_twofold.Insert(control_sample)) { oBatch.Has_sample_control = true; new CBatchFactory().Update(oBatch); } } } } }
private void Retrieve_Lst_Samples() { CRecep_sample_detail_elemFactory faRecep_sample_detail_elem = new CRecep_sample_detail_elemFactory(); lstSamples = faRecep_sample_detail_elem.GetAll(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); lstMethods = faTemplate_method_aa.GetAll(); }
Comun.MethodSaveProperty GetResultTestHeader() { // --- registro anterior if (IDTemplate_Method <= 0) { return(Comun.MethodSaveProperty.NewMethod); } else { CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory(); CTemplate_method oTemplate_method = new CTemplate_method(); oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(IDTemplate_Method)); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(IDTemplate_Method)); // --- change inside head, require new method if (oTemplate_method.Idelement != Convert.ToInt16(cbElement.EditValue)) { return(Comun.MethodSaveProperty.InspectionNewMethod); } if (oTemplate_method.Cod_type_sample != cbTypeSample.EditValue.ToString()) { return(Comun.MethodSaveProperty.InspectionNewMethod); } if (oTemplate_method.Type_analisys != Convert.ToChar(cbTypeAnalysis.EditValue)) { return(Comun.MethodSaveProperty.InspectionNewMethod); } if (oTemplate_method.Cod_template_method != gluCod_method.Text) { return(Comun.MethodSaveProperty.InspectionNewMethod); } //if (oTemplate_method.Abbreviation != tbAbreviation.Text) // return Comun.MethodSaveProperty.InspectionNewMethod; //if (oTemplate_method.Title != tbTitle.Text) // return Comun.MethodSaveProperty.InspectionNewMethod; //if (oTemplate_method.Recognized != ckRecognized.Checked) // return Comun.MethodSaveProperty.InspectionNewMethod; if (oTemplate_method.Cod_digestion_method != cbDigestion.EditValue.ToString()) { return(Comun.MethodSaveProperty.InspectionNewMethod); } //if (Convert.ToDecimal(oTemplate_method.Cost_method) != tbCost_Method.Value) // return Comun.MethodSaveProperty.InspectionNewMethod; if (Convert.ToInt16(oTemplate_method.Cod_repetition) != Convert.ToInt16(cbRepetition.EditValue)) { return(Comun.MethodSaveProperty.InspectionNewMethod); } return(Comun.MethodSaveProperty.Nothing); } }
void PlotChart() { lstChartPoint_serie1.Clear(); lstChartPoint_serie2.Clear(); // --- recuperar datos del método CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); tbValidity_calib.Value = Convert.ToInt32(oTemplate_method_aa.Validity_calib); tbRexp2.Value = Convert.ToDecimal(oTemplate_method_aa.Rexp2); cbMedium.EditValue = oTemplate_method_aa.Medium; tbMediumConc.Value = Convert.ToDecimal(oTemplate_method_aa.Medium_conc); cbModif.EditValue = oTemplate_method_aa.Modif; tbModifConc.Value = Convert.ToDecimal(oTemplate_method_aa.Modif_conc); // --- recuperar metodo actual if (gvCalibStd.GetFocusedRowCellValue(gcCal_Idtemplate_method) != null) { CTemplate_method_aa currentTemplate_method_aa = new CTemplate_method_aaFactory() .GetByPrimaryKey(new CTemplate_method_aaKeys( Convert.ToInt32(gvCalibStd.GetFocusedRowCellValue(gcCal_Idtemplate_method)))); // --- dibujar curva if (rgSelectGraphic.SelectedIndex == 0 || rgSelectGraphic.SelectedIndex == 2) { lstChartPoint_serie1 = (from t in LstAllCalibs where t.Idtemplate_method == currentTemplate_method_aa.Idtemplate_method select new ChartPoint { X = Convert.ToDecimal(t.Concentration), Y = t.Absorbance_previus }).ToList(); } // --- dibujar curva if (rgSelectGraphic.SelectedIndex == 1 || rgSelectGraphic.SelectedIndex == 2) { lstChartPoint_serie2 = (from t in LstAllCalibs where t.Idtemplate_method == currentTemplate_method_aa.Idtemplate_method select new ChartPoint { X = Convert.ToDecimal(t.Concentration), Y = t.Absorbance }).ToList(); } InitXYDiagram(); } }
private void ckChangeMethod_CheckedChanged(object sender, EventArgs e) { paChooseMethod.Visible = ckChangeMethod.Checked; CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); object obj = gvMethods.GetFocusedRowCellValue(gcMet_Idtemplate_method); if (obj != null) { if (gvMethods.RowCount > 0) ShowColumnsByTypeAnalysis(Comun.GetTypeAnalysis(Convert.ToChar(gvMethods.GetFocusedRowCellValue(gcMet_Type_analisys)))); } }
void ShowColumnsAA() { // --- get columns CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); Methods oMethods = new Methods(); gcMethodsDetail.DataSource = oMethods.GetMethodsAbsorcionAtomica(Convert.ToInt32(gvMethods.GetFocusedRowCellValue(gcMet_Idtemplate_method))); // --- set caption columns cvMethodsDetail.Columns["Idtemplate_method"].Caption = ""; cvMethodsDetail.Columns["Num_version"].Caption = "Versión"; cvMethodsDetail.Columns["Cod_template_method"].Caption = "Código"; cvMethodsDetail.Columns["Name_repetition"].Caption = "N°Repeticiones"; cvMethodsDetail.Columns["Title"].Caption = "Título"; cvMethodsDetail.Columns["Abbreviation"].Caption = "Abreviación"; cvMethodsDetail.Columns["Name_type_analysis"].Caption = "Tipo de análisis"; cvMethodsDetail.Columns["Name_type_sample"].Caption = "Tipo de muestra"; cvMethodsDetail.Columns["Name_digestion"].Caption = "Tipo de digestión"; cvMethodsDetail.Columns["Name_unit_result"].Caption = "Unidad"; cvMethodsDetail.Columns["Weight"].Caption = "Peso"; cvMethodsDetail.Columns["Volumen"].Caption = "Volumen"; cvMethodsDetail.Columns["Reading_min"].Caption = "Lectura Mínima"; cvMethodsDetail.Columns["Reading_max"].Caption = "Lectura Máxima"; cvMethodsDetail.Columns["Dilution2"].Caption = "Dilución2"; cvMethodsDetail.Columns["Dilution3"].Caption = "Dilución3"; cvMethodsDetail.Columns["Reason_rep"].Caption = "Razón Repetibilidad"; cvMethodsDetail.Columns["Law_limit_bottom"].Caption = "Ley Mínima"; cvMethodsDetail.Columns["Law_limit_top"].Caption = "Ley Máxima"; cvMethodsDetail.Columns["Name_unit_calib"].Caption = "Unidad de calibración"; // --- set visible columns cvMethodsDetail.Columns["Idtemplate_method"].Visible = false; cvMethodsDetail.Columns["Num_version"].Visible = true; cvMethodsDetail.Columns["Cod_template_method"].Visible = true; cvMethodsDetail.Columns["Name_repetition"].Visible = true; cvMethodsDetail.Columns["Title"].Visible = true; cvMethodsDetail.Columns["Abbreviation"].Visible = true; cvMethodsDetail.Columns["Name_type_analysis"].Visible = true; cvMethodsDetail.Columns["Name_type_sample"].Visible = true; cvMethodsDetail.Columns["Name_digestion"].Visible = true; cvMethodsDetail.Columns["Name_unit_result"].Visible = true; cvMethodsDetail.Columns["Weight"].Visible = true; cvMethodsDetail.Columns["Volumen"].Visible = true; cvMethodsDetail.Columns["Reading_min"].Visible = true; cvMethodsDetail.Columns["Reading_max"].Visible = true; cvMethodsDetail.Columns["Dilution2"].Visible = true; cvMethodsDetail.Columns["Dilution3"].Visible = true; cvMethodsDetail.Columns["Reason_rep"].Visible = true; cvMethodsDetail.Columns["Law_limit_bottom"].Visible = true; cvMethodsDetail.Columns["Law_limit_top"].Visible = true; cvMethodsDetail.Columns["Name_unit_calib"].Visible = true; }
public PriceMethod(CPrice_version_detail version, BindingList <PriceMethodHistory> history) { Idprice_version = version.Idprice_version; Idprice_version_detail = version.Idprice_version_detail; Num_item = version.Num_item; Idtemplate_method = version.Idtemplate_method; CTemplate_method oTemplate_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(Convert.ToInt32(version.Idtemplate_method))); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(version.Idtemplate_method))); Den_method = oTemplate_method.Cod_template_method + " - " + oTemplate_method.Title; Amount_item = version.Amount_item; Rank = oTemplate_method_aa.Reading_min.ToString() + " - " + oTemplate_method_aa.Reading_max.ToString(); Unit_price = version.Unit_price; Sale_price = version.Sale_price; History = history; }
Comun.MethodSaveProperty GetResultTestHeader() { // --- registro anterior if (IDTemplate_Method <= 0) { return Comun.MethodSaveProperty.NewMethod; } else { CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory(); CTemplate_method oTemplate_method = new CTemplate_method(); oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(IDTemplate_Method)); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(IDTemplate_Method)); // --- change inside head, require new method if (oTemplate_method.Idelement != Convert.ToInt16(cbElement.EditValue)) return Comun.MethodSaveProperty.InspectionNewMethod; if (oTemplate_method.Cod_type_sample != cbTypeSample.EditValue.ToString()) return Comun.MethodSaveProperty.InspectionNewMethod; if (oTemplate_method.Type_analisys != Convert.ToChar(cbTypeAnalysis.EditValue)) return Comun.MethodSaveProperty.InspectionNewMethod; if (oTemplate_method.Cod_template_method != gluCod_method.Text) return Comun.MethodSaveProperty.InspectionNewMethod; //if (oTemplate_method.Abbreviation != tbAbreviation.Text) // return Comun.MethodSaveProperty.InspectionNewMethod; //if (oTemplate_method.Title != tbTitle.Text) // return Comun.MethodSaveProperty.InspectionNewMethod; //if (oTemplate_method.Recognized != ckRecognized.Checked) // return Comun.MethodSaveProperty.InspectionNewMethod; if (oTemplate_method.Cod_digestion_method != cbDigestion.EditValue.ToString()) return Comun.MethodSaveProperty.InspectionNewMethod; //if (Convert.ToDecimal(oTemplate_method.Cost_method) != tbCost_Method.Value) // return Comun.MethodSaveProperty.InspectionNewMethod; if (Convert.ToInt16(oTemplate_method.Cod_repetition) != Convert.ToInt16(cbRepetition.EditValue)) return Comun.MethodSaveProperty.InspectionNewMethod; return Comun.MethodSaveProperty.Nothing; } }
decimal?GetMedium(int typeSol) { CTemplate_method_aa template_method_aa = new CTemplate_method_aaFactory() .GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(group_solution.Idtemplate_method))); if (typeSol == 1) { return(template_method_aa.Std_sol1_medium); } if (typeSol == 2) { return(template_method_aa.Std_sol2_medium); } if (typeSol == 3) { return(template_method_aa.Std_stdverif_medium); } return(null); }
public void InitConfiguration() { Mri_measured = 0; Lrb_measured = 0; Flag_correct_mri = null; Flag_correct_lrb = null; CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); Max_value_blk = Convert.ToDecimal(oTemplate_method_aa.Blk_max); Factor_repetibility = Convert.ToDecimal(oTemplate_method_aa.Reason_rep); Factor_reproducibility = Convert.ToDecimal(oTemplate_method_aa.Reproducibility); CMr_detailFactory faMr_detail = new CMr_detailFactory(); CMr_detail oMr_detail = faMr_detail.GetByPrimaryKey(new CMr_detailKeys(Convert.ToInt16(oTemplate_method_aa.Idmr_detail))); Law_fixed = Convert.ToDecimal(oMr_detail.Nominal_value); }
void InitData() { CReactiveFactory faReactive = new CReactiveFactory(); List <CReactive> lstReactive = faReactive.GetAll(); lstReactive.Add(new CReactive() { Idreactive = 0, Reactive_name = "---", Chemical_formula = "---" }); cbMedium.Properties.DataSource = lstReactive; cbMedium.Properties.ValueMember = "Idreactive"; cbMedium.Properties.DisplayMember = "Reactive_name"; cbModif.Properties.DataSource = lstReactive; cbModif.Properties.ValueMember = "Idreactive"; cbModif.Properties.DisplayMember = "Reactive_name"; CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); idreactive_medium = oTemplate_method_aa.Medium; idreactive_modif = oTemplate_method_aa.Modif; LstAllCalibs = oModCalibStd.GetCustomCalibStd(idelement, idmr_detail, idreactive_medium, idreactive_modif); gcCalibStd.DataSource = LstAllCalibs; gvCalibStd.ExpandAllGroups(); //oGroup_solution = oModCalibStd.GetMethodCalib(idelement, idmr_detail, idreactive_medium, idreactive_modif); CElement oElement = new CElementFactory() .GetByPrimaryKey(new CElementKeys(Convert.ToInt16(idelement))); ucTraceUser1.UserSign = Comun.GetUser(); ucTraceUser1.DateSign = Comun.GetDate(); }
public void InitConfiguration() { CCalibFactory faCalib = new CCalibFactory(); lstCalibrations = faCalib.GetAll().Where(x => x.Idtemplate_method == idtemplate_method).ToList(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); NumDecimalsCalib = Convert.ToInt16(oTemplate_method_aa.Num_decimal); Limit_bottom_law = Convert.ToDouble(oTemplate_method_aa.Law_limit_bottom); Limit_top_law = Convert.ToDouble(oTemplate_method_aa.Law_limit_top); Reading_min = Convert.ToDouble(oTemplate_method_aa.Reading_min); Reading_max = Convert.ToDouble(oTemplate_method_aa.Reading_max); CreateListRanksCalibAA(); CreateListRanksFactorAA(); }
public bool Is_reading_right() { CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); CTemplate_method_aa oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); // --- recorring reading columns for (int i = 0; i < ListSamples.Count; i++) { decimal reading1 = Convert.ToDecimal(ListSamples[i].Reading1); decimal reading2 = Convert.ToDecimal(ListSamples[i].Reading2); if (reading1 <= oTemplate_method_aa.Reading_min || reading1 >= oTemplate_method_aa.Reading_max) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la lectura esta fuera de los límites permitidos."); return(false); } if (reading2 <= oTemplate_method_aa.Reading_min || reading2 >= oTemplate_method_aa.Reading_max) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la lectura esta fuera de los límites permitidos."); return(false); } } return(true); }
void Show_batch_finished() { gbApprove.Visible = true; gbReview.Visible = true; gv2col_Qaqc_approve.ImageIndex = 0; gv2col_Qaqc_review.ImageIndex = 0; // --- show template method ShowDilution(); // --- show description method CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory(); CTemplate_method oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idtemplate_method)); tbCodMethod.Text = oTemplate_method.Cod_template_method; tbTitle.Text = oTemplate_method.Title; tbAbbreviation.Text = oTemplate_method.Abbreviation; // --- get batch trace_batch CTrace_batchFactory faTrace_batch = new CTrace_batchFactory(); Dictionary<string, string> dtTrace_batch = new BusinessLayer.Modules.ModProcessBatch().GetCurrentAndBelow(Idbatch, LimsProcess.PROCESS_IN_READING); CBatchFactory faBatch = new CBatchFactory(); CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch)); laTitleModule.Text = String.Format("Bandeja {0} Aprobada\n ({1})" , "B-" + oBatch.Num_tray.ToString().PadLeft(5, '0') , dtTrace_batch["User_approved"].ToString()); laUser_approved.Text = dtTrace_batch["User_approved"].ToString(); laDate_approved.Text = dtTrace_batch["Date_approved"].ToString(); laUser_revised.Text = dtTrace_batch["User_revised"].ToString(); laDate_revised.Text = dtTrace_batch["Date_revised"].ToString(); #region <optimizar> CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); CTemplate_method_aa oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); deDate_allowed_error.DateTime = Convert.ToDateTime(oTemplate_method_aa.Date_allowed_error); CMr_detailFactory faMr_detail = new CMr_detailFactory(); CMr_detail oMr_detail = faMr_detail.GetByPrimaryKey(new CMr_detailKeys(Convert.ToInt16(oTemplate_method_aa.Idmr_detail))); tbLawMri.Text = oMr_detail.Nominal_value.ToString(); CMrFactory faMr = new CMrFactory(); CMr oMr = faMr.GetByPrimaryKey(new CMrKeys( Convert.ToInt16(oMr_detail.Idmr) )); tbMri.Text = oMr.Cod_mr; CMeasurement_unitFactory faMeasure = new CMeasurement_unitFactory(); CMeasurement_unit oMeasurement_unit = faMeasure.GetByPrimaryKey(new CMeasurement_unitKeys(Convert.ToInt16(oMr_detail.Idunit1))); tbUnitMeasure.Text = oMeasurement_unit.Name_unit; #endregion // --- clear columns gcBachCalc.DataSource = null; // --- format the datatable with the number of repetitions if (cbAuthorizationApproved.EditValue.ToString() == "0000") oDataBatch = new CDataBatch(Idbatch, Idtemplate_method, Comun.StatusWork.Saved, Comun.CriteriaSort.BySample); else oDataBatch = new CDataBatch(Idbatch, Idtemplate_method, Comun.StatusWork.Management, Comun.CriteriaSort.BySample); gcBachCalc.DataSource = oDataBatch.ListSamples; // --- show sd tbAbs.Value = oDataBatch.Absorbance; tbStd.Value = oDataBatch.StdVerification; tbAbs.BackColor = oDataBatch.ColorAbsorbance; tbStd.BackColor = oDataBatch.ColorStd; tbSdBlk.Text = oDataBatch.LrbMeasured.ToString(); tbSdBlk.BackColor = oDataBatch.ColorLrbMeasured; tbSdMr.Text = oDataBatch.MriMeasured.ToString(); tbSdMr.BackColor = oDataBatch.ColorMriMeasured; // --- OPTIMIZAR A USER CONTROL paAuthorization.Visible = true; // --- show empty sample ShowParityEmptySample(true); }
void PlotChart() { lstChartPoint_serie1.Clear(); lstChartPoint_serie2.Clear(); // --- recuperar metodo actual if (gvCalibStd.GetFocusedRowCellValue(gcCal_Idtemplate_method) != null) { CTemplate_method_aa currentTemplate_method_aa = new CTemplate_method_aaFactory() .GetByPrimaryKey(new CTemplate_method_aaKeys( Convert.ToInt32(gvCalibStd.GetFocusedRowCellValue(gcCal_Idtemplate_method)))); tbValidity_calib.Value = Convert.ToInt32(currentTemplate_method_aa.Validity_calib); tbRexp2.Value = Convert.ToDecimal(currentTemplate_method_aa.Rexp2); cbMedium.EditValue = currentTemplate_method_aa.Medium; tbMediumConc.Value = Convert.ToDecimal(currentTemplate_method_aa.Medium_conc); cbModif.EditValue = currentTemplate_method_aa.Modif; tbModifConc.Value = Convert.ToDecimal(currentTemplate_method_aa.Modif_conc); // --- dibujar curva if (rgSelectGraphic.SelectedIndex == 0 || rgSelectGraphic.SelectedIndex == 2) { lstChartPoint_serie1 = (from t in LstAllCalibs where t.Idtemplate_method == currentTemplate_method_aa.Idtemplate_method select new ChartPoint { X = Convert.ToDecimal(t.Concentration), Y = Convert.ToDecimal(t.Absorbance_previus) }).ToList(); } // --- dibujar curva if (rgSelectGraphic.SelectedIndex == 1 || rgSelectGraphic.SelectedIndex == 2) { lstChartPoint_serie2 = (from t in LstAllCalibs where t.Idtemplate_method == currentTemplate_method_aa.Idtemplate_method select new ChartPoint { X = Convert.ToDecimal(t.Concentration), Y = Convert.ToDecimal(t.Absorbance) }).ToList(); } InitXYDiagram(); } }
public bool SaveTypeAnalysis(int? pIdtemplate_method) { CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); IDTemplate_Method = pIdtemplate_method; if (IDTemplate_Method != null && IDTemplate_Method > 0) { bool result_template_method_aa = false; CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(IDTemplate_Method))); if (oTemplate_method_aa == null) oTemplate_method_aa = new CTemplate_method_aa(); oTemplate_method_aa.Idtemplate_method = Convert.ToInt32(IDTemplate_Method); oTemplate_method_aa.Weight = tbWeight.Value; oTemplate_method_aa.Weight_incertitude = tbWeight_incertitude.Value; oTemplate_method_aa.Volumen = tbVolumen.Value; oTemplate_method_aa.Reading_min = tbReading_min.Value; oTemplate_method_aa.Reading_max = tbReading_max.Value; oTemplate_method_aa.Dilution2 = tbDilution2.Value; oTemplate_method_aa.Dilution3 = tbDilution3.Value; oTemplate_method_aa.Reason_rep = tbReason_rep.Value; oTemplate_method_aa.Error_allowed = tbError_allowed.Value; oTemplate_method_aa.Symbol = tbSymbol.Text; oTemplate_method_aa.Law_limit_bottom = tbLaw_limit_bottom.Value; oTemplate_method_aa.Law_limit_top = tbLaw_limit_top.Value; oTemplate_method_aa.Idunit_calib = Convert.ToInt16(cbUnit_calib.EditValue); oTemplate_method_aa.Absorvance = tbAbs.Value; oTemplate_method_aa.Abs_incertitude = tbAbs_incertitude.Value; oTemplate_method_aa.Std_verif = tbStd_verif.Value; oTemplate_method_aa.Std_verif_incertitude = tbStd_verif_incertitude.Value; oTemplate_method_aa.Wave_long = tbWave_long.Value; oTemplate_method_aa.Idmr_detail = Convert.ToInt16(cbMaterialRef.EditValue); oTemplate_method_aa.Blk_max = tbBlk_max.Value; oTemplate_method_aa.Reason_rep = tbReason_rep.Value; oTemplate_method_aa.Reproducibility = tbReproducibility.Value; oTemplate_method_aa.Num_decimal = Convert.ToInt16(tbNum_decimal.Value); oTemplate_method_aa.Date_allowed_error = Convert.ToDateTime(deDate_allowed_error.EditValue); oTemplate_method_aa.Rexp2 = tbRexp2.Value; oTemplate_method_aa.Validity_calib = Convert.ToInt16(tbValidity_calib.Value); oTemplate_method_aa.Sol_concentration = Convert.ToDecimal(tbCalibConcen.Text); oTemplate_method_aa.Std_validity_sol1 = Convert.ToInt16(tbValiditySI1.Value); oTemplate_method_aa.Std_validity_sol2 = Convert.ToInt16(tbValiditySI2.Value); oTemplate_method_aa.Std_validity_sv = Convert.ToInt16(tbValiditySV.Value); if (cbTypePattern.EditValue != null) oTemplate_method_aa.Type_pattern = Convert.ToInt32(cbTypePattern.EditValue); //if (oTemplate_method_aa.Type_pattern == 1) // mrc // oTemplate_method_aa.Mrorpattern = Convert.ToInt16(cbMrcOrPattern.EditValue); //else if (oTemplate_method_aa.Type_pattern == 2) // solucion // oTemplate_method_aa.Flag_sol_intermedia = true; if (cbMedium.EditValue != null) { oTemplate_method_aa.Medium = Convert.ToInt32(cbMedium.EditValue); oTemplate_method_aa.Medium_conc = Convert.ToDecimal(tbMediumConc.Value); } if (cbModif.EditValue != null) { oTemplate_method_aa.Modif = Convert.ToInt32(cbModif.EditValue); oTemplate_method_aa.Modif_conc = Convert.ToDecimal(tbModifConc.Value); } if (cbStdMrcOrPattern.EditValue != null) oTemplate_method_aa.Std_mrorpattern = Convert.ToInt32(cbStdMrcOrPattern.EditValue); oTemplate_method_aa.Std_type_pattern = Convert.ToInt32(cbStdType_pattern.EditValue); oTemplate_method_aa.Std_flag_sol_intermedia1 = ckStdSolIntermOne.Checked; oTemplate_method_aa.Std_flag_sol_intermedia2 = ckStdSolIntermTwo.Checked; oTemplate_method_aa.Std_concentration = Convert.ToDecimal(tbStdConcentration.EditValue); oTemplate_method_aa.Std_concentration_sol1 = Convert.ToDecimal(tbStdConcenOne.EditValue); oTemplate_method_aa.Std_concentration_sol2 = Convert.ToDecimal(tbStdConcenTwo.EditValue); oTemplate_method_aa.Std_sol1_medium = tbMediumSol1.Value; oTemplate_method_aa.Std_sol2_medium = tbMediumSol2.Value; oTemplate_method_aa.Std_stdverif_medium = tbMediumStdVerif.Value; oTemplate_method_aa.Idunit_result = Convert.ToInt16(cbUnit_result.EditValue); oTemplate_method_aa.Num_days = Convert.ToInt16(tbNum_days.Value); oTemplate_method_aa.Num_samples = Convert.ToInt16(tbNum_samples.Value); oTemplate_method_aa.Limit_samples = Convert.ToInt16(tbLimit_samples.Value); if (!(result_template_method_aa = faTemplate_method_aa.Update(oTemplate_method_aa))) { oTemplate_method_aa.Date_allowed_error = DateTime.Now; result_template_method_aa = faTemplate_method_aa.Insert(oTemplate_method_aa); } if (result_template_method_aa) { for (int i = 0; i < gvCalibracion.RowCount; i++) { CCalibFactory faCalib = new CCalibFactory(); CCalib oCalib = gvCalibracion.GetRow(i) as CCalib; oCalib.Idtemplate_method = IDTemplate_Method; if (!faCalib.Update(oCalib)) faCalib.Insert(oCalib); } } } return true; }
public Comun.MethodSaveProperty GetResultTestAA() { // --- registro anterior if (IDTemplate_Method <= 0) { return Comun.MethodSaveProperty.NewMethod; } else { CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(IDTemplate_Method))); if (oTemplate_method_aa.Wave_long != tbWave_long.Value) return Comun.MethodSaveProperty.InspectionNewMethod; // --- change inside details, require new version if (oTemplate_method_aa.Abs_incertitude != tbAbs_incertitude.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Absorvance != tbAbs.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Blk_max != tbBlk_max.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Date_allowed_error != deDate_allowed_error.DateTime) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Dilution2 != tbDilution2.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Dilution3 != tbDilution3.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Idmr_detail != Convert.ToInt16(cbMaterialRef.EditValue)) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Idunit_calib != Convert.ToInt16(cbUnit_calib.EditValue)) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Idunit_result != Convert.ToInt16(cbUnit_result.EditValue)) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Law_limit_bottom != tbLaw_limit_bottom.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Law_limit_top != tbLaw_limit_top.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Reproducibility != tbReproducibility.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Std_verif != tbStd_verif.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Std_verif_incertitude != tbStd_verif_incertitude.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Symbol != tbSymbol.Text) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Weight != tbWeight.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Weight_incertitude != tbWeight_incertitude.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Reason_rep != tbReason_rep.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Reading_min != tbReading_min.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Reading_max != tbReading_max.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Volumen != tbVolumen.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Num_decimal != tbNum_decimal.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Num_days != tbNum_days.Value) return Comun.MethodSaveProperty.InspectionNewVersion; if (oTemplate_method_aa.Num_samples != tbNum_samples.Value) return Comun.MethodSaveProperty.InspectionNewVersion; return Comun.MethodSaveProperty.Nothing; } }
public bool Is_reading_right() { CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); CTemplate_method_aa oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); // --- recorring reading columns for (int i = 0; i < ListSamples.Count; i++) { decimal reading1 = Convert.ToDecimal(ListSamples[i].Reading1); decimal reading2 = Convert.ToDecimal(ListSamples[i].Reading2); if (reading1 <= oTemplate_method_aa.Reading_min || reading1 >= oTemplate_method_aa.Reading_max) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la lectura esta fuera de los límites permitidos."); return false; } if (reading2 <= oTemplate_method_aa.Reading_min || reading2 >= oTemplate_method_aa.Reading_max) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la lectura esta fuera de los límites permitidos."); return false; } } return true; }
// --- insert sample came from retest full batch public void CallSaveFromRetestFullBatch(int idtemplate_method, long idrecep_sample, long idrecep_sample_detail, long idrecep_sample_detail_elem, long cod_interno, string str_cod_interno, string user, CCorrelative correlative, int?previus_parity) { Correlative = correlative; CBatch_detail_aa_twofold oBatch_detail_aa_twofold = new CBatch_detail_aa_twofold(); CTemplate_method oTemplate_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(idtemplate_method)); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detailFactory().GetByPrimaryKey(new CRecep_sample_detailKeys(idrecep_sample_detail)); CDescription_sample oDescription_sample = new CDescription_sampleFactory().GetByPrimaryKey(new CDescription_sampleKeys(oRecep_sample_detail.Cod_des_sample)); oBatch_detail_aa_twofold.Idtemplate_method = idtemplate_method; oBatch_detail_aa_twofold.Idrecep_sample = idrecep_sample; oBatch_detail_aa_twofold.Idrecep_sample_detail = idrecep_sample_detail; oBatch_detail_aa_twofold.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oBatch_detail_aa_twofold.Idunit_result = oTemplate_method_aa.Idunit_result; oBatch_detail_aa_twofold.Weight1 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Weight2 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Volumen1 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Volumen2 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Dilu2 = oTemplate_method_aa.Dilution2; oBatch_detail_aa_twofold.Dilu3 = oTemplate_method_aa.Dilution3; oBatch_detail_aa_twofold.Flag_dilu2 = false; oBatch_detail_aa_twofold.Flag_dilu3 = false; oBatch_detail_aa_twofold.Flag_mri = 0; oBatch_detail_aa_twofold.Fum = methods.GetFactorConvertionUM(idtemplate_method); oBatch_detail_aa_twofold.Qaqc_blk = 3; oBatch_detail_aa_twofold.Qaqc_par = 3; oBatch_detail_aa_twofold.Qaqc_mr = 3; oBatch_detail_aa_twofold.Qaqc_error = 0; oBatch_detail_aa_twofold.Qaqc_approve = false; oBatch_detail_aa_twofold.Qaqc_review = false; oBatch_detail_aa_twofold.Qaqc_has_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest_idmethod = 0; oBatch_detail_aa_twofold.Qaqc_approve_text = ""; oBatch_detail_aa_twofold.Qaqc_review_text = ""; oBatch_detail_aa_twofold.Qaqc_par_prev_batch = previus_parity; oBatch_detail_aa_twofold.Cod_interno = cod_interno; oBatch_detail_aa_twofold.Cod_sample = str_cod_interno; oBatch_detail_aa_twofold.Cod_des_sample = oRecep_sample_detail.Cod_des_sample; oBatch_detail_aa_twofold.Order_des_sample = oDescription_sample.Priority_order; // --- control sample control_sample.Idtemplate_method = idtemplate_method; //control_sample.Idrecep_sample = idrecep_sample; //control_sample.Idrecep_sample_detail = idrecep_sample_detail; //control_sample.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; control_sample.Weight1 = oTemplate_method_aa.Weight; control_sample.Weight2 = oTemplate_method_aa.Weight; control_sample.Volumen1 = oTemplate_method_aa.Volumen; control_sample.Volumen2 = oTemplate_method_aa.Volumen; control_sample.Dilu2 = oTemplate_method_aa.Dilution2; control_sample.Dilu3 = oTemplate_method_aa.Dilution3; control_sample.Flag_dilu2 = false; control_sample.Flag_dilu3 = false; control_sample.Flag_mri = 1; control_sample.Fum = methods.GetFactorConvertionUM(idtemplate_method); control_sample.Qaqc_blk = 3; control_sample.Qaqc_par = 3; control_sample.Qaqc_mr = 3; control_sample.Qaqc_error = 0; control_sample.Qaqc_approve = false; control_sample.Qaqc_review = false; control_sample.Qaqc_tmp_retest_idmethod = 0; control_sample.Qaqc_approve_text = ""; control_sample.Qaqc_review_text = ""; SaveInBatch(oBatch_detail_aa_twofold, user); }
public void CallSaveSampleBatchWithRetest(int idtemplate_method, long idrecep_sample, long idrecep_sample_detail, long idrecep_sample_detail_elem, long cod_interno, string str_cod_interno, string user, CCorrelative correlative, int Qaqc_par_prev_batch, long origin_batch) { Correlative = correlative; CBatch_detail_aa_twofold oBatch_detail_aa_twofold = new CBatch_detail_aa_twofold(); oTemplate_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(idtemplate_method)); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detailFactory().GetByPrimaryKey(new CRecep_sample_detailKeys(idrecep_sample_detail)); CDescription_sample oDescription_sample = new CDescription_sampleFactory().GetByPrimaryKey(new CDescription_sampleKeys(oRecep_sample_detail.Cod_des_sample)); if (oTemplate_method_aa != null) { oBatch_detail_aa_twofold.Idtemplate_method = idtemplate_method; oBatch_detail_aa_twofold.Idrecep_sample = idrecep_sample; oBatch_detail_aa_twofold.Idrecep_sample_detail = idrecep_sample_detail; oBatch_detail_aa_twofold.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oBatch_detail_aa_twofold.Idunit_result = oTemplate_method_aa.Idunit_result; oBatch_detail_aa_twofold.Weight1 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Weight2 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Volumen1 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Volumen2 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Dilu2 = oTemplate_method_aa.Dilution2; oBatch_detail_aa_twofold.Dilu3 = oTemplate_method_aa.Dilution3; oBatch_detail_aa_twofold.Flag_dilu2 = false; oBatch_detail_aa_twofold.Flag_dilu3 = false; oBatch_detail_aa_twofold.Cod_des_sample = oRecep_sample_detail.Cod_des_sample; oBatch_detail_aa_twofold.Order_des_sample = oDescription_sample.Priority_order; oBatch_detail_aa_twofold.Flag_mri = 0; oBatch_detail_aa_twofold.Fum = methods.GetFactorConvertionUM(idtemplate_method); oBatch_detail_aa_twofold.Qaqc_blk = 3; oBatch_detail_aa_twofold.Qaqc_par = 3; oBatch_detail_aa_twofold.Qaqc_mr = 3; oBatch_detail_aa_twofold.Qaqc_error = 0; oBatch_detail_aa_twofold.Qaqc_approve = false; oBatch_detail_aa_twofold.Qaqc_review = false; oBatch_detail_aa_twofold.Qaqc_has_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest_idmethod = 0; oBatch_detail_aa_twofold.Qaqc_approve_text = ""; oBatch_detail_aa_twofold.Qaqc_review_text = ""; oBatch_detail_aa_twofold.Qaqc_par_prev_batch = Qaqc_par_prev_batch; oBatch_detail_aa_twofold.Cod_interno = cod_interno; oBatch_detail_aa_twofold.Cod_sample = str_cod_interno; control_sample.Idtemplate_method = idtemplate_method; //control_sample.Idrecep_sample = idrecep_sample; //control_sample.Idrecep_sample_detail = idrecep_sample_detail; //control_sample.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; control_sample.Weight1 = oTemplate_method_aa.Weight; control_sample.Weight2 = oTemplate_method_aa.Weight; control_sample.Volumen1 = oTemplate_method_aa.Volumen; control_sample.Volumen2 = oTemplate_method_aa.Volumen; control_sample.Dilu2 = oTemplate_method_aa.Dilution2; control_sample.Dilu3 = oTemplate_method_aa.Dilution3; control_sample.Flag_dilu2 = false; control_sample.Flag_dilu3 = false; control_sample.Flag_mri = 1; control_sample.Fum = methods.GetFactorConvertionUM(idtemplate_method); control_sample.Qaqc_blk = 3; control_sample.Qaqc_par = 3; control_sample.Qaqc_mr = 3; control_sample.Qaqc_error = 0; control_sample.Qaqc_approve = false; control_sample.Qaqc_review = false; control_sample.Qaqc_tmp_retest_idmethod = 0; control_sample.Qaqc_approve_text = ""; control_sample.Qaqc_review_text = ""; Enabled_retest = true; oRetest.Idrecep_sample_detail = idrecep_sample_detail; oRetest.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oRetest.Origin_batch = origin_batch; oRetest.Useredit1 = user; oRetest.Usernew = user; oRetest.Type_retest = 'R'; oRetest.Status = true; // --- save in batch SaveInBatch(oBatch_detail_aa_twofold, user); } }
decimal? GetMedium(int typeSol) { CTemplate_method_aa template_method_aa = new CTemplate_method_aaFactory() .GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(group_solution.Idtemplate_method))); if (typeSol == 1) return template_method_aa.Std_sol1_medium; if (typeSol == 2) return template_method_aa.Std_sol2_medium; if (typeSol == 3) return template_method_aa.Std_stdverif_medium; return null; }
public bool Is_law_right() { CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); CTemplate_method_aa oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); // --- recorring law columns for (int i = 0; i < ListSamples.Count; i++) { CBatch_detail_aa_twofold row = ListSamples[i]; decimal law1 = Convert.ToDecimal(row.Law1); decimal law2 = Convert.ToDecimal(row.Law2); if (law1 <= oTemplate_method_aa.Law_limit_bottom || law1 >= oTemplate_method_aa.Law_limit_top) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la ley esta fuera de los límites permitidos."); return false; } if (law2 <= oTemplate_method_aa.Law_limit_bottom || law1 >= oTemplate_method_aa.Law_limit_top) { ComunForm.Send_message("Formulario de QaQc", TypeMsg.error, "Error: la ley esta fuera de los límites permitidos."); return false; } } return true; }
public void RetrieveTypeAnalysis() { try { InitData(); // --- recuperate head if (IDTemplate_Method != null && IDTemplate_Method > 0) { CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(IDTemplate_Method))); if (oTemplate_method_aa != null) { cbUnit_result.EditValue = oTemplate_method_aa.Idunit_result; tbNum_samples.Value = Convert.ToDecimal(oTemplate_method_aa.Num_samples); tbNum_days.Value = Convert.ToDecimal(oTemplate_method_aa.Num_days); tbLimit_samples.Value = Convert.ToInt16(oTemplate_method_aa.Limit_samples); tbWeight.Value = Convert.ToDecimal(oTemplate_method_aa.Weight); tbWeight_incertitude.Value = Convert.ToDecimal(oTemplate_method_aa.Weight_incertitude); tbVolumen.Value = Convert.ToDecimal(oTemplate_method_aa.Volumen); tbReading_min.Value = Convert.ToDecimal(oTemplate_method_aa.Reading_min); tbReading_max.Value = Convert.ToDecimal(oTemplate_method_aa.Reading_max); tbDilution2.Value = Convert.ToDecimal(oTemplate_method_aa.Dilution2); tbDilution3.Value = Convert.ToDecimal(oTemplate_method_aa.Dilution3); tbReason_rep.Value = Convert.ToDecimal(oTemplate_method_aa.Reason_rep); tbError_allowed.Value = Convert.ToDecimal(oTemplate_method_aa.Error_allowed); tbSymbol.Text = oTemplate_method_aa.Symbol; tbLaw_limit_bottom.Value = Convert.ToDecimal(oTemplate_method_aa.Law_limit_bottom); tbLaw_limit_top.Value = Convert.ToDecimal(oTemplate_method_aa.Law_limit_top); tbAbs.Value = Convert.ToDecimal(oTemplate_method_aa.Absorvance); tbAbs_incertitude.Value = Convert.ToDecimal(oTemplate_method_aa.Abs_incertitude); tbStd_verif.Value = Convert.ToDecimal(oTemplate_method_aa.Std_verif); tbStd_verif_incertitude.Value = Convert.ToDecimal(oTemplate_method_aa.Std_verif_incertitude); tbWave_long.Value = Convert.ToDecimal(oTemplate_method_aa.Wave_long); tbReproducibility.Value = Convert.ToDecimal(oTemplate_method_aa.Reproducibility); tbNum_decimal.Value = Convert.ToDecimal(oTemplate_method_aa.Num_decimal); tbBlk_max.Value = Convert.ToDecimal(oTemplate_method_aa.Blk_max); deDate_allowed_error.DateTime = Convert.ToDateTime(oTemplate_method_aa.Date_allowed_error); cbMaterialRef.EditValue = oTemplate_method_aa.Idmr_detail; cbUnit_calib.EditValue = oTemplate_method_aa.Idunit_calib; cbMrcOrPattern.EditValue = oTemplate_method_aa.Mrorpattern; tbRexp2.Value = Convert.ToDecimal(oTemplate_method_aa.Rexp2); tbNum_days.Value = Convert.ToInt16(oTemplate_method_aa.Num_days); tbNum_samples.Value = Convert.ToInt16(oTemplate_method_aa.Num_samples); cbUnit_result.EditValue = oTemplate_method_aa.Idunit_result; tbLimit_samples.EditValue = oTemplate_method_aa.Limit_samples; tbCalibConcen.EditValue = oTemplate_method_aa.Sol_concentration; /// medio de matriz cbMedium.EditValue = oTemplate_method_aa.Medium; if (oTemplate_method_aa.Medium == null) { tbMediumConc.Enabled = false; tbMediumConc.Value = 0; } else { tbMediumConc.Enabled = true; tbMediumConc.Value = Convert.ToDecimal(oTemplate_method_aa.Medium_conc); } /// modificador de matriz cbModif.EditValue = oTemplate_method_aa.Modif; if (oTemplate_method_aa.Modif == null) { tbModifConc.Enabled = false; tbModifConc.Value = Convert.ToDecimal(oTemplate_method_aa.Modif_conc); } else { tbModifConc.Enabled = true; tbModifConc.Value = Convert.ToDecimal(oTemplate_method_aa.Modif_conc); } tbValidity_calib.Value = Convert.ToDecimal(oTemplate_method_aa.Validity_calib); cbTypePattern.EditValue = oTemplate_method_aa.Type_pattern; deCalibDateExpir.DateTime = Convert.ToDateTime(oTemplate_method_aa.Sol_date_expiration); cbStdType_pattern.EditValue = oTemplate_method_aa.Std_type_pattern; cbStdMrcOrPattern.EditValue = oTemplate_method_aa.Std_mrorpattern; ckStdSolIntermOne.Checked = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia1); ckStdSolIntermTwo.Checked = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia2); tbStdConcentration.EditValue = oTemplate_method_aa.Std_concentration; tbStdConcenOne.EditValue = oTemplate_method_aa.Std_concentration_sol1; tbStdConcenTwo.EditValue = oTemplate_method_aa.Std_concentration_sol2; tbMediumSol1.Value = Convert.ToDecimal(oTemplate_method_aa.Std_sol1_medium); tbMediumSol2.Value = Convert.ToDecimal(oTemplate_method_aa.Std_sol2_medium); tbMediumStdVerif.Value = Convert.ToDecimal(oTemplate_method_aa.Std_stdverif_medium); tbValiditySI1.Value = Convert.ToInt16(oTemplate_method_aa.Std_validity_sol1); tbValiditySI2.Value = Convert.ToInt16(oTemplate_method_aa.Std_validity_sol2); tbValiditySV.Value = Convert.ToInt16(oTemplate_method_aa.Std_validity_sv); tbValiditySI1.Enabled = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia1); tbValiditySI2.Enabled = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia2); tbValiditySV.Enabled = true; // --- recuperate CCalibFactory faCalib = new CCalibFactory(); List<CCalib> lst = new CCalibFactory().GetAll(); gcCalibracion.DataSource = new BindingList<CCalib>( faCalib .GetAll() .Where(x => x.Idtemplate_method == oTemplate_method_aa.Idtemplate_method).ToList()); // --- recuperar soluciones List<CSolution_interm> lstSim = new ModSolInterm().GetLstSolution_intermByMethod(Convert.ToInt32(IDTemplate_Method)); foreach (CSolution_interm item in lstSim) { if (item.Type_sol == 1) {//solución intermedia 1 tbCodSol1.Text = item.Cod_solution; deExpSolInterm1.DateTime = Convert.ToDateTime(item.Date_end); } else if (item.Type_sol == 2) {//solución intermedia 2 tbCodSol2.Text = item.Cod_solution; deExpSolInterm2.DateTime = Convert.ToDateTime(item.Date_end); } else if (item.Type_sol == 3) {//estandar de calibración tbCodStdVer.Text = item.Cod_solution; deExpSV.DateTime = Convert.ToDateTime(item.Date_end); } else if (item.Type_sol == 4) {//calibraciones cbSolCalib.EditValue = item.Idsolution_interm; deCalibDateExpir.DateTime = Convert.ToDateTime(item.Date_end); } } } } else { // --- recuperate CCalibFactory faCalib = new CCalibFactory(); gcCalibracion.DataSource = new BindingList<CCalib>(faCalib.GetAll().Where(x => x.Idtemplate_method == 0).ToList()); } } catch (Exception ex) { ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); } }
private void bgvBatchCalc2_RowCellStyle(object sender, RowCellStyleEventArgs e) { if (e.Column == gv2col_Reading1 || e.Column == gv2col_Reading2) { CTemplate_method_aa method = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); // --- draw color style cell without result if (bgvBatchCalc2.GetRowCellValue(e.RowHandle, e.Column) != null) { string strReading = bgvBatchCalc2.GetRowCellValue(e.RowHandle, e.Column).ToString(); decimal reading = 0; if (decimal.TryParse(strReading, out reading)) { if (reading < method.Reading_min || reading > method.Reading_max) { e.Appearance.BackColor = Comun.ColorMorado; e.Appearance.Options.UseBackColor = true; } } } } if (e.Column == gv2col_Str_result_analysis) { if (tabTreeQaqc.SelectedTabPageIndex == 1) { CBatch_detail_aa_twofold oBatch_detail_aa_twofold = oDataBatch.ListSamples[e.RowHandle]; ///1 : incorrecto : rojo ///2 : plausible : ambar ///3 : aceptado : verde ///4 : incorrecto con observacion o reensayo : rojo if (oBatch_detail_aa_twofold.Qaqc_status_result == 1) e.Appearance.BackColor = Comun.ColorRojo; if (oBatch_detail_aa_twofold.Qaqc_status_result == 2) e.Appearance.BackColor = Comun.ColorAmbar; if (oBatch_detail_aa_twofold.Qaqc_status_result == 3) e.Appearance.BackColor = Comun.ColorVerde; if (oBatch_detail_aa_twofold.Qaqc_status_result == 4) e.Appearance.BackColor = Comun.ColorRojo; } } }
private void bgvBatchCalc2_ValidateRow(object sender, ValidateRowEventArgs e) { CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); GridView view = sender as GridView; if (!Convert.ToBoolean(bgvBatchCalc2.GetFocusedRowCellValue(gv2col_Flag_dila1)) && Convert.ToBoolean(bgvBatchCalc2.GetFocusedRowCellValue(gv2col_Flag_dilb1))) { e.Valid = false; view.SetColumnError(gv2col_Flag_dila1, "Selección de diluciones mal efectuada."); view.SetColumnError(gv2col_Flag_dilb1, "Selección de diluciones mal efectuada."); } }
void ShowDilution() { // --- get method CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); CTemplate_method_aa oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); // --- assign visibility columns // dilution 2 if (oTemplate_method_aa.Dilution2 == 1) { gv2col_Dilua1.Visible = false; gv2col_Flag_dila1.Visible = false; } else { gv2col_Dilua1.Visible = true; gv2col_Flag_dila1.Visible = true; } // dilution 3 if (oTemplate_method_aa.Dilution3 == 1) { gv2col_Dilub1.Visible = false; gv2col_Flag_dilb1.Visible = false; } else { gv2col_Dilub1.Visible = true; gv2col_Flag_dilb1.Visible = true; } if (oTemplate_method_aa.Dilution2 == 1 && oTemplate_method_aa.Dilution3 == 1) gbDilution.Visible = false; else gbDilution.Visible = true; }
void Show_batch() { // --- show trace groups gbApprove.Visible = false; gbReview.Visible = false; gv2col_Qaqc_approve.ImageIndex = 0; gv2col_Qaqc_review.ImageIndex = 0; // --- show template method ShowDilution(); // --- show description method CBatchFactory faBatch = new CBatchFactory(); CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch)); laTitleModule.Text = String.Format("Bandeja {0} en Espera", Comun.FormatCorrelativeCode("B-", Convert.ToInt64(oBatch.Num_tray), 5)); if (oBatch.Status_process == 'W') { ucSignCloseTray.Title = "Cerrar bandeja"; ucSignCloseTray.Enabled = true; bgvBatchCalc2.OptionsBehavior.Editable = false; } if (oBatch.Status_process == 'P') { ucSignCloseTray.Title = "Cerrado("+oBatch.User_close_tray+")"; ucSignCloseTray.Enabled = false; bgvBatchCalc2.OptionsBehavior.Editable = true; } CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory(); oTemplate_method_current = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idtemplate_method)); tbCodMethod.Text = oTemplate_method_current.Cod_template_method; tbTitle.Text = oTemplate_method_current.Title; tbAbbreviation.Text = oTemplate_method_current.Abbreviation; #region <optimizar> CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa_current = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method)); deDate_allowed_error.DateTime = Convert.ToDateTime(oTemplate_method_aa_current.Date_allowed_error); CMr_detailFactory faMr_detail = new CMr_detailFactory(); CMr_detail oMr_detail = faMr_detail.GetByPrimaryKey(new CMr_detailKeys(Convert.ToInt16(oTemplate_method_aa_current.Idmr_detail))); tbLawMri.Text = oMr_detail.Nominal_value.ToString(); CMrFactory faMr = new CMrFactory(); CMr oMr = faMr.GetByPrimaryKey(new CMrKeys( Convert.ToInt16(oMr_detail.Idmr) )); tbMri.Text = oMr.Cod_mr; CMeasurement_unitFactory faMeasure = new CMeasurement_unitFactory(); CMeasurement_unit oMeasurement_unit = faMeasure.GetByPrimaryKey(new CMeasurement_unitKeys(Convert.ToInt16(oMr_detail.Idunit1))); tbUnitMeasure.Text = oMeasurement_unit.Name_unit; #endregion // --- clear columns gcBachCalc.DataSource = null; // --- format the datatable with the number of repetitions oDataBatch = new CDataBatch(Idbatch, Idtemplate_method, Comun.StatusWork.Waiting, Comun.CriteriaSort.BySample); gcBachCalc.DataSource = oDataBatch.ListSamples; // --- show sd tbAbs.Value = oDataBatch.Absorbance; tbStd.Value = oDataBatch.StdVerification; tbAbs.BackColor = oDataBatch.ColorAbsorbance; tbStd.BackColor = oDataBatch.ColorStd; tbSdBlk.Text = oDataBatch.LrbMeasured.ToString(); tbSdBlk.BackColor = oDataBatch.ColorLrbMeasured; tbSdMr.Text = oDataBatch.MriMeasured.ToString(); tbSdMr.BackColor = oDataBatch.ColorMriMeasured; // --- show empty sample ShowParityEmptySample(false); }
public bool SaveTypeAnalysis(int?pIdtemplate_method) { CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); IDTemplate_Method = pIdtemplate_method; if (IDTemplate_Method != null && IDTemplate_Method > 0) { bool result_template_method_aa = false; CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(IDTemplate_Method))); if (oTemplate_method_aa == null) { oTemplate_method_aa = new CTemplate_method_aa(); } oTemplate_method_aa.Idtemplate_method = Convert.ToInt32(IDTemplate_Method); oTemplate_method_aa.Weight = tbWeight.Value; oTemplate_method_aa.Weight_incertitude = tbWeight_incertitude.Value; oTemplate_method_aa.Volumen = tbVolumen.Value; oTemplate_method_aa.Reading_min = tbReading_min.Value; oTemplate_method_aa.Reading_max = tbReading_max.Value; oTemplate_method_aa.Dilution2 = tbDilution2.Value; oTemplate_method_aa.Dilution3 = tbDilution3.Value; oTemplate_method_aa.Reason_rep = tbReason_rep.Value; oTemplate_method_aa.Error_allowed = tbError_allowed.Value; oTemplate_method_aa.Symbol = tbSymbol.Text; oTemplate_method_aa.Law_limit_bottom = tbLaw_limit_bottom.Value; oTemplate_method_aa.Law_limit_top = tbLaw_limit_top.Value; oTemplate_method_aa.Idunit_calib = Convert.ToInt16(cbUnit_calib.EditValue); oTemplate_method_aa.Absorvance = tbAbs.Value; oTemplate_method_aa.Abs_incertitude = tbAbs_incertitude.Value; oTemplate_method_aa.Std_verif = tbStd_verif.Value; oTemplate_method_aa.Std_verif_incertitude = tbStd_verif_incertitude.Value; oTemplate_method_aa.Wave_long = tbWave_long.Value; oTemplate_method_aa.Idmr_detail = Convert.ToInt16(cbMaterialRef.EditValue); oTemplate_method_aa.Blk_max = tbBlk_max.Value; oTemplate_method_aa.Reason_rep = tbReason_rep.Value; oTemplate_method_aa.Reproducibility = tbReproducibility.Value; oTemplate_method_aa.Num_decimal = Convert.ToInt16(tbNum_decimal.Value); oTemplate_method_aa.Date_allowed_error = Convert.ToDateTime(deDate_allowed_error.EditValue); oTemplate_method_aa.Rexp2 = tbRexp2.Value; oTemplate_method_aa.Validity_calib = Convert.ToInt16(tbValidity_calib.Value); oTemplate_method_aa.Sol_concentration = Convert.ToDecimal(tbCalibConcen.Text); oTemplate_method_aa.Std_validity_sol1 = Convert.ToInt16(tbValiditySI1.Value); oTemplate_method_aa.Std_validity_sol2 = Convert.ToInt16(tbValiditySI2.Value); oTemplate_method_aa.Std_validity_sv = Convert.ToInt16(tbValiditySV.Value); if (cbTypePattern.EditValue != null) { oTemplate_method_aa.Type_pattern = Convert.ToInt32(cbTypePattern.EditValue); } //if (oTemplate_method_aa.Type_pattern == 1) // mrc // oTemplate_method_aa.Mrorpattern = Convert.ToInt16(cbMrcOrPattern.EditValue); //else if (oTemplate_method_aa.Type_pattern == 2) // solucion // oTemplate_method_aa.Flag_sol_intermedia = true; if (cbMedium.EditValue != null) { oTemplate_method_aa.Medium = Convert.ToInt32(cbMedium.EditValue); oTemplate_method_aa.Medium_conc = Convert.ToDecimal(tbMediumConc.Value); } if (cbModif.EditValue != null) { oTemplate_method_aa.Modif = Convert.ToInt32(cbModif.EditValue); oTemplate_method_aa.Modif_conc = Convert.ToDecimal(tbModifConc.Value); } if (cbStdMrcOrPattern.EditValue != null) { oTemplate_method_aa.Std_mrorpattern = Convert.ToInt32(cbStdMrcOrPattern.EditValue); } oTemplate_method_aa.Std_type_pattern = Convert.ToInt32(cbStdType_pattern.EditValue); oTemplate_method_aa.Std_flag_sol_intermedia1 = ckStdSolIntermOne.Checked; oTemplate_method_aa.Std_flag_sol_intermedia2 = ckStdSolIntermTwo.Checked; oTemplate_method_aa.Std_concentration = Convert.ToDecimal(tbStdConcentration.EditValue); oTemplate_method_aa.Std_concentration_sol1 = Convert.ToDecimal(tbStdConcenOne.EditValue); oTemplate_method_aa.Std_concentration_sol2 = Convert.ToDecimal(tbStdConcenTwo.EditValue); oTemplate_method_aa.Std_sol1_medium = tbMediumSol1.Value; oTemplate_method_aa.Std_sol2_medium = tbMediumSol2.Value; oTemplate_method_aa.Std_stdverif_medium = tbMediumStdVerif.Value; oTemplate_method_aa.Idunit_result = Convert.ToInt16(cbUnit_result.EditValue); oTemplate_method_aa.Num_days = Convert.ToInt16(tbNum_days.Value); oTemplate_method_aa.Num_samples = Convert.ToInt16(tbNum_samples.Value); oTemplate_method_aa.Limit_samples = Convert.ToInt16(tbLimit_samples.Value); if (!(result_template_method_aa = faTemplate_method_aa.Update(oTemplate_method_aa))) { oTemplate_method_aa.Date_allowed_error = DateTime.Now; result_template_method_aa = faTemplate_method_aa.Insert(oTemplate_method_aa); } if (result_template_method_aa) { for (int i = 0; i < gvCalibracion.RowCount; i++) { CCalibFactory faCalib = new CCalibFactory(); CCalib oCalib = gvCalibracion.GetRow(i) as CCalib; oCalib.Idtemplate_method = IDTemplate_Method; if (!faCalib.Update(oCalib)) { faCalib.Insert(oCalib); } } } } return(true); }
public void RetrieveTypeAnalysis() { try { InitData(); // --- recuperate head if (IDTemplate_Method != null && IDTemplate_Method > 0) { CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(IDTemplate_Method))); if (oTemplate_method_aa != null) { cbUnit_result.EditValue = oTemplate_method_aa.Idunit_result; tbNum_samples.Value = Convert.ToDecimal(oTemplate_method_aa.Num_samples); tbNum_days.Value = Convert.ToDecimal(oTemplate_method_aa.Num_days); tbLimit_samples.Value = Convert.ToInt16(oTemplate_method_aa.Limit_samples); tbWeight.Value = Convert.ToDecimal(oTemplate_method_aa.Weight); tbWeight_incertitude.Value = Convert.ToDecimal(oTemplate_method_aa.Weight_incertitude); tbVolumen.Value = Convert.ToDecimal(oTemplate_method_aa.Volumen); tbReading_min.Value = Convert.ToDecimal(oTemplate_method_aa.Reading_min); tbReading_max.Value = Convert.ToDecimal(oTemplate_method_aa.Reading_max); tbDilution2.Value = Convert.ToDecimal(oTemplate_method_aa.Dilution2); tbDilution3.Value = Convert.ToDecimal(oTemplate_method_aa.Dilution3); tbReason_rep.Value = Convert.ToDecimal(oTemplate_method_aa.Reason_rep); tbError_allowed.Value = Convert.ToDecimal(oTemplate_method_aa.Error_allowed); tbSymbol.Text = oTemplate_method_aa.Symbol; tbLaw_limit_bottom.Value = Convert.ToDecimal(oTemplate_method_aa.Law_limit_bottom); tbLaw_limit_top.Value = Convert.ToDecimal(oTemplate_method_aa.Law_limit_top); tbAbs.Value = Convert.ToDecimal(oTemplate_method_aa.Absorvance); tbAbs_incertitude.Value = Convert.ToDecimal(oTemplate_method_aa.Abs_incertitude); tbStd_verif.Value = Convert.ToDecimal(oTemplate_method_aa.Std_verif); tbStd_verif_incertitude.Value = Convert.ToDecimal(oTemplate_method_aa.Std_verif_incertitude); tbWave_long.Value = Convert.ToDecimal(oTemplate_method_aa.Wave_long); tbReproducibility.Value = Convert.ToDecimal(oTemplate_method_aa.Reproducibility); tbNum_decimal.Value = Convert.ToDecimal(oTemplate_method_aa.Num_decimal); tbBlk_max.Value = Convert.ToDecimal(oTemplate_method_aa.Blk_max); deDate_allowed_error.DateTime = Convert.ToDateTime(oTemplate_method_aa.Date_allowed_error); cbMaterialRef.EditValue = oTemplate_method_aa.Idmr_detail; cbUnit_calib.EditValue = oTemplate_method_aa.Idunit_calib; cbMrcOrPattern.EditValue = oTemplate_method_aa.Mrorpattern; tbRexp2.Value = Convert.ToDecimal(oTemplate_method_aa.Rexp2); tbNum_days.Value = Convert.ToInt16(oTemplate_method_aa.Num_days); tbNum_samples.Value = Convert.ToInt16(oTemplate_method_aa.Num_samples); cbUnit_result.EditValue = oTemplate_method_aa.Idunit_result; tbLimit_samples.EditValue = oTemplate_method_aa.Limit_samples; tbCalibConcen.EditValue = oTemplate_method_aa.Sol_concentration; /// medio de matriz cbMedium.EditValue = oTemplate_method_aa.Medium; if (oTemplate_method_aa.Medium == null) { tbMediumConc.Enabled = false; tbMediumConc.Value = 0; } else { tbMediumConc.Enabled = true; tbMediumConc.Value = Convert.ToDecimal(oTemplate_method_aa.Medium_conc); } /// modificador de matriz cbModif.EditValue = oTemplate_method_aa.Modif; if (oTemplate_method_aa.Modif == null) { tbModifConc.Enabled = false; tbModifConc.Value = Convert.ToDecimal(oTemplate_method_aa.Modif_conc); } else { tbModifConc.Enabled = true; tbModifConc.Value = Convert.ToDecimal(oTemplate_method_aa.Modif_conc); } tbValidity_calib.Value = Convert.ToDecimal(oTemplate_method_aa.Validity_calib); cbTypePattern.EditValue = oTemplate_method_aa.Type_pattern; deCalibDateExpir.DateTime = Convert.ToDateTime(oTemplate_method_aa.Sol_date_expiration); cbStdType_pattern.EditValue = oTemplate_method_aa.Std_type_pattern; cbStdMrcOrPattern.EditValue = oTemplate_method_aa.Std_mrorpattern; ckStdSolIntermOne.Checked = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia1); ckStdSolIntermTwo.Checked = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia2); tbStdConcentration.EditValue = oTemplate_method_aa.Std_concentration; tbStdConcenOne.EditValue = oTemplate_method_aa.Std_concentration_sol1; tbStdConcenTwo.EditValue = oTemplate_method_aa.Std_concentration_sol2; tbMediumSol1.Value = Convert.ToDecimal(oTemplate_method_aa.Std_sol1_medium); tbMediumSol2.Value = Convert.ToDecimal(oTemplate_method_aa.Std_sol2_medium); tbMediumStdVerif.Value = Convert.ToDecimal(oTemplate_method_aa.Std_stdverif_medium); tbValiditySI1.Value = Convert.ToInt16(oTemplate_method_aa.Std_validity_sol1); tbValiditySI2.Value = Convert.ToInt16(oTemplate_method_aa.Std_validity_sol2); tbValiditySV.Value = Convert.ToInt16(oTemplate_method_aa.Std_validity_sv); tbValiditySI1.Enabled = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia1); tbValiditySI2.Enabled = Convert.ToBoolean(oTemplate_method_aa.Std_flag_sol_intermedia2); tbValiditySV.Enabled = true; // --- recuperate CCalibFactory faCalib = new CCalibFactory(); List <CCalib> lst = new CCalibFactory().GetAll(); gcCalibracion.DataSource = new BindingList <CCalib>( faCalib .GetAll() .Where(x => x.Idtemplate_method == oTemplate_method_aa.Idtemplate_method).ToList()); // --- recuperar soluciones List <CSolution_interm> lstSim = new ModSolInterm().GetLstSolution_intermByMethod(Convert.ToInt32(IDTemplate_Method)); foreach (CSolution_interm item in lstSim) { if (item.Type_sol == 1) {//solución intermedia 1 tbCodSol1.Text = item.Cod_solution; deExpSolInterm1.DateTime = Convert.ToDateTime(item.Date_end); } else if (item.Type_sol == 2) {//solución intermedia 2 tbCodSol2.Text = item.Cod_solution; deExpSolInterm2.DateTime = Convert.ToDateTime(item.Date_end); } else if (item.Type_sol == 3) {//estandar de calibración tbCodStdVer.Text = item.Cod_solution; deExpSV.DateTime = Convert.ToDateTime(item.Date_end); } else if (item.Type_sol == 4) {//calibraciones cbSolCalib.EditValue = item.Idsolution_interm; deCalibDateExpir.DateTime = Convert.ToDateTime(item.Date_end); } } } } else { // --- recuperate CCalibFactory faCalib = new CCalibFactory(); gcCalibracion.DataSource = new BindingList <CCalib>(faCalib.GetAll().Where(x => x.Idtemplate_method == 0).ToList()); } } catch (Exception ex) { ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); } }
void InitData() { CReactiveFactory faReactive = new CReactiveFactory(); List<CReactive> lstReactive = faReactive.GetAll(); lstReactive.Add(new CReactive() { Idreactive = 0, Reactive_name = "---", Chemical_formula = "---" }); cbMedium.Properties.DataSource = lstReactive; cbMedium.Properties.ValueMember = "Idreactive"; cbMedium.Properties.DisplayMember = "Reactive_name"; cbModif.Properties.DataSource = lstReactive; cbModif.Properties.ValueMember = "Idreactive"; cbModif.Properties.DisplayMember = "Reactive_name"; CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); idreactive_medium = oTemplate_method_aa.Medium; idreactive_modif = oTemplate_method_aa.Modif; LstAllCalibs = oModCalibStd.GetCustomCalibStd(idelement, idmr_detail, idreactive_medium, idreactive_modif); gcCalibStd.DataSource = LstAllCalibs; gvCalibStd.ExpandAllGroups(); //oGroup_solution = oModCalibStd.GetMethodCalib(idelement, idmr_detail, idreactive_medium, idreactive_modif); CElement oElement = new CElementFactory() .GetByPrimaryKey(new CElementKeys(Convert.ToInt16(idelement))); ucTraceUser1.UserSign = Comun.GetUser(); ucTraceUser1.DateSign = Comun.GetDate(); }
public Comun.MethodSaveProperty GetResultTestAA() { // --- registro anterior if (IDTemplate_Method <= 0) { return(Comun.MethodSaveProperty.NewMethod); } else { CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa(); CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory(); oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(IDTemplate_Method))); if (oTemplate_method_aa.Wave_long != tbWave_long.Value) { return(Comun.MethodSaveProperty.InspectionNewMethod); } // --- change inside details, require new version if (oTemplate_method_aa.Abs_incertitude != tbAbs_incertitude.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Absorvance != tbAbs.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Blk_max != tbBlk_max.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Date_allowed_error != deDate_allowed_error.DateTime) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Dilution2 != tbDilution2.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Dilution3 != tbDilution3.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Idmr_detail != Convert.ToInt16(cbMaterialRef.EditValue)) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Idunit_calib != Convert.ToInt16(cbUnit_calib.EditValue)) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Idunit_result != Convert.ToInt16(cbUnit_result.EditValue)) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Law_limit_bottom != tbLaw_limit_bottom.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Law_limit_top != tbLaw_limit_top.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Reproducibility != tbReproducibility.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Std_verif != tbStd_verif.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Std_verif_incertitude != tbStd_verif_incertitude.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Symbol != tbSymbol.Text) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Weight != tbWeight.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Weight_incertitude != tbWeight_incertitude.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Reason_rep != tbReason_rep.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Reading_min != tbReading_min.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Reading_max != tbReading_max.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Volumen != tbVolumen.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Num_decimal != tbNum_decimal.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Num_days != tbNum_days.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } if (oTemplate_method_aa.Num_samples != tbNum_samples.Value) { return(Comun.MethodSaveProperty.InspectionNewVersion); } return(Comun.MethodSaveProperty.Nothing); } }