public void addsale(sale_good p)
{
MySqlConnection conn = Util.Util.getConn();
MySqlCommand command;
try
{
command = conn.CreateCommand();
command.CommandText = "INSERT INTO sale_good(good_number,customernumber,unit,count,price,money,remark,dan_date,danju_id) VALUES(@good_id,@customerid,@unit,@count,@price,@money,@remark,@dan_date,@danju_id)";
command.Parameters.AddWithValue("@good_id", p.Good_number);
command.Parameters.AddWithValue("@customerid", p.Customernumber);
command.Parameters.AddWithValue("@unit", p.Unit);
command.Parameters.AddWithValue("@count", p.Count);
command.Parameters.AddWithValue("@price", p.Price);
command.Parameters.AddWithValue("@money", p.Money);
command.Parameters.AddWithValue("@remark", p.Remark);
command.Parameters.AddWithValue("@dan_date", p.Dan_date);
command.Parameters.AddWithValue("@danju_id", p.Danju_id);
command.ExecuteNonQuery();
//MessageBox.Show("插入成功");
}
catch (Exception)
{
MessageBox.Show("插入失败");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
//根据单据查询销货sale_good
public List <sale_good> selectMaterial_danhao(string danju_number)
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
sale_good r = null;
List <sale_good> rs = new List <model.sale_good>();
try
{
command = conn.CreateCommand();
string sql = "SELECT * FROM sale_good where danju_id='" + danju_number + "'";
Console.Write(sql);
command.CommandText = sql;
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
Console.Write("测试");
r = new sale_good();
r.Id = dataReader.GetInt16(0);
r.Good_number = dataReader.GetString(1);
r.Customernumber = dataReader.GetString(2);
r.Unit = dataReader.GetString(3);
r.Count = dataReader.GetDouble(4);
r.Price = dataReader.GetDouble(5);
r.Money = dataReader.GetDouble(6);
r.Remark = dataReader.GetString(7);
r.Dan_date = dataReader.GetDateTime(8);
Console.Write(r.Id);
Console.Write(r.Good_number);
Console.Write(r.Customernumber);
Console.Write(r.Unit);
Console.Write(r.Count);
Console.Write(r.Price);
Console.Write(r.Money);
Console.Write(r.Remark);
Console.Write(r.Dan_date);
rs.Add(r);
Console.Write("测试");
}
}
catch (Exception)
{
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(rs);
}
//根据日期和供应商、原材料名称查询purchase_material表中status为0的数据
public List <sale_good> selectMaterial_dateandrnameandsupplier(DateTime date1, DateTime date2, string customernumber, string name)
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
sale_good r = null;
List <sale_good> rs = new List <model.sale_good>();
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM sale_good where dan_date>='" + date1 + "' and dan_date<='" + date2 + "' and good_number=(select good_number from good where good_name like '%" + name + "%') and customernumber='" + customernumber + "' ";
dataReader = command.ExecuteReader();
Console.WriteLine();
while (dataReader.Read())
{
r = new sale_good();
r.Id = dataReader.GetInt16(0);
r.Good_number = dataReader.GetString(1);
r.Customernumber = dataReader.GetString(2);
r.Unit = dataReader.GetString(3);
r.Count = dataReader.GetDouble(4);
r.Price = dataReader.GetDouble(5);
r.Money = dataReader.GetDouble(6);
r.Remark = dataReader.GetString(7);
r.Dan_date = dataReader.GetDateTime(8);
r.Danju_id = dataReader.GetString(9);
Console.Write("瑶瑶李");
rs.Add(r);
Console.Write("瑶瑶李");
}
}
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[3].Value == null)
{
MessageBox.Show("单位不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[4].Value == null)
{
MessageBox.Show("数量不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[5].Value == null)
{
MessageBox.Show("单价不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[6].Value == null)
{
MessageBox.Show("金额不能为空");
b = false;
}
else if (textBox1.Text == "")
{
MessageBox.Show("请选择供应商");
b = false;
}
else if (textBox3.Text == "")
{
MessageBox.Show("销售人员不能为空！");
}
}
}
if (b == false)
{
}
else
{
MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show("是否确认保存？", "提交", messButton);
if (dr == DialogResult.OK)
{
string[] customer = supplier_text.Text.Split(' ');
string[] employer = textBox3.Text.Split(' ');
sale dao = new sale();
double mm = Convert.ToDouble(label10.Text);
dao.addDanju(Convert.ToDateTime(dateTimePicker1.Text), textBox1.Text, employer[0], mm, textBox4.Text, customer[0]);
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
sale_good p = new sale_good();
Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla");
p.Good_number = dataGridView1.Rows[i].Cells[0].Value.ToString();
p.Customernumber = customer[0];
p.Dan_date = Convert.ToDateTime(dateTimePicker1.Text);
Console.Write("这是一个人" + p.Customernumber + "这是一个人");
p.Unit = dataGridView1.Rows[i].Cells[3].Value.ToString();
p.Count = Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value);
p.Price = Convert.ToDouble(dataGridView1.Rows[i].Cells[5].Value);
Console.Write("这是一个人" + p.Price + "这是一个人");
p.Money = Convert.ToDouble(dataGridView1.Rows[i].Cells[6].Value);
if (dataGridView1.Rows[i].Cells[7].Value == null)
{
p.Remark = "";
}
else
{
p.Remark = dataGridView1.Rows[i].Cells[7].Value.ToString();
}
p.Danju_id = textBox1.Text;
// Console.Write("这是一个人" + p.Danju_id + "这是一个人");
dao.addsale(p);
}
MessageBox.Show("保存成功");
}
else
{
}
}
}
