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;
}
