private void SaveFieldConfig(String strTableName)
{
if (String.IsNullOrWhiteSpace(strTableName))
{
return;
}
Cursor.Current = Cursors.WaitCursor;
#region Save
STFieldConfigsController configCtrl = new STFieldConfigsController();
foreach (DataRow dr in ((DataView)this.ViewFieldConfig.DataSource).Table.Rows)
{
STFieldConfigsInfo configInfo = (STFieldConfigsInfo)configCtrl.GetObjectFromDataRow(dr);
if (configInfo != null)
{
configCtrl.UpdateObject(configInfo);
isModified = true;
}
}
#endregion
Cursor.Current = Cursors.Default;
}
public void SaveTables( )
{
ABCWaitingDialog.Show("", "Saving . . .!");
if (this.ViewFieldConfig.DataSource != null)
{
STFieldConfigsController configCtrl = new STFieldConfigsController();
foreach (DataRow dr in ((DataView)this.ViewFieldConfig.DataSource).Table.Rows)
{
STFieldConfigsInfo configInfo = (STFieldConfigsInfo)configCtrl.GetObjectFromDataRow(dr);
if (configInfo != null)
{
configCtrl.UpdateObject(configInfo);
isModified = true;
}
}
}
STTableConfigsController aliasCtrl = new STTableConfigsController();
foreach (STTableConfigsInfo aliasInfo in TableList)
{
aliasCtrl.UpdateObject(aliasInfo);
}
DataConfigProvider.SynchronizeTableConfigs();
InvalidateTableList();
ABCWaitingDialog.Close();
isNeedSaveTable = false;
}
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);
}
}
}
}
}
void ViewFieldConfig_ShowingEditor(object sender, CancelEventArgs e)
{
if (ViewFieldConfig.FocusedColumn.FieldName == "FilterString")
{
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))
{
return;
}
}
}
e.Cancel = true;
}
else if (ViewFieldConfig.FocusedColumn.FieldName == "Enum")
{
DataRow dr = ViewFieldConfig.GetDataRow(ViewFieldConfig.FocusedRowHandle);
if (dr != null)
{
STFieldConfigsInfo configInfo = (STFieldConfigsInfo) new STFieldConfigsController().GetObjectFromDataRow(dr);
if (configInfo != null)
{
if (DataStructureProvider.DataTablesList.ContainsKey(configInfo.TableName))
{
if (DataStructureProvider.GetCodingType(configInfo.TableName, configInfo.FieldName) == "String")
{
return;
}
}
}
}
e.Cancel = true;
}
}
private void SetDefaultFieldCaptionFromDictionary(String strTableName)
{
STFieldConfigsController fieldConfigCtrl = new STFieldConfigsController();
STTableConfigsController tableConfigCtrl = new STTableConfigsController();
STDictionarysController dictionaryCtrl = new STDictionarysController();
DataSet ds = DataQueryProvider.SystemDatabaseHelper.RunQuery(String.Format("SELECT * FROM STFieldConfigs WHERE TableName='{0}'", strTableName));
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
STFieldConfigsInfo configInfo = (STFieldConfigsInfo)fieldConfigCtrl.GetObjectFromDataRow(dr);
if (configInfo != null)
{
String strCaptionVN = configInfo.FieldName;
String strCaptionEN = configInfo.FieldName;
#region Dictionarys
DataSet ds2 = DataQueryProvider.SystemDatabaseHelper.RunQuery(String.Format("SELECT * FROM STDictionarys WHERE ('{0}' LIKE '%'+ KeyString+'%' AND IsContain='TRUE') OR ('{0}' LIKE KeyString+'%' AND IsStartWith='TRUE') OR ('{0}' LIKE '%' +KeyString AND IsEndWith='TRUE') OR (KeyString='{0}' AND (IsContain='FALSE' OR IsContain IS NULL) AND (IsStartWith='FALSE' OR IsStartWith IS NULL) AND (IsEndWith='FALSE' OR IsEndWith IS NULL) )", configInfo.FieldName));
if (ds2 != null && ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0)
{
STDictionarysInfo dictInfo = (STDictionarysInfo)dictionaryCtrl.GetObjectFromDataRow(ds2.Tables[0].Rows[0]);
if (dictInfo != null)
{
if (String.IsNullOrWhiteSpace(dictInfo.TranslateVN) == false)
{
strCaptionVN = dictInfo.TranslateVN;
}
if (String.IsNullOrWhiteSpace(dictInfo.TranslateEN) == false)
{
strCaptionEN = dictInfo.TranslateEN;
}
}
}
#endregion
if (DataStructureProvider.IsForeignKey(configInfo.TableName, configInfo.FieldName))
{
String strPKTableName = DataStructureProvider.GetTableNameOfForeignKey(configInfo.TableName, configInfo.FieldName);
STTableConfigsInfo tableConfigInfo = (STTableConfigsInfo)tableConfigCtrl.GetObject(String.Format("SELECT * FROM STTableConfigs WHERE TableName='{0}' ", strPKTableName));
if (tableConfigInfo != null && String.IsNullOrWhiteSpace(tableConfigInfo.CaptionVN) == false)
{
strCaptionVN = tableConfigInfo.CaptionVN;
}
if (tableConfigInfo != null && String.IsNullOrWhiteSpace(tableConfigInfo.CaptionEN) == false)
{
strCaptionEN = tableConfigInfo.CaptionEN;
}
else
{
strCaptionEN = strPKTableName.Substring(2, strPKTableName.Length - 3);
}
}
else if (configInfo.FieldName.StartsWith("FK_"))
{
String strPKTableName = DataStructureProvider.GetTableNameOfPrimaryKey(configInfo.FieldName.Substring(3, configInfo.FieldName.Length - 3));
if (String.IsNullOrWhiteSpace(strPKTableName) == false)
{
STTableConfigsInfo tableConfigInfo = (STTableConfigsInfo)tableConfigCtrl.GetObject(String.Format("SELECT * FROM STTableConfigs WHERE TableName='{0}' ", strPKTableName));
if (tableConfigInfo != null && String.IsNullOrWhiteSpace(tableConfigInfo.CaptionVN) == false)
{
strCaptionVN = tableConfigInfo.CaptionVN;
}
if (tableConfigInfo != null && String.IsNullOrWhiteSpace(tableConfigInfo.CaptionEN) == false)
{
strCaptionEN = tableConfigInfo.CaptionEN;
}
else
{
strCaptionEN = strPKTableName.Substring(2, strPKTableName.Length - 3);
}
}
}
//if ( String.IsNullOrWhiteSpace( strCaptionVN )==false||String.IsNullOrWhiteSpace( strCaptionEN )==false )
//{
if (strCaptionVN != configInfo.FieldName)
{
configInfo.CaptionVN = strCaptionVN;
}
else
{
configInfo.CaptionVN = String.Empty;
}
configInfo.CaptionEN = strCaptionEN;
fieldConfigCtrl.UpdateObject(configInfo);
//}
}
}
}
}
void ViewFieldConfig_CustomRowCellEdit(object sender, DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs e)
{
if (e.Column.FieldName == "Format")
{
DataRow dr = ViewFieldConfig.GetDataRow(e.RowHandle);
if (dr != null)
{
STFieldConfigsInfo configInfo = (STFieldConfigsInfo) new STFieldConfigsController().GetObjectFromDataRow(dr);
if (configInfo != null)
{
if (DataStructureProvider.DataTablesList.ContainsKey(configInfo.TableName))
{
String strType = DataStructureProvider.GetCodingType(configInfo.TableName, configInfo.FieldName);
if (strType == "DateTime" || strType == "Nullable<DataTime>" || strType == "int" || strType == "double" || strType == "decimal")
{
e.RepositoryItem = repoFormat;
return;
}
}
}
}
e.RepositoryItem = null;
}
#region AssignedEnum
if (e.Column.FieldName == "AssignedEnum")
{
DataRow dr = ViewFieldConfig.GetDataRow(e.RowHandle);
if (dr != null)
{
STFieldConfigsInfo configInfo = (STFieldConfigsInfo) new STFieldConfigsController().GetObjectFromDataRow(dr);
if (configInfo != null)
{
if (DataStructureProvider.DataTablesList.ContainsKey(configInfo.TableName))
{
if (DataStructureProvider.GetCodingType(configInfo.TableName, configInfo.FieldName) == "String")
{
e.RepositoryItem = repoEnum;
return;
}
}
}
}
e.RepositoryItem = null;
}
#endregion
if (e.Column.FieldName == "FilterString")
{
DataRow dr = ViewFieldConfig.GetDataRow(e.RowHandle);
if (dr != null)
{
STFieldConfigsInfo configInfo = (STFieldConfigsInfo) new STFieldConfigsController().GetObjectFromDataRow(dr);
if (configInfo != null)
{
if (DataStructureProvider.IsForeignKey(configInfo.TableName, configInfo.FieldName))
{
e.RepositoryItem = this.repoFilter;
return;
}
}
}
e.RepositoryItem = null;
}
}
