public void addpurchase(purchase_material p)
{
MySqlConnection conn = Util.Util.getConn();
MySqlCommand command;
try
{
command = conn.CreateCommand();
command.CommandText = "INSERT INTO purchase_material(rawMaterial_number,suppliernumber,unit,count,price,money,remark,dan_date,status,danju_id) VALUES(@rawMaterial_id,@supplierid,@unit,@count,@price,@money,@remark,@dan_date,@status,@danju_id)";
command.Parameters.AddWithValue("@rawMaterial_id", p.RawMaterial_number);
command.Parameters.AddWithValue("@supplierid", p.Suppliernumber);
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("@status", p.Status);
command.Parameters.AddWithValue("@danju_id", p.Danju_id);
command.ExecuteNonQuery();
//MessageBox.Show("插入成功");
}
catch (Exception)
{
MessageBox.Show("插入失败");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
//根据日期和供应商、原材料名称查询purchase_material表中status为0的数据
public List <purchase_material> selectMaterial_dateandrnameandsupplier(DateTime date1, DateTime date2, string suppliernumber, string name, int status)
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
purchase_material r = null;
List <purchase_material> rs = new List <model.purchase_material>();
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM purchase_material where dan_date>='" + date1 + "' and dan_date<='" + date2 + "' and rawMaterial_number=(select rawMaterial_number from rawmaterial where rawMaterial_name like '%" + name + "%') and suppliernumber='" + suppliernumber + "' and status =" + status;
dataReader = command.ExecuteReader();
Console.WriteLine();
while (dataReader.Read())
{
r = new purchase_material();
r.Id = dataReader.GetInt16(0);
r.RawMaterial_number = dataReader.GetString(1);
r.Suppliernumber = 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.Status = dataReader.GetInt16(9);
r.Danju_id = dataReader.GetString(10);
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_1(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[] supplier = supplier_text.Text.Split(' ');
string[] employer = textBox3.Text.Split(' ');
try
{
purchase dao = new purchase();
double mm = Convert.ToDouble(label9.Text);
dao.addDanju(Convert.ToDateTime(dateTimePicker1.Text), textBox1.Text, employer[0], mm, textBox4.Text, supplier[0], 1);
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
purchase_material p = new purchase_material();
Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla");
p.RawMaterial_number = dataGridView1.Rows[i].Cells[0].Value.ToString();
p.Suppliernumber = supplier[0];
p.Dan_date = Convert.ToDateTime(dateTimePicker1.Text);
Console.Write("这是一个人" + p.Suppliernumber + "这是一个人");
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.Status = 1;
p.Danju_id = textBox1.Text;
// Console.Write("这是一个人" + p.Danju_id + "这是一个人");
dao.addpurchase(p);
}
MessageBox.Show("保存成功");
}
catch (SystemException)
{
MessageBox.Show("操作有误");
}
}
else
{
}
}
}
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 (supplier_text.Text == "")
{
MessageBox.Show("请选择供应商");
b = false;
}
}
}
if (b == false)
{
}
else
{
purchase dao = new purchase();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
purchase_material p = new purchase_material();
Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla");
p.RawMaterial_number = dataGridView1.Rows[i].Cells[0].Value.ToString();
p.Suppliernumber = supplier_text.Text;
p.Dan_date = Convert.ToDateTime(dateTimePicker1.Text);
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);
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.Status = 1;
dao.addpurchase(p);
}
MessageBox.Show("保存成功");
}
}
