protected void Page_Load(object sender, System.EventArgs e)
{
Act.Pass();
Act.NoCache();
if (!Page.IsPostBack)
{
cancel.Attributes["onclick"] = "location.href='TTSEdit.aspx?NoTTS=" + NoTTS + "'";
tglsetoran.Text = Cf.Day(DateTime.Today);
Fill();
Bind();
}
}
private void Fill()
{
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
if (Dari > Sampai)
{
DateTime x = Sampai;
Sampai = Dari;
Dari = x;
}
string strSql = "SELECT * FROM MS_KOMISI_REWARD_R"
+ " WHERE CONVERT(varchar,Tgl,112) >= '" + Cf.Tgl112(Dari) + "'"
+ " AND CONVERT(varchar,Tgl,112) <= '" + Cf.Tgl112(Sampai) + "'"
+ " ORDER BY NoRR";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Tidak ada realisasi reward dengan kriteria seperti tersebut diatas.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = "<a href=\"javascript:call('" + rs.Rows[i]["NoRR"] + "')\">"
+ rs.Rows[i]["NoRR"].ToString() + "</a>";
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["Tgl"]);
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Ket"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Project"].ToString();
r.Cells.Add(c);
rpt.Rows.Add(r);
}
}
private void init()
{
dari.Text = Cf.Day(DateTime.Today);
sampai.Text = Cf.Day(DateTime.Today);
DataTable rs;
rs = Db.Rs("SELECT DISTINCT UserID FROM MS_TTR ORDER BY UserID");
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["UserID"].ToString();
user.Items.Add(new ListItem(v, v));
}
}
private void Report()
{
param.Visible = false;
rpt.Visible = true;
lblHeader.Text = Mi.Pt
+ "<br />"
+ "LAPORAN SUMMARY STOCK"
+ "<br />"
+ "PER " + Cf.Day(DateTime.Today)
;
Fill();
}
private void Report()
{
param.Visible = false;
rpt.Visible = true;
lblHeader.Text = Mi.Pt
+ "<br />"
+ "LAPORAN RATA-RATA HARGA JUAL PER TOWER"
+ "<br />"
+ "PER " + Cf.Day(DateTime.Today)
;
Fill();
}
private void init()
{
dari.Text = Cf.Day(DateTime.Today);
sampai.Text = Cf.Day(DateTime.Today);
//tipe
string[] x = Sc.MktCatalog();
for (int i = 0; i <= x.GetUpperBound(0); i++)
{
string[] xdetil = x[i].Split(';');
tipe.Items.Add(new ListItem(xdetil[2], xdetil[1]));
tipe.Items[i].Selected = true;
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
Rpt.SubJudul(x
, "Lokasi : " + lokasi.SelectedItem.Text
);
string tgl = "";
if (tbTarget.Checked)
{
tgl = tbTarget.Text;
}
if (tbTgl.Checked)
{
tgl = tbTgl.Text;
}
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(
x, "Status Wawancara : " + ddlStatus.SelectedItem.Text
);
if (rekening.SelectedIndex == 0)
{
Rpt.SubJudul(x, "Bank KPR : SEMUA");
}
else
{
Rpt.SubJudul(x, "Bank KPR : " + rekening.SelectedValue);
}
Rpt.SubJudul(
x, "Project : " + project.SelectedValue
);
Rpt.SubJudul(
x, "Perusahaan : " + pers.SelectedItem.Text
);
//Rpt.Header(rpt, x);
Rpt.HeaderReport(headReport, "", x);
}
private void newHeader()
{
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
string header = "<h2>" + Mi.Pt + "</h2>";
header += "<h1 class='title'>Laporan Pindah Unit</h1>";
header += "<h4>Project : " + Project + "</h4>";
header += "Periode : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai);
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void init()
{
dari.Text = Cf.Day(Cf.AwalBulan());
sampai.Text = Cf.Day(Cf.AkhirBulan());
string Project = project.SelectedValue == "SEMUA" ? "Project IN (" + Act.ProjectListSql + ")" : "Project = '" + project.SelectedValue + "'";
DataTable rs = Db.Rs("SELECT DISTINCT Lokasi FROM MS_KONTRAK WHERE " + Project + " ORDER BY Lokasi");
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
lokasi.SelectedIndex = 0;
}
private void init()
{
tgl.Text = Cf.Day(DateTime.Now);
string Project = project.SelectedValue == "SEMUA" ? "Project IN (" + Act.ProjectListSql + ")" : "Project = '" + project.SelectedValue + "'";
DataTable rs;
rs = Db.Rs("SELECT DISTINCT Lokasi FROM ISC064_MARKETINGJUAL..MS_KONTRAK WHERE " + Project + " ORDER BY Lokasi");
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
lokasi.SelectedIndex = 0;
}
private void init()
{
dari.Text = Cf.Day(DateTime.Today);
sampai.Text = Cf.Day(DateTime.Today);
DataTable rs = Db.Rs("SELECT * FROM REF_ACC");
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["Acc"].ToString();
string t = v + " : " + rs.Rows[i]["Bank"] + " " + rs.Rows[i]["Rekening"];
ddlAcc.Items.Add(new ListItem(t, v));
}
}
private void init()
{
dari.Text = Cf.Day(DateTime.Today);
sampai.Text = Cf.Day(DateTime.Today);
//DataTable rs;
//rs = Db.Rs("SELECT DISTINCT UserID FROM MS_TTS ORDER BY UserID");
//for (int i = 0; i < rs.Rows.Count; i++)
// kasir.Items.Add(new ListItem(
// rs.Rows[i][0].ToString()));
//kasir.SelectedIndex = 0;
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
Rpt.SubJudul(x
, "Lokasi : " + Lokasi
);
Rpt.SubJudul(x
, Tanggal2 + " : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
);
Rpt.SubJudul(
x, "Status SP3K : " + StatusSP3K
);
Rpt.SubJudul(
x, "Hasil SP3K : " + HasilSP3K
);
if (Rekening == "SEMUA")
{
Rpt.SubJudul(x, "Rekening Bank: SEMUA");
}
else
{
Rpt.SubJudul(x, "Rekening Bank: " + Rekening);
}
Rpt.SubJudul(
x, "Project : " + Project
);
string pers = (Perusahaan == "SEMUA") ? "SEMUA" : Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..REF_PERS WHERE Pers = '" + Perusahaan + "'");
Rpt.SubJudul(
x, "Perusahaan : " + pers
);
string legend = "";
//Rpt.Header(rpt, x);
Rpt.HeaderReport(headReport, legend, x);
}
private void init()
{
dari.Text = Cf.Day(Cf.AwalBulan());
sampai.Text = Cf.Day(Cf.AkhirBulan());
DataTable rs;
rs = Db.Rs("SELECT DISTINCT Lokasi FROM MS_KONTRAK ORDER BY Lokasi");
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
lokasi.SelectedIndex = 0;
}
protected void Header()
{
Label l;
l = new Label();
l.Text = Mi.Pt;
l.Text += "<h1 class='title'>Daily Report</h1>";
l.Text += "<h2>per " + Cf.Day(Tgl) + "</h2>";
l.Text += "Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : eProperty Mobile"
+ " dan username : "******"<br /><br />";
rpt.Controls.Add(l);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, "Tgl. Batal: " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.Header(rpt, x);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
Rpt.SubJudul(x
, "Tgl. Jatuh Tempo: " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
);
Rpt.Header(rpt, x);
}
private void SetBG()
{
string strSql = "SELECT TOP 1 NoBG, TglBG FROM MS_TTS WHERE NoBG = '" + NoBG + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
nobgbaru.Text = rs.Rows[0]["NoBG"].ToString();
tglbg.Text = Cf.Day(rs.Rows[0]["TglBG"]);
}
}
private void SubTotal(decimal decTotalKontrak, decimal decTotalPriceList, decimal decTotalNilaiKontrak, decimal decTotalDiskon, decimal decTotalBayar, DateTime TglKontrak)
{
TableRow r = new TableRow();
TableCell c;
c = Rpt.Foot();
c.Text = "SUBTOTAL UNIT PENJUALAN " + Cf.Day(TglKontrak);
c.ColumnSpan = 3;
c.HorizontalAlign = HorizontalAlign.Center;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = decTotalKontrak.ToString();
c.HorizontalAlign = HorizontalAlign.Center;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = "SUBTOTAL PENJUALAN " + Cf.Day(TglKontrak);
c.ColumnSpan = 4;
c.HorizontalAlign = HorizontalAlign.Center;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(decTotalPriceList);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(decTotalNilaiKontrak);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(decTotalDiskon);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(decTotalBayar);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = " ";
r.Cells.Add(c);
rpt.Rows.Add(r);
}
private void FillTb()
{
string strSql = "SELECT * "
+ ",(NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) AS SisaTagihan"
+ " FROM " + Tb + "..MS_TAGIHAN AS MS_TAGIHAN WHERE NoKontrak = '" + Ref + "'"
+ " AND KPR != '1' "
+ " AND (NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) > 0"
+ " ORDER BY NoUrut, TglJT";
rsTagihan = Db.Rs(strSql);
for (int i = 0; i < rsTagihan.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
Label l;
TextBox t;
l = new Label();
l.Text = "<tr valign=top>"
+ "<td>" + rsTagihan.Rows[i]["NoKontrak"] + "." + rsTagihan.Rows[i]["NoUrut"] + "</td>"
+ "<td>" + rsTagihan.Rows[i]["NamaTagihan"] + "</td>"
+ "<td>" + rsTagihan.Rows[i]["Tipe"] + "</td>"
+ "<td style='white-space:nowrap'>" + Cf.Day(rsTagihan.Rows[i]["TglJT"]) + "</td>"
+ "<td align=right>" + Cf.Num(rsTagihan.Rows[i]["SisaTagihan"]) + "</td>"
+ "<td>"
;
list.Controls.Add(l);
t = new TextBox();
t.ID = "lunas_" + i;
t.Width = 100;
t.CssClass = "txt_num";
t.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
t.Attributes["onkeyup"] = "CalcType(this,tempnum);";
t.Attributes["onblur"] = "CalcBlur(this);hitunggt();";
list.Controls.Add(t);
l = new Label();
l.Text = "</td>"
+ "<td><input type='checkbox' onclick=\"tagihan('" + i + "','" + Cf.Num(rsTagihan.Rows[i]["SisaTagihan"]) + "',this)\"></td>"
+ "</tr>";
list.Controls.Add(l);
}
}
private void Fill()
{
string strSql = "SELECT *"
+ ",CASE CaraBayar"
+ " WHEN 'TN' THEN 'TUNAI'"
+ " WHEN 'KK' THEN 'KARTU KREDIT'"
+ " WHEN 'KD' THEN 'KARTU DEBIT'"
+ " WHEN 'TR' THEN 'TRANSFER BANK'"
+ " WHEN 'BG' THEN 'CEK GIRO'"
+ " WHEN 'UJ' THEN 'UANG JAMINAN'"
+ " WHEN 'DN' THEN 'DISKON'"
+ " END AS CaraBayar2"
+ " FROM " + Mi.DbPrefix + "FINANCEAR..MS_TTS WHERE NoTTS = " + nomor;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count != 0)
{
nomorl.Text = rs.Rows[0]["NoTTS"].ToString().PadLeft(7, '0');
tgl.Text = Cf.Day(rs.Rows[0]["TglTTS"]);
cs.Text = rs.Rows[0]["Customer"].ToString();
decimal Total = Convert.ToDecimal(rs.Rows[0]["Total"]);
if ((bool)rs.Rows[0]["Pph"])
{
Total = Total * (decimal)1.1;
}
jumlah.Text = Cf.Num(Total);
terbilang.Text = Money.Str(Total);
carabayar.Text = rs.Rows[0]["CaraBayar2"].ToString();
if (rs.Rows[0]["CaraBayar"].ToString() == "BG")
{
carabayar.Text = carabayar.Text
+ " / " + rs.Rows[0]["NoBG"] + " Tgl. " + Cf.Day(rs.Rows[0]["TglBG"]);
}
if (rs.Rows[0]["Ket"].ToString() != "")
{
carabayar.Text = carabayar.Text + ", " + rs.Rows[0]["Ket"].ToString();
}
noref.Text = rs.Rows[0]["Ref"].ToString()
+ " (" + rs.Rows[0]["Unit"] + ")";
FillTable(rs.Rows[0]["Tipe"].ToString());
}
}
public static Kwitansi Kwitansi(object NoTTS)
{
Kwitansi x = new Kwitansi();
DataTable rs = Db.Rs("use " + Mi.DbPrefix + "financear;SELECT * "
+ ",CASE CaraBayar"
+ " WHEN 'TN' THEN 'TUNAI'"
+ " WHEN 'KK' THEN 'KARTU KREDIT'"
+ " WHEN 'KD' THEN 'KARTU DEBIT'"
+ " WHEN 'TR' THEN 'TRANSFER BANK'"
+ " WHEN 'BG' THEN 'CEK GIRO'"
+ " WHEN 'UJ' THEN 'UANG JAMINAN'"
+ " WHEN 'DN' THEN 'DISKON'"
+ " WHEN 'MB' THEN 'MERCHANT BANKING'"
+ " WHEN 'PP' THEN 'PENGHAPUSAN PIUTANG'"
+ " END AS NamaCaraBayar"
+ " FROM MS_TTS WHERE NoTTS = '" + NoTTS + "'");
if (rs.Rows.Count > 0)
{
var r = rs.Rows[0];
x.NoKontrak = r["Ref"].ToString();
x.NoTTS = NoTTS.ToString();
x.NoBKM = r["NoBKM"].ToString();
x.NoKwitansi = r["NoBKM2"].ToString();
x.CaraBayar = (string)r["carabayar"];
x.Keterangan = (string)r["Ket"];
x.NilaiKwitansi = (decimal)r["Total"];
x.Status = (string)r["Status"];
x.TglTTS = (DateTime)r["TglTTS"];
x.User = (string)r["UserID"];
x.TglBKM = Cf.Day(r["TglBKM"]);
x.TglInput = (DateTime)r["TglInput"];
x.IPAddress = r["IP"].ToString();
x.AccountID = r["Acc"].ToString();
x.StatusBG = r["StatusBg"].ToString();
x.TglBG = Cf.Day(r["TglBG"]);
x.UdahJadiJurnal = (bool)r["Fobo"];
x.Tipe = r["Tipe"].ToString();
x.AdminBank = (decimal)r["AdminBank"];
x.LebihBayar = (decimal)r["LebihBayar"];
x.KurangBayar = (decimal)r["KurangBayar"];
x.ManualTTS = r["manualTTS"].ToString();
x.ManualBKM = r["ManualBKM"].ToString();
x.NamaCaraBayar = r["NamaCaraBayar"].ToString();
x.NoGiro = r["NoBG"].ToString();
}
return(x);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (StatusA != "")
{
Rpt.SubJudul(x, "Status : " + StatusA);
}
else if (StatusB != "")
{
Rpt.SubJudul(x, "Status : " + StatusB);
}
else
{
Rpt.SubJudul(x, "Status : " + StatusS);
}
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
Rpt.SubJudul(x
, JenisTanggal + " : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
);
Rpt.SubJudul(x
, "Tipe : " + Tipe.Replace("'", "")
);
Rpt.SubJudul(x
, "Perusahaan : " + Perusahaan
);
Rpt.SubJudul(x
, "Project : " + Project
);
//Rpt.Header(rpt, x);
string legend = "<br />Status: A = Aktif / B = Batal.<br />"
+ "Tipe : BF = Booking Fee / DP = Downpayment / ANG = Angsuran / ADM = Biaya Administrasi.<br />"
+ "Cara Bayar: TN = Tunai / KD = Kartu Debit / KK = Kartu Kredit / TR = Transfer Bank / BG = Cek Giro / DN = Diskon.<br />"
+ "** = Jatuh Tempo.";
Rpt.HeaderReport(headReport, legend, x);
}
private void Fill()
{
string strSql = "SELECT *"
+ " FROM MS_KOMISI_CFP "
+ " WHERE NoCFP + NamaAgent + NamaSkema "
+ " LIKE '%" + Cf.Str(keyword.Text) + "%'"
+ " AND Project IN (" + Act.ProjectListSql + ")"
+ " ORDER BY NoCFP";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Tidak ditemukan data pengajuan closing fee dengan keyword diatas.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = "<a href=\"javascript:call('" + rs.Rows[i]["NoCFP"] + "')\">"
+ rs.Rows[i]["NoCFP"].ToString() + "</a>";
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["Tgl"]);
c.Wrap = false;
r.Cells.Add(c);
string Sales = Db.SingleString("SELECT TOP 1 STUFF((SELECT distinct ', ' + NamaAgent FROM MS_KOMISI_CFP_DETAIL AS T1"
+ " where NoCFP = '" + rs.Rows[i]["NoCFP"].ToString() + "'"
+ " FOR XML PATH('')), 1, 1, '') As Nama "
+ " FROM MS_KOMISI_CFP_DETAIL AS T2 where NoCFP = '" + rs.Rows[i]["NoCFP"].ToString() + "'"
);
c = new TableCell();
c.Text = Sales;
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void Fill()
{
string strSql = "SELECT *"
+ ",(SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..USERNAME WHERE UserID = MS_RESERVASI_JURNAL.UserID) AS Nama"
+ " FROM MS_RESERVASI_JURNAL"
+ " WHERE NoReservasi = " + NoReservasi
+ " ORDER BY JurnalID";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Jurnal untuk reservasi tersebut masih kosong.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["Tgl"]);
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Time(rs.Rows[i]["Tgl"]);
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["UserID"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Nama"].ToString();
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Ket"].ToString();
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void Fill()
{
nosklm.Enabled = false;
string strSql = "SELECT " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK.*"
+ "," + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER.Nama AS Cs"
+ "," + Mi.DbPrefix + "MARKETINGJUAL..MS_AGENT.Nama + ' ' + " + Mi.DbPrefix + "MARKETINGJUAL..MS_AGENT.Principal AS Ag"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER ON " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK.NoCustomer = " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER.NoCustomer"
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_AGENT ON " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK.NoAgent = " + Mi.DbPrefix + "MARKETINGJUAL..MS_AGENT.NoAgent"
+ " WHERE " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK.NoKontrak = '" + NoKontrak + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
tgl.Text = Cf.Day(DateTime.Today);
nokontrakl.Text = "<a href=\"javascript:popEditKontrak('" + rs.Rows[0]["NoKontrak"] + "')\">"
+ rs.Rows[0]["NoKontrak"].ToString() + "</a>";
unit.Text = "<a href=\"javascript:popUnit('" + rs.Rows[0]["NoStock"] + "')\">"
+ rs.Rows[0]["NoUnit"].ToString() + "</a>";
customer.Text = "<a href=\"javascript:popEditCustomer('" + rs.Rows[0]["NoCustomer"] + "')\">"
+ rs.Rows[0]["Cs"].ToString() + "</a>";
agent.Text = rs.Rows[0]["Ag"].ToString();
persenlunas.Text = Cf.Num(rs.Rows[0]["PersenLunas"]);
if ((decimal)rs.Rows[0]["PersenLunas"] < 100)
{
lunasinfo.Text = "PELUNASAN BELUM MENCAPAI 100%";
save.Enabled = false;
}
decimal pernahskl = Db.SingleInteger("SELECT COUNT(NoSKL) FROM MS_SKL WHERE Ref='" + NoKontrak + "'");
if (pernahskl > 0)
{
lunasinfo.Text += "SUDAH PERNAH DIREGISTRASIKAN";
nod.Enabled = false;
save.Enabled = false;
nosklm.Enabled = false;
DataTable rs3 = Db.Rs("SELECT * FROM MS_SKL WHERE Ref = '" + NoKontrak + "'");
nod.SelectedValue = Convert.ToString(rs3.Rows[0]["Used"]);
if (nod.SelectedValue == "1")
{
nosklm.Text = rs3.Rows[0]["NoSKLManual"].ToString();
}
}
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (statusA.Checked)
{
Rpt.SubJudul(x, "Status : " + statusA.Text);
}
else if (statusB.Checked)
{
Rpt.SubJudul(x, "Status : " + statusB.Text);
}
else
{
Rpt.SubJudul(x, "Status : " + statusS.Text);
}
string tgl = "";
if (tglkontrak.Checked)
{
tgl = tglkontrak.Text;
}
//if(tglbolehbayar.Checked) tgl = tglbolehbayar.Text;
//if(tglbayar.Checked) tgl = tglbayar.Text;
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(x
, "Project : " + project.SelectedValue
);
Rpt.SubJudul(x
, "Perusahaan : " + pers.SelectedItem.Text
);
//Rpt.Header(rpt, x);
string legend = "Status: A = Aktif / B = Batal. ";
Rpt.HeaderReport(headReport, legend, x);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
if (StatusA != "")
{
Rpt.SubJudul(x, "Status : " + StatusA);
}
else if (StatusB != "")
{
Rpt.SubJudul(x, "Status : " + StatusB);
}
else
{
Rpt.SubJudul(x, "Status : " + StatusS);
}
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
Rpt.SubJudul(x
, "Tanggal Kontrak" + " : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
);
Rpt.SubJudul(x
, "Jenis : " + Tipe.Replace("-", ",").Replace("%", " ").TrimEnd(',')
);
Rpt.SubJudul(x
, "Lokasi : " + nLokasi
);
//Rpt.SubJudul(x
// , "Principal : " + nAgent
// );
Rpt.SubJudul(x
, "Project : " + Project
);
Rpt.SubJudul(x
, "Perusahaan : " + Perusahaan
);
//Rpt.Header(rpt, x);
string legend = "Status: A = Aktif / B = Batal." + "<br>"
+ "Luas dalam meter persegi. Gross adalah harga sebelum diskon.";
Rpt.HeaderReport(headReport, legend, x);
}
private void Fill()
{
DataTable rs = Db.Rs(
"SELECT * FROM MS_NUP WHERE NoNUP = '" + NoKontrak + "'");
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
//Skema
int refSkema = Db.SingleInteger("SELECT NomorSkema FROM MS_NUP_Priority WHERE NoNUP='" + NoKontrak + "' ");
if (refSkema > 0)
{
skema.SelectedValue = refSkema.ToString();
}
else
{
skema.Items.Add(new ListItem(rs.Rows[0]["Skema"].ToString(), "0")); //cara bayar customize
skema.SelectedValue = refSkema.ToString();
}
string CaraBayar = Db.SingleString("SELECT Jenis FROM REF_SKEMA WHERE Nomor = " + skema.SelectedValue);
carabayar2.SelectedValue = CaraBayar;
decimal persenDP = Db.SingleDecimal("SELECT ISNULL(SUM(CAST(ISNULL(NULLIF(NominalString, ''), 0) AS FLOAT)),0) FROM REF_SKEMA_DETAIL WHERE Nomor='" + refSkema + "' AND Tipe='DP'");
decimal persenANG = Db.SingleDecimal("SELECT ISNULL(SUM(CAST(ISNULL(NULLIF(NominalString, ''), 0) AS FLOAT)),0) FROM REF_SKEMA_DETAIL WHERE Nomor='" + refSkema + "' AND Tipe='ANG'");
int BF = Db.SingleInteger("SELECT COUNT(*) FROM MS_NUP_TAGIHAN WHERE NoNUP='" + NoKontrak + "' AND Tipe='BF'");
int DP = Db.SingleInteger("SELECT COUNT(*) FROM MS_NUP_TAGIHAN WHERE NoNUP='" + NoKontrak + "' AND Tipe='DP'");
int ANG = Db.SingleInteger("SELECT COUNT(*) FROM MS_NUP_TAGIHAN WHERE NoNUP='" + NoKontrak + "' AND Tipe='ANG'");
dpjumlah.Text = Cf.Num(persenDP);
angjumlah.Text = Cf.Num(persenANG);
bfkali.Text = (BF).ToString();
dpkali.Text = (DP).ToString();
angkali.Text = (ANG).ToString();
decimal NilaiKontrak = Db.SingleDecimal("SELECT Pricelist FROM MS_NUP_Priority WHERE NoNUP='" + NoKontrak + "' ");
netto.Text = Cf.Num(NilaiKontrak);
tgl.Text = Cf.Day(DateTime.Today);
nokontrak2.Text = NoKontrak;
unit.Text = Db.SingleString("SELECT NoUnit FROM MS_UNIT WHERE NoStock = '" + NoStock + "'");
nama.Text = Db.SingleString("SELECT Nama FROM MS_CUSTOMER WHERE NoCustomer = '" + rs.Rows[0]["NoCustomer"].ToString() + "'");
agent.Text = Db.SingleString("SELECT Nama FROM MS_AGENT WHERE NoAgent = '" + rs.Rows[0]["NoAgent"].ToString() + "'");
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (statusA.Checked)
{
Rpt.SubJudul(x, "Status : " + statusA.Text);
}
else if (statusB.Checked)
{
Rpt.SubJudul(x, "Status : " + statusB.Text);
}
else
{
Rpt.SubJudul(x, "Status : " + statusS.Text);
}
string tgl = "";
if (tglkontrak.Checked)
{
tgl = tglkontrak.Text;
}
//if(tglbolehbayar.Checked) tgl = tglbolehbayar.Text;
//if(tglbayar.Checked) tgl = tglbayar.Text;
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(x
, "Sales : " + agent.SelectedItem.Text
);
//Rpt.SubJudul(x
// , "Tipe : " + Rpt.inSql(tipe).Replace("'","")
// );
//Rpt.Header(rpt, x);
string legend = "Status: A = Aktif / B = Batal.< br /> ";
Rpt.HeaderReport(headReport, legend, x);
}
