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