//public BindingList<CSolution> GetLstChildSolution(int idsolution) //{ // List<CSolution> lst = new CSolutionFactory() // .GetAll().Where(c => c.Idpattern == idsolution && c.Status == true).ToList(); // return new BindingList<CSolution>(lst); //} //public BindingList<CSolution> GetLstChildMr(short idmr) //{ // List<CSolution> lst = new CSolutionFactory() // .GetAll().Where(c => c.Idpattern_mr == idmr && c.Status == true).ToList(); // return new BindingList<CSolution>(lst); //} public decimal?GetConcentrationPPM(short idmr_detail) { CMr_detailFactory faMr_detail = new CMr_detailFactory(); CMr_detail oMr_detail = faMr_detail.GetByPrimaryKey(new CMr_detailKeys(idmr_detail)); CSettings oSettings = new CSettings(); CConvert_unit_measurementFactory faCConvert_unit_measurement = new CConvert_unit_measurementFactory(); var query = ( from t in faCConvert_unit_measurement.GetAll() where t.Idunit2 == oSettings.GetUnitMeasureSolution() && t.Idunit1 == oMr_detail.Idunit1 select new { Concentration = oMr_detail.Nominal_value * t.Factor }).ToList(); foreach (var item in query) { if (item.Concentration != null) { return(Math.Round(Convert.ToDecimal(item.Concentration), 4)); } } decimal?num = null; return(num); }
public decimal GetFactorConvertionUM(int idtemplate_method) { /* * SELECT INTO v_factor t3.factor * FROM template_method t1 * INNER JOIN template_method_aa t2 * ON t1.idtemplate_method = t2.idtemplate_method * INNER JOIN convert_unit_measurement t3 * ON t1.idunit_result = t3.idunit2 AND * t2.idunit_calib = t3.idunit1 * WHERE t1.idtemplate_method = p_idtemplate_method; * * RETURN v_factor; */ var query = (from t1 in GetAllLastVersionMethods() join t2 in new CTemplate_method_aaFactory().GetAll() on t1.Idtemplate_method equals t2.Idtemplate_method where t1.Idtemplate_method == idtemplate_method select new { idtemplate_method = t1.Idtemplate_method, idunit_result = t2.Idunit_result, idunit_calib = t2.Idunit_calib }).Distinct(); short idunit_result = 0, idunit_calib = 0; decimal factor = 1; foreach (var item in query) { idunit_result = Convert.ToInt16(item.idunit_result); idunit_calib = Convert.ToInt16(item.idunit_calib); break; } List <CConvert_unit_measurement> lst = new CConvert_unit_measurementFactory().GetAll(); foreach (CConvert_unit_measurement item in lst) { if (item.Idunit1 == idunit_calib && item.Idunit2 == idunit_result) { factor = Convert.ToDecimal(item.Factor); } } return(factor); }
public List <CCustom_solution> GetLstPatternSolution(short idelement) { CSettings oSettings = new CSettings(); List <CConvert_unit_measurement> lstConvertUnit = new CConvert_unit_measurementFactory().GetAll().Where(c => c.Idunit2 == oSettings.GetUnitMeasureSolution()).ToList(); List <CMr_detail> lstMr_detail = new CMr_detailFactory().GetAll().Where(c => c.Analyte == idelement).ToList(); List <CMr> lstMr = new CMrFactory().GetAll(); List <CSolution> lstSolution = new CSolutionFactory().GetAll().Where(c => c.Idelement == idelement).ToList(); // get reference material List <CCustom_solution> query1 = (from t1 in lstMr_detail join t2 in lstMr on t1.Idmr equals t2.Idmr join t3 in lstConvertUnit on t1.Idunit1 equals t3.Idunit1 select new CCustom_solution { Idmr = t2.Idmr, Idmr_detail = t1.Idmr_detail, Code = t2.Cod_mr, Lote = t2.Lot, Name = t2.Cod_mr, Purity = 100, IsPattern = true, Concentration = Convert.ToDecimal(t1.Nominal_value) * Convert.ToDecimal(t3.Factor), Name_group = "Material de Referencia y Sales" }).ToList <CCustom_solution>(); // get solutions List <CCustom_solution> query2 = (from t3 in lstSolution select new CCustom_solution { Idsolution = t3.Idsolution, Code = t3.Cod_solution, Name = t3.Solution_name, Lote = t3.Lote, Purity = Convert.ToDecimal(t3.Purity), IsPattern = false, Concentration = Convert.ToDecimal(t3.Concentration), Name_group = "Soluciones" }).ToList <CCustom_solution>(); List <CCustom_solution> lst = new List <CCustom_solution>(query1.Union(query2)); return(lst); }
protected override bool Grabar_Registro() { CConvert_unit_measurementFactory faConvert_unit_measurement = new CConvert_unit_measurementFactory(); CConvert_unit_measurement oConvert_unit_measurement = new CConvert_unit_measurement(); for(int i = 0; i < gvConvertionUM.RowCount; i++) { oConvert_unit_measurement.Idconvert = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idconvert)); oConvert_unit_measurement.Idunit1 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit1)); oConvert_unit_measurement.Idunit2 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit2)); oConvert_unit_measurement.Den_unit1 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit1).ToString(); oConvert_unit_measurement.Den_unit2 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit2).ToString(); oConvert_unit_measurement.Factor = Convert.ToDecimal( gvConvertionUM.GetRowCellValue(i, gcUmc_factor)); if (!faConvert_unit_measurement.Update(oConvert_unit_measurement)) faConvert_unit_measurement.Insert(oConvert_unit_measurement); } return true; }
protected override bool Grabar_Registro() { CConvert_unit_measurementFactory faConvert_unit_measurement = new CConvert_unit_measurementFactory(); CConvert_unit_measurement oConvert_unit_measurement = new CConvert_unit_measurement(); for (int i = 0; i < gvConvertionUM.RowCount; i++) { oConvert_unit_measurement.Idconvert = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idconvert)); oConvert_unit_measurement.Idunit1 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit1)); oConvert_unit_measurement.Idunit2 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit2)); oConvert_unit_measurement.Den_unit1 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit1).ToString(); oConvert_unit_measurement.Den_unit2 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit2).ToString(); oConvert_unit_measurement.Factor = Convert.ToDecimal(gvConvertionUM.GetRowCellValue(i, gcUmc_factor)); if (!faConvert_unit_measurement.Update(oConvert_unit_measurement)) { faConvert_unit_measurement.Insert(oConvert_unit_measurement); } } return(true); }
protected override void Recuperar_Registro() { CConvert_unit_measurementFactory faConvert_unit_measure = new CConvert_unit_measurementFactory(); gcConvertionUM.DataSource = new BindingList<CConvert_unit_measurement>(faConvert_unit_measure.GetAll()); }
protected override void Recuperar_Registro() { CConvert_unit_measurementFactory faConvert_unit_measure = new CConvert_unit_measurementFactory(); gcConvertionUM.DataSource = new BindingList <CConvert_unit_measurement>(faConvert_unit_measure.GetAll()); }