public DataTable getPrintData(Nyuukin_Ichihanyou_Entity nie)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>();
dic.Add("@paystart", new ValuePair {
value1 = SqlDbType.Date, value2 = nie.paymentstart
});
dic.Add("@payend", new ValuePair {
value1 = SqlDbType.Date, value2 = nie.paymentend
});
dic.Add("@payinputstart", new ValuePair {
value1 = SqlDbType.Date, value2 = nie.paymentinputstart
});
dic.Add("@payinputend", new ValuePair {
value1 = SqlDbType.Date, value2 = nie.paymentinputend
});
dic.Add("@StoreName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = nie.cbo_store
});
dic.Add("@WebCollectType", new ValuePair {
value1 = SqlDbType.VarChar, value2 = nie.cbo_torikomi
});
dic.Add("@CollectCustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = nie.search_customer
});
dic.Add("@Is_All", new ValuePair {
value1 = SqlDbType.Int, value2 = nie.rdb_all
});
UseTransaction = true;
return(SelectData(dic, "D_NyuuKinPrint"));
}
public NyuukinItiranHyou()
{
InitializeComponent();
this.KeyUp += NyuukinItiranHyou_KeyUp;
nih = new Nyuukin_Ichihanyou_BL();
previewForm = new Viewer();
nie = new Nyuukin_Ichihanyou_Entity();
dtlog = new DataTable();
}
protected Nyuukin_Ichihanyou_Entity GetNyuukinData()
{
nie = new Nyuukin_Ichihanyou_Entity();
nie.paymentstart = paymentstart.Text;
nie.paymentend = paymentend.Text;
nie.cbo_store = cbo_store.Text;
nie.paymentinputstart = paymentinputstart.Text;
nie.paymentinputend = paymentinputend.Text;
nie.cbo_torikomi = String.IsNullOrWhiteSpace(cbo_torikomi.Text)? null : cbo_torikomi.SelectedValue.ToString().Equals("-1") ? string.Empty : cbo_torikomi.SelectedValue.ToString();
nie.search_customer = search_customer.TxtCode.Text;
nie.rdb_all = rdb_all.Checked ? "1" : "0";
return(nie);
}
public DataTable getPrintData(Nyuukin_Ichihanyou_Entity nie)
{
return(nidl.getPrintData(nie));
}
protected override void PrintSec()
{
// レコード定義を行う
// DataTable table = new DataTable();
if (ErrorCheck())
{
nie = GetNyuukinData();
DataTable table = dtlog = nih.getPrintData(nie);
try
{
if (table == null)
{
return;
}
DialogResult ret;
var Report = new DataSet.Nyuukin_Ichihanyou();
switch (PrintMode)
{
case EPrintMode.DIRECT:
ret = bbl.ShowMessage("Q202");
if (ret == DialogResult.Cancel)
{
return;
}
Report.SetDataSource(table);
Report.Refresh();
Report.SetParameterValue("txtStoreName", cbo_store.SelectedValue.ToString() + " " + nie.cbo_store);
Report.SetParameterValue("txtDateTime", table.Rows[0]["yyyymmdd"].ToString() + " " + table.Rows[0]["mmss"].ToString());
vr = previewForm.CrystalReportViewer1;
if (ret == DialogResult.Yes)
{
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)
{
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:
bbl.ShowMessage("I202");
break;
}
var dt = new DataTable();
dt.Columns.Add("StoreCD");
for (int i = 0; i < dtlog.Rows.Count; i++)
{
if (!String.IsNullOrWhiteSpace(dtlog.Rows[i]["StoreCD"].ToString()) && !dtlog.Rows[i]["StoreCD"].Equals(null))
{
dt.Rows.Add(dtlog.Rows[i]["StoreCD"].ToString());
}
}
dt.AcceptChanges();
nih.L_Log_Insert_Print(new string[] { InOperatorCD, InPcID, InProgramID }, dt);
}
finally
{
paymentstart.Focus();
}
}
}
