private void frmPinMd5_FormClosed(object sender, FormClosedEventArgs e) { if (this.Caller is Penjualan.TabelDO) { if (_bagian != PinId.Bagian.Harga) { Penjualan.TabelDO frmCaller = (Penjualan.TabelDO) this.Caller; frmCaller.RefreshDataDO(); try { frmCaller.FindHeader("RowID", _rowID.ToString()); } catch { }; } else { Penjualan.TabelDO frm = (Penjualan.TabelDO)Caller; frm.RefreshDataDetailDO(); } } else if (this.Caller is Penjualan.frmNotaJualBrowser) { Penjualan.frmNotaJualBrowser frmCaller = (Penjualan.frmNotaJualBrowser) this.Caller; frmCaller.RefreshDataDO(); } else if (this.Caller is Penjualan.frmNotaReturJualBrowse) { Penjualan.frmNotaReturJualBrowse frmCaller = (Penjualan.frmNotaReturJualBrowse) this.Caller; frmCaller.RefreshDataReturJual(); } else if (this.Caller is Penjualan.frmNotaJualUpdate) { Penjualan.frmNotaJualUpdate frmCaller = (Penjualan.frmNotaJualUpdate) this.Caller; frmCaller.RefreshDataNota(); } else if (this.Caller is Penjualan.frmPotonganNotaBrowse) { Penjualan.frmPotonganNotaBrowse frmCaller = (Penjualan.frmPotonganNotaBrowse) this.Caller; frmCaller.RefreshData(); frmCaller.FindHeader("RowID", _rowID.ToString()); } }
private void cmdSave_Click(object sender, EventArgs e) { if (IsValid()) { try { switch (formMode) { case enumFormMode.New: string doc = "NOMOR_POTONGAN"; string depan = ""; string belakang = ""; string NoPot = ""; int iNomor; int lebar; depan = Tools.GeneralInitial(); DataTable dtNum = Tools.GetGeneralNumerator(doc); lebar = int.Parse(Tools.isNull(dtNum.Rows[0]["Lebar"], "0").ToString()); belakang = dtNum.Rows[0]["Belakang"].ToString(); if (Tools.isNull(dtNum.Rows[0]["Depan"], "").ToString() != depan) { iNomor = 1; } else { iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString()); iNomor++; } NoPot = Tools.FormatNumerator(iNomor, lebar, depan, belakang); txtNoPot.Text = Tools.isNull(NoPot, "").ToString(); using (Database db = new Database()) { DataTable dtCek = new DataTable(); db.Commands.Add(db.CreateCommand("usp_PenjualanPotongan_CEK")); db.Commands[0].Parameters.Add(new Parameter("@notaPenjualanID", SqlDbType.UniqueIdentifier, _row)); dtCek = db.Commands[0].ExecuteDataTable(); if (dtCek.Rows.Count > 0) { MessageBox.Show("Nota ini sudah ada Potongan."); return; } } MessageBox.Show(trID.ToString()); using (Database db = new Database()) { _rowID = Guid.NewGuid(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_PenjualanPotongan_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@notaPenjualanID", SqlDbType.UniqueIdentifier, _row)); db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, trID)); db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@noPot", SqlDbType.VarChar, txtNoPot.Text)); db.Commands[0].Parameters.Add(new Parameter("@tglPot", SqlDbType.DateTime, txtTglPot.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@dil", SqlDbType.Money, Convert.ToDouble(txtPotLumRp.Text))); db.Commands[0].Parameters.Add(new Parameter("@disc", SqlDbType.Money, Convert.ToDouble(txtPotLumPersen.Text))); db.Commands[0].Parameters.Add(new Parameter("@rpNet", SqlDbType.Money, Convert.ToDouble(txtNetto.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatPot.Text)); db.Commands[0].Parameters.Add(new Parameter("@tglACC", SqlDbType.DateTime, SqlDateTime.Null)); db.Commands[0].Parameters.Add(new Parameter("@dilACC", SqlDbType.Money, 0)); db.Commands[0].Parameters.Add(new Parameter("@catACC", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@discACC", SqlDbType.Money, 0)); db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@idLink", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); db.Commands.Add(db.CreateCommand("usp_Numerator_UPDATE")); db.Commands[1].Parameters.Add(new Parameter("@doc", SqlDbType.VarChar, doc)); db.Commands[1].Parameters.Add(new Parameter("@depan", SqlDbType.VarChar, depan)); db.Commands[1].Parameters.Add(new Parameter("@belakang", SqlDbType.VarChar, belakang)); db.Commands[1].Parameters.Add(new Parameter("@nomor", SqlDbType.Int, iNomor)); db.Commands[1].Parameters.Add(new Parameter("@lebar", SqlDbType.VarChar, lebar)); db.Commands[1].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[1].ExecuteNonQuery(); } break; case enumFormMode.Update: if (txtTglACC.DateValue.HasValue) { GlobalVar.LastClosingDate = (DateTime)txtTglACC.DateValue; if ((DateTime)txtTglACC.DateValue <= GlobalVar.LastClosingDate) { throw new Exception(String.Format(ISA.Trading.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate)); } } using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_PenjualanPotongan_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@notaPenjualanID", SqlDbType.UniqueIdentifier, _row)); db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, trID)); db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.VarChar, potID)); db.Commands[0].Parameters.Add(new Parameter("@noPot", SqlDbType.VarChar, txtNoPot.Text)); db.Commands[0].Parameters.Add(new Parameter("@tglPot", SqlDbType.DateTime, txtTglPot.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@dil", SqlDbType.Money, Convert.ToDouble(txtPotLumRp.Text))); //db.Commands[0].Parameters.Add(new Parameter("@disc", SqlDbType.Money, Convert.ToDouble(txtPotLumPersen.Text))); db.Commands[0].Parameters.Add(new Parameter("@rpNet", SqlDbType.Money, Convert.ToDouble(txtNetto.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatPot.Text)); if (ajukan == true) { db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0)); } else if (acc == true) { if (Convert.ToDouble(txtACCRp.Text) > 0) { db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 1)); } else { db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0)); } } db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); //db.Commands[0].Parameters.Add(new Parameter("@idLink", SqlDbType.VarChar, "")); //db.Commands[0].Parameters.Add(new Parameter("@discACC", SqlDbType.Decimal, Convert.ToDecimal(txtACCPersen.Text))); //db.Commands[0].Parameters.Add(new Parameter("@tglACC", SqlDbType.DateTime, txtTglACC.DateValue)); //db.Commands[0].Parameters.Add(new Parameter("@dilACC", SqlDbType.Money, Math.Round(Convert.ToDouble(txtACCRp.Text), 0))); //db.Commands[0].Parameters.Add(new Parameter("@catACC", SqlDbType.VarChar, txtCatACC.Text)); } //if (LookupInfo.GetValue("INSTALL_MODULE", "PIUTANG").ToString() == "True") //{ // if (ajukan == false) // { // if (acc == true && txtACCRp.GetDoubleValue > 0) // { // LinkToPiutang(); // } // } //} break; } MessageBox.Show("Data telah tersimpan"); this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } finally { Penjualan.frmPotonganNotaBrowse frmCaller = (frmPotonganNotaBrowse)this.Caller; frmCaller.RefreshData(); frmCaller.FindRow("RowID", _rowID.ToString()); this.Close(); frmCaller.Show(); } } }