/// <summary>
/// Cai dat luoi
/// </summary>
/// <param name="grid"></param>
/// <param name="autoFilter"></param>
public static void InitGridLookUp(GridLookUpEdit grid, bool autoFilter, TextEditStyles textEditStyle)
{
//Show filter
grid.Properties.View.OptionsView.ShowAutoFilterRow = autoFilter;
grid.Properties.TextEditStyle = textEditStyle;
grid.Properties.PopupFilterMode = PopupFilterMode.Contains;
//grid.Properties.BestFitMode = BestFitMode.BestFit;
for (int i = 0; i < grid.Properties.View.Columns.Count; i++)
{
grid.Properties.View.Columns[i].Visible = false;
}
}
/// <summary>
/// Thiet lap cau hinh luoi
/// </summary>
/// <param name="repo"></param>
/// <param name="autoFilter"></param>
/// <param name="autoPopup"></param>
/// <param name="textEditStyle"></param>
public static void Init(RepositoryItemGridLookUpEdit repo, bool autoPopup, TextEditStyles textEditStyle)
{
//Show filter
repo.View.OptionsView.ShowAutoFilterRow = true;
repo.TextEditStyle = textEditStyle;
repo.ImmediatePopup = autoPopup;
repo.PopupFilterMode = PopupFilterMode.Contains;
//grid.BestFitMode = BestFitMode.BestFit;
for (int i = 0; i < repo.View.Columns.Count; i++)
{
repo.View.Columns[i].Visible = false;
}
}
public W20231(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
this.Text = _ProgramID + "─" + _ProgramName;
GridHelper.SetCommonGrid(gvMain);
PrintableComponent = gcMain;
dao20231 = new D20231();
//統一設定下拉選單TextEditStyles
TextEditStyles textEditStyles = TextEditStyles.DisableTextEditor;
//期貨
//List<LookupItem> futList = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = " "},
// new LookupItem() { ValueMember = "F", DisplayMember = "○" }};
DataTable dtFut = new CODW().ListLookUpEdit("20231", "PLS4_FUT");
Pls4FutLookUpEdit.SetColumnLookUp(dtFut, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_FUT.ColumnEdit = Pls4FutLookUpEdit;
//選擇權
//List<LookupItem> optList = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = " "},
// new LookupItem() { ValueMember = "O", DisplayMember = "○" }};
DataTable dtOpt = new CODW().ListLookUpEdit("20231", "PLS4_OPT");
Pls4OptLookUpEdit.SetColumnLookUp(dtOpt, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_OPT.ColumnEdit = Pls4OptLookUpEdit;
//商品類別
//List<LookupItem> codeList = new List<LookupItem>(){
// new LookupItem() { ValueMember = "I", DisplayMember = "新增"},
// new LookupItem() { ValueMember = "M", DisplayMember = "小型"},
// new LookupItem() { ValueMember = "N", DisplayMember = " " }};
DataTable dtCode = new CODW().ListLookUpEdit("20231", "PLS4_STATUS_CODE");
Pls4StatusCodeLookUpEdit.SetColumnLookUp(dtCode, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_STATUS_CODE.ColumnEdit = Pls4StatusCodeLookUpEdit;
//上市/上櫃
//Pls4PidLookUpEdit.SetColumnLookUp(new COD().ListByCol("TFXM", "TFXM_PID"), "COD_ID", "COD_DESC", textEditStyles, null);
DataTable dtTFXM = new CODW().ListLookUpEdit("APDK", "UNDERLYING_MARKET");
Pls4PidLookUpEdit.SetColumnLookUp(dtTFXM, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_PID.ColumnEdit = Pls4PidLookUpEdit;
//預設隱藏DataGridView
gcMain.Visible = false;
}
/// <summary>
/// 直接設定DataTable給lookupEdit
/// </summary>
/// <param name="cbx"></param>
/// <param name="dataSource">dataTable or Dictionary(k,v)</param>
/// <param name="valueMember">valueMember</param>
/// <param name="displayMember">displayMember</param>
/// <param name="textEditStyles">Standard=可輸入 DisableTextEditor=不可輸入,單純的下拉選單</param>
/// <param name="nullText">nullText</param>
public static void SetDataTable(this DevExpress.XtraEditors.LookUpEdit cbx,
object dataSource,
string valueMember,
string displayMember = "CP_DISPLAY",
TextEditStyles textEditStyles = TextEditStyles.Standard,
string nullText = "--請選擇--")
{
//一些基本參數設定
cbx.EnterMoveNextControl = true;
cbx.Properties.NullText = nullText;
cbx.Properties.DropDownRows = 10; //一次顯示的下拉選單項目數量(太多或太少都不好)
cbx.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
cbx.Properties.SearchMode = SearchMode.AutoFilter; //SearchMode.AutoFilter=輸入框每次輸入,都直接過濾下拉選項
cbx.Properties.AutoSearchColumnIndex = 1;
cbx.Properties.TextEditStyle = textEditStyles; //Standard=可輸入 DisableTextEditor=不可輸入,單純的下拉選單
cbx.Properties.ShowHeader = false;
cbx.Properties.ShowFooter = false;
cbx.Properties.DataSource = dataSource;
cbx.Properties.ForceInitialize();
cbx.Properties.PopulateColumns();
cbx.Properties.DisplayMember = displayMember;
cbx.Properties.ValueMember = valueMember;
//把不需要顯示的欄位隱藏
//ken,如果是Dictionary<Key,Value>,則Key在PopulateColumns時其Visible就直接為false
foreach (LookUpColumnInfo col in cbx.Properties.Columns)
{
if (!string.IsNullOrEmpty(displayMember))
{
if (col.FieldName.ToUpper() != displayMember.ToUpper())
{
col.Visible = false;
}
}
}
}
internal static void SetCheckedComboEdit(CheckedComboBoxEdit control, ICollection <string> list, bool includeALL = false, TextEditStyles style = TextEditStyles.Standard)
{
if (control == null)
{
return;
}
control.Properties.Items.Clear();
if (includeALL)
{
control.Properties.Items.Add(ALL);
}
foreach (string item in list)
{
control.Properties.Items.Add(item);
}
if (control.Properties.Items.Count > 0)
{
foreach (CheckedListBoxItem item in control.Properties.Items)
{
item.CheckState = CheckState.Checked;
}
}
}
internal static void SetComboEdit(ComboBoxEdit control, ICollection <string> list, bool includeALL = false, TextEditStyles style = TextEditStyles.Standard)
{
if (control == null)
{
return;
}
control.Properties.Items.Clear();
if (includeALL)
{
control.Properties.Items.Add(ALL);
}
foreach (string item in list)
{
control.Properties.Items.Add(item);
}
if (control.Properties.Items.Count > 0)
{
control.SelectedIndex = 0;
}
control.Properties.TextEditStyle = style;
}
