public static RepositoryItemMRUEdit CreateTreeMRUEdit(this TreeListColumn treeColumn)
{
RepositoryItemMRUEdit repositoryItem = new RepositoryItemMRUEdit
{
AutoHeight = false
};
treeColumn.TreeList.RepositoryItems.Add(repositoryItem);
treeColumn.ColumnEdit = repositoryItem;
return(repositoryItem);
}
/// <summary>
/// 创建GridView的列编辑为MRUEdit
/// </summary>
/// <param name="gridColumn">GridColumn列对象</param>
/// <returns></returns>
public static RepositoryItemMRUEdit CreateMRUEdit(this GridColumn gridColumn)
{
RepositoryItemMRUEdit repositoryItem = new RepositoryItemMRUEdit
{
AutoHeight = false
};
gridColumn.View.GridControl.RepositoryItems.Add(repositoryItem);
gridColumn.ColumnEdit = repositoryItem;
return(repositoryItem);
}
private RepositoryItem formulationRepository(SchemaItemDTO schemaItemDTO)
{
if (_formulationRepository == null)
{
_formulationRepository = new RepositoryItemMRUEdit();
_presenter.AllFormulationKeys().Each(key => _formulationRepository.Items.Add(key));
}
_formulationRepository.ReadOnly = !schemaItemDTO.NeedsFormulation;
_formulationRepository.Enabled = schemaItemDTO.NeedsFormulation;
return(_formulationRepository);
}
private static void InitCotAutocomplete(GridColumn colunm, string fieldName, DataSet dsSource, bool allowSpin)
{
var edit = new RepositoryItemMRUEdit { Tag = true };
if (dsSource != null && dsSource.Tables.Count > 0)
{
foreach (DataRow r in dsSource.Tables[0].Rows)
{
if (r[0].ToString() == "") continue;
edit.Items.Add(r[0].ToString());
}
}
edit.Tag = false;
edit.AddingMRUItem += delegate(object sender, AddingMRUItemEventArgs e)
{
e.Cancel = !(bool)edit.Tag;
};
// edit.ShowDropDown = ShowDropDown.Never;
edit.Buttons[0].Visible = false;
HelpGridColumn.CotRepository(colunm, fieldName, edit, HorzAlignment.Near);
if (allowSpin == false)
{
// edit.OwnerEdit.c
edit.Spin += delegate(object sender, SpinEventArgs e)
{
e.Handled = true;
};
}
}
public RepositoryItemMRUEdit InitCotTietMuc()
{
rpTietMuc = new RepositoryItemMRUEdit();
// edit.Tag = true;
DataSet dsTM= HelpDB.getDBService().LoadDataSet("select * from dm_tiet_muc");
if (dsTM != null && dsTM.Tables.Count > 0)
{
dtTietMuc = dsTM.Tables[0];
foreach (DataRow r in dtTietMuc.Rows)
{
if (r["NAME"].ToString() == "") continue;
rpTietMuc.Items.Add(r["NAME"].ToString());
}
}
else
dtTietMuc = null;
//edit.Tag = false;
//edit.AddingMRUItem += delegate(object sender, AddingMRUItemEventArgs e)
//{
// e.Cancel = !(bool)edit.Tag;
//};
// edit.ShowDropDown = ShowDropDown.Never;
//edit.Buttons[0].Visible = false;
HelpGridColumn.CotRepository(ColTietNuc, "TIET_MUC_NAME", rpTietMuc, DevExpress.Utils.HorzAlignment.Near);
//if (AllowSpin == false)
//{
// // edit.OwnerEdit.c
//}
return rpTietMuc;
}
public ManualOrdersForm(int algId)
{
InitializeComponent();
SqlConnection sqlCon = new SqlConnection("Data Source=LP-Kevin;Initial Catalog=inSight_OPP;User ID=sa;Password=2020;Connect Timeout=15;");
sqlCon.Open();
DataTable table = ManualOrdersData.getManualOrdersNormal_GS(sqlCon, 123);
if (table != null && table.Rows.Count > 0)
{
var cmName = String.Empty;
var cmVisible = false;
for (int i = 0; i < table.Columns.Count; i++)
{
cmVisible = false;
cmName = table.Columns[i].ColumnName;
var dataType = getGridColumnType(table.Columns[i].DataType.Name);
if (cmName.IndexOf("_raw") == -1)
{
cmVisible = true;
}
//this.gridPTGS.Columns.Add(new GridColumn() { Name = cmName, FieldName = cmName, Caption = cmName, VisibleIndex = i, UnboundType = dataType, Visible = cmVisible,Tag = cmName });
DevExpress.XtraGrid.Columns.GridColumn cl = new DevExpress.XtraGrid.Columns.GridColumn();
cl.Name = cmName;
cl.Caption = cmName;
cl.FieldName = cmName;
cl.OptionsColumn.AllowSize = true;
//cl.OptionsColumn.ReadOnly = true;
cl.OptionsColumn.AllowEdit = true;
cl.OptionsColumn.AllowMove = false;
cl.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
cl.OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
cl.OptionsFilter.AllowFilter = false;
cl.OptionsFilter.AllowAutoFilter = false;
if (cmName == "TopSurCode")
{
//下拉框
RepositoryItemComboBox ricbo = new RepositoryItemComboBox();
ricbo.AutoComplete = true;//自动搜索筛选
ricbo.ImmediatePopup = true;
ricbo.DropDownRows = 5;
ricbo.Items.Add("asd黄色");
ricbo.Items.Add("dfasd黄色");
ricbo.Items.Add("米黄色");
ricbo.Items.Add("米黄色02");
ricbo.Items.Add("米黄色033");
ricbo.Items.Add("米黄色034");
ricbo.Items.Add("米黄色035");
ricbo.Items.Add("米黄色036");
ricbo.Items.Add("米黄色073");
ricbo.Items.Add("米黄色0fg3");
ricbo.Items.Add("米黄色034");
ricbo.Items.Add("米黄色045");
ricbo.Items.Add("米黄色034");
ricbo.Items.Add("111米黄色034");
ricbo.Items.Add("111米黄色035");
ricbo.Items.Add("111米黄色036");
ricbo.Items.Add("111米黄色073");
ricbo.Items.Add("11米黄色0fg3");
ricbo.Items.Add("11米黄色034");
ricbo.Items.Add("11米黄色045");
ricbo.Items.Add("11米黄色05");
cl.ColumnEdit = ricbo;
//comboBoxEdit1.Properties.AutoComplete = true;//自动搜索筛选
}
if (cmName == "itmfCode")
{
//下拉框
RepositoryItemMRUEdit ricbo = new RepositoryItemMRUEdit();
//ricbo.AutoComplete = true;//自动搜索筛选
ricbo.ImmediatePopup = true;
//MruEdit是否允许编辑
ricbo.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
//是否具有删除 绑定的数据源功能
ricbo.AllowRemoveMRUItems = false;
//ricbo.ImmediatePopup = true;
ricbo.DropDownRows = 5;
ricbo.Items.Add("侧板");
ricbo.Items.Add("dfasd黄色");
ricbo.Items.Add("米黄色");
ricbo.Items.Add("米黄色02");
ricbo.Items.Add("米黄色033");
ricbo.Items.Add("米黄色034");
ricbo.Items.Add("米黄色035");
ricbo.Items.Add("米黄色036");
ricbo.Items.Add("米黄色073");
ricbo.Items.Add("米黄色0fg3");
ricbo.Items.Add("米黄色034");
ricbo.Items.Add("米黄色045");
ricbo.Items.Add("米黄色034");
ricbo.Items.Add("111米黄色034");
ricbo.Items.Add("111米黄色035");
ricbo.Items.Add("111米黄色036");
ricbo.Items.Add("111米黄色073");
ricbo.Items.Add("11米黄色0fg3");
ricbo.Items.Add("11米黄色034");
ricbo.Items.Add("11米黄色045");
ricbo.Items.Add("11米黄色05");
cl.ColumnEdit = ricbo;
//comboBoxEdit1.Properties.AutoComplete = true;//自动搜索筛选
}
cl.Visible = cmVisible;
gridPTGS.Columns.Add(cl);
}
this.gridControlPTGS.DataSource = table;
}
}
