protected void btnHuyNhan_Click(object sender, EventArgs e) { SYS_Session session = (SYS_Session)Session["SYS_Session"]; string strMadviqly = session.User.ma_dviqly; DM_DVQLYService isyOrganizationService = new DM_DVQLYService(); Entity.DM_DVQLY sysOrganization = new Entity.DM_DVQLY(); sysOrganization = isyOrganizationService.SelectDM_DVQLY(int.Parse(strMadviqly)); if (rdImportDuLieu.SelectedIndex == 0) { } else { var lstData = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == sysOrganization.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "")); string tenfile = ""; foreach (var a in lstData) { tenfile = a.TENFILE; break; } Class.XuatXML_GCS class_xuatso = new Class.XuatXML_GCS(); DataSet ds = new DataSet(); CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable(); DataTable dt = cv.ConvertToDataTable(lstData.ToList()); dt.Columns.Remove("TENFILE"); dt.Columns.Remove("TrangThaiDongBo"); ds.Tables.Add(dt); string strXML = class_xuatso.HTML_XuatFileCMIS(); string strXML1 = ds.GetXml(); //strXML1 = strXML1.Replace(",", "."); strXML1 = strXML1.Replace("<NewDataSet>", ""); strXML1 = strXML1.Replace("</NewDataSet>", ""); strXML1 = strXML1.Replace("<Table>", "<Table1>"); strXML1 = strXML1.Replace("</Table>", "</Table1>"); strXML += strXML1 + "</NewDataSet>"; string attachment = "attachment;filename=" + tenfile + ".XML"; Response.ClearContent(); Response.ContentType = "application/xml"; Response.AddHeader("content-disposition", attachment); Response.Write(strXML); Response.End(); } }
private void DN_TK_ThuongPham_New() { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int ma_dviqly = int.Parse(session.User.ma_dviqly); DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var donvi = dm_dviSer.SelectDM_DVQLY(int.Parse(Request["DonVi"] + "")); int thangtr, namtr, thangN2, namN2; if (Request["Thang"] + "" == "1") { thangtr = 12; namtr = int.Parse(Request["Nam"] + "") - 1; thangN2 = 11; namN2 = int.Parse(Request["Nam"] + "") - 1; } else if (Request["Thang"] + "" == "2") { thangtr = 1; namtr = int.Parse(Request["Nam"] + ""); thangN2 = 12; namN2 = int.Parse(Request["Nam"] + "") - 1; } else { thangtr = int.Parse(Request["Thang"] + "") - 1; namtr = int.Parse(Request["Nam"] + ""); thangN2 = int.Parse(Request["Thang"] + "") - 2; namN2 = int.Parse(Request["Nam"] + ""); } //DataTable dt = dbOR.DN_TK_ThucTeTCT(int.Parse(Request["Thang"] + ""), int.Parse(Request["Nam"] + ""), thangtr, namtr, thangN2, namN2, int.Parse(Request["TuNgay"] + ""), int.Parse(Request["DenNgay"] + "")); CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable(); var tk = db.DN_TK_ThucTeTCT(int.Parse(Request["Thang"] + ""), int.Parse(Request["Nam"] + ""), thangtr, namtr, thangN2, namN2, int.Parse(Request["TuNgay"] + ""), int.Parse(Request["DenNgay"] + "")); DataTable dt = cv.ConvertToDataTable(tk.ToList()); MTCSYT.Report.InDN_ThuongPhamTCT report = new MTCSYT.Report.InDN_ThuongPhamTCT(dt, "" + Request["Thang"], "" + Request["Nam"], donvi.TEN_DVIQLY, int.Parse(Request["DonVi"] + "")); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }
private void DN_TK_KeHoach() { MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"]; int ma_dviqly = int.Parse(session.User.ma_dviqly); DM_DVQLYService dm_dviSer = new DM_DVQLYService(); var donvi = dm_dviSer.SelectDM_DVQLY(ma_dviqly); //DataTable dt = dbOR.DN_TK_DNKeHoach(int.Parse(session.User.ma_dviqly), int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"]), int.Parse(Request["Ngay"] + "")); CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable(); var tk = db.DN_TK_DNKeHoach(int.Parse(session.User.ma_dviqly), int.Parse("" + Request["Thang"]), int.Parse("" + Request["Nam"]), int.Parse(Request["Ngay"] + "")); DataTable dt = cv.ConvertToDataTable(tk.ToList()); MTCSYT.Report.InDN_DuKien report = new MTCSYT.Report.InDN_DuKien(dt, "" + Request["Thang"], "" + Request["Nam"], Request["Ngay"], donvi.TEN_DVIQLY); ReportViewer1.Report = report; ReportToolbar1.ReportViewer = ReportViewer1; }