public void init() { MySqlConnection con = new sql_conn().getconn(); MySqlCommand cmd = null; MySqlDataReader reader = null; dataGridView1.Rows.Clear(); try { String sql = "select * from sale1"; con.Open(); if (checkBox1.CheckState == CheckState.Checked) { sql = sql + " where remark = '退单中'"; } if (checkBox2.CheckState == CheckState.Checked && checkBox1.CheckState == CheckState.Unchecked) { sql = sql + " where remark = '退货中'"; } else if (checkBox2.CheckState == CheckState.Checked && checkBox1.CheckState == CheckState.Checked) { sql = sql + " or remark = '退货中'"; } if (checkBox2.CheckState == CheckState.Checked || checkBox1.CheckState == CheckState.Checked) { cmd = new MySqlCommand(sql, con); reader = cmd.ExecuteReader(); while (reader.Read()) { int i = dataGridView1.RowCount; dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells[0].Value = reader[0].ToString(); dataGridView1.Rows[i].Cells[1].Value = reader[6].ToString(); dataGridView1.Rows[i].Cells[2].Value = reader[2].ToString(); dataGridView1.Rows[i].Cells[3].Value = reader[5].ToString(); dataGridView1.Rows[i].Cells[4].Value = reader[1].ToString(); dataGridView1.Rows[i].Cells[5].Value = "审核"; } } } catch { } }
private void InitData(String sql) { try { list.Clear(); MySqlConnection con = new sql_conn().getconn(); con.Open(); MySqlDataReader dr; MySqlCommand cmd = new MySqlCommand(sql, con); dr = cmd.ExecuteReader(); while (dr.Read()) { int flag = 0; for (int i = 0; i < list.Count; i++) { if (list[i].name == dr[0].ToString()) { list[i].amount = list[i].amount + double.Parse(dr[1].ToString()); flag = 1; break; } } if (flag == 0) { sale_report st = new sale_report(); st.name = dr[0].ToString(); st.amount = double.Parse(dr[1].ToString()); list.Add(st); } } InitcharControls(); con.Close(); dr.Close(); } catch (Exception e) { MessageBox.Show("数据库链接失败,请重试"); MessageBox.Show(e.Message); } }