private void toolPrintPreview_Click(object sender, EventArgs e)
{
if (dtWaterMeterList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
DataTable dtPrint = GetDgvToTable(dgList);
dtPrint.TableName = "收费明细表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\收费明细表.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("收费明细表").Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}/// <summary>
private void toolPrintPreview_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
//DataTable dt = (DataTable)dgList.DataSource;
DataTable dtPrint = GetDgvToTable(dgList);
dtPrint.TableName = "水表情况表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\业扩模板\水表库存模板.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("水表情况表").Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
private void toolPrint_Click(object sender, EventArgs e)
{
if (dtWaterMeterList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
DataTable dtRecordTemp = dtWaterMeterList.Clone();
dtRecordTemp.Columns["readMeterRecordYearAndMonth"].DataType = typeof(string);
foreach (DataRow dr in dtWaterMeterList.Rows)
{
dtRecordTemp.ImportRow(dr);
}
for (int i = 0; i < dtRecordTemp.Rows.Count; i++)
{
object obj = dtRecordTemp.Rows[i]["readMeterRecordYearAndMonth"];
if (Information.IsDate(obj))
{
dtRecordTemp.Rows[i]["readMeterRecordYearAndMonth"] = Convert.ToDateTime(obj).ToString("yyyy-MM");
}
//object objWaterMeterNO = dtRecord.Rows[i]["waterMeterNo"];
//if (objWaterMeterNO != null && objWaterMeterNO != DBNull.Value)
// if (objWaterMeterNO.ToString().Length > 7)
// dtRecord.Rows[i]["waterMeterNo"] = objWaterMeterNO.ToString().Substring(6, 2);
}
DataTable dtPrint = dtRecordTemp.Copy();
dtPrint.TableName = "收费明细表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\实收明细表.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("收费明细表").Enabled = true;
report1.PrintSettings.ShowDialog = false;
report1.Prepare();
report1.Print();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
/// <summary>
/// 新增报表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmAddReport_Click(object sender, EventArgs e)
{
report = new FastReport.Report();
RegReportData();
frmReportDesign rp = new frmReportDesign(report, 0);
rp.ReportGUID = rpGUID;
rp.ShowDialog();
report.Dispose();
//ClearListData();
CreateMenu();
}
private void toolPrintPreview_Click(object sender, EventArgs e)
{
if (dtWaterMeterList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
DataTable dtPrint = GetDgvToTable(dgList);
for (int i = 0; i < dtPrint.Rows.Count; i++)
{
string strTelNO = "", strPhoneNO = "";
object objWaterPhone = dtPrint.Rows[i]["waterUserTelphoneNO"];
if (objWaterPhone != null && objWaterPhone != DBNull.Value)
{
strTelNO = objWaterPhone.ToString();
}
objWaterPhone = dtPrint.Rows[i]["waterPhone"];
if (objWaterPhone != null && objWaterPhone != DBNull.Value)
{
strPhoneNO = objWaterPhone.ToString();
}
dtPrint.Rows[i]["waterPhone"] = strTelNO == "" ? strPhoneNO : strTelNO + " " + strPhoneNO;
}
dtPrint.TableName = "未抄水表明细表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\未抄水表明细表.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("未抄水表明细表").Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}/// <summary>
private void button1_Click(object sender, EventArgs e)
{
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
// report1.Load("E:\\FsFile\\Untitled.frx");
report1.Load("E:\\FsFile\\Test.frx");
report1.SetParameterValue("aaa", "adbajdbjadbjadbabdadadad");
report1.SetParameterValue("bbb", "uiyiyuiyy");
report1.SetParameterValue("ccc", "1313131313");
/*
* var lableTag = new LableTag();
* lableTag.ProdNo = "800-sdashd-a0-0";
* lableTag.Qty = "300";
* lableTags = new LableTag[] { lableTag };
*
*
*
* report1.RegisterData(lableTags, "lableTag");
* // report1.RegisterData("456", "two");
* //report.RegisterData(cdsPrints, "frCds_Print");
*
* //找到 DataBind 邦定数据 一定要先注册数据才可以邦定
*
* //DataBand data = report1.FindObject("Data1") as DataBand;
* // data.DataSource = report1.GetDataSource("one");
* // register the dataset
*
* // report1.RegisterData(FDataSet);
* // report1.GetDataSource("Items").Enabled = true;
* // run the report
* // report1.Show();
* //进行打印预览
*/
report1.Prepare();
//report1.Variables.Add.Name:=' Yuan';
report1.ShowPrepared();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
private void button2_Click(object sender, EventArgs e)
{
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
// report1.Load("E:\\FsFile\\Untitled.frx");
report1.Load("E:\\FsFile\\Test.frx");
/*
* //填充参数及对应的值
* Type typePrint = typeof(LableTag);
* System.Reflection.PropertyInfo[] pros = typePrint.GetProperties();
* foreach (System.Reflection.PropertyInfo pro in pros)
* {
* object val = pro == null ? ""
* : pro.GetValue(lableTags[0], null) == null ? ""
* : pro.GetValue(lableTags[0], null).ToString();
*
* if (val == null)
* {
* val = "";
* }
* string paraName = "lableTag." + pro.Name;
* report1.SetParameterValue(paraName, val);
*
* }
* var lableTag = new LableTag();
* lableTag.ProdNo = "800-sdashd-a0-0";
* lableTag.Qty = "300";
* lableTags = new LableTag[] { lableTag };
*
* report1.RegisterData(lableTags, "lableTag");
*/
report1.SetParameterValue("aaa", "111");
report1.SetParameterValue("bbb", "222");
report1.SetParameterValue("ccc", "333");
report1.Design();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
/// <summary>
/// 打印预览
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmPreviewReport_Click(object sender, EventArgs e)
{
if (tsmChooseReport.HasDropDownItems)
{
report = new FastReport.Report();
if (!report.IsRunning)
{
GetData(tsmChooseDetail[iDefaultChecked].Name);
report.Load(new MemoryStream(bt));
RegReportData();
}
frmReportPreview rp = new frmReportPreview(report);
rp.ShowDialog();
report.Dispose();
}
}
private void toolPrintPreview_Click(object sender, EventArgs e)
{
if (dgList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
//DataTable dt = (DataTable)dgList.DataSource;
DataTable dt = GetDgvToTable(dgList);
DataTable dtPrint = dt.Copy();
dtPrint.TableName = strStaticsName;
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\预存统计模板\" + strStaticsName + ".frx");
if (strStaticsName == "预存统计(按收费员)")
{
(report1.FindObject("txtTitle") as FastReport.TextObject).Text = "大厅收费统计(按收费员)";
}
else if (strStaticsName == "预存统计(按用户)")
{
(report1.FindObject("txtTitle") as FastReport.TextObject).Text = "大厅收费统计(按用户)";
}
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource(strStaticsName).Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}/// <summary>
/// <summary>
/// 打印
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmPrintReport_Click(object sender, EventArgs e)
{
if (tsmChooseReport.HasDropDownItems)
{
report = new FastReport.Report();
if (!report.IsPrinting)
{
GetData(tsmChooseDetail[iDefaultChecked].Name);
report.Load(new MemoryStream(bt));
RegReportData();
}
//是否显示打印机选择对话框
report.PrintSettings.ShowDialog = ShowPrintDialog;
report.Print();
report.Dispose();
}
}
public void Dispose()
{
RunFlag = false;
ConstantMethod.Delay(100);
//保存文件
SaveFile();
if (evokDevice != null)
{
evokDevice.DeviceShutDown();
}
printReport.Dispose();
if (CutThread != null && CutThread.IsAlive)
{
CutThread.Join();
}
LogManager.WriteProgramLog(Constant.Quit);
}
/// <summary>
/// 设计报表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmDesginReport_Click(object sender, EventArgs e)
{
if (tsmChooseReport.HasDropDownItems)
{
report = new FastReport.Report();
if (!report.IsDesigning)
{
GetData(tsmChooseDetail[iDefaultChecked].Name);
report.Load(new MemoryStream(bt));
RegReportData();
}
frmReportDesign rp = new frmReportDesign(report, Convert.ToInt32(tsmChooseDetail[iDefaultChecked].Name));
rp.ReportGUID = rpGUID;
rp.ShowDialog();
report.Dispose();
//刷新菜单
CreateMenu();
}
}
private void toolPrint_Click(object sender, EventArgs e)
{
if (dtWaterUserList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
//DataTable dt = (DataTable)dgList.DataSource;
DataTable dtPrint = dtWaterUserList.Copy();
if (dtClone.Rows.Count > 0)
{
dtPrint.ImportRow(dtClone.Rows[0]);
}
dtPrint.TableName = "用户应收明细表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\用户应收明细表.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("用户应收明细表").Enabled = true;
report1.Prepare();
report1.Print();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
private void toolPrintPreview_Click(object sender, EventArgs e)
{
if (dgList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
//DataTable dt = (DataTable)dgList.DataSource;
DataTable dt = GetDgvToTable(dgList);
//DataTable dtPrint = dt.Copy();
DataTable dtPrint = dt.DefaultView.ToTable(true, "CHARGEID", "CANCELWORKERNAME", "CANCELDATETIME", "CANCELMEMO", "WATERTOTALCHARGECHARGE",
"EXTRATOTALCHARGECHARGE", "OVERDUEMONEYCHARGE", "TOTALCHARGECHARGE", "CHARGEBCYS", "CHARGEBCSS", "CHARGEDATETIME", "CHARGEWORKERNAME", "waterUserNO",
"waterUserName", "waterPhone", "waterUserAddress", "INVOICEBATCHNAME", "INVOICENO");
dtPrint.TableName = "收费冲减明细表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\收费冲减明细表.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("收费冲减明细表").Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
private void toolPrintPreview_Click(object sender, EventArgs e)
{
if (dtList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
DataTable dtPrint = dtList.Copy();
if (dtClone.Rows.Count > 0)
{
dtPrint.ImportRow(dtClone.Rows[0]);
}
dtPrint.TableName = "异常用水明细表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\异常用水明细表.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("异常用水明细表").Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}/// <summary>
private void toolPrint_Click(object sender, EventArgs e)
{
if (dtWaterMeterList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
DataTable dtPrint = GetDgvToTable(dgList);
dtPrint.TableName = "收费明细表";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\一户式查询打印.frx");
(report1.FindObject("txtWaterUserNO") as FastReport.TextObject).Text = "用户号:" + strWaterUserID;
(report1.FindObject("txtWaterUserName") as FastReport.TextObject).Text = "用户名:" + strWaterUserName;
(report1.FindObject("txtWaterUserAddress") as FastReport.TextObject).Text = "地 址:" + strWaterUserAddress;
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("收费明细表").Enabled = true;
report1.PrintSettings.ShowDialog = false;
report1.Prepare();
report1.Print();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
/// <summary>
/// 添加新报表
/// </summary>
/// <param name="e"></param>
/// <param name="strReportTemplateName"></param>
/// <returns></returns>
public static string AddNewReport(ReportRequestArgs e, string strReportTemplateName)
{
string strReportPath = "";
using (FastReport.Report report = new FastReport.Report())
{
BuildParmsAndData(e, report, enBuildParmsAndDataActionType.AddNew);
string strReportFullName = Path.Combine(ReportHelper.ReportPath, strReportTemplateName + ".frx");
report.Save(strReportFullName);
strReportPath = strReportFullName;
//Form frm = new Form();
//frm.Icon = FastReport.Utils.Config.PreviewSettings.Icon;
//frm.Show();
//report.Design();
report.Dispose();
//frm.Close();
}
return(strReportPath);
}
//public static void BuildReportParmsAndData(FastReport.Report report, ReportArgs reportArgs)
//{
// report.Parameters.Clear();
// List<FastReport.Data.Parameter> lstParm = new List<FastReport.Data.Parameter>();
// if (reportArgs.RecordDR != null)
// {
// foreach (DataColumn dc in reportArgs.RecordDR.Table.Columns)
// {
// FastReport.Data.Parameter parm = new FastReport.Data.Parameter(dc.ColumnName);
// parm.DataType = dc.DataType;
// parm.Value = reportArgs.RecordDR[dc.ColumnName];
// lstParm.Add(parm);
// }
// }
// if (reportArgs.DSDataSource != null)
// {
// foreach (DataTable dtSource in reportArgs.DSDataSource.Tables)
// {
// report.RegisterData(dtSource, dtSource.TableName);
// report.GetDataSource(dtSource.TableName).Enabled = true;
// }
// }
//}
/// <summary>
/// 打开报表设计器
/// </summary>
/// <param name="lReportTemplateID"></param>
/// <param name="reportArgs"></param>
public static void OpenReportDesign(ReportRequestArgs reportArgs)
{
string strReportFileName;
bool bolExists = RefleshClientReport(reportArgs.ReportTemplateID, out strReportFileName);
if (bolExists)
{
using (FastReport.Report report = new FastReport.Report())
{
BuildParmsAndData(reportArgs, report, enBuildParmsAndDataActionType.AddNew);
report.Load(strReportFileName);
Form frm = new Form();
frm.Icon = FastReport.Utils.Config.PreviewSettings.Icon;
frm.Show();
report.Design();
report.Dispose();
frm.Close();
}
}
}
private void toolPrintPreview_Click(object sender, EventArgs e)
{
if (dtList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
DataTable dtPrint = dtList.Copy();
if (dtClone.Rows.Count > 0)
{
dtPrint.ImportRow(dtClone.Rows[0]);
}
dtPrint.TableName = strStaticsName;
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\期数未收统计模板\" + strStaticsName + ".frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource(strStaticsName).Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}/// <summary>
private void btPrint_Click(object sender, EventArgs e)
{
if (txtReason.Text == "")
{
if (mes.ShowQ("原因为空,确定要打印吗?") != DialogResult.OK)
{
return;
}
}
#region
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\变更审批表模板.frx");
(report1.FindObject("txtName") as FastReport.TextObject).Text = txtName.Text;
(report1.FindObject("txtNO") as FastReport.TextObject).Text = txtNO.Text;
(report1.FindObject("txtAddress") as FastReport.TextObject).Text = txtAddress.Text;
(report1.FindObject("txtReason") as FastReport.TextObject).Text = "变更原因:" + txtReason.Text;
//report1.Show();
report1.PrintSettings.ShowDialog = false;
report1.Prepare();
report1.Print();
}
catch (Exception exx)
{
mes.Show(exx.Message);
return;
}
finally
{
// free resources used by report
report1.Dispose();
}
#endregion
}
private void toolPrint_Click(object sender, EventArgs e)
{
if (dgJieZhangYS.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
decimal decSum = 0;
DataSet ds = new DataSet();
DataTable dtPrint = GetDgvToTable(dgJieZhangYS);
dtPrint.TableName = "水费应收统计表(按用水性质)";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\应收水费统计模板\应收水费统计(结账报表).frx");
(report1.FindObject("txtMonth") as FastReport.TextObject).Text = "应收月份：" + dtpStartSearch.Value.ToString("yyyy-MM");
report1.RegisterData(ds);
report1.GetDataSource("水费应收统计表(按用水性质)").Enabled = true;
report1.PrintSettings.ShowDialog = false;
report1.Prepare();
report1.Print();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
/// <summary>
/// 设计报表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmDesginReport_Click(object sender, EventArgs e)
{
if (tsmChooseReport.HasDropDownItems)
{
report = new FastReport.Report();
if (!report.IsDesigning)
{
GetData(tsmChooseDetail[iDefaultChecked].Name);
report.Load(new MemoryStream(bt));
RegReportData();
}
frmReportDesign rp = new frmReportDesign(report, Convert.ToInt32(tsmChooseDetail[iDefaultChecked].Name));
rp.ReportGUID = rpGUID;
rp.ShowDialog();
report.Dispose();
//刷新菜单
CreateMenu();
}
}
private static void ShowReport(enRequestReportActionType eActionType, ReportRequestArgs e)
{
// FastReport 配置
Config.DesignerSettings.ShowInTaskbar = true;
Config.DesignerSettings.DefaultFont = new System.Drawing.Font(Config.DesignerSettings.DefaultFont.FontFamily, 10f);
//Config.DesignerSettings.Icon = TS.Win.Styles.Sheet.AppIcon;
Config.DesignerSettings.Text = "报表设计器";
//Config.PreviewSettings.Buttons = PreviewButtons.Print;
Config.PreviewSettings.ShowInTaskbar = true;
//Config.PreviewSettings.Icon = TS.Win.Styles.Sheet.AppIcon;
long lReportTemplateID = Convert.ToInt64(e.ReportTemplateConfig["ReportTemplateID"]);
byte[] reportTempleData = (byte[])e.ReportTemplateConfig["TemplateData"];
DateTime dtTemplateFileTime = DateTime.Parse(e.ReportTemplateConfig["TemplateFileTime"].ToString());
string strReportTemplateName = e.ReportTemplateConfig["ReportTemplateName"].ToString().Trim();
string strReportTemplateNameExt = e.ReportTemplateConfig["ReportTemplateNameExt"].ToString().Trim();
//检测本地是否存在报表文件，如果不存在或者与服务器比本地文件新时更新本地文件
string strFileFullName = WriteReportWithCheck(lReportTemplateID, strReportTemplateName, dtTemplateFileTime, reportTempleData, strReportTemplateNameExt);
ProcessStep.AddStep("WriteReportWithCheck_End", DateTime.Now.ToString("MMdd HH:mm:ss ") + DateTime.Now.Millisecond);
// 加载模板
FastReport.Report report = null;
//Form frm = null;
try
{
//frm = new Form();
report = new FastReport.Report();
ProcessStep.AddStep("Report_New", DateTime.Now.ToString("MMdd HH:mm:ss ") + DateTime.Now.Millisecond);
report.FinishReport += Report_FinishReport;
report.Load(strFileFullName);
ProcessStep.AddStep("Report_Load", DateTime.Now.ToString("MMdd HH:mm:ss ") + DateTime.Now.Millisecond);
// 纸张设置
//SetPaperAuto(report, iReportTemplateID);
BuildParmsAndData(e, report, enBuildParmsAndDataActionType.SetValue);
ProcessStep.AddStep("BuildParmsAndData", DateTime.Now.ToString("MMdd HH:mm:ss ") + DateTime.Now.Millisecond);
//ReportPreviewer previewer = new Report.ReportPreviewer(report);
SetPrintSettings(report, lReportTemplateID);
ProcessStep.AddStep("SetPrintSettings", DateTime.Now.ToString("MMdd HH:mm:ss ") + DateTime.Now.Millisecond);
if (eActionType == enRequestReportActionType.Preview)//预览
{
//frm.FormBorderStyle = FormBorderStyle.None;
//frm.Text = "报表预览[" + strReportTemplateName + "]";
//frm.TransparencyKey = frm.BackColor;
//frm.Show();
//report.Show(true, frm);
//LBShowForm.ShowDialog(previewer);
report.Show(true);
}
else if (eActionType == enRequestReportActionType.DirectPrint)//直接打印
{
report.PrintSettings.ShowDialog = false;
report.Print();
//string strPrinterStatus =PrinterHelper.GetPrinterStatus(report.PrintSettings.Printer);
ProcessStep.AddStep("Print", DateTime.Now.ToString("MMdd HH:mm:ss ") + DateTime.Now.Millisecond);
}
}
finally
{
try
{
if (report != null)
{
report.Dispose();
//if (frm != null)
//{
// frm.Close();
//}
}
}
catch
{
}
}
}
private void toolPrintPreview_Click(object sender, EventArgs e)
{
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\用水情况一览表.frx");
(report1.FindObject("Cell3") as FastReport.TextObject).Text = labYCHS.Text;
(report1.FindObject("Cell8") as FastReport.TextObject).Text = labXSHS.Text;
(report1.FindObject("Cell13") as FastReport.TextObject).Text = labXHHS.Text;
(report1.FindObject("Cell148") as FastReport.TextObject).Text = labYMHS.Text;
(report1.FindObject("Cell33") as FastReport.TextObject).Text = labYSZJ.Text;
(report1.FindObject("Cell43") as FastReport.TextObject).Text = labFSYSHS.Text;
(report1.FindObject("Cell48") as FastReport.TextObject).Text = labYSYSL.Text;
(report1.FindObject("Cell38") as FastReport.TextObject).Text = labYSSF.Text;
(report1.FindObject("Cell58") as FastReport.TextObject).Text = labYSWSSF.Text;
(report1.FindObject("Cell63") as FastReport.TextObject).Text = labYSFJF.Text;
(report1.FindObject("Cell68") as FastReport.TextObject).Text = labSSZJ.Text;
(report1.FindObject("Cell108") as FastReport.TextObject).Text = labSSSL.Text;
(report1.FindObject("Cell103") as FastReport.TextObject).Text = labSSHS.Text;
(report1.FindObject("Cell53") as FastReport.TextObject).Text = labSSSF.Text;
(report1.FindObject("Cell28") as FastReport.TextObject).Text = labSSWSCLF.Text;
(report1.FindObject("Cell18") as FastReport.TextObject).Text = labSSFJF.Text;
(report1.FindObject("Cell113") as FastReport.TextObject).Text = labOverDue.Text;
(report1.FindObject("Cell73") as FastReport.TextObject).Text = labWQZJ.Text;
(report1.FindObject("Cell98") as FastReport.TextObject).Text = labWQSL.Text;
(report1.FindObject("Cell93") as FastReport.TextObject).Text = labWQHS.Text;
(report1.FindObject("Cell88") as FastReport.TextObject).Text = labWQSF.Text;
(report1.FindObject("Cell83") as FastReport.TextObject).Text = labWQWSCLF.Text;
(report1.FindObject("Cell78") as FastReport.TextObject).Text = labWQFJF.Text;
(report1.FindObject("Cell118") as FastReport.TextObject).Text = labLJQFZJ.Text;
(report1.FindObject("Cell123") as FastReport.TextObject).Text = labLJQFHS.Text;
(report1.FindObject("Cell128") as FastReport.TextObject).Text = labLJQFSL.Text;
(report1.FindObject("Cell133") as FastReport.TextObject).Text = labLJQFSF.Text;
(report1.FindObject("Cell138") as FastReport.TextObject).Text = labLJQFWSCLF.Text;
(report1.FindObject("Cell143") as FastReport.TextObject).Text = labLJQFFJF.Text;
//(report1.FindObject("Cell28") as FastReport.TextObject).Text = labSQZMJE.Text;
//(report1.FindObject("Cell18") as FastReport.TextObject).Text = labBQZJ.Text;
//(report1.FindObject("Cell23") as FastReport.TextObject).Text = labBQZMJE.Text;
if (GetMonth(dtpStartSearch.Value, dtpEndSearch.Value) > 1)
{
(report1.FindObject("txtTitle") as FastReport.TextObject).Text = dtpStartSearch.Value.ToString("yyyy-MM") + "至" + dtpEndSearch.Value.ToString("yyyy-MM") + "月份用水情况一览表";
}
else
{
(report1.FindObject("txtTitle") as FastReport.TextObject).Text = strMonth[dtpEndSearch.Value.Month - 1] + "月份用水情况一览表";
}
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
/// <summary>
/// 打印
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmPrintReport_Click(object sender, EventArgs e)
{
if (tsmChooseReport.HasDropDownItems)
{
report = new FastReport.Report();
if (!report.IsPrinting)
{
GetData(tsmChooseDetail[iDefaultChecked].Name);
report.Load(new MemoryStream(bt));
RegReportData();
}
//是否显示打印机选择对话框
report.PrintSettings.ShowDialog = ShowPrintDialog;
report.Print();
report.Dispose();
}
}
public FileResult CekSenetYazdir(string ID = "")
{
FastReport.Utils.Config.WebMode = true;
FastReport.Report report1 = new FastReport.Report();
report1.Prepare(true);
try
{
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Cek.frx"));
}
catch
{
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/Default"), "Cek.frx"));
}
using (SqlConnection conp = new SqlConnection(AyarMetot.strcon))
{
if (conp.State == ConnectionState.Closed)
{
conp.Open();
}
using (SqlCommand getir = new SqlCommand("Select CariID From CASH_PAY where ID='" + ID + "'", conp))
{
using (SqlDataReader dr = getir.ExecuteReader())
{
while (dr.Read())
{
using (DataTable Teklifler = GetDataTable("set dateformat dmy;SELECT * ,(Select Adi+' '+Soyadi from Personel where ID=PersonelID) as PersonelAdi From CASH_PAY where ID = '" + ID + "'"))
{
report1.RegisterData(Teklifler.DefaultView.ToTable(), "NakitHavale");
report1.GetDataSource("NakitHavale").Enabled = true;
}
report1.RegisterData(AyarMetot.CariBil(Convert.ToInt32(dr["CariID"]), "Tümü", "", "Tümü", "Tümü"), "CariBilgileri");
report1.RegisterData(AyarMetot.FirmaBil(), "FirmaBilgileri");
report1.GetDataSource("CariBilgileri").Enabled = true;
report1.GetDataSource("FirmaBilgileri").Enabled = true;
}
}
}
}
using (FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport())
{
byte[] dosya;
try
{
dosya =
System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()),
"Cek.pdf"));
}
catch
{
dosya =
System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/Defaut"),
"Cek.pdf"));
}
try
{
report1.Prepare(true);
try
{
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Cek.pdf"));
}
catch
{
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/Default"), "Cek.pdf"));
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
//report1.Save(Path.Combine(Server.MapPath("~/REPORTS/ATTACHMENT"),"b.frx"));
report1.Dispose();
return(File(dosya, "application/pdf"));
}
catch (Exception e)
{
return(File(dosya, "application/pdf"));
}
}
}
/// <summary>
/// 新增报表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmAddReport_Click(object sender, EventArgs e)
{
report = new FastReport.Report();
RegReportData();
frmReportDesign rp = new frmReportDesign(report,0);
rp.ReportGUID = rpGUID;
rp.ShowDialog();
report.Dispose();
//ClearListData();
CreateMenu();
}
public FileResult IadeYazdir(string ID = "")
{
try
{
FastReport.Utils.Config.WebMode = true;
FastReport.Report report1 = new FastReport.Report();
report1.Prepare(true);
DataTable dtDetay = new DataTable();
try {
report1.Load(Path.Combine(Server.MapPath("~//REPORTS/" + Session["FirmaID"].ToString()), "Iade.frx"));
}
catch
{
report1.Load(Path.Combine(Server.MapPath("~//REPORTS/Default"), "Iade.frx"));
}
using (SqlConnection bag = new SqlConnection(AyarMetot.strcon))
{
if (bag.State == ConnectionState.Closed)
{
bag.Open();
}
using (SqlCommand servisgetir = new SqlCommand("Select * From INVOICE where ID='" + ID + "'", bag))
{
using (SqlDataReader dt = servisgetir.ExecuteReader())
{
while (dt.Read())
{
string KDVdh = "Dahil";
dtDetay = AyarMetot.FaturaDetayBil(ID, KDVdh, Convert.ToDecimal(dt["FKuru"]));
if (dt["KdvDH"].ToString() != "D")
{
KDVdh = "Hariç";
}
report1.RegisterData(AyarMetot.FaturaBil(ID), "FaturaBilgileri");
report1.RegisterData(dtDetay, "UrunBilgileri");
report1.RegisterData(AyarMetot.CariBil(Convert.ToInt32(dt["CariID"]), "Tümü", "Tümü", "Tümü", "Tümü"), "CariBilgileri");
report1.RegisterData(AyarMetot.FirmaBil(), "FirmaBilgileri");
report1.GetDataSource("FaturaBilgileri").Enabled = true;
report1.GetDataSource("UrunBilgileri").Enabled = true;
report1.GetDataSource("CariBilgileri").Enabled = true;
report1.GetDataSource("FirmaBilgileri").Enabled = true;
}
}
}
}
using (FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport())
{
ReportPage page1 = report1.Pages[0] as ReportPage;
page1.PaperHeight = page1.PaperHeight + (dtDetay.Rows.Count * ((float)5));
report1.Prepare(true);
try {
report1.Export(pdf, Path.Combine(Server.MapPath("~//REPORTS/" + Session["FirmaID"].ToString()), "Iade.pdf"));
}
catch
{
report1.Export(pdf, Path.Combine(Server.MapPath("~//REPORTS/Default"), "Iade.pdf"));
}
dtDetay.Dispose();
System.IO.MemoryStream ms = new System.IO.MemoryStream();
//report1.Save(Path.Combine(Server.MapPath("~/REPORTS/ATTACHMENT"),"Irs.frx"));
// page1.Dispose();
report1.Dispose();
byte[] dosya;
try {
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Iade.pdf"));
}
catch
{
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/Default"), "Iade.pdf"));
}
return(File(dosya, "application/pdf"));
}
}
catch (Exception e1)
{
try {
System.IO.File.WriteAllText(Path.Combine(@"C:\Users\ilhan\AppData\Local\Sayazilim", "sonuç.xml"), e1.ToString());
}
catch
{
}
byte[] dosya = null;
return(File(dosya, "application/pdf"));
}
}
private bool CreateReport()
{
bool functionReturnValue = false;
// ERROR: Not supported in C#: OnErrorStatement
functionReturnValue = false;
// create report instance
FastReport.Report MainReport = new FastReport.Report();
FastReport.Report StyleReport = default(FastReport.Report);
// register the dataset
MainReport.RegisterData(this.FDataSet);
MainReport.GetDataSource("TableData").Enabled = true;
if (StyleRowsEven == null)
{
if (System.IO.File.Exists(Application.StartupPath + "\\Report\\Pattern.frx"))
{
StyleReport = new FastReport.Report();
StyleReport.Load(Application.StartupPath + "\\Report\\Pattern.frx");
StyleRowsEven = StyleReport.Styles[0];
if (StyleRowsEven != null)
{
MainReport.Styles.Add(StyleRowsEven);
}
}
}
ReportPage page = new ReportPage();
page.Width = 33 * Units.Centimeters;
MainReport.Pages.Add(page);
page.CreateUniqueName();
DataBand dataBand = new DataBand();
page.Bands.Add(dataBand);
dataBand.CreateUniqueName();
dataBand.DataSource = MainReport.GetDataSource("TableData");
dataBand.Height = (Units.Centimeters * 0.5f);
if (StyleRowsEven != null)
{
MainReport.Styles.Add(StyleRowsEven);
if (!ChkWithoutColorTextReport.Checked)
{
dataBand.EvenStyle = StyleRowsEven.Name;
}
else
{
dataBand.EvenStyle = "";
}
}
page.ReportTitle = new ReportTitleBand();
page.ReportTitle.Height = (Units.Centimeters * 4f);
page.ReportTitle.CreateUniqueName();
if (ChkWithoutColorHeader.CheckState == CheckState.Checked)
{
colorHeader = Color.Transparent;
backgroundColor = Color.Transparent;
}
HeaderAllReport(page, cboLayers.SelectedItem.ToString());
double higthHeader = double.Parse(txtWidthHeader.Text);
double higthBody = double.Parse(txtWidthBody.Text);
double WidthReport = 19;
double widthColumn = (double)19 / columnNames.Count;
for (int i = 0; i < columnNames.Count; i++)
{
WidthReport -= (widthColumn - 0.005);
if (WidthReport < 0)
{
break;
}
TextObject titleText = new TextObject();
titleText.Parent = page.ReportTitle;
titleText.CreateUniqueName();
titleText.Bounds = new RectangleF(Convert.ToSingle((Units.Centimeters * WidthReport)), (Units.Centimeters * 3f), (Units.Centimeters * (float)widthColumn), (Units.Centimeters * (float)higthHeader));
titleText.Font = FontDialog_Topic.Font;
titleText.Text = columnNames[i];
titleText.VertAlign = VertAlign.Center;
titleText.HorzAlign = HorzAlign.Center;
titleText.Fill = new LinearGradientFill(backgroundColor, colorHeader, 90, Convert.ToSingle(higthHeader), 1f);
titleText.RightToLeft = true;
TextObject ReportText = new TextObject();
ReportText.Parent = dataBand;
ReportText.CreateUniqueName();
ReportText.Bounds = new RectangleF(Convert.ToSingle((Units.Centimeters * WidthReport)), 0f, (Units.Centimeters * (float)widthColumn), (Units.Centimeters * (float)higthBody));
ReportText.Text = "[TableData." + FDataSet.Tables[0].Columns[i].ColumnName + "]";
ReportText.Font = FontDialog_TextReport.Font;
ReportText.HorzAlign = HorzAlign.Center;
ReportText.VertAlign = VertAlign.Center;
ReportText.RightToLeft = true;
// ReportText.Border.Lines = BorderLines.All;
//ReportText.Border.BottomLine.Color = Color.Black;
//ReportText.Border.BottomLine.Width = 0.5f;
//ReportText.Border.TopLine .Color = Color.Black;
//ReportText.Border.TopLine.Width = 0.5f;
}
if (WidthReport < 19)
{
TextObject RemaintitleText = new TextObject();
RemaintitleText.Parent = page.ReportTitle;
RemaintitleText.CreateUniqueName();
RemaintitleText.Bounds = new RectangleF(0.0f, (Units.Centimeters * 3f), Convert.ToSingle((Units.Centimeters * WidthReport)), (Units.Centimeters * (float)higthHeader));
RemaintitleText.Text = "";
RemaintitleText.VertAlign = VertAlign.Center;
RemaintitleText.HorzAlign = HorzAlign.Center;
RemaintitleText.Fill = new LinearGradientFill(backgroundColor, colorHeader, 90, Convert.ToSingle(higthHeader), 1f);
}
MainReport.Save(Application.StartupPath + "\\Report\\Report_TableResult.frx");
MainReport.Dispose();
functionReturnValue = true;
return(functionReturnValue);
Err:
return(functionReturnValue);
}
private void toolPrintPreview_Click(object sender, EventArgs e)
{
if (dgList.Rows.Count == 0)
{
toolPrint.Enabled = false;
toolPrintPreview.Enabled = false;
return;
}
DataSet ds = new DataSet();
//DataTable dt = (DataTable)dgList.DataSource;
DataTable dt = GetDgvToTable(dgList);
DataTable dtPrint = dt.Copy();
DataColumn dc1 = new DataColumn("totalChargeOld", typeof(decimal));
dtPrint.Columns.Add(dc1);
//dtPrint.Columns["totalChargeOld"].Expression = "OVERDUEGET + totalCharge";
DataColumn dc2 = new DataColumn("REMITSUM", typeof(decimal));
dtPrint.Columns.Add(dc2);
for (int i = 0; i < dtPrint.Rows.Count - 1; i++)
{
dtPrint.Rows[i]["totalChargeOld"] = (Information.IsNumeric(dtPrint.Rows[i]["totalCharge"]) ? Convert.ToDecimal(dtPrint.Rows[i]["totalCharge"]) : 0) +
(Information.IsNumeric(dtPrint.Rows[i]["OVERDUEGET"]) ? Convert.ToDecimal(dtPrint.Rows[i]["OVERDUEGET"]) : 0);
dtPrint.Rows[i]["REMITSUM"] = (Information.IsNumeric(dtPrint.Rows[i]["REMITWATERFEE"]) ? Convert.ToDecimal(dtPrint.Rows[i]["REMITWATERFEE"]) : 0) +
(Information.IsNumeric(dtPrint.Rows[i]["REMITEXTRAFEE"]) ? Convert.ToDecimal(dtPrint.Rows[i]["REMITEXTRAFEE"]) : 0) +
(Information.IsNumeric(dtPrint.Rows[i]["REMITOVERDUE"]) ? Convert.ToDecimal(dtPrint.Rows[i]["REMITOVERDUE"]) : 0);
}
//统计未减免总水费小计
object objSumToltalCharge = dtPrint.Compute("SUM(totalChargeOld)", "");
if (Information.IsNumeric(objSumToltalCharge))
{
dtPrint.Rows[dtPrint.Rows.Count - 1]["totalChargeOld"] = Convert.ToDecimal(objSumToltalCharge).ToString("F2");
}
//统计减免总水费小计
object objSumRemit = dtPrint.Compute("SUM(REMITSUM)", "");
if (Information.IsNumeric(objSumRemit))
{
dtPrint.Rows[dtPrint.Rows.Count - 1]["REMITSUM"] = Convert.ToDecimal(objSumRemit).ToString("F2");
}
dtPrint.TableName = "水费减免明细模板";
ds.Tables.Add(dtPrint);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\水费减免明细模板.frx");
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("水费减免明细模板").Enabled = true;
// run the report
report1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// free resources used by report
report1.Dispose();
}
}
/// <summary>
/// 打印预览
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void tsmPreviewReport_Click(object sender, EventArgs e)
{
if (tsmChooseReport.HasDropDownItems)
{
report = new FastReport.Report();
if (!report.IsRunning)
{
GetData(tsmChooseDetail[iDefaultChecked].Name);
report.Load(new MemoryStream(bt));
RegReportData();
}
frmReportPreview rp = new frmReportPreview(report);
rp.ShowDialog();
report.Dispose();
}
}
public FileResult DepoIslemYazdir(string ID = "")
{
FastReport.Utils.Config.WebMode = true;
FastReport.Report report1 = new FastReport.Report();
report1.Prepare(true);
DataTable dtDetay = new DataTable();
try
{
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "depo.frx"));
}
catch {
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/Default"), "depo.frx"));
}
using (SqlConnection bag = new SqlConnection(AyarMetot.strcon))
{
if (bag.State == ConnectionState.Closed)
{
bag.Open();
}
using (SqlCommand servisgetir = new SqlCommand("Select * From STORE_PROCESS where ID='" + ID + "'", bag))
{
using (SqlDataReader dt = servisgetir.ExecuteReader())
{
while (dt.Read())
{
dtDetay = AyarMetot.DepoIslemDetayBil(ID);
report1.RegisterData(AyarMetot.DepoIslemBil(ID), "Depo_İşlem");
report1.RegisterData(dtDetay, "Depo_İşlem_Detay");
report1.RegisterData(AyarMetot.FirmaBil(), "FirmaBilgileri");
report1.GetDataSource("Depo_İşlem").Enabled = true;
report1.GetDataSource("Depo_İşlem_Detay").Enabled = true;
report1.GetDataSource("FirmaBilgileri").Enabled = true;
}
}
}
}
using (FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport())
{
try
{
ReportPage page1 = report1.Pages[0] as ReportPage;
page1.PaperHeight = page1.PaperHeight + (dtDetay.Rows.Count * ((float)6.5));
}
catch { }
report1.Prepare(true);
try {
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "depo.pdf"));
}
catch
{
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/Default"), "depo.pdf"));
}
dtDetay.Dispose();
//System.IO.MemoryStream ms = new System.IO.MemoryStream();
//report1.Save(Path.Combine(Server.MapPath("~/REPORTS/ATTACHMENT"), "depoyeni.frx"));
byte[] dosya;
report1.Dispose();
try {
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "depo.pdf"));
}
catch
{
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/Default"), "depo.pdf"));
}
return(File(dosya, "application/pdf"));
}
}