public static WebbDataSource CreateDataSource()
{
WebbDataProvider dataProvider = new WebbDataProvider();
WebbDataSource m_DBSource = new WebbDataSource();
//Show wizard
DialogResult m_Result = dataProvider.ShowWizard(null, m_DBSource);
if (m_Result != DialogResult.OK)
{
return(null);
}
Webb.Utilities.WaitingForm.ShowWaitingForm();
Webb.Utilities.WaitingForm.SetWaitingMessage("Loading Datasource....");
bool m_result = dataProvider.GetDataSource(m_DBSource);
if (!m_result || m_DBSource.DataSource.Tables.Count == 0)
{
MessageBox.Show("No data in you selected dataSource!", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(null);
}
SetDataSource(dataProvider, m_DBSource);
Webb.Utilities.WaitingForm.CloseWaitingForm();
return(m_DBSource);
}
public static WebbDataSource CreateDataSourse(string[] args, bool throwException)
{
if (args == null || args.Length != 10)
{
return(null);
}
if (args[3] == "DBConn:" && args[8] == @"Files:")
{
return(null);
}
try
{
CommandManager m_CmdManager = new CommandManager(args);
DBSourceConfig m_Config = m_CmdManager.CreateDBConfig();
WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config);
WebbDataSource m_DBSource = new WebbDataSource();
m_DBProvider.GetDataSource(m_Config, m_DBSource);
Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider;
return(m_DBSource);
}
catch (Exception ex)
{
if (throwException)
{
MessageBox.Show("Bad parameters in Config File!\r\n" + ex.Message);
}
return(null);
}
}
private static void SetDataSource(WebbDataProvider m_DBProvider, WebbDataSource m_DBSource)
{
ArrayList m_Fields = new ArrayList();
foreach (System.Data.DataColumn m_col in m_DBSource.DataSource.Tables[0].Columns)
{
if (m_col.Caption == "{EXTENDCOLUMNS}" && m_col.ColumnName.StartsWith("C_"))
{
continue;
}
m_Fields.Add(m_col.ColumnName);
}
Webb.Data.PublicDBFieldConverter.SetAvailableFields(m_Fields);
Webb.Reports.DataProvider.VideoPlayBackManager.DataSource = m_DBSource.DataSource; //Set dataset for click event
Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider;
Webb.Reports.DataProvider.VideoPlayBackManager.LoadAdvScFilters(); //Modified at 2009-1-19 13:48:30@Scott
Webb.Reports.DataProvider.VideoPlayBackManager.ReadPictureDirFromRegistry();
}
public void SetDataSource(WebbDataSource i_DataSource)
{
this._WebbDataSource = i_DataSource;
//this._SectionFilters = i_DataSource.SectionFilters; //04-23-2008@Scott
this.UpdataDBSourceForExControls(i_DataSource.DataSource, i_DataSource.DataMember);
}
public static WebbDataSource ReadDataConfig(string DataConfigFile, string filename)
{
if (!File.Exists(DataConfigFile))
{
return(null);
}
WebbDataSource m_DBSource = new WebbDataSource();
DataSet ds = new DataSet();
try
{
ds.ReadXml(DataConfigFile);
if (ds.Tables.Count == 0)
{
return(null);
}
int lastCount = ds.Tables.Count - 1;
if (lastCount == 0)
{
m_DBSource.DataSource = ds;
}
else if (ds.Tables[lastCount].TableName == "[TableStructure]")
{
DBSourceConfig m_Config = new DBSourceConfig();
m_Config.WebbDBType = WebbDBTypes.CoachCRM;
m_Config.DBFilePath = DataConfigFile;
Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = new WebbDataProvider(m_Config);
m_DBSource.DataSource = ds;
}
else
{
DataTable dt = ds.Tables[lastCount];
filename = "Path:" + filename;
DataRow dr = dt.Rows[dt.Rows.Count - 1];
if (dr == null || dt.Columns.Count != 10)
{
return(null);
}
string[] strConfigs = new string[dt.Columns.Count];
strConfigs[0] = "Path:" + filename;
for (int i = 1; i < dt.Columns.Count; i++)
{
strConfigs[i] = dr[i].ToString();
}
CommandManager m_CmdManager = new CommandManager(strConfigs);
DBSourceConfig m_Config = m_CmdManager.CreateDBConfig();
WebbDataProvider m_DBProvider = new WebbDataProvider(m_Config);
Webb.Reports.DataProvider.VideoPlayBackManager.PublicDBProvider = m_DBProvider;
ds.Tables.RemoveAt(lastCount);
AdvGameData.FillGamesAndFilters(m_DBSource, m_Config);
m_DBSource.DataSource = ds;
}
return(m_DBSource);
}
catch (Exception ex)
{
ds.Dispose();
MessageBox.Show(ex.Message);
return(null);
}
}
