コード例 #1
0
 private void frmAntarGudangDetailUpdate_FormClosed(object sender, FormClosedEventArgs e)
 {
     if (this.DialogResult == DialogResult.OK)
     {
         if (this.Caller is frmAntarGudang)
         {
             ArusStock.frmAntarGudang frmcaller = (ArusStock.frmAntarGudang) this.Caller;
             frmcaller.RefreshDetail();
             frmcaller.FindDetail("RowIDD", _RowID.ToString());
         }
     }
 }
コード例 #2
0
        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();
            }
        }