void rePopupContainer_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { DataTable currentTable = (propertyGridControl1.SelectedObject as MyObject).MySpreadSheet; if (currentTable == null) { currentTable = new DataTable(); (propertyGridControl1.SelectedObject as MyObject).MySpreadSheet = currentTable; } currentTable.Clear(); currentTable.Columns.Clear(); SpreadsheetControl spreadSheet = (sender as PopupContainerEdit).Properties.PopupControl.Controls[0] as SpreadsheetControl; Worksheet workSheet = spreadSheet.Document.Worksheets[0]; CellRange usedRange = workSheet.GetUsedRange(); for (int i = 0; i < usedRange.ColumnCount; i++) { currentTable.Columns.Add("Column" + i.ToString()); } for (int i = 0; i < usedRange.RowCount; i++) { DataRow newRow = currentTable.NewRow(); for (int j = 0; j < usedRange.ColumnCount; j++) { newRow[j] = workSheet.Cells[i, j].DisplayText; } currentTable.Rows.Add(newRow); } }
void ri_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { e.Value = dateEdit1.EditValue; DateTime date = Convert.ToDateTime(e.Value); PropertyInfo pi = typeof(FilterControl).GetProperty("FocusInfo", BindingFlags.Instance | BindingFlags.NonPublic); FilterControlFocusInfo focus = (FilterControlFocusInfo)pi.GetValue(filterControl1, null); ClauseNode cnode = focus.Node as ClauseNode; if (cnode == null) { return; } if (cnode.Operation == ClauseType.Between) { if (focus.ElementIndex == 2) { PatchOperator(cnode.AdditionalOperands[1] as OperandValue, date, comboBoxEdit1.Text, true); } else if (focus.ElementIndex == 3) { PatchOperator(cnode.AdditionalOperands[0] as OperandValue, date, comboBoxEdit1.Text, false); } cnode.RecalcLabelInfo(); } }
private void popupContainerEdit1_Properties_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { int[] selectedRow_s = gridView1.GetSelectedRows(); List <dynamic> selectedObject_s = selectedRow_s.Select(rowHandleIndex => gridView1.GetRow(rowHandleIndex)).Cast <dynamic>().ToList(); string templateString = " {0} [{1}]"; List <string> tempList = selectedObject_s.Select(@object => String.Format(templateString, @object.UserLastName, @object.UserEnrollNumber)).Cast <string>().ToList(); string selectedObjectString_s = string.Join(";", tempList); //List<string> selectedObjectString_s = selectedObject_s.Aggregate(string.Empty, (current, item) => current +=) e.Value = selectedObjectString_s; }
void ri_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { int[] selectedRows = popupGridView1.GetSelectedRows(); List <string> values = new List <string>(); foreach (int rowHandle in selectedRows) { values.Add(popupGridView1.GetRowCellValue(rowHandle, "Name").ToString()); } string csv = String.Join(", ", values); e.Value = csv; }
private void popupContainerEdit1_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { if (gridView1.FocusedRowHandle > -1) { e.Value = gridView1.GetFocusedRowCellValue(_DisplayMember); _value = Convert.ToInt32(gridView1.GetFocusedRowCellValue(_ValueMember)); } else { e.Value = string.Empty; _value = 0; } }
private void popupContainerEdit1_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { string ss = string.Empty; for (int i = 0; i < checkedListBox1.Items.Count; i++) { if (checkedListBox1.GetItemChecked(i)) { ss = ss + dt.Rows[i][_DisplayMember].ToString() + ","; } } if (ss.Length > 0) { ss = ss.Remove(ss.Length - 1, 1); } //popupContainerEdit1.EditValue = ss; e.Value = ss; }
private void pEdit_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { if (viewQuery.SelectedRowsCount == 0) { return; } if (viewQuery.FocusedRowHandle < 0) { return; } bSelected = true; DataRow dr = viewQuery.GetDataRow(viewQuery.FocusedRowHandle); e.Value = dr[DisplayMember]; EditValue = dr[ValueMember]; DataTable dt = ((DataTable)gridQuery.DataSource); dt.DefaultView.RowFilter = ""; }
private void popupContainerEdit1_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { if (e.Value == null) { return; } if (e.Value.GetType().Equals(typeof(DataRow))) { Customers.Customer cr = new Customers.Customer(((DataRow)e.Value).Field <int>("CustomerID")); e.Value = cr; } else if (e.Value.GetType().Equals(typeof(Customers.Customer))) { } else { e.Value = null; } }
private void popupContainerEdit1_Properties_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { try { string name = dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells[0].Value.ToString(); if (name.Trim() != "") { name = name + "路径表单"; } e.Value = name; } catch { } return; try { DataTable temp = (DataTable)dataGridView1.DataSource; string name = dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells[0].Value.ToString(); if (name.Trim() != "") { name = name + "路径表单"; } e.Value = name; if (AddorMOdify) { //复制后,加载表单 ((DataTable)this.dgvPathTableStep.DataSource).Rows.Clear(); //获得路径的的阶段 DataTable tbpathstep = ts_Clinical_Class.function.GetPathstep(temp.DefaultView[this.dataGridView1.CurrentCell.RowIndex]["PATHWAY_ID"].ToString()); for (int i = 0; i < tbpathstep.Rows.Count; i++) { DataRow _row = ((DataTable)this.dgvPathTableStep.DataSource).NewRow(); _row["TABLE_STEP_NAME"] = tbpathstep.Rows[i]["PATH_STEP_NAME"].ToString(); // _row["PATH_TABLE_ID"] = ""; _row["DELETED"] = 0; ((DataTable)this.dgvPathTableStep.DataSource).Rows.Add(_row); } } } catch (Exception ex) { } }
private void OnQueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { e.Value = ValuesConverter.TrackBarRangeToString(rangeTrackBarControl1.Value); }
private void repositoryItemPopupContainerEdit1_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { e.Value = memoEdit1.EditValue; }
private void popupContainerEdit1_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { e.Value = gridView1.GetFocusedRowCellValue("AdSoyad"); }
private void popupContainerEdit1_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { e.Value = dataSet11.Tables[0].Rows[0]["FirstName"]; }
private void popupContainerEdit1_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { }
private void popupContainerEdit1_Properties_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { e.Value = memoEdit1.Text; }
private void XtraRepositoryItemPopupContainerEdit_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { if (this.gridView1Popup.FocusedRowHandle >= 0) { if (_IsNULLSelected) { e.Value = System.DBNull.Value; } else { e.Value = this.gridView1Popup.GetDataRow(this.gridView1Popup.FocusedRowHandle)[_ValueFieldName]; } } }
private void popupContainerEditCustomButtonForTest_Properties_QueryResultValue(object sender, DevExpress.XtraEditors.Controls.QueryResultValueEventArgs e) { e.Value = buttonEditSample.EditValue; }