91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

在日常使用中，很多人事系統的報表軟件功能不夠強大，造成打印出入廠證，各類證卡非常不方便，以九段人事軟件為例，在日常打印廠牌中非常麻煩， 例如打印尺寸很難調節，打印位置設置非常麻煩，不能根據使用部門或其它字段自動選擇不能的底圖，如行政管理部用紅色底圖，工程管理部用黃色底圖，其它人員用藍色底圖等； 為解決此類問題，特開發了此軟件，此軟件可以通用其它使用SQL數據的任何軟件及人事系統， 此軟件為免費軟件，可任意復制、安裝、使用！

資源截圖

代碼片段和文件信息 



using?System;
using?System.Data;
using?System.IO;
using?System.Web;
using?NPOI;
using?NPOI.HPSF;
using?NPOI.HSSF;
using?NPOI.HSSF.UserModel;
using?NPOI.SS.UserModel;
using?NPOI.POIFS;
using?NPOI.Util;
using?System.Text;
using?System.Net;

public?class?NPOIHelper
{
????///?
????///?由DataSet導出Excel
????///?
????///?要導出數據的DataTable????
????///?工作表名稱
????///?Excel工作表????
????private?static?Stream?ExportDataSetToExcel（DataSet?sourceDs?string?sheetName）
????{
????????HSSFWorkbook?workbook?=?new?HSSFWorkbook（）;
????????MemoryStream?ms?=?new?MemoryStream（）;
????????string[]?sheetNames?=?sheetName.Split（‘‘）;
????????for?（int?i?=?0;?i?????????{
????????????ISheet?sheet?=?workbook.CreateSheet（sheetNames[i]）;
????????????IRow?headerRow?=?sheet.CreateRow（0）;
????????????//?handling?header.????????????
????????????foreach?（DataColumn?column?in?sourceDs.Tables[i].Columns）
????????????????headerRow.CreateCell（column.Ordinal）.SetCellValue（column.ColumnName）;
????????????//?handling?value.????????????
????????????int?rowIndex?=?1;
????????????foreach?（DataRow?row?in?sourceDs.Tables[i].Rows）
????????????{
????????????????IRow?dataRow?=?sheet.CreateRow（rowIndex）;
????????????????foreach?（DataColumn?column?in?sourceDs.Tables[i].Columns）
????????????????{
????????????????????dataRow.CreateCell（column.Ordinal）.SetCellValue（row[column].ToString（））;
????????????????}
????????????????rowIndex++;
????????????}
????????}
????????workbook.Write（ms）;
????????ms.Flush（）;
????????ms.Position?=?0;
????????workbook?=?null;
????????return?ms;
????}
??
????///?
????///?由DataTable導出Excel
????///?
????///?要導出數據的DataTable?
????///?Excel工作表????
????public?static?Stream?ExportDataTableToExcel（DataTable?sourceTable?string?sheetName）
????{
????????HSSFWorkbook?workbook?=?new?HSSFWorkbook（）;
????????MemoryStream?ms?=?new?MemoryStream（）;
????????ISheet?sheet?=?workbook.CreateSheet（sheetName）;
????????IRow?headerRow?=?sheet.CreateRow（0）;
????????//?handling?header.??????
????????foreach?（DataColumn?column?in?sourceTable.Columns）
????????????headerRow.CreateCell（column.Ordinal）.SetCellValue（column.ColumnName）;
????????//?handling?value.??????
????????int?rowIndex?=?1;
????????foreach?（DataRow?row?in?sourceTable.Rows）
????????{
????????????IRow?dataRow?=?sheet.CreateRow（rowIndex）;
????????????foreach?（DataColumn?column?in?sourceTable.Columns）
????????????{
????????????????dataRow.CreateCell（column.Ordinal）.SetCellValue（row[column].ToString（））;
????????????}
????????????rowIndex++;
????????}
????????workbook.Write（ms）;
????????ms.Flush（）;
????????ms.Position?=?0;
????????sheet?=?null;
????????headerRow?=?null;
????????workbook?=?null;
????????return?ms;
????}


????///?
????///?由DataTable導出Exc

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-03-20?11:19??人事系統證卡打印軟件\
?????文件?????4481024??2010-09-11?15:56??人事系統證卡打印軟件\Aspose.Cells.dll
?????文件???????57136??2012-12-03?15:05??人事系統證卡打印軟件\Chinese?（Simplified）.frl
?????文件?????3233792??2014-11-28?22:06??人事系統證卡打印軟件\FastReport.Bars.dll
?????文件?????3153408??2014-11-28?23:35??人事系統證卡打印軟件\FastReport.dll
?????文件?????1006080??2014-11-28?22:06??人事系統證卡打印軟件\FastReport.Editor.dll
?????文件?????1717083??2014-11-27?23:27??人事系統證卡打印軟件\FastReport.xml
?????文件??????165888??2019-03-20?11:18??人事系統證卡打印軟件\Forms.exe
?????文件?????????353??2019-03-20?11:20??人事系統證卡打印軟件\Forms.exe.config
?????文件???????97792??2019-03-20?11:18??人事系統證卡打印軟件\Forms.pdb
?????文件???????11608??2013-04-05?10:58??人事系統證卡打印軟件\Forms.vshost.exe
?????文件?????????357??2013-02-27?10:50??人事系統證卡打印軟件\Forms.vshost.exe.config
?????文件?????????490??2010-03-17?22:39??人事系統證卡打印軟件\Forms.vshost.exe.manifest
?????文件???????????0??2019-03-20?11:13??人事系統證卡打印軟件\http.ini
?????文件????????4016??2018-08-09?09:49??人事系統證卡打印軟件\MainForms_dbgSqls.xml
?????文件?????????226??2018-08-09?09:49??人事系統證卡打印軟件\MainForms_dbgSqlsstyles.xml
?????文件???????24576??2019-03-20?11:04??人事系統證卡打印軟件\Maticsoft.BLL.dll
?????文件???????96256??2012-09-12?17:23??人事系統證卡打印軟件\Maticsoft.Common.dll
?????文件??????163840??2019-03-20?11:04??人事系統證卡打印軟件\Maticsoft.DAL.dll
?????文件???????57344??2019-03-20?11:04??人事系統證卡打印軟件\Maticsoft.DBUtility.dll
?????文件???????69632??2019-03-20?11:04??人事系統證卡打印軟件\Maticsoft.Model.dll
?????文件??????369152??2012-09-12?17:23??人事系統證卡打印軟件\MySql.Data.dll
?????文件?????1454080??2012-05-04?19:57??人事系統證卡打印軟件\NPOI.dll
?????文件???????15782??2018-08-04?13:47??人事系統證卡打印軟件\NPOIHelper.cs
?????文件?????????470??2013-02-22?10:43??人事系統證卡打印軟件\Program.cs
?????文件?????????855??2019-03-19?11:58??人事系統證卡打印軟件\sqlstring.txt
?????文件?????????323??2019-03-19?11:58??人事系統證卡打印軟件\sysset.ini
?????文件??????847872??2012-09-12?17:23??人事系統證卡打印軟件\System.Data.SQLite.dll
?????文件?????1753088??2009-03-06?17:43??人事系統證卡打印軟件\System.Windows.Forms.DataVisualization.dll
?????文件???????28672??2019-03-20?11:04??人事系統證卡打印軟件\Systemset.exe
?????文件?????????117??2013-02-23?10:32??人事系統證卡打印軟件\Systemset.exe.config
............此處省略13個文件信息

評論

共有 條評論

相關資源