void ViewTableConfig_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
STTableConfigsInfo objTableConfig = null;
if (isNeedSaveField)
{
objTableConfig = (STTableConfigsInfo)ViewTableConfig.GetRow(e.PrevFocusedRowHandle);
if (objTableConfig != null && String.IsNullOrWhiteSpace(objTableConfig.TableName) == false)
{
DialogResult result = ABCHelper.ABCMessageBox.Show(String.Format("Do you want to save the table '{0}' ?", objTableConfig.TableName), "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
SaveFieldConfig(objTableConfig.TableName);
}
}
isNeedSaveField = false;
}
objTableConfig = (STTableConfigsInfo)ViewTableConfig.GetRow(e.FocusedRowHandle);
if (objTableConfig == null || String.IsNullOrWhiteSpace(objTableConfig.TableName))
{
return;
}
DataSet ds = DataQueryProvider.SystemDatabaseHelper.RunQuery(String.Format("SELECT * FROM STFieldConfigs WHERE TableName='{0}'", objTableConfig.TableName));
if (ds != null && ds.Tables.Count > 0)
{
this.GridFieldConfig.DataSource = ds.Tables[0];
}
}
void Form_FormClosing(object sender, FormClosingEventArgs e)
{
if (isNeedSaveField || isNeedSaveTable)
{
DialogResult result = ABCHelper.ABCMessageBox.Show("Do you want to save ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
STTableConfigsInfo objTableConfig = (STTableConfigsInfo)ViewTableConfig.GetRow(ViewTableConfig.FocusedRowHandle);
if (objTableConfig != null && String.IsNullOrWhiteSpace(objTableConfig.TableName) == false)
{
SaveFieldConfig(objTableConfig.TableName);
}
SaveTables();
}
}
if (isModified)
{
DataConfigProvider.SynchronizeTableConfigs();
foreach (HostSurface surface in OwnerStudio.SurfaceManager.DesignSurfaces)
{
(surface.DesignerHost.RootComponent as ABCView).RefreshBindingControl();
}
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
STTableConfigsInfo objTableConfig = (STTableConfigsInfo)ViewTableConfig.GetRow(ViewTableConfig.FocusedRowHandle);
if (objTableConfig == null || String.IsNullOrWhiteSpace(objTableConfig.TableName))
{
return;
}
SetDefaultFieldCaptionFromDictionary(objTableConfig.TableName);
DataSet ds = DataQueryProvider.SystemDatabaseHelper.RunQuery(String.Format("SELECT * FROM STFieldConfigs WHERE TableName='{0}'", objTableConfig.TableName));
if (ds != null && ds.Tables.Count > 0)
{
this.GridFieldConfig.DataSource = ds.Tables[0];
}
}
