internal static void GridLookupEdit_门店信息(RepositoryItemGridLookUpEdit properties, string[] fields = null)
{
var list = 门店Logic.GetList();
properties.DataSource = list;
properties.ValueMember = "编码";
properties.DisplayMember = "门店名称";
properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit;
properties.ShowFooter = false;
properties.View.AutoConfig();
properties.View.BestFitColumns();
if (null == fields)
fields = new string[]
{
"门店名称"
};
for (int i = 0; i < fields.Length; i++)
{
properties.View.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn
{
FieldName = fields[i],
Caption = fields[i],
VisibleIndex = i
});
}
}
/// <summary>
/// An di cac cot, dung sau ShowField
/// </summary>
/// <param name="grid"></param>
/// <param name="fieldName"></param>
public static void HideField(RepositoryItemGridLookUpEdit grid, string[] fieldName)
{
for (int i = 0; i < fieldName.Length; i++)
{
grid.View.Columns[fieldName[i]].Visible = false;
}
}
//filter control
public override void applyCustomEditShownFilterControl(IDataBindingSource src, ShowValueEditorEventArgs e)
{
RepositoryItemGridLookUpEdit rle = new RepositoryItemGridLookUpEdit();
e.CustomRepositoryItem = rle;
setupRle(src, rle, e.CurrentNode.FirstOperand.PropertyName);
}
/// <summary>
///
/// </summary>
/// <param name="grid"></param>
/// <param name="fieldName"></param>
/// <param name="visible"></param>
public static void ShowAssignField(RepositoryItemGridLookUpEdit grid, string[] fieldName, bool visible)
{
for (int i = 0; i < fieldName.Length; i++)
{
grid.View.Columns[fieldName[i]].Visible = visible;
}
}
private void InitializeComponent()
{
this.fProperties = new DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit();
this.fPropertiesView = new DevExpress.XtraGrid.Views.Grid.GridView();
((System.ComponentModel.ISupportInitialize)(this.fProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.fPropertiesView)).BeginInit();
this.SuspendLayout();
//
// fProperties
//
this.fProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
});
this.fProperties.Name = "fProperties";
this.fProperties.PopupView = this.fPropertiesView;
//
// fPropertiesView
//
this.fPropertiesView.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
this.fPropertiesView.Name = "fPropertiesView";
this.fPropertiesView.OptionsSelection.EnableAppearanceFocusedCell = false;
this.fPropertiesView.OptionsView.ShowGroupPanel = false;
((System.ComponentModel.ISupportInitialize)(this.fProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.fPropertiesView)).EndInit();
this.ResumeLayout(false);
}
public FrmS11AH()
{
InitializeComponent();
_dbOptionHelper = new GlobalVariable();
_accountsPresenter = new AccountsPresenter(this);
dateTimeRangeV1.InitData(DateTime.Parse(new GlobalVariable().PostedDate));
dateTimeRangeV1.SetComboIndex(7);
#region BudgetItem
_rpsAccountNumberView = new GridView();
_rpsAccountNumberView.OptionsView.ColumnAutoWidth = false;
_rpsAccountNumber = new RepositoryItemGridLookUpEdit
{
NullText = "",
View = _rpsAccountNumberView,
TextEditStyle = TextEditStyles.Standard,
PopupResizeMode = ResizeMode.FrameResize,
PopupFormSize = new Size(500, 200),
ShowFooter = false
};
_rpsAccountNumber.View.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never;
_rpsAccountNumber.View.BestFitColumns();
_rpsAccountNumber.View.OptionsView.ShowIndicator = false;
#endregion
}
private void SetUpEditor(RepositoryItemGridLookUpEdit edit)
{
edit.DataSource = list;//new BindingSource(list, "");
edit.ValueMember = "ID";
edit.DisplayMember = "Text";
helper = new TypeConverterHelper(edit, "Unbound", "Point");
}
private void zoneNameGridLookUpEdit_QueryPopUp(object sender, CancelEventArgs e)
{
GridLookUpEdit editor = (GridLookUpEdit)sender;
RepositoryItemGridLookUpEdit properties = editor.Properties;
properties.PopupFormSize = new Size(editor.Width - 4, properties.PopupFormSize.Height);
}
public UserControlAccountingObjectList()
{
InitializeComponent();
rpsAccountingObjectCategory = new RepositoryItemGridLookUpEdit();
_accountingObjectsPresenter = new AccountingObjectsPresenter(this);
}
/// <summary>
/// Initializes a new instance of the <see cref="FrmS12H"/> class.
/// </summary>
public FrmS12H()
{
InitializeComponent();
_dbOptionHelper = new GlobalVariable();
_accountsPresenter = new AccountsPresenter(this);
_banksPresenter = new BanksPresenter(this);
dateTimeRangeV1.DateRangePeriodMode = DateRangeMode.Reduce;
dateTimeRangeV1.InitSelectedIndex = GlobalVariable.DateRangeSelectedIndex;
#region BudgetItem
var rpsAccountNumberView = new GridView();
rpsAccountNumberView.OptionsView.ColumnAutoWidth = false;
var rpsAccountNumber = new RepositoryItemGridLookUpEdit
{
NullText = "",
View = rpsAccountNumberView,
TextEditStyle = TextEditStyles.Standard,
PopupResizeMode = ResizeMode.FrameResize,
PopupFormSize = new Size(500, 200),
ShowFooter = false
};
rpsAccountNumber.View.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never;
rpsAccountNumber.View.OptionsView.ShowIndicator = false;
#endregion
}
private void TypeLookUp_SizeChanged(object sender, EventArgs e)
{
GridLookUpEdit editor = (GridLookUpEdit)sender;
RepositoryItemGridLookUpEdit properties = editor.Properties;
properties.PopupFormSize = new Size(editor.Width, properties.PopupFormSize.Height);
}
public void AddEvent()
{
gcMain = data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl;
gvMain = gcMain.MainView as GridView;
riCode = gcMain.RepositoryItems["Code"] as RepositoryItemGridLookUpEdit;
riCode.CloseUp += new DevExpress.XtraEditors.Controls.CloseUpEventHandler(riCode_CloseUp);
}
public void AddEvent()
{
//bổ sung chọn địa chỉ giao hàng, người liên hệ và số điện thoại
cbeDCGH = data.FrmMain.Controls.Find("NguoiLH", true)[0] as ComboBoxEdit;
cbeNLH = data.FrmMain.Controls.Find("NLH", true)[0] as ComboBoxEdit;
cbeDT = data.FrmMain.Controls.Find("SDTNL", true)[0] as ComboBoxEdit;
cbeDCGH.QueryPopUp += new System.ComponentModel.CancelEventHandler(cbeDCGH_QueryPopUp);
cbeNLH.QueryPopUp += new System.ComponentModel.CancelEventHandler(cbeNLH_QueryPopUp);
cbeNLH.EditValueChanged += new EventHandler(cbeNLH_EditValueChanged);
gluKH = data.FrmMain.Controls.Find("MaKH", true)[0] as GridLookUpEdit;
//gluKH.CloseUp += new DevExpress.XtraEditors.Controls.CloseUpEventHandler(gluKH_CloseUp);
gcMain = data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl;
gvMain = gcMain.MainView as GridView;
RepositoryItemGridLookUpEdit gluDVT = gcMain.RepositoryItems["MaDVT"] as RepositoryItemGridLookUpEdit;
gluDVT.QueryCloseUp += new System.ComponentModel.CancelEventHandler(gluDVT_QueryCloseUp);
gvMain.FocusedColumnChanged += new DevExpress.XtraGrid.Views.Base.FocusedColumnChangedEventHandler(gvMain_FocusedColumnChanged);
data.BsMain.DataSourceChanged += new EventHandler(BsMain_DataSourceChanged);
BsMain_DataSourceChanged(data.BsMain, new EventArgs());
//them chuc nang Lam tron tien
LayoutControl lcMain = data.FrmMain.Controls.Find("lcMain", true)[0] as LayoutControl;
SimpleButton btnLamTron = new SimpleButton();
btnLamTron.Name = "btnLamTron"; //phai co name cua control
btnLamTron.Text = "Làm tròn";
LayoutControlItem lci = lcMain.AddItem("", btnLamTron);
lci.Name = "cusLamTron"; //phai co name cua item, bat buoc phai co "cus" phai truoc
btnLamTron.Click += new EventHandler(btnLamTron_Click);
}
public static void InitCachingPresentControls( )
{
CachingGridViews.Clear();
ReposityGridLookupEdits.Clear();
ReposityLookupEdits.Clear();
foreach (String strTableName in DataConfigProvider.TableConfigList.Keys)
{
DataConfigProvider.TableConfig config = DataConfigProvider.TableConfigList[strTableName];
if (config.IsCaching && DataStructureProvider.IsSystemTable(strTableName) == false)
{
//RepositoryLookUpEdit
GetDefaultRepositoryLookUpEdit(strTableName, false);
}
}
foreach (String strTableName in DataConfigProvider.TableConfigList.Keys)
{
DataConfigProvider.TableConfig config = DataConfigProvider.TableConfigList[strTableName];
if (config.IsCaching)
{
//GridView
GridView view = GetDefaultGridView(strTableName);
//RepositoryGridLookupEdit
RepositoryItemGridLookUpEdit repoLookupEdit = GetDefaultRepositoryGridLookupEdit(strTableName, false);
repoLookupEdit.View = view;
}
}
}
private void GetLookUpData()
{
string table = _data.DrTableMaster["TableName"].ToString();
if ((table == "MT24" || table == "MT32") && gvVat.Columns["MaVT"] != null && gvVat.Columns["MaVT"].ColumnEdit != null)
{
RepositoryItemGridLookUpEdit riGlu = gvVat.Columns["MaVT"].ColumnEdit as RepositoryItemGridLookUpEdit;
CDTData data = (riGlu.Tag as GrdSingle).Data;
//CDTData data = riGlu.Tag as CDTData;
if (data.FullData)
{
return;
}
data.GetData();
data.FullData = true;
BindingSource bs = riGlu.DataSource as BindingSource;
bs.DataSource = data.DsData.Tables[0];
}
if ((table.Contains("MT1") || table == "MT51") && gvVat.Columns["MaKH"] != null && gvVat.Columns["MaKH"].ColumnEdit != null)
{
RepositoryItemGridLookUpEdit riGlu = gvVat.Columns["MaKH"].ColumnEdit as RepositoryItemGridLookUpEdit;
CDTData data = (riGlu.Tag as GrdSingle).Data;
//CDTData data = riGlu.Tag as CDTData;
if (data.FullData)
{
return;
}
data.GetData();
data.FullData = true;
BindingSource bs = riGlu.DataSource as BindingSource;
bs.DataSource = data.DsData.Tables[0];
}
}
public void AddEvent()
{
isVay = _data.DrTable.Table.Columns.Contains("ExtraSql") && _data.DrTable["ExtraSql"].ToString().ToLower().Contains("isvay = 1");
gvMain = (_data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl).MainView as GridView;
RepositoryItemGridLookUpEdit gluLT = gvMain.GridControl.RepositoryItems["LoaiThu"] as RepositoryItemGridLookUpEdit;
gluLT.Popup += new EventHandler(gluLC_Popup);
cbePX = (_data.FrmMain.Controls.Find("PhanXuong", true)[0] as ComboBoxEdit);
gluLT.View.ColumnFilterChanged += new EventHandler(View_ColumnFilterChanged);
cbePX.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(cbe_EditValueChanging);
//thêm nút chọn DH
lcMain = _data.FrmMain.Controls.Find("lcMain", true)[0] as LayoutControl;
if (!isVay)
{
SimpleButton btnChon = new SimpleButton();
btnChon.Name = "btnChon";
btnChon.Text = "Chọn khách hàng";
LayoutControlItem lci = lcMain.AddItem("", btnChon);
lci.Name = "cusChon";
btnChon.Click += new EventHandler(btnChon_Click);
}
_data.FrmMain.Shown += new EventHandler(FrmMain_Shown);
_data.BsMain.DataSourceChanged += new EventHandler(BsMain_DataSourceChanged);
BsMain_DataSourceChanged(_data.BsMain, new EventArgs());
}
private void FilterDMCN(GridLookUpEdit gluDMCN)
{
if (!_data.DrTable.Table.Columns.Contains("ExtraSQL"))
{
return;
}
string filter = _data.DrTable["ExtraSQL"].ToString();
RepositoryItemGridLookUpEdit ri = gluDMCN.Properties;
if ((ri.Tag as GrdSingle) != null)
{
CDTData data = (ri.Tag as GrdSingle).Data;
if (data.FullData)
{
return;
}
if (data.Condition != string.Empty)
{
data.Condition = data.Condition + " and " + filter;
}
else
{
data.Condition = filter;
}
data.GetData();
data.FullData = true;
BindingSource bs = ri.DataSource as BindingSource;
bs.DataSource = data.DsData.Tables[0];
ri.View.BestFitColumns();
}
}
protected override void InitControls()
{
grdDetail.ForceInitialize();
RepositorySalaryRatio = new RepositoryItemCalcEdit();
RepositoryAmount = new RepositoryItemCalcEdit();
RepositoryPayItemId = new RepositoryItemGridLookUpEdit();
RepositorySalaryRatio.Mask.MaskType = MaskType.Numeric;
RepositorySalaryRatio.Mask.EditMask = @"f" + _dbOptionHelper.ExchangeRateDecimalDigits;
RepositorySalaryRatio.Mask.UseMaskAsDisplayFormat = true;
RepositoryAmount.Mask.MaskType = MaskType.Numeric;
RepositoryAmount.Mask.EditMask = @"c" + int.Parse(_dbOptionHelper.CurrencyDecimalDigits);
RepositoryAmount.Mask.Culture = new CultureInfo("vi-VN")
{
NumberFormat =
{
CurrencySymbol = _dbOptionHelper.CurrencySymbol,
CurrencyDecimalSeparator = _dbOptionHelper.CurrencyDecimalSeparator,
CurrencyGroupSeparator = _dbOptionHelper.CurrencyGroupSeparator,
CurrencyDecimalDigits = int.Parse(_dbOptionHelper.CurrencyDecimalDigits)
}
};
RepositoryAmount.Mask.UseMaskAsDisplayFormat = true;
RepositoryPayItemId.NullText = ResourceHelper.GetResourceValueByName("ResRepositoryControlPayItemID");
}
/// <summary>
/// 新的下拉菜单
/// </summary>
/// <param name="ykgridLookUp"></param>
/// <param name="displayName"></param>
/// <param name="valueName"></param>
public virtual void SetGridLookUpEdit(RepositoryItemGridLookUpEdit ykgridLookUp, List <InputItem> listData, int inputitemCount = 1)
{
ykgridLookUp.View.Columns.Clear();
ykgridLookUp.DataSource = listData.OrderBy(a => a.Value).ToList();
//初始化一些状态
GridColumn col1 = ykgridLookUp.View.Columns.AddField("DisPlayName");
col1.VisibleIndex = 0;
col1.Caption = "描述";
for (int i = 1; i <= inputitemCount; i++)
{
GridColumn col = ykgridLookUp.View.Columns.AddField("InputCode" + i);
col.VisibleIndex = i;
col.Caption = "代号" + i;
}
ykgridLookUp.NullText = "";
ykgridLookUp.View.OptionsBehavior.AutoPopulateColumns = false;
ykgridLookUp.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
ykgridLookUp.View.BestFitColumns();
ykgridLookUp.ShowFooter = true;
ykgridLookUp.View.OptionsView.ShowAutoFilterRow = false;
ykgridLookUp.AutoComplete = false;
ykgridLookUp.ImmediatePopup = true;
ykgridLookUp.PopupFilterMode = PopupFilterMode.Contains;
ykgridLookUp.TextEditStyle = TextEditStyles.Standard;
ykgridLookUp.DisplayMember = "DisPlayName";
ykgridLookUp.ValueMember = "Value";
ykgridLookUp.View.BestFitColumns();
ykgridLookUp.BestFitMode = BestFitMode.BestFitResizePopup;
ykgridLookUp.EditValueChanging += ykgridLookUp_EditValueChanging;
}
protected virtual void Attach(RepositoryItemGridLookUpEdit rep)
{
if (rep == null)
{
return;
}
selection.Clear();
_currentRepository = rep;
edit = _currentRepository.View.GridControl.RepositoryItems.Add("CheckEdit") as RepositoryItemCheckEdit;
GridColumn column = _currentRepository.View.Columns.Add();
column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
column.Visible = true;
column.VisibleIndex = 0;
column.FieldName = checkColumnFieldName;
column.Caption = "Mark";
column.OptionsColumn.ShowCaption = false;
column.OptionsColumn.AllowEdit = false;
column.OptionsColumn.AllowSize = false;
column.UnboundType = DevExpress.Data.UnboundColumnType.Boolean;
column.Width = GetCheckBoxWidth();
column.ColumnEdit = edit;
_currentRepository.View.Click += new EventHandler(View_Click);
_currentRepository.View.CustomDrawColumnHeader += new ColumnHeaderCustomDrawEventHandler(View_CustomDrawColumnHeader);
_currentRepository.View.CustomDrawGroupRow += new RowObjectCustomDrawEventHandler(View_CustomDrawGroupRow);
_currentRepository.View.CustomUnboundColumnData += new CustomColumnDataEventHandler(view_CustomUnboundColumnData);
_currentRepository.View.KeyDown += new KeyEventHandler(view_KeyDown);
}
/// <summary>
/// Loads the data into grid.
/// </summary>
protected void LoadDataIntoGrid()
{
IList <ActionForm> dataSource = new List <ActionForm>();
dataSource.Add(new ActionForm(1, "Thêm mới"));
dataSource.Add(new ActionForm(2, "Sửa"));
dataSource.Add(new ActionForm(3, "Xóa"));
dataSource.Add(new ActionForm(4, "Xem"));
dataSource.Add(new ActionForm(5, "Nhân bản"));
dataSource.Add(new ActionForm(6, "In"));
dataSource.Add(new ActionForm(7, "Đăng nhập"));
dataSource.Add(new ActionForm(8, "Đăng xuất"));
_rsActionView = new GridView();
_rsActionView.OptionsView.ColumnAutoWidth = false;
_rsAction = new RepositoryItemGridLookUpEdit
{
NullText = "",
View = _rsActionView,
TextEditStyle = TextEditStyles.Standard,
};
_rsAction.View.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never;
_rsAction.View.OptionsView.ShowIndicator = false;
_rsAction.PopupFormSize = new Size(10, 150);
_rsAction.View.BestFitColumns();
_rsAction.DataSource = dataSource;
_rsActionView.PopulateColumns(dataSource);
var gridColumnsCollection = new List <XtraColumn>();
gridColumnsCollection.Add(new XtraColumn
{
ColumnName = "Id",
ColumnCaption = "Mã nguồn vốn",
ColumnVisible = false,
ColumnPosition = 1
});
gridColumnsCollection.Add(new XtraColumn
{
ColumnName = "Name",
ColumnCaption = "Thao tác",
ColumnVisible = true,
ColumnWith = 180,
ColumnPosition = 2
});
XtraColumnCollectionHelper <ActionForm> .ShowXtraColumnInGridView(gridColumnsCollection, _rsActionView);
_rsAction.DataSource = dataSource;
_rsAction.DisplayMember = "Name";
_rsAction.ValueMember = "Id";
_audittingLogsPresenter.Display();
_refTypesPresenter.Display();
_userProfilesPresenter.Display();
}
public void AddRepositoryGridLookupEdit(RepositoryItemGridLookUpEdit gridlookup)
{
DataTable dataTable = new DataTable();
gridlookup.DataSource = this.GetList();
gridlookup.DisplayMember = "MachineName";
gridlookup.ValueMember = "MachineCode";
}
public void AddRepositoryGridLookupEdit(RepositoryItemGridLookUpEdit gridlookup)
{
DataTable dataTable = new DataTable();
gridlookup.DataSource = this.GetList();
gridlookup.DisplayMember = "TimeKeeperTableListName";
gridlookup.ValueMember = "TimeKeeperTableListID";
}
/// <summary>
/// Initializes a new instance of the <see cref="UserControlOutputInventoryList"/> class.
/// </summary>
public UserControlOutputInventoryList()
{
InitializeComponent();
_rpsInventoryItem = new RepositoryItemGridLookUpEdit();
_inventoryItemsPresenter = new InventoryItemsPresenter(this);
_outputInventoriesPresenter = new OutputInventoriesPresenter(this);
_voucherTypesPresenter = new VoucherTypesPresenter(this);
}
public void AddRepositoryGridLookup(RepositoryItemGridLookUpEdit grlookup)
{
DataTable dataTable = new DataTable();
grlookup.DataSource = this.GetList();
grlookup.DisplayMember = "RelativeName";
grlookup.ValueMember = "RelativeName";
}
public void AddRepositoryGridLookupEdit(Guid SalaryTableListID, RepositoryItemGridLookUpEdit gridlookup)
{
DataTable dataTable = new DataTable();
gridlookup.DataSource = this.GetList(SalaryTableListID);
gridlookup.DisplayMember = "DeductionName";
gridlookup.ValueMember = "DeductionCode";
}
public TypeConverterHelper(RepositoryItemGridLookUpEdit edit, string unboundColumnFieldName,
string convertedProperty)
{
this.edit = edit;
this.unboundColumnFieldName = unboundColumnFieldName;
this.convertedProperty = convertedProperty;
CreateUnboundColumn(edit.View, unboundColumnFieldName);
}
public override void applyRetrievedAttribute(IDataBindingSource src, FieldRetrievedEventArgs e)
{
RepositoryItemGridLookUpEdit rle = e.RepositoryItem as RepositoryItemGridLookUpEdit;
src.EditorsHost.onSetupLookUpGridEventData(this, new SetupLookUpGridEventData {
FieldName = e.FieldName, DataBindingSource = src, Rle = rle
});
setupRle(src, rle, e.FieldName);
}
public override void applyCustomRowCellEdit(IDataBindingSource src, CustomRowCellEditEventArgs e)
{
RepositoryItemGridLookUpEdit rle = e.RepositoryItem as RepositoryItemGridLookUpEdit;
rle.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
src.EditorsHost.onSetupLookUpGridEventData(this, new SetupLookUpGridEventData {
FieldName = e.Column.FieldName, DataBindingSource = src, Rle = rle
});
}
public void SetReposGridLookUpEdit(RepositoryItemGridLookUpEdit ykgridLookUp, string displayName, string valueName)
{
ykgridLookUp.DisplayMember = displayName;
ykgridLookUp.ValueMember = valueName;
ykgridLookUp.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
ykgridLookUp.ImmediatePopup = true;
ykgridLookUp.View.OptionsView.ShowColumnHeaders = false;
ykgridLookUp.NullText = "";
}
public void AddEvent()
{
_isBanSP = _data.DrTable.Table.Columns.Contains("ExtraSql") && _data.DrTable["ExtraSql"].ToString().Contains("IsBanSP = 1");
_data.BsMain.DataSourceChanged += new EventHandler(BsMain_DataSourceChanged);
BsMain_DataSourceChanged(_data.BsMain, new EventArgs());
GridControl gcMain = (_data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl);
RepositoryItemGridLookUpEdit glu = gcMain.RepositoryItems["MaSP"] as RepositoryItemGridLookUpEdit;
glu.Popup += new EventHandler(glu_Popup);
}
public BookFilterEditor(TCommonFireBirdDB db)
{
if (db == null)
{
throw new ArgumentNullException("db");
}
InitializeComponent();
firstActivate = true;
database = db;
FilterColumnCollection columnCollection = new FilterColumnCollection();
genreEditor = new RepositoryItemGridLookUpEdit();
genreEditor.ValueMember = "Name";
genreEditor.DisplayMember = "Name";
genreEditor.ViewType = GridLookUpViewType.Default;
GridColumn genreNameColumn = new GridColumn();
genreNameColumn.Caption = "Name";
genreNameColumn.FieldName = "Name";
genreNameColumn.VisibleIndex = 0;
GridColumn genreDescColumn = new GridColumn();
genreDescColumn.Caption = "Description";
genreDescColumn.FieldName = "RuDescription";
genreDescColumn.VisibleIndex = 1;
genreEditor.View.Columns.Add(genreNameColumn);
genreEditor.View.Columns.Add(genreDescColumn);
columnCollection.Add(new UnboundFilterColumn("Genre", "Genres", typeof(string), this.genreEditor, FilterColumnClauseClass.String));
columnCollection.Add(new UnboundFilterColumn("Language", "Lang", typeof(string), new RepositoryItemComboBox(), FilterColumnClauseClass.String));
columnCollection.Add(new UnboundFilterColumn("Source Language", "SrcLang", typeof(string), new RepositoryItemComboBox(), FilterColumnClauseClass.String));
columnCollection.Add(new UnboundFilterColumn("Book Author", "BookAuthors", typeof(string), new RepositoryItemComboBox(), FilterColumnClauseClass.String));
this.filterControl.SetFilterColumnsCollection(columnCollection);
}
protected virtual void Attach(RepositoryItemGridLookUpEdit rep)
{
if (rep == null) return;
selection.Clear();
_currentRepository = rep;
edit = _currentRepository.View.GridControl.RepositoryItems.Add("CheckEdit") as RepositoryItemCheckEdit;
GridColumn column = _currentRepository.View.Columns.Add();
column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
column.Visible = true;
column.VisibleIndex = 0;
column.FieldName = checkColumnFieldName;
column.Caption = "Mark";
column.OptionsColumn.ShowCaption = false;
column.OptionsColumn.AllowEdit = false;
column.OptionsColumn.AllowSize = false;
column.UnboundType = DevExpress.Data.UnboundColumnType.Boolean;
column.Width = GetCheckBoxWidth();
column.ColumnEdit = edit;
_currentRepository.View.Click += new EventHandler(View_Click);
_currentRepository.View.CustomDrawColumnHeader += new ColumnHeaderCustomDrawEventHandler(View_CustomDrawColumnHeader);
_currentRepository.View.CustomDrawGroupRow += new RowObjectCustomDrawEventHandler(View_CustomDrawGroupRow);
_currentRepository.View.CustomUnboundColumnData += new CustomColumnDataEventHandler(view_CustomUnboundColumnData);
_currentRepository.View.KeyDown += new KeyEventHandler(view_KeyDown);
}
/// <summary>
/// 绑定表格数据
/// </summary>
/// <param name="dbgrid">显示数据的表格</param>
/// <param name="tab">数据表</param>
public void BindGrid(GridControl dbgrid, DataTable tab)
{
if (null == dbgrid || null == tab)
return;
GridView gridview = (GridView)dbgrid.MainView;
dbgrid.DataSource = tab;
gridview.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gridview_CellValueChanged);
DataColumnCollection dbcols = tab.Columns;
if (null != gridview.Columns["ID"])
gridview.Columns["ID"].Visible = false;
foreach (DataColumn dbcol in dbcols)
{
//设置表格字典
GridColumn gdcol = gridview.Columns.ColumnByFieldName(dbcol.ColumnName);
if (null == gdcol)
gdcol = gridview.Columns.ColumnByName(dbcol.ColumnName);
if (null == gdcol)
continue;
string src = Convert.ToString(dbcol.ExtendedProperties[BindManager.srcpro]);
string txt = Convert.ToString(dbcol.ExtendedProperties[BindManager.txtpro]);
string val = Convert.ToString(dbcol.ExtendedProperties[BindManager.valpro]);
txt = string.IsNullOrEmpty(txt) ? val : txt;
val = string.IsNullOrEmpty(val) ? txt : val;
if (BindManager.regexSQL.IsMatch(src))
src = dbcol.ColumnName;
if (null != tab.DataSet && !string.IsNullOrEmpty(src) && !string.IsNullOrEmpty(txt) && !string.IsNullOrEmpty(val)
&& tab.DataSet.Tables.Contains(src))
{
DataTable tabdict = tab.DataSet.Tables[src];
if (tabdict.Columns.Contains(txt) && tabdict.Columns.Contains(val))
{
RepositoryItemGridLookUpEdit ri = new RepositoryItemGridLookUpEdit();
ri.DataSource = tabdict;
//控制下拉的选项哪些可以显示，哪些不可以显示
if (ri.View.Columns.Contains(ri.View.Columns["ID"]))
{
ri.View.Columns["ID"].Visible = false;
}
ri.NullText = "请选择";
ri.DisplayMember = txt;
ri.ValueMember = val;
gdcol.ColumnEdit = ri ;
}
}
//设置列是否可见
if (null != dbcol.ExtendedProperties[BindManager.visipro])
{
bool visible = Convert.ToBoolean(dbcol.ExtendedProperties[BindManager.visipro]);
if (!visible) gdcol.Visible = visible;
}
//设置列是否只读
if (null != dbcol.ExtendedProperties[BindManager.readpro])
{
bool readble = Convert.ToBoolean(dbcol.ExtendedProperties[BindManager.readpro]);
if (readble) gdcol.Visible = readble;
}
}
}
/// <summary>
/// 绑定表格数据并且只根据部门来绑定过滤后的数据
/// </summary>
/// <param name="dbgrid">显示数据的表格</param>
/// <param name="tab">数据表</param>
/// <param name="tag">部门id</param>
private void GetDeptEmployee(GridControl dbgrid, DataTable tab, string tag)
{
if (null == dbgrid || null == tab)
return;
GridView gridview = (GridView)dbgrid.MainView;
DataTable dt = tab.Clone();
if (!dt.Columns.Contains("部门id"))
return;
dt = FunShare.GetTable(dt, tab.Select("部门id='" + tag + "'"));
dbgrid.DataSource = dt;
DataColumnCollection dbcols = tab.Columns;
if (null != gridview.Columns["ID"])
gridview.Columns["ID"].Visible = false;
foreach (DataColumn dbcol in dbcols)
{
//设置表格字典
GridColumn gdcol = gridview.Columns.ColumnByFieldName(dbcol.ColumnName);
if (null == gdcol)
gdcol = gridview.Columns.ColumnByName(dbcol.ColumnName);
if (null == gdcol)
continue;
string src = Convert.ToString(dbcol.ExtendedProperties[srcpro]);
string txt = Convert.ToString(dbcol.ExtendedProperties[txtpro]);
string val = Convert.ToString(dbcol.ExtendedProperties[valpro]);
txt = string.IsNullOrEmpty(txt) ? val : txt;
val = string.IsNullOrEmpty(val) ? txt : val;
src = dbcol.ColumnName;
if (null != tab.DataSet && !string.IsNullOrEmpty(src) && !string.IsNullOrEmpty(txt) && !string.IsNullOrEmpty(val)
&& tab.DataSet.Tables.Contains(src))
{
DataTable tabdict = tab.DataSet.Tables[src];
if (tabdict.Columns.Contains(txt) && tabdict.Columns.Contains(val))
{
RepositoryItemGridLookUpEdit ri = new RepositoryItemGridLookUpEdit();
DataTable dtDict = tabdict.Clone();
if (dtDict.Columns.Contains("id"))
{
dtDict = FunShare.GetTable(dtDict, tabdict.Select("id='" + tag + "'"));
ri.DataSource = dtDict;
}
else
{
ri.DataSource = tabdict;
}
//控制下拉的选项哪些可以显示，哪些不可以显示
if (ri.View.Columns.Contains(ri.View.Columns["ID"]))
{
ri.View.Columns["ID"].Visible = false;
}
ri.NullText = "请选择";
ri.DisplayMember = txt;
ri.ValueMember = val;
gdcol.ColumnEdit = ri;
}
}
}
}
protected virtual void Detach()
{
if (_currentRepository == null) return;
if (edit != null)
{
_currentRepository.View.GridControl.RepositoryItems.Remove(edit);
edit.Dispose();
}
_currentRepository.View.Click -= new EventHandler(View_Click);
_currentRepository.View.CustomDrawColumnHeader -= new ColumnHeaderCustomDrawEventHandler(View_CustomDrawColumnHeader);
_currentRepository.View.CustomDrawGroupRow -= new RowObjectCustomDrawEventHandler(View_CustomDrawGroupRow);
_currentRepository.View.CustomUnboundColumnData -= new CustomColumnDataEventHandler(view_CustomUnboundColumnData);
_currentRepository.View.KeyDown -= new KeyEventHandler(view_KeyDown);
_currentRepository = null;
}
public GridCheckMarksSelection(RepositoryItemGridLookUpEdit repository)
: this()
{
CurrentRepository = repository;
}
