public void LoadReport()
{
string location = @"Report/Certificateofcanv.frx";
rpt.Load(location);
rpt.RegisterData(ds);
rpt.RegisterData(ds1);
rpt.RegisterData(ds2);
rpt.RegisterData(ds3);
rpt.RegisterData(ds4);
rpt.RegisterData(ds5);
rpt.RegisterData(ds6);
rpt.RegisterData(ds7);
rpt.RegisterData(ds8);
rpt.RegisterData(ds9);
rpt.GetDataSource("certificate_ofcanvass").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass1").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass2").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass3").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass4").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass5").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass6").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass7").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass8").Enabled = true;
rpt.GetDataSource("certificate_ofcanvass9").Enabled = true;
}
private void Table1_ManualBuild(object sender, EventArgs e)
{
// get the data source by its name
DataSourceBase rowData = Report.GetDataSource("Oocytes");
// init the data source
rowData.Init();
// print the first table row - it is a header
Table1.PrintColumn(0);
// each PrintRow call must be followed by either PrintColumn or PrintColumns call
// to print cells on the row
Table1.PrintRows();
// now enumerate the data source and print the table body
while (rowData.HasMoreRows)
{
// print the table body
Table1.PrintColumn(1);
Table1.PrintRows();
// go next data source row
rowData.Next();
}
}
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();
}
}
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 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>
public static void BuildParmsAndData(ReportRequestArgs e, FastReport.Report report, enBuildParmsAndDataActionType actionType)
{
if (actionType == enBuildParmsAndDataActionType.SetValue) // 对模板已有参数赋值
{
foreach (FastReport.Data.Parameter parm in report.Parameters)
{
// 参数值是从 fastParms.ReportParameters 中传入的
foreach (DataColumn dc in e.RecordDR.Table.Columns)
{
if (parm.Name.Equals(dc.ColumnName, StringComparison.CurrentCultureIgnoreCase))
{
parm.Value = e.RecordDR[dc.ColumnName];
break;
}
}
}
}
else // 添加新的参数至模板
{
if (e.RecordDR != null)
{
report.Parameters.Clear();
foreach (DataColumn dc in e.RecordDR.Table.Columns)
{
FastReport.Data.Parameter parm = new FastReport.Data.Parameter(dc.ColumnName);
parm.DataType = dc.DataType;
parm.Value = e.RecordDR[dc.ColumnName];
report.Parameters.Add(parm);
}
}
}
if (e.DSDataSource != null)
{
for (int i = 0, j = e.DSDataSource.Tables.Count; i < j; i++)
{
DataTable table = e.DSDataSource.Tables[i];
string description;
string strTableName = table.TableName;
report.RegisterData(table, strTableName);
//report.RegisterData(e.DSDataSource);
//report.ReportInfo.Description = table.TableName;
DataSourceBase dataSource = report.GetDataSource(strTableName);
dataSource.Enabled = true;
}
}
}
void BindReport(DataTable dt)
{
FastReport.Report report = new FastReport.Report();
//判断有报表数据，则注册数据
if (dt != null && dt.Rows.Count > 0)
{
report.RegisterData(dt, "v_repair_vehicle_number_report");
}
else
{
return;
}
report.GetDataSource("v_repair_vehicle_number_report").Enabled = true;
report.Load("Report/repair_vehicle_number_report.frx");
report.Preview = pcReport;
report.Prepare();
report.ShowPrepared();
}
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 = 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 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();
}
}
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();
}
}
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"));
}
}
/// <summary>
/// 生成默认报表
/// </summary>
/// <returns></returns>
public FastReport.Report DefaultReport()
{
FastReport.Report report = new FastReport.Report();
//判断有报表数据，则注册数据
if (dt != null && dt.Rows.Count > 0)
{
report.RegisterData(dt, styleObject);
}
else
{
return(null);
}
//查询报表设置
DataTable dtReportSet = DBHelper.GetTable("", "tb_report_set", "*", string.Format("set_object='{0}' and set_user='******'", styleObject, GlobalStaticObj.UserID), "", "order by set_num");
if (dtReportSet == null || dtReportSet.Rows.Count == 0)
{
return(null);
}
// enable the "Employees" table to use it in the report
report.GetDataSource(styleObject).Enabled = true;
// add report page
ReportPage page = new ReportPage();
if (paperSize != null)
{
page.PaperWidth = paperSize.Width;
page.PaperHeight = paperSize.Height;
}
report.Pages.Add(page);
// always give names to objects you create. You can use CreateUniqueName method to do this;
// call it after the object is added to a report.
page.CreateUniqueName();
// create title band
page.ReportTitle = new ReportTitleBand();
// native FastReport unit is screen pixel, use conversion
page.ReportTitle.Height = Units.Centimeters * 1;
page.ReportTitle.CreateUniqueName();
// create title text
TextObject titleText = new TextObject();
titleText.Parent = page.ReportTitle;
titleText.CreateUniqueName();
//titleText.Bounds = new RectangleF(Units.Centimeters * 5, 0, Units.Centimeters * 10, Units.Centimeters * 1);
titleText.Bounds = new RectangleF(0, 0, Units.Millimeters * page.PaperWidth, Units.Centimeters * 1);
titleText.Font = new Font("Arial", 14, FontStyle.Bold);
titleText.Text = styleTitle;
titleText.HorzAlign = HorzAlign.Center;
titleText.VertAlign = VertAlign.Center;
//内容行高
float rowHeight = Units.Centimeters * 1F;
//标题行高，如果有合并列，怎行高价高
float rowHeaderHeight = rowHeight;
if (dicSpanRows != null && dicSpanRows.Count > 0)
{
rowHeaderHeight = Units.Centimeters * 1.5f;
}
page.PageHeader = new PageHeaderBand();
page.PageHeader.Height = rowHeaderHeight;
page.PageHeader.CreateUniqueName();
#region 生成报表内容
// create data band
DataBand dataBand = new DataBand();
page.Bands.Add(dataBand);
dataBand.CreateUniqueName();
dataBand.DataSource = report.GetDataSource(styleObject);
dataBand.Height = rowHeight;
float x = 0F;//x坐标
foreach (DataRow dr in dtReportSet.Rows)
{
//判断是否要打印
if (CommonCtrl.IsNullToString(dr["is_print"]) != "1")
{
continue;
}
//列宽
float columnWidth = Units.Centimeters * 2;
//标题
string headerName = string.Empty;
//获取设置的列宽和标题
float.TryParse(dr["set_width"].ToString(), out columnWidth);
//columnWidth = columnWidth * 0.9f;
headerName = dr["set_name"].ToString();
//生成标题
TextObject txtHeader = new TextObject();
txtHeader.Parent = page.PageHeader;
txtHeader.CreateUniqueName();
txtHeader.Text = headerName;
txtHeader.HorzAlign = HorzAlign.Center;
txtHeader.VertAlign = VertAlign.Center;
//生成标题竖线
LineObject lineHeaderVer = new LineObject();
lineHeaderVer.Parent = page.PageHeader;
//生成标题横线
LineObject lineHeaderHor = new LineObject();
lineHeaderHor.Parent = page.PageHeader;
lineHeaderHor.Bounds = new RectangleF(x, 0, columnWidth, 1f);
//数据源列名称
string dataName = dr["set_data_name"].ToString();
string spanName = IsContainDataColumn(dataName);
//判断列是否是合并列
if (spanName.Length > 0)
{
#region 合并列标题
txtHeader.Bounds = new RectangleF(x, rowHeaderHeight / 2, columnWidth, rowHeaderHeight / 2);
lineHeaderVer.Bounds = new RectangleF(x, rowHeaderHeight / 2, 1F, rowHeaderHeight / 2);
//生成合并列的短竖线
LineObject lineHeaderHorSpan = new LineObject();
lineHeaderHorSpan.Parent = page.PageHeader;
lineHeaderHorSpan.Bounds = new RectangleF(x, rowHeaderHeight / 2, columnWidth, 1F);
//判断是否包含合并列头
if (dicSpanWidth.ContainsKey(spanName))
{
//增加合并列头的列宽
RectangleF rf = dicSpanWidth[spanName];
rf.Width += columnWidth;
dicSpanWidth[spanName] = rf;
}
else
{
//记录合并列头
RectangleF rf = new RectangleF();
rf.X = x;
rf.Y = 0;
rf.Width = columnWidth;
rf.Height = rowHeaderHeight / 2;
dicSpanWidth.Add(spanName, rf);
}
#endregion
}
else
{
lineHeaderVer.Bounds = new RectangleF(x, 0, 1F, rowHeaderHeight);
txtHeader.Bounds = new RectangleF(x, 0, columnWidth, rowHeaderHeight);
}
// create two text objects with employee's name and birth date
//生成内容
TextObject empNameText = new TextObject();
empNameText.Parent = dataBand;
empNameText.CreateUniqueName();
empNameText.Bounds = new RectangleF(x, 0, columnWidth, rowHeight);
DataColumn dc = dt.Columns[dataName];
empNameText.Text = string.Format("[{0}.{1}]", styleObject, dataName);
//empNameText.HideZeros = true;
if (dc != null && dc.DataType != typeof(string))
{
empNameText.HorzAlign = HorzAlign.Right;
}
else
{
empNameText.HorzAlign = HorzAlign.Center;
}
empNameText.VertAlign = VertAlign.Center;
//生成内容列的竖线
LineObject lineVertical = new LineObject();
lineVertical.Parent = dataBand;
lineVertical.Bounds = new RectangleF(x, 0, 1F, rowHeight);
//生成内容列顶部的横线
LineObject lineHorizontal = new LineObject();
lineHorizontal.Parent = dataBand;
lineHorizontal.Bounds = new RectangleF(x, 0, columnWidth, 1f);
//生成内荣列底部的横线
LineObject lineHorizontalD = new LineObject();
lineHorizontalD.Parent = dataBand;
lineHorizontalD.Bounds = new RectangleF(x, rowHeight, columnWidth, 1f);
//x坐标增加当前列
x += columnWidth;
}
//生成标题右边的竖线
LineObject lineHeaderRightVer = new LineObject();
lineHeaderRightVer.Parent = page.PageHeader;
lineHeaderRightVer.Bounds = new RectangleF(x, 0, 1f, rowHeight);
//生成内容右边的竖线
LineObject lineRightVer = new LineObject();
lineRightVer.Parent = dataBand;
lineRightVer.Bounds = new RectangleF(x, 0, 1f, rowHeight);
//生成合并列头
foreach (string span in dicSpanWidth.Keys)
{
//合并列头
TextObject txtSpan = new TextObject();
txtSpan.Parent = page.PageHeader;
txtSpan.CreateUniqueName();
txtSpan.Bounds = dicSpanWidth[span];
txtSpan.Text = span;
txtSpan.HorzAlign = HorzAlign.Center;
txtSpan.VertAlign = VertAlign.Center;
//合并列头的竖线
LineObject lineHeaderVer = new LineObject();
lineHeaderVer.Parent = page.PageHeader;
lineHeaderVer.Bounds = new RectangleF(txtSpan.Bounds.X, txtSpan.Bounds.Y, 1f, txtSpan.Bounds.Height);
}
#endregion
return(report);
}
private void btnImprimirSugerido_Click(object sender, EventArgs e)
{
try
{
if (this.dgvDatos.DataSource == null)
return;
//(System.Collections.Generic.List<pauParteBusquedaEnTraspasos_Result>)
var lista = new List<pauParteBusquedaEnTraspasos_Result>();
foreach (DataGridViewRow fila in this.dgvDatos.Rows)
{
var cb = (DataGridViewCheckBoxCell)fila.Cells["X"];
if (cb.Value != null)
{
if (Util.Logico(cb.Value))
{
var sugerido = new pauParteBusquedaEnTraspasos_Result()
{
ParteID = Util.Entero(fila.Cells["ParteID"].Value),
NumeroParte = Util.Cadena(fila.Cells["NumeroParte"].Value),
NombreParte = Util.Cadena(fila.Cells["NombreParte"].Value),
MarcaParteID = Util.Entero(fila.Cells["MarcaParteID"].Value),
LineaID = Util.Entero(fila.Cells["LineaID"].Value),
SistemaID = Util.Entero(fila.Cells["SistemaID"].Value),
SubsistemaID = Util.Entero(fila.Cells["SubsistemaID"].Value),
SucursalID = Util.Entero(fila.Cells["SucursalID"].Value),
Existencia = Util.Decimal(fila.Cells["Existencia"].Value),
Maximo = Util.Decimal(fila.Cells["Maximo"].Value),
Minimo = Util.Decimal(fila.Cells["Minimo"].Value),
SucursalDestinoID = Util.Entero(fila.Cells["SucursalDestinoID"].Value),
DestinoExistencia = Util.Decimal(fila.Cells["DestinoExistencia"].Value),
DestinoMaximo = Util.Decimal(fila.Cells["DestinoMaximo"].Value),
DestinoMinimo = Util.Decimal(fila.Cells["DestinoMinimo"].Value),
Sugerencia = Util.Decimal(fila.Cells["Sugerencia"].Value)
};
lista.Add(sugerido);
}
}
}
IEnumerable<pauParteBusquedaEnTraspasos_Result> listaE = lista;
using (FastReport.Report report = new FastReport.Report())
{
report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteSugeridoTraspaso.frx"));
report.SetParameterValue("Origen", this.cboUbicacionOrigen.Text);
report.SetParameterValue("Destino", this.cboUbicacionDestino.Text);
report.SetParameterValue("FechaHora", DateTime.Now);
report.RegisterData(listaE, "sugerido", 3);
report.GetDataSource("sugerido").Enabled = true;
report.Show(true);
}
}
catch (Exception ex)
{
Util.MensajeError(ex.Message, GlobalClass.NombreApp);
}
}
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);
}
/// <summary>
/// 生成默认报表
/// </summary>
/// <returns></returns>
public FastReport.Report DefaultReport()
{
FastReport.Report report = new FastReport.Report();
//判断有报表数据，则注册数据
if (dt != null && dt.Rows.Count > 0)
{
report.RegisterData(dt, styleObject);
}
else
{
return null;
}
//查询报表设置
DataTable dtReportSet = DBHelper.GetTable("", "tb_report_set", "*", string.Format("set_object='{0}' and set_user='******'", styleObject, GlobalStaticObj.UserID), "", "order by set_num");
if (dtReportSet == null || dtReportSet.Rows.Count == 0)
{
return null;
}
// enable the "Employees" table to use it in the report
report.GetDataSource(styleObject).Enabled = true;
// add report page
ReportPage page = new ReportPage();
if (paperSize != null)
{
page.PaperWidth = paperSize.Width;
page.PaperHeight = paperSize.Height;
}
report.Pages.Add(page);
// always give names to objects you create. You can use CreateUniqueName method to do this;
// call it after the object is added to a report.
page.CreateUniqueName();
// create title band
page.ReportTitle = new ReportTitleBand();
// native FastReport unit is screen pixel, use conversion
page.ReportTitle.Height = Units.Centimeters * 1;
page.ReportTitle.CreateUniqueName();
// create title text
TextObject titleText = new TextObject();
titleText.Parent = page.ReportTitle;
titleText.CreateUniqueName();
//titleText.Bounds = new RectangleF(Units.Centimeters * 5, 0, Units.Centimeters * 10, Units.Centimeters * 1);
titleText.Bounds = new RectangleF(0, 0, Units.Millimeters * page.PaperWidth, Units.Centimeters * 1);
titleText.Font = new Font("Arial", 14, FontStyle.Bold);
titleText.Text = styleTitle;
titleText.HorzAlign = HorzAlign.Center;
titleText.VertAlign = VertAlign.Center;
//内容行高
float rowHeight = Units.Centimeters * 1F;
//标题行高，如果有合并列，怎行高价高
float rowHeaderHeight = rowHeight;
if (dicSpanRows != null && dicSpanRows.Count > 0)
{
rowHeaderHeight = Units.Centimeters * 1.5f;
}
page.PageHeader = new PageHeaderBand();
page.PageHeader.Height = rowHeaderHeight;
page.PageHeader.CreateUniqueName();
#region 生成报表内容
// create data band
DataBand dataBand = new DataBand();
page.Bands.Add(dataBand);
dataBand.CreateUniqueName();
dataBand.DataSource = report.GetDataSource(styleObject);
dataBand.Height = rowHeight;
float x = 0F;//x坐标
foreach (DataRow dr in dtReportSet.Rows)
{
//判断是否要打印
if (CommonCtrl.IsNullToString(dr["is_print"]) != "1")
{
continue;
}
//列宽
float columnWidth = Units.Centimeters * 2;
//标题
string headerName = string.Empty;
//获取设置的列宽和标题
float.TryParse(dr["set_width"].ToString(), out columnWidth);
//columnWidth = columnWidth * 0.9f;
headerName = dr["set_name"].ToString();
//生成标题
TextObject txtHeader = new TextObject();
txtHeader.Parent = page.PageHeader;
txtHeader.CreateUniqueName();
txtHeader.Text = headerName;
txtHeader.HorzAlign = HorzAlign.Center;
txtHeader.VertAlign = VertAlign.Center;
//生成标题竖线
LineObject lineHeaderVer = new LineObject();
lineHeaderVer.Parent = page.PageHeader;
//生成标题横线
LineObject lineHeaderHor = new LineObject();
lineHeaderHor.Parent = page.PageHeader;
lineHeaderHor.Bounds = new RectangleF(x, 0, columnWidth, 1f);
//数据源列名称
string dataName = dr["set_data_name"].ToString();
string spanName = IsContainDataColumn(dataName);
//判断列是否是合并列
if (spanName.Length > 0)
{
#region 合并列标题
txtHeader.Bounds = new RectangleF(x, rowHeaderHeight / 2, columnWidth, rowHeaderHeight / 2);
lineHeaderVer.Bounds = new RectangleF(x, rowHeaderHeight / 2, 1F, rowHeaderHeight / 2);
//生成合并列的短竖线
LineObject lineHeaderHorSpan = new LineObject();
lineHeaderHorSpan.Parent = page.PageHeader;
lineHeaderHorSpan.Bounds = new RectangleF(x, rowHeaderHeight / 2, columnWidth, 1F);
//判断是否包含合并列头
if (dicSpanWidth.ContainsKey(spanName))
{
//增加合并列头的列宽
RectangleF rf = dicSpanWidth[spanName];
rf.Width += columnWidth;
dicSpanWidth[spanName] = rf;
}
else
{
//记录合并列头
RectangleF rf = new RectangleF();
rf.X = x;
rf.Y = 0;
rf.Width = columnWidth;
rf.Height = rowHeaderHeight / 2;
dicSpanWidth.Add(spanName, rf);
}
#endregion
}
else
{
lineHeaderVer.Bounds = new RectangleF(x, 0, 1F, rowHeaderHeight);
txtHeader.Bounds = new RectangleF(x, 0, columnWidth, rowHeaderHeight);
}
// create two text objects with employee's name and birth date
//生成内容
TextObject empNameText = new TextObject();
empNameText.Parent = dataBand;
empNameText.CreateUniqueName();
empNameText.Bounds = new RectangleF(x, 0, columnWidth, rowHeight);
DataColumn dc = dt.Columns[dataName];
empNameText.Text = string.Format("[{0}.{1}]", styleObject, dataName);
//empNameText.HideZeros = true;
if (dc != null && dc.DataType != typeof(string))
{
empNameText.HorzAlign = HorzAlign.Right;
}
else
{
empNameText.HorzAlign = HorzAlign.Center;
}
empNameText.VertAlign = VertAlign.Center;
//生成内容列的竖线
LineObject lineVertical = new LineObject();
lineVertical.Parent = dataBand;
lineVertical.Bounds = new RectangleF(x, 0, 1F, rowHeight);
//生成内容列顶部的横线
LineObject lineHorizontal = new LineObject();
lineHorizontal.Parent = dataBand;
lineHorizontal.Bounds = new RectangleF(x, 0, columnWidth, 1f);
//生成内荣列底部的横线
LineObject lineHorizontalD = new LineObject();
lineHorizontalD.Parent = dataBand;
lineHorizontalD.Bounds = new RectangleF(x, rowHeight, columnWidth, 1f);
//x坐标增加当前列
x += columnWidth;
}
//生成标题右边的竖线
LineObject lineHeaderRightVer = new LineObject();
lineHeaderRightVer.Parent = page.PageHeader;
lineHeaderRightVer.Bounds = new RectangleF(x, 0, 1f, rowHeight);
//生成内容右边的竖线
LineObject lineRightVer = new LineObject();
lineRightVer.Parent = dataBand;
lineRightVer.Bounds = new RectangleF(x, 0, 1f, rowHeight);
//生成合并列头
foreach (string span in dicSpanWidth.Keys)
{
//合并列头
TextObject txtSpan = new TextObject();
txtSpan.Parent = page.PageHeader;
txtSpan.CreateUniqueName();
txtSpan.Bounds = dicSpanWidth[span];
txtSpan.Text = span;
txtSpan.HorzAlign = HorzAlign.Center;
txtSpan.VertAlign = VertAlign.Center;
//合并列头的竖线
LineObject lineHeaderVer = new LineObject();
lineHeaderVer.Parent = page.PageHeader;
lineHeaderVer.Bounds = new RectangleF(txtSpan.Bounds.X, txtSpan.Bounds.Y, 1f, txtSpan.Bounds.Height);
}
#endregion
#region 生成页脚
page.PageFooter = new PageFooterBand();
page.PageFooter.Height = rowHeaderHeight;
page.PageHeader.CreateUniqueName();
TextObject txtPageN = new TextObject();
txtPageN.Parent = page.PageFooter;
txtPageN.CreateUniqueName();
txtPageN.Text = "[PageNofM]";
txtPageN.Bounds = new RectangleF(100, 0, 200, rowHeaderHeight);
//TextObject txtTotalPages = new TextObject();
//txtTotalPages.Parent = page.PageFooter;
//txtTotalPages.CreateUniqueName();
//txtTotalPages.Text = "[TotalPages]";
//txtTotalPages.Bounds = new RectangleF(350, 0, 200, rowHeaderHeight);
#endregion
return report;
}
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="TaskID"></param>
/// <param name="_LastPointSort"></param>
private void PrintReceipt(string TaskID, string _LastPointSort)
{
//获取用户基本信息
Hashtable ht = new SqlServerHelper().GetHashtableById("View_WorkBase", "TaskID", TaskID);
if (ht.Contains("SD"))
{
string _waterUserId = ht["WATERUSERID"].ToString();
string _waterUserName = ht["WATERUSERNAME"].ToString();
string _SD = ht["SD"].ToString();
string _waterUserAddress = ht["WATERUSERADDRESS"].ToString();
string _TotalFee_CH = "";//合计大写
//获取费用合计
string sqlstr = @"SELECT * FROM
(SELECT SUM(FEE) AS FEE,InvoiceType AS FEENAME,'0' AS SORT FROM
(SELECT FEE,(SELECT InvoiceTitle FROM Meter_FeeItmes WHERE FeeID=MWF.FeeID) AS InvoiceType FROM Meter_WorkResolveFee MWF,Meter_WorkResolve MWR
WHERE MWF.ResolveID=MWR.ResolveID AND MWF.[STATE]=1
AND MWR.TaskID=@TaskID AND PointSort=@LastPoingSort
) T GROUP BY InvoiceType
UNION ALL
SELECT SUM(CONVERT(decimal,Fee)),'合计','1' FROM Meter_WorkResolveFee MWF,Meter_WorkResolve MWR
WHERE MWF.ResolveID=MWR.ResolveID AND MWF.[STATE]=1
AND MWR.TaskID=@TaskID AND PointSort=@LastPoingSort) M WHERE FEE<>0";
//FEE--收费金额
//FEENAME--收费名称
DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@TaskID", TaskID), new SqlParameter("@LastPoingSort", _LastPointSort) });
if (DataTableHelper.IsExistRows(dt))
{
DataRow[] DR = dt.Select("SORT=1");
if (DR.Length.Equals(1))
{
_TotalFee_CH = RMBHelper.CmycurD(decimal.Parse(DR[0]["FEE"].ToString()));
}
//====================================打印
DataSet ds = new DataSet();
DataTable dtTemp = dt.Copy();
dtTemp.TableName = "收据模板";
ds.Tables.Add(dtTemp);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\业扩模板\业扩预算收据模板.frx");
(report1.FindObject("txtReceiptNO") as FastReport.TextObject).Text = "NO." + RECEIPTNO.Text;
(report1.FindObject("txtWaterUserNO") as FastReport.TextObject).Text = "用 户 号:" + _waterUserId;
(report1.FindObject("txtSD") as FastReport.TextObject).Text = "受理编号:" + _SD;
(report1.FindObject("txtWaterUserName") as FastReport.TextObject).Text = "用户名称:" + _waterUserName;
(report1.FindObject("txtWaterUserAddress") as FastReport.TextObject).Text = "地 址:" + _waterUserAddress;
(report1.FindObject("txtCapMoney") as FastReport.TextObject).Text = "金额大写:" + _TotalFee_CH;
(report1.FindObject("txtCasher") as FastReport.TextObject).Text = "收 款 员:" + strRealName;
(report1.FindObject("txtReceiptNO1") as FastReport.TextObject).Text = "NO." + RECEIPTNO.Text;
(report1.FindObject("txtWaterUserNO1") as FastReport.TextObject).Text = "用 户 号:" + _waterUserId;
(report1.FindObject("txtSD1") as FastReport.TextObject).Text = "受理编号:" + _SD;
(report1.FindObject("txtWaterUserName1") as FastReport.TextObject).Text = "用户名称:" + _waterUserName;
(report1.FindObject("txtWaterUserAddress1") as FastReport.TextObject).Text = "地 址:" + _waterUserAddress;
(report1.FindObject("txtCapMoney1") as FastReport.TextObject).Text = "金额大写:" + _TotalFee_CH;
(report1.FindObject("txtCasher1") as FastReport.TextObject).Text = "收 款 员:" + strRealName;
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("收据模板").Enabled = true;
//report1.Show();
report1.PrintSettings.ShowDialog = false;
report1.Prepare();
report1.Print();
}
catch (Exception ex)
{
mes.Show("收据打印失败:" + ex.Message);
}
}
}
}
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"));
}
}
}
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"));
}
}
void BindReport(DataTable dt)
{
FastReport.Report report = new FastReport.Report();
//判断有报表数据，则注册数据
if (dt != null && dt.Rows.Count > 0)
{
report.RegisterData(dt, "v_repair_vehicle_number_report");
}
else
{
return;
}
report.GetDataSource("v_repair_vehicle_number_report").Enabled = true;
report.Load("Report/repair_vehicle_number_report.frx");
report.Preview = pcReport;
report.Prepare();
report.ShowPrepared();
}
private void btnImprimirRpt_Click(object sender, EventArgs e)
{
try
{
if (this.dgvReporteVentas.DataSource == null)
return;
var lista = (System.Collections.Generic.List<pauVentasCancelaciones_Result>)this.dgvReporteVentas.DataSource;
IEnumerable<pauVentasCancelaciones_Result> listaE = lista;
using (FastReport.Report report = new FastReport.Report())
{
report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteVentasCancelaciones.frx"));
report.SetParameterValue("Origen", this.cboSucursalRpt.Text);
report.SetParameterValue("Desde", this.dtpDesdeRpt.Value);
report.SetParameterValue("Hasta", this.dtpHastaRpt.Value);
report.RegisterData(listaE, "ventasCancelaciones", 3);
report.GetDataSource("ventasCancelaciones").Enabled = true;
report.Show(true);
}
}
catch (Exception ex)
{
Util.MensajeError(ex.Message, GlobalClass.NombreApp);
}
}
