private void PrintRawRincianBiaya(DataTable dt)
{
BuildString printESC = new BuildString();
DateTime tglKirim = DateTime.Parse(dt.Rows[0]["TglKirim"].ToString());
string sopir = dt.Rows[0]["Sopir"].ToString();
string tujuan = dt.Rows[0]["Tujuan"].ToString();
string kernet = dt.Rows[0]["Kernet"].ToString();
string noPolisi = dt.Rows[0]["NoPolisi"].ToString();
double total = double.Parse(dt.Rows[0]["Total"].ToString());
double bbmRp = double.Parse(dt.Rows[0]["BBMRp"].ToString());;
double parkir = double.Parse(dt.Rows[0]["Parkir"].ToString());;
double uangMakan = double.Parse(dt.Rows[0]["UangMakan"].ToString());;
double tol = double.Parse(dt.Rows[0]["Tol"].ToString());;
double izinMasuk = double.Parse(dt.Rows[0]["IzinMasuk"].ToString());;
double timbangan = double.Parse(dt.Rows[0]["Timbangan"].ToString());;
double insTepatWaktu = double.Parse(dt.Rows[0]["InTepatWaktu"].ToString());;
double insPengiriman = double.Parse(dt.Rows[0]["InPengiriman"].ToString());;
double lain = double.Parse(dt.Rows[0]["Lain"].ToString());;
double kuli = double.Parse(dt.Rows[0]["Kuli"].ToString());;
double kasbon = double.Parse(dt.Rows[0]["Kasbon"].ToString());
printESC.Initialize();
printESC.Append(printESC.SPACE(20) + Convert.ToString((char)27) + Convert.ToString((char)33) + Convert.ToString((char)24));
printESC.PROW(true, 1, "PERINCIAN BIAYA EKSPEDISI");
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, Convert.ToString((char)27) + Convert.ToString((char)33) + Convert.ToString((char)1) + "Periode : " + tglKirim.ToString("dd-MMM-yyyy") + printESC.SPACE(15) + "Nama Sopir : " + sopir);
printESC.PROW(true, 1, "Jalur : " + tujuan.PadRight(20) + printESC.SPACE(6) + "Nama Helper : " + kernet);
printESC.PROW(true, 1, printESC.SPACE(37) + "No. Polisi : " + noPolisi);
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, printESC.Replicate("-", 60));
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "Biaya Bahan Bakar : Rp. " + bbmRp.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Biaya Retribusi Parkir : Rp. " + parkir.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Biaya Makan : Rp. " + uangMakan.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Biaya Tol : Rp. " + tol.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Biaya Izin Masuk kota : Rp. " + izinMasuk.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Biaya Timbangan : Rp. " + timbangan.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Insentif tepat waktu : Rp. " + insTepatWaktu.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Insentif pengiriman : Rp. " + insPengiriman.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Lain-lain : Rp. " + lain.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Biaya Kuli : Rp. " + kuli.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, printESC.SPACE(32) + "-----------------");
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "Jumlah Biaya : Rp. " + total.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "Uang Saku : Rp. " + kasbon.ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, printESC.SPACE(32) + "-----------------");
printESC.PROW(true, 1, "Sisa uang saku : Rp. " + (kasbon - total).ToString("#,##0").PadLeft(9));
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "Keterangan : ");
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, " Bag. Ekspedisi, Kasir, ");
printESC.Eject();
printESC.SendToPrinter("RincianBiaya.txt");
}
private string _temp()
{
BuildString sppb = new BuildString();
string _temp = sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine();
return(sppb.GenerateString());
}
private string PrintHeader(DataTable dt)
{
BuildString printESC = new BuildString();
string namaPerusahaan = dt.Rows[0]["NamaPerusahaan"].ToString();
string alamat = dt.Rows[0]["AlamatPerusahaan"].ToString();
string kota = dt.Rows[0]["KotaPerusahaan"].ToString();
DateTime tglKirim = DateTime.Parse(dt.Rows[0]["TglKirim"].ToString());
string tujuan = dt.Rows[0]["Tujuan"].ToString();
string supir = dt.Rows[0]["Sopir"].ToString();
string kernet = dt.Rows[0]["Kernet"].ToString();
string noKirim = dt.Rows[0]["NoKirim"].ToString();
string noPolisi = dt.Rows[0]["NoPolisi"].ToString();
printESC.PROW(true, 1, namaPerusahaan);
printESC.PROW(true, 1, alamat);
printESC.PROW(true, 1, kota);
printESC.PROW(true, 1, "");
printESC.PROW(true, 1, "TANGGAL : " + tglKirim.ToString("dd-MMM-yyyy"));
printESC.PROW(true, 1, "TUJUAN : " + tujuan);
printESC.PROW(true, 1, "SOPIR/KERNET : " + supir + "/" + kernet);
printESC.PROW(true, 1, "NO.KIRIM : " + noKirim);
printESC.PROW(true, 1, "No.POLISI : " + noPolisi);
printESC.PROW(true, 1, "==================================================================================================================");
printESC.PROW(true, 1, "|NO| NAMA TOKO |KOLI|NO.NOTA| NO.SJ |T/K| SALES | KETERANGAN | TANDA TERIMA |");
printESC.PROW(true, 1, "------------------------------------------------------------------------------------------------------------------");
return(printESC.GenerateString());
}
private void CetakPackingListAmplop(DataTable dt)
{
BuildString data = new BuildString();
string sAlamat = dt.Rows[0]["Alamat"].ToString().Trim();
string sJmlKoli = dt.Compute("SUM(JmlKoli)", string.Empty).ToString();
data.Initialize();
data.LetterQuality(true);
data.FontCPI(10);
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, data.SPACE(2) + "JUMLAH KOLI : "
+ sJmlKoli + " (" + Tools.Terbilang(int.Parse(sJmlKoli)).ToUpper() + ")");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, dt.Rows[0]["NamaToko"].ToString().PadLeft(83));
data.PROW(true, 1, data.SPACE(10) + dt.Rows[0]["Catatan3"].ToString().Trim());
data.PROW(true, 1, sAlamat.PadLeft(83));
data.PROW(true, 1, "");
data.PROW(true, 1, dt.Rows[0]["Daerah"].ToString().PadLeft(83));
data.PROW(true, 1, dt.Rows[0]["Kota"].ToString().PadLeft(83));
data.Eject();
data.SendToPrinter("amplop.txt", data.GenerateString());
}
private void button13_Click(object sender, EventArgs e)
{
//string data = " ";
//textBox3.Text = data.Insert(1, "kangguru");
BuildString data = new BuildString();
data.Append(data.PrintDoubleLine(23));
string temp = "ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ";
byte[] tes = new byte[temp.Length];
for (int i = 0; i < temp.Length; i++)
{
tes[i] = Convert.ToByte(temp[i]);
}
// byte[] tes = { 205, 205, 205, 205 };
//System.IO.StreamWriter file = new System.IO.StreamWriter("C:\\test.txt", false, Encoding.UTF8);
//file.WriteLine(Convert.ToBase64String(tes));
//file.Close();
File.WriteAllBytes("C:\\test.txt", tes);
//File.WriteAllBytes("C:\\test.txt", Encoding.UTF8.GetBytes(data.GenerateString()));
MessageBox.Show("Printed");
}
private void PrintRawSPPB2(DataTable dt)
{
BuildString sppb = new BuildString();
string _NamaStok = string.Empty;
string _Pcs = string.Empty;
string _Lok = string.Empty;
int No = 0;
int n = dt.Rows.Count;
int i = 0;
int p = 0;
int s = 0;
p = n / 13;
s = n % 13;
#region "First Header"
//sppb.Initialize();
//sppb.LeftMargin(1);
//sppb.BottomMargin(1);
//sppb.PROW(true, 1, string.Empty);
sppb.AddCR();
sppb.PROW(false, 1, "KODE RAK : TANGGAL :");
sppb.Append(PrintHeader(No, n));
#endregion
#region "Detail"
foreach (DataRow dr in dt.Rows)
{
No++;
i++;
_NamaStok = dr["NamaStok"].ToString();
_Pcs = dr["SatJual"].ToString();
_Lok = dr["Lokasi"].ToString();
sppb.PROW(true, 1, sppb.PrintVerticalLine() + No.ToString().PadLeft(4, ' ') + sppb.PrintVerticalLine() + _NamaStok.PadRight(73, '.') + sppb.SPACE(4) + sppb.PrintVerticalLine() + _Pcs.PadLeft(3, ' ') + sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine() + _Lok.PadLeft(7, ' ') + sppb.PrintVerticalLine());
if (i == 28 || No == n)
{
sppb.PROW(true, 1, sppb.PrintBottomLeftCorner() + sppb.PrintHorizontalLine(4) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(77) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(3) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(14) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(14) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(14) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(7) + sppb.PrintRightBottomCorner());
sppb.Eject();
i = 0;
if (i == 0 && No != n)
{
sppb.Append(PrintHeader(No, n));
}
}
else
{
sppb.PROW(true, 1, sppb.PrintTLeft() + sppb.PrintHorizontalLine(4) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(77) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(3) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(14) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(14) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(14) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(7) + sppb.PrintTRight());
}
}
#endregion
sppb.SendToPrinter("sppb.txt", sppb.GenerateString());
}
private void cetakKasbon()
{
BuildString lap = new BuildString();
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, "[ PERTANGGUNGAN UANG MUKA PEGAWAI ]");
lap.DoubleWidth(false);
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, "NOMOR".PadRight(12) + lap.PadCenter(3, ":") + TBNoKasbon.Text.PadRight(70));
lap.PROW(true, 1, "TANGGAL".PadRight(12) + lap.PadCenter(3, ":") + String.Format("{0:dd-MMM-yyyy}", tbTanggal.DateValue).PadRight(70));
lap.PROW(true, 1, "NAMA PEGAWAI".PadRight(12) + lap.PadCenter(3, ":") + tbNamaPegawai.Text.PadRight(70));
lap.PROW(true, 1, "NIP/DIVISI".PadRight(12) + lap.PadCenter(3, ":") + tbDivisi.Text.PadRight(70));
lap.PROW(true, 1, "KEPERLUAN".PadRight(12) + lap.PadCenter(3, ":") + tbKeperluan.Text.PadRight(70));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.PrintMinusSymbol(85));
lap.PROW(true, 1, "I. PENGAMBILAN".PadRight(20) + "1.BKK No : " + txtNoBkk.Text + lap.SPACE(5) + txtRpBkk.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(70) + txtRpTotal.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, "II. PENGELUARAN".PadRight(85));
lap.PROW(true, 1, lap.SPACE(4) + "- Biaya".PadRight(8) + txtJv.Text.PadRight(33) + lap.SPACE(5) + txtRpBkk.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(70) + txtRpJv.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(70) + lap.PrintMinusSymbol(15));
lap.PROW(true, 1, lap.SPACE(55) + "KURANG/LEBIH".PadRight(15) + txtRpLbhKrng.Text.PadLeft(15));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, "III. PENYELESAIAN".PadRight(85));
lap.PROW(true, 1, lap.SPACE(5) + "KURANG".PadRight(15) + "1.BKK No : " + txtBkk3.Text + lap.SPACE(5) + txtRpBkk3.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(20) + "2.TRK No : " + txtTrk3.Text + lap.SPACE(5) + txtRpTrk3.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(70) + string.Format("{0:#,##0}", (Convert.ToDouble(txtRpTrk3.Text) + Convert.ToDouble(txtRpBkk3.Text))).PadLeft(15));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.SPACE(5) + "LEBIH".PadRight(15) + "1.BKM No : " + txtBkm3.Text + lap.SPACE(5) + txtRpBkm3.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(20) + "2.TRN No : " + txtTrm3.Text + lap.SPACE(5) + txtRpTrm3.Text.Trim().PadLeft(15));
lap.PROW(true, 1, lap.SPACE(70) + string.Format("{0:#,##0}", (Convert.ToDouble(txtRpTrm3.Text) + Convert.ToDouble(txtRpBkm3.Text))).PadLeft(15));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.PrintMinusSymbol(85));
lap.PROW(true, 1, "JUMLAH UANG MUKA : Rp." + txtRpTotal.Text.PadLeft(15));
lap.PROW(true, 1, "(" + Tools.Terbilang(Convert.ToDouble(txtRpTotal.Text)) + ")");
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.PadCenter(15, "Dibuat") + lap.SPACE(8) + lap.PadCenter(15, "Disetujui") + lap.SPACE(8) + lap.PadCenter(15, "Diketahui") + lap.SPACE(8) + lap.PadCenter(15, "Penerima"));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, lap.SPACE(85));
lap.PROW(true, 1, "(" + lap.SPACE(13) + ")" + lap.SPACE(8) + "(" + lap.SPACE(13) + ")" + lap.SPACE(8) + "(" + lap.SPACE(13) + ")" + lap.SPACE(8) + "(" + lap.SPACE(13) + ")");
lap.Eject();
//lap.SendToPrinter("laporanPS.txt");
lap.SendToFile("laporanPS.txt");
}
private string PrintHeader(int nUrut, int nMaxHal)
{
BuildString header = new BuildString();
int nHal = (int)Math.Round((nUrut / 18) + 0.4, 0) + 1;
header.PROW(true, 1, header.PrintTopLeftCorner() + header.PrintDoubleLine(4) + header.PrintTTOp() + header.PrintDoubleLine(77) + header.PrintTTOp() + header.PrintDoubleLine(3) + header.PrintTTOp() + header.PrintDoubleLine(14) + header.PrintTTOp() + header.PrintDoubleLine(14) + header.PrintTTOp() + header.PrintDoubleLine(14) + header.PrintTTOp() + header.PrintDoubleLine(7) + header.PrintTopRightCorner());
header.PROW(true, 1, header.PrintVerticalLine() + "No. " + header.PrintVerticalLine() + " N A M A B A R A N G " + header.PrintVerticalLine() + "SAT" + header.PrintVerticalLine() + " 1 " + header.PrintVerticalLine() + " 2 " + header.PrintVerticalLine() + " 3 " + header.PrintVerticalLine() + " OK. " + header.PrintVerticalLine());
header.PROW(true, 1, header.PrintTLeft() + header.PrintDoubleLine(4) + header.PrintTMidlle() + header.PrintDoubleLine(77) + header.PrintTMidlle() + header.PrintDoubleLine(3) + header.PrintTMidlle() + header.PrintDoubleLine(14) + header.PrintTMidlle() + header.PrintDoubleLine(14) + header.PrintTMidlle() + header.PrintDoubleLine(14) + header.PrintTMidlle() + header.PrintDoubleLine(7) + header.PrintTRight());
return(header.GenerateString());
}
private void DspReport5(DataTable dt)
{
//List<ReportParameter> rptParams = new List<ReportParameter>();
//rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//rptParams.Add(new ReportParameter("GroupLokasi", txtKodeRak.Text));
////call report viewer
//frmReportViewer ifrmReport = new frmReportViewer("Persediaan.rptFrmDetailPerKodeRak5.rdlc", rptParams, dt, "dsOpname_Data");
//ifrmReport.Show();
{
int i = 0;
int No = 0;
int n = dt.Rows.Count;
BuildString detail = new BuildString();
detail.FontCondensed(true);
detail.LeftMargin(0);
detail.PageLLine(33);
foreach (DataRowView dr in dt.DefaultView)
{
i++;
No++;
if (i == 1)
{
detail.PROW(true, 1, "FORM OPNAME 2014 NOMOR :");
detail.PROW(true, 1, " ");
detail.PROW(true, 1, "Tanggal : Hitungan ke :");
detail.PROW(true, 1, "-------------------------------------------------------------------------------------------------------------------------------------------------------");
detail.PROW(true, 1, "|No. | Nama Barang | Sat. | Kode Rak | Baik | Cacat | Rusak |");
detail.PROW(true, 1, "-------------------------------------------------------------------------------------------------------------------------------------------------------");
// |12345|xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx| xxxxx| xxxxxxx | | | |
}
detail.PROW(true, 1, "|" + i.ToString().PadLeft(5, ' ') + "|" + dr["NamaStok"].ToString().PadRight(100)
+ "| " + detail.PadCenter(5, dr["SatJual"].ToString()) + "| " + dr["Lokasi"].ToString() + " | | | |");
detail.PROW(true, 1, "| | | | | | | |");
detail.PROW(true, 1, "-------------------------------------------------------------------------------------------------------------------------------------------------------");
if ((No == n) || (i == 5 && No != n)) // eof()
{
i = 0;
detail.PROW(true, 1, " Penghitung Pencatat Ka. Area");
detail.PROW(true, 1, " ");
detail.PROW(true, 1, " ");
detail.PROW(true, 1, " (...............) (..............) (................)");
detail.Eject();
}
}
detail.SendToPrinter("detailPerKodeRak.txt");
}
}
private void DisplayReport2(DataTable dtA)
{
////construct parameter
//// periode = String.Format("{0} s/d {1}", ((DateTime)rgbTglDO.FromDate.Value).ToString("dd/MM/yyyy"), ((DateTime)rgbTglDO.ToDate.Value).ToString("dd/MM/yyyy"));
//List<ReportParameter> rptParams = new List<ReportParameter>();
//// rptParams.Add(new ReportParameter("Periode", periode));
//rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
////call report viewer
//frmReportViewer ifrmReport = new frmReportViewer("ArusStock.rptAntarGudangNota.rdlc", rptParams, dtA, "dsAntarGudang_Data");
//ifrmReport.Show();
int i = 0;
BuildString ag = new BuildString();
ag.FontCondensed(true);
ag.LeftMargin(3);
ag.PROW(true, 1, "BPB-AG");
ag.PROW(true, 1, "Gud. Tujuan : " + dtA.Rows[0]["KeGudang"].ToString() + ag.SPACE(50) +
"No : " + dtA.Rows[0]["NoAG"].ToString());
ag.PROW(true, 1, "Gud. Pengirim : " + dtA.Rows[0]["DrGudang"].ToString() + ag.SPACE(50) +
"Tanggal : " + dtA.Rows[0]["TglKirim"].ToString());
ag.PROW(true, 1, ag.PrintTopLeftCorner() + ag.PrintHorizontalLine(128) + ag.PrintTopRightCorner());
ag.PROW(true, 1, ag.PrintVerticalLine() + ag.PadCenter(5, "NO") + ag.PrintVerticalLine() +
ag.PadCenter(110, "NAMA BARANG") + ag.PrintVerticalLine() + ag.PadCenter(5, "SAT") + ag.PrintVerticalLine() +
ag.PadCenter(5, "QTY") + ag.PrintVerticalLine());
ag.PROW(true, 1, ag.PrintVerticalLine() + ag.PrintHorizontalLine(128) + ag.PrintVerticalLine());
foreach (DataRowView dr in dtA.DefaultView)
{
i++;
ag.PROW(true, 1, ag.PrintVerticalLine() + ag.PadCenter(5, i.ToString()) + ag.PrintVerticalLine() +
dr["NamaStok"].ToString().PadRight(110) + ag.PrintVerticalLine() + ag.PadCenter(5, dr["Satuan"].ToString()) + ag.PrintVerticalLine() +
dr["QtyKirim"].ToString().PadLeft(5) + ag.PrintVerticalLine());
}
ag.PROW(true, 1, ag.PrintBottomLeftCorner() + ag.PrintHorizontalLine(128) + ag.PrintBottomRightCorner());
ag.PROW(true, 1, ag.PadCenter(30, "Gudang") + ag.SPACE(20) + ag.PadCenter(30, "Checker 1") + ag.SPACE(20) +
ag.PadCenter(30, "Checker 2"));
ag.PROW(true, 1, "");
ag.PROW(true, 1, "");
ag.PROW(true, 1, "");
ag.PROW(true, 1, "(" + ag.SPACE(28) + ")" + ag.SPACE(20) + "(" + ag.SPACE(28) + ")" + ag.SPACE(20) +
"(" + ag.SPACE(28) + ")");
ag.Eject();
ag.SendToPrinter("notaJual.txt");
}
private void PrintRawBarangKeluar(DataTable dt)
{
BuildString barangKeluar = new BuildString();
string sales = dt.Rows[0]["Sales"].ToString().PadRight(23);
string tglKeluar = DateTime.Parse(dt.Rows[0]["TglKeluar"].ToString()).ToString("dd-MMM-yyyy");
string tglBatas = DateTime.Parse(dt.Rows[0]["TglBatas"].ToString()).ToString("dd-MMM-yyyy");
string noBukti = dt.Rows[0]["NoBukti"].ToString();
string penjamin = dt.Rows[0]["Penjamin"].ToString().PadRight(10);
string catatan = dt.Rows[0]["CatatanH"].ToString();
int No = 0;
barangKeluar.Initialize();
barangKeluar.PageLLine(33);
barangKeluar.FontCPI(12);
barangKeluar.Append(Convert.ToString((char)27) + Convert.ToString((char)33) + Convert.ToString((char)1));
barangKeluar.PROW(true, 1, barangKeluar.PadCenter(88, "BUKTI PEMINJAMAN BARANG"));
barangKeluar.PROW(true, 1, "");
barangKeluar.PROW(true, 1, "Nama salesman : " + sales + barangKeluar.SPACE(12) + "Tanggal pinjam : " + tglKeluar);
barangKeluar.PROW(true, 1, "Nomor pinjam : " + noBukti.PadRight(10) + barangKeluar.SPACE(25) + "Batas tanggal pinjam : " + tglBatas);
barangKeluar.PROW(true, 1, "Penjamin : " + penjamin);
barangKeluar.PROW(true, 1, barangKeluar.PrintEqualSymbol(88));
barangKeluar.PROW(true, 1, "No Nama Barang Qty");
barangKeluar.PROW(true, 1, barangKeluar.PrintMinusSymbol(88));
string namaStok = string.Empty;
int qtyKeluarGudang = 0;
foreach (DataRow dr in dt.Rows)
{
No++;
namaStok = dr["NamaStok"].ToString().PadRight(73);
qtyKeluarGudang = int.Parse(dr["QtyKeluarGudang"].ToString());
barangKeluar.PROW(true, 1, No.ToString().PadLeft(2) + " " + namaStok + barangKeluar.SPACE(5) + qtyKeluarGudang.ToString().PadLeft(3));
}
barangKeluar.PROW(true, 1, barangKeluar.PrintEqualSymbol(88));
barangKeluar.PROW(true, 1, "Catatan : " + catatan);
barangKeluar.PROW(true, 1, "");
barangKeluar.PROW(true, 1, "");
barangKeluar.PROW(true, 1, " Penjualan Peminjam");
barangKeluar.Eject();
barangKeluar.SendToPrinter("BarangKeluar.txt");
}
private string CetakHeader(string NamaToko, string Alamat, string Daerah)
{
BuildString PrintHeader = new BuildString();
PrintHeader.FontCondensed(true);
PrintHeader.PageLLine(33);
PrintHeader.PROW(true, 1, "ÕÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ͸");
PrintHeader.PROW(true, 1, "³TOKO : " + NamaToko + PrintHeader.SPACE(82 - NamaToko.Length) + "³");
PrintHeader.PROW(true, 1, "³ALAMAT : " + Alamat + PrintHeader.SPACE(82 - Alamat.Length) + "³");
PrintHeader.PROW(true, 1, "³DAERAH : " + Daerah + PrintHeader.SPACE(82 - Daerah.Length) + "³");
PrintHeader.PROW(true, 1, "ÃÄÄÂÄÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÂÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÄÂÄÄÂÄÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´");
PrintHeader.PROW(true, 1, "³ ³ ³ ³KD ³ ³ ³ ³ PEMBAYARAN ³");
PrintHeader.PROW(true, 1, "³NO³TGL.TERIMA ³NO.NOTA³BRG³ SALES ³JW³TGL.J.TEMPOÃÄÄÄÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄ´");
PrintHeader.PROW(true, 1, "³ ³ ³ ³ ³ ³ ³ ³ NILAI ³ TITIPAN ³ SALDO ³");
PrintHeader.PROW(true, 1, "ÃÄÄÅÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÅÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄÄÅÄÄÅÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄ´");
return(PrintHeader.GenerateString());
}
private void PrintRawMemoPeminjaman(DataTable dt)
{
BuildString memo = new BuildString();
string sales = dt.Rows[0]["Sales"].ToString().PadRight(23);
string tglKeluar = DateTime.Parse(dt.Rows[0]["TglKeluar"].ToString()).ToString("dd-MMM-yyyy");
string tglBatas = DateTime.Parse(dt.Rows[0]["TglBatas"].ToString()).ToString("dd-MMM-yyyy");
string noBukti = dt.Rows[0]["NoBukti"].ToString();
string penjamin = dt.Rows[0]["Penjamin"].ToString().PadRight(10);
int No = 0;
memo.Initialize();
memo.PageLLine(33);
memo.FontCPI(12);
memo.Append(Convert.ToString((char)27) + Convert.ToString((char)33) + Convert.ToString((char)1));
memo.PROW(true, 1, memo.PadCenter(88, "MEMO PEMINJAMAN BARANG"));
memo.PROW(true, 1, "");
memo.PROW(true, 1, "Nama salesman : " + sales + memo.SPACE(12) + "Tanggal pinjam : " + tglKeluar);
memo.PROW(true, 1, "Nomor pinjam : " + noBukti.PadRight(10) + memo.SPACE(25) + "Batas tanggal pinjam : " + tglBatas);
memo.PROW(true, 1, "Penjamin : " + penjamin);
memo.PROW(true, 1, memo.PrintEqualSymbol(88));
memo.PROW(true, 1, "No Nama Barang Pinjam Kirim");
memo.PROW(true, 1, memo.PrintMinusSymbol(88));
string namaStok = string.Empty;
int qtyMemo = 0;
foreach (DataRow dr in dt.Rows)
{
No++;
namaStok = dr["NamaStok"].ToString().PadRight(73);
qtyMemo = int.Parse(dr["QtyMemo"].ToString());
memo.PROW(true, 1, No.ToString().PadLeft(2) + " " + namaStok + " " + qtyMemo.ToString().PadLeft(3) + " ...");
}
memo.PROW(true, 1, memo.PrintEqualSymbol(88));
memo.PROW(true, 1, "");
memo.PROW(true, 1, "");
memo.PROW(true, 1, "");
memo.PROW(true, 1, " Ka.Gudang Checker 1 Checker 2 Gudang");
memo.Eject();
memo.SendToPrinter("MemoPeminjaman.txt");
}
private void PrintRawBarangKembali(DataTable dt)
{
BuildString barangKembali = new BuildString();
string sales = dt.Rows[0]["Sales"].ToString().PadRight(23);
string tglKembali = DateTime.Parse(dt.Rows[0]["TglKembaliPj"].ToString()).ToString("dd-MMM-yyyy");
string noKembali = dt.Rows[0]["NoKembali"].ToString();
string catatan = dt.Rows[0]["Catatan"].ToString();
int No = 0;
barangKembali.Initialize();
barangKembali.PageLLine(33);
barangKembali.FontCPI(12);
barangKembali.Append(Convert.ToString((char)27) + Convert.ToString((char)33) + Convert.ToString((char)1));
barangKembali.PROW(true, 1, barangKembali.PadCenter(88, "BUKTI PENGEMBALIAN PINJAMAN"));
barangKembali.PROW(true, 1, "");
barangKembali.PROW(true, 1, "Nama salesman : " + sales);
barangKembali.PROW(true, 1, "No.Pengembalian : " + noKembali + barangKembali.SPACE(28) + "Tgl.Pengembalian : " + tglKembali);
barangKembali.PROW(true, 1, barangKembali.PrintEqualSymbol(88));
barangKembali.PROW(true, 1, "No Nama Barang No.Pinj Qty");
barangKembali.PROW(true, 1, barangKembali.PrintMinusSymbol(88));
string namaStok = string.Empty;
string noPinjam = string.Empty;
int qtyKembali = 0;
foreach (DataRow dr in dt.Rows)
{
No++;
namaStok = dr["NamaStok"].ToString().PadRight(70);
noPinjam = dr["NoPinjam"].ToString().PadRight(10);
qtyKembali = int.Parse(dr["QtyKembali"].ToString());
barangKembali.PROW(true, 1, No.ToString().PadLeft(2) + " " + namaStok + " " + noPinjam + " " + qtyKembali.ToString().PadLeft(3));
}
barangKembali.PROW(true, 1, barangKembali.PrintEqualSymbol(88));
barangKembali.PROW(true, 1, "Catatan : " + catatan);
barangKembali.PROW(true, 1, "");
barangKembali.PROW(true, 1, "");
barangKembali.PROW(true, 1, " Penjualan Pengembali Ka.Gudang Gudang");
barangKembali.Eject();
barangKembali.SendToPrinter("BarangKembali.txt");
}
private void ShowNotepad(DataTable dt)
{
try
{
BuildString data = new BuildString();
data.PROW(true, 1, "HASIL DOWNLOAD NO.PERK DARI 11");
data.PROW(true, 1, "===============================================================================================");
data.PROW(true, 1, data.PrintVerticalLine2());
data.PROW(false, 3, "REF");
data.PROW(false, 7, data.PrintVerticalLine2());
data.PROW(false, 10, "No.Perkiraan");
data.PROW(false, 24, data.PrintVerticalLine2());
data.PROW(false, 50, "Nama Perkiraan");
data.PROW(false, 96, data.PrintVerticalLine2());
data.PROW(true, 1, "-----------------------------------------------------------------------------------------------");
foreach (DataRow dr in dt.Rows)
{
data.PROW(true, 1, data.PrintVerticalLine2());
data.PROW(false, 3, Tools.isNull(dr["ref"], "").ToString().Trim());
data.PROW(false, 7, data.PrintVerticalLine2());
data.PROW(false, 10, Tools.isNull(dr["no_perk"], "").ToString().Trim());
data.PROW(false, 24, data.PrintVerticalLine2());
data.PROW(false, 26, Tools.isNull(dr["uraian"], "").ToString().Trim());
data.PROW(false, 96, data.PrintVerticalLine2());
}
data.PROW(true, 1, "===============================================================================================");
data.Eject();
if (File.Exists(Properties.Settings.Default.OutputFile + "\\" + "NoPerk.txt"))
{
File.Delete(Properties.Settings.Default.OutputFile + "\\" + "NoPerk.txt");
}
data.SendToTxt("NoPerk.txt", data.GenerateString());
Process.Start(Properties.Settings.Default.OutputFile + "\\" + "NoPerk.txt");
}
catch (Exception ex)
{
Error.LogError(ex);
MessageBox.Show(ex.Message);
}
}
private void PrintRekapPerBulan(DataTable dt)
{
try
{
BuildString data = new BuildString();
data.AddCR();
data.PROW(true, 1, "Kartu Piutang " + lookupToko1.NamaToko.Trim() + " " + lookupToko1.Alamat.Trim() + " " + lookupToko1.Kota.Trim());
data.PROW(true, 1, " " + "Id.Wil: " + lookupToko1.WilID + " Plafon : Rp." + lookupToko1.Plafon.ToString("#,##0"));
data.PROW(true, 1, "");
data.PROW(true, 1, " Bulan Penjualan Pembayaran Retur/Tarikan Lain-lain ");
data.PROW(true, 1, "============================================================================= ");
string bulan = string.Empty;
foreach (DataRow dr in dt.Rows)
{
data.PROW(true, 1,
Tools.Left(dr["TglTransaksi"].ToString(), 10) + " " +
Tools.Left(dr["Combine"].ToString(), 4) + " " +
double.Parse(dr["RpJual"].ToString()).ToString("#,##0") + " " +
double.Parse(dr["Rpbayar"].ToString()).ToString("#,##0") + " " +
double.Parse(dr["RpRetur"].ToString()).ToString("#,##0") + " " +
double.Parse(dr["RpLain"].ToString()).ToString("#,##0") + " "
);
}
data.PROW(true, 1, "============================================================================= ");
data.PROW(true, 1, " " +
double.Parse(dt.Compute("SUM(RpJual)", string.Empty).ToString()).ToString("#,##0") + " " +
double.Parse(dt.Compute("SUM(Rpbayar)", string.Empty).ToString()).ToString("#,##0") + " " +
double.Parse(dt.Compute("SUM(RpRetur)", string.Empty).ToString()).ToString("#,##0") + " " +
double.Parse(dt.Compute("SUM(RpLain)", string.Empty).ToString()).ToString("#,##0") + " "
);
data.Eject();
data.SendToPrinter("show.txt", data.GenerateString());
Process.Start(Properties.Settings.Default.OutputFile + "\\" + "show.txt");
}
catch (System.Exception ex)
{
Error.LogError(ex);
MessageBox.Show(ex.Message);
}
}
private void DisplayReport(DataTable dt)
{
////construct parameter
//List<ReportParameter> rptParams=new List<ReportParameter>();
//rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
////call report viewer
//frmReportViewer ifrmReport=new frmReportViewer("Persediaan.rptDetailPerKodeRak.rdlc", rptParams, dt, "dsOpname_Data");
//ifrmReport.Show();
int i = 0;
BuildString detail = new BuildString();
detail.FontCondensed(true);
detail.LeftMargin(3);
foreach (DataRowView dr in dt.DefaultView)
{
i++;
detail.PROW(true, 1, detail.PrintTopLeftCorner() + detail.PrintHorizontalLine(42) + detail.PrintTTOp() +
detail.PrintHorizontalLine(42) + detail.PrintTTOp() + detail.PrintHorizontalLine(42) + detail.PrintTopRightCorner());
detail.PROW(true, 1, detail.PrintVerticalLine() + "Tanggal :".PadRight(42) + detail.PrintVerticalLine() + "No. Form :".PadRight(42)
+ detail.PrintVerticalLine() + detail.PadCenter(42, "KODE RAK :" + dr["Lokasi"].ToString()) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(5) + detail.PrintTTOp() +
detail.PrintHorizontalLine(36) + detail.PrintTBottom() + detail.PrintHorizontalLine(42) + detail.PrintTBottom() +
detail.PrintHorizontalLine(20) + detail.PrintTTOp() + detail.PrintHorizontalLine(5) + detail.PrintTTOp() +
detail.PrintHorizontalLine(15) + detail.PrintTRight());
detail.PROW(true, 1, detail.PrintVerticalLine() + detail.PadCenter(5, "NO.") + detail.PrintVerticalLine() + detail.PadCenter(100, "NAMA BARANG")
+ detail.PrintVerticalLine() + detail.PadCenter(5, "SAT") + detail.PrintVerticalLine() + detail.PadCenter(15, "PENGHITUNG") + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(5) + detail.PrintTMidlle() +
detail.PrintHorizontalLine(100) + detail.PrintTMidlle() + detail.PrintHorizontalLine(5) + detail.PrintTMidlle() +
detail.PrintHorizontalLine(15) + detail.PrintTRight());
//detail.PROW(true, 1, detail.PrintVerticalLine() + detail.PadCenter(5, "") + detail.PrintVerticalLine() + detail.PadCenter(100, "")
// + detail.PrintVerticalLine() + detail.PadCenter(5, "") + detail.PrintVerticalLine() + detail.PadCenter(15, "") + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + i.ToString().PadLeft(5) + detail.PrintVerticalLine() + dr["NamaStok"].ToString().PadRight(100)
+ detail.PrintVerticalLine() + detail.PadCenter(5, dr["SatJual"].ToString()) + detail.PrintVerticalLine() + detail.PadCenter(15, "") + detail.PrintVerticalLine());
//detail.PROW(true, 1, detail.PrintVerticalLine() + detail.PadCenter(5, "") + detail.PrintVerticalLine() + detail.PadCenter(100, "")
// + detail.PrintVerticalLine() + detail.PadCenter(5, "") + detail.PrintVerticalLine() + detail.PadCenter(15, "") + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(5) + detail.PrintTBottom() +
detail.PrintHorizontalLine(22) + detail.PrintTTOp() + detail.PrintHorizontalLine(28) + detail.PrintTTOp() +
detail.PrintHorizontalLine(28) + detail.PrintTTOp() + detail.PrintHorizontalLine(19) + detail.PrintTBottom() +
detail.PrintHorizontalLine(5) + detail.PrintTBottom() + detail.PrintHorizontalLine(15) + detail.PrintTRight());
detail.PROW(true, 1, detail.PrintVerticalLine() + detail.PadCenter(28, "BAIK") + detail.PrintVerticalLine() + detail.PadCenter(28, "CACAT") + detail.PrintVerticalLine()
+ detail.PadCenter(28, "RUSAK") + detail.PrintVerticalLine() + "Dicatat Oleh,".PadLeft(41) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + detail.PadCenter(28, "") + detail.PrintVerticalLine() + detail.PadCenter(28, "") + detail.PrintVerticalLine()
+ detail.PadCenter(28, "") + detail.PrintVerticalLine() + "".PadLeft(41) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + detail.PadCenter(28, "") + detail.PrintVerticalLine() + detail.PadCenter(28, "") + detail.PrintVerticalLine()
+ detail.PadCenter(28, "") + detail.PrintVerticalLine() + "".PadLeft(41) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + detail.PadCenter(28, "") + detail.PrintVerticalLine() + detail.PadCenter(28, "") + detail.PrintVerticalLine()
+ detail.PadCenter(28, "") + detail.PrintVerticalLine() + "Bag. Adm. Persediaan".PadLeft(41) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintBottomLeftCorner() + detail.PrintHorizontalLine(28) + detail.PrintTBottom() + detail.PrintHorizontalLine(28) + detail.PrintTBottom() +
detail.PrintHorizontalLine(28) + detail.PrintTBottom() + detail.PrintHorizontalLine(41) + detail.PrintBottomRightCorner());
if ((i % 2 == 0) && (i % 4 != 0))
{
for (int j = 0; j < 10; j++)
{
detail.PROW(true, 1, "");
}
}
else if (i % 4 == 0)
{
detail.Eject();
}
}
if (i % 2 != 0)
{
detail.Eject();
}
detail.SendToPrinter("notaJual.txt");
}
private void Cetak(DataTable dt)
{
BuildString detail = new BuildString();
string NoDKN = Tools.isNull(dt.Rows[0]["NoDKN"], "").ToString();
string Tanggal = Tools.isNull(dt.Rows[0]["Tanggal"], "").ToString();
string Cabang = Tools.isNull(dt.Rows[0]["Cabang"], "").ToString();
string DK = Tools.isNull(dt.Rows[0]["DK"], "").ToString();
string headerTitle = string.Empty;
string deskripsi = string.Empty;
int posHeader = 0;
if (DK == "K")
{
headerTitle = "KREDIT NOTA";
deskripsi = "Dengan ini kami menkredit Rekening Saudara untuk transaksi sebagai berikut";
posHeader = 12;
}
else if (DK == "D")
{
headerTitle = "DEBET NOTA";
deskripsi = "Dengan ini kami mendebet Rekening Saudara untuk transaksi sebagai berikut";
posHeader = 13;
}
string Perkiraan = string.Empty;
string Uraian = string.Empty;
double Jumlah = 0;
double sumJumlah = 0;
string tempJumlah = string.Empty;
string typePrinter = detail.GetPrinterName();
detail.Initialize();
detail.FontCondensed(false);
detail.FontCPI(7);
detail.PageLLine(33);
detail.LeftMargin(5);
detail.BottomMargin(1);
detail.FontCondensed(true);
#region Header
if (typePrinter.Contains("LX"))
{
detail.LetterQuality(false);
detail.FontBold(true);
detail.FontCondensed(true);
detail.DoubleHeight(true);
}
else
{
detail.LetterQuality(true);
detail.FontBold(true);
detail.DoubleHeight(true);
detail.DoubleWidth(true);
}
detail.FontBold(false);
detail.DoubleHeight(false);
detail.DoubleWidth(false);
detail.FontCondensed(false);
detail.LineSpacing("1/8");
detail.AddCR();
detail.FontCPI(12);
detail.PROW(true, 1, detail.PrintTopLeftCorner() + detail.PrintHorizontalLine(92) + detail.PrintTopRightCorner());
detail.PROW(false, 30, detail.PrintTTOp());
detail.PROW(true, 1, detail.PrintVerticalLine());
//detail.FontBold(true);
//detail.FontBold(false);
detail.PROW(false, 30, detail.PrintVerticalLine() + " Tanggal : " + ((DateTime)dt.Rows[0]["Tanggal"]).ToString("dd/MM/yyyy").PadRight(51) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine());
detail.FontCPI(14);
detail.FontBold(true);
detail.PROW(false, posHeader, headerTitle);
detail.FontCPI(12);
detail.FontBold(false);
detail.PROW(false, 36, detail.PrintTLeft() + detail.PrintHorizontalLine(64) + detail.PrintTRight());
detail.PROW(true, 1, detail.PrintVerticalLine());
detail.PROW(false, 30, detail.PrintVerticalLine() + detail.SPACE(1) + "Kepada : Kepala Administrasi " + Cabang.PadRight(31) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine());
detail.PROW(false, 8, "[No: " + NoDKN + "]");
detail.PROW(false, 30, detail.PrintTLeft() + detail.PrintHorizontalLine(64) + detail.PrintTRight());
detail.PROW(true, 1, detail.PrintVerticalLine());
detail.PROW(false, 30, detail.PrintVerticalLine() + detail.SPACE(1) + "Lampiran :" + detail.SPACE(10) + "lbr: ".PadRight(42) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(92) + detail.PrintTRight());
detail.PROW(false, 30, detail.PrintTBottom());
detail.PROW(true, 1, detail.PrintVerticalLine() + deskripsi.PadRight(93) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(91) + detail.PrintTRight());
detail.PROW(false, 15, detail.PrintTTOp());
detail.PROW(false, 84, detail.PrintTTOp());
detail.PROW(true, 1, detail.PrintVerticalLine() + " Perkiraan " + detail.PrintVerticalLine() + detail.SPACE(31) + "Uraian" + detail.SPACE(31) + detail.PrintVerticalLine() + " Jumlah " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(91) + detail.PrintTRight());
detail.PROW(false, 15, detail.PrintTLeft());
detail.PROW(false, 84, detail.PrintTRight());
#endregion
#region CetakDetail
foreach (DataRow dr in dt.Rows)
{
Perkiraan = dr["NoPerkiraan"].ToString();
Uraian = dr["Uraian"].ToString();
Jumlah = double.Parse(dr["Jumlah"].ToString());
sumJumlah = sumJumlah + Jumlah;
tempJumlah = Jumlah.ToString("#,##0");
detail.PROW(true, 1, detail.PrintVerticalLine() + Perkiraan + detail.SPACE(1) + detail.PrintVerticalLine() + Uraian.PadRight(68) + detail.PrintVerticalLine() + tempJumlah.PadLeft(10) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(91) + detail.PrintTRight());
detail.PROW(false, 15, detail.PrintTBottom());
detail.PROW(false, 84, detail.PrintTBottom());
//header.PROW(true, 1, header.PrintVerticalLine() + header.SPACE(2) + "Perkiraan" + header.SPACE(2) + header.PrintVerticalLine() + header.SPACE(22) + "Uraian" + header.SPACE(22) + header.PrintVerticalLine() + header.SPACE(2) + "Jumlah" + header.SPACE(2) + header.PrintVerticalLine());
}
detail.PROW(true, 1, detail.PrintVerticalLine() + detail.SPACE(14) + "Total" + detail.SPACE(64) + sumJumlah.ToString("#,##0").PadLeft(10) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(93) + detail.PrintTRight());
detail.PROW(true, 1, detail.PrintVerticalLine() + "Terbilang" + detail.SPACE(5) + ISA.Common.Tools.Terbilang(sumJumlah).PadRight(79) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + detail.SPACE(93) + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(91) + detail.PrintTRight());
detail.PROW(false, 32, detail.PrintTTOp());
detail.PROW(false, 61, detail.PrintTTOp());
#endregion
#region Footer
detail.PROW(true, 1, detail.PrintVerticalLine() + " Dibuat Oleh " + detail.PrintVerticalLine() + " Mengetahui " + detail.PrintVerticalLine() + " Dibukukan Oleh " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintTLeft() + detail.PrintHorizontalLine(91) + detail.PrintTRight());
detail.PROW(false, 32, detail.PrintTTOp());
detail.PROW(false, 61, detail.PrintTTOp());
detail.PROW(true, 1, detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintVerticalLine() + " MNG " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine() + " " + detail.PrintVerticalLine());
detail.PROW(true, 1, detail.PrintBottomLeftCorner() + detail.PrintHorizontalLine(91) + detail.PrintRightBottomCorner2());
detail.PROW(false, 32, detail.PrintTBottom());
detail.PROW(false, 61, detail.PrintTBottom());
#endregion
detail.Eject();
detail.SendToPrinter("DebetKreditNota.txt", detail.GenerateString());
}
private void PrintLaporan(DataTable dt)
{
BuildString lap = new BuildString();
string typePrinter = lap.GetPrinterName();
//string NamaBank = Tools.isNull(dt.Rows[0]["Bank"], "").ToString();
string NoBBK = Tools.isNull(dt.Rows[0]["NoBBK"], "").ToString().Trim();
string TglBBK = ((DateTime)dt.Rows[0]["TglBBK"]).ToString("dd-MMM-yyyy").Trim();
string Pembukuan = Tools.isNull(dt.Rows[0]["Dibukukan"], "").ToString().Trim();
string Mengetahui = Tools.isNull(dt.Rows[0]["Diketahui"], "").ToString().Trim();
string Kasir = Tools.isNull(dt.Rows[0]["Kasir"], "").ToString().Trim();
string Penerima = Tools.isNull(dt.Rows[0]["Penerima"], "").ToString().Trim();
string Nomor = string.Empty;
string NamaBank = string.Empty;
string TglGiro = string.Empty;
string TglJth = string.Empty;
double Jumlah = 0;
double sumJumlah = 0;
string tempJumlah = string.Empty;
int i = 0;
int rowNo = 0;
int no = 0;
int ttlData = dt.Rows.Count;
int hal = 1;
int ttlHal = 0;
int prevHal = hal;
if (ttlData % 10 > 0)
{
ttlHal = (ttlData / 10) + 1;
}
else
{
ttlHal = ttlData / 10;
}
//lap.Initialize();
//lap.PageLLine(33);
//lap.LeftMargin(3);
//lap.FontCPI(10);
//lap.DoubleWidth(true);
//lap.PROW(true, 1, "[VOUCHER BUKA GIRO]");
//lap.DoubleWidth(false);
//lap.FontCondensed(true);
//lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(64)+lap.PrintTTOp()+ lap.PrintHorizontalLine(63)+ lap.PrintTopRightCorner());
//lap.PROW(true, 1, lap.PrintVerticalLine() + "Dibayarkan Kepada: ".PadRight(64) + lap.PrintVerticalLine()+ ("Nomor : " + NoBBK).PadRight(63) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintVerticalLine() + Penerima.PadRight(64) + lap.PrintVerticalLine()+ "Tanggal: " + TglBBK.PadRight(20) + "Hal :" + hal.ToString() + "/" + ttlHal.ToString().PadRight(22) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(64) + lap.PrintTBottom() + lap.PrintHorizontalLine(63) + lap.PrintTRight());
//lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(15,"Nomor") + lap.PadCenter(51,"Bank") + lap.PadCenter(21,"Tgl.Giro") + lap.PadCenter(21,"Tgl.JT") + lap.PadCenter(20,"Nilai Tranfer")+ lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(128) + lap.PrintTRight());
bool cetak = true;
foreach (DataRow dr in dt.Rows)
{
#region header
if (cetak)
{
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, "[VOUCHER BUKA GIRO]");
lap.DoubleWidth(false);
lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(41) + lap.PrintTTOp() + lap.PrintHorizontalLine(41) +
lap.PrintTopRightCorner());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Dibayarkan Kepada: ".PadRight(41) + lap.PrintVerticalLine() +
("Nomor : " + NoBBK).PadRight(41) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + Penerima.PadRight(41) + lap.PrintVerticalLine() + ("Tanggal: " +
TglBBK).PadRight(30) + ("Hal : " + hal.ToString() + "/" + ttlHal.ToString()).PadRight(11) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(41) + lap.PrintTBottom() + lap.PrintHorizontalLine(41) +
lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(15, "Nomor") + lap.PadCenter(27, "Nama Bank") +
lap.PadCenter(13, "Tgl.Giro") + lap.PadCenter(13, "Tgl.JT") + lap.PadCenter(15, "Nilai Tranfer") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
}
#endregion
Nomor = dr["Nomor"].ToString().Trim();
NamaBank = dr["Bank"].ToString().Trim();
TglGiro = ((DateTime)dr["TglGiro"]).ToString("dd-MMM-yyyy").Trim();
TglJth = ((DateTime)dr["TglJth"]).ToString("dd-MMM-yyyy").Trim();
Jumlah = double.Parse(dr["Nominal"].ToString());
sumJumlah = sumJumlah + Jumlah;
tempJumlah = Jumlah.ToString("#,##0");
lap.PROW(true, 1, lap.PrintVerticalLine() + Nomor.PadRight(15) + NamaBank.PadRight(27) + lap.PadCenter(13, TglGiro) + lap.PadCenter(13, TglJth) +
tempJumlah.PadLeft(15) + lap.PrintVerticalLine());
i++;
no++;
rowNo++;
cetak = false;
if (hal == ttlHal && 10 - no > 0 && rowNo == ttlData)
{
for (int j = 0; j < 10 - no; j++)
{
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(83) + lap.PrintVerticalLine());
}
}
#region footer
if (ttlData == rowNo || no == 10)
{
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Terbilang".PadRight(58) + "Jumlah Rp." + sumJumlah.ToString("#,##0").PadLeft(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + Tools.Terbilang(sumJumlah).PadRight(83) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) +
lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "Pembukuan") + lap.PrintVerticalLine() + lap.PadCenter(20, "Mengetahui")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "Kasir") + lap.PrintVerticalLine() + lap.PadCenter(20, "Penerima") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine() + lap.SPACE(20) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Pembukuan) + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Mengetahui) + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Kasir) + ")"
+ lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Penerima) + ")" + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintBottomLeftCorner() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) +
lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintRightBottomCorner2());
lap.PROW(true, 1, String.Format("{0:yyyyMMddhh:mm:ss}", DateTime.Now) + " " + SecurityManager.UserName);
lap.Eject();
}
#endregion
}
lap.SendToPrinter("BBK.txt", lap.GenerateString());
}
private void PrintLaporan(DataTable dt)
{
BuildString lap = new BuildString();
Guid _RowID = (Guid)dt.Rows[0]["RowID"];
string typePrinter = lap.GetPrinterName();
string NamaBank = Tools.isNull(dt.Rows[0]["NamaBank"], "").ToString().Trim();
string NoBBM = Tools.isNull(dt.Rows[0]["NoBBM"], "").ToString().Trim();
string TglBBM = ((DateTime)dt.Rows[0]["TglBBM"]).ToString("dd-MMM-yyyy").Trim();
string Pembukuan = Tools.isNull(dt.Rows[0]["Dibukukan"], "").ToString().Trim();
string Mengetahui = Tools.isNull(dt.Rows[0]["Diketahui"], "").ToString().Trim();
string Kasir = Tools.isNull(dt.Rows[0]["Kasir"], "").ToString().Trim();
string Penyetor = Tools.isNull(dt.Rows[0]["Penyetor"], "").ToString().Trim();
string Nomor = string.Empty;
string AsalTransfer = string.Empty;
string Bank = string.Empty;
string TglBank = string.Empty;
string TglTransfer = string.Empty;
double Jumlah = 0;
double sumJumlah = 0;
string tempJumlah = string.Empty;
int i = 0;
int rowNo = 0;
int no = 0;
int ttlData = dt.Rows.Count;
int hal = 1;
int ttlHal = 0;
int prevHal = hal;
if (ttlData % 10 > 0)
{
ttlHal = (ttlData / 10) + 1;
}
else
{
ttlHal = ttlData / 10;
}
//lap.Initialize();
//lap.PageLLine(33);
//lap.LeftMargin(3);
//lap.FontCPI(10);
//lap.DoubleWidth(true);
//lap.PROW(true, 1, "[Bukti Bank Masuk]");
//lap.DoubleWidth(false);
//lap.FontCondensed(true);
//lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(128) + lap.PrintTopRightCorner());
//lap.PROW(false, 63, lap.PrintTTOp());
//lap.PROW(true, 1, lap.PrintVerticalLine() + "Diterima Dari: ".PadRight(61) + lap.PrintVerticalLine());
//lap.PROW(false, 65, "Nomor : " + NoBBM.PadRight(57) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintVerticalLine() + NamaBank.PadRight(61) + lap.PrintVerticalLine());
//lap.PROW(false, 65, "Tanggal: " + TglBBM.PadLeft(10) + lap.SPACE(3) + "Hal : " + hal.ToString() + "/" + ttlHal.ToString().PadRight(36) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(128) + lap.PrintTRight());
//lap.PROW(false, 63, lap.PrintTBottom());
//lap.PROW(true, 1, lap.PrintVerticalLine() + "Nomor" + lap.SPACE(16) + "Asal Transfer" + lap.SPACE(16) + "Bank" + lap.SPACE(16) + "Tgl.Bank" + lap.SPACE(16) + "Tgl.Trf" + lap.SPACE(15) + "Nilai Tranfer" + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(129) + lap.PrintTRight());
bool cetak = true;
foreach (DataRow dr in dt.Rows)
{
#region header
if (cetak)
{
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, "[Bukti Bank Masuk]");
lap.DoubleWidth(false);
lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(41) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(41) + lap.PrintTopRightCorner());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Diterima Dari: ".PadRight(41) +
lap.PrintVerticalLine() + ("Nomor : " + NoBBM).PadRight(41) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + NamaBank.PadRight(41) + lap.PrintVerticalLine() + ("Tanggal : " +
TglBBM).PadRight(30) + ("Hal : " + hal.ToString() + "/" + ttlHal.ToString()).PadRight(11) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(41) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(41) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(10, "Nomor") + lap.PadCenter(20, "Asal Transfer") + lap.SPACE(1)
+ lap.PadCenter(11, "Bank") + lap.PadCenter(13, "Tgl. Bank") + lap.PadCenter(13, "Tgl. Trf")
+ lap.PadCenter(15, "Nilai Transfer") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
}
#endregion
Nomor = dr["Nomor"].ToString().Trim();
AsalTransfer = dr["AsalTransfer"].ToString().Trim();
Bank = dr["Bank"].ToString().Trim();
TglBank = ((DateTime)dr["TglBank"]).ToString("dd-MMM-yyyy").Trim();
TglTransfer = ((DateTime)dr["TglTransfer"]).ToString("dd-MMM-yyyy").Trim();
Jumlah = double.Parse(dr["Nominal"].ToString());
sumJumlah = sumJumlah + Jumlah;
lap.PROW(true, 1, lap.PrintVerticalLine() + Nomor.PadRight(10) + AsalTransfer.ToUpper().PadRight(20).Substring(0, 20) + lap.SPACE(1)
+ dr["NamaBank"].ToString().PadRight(11).Substring(0, 11) + lap.PadCenter(13, TglBank)
+ lap.PadCenter(13, TglTransfer) + Jumlah.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
i++;
no++;
rowNo++;
cetak = false;
if (hal == ttlHal && 10 - no > 0 && rowNo == ttlData)
{
for (int j = 0; j < 10 - no; j++)
{
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(83) + lap.PrintVerticalLine());
}
}
#region footer
if (ttlData == rowNo || no == 10)
{
prevHal = hal;
hal++;
no = 0;
cetak = true;
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Terbilang".PadRight(58) + "Jumlah Rp." +
sumJumlah.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + Tools.Terbilang(sumJumlah).PadRight(83) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "Pembukuan") + lap.PrintVerticalLine() + lap.PadCenter(20, "Mengetahui")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "Kasir") + lap.PrintVerticalLine() + lap.PadCenter(20, "Penyetor") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Pembukuan) + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Mengetahui)
+ ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Kasir) + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Penyetor) + ")" +
lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintBottomLeftCorner() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintBottomRightCorner());
lap.PROW(true, 1, String.Format("{0:yyyyMMddhh:mm:ss}", DateTime.Now) + " " + SecurityManager.UserName);
lap.Eject();
}
#endregion
}
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_TransferBank_Update"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@NPrint", SqlDbType.Int, (int)dt.Rows[0]["NPrint"] + 1));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].ExecuteNonQuery();
}
lap.SendToPrinter("BBM.txt", lap.GenerateString());
//lap.SendToFile("BBM.txt");
}
private void CetakBORaw(DataTable dt)
{
BuildString detail = new BuildString();
const int RowsPerPage = 16;
int nMaxHal = dt.Rows.Count;
int nHal = 0;
int nUrut = 0;
double x = (nMaxHal / RowsPerPage);
nMaxHal = nMaxHal % RowsPerPage == 0 ? (int)Math.Round(x, 0) : (int)(nMaxHal / RowsPerPage) + 1;
detail.Append(CetakHeaderBO(dt, nUrut, nMaxHal, out nHal));
#region Cetak Detail
double nJumlah = 0;
string NamaStok = string.Empty;
string KodeRak = string.Empty;
string Satuan = string.Empty;
string Dikirim = string.Empty;
string tempQSisa = string.Empty;
string JumlahDo = string.Empty;
string HargaJual = string.Empty;
string HargaNet = string.Empty;
string JumlahDiskon = string.Empty;
int QtyDO = 0;
int QtySuratJalan = 0;
int QSisa = 0;
double Net = 0;
detail.FontCondensed(true);
foreach (DataRow dr in dt.Rows)
{
nUrut++;
NamaStok = dr["NamaBarang"].ToString().PadRight(65, '.');
KodeRak = detail.STR(7, dr["KodeRak"].ToString());
Satuan = detail.STR(3, dr["Satuan"].ToString());
QtyDO = int.Parse(dr["QtyDO"].ToString());
QtySuratJalan = int.Parse(Tools.isNull(dr["QtySuratJalan"], "0").ToString());
Dikirim = nUrut % 2 == 1 ? detail.STR(3, nUrut.ToString()) + ".[_______] " : detail.STR(16, nUrut.ToString()) + ".[_______]";
QSisa = int.Parse(Tools.isNull(dr["QtySisa"], "0").ToString());
Net = double.Parse(Tools.isNull(dr["HrgNet"], "0").ToString());
JumlahDo = Convert.ToString((QtyDO - QtySuratJalan));
nJumlah = nJumlah + Net;
tempQSisa = QSisa == 0 ? " 0" : QSisa.ToString("#,###").PadLeft(7, ' ');
HargaJual = double.Parse(dr["HrgJual"].ToString()).ToString("#,###");
HargaNet = double.Parse(dr["HrgNet"].ToString()).ToString("#,###");
JumlahDiskon = double.Parse(dr["JmlDisc"].ToString()).ToString("#,###");
JumlahDiskon = string.IsNullOrEmpty(JumlahDiskon) == true ? "0" : JumlahDiskon;
detail.PROW(true, 1, detail.STR(2, nUrut.ToString()) + ". " + NamaStok + " " + KodeRak + " " + detail.STR(5, JumlahDo) + " " + Satuan + Dikirim + detail.STR(9, HargaJual) + " " + detail.STR(10, JumlahDiskon) + " " + detail.STR(10, HargaNet) + " " + tempQSisa);
if ((nUrut % RowsPerPage == 0) && (nHal < nMaxHal))
{
detail.PROW(true, 1, detail.PrintDoubleLine(164));
detail.PROW(true, 1, "A/R-SAS : " + SecurityManager.UserName + ", Tgl." + DateTime.Now.ToString("dd-MMM-yyy") + " Jam " + DateTime.Now.ToShortTimeString());
detail.PROW(true, 1, "");
detail.PROW(true, 1, " ( Bag. Piutang ) ( Bag. Penjualan ) ( Bag. Gudang ) ( Bag. Cheker I ) ( Bag. Cheker II )");
detail.Eject();
detail.Append(CetakHeaderBO(dt, nUrut, nMaxHal, out nHal));
}
}
if (nUrut % RowsPerPage != 0)
{
for (int i = nUrut + 1; i <= nUrut + (RowsPerPage - (nUrut % RowsPerPage)); i++)
{
detail.PROW(true, 1, detail.STR(2, i.ToString()) + ". ");
}
}
#endregion
#region Footer
detail.PROW(true, 1, detail.PrintDoubleLine(151));
detail.PROW(true, 1, "A/R-SAS : " + SecurityManager.UserName + ", Tgl." + DateTime.Now.ToString("dd-MMM-yyy") + " Jam " + DateTime.Now.ToShortTimeString());
detail.DoubleWidth(true);
detail.FontItalic(true);
detail.AddCR();
detail.PROW(false, 43, "Total D.O ");
detail.PROW(false, 59, "Rp." + nJumlah.ToString("#,###").PadLeft(14, ' '));
detail.DoubleWidth(false);
detail.FontItalic(false);
detail.PROW(true, 1, " ( Bag. Piutang ) ( Bag. Penjualan ) ( Bag. Gudang ) ( Bag. Cheker I ) ( Bag. Cheker II )");
detail.Eject();
#endregion
detail.SendToPrinter("bo.txt");
}
private string CetakHeaderBO(DataTable dt, int nUrut, int nMaxHal, out int nHlm)
{
BuildString header = new BuildString();
const int RowsPerPage = 16;
int nHal = (int)Math.Round((nUrut / RowsPerPage) + 0.4, 0) + 1;
nHlm = nHal;
string cat1 = dt.Rows[0]["Catatan1"].ToString();
string cat2 = dt.Rows[0]["Catatan2"].ToString();
string sales = GetSales();
string namaToko = dt.Rows[0]["NamaToko"].ToString();
string cClass = dt.Rows[0]["StsToko"].ToString();
string TglDO = header.GetDayName(DateTime.Now.DayOfWeek.ToString()) + ", " + DateTime.Now.ToString("dd-MMM-yyyy");
string DO = dt.Rows[0]["NoDO"].ToString() + " " + header.GetDayName(Convert.ToDateTime(dt.Rows[0]["TglDO"].ToString()).DayOfWeek.ToString()) + ", " + Convert.ToDateTime(dt.Rows[0]["TglDO"].ToString()).ToString("dd-MMM-yyyy");
string noRq = dt.Rows[0]["NoRequest"].ToString() + " " + header.GetDayName(Convert.ToDateTime(dt.Rows[0]["TglRequest"].ToString()).DayOfWeek.ToString()) + ", " + Convert.ToDateTime(dt.Rows[0]["TglRequest"].ToString()).ToString("dd-MMM-yyyy");
string alamatKirim = header.Alamat(dt.Rows[0]["Alamat"].ToString());
string nSpace = namaToko.Trim() + header.SPACE(namaToko.Trim().Length + (15 - namaToko.Trim().Length) - 7) + cClass;
string waktu = dt.Rows[0]["HariKredit"].ToString() + " Hari / ";
string wilID = dt.Rows[0]["WilID"].ToString().Trim();
string daerah = header.Daerah(dt.Rows[0]["Daerah"].ToString()) + "(Wil: " + wilID + ") ";
string kota = header.Kota(dt.Rows[0]["Kota"].ToString());
string expedisi = dt.Rows[0]["Expedisi"].ToString();
string namaExpedisi = dt.Rows[0]["NamaExpedisi"].ToString();
double plafon = double.Parse(dt.Rows[0]["Plafon"].ToString());
string grade = dt.Rows[0]["Grade"].ToString();
#region Cetak Header
header.Initialize();
header.FontCondensed(false);
header.FontCPI(12);
header.PageLLine(33);
header.LeftMargin(1);
header.BottomMargin(1);
header.DoubleHeight(true);
header.DoubleWidth(true);
header.PROW(true, 1, "DELIVERY ORDER (BO)");
header.DoubleHeight(false);
header.DoubleWidth(false);
header.LetterQuality(true);
header.FontCPI(12);
header.FontBold(true);
header.PROW(true, 1, header.Sales(sales));
header.FontBold(false);
header.FontItalic(false);
header.LineSpacing("1/6");
header.FontItalic(true);
header.AddCR();
header.Append(" ");
header.FontItalic(false);
header.FontCondensed(true);
header.PROW(false, 53, header.PrintTopLeftCorner() + header.PrintHorizontalLine(2) + " Pengiriman kepada Toko " + header.PrintHorizontalLine(14) + header.PrintTopRightCorner());
header.PROW(true, 1, cat1.PadRight(47, ' '));
header.PROW(false, 51, header.PrintVerticalLine() + header.SPACE(40) + header.PrintVerticalLine());
header.FontBold(true);
header.AddCR();
header.PROW(false, 55, nSpace);
header.FontBold(false);
header.FontBold(true);
header.PROW(true, 1, "TGL.DOBO : ");
header.FontBold(false);
header.FontItalic(true);
header.AddCR();
header.PROW(false, 13, TglDO);
header.FontItalic(false);
header.PROW(false, 53, header.PrintVerticalLine() + header.SPACE(40) + header.PrintVerticalLine());
//header.FontCondensed(true);
header.FontItalic(true);
header.AddCR();
header.PROW(false, 92, alamatKirim);
header.FontItalic(false);
//header.FontCondensed(false);
header.FontBold(true);
header.PROW(true, 1, "ASAL D.O : ");
header.FontBold(false);
header.FontItalic(true);
header.AddCR();
header.PROW(false, 13, DO);
header.FontItalic(false);
header.PROW(false, 53, header.PrintVerticalLine() + header.SPACE(40) + header.PrintVerticalLine());
header.FontItalic(true);
header.AddCR();
header.PROW(false, 55, daerah);
header.FontItalic(false);
header.FontBold(true);
header.PROW(true, 1, "JK.WAKTU : ");
header.FontBold(false);
header.FontItalic(true);
header.AddCR();
header.PROW(false, 13, waktu + cat2.PadRight(20, ' '));
header.FontItalic(false);
header.PROW(false, 53, header.PrintVerticalLine() + header.SPACE(40) + header.PrintVerticalLine());
header.FontItalic(true);
header.AddCR();
header.PROW(false, 55, kota);
header.FontItalic(false);
header.FontBold(true);
header.PROW(true, 1, "NOMOR RQ. : ");
header.FontBold(false);
header.FontItalic(true);
header.AddCR();
header.PROW(false, 13, noRq);
header.FontItalic(false);
header.PROW(false, 53, header.PrintVerticalLine() + header.SPACE(31) + "Grade: " + header.PrintVerticalLine());
header.FontItalic(true);
header.AddCR();
header.PROW(false, 55, "PLAFON :" + plafon.ToString("#,###").PadLeft(14, ' '));
header.FontItalic(false);
header.PROW(false, 91, header.STR(2, grade));
header.FontItalic(false);
header.FontBold(true);
header.PROW(true, 1, "EXPEDISI : ");
header.FontBold(false);
header.FontItalic(true);
header.AddCR();
header.PROW(false, 13, expedisi + " (" + namaExpedisi + ")");
header.FontItalic(false);
header.PROW(false, 53, header.PrintBottomLeftCorner() + header.PrintHorizontalLine(40) + header.PrintBottomRightCorner());
header.LetterQuality(false);
//header.FontCondensed(true);
header.LineSpacing("1/6");
header.PROW(true, 1, "No. N a m a B a r a n g RAK Dipesan Dikirim H.Sat. Disc./Pot. Jml.Net Stok");
header.PROW(true, 1, header.PrintDoubleLine(151));
#endregion
return(header.GenerateString());
}
private void PrintRawSuratJalan(DataTable dt)
{
BuildString suratJalan = new BuildString();
int jumlahkoli = 0;
#region Header
string nosj = dt.Rows[0]["NoSuratJalan"].ToString();
string namatoko = dt.Rows[0]["NamaToko"].ToString();
string alamat = dt.Rows[0]["Alamat"].ToString();
string tmp = string.Empty;
if (alamat.Length > 28)
{
tmp = alamat.Substring(0, 28);
}
else
{
tmp = alamat + " ";
}
int pos = tmp.LastIndexOf(' ');
string alamat1 = tmp.Substring(0, pos);
string alamat3 = dt.Rows[0]["Alamat3"].ToString();
string alamat2 = alamat.Substring(pos).Trim() + alamat3;
string kota = dt.Rows[0]["Kota"].ToString();
string kodeexpedisi = dt.Rows[0]["KodeExp1"].ToString();
string[] namaexpedisi = new string[4];
namaexpedisi[1] = dt.Rows[0]["NamaExpedisi1"].ToString();
namaexpedisi[2] = dt.Rows[0]["NamaExpedisi2"].ToString();
namaexpedisi[3] = dt.Rows[0]["NamaExpedisi3"].ToString();
string idwil = dt.Rows[0]["WilID"].ToString();
string tlp = dt.Rows[0]["Telp"].ToString();
DateTime tglsuratjalan = DateTime.Parse(dt.Rows[0]["TglSuratJalan"].ToString());
suratJalan.Initialize();
suratJalan.Append((char)27 + "@" + (char)27 + "C" + (char)33 + (char)27 + "M");
suratJalan.Append(Convert.ToString((char)27) + Convert.ToString((char)33) + Convert.ToString((char)1));
suratJalan.PROW(true, 1, "");
suratJalan.PROW(true, 1, suratJalan.PadCenter(80, "SURAT JALAN"));
suratJalan.PROW(true, 1, "");
suratJalan.PROW(true, 1, "NO. : " + nosj.PadRight(14) + suratJalan.SPACE(20) + "KEPADA YTH :");
suratJalan.PROW(true, 1, "KENDARAAN : .............." + suratJalan.SPACE(20) + namatoko);
suratJalan.PROW(true, 1, "NO. POLISI : .............." + suratJalan.SPACE(20) + alamat1);
if (kodeexpedisi == "SAS")
{
//kodeexpedisi = suratJalan.SPACE(3);
suratJalan.PROW(true, 1, "EXPEDISI : " + kodeexpedisi.PadRight(34) + (string.IsNullOrEmpty(alamat2) == true ? kota : alamat2));
if (!string.IsNullOrEmpty(alamat2))
{
suratJalan.PROW(true, 1, "TANGGAL : " + tglsuratjalan.ToString("dd-MMM-yyyy").PadRight(14) + suratJalan.SPACE(20) + kota);
suratJalan.PROW(true, 1, suratJalan.SPACE(48) + "WIL : " + idwil + (string.IsNullOrEmpty(tlp) == true ? tlp : ",TELP : " + tlp));
}
else
{
suratJalan.PROW(true, 1, "TANGGAL : " + tglsuratjalan.ToString("dd-MMM-yyyy").PadRight(14) + suratJalan.SPACE(20) + "WIL : " + idwil + (string.IsNullOrEmpty(tlp) == true ? tlp : ",TELP : " + tlp));
}
}
else
{
suratJalan.PROW(true, 1, "EXPEDISI : " + namaexpedisi[1].PadRight(34) + (string.IsNullOrEmpty(alamat2) == false ? alamat2 : kota));
if (!string.IsNullOrEmpty(namaexpedisi[2]) && !string.IsNullOrEmpty(namaexpedisi[3]))
{
//suratJalan.PROW(true, 1, suratJalan.SPACE(14) + namaexpedisi[2].PadRight(34) + (string.IsNullOrEmpty(alamat2) == false ? kota : "WIL : " + idwil) + (string.IsNullOrEmpty(tlp) == true ? tlp : ", TELP : "+ tlp));
//suratJalan.PROW(true, 1, suratJalan.SPACE(14) + namaexpedisi[3].PadRight(34) + (string.IsNullOrEmpty(alamat2) == false ? "WIL : " + idwil : "") + (string.IsNullOrEmpty(tlp) == true ? tlp : ", TELP : "+ tlp));
suratJalan.PROW(true, 1, "TANGGAL : " + tglsuratjalan.ToString("dd-MMM-yyyy").PadRight(14));
}
else if (!string.IsNullOrEmpty(namaexpedisi[2]) && string.IsNullOrEmpty(namaexpedisi[3]))
{
//suratJalan.PROW(true, 1, suratJalan.SPACE(14) + namaexpedisi[2].PadRight(34) + (string.IsNullOrEmpty(alamat2) == false ? kota : "WIL : " + idwil) + (string.IsNullOrEmpty(tlp) == true ? tlp : ", TELP : "+ tlp));
suratJalan.PROW(true, 1, "TANGGAL : " + tglsuratjalan.ToString("dd-MMM-yyyy").PadRight(14) + suratJalan.SPACE(20) + (string.IsNullOrEmpty(alamat2) == false ? "WIL : " + idwil : "") + (string.IsNullOrEmpty(tlp) == true ? tlp : ", TELP : " + tlp));
}
else if (string.IsNullOrEmpty(namaexpedisi[2]) && string.IsNullOrEmpty(namaexpedisi[3]))
{
suratJalan.PROW(true, 1, "TANGGAL : " + tglsuratjalan.ToString("dd-MMM-yyyy").PadRight(14) + suratJalan.SPACE(20) + (string.IsNullOrEmpty(alamat2) == false ? kota : "WIL : " + idwil) + (string.IsNullOrEmpty(tlp) == true ? tlp : ", TELP : " + tlp));
if (!string.IsNullOrEmpty(alamat2))
{
suratJalan.PROW(true, 1, suratJalan.SPACE(58) + "WIL : " + idwil + (string.IsNullOrEmpty(tlp) == true ? tlp : ", TELP : " + tlp));
}
}
}
suratJalan.PROW(true, 1, suratJalan.PrintEqualSymbol(88));
suratJalan.PROW(true, 1, " NO.DO NO.NOTA SALES URAIAN JUMLAH SATUAN KETERANGAN ");
suratJalan.PROW(true, 1, suratJalan.Replicate(".", 88));
#endregion
#region Detail
string nonota = string.Empty;
string nodo = string.Empty;
string sales = string.Empty;
string lastNoNota = string.Empty;
string uraian = string.Empty;
string ket = string.Empty;
string satuan = string.Empty;
int jumlah = 0;
foreach (DataRow dr in dt.Rows)
{
nonota = dr["NoNota"].ToString();
nodo = dr["NoDO"].ToString();
sales = dr["Sales"].ToString();
uraian = dr["Uraian"].ToString();
ket = dr["Keterangan"].ToString();
satuan = dr["Satuan"].ToString();
jumlah = int.Parse(dr["Jumlah"].ToString());
jumlahkoli += jumlah;
if (lastNoNota.Equals(nonota))
{
sales = suratJalan.SPACE(11);
nodo = suratJalan.SPACE(7);
nonota = suratJalan.SPACE(7);
}
else
{
lastNoNota = nonota;
}
suratJalan.PROW(true, 1, " " + nodo +
" " + nonota +
" " + sales +
" " + uraian.PadRight(12) +
" " + jumlah.ToString("#,###;(#,###);#").PadLeft(7) +
" " + suratJalan.PadCenter(6, satuan) +
" " + ket.PadRight(30));
}
#endregion
#region Footer
string namacabang = dt.Rows[0]["NamaCabang"].ToString();
string alamatexpedisi = dt.Rows[0]["AlamatExpedisi"].ToString();
string tlpexpedisi = dt.Rows[0]["TlpExpedisi"].ToString();
suratJalan.PROW(true, 1, suratJalan.PrintEqualSymbol(88));
if (dt.Rows[0]["KodeExp1"].ToString() != "SAS")
{
//suratJalan.PROW(true, 1, "KEMBALI KE SAS " + namacabang +" ***"+ suratJalan.SPACE(4) + jumlahkoli.ToString("#,##0").PadLeft(6));
suratJalan.PROW(true, 1, suratJalan.SPACE(41) + jumlahkoli.ToString("#,##0").PadLeft(6) + suratJalan.SPACE(11) + (char)27 + (char)33 + (char)24 + "FRANGKO" + (char)27 + (char)33 + (char)1);
}
else
{
suratJalan.PROW(true, 1, suratJalan.SPACE(41) + jumlahkoli.ToString("#,##0").PadLeft(6) + suratJalan.SPACE(11) + (char)27 + (char)33 + (char)24 + "FRANGKO" + (char)27 + (char)33 + (char)1);
}
suratJalan.PROW(true, 1, "");
if (dt.Rows[0]["KodeExp1"].ToString() != "SAS")
{
suratJalan.PROW(true, 1, "ALAMAT Expedisi : " + alamatexpedisi + " " + tlpexpedisi);
suratJalan.PROW(true, 1, "");
}
suratJalan.PROW(true, 1, " PENERIMA PENGIRIMAN SOPIR");
suratJalan.PROW(true, 1, "");
suratJalan.PROW(true, 1, "");
suratJalan.PROW(true, 1, "");
suratJalan.PROW(true, 1, "");
suratJalan.PROW(true, 1, " (..........) (...........) (............)");
suratJalan.PROW(true, 1, SecurityManager.UserName + ", Tgl." + DateTime.Now.ToString("dd-MMM-yyyy") + " Jam " + DateTime.Now.ToShortTimeString());
suratJalan.Eject();
#endregion
suratJalan.SendToFile("RekapKoli.txt");
//suratJalan.SendToPrinter("RekapKoli.txt");
}
public void cetakLaporan()
{
int i = 0;
double total = 0, jumlah;
string _Terima, _NoBukti, _Tanggal, _Lampiran, _Kasir;
_Terima = asalGiro;
_NoBukti = noBKM;
_Lampiran = " ";
_Tanggal = tglCair.ToString("dd-MMM-yyyy");
_Kasir = SecurityManager.UserName;
try
{
BuildString lap = new BuildString();
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, "[BUKTI KAS MASUK]");
lap.DoubleWidth(false);
lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(41) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(41) + lap.PrintTopRightCorner());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Di Terima Dari : ".PadRight(41) +
lap.PrintVerticalLine() + ("Nomor : " + _NoBukti).PadRight(41) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + _Terima.PadRight(41) + lap.PrintVerticalLine() + ("Tanggal : " +
_Tanggal).PadRight(30) + ("Hal : 1/1").PadRight(11) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(41) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(41) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "No. Prk".PadRight(10) + lap.PadCenter(58, "URAIAN") + lap.SPACE(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
foreach (DataRow dr in dtBKMDetail.Rows)
{
jumlah = Convert.ToDouble(dr["Jumlah"].ToString());
lap.PROW(true, 1, lap.PrintVerticalLine() + "".ToString().Trim().PadRight(10) + dr["Uraian"].ToString().ToUpper().PadRight(58).Substring(0, 58) + jumlah.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
total += Convert.ToDouble(dr["Jumlah"].ToString());
i++;
}
if (i < 10)
{
for (int j = 0; j < 10 - i; j++)
{
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(83) + lap.PrintVerticalLine());
}
}
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Terbilang".PadRight(58) + "Jumlah Rp.".PadRight(10) +
total.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + ISA.Common.Tools.Terbilang(total).PadRight(83) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "Pembukuan") + lap.PrintVerticalLine() + lap.PadCenter(20, "Mengetahui")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "Kasir") + lap.PrintVerticalLine() + lap.PadCenter(20, "Penerima") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "") + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "")
+ ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, _Kasir.Trim()) + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, _Terima.Trim()) + ")" +
lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintBottomLeftCorner() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintBottomRightCorner());
lap.PROW(true, 1, String.Format("{0:yyyyMMddhhmmss}", DateTime.Now) + " " + SecurityManager.UserName);
lap.Eject();
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("rsp_CetakBukti"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _titipID));
db.Commands[0].ExecuteNonQuery();
}
lap.SendToPrinter("laporan.txt");
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void PrintRawSPPB(DataTable dt)
{
BuildString sppb = new BuildString();
int No = 1;
int n = dt.Rows.Count;
int i = 0;
int p = 0;
int s = 0;
p = n / 13;
s = n % 13;
bool _repeat = true;
#region "Header"
sppb.Initialize();
sppb.LeftMargin(1);
sppb.BottomMargin(1);
sppb.PROW(true, 1, "KODE RAK : TANGGAL :");
#endregion
string _NamaStok = string.Empty;
string _Pcs = string.Empty;
string _Lok = string.Empty;
string _Header1 = sppb.PrintTopLeftCorner() + sppb.PrintDoubleLine(4) + sppb.PrintTTOp() + sppb.PrintDoubleLine(77) + sppb.PrintTTOp() + sppb.PrintDoubleLine(3) + sppb.PrintTTOp() + sppb.PrintDoubleLine(15) + sppb.PrintTTOp() + sppb.PrintDoubleLine(15) + sppb.PrintTTOp() + sppb.PrintDoubleLine(15) + sppb.PrintTTOp() + sppb.PrintDoubleLine(7) + sppb.PrintTopRightCorner();
string _Header2 = sppb.PrintVerticalLine() + "No. " + sppb.PrintVerticalLine() + " N A M A B A R A N G " + sppb.PrintVerticalLine() + "SAT" + sppb.PrintVerticalLine() + " 1 " + sppb.PrintVerticalLine() + " 2 " + sppb.PrintVerticalLine() + " 3 " + sppb.PrintVerticalLine() + " OK. " + sppb.PrintVerticalLine();
string _Header3 = sppb.PrintTLeft() + sppb.PrintDoubleLine(4) + sppb.PrintTMidlle() + sppb.PrintDoubleLine(77) + sppb.PrintTMidlle() + sppb.PrintDoubleLine(3) + sppb.PrintTMidlle() + sppb.PrintDoubleLine(15) + sppb.PrintTMidlle() + sppb.PrintDoubleLine(15) + sppb.PrintTMidlle() + sppb.PrintDoubleLine(15) + sppb.PrintTMidlle() + sppb.PrintDoubleLine(7) + sppb.PrintTRight();
string _Footer1 = sppb.PrintTLeft() + sppb.PrintHorizontalLine(4) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(77) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(3) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(15) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(15) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(15) + sppb.PrintTMidlle() + sppb.PrintHorizontalLine(7) + sppb.PrintTRight();
string _Footer2 = sppb.PrintBottomLeftCorner() + sppb.PrintHorizontalLine(4) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(77) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(3) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(15) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(15) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(15) + sppb.PrintTBottom() + sppb.PrintHorizontalLine(7) + sppb.PrintBottomRightCorner();
string _temp = sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine() + " " + sppb.PrintVerticalLine();
foreach (DataRow dr in dt.Rows)
{
#region "Header"
if (i == 0 && _repeat)
{
sppb.PROW(true, 1, _Header1);
sppb.PROW(true, 1, _Header2);
sppb.PROW(true, 1, _Header3);
}
#endregion
if (i <= 13)
{
_NamaStok = dr["NamaStok"].ToString();
_Pcs = dr["SatJual"].ToString();
_Lok = dr["Lokasi"].ToString();
sppb.PROW(true, 1, sppb.PrintVerticalLine() + No.ToString().PadLeft(4, ' ') + sppb.PrintVerticalLine() + _NamaStok.PadRight(73, '.') + sppb.SPACE(4) + sppb.PrintVerticalLine() + _Pcs.PadLeft(3, ' ') + _temp + _Lok.PadLeft(7, ' ') + sppb.PrintVerticalLine());
sppb.PROW(true, 1, (No == n || i == 12) ? _Footer2 : _Footer1);
_repeat = false;
if (i == 12 || No == n)
{
sppb.PROW(true, 1, " ");
_repeat = true;
i = -1;
sppb.Eject();
}
}
i++;
No++;
}
sppb.SendToPrinter("sppb.txt", sppb.ToString());
}
public void cetakLaporan()
{
if ((int.Parse(dgDetailBank.SelectedCells[0].OwningRow.Cells["NPrint"].Value.ToString()) > 0) && (!SecurityManager.IsManager()))
{
if (!SecurityManager.AskPasswordManager())
{
return;
}
}
string Keterangan, NoBBK, TglBank, NoBGCH, NamaBank, TglRK, Nilai, Kasir, jnsTran, Tanggal;
string txtJudul, txtKeterangan, txtNamaBank, txtPenerima;
Guid _rowID = (Guid)dgDetailBank.SelectedCells[0].OwningRow.Cells["RowID"].Value;
Keterangan = dgDetailBank.SelectedCells[0].OwningRow.Cells["Keterangan"].Value.ToString().Trim();
NamaBank = dgHeaderBank.SelectedCells[0].OwningRow.Cells["NamaBank"].Value.ToString().Trim();
Tanggal = String.Format("{0:dd-MMM-yyyy}", (DateTime)dgDetailBank.SelectedCells[0].OwningRow.Cells["TglBank"].Value);
TglBank = String.Format("{0:dd-MMM-yyyy}", (DateTime)dgDetailBank.SelectedCells[0].OwningRow.Cells["TglBank"].Value);
NoBBK = dgDetailBank.SelectedCells[0].OwningRow.Cells["NoBBKD"].Value.ToString().Trim();
NoBGCH = dgDetailBank.SelectedCells[0].OwningRow.Cells["NoBGCH"].Value.ToString().Trim();
TglRK = String.Format("{0:dd-MMM-yyyy}", (DateTime)dgDetailBank.SelectedCells[0].OwningRow.Cells["TglRK"].Value);
jnsTran = dgDetailBank.SelectedCells[0].OwningRow.Cells["JnsTran"].Value.ToString().Trim();
Kasir = SecurityManager.UserID;
if (jnsTran == "BBM")
{
txtJudul = "BUKTI BANK MASUK";
txtKeterangan = "Diterima dari : ";
txtNamaBank = "Asal Transfer";
txtPenerima = "Penyetor";
Nilai = String.Format("{0:0,0}", Convert.ToDouble(dgDetailBank.SelectedCells[0].OwningRow.Cells["Debet"].Value));
}
else
{
txtJudul = "BUKTI BANK KELUAR";
txtKeterangan = "Dibayar kepada : ";
txtNamaBank = "Transfer Ke";
txtPenerima = "Penerima";
Nilai = String.Format("{0:0,0}", Convert.ToDouble(dgDetailBank.SelectedCells[0].OwningRow.Cells["Kredit"].Value));
}
try
{
BuildString lap = new BuildString();
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, txtJudul);
lap.DoubleWidth(false);
lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(41) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(41) + lap.PrintTopRightCorner());
lap.PROW(true, 1, lap.PrintVerticalLine() + txtKeterangan.PadRight(41) +
lap.PrintVerticalLine() + ("Nomor : " + NoBBK).PadRight(41) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + Keterangan.PadRight(41).Substring(0, 41) + lap.PrintVerticalLine() + ("Tanggal : " +
Tanggal).PadRight(30) + "Hal : 1/1".PadRight(11) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(41) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(41) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(15, "Nomor") + lap.PadCenter(16, txtNamaBank) + lap.SPACE(1) + lap.PadCenter(10, "Bank")
+ lap.PadCenter(13, "Tgl Bank") + lap.PadCenter(13, "Tgl Trf") + lap.PadCenter(15, "Nilai Transfer") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + NoBGCH.PadRight(15) + NamaBank.ToString().ToUpper().PadRight(16).Substring(0, 16) + lap.SPACE(1) + "".PadRight(10) +
lap.PadCenter(13, TglBank) + lap.PadCenter(13, TglRK)
+ Nilai.PadLeft(15) + lap.PrintVerticalLine());
for (int j = 0; j < 9; j++)
{
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(83) + lap.PrintVerticalLine());
}
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Terbilang".PadRight(58) + "Jumlah Rp." +
Nilai.PadLeft(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + Tools.Terbilang(Convert.ToDouble(Nilai)).PadRight(83) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "Pembukuan") + lap.PrintVerticalLine() + lap.PadCenter(20, "Mengetahui")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "Kasir") + lap.PrintVerticalLine() + lap.PadCenter(20, txtPenerima) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "") + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "")
+ ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Kasir) + ")" + lap.PrintVerticalLine() + "(" + lap.SPACE(18) + ")" +
lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintBottomLeftCorner() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintBottomRightCorner());
lap.PROW(true, 1, ":: " + String.Format("{0:yyyyMMddhh:mm:ss}", DateTime.Now) + " " + SecurityManager.UserName);
lap.Eject();
using (Database db = new Database(GlobalVar.DBFinance))
{
db.Commands.Add(db.CreateCommand("rsp_CetakBankDetail"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].ExecuteNonQuery();
}
DetailRefresh(_rowID);
DetailFindRow("RowID", _rowID.ToString());
lap.SendToPrinter("laporanPS.txt");
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void PrintRawPengantarSuratJalan(DataTable dt)
{
BuildString printESC = new BuildString();
printESC.Initialize();
printESC.LeftMargin(0);
printESC.FontCPI(15);
printESC.Append(PrintHeader(dt));
int nKoli = 0;
int jKoli = 0;
int ctr = 0;
int no = 0;
string namaToko = string.Empty;
string noNota = string.Empty;
string noSJ = string.Empty;
string tunaiKredit = string.Empty;
string sales = string.Empty;
string ket = string.Empty;
string tempAlamat = string.Empty;
string alamat1 = string.Empty;
string alamat2 = string.Empty;
string lastToko = string.Empty;
string lastAlamat1 = string.Empty;
bool printAlamat1 = false;
bool printAlamat2 = false;
bool firstRecord = true;
int recordCount = 0;
string kodeToko_ = string.Empty;
ctr = 12;
int row = 0;
bool first = true;
foreach (DataRow dr in dt.Rows)
{
recordCount++;
namaToko = dr["Toko"].ToString();
kodeToko_ = dr["KodeToko"].ToString();
jKoli = int.Parse(dr["JmlKoli"].ToString());
noNota = dr["NoNota"].ToString();
noSJ = dr["NoSuratJalan"].ToString();
tunaiKredit = dr["TK"].ToString();
sales = dr["Sales"].ToString();
ket = dr["Keterangan"].ToString();
tempAlamat = dr["Alamat"].ToString();
if (tempAlamat.Length > 31)
{
alamat1 = tempAlamat.Substring(0, 31);
int pos = alamat1.LastIndexOf(' ');
alamat1 = alamat1.Substring(0, pos).PadRight(31);
alamat2 = tempAlamat.Substring(pos);
}
else
{
alamat1 = tempAlamat.PadRight(31);
alamat2 = string.Empty;
}
alamat2 = alamat2.TrimStart();
nKoli += jKoli;
if (lastToko.Equals(kodeToko_)) //(lastToko.Equals(kodeToko_) && lastAlamat1.Equals(alamat1))
{
if (printAlamat1 == false)
{
printAlamat1 = true;
printESC.PROW(true, 1, "|" + " |" + alamat1 + "|" + jKoli.ToString().PadLeft(4) +
"|" + noNota + "|" + noSJ + "| " + tunaiKredit + " |" + sales.PadRight(11) + "|" + ket.PadRight(14) + "| " + printESC.SPACE(23) + " |");
}
else if (printAlamat2 == false)
{
printAlamat2 = true;
printESC.PROW(true, 1, "|" + " |" + alamat2.PadRight(31) + "|" + jKoli.ToString().PadLeft(4) +
"|" + noNota + "|" + noSJ + "| " + tunaiKredit + " |" + sales.PadRight(11) + "|" + ket.PadRight(14) + "| " + printESC.SPACE(23) + " |");
}
else
{
printESC.PROW(true, 1, "|" + " |" + printESC.SPACE(31) + "|" + jKoli.ToString().PadLeft(4) +
"|" + noNota + "|" + noSJ + "| " + tunaiKredit + " |" + sales.PadRight(11) + "|" + ket.PadRight(14) + "| " + printESC.SPACE(23) + " |");
}
firstRecord = true;
row++;
ctr++;
}
else if (printAlamat1 == false && printAlamat2 == false && firstRecord == false)
{
printESC.PROW(true, 1, "| |" + alamat1 + "| | | | | | | |");
row += 1;
ctr = ctr + 1;
if (!string.IsNullOrEmpty(alamat2.Trim()))
{
printESC.PROW(true, 1, "| |" + alamat2.PadRight(31) + "| | | | | | | |");
row += 1;
ctr = ctr + 1;
}
//row += 2;
//ctr = ctr + 2;
firstRecord = true;
printAlamat1 = true;
printAlamat2 = true;
}
else
{
no++;
if (row < 5 && first == false)
{
for (int i = 0; i < 5 - row; i++)
{
printESC.PROW(true, 1, "| | | | | | | | | |");
}
ctr = ctr + (5 - row);
}
row = 0;
if (no != 1)
{
printESC.PROW(true, 1, "| | | | | | | | | ....................... |");
row += 1;
ctr = ctr + 1;
}
else
{
row += 1;
}
if ((ctr >= 47) && (recordCount != dt.Rows.Count))
{
ctr = 0;
printESC.PROW(true, 1, "| | | | | | | | | |");
printESC.PROW(true, 1, "==================================================================================================================");
printESC.Eject();
printESC.Append(PrintHeader(dt));
ctr = 12;
first = true;
}
printESC.PROW(true, 1, "|" + no.ToString().PadLeft(2) + "|" + namaToko.PadRight(31) + "|" + jKoli.ToString().PadLeft(4) +
"|" + noNota + "|" + noSJ + "| " + tunaiKredit + " |" + sales.PadRight(11) + "|" + ket.PadRight(14) + "| " + " " + " |");
firstRecord = true;
printAlamat1 = false;
printAlamat2 = false;
first = false;
row += 1;
ctr = ctr + 1;
}
lastToko = kodeToko_;
lastAlamat1 = alamat1;
}
if (row < 5)
{
for (int i = 0; i < 5 - row; i++)
{
printESC.PROW(true, 1, "| | | | | | | | | |");
}
ctr = ctr + (5 - row);
}
printESC.PROW(true, 1, "------------------------------------------------------------------------------------------------------------------");
printESC.PROW(true, 1, "| TOTAL KOLI |" + nKoli.ToString().PadLeft(4) + "| |");
printESC.PROW(true, 1, "==================================================================================================================");
printESC.Eject();
printESC.SendToFile("PengantarSuratJalan.txt");
}
public void cetakLaporan()
{
int nprint = int.Parse(gridHeader.SelectedCells[0].OwningRow.Cells["hdrNPrint"].Value.ToString());
if ((nprint > 0) && (!SecurityManager.IsManager()))
{
if (!SecurityManager.AskPasswordManager())
{
return;
}
}
double total = 0, jumlah;
string _Kepada, _NoBukti, _Tanggal, _Kasir;
Guid _rowID = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value;
string _uraian = gridHeader.SelectedCells[0].OwningRow.Cells["hdrUraian"].Value.ToString().Trim();
string _dari = gridHeader.SelectedCells[0].OwningRow.Cells["hdrUraian2"].Value.ToString().Split('|').GetValue(0).ToString().Trim();
_Kepada = gridHeader.SelectedCells[0].OwningRow.Cells["KetBon"].Value.ToString().Trim();
_Kasir = gridHeader.SelectedCells[0].OwningRow.Cells["hdrDibuat"].Value.ToString();
_NoBukti = gridHeader.SelectedCells[0].OwningRow.Cells["hdrNoVoucher"].Value.ToString();
_Tanggal = Convert.ToDateTime(gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value).ToString("dd/MM/yyyy");
int rowNo = 0;
int no = 0;
int ttlData = dtDetail.Rows.Count;
int hal = 1;
int ttlHal = 0;
int prevHal = hal;
if (ttlData % 10 > 0)
{
ttlHal = (ttlData / 10) + 1;
}
else
{
ttlHal = ttlData / 10;
}
try
{
BuildString lap = new BuildString();
//lap.Initialize();
//lap.PageLLine(33);
//lap.LeftMargin(3);
//lap.FontCPI(10);
//lap.DoubleWidth(true);
//lap.PROW(true, 1, "[BUKTI KAS KELUAR]");
//lap.DoubleWidth(false);
//lap.FontCondensed(true);
//lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(63) + lap.PrintTTOp()
// + lap.PrintHorizontalLine(64) + lap.PrintTopRightCorner());
//lap.PROW(true, 1, lap.PrintVerticalLine() + "Kepada : ".PadRight(63) +
// lap.PrintVerticalLine() + "Nomor : " + _NoBukti.PadRight(54) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintVerticalLine() + _Kepada.PadRight(63) + lap.PrintVerticalLine() + "Tanggal : " +
// _Tanggal.PadRight(30) + "Hal : " + hal.ToString() + "/" + ttlHal.ToString().PadRight(12) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(63) + lap.PrintTBottom()
// + lap.PrintHorizontalLine(64) + lap.PrintTRight());
//lap.PROW(true, 1, lap.PrintVerticalLine() + "No. Prk".PadRight(15) + lap.PadCenter(98, "URAIAN") + lap.SPACE(15) + lap.PrintVerticalLine());
//lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(128) + lap.PrintTRight());
bool cetak = true;
foreach (DataRow dr in dtDetail.Rows)
{
#region header
if (cetak)
{
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, "[BUKTI KAS KELUAR]");
lap.DoubleWidth(false);
//lap.FontCondensed(true);
lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(41) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(41) + lap.PrintTopRightCorner());
lap.PROW(true, 1, lap.PrintVerticalLine() + ("Kepada : " + _dari.Trim()).PadRight(41) +
lap.PrintVerticalLine() + ("Nomor : " + _NoBukti).PadRight(41) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + _Kepada.PadRight(41) + lap.PrintVerticalLine() + ("Tanggal : " +
_Tanggal).PadRight(30) + ("Hal : " + hal.ToString() + "/" + ttlHal.ToString()).PadRight(11) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(41) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(41) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "No. Prk".PadRight(10) + lap.PadCenter(58, "URAIAN") + lap.SPACE(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
}
#endregion
jumlah = Convert.ToDouble(dr["Debet"].ToString());
lap.PROW(true, 1, lap.PrintVerticalLine() + "".PadRight(10) + dr["Keterangan"].ToString().ToUpper().PadRight(58).Substring(0, 58) + jumlah.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
total += Convert.ToDouble(dr["Debet"].ToString());
no++;
rowNo++;
cetak = false;
if (hal == ttlHal && 10 - no > 0 && rowNo == ttlData)
{
for (int j = 0; j < 10 - no; j++)
{
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(83) + lap.PrintVerticalLine());
}
}
#region footer
if (ttlData == rowNo || no == 10)
{
prevHal = hal;
hal++;
no = 0;
cetak = true;
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Terbilang".PadRight(58) + "Jumlah Rp.".PadRight(10) +
total.ToString("#,###").PadLeft(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + Tools.Terbilang(total).PadRight(83) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "Pembukuan") + lap.PrintVerticalLine() + lap.PadCenter(20, "Mengetahui")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "Kasir") + lap.PrintVerticalLine() + lap.PadCenter(20, "Penerima") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "") + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "")
+ ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, _Kasir.Trim()) + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "") + ")" +
lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintBottomLeftCorner() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintBottomRightCorner());
lap.PROW(true, 1, String.Format("{0:yyyyMMddhhmmss}", DateTime.Now) + " " + SecurityManager.UserName);
lap.Eject();
}
#endregion
}
//UPDATE NPRINT
using (Database db = new Database(GlobalVar.DBName))
{
VoucherJournal.UpdateNPrint(db, _rowID, nprint + 1);
}
//REFRESH ROW HEADER
RefreshRowHeader(_rowID);
lap.SendToPrinter("laporanPS.txt");
//lap.SendToFile("laporanPS.txt");
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void CetakPackingList(DataTable dt)
{
BuildString data = new BuildString();
data.Initialize();
data.PageLLine(11);
data.FontCPI(15);
data.DoubleHeight(true);
data.DoubleWidth(true);
data.PROW(true, 1, "");
data.PROW(true, 1, "PACKING LIST");
data.PROW(true, 1, "");
data.DoubleHeight(false);
data.DoubleWidth(false);
data.LetterQuality(true);
data.FontCPI(10);
data.PROW(true, 1, "Tanggal : " + ((DateTime)dt.Rows[0]["tglSuratJalan"]).ToString("dd-MMM-yyyy"));
data.AddCR();
data.PROW(false, 51, "Dikirim Ke : " + dt.Rows[0]["NamaToko"].ToString().PadRight(31));
data.PROW(true, 1, "Expedisi : " + dt.Rows[0]["Expedisi"]);
data.AddCR();
data.PROW(false, 51, "Alamat : " + dt.Rows[0]["Kota"].ToString().PadRight(20));
data.FontCondensed(true);
data.PROW(true, 1, data.PrintTopLeftCorner() + data.PrintHorizontalLine(139) + data.PrintTopRightCorner());
data.PROW(true, 1, data.PrintVerticalLine() + "No." + data.PrintVerticalLine() + " NOTA "
+ data.PrintVerticalLine() + " N A M A B A R A N G "
+ data.PrintVerticalLine() + " QUANTITY " + data.PrintVerticalLine() + " NOMOR KOLI "
+ data.PrintVerticalLine() + " KETERANGAN " + data.PrintVerticalLine());
data.PROW(true, 1, data.PrintBottomLeftCorner() + data.PrintHorizontalLine(139) + data.PrintBottomRightCorner());
int nUrut = 0;
string sNoNota, sNamaBrg, sNokoli, sKet, sSatuan;
int nQty, nSumJmlkoli = 0;
foreach (DataRow dr in dt.Rows)
{
sNoNota = dr["NoSuratJalan"].ToString().Trim();
sNamaBrg = dr["NamaBarang"].ToString().Trim();
sNokoli = dr["NoKoli"].ToString().Trim();
sSatuan = dr["Satuan"].ToString().Trim();
sKet = dr["KetKoli"].ToString().Trim();
nQty = int.Parse(dr["QtySuratjalan"].ToString());
nSumJmlkoli = nSumJmlkoli + int.Parse(dr["JmlKoli"].ToString());
nUrut++;
if (rdbAuto.Checked)
{
data.PROW(true, 1, data.PrintVerticalLine() + nUrut.ToString().PadLeft(3)
+ data.PrintVerticalLine() + sNoNota
+ data.PrintVerticalLine() + sNamaBrg.PadRight(73, '.')
+ data.PrintVerticalLine() + nQty.ToString().PadLeft(7) + " " + sSatuan.PadRight(4)
+ data.PrintVerticalLine() + " " + sNokoli.PadRight(17)
+ data.PrintVerticalLine() + sKet.PadRight(20) + data.PrintVerticalLine());
}
if (rdbManual.Checked)
{
data.PROW(true, 1, data.PrintVerticalLine() + nUrut.ToString().PadLeft(3)
+ data.PrintVerticalLine() + sNoNota
+ data.PrintVerticalLine() + sNamaBrg.PadRight(73, '.')
+ data.PrintVerticalLine() + nQty.ToString().PadLeft(7) + " " + sSatuan.PadRight(4)
+ data.PrintVerticalLine() + "_______" + "_____" + "_______"
+ data.PrintVerticalLine() + "____________________" + data.PrintVerticalLine());
}
}
data.PROW(true, 1, data.PrintBottomLeftCorner() + data.PrintHorizontalLine(139) + data.PrintBottomRightCorner());
data.PROW(true, 1, "Jumlah : "
+ (rdbAuto.Checked ? nSumJmlkoli.ToString("#,###").PadLeft(10) : "_______")
+ " Koli");
if (txtKeterangan.Text.Trim() != "" && rdbAuto.Checked)
{
data.PROW(true, 1, "");
data.PROW(true, 1, "Keterangan :");
data.PROW(true, 1, txtKeterangan.Text);
}
data.PROW(true, 1, "");
data.PROW(true, 1, " Dibuat Oleh : Diterima Oleh : ");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, "");
data.PROW(true, 1, data.SPACE(8) + data.PrintHorizontalLine(15) + data.SPACE(71) + data.PrintHorizontalLine(15) + data.SPACE(6));
data.PROW(true, 1, " Checker ");
data.PROW(true, 1, "");
data.PROW(true, 1, " Barang-barang tersebut di atas telah diperiksa & diterima dalam keadaan baik & lengkap");
data.PROW(true, 1, " Komplain mengenai barang tersebut di atas diterima paling lambat 1 minggu setelah barang diterima.");
data.Eject();
data.SendToPrinter("packingList.txt");
}
private void printOpname(string namaStok, string satJual, string kodeBarang)
{
BuildString op = new BuildString();
double saldoAwal = 0;
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_getSaldoAwal"));
db.Commands[0].Parameters.Add(new Parameter("@TglOpname", SqlDbType.DateTime, DateTime.Now));
db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, kodeBarang));
db.Commands[0].Parameters.Add(new Parameter("@KodeGudang", SqlDbType.VarChar, GlobalVar.Gudang));
dt = db.Commands[0].ExecuteDataTable();
saldoAwal = Convert.ToDouble(Tools.isNull(dt.Rows[0][0], "0").ToString());
}
op.LeftMargin(3);
op.FontBold(true);
op.FontCPI(20);
op.PROW(true, 0, "FORM OPNAME HARIAN 0000");
op.PROW(true, 1, "");
op.FontCondensed(true);
op.FontBold(false);
op.PROW(true, 1, "Tgl. Opname " + String.Format("{0:dd-MMM-yyyy}", DateTime.Now) +
op.SPACE(5) + "(Saldo Awal : " + saldoAwal.ToString() + ")");
op.PROW(true, 1, "");
op.PROW(true, 1, "");
op.PROW(true, 1, op.PrintTopLeftCorner() + op.PrintHorizontalLine(128) + op.PrintTopRightCorner());
op.PROW(true, 1, op.PrintVerticalLine() + op.PadCenter(15, "Nama barang") + op.PrintVerticalLine() +
namaStok.PadRight(112) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.PrintHorizontalLine(128) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.SPACE(15) + op.PrintVerticalLine() + op.SPACE(112) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + "QTY".PadLeft(15) + op.PrintVerticalLine() + op.SPACE(20) +
satJual.PadRight(92) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.SPACE(15) + op.PrintVerticalLine() + op.SPACE(112) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintBottomLeftCorner() + op.PrintHorizontalLine(128) + op.PrintBottomRightCorner());
op.PROW(true, 1, "");
op.PROW(true, 1, op.PrintTopLeftCorner() + op.PrintHorizontalLine(128) + op.PrintTopRightCorner());
op.PROW(true, 1, op.PrintVerticalLine() + op.PadCenter(42, "Penghitung") + op.PrintVerticalLine() +
op.PadCenter(42, "Ka. gudang") + op.PrintVerticalLine() + op.PadCenter(42, "Accounting") + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.PadCenter(42, "Mengajukan") + op.PrintVerticalLine() +
op.PadCenter(42, "Menyetujui") + op.PrintVerticalLine() + op.PadCenter(42, "Mengetahui") + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.PrintHorizontalLine(128) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine() + op.SPACE(42) +
op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine() + op.SPACE(42) +
op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine() + op.SPACE(42) +
op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine() + op.SPACE(42) +
op.PrintVerticalLine() + op.SPACE(42) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + op.PrintHorizontalLine(128) + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintVerticalLine() + " (" + op.SPACE(36) + ") " + op.PrintVerticalLine() +
" (" + op.SPACE(36) + ") " + op.PrintVerticalLine() + " (" + op.SPACE(36) + ") " + op.PrintVerticalLine());
op.PROW(true, 1, op.PrintBottomLeftCorner() + op.PrintHorizontalLine(128) + op.PrintBottomRightCorner());
op.PROW(true, 1, String.Format("{0:dd-MMM-yyy-hh-mm-ss}", DateTime.Now) + ", " + SecurityManager.UserName);
op.Eject();
op.SendToPrinter("notaJual.txt");
}
