本文整理汇总了C#中VIETTEL.Controllers.clsExcelResult类的典型用法代码示例。如果您正苦于以下问题:C# clsExcelResult类的具体用法?C# clsExcelResult怎么用?C# clsExcelResult使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
clsExcelResult类属于VIETTEL.Controllers命名空间,在下文中一共展示了clsExcelResult类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: ExportToExcel
/// <summary>
/// Xuất báo cáo ra file excel
/// </summary>
/// <param name="TuThang"></param>
/// <param name="DenThang"></param>
/// <param name="NamLuong"></param>
/// <param name="TrangThai"></param>
/// <returns></returns>
public clsExcelResult ExportToExcel(String TuThang, String DenThang, String NamLuong, String TrangThai)
{
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), TuThang,DenThang,NamLuong,TrangThai);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "TongHop_ThuThueDauVao.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:22,代码来源:rptLuong_TongHopThuThueDauVaoController.cs
示例2: ExportToExcel
public clsExcelResult ExportToExcel(String MaBL)
{
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath),MaBL);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "Luong_NguoiPhuThuoc.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:14,代码来源:rptLuong_DanhSachCaNhan_NguoiPhuThuocController.cs
示例3: ExportToExcel
public clsExcelResult ExportToExcel(String MaND, string iID_MaPhongBan, string iThang1, string iThang2, string iThang3, string iThang4, String bQuy)
{
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), MaND, iID_MaPhongBan, iThang1, iThang2, iThang3, iThang4,bQuy);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "rptQTQS_ThuongXuyen.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:14,代码来源:rptQTQS_ThuongXuyenController.cs
示例4: ExportToExcel
public clsExcelResult ExportToExcel(String iID_MaDonVi, String iNamLamViec, String iID_MaTaiKhoan, String iThang1, String iThang2)
{
HamChung.Language();
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), iID_MaDonVi, iNamLamViec, iID_MaTaiKhoan, iThang1, iThang2);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "ChoDoanhnghiep.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:15,代码来源:rptChiTietTaiKhoanTheoDonViController.cs
示例5: ExportToExcel
public clsExcelResult ExportToExcel(String NamLamViec)
{
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), NamLamViec);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "rptQLDA_QTHT_02QTHT.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:15,代码来源:rptQLDA_QTHT_02QTHTController.cs
示例6: ExportToExcel
public clsExcelResult ExportToExcel(String iNamLamViec, String iThang,String iTrangThai)
{
HamChung.Language();
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), iNamLamViec, iThang, iTrangThai);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "rptChiTietTaiKhoanTheoDonVi1.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:15,代码来源:rptKT_ChiTiet_TaiKhoanTheoDonVi1Controller.cs
示例7: ExportToExcel
/// <summary>
/// Hàm xuất dữ liệu ra file excel
/// </summary>
/// <param name="NamLamViec"></param>
/// <returns></returns>
public clsExcelResult ExportToExcel(String MaND, String iID_MaTrangThaiDuyet)
{
HamChung.Language();
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), MaND, iID_MaTrangThaiDuyet);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "DT_CNSQP_TuyVien"+Convert.ToString(DateTime.Now)+".xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:21,代码来源:rptDuToanChiNganSachQuocPhongNamTuyVienController.cs
示例8: ExportToExcel
/// <summary>
/// hàm xuất dữ liệu ra file Excel
/// </summary>
/// <param name="NamLamViec"></param>
/// <param name="sLNS"></param>
/// <returns></returns>
public clsExcelResult ExportToExcel(String NamLamViec, String iID_MaTrangThaiDuyet)
{
HamChung.Language();
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), NamLamViec, iID_MaTrangThaiDuyet);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "DuToanChiNganSach4d2-C.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:22,代码来源:rptDT_CNSNamLNS2Controller.cs
示例9: ExportToExcel
public clsExcelResult ExportToExcel(String iID_MaTaiKhoan)
{
HamChung.Language();
String DuongDanFile = sFilePath_A3;
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDanFile), iID_MaTaiKhoan);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "DanhMuc_TaiKhoanChiTiet.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:16,代码来源:rptKeToanTongHop_InTaiKhoanChiTietController.cs
示例10: ExportToExcel
public clsExcelResult ExportToExcel(String NamLamViec, String ThangLamViec, String TrangThai)
{
HamChung.Language();
String DuongDanFile = sFilePath_A3;
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDanFile), NamLamViec, ThangLamViec, TrangThai);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "KeToan_QuyetToanNam.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:16,代码来源:rptKeToan_BangCanDoiSoDuController.cs
示例11: ExportToExcel
public clsExcelResult ExportToExcel(String iNam, String iThang, String optThu, String optTamUng, String optTra,String KhoGiay)
{
HamChung.Language();
String DuongDan = "";
if (KhoGiay == "1") DuongDan = sFilePath_a3;
else DuongDan = sFilePath_a4;
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDan), iNam, iThang, optThu, optTamUng, optTra,KhoGiay);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "GiaiThichSoDu.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:18,代码来源:rptKeToanTongHop_GiaiThichSoDuController.cs
示例12: ExportToExcel
public clsExcelResult ExportToExcel(String MaND, String ThangQuy, String LoaiThang_Quy, String iID_MaDonVi, String iID_MaNhomDonVi, String LuyKe, String iID_MaTrangThaiDuyet, String KhoGiay, String BaoHiem,String iLoai)
{
clsExcelResult clsResult = new clsExcelResult();
HamChung.Language();
String sFilePath = "";
if (KhoGiay == "0")
{
if (BaoHiem == "0" || BaoHiem == "1" || BaoHiem == "2")
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToan1.xls";
}
else if (BaoHiem == "3")
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToanCN.xls";
}
else if (BaoHiem == "4")
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToanDV.xls";
}
else
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToanTH.xls";
}
}
else
{
if (BaoHiem == "0" || BaoHiem == "1" || BaoHiem == "2")
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToan1A3.xls";
}
else if (BaoHiem == "3")
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToanCNA3.xls";
}
else if (BaoHiem == "4")
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToanDVA3.xls";
}
else
{
sFilePath = "/Report_ExcelFrom/BaoHiem/rptBH_TongQuyetToanTH.xls";
}
}
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), MaND, ThangQuy, LoaiThang_Quy, iID_MaDonVi, iID_MaNhomDonVi, LuyKe, iID_MaTrangThaiDuyet, KhoGiay, BaoHiem,iLoai);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
//if (KhoGiay == "1")
//{
// clsResult.FileName = "baocaoquyettoanChiCacCheDoBHXH.xls";
//}
//else
//{
// clsResult.FileName = "baocaoquyettoanChiCacCheDoBHXH_A4.xls";
//}
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:64,代码来源:rptBH_TongQuyetToanController.cs
示例13: ExportToPDF
/// <summary>
/// Xuất báo cáo ra file PDF
/// </summary>
/// <param name="Nam">Năm làm việc</param>
/// <param name="MaDV">Mã doanh nghiệp</param>
/// <returns></returns>
public clsExcelResult ExportToPDF(String Quy, String Nam, String MaDN)
{
HamChung.Language();
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath),Quy,Nam,MaDN);
using (FlexCelPdfExport pdf = new FlexCelPdfExport())
{
pdf.Workbook = xls;
using (MemoryStream ms = new MemoryStream())
{
pdf.BeginExport(ms);
pdf.ExportAllVisibleSheets(false, "AA");
pdf.EndExport();
ms.Position = 0;
clsResult.FileName = "Test.pdf";
clsResult.type = "pdf";
clsResult.ms = ms;
return clsResult;
}
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:27,代码来源:rptTCND_BC_KQHDKinhDoanhController.cs
示例14: ExportToExcel
/// <summary>
/// Xuất báo cáo ra file Excel
/// </summary>
/// <param name="Nam">Năm làm việc</param>
/// <param name="MaDV">Mã doanh nghiệp</param>
/// <returns></returns>
public clsExcelResult ExportToExcel(String Quy, String Nam, String MaDN)
{
HamChung.Language();
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(sFilePath), Quy,Nam,MaDN);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "HoatDong_KD_"+Nam+".xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:21,代码来源:rptTCND_BC_KQHDKinhDoanhController.cs
示例15: ExportToExcel
public clsExcelResult ExportToExcel(String NgoaiTe, string vidDenNgay)
{
String DuongDanFile = sFilePath;
// DateTime dNgay = Convert.ToDateTime(CommonFunction.LayNgayTuXau(vidDenNgay));
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDanFile), NgoaiTe, vidDenNgay);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "rptKHV_Bieu02VDT" + String.Format("{0:ddMMyyyyhhmmss}", DateTime.Now) + ".xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:17,代码来源:rptKHV_Bieu02VDTController.cs
示例16: ExportToPDF
public clsExcelResult ExportToPDF(String iID_MaTrangThaiDuyet, String iID_MaDonVi, String dNgayCapPhat, String iDM_MaLoaiCapPhat, String LuyKe, String LoaiBaoCao)
{
HamChung.Language();
String DuongDan = "";
if (LoaiBaoCao == "Muc")
{
DuongDan = sFilePathMuc;
}
else if (LoaiBaoCao == "TieuMuc")
{
DuongDan = sFilePathTieuMuc;
}
else
{
DuongDan = sFilePathNganh;
}
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDan), iID_MaTrangThaiDuyet, iID_MaDonVi, dNgayCapPhat, iDM_MaLoaiCapPhat, LuyKe, LoaiBaoCao);
using (FlexCelPdfExport pdf = new FlexCelPdfExport())
{
pdf.Workbook = xls;
using (MemoryStream ms = new MemoryStream())
{
pdf.BeginExport(ms);
pdf.ExportAllVisibleSheets(false, "AA");
pdf.EndExport();
ms.Position = 0;
clsResult.FileName = "Test.pdf";
clsResult.type = "pdf";
clsResult.ms = ms;
return clsResult;
}
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:35,代码来源:rptCapPhat_79_3Controller.cs
示例17: ExportToExcel
/// <summary>
/// Xuất ra excel
/// </summary>
/// <param name="NamLamViec"></param>
/// <param name="iID_MaDonVi"></param>
/// <param name="dNgayCapPhat"></param>
/// <param name="iDM_MaLoaiCapPhat"></param>
/// <param name="LuyKe"></param>
/// <param name="LoaiBaoCao"></param>
/// <returns></returns>
public clsExcelResult ExportToExcel(String iID_MaTrangThaiDuyet, String iID_MaDonVi, String dNgayCapPhat, String iDM_MaLoaiCapPhat, String LuyKe, String LoaiBaoCao)
{
HamChung.Language();
String DuongDan = "";
if (LoaiBaoCao == "Muc")
{
DuongDan = sFilePathMuc;
}
else if (LoaiBaoCao == "TieuMuc")
{
DuongDan = sFilePathTieuMuc;
}
else
{
DuongDan = sFilePathNganh;
}
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDan), iID_MaTrangThaiDuyet, iID_MaDonVi, dNgayCapPhat, iDM_MaLoaiCapPhat, LuyKe, LoaiBaoCao);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "CapPhat_79_3.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:40,代码来源:rptCapPhat_79_3Controller.cs
示例18: ExportToPDF
public clsExcelResult ExportToPDF(String NamLamViec, String Thang_Quy, String LoaiThang_Quy, String inmuc, String iID_MaNguonNganSach, String iID_MaNamNganSach, String iID_MaTrangThaiDuyet)
{
HamChung.Language();
String DuongDan = "";
DuongDan = PathFile(inmuc, DuongDan);
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDan), NamLamViec, Thang_Quy, LoaiThang_Quy, inmuc, iID_MaNguonNganSach, iID_MaNamNganSach, iID_MaTrangThaiDuyet);
using (FlexCelPdfExport pdf = new FlexCelPdfExport())
{
pdf.Workbook = xls;
using (MemoryStream ms = new MemoryStream())
{
pdf.BeginExport(ms);
pdf.ExportAllVisibleSheets(false, "AA");
pdf.EndExport();
ms.Position = 0;
clsResult.FileName = "Test.pdf";
clsResult.type = "pdf";
clsResult.ms = ms;
return clsResult;
}
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:23,代码来源:rptDoiChieuSuDungKinhPhiController.cs
示例19: ExportToExcel
public clsExcelResult ExportToExcel(String NamLamViec, String Thang_Quy, String LoaiThang_Quy, String inmuc, String iID_MaNguonNganSach, String iID_MaNamNganSach, String iID_MaTrangThaiDuyet)
{
String DuongDan = "";
DuongDan = PathFile(inmuc, DuongDan);
HamChung.Language();
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDan), NamLamViec, Thang_Quy, LoaiThang_Quy, inmuc, iID_MaNguonNganSach, iID_MaNamNganSach, iID_MaTrangThaiDuyet);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "ChoDoanhnghiep.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:18,代码来源:rptDoiChieuSuDungKinhPhiController.cs
示例20: ExportToExcel
//<summary>
//Hàm thực hiện việc xuất dữ liệu ra file excel
//</summary>
//<param name="NamLamViec"></param>
//<param name="sLNS"></param>
//<param name="iID_MaDotPhanBo"></param>
//<param name="TruongTien"></param>
//<returns></returns>
public clsExcelResult ExportToExcel(String MaND, String sLNS, String iID_MaDotPhanBo, String iID_MaTrangThaiDuyet, String TruongTien, String KhoGiay, String LuyKe, String ToSo)
{
HamChung.Language();
String DuongDan = "";
if (LuyKe != "on")
{
if (KhoGiay == "1")
{
if (ToSo == "1") DuongDan = sFilePath_A3_1_RG;
else DuongDan = sFilePath_A3_2_RG;
}
else
{
if (ToSo == "1") DuongDan = sFilePath_A4_1_RG;
else DuongDan = sFilePath_A4_2_RG;
}
}
else
{
if (KhoGiay == "1")
{
if (ToSo == "1") DuongDan = sFilePath_A3_1;
else DuongDan = sFilePath_A3_2;
}
else
{
if (ToSo == "1") DuongDan = sFilePath_A4_1;
else DuongDan = sFilePath_A4_2;
}
}
clsExcelResult clsResult = new clsExcelResult();
ExcelFile xls = CreateReport(Server.MapPath(DuongDan), MaND, sLNS, iID_MaDotPhanBo, iID_MaTrangThaiDuyet, TruongTien, KhoGiay, LuyKe, ToSo);
using (MemoryStream ms = new MemoryStream())
{
xls.Save(ms);
ms.Position = 0;
clsResult.ms = ms;
clsResult.FileName = "TongHopChiTieuDonVi.xls";
clsResult.type = "xls";
return clsResult;
}
}
开发者ID:BMSProject2015,项目名称:BMS,代码行数:51,代码来源:rptPBTong6Controller.cs
注:本文中的VIETTEL.Controllers.clsExcelResult类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论