private void UrikakekinTairyuuHyou_Load(object sender, EventArgs e)
{
InProgramID = "UrikakekinTairyuuHyou";
ukkthbl = new UrikakekinTairyuuHyou_BL();
// SetFunctionLabel(EProMode.MENTE);
SetFunctionLabel(EProMode.PRINT);
StartProgram();
ModeVisible = false;
Btn_F2.Text = string.Empty;
Btn_F9.Text = string.Empty;
//Btn_F10.Text = string.Empty;
Btn_F11.Text = string.Empty;
Btn_F10.Text = "出力(F10)";
BindData();
SetRequireField();
}
protected override void PrintSec()
{
// レコード定義を行う
// DataTable table = new DataTable();
ukkthbl = new UrikakekinTairyuuHyou_BL();
string header = string.Empty;
DataTable dtPrint;
if (PrintMode != EPrintMode.DIRECT)
{
return;
}
if (ErrorCheck())
{
msce = new M_StoreClose_Entity();
msce = GetStoreClose_Data();
DateTime now = Convert.ToDateTime(txtDate.Text.ToString() + "/01 00:00:00");
string[] strmonth = new string[12];
for (int i = 11; i >= 0; i--)
{
strmonth[i] = now.AddMonths(-i).ToString().Substring(0, 7);
}
dtPrint = ukkthbl.Select_DataToExport(msce);
//header = "棚入れリスト";
try
{
if (dtPrint == null || dtPrint.Rows.Count <= 0)
{
bbl.ShowMessage("E128");
txtDate.Focus();
}
else
{
string customerCD = string.Empty;
for (int i = 0; i < dtPrint.Rows.Count; i++)
{
if (customerCD != dtPrint.Rows[i]["CustomerCD"].ToString())
{
customerCD = dtPrint.Rows[i]["CustomerCD"].ToString();
}
DataTable dtResult = dtPrint.Select("SaleA='売上' and CustomerCD='" + customerCD + "'").CopyToDataTable();
if (dtResult.Rows.Count == 1)
{
dtPrint.Rows[i]["Result"] = dtResult.Rows[0]["Result"].ToString();
}
}
//xsdファイルを保存します。
//①保存した.xsdはプロジェクトに追加しておきます。
DialogResult ret;
UrikakekinTairyuuHyou_Report Report = new UrikakekinTairyuuHyou_Report();
switch (PrintMode)
{
case EPrintMode.DIRECT:
ret = bbl.ShowMessage("Q202");
if (ret == DialogResult.No)
{
return;
}
//}
// 印字データをセット
Report.SetDataSource(dtPrint);
Report.Refresh();
Report.SetParameterValue("txtStore", cboStore.SelectedValue.ToString() + " " + cboStore.Text);
Report.SetParameterValue("txtMonth11", strmonth[11].ToString());
Report.SetParameterValue("txtMonth10", strmonth[10].ToString());
Report.SetParameterValue("txtMonth9", strmonth[9].ToString());
Report.SetParameterValue("txtMonth8", strmonth[8].ToString());
Report.SetParameterValue("txtMonth7", strmonth[7].ToString());
Report.SetParameterValue("txtMonth6", strmonth[6].ToString());
Report.SetParameterValue("txtMonth5", strmonth[5].ToString());
Report.SetParameterValue("txtMonth4", strmonth[4].ToString());
Report.SetParameterValue("txtMonth3", strmonth[3].ToString());
Report.SetParameterValue("txtMonth2", strmonth[2].ToString());
Report.SetParameterValue("txtMonth1", strmonth[1].ToString());
Report.SetParameterValue("txtMonth0", strmonth[0].ToString());
if (ret == DialogResult.Yes)
{
var previewForm = new Viewer();
previewForm.CrystalReportViewer1.ShowPrintButton = true;
previewForm.CrystalReportViewer1.ReportSource = Report;
previewForm.ShowDialog();
}
else /// //Still Not Working because of Applymargin and Printer not Setting up (PTK Will Solve)
{
//int marginLeft = 360;
CrystalDecisions.Shared.PageMargins margin = Report.PrintOptions.PageMargins;
margin.leftMargin = DefaultMargin.Left; // mmの指定をtwip単位に変換する
margin.topMargin = DefaultMargin.Top;
margin.bottomMargin = DefaultMargin.Bottom; //mmToTwip(marginLeft);
margin.rightMargin = DefaultMargin.Right;
Report.PrintOptions.ApplyPageMargins(margin); /// Error Now
// プリンタに印刷
System.Drawing.Printing.PageSettings ps;
try
{
System.Drawing.Printing.PrintDocument pDoc = new System.Drawing.Printing.PrintDocument();
CrystalDecisions.Shared.PrintLayoutSettings PrintLayout = new CrystalDecisions.Shared.PrintLayoutSettings();
System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings();
Report.PrintOptions.PrinterName = "\\\\dataserver\\Canon LBP2900";
System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings);
Report.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
Report.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex;
Report.PrintToPrinter(printerSettings, pSettings, false, PrintLayout);
}
catch (Exception ex)
{
}
}
break;
case EPrintMode.PDF:
if (bbl.ShowMessage("Q204") != DialogResult.Yes)
{
return;
}
string filePath = "";
if (!ShowSaveFileDialog(InProgramNM, out filePath))
{
return;
}
// 印字データをセット
Report.SetDataSource(dtPrint);
Report.Refresh();
Report.SetParameterValue("txtSouko", cboStore.SelectedValue.ToString() + " " + cboStore.Text);
Report.SetParameterValue("txtHeader", header);
bool result = OutputPDF(filePath, Report);
//PDF出力が完了しました。
bbl.ShowMessage("I202");
break;
}
//InsertLog(Get_L_Log_Entity(dtPrint));
}
}
finally
{
}
}
}
