private void button9_Click(object sender, EventArgs e)
{
plan p = new plan();
p.FormClosed += new FormClosedEventHandler(FormClosed);
p.Show();
this.Hide();
}
private bool checkAll()
{
bool pass = true;
//以下檢查客戶有無選擇
if (comboBox1.SelectedIndex == -1 && !comboBox1.Text.Trim().Equals(""))
{
DialogResult dialogResult;
dialogResult = MessageBox.Show("找不到這個客戶，新增嗎？", "新增客戶", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
string s = comboBox1.Text;
Customer c = new Customer(s);
c.ShowDialog();
myds.Tables["客戶資料表"].Clear();
MySqlDataAdapter customerAdapter = new MySqlDataAdapter("SELECT * FROM 客戶資料表; ", conn); //客戶資料用臨時變壓器
customerAdapter.Fill(myds, "客戶資料表");
comboBox1.SelectedIndex = comboBox1.FindStringExact(s);
}
pass = false;
}
else if (comboBox1.SelectedIndex == -1)
{
pass = false;
MessageBox.Show("請檢查是否有未填欄位！");
}
//以下檢查數量是否都有填入，出貨後庫存量是否有負數
foreach (DataGridViewRow v in dataGridView1.Rows)
{
if (v.Cells["數量"].Value == null && !v.IsNewRow)
{
pass = false;
MessageBox.Show("請檢查是否有未填欄位！");
}
if (v.Cells["出貨後數量"].Style.ForeColor == Color.Red)
{
DialogResult dialogResult;
dialogResult = MessageBox.Show("注意：有庫存量不足的情況！\n是否排定生產計畫？", "生產單建立", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
plan pp = new plan();
pp.ShowDialog();
}
}
}
return(pass);
}
private void 低於ROP()
{
Predict p = new Predict();
foreach (DataGridViewRow v in dataGridView1.Rows)
{
p.setI(int.Parse(v.Cells["品號"].Value.ToString()));
double a = int.Parse(v.Cells["出貨後數量"].Value.ToString());
double b = p.ROP();
if (a < b)
{
DialogResult dialogResult = MessageBox.Show("品號：" + v.Cells["品號"].Value.ToString() + "剩餘數量低於ROP點", "要安排生產計畫嗎？", MessageBoxButtons.YesNoCancel);
if (dialogResult == DialogResult.Yes)
{
plan pp = new plan(v.Cells["品號"].Value.ToString(), p.EOQ().ToString());
pp.ShowDialog();
}
p.Show();
}
}
}
