APKT perubahan data export script

vim macros

[DirectMethod]
public void BuildReport(string gridID)
{
    try
    {
        if (((DataSet)Session["DaftarLaporLebih1Kali"]).Tables.Contains(gridID))
        {
            string HTMLoutput;
            String xml = ((DataSet)Session["DaftarLaporLebih1Kali"]).GetXml();
            xml = "<?xml version='1.0' encoding='utf-8'?>\n" + xml;
            using (MemoryStream ms = new MemoryStream(Encoding.ASCII.GetBytes(xml)))
            {
                using (StringWriter writer = new StringWriter())
                {
                    System.Xml.XmlReader xreader = System.Xml.XmlReader.Create(ms);
                    XslCompiledTransform xt = new XslCompiledTransform();
                    xt.Load(Server.MapPath("ReportTemplate.xslt"));
                    xt.Transform(xreader, null, writer);
                    HTMLoutput = writer.ToString();
                }
            }
            
            #region "Build window"
            var win = new Window
            {
                ID = "winRpt_RPTSLA",
                Title = "Laporan Respon Time",
                Width = Unit.Pixel(800),
                Height = Unit.Pixel(400),
                BodyStyle = "background-color:#fff;",
                Html = HTMLoutput,
                Modal = false,
                Collapsible = true,
                Maximizable = true,
                AutoScroll = true
            };
            win.AutoLoad.Mode = LoadMode.IFrame;
            win.Render(this.Form);
            #endregion
        }
        else
        {
            throw new Exception("Data Pada Session Tidak ditemukan!");
        }
    }
    catch (Exception ex)
    {
        throw ex;
    }
}
protected void ToExcel(object sender, EventArgs e)
{
   ExportDataTo("ms-excel", ".xls");
}

protected void ToWord(object sender, EventArgs e)
{
   ExportDataTo("msword", ".doc");
}

private void ExportDataTo(string format, string extension)
{
    try
    {
        String xml = ((DataSet)Session["DaftarLaporLebih1Kali"]).GetXml();
        xml = "<?xml version='1.0' encoding='utf-8'?>\n" + xml;
        using (MemoryStream ms = new MemoryStream(Encoding.ASCII.GetBytes(xml)))
        {
            System.Xml.XmlReader xreader = System.Xml.XmlReader.Create(ms);
            this.Response.Clear();
            this.Response.ContentType = "application/vnd." + format;
            this.Response.AddHeader("Content-Disposition", "attachment; filename=Laporan_Daftar_gangguan_melapor_lebih_dari_1_kali" + extension);
            XslCompiledTransform xtExcel = new XslCompiledTransform();
            xtExcel.Load(Server.MapPath("ReportTemplate.xslt"));
            xtExcel.Transform(xreader, null, this.Response.OutputStream);
            this.Response.End();
        }
    }
    catch (Exception ex)
    {
        throw ex;
    }
}

private DataTable GetTableParameter()
{
    try
    {
        Page.Culture = "id-ID";
        // create table parameter
        DataTable table = new DataTable("Parameter");
        table.Columns.Add("UNIT", typeof(string));
        table.Columns.Add("AREA", typeof(string));
        table.Columns.Add("RAYON", typeof(string));
        table.Columns.Add("PERIODE", typeof(string));
        table.Columns.Add("TANGGALCETAK", typeof(string));
        // add data into parameter row
        table.Rows.Add(this.ComboDistribusi.SelectedItem.Text,
                        this.ComboArea.SelectedItem.Text,
                        this.ComboPosko.SelectedItem.Text,
                        String.Format("PERIODE TANGGAL : {0} SD TGL {1}", this.TanggalAwal.SelectedDate.ToString("d-MMMM-yyyy"), this.TanggalAkhir.SelectedDate.ToString("d-MMMM-yyyy")),
                        DateTime.Today.ToString("dddd, d-MMMM-yyyy"));
        return table;
    }
    catch (Exception ex)
    {
        throw ex;
    }
}
x


s
<ext:SplitButton ID="Button3" runat="server" Disabled="true" Text="Lihat Laporan" Icon="Report" Before="return #{FormPanel1}.getForm().isValid();">
<Menu>
<ext:Menu ID="Menu1" runat="server">
<Items>
<ext:MenuItem ID="MenuItem1" runat="server" Text="Excel" AutoPostBack="true" OnClick="ToExcel" Icon="PageExcel"/>
<ext:MenuItem ID="MenuItem2" runat="server" Text="Word" AutoPostBack="true" OnClick="ToWord" Icon="PageWord" />
</Items>
</ext:Menu>
</Menu>
<DirectEvents>
<Click OnEvent="Button3_Click">
<EventMask ShowMask="true" />
</Click>
</DirectEvents>
</ext:SplitButton>


j
sumberLapor.setValue(rec.data.SUMBER_LAPOR);

r
<ext:RecordField Name="SUMBER_LAPOR" />

c
<ext:Column Header="Sumber Lapor" DataIndex="SUMBER_LAPOR" />

f
<Filters>
  <ext:StringFilter DataIndex="NO_LAPORAN" />
  <ext:StringFilter DataIndex="TGL_LAPOR" />
  <ext:StringFilter DataIndex="TGL_DATANG" />
  <ext:StringFilter DataIndex="IDPEL_IDMETER" />
  <ext:StringFilter DataIndex="NAMA_PELAPOR" />
  <ext:StringFilter DataIndex="ALAMAT_PELAPOR" />
  <ext:StringFilter DataIndex="NO_TELP_PELAPOR" />
  <ext:StringFilter DataIndex="KETERANGAN_PELAPOR" />
  <ext:StringFilter DataIndex="APKT_STATUS" />
  <ext:StringFilter DataIndex="SUMBER_LAPOR" />
  <ext:StringFilter DataIndex="NAMARAYON" />
</Filters>

d
<ext:TextField ID="sumberLapor" runat="server" FieldLabel="SUMBER LAPOR" Width="350" ReadOnly="true" />