public JsonResult Ds_DonVi(string ParentID, string PhongBan, string TuThang, string DenThang, string iID_MaDonVi) { String MaND = User.Identity.Name; DataTable dt = QuyetToan_ReportModels.QTQS_DSDonVi(PhongBan, TuThang, DenThang, MaND); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult Ds_DonVi(String ParentID, String Nganh, String ToSo, String sLNS, String iID_MaPhongBan) { String MaND = User.Identity.Name; if(String.IsNullOrEmpty(ToSo)) ToSo = "1"; DataTable dt = DanhSachToIn(MaND, Nganh, "1", sLNS, iID_MaPhongBan); if (String.IsNullOrEmpty(ToSo)) { ToSo = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/To_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, ToSo, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
/// <summary> /// Lấy danh sách loại ngân sách dựa vào đợt cấp phát, loại thông tri, phòng ban /// </summary> /// <param name="ParentID"></param> /// <param name="iNamCapPhat">Đợt cấp phát</param> /// <param name="LoaiThongTri">Loại thông tri</param> /// <param name="sLNS">Loại ngân sách</param> /// <param name="iID_MaPhongBan">Mã phòng ban</param> /// <returns></returns> public JsonResult LayDanhSachLNS(String ParentID, String iNamCapPhat, String LoaiThongTri, String sLNS, String iID_MaPhongBan) { String MaND = User.Identity.Name; String sViewPath = "~/Views/DungChung/DonVi/LNS_DanhSach_ThongTri.ascx"; DataTable dt = CapPhat_ReportModels.LayDtLoaiThongTri_LNS(iNamCapPhat, MaND, LoaiThongTri, iID_MaPhongBan); if (String.IsNullOrEmpty(sLNS)) { sLNS = Guid.Empty.ToString(); } DanhSachDonViModels Model = new DanhSachDonViModels(MaND, sLNS, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(sViewPath, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public String obj_DonVi(String ParentID, String Thang_Quy, String sLNS, String iID_MaDonVi, String iID_MaTrangThaiDuyet,String MaND) { DataTable dt = LayDSDonVi(Thang_Quy, sLNS, iID_MaTrangThaiDuyet,MaND); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam="~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model= new DanhSachDonViModels(MaND,iID_MaDonVi,dt,""); String strDonVi=HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); //SelectOptionList sldonvi = new SelectOptionList(dt, "iID_MaDonVi", "sTen"); // String strDonVi = MyHtmlHelper.DropDownList(ParentID, sldonvi, iID_MaDonVi, "iID_MaDonVi", "", "class=\"input1_2\" style=\"width: 100%\""); return strDonVi; }
public JsonResult Ds_DonVi(String ParentID, String NamLamViec, String LoaiThangQuy, String Thang_Quy, String iID_MaDonVi, String iID_MaTrangThaiDuyet) { String MaND = User.Identity.Name; DataTable dt = LayDSDonVi(NamLamViec, LoaiThangQuy, Thang_Quy, iID_MaTrangThaiDuyet); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, "rptBH_Chi_ThongTri_72_2"); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); // return Json(obj_DonVi(ParentID, NamLamViec, LoaiThangQuy, Thang_Quy, iID_MaDonVi, iID_MaTrangThaiDuyet), JsonRequestBehavior.AllowGet); }
public JsonResult Ds_DonVi(String ParentID, String iID_MaDonVi,String BaoCao, String MaTo) { String MaND = User.Identity.Name; if (String.IsNullOrEmpty(iID_MaDonVi)) iID_MaDonVi = "1"; DataTable dt = DanhSachBaoCao(MaND, iID_MaDonVi, MaTo); String ViewNam = "~/Views/DungChung/DonVi/BaoCao_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, BaoCao, dt, ParentID); dt.Dispose(); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult Ds_DonVi(String ParentID, String iID_MaDonVi) { String MaND = User.Identity.Name; DataTable dt = TCSN_DoanhNghiepModels.Get_ListDoanhNghiep(); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult Ds_DonVi(String ParentID, String iQuy, String sLNS, String iID_MaDonVi, String iID_MaTrangThaiDuyet) { String MaND = User.Identity.Name; DataTable dt = LayDSDonVi(iQuy, sLNS, iID_MaTrangThaiDuyet, MaND); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, "rptQuyetToan_ThongTri_5_Nganh"); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult ds_NhomDonVi(String ParentID, String iID_MaTrangThaiDuyet, String Thang_Quy, String LoaiThang_Quy, String iID_MaDonVi, String iID_MaDanhMuc) { String MaND = User.Identity.Name; NhomDonViData _data = new NhomDonViData(); DataTable dtNhomDonVi = DanhSachNhomDonVi(iID_MaTrangThaiDuyet, Thang_Quy, LoaiThang_Quy, MaND); SelectOptionList slNhomDonVi = new SelectOptionList(dtNhomDonVi, "iID_MaDanhMuc", "TenDM"); _data.iID_MaDanhMuc = MyHtmlHelper.DropDownList(ParentID, slNhomDonVi, iID_MaDanhMuc, "iID_MaDanhMuc", "", "class=\"input1_2\" style=\"width: 50%\" onChange=ChonDV()"); if (iID_MaDanhMuc == "undefined") { iID_MaDanhMuc = Guid.Empty.ToString(); } dtNhomDonVi.Dispose(); DataTable dtDonVi = DanhSachDonVi(iID_MaTrangThaiDuyet, Thang_Quy, LoaiThang_Quy, iID_MaDanhMuc, MaND); String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dtDonVi, ""); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); _data.iID_MaDonVi = strDonVi; dtDonVi.Dispose(); return Json(_data, JsonRequestBehavior.AllowGet); }
/// <summary> /// onchange /// </summary> /// <param name="ParentID"></param> /// <param name="sLNS"></param> /// <param name="NamLamViec"></param> /// <param name="iID_MaDotPhanBo"></param> /// <param name="iID_MaDonVi"></param> /// <returns></returns> public JsonResult ds_DotPhanBo(String ParentID, String sLNS, String MaND, String iID_MaTrangThaiDuyet, String iID_MaDotPhanBo, String iID_MaDonVi,String iThongBao) { LNSdata _LNSdata = new LNSdata(); #region Đợt phân bổ DataTable dtDotPhanBo = PhanBo_ReportModels.LayDSDotPhanBo2(MaND, iID_MaTrangThaiDuyet, sLNS); SelectOptionList slPhanBo = new SelectOptionList(dtDotPhanBo, "iID_MaDotPhanBo", "dNgayDotPhanBo"); _LNSdata.iID_MaDotPhanBo = MyHtmlHelper.DropDownList(ParentID, slPhanBo, iID_MaDotPhanBo, "iID_MaDotPhanBo", "", "class=\"input1_2\" style=\"width: 100%\" Onchange=\"ChonDV()\""); dtDotPhanBo.Dispose(); #endregion #region Danh sách đơn vị DataTable dtDonVi = PhanBo_ReportModels.DanhSachDonVi2(MaND, iID_MaTrangThaiDuyet, sLNS, iID_MaDotPhanBo, false, true, iThongBao,false); String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dtDonVi, "rptPhanBo_4_2", 1); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); _LNSdata.iID_MaDonVi = strDonVi; #endregion return Json(_LNSdata, JsonRequestBehavior.AllowGet); }
public JsonResult Get_dsDotPhanBo(string ParentID, String MaND, String iID_MaTrangThaiDuyet, String iID_MaDotPhanBo, String iID_MaDonVi) { cl_DotPhanBo a = new cl_DotPhanBo(); DataTable dtDotPhanBo = PhanBo_ReportModels.LayDSDotPhanBo2(MaND, iID_MaTrangThaiDuyet); SelectOptionList slTenDotPhanBo = new SelectOptionList(dtDotPhanBo, "iID_MaDotPhanBo", "dNgayDotPhanBo"); a.iID_MaDotPhanBo = MyHtmlHelper.DropDownList(ParentID, slTenDotPhanBo, iID_MaDotPhanBo, "iID_MaDotPhanBo", "", "class=\"input1_2\" style=\"width: 100%\" onchange=\"ChonDotPhanBo()\""); dtDotPhanBo.Dispose(); DataTable dtDonVi = PhanBo_ReportModels.DanhSachDonVi2(MaND, iID_MaTrangThaiDuyet, iID_MaDotPhanBo, false, false,false); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dtDonVi, "rptThongBaoCapNganSachNam",1); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); a.iID_MaDonVi = strDonVi; dtDotPhanBo.Dispose(); return Json(a, JsonRequestBehavior.AllowGet); }
public JsonResult Get_dsDonVi(string ParentID, String jiID_MaTrangThaiDuyet, String jiThang_Quy, String jiID_MaPhongBan, String jiID_MaDonVi, String jsLNS, String jiID_MaNamNganSach) { String MaND = User.Identity.Name; DataTable dtDonVi = LayDSDonVi(jiID_MaTrangThaiDuyet, jiThang_Quy, jiID_MaPhongBan, jsLNS, jiID_MaNamNganSach, MaND); if (String.IsNullOrEmpty(jiID_MaDonVi)) { jiID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, jiID_MaDonVi, dtDonVi, "rptQuyetToan_ThongTri_5"); dtDonVi.Dispose(); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); ; }
//VungNV: 2015/09/21 add new parm iID_MaPhongBan public JsonResult Ds_LNS(String ParentID, String Thang_Quy, String iID_MaNamNganSach, String LoaiThongTri, String sLNS, String iID_MaPhongBan) { String MaND = User.Identity.Name; //VungNV: 2015/09/21 add new parm iID_MaPhongBan DataTable dt = QuyetToan_ReportModels.dtLoaiThongTri_LNS(Thang_Quy, iID_MaNamNganSach, MaND, LoaiThongTri, iID_MaPhongBan); if (String.IsNullOrEmpty(sLNS)) { sLNS = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/LNS_DanhSach_ThongTri.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, sLNS, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult Ds_DonVi(string ParentID, string dsMaChungTu) { String MaND = User.Identity.Name; string[] arrChungTu = dsMaChungTu.Split(','); DataTable dtDonVi = null; for (int i = 0; i < arrChungTu.Length; i++) { if (dtDonVi != null) { dtDonVi.Merge(DuToanBS_ReportModels.dtDonVi_ChungTu(arrChungTu[i])); } else { dtDonVi = DuToanBS_ReportModels.dtDonVi_ChungTu(arrChungTu[i]); } } dtDonVi = HamChung.SelectDistinct("Donvi", dtDonVi, "iID_MaDonVi,TenHT", "iID_MaDonVi,TenHT", "iID_MaDonVi,TenHT"); string sLNS = ""; String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, sLNS, dtDonVi, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult Ds_DonVi(String ParentID, String Thang_Quy, String MaTo, String sLNS, String iID_MaNamNganSach, String iID_MaPhongBan) { String MaND = User.Identity.Name; DataTable dt = QuyetToan_ReportModels.dtTo_LNS(Thang_Quy, iID_MaNamNganSach, MaND, sLNS,iID_MaPhongBan); if (String.IsNullOrEmpty(MaTo)) { MaTo = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/To_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, MaTo, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult ds_DonVi(String ParentID, String MaND, String Thang_Quy, String iID_MaDonVi, String iID_MaTrangThaiDuyet) { DataTable dtDonVi = DanhSachDonVi(iID_MaTrangThaiDuyet, Thang_Quy, "0", MaND); String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dtDonVi, ""); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); dtDonVi.Dispose(); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
/// <summary> /// Lấy danh sách Loại Ngân Sách theo đợt,đơn vị,phòng ban /// </summary> /// <param name="ParentID"></param> /// <param name="iID_MaDot">Mã Đợt</param> /// <param name="iID_MaPhongBan">Mã Phòng Ban</param> /// <param name="iID_MaDonVi">Mã Đơn Vị</param> /// <param name="sLNS">Loại Ngân Sách</param> /// <returns></returns> public JsonResult LayDanhSachLNS(String ParentID, String iID_MaDot, String iID_MaPhongBan, String iID_MaDonVi, String sLNS) { String MaND = User.Identity.Name; String ViewNam = "~/Views/DungChung/DonVi/LNS_DanhSach_1.ascx"; DataTable dt = DuToanBS_ReportModels.dtLNS_Dot(iID_MaDot, iID_MaPhongBan, iID_MaDonVi, MaND); DanhSachDonViModels Model = new DanhSachDonViModels(MaND, sLNS, dt, ParentID); String strLNS = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strLNS, JsonRequestBehavior.AllowGet); }
public JsonResult ds_DonVi(String ParentID,String MaND, String Thang_Quy, String iID_MaDonVi, String iID_MaTrangThaiDuyet) { DataTable dt = HienThiDonViTheoNam(MaND,Thang_Quy,iID_MaTrangThaiDuyet); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, "rptQuyetToan_83"); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public String obj_DonVi(String ParentID, String iQuy, String sLNS, String iID_MaDonVi, String iID_MaTrangThaiDuyet, String MaND) { DataTable dt = LayDSDonVi(iQuy, sLNS, iID_MaTrangThaiDuyet, MaND); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, ""); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return strDonVi; }
public JsonResult Ds_DonVi(String ParentID, String iID_MaDotTu, String iID_MaDotDen, String iID_MaPhongBan, String iID_MaDonVi) { String MaND = User.Identity.Name; DataTable dt = DuToanBS_ReportModels.dtDonVi_Dot2(iID_MaDotTu, iID_MaDotDen, iID_MaPhongBan); String ViewNam = "~/Views/DungChung/DonVi/DonVi_Dot_DuToanBS.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
/// <summary> /// Lấy danh sách LNS từ quý, đơn vị, phòng ban /// </summary> /// <param name="ParentID"></param> /// <param name="Thang_Quy">Quý</param> /// <param name="iID_MaDonVi">Mã đơn vị</param> /// <param name="sLNS">Loại ngân sách</param> /// <param name="iID_MaNamNganSach">Năm ngân sách</param> /// <param name="iID_MaPhongBan">Mã phòng ban</param> /// HungPH: 2015/11/17 public JsonResult LayDanhSachLNS(String ParentID, String Thang_Quy, String iID_MaDonVi, String sLNS, String iID_MaNamNganSach, String iID_MaPhongBan) { String MaND = User.Identity.Name; String sViewPath = "~/Views/DungChung/DonVi/LNS_DanhSach.ascx"; DataTable dt = QuyetToan_ReportModels.dtDonVi_LNS_PhongBan(Thang_Quy, iID_MaNamNganSach, MaND, iID_MaDonVi, iID_MaPhongBan); if (String.IsNullOrEmpty(sLNS)) { sLNS = Guid.Empty.ToString(); } DanhSachDonViModels Model = new DanhSachDonViModels(MaND, sLNS, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(sViewPath, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
public JsonResult Ds_DonVi(String ParentID, String iID_MaPhongBan, String iID_MaDonVi, String MaND) { DataTable dt = QuyetToan_ReportModels.dtDonVi_ChuyenNamSau(iID_MaPhongBan,MaND); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
/// <summary> /// Lấy danh sách đơn vị dựa vào loại ngân sách, đợt dự toán, phòng ban /// </summary> /// <param name="ParentID"></param> /// <param name="maDonVi">Mã đơn vị</param> /// <param name="maDot">Đợt dự toán</param> /// <param name="maPhongBan">Mã phòng ban</param> /// <param name="sLNS">Loại ngân sách</param> /// <returns></returns> public JsonResult LayDanhSachDonVi(String ParentID, String maDonVi, String maDot, String maPhongBan, String sLNS) { String MaND = User.Identity.Name; String sViewPatch = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DataTable dt = DuToan_ReportModels.laydtPhongBan_LNS_DonVi(MaND, maDot, maPhongBan, sLNS); if (String.IsNullOrEmpty(maDonVi)) { maDonVi = Guid.Empty.ToString(); } DanhSachDonViModels Model = new DanhSachDonViModels(MaND, maDonVi, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(sViewPatch, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }
/// <summary> /// Lấy danh sách đơn vị theo đợt và phòng ban /// </summary> /// <param name="ParentID"></param> /// <param name="iID_MaDonVi">Mã Đơn Vị</param> /// <param name="iID_Dot">Mã Đợt</param> /// <param name="iID_MaPhongBan">Mã Phòng Ban</param> /// <returns></returns> public JsonResult LayDanhSachDonVi(String ParentID, String iID_MaDonVi, String iID_Dot, String iID_MaPhongBan) { String MaND = User.Identity.Name; String ViewNam = "~/Views/DungChung/DonVi/DonVi_DanhSach.ascx"; DataTable dt = DuToanBS_ReportModels.getdtPhongBan_DonVi(iID_Dot, iID_MaPhongBan); if (String.IsNullOrEmpty(iID_MaDonVi)) { iID_MaDonVi = Guid.Empty.ToString(); } DanhSachDonViModels Model = new DanhSachDonViModels(MaND, iID_MaDonVi, dt, ParentID); String strDonVi = HamChung.RenderPartialViewToStringLoad(ViewNam, Model, this); return Json(strDonVi, JsonRequestBehavior.AllowGet); }