/// <summary>
/// 帳票プリント
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
ExcelPrintChecks();
// 帳票をプリントする
if (chkRanking.Checked)
{
if (rdBook.Checked)
{
// 移送項目3
using (ExcelManager xlMgr = new ExcelManager(System.IO.Path.GetFullPath(BOOK_RANKING_NAME)))
{
// データ抜き出し
DataTable dt = dataGridView1.DataSource as DataTable;
int row = 6;
int col = 2;
int sheetPage = 1;
for (int i = 0; i < dataGridView1.Table.Rows.Count; i++)
{
for (int j = 0; j < dataGridView1.Table.Columns.Count; j++)
{
xlMgr.WriteCell <string>(dataGridView1.Table.Rows[i][j].ToString(), (row + i), (col + j), sheetPage);
}
}
// ランキング抽出期間の書き込み
row = 2;
col = 7;
string str = RecordTermString();
xlMgr.WriteCell <string>(str, row, col, sheetPage);
}
return;
}
if (rdUser.Checked)
{
// 移送項目4
using (ExcelManager xlMgr = new ExcelManager(System.IO.Path.GetFullPath(USER_RANKING_NAME)))
{
// データ抜き出し
DataTable dt = dataGridView1.DataSource as DataTable;
int row = 6;
int col = 2;
int sheetPage = 1;
for (int i = 0; i < dataGridView1.Table.Rows.Count; i++)
{
for (int j = 0; j < dataGridView1.Table.Columns.Count; j++)
{
xlMgr.WriteCell <string>(dataGridView1.Table.Rows[i][j].ToString(), row + i, col + j, sheetPage);
}
}
// ランキング抽出期間の書き込み
row = 2;
col = 4;
string str = RecordTermString();
xlMgr.WriteCell <string>(str, row, col, sheetPage);
}
return;
}
}
// 移送項目2
using (ExcelManager xlMgr = new ExcelManager(System.IO.Path.GetFullPath(HISTORY_NAME)))
{
// データ抜き出し
DataTable dt = dataGridView1.DataSource as DataTable;
int row = 10;
int col = 2;
int sheetPage = 1;
int recordNumBegin = 1;
int recordNumColumn = 1;
for (int i = 0; i < dataGridView1.Table.Rows.Count; i++)
{
xlMgr.WriteCell <int>((i + recordNumBegin), (row + i), recordNumColumn, sheetPage);
xlMgr.BorderWrite((row + i), recordNumColumn, sheetPage);
for (int j = 0; j < dataGridView1.Table.Columns.Count; j++)
{
xlMgr.WriteCell <string>(dataGridView1.Table.Rows[i][j].ToString(), (row + i), (col + j), sheetPage);
xlMgr.BorderWrite((row + i), (col + j), sheetPage);
}
}
row = 2;
col = 11;
xlMgr.WriteCell <string>(DateTime.Now.Date.ToString("yyyy-MM-dd"), row, col, sheetPage);
}
return;
}