void repFilter_ButtonPressed(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { DataRow dr = ViewFieldConfig.GetDataRow(ViewFieldConfig.FocusedRowHandle); if (dr != null) { STFieldConfigsInfo configInfo = (STFieldConfigsInfo) new STFieldConfigsController().GetObjectFromDataRow(dr); if (configInfo != null) { if (DataStructureProvider.IsForeignKey(configInfo.TableName, configInfo.FieldName)) { String strPKTableName = DataStructureProvider.GetTableNameOfForeignKey(configInfo.TableName, configInfo.FieldName); ABCCommonForms.FilterBuilderForm filterBuilder = new ABCCommonForms.FilterBuilderForm(strPKTableName); String strOldValue = ViewFieldConfig.GetRowCellValue(ViewFieldConfig.FocusedRowHandle, "FilterString").ToString(); filterBuilder.SetFilterString(strOldValue); if (filterBuilder.ShowDialog() == DialogResult.OK) { ViewFieldConfig.SetRowCellValue(ViewFieldConfig.FocusedRowHandle, "FilterString", filterBuilder.FilterString); } } } } }
protected override DevExpress.XtraEditors.Controls.ConvertEditValueEventArgs DoFormatEditValue(object val) { object objValue = val; if (objValue != null && objValue != DBNull.Value) { if (this.OwnerEdit != null) { ABCTextEdit textEdit = (this.OwnerEdit as ABCTextEdit); String strDataMember = textEdit.DataMember; if (DataStructureProvider.IsForeignKey(textEdit.TableName, textEdit.DataMember)) { strDataMember = textEdit.DataMember + ":" + DataStructureProvider.GetDisplayColumn(textEdit.TableName); } if (textEdit.BindingManager.Position >= 0 && textEdit.BindingManager.Current != null && textEdit.BindingManager.Current is ABCBusinessEntities.BusinessObject) { if (strDataMember.Contains(":") && objValue is Guid && ABCHelper.DataConverter.ConvertToGuid(objValue) != Guid.Empty) { ABCBusinessEntities.BusinessObject objBinds = textEdit.BindingManager.Current as ABCBusinessEntities.BusinessObject; objValue = DataCachingProvider.GetCachingObjectAccrossTable(objBinds, ABCHelper.DataConverter.ConvertToGuid(objValue), strDataMember); } } } } return(base.DoFormatEditValue(objValue)); }
public static bool SetAutoValue(BusinessObject obj) { bool isModified = false; #region Edit Count if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colEditCount)) { int iCount = -1; object objCount = ABCDynamicInvoker.GetValue(obj, ABCCommon.ABCConstString.colEditCount); if (objCount != null && objCount != DBNull.Value) { iCount = Convert.ToInt32(objCount); } iCount++; object objOldValue = ABCDynamicInvoker.GetValue(obj, ABCCommon.ABCConstString.colEditCount); ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colEditCount, iCount); if (Convert.ToInt32(objOldValue) != iCount) { isModified = true; } } #endregion isModified = isModified || CurrencyProvider.GenerateCurrencyValue(obj); return(isModified); }
public static Type GetBusinessObjectType(String strTableName) { String strBusName = strTableName + "Info"; Type type = null; if (CachingBusinessObjectType.TryGetValue(strBusName, out type) == false) { try { if (DataStructureProvider.IsSystemTable(strTableName)) { Assembly assEntities = Assembly.LoadFrom(Application.StartupPath + "\\BaseObjects.dll"); type = assEntities.GetType("ABCBusinessEntities." + strBusName); } else { Assembly assEntities = Assembly.LoadFrom(Application.StartupPath + "\\BusinessObjects.dll"); type = assEntities.GetType("ABCBusinessEntities." + strBusName); } if (type != null) { CachingBusinessObjectType.Add(strBusName, type); } } catch (Exception) { } } return(type); }
public static void InitDefaultRepositoryLookupEdit(String strTableName, ABCRepositoryLookUpEdit repo) { DataConfigProvider.TableConfig config = DataConfigProvider.TableConfigList[strTableName]; #region Columns foreach (String strField in config.FieldConfigList.Keys) { if (config.FieldConfigList[strField].InUse && config.FieldConfigList[strField].IsDefault) { DevExpress.XtraEditors.Controls.LookUpColumnInfo col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo(); col.FieldName = strField; col.Caption = DataConfigProvider.GetFieldCaption(strTableName, strField); col.Visible = true; repo.Columns.Add(col); } } #endregion repo.ValueMember = DataStructureProvider.DataTablesList[strTableName].PrimaryColumn; repo.DisplayMember = DataStructureProvider.GetDisplayColumn(strTableName); if (String.IsNullOrWhiteSpace(repo.DisplayMember) && repo.Columns.Count > 0) { repo.DisplayMember = repo.Columns[0].FieldName; } repo.BestFit(); }
public void UpdateObject(BusinessObject obj) { if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colSelected)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colSelected, false); } if (String.IsNullOrWhiteSpace(ABCBaseUserProvider.CurrentUserName) == false && DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colUpdateUser)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colUpdateUser, ABCBaseUserProvider.CurrentUserName); } if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colUpdateTime)) { ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colUpdateTime, ABCApp.ABCDataGlobal.WorkingDate); } BusinessObjectHelper.GenerateNoColumn(obj, false); if (DatabaseHelper.IsSQLConnection()) { (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.Update, TableName), obj); } else { DatabaseHelper.RunScript(QueryTemplateGenerator.GenUpdate(TableName), obj); } }
public static void InitDefaultRepositoryGridLookUpEdit(String strTableName, ABCRepositoryGridLookupEdit repo, Boolean isCreateNewView) { ABCGridView view; if (isCreateNewView) { view = new ABCGridView(strTableName); InitDefaultColumns(strTableName, view); } else { view = GetDefaultGridView(strTableName); } repo.View = view; repo.ValueMember = DataStructureProvider.GetPrimaryKeyColumn(strTableName); String strDisplayCol = DataStructureProvider.GetDisplayColumn(strTableName); if (String.IsNullOrWhiteSpace(strDisplayCol)) { strDisplayCol = repo.ValueMember; } repo.DisplayMember = strDisplayCol; if (view.Columns.Count <= 7) { repo.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; } else { repo.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit; repo.PopupFormSize = new System.Drawing.Size(700, 400); } }
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; } } }
public void UpdateFieldName(ABCCommonTreeListNode obj) { if (obj == null || obj.InnerData == null) { return; } if (obj.ParentNode != null) { ABCCommonTreeListNode objparent = obj.ParentNode; ABCBindingConfig currentBind = (ABCBindingConfig)obj.InnerData; ABCBindingConfig parentBind = (ABCBindingConfig)objparent.InnerData; if (currentBind != null && parentBind != null) { if (currentBind.ParentName != parentBind.TableName || (currentBind.ParentName == parentBind.TableName && (String.IsNullOrWhiteSpace(currentBind.ParentField) || String.IsNullOrWhiteSpace(currentBind.ChildField)))) { if (DataStructureProvider.IsExistedTable(parentBind.TableName)) { currentBind.ParentField = DataStructureProvider.GetPrimaryKeyColumn(parentBind.TableName); } if (DataStructureProvider.IsExistedTable(currentBind.TableName)) { currentBind.ChildField = DataStructureProvider.GetTable(currentBind.TableName).GetForeignKeyOfTableName(parentBind.TableName); } } currentBind.ParentName = parentBind.Name; } } //foreach ( TreeListNode nodeChild in node.Nodes ) // UpdateFieldName( nodeChild ); }
public void ExpandForeignNode(ABCCommonTreeListNode node) { FieldNodeInfo fieldInfo = (FieldNodeInfo)node.InnerData; if (fieldInfo == null) { return; } String[] strArr = fieldInfo.FieldName.Split(':'); if (strArr.Length <= 0) { return; } String strFK = strArr[strArr.Length - 1]; String strTableName = DataStructureProvider.GetTableNameOfForeignKey(fieldInfo.TableName, strFK); if (DataStructureProvider.DataTablesList.ContainsKey(strTableName) == false) { return; } foreach (String strFieldName in DataStructureProvider.DataTablesList[strTableName].ColumnsList.Keys) { InitField(node, strTableName, strFieldName); } }
private void InitField(ABCCommonTreeListNode parentNode, String strTableName, String strFieldName) { ABCScreen.ABCBindingConfig bindInfo = ((FieldNodeInfo)parentNode.InnerData).Config; String strDiplay = DataConfigProvider.GetFieldCaption(strTableName, strFieldName); if (strDiplay == strFieldName) { return; } FieldNodeInfo fieldInfo = new FieldNodeInfo(); fieldInfo.Display = strDiplay; fieldInfo.Type = FiledNodeType.Field; fieldInfo.Config = bindInfo; if (String.IsNullOrWhiteSpace(((FieldNodeInfo)parentNode.InnerData).FieldName) == false) { fieldInfo.FieldName = ((FieldNodeInfo)parentNode.InnerData).FieldName + ":"; } fieldInfo.FieldName += strFieldName; fieldInfo.TableName = strTableName; ABCCommonTreeListNode node = new ABCCommonTreeListNode(parentNode, fieldInfo); InitControls(node); if (DataStructureProvider.IsForeignKey(strTableName, strFieldName)) { fieldInfo.Type = FiledNodeType.Foreign; } }
public static String GetLabelCaption(String strTableName, String strDataMember) { if (string.IsNullOrWhiteSpace(strDataMember) || String.IsNullOrWhiteSpace(strTableName)) { return(String.Empty); } if (strDataMember.Contains(":") == false) { return(DataConfigProvider.GetFieldCaption(strTableName, strDataMember)); } String strCurrentTableName = strTableName; String[] strArray = strDataMember.Split(':'); foreach (String strCurrentField in strArray) { if (DataStructureProvider.IsForeignKey(strCurrentTableName, strCurrentField)) { strCurrentTableName = DataStructureProvider.GetTableNameOfForeignKey(strCurrentTableName, strCurrentField); } else { return(DataConfigProvider.GetFieldCaption(strCurrentTableName, strCurrentField)); } } return(String.Empty); }
public void AddComment(String strTableName, Guid iID, String strComment) { if (String.IsNullOrWhiteSpace(strComment)) { return; } if (DataStructureProvider.IsExistedTable(strTableName) == false) { return; } if (BusinessControllerFactory.GetBusinessController(strTableName).GetObjectByID(iID) == null) { return; } RefreshTagsString(); String strCreateUser = ABCUserProvider.CurrentUserName.Replace("'", "''"); String strCreateEmployee = ABCUserProvider.CurrentEmployeeName.Replace("'", "''"); String strQuery = String.Format(@"INSERT INTO GEComments ( GECommentID,CreateTime , CreateUser , Employee , TableName , ID ,Comment,TagString,TagStringDisplay ) VALUES ('{0}',GetDate() ,N'{1}' ,N'{2}' ,'{3}','{4}',N'{5}',N'{6}',N'{7}')", Guid.NewGuid(), strCreateUser.Replace("'", "''"), strCreateEmployee.Replace("'", "''"), strTableName, iID, strComment.Replace("'", "''"), Tags.Replace("'", "''"), TagsDisplay.Replace("'", "''")); BusinessObjectController.RunQuery(strQuery); NotifyProvider.CreateNewNotifyFromComment(strTableName, iID); LoadComments(); this.gridView.MoveLast(); this.richEditControl1.Text = ""; this.tabPanel.ClearTags(); }
void Menu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (e.Item.Tag != null && e.Item.Tag.ToString() == "New") { TableChooserForm form = new TableChooserForm(); String strTableName = form.ShowChooseOne(); if (form.DialogResult == DialogResult.Cancel) { return; } if (DataStructureProvider.IsExistedTable(strTableName) == false) { return; } TreeConfigData configData = new TreeConfigData(); configData.Name = "objNew" + this.Manager.ConfigList.Count; configData.DefaultLoad = true; configData.TableName = strTableName; configData.ColumnFieldNames = new Dictionary <string, string>(); TreeConfigNode obj = (TreeConfigNode)DataConfigTreeCtrl.GetDataRecordByNode(DataConfigTreeCtrl.FocusedNode); if (obj == null) { new TreeConfigNode(Manager.RootConfig, configData); } else { configData.ParentTableName = obj.InnerData.TableName; configData.ParentField = DataStructureProvider.GetPrimaryKeyColumn(obj.InnerData.TableName); configData.ChildField = DataStructureProvider.GetForeignKeyOfTableName(configData.TableName, obj.InnerData.TableName); new TreeConfigNode(obj, configData); } UpdateDataConfigs(); RefreshDataConfigTree(); } if (e.Item.Tag != null && e.Item.Tag.ToString() == "Delete") { TreeConfigNode obj = (TreeConfigNode)DataConfigTreeCtrl.GetDataRecordByNode(DataConfigTreeCtrl.FocusedNode); if (obj == null || (TreeConfigData)obj.InnerData == null) { return; } DialogResult result = ABCHelper.ABCMessageBox.Show("Do you want to delete selected Object ? ", "Delete Object", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { obj.ParentNode.ChildrenNodes.Remove(obj.InnerData.Name); obj.ParentNode = null; UpdateDataConfigs(); RefreshDataConfigTree(); } } }
public override object EditValue(ITypeDescriptorContext context, System.IServiceProvider provider, object value) { IWindowsFormsEditorService svc = null; if (provider != null) { svc = (IWindowsFormsEditorService)provider.GetService(typeof(IWindowsFormsEditorService)); } if (svc != null) { String strTableName = String.Empty; if ((context as DevExpress.XtraVerticalGrid.Data.DescriptorContext).FieldName == "FilterCondition" && context.Instance.GetType().FullName == typeof(ABCScreen.ABCBindingConfig).FullName) { //if ( Convert.ToBoolean( context.Instance.GetType().GetProperty( "IsList" ).GetValue( context.Instance , null ) )==false ) //{ // ABCHelper.ABCMessageBox.Show( "Please set IsList = true before use this function." ); // return value; //} strTableName = context.Instance.GetType().GetProperty("TableName").GetValue(context.Instance, null).ToString(); } if ((context as DevExpress.XtraVerticalGrid.Data.DescriptorContext).FieldName.EndsWith("Editor.FilterStringEx") && context.Instance.GetType().FullName.EndsWith("LookUpEdit")) { strTableName = context.Instance.GetType().GetProperty("TableName").GetValue(context.Instance, null).ToString(); String strFieldName = context.Instance.GetType().GetProperty("DataMember").GetValue(context.Instance, null).ToString(); if (DataStructureProvider.IsForeignKey(strTableName, strFieldName) == false) { return(value); } strTableName = DataStructureProvider.GetTableNameOfForeignKey(strTableName, strFieldName); } if (String.IsNullOrWhiteSpace(strTableName) == false) { using (ABCCommonForms.FilterBuilderForm form = new ABCCommonForms.FilterBuilderForm(strTableName)) { String strOld = String.Empty; if (value != null) { strOld = value.ToString(); } form.SetFilterString(strOld); if (form.ShowDialog() == DialogResult.OK) { value = form.FilterString; } } } } return(value); }
public void InvalidateControl( ) { if (EditControl == null) { #region init String strType = DataStructureProvider.GetCodingType(this.TableName, this.DataMember.Split(':')[0]); if (strType == "String" || strType == "Nullable<String>") { EditControl = (ISearchControl)ABCBusinessEntities.ABCDynamicInvoker.CreateInstanceObject(typeof(ABCTextSearch)); } else if (strType == "bool" || strType == "Nullable<bool>") { EditControl = (ISearchControl)ABCBusinessEntities.ABCDynamicInvoker.CreateInstanceObject(typeof(ABCBoolSearch)); } else if (strType == "DateTime" || strType == "Nullable<DateTime>") { EditControl = (ISearchControl)ABCBusinessEntities.ABCDynamicInvoker.CreateInstanceObject(typeof(ABCDateTimeSearch)); } else if (strType == "int" || strType == "Nullable<int>" || strType == "Guid" || strType == "Nullable<Guid>" || strType == "double" || strType == "Nullable<double>" || strType == "decimal" || strType == "Nullable<decimal>") { if (DataStructureProvider.IsForeignKey(this.TableName, this.DataMember.Split(':')[0]) || DataStructureProvider.IsPrimaryKey(this.TableName, this.DataMember.Split(':')[0])) { EditControl = (ISearchControl)ABCBusinessEntities.ABCDynamicInvoker.CreateInstanceObject(typeof(ABCGridLookUpEditSearch)); } else { EditControl = (ISearchControl)ABCBusinessEntities.ABCDynamicInvoker.CreateInstanceObject(typeof(ABCNumbSearch)); } } if (EditControl != null) { EditControl.GetType().GetProperty("DataMember").SetValue(EditControl, this.DataMember, null); EditControl.GetType().GetProperty("TableName").SetValue(EditControl, this.TableName, null); if (EditControl is ABCGridLookUpEdit) { ((ABCGridLookUpEdit)EditControl).Initialize(OwnerView); } } #endregion } if (EditControl != null) { EditControl.GetType().GetProperty("DataMember").SetValue(EditControl, this.DataMember, null); EditControl.GetType().GetProperty("TableName").SetValue(EditControl, this.TableName, null); EditControl.SetFormatInfo(); this.layoutControl1.Controls.Add((this.EditControl as Control)); this.LayoutItem.Control = (this.EditControl as Control); } UpdateLabelText(); }
public void RefreshDisplayTree( ) { DisplayTreeListCtrl.TableName = this.TableName; DisplayTreeListCtrl.InnerTreeList.Columns.Clear(); DisplayTreeListCtrl.ColumnConfigs = this.ColumnList; DisplayTreeListCtrl.Manager.ConfigList = this.Manager.ConfigList;//new DisplayTreeListCtrl.InitColumns(); #region Script if (String.IsNullOrWhiteSpace(this.TableName)) { if (String.IsNullOrWhiteSpace(Script) == false) { DataSet ds = DataQueryProvider.RunQuery(Script); if (ds != null && ds.Tables.Count > 0) { Manager.Invalidate(ds); DisplayTreeListCtrl.InnerTreeList.ColumnsCustomization(); } } return; } #endregion if (DataCachingProvider.LookupTables.ContainsKey(this.TableName)) { Manager.Invalidate(DataCachingProvider.LookupTables[this.TableName]); } else { ABCHelper.ConditionBuilder strBuilder = new ABCHelper.ConditionBuilder(); strBuilder.Append(String.Format(@"SELECT TOP 5 * FROM {0} ", this.TableName)); if (DataStructureProvider.IsExistABCStatus(this.TableName)) { strBuilder.AddCondition(QueryGenerator.GenerateCondition(this.TableName, ABCCommon.ABCColumnType.ABCStatus)); } strBuilder.Append(String.Format(@" ORDER BY {0} DESC", DataStructureProvider.GetPrimaryKeyColumn(this.TableName))); try { DataSet ds = DataQueryProvider.RunQuery(strBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { this.DisplayTreeListCtrl.InnerTreeList.DataSource = ds.Tables[0]; } } catch (Exception ex) { } } this.DisplayTreeListCtrl.InnerTreeList.RefreshDataSource(); DisplayTreeListCtrl.InnerTreeList.ColumnsCustomization(); }
public static Guid GetIDValue(BusinessObject obj) { if (obj == null) { return(Guid.Empty); } string strPrimaryKeyColumn = DataStructureProvider.GetPrimaryKeyColumn(obj.AATableName); return(ABCHelper.DataConverter.ConvertToGuid(ABCDynamicInvoker.GetValue(obj, strPrimaryKeyColumn))); }
public List <BusinessObject> GetListByColumn(String strFieldName, object objValue) { if (DataStructureProvider.IsTableColumn(TableName, strFieldName) == false) { return(new List <BusinessObject>()); } String strQuery = QueryGenerator.GenSelectByColumn(TableName, strFieldName, objValue, false); return(GetList(strQuery)); }
public static DataSet RunQuery(String strQuery, String strTableName) { if (DataStructureProvider.IsSystemTable(strTableName)) { return(DataQueryProvider.SystemDatabaseHelper.RunQuery(strQuery)); } else { return(DataQueryProvider.CompanyDatabaseHelper.RunQuery(strQuery)); } }
public void RunLink(String strTableName, ViewMode mode, bool isShowDialog, Guid iMainID, ABCScreenAction action) { STViewsInfo viewResult = null; STViewsController viewCtrl = new STViewsController(); String strViewNo = VoucherProvider.GetViewNo(strTableName, iMainID); if (!String.IsNullOrWhiteSpace(strViewNo)) { viewResult = viewCtrl.GetObjectByNo(strViewNo) as STViewsInfo; } if (viewResult == null) { #region Without Voucher BusinessObjectController controller = BusinessControllerFactory.GetBusinessController(strTableName); if (controller == null) { return; } BusinessObject obj = controller.GetObjectByID(iMainID); if (obj == null) { return; } List <BusinessObject> lstViews = viewCtrl.GetListFromDataset(viewCtrl.GetDataSet(String.Format("SELECT * FROM STViews WHERE [MainTableName] = '{0}' ", strTableName))); foreach (STViewsInfo viewIfo in lstViews) { if (String.IsNullOrWhiteSpace(viewIfo.MainFieldName) == false && DataStructureProvider.IsTableColumn(strTableName, viewIfo.MainFieldName)) { object objValue = ABCBusinessEntities.ABCDynamicInvoker.GetValue(obj, viewIfo.MainFieldName); if (objValue != null && objValue.ToString().ToUpper().Trim() == viewIfo.MainValue.ToUpper()) { viewResult = viewIfo; break; } } } if (viewResult == null && lstViews.Count > 0) { viewResult = lstViews[0] as STViewsInfo; } #endregion } if (viewResult != null) { ABCScreenManager.Instance.RunLink(viewResult, mode, isShowDialog, iMainID, action); } }
public void PopulateControls(ABCView view, String BusName, String strTableName) { ViewOwner = view; DataSource = BusName; TableName = strTableName; int iCount = 0; ABCSearchControl ctrl = null; foreach (DataConfigProvider.FieldConfig fieldConfig in DataConfigProvider.TableConfigList[strTableName].FieldConfigList.Values) { if (fieldConfig.InUse == false) { continue; } if (DataStructureProvider.IsPrimaryKey(strTableName, fieldConfig.FieldName) || DataStructureProvider.IsForeignKey(strTableName, fieldConfig.FieldName)) { continue; } if (fieldConfig.IsDefault) { if (view != null && view.Mode == ViewMode.Design) { ctrl = (ABCSearchControl)view.Surface.DesignerHost.CreateComponent(typeof(ABCSearchControl)); } else { ctrl = (ABCSearchControl)ABCDynamicInvoker.CreateInstanceObject(typeof(ABCSearchControl)); } ABCSearchInfo searchInfo = new ABCSearchInfo(); searchInfo.DataSource = BusName; searchInfo.TableName = TableName; searchInfo.DataMember = fieldConfig.FieldName; ctrl.Initialize(view, searchInfo); ctrl.Parent = this.DropZone; iCount++; } } if (iCount % 2 != 0) { iCount++; } iCount = iCount / 2; if (ctrl != null) { this.Size = new Size(ctrl.Width * 2 + 4 * 3, 20 * iCount + (iCount + 1) * 5 + 25); } }
void ConfigGridView_CustomRowCellEdit(object sender, DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs e) { if (e.Column.FieldName == "FilterString") { ABCGridColumn.ColumnConfig config = this.ConfigGridView.GetRow(this.ConfigGridView.FocusedRowHandle) as ABCGridColumn.ColumnConfig; if (config == null || DataStructureProvider.IsForeignKey(config.TableName, config.FieldName) == false) { e.RepositoryItem = null; return; } } }
void ABCGridLookUpEdit_QueryPopUp(object sender, CancelEventArgs e) { if (String.IsNullOrWhiteSpace(this.ParentCtrlName) == false && String.IsNullOrWhiteSpace(this.ChildField) == false) { if (ParentControl == null) { Form frm = this.FindForm(); Control[] parentCtrls = frm.Controls.Find(this.ParentCtrlName, true); if (parentCtrls != null && parentCtrls.Length > 0) { if (parentCtrls[0] is IABCBindableControl && parentCtrls[0] is ABCBindingBaseEdit == false) { ParentControl = parentCtrls[0] as IABCBindableControl; } else if (parentCtrls[0] is ABCBindingBaseEdit && (parentCtrls[0] as ABCBindingBaseEdit).EditControl is IABCBindableControl) { ParentControl = (parentCtrls[0] as ABCBindingBaseEdit).EditControl as IABCBindableControl; } } } if (ParentControl != null && ParentControl is IABCBindableControl && DataStructureProvider.IsTableColumn(LookupTableName, ChildField)) { object objValue = ParentControl.GetType().GetProperty((ParentControl as IABCBindableControl).BindingProperty).GetValue(ParentControl, null); if (objValue != null) { DataView newView = DataCachingProvider.TryToGetDataView(this.LookupTableName, true); newView.RowFilter = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetDataSetWhere(DevExpress.Data.Filtering.CriteriaOperator.Parse(DefaultFilterString)); String strFilter = String.Empty; if (objValue.GetType() == typeof(int) || objValue.GetType() == typeof(double) || objValue.GetType() == typeof(Nullable <int>) || objValue.GetType() == typeof(Nullable <double>) || objValue.GetType() == typeof(Boolean) || objValue.GetType() == typeof(Nullable <Boolean>)) { strFilter = String.Format(@" {0} = {1} ", ChildField, objValue); } if (objValue.GetType() == typeof(String)) { strFilter = String.Format(@" {0} = '{1}' ", ChildField, objValue.ToString()); } if (String.IsNullOrWhiteSpace(newView.RowFilter) == false) { strFilter = " AND " + strFilter; } newView.RowFilter += strFilter; this.Properties.DataSource = newView; } } } }
private void DrawLinkButton(DevExpress.XtraVerticalGrid.Events.CustomDrawRowValueCellEventArgs e) { if (this.ABCGrid == null || (this.ABCGrid.OwnerView != null && this.ABCGrid.OwnerView.Mode != ViewMode.Design)) { if (e.Row != null && e.Row.Tag is ABCGridColumn.ColumnConfig && String.IsNullOrWhiteSpace(this.ABCGrid.TableName) == false && e.CellValue != null && e.CellValue.GetType() == typeof(int)) { Boolean isDraw = false; EditorRow gridRow = e.Row as EditorRow; String strTableName = this.ABCGrid.TableName; if (gridRow.Properties.FieldName.Contains(":") == false) { if (ForeignColumnList.TryGetValue(gridRow.Properties.FieldName, out isDraw) == false) { if (DataStructureProvider.IsForeignKey(strTableName, gridRow.Properties.FieldName)) { ForeignColumnList.Add(gridRow.Properties.FieldName, true); } else { ForeignColumnList.Add(gridRow.Properties.FieldName, false); } } } else { DataCachingProvider.AccrossStructInfo acrrosInfo = DataCachingProvider.GetAccrossStructInfo(strTableName, ABCHelper.DataConverter.ConvertToGuid(e.CellValue), e.Row.Properties.FieldName); if (acrrosInfo != null && (acrrosInfo.FieldName == DataStructureProvider.GetNOColumn(acrrosInfo.TableName) || acrrosInfo.FieldName == DataStructureProvider.GetNAMEColumn(acrrosInfo.TableName))) { isDraw = true; } } if (isDraw) { e.Graphics.DrawImage(ABCControls.ABCImageList.GetImage16x16("DocLink"), e.Bounds.Location); Rectangle r = e.Bounds; r.Width -= 18; r.X += 18; e.Appearance.DrawString(e.Cache, e.CellText, r); e.Handled = true; } } } }
public void RunFocusedLink( ) { if (String.IsNullOrWhiteSpace(this.ABCGrid.TableName) == false) { if (this.ABCGrid == null || (this.ABCGrid.OwnerView != null && this.ABCGrid.OwnerView.Mode != ViewMode.Design)) { String strTableName = this.ABCGrid.TableName; String strFieldName = VGrid.FocusedRow.Properties.FieldName; String strLinkTableName = String.Empty; Guid iLinkID = Guid.Empty; EditorRow gridRow = this.VGrid.FocusedRow as EditorRow; object objCellValue = this.VGrid.GetCellValue(gridRow, VGrid.FocusedRecord); if (objCellValue == null || objCellValue.GetType() != typeof(Guid)) { return; } if (gridRow.Properties.FieldName.Contains(":")) { DataCachingProvider.AccrossStructInfo acrrosInfo = DataCachingProvider.GetAccrossStructInfo(strTableName, ABCHelper.DataConverter.ConvertToGuid(objCellValue), gridRow.Properties.FieldName); if (acrrosInfo != null && (acrrosInfo.FieldName == DataStructureProvider.GetNOColumn(acrrosInfo.TableName) || acrrosInfo.FieldName == DataStructureProvider.GetNAMEColumn(acrrosInfo.TableName))) { strLinkTableName = acrrosInfo.TableName; iLinkID = acrrosInfo.TableID; } } else if (DataStructureProvider.IsForeignKey(strTableName, strFieldName)) { strLinkTableName = DataStructureProvider.GetTableNameOfForeignKey(strTableName, strFieldName); iLinkID = ABCHelper.DataConverter.ConvertToGuid(objCellValue); } if (iLinkID != Guid.Empty) { if (this.ABCGrid.OwnerView != null) { ABCScreen.ABCScreenHelper.Instance.RunLink(strLinkTableName, this.ABCGrid.OwnerView.Mode, false, iLinkID, ABCScreenAction.None); } else { ABCScreen.ABCScreenHelper.Instance.RunLink(strLinkTableName, ViewMode.Runtime, false, iLinkID, ABCScreenAction.None); } } } } }
public void RefreshDisplayGrid( ) { DisplayGridCtrl.TableName = this.TableName; DisplayGridCtrl.Grid.Fields.Clear(); DisplayGridCtrl.FieldConfigs = this.FieldsList; DisplayGridCtrl.InitFields(); DisplayGridCtrl.Grid.OptionsView.RowTreeWidth = RowTreeWidth; DisplayGridCtrl.UseChartControl = UseChartControl; DisplayGridCtrl.Script = Script; if (String.IsNullOrWhiteSpace(this.TableName)) { DisplayGridCtrl.LoadDataSourceFromScript(); return; } if (DataCachingProvider.LookupTables.ContainsKey(this.TableName)) { this.DisplayGridCtrl.GridDataSource = DataCachingProvider.LookupTables[this.TableName]; } else { ABCHelper.ConditionBuilder strBuilder = new ABCHelper.ConditionBuilder(); strBuilder.Append(String.Format(@"SELECT TOP 5 * FROM {0}", this.TableName)); if (DataStructureProvider.IsExistABCStatus(this.TableName)) { strBuilder.AddCondition(QueryGenerator.GenerateCondition(this.TableName, ABCCommon.ABCColumnType.ABCStatus)); } strBuilder.Append(String.Format(@" ORDER BY {0} DESC", DataStructureProvider.GetPrimaryKeyColumn(this.TableName))); try { DataSet ds = DataQueryProvider.RunQuery(strBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { this.DisplayGridCtrl.GridDataSource = ds.Tables[0]; } } catch (Exception ex) { } } this.DisplayGridCtrl.RefreshDataSource(); DisplayGridCtrl.Grid.FieldsCustomization(splitContainerControl2.Panel2); }
public void RefreshData(Boolean includeParent, Boolean includeChildren, Boolean defaultOnly) { #region Current Node if (InnerData != null) { BusinessObjectController ctrller = BusinessControllerFactory.GetBusinessController(InnerData.AATableName); String strPK = DataStructureProvider.GetPrimaryKeyColumn(InnerData.AATableName); Guid iID = ABCHelper.DataConverter.ConvertToGuid(ABCBusinessEntities.ABCDynamicInvoker.GetValue(InnerData, strPK)); InnerData = ctrller.GetObjectByID(iID); if (InnerData == null) { if (this.ParentNode != null) { this.ParentNode.ChildrenNodes.Remove(iID); this.ParentNode = null; } Dictionary <Guid, ABCTreeListNode> innerList = null; if (this.Manager.DataList.TryGetValue(this.ObjectName, out innerList)) { if (innerList.ContainsKey(iID)) { innerList.Remove(iID); } } } } #endregion List <ABCTreeListNode> lstTemps = new List <ABCTreeListNode>(); foreach (ABCTreeListNode childNode in this.ChildrenNodes.Values) { lstTemps.Add(childNode); } if (includeChildren) { foreach (ABCTreeListNode childNode in lstTemps) { childNode.RefreshData(false, includeChildren, defaultOnly); } } if (includeParent && this.ParentNode != null) { this.ParentNode.RefreshData(true, false, defaultOnly); } ExpandData(includeChildren, defaultOnly); }
void repoFilterStringEditor_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { ABCGridColumn.ColumnConfig config = this.ConfigGridView.GetRow(this.ConfigGridView.FocusedRowHandle) as ABCGridColumn.ColumnConfig; if (config != null && DataStructureProvider.IsForeignKey(config.TableName, config.FieldName)) { String strTableName = DataStructureProvider.GetTableNameOfForeignKey(config.TableName, config.FieldName); using (ABCCommonForms.FilterBuilderForm form = new ABCCommonForms.FilterBuilderForm(strTableName)) { form.SetFilterString(config.FilterString); if (form.ShowDialog() == DialogResult.OK) { config.FilterString = form.FilterString; } } } }
public DataSet GetDataSetByColumn(String strFieldName, object objValue) { if (DataStructureProvider.IsTableColumn(TableName, strFieldName) == false) { return(null); } String strTypeName = DataStructureProvider.GetCodingType(TableName, strFieldName); if (strTypeName == "String" || strTypeName == "DateTime" || strTypeName == "Guid" || strTypeName == "Nullable<Guid>") { return(GetDataSet(String.Format("SELECT * FROM {0} WHERE {1} = '{2}' ", TableName, strFieldName, objValue))); } return(GetDataSet(String.Format("SELECT * FROM {0} WHERE {1} = {2} ", TableName, strFieldName, objValue))); }