protected void ExportToEXCEL(object sender, EventArgs e) { DataTable dt = new DataTable(); bind_details(); dt = DBCon.Ora_Execute_table(sqry); if (dt.Rows.Count != 0) { RptviwerStudent.Reset(); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); double deb = 0, krd = 0; if (countRow != 0) { StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "Imbangan_Duga_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("No Akaun,Keterangan,Debit (RM),Kredit (RM)" + Environment.NewLine); for (int k = 0; k <= (dt.Rows.Count - 1); k++) { builder.Append(dt.Rows[k]["kod_akaun"].ToString() + " , " + dt.Rows[k]["nama_akaun"].ToString().Replace(",", "") + ", " + dt.Rows[k]["Amt1"].ToString() + "," + dt.Rows[k]["Amt2"].ToString() + Environment.NewLine); deb += double.Parse(dt.Rows[k]["kw_Debit_amt"].ToString()); krd += double.Parse(dt.Rows[k]["kw_kredit_amt"].ToString()); if (k == (dt.Rows.Count - 1)) { string val1 = "JUMLAH"; string val2 = string.Empty; builder.Append(val1 + ", " + val2 + ", " + deb.ToString() + "," + krd.ToString() + Environment.NewLine); } } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alert('Rekod tidak dijumpai. Sila pastikan semua maklumat dimasukkan dengan betul');", true); // txtError.Text = "Rekod tidak dijumpai. Sila pastikan semua maklumat dimasukkan dengan betul."; } } else { BindData(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } }
//void grid() //{ // //SqlCommand cmd2 = new SqlCommand("select ht.trn_dur,upper(sp.stf_name) as stf_name from hr_post_his as ph left join hr_training as ht on ht.trn_staff_no=ph.pos_staff_no left join hr_staff_profile as sp on sp.stf_staff_no=ht.trn_staff_no where ht.trn_start_dt>=DATEADD(day, DATEDIFF(day, 0, '2016-01-12'), 0) and ht.trn_start_dt<=DATEADD(day, DATEDIFF(day, 0, '2016-01-16'), 0) and ph.pos_end_dt='9999-12-31' and ht.trn_cat_cd='' and ht.trn_type_cd='' and ht.trn_staff_no='0202020202' and ph.pos_org_id='s637456346' and ph.pos_dept_cd='01' and ph.pos_unit_cd='18'", con); // SqlCommand cmd2 = new SqlCommand("select FORMAT(ha.atd_date,'dd/MM/yyyy', 'en-us') atd_date,ha.atd_clock_in,ha.atd_clock_out,sp.stf_working_hour from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Kaki_no.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0)", con); // SqlDataAdapter da2 = new SqlDataAdapter(cmd2); // DataSet ds2 = new DataSet(); // da2.Fill(ds2); // if (ds2.Tables[0].Rows.Count == 0) // { // ds2.Tables[0].Rows.Add(ds2.Tables[0].NewRow()); // GridView1.DataSource = ds2; // GridView1.DataBind(); // int columncount = GridView1.Rows[0].Cells.Count; // GridView1.Rows[0].Cells.Clear(); // GridView1.Rows[0].Cells.Add(new TableCell()); // GridView1.Rows[0].Cells[0].ColumnSpan = columncount; // GridView1.Rows[0].Cells[0].Text = "<strong>Maklumat Carian Tidak Dijumpai</strong>"; // } // else // { // GridView1.DataSource = ds2; // GridView1.DataBind(); // } //} //protected void gvSelected_PageIndexChanging(object sender, GridViewPageEventArgs e) //{ // GridView1.PageIndex = e.NewPageIndex; // grid(); //} void clk_print() { { try { if (tm_date.Text != "" && ta_date.Text != "" && Kaki_no.Text != "") { DataTable select_kaki_jum = new DataTable(); select_kaki_jum = DBCon.Ora_Execute_table("select a.stf_staff_no,a.Hol,ISNULL(b.Late,'') as Late from (select sp.stf_staff_no,count(ha.atd_hol_late_ind) as Hol from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0) and ha.atd_hol_late_ind = 'H' group by sp.stf_staff_no) as a full outer join (select sp.stf_staff_no,count(ha.atd_hol_late_ind) as Late from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0) and ha.atd_hol_late_ind = 'L' group by sp.stf_staff_no) as b on b.stf_staff_no = a.stf_staff_no"); if (select_kaki_jum.Rows.Count != 0) { jm_hl.Text = select_kaki_jum.Rows[0]["Late"].ToString(); jm_hc.Text = select_kaki_jum.Rows[0]["Hol"].ToString(); DataTable sel_poshis = new DataTable(); sel_poshis = DBCon.Ora_Execute_table("select pos_spv_name1,sp.stf_name,rj.hr_jaw_desc from hr_post_his as ph left join hr_staff_profile sp on sp.stf_staff_no=ph.pos_spv_name1 left join Ref_hr_Jawatan rj on rj.hr_jaw_Code=sp.stf_curr_post_cd where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "'"); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = DBCon.Ora_Execute_table("select FORMAT(ha.atd_date,'dd/MM/yyyy', 'en-us') atd_date,ha.atd_clock_in,ha.atd_clock_out,sp.stf_working_hour,ha.atd_remark as stf_desc,stf_staff_no,UPPER(stf_name) as stf_name,UPPER(hr_gred_desc) as hr_gred_desc,UPPER(hr_jaba_desc) as hr_jaba_desc,UPPER(hr_jaw_desc) as hr_jaw_desc from hr_post_his as ph left join hr_staff_profile as sp on sp.stf_staff_no=ph.pos_staff_no left join Ref_hr_jabatan as JB on JB.hr_jaba_Code=SP.stf_curr_dept_cd left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=SP.stf_curr_post_cd left join Ref_hr_gred as GR on GR.hr_gred_Code=SP.stf_curr_grade_cd left join hr_attendance as ha on ha.atd_staff_no=ph.pos_staff_no where pos_end_dt='9999-12-31' and pos_staff_no='" + Applcn_no1.Text + "' and ha.atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and ha.atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), 0)"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/hr_lrk.rdlc"; ReportDataSource rds = new ReportDataSource("hr_lrk", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("sup_name", sel_poshis.Rows[0]["stf_name"].ToString()), new ReportParameter("jaw_name", sel_poshis.Rows[0]["hr_jaw_desc"].ToString()), new ReportParameter("oname", txt_org.Text) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.DisplayName = "Laporan_Kehadiran_" + Applcn_no1.Text + "-" + DateTime.Now.ToString("ddMMyyyy"); //Refresh RptviwerStudent.LocalReport.Refresh(); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } else { // grid(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } else { // grid(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } catch (Exception ex) { throw ex; } } }
//protected void txt_changed_markah(object sender, EventArgs e) //{ // GridViewRow row = ((GridViewRow)((System.Web.UI.WebControls.TextBox)sender).NamingContainer); // System.Web.UI.WebControls.TextBox markah = (System.Web.UI.WebControls.TextBox)row.FindControl("lbl_markah"); // System.Web.UI.WebControls.TextBox bah_cd = (System.Web.UI.WebControls.TextBox)row.FindControl("Label2"); // System.Web.UI.WebControls.TextBox sub_cd = (System.Web.UI.WebControls.TextBox)row.FindControl("Label5"); // System.Web.UI.WebControls.TextBox sec_type = (System.Web.UI.WebControls.TextBox)row.FindControl("Label4"); // DataTable chk_apprisal = new DataTable(); // chk_apprisal = DBCon.Ora_Execute_table("select * from hr_staff_appraisal where sap_staff_no='" + Kaki_no.Text + "' and sap_section_cd ='" + bah_cd.Text + "' and sap_post_cat_cd='" + sub_cd.Text + "' and cse_sec_type='"+ sec_type.Text + "' and sap_year='"+ txt_tahun.Text +"'"); // if (chk_apprisal.Rows.Count != 0) // { // string Inssql1 = "Update hr_staff_appraisal set sap_ppp_score='" + markah.Text + "' where sap_staff_no='" + Kaki_no.Text + "' and sap_section_cd ='" + bah_cd.Text + "' and sap_post_cat_cd='" + sub_cd.Text + "' and cse_sec_type='" + sec_type.Text + "' and sap_year='" + txt_tahun.Text + "'"; // Status = DBCon.Ora_Execute_CommamdText(Inssql1); // } // grid_list(); //} protected void clk_cetak(object sender, EventArgs e) { try { if (Kaki_no.Text != "") { string filename = string.Empty; DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = DBCon.Ora_Execute_table("SELECT FORMAT(trn_start_dt,'dd/MM/yyyy') dari,trn_venue,trn_training_name,trn_dur,trn_organiser,trn_fee_amt,trn_catatan FROM hr_training WHERE year(trn_start_dt) ='" + txt_tahun.Text + "' AND trn_staff_no='" + Kaki_no.Text + "'"); ds.Tables.Add(dt); DataTable dt1 = new DataTable(); dt1 = DBCon.Ora_Execute_table("select dis_staff_no,s2.hr_discipline_desc,FORMAT(dis_eff_dt,'dd/MM/yyyy') eff_dt,case when FORMAT(dis_exp_dt,'dd/MM/yyyy') ='01/01/1900' then '' else FORMAT(dis_exp_dt,'dd/MM/yyyy') end as exp_dt,s1.dis_catatan from hr_discipline s1 left join Ref_hr_discipline s2 on s2.hr_discipline_Code=dis_discipline_type_cd where dis_staff_no='" + Kaki_no.Text + "' and year(dis_eff_dt) = '" + txt_tahun.Text + "'"); ds.Tables.Add(dt1); DataTable dt2 = new DataTable(); dt2 = DBCon.Ora_Execute_table("select * from (SELECT sap_section_cd,sap_post_cat_cd,sap_subject_cd,sap_staff_remark,sap_weightage,b.cse_section_desc,A.cse_sec_type,case when ISNULL(sap_ppp_score,'0')='0' then '0' else sap_ppp_score end as sap_ppp_score,case when ISNULL(sap_ppk_score,'0')='0' then '0' else sap_ppk_score end as sap_ppk_score FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A. sap_section_cd=B.cse_section_cd WHERE sap_staff_no='" + Kaki_no.Text + "' AND sap_year='" + txt_tahun.Text + "' AND cap_status='A' ) as a " + " outer apply(SELECT sap_section_cd, sum(sap_weightage) cnt,sum(ISNULL(sap_ppp_score,'0')) cnt1,sum(ISNULL(sap_ppk_score,'0')) cnt2 FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A.sap_section_cd = B.cse_section_cd WHERE sap_staff_no = '" + Kaki_no.Text + "' AND sap_year = '" + txt_tahun.Text + "' AND cap_status = 'A' group by sap_section_cd) as b where b.sap_section_cd = a.sap_section_cd ORDER BY a.sap_section_cd, a.sap_post_cat_cd"); ds.Tables.Add(dt2); DataTable dt3 = new DataTable(); dt3 = DBCon.Ora_Execute_table("select a.*,cast(((((c3 + c4) /2) / c2) * ((c1 / tot_marks) * 100)) as int) purta from( " + " SELECT sap_section_cd, b.cse_section_desc, sum(cast(cse_marks as int)) c1, sum(sap_weightage) c2, sum(case when ISNULL(sap_ppp_score, '0') = '0' then '0' else sap_ppp_score end) as c3 " + " , sum(case when ISNULL(sap_ppk_score, '0') = '0' then '0' else sap_ppk_score end) as c4, c.tot_marks FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A.sap_section_cd = B.cse_section_cd " + " outer apply(SELECT cast(sum(cast(cse_marks as int)) as float) tot_marks FROM hr_staff_appraisal A INNER JOIN hr_cmn_appr_section B ON A.sap_section_cd = B.cse_section_cd WHERE sap_year = '" + txt_tahun.Text + "' AND cap_status = 'A') as c WHERE sap_staff_no = '" + Kaki_no.Text + "' AND cap_status = 'A' group by sap_section_cd, b.cse_section_desc, c.tot_marks " + " ) as a"); ds.Tables.Add(dt3); RptviwerStudent.Reset(); RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/lap_pen_pertasi.rdlc"; RptviwerStudent.LocalReport.EnableExternalImages = true; string imagePath = string.Empty; //if (dt.Rows[0]["v25"].ToString() != "") //{ // imagePath = new Uri(Server.MapPath("~/FILES/user/" + dt.Rows[0]["v25"].ToString() + "")).AbsoluteUri; //} //else //{ // imagePath = new Uri(Server.MapPath("~/FILES/user/no_image.jpg")).AbsoluteUri; //} ReportDataSource rds = new ReportDataSource("lpp_DS1", dt); ReportDataSource rds1 = new ReportDataSource("lpp_DS2", dt1); ReportDataSource rds2 = new ReportDataSource("lpp_DS3", dt2); ReportDataSource rds3 = new ReportDataSource("lpp_DS4", dt3); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("pv1", Kaki_no.Text), new ReportParameter("pv2", txt_org.Text), new ReportParameter("pv3", s_nama.Text), new ReportParameter("pv4", s_gred.Text), new ReportParameter("pv5", s_jab.Text), new ReportParameter("pv6", s_kj.Text), new ReportParameter("pv7", s_jaw.Text), new ReportParameter("pv8", s_unit.Text), new ReportParameter("pv9", txt_tahun.Text), new ReportParameter("pv10", dt.Rows.Count.ToString()), new ReportParameter("pv11", dt1.Rows.Count.ToString()) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.DataSources.Add(rds1); RptviwerStudent.LocalReport.DataSources.Add(rds2); RptviwerStudent.LocalReport.DataSources.Add(rds3); RptviwerStudent.LocalReport.Refresh(); filename = string.Format("{0}.{1}", "PENILAIAN_PRESTASI_" + Kaki_no.Text + "_" + txt_tahun.Text + "", "pdf"); //} Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila masukan Maklumat Carian',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } catch { } }
protected void ctk_values(object sender, EventArgs e) { string rcount = string.Empty; int count1 = 0; get_det(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = DBCon.Ora_Execute_table("select ph.Id,stf_staff_no,stf_name,FORMAT(lap_application_dt,'dd/MM/yyyy') lap_application_dt,lap_leave_type_cd,hjc.hr_jenis_desc,lap_leave_day,FORMAT(lap_leave_start_dt,'dd/MM/yyyy') as lap_leave_start_dt,FORMAT(lap_leave_end_dt, 'dd/MM/yyyy') as lap_leave_end_dt, lap_ref_no,case when lap_approve_sts_cd = '00' then 'MOHON' when lap_approve_sts_cd = '01' then 'SAH' when lap_approve_sts_cd = '02' then 'TIDAK SAH' when lap_approve_sts_cd = '03' then '' when lap_approve_sts_cd = '04' then 'BATAL' else '' end as app_stscd,case when lap_endorse_sts_cd = '01' then 'SAH' when lap_endorse_sts_cd = '02' then 'TIDAK SAH' else '' end as psts,lap_late_apply from hr_leave_application ph left join hr_staff_profile sp on sp.stf_staff_no = ph.lap_staff_no Left join Ref_hr_jenis_cuti hjc on hjc.hr_jenis_Code = ph.lap_leave_type_cd where stf_service_end_dt>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' and stf_service_end_dt <= '9999-12-31' and ph.lap_cancel_ind='N' " + sqry + " order by lap_ref_no desc"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); string sts_v1 = string.Empty, sts_v2 = string.Empty; if (DropDownList1.SelectedValue == "") { sts_v1 = "-"; } else { sts_v1 = DropDownList1.SelectedItem.Text; } RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/cuti_list.rdlc"; ReportDataSource rds = new ReportDataSource("hr_cuti_info", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("s1", txt_tkcuti.Text), new ReportParameter("s2", txt_hing.Text), new ReportParameter("s3", sts_v1) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; if (sel_frmt.SelectedValue == "02") { StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "Semakan_Cuti_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("NAMA KAKITANGAN,NO KAKITANGAN, NO RUJUKAN,TARIKH MOHON, JENIS CUTI,HARI CUTI,TARIKH MULA, TARIKH SEHINGGA,LEWAT MOHON (HARI),STATUS KELULUSAN,STATUS PENGESAHAN" + Environment.NewLine); for (int k = 0; k <= (dt.Rows.Count - 1); k++) { builder.Append(dt.Rows[k]["stf_name"].ToString() + " , " + dt.Rows[k]["stf_staff_no"].ToString() + "," + dt.Rows[k]["lap_ref_no"].ToString() + "," + dt.Rows[k]["lap_application_dt"].ToString() + "," + dt.Rows[k]["hr_jenis_desc"].ToString().ToUpper() + "," + dt.Rows[k]["lap_leave_day"].ToString() + "," + dt.Rows[k]["lap_leave_start_dt"].ToString() + "," + dt.Rows[k]["lap_leave_end_dt"].ToString() + "," + dt.Rows[k]["lap_late_apply"].ToString() + "," + dt.Rows[k]["app_stscd"].ToString() + "," + dt.Rows[k]["psts"].ToString() + Environment.NewLine); } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } else if (sel_frmt.SelectedValue == "01") { filename = string.Format("{0}.{1}", "Semakan_Cuti_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } BindData_Grid(); }
protected void ctk_values(object sender, EventArgs e) { if (txt_dar.Text != "" && txt_seh.Text != "") { DateTime pd = DateTime.ParseExact(txt_dar.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); dt1 = pd.ToString("yyyy-MM-dd"); DateTime pd1 = DateTime.ParseExact(txt_seh.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); dt2 = pd1.ToString("yyyy-MM-dd"); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = dbcon.Ora_Execute_table("select ho.org_name as org,UPPER(cs.cas_asset_desc) as naset,b.cnt as qty,dis_asset_age as uaset,dis_purchase_amt as hps,(dis_purchase_amt * b.cnt) as hpj,dis_curr_amt as nss,(dis_curr_amt * b.cnt) as nsj,kk.kaedah_desc as kp ,UPPER(ast_justifikasi_desc) as ast_justifikasi_desc from (select * from ast_dispose where dis_dispose_reg_dt>=DATEADD(day, DATEDIFF(day, 0, '" + dt1 + "'), 0) and dis_dispose_reg_dt<=DATEADD(day, DATEDIFF(day, 0, '" + dt2 + "'), +0)) as a left join ast_cmn_asset as cs on cs.cas_asset_cd=a.dis_asset_cd and cs.cas_asset_cat_cd=a.dis_asset_cat_cd and cs.cas_asset_sub_cat_cd=a.dis_asset_sub_cat_cd and cs.cas_asset_type_cd=a.dis_asset_type_cd left join Ref_ast_kaedah_palupusan as kk on kk.kaedah_id=a.dis_dispose_type_cd left join hr_organization as ho on ho.org_gen_id=a.dis_org_id left join ast_staff_asset as st on st.sas_asset_id=a.dis_asset_id and ISNULL(st.sas_justify_cd,'') != '' left join Ref_ast_justifikasi as J on J.ast_justifikasi_code=st.sas_justify_cd full outer join (select count(dis_asset_type_cd) as cnt,dis_asset_type_cd from ast_dispose where dis_dispose_reg_dt>=DATEADD(day, DATEDIFF(day, 0, '" + dt1 + "'), 0) and dis_dispose_reg_dt<=DATEADD(day, DATEDIFF(day, 0, '" + dt2 + "'), +0) group by dis_asset_type_cd) as b on b.dis_asset_type_cd=a.dis_asset_type_cd"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "Aset/ast_slupus.rdlc"; ReportDataSource rds = new ReportDataSource("astslupus", dt); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; if (sel_frmt.SelectedValue == "01") { filename = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (sel_frmt.SelectedValue == "02") { StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("Organisation ,Nama Aset,Kuantiti, Usia Aset, Seunit (RM), Jumlah (RM), Seunit (RM), Jumlah (RM), Kaedah Pelupusan, Justifikasi Pelupusan" + Environment.NewLine); foreach (GridViewRow row in gvSelected.Rows) { string oname = ((Label)row.FindControl("Label3")).Text.ToString(); string naset = ((Label)row.FindControl("Label2")).Text.ToString(); string qty = ((Label)row.FindControl("Label6")).Text.ToString(); string uaset = ((Label)row.FindControl("Label7")).Text.ToString(); string hss = ((Label)row.FindControl("Label8")).Text.ToString(); string hsj = ((Label)row.FindControl("Label9")).Text.ToString(); string nss = ((Label)row.FindControl("Label10")).Text.ToString(); string nsj = ((Label)row.FindControl("Label11")).Text.ToString(); string jp = ((Label)row.FindControl("Label12")).Text.ToString(); string kp = ((Label)row.FindControl("lbl_kp")).Text.ToString(); builder.Append(oname + "," + naset + "," + qty + "," + uaset + "," + hss + "," + hsj + "," + nss.Replace(",", "") + "," + nsj.Replace(",", "") + "," + kp + "," + jp + Environment.NewLine); } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } else if (sel_frmt.SelectedValue == "03") { byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings); filename = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc"); Response.Buffer = true; Response.Clear(); Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); Response.ContentType = mimeType; Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } else { BindGrid(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } }
protected void ctk_values(object sender, EventArgs e) { if (txt_dar.Text != "" && txt_seh.Text != "" || DropDownList3.SelectedValue != "") { select_qry(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = dbcon.Ora_Execute_table("" + sqry + ""); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty; if (DropDownList3.SelectedValue != "") { ss1 = DropDownList3.SelectedItem.Text; } if (dd_pen.SelectedValue != "") { ss2 = dd_pen.SelectedItem.Text; } if (dd_ajk1.SelectedValue != "") { ss3 = dd_ajk1.SelectedItem.Text; } if (dd_ajk2.SelectedValue != "") { ss4 = dd_ajk2.SelectedItem.Text; } RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "Aset/ast_klupus.rdlc"; ReportDataSource rds = new ReportDataSource("astskupus", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("h1", txt_dar.Text), new ReportParameter("h2", txt_seh.Text), new ReportParameter("h3", ss1), new ReportParameter("h4", TextBox2.Text), new ReportParameter("h5", ss2), new ReportParameter("h6", ss3), new ReportParameter("h7", ss4), }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; if (sel_frmt.SelectedValue == "01") { filename = string.Format("{0}.{1}", "Kelulusan_Rekod_Pelupusan_Aset_" + DateTime.Now.ToString("ddMMyyyy") + ".", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (sel_frmt.SelectedValue == "02") { StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("Organisation ,Nama Aset,Kuantiti, Usia Aset, Seunit (RM), Jumlah (RM), Seunit (RM), Jumlah (RM), Kaedah Pelupusan, NILAI REZAB (RM)" + Environment.NewLine); foreach (GridViewRow row in gvSelected.Rows) { string oname = ((Label)row.FindControl("Label3")).Text.ToString(); string naset = ((Label)row.FindControl("Label2")).Text.ToString(); string qty = ((Label)row.FindControl("Label6")).Text.ToString(); string uaset = ((Label)row.FindControl("Label7")).Text.ToString(); string hss = ((Label)row.FindControl("Label8")).Text.ToString(); string hsj = ((Label)row.FindControl("Label9")).Text.ToString(); string nss = ((Label)row.FindControl("Label10")).Text.ToString(); string nsj = ((Label)row.FindControl("Label11")).Text.ToString(); string res_amt = ((Label)row.FindControl("lbl_ramt")).Text.ToString(); string kp = ((DropDownList)row.FindControl("lbl_kp")).Text.ToString(); builder.Append(oname + "," + naset + "," + qty + "," + uaset + "," + hss + "," + hsj + "," + nss + "," + nsj + "," + res_amt + "," + kp + Environment.NewLine); } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } else if (sel_frmt.SelectedValue == "03") { byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings); filename = string.Format("{0}.{1}", "SEMAKAN_REKOD_PELUPUSAN_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc"); Response.Buffer = true; Response.Clear(); Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); Response.ContentType = mimeType; Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } else { BindGrid(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } }
//void grid() //{ // con.Open(); // DataTable ddicno = new DataTable(); // ddicno = DBCon.Ora_Execute_table("select stf_staff_no,str_curr_org_cd,stf_curr_dept_cd,OG.org_name,hr_jaba_desc From hr_staff_profile as ST left join hr_organization as OG on OG.org_id=ST.str_curr_org_cd left join Ref_hr_jabatan as JB on JB.hr_jaba_Code=ST.stf_curr_dept_cd where stf_icno='" + Session["New"].ToString() + "' "); // string stffno = ddicno.Rows[0]["stf_staff_no"].ToString(); // DD_Orgnsi.SelectedValue = ddicno.Rows[0]["str_curr_org_cd"].ToString(); // DD_JABAT.SelectedValue = ddicno.Rows[0]["stf_curr_dept_cd"].ToString(); // String fromdate = string.Empty, todate = string.Empty; // if (txt_tmula.Text != "") // { // string datedari = txt_tmula.Text; // DateTime dt = DateTime.ParseExact(datedari, "dd/MM/yyyy", CultureInfo.InvariantCulture); // fromdate = dt.ToString("yyyy-MM-dd"); // } // else // { // fromdate = ""; // } // if (txt_takhir.Text != "") // { // string datedari1 = txt_takhir.Text; // DateTime dt1 = DateTime.ParseExact(datedari1, "dd/MM/yyyy", CultureInfo.InvariantCulture); // todate = dt1.ToString("yyyy-MM-dd"); // } // else // { // todate = ""; // } // SqlCommand cmd = new SqlCommand("select stf_staff_no,stf_name,hr_jaw_desc,a.LIND,b.HIND from hr_staff_profile as SF left join hr_attendance as AT on AT.atd_staff_no=SF.stf_staff_no left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=stf_curr_post_cd full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as LIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='L' group by atd_staff_no,atd_hol_late_ind) a on a.atd_staff_no=SF.stf_staff_no full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as HIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='H' group by atd_staff_no,atd_hol_late_ind) b on b.atd_staff_no=SF.stf_staff_no where stf_staff_no='" + stffno + "' and ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) group by a.LIND,b.HIND,stf_staff_no,stf_name,hr_jaw_desc", con); // SqlDataAdapter da = new SqlDataAdapter(cmd); // DataSet ds = new DataSet(); // da.Fill(ds); // if (ds.Tables[0].Rows.Count == 0) // { // ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); // GridView1.DataSource = ds; // GridView1.DataBind(); // int columncount = GridView1.Rows[0].Cells.Count; // GridView1.Rows[0].Cells.Clear(); // GridView1.Rows[0].Cells.Add(new TableCell()); // GridView1.Rows[0].Cells[0].ColumnSpan = columncount; // GridView1.Rows[0].Cells[0].Text = "<center>Maklumat Carian Tidak Dijumpai</center>"; // //btn_hups.Visible = false; // } // else // { // GridView1.DataSource = ds; // GridView1.DataBind(); // } // con.Close(); //} //protected void btn_cetak_Click(object sender, EventArgs e) //{ // try // { // Page.Header.Title = "Portal Laporan Pembiayaan CMCCS "; // //string datedari = Convert.ToDateTime(txt_tmula.Text).ToString("yyyy/MM/dd"); // //string datehingga = Convert.ToDateTime(txt_takhir.Text).ToString("yyyy/MM/dd"); // string datefrom = txt_tmula.Text; // DateTime dts = DateTime.ParseExact(datefrom, "dd/mm/yyyy", CultureInfo.InvariantCulture); // String datedari = dts.ToString("yyyy-mm-dd"); // string dateto = txt_takhir.Text; // DateTime dt1 = DateTime.ParseExact(dateto, "dd/mm/yyyy", CultureInfo.InvariantCulture); // String datehingga = dt1.ToString("yyyy-mm-dd"); // Session["fformat"] = ddfformat.SelectedItem.Text; // string ffile = Session["fformat"].ToString(); // if ((txt_tmula.Text != "") && (txt_takhir.Text != "")) // { // DataTable ddicno = new DataTable(); // ddicno = DBCon.Ora_Execute_table("select stf_staff_no From hr_staff_profile where stf_icno='" + Session["New"].ToString() + "' "); // string stffno = ddicno.Rows[0]["stf_staff_no"].ToString(); // DataSet dsCustomers = GetData("select stf_staff_no,stf_name,hr_jaw_desc,a.LIND,b.HIND from hr_staff_profile as SF left join hr_attendance as AT on AT.atd_staff_no=SF.stf_staff_no left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=stf_curr_post_cd full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as LIND From hr_attendance where ((atd_date) between ('" + datedari + "') And ('" + datehingga + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='L' group by atd_staff_no,atd_hol_late_ind) a on a.atd_staff_no=SF.stf_staff_no full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as HIND From hr_attendance where ((atd_date) between ('" + datedari + "') And ('" + datehingga + "')) and atd_staff_no='" + stffno + "' and atd_hol_late_ind='H' group by atd_staff_no,atd_hol_late_ind) b on b.atd_staff_no=SF.stf_staff_no where stf_staff_no='" + stffno + "' and ((atd_date) between ('" + datedari + "') And ('" + datehingga + "')) group by a.LIND,b.HIND,stf_staff_no,stf_name,hr_jaw_desc"); // dt = dsCustomers.Tables[0]; // } // ReportViewer1.Reset(); // List<DataRow> listResult = dt.AsEnumerable().ToList(); // listResult.Count(); // int countRow = 0; // countRow = listResult.Count(); // if (countRow != 0) // { // //txtError.Text = ""; // //Display Report // ReportViewer1.LocalReport.DataSources.Clear(); // ReportDataSource rds = new ReportDataSource("DataSet1", dt); // ReportViewer1.LocalReport.DataSources.Add(rds); // //Path // ReportViewer1.LocalReport.ReportPath = "HR_REKOD_KEHADIRAN.rdlc"; // //Parameters // ReportParameter[] rptParams = new ReportParameter[]{ // //new ReportParameter("fromDate",FromDate .Text ), // //new ReportParameter("toDate",ToDate .Text ) // //new ReportParameter("fromDate",datedari ), // //new ReportParameter("toDate",datehingga ), // //new ReportParameter("caw",branch ), // //new ReportParameter("Cdate",DateTime.Now.ToString("dd/MM/yyyy") ), // //new ReportParameter("Date",DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") ) // }; // ReportViewer1.LocalReport.SetParameters(rptParams); // //ReportViewer1.LocalReport.ExecuteReportInCurrentAppDomain(AppDomain.CurrentDomain.Evidence); // //Refresh // ReportViewer1.LocalReport.Refresh(); // if (ffile == "PDF") // { // Warning[] warnings; // string[] streamids; // string mimeType; // string encoding; // string extension; // // string devinfo = "<DeviceInfo>" + // //" <OutputFormat>PDF</OutputFormat>" + // //" <PageSize>A4</PageSize>" + // //" <PageWidth>8.5in</PageWidth>" + // //" <PageHeight>11in</PageHeight>" + // //" <MarginTop>0.25in</MarginTop>" + // //" <MarginLeft>0.5in</MarginLeft>" + // //" <MarginRight>0.5in</MarginRight>" + // //" <MarginBottom>0.5in</MarginBottom>" + // //"</DeviceInfo>"; // byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); // Response.Buffer = true; // Response.Clear(); // Response.ContentType = mimeType; // string extfile = DateTime.Now.ToString("dd_MM_yyyy."); // Response.AddHeader("content-disposition", "inline; filename=REKOD_KEHADIRAN" + extfile + extension); // Response.BinaryWrite(bytes); // Response.Flush(); // Response.End(); // } // else if (ffile == "Excel") // { // Warning[] warnings; // string[] streamids; // string mimeType; // string encoding; // string extension; // string filename; // byte[] bytes = ReportViewer1.LocalReport.Render( // "Excel", null, out mimeType, out encoding, // out extension, // out streamids, out warnings); // filename = string.Format("{0}.{1}", "Laporan", "xls"); // Response.Buffer = true; // Response.Clear(); // Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); // Response.ContentType = mimeType; // Response.BinaryWrite(bytes); // Response.Flush(); // Response.End(); // } // else // { // Warning[] warnings; // string[] streamids; // string mimeType; // string encoding; // string extension; // byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); // Response.Buffer = true; // Response.Clear(); // Response.ContentType = mimeType; // Response.AddHeader("content-disposition", "inline; filename=myfile." + extension); // Response.BinaryWrite(bytes); // Response.Flush(); // Response.End(); // } // } // else if (countRow == 0) // { // ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alert('Rekod tidak dijumpai. Sila pastikan semua maklumat dimasukkan dengan betul.');", true); // } // } // catch (Exception ex) // { // //txtError.Text = ex.ToString(); // } //} void clk_print() { { try { if (DD_Orgnsi.SelectedValue != "" || dd_org_pen.SelectedValue != "" || DD_JABAT.SelectedValue != "") { if (txt_tmula.Text != "") { string datedari = txt_tmula.Text; DateTime dt2 = DateTime.ParseExact(datedari, "dd/MM/yyyy", CultureInfo.InvariantCulture); fromdate = dt2.ToString("yyyy/MM/dd"); } else { fromdate = ""; } if (txt_takhir.Text != "") { string datedari1 = txt_takhir.Text; DateTime dt1 = DateTime.ParseExact(datedari1, "dd/MM/yyyy", CultureInfo.InvariantCulture); todate = dt1.ToString("yyyy/MM/dd"); } else { todate = ""; } selqry(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); //dt = DBCon.Ora_Execute_table("select stf_staff_no,stf_name,hr_jaw_desc,a.LIND,b.HIND from hr_staff_profile as SF left join hr_attendance as AT on AT.atd_staff_no=SF.stf_staff_no left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=stf_curr_post_cd full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as LIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_hol_late_ind='L' group by atd_staff_no,atd_hol_late_ind) a on a.atd_staff_no=SF.stf_staff_no full outer join (select atd_staff_no,COUNT(atd_hol_late_ind) as HIND From hr_attendance where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) and atd_hol_late_ind='H' group by atd_staff_no,atd_hol_late_ind) b on b.atd_staff_no=SF.stf_staff_no where ((atd_date) between ('" + fromdate + "') And ('" + todate + "')) group by a.LIND,b.HIND,stf_staff_no,stf_name,hr_jaw_desc"); dt = DBCon.Ora_Execute_table("select a.stf_staff_no,UPPER(a.stf_name) as stf_name,UPPER(ISNULL(jw.hr_jaw_desc,'')) as hr_jaw_desc,UPPER(ISNULL(op.op_perg_name,'')) as op_perg_name,UPPER(ISNULL(JB.oj_jaba_desc,'')) as oj_jaba_desc,ISNULL(b.LIND,'') LIND,ISNULL(c.HIND,'') HIND from (select * from hr_staff_profile as hp where " + sqry1 + ") as a full outer join (select hp.stf_staff_no,COUNT(atd_hol_late_ind) as LIND from hr_staff_profile as hp left join hr_attendance as ha on ha.atd_staff_no = hp.stf_staff_no and atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + fromdate + "'), 0) and atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + todate + "'), 0) where atd_hol_late_ind='L' and " + sqry1 + " group by stf_staff_no) as b on b.stf_staff_no=a.stf_staff_no full outer join (select hp.stf_staff_no,COUNT(atd_hol_late_ind) as HIND from hr_staff_profile as hp left join hr_attendance as ha on ha.atd_staff_no = hp.stf_staff_no and atd_date>=DATEADD(day, DATEDIFF(day, 0, '" + fromdate + "'), 0) and atd_date<=DATEADD(day, DATEDIFF(day, 0, '" + todate + "'), 0) where atd_hol_late_ind='H' and " + sqry1 + " group by stf_staff_no) as c on c.stf_staff_no=a.stf_staff_no left join hr_organization_jaba JB on jb.oj_jaba_cd=a.stf_curr_dept_cd and jb.oj_perg_code=a.stf_cur_sub_org left join hr_organization_pern OP on op.op_perg_code=a.stf_cur_sub_org left join Ref_hr_Jawatan as JW on JW.hr_jaw_Code=a.stf_curr_post_cd order by op.op_perg_code,jb.oj_jaba_cd"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); if (DD_JABAT.SelectedValue != "") { sqry2 = DD_JABAT.SelectedItem.Text; } else { sqry2 = "SEMUA"; } if (dd_org_pen.SelectedValue != "") { sqry3 = dd_org_pen.SelectedItem.Text; } else { sqry3 = "SEMUA"; } RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { shw_hdr1.Visible = true; RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/HR_REKOD_KEHADIRAN.rdlc"; ReportDataSource rds = new ReportDataSource("HR_rk", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("s1", DD_Orgnsi.SelectedItem.Text), new ReportParameter("s2", sqry2), new ReportParameter("s3", txt_tmula.Text), new ReportParameter("s4", txt_takhir.Text), new ReportParameter("s5", sqry3), }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DisplayName = "Rekod_Kehadiran -" + DateTime.Now.ToString("ddMMyyyy"); RptviwerStudent.LocalReport.DataSources.Add(rds); //Refresh RptviwerStudent.LocalReport.Refresh(); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } else { //grid(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } catch (Exception ex) { throw ex; } } }
void clk_print() { { try { if (dd_org.SelectedValue != "" || dd_jabatan.SelectedValue.Trim() != "" || dd_unit.SelectedValue != "" || tm_date.Text != "" || ta_date.Text != "") { if (tm_date.Text != "" && ta_date.Text != "") { string d1 = tm_date.Text; DateTime today1 = DateTime.ParseExact(d1, "dd/MM/yyyy", CultureInfo.InvariantCulture); phdate1 = today1.ToString("yyyy-MM-dd"); string d2 = ta_date.Text; DateTime today2 = DateTime.ParseExact(d2, "dd/MM/yyyy", CultureInfo.InvariantCulture); phdate2 = today2.ToString("yyyy-MM-dd"); } else { phdate1 = ""; phdate2 = ""; } if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text == "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "'"; } else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text == "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "'"; } else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue != "" && tm_date.Text == "" && ta_date.Text == "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "'"; } else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text == "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "'"; } else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue != "" && tm_date.Text == "" && ta_date.Text == "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "'"; } else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text == "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_start_dt='" + phdate1 + "'"; } else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text == "" && ta_date.Text != "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_end_dt='" + phdate2 + "'"; } else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue != "" && tm_date.Text == "" && ta_date.Text == "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "' and aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "'"; } else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text != "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)"; } else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue != "" && tm_date.Text != "" && ta_date.Text != "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)"; } else if (dd_org.SelectedValue == "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text != "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)"; } else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() != "" && dd_unit.SelectedValue != "" && tm_date.Text != "" && ta_date.Text != "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_dept_cd='" + dd_jabatan.SelectedValue.Trim() + "' and aps_unit_cd='" + dd_unit.SelectedValue.Trim() + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)"; } else if (dd_org.SelectedValue != "" && dd_jabatan.SelectedValue.Trim() == "" && dd_unit.SelectedValue == "" && tm_date.Text != "" && ta_date.Text != "") { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id='" + dd_org.SelectedValue + "' and aps_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + phdate1 + "'), 0) and aps_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + phdate2 + "'), +1)"; } else { val1 = "select sa.aps_staff_no,sa.aps_staff_name,rj.hr_jaw_desc,pk.hr_kate_desc,sa.aps_section1_score,sa.aps_section2_score,sa.aps_section3_score,sa.aps_section4_score,sa.aps_total_score from hr_appraisal_summary as sa left join Ref_hr_Jawatan as rj on rj.hr_jaw_Code=sa.aps_post_cd left join Ref_hr_penj_kategori as pk on pk.hr_kate_Code=sa.aps_post_cat_cd where aps_org_id=''"; } DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = DBCon.Ora_Execute_table("" + val1 + ""); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { hdr_txt.Visible = true; RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/hr_lppk.rdlc"; ReportDataSource rds = new ReportDataSource("hr_lppk", dt); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.DisplayName = " PENILAIAN_PRESTASI_" + DateTime.Now.ToString("ddMMyyyy"); //Refresh RptviwerStudent.LocalReport.Refresh(); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } else { //grid(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukkan Input Carian.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } catch (Exception ex) { throw ex; } } }
protected void Button1_Click(object sender, EventArgs e) { try { if (TextBox4.Text != "" && DropDownList1.SelectedValue != "") { string chk_stf = string.Empty; act_dt = TextBox4.Text + "-" + DropDownList1.SelectedValue; DataTable dd_hrsal = new DataTable(); if (Session["roles"].ToString() == "R0001") { if (TextBox2.Text == "") { chk_stf = TextBox1.Text; } else { chk_stf = TextBox2.Text; } } else { chk_stf = TextBox1.Text; } dd_hrsal = DBCon.Ora_Execute_table("select * from hr_income where inc_staff_no='" + chk_stf + "' and inc_month='" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "' and inc_app_sts='A'"); string fmyr = DateTime.Now.ToString("yyyy") + "01"; string cmyr = DateTime.Now.ToString("yyyy") + DateTime.Now.ToString("MM"); DataTable dd_hrsal_dt = new DataTable(); dd_hrsal_dt = DBCon.Ora_Execute_table("select sum(inc_kwsp_amt) as k1,sum(inc_emp_kwsp_amt) as k2,sum(inc_perkeso_amt) as k3,sum(inc_emp_perkeso_amt) as k4,sum(inc_SIP_amt) as k5,sum(inc_emp_SIP_amt) as k6 from hr_income where inc_staff_no='" + chk_stf + "' and inc_month between '01' and '" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "'"); if (dd_hrsal.Rows.Count != 0) { DataTable dd_incsum = new DataTable(); dd_incsum = DBCon.Ora_Execute_table("select (sum(inc_pcb_amt) + sum(inc_cp38_amt) + sum(inc_cp38_amt2)) as tt_amt1 from hr_income where inc_staff_no='" + chk_stf + "' and inc_month between '01' and '" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "'"); string incamt = string.Empty; if (dd_incsum.Rows[0]["tt_amt1"].ToString() != "") { incamt = dd_incsum.Rows[0]["tt_amt1"].ToString(); } else { incamt = "0.00"; } DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = DBCon.Ora_Execute_table("select hsp.stf_name,hsp.stf_epf_no,hsp.stf_tax_no,hsp.stf_socso_no,hsp.str_curr_org_cd,FORMAT(hsp.stf_service_start_dt,'dd/MM/yyyy', 'en-us') as stf_service_start_dt,hsp.stf_staff_no,ISNULL(hsp.stf_bank_acc_no,'') as stf_bank_acc_no,ISNULL(nb.Bank_Name,'') as Bank_Name,hsp.stf_icno,inc_dept_cd,inc_grade_cd,pos_post_cd,ISNULL(jb.hr_jaw_desc,'') as hr_jaba_desc,ISNULL(pt.hr_traf_desc,'') as job_sts from hr_income hi left join hr_staff_profile hsp on hsp.stf_staff_no=hi.inc_staff_no left join hr_post_his hph on hph.pos_staff_no=hsp.stf_staff_no left join Ref_hr_Jawatan as jb on jb.hr_jaw_Code= hsp.stf_curr_post_cd left join Ref_Nama_Bank as nb on nb.Bank_Code=hsp.stf_bank_cd left join Ref_hr_penj_traf pt on pt.hr_traf_Code=pos_job_sts_cd where hsp.stf_staff_no='" + chk_stf + "' and pos_end_dt = '9999-12-31' and hi.inc_month='" + DropDownList1.SelectedValue + "' and inc_year='" + TextBox4.Text + "'"); ds.Tables.Add(dt); DataTable dt1 = new DataTable(); dt1 = DBCon.Ora_Execute_table("select hd.ded_staff_no,po.hr_poto_desc,ded_deduct_amt,hd.ded_deduct_type_cd from hr_deduction as hd inner join Ref_hr_potongan as PO on PO.hr_poto_Code=hd.ded_deduct_type_cd where hd.ded_staff_no='" + chk_stf + "' and (('" + act_dt.ToString() + "') between FORMAT(hd.ded_start_dt,'yyyy-MM') And FORMAT(hd.ded_end_dt,'yyyy-MM'))"); ds.Tables.Add(dt1); DataTable dt2 = new DataTable(); dt2 = DBCon.Ora_Execute_table("select a.fxa_staff_no,el.hr_elau_desc as hr_elaun_desc,a.fxa_allowance_amt from (select * from hr_fixed_allowance as fx where ('" + act_dt.ToString() + "' between FORMAT(fx.fxa_eff_dt,'yyyy-MM') And FORMAT(fx.fxa_end_dt,'yyyy-MM')) and fx.fxa_staff_no='" + chk_stf + "') as a left join Ref_hr_jenis_elaun as EL on EL.hr_elau_Code=a.fxa_allowance_type_cd"); ds.Tables.Add(dt2); DataTable dt3 = new DataTable(); dt3 = DBCon.Ora_Execute_table("select a.xta_staff_no,EL.hr_elau_desc as hr_elaun_desc,a.xta_allowance_amt from (select * from hr_extra_allowance as ea where ea.xta_staff_no='" + chk_stf + "' and ('" + act_dt.ToString() + "' between FORMAT(ea.xta_eff_dt,'yyyy-MM') And FORMAT(ea.xta_end_dt,'yyyy-MM'))) as a left join Ref_hr_jenis_elaun as EL on EL.hr_elau_Code=a.xta_allowance_type_cd"); ds.Tables.Add(dt3); DataTable dt5 = new DataTable(); dt5 = DBCon.Ora_Execute_table("select *,hr_tung_desc from hr_tunggakan left join Ref_hr_tunggakan on hr_tung_Code=tun_type_cd where tun_staff_no='" + chk_stf + "' and tun_year='" + TextBox4.Text + "' and tun_month='" + DropDownList1.SelectedValue + "'"); ds.Tables.Add(dt5); DataTable dt6 = new DataTable(); dt6 = DBCon.Ora_Execute_table("select s2.typeklm_desc +' ' + otl_remark as nm1,otl_remark,otl_ot_amt from hr_ot s1 left join Ref_hr_type_klm s2 on s2.typeklm_cd=s1.otl_ot_type_cd where otl_staff_no='" + chk_stf + "' and year(otl_work_dt) = '" + TextBox4.Text + "' and Month(otl_work_dt) = '" + DropDownList1.SelectedValue + "'"); ds.Tables.Add(dt6); RptviwerStudent.Reset(); string filename; DataTable dd_org = new DataTable(); dd_org = DBCon.Ora_Execute_table("select org_epf_no,org_socso_no,org_temp_ind,org_income_tax_no,org_name from hr_organization where org_gen_id='" + dt.Rows[0]["str_curr_org_cd"].ToString() + "'"); decimal sal_amt = decimal.Parse(dd_hrsal.Rows[0]["inc_salary_amt"].ToString()); decimal el_amt = decimal.Parse(dd_hrsal.Rows[0]["inc_cumm_fix_allwnce_amt"].ToString()); decimal ll_amt = decimal.Parse(dd_hrsal.Rows[0]["inc_cumm_xtra_allwnce_amt"].ToString()); DataTable dd_hrsal4 = new DataTable(); dd_hrsal4 = DBCon.Ora_Execute_table("select fx.ded_staff_no,sum(fx.ded_deduct_amt) as samt from hr_deduction as fx where ('" + act_dt.ToString() + "' between FORMAT(fx.ded_start_dt,'yyyy-MM') And FORMAT(fx.ded_end_dt,'yyyy-MM')) and fx.ded_staff_no='" + chk_stf + "' group by fx.ded_staff_no"); string hrs4_amt = string.Empty; if (dd_hrsal4.Rows.Count != 0 && dd_hrsal4.Rows[0]["samt"].ToString() != "") { hrs4_amt = double.Parse(dd_hrsal4.Rows[0]["samt"].ToString()).ToString("C").Replace("$", "").Replace("RM", ""); } else { hrs4_amt = "0.00"; } DataTable dd_inc_tax = new DataTable(); dd_inc_tax = DBCon.Ora_Execute_table("select tax_pcb_amt from hr_income_tax where ('" + act_dt.ToString() + "' between FORMAT(tax_pcb_start_dt ,'yyyy-MM') And FORMAT(tax_pcb_end_dt,'yyyy-MM')) and tax_staff_no='" + chk_stf + "'"); string pcb4_amt = string.Empty; if (dd_inc_tax.Rows.Count != 0 && dd_inc_tax.Rows[0]["tax_pcb_amt"].ToString() != "") { pcb4_amt = double.Parse(dd_inc_tax.Rows[0]["tax_pcb_amt"].ToString()).ToString("C").Replace("$", "").Replace("RM", ""); } else { pcb4_amt = "0.00"; } DataTable dd_inc_cp38 = new DataTable(); dd_inc_cp38 = DBCon.Ora_Execute_table("select tax_cp38_amt1 from hr_income_tax where ('" + act_dt.ToString() + "' between FORMAT(tax_cp38_start_dt1 ,'yyyy-MM') And FORMAT(tax_cp38_end_dt1,'yyyy-MM')) and tax_type ='2' and tax_staff_no='" + chk_stf + "'"); string hr_cpamt2 = string.Empty; if (dd_inc_cp38.Rows.Count != 0 && dd_inc_cp38.Rows[0]["tax_cp38_amt1"].ToString() != "") { double cp2 = double.Parse(dd_inc_cp38.Rows[0]["tax_cp38_amt1"].ToString()); hr_cpamt2 = cp2.ToString("C").Replace("$", "").Replace("RM", ""); } else { hr_cpamt2 = "0.00"; } DataTable dd_tun = new DataTable(); dd_tun = DBCon.Ora_Execute_table("select sum(clm_claim_amt) as camt from hr_claim where clm_staff_no='" + chk_stf + "' and clm_month='" + DropDownList1.SelectedValue + "' and clm_year='" + TextBox4.Text + "'"); string ded_at = string.Empty; DataTable dd_deduct = new DataTable(); //dd_deduct = DBCon.Ora_Execute_table("select sum(ind_deduct_amt) as amt1,ind_ref_no from hr_income_deduct where ind_staff_no='" + TextBox1.Text + "' and ind_deduct_type_cd='04' and ind_month between '01' and '" + DropDownList1.SelectedValue + "' and ind_year='" + TextBox4.Text + "' group by ind_ref_no"); dd_deduct = DBCon.Ora_Execute_table("SELECT top(1) a.amt1,b.ind_ref_no FROM (select sum(ISNULL(ind_deduct_amt,'')) as amt1 from hr_income_deduct where ind_staff_no='" + chk_stf + "' and ind_deduct_type_cd='04' and ind_month between '01' and '" + DropDownList1.SelectedValue + "' and ind_year='" + TextBox4.Text + "') as a full outer join (select * from hr_income_deduct where ind_staff_no='" + chk_stf + "' and ind_deduct_type_cd='04' and ind_month between '01' and '" + DropDownList1.SelectedValue + "' and ind_year='" + TextBox4.Text + "') as b on b.ind_staff_no='" + chk_stf + "'"); if (dd_deduct.Rows.Count != 0 && dd_deduct.Rows[0]["amt1"].ToString() != "") { ded_at = dd_deduct.Rows[0]["amt1"].ToString(); } else { ded_at = "0.00"; } string tun_amt = string.Empty; if (dd_tun.Rows[0]["camt"].ToString() != "") { tun_amt = dd_tun.Rows[0]["camt"].ToString(); } else { tun_amt = "0.00"; } string aq1 = string.Empty, aq2 = string.Empty, aq3 = string.Empty, aq4 = string.Empty, aq5 = string.Empty, aq6 = string.Empty, aq7 = string.Empty; string kq1 = string.Empty, kq2 = string.Empty, kq3 = string.Empty, kq4 = string.Empty, kq5 = string.Empty, kq6 = string.Empty; if (dd_hrsal.Rows[0]["inc_emp_kwsp_amt"].ToString() != "") { aq1 = dd_hrsal.Rows[0]["inc_emp_kwsp_amt"].ToString(); } else { aq1 = "0.00"; } if (dd_hrsal.Rows[0]["inc_emp_perkeso_amt"].ToString() != "") { aq2 = dd_hrsal.Rows[0]["inc_emp_perkeso_amt"].ToString(); } else { aq2 = "0.00"; } if (dd_hrsal.Rows[0]["inc_bonus_amt"].ToString() != "") { aq3 = dd_hrsal.Rows[0]["inc_bonus_amt"].ToString(); } else { aq3 = "0.00"; } if (dd_hrsal.Rows[0]["inc_kpi_bonus_amt"].ToString() != "") { aq4 = dd_hrsal.Rows[0]["inc_kpi_bonus_amt"].ToString(); } else { aq4 = "0.00"; } if (dd_hrsal.Rows[0]["inc_ot_amt"].ToString() != "") { aq5 = dd_hrsal.Rows[0]["inc_ot_amt"].ToString(); } else { aq5 = "0.00"; } if (dd_hrsal.Rows[0]["inc_tunggakan_amt"].ToString() != "") { aq6 = dd_hrsal.Rows[0]["inc_tunggakan_amt"].ToString(); } else { aq6 = "0.00"; } if (dd_hrsal.Rows[0]["inc_emp_sip_amt"].ToString() != "") { aq7 = dd_hrsal.Rows[0]["inc_emp_sip_amt"].ToString(); } else { aq7 = "0.00"; } if (dd_hrsal_dt.Rows[0]["k1"].ToString() != "") { kq1 = dd_hrsal_dt.Rows[0]["k1"].ToString(); } else { kq1 = "0.00"; } if (dd_hrsal_dt.Rows[0]["k2"].ToString() != "") { kq2 = dd_hrsal_dt.Rows[0]["k2"].ToString(); } else { kq2 = "0.00"; } if (dd_hrsal_dt.Rows[0]["k3"].ToString() != "") { kq3 = dd_hrsal_dt.Rows[0]["k3"].ToString(); } else { kq3 = "0.00"; } if (dd_hrsal_dt.Rows[0]["k4"].ToString() != "") { kq4 = dd_hrsal_dt.Rows[0]["k4"].ToString(); } else { kq4 = "0.00"; } if (dd_hrsal_dt.Rows[0]["k5"].ToString() != "") { kq5 = dd_hrsal_dt.Rows[0]["k5"].ToString(); } else { kq5 = "0.00"; } if (dd_hrsal_dt.Rows[0]["k6"].ToString() != "") { kq6 = dd_hrsal_dt.Rows[0]["k6"].ToString(); } else { kq6 = "0.00"; } string jum_pend = (double.Parse(sal_amt.ToString()) + double.Parse(el_amt.ToString()) + double.Parse(ll_amt.ToString()) + double.Parse(aq3.ToString()) + double.Parse(aq4.ToString()) + double.Parse(aq5.ToString()) + double.Parse(aq6.ToString())).ToString("C").Replace("$", "").Replace("RM", ""); //string jum_pote = (double.Parse(dd_hrsal.Rows[0]["inc_ctg_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_kwsp_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_perkeso_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_pcb_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()) + double.Parse(hr_cpamt2.ToString()) + double.Parse(hrs4_amt.ToString())).ToString("C").Replace("$", "").Replace("RM", ""); string jum_pote = (double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_SIP_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_ctg_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_kwsp_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_perkeso_amt"].ToString()) + double.Parse(pcb4_amt.ToString()) /*double.Parse(dd_hrsal.Rows[0]["inc_pcb_amt"].ToString()) + double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()) +*/ + double.Parse(hrs4_amt.ToString())).ToString("C").Replace("$", "").Replace("RM", ""); string tot_nettamt = (double.Parse(jum_pend) - double.Parse(jum_pote)).ToString("C").Replace("$", "").Replace("RM", ""); string org_typ = string.Empty; string fname1 = string.Empty; //if (dd_org.Rows[0]["org_temp_ind"].ToString() == "A") //{ // org_typ = "ar-rahnu.rdlc"; // //org_typ = "koop_sahabat.rdlc"; // //fname1 = "AR-RAHNU"; //} //else if (dd_org.Rows[0]["org_temp_ind"].ToString() == "k") //{ // org_typ = "koop_sahabat.rdlc"; // //fname1 = "KOOP_SAHABAT"; //} //else if (dd_org.Rows[0]["org_temp_ind"].ToString() == "G") //{ // org_typ = "GEMALAI_PLANTATION.rdlc"; // //fname1 = "GEMALAI_PLANTATION"; //} //else //{ // org_typ = "koop_sahabat.rdlc"; // //fname1 = "KOOP_SAHABAT"; //} //string img_name = Server.MapPath("~/FILES/org_logo/logo4.png"); //ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc"); RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/KTHB_PAYSLIP.rdlc"; RptviwerStudent.LocalReport.EnableExternalImages = true; string imagePath = new Uri(Server.MapPath("~/FILES/org_logo/" + dd_org.Rows[0]["org_temp_ind"].ToString() + "")).AbsoluteUri; ReportDataSource rds = new ReportDataSource("ks", dt); ReportDataSource rds1 = new ReportDataSource("ks1", dt1); ReportDataSource rds2 = new ReportDataSource("ks2", dt2); ReportDataSource rds3 = new ReportDataSource("ks3", dt3); ReportDataSource rds4 = new ReportDataSource("ks5", dt5); ReportDataSource rds5 = new ReportDataSource("ks6", dt6); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("sal_amt", sal_amt.ToString("C").Replace("$", "")), new ReportParameter("et_amt", el_amt.ToString("C").Replace("$", "")), new ReportParameter("ll_amt", ll_amt.ToString("C").Replace("$", "")), new ReportParameter("tun_amt", double.Parse(tun_amt.ToString()).ToString("C").Replace("$", "")), new ReportParameter("jum_pen", jum_pend.ToString()), new ReportParameter("pctg_amt", double.Parse(dd_hrsal.Rows[0]["inc_ctg_amt"].ToString()).ToString("C").Replace("$", "")), new ReportParameter("ckwsp_amt", double.Parse(dd_hrsal.Rows[0]["inc_kwsp_amt"].ToString()).ToString("C").Replace("$", "")), new ReportParameter("perk_amt", double.Parse(dd_hrsal.Rows[0]["inc_perkeso_amt"].ToString()).ToString("C").Replace("$", "")), new ReportParameter("ppcb_amt", double.Parse(dd_hrsal.Rows[0]["inc_pcb_amt"].ToString()).ToString("C").Replace("$", "")), new ReportParameter("cp38_amt1", double.Parse(dd_hrsal.Rows[0]["inc_cp38_amt"].ToString()).ToString("C").Replace("$", "")), new ReportParameter("cp38_amt2", hr_cpamt2.ToString()), new ReportParameter("jum_pote", jum_pote.ToString()), new ReportParameter("nett_amt", tot_nettamt), new ReportParameter("kwsp_maj", double.Parse(aq1).ToString("C").Replace("$", "")), new ReportParameter("perk_maj", double.Parse(aq2).ToString("C").Replace("$", "")), new ReportParameter("sip_maj", double.Parse(aq7).ToString("C").Replace("$", "")), new ReportParameter("kwsp_pek", dt.Rows[0]["stf_epf_no"].ToString()), new ReportParameter("kwsp_majno", dd_org.Rows[0]["org_epf_no"].ToString()), new ReportParameter("per_pek", dt.Rows[0]["stf_socso_no"].ToString()), new ReportParameter("per_majno", dd_org.Rows[0]["org_socso_no"].ToString()), new ReportParameter("sip_pek", dt.Rows[0]["stf_tax_no"].ToString()), new ReportParameter("sip_majno", dd_org.Rows[0]["org_income_tax_no"].ToString()), new ReportParameter("cuk_pen", dt.Rows[0]["stf_tax_no"].ToString()), new ReportParameter("k1", double.Parse(kq1).ToString("C").Replace("$", "")), new ReportParameter("k2", double.Parse(kq2).ToString("C").Replace("$", "")), new ReportParameter("k3", double.Parse(kq3).ToString("C").Replace("$", "")), new ReportParameter("k4", double.Parse(kq4).ToString("C").Replace("$", "")), new ReportParameter("k5", double.Parse(incamt.ToString()).ToString("C").Replace("$", "")), new ReportParameter("k6", dd_deduct.Rows[0]["ind_ref_no"].ToString()), new ReportParameter("k7", double.Parse(ded_at.ToString()).ToString("C").Replace("$", "")), new ReportParameter("k8", DropDownList1.SelectedItem.Text.ToUpper()), new ReportParameter("k9", TextBox4.Text), new ReportParameter("imgname", imagePath), new ReportParameter("org", dd_org.Rows[0]["org_name"].ToString()), new ReportParameter("k10", double.Parse(aq3).ToString("C").Replace("$", "")), new ReportParameter("k11", double.Parse(aq4).ToString("C").Replace("$", "")), new ReportParameter("k12", double.Parse(aq5).ToString("C").Replace("$", "")), new ReportParameter("k13", double.Parse(dd_hrsal.Rows[0]["inc_SIP_amt"].ToString()).ToString("C").Replace("$", "")), new ReportParameter("k14", double.Parse(dd_hrsal.Rows[0]["inc_emp_SIP_amt"].ToString()).ToString("C").Replace("$", "")), new ReportParameter("k15", double.Parse(kq5).ToString("C").Replace("$", "")), new ReportParameter("k16", double.Parse(kq6).ToString("C").Replace("$", "")), new ReportParameter("k17", dt.Rows[0]["job_sts"].ToString()), new ReportParameter("k18", double.Parse(pcb4_amt).ToString("C").Replace("$", "")) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.DataSources.Add(rds1); RptviwerStudent.LocalReport.DataSources.Add(rds2); RptviwerStudent.LocalReport.DataSources.Add(rds3); RptviwerStudent.LocalReport.DataSources.Add(rds4); RptviwerStudent.LocalReport.DataSources.Add(rds5); RptviwerStudent.LocalReport.DisplayName = "" + dt.Rows[0]["stf_staff_no"].ToString().ToUpper().Trim() + "_" + DropDownList1.SelectedValue + "" + TextBox4.Text + ""; RptviwerStudent.LocalReport.Refresh(); filename = string.Format("{0}.{1}", "" + dt.Rows[0]["stf_staff_no"].ToString().ToUpper().Trim() + "_" + DropDownList1.SelectedValue + "" + TextBox4.Text + "", "pdf"); //} Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila masukan Input Carian',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Issue',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } }
protected void ctk_values(object sender, EventArgs e) { sel_qry(); string stdt1 = string.Empty, eddt1 = string.Empty, vv1 = string.Empty, vv2 = string.Empty; if (TextBox1.Text != "") { DateTime dt_1 = DateTime.ParseExact(TextBox1.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); stdt1 = dt_1.ToString("yyyy-MM-dd"); } else { stdt1 = "SEMUA"; } if (TextBox3.Text != "") { DateTime dt_2 = DateTime.ParseExact(TextBox3.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); eddt1 = dt_2.ToString("yyyy-MM-dd"); } else { eddt1 = "SEMUA"; } if (ddkat_jaw.SelectedValue != "") { vv1 = ddkat_jaw.SelectedItem.Text; } else { vv1 = "SEMUA"; } if (dd_unit.SelectedValue != "") { vv2 = dd_unit.SelectedItem.Text; } else { vv2 = "SEMUA"; } DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = dbcon.Ora_Execute_table("" + val1 + ""); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "HR_pen_pertasi1.rdlc"; ReportDataSource rds = new ReportDataSource("HR_pen_pertasi1", dt); RptviwerStudent.LocalReport.DataSources.Add(rds); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("s1", stdt1), new ReportParameter("s2", eddt1), new ReportParameter("s3", vv1), new ReportParameter("s4", vv2) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; filename = string.Format("{0}.{1}", "Kemaskini_Dokumen_Penilaian_Prestasi_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul');", true); } }
protected void ctk_values(object sender, EventArgs e) { string rcount = string.Empty; int count1 = 0; DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = DBCon.Ora_Execute_table("select *,s1.stf_name as nama,Format(otd_work_dt,'dd/MM/yyyy') as tdt from hr_daily_ot left join hr_staff_profile s1 on s1.stf_staff_no=otd_staff_no where otd_staff_no='" + Session["New"].ToString() + "' and otd_month='" + DropDownList1.SelectedValue + "' and otd_year='" + Tahun_kew.SelectedItem.Text + "'"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { if (sel_frmt.SelectedValue == "01") { RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/jadual_klm.rdlc"; ReportDataSource rds = new ReportDataSource("jadualklm", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("s1", Tahun_kew.SelectedItem.Text), new ReportParameter("s2", DropDownList1.SelectedItem.Text) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; filename = string.Format("{0}.{1}", "Jadual_KLM_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (sel_frmt.SelectedValue == "02") { System.Text.StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "Jadual_KLM_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("No Kakitangan ,Nama Kakitangan, Tarikh, Masa Mula, Masa Akhir, Keterangan, Jumlah Jam" + Environment.NewLine); for (int i = 0; i < dt.Rows.Count; i++) { builder.Append(dt.Rows[i]["otd_staff_no"].ToString() + "," + txt_nama.Text + "," + dt.Rows[i]["tdt"].ToString() + "," + dt.Rows[i]["otd_time_start"].ToString() + "," + dt.Rows[i]["otd_time_end"].ToString() + "," + dt.Rows[i]["otd_desc"].ToString() + "," + dt.Rows[i]["otd_total_hour"].ToString() + Environment.NewLine); } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } grid(); }
protected void Click_print(object sender, EventArgs e) { try { string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty; if (Txtnokp.Text != "") { if (DropDownList4.SelectedValue != "") { //Path DataSet ds = new DataSet(); DataTable dt = new DataTable(); //dt = DBCon.Ora_Execute_table("SELECT DISTINCT A.mem_member_no, A.mem_name, A.mem_address, A.mem_new_icno, A.mem_phone_m, A.gender_desc, A.Bangsa_Name, A.Wilayah_Name, A.mem_centre, A.cawangan_name, A.mem_fee_amount, CONVERT(VARCHAR(10),GETDATE(),105) as cdate, B.ftunai,B.fpst,B.SPST,B.STUNAI,B.jumlah,c.sha_approve_Dt, C.sha_item,C. sha_reference_ind,C. sha_debit_amt,C. sha_credit_amt,c.Jumla,d.div_pay_dt,d.div_remark,d.Bank_Name as bname,d.div_bank_acc_no,d.div_debit_amt,a.Applicant_Name,e.ast_end_date,e.ast_monthly_collect_amt,e.ast_st_balance_amt FROM ((select mem_member_no,mem_name,mem_address,mem_new_icno,mem_phone_m,rg.gender_desc,rb.Bangsa_Name,rw.Wilayah_Name,mm.mem_centre,mem_fee_amount,ra.Applicant_Name,br.branch_desc as cawangan_name from mem_member as mm Left join Ref_Wilayah AS rw ON mm.mem_region_cd = rw.Wilayah_Code Left join Ref_Cawangan AS rc ON mm.mem_area_cd=rc.kawasan_code inner join Ref_Bangsa rb on rb.Bangsa_Code=mm.mem_race_cd inner join ref_gender rg on rg.gender_cd=mm.mem_gender_cd inner join Ref_Applicant_Category ra on ra.Applicant_Code=mm.mem_applicant_type_cd left join ref_branch br on br.branch_cd=mm.mem_branch_cd ) a FULL OUTER JOIN (select b.FTUNAI,b.FPST,a.STUNAI,a.SPST, a.STUNAI + a.SPST as Jumlah,a.sha_new_icno from (select * from (select isnull([STUNAI],'') as STUNAI,isnull([SPST],'') as SPST,sha_new_icno from (select SUM(sha_debit_amt) - sum(sha_credit_amt) as Tran_count, case (sha_reference_ind) WHEN 'C' THEN 'STUNAI' WHEN 'P' THEN 'SPST' END MONTHNAME,sha_new_icno from mem_share where sha_new_icno='" + Txtnokp.Text + "' and sha_refund_ind='N' and year(sha_approve_dt) = '" + DropDownList4.SelectedValue + "' group by sha_reference_ind,sha_new_icno ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([STUNAI], [SPST]))AS PivotTable) as final )a full outer join (select * from (select isnull([FTUNAI],'') as FTUNAI,isnull([FPST],'') as FPST,fee_new_icno from (select SUM(fee_amount) as Tran_count, case (fee_payment_type_cd) WHEN 'C' THEN 'FTUNAI' WHEN 'P' THEN 'FPST' END MONTHNAME,fee_new_icno from mem_fee where fee_new_icno='860715235832' and fee_refund_ind='N' group by fee_payment_type_cd,fee_new_icno ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([FTUNAI], [FPST]))AS PivotTable) as final )b on b.fee_new_icno=a.sha_new_icno)b on A.mem_new_icno= '" + Txtnokp.Text + "' FULL OUTER JOIN (select ISNULL(CASE WHEN sha_approve_Dt = '1900-01-01 00:00:00.000' THEN '' ELSE sha_approve_Dt END, '') AS sha_approve_Dt, UPPER(sha_item) as sha_item,case(sha_reference_ind) when 'C' then 'TUNAI' when 'P' then 'PST' end as sha_reference_ind,sha_debit_amt,sha_credit_amt,Jumla=(sum(sha_debit_amt)-Sum(sha_credit_amt)),ms.sha_new_icno from mem_member AS mm left join Ref_Nama_Bank as bn ON mm.mem_bank_cd=bn.Bank_Code Left join mem_share AS ms ON ms.sha_new_icno = mm.mem_new_icno and ms.sha_refund_ind='N' and year(sha_approve_dt) = '" + DropDownList4.SelectedValue + "' group by sha_approve_Dt,sha_item,sha_reference_ind ,sha_debit_amt,sha_credit_amt,sha_new_icno )c on c.sha_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(CHAR(10), div_pay_dt, 105) as div_pay_dt,div_remark,Bank_Name,div_bank_acc_no,div_debit_amt,div_new_icno from mem_member AS mm left join Ref_Nama_Bank as bn ON mm.mem_bank_cd=bn.Bank_Code Left join mem_divident AS md ON md.div_new_icno = mm.mem_new_icno and year(md.div_pay_dt)='" + DropDownList4.SelectedValue + "') d on d.div_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(char(10),ast_end_date,105) as ast_end_date,ast_st_balance_amt,ast_monthly_collect_amt,ast_new_icno from aim_st ) e on e.ast_new_icno=a.mem_new_icno) where a.mem_new_icno='" + Txtnokp.Text + "'"); dt = DBCon.Ora_Execute_table("SELECT DISTINCT Format(fee_approval_dt, 'dd/MM/yyyy') fee_approval_dt,A.mem_member_no, A.mem_name, A.mem_address, A.mem_new_icno, ISNULL(CASE WHEN A.mem_phone_m = 'NULL' THEN '' else A.mem_phone_m END, '') as mem_phone_m, A.gender_desc, A.Bangsa_Name, A.Wilayah_Name, A.mem_centre, A.cawangan_name, A.mem_fee_amount, CONVERT(VARCHAR(10),GETDATE(),105) as cdate, B.ftunai,B.fpst,B.SPST,B.STUNAI,B.jumlah, Convert(CHAR(10),c.sha_txn_dt,105) as sha_approve_Dt, C.sha_item,C. sha_reference_ind,C. sha_debit_amt,C. sha_credit_amt,c.Jumla,d.div_pay_dt,d.div_remark,d.Bank_Name as bname,d.div_bank_acc_no,d.div_debit_amt,a.Applicant_Name,e.ast_end_date,e.ast_monthly_collect_amt,e.ast_st_balance_amt FROM ((select mem_member_no,mem_name,mem_address,mem_new_icno,mem_phone_m,rg.gender_desc,rb.Bangsa_Name,rw.Wilayah_Name,mm.mem_centre,mem_fee_amount,ra.Applicant_Name,br.branch_desc as cawangan_name from mem_member as mm Left join Ref_Wilayah AS rw ON mm.mem_region_cd = rw.Wilayah_Code Left join Ref_Cawangan AS rc ON mm.mem_area_cd=rc.kawasan_code left join Ref_Bangsa rb on rb.Bangsa_Code=mm.mem_race_cd left join ref_gender rg on rg.gender_cd=mm.mem_gender_cd Left join Ref_Applicant_Category ra on ra.Applicant_Code=mm.mem_applicant_type_cd left join ref_branch br on br.branch_cd=mm.mem_branch_cd where mm.Acc_sts='Y') a FULL OUTER JOIN (select b.FTUNAI,b.FPST,a.STUNAI,a.SPST, a.STUNAI + a.SPST as Jumlah,a.sha_new_icno,fee_approval_dt from (select * from (select isnull([STUNAI],'0.00') as STUNAI,isnull([SPST],'0.00') as SPST,sha_new_icno from (select SUM(ISNULL(sha_debit_amt,'0.00')) - sum(ISNULL(sha_credit_amt,'0.00')) as Tran_count, case (sha_reference_ind) WHEN 'C' THEN 'STUNAI' WHEN 'P' THEN 'SPST' END MONTHNAME,sha_new_icno from mem_share where sha_new_icno='" + Txtnokp.Text + "' and Acc_sts ='Y' and sha_refund_ind='N' group by sha_reference_ind,sha_new_icno ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([STUNAI], [SPST]))AS PivotTable) as final )a full outer join (select * from (select isnull([FTUNAI],'') as FTUNAI,isnull([FPST],'') as FPST,fee_new_icno,fee_approval_dt from (select SUM(fee_amount) as Tran_count, case (fee_payment_type_cd) WHEN 'C' THEN 'FTUNAI' WHEN 'P' THEN 'FPST' END MONTHNAME,fee_new_icno,fee_approval_dt from mem_fee where fee_new_icno='" + Txtnokp.Text + "' and Acc_sts ='Y' and fee_refund_ind='N' group by fee_payment_type_cd,fee_new_icno,fee_approval_dt ) as Games PIVOT(MIN(Tran_count) FOR MONTHNAME in ([FTUNAI], [FPST]))AS PivotTable) as final )b on b.fee_new_icno=a.sha_new_icno)b on A.mem_new_icno= '" + Txtnokp.Text + "' FULL OUTER JOIN (select ISNULL(CASE WHEN sha_txn_dt = '1900-01-01 00:00:00.000' THEN '' ELSE sha_txn_dt END, '') AS sha_txn_dt, UPPER(sha_item) as sha_item,case(sha_reference_ind) when 'C' then 'TUNAI' when 'P' then 'PST' end as sha_reference_ind,ISNULL(sha_debit_amt,'0.00')sha_debit_amt,ISNULL(sha_credit_amt,'0.00') sha_credit_amt,Jumla=(sum(ISNULL(sha_debit_amt,'0.00'))-Sum(ISNULL(sha_credit_amt,'0.00'))),ms.sha_new_icno from mem_member AS mm left join Ref_Nama_Bank as bn ON mm.mem_bank_cd=bn.Bank_Code Left join mem_share AS ms ON ms.sha_new_icno = mm.mem_new_icno and ms.Acc_sts ='Y' where mm.Acc_sts ='Y' and ms.sha_refund_ind='N' and year(sha_txn_dt) <= '" + DropDownList4.SelectedItem.Text + "' and ms.sha_new_icno='" + Txtnokp.Text + "' group by sha_txn_dt,sha_item,sha_reference_ind ,sha_debit_amt,sha_credit_amt,sha_new_icno )c on c.sha_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(CHAR(10), div_pay_dt, 105) as div_pay_dt,div_remark,Bank_Name,div_bank_acc_no,div_debit_amt,div_new_icno from mem_member AS mm Left join mem_divident AS md ON md.div_new_icno = mm.mem_new_icno left join Ref_Nama_Bank as bn ON md.div_bank_cd=bn.Bank_Code and md.Acc_sts ='Y' where md.div_approve_ind='SA' and mm.Acc_sts ='Y' and md.div_new_icno='" + Txtnokp.Text + "' and year(md.div_pay_dt) <='" + DropDownList4.SelectedItem.Text + "') d on d.div_new_icno=a.mem_new_icno FULL OUTER JOIN (select Convert(char(10),ast_end_date,105) as ast_end_date,ast_st_balance_amt,ast_monthly_collect_amt,ast_new_icno from aim_st ) e on e.ast_new_icno=a.mem_new_icno) where a.mem_new_icno='" + Txtnokp.Text + "' order by sha_approve_Dt desc"); if (DropDownList4.SelectedValue != "") { ss1 = DropDownList4.SelectedItem.Text; } if (ddlnegri.SelectedValue != "") { ss2 = ddlnegri.SelectedItem.Text; } RptviwerStudent.Reset(); ds.Tables.Add(dt); RptviwerStudent.LocalReport.DataSources.Clear(); //ReportDataSource RDS1 = new ReportDataSource("BANKSLIP", dt1); //ReportViewer1.ProcessingMode = ProcessingMode.Local; RptviwerStudent.LocalReport.ReportPath = "keanggotan/Report2.rdlc"; //ReportViewer1.LocalReport.DataSources.Add(RDS1); ReportDataSource rds = new ReportDataSource("list", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("pyear", ss1), new ReportParameter("negri", ss2), new ReportParameter("pscd", TextBox3.Text), new ReportParameter("app_dt", dt.Rows[0]["fee_approval_dt"].ToString()) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); //Refresh RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string devinfo = "<DeviceInfo><ColorDepth>32</ColorDepth><DpiX>350</DpiX><DpiY>350</DpiY><OutputFormat>PDF</OutputFormat>" + " <PageWidth>12.20in</PageWidth>" + " <PageHeight>8.27in</PageHeight>" + " <MarginTop>0.1in</MarginTop>" + " <MarginLeft>0.5in</MarginLeft>" + " <MarginRight>0in</MarginRight>" + " <MarginBottom>0in</MarginBottom>" + "</DeviceInfo>"; byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=myfile." + extension); Response.BinaryWrite(bytes); //Response.Write("<script>"); //Response.Write("window.open('', '_newtab');"); //Response.Write("</script>"); Response.Flush(); Response.End(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Sila Pilih Tahun');", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Medan Input Adalah Mandatori');", true); } } catch (Exception ex) { throw ex; } }
protected void ctk_values(object sender, EventArgs e) { string rcount = string.Empty; int count1 = 0; get_det(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = dbcon.Ora_Execute_table("select stf_staff_no,stf_name,stf_icno,clm_rec_dt,format(clm_rec_dt,'dd/MM/yyyy') clm_rec_dt1,ht.hr_tun_desc,clm_claim_amt,format(clm_rec_dt,'dd/MM/yyyy') clm_app_dt1,ISNULL(clm_app_sts,'') as sts,clm_claim_cd,file_name,case when ISNULL(clm_app_sts,'') = '' then 'PENDING' when ISNULL(clm_app_sts,'') = '01' then 'SAH' when ISNULL(clm_app_sts,'')='02' then 'TIDAK SAH' end as sts_desc,case when ISNULL(clm_approve_sts_cd,'') = '' then 'PENDING' when ISNULL(clm_approve_sts_cd,'') = '01' then 'SAH' when ISNULL(clm_approve_sts_cd,'')='02' then 'TIDAK SAH' end as sts_desc1,clm_balance_amt,clm_sebap from hr_claim_new left join hr_staff_profile sp on sp.stf_staff_no=clm_staff_no left join Ref_hr_tuntutan ht on ht.hr_tun_Code=clm_claim_cd " + sqry + ""); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/pen_tuntutan.rdlc"; ReportDataSource rds = new ReportDataSource("hrpentut", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("s1", txt_tahun.SelectedItem.Text), new ReportParameter("s2", DD_bulancaruman.SelectedItem.Text) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; if (sel_frmt.SelectedValue == "01") { filename = string.Format("{0}.{1}", "STATUS_TUNTUTAN_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (sel_frmt.SelectedValue == "02") { System.Text.StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "STATUS_TUNTUTAN_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("No Kakitangan ,Ic No,Nama Kakitangan, Reciept Date, Apply Date, Jenis Tuntutan, clm_sebap, Amaun (RM), Baki / Jumlah Terkini (RM), Status Kelulusan, Status Pengesahan" + Environment.NewLine); foreach (GridViewRow row in gvSelected.Rows) { string stfno = ((Label)row.FindControl("Label2")).Text.ToString(); string icno = ((Label)row.FindControl("Label3")).Text.ToString(); string name = ((Label)row.FindControl("Label2_name")).Text.ToString(); string rec_dt = ((Label)row.FindControl("Label2_yr")).Text.ToString(); string app_dt = ((Label)row.FindControl("Label4")).Text.ToString(); string jenis = ((Label)row.FindControl("Label5")).Text.ToString(); string amt = ((Label)row.FindControl("Label6_amt")).Text.ToString(); string amt1 = ((Label)row.FindControl("Label6_amt1")).Text.ToString(); string sts = ((Label)row.FindControl("Label5_sts")).Text.ToString(); string sts1 = ((Label)row.FindControl("Label5_sts1")).Text.ToString(); string sebab = ((Label)row.FindControl("Label4_seb")).Text.ToString(); builder.Append(stfno + "," + icno + "," + name + "," + rec_dt + "," + app_dt + "," + jenis + "," + sebab + "," + amt.Replace(",", "") + "," + amt1.Replace(",", "") + "," + sts + "," + sts1 + Environment.NewLine); } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } //else if (sel_frmt.SelectedValue == "03") //{ // byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings); // filename = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc"); // Response.Buffer = true; // Response.Clear(); // Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); // Response.ContentType = mimeType; // Response.BinaryWrite(bytes); // Response.Flush(); // Response.End(); //} } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } grid(); }
protected void ctk_values(object sender, EventArgs e) { string stdt = string.Empty, eddt = string.Empty; if (TextBox1.Text != "") { DateTime dt_1 = DateTime.ParseExact(TextBox1.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); stdt = dt_1.ToString("yyyy-MM-dd"); } if (TextBox3.Text != "") { DateTime dt_2 = DateTime.ParseExact(TextBox3.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); eddt = dt_2.ToString("yyyy-MM-dd"); } DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = dbcon.Ora_Execute_table("select FORMAT(a.cap_start_dt,'dd/MM/yyyy') as dt1,FORMAT(a.cap_end_dt,'dd/MM/yyyy') as dt2,a.cap_post_cat_cd,a.cap_unit_cd,a.cap_section_cd,a.cap_subject_cd,a.cap_seq_no,cas.cse_section_desc,cs.csb_subject_desc,a.cap_weightage,c1.hr_jaw_desc,c2.hr_unit_desc from (select * from hr_cmn_appraisal as ca where ca.cap_start_dt>=DATEADD(day, DATEDIFF(day, 0, '" + stdt + "'), 0) and ca.cap_start_dt<=DATEADD(day, DATEDIFF(day, 0, '" + eddt + "'), +0) and ca.cap_post_cat_cd ='" + ddkat_jaw.SelectedValue + "' and ca.cap_unit_cd ='" + dd_unit.SelectedValue + "') a left join hr_cmn_appr_section as cas on cas.cse_section_cd=a.cap_section_cd left join hr_cmn_subject as cs on cs.csb_subject_cd=a.cap_subject_cd left join Ref_hr_Jawatan c1 on c1.hr_jaw_Code=a.cap_post_cat_cd left join Ref_hr_unit c2 on c2.hr_unit_Code=a.cap_unit_cd"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/HR_pen_pertasi.rdlc"; ReportDataSource rds = new ReportDataSource("HR_pen_pertasi", dt); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; filename = string.Format("{0}.{1}", "JANA_DOKUMEN_PENILAIAN_PRESTASI_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul',{'type': 'warning','title': 'Warning','auto_close': 2000});", true); } }
protected void pdf_Click(object sender, EventArgs e) { try { sql_info(); DataTable dt = new DataTable(); dt = DBCon.Ora_Execute_table(val1); //Reset RptviwerStudent.Reset(); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); if (countRow != 0) { // Label1.Text = ""; //Label2.Text = ""; ReportDataSource rds = new ReportDataSource("lapkursus", dt); RptviwerStudent.LocalReport.DataSources.Add(rds); //Path RptviwerStudent.LocalReport.ReportPath = "SUMBER_MANUSIA/lap_kursus.rdlc"; //ToDate.Text = today.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture); //Parameters ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("d1", tm_date.Text), new ReportParameter("d2", ta_date.Text), new ReportParameter("d3", ""), new ReportParameter("d4", ""), new ReportParameter("d5", "") }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DisplayName = "LAPORAN_KURSUS_" + DateTime.Now.ToString("ddMMyyyy"); //Refresh RptviwerStudent.LocalReport.Refresh(); string filename = string.Format("{0}.{1}", "LAPORAN_KURSUS_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); //} Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Tiada Rekod Dijumpai Dalam Julat Tarikh Yang Dimasukkan.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } catch (Exception ex) { //Label2.Text = ex.ToString(); } string script1 = "$(function () { $('[id*=GridView1]').prepend($('<thead></thead>').append($(this).find('tr:first'))).DataTable({ 'responsive': true, 'sPaginationType': 'full_numbers' }); });"; ScriptManager.RegisterStartupScript(this, this.GetType(), "", script1, true); }
void gen_barcode() { try { DataSet ds = new DataSet(); DataTable dt = new DataTable(); //dt = DBCon.Ora_Execute_table("select ho.org_name,rk.ast_kategori_desc,rja.ast_jeniaset_desc,aca.cas_asset_desc,a.sas_asset_id,a.sas_curr_price_amt,a.sas_asset_cat_cd,a.sas_asset_sub_cat_cd,a.sas_asset_type_cd,a.sas_asset_cd,a.sas_org_id, case a.sas_asset_cat_cd when '01' then (select FORMAT(com_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_component where com_asset_cat_cd=a.sas_asset_cat_cd and com_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and com_asset_type_cd=a.sas_asset_type_cd and com_asset_cd=a.sas_asset_cd) when '02' then (select FORMAT(car_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_car where car_asset_cat_cd=a.sas_asset_cat_cd and car_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and car_asset_type_cd=a.sas_asset_type_cd and car_asset_cd=a.sas_asset_cd) when '03' then (select FORMAT(inv_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_inventory where inv_asset_cat_cd=a.sas_asset_cat_cd and inv_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and inv_asset_type_cd=a.sas_asset_type_cd and inv_asset_cd=a.sas_asset_cd) end as a1, case a.sas_asset_cat_cd when '01' then (select DATEDIFF(day,com_reg_dt,GETDATE()) as u_dt from ast_component where com_asset_cat_cd=a.sas_asset_cat_cd and com_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and com_asset_type_cd=a.sas_asset_type_cd and com_asset_cd=a.sas_asset_cd) when '02' then (select DATEDIFF(day,car_reg_dt,GETDATE()) as u_dt from ast_car where car_asset_cat_cd=a.sas_asset_cat_cd and car_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and car_asset_type_cd=a.sas_asset_type_cd and car_asset_cd=a.sas_asset_cd) when '03' then (select DATEDIFF(day,inv_reg_dt,GETDATE()) as u_dt from ast_inventory where inv_asset_cat_cd=a.sas_asset_cat_cd and inv_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and inv_asset_type_cd=a.sas_asset_type_cd and inv_asset_cd=a.sas_asset_cd) end as a2, case a.sas_asset_cat_cd when '01' then (select com_price_amt from ast_component where com_asset_cat_cd=a.sas_asset_cat_cd and com_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and com_asset_type_cd=a.sas_asset_type_cd and com_asset_cd=a.sas_asset_cd) when '02' then (select car_price_amt from ast_car where car_asset_cat_cd=a.sas_asset_cat_cd and car_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and car_asset_type_cd=a.sas_asset_type_cd and car_asset_cd=a.sas_asset_cd) when '03' then (select inv_price_amt from ast_inventory where inv_asset_cat_cd=a.sas_asset_cat_cd and inv_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and inv_asset_type_cd=a.sas_asset_type_cd and inv_asset_cd=a.sas_asset_cd) end as a3 from (select * from ast_staff_asset where sas_cond_sts_cd = 'DI' and sas_dispose_cfm_ind !='Y') as a left join Ref_ast_kategori as rk on rk.ast_kategori_code=a.sas_asset_cat_cd left join Ref_ast_jenis_aset as rja on rja.ast_jeniaset_Code=a.sas_asset_type_cd left join ast_cmn_asset as aca on aca.cas_asset_cd=a.sas_asset_cd left join hr_organization as ho on ho.org_gen_id=a.sas_org_id"); dt = DBCon.Ora_Execute_table("select sas_asset_id,sas_asset_cat_cd,sas_asset_sub_cat_cd,sas_asset_type_cd,sas_asset_cd,sas_location_cd,s1.ast_jeniaset_desc from ast_staff_asset left join Ref_ast_jenis_aset as s1 on s1.ast_jeniaset_Code=sas_asset_type_cd and s1.ast_sub_cat_Code=sas_asset_sub_cat_cd where sas_asset_id='" + lblid1 + "' order by sas_crt_dt desc"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "Aset/Ast_Barcode.rdlc"; ReportDataSource rds = new ReportDataSource("Bcode", dt); string bar_code = dt.Rows[0]["sas_asset_id"].ToString(); string ast_type = dt.Rows[0]["ast_jeniaset_desc"].ToString(); string ast_cd = dt.Rows[0]["sas_asset_cd"].ToString(); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("bcode", bar_code), new ReportParameter("asttype", ast_type), new ReportParameter("astcd", ast_cd) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; filename = string.Format("{0}.{1}", "Barcode_" + bar_code.ToUpper() + "_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); //string script = " $(function () {$(" + GridView1.ClientID + ").prepend($('<thead></thead>').append($(this).find('tr:first'))).DataTable({'responsive': true,'sPaginationType': 'full_numbers', 'iDisplayLength': 15,'aLengthMenu': [[15, 30, 50, 100], [15, 30, 50, 100]]});});"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "", script, true); } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } catch { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Issue.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } }
protected void ctk_values(object sender, EventArgs e) { string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, ss6 = string.Empty, ss7 = string.Empty, ss8 = string.Empty, ss9 = string.Empty, ss10 = string.Empty, ss11 = string.Empty; DataSet ds1 = new DataSet(); DataTable dt = new DataTable(); DataTable dh = new DataTable(); DataTable dh1 = new DataTable(); bind_details(); dt = Dbcon.Ora_Execute_table(sqry); ds1.Tables.Add(dt); RptviwerStudent.Reset(); RptviwerStudent.LocalReport.Refresh(); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); if (countRow != 0) { //ss1_stap1.Visible = true; DataTable get_pfl = new DataTable(); get_pfl = DBCon.Ora_Execute_table("select syar_logo from KW_Profile_syarikat where cur_sts='1' and Status='A'"); string imagePath = string.Empty; if (get_pfl.Rows[0]["syar_logo"].ToString() != "") { imagePath = new Uri(Server.MapPath("~/FILES/Profile_syarikat/" + get_pfl.Rows[0]["syar_logo"].ToString() + "")).AbsoluteUri; } else { imagePath = new Uri(Server.MapPath("~/FILES/Profile_syarikat/user.png")).AbsoluteUri; } RptviwerStudent.LocalReport.EnableExternalImages = true; RptviwerStudent.LocalReport.DataSources.Clear(); ReportDataSource rds = new ReportDataSource("Imbungan", dt); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.ReportPath = "kewengan/Kw_Imbungan.rdlc"; // string branch; ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("d1", DropDownList1.SelectedItem.Text), new ReportParameter("d2", kat_bajet.SelectedItem.Text), new ReportParameter("d3", imagePath) }; RptviwerStudent.LocalReport.SetParameters(rptParams); //Refresh RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attatchment; filename=MAKLUMAT_PERIBADI_ANGGOTA." + extension); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } }
void grid() { clk_jana(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = dbcon.Ora_Execute_table("select ISNULL(ho.org_name,'') as org_name,rak.ast_kategori_desc,rsk.ast_subkateast_desc,ja.ast_jeniaset_desc,b.amt1 from (select dis_org_id,dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd from ast_dispose where " + vv1 + " group by dis_org_id,dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd) as asa left join Ref_ast_kategori as rak on rak.ast_kategori_code=asa.dis_asset_cat_cd left join Ref_ast_sub_kategri_Aset as rsk on rsk.ast_subkateast_Code=asa.dis_asset_sub_cat_cd left join Ref_ast_jenis_aset as ja on ja.ast_jeniaset_Code=asa.dis_asset_type_cd left join hr_organization as ho on ho.org_gen_id=asa.dis_org_id full outer join (select dis_org_id,dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd,sum(dis_purchase_amt) as amt1 from ast_dispose where " + vv1 + " group by dis_asset_cat_cd,dis_asset_sub_cat_cd,dis_asset_type_cd,dis_org_id) as b on b.dis_org_id=asa.dis_org_id and b.dis_asset_cat_cd=asa.dis_asset_cat_cd and b.dis_asset_sub_cat_cd=asa.dis_asset_sub_cat_cd and b.dis_asset_type_cd=asa.dis_asset_type_cd"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, ss6 = string.Empty; if (DD_Kategori.SelectedValue != "") { ss1 = DD_Kategori.SelectedItem.Text.ToUpper(); } else { ss1 = "SEMUA"; } if (DD_Sub_Kateg.SelectedValue != "") { ss2 = DD_Sub_Kateg.SelectedItem.Text.ToUpper(); } else { ss2 = "SEMUA"; } if (DD_Jenis_ast.SelectedValue != "") { ss3 = DD_Jenis_ast.SelectedItem.Text.ToUpper(); } else { ss3 = "SEMUA"; } if (DD_NAMAAST.SelectedValue != "") { ss4 = DD_NAMAAST.SelectedItem.Text.ToUpper(); } else { ss4 = "SEMUA"; } if (DD_organ.SelectedValue != "") { ss5 = DD_organ.SelectedItem.Text.ToUpper(); } else { ss5 = "SEMUA"; } if (dd_pel.SelectedValue != "") { ss6 = dd_pel.SelectedItem.Text.ToUpper(); } else { ss6 = "SEMUA"; } RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { disp_hdr_txt.Visible = true; RptviwerStudent.LocalReport.ReportPath = "Aset/AST_Laporannayd.rdlc"; ReportDataSource rds = new ReportDataSource("astlastlaporannaydapnamo", dt); ReportParameter[] rptParams = new ReportParameter[] { //new ReportParameter("fromDate",FromDate .Text ), //new ReportParameter("toDate",ToDate .Text ) new ReportParameter("s7", txt_dar.Text), new ReportParameter("s8", txt_seh.Text), new ReportParameter("s1", ss1), new ReportParameter("s2", ss2), new ReportParameter("s3", ss3), new ReportParameter("s4", ss4), new ReportParameter("s5", ss5), new ReportParameter("s6", ss6) }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.DisplayName = "Laporan_Nilai_Keseluruhan_Aset_" + DateTime.Now.ToString("ddMMyyyy"); RptviwerStudent.LocalReport.Refresh(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } }
protected void ctk_values(object sender, EventArgs e) { if (txt_dar.Text != "" && txt_seh.Text != "") { DataSet ds = new DataSet(); DataTable dt = new DataTable(); string rcount = string.Empty, rcount1 = string.Empty; int count = 0; double sum = 0; dt.Columns.AddRange(new DataColumn[4] { new DataColumn("nast"), new DataColumn("qnty"), new DataColumn("ast_id"), new DataColumn("ns_rm") }); foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[4].FindControl("chkRow") as CheckBox); if (chkRow.Checked) { string naset = (row.Cells[1].FindControl("Label3") as Label).Text; string qty = (row.Cells[2].FindControl("Label2") as Label).Text; string aid = (row.Cells[3].FindControl("Label1") as Label).Text; string ns = (row.Cells[4].FindControl("Label7") as Label).Text; dt.Rows.Add(naset, qty, aid, ns); count++; double amount = Convert.ToDouble((row.Cells[4].FindControl("Label7") as Label).Text); sum += amount; } rcount = count.ToString(); rcount1 = sum.ToString("0.00"); } } string vv1 = string.Empty; if (DD_nama.SelectedValue != "") { vv1 = DD_nama.SelectedItem.Text; } //dt = dbcon.Ora_Execute_table("" + mqry + ""); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (rcount != "0") { RptviwerStudent.LocalReport.ReportPath = "Aset/AST_Hadiah.rdlc"; ReportDataSource rds = new ReportDataSource("asthadiah", dt); ReportParameter[] rptParams = new ReportParameter[] { new ReportParameter("tot_amt", rcount1), new ReportParameter("h1", txt_dar.Text), new ReportParameter("h2", txt_seh.Text), new ReportParameter("h3", TextBox2.Text), new ReportParameter("h4", TextBox1.Text), new ReportParameter("h5", vv1), new ReportParameter("h6", TextBox3.Text), new ReportParameter("h7", TextBox4.Text), //new ReportParameter("h8",TextBox4.Text ), }; RptviwerStudent.LocalReport.SetParameters(rptParams); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; if (sel_frmt.SelectedValue == "01") { filename = string.Format("{0}.{1}", "Pendaftaran_Maklumat_Hadiah_" + DateTime.Now.ToString("ddMMyyyy") + ".", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (sel_frmt.SelectedValue == "02") { StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "LAPORAN_NILAI_ASET_YANG" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("Nama Aset,Kuantiti,Nilai Semasa (RM)" + Environment.NewLine); foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[4].FindControl("chkRow") as CheckBox); if (chkRow.Checked) { string nast = ((Label)row.FindControl("Label3")).Text.ToString(); string qty = ((Label)row.FindControl("Label2")).Text.ToString(); string kb = ((Label)row.FindControl("Label7")).Text.ToString(); builder.Append(nast + "," + qty + "," + kb + Environment.NewLine); } } } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } else if (sel_frmt.SelectedValue == "03") { byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings); filename = string.Format("{0}.{1}", "LAPORAN_NILAI_ASET_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc"); Response.Buffer = true; Response.Clear(); Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); Response.ContentType = mimeType; Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Masukan Maklumat.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } }
protected void ctk_values(object sender, EventArgs e) { string rcount = string.Empty; int count1 = 0; foreach (GridViewRow gvrow in gvSelected.Rows) { var rb = gvrow.FindControl("RadioButton1") as System.Web.UI.WebControls.RadioButton; if (rb.Checked) { count1++; } rcount = count1.ToString(); } if (rcount != "0") { DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = dbcon.Ora_Execute_table("select ISNULL(ho.org_name,'') as org_name,ISNULL(dd.dis_dispose_type_cd,'') as dis_dispose_type_cd,rk.ast_kategori_desc,ISNULL(kk.kaedah_desc,'') kaedah_desc,rja.ast_jeniaset_desc,aca.cas_asset_desc,a.sas_asset_id,a.sas_curr_price_amt, a.sas_asset_cat_cd,a.sas_asset_sub_cat_cd,a.sas_asset_type_cd,a.sas_asset_cd,a.sas_org_id, case a.sas_asset_cat_cd when '01' then (select FORMAT(com_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_component where com_asset_id=a.sas_asset_id) when '02' then (select FORMAT(car_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_car where car_asset_id=a.sas_asset_id) when '04' then (select FORMAT(pro_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_property where pro_asset_id=a.sas_asset_id) when '03' then (select FORMAT(inv_reg_dt,'dd/MM/yyyy', 'en-us') as reg_dt from ast_inventory where inv_asset_id=a.sas_asset_id) end as a1, case a.sas_asset_cat_cd when '01' then (select DATEDIFF(day,com_reg_dt,GETDATE()) as u_dt from ast_component where com_asset_id=a.sas_asset_id) when '02' then (select DATEDIFF(day,car_reg_dt,GETDATE()) as u_dt from ast_car where car_asset_id=a.sas_asset_id) when '04' then (select DATEDIFF(day,pro_reg_dt,GETDATE()) as u_dt from ast_property where pro_asset_id=a.sas_asset_id) when '03' then (select DATEDIFF(day,inv_reg_dt,GETDATE()) as u_dt from ast_inventory where inv_asset_id=a.sas_asset_id) end as a2, case a.sas_asset_cat_cd when '01' then (select com_price_amt from ast_component where com_asset_id=a.sas_asset_id) when '02' then (select car_price_amt from ast_car where car_asset_id=a.sas_asset_id) when '04' then (select pro_buy_amt from ast_property where pro_asset_id=a.sas_asset_id) when '03' then (select inv_price_amt from ast_inventory where inv_asset_id=a.sas_asset_id) end as a3 from (select * from ast_staff_asset where sas_dispose_cfm_ind !='Y' or sas_dispose_cfm_ind IS NULL and sas_cond_sts_cd = '03') as a left join Ref_ast_kategori as rk on rk.ast_kategori_code=a.sas_asset_cat_cd left join Ref_ast_jenis_aset as rja on rja.ast_jeniaset_Code=a.sas_asset_type_cd left join ast_cmn_asset as aca on aca.cas_asset_cd=a.sas_asset_cd and aca.cas_asset_cat_cd=a.sas_asset_cat_cd and aca.cas_asset_sub_cat_cd=a.sas_asset_sub_cat_cd and aca.cas_asset_type_cd=a.sas_asset_type_cd left join hr_organization as ho on ho.org_gen_id=a.sas_org_id left join ast_dispose as dd on dd.dis_asset_id=a.sas_asset_id left join Ref_ast_kaedah_palupusan as kk on kk.kaedah_id=dd.dis_dispose_type_cd"); RptviwerStudent.Reset(); ds.Tables.Add(dt); List <DataRow> listResult = dt.AsEnumerable().ToList(); listResult.Count(); int countRow = 0; countRow = listResult.Count(); RptviwerStudent.LocalReport.DataSources.Clear(); if (countRow != 0) { RptviwerStudent.LocalReport.ReportPath = "Aset/ast_prp.rdlc"; ReportDataSource rds = new ReportDataSource("astprp", dt); RptviwerStudent.LocalReport.DataSources.Add(rds); RptviwerStudent.LocalReport.Refresh(); Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; if (sel_frmt.SelectedValue == "01") { filename = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "pdf"); byte[] bytes = RptviwerStudent.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=" + filename); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } else if (sel_frmt.SelectedValue == "02") { StringBuilder builder = new StringBuilder(); string strFileName = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "csv"); builder.Append("Organisation ,Kategori Aset,Jenis Aset, Nama Aset, Aset ID, Tarikh Perolehan, Usia Aset, Nilai Perolehan (RM), Nilai Semasa (RM), Kaedah Pelupusan" + Environment.NewLine); foreach (GridViewRow row in gvSelected.Rows) { string oname = ((Label)row.FindControl("Label3")).Text.ToString(); string kaset = ((Label)row.FindControl("Label2")).Text.ToString(); string jaset = ((Label)row.FindControl("Label6")).Text.ToString(); string naset = ((Label)row.FindControl("Label7")).Text.ToString(); string asid = ((Label)row.FindControl("Label8")).Text.ToString(); string tp = ((Label)row.FindControl("Label9")).Text.ToString(); string ua = ((Label)row.FindControl("Label10")).Text.ToString(); string np = ((Label)row.FindControl("Label11")).Text.ToString(); string ns = ((Label)row.FindControl("Label12")).Text.ToString(); string kp = ((DropDownList)row.FindControl("dd_lab1")).SelectedItem.Text.ToString(); builder.Append(oname + "," + kaset + "," + jaset + "," + naset + "," + asid + "," + tp + "," + ua + "," + np + "," + ns + "," + kp + Environment.NewLine); } Response.Clear(); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName); Response.Write(builder.ToString()); Response.End(); } //else if (sel_frmt.SelectedValue == "03") //{ // byte[] bytes = RptviwerStudent.LocalReport.Render("Word", null, out mimeType, out encoding, out extension, out streamids, out warnings); // filename = string.Format("{0}.{1}", "PENDAFTARAN_REKOD_" + DateTime.Now.ToString("ddMMyyyy") + "", "doc"); // Response.Buffer = true; // Response.Clear(); // Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); // Response.ContentType = mimeType; // Response.BinaryWrite(bytes); // Response.Flush(); // Response.End(); //} } else if (countRow == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod tidak dijumpai. Sila Pastikan Semua Maklumat Dimasukkan Dengan Betul.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } } else { BindGrid(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Sila Pilih Rekod Yang Ingin Dihapuskan.',{'type': 'warning','title': 'warning','auto_close': 2000});", true); } string script = " $(function () {$(" + gvSelected.ClientID + ") .prepend($('<thead></thead>').append($(this).find('tr:first'))).DataTable({'responsive': true,'sPaginationType': 'full_numbers', 'iDisplayLength': 15,'aLengthMenu': [[15, 30, 50, 100], [15, 30, 50, 100]]});});"; ScriptManager.RegisterStartupScript(this, this.GetType(), "", script, true); }