コード例 #1
0
        private void titipGiro()
        {
            try
            {
                Guid _GiroID = (Guid)gridDetail.SelectedCells[0].OwningRow.Cells["GiroID"].Value;
                using (Database db = new Database(GlobalVar.DBFinance))
                {
                    db.Commands.Add(db.CreateCommand("usp_Giro_UPDATE"));
                    db.Commands[0].Parameters.Add(new Parameter("@GiroID", SqlDbType.UniqueIdentifier, _GiroID));
                    db.Commands[0].Parameters.Add(new Parameter("@TitipID", SqlDbType.UniqueIdentifier, _titipID));
                    db.Commands[0].Parameters.Add(new Parameter("@TitipRecID", SqlDbType.VarChar, _titipRecID));
                    db.Commands[0].Parameters.Add(new Parameter("@TglTitip", SqlDbType.DateTime, DateTime.Today));
                    db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));

                    if (jnsSlip == "" || jnsSlip == "Titip")
                    {
                        db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, _bankID));
                        db.Commands[0].Parameters.Add(new Parameter("@NamaBanki", SqlDbType.VarChar, _namaBank));
                    }
                    else if (jnsSlip == "Tunai")
                    {
                        db.Commands[0].Parameters.Add(new Parameter("@CHBG", SqlDbType.VarChar, "K"));
                        db.Commands[0].Parameters.Add(new Parameter("@CairTolak", SqlDbType.VarChar, "C"));
                        db.Commands[0].Parameters.Add(new Parameter("@TglCair", SqlDbType.VarChar, DateTime.Today));
                    }
                    db.Commands[0].ExecuteNonQuery();
                }

                if (jnsSlip == "Tunai")
                {
                    cetakLaporan();
                }

                frmVoucherGiroTitipanBrowse frm = new frmVoucherGiroTitipanBrowse();
                frm = (frmVoucherGiroTitipanBrowse)Caller;
                frm.HeaderRowRefresh(_titipID);
                frm.DetailRowRefresh(_GiroID);
                frm.DetailFindRow("GiroID", _GiroID.ToString());
                this.Close();
            }
            catch (Exception ex)
            {
                Error.LogError(ex);
            }
        }