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); }
public void SyncList() { this.dg_overview.Rows.Clear(); StockRuleItem[] items = null, items2 = null; int selectedIndex = 0, selectedDaPan = 0; string selectedDaPanValue = ""; if (cmb_kpi.SelectedIndex > 0) { selectedIndex = cmb_kpi.SelectedIndex; } if (cmb_dapan.SelectedIndex > 0) { selectedDaPan = cmb_dapan.SelectedIndex; } if (selectedDaPan > 0) { selectedDaPanValue = StockDapan.namelist[cmb_dapan.SelectedIndex - 1]; } double minumum_grade = (double)this.num_grade.Value / 100; foreach (Buy rule in StockApp.listbuy) { items = StockRuleSQL.GetRuleBuyList(rule.ToString(), startdate, enddate, Rule.STATUS_BUY_ML); AddList(items, Rule.STATUS_BUY_ML, rule.ToString(), selectedDaPanValue, 0, 0, minumum_grade); items = StockRuleSQL.GetRuleBuyList(rule.ToString(), startdate, enddate, Rule.STATUS_BUY); items2 = StockRuleSQL.GetRuleBuyList(rule.ToString(), startdate, enddate, Rule.STATUS_BUY_PY); if (selectedIndex > 0) { AddList(items, Rule.STATUS_BUY, rule.ToString(), selectedDaPanValue, cmb_kpi.SelectedIndex, 0, minumum_grade); //第SelectedIndex个KPI值为0的数据 AddList(items, Rule.STATUS_BUY, rule.ToString(), selectedDaPanValue, cmb_kpi.SelectedIndex, 1, minumum_grade); //第SelectedIndex个KPI值为1的数据 AddList(items2, Rule.STATUS_BUY_PY, rule.ToString(), selectedDaPanValue, cmb_kpi.SelectedIndex, 0, minumum_grade); //第SelectedIndex个KPI值为0的数据 AddList(items2, Rule.STATUS_BUY_PY, rule.ToString(), selectedDaPanValue, cmb_kpi.SelectedIndex, 1, minumum_grade); //第SelectedIndex个KPI值为1的数据 } else { AddList(items, Rule.STATUS_BUY, rule.ToString(), selectedDaPanValue, 0, 0, minumum_grade); //第一个0是大盘状态, 第0个KPI值为0 AddList(items2, Rule.STATUS_BUY_PY, rule.ToString(), selectedDaPanValue, 0, 0, minumum_grade); //第一个0是大盘状态, 第0个KPI值为0 } } /*foreach (Sell rule in StockApp.listsell) * { * items = StockRuleSQL.GetRuleSellList(rule.ToString(), startdate, enddate); * AddList(items, -1, rule.ToString(), selectedDaPanValue, 0, 0, minumum_grade); * }*/ }