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;
}
