コード例 #1
0
        private void Fill()
        {
            btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_ANONIM_LOG&Pk=" + NoAnonim.ToString().PadLeft(5, '0') + "'";
            btndel.Attributes["onclick"] = "location.href='TransferAnonimDel.aspx?NoAnonim=" + NoAnonim + "'";

            string strSql = "SELECT * "
                            + " FROM MS_ANONIM WHERE NoAnonim = " + NoAnonim;
            DataTable rs = Db.Rs(strSql);

            if (rs.Rows.Count == 0)
            {
                Response.Redirect("/CustomError/Deleted.html");
            }
            else
            {
                no.InnerHtml = NoAnonim.ToString().PadLeft(5, '0');

                tgl.Text           = Cf.Day(rs.Rows[0]["Tgl"]);
                bank.SelectedValue = rs.Rows[0]["AccountID"].ToString();
                nilai.Text         = Cf.Num(rs.Rows[0]["Nilai"]);

                nokontrak.Text        = rs.Rows[0]["NoKontrak"].ToString();
                customer.Text         = rs.Rows[0]["Customer"].ToString();
                unit.Text             = rs.Rows[0]["Unit"].ToString();
                ket.Text              = rs.Rows[0]["Ket"].ToString();
                project.SelectedValue = rs.Rows[0]["Project"].ToString();
                if (rs.Rows[0]["Status"].ToString() == "ID")
                {
                    trunit.Visible = trcs.Visible = true;
                }
                else
                {
                    trunit.Visible = trcs.Visible = true;
                }



                //kalo udah solve(udah dipake anonimnya) ga bisa ganti customer
                if (rs.Rows[0]["Status"].ToString() == "S")
                {
                    nokontrak.Enabled = false;
                    customer.Enabled  = false;
                    btnpop.Disabled   = true;
                }
            }
        }
コード例 #2
0
        protected void delbtn_Click(object sender, System.EventArgs e)
        {
            DataTable rs = Db.Rs(
                "SELECT * FROM MS_ANONIM WHERE NoAnonim = " + NoAnonim);

            if (rs.Rows.Count == 0)
            {
                Response.Redirect("/CustomError/Deleted.html");
            }
            else
            {
                string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
                             + "<br><br>***Data Sebelum Delete :<br>"
                             + Cf.LogCapture(rs);

                Db.Execute("DELETE FROM MS_ANONIM WHERE NoAnonim = " + NoAnonim);

                int c = Db.SingleInteger(
                    "SELECT COUNT(*) FROM MS_ANONIM WHERE NoAnonim = " + NoAnonim);

                if (c == 0)
                {
                    //Log
                    Db.Execute("EXEC spLogAnonim "
                               + " 'DELETE'"
                               + ",'" + Act.UserID + "'"
                               + ",'" + Act.IP + "'"
                               + ",'" + Ket + "'"
                               + ",'" + NoAnonim.ToString().PadLeft(5, '0') + "'"
                               );

                    decimal LogID   = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_ANONIM_LOG ORDER BY LogID DESC");
                    string  Project = Db.SingleString("SELECT Project FROM MS_ANONIM WHERE NoAnonim = '" + NoAnonim + "'");
                    Db.Execute("UPDATE MS_ANONIM_LOG SET Project = '" + Project + "' WHERE LogID  = " + LogID);

                    Js.Close(this);
                }
                else
                {
                    //Tidak bisa dihapus
                    frm.Visible   = false;
                    nodel.Visible = true;
                }
            }
        }
コード例 #3
0
        private bool Save()
        {
            if (valid())
            {
                DateTime Tgl       = Convert.ToDateTime(tgl.Text);
                string   Bank      = Db.SingleString("SELECT Bank FROM REF_ACC WHERE Acc = '" + bank.SelectedValue + "'");
                string   Rekening  = Db.SingleString("SELECT Rekening FROM REF_ACC WHERE Acc = '" + bank.SelectedValue + "'");
                decimal  Nilai     = Convert.ToDecimal(nilai.Text);
                string   Ket       = Cf.Str(ket.Text);
                string   NoKontrak = Cf.Str(nokontrak.Text);

                string Unit     = Db.SingleString("SELECT NoUnit FROM ISC064_MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");
                string Customer = Db.SingleString("SELECT Nama FROM ISC064_MARKETINGJUAL..MS_CUSTOMER WHERE NoCustomer = (SELECT NoCustomer FROM ISC064_MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "')");

                DataTable rs = Db.Rs("SELECT "
                                     + " NoAnonim AS [No.]"
                                     + " FROM MS_ANONIM"
                                     + " WHERE NoAnonim = " + NoAnonim
                                     );

                DataTable rsBef = Db.Rs("SELECT "
                                        + " NoAnonim AS [No.]"
                                        + ",CONVERT(varchar,Tgl,106) AS Tgl"
                                        + ",AccountID"
                                        + ",Bank"
                                        + ",Rekening"
                                        + ",Nilai"
                                        + ",Unit"
                                        + ",Customer"
                                        + ",Ket AS [Keterangan Pembayaran]"
                                        + ",Status"
                                        + ",Project"
                                        + " FROM MS_ANONIM"
                                        + " WHERE NoAnonim = " + NoAnonim
                                        );

                Db.Execute("UPDATE MS_ANONIM SET"
                           + " Tgl = '" + Tgl + "'"
                           + ",Nilai = " + Nilai
                           + ",AccountID = '" + bank.SelectedValue + "'"
                           + ",Bank = '" + Bank + "'"
                           + ",Rekening = '" + Rekening + "'"
                           + ",Unit = '" + Unit + "'"
                           + ",Customer = '" + Customer + "'"
                           + ",NoKontrak = '" + NoKontrak + "'"
                           + ",Ket = '" + Ket + "'"
                           + ",Project = '" + project.SelectedValue + "'"
                           + " WHERE NoAnonim = " + NoAnonim
                           );

                if (Unit != "" || Customer != "" || Ket != "")
                {
                    Db.Execute("UPDATE MS_ANONIM SET"
                               + " Status = 'ID'"
                               + " WHERE NoAnonim = " + NoAnonim
                               + " AND Status = 'BARU'"
                               );
                }

                DataTable rsAft = Db.Rs("SELECT "
                                        + " NoAnonim AS [No.]"
                                        + ",CONVERT(varchar,Tgl,106) AS Tgl"
                                        + ",AccountID"
                                        + ",Bank"
                                        + ",Rekening"
                                        + ",Nilai"
                                        + ",NoKontrak"
                                        + ",Unit"
                                        + ",Customer"
                                        + ",Ket AS [Keterangan Pembayaran]"
                                        + ",Status"
                                        + ",Project"
                                        + " FROM MS_ANONIM"
                                        + " WHERE NoAnonim = " + NoAnonim
                                        );

                //Logfile
                string ketlog = Cf.LogCapture(rs)
                                + Cf.LogCompare(rsBef, rsAft);

                Db.Execute("EXEC spLogAnonim"
                           + " 'EDIT'"
                           + ",'" + Act.UserID + "'"
                           + ",'" + Act.IP + "'"
                           + ",'" + ketlog + "'"
                           + ",'" + NoAnonim.ToString().PadLeft(5, '0') + "'"
                           );

                decimal LogID   = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_ANONIM_LOG ORDER BY LogID DESC");
                string  Project = Db.SingleString("SELECT Project FROM MS_ANONIM WHERE NoAnonim = '" + NoAnonim + "'");
                Db.Execute("UPDATE MS_ANONIM_LOG SET Project = '" + Project + "' WHERE LogID  = " + LogID);

                return(true);
            }
            else
            {
                return(false);
            }
        }