//印刷データ
private string[,] hyoji = new string[500, 9];
private string [,] prtData=new string [3 ,6];
private int rowCnt = 0;
private int page = 1;
//改ページ変数
int rnum;
int maxRow = 45;
//グループの開始行と終了行など
private int[] sRow = new int[2]; //先頭
private int[] eRow = new int[2]; //最後
private int[] hRow = new int[2]; //班名行
private int[] mRow = new int[2]; //見出し行
private int[] kRow = new int[2]; //入金予定行
//描画する行の合計
private int rowSum = 0;
private void btnPrint_Click(object sender, EventArgs e)
{
sRow = new int[hanmei.Length]; //グループの開始行
eRow = new int[hanmei.Length]; //グループの終了行
hRow = new int[hanmei.Length]; //グループの班名行
mRow = new int[hanmei.Length]; //グループの見出し行
kRow = new int[hanmei.Length]; //グループの入金予定行
for (int i = 0; i <hanmei.Length; i++)
{
dvGroup.RowFilter = "group='" + hanmei[i] + "'";
rowCnt = suitoDataGridView.RowCount;//班のレコード数
sRow[i] = rowSum;
eRow[i] = rowSum + rowCnt + 3;
toRead(i, sRow[i], eRow[i]); //データ整形
rowSum += rowCnt + 4; //総レコード数
}
for (int i = 0; i < hanmei.Length; i++)
{
hRow[i] = sRow[i] + 1;
mRow[i] = sRow[i] + 2;
kRow[i] = sRow[i] + 3;
}
System.Drawing.Printing.PrintDocument pd =
new System.Drawing.Printing.PrintDocument();
pd.PrintPage +=
new System.Drawing.Printing.PrintPageEventHandler(printDocument1_PrintPage);
PrintDialog pdlg = new PrintDialog();
pdlg.Document = printDocument1;
if (pdlg.ShowDialog() == DialogResult.OK)
printDocument1.Print();
}
private void leftPad(int i, int j, int s)
{
hyoji[i, j] = suitoDataGridView[j + 1, i - s - 4].Value.ToString().PadLeft(2);
}
private void toRead(int h, int s, int e)
{
//印刷用データを整形
int inYotei = 0; //納入予定額
int inSum = 0; //累積納入額
int inKin = 0; //入金額
for (int i = s; i < e + 1; i++)
{
if (i == s)
{
for (int j = 0; j < 7; j++)
{
hyoji[i, j] = "";
}
}
else if (i == s + 1)
{
for (int j = 0; j < 7; j++)
{
hyoji[i, j] = "";
hyoji[i, 0] = "[" + hanmei[h] + "]班";
}
}
else if (i == s + 2)
{
hyoji[i, 0] = "月";
hyoji[i, 1] = "日";
hyoji[i, 2] = " 入金額";
hyoji[i, 3] = " 摘 要";
hyoji[i, 4] = " 納入額";
hyoji[i, 5] = " 未納額";
}
else if (i == s + 3)
{
for (int j = 0; j < 7; j++)
{
hyoji[i, j] = "";
}
hyoji[i, 3] = " 納入予定額";
hyoji[i, 4] = dgvSum[1, h].Value.ToString();
inYotei = int.Parse(hyoji[i, 4]);
hyoji[i, 4] = inYotei.ToString("#,###").PadLeft(2);
}
else
{
int pp = 0;
for (int j = 0; j < 4; j++)
{
if (j > 1) pp = 1; //班名は読み込まない
switch (j)
{
case 0:
case 1:
leftPad(i, j, s);
break;
default:
hyoji[i, j] = suitoDataGridView[j + 1 + pp, i - s - 4].Value.ToString();
break;
}
}
}
}
for (int i = s; i < e + 1; i++)
{
if (i > s + 3)
{
inKin = int.Parse(hyoji[i, 2]);
inSum += inKin;
hyoji[i, 2] = inKin.ToString("#,###").PadLeft(10);
hyoji[i, 4] = inSum.ToString("#,###").PadLeft(10);
hyoji[i, 5] = (inYotei - inSum).ToString("#,###").PadLeft(10);
}
}
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
drawLine(e); //データの表を描く
}
private void printDocument1_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
rnum = 0;
page = 1;
}
private void drawLine(System.Drawing.Printing.PrintPageEventArgs e)
{
Font f = new Font("ＭＳ ゴシック", 11);
int pitch = f.Height + 7; //行ピッチ
int x = 110; //印刷開始位置
int y = 110; //印刷開始位置
int Apage; //ページ番号
int cnt = 0;
int leftX = x;
int topY = y;
int lineY;
int lastlineY;
int[] moveX = new int[7]; //縦罫線の位置
int[] moveS = new int[7]; //文字列の位置
moveX[0] = x;
moveX[1] = moveX[0] + 23;
moveX[2] = moveX[1] + 23;
moveX[3] = moveX[2] + 88;
moveX[4] = moveX[3] + 200;
moveX[5] = moveX[4] + 88;
moveX[6] = moveX[5] + 88;
for (int s = 0; s < 7; s++)
{
moveS[s] = moveX[s] + 2;
}
int rectWidth = moveX[6] - x;
int rightX = moveX[6];
//セルの色（見出し&総計）
HatchBrush hBrushOO = new HatchBrush(HatchStyle.LightDownwardDiagonal, Color.SaddleBrown, Color.White);
HatchBrush hBrushOs = new HatchBrush(HatchStyle.LightDownwardDiagonal, Color.Coral, Color.White);
HatchBrush hBrushOg = new HatchBrush(HatchStyle.LightDownwardDiagonal, Color.Moccasin, Color.White);
//標題
f = new Font("ＭＳ ゴシック", 12);
e.Graphics.DrawString("会 費 収 納 簿", f, Brushes.Black, x + 150, y - 50);
//日付
f = new Font("ＭＳ 明朝", 9);
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("ja-JP");
System.Globalization.DateTimeFormatInfo dtfi = ci.DateTimeFormat;
dtfi.Calendar = new System.Globalization.JapaneseCalendar();
System.DateTime dTime = System.DateTime.Now;
e.Graphics.DrawString(dTime.ToString("ggy年M月d日 現在", dtfi), f, Brushes.Black, rightX - 138, y - 20);
//ページ番号
f = new Font("ＭＳ ゴシック", 10);
Apage = (rowSum % maxRow == 0) ? rowSum / maxRow : rowSum / maxRow + 1;
e.Graphics.DrawString(page + "/" + Apage + "page", f, Brushes.Black, rightX - 55, y - 60);
f = new Font("ＭＳ 明朝", 11);
int dataY = y;
do
{
if (rnum <= rowSum - 1)
{
lineY = dataY + f.Height - 1;
lastlineY = 0;
//見出し行塗潰しとフォント指定
if (Array.IndexOf(mRow, rnum) != -1)
{
e.Graphics.FillRectangle(hBrushOO, leftX, lineY - 16, rectWidth, pitch - 2);
f = new Font("ＭＳ ゴシック", 11);
}
else
{
f = new Font("ＭＳ 明朝", 11);
}
//下線-空白行以外
if (Array.IndexOf(sRow, rnum) == -1)
{
e.Graphics.DrawLine(Pens.Black, leftX, lineY + 5, rightX, lineY + 5);
lastlineY = lineY + 5;
}
//グループ毎の合計を強調する塗潰し
if (Array.IndexOf(eRow, rnum) != -1)
{
e.Graphics.FillRectangle(hBrushOs, moveX[4], lineY + 7 - pitch, 88 * 2, pitch -3);
}
//データを描画
for (int i = 0; i < 6; i++)
{
//入金予定行は特別色
if (Array.IndexOf(kRow, rnum) != -1)
e.Graphics.DrawString(hyoji[rnum, i], f, Brushes.Coral, moveS[i], dataY);
else
e.Graphics.DrawString(hyoji[rnum, i], f, Brushes.Black, moveS[i], dataY);
}
//縦線
Pen thinPen = new Pen(Color.Black, 0.3F);
if (Array.IndexOf(sRow, rnum) == -1 && Array.IndexOf(hRow, rnum) == -1)
{
for (int i = 0; i < 7; i++)
{
if (i >= 1 && i <= 5)
e.Graphics.DrawLine(thinPen, moveX[i], lastlineY - pitch, moveX[i], lastlineY);
else
e.Graphics.DrawLine(Pens.Black, moveX[i], lastlineY - pitch, moveX[i], lastlineY);
}
}
}
dataY += pitch;
rnum++;
cnt++;
//改ページの確認
if (cnt >= maxRow)
{
e.HasMorePages = true;
page++;
break;
}
} while (rnum <= rowSum - 1);
//最終ページの罫線
if (rnum == rowSum - 1)
{
e.HasMorePages = false;
}
}
