private bool checkAll()
{
bool pass = true;
//以下檢查數量是否都有填入，出貨後庫存量是否有負數
foreach (DataGridViewRow v in dataGridView1.Rows)
{
if (v.Cells["數量"].Value == null && !v.IsNewRow)
{
pass = false;
MessageBox.Show("請檢查是否有未填欄位！");
}
if (v.Cells["訂單編號"].Value == null && !v.IsNewRow)
{
pass = false;
MessageBox.Show("請檢查是否有未填欄位！");
}
if (v.Cells["出貨後數量"].Style.ForeColor == Color.Red)
{
pass = false;
DialogResult dialogResult;
dialogResult = MessageBox.Show("注意：有庫存量不足的情況！\n是否排定生產單？", "生產單建立", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
produce p = new produce();
p.ShowDialog();
}
}
}
return(pass);
}
private void button8_Click(object sender, EventArgs e)
{
produce p = new produce();
p.FormClosed += new FormClosedEventHandler(FormClosed);
p.Show();
this.Hide();
}
public MouldSelect(produce value)
{
InitializeComponent();
string dbHost = "localhost"; //資料庫位址
string dbPort = "3306"; //資料庫的port
string dbUser = "******"; //資料庫使用者帳號
string dbPass = "******"; //資料庫使用者密碼
string dbName = "Seminar"; //資料庫名稱
string connStr = "server=" + dbHost + ";port=" + dbPort + ";uid=" + dbUser + ";pwd=" + dbPass + ";database=" + dbName;
conn = new MySqlConnection(connStr);
command = conn.CreateCommand();
toAdded = value;
}
