private void btnWHHistory_Click(object sender, EventArgs e) { using (MySqlConnection CnnMySQL = ServerHelper.ConnectToMySQL()) { using (MySqlTransaction TranMySQL = CnnMySQL.BeginTransaction()) { try { WHIOType IOType = WHIOType.Input; for (int i = 1; i < 1000; i++) { WHHistory WHHistory = new WHHistory(); WHHistory.TranMySQL = TranMySQL; WHHistory.ItemNo = "01TX0015"; WHHistory.IOType = IOType; WHHistory.OKQty = 111; WHHistory.CreatedBy = "Kenneth"; WHHistory.CreatedDate = DateTime.Now; WHHistory.CnnMySQL = CnnMySQL; WHHistory.Save(); if (IOType == WHIOType.Input) IOType = WHIOType.Output; else IOType = WHIOType.Input; } TranMySQL.Commit(); } catch (Exception ex) { MessageBox.Show(ex.Message); TranMySQL.Rollback(); } } MessageBox.Show("OK"); } }
public void DeductWH() { if (OrderStatus != "Waiting") return; WHHistory WHHistory = new WHHistory(); WHHistory.ItemNo = ItemNo; WHHistory.ItemName = ItemName; WHHistory.ItemType = ItemType; WHHistory.RefNo = OrderNo; WHHistory.RefType = "SO"; WHHistory.OKQty = MoveQty; WHHistory.VendDefectQty = 0; WHHistory.DefectQty = 0; //WHHistory.OK = "ok"; WHHistory.Supplier = Destination; WHHistory.Status = "Complete"; WHHistory.IOType = WHIOType.Output; WHHistory.Save(); ChangeStatus("TSI"); UpdateAllRecord(); }