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