private void dg_overview_DoubleClick(object sender, EventArgs e) { dg_detail.Rows.Clear(); DataGridViewRow row = this.dg_overview.Rows[this.dg_overview.SelectedCells[0].RowIndex]; int type = Convert.ToInt16(row.Cells[0].Value); string rulename = (string)row.Cells[1].Value; StockRuleItem[] items = null; if (Rule.contains(type)) { items = StockRuleSQL.GetRuleBuyList(rulename, startdate, enddate, type); } else { items = StockRuleSQL.GetRuleSellList(rulename, startdate, enddate); } foreach (StockRuleItem s in items) { if (s.pregrade < (double)this.num_grade.Value / 100) { continue; } dg_detail.Rows.Add(s.ToRowInfo()); } ShowDetail(true); }
private void btn_exportAll_Click(object sender, EventArgs e) { int size = this.dg_overview.Rows.Count; dg_detail.Rows.Clear(); DataGridViewRow row = this.dg_overview.Rows[0]; int type = Convert.ToInt16(row.Cells[0].Value); string rulename = (string)row.Cells[1].Value; StockRuleItem[] items = null; if (Rule.contains(type)) { items = StockRuleSQL.GetRuleBuyList(rulename, startdate, enddate, type); } else { items = StockRuleSQL.GetRuleSellList(rulename, startdate, enddate); } foreach (StockRuleItem s in items) { dg_detail.Rows.Add(s.ToRowInfo()); } Util.ExportCSV(this.dg_detail, "StockRuleAll.csv", true); for (int i = 1; i < size; i++) { dg_detail.Rows.Clear(); row = this.dg_overview.Rows[0]; type = Convert.ToInt16(row.Cells[0].Value); rulename = (string)row.Cells[1].Value; if (Rule.contains(type)) { items = StockRuleSQL.GetRuleBuyList(rulename, startdate, enddate, type); } else { items = StockRuleSQL.GetRuleSellList(rulename, startdate, enddate); } } foreach (StockRuleItem s in items) { dg_detail.Rows.Add(s.ToRowInfo()); } Util.ExportCSV(this.dg_detail, "StockRuleAll.csv", false); MessageBox.Show("done"); ShowDetail(true); }