void RetrieveData() { string element = ckElement.Checked == true ? cbElement1.Text : null; var query = (from m in new CElement_wavelengthFactory().GetAll() from n in new CElementFactory().GetAll().Where(x => x.Idelement == m.Idelement) where (element == null || n.Cod_element == element) select new { m.Idelement, n.Cod_element, m.Idelement_wavelength, m.Element_wavelength, m.Wavelength, m.Idl_axial, m.Idl_radial, m.Lineality_axial, m.Lineality_radial }); DataTable queryIcp = new ModIcp().GetElements(element); var queryIcpElement = (from p in queryIcp.AsEnumerable() join q in new CElementFactory().GetAll() on p.Field <string>("elementSymbol") equals q.Cod_element select new { Wavelength = p.Field <string>("wavelength"), elementSymbol = q.Cod_element, Idelement = q.Idelement, Element_wavelength = p.Field <string>("ElementName"), Idl_radial = SetValueView(p.Field <int>("Radial")), Idl_axial = SetValueView(p.Field <int>("Axial")), Lineality_radial = SetValueView(p.Field <int>("Radial")), Lineality_axial = SetValueView(p.Field <int>("Axial")) }).ToList(); List <CElement_wavelength> lst = (from t in queryIcpElement join p in query on t.Wavelength equals p.Wavelength into tp from q in tp.DefaultIfEmpty() select new CElement_wavelength { Idelement_wavelength = q == null ? 0 : q.Idelement_wavelength, Idelement = t.Idelement, Wavelength = t.Wavelength, Element_wavelength = t.Element_wavelength, Idl_radial = q == null ? t.Idl_radial : q.Idl_radial, Idl_axial = q == null ? t.Idl_axial : q.Idl_axial, Lineality_radial = q == null ? t.Lineality_radial : q.Lineality_radial, Lineality_axial = q == null ? t.Lineality_axial : q.Lineality_axial }).ToList(); gcElemWavelength.DataSource = new BindingList <CElement_wavelength>(lst); SaveData(); }
private void cbElement1_EditValueChanged(object sender, EventArgs e) { if (cbElement1.EditValue != null) { //conectar con icp según filtro de elemento ModIcp modIcp = new ModIcp(); DataTable dtElements = modIcp.GetElements(cbElement1.Text); RetrieveData(); } }
private void cbElement1_EditValueChanged(object sender, EventArgs e) { if (cbElement1.EditValue != null) { //conectar con icp según filtro de elemento ModIcp modIcp = new ModIcp(); DataTable dtElements = modIcp.GetElements(cbElement1.Text); RetrieveData(); } }
void RetrieveData() { string element = ckElement.Checked == true ? cbElement1.Text : null; var query = (from m in new CElement_wavelengthFactory().GetAll() from n in new CElementFactory().GetAll().Where(x => x.Idelement == m.Idelement) where (element == null || n.Cod_element == element) select new { m.Idelement, n.Cod_element, m.Idelement_wavelength, m.Element_wavelength, m.Wavelength, m.Idl_axial, m.Idl_radial, m.Lineality_axial, m.Lineality_radial }); DataTable queryIcp = new ModIcp().GetElements(element); var queryIcpElement = (from p in queryIcp.AsEnumerable() join q in new CElementFactory().GetAll() on p.Field<string>("elementSymbol") equals q.Cod_element select new { Wavelength = p.Field<string>("wavelength"), elementSymbol = q.Cod_element, Idelement = q.Idelement, Element_wavelength = p.Field<string>("ElementName"), Idl_radial = SetValueView(p.Field<int>("Radial")), Idl_axial = SetValueView(p.Field<int>("Axial")), Lineality_radial = SetValueView(p.Field<int>("Radial")), Lineality_axial = SetValueView(p.Field<int>("Axial")) }).ToList(); List<CElement_wavelength> lst = (from t in queryIcpElement join p in query on t.Wavelength equals p.Wavelength into tp from q in tp.DefaultIfEmpty() select new CElement_wavelength { Idelement_wavelength = q == null ? 0 : q.Idelement_wavelength, Idelement = t.Idelement, Wavelength = t.Wavelength, Element_wavelength = t.Element_wavelength, Idl_radial = q == null ? t.Idl_radial : q.Idl_radial, Idl_axial = q == null ? t.Idl_axial : q.Idl_axial, Lineality_radial = q == null ? t.Lineality_radial : q.Lineality_radial, Lineality_axial = q == null ? t.Lineality_axial : q.Lineality_axial }).ToList(); gcElemWavelength.DataSource = new BindingList<CElement_wavelength>(lst); SaveData(); }