private void cmdSAVE_Click(object sender, EventArgs e) { if (txtNoKoreksi.Text == "") { MessageBox.Show("No Koreksi tidah boleh kosong"); return; } if (txtQtyNota2.GetIntValue - txtQtyNota1.GetIntValue == 0) { ErrorProvider ep = new ErrorProvider(); ep.SetError(txtQtyNota2, "Tidak bisa diisi dengan nilai sama dengan Qty Nota sebelumnya!"); return; } try { GlobalVar.LastClosingDate = (DateTime)txtTglKoreksi.DateValue; if (txtTglKoreksi.DateValue <= GlobalVar.LastClosingDate) { throw new Exception(String.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate)); } double hrgKoreksi = double.Parse(txtHrgNetto2.Text) - double.Parse(txtHrgNetto1.Text); int qtyKoreksi = txtQtyNota2.GetIntValue - txtQtyNota1.GetIntValue; if (qtyKoreksi < 0) { #region "Stok Minus Lock New" using (Stock st = new Stock()) { st.AddList(_dtReturJualDetail.Rows[0]["BarangID"].ToString(), "", Math.Abs(qtyKoreksi)); // pass = st.Pass(); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses,\n nilai transaksi menyebabkan stok minus! ", "Warning"); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } this.Close(); return; } } #endregion } this.Cursor = Cursors.WaitCursor; _rowID = Guid.NewGuid(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_KoreksiReturPenjualan_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@returJualDetailID", SqlDbType.UniqueIdentifier, _dtReturJualDetail.Rows[0]["RowID"])); db.Commands[0].Parameters.Add(new Parameter("@returJualDetailRecID", SqlDbType.VarChar, _dtReturJualDetail.Rows[0]["RecordID"])); db.Commands[0].Parameters.Add(new Parameter("@tglKoreksi", SqlDbType.DateTime, txtTglKoreksi.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, _dtReturJualDetail.Rows[0]["BarangID"])); db.Commands[0].Parameters.Add(new Parameter("@noKoreksi", SqlDbType.VarChar, txtNoKoreksi.Text)); db.Commands[0].Parameters.Add(new Parameter("@qtyNotaBaru", SqlDbType.Int, txtQtyNota2.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@hrgJualBaru", SqlDbType.Money, double.Parse(txtHrgSatuan2.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatatan2.Text)); db.Commands[0].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _dtReturJual.Rows[0]["KodeToko"])); db.Commands[0].Parameters.Add(new Parameter("@sumber", SqlDbType.VarChar, "NRJ")); db.Commands[0].Parameters.Add(new Parameter("@linkID", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@hrgJualKoreksi", SqlDbType.Money, hrgKoreksi)); db.Commands[0].Parameters.Add(new Parameter("@qtyNotaKoreksi", SqlDbType.Int, qtyKoreksi)); 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(); } this.DialogResult = DialogResult.OK; MessageBox.Show("Data telah disimpan"); this.Close(); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }
private void InsertKoreksi() { try { double hrgKoreksi = double.Parse(txtHrgNet2.Text) - double.Parse(txtHrgNet1.Text); int qtyKoreksi = txtQtyNota2.GetIntValue - txtQtyNota1.GetIntValue; #region "Stok Minus Lock New" if (qtyKoreksi < 0) { using (Stock st = new Stock()) { st.AddList(dtNotaBeliDetail.Rows[0]["BarangID"].ToString(), "", Math.Abs(qtyKoreksi)); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses,\n nilai transaksi menyebabkan stok minus! ", "Warning"); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } this.Close(); return; } } } #endregion this.Cursor = Cursors.WaitCursor; _rowID = Guid.NewGuid(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_KoreksiPembelian_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@notaBeliDetailID", SqlDbType.UniqueIdentifier, dtNotaBeliDetail.Rows[0]["RowID"])); db.Commands[0].Parameters.Add(new Parameter("@notaBeliDetailRecID", SqlDbType.VarChar, dtNotaBeliDetail.Rows[0]["RecordID"])); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, dtNotaBeliDetail.Rows[0]["BarangID"])); db.Commands[0].Parameters.Add(new Parameter("@tglKoreksi", SqlDbType.DateTime, txtTglKoreksi.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@noKoreksi", SqlDbType.VarChar, txtNoKoreksi.Text)); db.Commands[0].Parameters.Add(new Parameter("@qtyNotaBaru", SqlDbType.Int, txtQtyNota2.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@hrgBeliBaru", SqlDbType.Money, double.Parse(txtHrgBeli2.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@pemasok", SqlDbType.VarChar, dtNotaBeliDetail.Rows[0]["Pemasok"])); db.Commands[0].Parameters.Add(new Parameter("@sumber", SqlDbType.VarChar, "NPB")); db.Commands[0].Parameters.Add(new Parameter("@linkID", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@hrgBeliKoreksi", SqlDbType.Money, hrgKoreksi)); db.Commands[0].Parameters.Add(new Parameter("@qtyNotaKoreksi", SqlDbType.Int, qtyKoreksi)); 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(); } this.DialogResult = DialogResult.OK; MessageBox.Show("Data telah disimpan"); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }
private void cmdSave_Click(object sender, EventArgs e) { switch (formMode) { case enumFormMode.New: try { this.Cursor = Cursors.WaitCursor; if (lookupStock.BarangID == "") { lookupStock.Focus(); return; } if (txtQtyDO.GetIntValue <= 0 || txtQtyKirim.GetIntValue < 0) { txtQtyDO.Focus(); return; } #region "Stok Minus Lock New" using (Stock st = new Stock()) { st.AddList(lookupStock.BarangID, "", txtQtyKirim.GetIntValue); // pass = st.Pass(); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses,\n nilai transaksi menyebabkan stok minus! ", "Warning"); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } txtQtyKirim.Focus(); txtQtyKirim.SelectAll(); return; } } #endregion using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_AntarGudangDetail_Insert")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, Guid.NewGuid())); db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, _HeaderID)); db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@TransactionID", SqlDbType.VarChar, _TransactionID)); db.Commands[0].Parameters.Add(new Parameter("@QtyDO", SqlDbType.Int, txtQtyDO.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@QtyKirim", SqlDbType.Int, txtQtyKirim.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@QtyTerima", SqlDbType.Int, txtQtyTerima.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, lookupStock.BarangID)); db.Commands[0].Parameters.Add(new Parameter("@Catatan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@Ongkos", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dt = db.Commands[0].ExecuteDataTable(); if (dt.Rows.Count > 0) { MessageBox.Show("Kode barang:" + lookupStock.BarangID + " tidak bisa diinput dua kali"); lookupStock.Focus(); return; } } using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("psp_StokGudang_Recalculation")); db.Commands[0].Parameters.Add(new Parameter("@gudangID", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, lookupStock.BarangID)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } this.DialogResult = DialogResult.OK; if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmAntarGudang) { ArusStock.frmAntarGudang frmcaller = (ArusStock.frmAntarGudang) this.Caller; frmcaller.RefreshDetail(); frmcaller.FindDetail("RowIDD", _RowID.ToString()); } } cmdClose.PerformClick(); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } break; case enumFormMode.Update: try { this.Cursor = Cursors.WaitCursor; #region "Stok Minus Lock Update" if (_DrGudang == GlobalVar.Gudang) { using (Stock st = new Stock()) { st.AddList(lookupStock.BarangID, "", txtQtyKirim.GetIntValue - VBefore); // pass = st.Pass(); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses ", "Warning"); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } txtQtyKirim.Focus(); txtQtyKirim.SelectAll(); return; } } } #endregion using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_AntarGudangDetail_Update")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID)); db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, _HeaderID)); db.Commands[0].Parameters.Add(new Parameter("@QtyDO", SqlDbType.Int, txtQtyDO.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@QtyKirim", SqlDbType.Int, txtQtyKirim.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@QtyTerima", SqlDbType.Int, txtQtyTerima.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, lookupStock.BarangID)); db.Commands[0].Parameters.Add(new Parameter("@Catatan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dt = db.Commands[0].ExecuteDataTable(); if (dt.Rows.Count > 0) { MessageBox.Show("Kode barang:" + lookupStock.BarangID + " tidak bisa diinput dua kali"); lookupStock.Focus(); return; } } using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("psp_StokGudang_Recalculation")); db.Commands[0].Parameters.Add(new Parameter("@gudangID", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, lookupStock.BarangID)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } break; } this.DialogResult = DialogResult.OK; if (formMode == enumFormMode.New) { //MessageBox.Show("Data telah tersimpan"); lookupStock.NamaStock = ""; lookupStock.BarangID = ""; txtCatatan.Text = ""; txtQtyDO.Text = "0"; txtQtyKirim.Text = "0"; txtQtyTerima.Text = "0"; } else { cmdClose.PerformClick(); } }
private void cmdSave_Click(object sender, EventArgs e) { if (!ValidateInput()) { return; } try { this.Cursor = Cursors.WaitCursor; _notaIDBaru = Guid.Empty; string notaRecID = ""; string catatan = cboKategori.SelectedValue.ToString() + " " + txtCatatan.Text; if (cboKodeRetur.SelectedValue.ToString() == "1") { _notaIDBaru = (Guid)dtNota.Rows[0]["RowID"]; notaRecID = dtNota.Rows[0]["RecordID"].ToString(); } switch (_formMode) { case enumFormMode.New: #region "Stok Minus Lock New" using (Stock st = new Stock()) { st.AddList(lookupStock.BarangID, "", txtQtyGudang.GetIntValue); // pass = st.Pass(); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses,\n nilai transaksi menyebabkan stok minus! ", "Warning"); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } this.Close(); return; } } #endregion _rowID = Guid.NewGuid(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_ReturPembelianDetail_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _headerID)); db.Commands[0].Parameters.Add(new Parameter("@notaBeliDetailID", SqlDbType.UniqueIdentifier, _notaIDBaru)); db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@returID", SqlDbType.VarChar, dtReturHeader.Rows[0]["ReturID"])); db.Commands[0].Parameters.Add(new Parameter("@notaBeliDetailRecID", SqlDbType.VarChar, notaRecID)); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, lookupStock.BarangID)); db.Commands[0].Parameters.Add(new Parameter("@KodeRetur", SqlDbType.VarChar, cboKodeRetur.SelectedValue.ToString())); db.Commands[0].Parameters.Add(new Parameter("@qtyGudang", SqlDbType.Int, txtQtyGudang.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@qtyTerima", SqlDbType.Int, txtQtyGudang.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@hrgBeli", SqlDbType.Money, double.Parse(txtHrgBeli.Text))); db.Commands[0].Parameters.Add(new Parameter("@hrgNet", SqlDbType.Money, 0)); db.Commands[0].Parameters.Add(new Parameter("@hrgPokok", SqlDbType.Money, double.Parse(txtHrgBeli.Text))); db.Commands[0].Parameters.Add(new Parameter("@hppSolo", SqlDbType.Money, double.Parse(txtHrgBeli.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, catatan)); db.Commands[0].Parameters.Add(new Parameter("@TglKeluar", SqlDbType.DateTime, dtReturHeader.Rows[0]["TglKeluar"])); db.Commands[0].Parameters.Add(new Parameter("@kodeGudang", SqlDbType.VarChar, GlobalVar.Gudang)); 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].ExecuteDataTable(); } this.DialogResult = DialogResult.OK; MessageBox.Show("Data telah disimpan"); this.Clear(); lookupStock.Focus(); break; case enumFormMode.Update: #region "Stok Minus Lock New" using (Stock st = new Stock()) { st.AddList(lookupStock.BarangID, "", txtQtyGudang.GetIntValue - _qtyBefore); // pass = st.Pass(); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } this.Close(); return; } } #endregion using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_ReturPembelianDetail_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _headerID)); db.Commands[0].Parameters.Add(new Parameter("@notaBeliDetailID", SqlDbType.UniqueIdentifier, _notaIDBaru)); db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, dtReturDetail.Rows[0]["RecordID"])); db.Commands[0].Parameters.Add(new Parameter("@returID", SqlDbType.VarChar, dtReturDetail.Rows[0]["ReturID"])); db.Commands[0].Parameters.Add(new Parameter("@notaBeliDetailRecID", SqlDbType.VarChar, notaRecID)); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, lookupStock.BarangID)); db.Commands[0].Parameters.Add(new Parameter("@KodeRetur", SqlDbType.VarChar, cboKodeRetur.SelectedValue.ToString())); db.Commands[0].Parameters.Add(new Parameter("@qtyGudang", SqlDbType.Int, txtQtyGudang.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@qtyTerima", SqlDbType.Int, txtQtyGudang.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@hrgBeli", SqlDbType.Money, double.Parse(txtHrgBeli.Text))); db.Commands[0].Parameters.Add(new Parameter("@hrgNet", SqlDbType.Money, 0)); db.Commands[0].Parameters.Add(new Parameter("@hrgPokok", SqlDbType.Money, double.Parse(txtHrgBeli.Text))); db.Commands[0].Parameters.Add(new Parameter("@hppSolo", SqlDbType.Money, double.Parse(txtHrgBeli.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, catatan)); db.Commands[0].Parameters.Add(new Parameter("@TglKeluar", SqlDbType.DateTime, dtReturDetail.Rows[0]["TglKeluar"])); db.Commands[0].Parameters.Add(new Parameter("@kodeGudang", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteDataTable(); } this.DialogResult = DialogResult.OK; MessageBox.Show("Data telah disimpan"); this.Close(); break; } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }
private void InsertDataTypeSeimbang() { if (ctr < 2) { if (kodeBarang[0] == lookupStock1.BarangID && ctr == 1) { MessageBox.Show("Kode Barang: " + lookupStock1.BarangID + " tidak dapat diinput lebih dari satu kali"); lookupStock1.Focus(); return; } newGuid[ctr] = Guid.NewGuid(); qtyMutasi[ctr] = txtJumlah.GetIntValue; kodeBarang[ctr] = lookupStock1.BarangID; keterangan[ctr] = txtCatatan.Text; txtJumlah.Text = "-" + txtJumlah.Text; txtCatatan.Text = string.Empty; lookupStock1.ResetAll(); txtJumlah.Enabled = false; ctr++; if (ctr == 2) { #region "Stok Minus Lock New" using (Stock st = new Stock()) { st.AddList(kodeBarang[1], "", Math.Abs(qtyMutasi[1])); // pass = st.Pass(); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses,\n nilai transaksi menyebabkan stok minus! ", "Warning"); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } this.DialogResult = DialogResult.No; cmdCancel.PerformClick(); return; } } #endregion try { this.Cursor = Cursors.WaitCursor; using (Database db = new Database()) { //_rowID = ; DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_MutasiDetail_Insert")); for (int i = 0; i <= 1; i++) { db.Commands[0].Parameters.Clear(); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, newGuid[i])); db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, _headerID)); db.Commands[0].Parameters.Add(new Parameter("@MutasiID", SqlDbType.VarChar, _MutasiID)); db.Commands[0].Parameters.Add(new Parameter("@QtyMutasi", SqlDbType.Int, qtyMutasi[i])); db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, kodeBarang[i])); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, keterangan[i])); db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].Parameters.Add(new Parameter("@kdGudang", SqlDbType.VarChar, GlobalVar.Gudang)); dt = db.Commands[0].ExecuteDataTable(); } this.DialogResult = DialogResult.OK; CloseForm(); cmdCancel.PerformClick(); } } catch (System.Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } } } }
private void cmdAdd_Click(object sender, EventArgs e) { ///MessageBox.Show(Tools.AutoNumbering("NoNota", "ISADBDepoRetail.dbo.NotaPenjualan").ToString()); //return; dt.AcceptChanges(); double _totalHrg = 0;// double.Parse(dt.Compute("SUM(TotalHrg)", string.Empty).ToString()); int x = 0; double _disc1 = 0; double _disc2 = 0; double _disc3 = 0; double _discFormula = 0; double _harga3D = 0; bool isBonusan = false; if (!Validasichecker()) { return; } #region "Stok Minus Lock New" DataRow[] dr1 = dt.Select("QtySisa>0 AND StatusDO='BOLEH'"); using (Stock st = new Stock()) { foreach (DataRow drd in dr1) { st.AddList(drd["BarangID"].ToString(), "", Convert.ToInt32(drd["QtySisa"])); } // pass = st.Pass(); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses,\n nilai transaksi menyebabkan stok minus! ", "Warning"); if (MessageBox.Show("Batal Seluruh Nota ?", "Batal", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } this.DialogResult = DialogResult.No; this.Close(); return; } else { st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } for (int i = 0; i < st.GetListBarangs.Count; i++) { if (st.ListBarangs(i).SaldoStok - st.ListBarangs(i).QtyTrans < 0) { var rows = dt.Select("BarangID='" + st.ListBarangs(i).KodeBarang + "'"); foreach (var row in rows) { row.Delete(); } dt.AcceptChanges(); } } } } } int sum = 0; for (int i = 0; i < dataGridDetailDO.Rows.Count; ++i) { sum += Convert.ToInt32(dataGridDetailDO.Rows[i].Cells["QtyNota"].Value); } if (sum == 0) { MessageBox.Show("Tidak bisa simpan record dengan Qty. Nota = 0. Mohon diisi Qty. Nota atau batalkan", "Cak Qty Nota"); return; } #endregion //#region RpaccPiutang //DataTable dtt = new DataTable(); //dtt = dt.Copy(); //dr1 = dtt.Select("QtySisa>0 AND StatusDO='BOLEH'"); //double _RpDO = 0; //int xx = 0; //foreach (DataRow drr in dr1) //{ // xx++; // double qtDo = double.Parse(Tools.isNull(drr["QtySisa"], "0").ToString()); // double Hrjl = double.Parse(Tools.isNull(drr["HrgJual"], "0").ToString()); // double RpDo = qtDo * Hrjl; // _disc1 = double.Parse(Tools.isNull(drr["Disc1"], "0").ToString()); // _disc2 = double.Parse(Tools.isNull(drr["Disc2"], "0").ToString()); // _disc3 = double.Parse(Tools.isNull(drr["Disc3"], "0").ToString()); // if (drr["DiscFormula"].ToString() == string.Empty) // { // _discFormula = 0; // } // DataTable dtNet3 = new DataTable(); // using (Database db = new Database()) // { // db.Commands.Add(db.CreateCommand("usp_GetNet3Disc")); // db.Commands[0].Parameters.Add(new Parameter("@jmlHrg", SqlDbType.Money, RpDo)); // db.Commands[0].Parameters.Add(new Parameter("@disc1", SqlDbType.Decimal, _disc1)); // db.Commands[0].Parameters.Add(new Parameter("@disc2", SqlDbType.Decimal, _disc2)); // db.Commands[0].Parameters.Add(new Parameter("@disc3", SqlDbType.Decimal, _disc3)); // db.Commands[0].Parameters.Add(new Parameter("@discFormula", SqlDbType.VarChar, _discFormula)); // dtNet3 = db.Commands[0].ExecuteDataTable(); // } // if (drr["BarangID"].ToString().Substring(0, 3).Equals("FXB")) // _RpDO = _RpDO + 0; // else // _RpDO = _RpDO + double.Parse(Tools.isNull(dtNet3.Rows[0]["HrgNet3Disc"], "0").ToString()); //} //if (_RpDO > _rpSisaACCPiutang) //{ // MessageBox.Show("Nilai Nota Rp. " + _RpDO + "\n Lebih besar dari nilai ACC piutang Rp. " // + _rpACCPiutang + "\nProsess pembuatan nota tidak dapat dilanjutkan"); // this.DialogResult = DialogResult.No; // this.Close(); // return; //} //if (xx==0) //{ // DataTable dtBonus = new DataTable(); // dtBonus = dt.Copy(); // DataRow[] drBonus = dtBonus.Select("BarangID LIKE 'FXB%'"); // if (dt.Rows.Count > 0 && drBonus.Length == dt.Rows.Count) // { // isBonusan = true; // } // if (!isBonusan) // { // MessageBox.Show("Nilai DO : 0 \nProsess pembuatan nota tidak dapat dilanjutkan"); // this.DialogResult = DialogResult.No; // this.Close(); // return; // } //} //#endregion //for (x=0; x < dt.Rows.Count; x++) //{ // double qtDo = double.Parse(Tools.isNull(dt.Rows[x]["QtySisa"], "0").ToString()); // double Hrjl = double.Parse(Tools.isNull(dt.Rows[x]["HrgJual"], "0").ToString()); // _totalHrg = qtDo * Hrjl; // //_totalHrg = double.Parse(Tools.isNull(dt.Rows[x]["TotalHrg"], "").ToString()); // _disc1 = double.Parse(Tools.isNull(dt.Rows[x]["Disc1"], "").ToString()); // _disc2 = double.Parse(Tools.isNull(dt.Rows[x]["Disc2"], "").ToString()); // _disc3 = double.Parse(Tools.isNull(dt.Rows[x]["Disc3"], "").ToString()); // if (dt.Rows[x]["DiscFormula"].ToString() == string.Empty) // { // _discFormula = 0; // } // DataTable dtNet3Disc = new DataTable(); // using (Database db = new Database()) // { // db.Commands.Add(db.CreateCommand("usp_GetNet3Disc")); // db.Commands[0].Parameters.Add(new Parameter("@jmlHrg", SqlDbType.Money, _totalHrg)); // db.Commands[0].Parameters.Add(new Parameter("@disc1", SqlDbType.Decimal, _disc1)); // db.Commands[0].Parameters.Add(new Parameter("@disc2", SqlDbType.Decimal, _disc2)); // db.Commands[0].Parameters.Add(new Parameter("@disc3", SqlDbType.Decimal, _disc3)); // db.Commands[0].Parameters.Add(new Parameter("@discFormula", SqlDbType.VarChar, _discFormula)); // dtNet3Disc = db.Commands[0].ExecuteDataTable(); // } // if (dt.Rows[x]["BarangID"].ToString().Substring(0, 3).Equals("FXB")) // _harga3D =_harga3D+ 0; // else // _harga3D = _harga3D + double.Parse(Tools.isNull(dtNet3Disc.Rows[0]["HrgNet3Disc"], "0").ToString()); //} double _totalHrgNota = _harga3D; string cCab1 = dtDO.Rows[0]["Cabang1"].ToString().Trim(); string cCab2 = dtDO.Rows[0]["Cabang2"].ToString().Trim(); //if (_totalHrgNota > _rpSisaACCPiutang) //{ // if (cCab1 == GlobalVar.CabangID || cCab2 == GlobalVar.CabangID) // { // MessageBox.Show("Nilai Nota Rp. " + _totalHrgNota + "\nlebih besar dari nilai ACC piutang Rp. " // + _rpACCPiutang + "\nProsess pembuatan nota tidak dapat dilanjutkan"); // return; // } //} cCab1 = dtDO.Rows[0]["Cabang1"].ToString().Trim(); if (cCab1 == GlobalVar.CabangID) { //if (dtDO.Rows[0]["NoACCPiutang"].ToString() != "BONUSAN") //{ // if (_totalHrgNota > TokoPlafon.SisaPlafon(_kodeToko, _transType)) // { // MessageBox.Show("Tidak bisa buat nota. Nilai Nota melebihi Sisa Plafon toko. \n" + // "Silahkan melakukan pengajuan plafon ke PS HO"); // this.DialogResult = DialogResult.No; // return; // } //} } try { int k; int l; k = 0; l = 0; _notaHeaderRowID = Guid.NewGuid(); string _notaHeaderRecID = Tools.CreateShortFingerPrint(k); string _notaDetailRecID = string.Empty; // Add new Nota Penjualan Header this.Cursor = Cursors.WaitCursor; string temp = string.Empty; //Generate Nomor Nota string kodeNota = ""; string nomorNota = ""; string PTpattern = "KH,TH,KL,TL"; string depan = ""; string belakang = ""; int iNomor; int lebar; int lebarOriginal = 0; int ctr = 0; int lastCtr = 0; int ctrBef = 0; DataTable dtNum; int countRows = 0; if (IsTokoPT()) { string transType = _transType; if (PTpattern.Contains(transType)) { kodeNota = "NOMOR_NOTA_TAX_2"; } else { kodeNota = "NOMOR_NOTA_TAX"; } depan = GetInitialPT(); } else { if (Tools.Left(dtDO.Rows[0]["Cabang1"].ToString(), 1) == "9") { kodeNota = "NOMOR_NOTA_PS"; } else { kodeNota = "NOMOR_NOTA"; } depan = Tools.GeneralInitial(); } if (DateTime.Today <= GlobalVar.LastClosingDate) { throw new Exception(string.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate)); } //dtNum = Tools.GetGeneralNumerator(kodeNota, depan); //lebarOriginal = int.Parse(dtNum.Rows[0]["Lebar"].ToString()); //lebar = lebarOriginal; //iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString()); //belakang = dtNum.Rows[0]["Belakang"].ToString(); //iNomor++; //nomorNota = Tools.AutoNumbering("NoNota", "ISADBDepoRetail.dbo.NotaPenjualan"); nomorNota = _NoDo; //PROSES NOTA using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_NotaPenjualan_INSERT")); //udah cek heri db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _notaHeaderRowID)); db.Commands[0].Parameters.Add(new Parameter("@recID", SqlDbType.VarChar, _notaHeaderRecID)); //_notaHeaderRecID)); db.Commands[0].Parameters.Add(new Parameter("@DOID", SqlDbType.UniqueIdentifier, _doID)); db.Commands[0].Parameters.Add(new Parameter("@htrID", SqlDbType.VarChar, _doHtrID)); db.Commands[0].Parameters.Add(new Parameter("@noSJ", SqlDbType.VarChar, nomorNota)); //Tools.GetGeneralNumerator("NOMOR_NOTA").Rows[0].ToString())); db.Commands[0].Parameters.Add(new Parameter("@noNota", SqlDbType.VarChar, nomorNota)); db.Commands[0].Parameters.Add(new Parameter("@tglNota", SqlDbType.DateTime, GlobalVar.DateOfServer)); db.Commands[0].Parameters.Add(new Parameter("@tglSJ", SqlDbType.DateTime, DateTime.Today)); db.Commands[0].Parameters.Add(new Parameter("@tglTerima", SqlDbType.DateTime, SqlDateTime.Null)); db.Commands[0].Parameters.Add(new Parameter("@tglSerahTerimaChecker", SqlDbType.DateTime, SqlDateTime.Null)); db.Commands[0].Parameters.Add(new Parameter("@cabang1", SqlDbType.VarChar, dtDO.Rows[0]["Cabang1"])); db.Commands[0].Parameters.Add(new Parameter("@cabang2", SqlDbType.VarChar, dtDO.Rows[0]["Cabang2"])); db.Commands[0].Parameters.Add(new Parameter("@cabang3", SqlDbType.VarChar, dtDO.Rows[0]["Cabang3"])); db.Commands[0].Parameters.Add(new Parameter("@kodeSales", SqlDbType.VarChar, dtDO.Rows[0]["KodeSales"])); db.Commands[0].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, dtDO.Rows[0]["KodeToko"])); db.Commands[0].Parameters.Add(new Parameter("@alamatKirim", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@kota", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@isClosed", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@catatan1", SqlDbType.VarChar, _Cat1)); db.Commands[0].Parameters.Add(new Parameter("@catatan2", SqlDbType.VarChar, _Cat2)); db.Commands[0].Parameters.Add(new Parameter("@catatan3", SqlDbType.VarChar, _Cat3)); db.Commands[0].Parameters.Add(new Parameter("@catatan4", SqlDbType.VarChar, _Cat4)); db.Commands[0].Parameters.Add(new Parameter("@catatan5", SqlDbType.VarChar, _Cat5)); db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@linkID", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@nPrint", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@transactionType", SqlDbType.VarChar, _transType)); db.Commands[0].Parameters.Add(new Parameter("@hariKredit", SqlDbType.Int, _hariKredit)); db.Commands[0].Parameters.Add(new Parameter("@hariKirim", SqlDbType.Int, dtDO.Rows[0]["HariKirim"])); db.Commands[0].Parameters.Add(new Parameter("@hariSales", SqlDbType.Int, dtDO.Rows[0]["HariSales"])); db.Commands[0].Parameters.Add(new Parameter("@checker1", SqlDbType.UniqueIdentifier, lookupStafAdm1.RowID)); db.Commands[0].Parameters.Add(new Parameter("@checker2", SqlDbType.UniqueIdentifier, lookupStafAdm2.RowID)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); countRows = dt.Rows.Count; DataRow[] dr = dt.Select("QtySisa>0 AND StatusDO='BOLEH'"); int a = 0; foreach (DataRow drd in dr) { a++; } lastCtr = a; db.BeginTransaction(); for (int j = 0; j < db.Commands.Count; j++) { db.Commands[j].ExecuteNonQuery(); } db.CommitTransaction(); int counter = 0; for (int i = 0; i < countRows; i++) { db.Commands.Clear(); int _qtySisa = (int)dataGridDetailDO.Rows[i].Cells["QtySisa"].Value; int _qtyMin = (int)dataGridDetailDO.Rows[i].Cells["QtyMin"].Value; Guid _doDetailID = (Guid)dataGridDetailDO.Rows[i].Cells["DetailRowID"].Value; string _StatusDO = dataGridDetailDO.Rows[i].Cells["StatusDO"].Value.ToString(); //db.Commands.Clear(); int _qtyNota = Convert.ToInt32(dataGridDetailDO.Rows[i].Cells["QtyNota"].Value); if (_qtyNota > 0) { if (_qtySisa > 0 && _StatusDO.Equals("BOLEH") || isBonusan) { _notaDetailRecID = Tools.CreateShortFingerPrint(counter + 1); temp = _notaDetailRecID; db.Commands.Add(db.CreateCommand("usp_NotaPenjualanDetail_INSERT")); // udah cek heri db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, Guid.NewGuid())); db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _notaHeaderRowID)); db.Commands[0].Parameters.Add(new Parameter("@recID", SqlDbType.VarChar, _notaDetailRecID)); db.Commands[0].Parameters.Add(new Parameter("@htrID", SqlDbType.VarChar, _notaHeaderRecID)); db.Commands[0].Parameters.Add(new Parameter("@doID", SqlDbType.UniqueIdentifier, _doID)); db.Commands[0].Parameters.Add(new Parameter("@doDetailID", SqlDbType.UniqueIdentifier, _doDetailID)); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, dataGridDetailDO.Rows[i].Cells["BarangID"].Value)); db.Commands[0].Parameters.Add(new Parameter("@kodeGudang", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@qtySJ", SqlDbType.Int, _qtySisa)); db.Commands[0].Parameters.Add(new Parameter("@hrgJual", SqlDbType.Money, dataGridDetailDO.Rows[i].Cells["HrgJual"].Value)); db.Commands[0].Parameters.Add(new Parameter("@disc1", SqlDbType.Decimal, dataGridDetailDO.Rows[i].Cells["DetailDisc1"].Value)); db.Commands[0].Parameters.Add(new Parameter("@disc2", SqlDbType.Decimal, dataGridDetailDO.Rows[i].Cells["DetailDisc2"].Value)); db.Commands[0].Parameters.Add(new Parameter("@disc3", SqlDbType.Decimal, dataGridDetailDO.Rows[i].Cells["DetailDisc3"].Value)); db.Commands[0].Parameters.Add(new Parameter("@discFormula", SqlDbType.VarChar, dataGridDetailDO.Rows[i].Cells["DetailDiscFormula"].Value)); db.Commands[0].Parameters.Add(new Parameter("@pot", SqlDbType.Money, dataGridDetailDO.Rows[i].Cells["Pot"].Value)); db.Commands[0].Parameters.Add(new Parameter("@qtyNota", SqlDbType.Int, _qtyNota)); db.Commands[0].Parameters.Add(new Parameter("@qtyKoli", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@koliAwal", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@koliAkhir", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@noKoli", SqlDbType.VarChar, dataGridDetailDO.Rows[i].Cells["NoKoli"].Value.ToString())); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, dataGridDetailDO.Rows[i].Cells["Catatan"].Value.ToString())); db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@ketKoli", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); //tambahan fefe db.Commands[0].Parameters.Add(new Parameter("@NPackingListPrint", SqlDbType.VarChar, "")); ctr++; counter++; } //EXECUTE ALL COMMANDS db.BeginTransaction(); for (int j = 0; j < db.Commands.Count; j++) { db.Commands[j].ExecuteNonQuery(); } db.CommitTransaction(); } #region Insert Nota if ((ctr % 20 == 0) && (ctr != 0) && (ctr != lastCtr) && (ctr != ctrBef)) { //lastCtr = ctr; ctrBef = ctr; _notaHeaderRowID = Guid.NewGuid(); _notaHeaderRecID = Tools.CreateShortFingerPrint(k); //dtNum = Tools.GetGeneralNumerator(kodeNota); //lebarOriginal = int.Parse(dtNum.Rows[0]["Lebar"].ToString()); ////lebar = lebarOriginal - 3; ////Update 2013-05-28 //lebar = lebarOriginal; //iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString()); //belakang = dtNum.Rows[0]["Belakang"].ToString(); //iNomor++; ////nomorNota = Tools.FormatNumerator(iNomor, lebar, depan, belakang); //nomorNota = Tools.AutoNumbering("NoNota", "SADBDepoRetail.dbo.NotaPenjualan"); nomorNota = _NoDo; db.Commands.Clear(); db.Commands.Add(db.CreateCommand("usp_NotaPenjualan_INSERT")); //udah cek heri db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _notaHeaderRowID)); db.Commands[0].Parameters.Add(new Parameter("@recID", SqlDbType.VarChar, _notaHeaderRecID)); db.Commands[0].Parameters.Add(new Parameter("@DOID", SqlDbType.UniqueIdentifier, _doID)); db.Commands[0].Parameters.Add(new Parameter("@htrID", SqlDbType.VarChar, _doHtrID)); db.Commands[0].Parameters.Add(new Parameter("@noSJ", SqlDbType.VarChar, nomorNota)); //Tools.GetGeneralNumerator("NOMOR_NOTA").Rows[0].ToString())); db.Commands[0].Parameters.Add(new Parameter("@noNota", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@tglNota", SqlDbType.DateTime, SqlDateTime.Null)); db.Commands[0].Parameters.Add(new Parameter("@tglSJ", SqlDbType.DateTime, DateTime.Today)); db.Commands[0].Parameters.Add(new Parameter("@tglTerima", SqlDbType.DateTime, SqlDateTime.Null)); db.Commands[0].Parameters.Add(new Parameter("@tglSerahTerimaChecker", SqlDbType.DateTime, SqlDateTime.Null)); db.Commands[0].Parameters.Add(new Parameter("@cabang1", SqlDbType.VarChar, dtDO.Rows[0]["Cabang1"])); db.Commands[0].Parameters.Add(new Parameter("@cabang2", SqlDbType.VarChar, dtDO.Rows[0]["Cabang2"])); db.Commands[0].Parameters.Add(new Parameter("@cabang3", SqlDbType.VarChar, dtDO.Rows[0]["Cabang3"])); db.Commands[0].Parameters.Add(new Parameter("@kodeSales", SqlDbType.VarChar, dtDO.Rows[0]["KodeSales"])); db.Commands[0].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, dtDO.Rows[0]["KodeToko"])); db.Commands[0].Parameters.Add(new Parameter("@alamatKirim", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@kota", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@isClosed", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@catatan1", SqlDbType.VarChar, _Cat1)); db.Commands[0].Parameters.Add(new Parameter("@catatan2", SqlDbType.VarChar, _Cat2)); db.Commands[0].Parameters.Add(new Parameter("@catatan3", SqlDbType.VarChar, _Cat3)); db.Commands[0].Parameters.Add(new Parameter("@catatan4", SqlDbType.VarChar, _Cat4)); db.Commands[0].Parameters.Add(new Parameter("@catatan5", SqlDbType.VarChar, _Cat5)); db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@linkID", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@nPrint", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@transactionType", SqlDbType.VarChar, _transType)); db.Commands[0].Parameters.Add(new Parameter("@hariKredit", SqlDbType.Int, _hariKredit)); db.Commands[0].Parameters.Add(new Parameter("@hariKirim", SqlDbType.Int, dtDO.Rows[0]["HariKirim"])); db.Commands[0].Parameters.Add(new Parameter("@hariSales", SqlDbType.Int, dtDO.Rows[0]["HariSales"])); db.Commands[0].Parameters.Add(new Parameter("@checker1", SqlDbType.UniqueIdentifier, lookupStafAdm1.RowID)); db.Commands[0].Parameters.Add(new Parameter("@checker2", SqlDbType.UniqueIdentifier, lookupStafAdm2.RowID)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); //db.Commands.Add(db.CreateCommand("usp_Numerator_UPDATE")); //db.Commands[1].Parameters.Add(new Parameter("@doc", SqlDbType.VarChar, kodeNota)); //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, lebarOriginal)); //db.Commands[1].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); countRows = dt.Rows.Count; db.BeginTransaction(); for (int j = 0; j < db.Commands.Count; j++) { db.Commands[0].ExecuteNonQuery(); } db.CommitTransaction(); } k++; #endregion #region recalculate string barangID = dataGridDetailDO.Rows[i].Cells["BarangID"].Value.ToString(); string gudang = GlobalVar.Gudang; Recalculate(barangID, gudang); //MessageBox.Show("Proses RECALCULATE Selesai"); this.Cursor = Cursors.Default; #endregion } this.DialogResult = DialogResult.OK; MessageBox.Show(Messages.Confirm.UpdateSuccess + "\nNomor Nota: " + nomorNota); } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } frmNotaJualBrowser frmCaller = (frmNotaJualBrowser)this.Caller; frmCaller.RefreshDataNotaJual(); //} this.Close(); }
private void cmdSAVE_Click(object sender, EventArgs e) { if (!ValidateInput()) { return; } try { GlobalVar.LastClosingDate = (DateTime)txtTglKoreksi.DateValue; if ((DateTime)txtTglKoreksi.DateValue <= GlobalVar.LastClosingDate) { throw new Exception(string.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate)); } double hrgKoreksi = double.Parse(txtHrgNet2.Text) - double.Parse(txtHrgNet1.Text); int qtyKoreksi = txtQtyNota2.GetIntValue - txtQtyNota1.GetIntValue; this.Cursor = Cursors.WaitCursor; #region "Stok Minus Lock New" if (qtyKoreksi > 0) { using (Stock st = new Stock()) { st.AddList(dtReturBeliDetail.Rows[0]["BarangID"].ToString(), "", qtyKoreksi); if (!st.Pass()) { MessageBox.Show("Tidak Bisa Proses,\n nilai transaksi menyebabkan stok minus! ", "Warning"); st.ReportMinus(); if (MessageBox.Show("Cetak Form Opname?", "Opname", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { st.PrintOutMinus(); } this.Close(); return; } } } #endregion _rowID = Guid.NewGuid(); DataTable dtMessage = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_KoreksiReturPembelian_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@returBeliDetailID", SqlDbType.UniqueIdentifier, dtReturBeliDetail.Rows[0]["RowID"])); db.Commands[0].Parameters.Add(new Parameter("@returBeliDetailRecID", SqlDbType.VarChar, dtReturBeliDetail.Rows[0]["RecordID"])); db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, dtReturBeliDetail.Rows[0]["BarangID"])); db.Commands[0].Parameters.Add(new Parameter("@tglKoreksi", SqlDbType.DateTime, txtTglKoreksi.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@qtyNotaBaru", SqlDbType.Int, txtQtyNota2.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@hrgBeliBaru", SqlDbType.Money, double.Parse(txtHrgBeli2.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@pemasok", SqlDbType.VarChar, dtReturBeliDetail.Rows[0]["Pemasok"])); db.Commands[0].Parameters.Add(new Parameter("@sumber", SqlDbType.VarChar, "NRB")); db.Commands[0].Parameters.Add(new Parameter("@linkID", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@hrgBeliKoreksi", SqlDbType.Money, hrgKoreksi)); db.Commands[0].Parameters.Add(new Parameter("@qtyNotaKoreksi", SqlDbType.Int, qtyKoreksi)); db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dtMessage = db.Commands[0].ExecuteDataTable(); if (dtMessage.Rows.Count > 0) { if (dtMessage.Rows[0]["pesan"].ToString() == "Data Berhasil Insert") { this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show(dtMessage.Rows[0]["pesan"].ToString()); return; } //if (dt.Rows[0]["pesan"].ToString() == "Data Sudah Ada") //{ // txtKode.Text = string.Empty; // txtKode.Focus(); // return; //} } } //this.DialogResult = DialogResult.OK; //MessageBox.Show("Data telah disimpan"); //this.Close(); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }