//private DataGridViewPrinter _DataGridViewPrinter; public frmMain() { InitializeComponent(); _pdalStock = new DALDoubleM(lblDMMsg, pBarDM); _pdalStock.MarqueeUpdate(); CommonDoubleM._pdalStock1 = new DALDoubleM(lblDMMsg, pBarDM); ////////////////////////// _groupPaneBar.Add(CreateButton("Basics", CommonDoubleM.Basics.Length), "Basics ", imglstMain.Images[0], true); _groupPaneBar.Add(CreateButton("Online", CommonDoubleM.Online.Length), "Online ", imglstMain.Images[1], true); _groupPaneBar.Add(CreateButton("Analysis", CommonDoubleM.Analysis.Length), "Analysis ", imglstMain.Images[2], true); _groupPaneBar.Add(CreateButton("Views", CommonDoubleM.Views.Length), "Views ", imglstMain.Images[3], true); _groupPaneBar.Add(CreateButton("Configuration", CommonDoubleM.Configuration.Length), "Configuration ", imglstMain.Images[3], true); _groupPaneBar.Add(CreateButton("About", CommonDoubleM.About.Length), " About ", imglstMain.Images[4], true); _groupPaneBar.CollapseAll(false); _groupPaneBar.CanResize = false; _groupPaneBar[0].Expanded = true; _groupPaneBar.ShowExpandCollapseButton = false; selectAllToolStripMenuItem.Checked = false; /*Winform FAQ*/ //http://www.syncfusion.com/faq/windowsforms/default.aspx /*Hiding Tab Pages on tab control*/ //http://www.experts-exchange.com/Programming/Programming_Languages/C_Sharp/Q_21549892.html tbMain.Top = tbMain.Top - tbMain.ItemSize.Height; tbMain.Height = tbMain.Height + tbMain.ItemSize.Height; tbMain.Region = new Region(new RectangleF(tpMain.Left, tpMain.Top, tpMain.Width, tpMain.Height + tbMain.ItemSize.Height)); LoadStocks(); pTradings = new frmTradingHist(_pdalStock); }
private void btnStart_Click(object sender, EventArgs e) { string sStockIDs = "", sStocksDates = "", sWhere = "", sSQL = ""; btnStart.Enabled = false; Cursor = Cursors.WaitCursor; //Incase no selection assume all stocks selected if (lstBStock.SelectedItems.Count == 0) { sWhere = " (TTrade.TradeOn" + chkAfterBefore.Text + "=#" + dtPKStart.Value.AddHours(23).ToString("dd/MMM/yyyy") + "#)"; } else if (lstBStock.SelectedItems.Count > 0) { sStocksDates = " AND (TTrade.TradeOn" + chkAfterBefore.Text + "=#" + dtPKStart.Value.AddHours(23).ToString() + "#)"; for (int i = 0; i <= lstBStock.SelectedItems.Count - 1; i++) { DataRowView ln = lstBStock.SelectedItems[i] as DataRowView; //MessageBox.Show(ln[0].ToString()); sStockIDs = "TStockName.StockID=" + ln[0].ToString(); sWhere += "((" + sStockIDs + ")" + sStocksDates + ") OR "; } sWhere = sWhere.Substring(0, sWhere.Length - 4); } sSQL = "SELECT TStockName.StockName, TTrade.Quantity, TRates.Price, TTrade.Brokerage, TTrade.Tax, TTrade.TradeOn, TTradeNotes.TradeNote " + "FROM ((TStockName INNER JOIN TRates ON TStockName.StockID = TRates.StockID) INNER JOIN TTrade ON TRates.RateID = TTrade.RateID) LEFT JOIN TTradeNotes ON TTrade.TradeID = TTradeNotes.TradeID " + "Where " + sWhere + " ORDER BY TStockName.StockName, TTrade.TradeOn"; //MessageBox.Show(sSQL); if (pTradings == null) { pTradings = new frmTradingHist(_pdalStock); } pTradings.MdiParent = this; pTradings.Show(); pTradings.Select(); pTradings.FillTradeBook(sSQL); btnStart.Enabled = true; Cursor = Cursors.Default; }