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