public void Bind(Comun.TypeMr typemr, short idelement)
{
Init();
this.Properties.DataSource = new ModMaterialReference().GetBy_TypeMr_And_Element(typemr, idelement);
this.Properties.ValueMember = "Idmr_detail";
this.Properties.DisplayMember = "Cod_mr";
}
public void BindConcen(Comun.TypeMr typemr, short idelement)
{
this.Properties.Columns.Clear();
this.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Nominal_value", Visible = true
});
this.Properties.ShowHeader = false;
this.Properties.ShowFooter = false;
this.Properties.DataSource = new ModMaterialReference().GetConcentration_By_TypeMr(typemr, idelement);
this.Properties.ValueMember = "Nominal_value";
this.Properties.DisplayMember = "Nominal_value";
}
public IList GetConcentration_By_TypeMr(Comun.TypeMr typeMr, short idelement)
{
List <CMr_detail> lstMr_detail = new CMr_detailFactory().GetAll().Where(c => c.Analyte == idelement).ToList();
List <CMr> lstMr = new CMrFactory().GetAll().Where(x => x.Type_mr == Convert.ToChar(typeMr)).ToList();
// get reference material
var query1 =
(from t1 in lstMr_detail
from t2 in lstMr.Where(x => x.Idmr == t1.Idmr)
select new
{
t1.Nominal_value
}).Distinct().ToList();
return(query1);
}
public IList GetBy_TypeMr_And_Element(Comun.TypeMr typeMr, short idelement)
{
List <CMr_detail> lstMr_detail = new CMr_detailFactory().GetAll().Where(c => c.Analyte == idelement).ToList();
List <CMr> lstMr = new CMrFactory().GetAll();
// get reference material
var query1 =
(from t1 in lstMr_detail
join t2 in lstMr on t1.Idmr equals t2.Idmr
where t2.Type_mr == Convert.ToChar(typeMr)
select new
{
t2.Idmr,
t1.Idmr_detail,
t2.Cod_mr,
t1.Nominal_value
}).Distinct().ToList();
return(query1);
}
public List <CCustom_solution> GetLstMrc(Comun.TypeMr typeMr, short idelement)
{
CSettings oSettings = new CSettings();
List <CMr_detail> lstMr_detail = new CMr_detailFactory().GetAll().Where(c => c.Analyte == idelement).ToList();
List <CMr> lstMr = new CMrFactory().GetAll();
// get reference material
List <CCustom_solution> query1 =
(from t1 in lstMr_detail
join t2 in lstMr on t1.Idmr equals t2.Idmr
where t2.Type_mr == Convert.ToChar(typeMr)
select new CCustom_solution
{
Idmr = t2.Idmr,
Idmr_detail = t1.Idmr_detail,
Code = t2.Cod_mr,
Name = t2.Cod_mr
}).ToList <CCustom_solution>();
return(query1);
}
