using
System;
using
System.Collections.Generic;
using
System.Text;
using
System.Data.OleDb;
using
System.Windows.Forms;
using
System.Data;
using
Microsoft.Office.Interop.Excel;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
namespace
BoyangMIS
![](https://i-blog.csdnimg.cn/blog_migrate/a41954a27d6ad96fa2c2cf816e677448.gif)
...
{
class OutDataClass
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
//DataSet dst = new DataSet();
public Microsoft.Office.Interop.Excel.Application xlApp;
Workbook wb;
Worksheet ws;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
public string modName;
public DataSet dstExcel = new DataSet();
public OutDataClass(DataSet _dstExcel, string _modName)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
this.dstExcel = _dstExcel;
this.modName = _modName;
}
//public int ModName
//{
// get
// {
// return modName;
// }
// set
// {
// modName = value;
// }
//}
//public DataSet Dstexcel
//{
// get
// {
// return dstExcel;
// }
// set
// {
// dstExcel = value;
// }
//}
public void OutDataExcel()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
xlApp = new Microsoft.Office.Interop.Excel.Application();
wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
ws = (Worksheet)wb.Worksheets[1];
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
int iMaxRow = dstExcel.Tables[0].Rows.Count;
int iMaxCol = dstExcel.Tables[0].Columns.Count;
//设置公共格式
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iMaxCol]).Font.Name = "Tahoma";
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iMaxCol]).Font.Bold = true;
//ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iMaxCol]).Font.Size = 10;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
ws.get_Range(ws.Cells[1, 1], ws.Cells[iMaxRow + 1, iMaxCol]).Borders.LineStyle = 1;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
xlApp.Cells.Font.Size = 10;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
//设置标题
if (modName == "Room")
Room();
else if (modName == "RoomType")
RoomType();
else if (modName == "RoomSearch")
RoomSearch();
else if (modName == "RoomPrearrange")
RoomPrearrange();
else if (modName == "Reckoning")
Reckoning();
else if (modName == "ClientSearch")
ClientSearch();
else if (modName == "ClientInfo")
ClientInfo();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
//填充数据
for (int iRow = 0; iRow < iMaxRow; iRow++)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
for (int iCol = 0; iCol < iMaxCol; iCol++)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
xlApp.Cells[iRow + 2, iCol + 1] = dstExcel.Tables[0].Rows[iRow][iCol].ToString();
}
}
//保存Execl
//xlApp.Save("C:/Room.xls");
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**/////打开EXCEL
xlApp.Visible = true;
}
catch (Exception exp)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(exp.ToString());
return;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
}
private void Room()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
IniFile ini = new IniFile();
ws.get_Range(ws.Cells[1, 1], ws.Cells[1,1]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomNumber"));
ws.get_Range(ws.Cells[1, 2], ws.Cells[1, 2]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomTypeName"));
ws.get_Range(ws.Cells[1, 3], ws.Cells[1, 3]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomFloor"));
ws.get_Range(ws.Cells[1, 4], ws.Cells[1, 4]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RatedCount"));
ws.get_Range(ws.Cells[1, 5], ws.Cells[1, 5]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RatedBed"));
ws.get_Range(ws.Cells[1, 6], ws.Cells[1, 6]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "ActuallyCount"));
ws.get_Range(ws.Cells[1, 7], ws.Cells[1, 7]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomState"));
ws.get_Range(ws.Cells[1, 8], ws.Cells[1, 8]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomMemo"));
xlApp.Cells[1, 1] = "房间号";
xlApp.Cells[1, 2] = "房间类型";
xlApp.Cells[1, 3] = "房间楼层";
xlApp.Cells[1, 4] = "额定人数";
xlApp.Cells[1, 5] = "额定床数";
xlApp.Cells[1, 6] = "实际人数";
xlApp.Cells[1, 7] = "房间状态";
xlApp.Cells[1, 8] = "备注";
}
private void RoomType()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
IniFile ini = new IniFile();
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 1]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RoomTypeName"));
ws.get_Range(ws.Cells[1, 2], ws.Cells[1, 2]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RoomArea"));
ws.get_Range(ws.Cells[1, 3], ws.Cells[1, 3]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RatedBed"));
ws.get_Range(ws.Cells[1, 4], ws.Cells[1, 4]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RatedCount"));
ws.get_Range(ws.Cells[1, 5], ws.Cells[1, 5]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RoomPrice"));
ws.get_Range(ws.Cells[1, 6], ws.Cells[1, 6]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RoomTV"));
ws.get_Range(ws.Cells[1, 7], ws.Cells[1, 7]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RoomPhone"));
ws.get_Range(ws.Cells[1, 8], ws.Cells[1, 8]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RoomAir"));
ws.get_Range(ws.Cells[1, 9], ws.Cells[1, 9]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomTypeExcelColumn", "RoomToilet"));
xlApp.Cells[1, 1] = "客房类型";
xlApp.Cells[1, 2] = "客房面积";
xlApp.Cells[1, 3] = "额定床数";
xlApp.Cells[1, 4] = "额定人数";
xlApp.Cells[1, 5] = "客房价格";
xlApp.Cells[1, 6] = "电视";
xlApp.Cells[1, 7] = "电话";
xlApp.Cells[1, 8] = "空调";
xlApp.Cells[1, 9] = "卫生间";
}
private void RoomSearch()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
IniFile ini = new IniFile();
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 1]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomNumber"));
ws.get_Range(ws.Cells[1, 2], ws.Cells[1, 2]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomTypeName"));
ws.get_Range(ws.Cells[1, 3], ws.Cells[1, 3]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomFloor"));
ws.get_Range(ws.Cells[1, 4], ws.Cells[1, 4]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RatedCount"));
ws.get_Range(ws.Cells[1, 5], ws.Cells[1, 5]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RatedBed"));
ws.get_Range(ws.Cells[1, 6], ws.Cells[1, 6]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "ActuallyCount"));
ws.get_Range(ws.Cells[1, 7], ws.Cells[1, 7]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomMemo"));
ws.get_Range(ws.Cells[1, 8], ws.Cells[1, 8]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("RoomExcelColumn", "RoomState"));
xlApp.Cells[1, 1] = "房间号";
xlApp.Cells[1, 2] = "房间类型";
xlApp.Cells[1, 3] = "房间楼层";
xlApp.Cells[1, 4] = "额定人数";
xlApp.Cells[1, 5] = "额定床位";
xlApp.Cells[1, 6] = "实际人数";
xlApp.Cells[1, 7] = "备注";
xlApp.Cells[1, 8] = "房间状态";
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void RoomPrearrange()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
IniFile ini = new IniFile();
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 1]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientPrearrangeExC", "ID"));
ws.get_Range(ws.Cells[1, 2], ws.Cells[1, 2]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientPrearrangeExC", "ClientPName"));
ws.get_Range(ws.Cells[1, 3], ws.Cells[1, 3]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientPrearrangeExC", "ClientPPhone"));
ws.get_Range(ws.Cells[1, 4], ws.Cells[1, 4]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientPrearrangeExC", "ClientPRoom"));
ws.get_Range(ws.Cells[1, 5], ws.Cells[1, 5]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientPrearrangeExC", "PrearrangeDate"));
xlApp.Cells[1, 1] = "序号";
xlApp.Cells[1, 2] = "预定者姓名";
xlApp.Cells[1, 3] = "预定电话";
xlApp.Cells[1, 4] = "预定房间";
xlApp.Cells[1, 5] = "预定时间";
}
private void Reckoning()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
IniFile ini = new IniFile();
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 1]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "ID"));
ws.get_Range(ws.Cells[1, 2], ws.Cells[1, 2]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "ClientID"));
ws.get_Range(ws.Cells[1, 3], ws.Cells[1, 3]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "ClientName"));
ws.get_Range(ws.Cells[1, 4], ws.Cells[1, 4]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "RoomID"));
ws.get_Range(ws.Cells[1, 5], ws.Cells[1, 5]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "InDate"));
ws.get_Range(ws.Cells[1, 6], ws.Cells[1, 6]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "CheckDate"));
ws.get_Range(ws.Cells[1, 7], ws.Cells[1, 7]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "Settle"));
ws.get_Range(ws.Cells[1, 8], ws.Cells[1, 8]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientRecordExcelCloumn", "ClientMemo"));
xlApp.Cells[1, 1] = "序号";
xlApp.Cells[1, 2] = "客户ID";
xlApp.Cells[1, 3] = "客户姓名";
xlApp.Cells[1, 4] = "房间";
xlApp.Cells[1, 5] = "入住日期";
xlApp.Cells[1, 6] = "退房日期";
xlApp.Cells[1, 7] = "结账金额";
xlApp.Cells[1, 8] = "备注";
}
private void ClientSearch()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
Reckoning();
}
private void ClientInfo()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
IniFile ini = new IniFile();
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 1]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientExcelColumn", "ID"));
ws.get_Range(ws.Cells[1, 2], ws.Cells[1, 2]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientExcelColumn", "ClientID"));
ws.get_Range(ws.Cells[1, 3], ws.Cells[1, 3]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientExcelColumn", "ClientName"));
ws.get_Range(ws.Cells[1, 4], ws.Cells[1, 4]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientExcelColumn", "ClientSex"));
ws.get_Range(ws.Cells[1, 5], ws.Cells[1, 5]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientExcelColumn", "ClientAddress"));
ws.get_Range(ws.Cells[1, 6], ws.Cells[1, 6]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientExcelColumn", "ClientPhone"));
ws.get_Range(ws.Cells[1, 7], ws.Cells[1, 7]).ColumnWidth = Convert.ToInt16(ini.IniReadValue("ClientExcelColumn", "ClientMemo"));
xlApp.Cells[1, 1] = "序号";
xlApp.Cells[1, 2] = "客户ID";
xlApp.Cells[1, 3] = "客户姓名";
xlApp.Cells[1, 4] = "性别";
xlApp.Cells[1, 5] = "籍贯";
xlApp.Cells[1, 6] = "电话";
xlApp.Cells[1, 7] = "备注";
}
}
}
=======下面是parameter.ini文件内容===============
关于操作INI文件Class,请查看我的"简单操作INI文件"文章或联系我
[DataGridView]
pagesize = 10
[ControlPar]
Address = 北京,上海
Address1 = "北京"
Address2 = "上海"
Address3 = "天津"
Address4 = "重庆"
[RoomExcelColumn]
RoomNumber = 5
RoomTypeName = 8
RoomFloor = 7
RatedCount = 7
RatedBed = 7
ActuallyCount= 7
RoomState = 7
RoomMemo = 25
[RoomTypeExcelColumn]
RoomTypeName = 8
RoomArea = 7
RatedBed = 7
RatedCount = 7
RoomPrice = 7
RoomTV = 7
RoomPhone = 7
RoomAir = 7
RoomToilet = 7
[ClientRecordExcelCloumn]
ID = 7
ClientID = 20
ClientName = 8
RoomID = 7
InDate = 15
CheckDate = 15
Settle = 7
ClientMemo = 25
[ClientPrearrangeExC]
ID = 7
ClientPName = 8
ClientPPhone = 10
ClientPRoom = 7
PrearrangeDate= 15
[ClientExcelColumn]
ID = 7
ClientID = 20
ClientName = 8
ClientSex = 7
ClientAddress= 7
ClientPhone = 10
ClientMemo = 25
[Time]
;预定提示时间以分钟计算
Prearrange = 30