public virtual void CreateMainObjectRule() { VinaDbUtil dbUtil = new VinaDbUtil(); MainObject.BusinessRuleCollections = new List <BusinessRule>(); String strMainObjectTableName = VinaUtil.GetTableNameFromBusinessObject(MainObject); DataSet dsColumns = dbUtil.GetNotAllowNullTableColumns(strMainObjectTableName); if (dsColumns.Tables.Count > 0) { AAColumnAliasController objColumnAlliasController = new AAColumnAliasController(); List <AAColumnAliasInfo> LstColumnAlias = objColumnAlliasController.GetColumnAliasByTableName(strMainObjectTableName); foreach (DataRow rowColumn in dsColumns.Tables[0].Rows) { String strColumnName = rowColumn["COLUMN_NAME"].ToString(); String strBrokenRuleDescription = String.Empty; //Add rule if column is not primary key if (!dbUtil.IsPrimaryKey(strMainObjectTableName, strColumnName)) { //If column does not allow null if (!dbUtil.ColumnIsAllowNull(strMainObjectTableName, strColumnName)) { AAColumnAliasInfo objColumnAliasInfo = LstColumnAlias.Where(a => a.AATableName == strMainObjectTableName && a.AAColumnAliasName == strColumnName).FirstOrDefault(); if (objColumnAliasInfo != null) { strBrokenRuleDescription = String.Format(string.Format("{0} không thể để trống", objColumnAliasInfo.AAColumnAliasCaption)); } else { strBrokenRuleDescription = String.Format(string.Format("{0} không thể để trống", strColumnName)); } if (((IBaseModuleERP)Module).IsForeignKey(strMainObjectTableName, strColumnName)) { BusinessRule foreignKeyRule = new BusinessRule( strColumnName, strBrokenRuleDescription, IsValidForeignKeyProperty); MainObject.BusinessRuleCollections.Add(foreignKeyRule); } else { BusinessRule nonForeignKeyRule = new BusinessRule(strColumnName, strBrokenRuleDescription, IsValidNonForeignKeyPropety); MainObject.BusinessRuleCollections.Add(nonForeignKeyRule); } } } } } dsColumns.Dispose(); }
protected virtual void AddColumnsToGridView(string strTableName, GridView gridView) { VinaDbUtil vinaDbUtil = new VinaDbUtil(); AAColumnAliasController objColumnAliasController = new AAColumnAliasController(); List <AAColumnAliasInfo> columnAlias = objColumnAliasController.GetColumnAliasByTableName(strTableName); columnAlias.ForEach(o => { if (gridView.Columns.ColumnByFieldName(o.AAColumnAliasName) == null) { GridColumn column = this.InitGridColumn(strTableName, -1, o.AAColumnAliasName, o.AAColumnAliasCaption, 50); if (vinaDbUtil.IsForeignKey(strTableName, o.AAColumnAliasName)) { RepositoryItemLookUpEdit itemBosLookupEdit = this.InitColumnLookupEdit(strTableName, o.AAColumnAliasName, o.AAColumnAliasCaption); if (itemBosLookupEdit != null) { column.ColumnEdit = (DevExpress.XtraEditors.Repository.RepositoryItem)itemBosLookupEdit; } } else { string empty = string.Empty; string groupName = o.AAColumnAliasName.Substring(2, o.AAColumnAliasName.Length - 2); if (VinaUtil.ADConfigValueUtility.ContainsKey(groupName)) { RepositoryItemLookUpEdit itemLookUpEdit = this.InitRepositoryForConfigValues(VinaUtil.ADConfigValueUtility[groupName]); column.ColumnEdit = itemLookUpEdit; } else { //column.ColumnEdit = this.InitColumnRepositoryFromFieldFormatGroup(strTableName, objectFromDataRow.AAColumnAliasName); //if (column.ColumnEdit != null) // column.ColumnEdit.MouseWheel += new MouseEventHandler(this.ColumnEdit_MouseWheel); } } column.OptionsColumn.AllowEdit = false; gridView.Columns.Add(column); } else { gridView.Columns[o.AAColumnAliasName].Caption = o.AAColumnAliasCaption; } }); }
protected virtual void AddColumnsToGridViewResults(GridView gridView, string tableName) { gridView.Columns.Clear(); VinaDbUtil dbUtil = new VinaDbUtil(); AAColumnAliasController objAAColumnAliasController = new AAColumnAliasController(); List <AAColumnAliasInfo> columnAliasList = objAAColumnAliasController.GetColumnAliasByTableName(tableName); if (columnAliasList.Count() == 0) { return; } int visibleIndex = 0; columnAliasList.ForEach(o => { if (gridView.Columns.ColumnByFieldName(o.AAColumnAliasName) == null) { GridColumn column = this.InitGridColumn(tableName, -1, o.AAColumnAliasName, o.AAColumnAliasCaption, 50); if (dbUtil.IsForeignKey(tableName, o.AAColumnAliasName)) { RepositoryItemLookUpEdit itemBosLookupEdit = this.InitColumnLookupEdit(tableName, o.AAColumnAliasName, o.AAColumnAliasCaption); if (itemBosLookupEdit != null) { column.ColumnEdit = (DevExpress.XtraEditors.Repository.RepositoryItem)itemBosLookupEdit; } } else { string empty = string.Empty; string groupName = o.AAColumnAliasName.Substring(2, o.AAColumnAliasName.Length - 2); if (VinaUtil.ADConfigValueUtility.ContainsKey(groupName)) { RepositoryItemLookUpEdit itemLookUpEdit = this.InitRepositoryForConfigValues(VinaUtil.ADConfigValueUtility[groupName]); column.ColumnEdit = itemLookUpEdit; } else { //column.ColumnEdit = this.InitColumnRepositoryFromFieldFormatGroup(strTableName, objectFromDataRow.AAColumnAliasName); //if (column.ColumnEdit != null) // column.ColumnEdit.MouseWheel += new MouseEventHandler(this.ColumnEdit_MouseWheel); } } column.Name = "col" + o.AAColumnAliasName; column.FieldName = o.AAColumnAliasName; column.Caption = o.AAColumnAliasCaption; column.Width = 100; column.VisibleIndex = visibleIndex++; column.OptionsColumn.AllowEdit = false; gridView.Columns.Add(column); } else { gridView.Columns[o.AAColumnAliasName].Caption = o.AAColumnAliasCaption; } //column = new GridColumn(); //column.Name = "col" + o.AAColumnAliasName; //column.FieldName = o.AAColumnAliasName; //column.Caption = o.AAColumnAliasCaption; //column.Width = 100; //column.VisibleIndex = visibleIndex++; //gridView.Columns.Add(column); }); }