public void ExecutePreview()
{
this.Hide();
DataSet ds = new DataSet();
ds.Tables.Add(new bllUser().GetUsers().Copy());//取报表数据
_report = new TfrxReportClass();
_report.OnBeforePrint += new IfrxReportEventDispatcher_OnBeforePrintEventHandler(Report_OnBeforePrint);
_report.OnAfterPrint += new IfrxReportEventDispatcher_OnAfterPrintEventHandler(Report_OnAfterPrint);
ds.Tables[0].TableName = "User"; //设置表名，与FastReport报表内名称定义一致
dtSummary = new FrxDataTable(ds.Tables[0]); //创建报表代理数据
_report.MainWindowHandle = (int)this.Handle; //设置报表窗体的主窗体
_report.LoadReportFromFile(GetReportFile("users.fr3")); //加载报表文件
_report.ClearDatasets(); //先清空报表数据
dtSummary.AssignToReport(true, _report); //设置报表的主数据源
dtSummary.AssignToDataBand("MasterData1", _report); //绑定主表的报表数据
frmPrintViewerFR.ExecutePreview(this, _report); //显示打印预览窗体
this.Close(); //预览或打印完成关闭本窗体
}
private void reportPrint(List <titletable> title, List <TB_EXPENSE> detail, List <foots> fs)
{
try
{
ReportTools myReportTool;
TfrxReportClass report;
myReportTool = new ReportTools();
report = new TfrxReportClass();
report.ClearDatasets();
FrxDataTable titleable = new FrxDataTable("dtWorkTitle"); //概要
myReportTool.ListToFrxTable(title, titleable);
FrxDataTable detailtable = new FrxDataTable("dtWorkDetail"); //明细
myReportTool.ListToFrxTable(detail, detailtable);
FrxDataTable detailtable2 = new FrxDataTable("dtWorkDetail2"); //明细2
myReportTool.ListToFrxTable(fs, detailtable2);
report.LoadReportFromFile("ExpenseReport.fr3");
detailtable.AssignToReport(true, report);
titleable.AssignToReport(true, report);
report.ShowReport();
}
catch (System.Exception ex)
{
MessageHelper.ShowMessage(ex.Message);
}
}
/// <summary>
/// 设置报表Label的文本
/// </summary>
/// <param name="report"></param>
/// <param name="key"></param>
/// <param name="vlaue"></param>
public static void SetMemoText(TfrxReportClass report, string key, object vlaue)
{
IfrxComponent memo = report.FindObject(key);
if (memo != null)
{
string text = "";
if (vlaue != null)
{
text = vlaue.ToString();
}
IfrxCustomMemoView control = memo as IfrxCustomMemoView;
if (control != null)
{
control.Text = text;
}
else
{
IfrxBarCodeView controlbar = memo as IfrxBarCodeView;
if (controlbar != null)
{
controlbar.Text = text;
}
}
}
}
//准备报表数据
private void PrepareReport()
{
//取报表数据
DataSet ds = new bllSO().GetReportData(txtNoFrom.Text, txtNoTo.Text, txtDateFrom.DateTime, txtDateTo.DateTime);
//报表实例
_report = new TfrxReportClass();
_report.OnBeforePrint += new IfrxReportEventDispatcher_OnBeforePrintEventHandler(Report_OnBeforePrint);
_report.OnAfterPrint += new IfrxReportEventDispatcher_OnAfterPrintEventHandler(Report_OnAfterPrint);
ds.Tables[0].TableName = "M"; //Master 主表
ds.Tables[1].TableName = "D"; //Detail 明细
dtSummary = new FrxDataTable(ds.Tables[0]); //创建主表的报表代理数据
dtDetailView = new FrxDataView(ds.Tables[1], "D"); //创建明细表的报表代理数据
//主从表数据需要绑定3个事件, 取主表的主键用于过滤明细数据
dtSummary.FrxEventOnFirst += new FrxOnFirst(OnGetValueHandler); //对应Delphi的DataSet.First
dtSummary.FrxEventOnNext += new FrxOnNext(OnGetValueHandler); //对应Delphi的DataSet.Next
dtSummary.FrxEventOnPrior += new FrxOnPrior(OnGetValueHandler); //对应Delphi的DataSet.Prior
_report.MainWindowHandle = (int)this.Handle;
_report.LoadReportFromFile(GetReportFile("SO.fr3")); //从文件加载报表
_report.ClearDatasets();
dtSummary.AssignToReport(true, _report); //绑定报表数据集
dtDetailView.AssignToReport(true, _report); //绑定报表数据集
dtSummary.AssignToDataBand("MasterData1", _report); //绑定主表Band
dtDetailView.AssignToDataBand("DetailData1", _report); //绑定明细表Bank
}
/// <summary>
/// Assigns table to report
/// </summary>
public void AssignToDataBand(string BandName, TfrxReportClass report)
{
IfrxComponent frx_component;
frx_component = ((IfrxComponent)report).FindObject(BandName);
((IfrxDataBand)frx_component).DataSet = (IfrxDataSet)m_ds;
}
public void AssignToDataBand(string BandName, TfrxReportClass report)
{
IfrxComponent component;
((IfrxComponent)report).FindObject(BandName, out component);
((IfrxDataBand)component).DataSet = (IfrxDataSet)this.m_ds;
}
public void BindToReport(TfrxReportClass report)
{
foreach (DataTable tbl in Tables)
{
FrxDataTable local_table = new FrxDataTable(tbl);
frx_tables_array.Add(local_table);
local_table.AssignToReport(true, report);
}
}
public void UnbindFromReport(TfrxReportClass report)
{
foreach (FrxDataTable local_table in frx_tables_array)
{
local_table.AssignToReport(false, report);
local_table.Dispose();
}
frx_tables_array.Clear();
}
public static void Print(TfrxReportClass report)
{
report.ShowProgress = false;
report.PrintOptions.ShowDialog = false;
report.PrintOptions.PageNumbers = "";
report.PrepareReport(true);
report.PrintReport();
report.ClearDatasets();
}
/// <summary>
/// 显示预览窗体
/// </summary>
public static void ExecutePreview(Form owner, TfrxReportClass report)
{
frmPrintViewerFR preview = new frmPrintViewerFR();
preview.ShowInTaskbar = false;
preview.Text = "打印预览窗体";
preview.Owner = owner;
preview._CurrentReport = report;
preview._CurrentOwnerForm = owner;
preview.ShowDialog();
}
public static void PrintByPrinterName(TfrxReportClass report, string printerName)
{
report.ShowProgress = false;
report.PrintOptions.ShowDialog = false;
report.PrintOptions.PageNumbers = "";
report.PrintOptions.Printer = printerName;
report.PrepareReport(true);
report.PrintReport();
report.ClearDatasets();
report.ClearReport();
}
private void button7_Click(object sender, EventArgs e)
{
TfrxReportClass report;
report = new TfrxReportClass();
report.ReportOptions.ConnectionName = @"Database=database1;Data Source=127.0.0.1;User Id=root;Password="******"C:/Users/Asus/Desktop/2.fr3");
// report.DesignReport(); редактирование отчета
report.ShowReport();
report.PrintOptions.PageNumbers = "";
report.ExportToTXT("export2.txt", true, true, true, true);
}
private void updatebarcodeFrm_Load(object sender, EventArgs e)
{
lbbarcode.Text = this._barcode;
DataSet ds = null;
string sqlstr = "select * from WMS_Bms_Inv_Info where barcode='" + _barcode + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
SpinEdit1.Value = int.Parse(ds.Tables[0].Rows[0]["gh"].ToString());
inisx(_pch);
BindBHGR();
if (Report == null)
{
Report = new TfrxReportClass();
}
}
/// <summary>
/// 导出报表数据
/// </summary>
/// <param name="report">报表实例</param>
/// <returns></returns>
public string ExportToFile(TfrxReportClass report)
{
string fileName = Path.GetTempPath() + @"\_rpt" + DateTime.Now.ToString("yyyyMMddhhmmss") + "_" + Loginer.CurrentUser.Account;
if (ExportType.PDF == _exportType)//PDF
{
fileName = fileName + ".pdf";
report.ExportToPDF(fileName, false, false, false);
}
else if (ExportType.XLS == _exportType)//XLS
{
fileName = fileName + ".xls";
report.ExportToXLS(fileName, true, false, false, false, true);
}
else if (ExportType.HTML == _exportType)//HTML
{
fileName = fileName + ".html";
report.ExportToHTML(fileName, true, true, false, false, true, true);
}
return(fileName);
}
private void reportPrint(List <projProfileClass> summery, List <TB_EXPENSE> detail)
{
try
{
ReportTools myReportTool;
TfrxReportClass report;
myReportTool = new ReportTools();
report = new TfrxReportClass();
report.ClearDatasets();
FrxDataTable summeryTable = new FrxDataTable("dtWorkTitle"); //概要
myReportTool.ListToFrxTable(summery, summeryTable);
FrxDataTable detailtable = new FrxDataTable("dtWorkDetail"); //明细
myReportTool.ListToFrxTable(detail, detailtable);
report.LoadReportFromFile("profileReport.fr3");
summeryTable.AssignToReport(true, report);
detailtable.AssignToReport(true, report);
report.ShowReport();
}
catch (System.Exception ex)
{
MessageHelper.ShowMessage(ex.Message);
}
}
private void btn_lbdesign_Click(object sender, EventArgs e)
{
if (dgvm.SelectedRows.Count == 0)
{
return;
}
if (dgv.SelectedRows.Count == 0)
{
return;
}
string modename = dgvm.SelectedRows[0].Cells[0].Value.ToString();
string lbname = dgv.SelectedRows[0].Cells[0].Value.ToString();
if (modename == "标准模板")
{
MessageBox.Show("标准模板不允许设计！", "系统提示");
return;
}
string filefullpath = Application.StartupPath + "\\report\\" + modename + "\\" + lbname;
TfrxReportClass Report = Report = new TfrxReportClass();
if (!File.Exists(filefullpath))
{
MessageBox.Show("标签文件不存在！", "系统提示");
return;
}
try
{
Report.LoadReportFromFile(filefullpath);
}
catch (System.Exception ex)
{
MessageBox.Show("加载打印模板错误，请联系系统管理员！" + ex.Message, "系统错误");
return;
}
Report.DesignReport();
}
public void BindTableToBand(string table_name, TfrxReportClass report, string band_name)
{
IfrxComponent MasterData3;
MasterData3 = (report as IfrxComponent).FindObject(band_name);
if (MasterData3 is IfrxDataBand)
{
if (table_name == null || table_name == "")
{
(MasterData3 as IfrxDataBand).ResetDataSet();
}
else
{
foreach (FrxDataTable local_table in frx_tables_array)
{
if (local_table.TableName == table_name)
{
(MasterData3 as IfrxDataBand).DataSet = local_table.FrxTable;
}
}
}
}
MasterData3 = null;
}
public static void Preview(TfrxReportClass report)
{
report.PrepareReport(true);
report.ShowReport();
}
private void printpq(string barcode, string strJz)
{
string scriptstr = "";
string ph, gg, pch, jz, rq, bb, gh, bz, xlh, tm, ckcxh, sx, pcxx, bzstr, bbtemp, printmodual, stpath, tct, wlh;
bool ckflg, nocheck;
int iType;
if (chkTSXX.Checked)
{
if (chkCPDJ.Checked)
{
iType = 4;
}
else
{
iType = 3;
}
}
else
{
if (chkCPDJ.Checked)
{
iType = 2;
}
else
{
iType = 1;
}
}
printmodual = Public.GetXmlValue("PrintModuleName");
if (printmodual == "")
{
printmodual = "标准模板";
}
stpath = Application.StartupPath + "\\report\\" + printmodual + "\\";
if (!Directory.Exists(stpath))
{
MessageBox.Show("标签模板不存在！", "系统提示");
return;
}
string strSql = "select * from " + tablename + " where barcode='" + barcode.Trim() + "'";
DataSet ds = DbEntry.Context.ExecuteDataset(strSql);
ph = ds.Tables[0].Rows[0]["PH"].ToString();
gg = ds.Tables[0].Rows[0]["GG"].ToString();
pch = ds.Tables[0].Rows[0]["PCH"].ToString();
jz = strJz;
rq = ds.Tables[0].Rows[0]["ProduceData"].ToString();
bb = ds.Tables[0].Rows[0]["bb"].ToString();
pcxx = ds.Tables[0].Rows[0]["pcinfo"].ToString();
gh = Convert.ToInt32(ds.Tables[0].Rows[0]["gh"]).ToString().PadLeft(2, '0');
sx = ds.Tables[0].Rows[0]["SX"].ToString();
if (sx.ToUpper() == "CK")
{
bz = ds.Tables[0].Rows[0]["GH"].ToString().PadLeft(2, '0');
}
else
{
bz = ds.Tables[0].Rows[0]["bz"].ToString();
}
xlh = this.txtLSH.Text;
tm = barcode;
wlh = ds.Tables[0].Rows[0]["wlh"].ToString();
ckcxh = ds.Tables[0].Rows[0]["ckcxh"].ToString();
if ((sx == "B2") || (sx == "C2"))
{
nocheck = false;
}
else
{
nocheck = true;
}
TfrxReportClass Report = new TfrxReportClass();
scriptstr = "begin" + "\r\n";
if (sx == "CK")
{
Report.LoadReportFromFile(stpath + "ckcz.fr3");
scriptstr += "memspec.Text:='" + pcxx + "';";
if (this.chkTSXX.Checked)
{
scriptstr += "memspec.visible:=true;";
}
else
{
scriptstr += "memspec.visible:=false;";
}
}
else
{
switch (iType)
{
case 1:
Report.LoadReportFromFile(stpath + "ptcz1.fr3");
break;
case 2:
Report.LoadReportFromFile(stpath + "ptcz2.fr3");
scriptstr += "memosx.text:='" + sx + "';";
if (!nocheck)
{
scriptstr += "memosx.visible:=false;";
scriptstr += "Shape1.visible:=false;";
}
else
{
scriptstr += "memosx.visible:=true;";
scriptstr += "Shape1.visible:=true;";
}
break;
case 3:
Report.LoadReportFromFile(stpath + "ptcz3.fr3");
scriptstr += "memopcinfo.text:='" + pcxx + "';";
if (!nocheck)
{
scriptstr += "memopcinfo.visible:=false;";
}
else
{
scriptstr += "memopcinfo.visible:=true;";
}
break;
case 4:
Report.LoadReportFromFile(stpath + "ptcz4.fr3");
scriptstr += "memopcinfo.text:='" + pcxx + "';";
if (!nocheck)
{
scriptstr += "memopcinfo.visible:=false;";
scriptstr += "Shape1.visible:=false;";
}
else
{
scriptstr += "memopcinfo.visible:=true;";
scriptstr += "Shape1.visible:=true;";
}
break;
}
}
scriptstr += "Barcode1.text:='" + tm + "';";
scriptstr += "memoph.text:='" + ph + "';";
scriptstr += "memogg.text:='" + gg + "';";
scriptstr += "memopch.text:='" + pch + "';";
double fjz = Convert.ToDouble(jz);;
scriptstr += "memojz.text:='" + fjz.ToString() + " kg';";
scriptstr += "memorq.text:='" + rq + "';";
scriptstr += "memogh.text:='" + gh + "';";
//bbtemp = "";
//if (bb == "甲班") bbtemp = "A";
//if (bb == "乙班") bbtemp = "B";
//if (bb == "丙班") bbtemp = "C";
//if (bb == "丁班") bbtemp = "D";
//scriptstr += "memobb.text:='" + bbtemp + "';";
//如果炉号为空，则再次查询nc
if (txtheatid.Text.Trim() == "")
{
string loadSql = "";
loadSql += "select mm_wr_b.pch,getbilletbatchcode(mm_wr_b.pch) billet_heat_number,";
loadSql += " mm_po.xsddh customer_material_number";
loadSql += " from mm_wr_b mm_wr_b, mm_mo mm_mo, mm_mosource mm_mosource, mm_po mm_po";
loadSql += " where mm_wr_b.scddid = mm_mo.pk_moid and mm_mo.pk_moid = mm_mosource.scddid";
loadSql += " and mm_mosource.lyid = mm_po.pk_poid and mm_po.pk_corp = '1001'";
loadSql += " and mm_po.dr = 0 and mm_mosource.pk_corp = '1001' and mm_mosource.dr = 0 ";
loadSql += " and mm_mo.pk_corp = '1001' and mm_mo.dr = 0 and mm_wr_b.pk_corp = '1001'";
loadSql += " and mm_wr_b.dr = 0 and mm_wr_b.pch = '" + pch + "'";
//OracleConnection conn = new OracleConnection("Data Source=192.168.2.221/orcl;User ID=nctest;Password=nctest;");
//OracleConnection conn = new OracleConnection("Data Source=nctest;User ID=nctest;Password=nctest;");
OracleConnection conn = new OracleConnection("Data Source=ncv5;User ID=xgerp50;Password=xgerp204212350;");
conn.Open();
OracleCommand selectCmd = conn.CreateCommand();
selectCmd.CommandText = loadSql;
// selectCmd.BindByName = true;
OracleDataAdapter oradap = new OracleDataAdapter(selectCmd);
DataSet ds1 = new DataSet();
oradap.Fill(ds1);
conn.Close();
if (ds1 == null || ds1.Tables.Count == 0 || ds1.Tables[0].Rows.Count == 0)
{
}
else
{
txtheatid.Text = ds1.Tables[0].Rows[0]["billet_heat_number"].ToString();
txtGgHeatid.Text = ds1.Tables[0].Rows[0]["billet_heat_number"].ToString();
txtliaohao.Text = ds1.Tables[0].Rows[0]["customer_material_number"].ToString();
}
}
//库内补打 料号判断 异常情况料号置空
if ((txtliaohao.Text.ToString().Trim() != "") && (tablename == "WMS_Bms_Inv_Info"))
{
string sql = " SELECT invinfo.WGDH FROM WMS_Bms_Inv_Info AS invinfo LEFT OUTER JOIN WMS_Bms_Rec_WGD AS wgd ON invinfo.PCH = wgd.PCH WHERE (invinfo.WLH = wgd.YWLH) AND (invinfo.vfree1 = wgd.vfree1) AND ";
sql += " (wgd.yvfree1 = wgd.vfree1) AND (invinfo.vfree2 = wgd.vfree2) AND (wgd.yvfree2 = wgd.vfree2) AND (invinfo.vfree3 = wgd.vfree3) AND (wgd.yvfree3 = wgd.vfree3) AND (invinfo.SX IN ('AAA', 'AA', 'A', 'CK')) AND ";
sql += " invinfo.barcode='" + barcode.Trim() + "'";
DataSet dstable = DbEntry.Context.ExecuteDataset(sql);
if ((dstable == null) || (dstable.Tables.Count == 0) || dstable.Tables[0].Rows.Count == 0)
{
txtliaohao.Text = "";
}
}
if (txtliaohao.Text.ToString().Trim() != "")
{
scriptstr += "Memliao.text:='" + txtliaohao.Text.ToString().Trim() + "';";
scriptstr += "Memliao.visible:=true;";
scriptstr += "memliao1.visible:=true;";
scriptstr += "Lineliao.visible:=true;";
}
//修改添加 炉次 删除班别
scriptstr += "memobb.text:='" + txtheatid.Text.ToString().Trim() + "';";
if (sx != "CK")
{
string bzstrf = "";
bzstrf = bz.Substring(bz.IndexOf('~') + 1);
scriptstr += "memobz.text:='" + bzstrf + "';";
}
else
{
scriptstr += "memoxlh.text:='" + xlh + "';";
}
scriptstr += "memowlh.text:='" + wlh.Substring(0, 3) + "';";
scriptstr += "end.";
Report.ScriptText = scriptstr;
Report.PrepareReport(true);
int con = 2;
if (this.numTxt.Value > 0)
{
con = int.Parse(numTxt.Value.ToString());
}
Report.PrintOptions.ShowDialog = false;
Report.PrintOptions.Copies = con;
try
{
if (this.chkBowse.Checked)
{
Report.ShowReport();
}
else
{
Report.PrintReport();
}
}
catch (System.Exception ex)
{
MessageBox.Show("打印错误：" + ex.Message + ".请补打！");
}
}
public static void Design(TfrxReportClass report)
{
report.PrepareReport(true);
report.DesignReport();
}
/// <summary>
/// Assigns table to report
/// </summary>
public void AssignToReport(bool Enable, TfrxReportClass report)
{
report.SelectDataset(Enable, m_ds);
}
