/// <summary>
/// 放映表导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void 放映表ToolStripMenuItem_Click(object sender, EventArgs e)
{
//创建排片信息集合对象,用以保存信息
List <IMovieShowList.MovieShow> listMovie = new List <IMovieShowList.MovieShow>();
try
{
if (newExcel)
{
ExcelSource ex = new ExcelSource();
listMovie = ex.GetList4Excel(newFileName);
if (!ex.isOk)
{
MessageBox.Show(ex.Msg);
return;
}
}
else
{
//排片信息读取
listMovie = movieList;
}
if (listMovie.Count == 0)
{
MessageBox.Show("没有排片信息");
return;
}
}
catch
{
MessageBox.Show("未知错误,请重试");
return;
}
MovieEndTime end = new MovieEndTime();
listMovie = end.GetMovieEndTimeList(listMovie);
string headeValue = string.Empty;
//是否Excel源或Api源
bool ok = IsExcelOrApi(out headeValue, listMovie);
if (!ok)
{
return;
}
//让排片信息以厅号来排序
var iList = listMovie.OrderBy(i => i.Room[0]);
//提取所有厅号
var a = from room in iList select room.Room;
//去重之后放映厅的集合
List <string> RoomInfo = a.Distinct().ToList();
//创建放映表
hssfworkbook = new HSSFWorkbook();
Sheet sheet = hssfworkbook.CreateSheet("放映表");
sheet.PrintSetup.Landscape = true;//设置为横向
//设定列宽
for (int i = 0; i < 12; i++)
{
if ((i + 1) % 3 == 0)
{
//将包含电影名称的列设置列宽
sheet.SetColumnWidth(i, 23 * 256 + 200);
}
else
{
//其它的列设置列宽
sheet.SetColumnWidth(i, 6 * 256 + 200);
}
}
//创建第一行
CreateR1(sheet, 0, 0, 0, 11, headeValue);
//行标识从第2行开始
int roomCout = 1;
Dictionary <string, int> roomIndex = new Dictionary <string, int>();
//创建当前行
Row row = sheet.CreateRow(roomCout);
row.HeightInPoints = 30;
int j = -1;
//保存厅号的位置信息
List <Cell> listCell = new List <Cell>();
//创建其它字段
for (int i = 0; i < RoomInfo.Count; i++)
{
//创建第四个厅的时候转折
if ((i + 1) % 5 == 0)
{
//并且前面空余8格
roomCout += 9;
row = sheet.CreateRow(roomCout);
row.HeightInPoints = 30;
j = -1;
}
j++;
//创建单元格
//创建字体样式
NPOI.SS.UserModel.Font fontHeader = hssfworkbook.CreateFont();
fontHeader.FontHeightInPoints = 12;
fontHeader.Boldweight = 700;
int count = j * 3;
Cell cell = row.CreateCell(count);
cell.SetCellValue(RoomInfo[i]);
cell.CellStyle = SetCellAllCenterBorder();
cell.CellStyle.SetFont(fontHeader);
//将后面的两个单元格设置出来
SetCell(row, count + 1, string.Empty);
SetCell(row, count + 2, string.Empty);
//进行单元格合并
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(roomCout, roomCout, count, count + 2));
listCell.Add(cell);
}
//将影片信息按厅排列
List <IMovieShowList.MovieShow> li = listMovie.OrderBy(x => x.Room[0]).ToList <IMovieShowList.MovieShow>();
int rowIndex = 0;
int indexCol;
foreach (var item in listCell)
{
//当前厅名
string room = item.StringCellValue;
//找到当前厅的所有子集并且进行排序
List <IMovieShowList.MovieShow> s = (from i in li where i.Room == room select i).OrderBy(x => x.BeginTime).ToList <IMovieShowList.MovieShow>();
//如果rowIndex与上次一致,则不创建行,直接在原有的行上创建单元格
//保存之前的rowIndex;
rowIndex = item.RowIndex + 1; //3
indexCol = item.ColumnIndex; //0
//循环子集添加
foreach (var movie in s)
{
//获得下一行
Row rowCell = sheet.GetRow(rowIndex) ?? sheet.CreateRow(rowIndex);
//设置行高
rowCell.HeightInPoints = 20;
//在行下面创建三个单元格填充值
SetCell(rowCell, indexCol, movie.BeginTime);
SetCell(rowCell, indexCol + 1, movie.EndTime);
//单独处理电影名称,让其左对齐
//SetCell(rowCell, indexCol+2, movie.Name);
Cell cellName = rowCell.CreateCell(indexCol + 2);
cellName.CellStyle = cellLeftAllBorder();
cellName.SetCellValue(movie.Name);
rowIndex++;
}
}
//打开一个保存对话框,让用户保存数据
SaveFileDialog save = new SaveFileDialog();
save.Filter = "excel|*.xls";
save.FileName = headeValue + "--放映 ";
DialogResult res = save.ShowDialog();
if (res == DialogResult.OK)
{
string path = save.FileName;
try
{
FileStream file = new FileStream(path, FileMode.Create, FileAccess.Write);
hssfworkbook.Write(file);
file.Close();
MessageBox.Show("保存成功");
}
catch
{
MessageBox.Show("文件已打开,请先关闭文件");
return;
}
}
else
{
return;
}
}
/// <summary>
/// 场务表的导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void 场务表ToolStripMenuItem_Click(object sender, EventArgs e)
{
#region MyRegion
///创建集合用以保存排片信息
List <IMovieShowList.MovieShow> list = new List <IMovieShowList.MovieShow>();
try
{
if (newExcel)
{
ExcelSource ex = new ExcelSource();
list = ex.GetList4Excel(newFileName);
if (!ex.isOk)
{
MessageBox.Show(ex.Msg);
return;
}
}
else
{
//排片信息读取
list = movieList;
}
if (list.Count == 0)
{
MessageBox.Show("没有排片信息");
return;
}
}
catch
{
MessageBox.Show("未知错误,请重试");
return;
}
MovieEndTime end = new MovieEndTime();
list = end.GetMovieEndTimeList(list);
//将信息按时间排序
string headeValue = string.Empty;
bool ok = IsExcelOrApi(out headeValue, list);
if (!ok)
{
return;
}
//创建一个工作薄对象
hssfworkbook = new HSSFWorkbook();
//创建一张表
Sheet sheet = hssfworkbook.CreateSheet("场务表");
//创建第一行表头行
CreateR1(sheet, 0, 0, 0, 5, headeValue);
///-----设置列宽格式 开始------//
//设置第1列到第3列
SetColWidth(sheet, 0, 3, 10);
//设置第4列(电影名称列)
sheet.SetColumnWidth(3, 26 * 256 + 200);
//设置第5列到第6列
SetColWidth(sheet, 4, 2, 15);
///-----设置格式 结束------//
//创建一个单元格样式对象
CellStyle styleCell = SetCellAllCenterBorder();
#region 读取出数据
//创建行标识(第二行开始)
int count = 1;
//循环读取排片信息集合
foreach (IMovieShowList.MovieShow item in list)
{
//创建行
Row rowCell = sheet.CreateRow(count);
//设置行高
rowCell.HeightInPoints = 20;
//写入行信息
SetCellMovieInfo(rowCell, styleCell, item);
count++;
}
#endregion
//打开一个保存对话框,让用户保存数据
SaveFileDialog save = new SaveFileDialog();
save.Filter = "excel|*.xls";
save.FileName = headeValue + "--场务";//设置默认文件名
DialogResult res = save.ShowDialog();
if (res == DialogResult.OK)
{
string path = save.FileName;
try
{
FileStream file = new FileStream(path, FileMode.Create, FileAccess.Write);
hssfworkbook.Write(file);
file.Close();
MessageBox.Show("保存成功");
}
catch
{
MessageBox.Show("文件已打开,请先关闭文件");
return;
}
}
else
{
return;
}
#endregion
}
