SearchLookUpEdit
public void compBindSource()
{
txt_wtcomp.EditValue = null; ;//清空数据源
//下拉框和数据库的实现
//默认值
txt_wtcomp.Properties.NullText = "------请选择------";
是否显示底部
txt_wtcomp.Properties.ShowFooter = false;
//填充列
txt_wtcomp.Properties.View.PopulateColumns();
txt_wtcomp.Properties.View.Columns.Add(new GridColumn { FieldName = "wtcompid", VisibleIndex = 1, Caption = "id", } );
txt_wtcomp.Properties.View.Columns.Add(new GridColumn { FieldName = "wtcompname", VisibleIndex = 1, Caption = "类别代码", });
//设置列属性
DataTable dt = wtcompSER.QueryTABwtcomp().Tables[0];
txt_wtcomp.Properties.DataSource = dt;
txt_wtcomp.Properties.DisplayMember = "wtcompname";
txt_wtcomp.Properties.ValueMember = "wtcompid";
// txt_wtcomp.Properties.View.EndInit();
//txt_wtcomp.Properties.View.Columns[1].Width = 120;
// txt_wtcomp.Properties.View.Columns[0].DisplayFormat.FormatString = "000000";//列格式设置
下拉框自适应宽度
// txt_wtcomp.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
// txt_wtcomp.Properties.View.BestFitColumns();
或者设置总宽度
// txt_wtcomp.Properties.PopupFormWidth = 500;//或者设置总宽度
//txt_wtcomp.Properties.TextEditStyle = TextEditStyles.Standard;
选择第一项
txt_wtcomp.Properties.View.SelectRow(0);
txt_wtcomp.Properties.View.EndUpdate();
txt_wtcomp.Properties.View.BestFitColumns();
txt_wtcomp.Properties.ShowFooter = false;
txt_wtcomp.Properties.View.OptionsView.ShowAutoFilterRow = true; //显示不显示grid上第一个空行,也是用于检索的应用
txt_wtcomp.Properties.View.OptionsFilter.AllowFilterEditor = false;
//txt_wtcomp.Properties.CustomizeAutoCompleteSource = false;
txt_wtcomp.Properties.ImmediatePopup = true;
txt_wtcomp.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains;
txt_wtcomp.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; //配置,用于像文本框
}
treelist
private void CreateColumns(TreeList tl)
{
//RepositoryItemComboBox cbbEnd = new RepositoryItemComboBox();
//DataTable dt = unitSER.QueryTABunit().Tables[0];
//cbbEnd.Items.Clear();
//foreach (DataRow item in dt.Rows)
//{
// string str = item["unit_name"].ToString();
// string strID = item["unit_id"].ToString();
// cbbEnd.Items.Add(str);
//}
// Create three columns.
//tl.BeginUpdate();
tl.Columns.Add();
tl.Columns[0].Caption = "id";
tl.Columns[0].VisibleIndex = 0;
tl.Columns[0].FieldName = "id";
tl.Columns.Add();
tl.Columns[1].Caption = "样品名称";
tl.Columns[1].VisibleIndex = 1;
tl.Columns[1].Width = 150;
//tl.Columns.Add();
//tl.Columns[2].Caption = "试验称";
tl.Columns[0].FieldName = "id";
//tl.Columns[2].VisibleIndex = 2;
//tl.Columns[2].Width = 30;
// // 添加根节点
// TreeListNode root = tl.AppendNode(null, null);
// root.SetValue("Name", "Root Node");
// root.Tag = "root";
// // 添加子节点
// TreeListNode child = tl.AppendNode(null, root);
// child.SetValue("Name", "Child Node");
tl.PopulateColumns();//加这一句
List<ypkuZD> Tzl = ypkuSER.Getmoreypku();
for (int s = 0; s < Tzl.Count; s++)
{
TreeListNode node2 = tl.AppendNode(null, null);
node2.SetValue(tl.Columns[0], Tzl[s].ypku_id);
node2.SetValue(tl.Columns[1], Tzl[s].ypku_bigname + "[" + "]");
node2.Tag = Tzl[s].ypku_id;
//node2.SetValue(treeList1.Columns[2], Tzl[s].yptest_price);
//node2.SetValue(treeList1.Columns[3], "0");
/*
//设置第二层
List<yptestkuzxmZD> szl = yptestkuzxmSER.Getmoreyptestkuzxmbyt(Tzl[s].yptestku_id.ToString());
for (int t = 0; t < szl.Count; t++)
{
//设置第三层
TreeListNode node3 = treeList1.AppendNode(test, node2);
node3.SetValue(treeList1.Columns[0], szl[t].yptestkuzxm_id);
node3.SetValue(treeList1.Columns[1], szl[t].yptestkuzxm_name);
node3.SetValue(treeList1.Columns[2], szl[t].yptestkuzxm_price);
node3.Tag = "1";
}
*/
}
tl.Columns[0].Visible = true;
// tl.OptionsView.ShowCheckBoxes = true; //是否显示CheckBox
tl.RowHeight = 20;
tl.ExpandAll();
tl.Columns[1].OptionsColumn.ReadOnly = true;
tl.Columns[1].OptionsColumn.AllowEdit = false;
//tl.Columns[2].OptionsColumn.AllowEdit = false;
//tl.Columns[3].OptionsColumn.AllowEdit = false;
// tl.EndUpdate();
}