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);
}
}
