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);
});
}
