public int selectTuikuan_date1(DateTime date1, DateTime date2) { MySqlConnection conn = Util.Util.getConn(); MySqlDataReader dataReader = null; MySqlCommand command = null; Tuikuan tui = null; Int16 sumtuikuan_money = 0; try { command = conn.CreateCommand(); command.CommandText = "SELECT sum(tuikuan_money) FROM tuikuan_money where date>='" + date1 + "'and date<='" + date2 + "'"; dataReader = command.ExecuteReader(); Console.WriteLine(command.CommandText); while (dataReader.Read()) { sumtuikuan_money = dataReader.GetInt16(0); } } catch (Exception) { } finally { if (!dataReader.IsClosed) { dataReader.Close(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(sumtuikuan_money); }
public void addTuikuandan(Tuikuan p) { MySqlConnection conn = Util.Util.getConn(); MySqlCommand command; try { command = conn.CreateCommand(); command.CommandText = "INSERT INTO tuikuan_money(tuikuan_zhanghu,tuikuan_money,tuikuan_way,mark,tuikuan_suppliernumber,employee_number,date,tuikuan_danjuid) VALUES(@tuikuan_zhanghu,@tuikuan_money,@tuikuan_way,@mark,@tuikuan_suppliernumber,@employee_number,@date,@tuikuan_danjuid)"; command.Parameters.AddWithValue("@tuikuan_zhanghu", p.Tuikuan_zhanghu); command.Parameters.AddWithValue("@tuikuan_money", p.Tuikuan_money); command.Parameters.AddWithValue("@tuikuan_way", p.Tuikuan_way); command.Parameters.AddWithValue("@mark", p.Mark); command.Parameters.AddWithValue("@tuikuan_suppliernumber", p.Tuikuan_suppliernumber); command.Parameters.AddWithValue("@employee_number", p.Employee_number); command.Parameters.AddWithValue("@date", p.Date); command.Parameters.AddWithValue("@tuikuan_danjuid", p.Tuikuan_danjuid); command.ExecuteNonQuery(); //MessageBox.Show("插入成功"); } catch (Exception) { MessageBox.Show("插入失败"); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
//按照单据日期和客户查询 public List <Tuikuan> selectTuikuan_dateandkehuname(DateTime date1, DateTime date2, string supplier_name) { MySqlConnection conn = Util.Util.getConn(); MySqlDataReader dataReader = null; MySqlCommand command = null; Tuikuan tui = null; List <Tuikuan> rs = new List <model.Tuikuan>(); try { command = conn.CreateCommand(); command.CommandText = "SELECT * FROM tuikuan_money where date>='" + date1 + "'and date<='" + date2 + "'and payfor_suppliernumber='" + supplier_name + "'"; dataReader = command.ExecuteReader(); Console.WriteLine(); while (dataReader.Read()) { tui = new Tuikuan(); tui.Id = dataReader.GetInt16(0); tui.Tuikuan_zhanghu = dataReader.GetString(1); tui.Tuikuan_money = dataReader.GetString(2); tui.Tuikuan_way = dataReader.GetString(3); tui.Mark = dataReader.GetString(4); tui.Tuikuan_suppliernumber = dataReader.GetString(5); tui.Employee_number = dataReader.GetString(6); tui.Date = dataReader.GetDateTime(7); tui.Tuikuan_danjuid = dataReader.GetString(8); rs.Add(tui); } } catch (Exception) { } finally { if (!dataReader.IsClosed) { dataReader.Close(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(rs); }
private void button4_Click(object sender, EventArgs e) { bool b = true; if (dataGridView1.Rows.Count == 1) { MessageBox.Show("请填写信息"); b = false; } else { for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { if (dataGridView1.Rows[i].Cells[0].Value == null) { MessageBox.Show("结算账户不能为空"); b = false; } else if (dataGridView1.Rows[i].Cells[1].Value == null) { MessageBox.Show("退款金额不能为空"); b = false; } else if (dataGridView1.Rows[i].Cells[2].Value == null) { MessageBox.Show("结算方式不能为空"); b = false; } else if (textBox1.Text == null) { MessageBox.Show("供应商不能为空"); b = false; } else if (textBox2.Text == null) { MessageBox.Show("操作人不能为空"); b = false; } } } if (b == false) { } else { MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("是否确认保存?", "提交", messButton); if (dr == DialogResult.OK) { string[] supplier1 = textBox1.Text.Split(' '); string[] employer = textBox2.Text.Split(' '); try { ZijinDao dao = new ZijinDao(); for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { Tuikuan p = new Tuikuan(); Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla"); p.Tuikuan_zhanghu = dataGridView1.Rows[i].Cells[0].Value.ToString(); p.Tuikuan_money = dataGridView1.Rows[i].Cells[1].Value.ToString(); p.Tuikuan_way = dataGridView1.Rows[i].Cells[2].Value.ToString(); if (dataGridView1.Rows[i].Cells[3].Value == null) { p.Mark = ""; } else { p.Mark = dataGridView1.Rows[i].Cells[3].Value.ToString(); } p.Tuikuan_suppliernumber = supplier1[0]; p.Employee_number = employer[0]; p.Date = Convert.ToDateTime(dateTimePicker1.Text); p.Tuikuan_danjuid = textBox3.Text; dao.addTuikuandan(p); } MessageBox.Show("保存成功"); dataGridView1.Rows.Clear(); } catch (SystemException) { MessageBox.Show("操作有误"); } } else { } } }