protected void Button2_Click(object sender, EventArgs e) { try { if (f_date.Text != "" && t_date.Text != "") { //Path DataSet ds = new DataSet(); DataTable dt = new DataTable(); string fdate = f_date.Text; DateTime fd = DateTime.ParseExact(fdate, "dd/MM/yyyy", CultureInfo.InvariantCulture); String fmdate = fd.ToString("yyyy-MM-dd"); string tdate = t_date.Text; DateTime td = DateTime.ParseExact(tdate, "dd/MM/yyyy", CultureInfo.InvariantCulture); String tmdate = td.ToString("yyyy-MM-dd"); string skav_no = string.Empty; if (DD_kaw.SelectedValue != "") { DataTable ddokdicno_pro = new DataTable(); ddokdicno_pro = DBCon.Ora_Execute_table("select DISTINCT Area_Code,Area_Name from Ref_Kawasan where Area_Name='" + DD_kaw.SelectedValue + "'"); skav_no = ddokdicno_pro.Rows[0]["Area_Code"].ToString(); } if (rpt_type.SelectedValue == "01") { if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[1] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);// } string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, rdlc_name = string.Empty, DS_name = string.Empty; if (DD_kaw.SelectedValue != "") { ss1 = DD_kaw.SelectedItem.Text; } else { ss1 = "SEMUA"; } if (DD_wilayah.SelectedValue != "") { ss2 = DD_wilayah.SelectedItem.Text; } else { ss2 = "SEMUA"; } if (DD_cawangan.SelectedValue != "") { ss3 = DD_cawangan.SelectedItem.Text; } else { ss3 = "SEMUA"; } RptviwerLKSENARI.Reset(); RptviwerLKSENARI.LocalReport.Refresh(); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); if (countRow != 0) { RptviwerLKSENARI.LocalReport.DataSources.Clear(); RptviwerLKSENARI.LocalReport.ReportPath = "LK_tambahan_senrept.rdlc"; ReportDataSource rds = new ReportDataSource("LK_tambahan_senrept", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("s1", f_date.Text), new ReportParameter("s2", t_date.Text), new ReportParameter("s3", ss1), new ReportParameter("s4", ss2), new ReportParameter("s5", ss3), new ReportParameter("s6", ss4), new ReportParameter("s7", ss5), new ReportParameter("s8", rpt_type.SelectedItem.Text) }; RptviwerLKSENARI.LocalReport.SetParameters(rptParams); RptviwerLKSENARI.LocalReport.DataSources.Add(rds); //Refresh RptviwerLKSENARI.LocalReport.Refresh(); //List<ReportParameter> paramList = new List<ReportParameter>(); //paramList.Add(new ReportParameter("RowsPerPage", "30")); //RptviwerLKSENARI.LocalReport.SetParameters(paramList); } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } else { if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[1] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "") { dt = DBCon.Ora_Execute_table("select count(ISNULL(mem_new_icno,'')) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);// } string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, rdlc_name = string.Empty, DS_name = string.Empty; if (DD_kaw.SelectedValue != "") { ss1 = DD_kaw.SelectedItem.Text; } else { ss1 = "SEMUA"; } if (DD_wilayah.SelectedValue != "") { ss2 = DD_wilayah.SelectedItem.Text; } else { ss2 = "SEMUA"; } if (DD_cawangan.SelectedValue != "") { ss3 = DD_cawangan.SelectedItem.Text; } else { ss3 = "SEMUA"; } RptviwerLKSENARI.Reset(); RptviwerLKSENARI.LocalReport.Refresh(); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); if (countRow != 0) { ss1_stap1.Visible = true; RptviwerLKSENARI.LocalReport.DataSources.Clear(); RptviwerLKSENARI.LocalReport.ReportPath = "keanggotan/LK_tambahan_ringrept.rdlc"; ReportDataSource rds = new ReportDataSource("LK_tambahan_ringrept", dt); ss2 = ss2.Replace("s4", String.Empty); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("s1", f_date.Text), new ReportParameter("s2", t_date.Text), new ReportParameter("s3", ss1), new ReportParameter("s4", ss2), new ReportParameter("s5", ss3), new ReportParameter("s6", ss4), new ReportParameter("s7", ss5), new ReportParameter("s8", "") }; RptviwerLKSENARI.LocalReport.SetParameters(rptParams); RptviwerLKSENARI.LocalReport.DataSources.Add(rds); //Refresh RptviwerLKSENARI.LocalReport.Refresh(); System.Threading.Thread.Sleep(1); //List<ReportParameter> paramList = new List<ReportParameter>(); //paramList.Add(new ReportParameter("RowsPerPage", "30")); //RptviwerLKSENARI.LocalReport.SetParameters(paramList); } else { ss1_stap1.Visible = false; ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } } else { ss1_stap1.Visible = false; ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } catch (Exception ex) { throw ex; //Response.Redirect("LK_SENARI.aspx"); } }
protected void Button2_Click(object sender, EventArgs e) { try { if (f_date.Text != "" && t_date.Text != "") { //Path DataSet ds = new DataSet(); DataTable dt = new DataTable(); string fdate = f_date.Text; DateTime fd = DateTime.ParseExact(fdate, "dd/MM/yyyy", CultureInfo.InvariantCulture); String fmdate = fd.ToString("yyyy-MM-dd"); string tdate = t_date.Text; DateTime td = DateTime.ParseExact(tdate, "dd/MM/yyyy", CultureInfo.InvariantCulture); String tmdate = td.ToString("yyyy-MM-dd"); disp_sts.Text = DD_STS_ANGGO.SelectedItem.Text; string skav_no = string.Empty; if (DD_kaw.SelectedValue != "") { DataTable ddokdicno_pro = new DataTable(); ddokdicno_pro = DBCon.Ora_Execute_table("select DISTINCT Area_Code,Area_Name from Ref_Kawasan where Area_Name='" + DD_kaw.SelectedValue + "'"); skav_no = ddokdicno_pro.Rows[0]["Area_Code"].ToString(); } //if (DD_STS_ANGGO.SelectedValue == "TL") //{ // if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") // { // dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); // ds.Tables.Add(dt); // } // else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") // { // dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); // ds.Tables.Add(dt); // } // else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") // { // dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); // ds.Tables.Add(dt); // } // else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "") // { // dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); // ds.Tables.Add(dt); // } // else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "") // { // dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); // ds.Tables.Add(dt); // } // else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") // { // dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); // ds.Tables.Add(dt); // } // else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") // { // dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); // ds.Tables.Add(dt); // } // else // { // ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Rekod Tidak Dijumpai.');", true);// // } //} //else if (DD_STS_ANGGO.SelectedValue == "L") //{ if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") { //dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt "); dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "") { dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name"); ds.Tables.Add(dt); if (dt.Rows.Count % 20 != 0) { int addCount = 20 - dt.Rows.Count % 20; for (int i = 0; i < addCount; i++) { DataRow dr = dt.NewRow(); dr[0] = ""; dt.Rows.Add(dr); } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);// } //} string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, ss6 = string.Empty, ss7 = string.Empty; if (DD_kaw.SelectedValue != "") { ss1 = DD_kaw.SelectedItem.Text; } else { ss1 = "SEMUA"; } if (DD_wilayah.SelectedValue != "") { ss2 = DD_wilayah.SelectedItem.Text; } else { ss2 = "SEMUA"; } if (DD_cawangan.SelectedValue != "") { ss3 = DD_cawangan.SelectedItem.Text; } else { ss3 = "SEMUA"; } if (txt_pusat.Text != "") { ss4 = txt_pusat.Text; } else { ss4 = "SEMUA"; } RptviwerLKSENARI.Reset(); RptviwerLKSENARI.LocalReport.Refresh(); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); string disp = string.Empty; if (countRow != 0) { ss1_stap1.Visible = true; RptviwerLKSENARI.LocalReport.DataSources.Clear(); //if (DD_STS_ANGGO.SelectedValue == "TL") //{ // RptviwerLKSENARI.LocalReport.ReportPath = "TLAB_SENARI.rdlc"; // ReportDataSource rds = new ReportDataSource("TLAB_SENARI", dt); // RptviwerLKSENARI.LocalReport.DataSources.Add(rds); // disp = "TIDAK_LULUS_ANGGOTA_BAHARU_SENERAI_" + DateTime.Now.ToString("ddMMyyyy"); //} //else if (DD_STS_ANGGO.SelectedValue=="L") //{ RptviwerLKSENARI.LocalReport.ReportPath = "keanggotan/TLAB_RINGASAN_RK.rdlc"; ReportDataSource rds = new ReportDataSource("TLAB_RINGASAN_RK", dt); RptviwerLKSENARI.LocalReport.DataSources.Add(rds); disp = "TIDAK_LULUS_ANGGOTA_BAHARU_SENERAI_" + DateTime.Now.ToString("ddMMyyyy"); //} ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("p1", f_date.Text), new ReportParameter("p2", t_date.Text), new ReportParameter("p3", ss1), new ReportParameter("p4", ss2), new ReportParameter("p5", ss3), new ReportParameter("p6", ss4), new ReportParameter("p7", disp_sts.Text) }; RptviwerLKSENARI.LocalReport.SetParameters(rptParams); RptviwerLKSENARI.LocalReport.DisplayName = disp; //Refresh RptviwerLKSENARI.LocalReport.Refresh(); System.Threading.Thread.Sleep(1); //List<ReportParameter> paramList = new List<ReportParameter>(); //paramList.Add(new ReportParameter("RowsPerPage", "30")); //RptviwerLKSENARI.LocalReport.SetParameters(paramList); } else { ss1_stap1.Visible = false; ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } else { ss1_stap1.Visible = false; ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } catch (Exception ex) { throw ex; //Response.Redirect("LK_SENARI.aspx"); } }