private void butprint_pos_Click(object sender, EventArgs e) { DataTable tb = (DataTable)this.dataGridViewX1.DataSource; DataSetjk.yjjszqkDataTable tbyjj = new DataSetjk.yjjszqkDataTable(); DataRow dr; for (int i = 0; i <= tb.Rows.Count - 1; i++) { dr = tbyjj.NewRow(); for (int j = 1; j < tb.Columns.Count; j++) { if (tb.Columns[j].ColumnName == "财务记帐") { tb.Columns[j].ColumnName = "财务记账"; } dr[tb.Columns[j].ColumnName] = tb.Rows[i][tb.Columns[j].ColumnName]; } tbyjj.Rows.Add(dr); } ParameterEx[] parameters = new ParameterEx[2]; parameters[0].Text = "医院名称"; parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName; parameters[1].Text = "统计日期"; parameters[1].Value = "日期从:" + dtpjsrq1.Value.ToString() + " 到:" + dtpjsrq2.Value.ToString(); TrasenFrame.Forms.FrmReportView f; f = new FrmReportView(tbyjj, Constant.ApplicationDirectory + "\\Report\\门诊预交金收支情况表.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } }
private void btnprint_Click(object sender, EventArgs e) { if (dgvData.DataSource == null) { return; } try { DataTable dt = dgvData.DataSource as DataTable; FrmReportView f = new FrmReportView(dt, Constant.ApplicationDirectory + "\\Report\\交款票据统计.rpt", null); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (Exception err) { MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void butprint_pos_Click(object sender, EventArgs e) { if (dataGridView1.DataSource == null) { return; } try { DataTable tb = (DataTable)dataGridView1.DataSource; ts_mz_report.DataSet1 ds = new ts_mz_report.DataSet1(); DataRow dr; for (int i = 0; i <= tb.Rows.Count - 1; i++) { dr = ds.门诊预交金消费对账.NewRow(); int x = i + 1; dr["序号"] = Convert.ToString(Convertor.IsNull(tb.Rows[i]["序号"], "")); dr["姓名"] = Convert.ToString(Convertor.IsNull(tb.Rows[i]["姓名"], "")); dr["卡号"] = Convert.ToString(Convertor.IsNull(tb.Rows[i]["卡号"], "")); dr["现金存入"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["现金存入"], "0")); dr["发生日期1"] = Convert.ToString(Convertor.IsNull(tb.Rows[i]["现金日期"], "")); dr["银行转账"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["银行转账"], "0")); dr["发生日期2"] = Convert.ToString(Convertor.IsNull(tb.Rows[i]["转账日期"], "")); dr["支出"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["支出"], "0")); dr["发生日期3"] = Convert.ToString(Convertor.IsNull(tb.Rows[i]["支出日期"], "")); dr["卡余额"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["卡余额"], "0")); dr["收款员"] = Convert.ToString(Convertor.IsNull(tb.Rows[i]["收款员"], "")); ds.门诊预交金消费对账.Rows.Add(dr); } ParameterEx[] parameters = new ParameterEx[9]; parameters[0].Text = "医院名称"; parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName; parameters[1].Text = "填报日期"; parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString(); parameters[2].Text = "填报人"; parameters[2].Value = InstanceForm.BCurrentUser.Name; parameters[3].Text = "rq1"; parameters[3].Value = dtpjsrq1.Value.ToString(); parameters[4].Text = "rq2"; parameters[4].Value = dtpjsrq2.Value.ToString(); parameters[5].Text = "现金合计"; parameters[5].Value = lblcrxj.Text.ToString(); parameters[6].Text = "转账合计"; parameters[6].Value = lblyhzz.Text.ToString(); parameters[7].Text = "支出合计"; parameters[7].Value = lblljxf.Text.ToString(); parameters[8].Text = "余额合计"; parameters[8].Value = lbljcje.Text.ToString(); TrasenFrame.Forms.FrmReportView f; f = new FrmReportView(ds, Constant.ApplicationDirectory + "\\Report\\MZ_预交金消费对账.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }