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; }