private void button1_Click(object sender, EventArgs e)
{
DateTime d_rq1 = dateTimePicker1.Value.Date;
DateTime d_rq2 = dateTimePicker1.Value.AddDays(1).Date;
var dataList = SqlUtil.Inst.Orders.Where(a => a.date >= d_rq1 && a.date < d_rq2).ToList().Select(a => new {
no = a.no,
date = a.date.ToString("yyyy年MM月dd日"),
zje = a.zje.ToString("0.00"),
yhje = a.yhje.ToString("0.00"),
ssje = (a.zje - a.yhje).ToString("0.00"),
zffs = a.zffs
}).ToList();
Assembly assembly = Assembly.GetExecutingAssembly();
//获取指定的资源
using (Stream stream = assembly.GetManifestResourceStream("DishSysManager.daily_mx.frx"))
{
if (stream != null) //没有找到，GetManifestResourceStream会返回null
{
report.Clear();
report.Load(stream);
report.RegisterData(dataList, "mx");
report.Preview = this.previewControl1;
report.Prepare();
report.ShowPrepared();
}
}
}
public FrmMain()
{
InitializeComponent();
FastReport.Report report = new FastReport.Report();
string fileName = Path.Combine(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "steelorder.frx");
report.Load(fileName);
report.Page.Height = 1000;
report.ShowPrepared();
}
/// <summary>
/// FastReports
/// </summary>
/// <param name="isDesign"></param>
private void FastReports(bool isDesign)
{
System.Data.DataSet printDataDs = new System.Data.DataSet();
try
{
int[] rownumber = this.gridViewMainData.GetSelectedRows();
DataRow row = this.gridViewMainData.GetDataRow(rownumber[0]);
System.Data.DataTable mainData = ToDataTable(row);
System.Data.DataTable detailsData = ((DataView)this.gridViewDetailsData.DataSource).ToTable();
if (mainData != null && mainData.Rows.Count > 0)
{
mainData.TableName = "mainData";
printDataDs.Tables.Add(mainData.Copy());
}
if (detailsData != null && detailsData.Rows.Count > 0)
{
detailsData.TableName = "detailsData";
printDataDs.Tables.Add(detailsData.Copy());
}
FastReport.Report report = new FastReport.Report();
Res.LocaleFolder = AppDomain.CurrentDomain.BaseDirectory + "FastReports\\Localization";
Res.LoadLocale(Res.LocaleFolder + @"\Chinese (Simplified).frl");
string FDataTables = "FDataTables";
string filename = @"FastReports\Reports\fx_001.frx";
report.Load(filename);
using (Designer designer = new Designer())
{
designer.SetModified(this, "EditData");
int i = 0;
foreach (DataTable dt in printDataDs.Tables)
{
FDataTables = "FDataTables" + i.ToString();
printDataDs.Tables[i].TableName = FDataTables;
report.RegisterData(printDataDs.Tables[i], FDataTables);
report.GetDataSource(FDataTables).Enabled = true;
i = i + 1;
}
Res.LocaleFolder = AppDomain.CurrentDomain.BaseDirectory + "FastReports\\Localization";
Res.LoadLocale(Res.LocaleFolder + @"\Chinese (Simplified).frl");
if (isDesign)
{
report.Design();
}
else
{
report.SetParameterValue("time", DateTime.Now.Date.ToString("yyyy-MM-dd"));
report.Prepare();
report.ShowPrepared();
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void ShowModels(List <Maticsoft.Model.SMT_VERMODEL_INFO> infos)
{
modelTree.Nodes[1].Nodes.Clear();
foreach (var item in infos)
{
Node model = new Node(item.VERM_NAME);
model.Tag = item;
modelTree.Nodes[1].Nodes.Add(model);
if (_lastSelectModel != null && _lastSelectModel.ID == item.ID)
{
_lastSelectModel = item;
modelTree.SelectedNode = model;
}
}
if (_lastSelectModel == null)
{
_report.Clear();
_report.Prepare();
_report.ShowPrepared();
}
modelTree.ExpandAll();
}
public void ShowReport(Stream stream)
{
// TODO: Вынести в инициализацию EPS клиента
Config.PreviewSettings.ShowInTaskbar = true;
var report = new FastReport.Report();
report.LoadPrepared(stream);
var lfs = LocalizationResources.RussianFastReport;
if (lfs != null && lfs.Length > 0)
{
Res.LoadLocale(new MemoryStream(lfs));
}
report.ShowPrepared(false, this);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.SelectedRows.Count <= 0)
{
return;
}
var order = dataGridView1.SelectedRows[0].DataBoundItem as Data.Order;
if (order == null)
{
return;
}
var dataList = SqlUtil.Inst.Details.Where(a => a.ord_no == order.no).ToList();
Assembly assembly = Assembly.GetExecutingAssembly();
List <Order> dataList2 = new List <Order>();
dataList2.Add(order);
var hz = dataList2.Select(a => new
{
date = a.date.ToString("yyyy-MM-dd HH:mm"),
zje = a.zje.ToString("0.00"),
yhje = a.yhje.ToString("0.00"),
sfje = (a.zje - a.yhje).ToString("0.00"),
a.desk, ord_no = a.no
}).ToList();
//获取指定的资源
using (Stream stream = assembly.GetManifestResourceStream("DishSysManager.daily_cp.frx"))
{
if (stream != null) //没有找到，GetManifestResourceStream会返回null
{
report.Clear();
//this.previewControl1.Clear();
report.Load(stream);
report.RegisterData(dataList, "mx");
report.RegisterData(hz, "hz");
report.Preview = this.previewControl1;
report.Prepare();
report.ShowPrepared();
previewControl1.ZoomPageWidth();
}
}
}
public void ShowReport(string fileName)
{
var report = new FastReport.Report();
report.LoadPrepared(fileName);
var lfs = LocalizationResources.RussianFastReport;
if (lfs != null && lfs.Length > 0)
{
Res.LoadLocale(new MemoryStream(lfs));
}
report.ShowPrepared(false, this);
if (File.Exists(fileName))
{
File.Delete(fileName);
}
}
/// <summary>
/// 预览
/// </summary>
/// <param name="dt"></param>
public void Preview(DataTable dt)
{
if (dt == null || dt.Rows.Count == 0)
{
MessageBoxEx.ShowWarning("没有可预览数据！");
return;
}
FastReport.Report report = GetReport(dt);
report.Save("tb_parts.frx");
if (report != null)
{
report.Prepare();
report.ShowPrepared();
report.Dispose();
}
else
{
MessageBoxEx.ShowWarning("没有预览数据！");
}
}
internal void PrintOrder(OrderInfo order, bool preview = false)
{
string fileName = Path.Combine(Environment.CurrentDirectory, "steelorder.frx");
FastReport.Report report = new FastReport.Report();
report.Load(fileName);
report.SetParameterValue("orderno", order.orderno);
report.SetParameterValue("orderid", order.orderid);
report.SetParameterValue("customer", order.customer);
report.SetParameterValue("phone", order.phone);
report.SetParameterValue("addr", order.addr);
report.SetParameterValue("orderdate", order.orderdate);
string detailno = "0", guage = "", number = "", acreage = "", price = "", money = "", note = "";
for (int i = 1; i < 6; i++)
{
detailno = "detailno" + i.ToString();
guage = "guage" + i.ToString();
number = "number" + i.ToString();
acreage = "acreage" + i.ToString();
price = "price" + i.ToString();
money = "money" + i.ToString();
note = "note" + i.ToString();
if (i <= order.Detail.Count)
{
report.SetParameterValue(detailno, order.Detail[i - 1].XH);
report.SetParameterValue(guage, order.Detail[i - 1].GG);
report.SetParameterValue(number, (order.Detail[i - 1].SL.ToString()));
report.SetParameterValue(acreage, (order.Detail[i - 1].MJ.ToString()));
report.SetParameterValue(price, (order.Detail[i - 1].DJ.ToString()));
report.SetParameterValue(money, (order.Detail[i - 1].JE.ToString()));
report.SetParameterValue(note, order.Detail[i - 1].BZ);
}
else
{
report.SetParameterValue(detailno, i.ToString());
report.SetParameterValue(guage, "");
report.SetParameterValue(number, "");
report.SetParameterValue(acreage, "");
report.SetParameterValue(price, "");
report.SetParameterValue(money, "");
report.SetParameterValue(note, "");
}
}
report.SetParameterValue("sumnumber", (order.sumnumber.ToString()));
report.SetParameterValue("sumacreage", order.sumacreage.ToString());
report.SetParameterValue("summoney", (order.summoney.ToString()));
report.SetParameterValue("dxje", RMBUtils.CmycurD(Convert.ToDecimal(order.summoney)));
report.SetParameterValue("operation", order.operation);
report.SetParameterValue("sign", order.sign);
report.SetParameterValue("lxdz", order.lxdz);
report.SetParameterValue("lxdh", order.lxdh);
report.SetParameterValue("bz", order.bz);
report.PrintSettings.ShowDialog = false;
//FastReport环境变量设置（打印时不提示 "正在准备../正在打印..",一个程序只需设定一次，故一般写在程序入口）
(new FastReport.EnvironmentSettings()).ReportSettings.ShowProgress = false;
if (preview)
{
report.Prepare();
report.ShowPrepared();
}
else
{
report.Print();
}
}
private void frmReportPreview_Load(object sender, EventArgs e)
{
PreRepot.Preview = previewControl1;
PreRepot.Prepare();
PreRepot.ShowPrepared();
}
