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>
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 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
}
/// <summary>
/// Creates the unique object's name.
/// </summary>
/// <remarks>
/// <para><b>Note:</b> you have to set object's parent before calling this method. Method uses the <see cref="BaseName"/>
/// property to create a name.</para>
/// <para><b>Note:</b> this method may be very slow on a report that contains lots of objects. Consider
/// using own naming logic in this case.</para>
/// </remarks>
/// <example>
/// <code>
/// TextObject textObj = new TextObject();
/// dataBand1.Objects.Add(textObj);
/// textObj.CreateUniqueName();
/// </code>
/// </example>
public void CreateUniqueName()
{
Report report = Report;
if (report == null)
{
return;
}
string s;
int i = 1;
do
{
s = baseName + i.ToString();
i++;
}while (report.FindObject(s) != null);
SetName(s);
}
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();
}
}
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="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);
}
}
}
}
