private void Cek(string path) { string strSql = "SELECT * FROM [SLIP$]"; DataTable rs = new DataTable(); try { rs = Db.xls(strSql, path); } catch {} if (Rpt.ValidateXls(rs, rule, gagal)) { Save(path); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["belong"] = "0"; using (var db = new SiewebEntities()) { var se = from it in db.teacher where it.lang == 0 orderby it.updatetime descending select it; Rpt.DataSource = se.ToList(); Rpt.DataBind(); } } }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); Rpt.SubJudul(x , "Tanggal PPJB : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai) ); Rpt.SubJudul(x , "Project : " + Project ); Rpt.HeaderReport(headReport, "", x); }
private void SubTotal(string txt, decimal t1, decimal t2, decimal t3, decimal t4, decimal t5, decimal t6, decimal t7) { TableRow r = new TableRow(); TableCell c; c = Rpt.Foot(); c.Text = txt; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t1) + " UNIT"; c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t2); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t3); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t4); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t5); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t6); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t7); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); rpt.Rows.Add(r); }
private void Fill() { string strSql = "SELECT * FROM ISC064_MARKETINGJUAL..MS_FOLLOWUP ORDER BY NoFU"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak ditemukan data follow up dengan keyword diatas."); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = "<a href=\"javascript:call('" + rs.Rows[i]["NoKontrak"] + "','" + rs.Rows[i]["NoFU"] + "')\">" + rs.Rows[i]["NoKontrak"].ToString() + "." + rs.Rows[i]["NoFU"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglFU"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NamaGrouping"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Db.SingleString("SELECT Nama FROM ISC064_MARKETINGJUAL..MS_CUSTOMER WHERE NOCUSTOMER IN(SELECT NOCUSTOMER FROM ISC064_MARKETINGJUAL..MS_FOLLOWUP WHERE NOKONTRAK = '" + rs.Rows[i]["NoKontrak"].ToString() + "')"); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Ket"].ToString(); c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); if (statusA.Checked) { Rpt.SubJudul(x, "Status : " + statusA.Text); } else if (statusB.Checked) { Rpt.SubJudul(x, "Status : " + statusB.Text); } else { Rpt.SubJudul(x, "Status : " + statusS.Text); } string tgl = ""; if (tglkontrak.Checked) { tgl = tglkontrak.Text; } DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); Rpt.SubJudul(x , tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) ); Rpt.SubJudul(x , "Jenis : " + Rpt.inSql(jenis).Replace("'", "") ); Rpt.SubJudul(x , "Lokasi : " + lokasi.SelectedItem.Text ); Rpt.SubJudul(x , "Sales : " + agent.SelectedItem.Text ); Rpt.Header(rpt, x); }
private void SubTotal(decimal GrandTotal) { TableRow r = new TableRow(); TableCell c; c = Rpt.Foot(); c.Text = "Grand Total"; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(GrandTotal); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); rpt.Rows.Add(r); }
protected void SubTotal(decimal t) { TableRow r = new TableRow(); TableCell c; c = Rpt.Foot(); c.Text = "<strong>TOTAL</strong>"; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = Rpt.Foot(); c.Text = "<strong>" + Cf.Num(t) + "</strong>"; c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); rpt.Rows.Add(r); }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); Rpt.SubJudul(x , "Project : " + project.SelectedValue ); Rpt.SubJudul(x , "Perusahaan : " + pers.SelectedItem.Text ); string legend = "Status: A = Aktif / B = Batal."; Rpt.HeaderReport(headReport, legend, x); }
protected void fillNext(byte Lvl) { TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = " "; r.Cells.Add(c); c = new TableCell(); c.Text = "<a href='ApprovalDetailEdit.aspx?lvl=" + Lvl + "&tipe=" + TipeApproval + "&project=" + Project + "'><p style='font-size:14pt;font-weight:bold;'>Edit / Delete</p></a>"; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); if (statusA.Checked) { Rpt.SubJudul(x, "Status : " + statusA.Text); } else if (statusB.Checked) { Rpt.SubJudul(x, "Status : " + statusB.Text); } else { Rpt.SubJudul(x, "Status : " + statusS.Text); } string tgl = ""; if (tglkontrak.Checked) { tgl = tglkontrak.Text; } DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); Rpt.SubJudul(x , tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) ); Rpt.SubJudul(x , "Project : " + project.SelectedValue ); Rpt.SubJudul(x , "Perusahaan : " + pers.SelectedItem.Text ); //Rpt.Header(rpt, x); string legend = "Status: A = Aktif / B = Batal."; Rpt.HeaderReport(headReport, legend, x); }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); if (StatusA != "") { Rpt.SubJudul(x, "Status : " + StatusA); } else if (StatusB != "") { Rpt.SubJudul(x, "Status : " + StatusB); } else if (StatusH != "") { Rpt.SubJudul(x, "Status : " + StatusH); } else { Rpt.SubJudul(x, "Status : " + StatusS); } Rpt.SubJudul(x , "Tipe : " + Jenis ); Rpt.SubJudul(x , "Lokasi : " + Lokasi ); Rpt.SubJudul(x , "Project : " + Project ); Rpt.SubJudul(x , "Perusahaan : " + Perusahaan ); string legend = "Status: A = Available / S = Sold / H = Hold." + "<br />" + "Luas dalam meter persegi.Harga price list adalah dalam rupiah."; //Rpt.Header(rpt, x); Rpt.HeaderReport(headReport, legend, x); }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); if (StatusA != "") { Rpt.SubJudul(x, "Status : " + StatusA); } else if (StatusB != "") { Rpt.SubJudul(x, "Status : " + StatusB); } else { Rpt.SubJudul(x, "Status : " + StatusS); } DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); Rpt.SubJudul(x , "Tanggal Kontrak" + " : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai) ); Rpt.SubJudul(x , "Jenis : " + Jenis//Rpt.inSql(jenis).Replace("'","") ); Rpt.SubJudul(x , "Lokasi : " + Lokasi ); Rpt.SubJudul(x , "Sales : " + Agent ); //Rpt.Header(rpt, x); string legend = "Status: A = Aktif / B = Batal.< br />" + "Luas dalam meter persegi.Gross adalah harga sebelum diskon."; Rpt.HeaderReport(headReport, legend, x); }
private void SetBarisPM(TextBox Kali, string Tipe, string Nama, TextBox nominal) { int count = Convert.ToInt32(Kali.Text); int index = rpt.Rows.Count - 1; for (int i = 0; i < count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; index++; c = new TableCell(); c.Text = index.ToString() + "."; r.Cells.Add(c); c = new TableCell(); c.Text = Tipe; r.Cells.Add(c); c = new TableCell(); int countkpr = Db.SingleInteger("select count(*) from REF_SKEMA_DETAIL where KPR = 1 AND Nomor = " + skema.SelectedValue); if (countkpr != 0) { c.Text = Nama; } else { c.Text = Nama + " " + (i + 1); } r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(DateTime.Today); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void SubTotal(decimal t1, decimal t2, decimal t3, decimal t4, decimal t5, decimal t6, decimal t7) { TableRow r = new TableRow(); TableCell c; c = Rpt.Foot(); c.Text = "<strong>TOTAL</strong>"; c.ColumnSpan = 14; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t1); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t3); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t4); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t2); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(Math.Round(t5)); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(Math.Round(t6)); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); rpt.Rows.Add(r); }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); Rpt.SubJudul(x , "Tanggal : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) ); //Rpt.Header(rpt, x); string legend = ""; Rpt.HeaderReport(headReport, legend, x); }
protected void xls_Click(object sender, System.EventArgs e) { if (valid()) { Report(); //rpt.Controls.Add(rptC); rp.Controls.Add(headJudul); rp.Controls.Add(lblA); rp.Controls.Add(rptA); rp.Controls.Add(lblB); rp.Controls.Add(rptB); rp.Controls.Add(lblC); rp.Controls.Add(rpt); rp.Controls.Add(lblD); rp.Controls.Add(rptD); Rpt.ToExcel(this, rp); } }
private void SubTotal(string txt, decimal t1) { TableRow r = new TableRow(); TableCell c; c = Rpt.Foot(); c.Text = txt; c.ColumnSpan = 12; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); //c = Rpt.Foot(); //c.Text = Cf.Num(t1); //c.HorizontalAlign = HorizontalAlign.Right; //r.Cells.Add(c); rpt.Rows.Add(r); }
private void DataBindToRepeater(int currentPage, List <Author> datascore) { PagedDataSource pds = new PagedDataSource(); pds.AllowPaging = true; pds.PageSize = 5; pds.DataSource = datascore; lbTotal.Text = pds.PageCount.ToString(); pds.CurrentPageIndex = currentPage - 1; Rpt.DataSource = pds; Rpt.DataBind(); }
private void FillTable() { decimal t = 0; DataTable rs = Db.Rs("SELECT * FROM MS_TUNGGAKAN_DETIL WHERE NoTunggakan = " + NoTunggakan); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglJT"]); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Telat"] + " Hari"; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NamaTagihan"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["Nilai"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); t = t + (decimal)rs.Rows[i]["Nilai"]; Rpt.Border(r); rpt.Rows.Add(r); if (i == rs.Rows.Count - 1) { SubTotal(t); } } }
protected void FillDetil() { DataTable rs2 = Db.Rs("SELECT * FROM MS_PELUNASAN_KPA WHERE NoRealKPA=" + nomor); for (int i = 0; i < rs2.Rows.Count; i++) { TableCell c; TableRow r = new TableRow(); DataTable tts = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "FINANCEAR..MS_TTS WHERE NoTTS=" + rs2.Rows[i]["NoTTS"]); c = new TableCell(); c.Text = tts.Rows[0]["NoTTS2"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = "<b>" + tts.Rows[0]["Status"].ToString() + "</b>"; if (tts.Rows[0]["Status"].ToString() == "VOID") { c.ForeColor = Color.Red; } r.Cells.Add(c); c = new TableCell(); c.Text = rs2.Rows[i]["NoKontrak"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = tts.Rows[0]["Customer"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = tts.Rows[0]["Unit"].ToString(); r.Cells.Add(c); c = new TableCell(); c.CssClass = "txt_num"; c.Text = Cf.Num(rs2.Rows[i]["NilaiPelunasan"]); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void CarregaGrid() { try { AudienciaNegocios oNegocios = new AudienciaNegocios(); oList = oNegocios.Listar(new AudienciaModel()); if (oList.Count > 0) { Rpt.DataSource = oList; Rpt.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EROOR", "$(document).MensagemModal(3,'Ocorreu um erro inesperado! Mensagem = " + new JavaScriptSerializer().Serialize(ex.Message.ToString()) + "');", true); } }
private void ListarAudiencia(int Id) { AudienciaModel oModel = new AudienciaModel(); List <AudienciaModel> oListModel = new List <AudienciaModel>(); AudienciaNegocios oNegocios = new AudienciaNegocios(); oModel.Id = Id; oListModel = oNegocios.Listar(oModel); if (oListModel.Count > 0) { Rpt.DataSource = oListModel; Rpt.DataBind(); } else { Rpt.DataSource = new List <AudienciaModel>(); Rpt.DataBind(); } }
private void Fill() { string strSql = "SELECT *" + " FROM MS_KOMISIR" + " WHERE NoKomisiR + NoKomisiP + Ket " + " LIKE '%" + Cf.Str(keyword.Text) + "%'" + " AND Project IN (" + Act.ProjectListSql + ")" + " ORDER BY NoKomisiR"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak ditemukan data realisasi komisi dengan keyword diatas."); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = "<a href=\"javascript:call('" + rs.Rows[i]["NoKomisiR"] + "')\">" + rs.Rows[i]["NoKomisiR"].ToString() + "</a>"; c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["Tgl"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Ket"].ToString(); c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); Rpt.SubJudul(x , "Tanggal: " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) ); Rpt.SubJudul(x , "Jenis PPN: DITANGGUNG " + JenisPPN.SelectedItem.Text ); Rpt.Header(rpt, x); }
private void SubTotal(decimal t1, decimal t2, decimal t3, decimal t4, decimal t5, decimal t6) { TableRow r = new TableRow(); TableCell c; c = Rpt.Foot(); c.Text = "TOTAL"; c.HorizontalAlign = HorizontalAlign.Left; c.VerticalAlign = VerticalAlign.Top; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t1); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t2); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t3); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t4); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t5); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = Rpt.Foot(); c.Text = Cf.Num(t6); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); rpt.Rows.Add(r); }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); Rpt.SubJudul(x , "Tanggal : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) ); Rpt.SubJudul(x , "Rekening Bank : " + ddlAcc.SelectedItem.Text ); Rpt.Header(rpt, x); }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); Rpt.Judul(x, comp, judul); Rpt.SubJudul(x , "Lokasi : " + lokasi.SelectedItem.Text ); string tgl = ""; if (tbTarget.Checked) { tgl = tbTarget.Text; } if (tbTgl.Checked) { tgl = tbTgl.Text; } DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); Rpt.SubJudul(x , tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) ); Rpt.SubJudul( x, "Status LPA : " + ddlStatus.SelectedItem.Text ); Rpt.SubJudul( x, "Project : " + project.SelectedValue ); Rpt.SubJudul( x, "Perusahaan : " + pers.SelectedItem.Text ); //Rpt.Header(rpt, x); Rpt.HeaderReport(headReport, "", x); }
private void ListaPerfilAcesso(int IdFunc) { PerfilAcessoFuncionarioModel oModel = new PerfilAcessoFuncionarioModel(); List <PerfilAcessoFuncionarioModel> oListModel = new List <PerfilAcessoFuncionarioModel>(); PerfilAcessoFuncionarioNegocios oNegocios = new PerfilAcessoFuncionarioNegocios(); oModel.Codigo_Funcionario = IdFunc; oListModel = oNegocios.Listar(oModel); if (oListModel.Count > 0) { Rpt.DataSource = oListModel; Rpt.DataBind(); } else { Rpt.DataSource = new List <PerfilAcessoFuncionarioModel>(); Rpt.DataBind(); } }
private void FillOld() { string strSql = "SELECT * FROM MS_TAGIHAN where NoKontrak = '" + NoKontrak + "'" //+ " AND Nokontrak = '" + NoKontrak + "' AND Tipe <> 'ADM'" + " ORDER BY NoUrut"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rptTagihanNew, rs, "No Reservation."); decimal TotalOld = 0; for (int i = 0; i < rs.Rows.Count; i++) { TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = rs.Rows[i]["NoUrut"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Tipe"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NamaTagihan"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(Convert.ToDateTime(rs.Rows[i]["TglJT"])); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(Convert.ToDecimal(rs.Rows[i]["NilaiTagihan"])); r.Cells.Add(c); TotalOld += Convert.ToDecimal(rs.Rows[i]["NilaiTagihan"]); Rpt.Border(r); rptTagihanOld.Rows.Add(r); } grandTotalold.Text = Cf.Num(TotalOld); }