/// <summary> /// 將資料寫入資料庫中 /// </summary> private void RunInsertData() { try { My.MyDatabase MyDb = new My.MyDatabase(); SIS.Configuration.ClsShipConfig CSC = new Configuration.ClsShipConfig(); CSC.ShipID = txtShipID.Text; CSC.ShipDate = dtpShipDate.Value.ToString("yyyy年MM月dd日"); CSC.TotalPreTax = int.Parse(txtTotalPreTax.Text); CSC.Tax = int.Parse(txtTax.Text); CSC.TotalAfterTax = int.Parse(txtTotalAfterTax.Text); CSC.CustomerID = cboCustomer.Text.Substring(0, cboCustomer.Text.IndexOf("-")); CSC.BusinessTaxShipTaxRate = int.Parse(txtBusinessTaxShipTaxRate.Text); CSC.AmountPaid = int.Parse(mtbAmountPaid.Text); CSC.UnpaidAmount = int.Parse(txtUnpaidAmount.Text); CSC.ShipStaff = cboShipStaff.Text; CSC.PaymentType = cboPaymentType.Text.Split('-')[1]; CSC.Notes = rtbNotes.Text.Replace("'", "''"); CSC.ShipItems = getItemsValueFromDataGridView(dgvShipDetails); SIS.DBClass.DBClassShipMaster DBCSM = new DBClass.DBClassShipMaster(); if (MyDb.AuthPK(CSC.ShipID, "ShipID", "ShipMaster") == false) { if (DBCSM.InsertData(CSC)) { MessageBox.Show("新增[" + CSC.ShipID + "]出貨單資料成功", "新增出貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDefaultValue(); } else { MessageBox.Show("新增[" + CSC.ShipID + "]出貨單資料失敗", "新增出貨單資料", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("對不起,資料庫已存在[ " + CSC.ShipID + " ]出貨單資料!!(資料重複)", "資料新增"); } } catch (Exception ex) { MessageBox.Show("錯誤訊息:" + ex.Message.ToString(), "發生例外"); } }