private void PrintReport()
{
try
{
DataTable tbmx = GetDataOfPrint();
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "开始日期";
parameters[0].Value = dtpBjksj.Value.ToString("yyyy-MM-dd");
parameters[1].Text = "结束日期";
parameters[1].Value = this.dtpEjksj.Value.ToString("yyyy-MM-dd");
parameters[2].Text = "病人类型";
parameters[2].Value = comboBox1.Text;
TrasenFrame.Forms.FrmReportView f = null;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\住院欠费结算明细报表.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_Click(object sender, EventArgs e)
{
try
{
DataTable tbmx = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "开始日期";
parameters[0].Value = dtpBjksj.Value.ToString("yyyy-MM-dd");
parameters[1].Text = "结束日期";
parameters[1].Value = dtpBjksj.Value.ToString("yyyy-MM-dd");
parameters[2].Text = "统计方式";
parameters[2].Value = cmbtjfs.Text;
TrasenFrame.Forms.FrmReportView f = null;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\业务收入报表.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.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 dtzf = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 dset = new ts_mz_report.DataSet1();
DataRow dr;
for (int i = 0; i <= dtzf.Rows.Count - 1; i++)
{
dr = dset.银医支付方式统计.NewRow();
int x = i + 1;
dr["序号"] = Convert.ToString(dtzf.Rows[i]["序号"]);
dr["卡号"] = Convert.ToString(dtzf.Rows[i]["卡号"]);
dr["卡类型"] = Convert.ToString(dtzf.Rows[i]["卡类型"]);
dr["病人姓名"] = Convert.ToString(dtzf.Rows[i]["病人姓名"]);
dr["身份证号"] = Convert.ToString(dtzf.Rows[i]["身份证号"]);
dr["预交金"] = Convert.ToDecimal(Convertor.IsNull(dtzf.Rows[i]["预交金"], "0"));
dr["现金支付"] = Convert.ToDecimal(Convertor.IsNull(dtzf.Rows[i]["现金支付"], "0"));
dr["银联支付"] = Convert.ToDecimal(Convertor.IsNull(dtzf.Rows[i]["银联支付"], "0"));
dr["财务记账"] = Convert.ToDecimal(Convertor.IsNull(dtzf.Rows[i]["财务记账"], "0"));
dr["医保支付"] = Convert.ToDecimal(Convertor.IsNull(dtzf.Rows[i]["医保支付"], "0"));
dset.银医支付方式统计.Rows.Add(dr);
}
ParameterEx[] parameters = new ParameterEx[4];
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 = "收费日期:" + startTjrq.Value.ToString() + " 到 " + endTjrq.Value.ToString();
parameters[3].Text = "统计人";
parameters[3].Value = InstanceForm.BCurrentUser.Name;
bool bprint = chkprint.Checked == true ? false : true;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(dset, Constant.ApplicationDirectory + "\\Report\\MZ_银医诊疗卡支付方式统计.rpt", parameters, bprint);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnprintmxbfy_Click(object sender, EventArgs e)
{
if (dataGridView2.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[1];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医保结算统计(明细不分页).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//医院端打印
private void tsmt_print2_Click(object sender, EventArgs e)
{
try
{
DataTable tb = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 dset = new ts_mz_report.DataSet1();
DataRow dr;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
dr = dset._建行自助机对账明细统计_医院端_.NewRow();
int x = i + 1;
dr["序号"] = Convert.ToString(tb.Rows[i]["序号"]);
dr["医院交易代码"] = Convert.ToString(tb.Rows[i]["医院交易代码"]);
dr["医院交易日期"] = Convert.ToString(tb.Rows[i]["医院交易日期"]);
dr["医院交易金额"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["医院交易金额"], "0"));
dr["医院手续费"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["医院手续费"], "0"));
dr["平台流水号"] = Convert.ToString(tb.Rows[i]["平台流水号"]);
dr["自助终端号"] = Convert.ToString(tb.Rows[i]["自助终端号"]);
dset._建行自助机对账明细统计_医院端_.Rows.Add(dr);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = fHospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(db).ToShortDateString();
parameters[2].Text = "备注";
parameters[2].Value = "统计日期:" + bDateTime.ToString() + " 到 " + eDateTime.ToString();
parameters[3].Text = "统计人";
parameters[3].Value = fOperName;
string strReportDir = fApplicationDir + "\\Report\\MZ_建设银行自助机对账明细统计（医院端）.rpt";
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(dset._建行自助机对账明细统计_医院端_, strReportDir, parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void tsmt_print2_Click(object sender, EventArgs e)
{
try
{
DataTable tb = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 dset = new ts_mz_report.DataSet1();
DataRow dr;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
dr = dset._工商银行自助机对账明细统计_医院端_.NewRow();
int x = i + 1;
dr["序号"] = Convert.ToString(tb.Rows[i]["序号"]);
dr["HIS_卡号"] = Convert.ToString(tb.Rows[i]["HIS_卡号"]);
dr["HIS_金额"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["HIS_金额"], "0"));
dr["银行流水号"] = Convert.ToString(tb.Rows[i]["银行流水号"]);
dr["HIS_交易日期"] = Convert.ToString(tb.Rows[i]["HIS_交易日期"]);
dr["HIS_时间"] = Convert.ToString(tb.Rows[i]["HIS_时间"]);
dr["银行终端"] = Convert.ToString(tb.Rows[i]["银行终端"]);
dset._工商银行自助机对账明细统计_医院端_.Rows.Add(dr);
}
ParameterEx[] parameters = new ParameterEx[4];
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 = "统计日期:" + ksrq.ToString() + " 到 " + jsrq.ToString();
parameters[3].Text = "统计人";
parameters[3].Value = InstanceForm.BCurrentUser.Name;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(dset, Constant.ApplicationDirectory + "\\Report\\MZ_工商银行自助机对账明细统计(医院端).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_pos_Click(object sender, EventArgs e)
{
try
{
DataTable tbmx = dset.Tables[0];
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
int x = 0;
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = x + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
//}
}
Dset.收费项目.Rows.Add(myrow);
x = 0;
for (int nrow = 0; nrow <= tbmx.Rows.Count - 2; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
//}
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[12];
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 = chkbkrq.Checked == true?dtpjsrq1.Value.ToString() : "";
parameters[4].Text = "rq2";
parameters[4].Value = chkbkrq.Checked == true?dtpjsrq2.Value.ToString() : "";
parameters[5].Text = "工作单位";
parameters[5].Value = txtgzdw.Text;
parameters[6].Text = "家庭地址";
parameters[6].Value = txtjtdz.Text;
string zt = "";
if (chkye.Checked == true)
{
zt = "有余额";
}
if (chkdj.Checked == true)
{
zt = zt + " 已冻结";
}
if (chkgs.Checked == true)
{
zt = zt + " 已挂失";
}
parameters[7].Text = "其它";
parameters[7].Value = "状态: " + zt;
parameters[8].Text = "办卡张数";
parameters[8].Value = lblbkzs.Text;
parameters[9].Text = "累计存入";
parameters[9].Value = lblljcr.Text;
parameters[10].Text = "累计消费";
parameters[10].Value = lblljxf.Text;
parameters[11].Text = "结余金额";
parameters[11].Value = lbljcje.Text;
bool bprint = chkprint.Checked == true ? false : true;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_预交款结余情况表.rpt", parameters, bprint);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, EventArgs e)
{
try
{
DataTable tbsk = (DataTable)dataGridView1.DataSource;
if (tbsk == null)
{
return;
}
if (tbsk.Rows.Count == 1 && tbsk.Rows[0]["序号"].ToString().Trim() == "合计")
{
return;
}
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow;
for (int i = 0; i <= tbsk.Rows.Count - 1; i++)
{
myrow = Dset.交款表.NewRow();
int x = i + 1;
myrow["序号"] = Convert.ToString(tbsk.Rows[i]["序号"]);
myrow["收费员"] = Convert.ToString(tbsk.Rows[i]["收费员"]);
myrow["交款时间"] = Convert.ToString(tbsk.Rows[i]["缴款时间"]);
myrow["发票金额"] = Convert.ToString(tbsk.Rows[i]["发票金额"]);;
myrow["有效张数"] = Convert.ToString(tbsk.Rows[i]["有效张数"]);
myrow["废票张数"] = Convert.ToString(tbsk.Rows[i]["废票张数"]);
myrow["现金支付"] = Convert.ToString(tbsk.Rows[i]["现金支付"]);
myrow["支票支付"] = Convert.ToString(tbsk.Rows[i]["支票支付"]);
myrow["银联支付"] = Convert.ToString(tbsk.Rows[i]["银联支付"]);
myrow["医保支付"] = Convert.ToString(tbsk.Rows[i]["医保支付"]);
myrow["财务记账"] = Convert.ToString(tbsk.Rows[i]["财务记账"]);
myrow["欠费挂账"] = Convert.ToString(tbsk.Rows[i]["欠费挂账"]);
myrow["优惠金额"] = Convert.ToString(tbsk.Rows[i]["优惠金额"]);
myrow["发票段"] = Convert.ToString(tbsk.Rows[i]["收费票段"]) + " " + Convert.ToString(Convertor.IsNull(tbsk.Rows[i]["作废票号"], ""));
myrow["作废票号"] = Convert.ToString(tbsk.Rows[i]["作废票号"]);
myrow["作废金额"] = Convert.ToString(tbsk.Rows[i]["废票金额"]);
if (tbsk.Columns.Contains("缴款科室") == true)
{
myrow["缴款科室"] = Convert.ToString(tbsk.Rows[i]["缴款科室"]);
}
if (tbsk.Columns.Contains("离休老干"))
{
myrow["离休老干"] = Convert.ToString(tbsk.Rows[i]["离休老干"]);
}
if (tbsk.Columns.Contains("职工血透"))
{
myrow["职工血透"] = Convert.ToString(tbsk.Rows[i]["职工血透"]);
}
Dset.交款表.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[4];
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 = dtp1.Value.ToString() + " 到 " + dtp2.Value.ToString() + " 收费员:" + cmbuser.Text.Trim();
parameters[3].Text = "现金大写";
parameters[3].Value = "";
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_操作员缴款汇总表.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null || ((DataTable)this.dataGridView1.DataSource).Rows.Count == 0)
{
MessageBox.Show("没有数据！");
return;
}
try
{
DataTable tbsk = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow;
for (int i = 0; i <= tbsk.Rows.Count - 1; i++)
{
myrow = Dset.合同单位汇总.NewRow();
int x = i + 1;
//myrow["序号"] = Convert.ToString(tbsk.Rows[i]["序号"]);
myrow["单位类型"] = Convert.ToString(tbsk.Rows[i]["单位性质"]);
myrow["合同单位名称"] = Convert.ToString(tbsk.Rows[i]["单位名称"]);
myrow["应收"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["应收"], "0"));
myrow["优惠"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["优惠"], "0"));
myrow["实收"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["实收"], "0"));
myrow["dwmc"] = Convertor.IsNull(tbsk.Rows[i]["dwmc"], "");
Dset.合同单位汇总.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "统计条件";
if (_menuTag.Function_Name == "Fun_ts_mz_tjbb_jk_htdw")
{
parameters[1].Value = "缴款日期从:" + dtp1.Value.ToString() + " 到:" + dtp2.Value.ToString() + " 缴款员:" + cmbuser.Text + " 统计部门:" + cmbjgbm.Text;
}
else
{
parameters[1].Value = "收款日期从:" + dtp1.Value.ToString() + " 到:" + dtp2.Value.ToString() + " 收费员:" + cmbuser.Text + " 统计部门:" + cmbjgbm.Text;
}
parameters[2].Text = "备注";
parameters[2].Value = cmbjgbm.Text;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_合同单位汇总.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprintmx_Click(object sender, EventArgs e)
{
if (dataGridView2.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
if (tbmx.Rows[nrow]["医保类型"].ToString() != "总计")
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
}
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
string ss = "部门:" + cmbjgbm.Text;
if (Convertor.IsNull(cmbyblx.SelectedValue, "0") != "0")
{
ss = ss + " 医保类型:" + cmbyblx.Text.Trim();
}
if (Convertor.IsNull(cmbsfy.SelectedValue, "0") != "0")
{
ss = ss + " 收费员:" + cmbsfy.Text.Trim();
}
ss = ss + " 收费日期:" + dtp1.Value.ToString() + " 到 " + dtp2.Value.ToString();
parameters[2].Text = "备注";
parameters[2].Value = ss;
parameters[3].Text = "现金大写";
parameters[3].Value = "";
parameters[4].Text = "操作员";
parameters[4].Value = InstanceForm.BCurrentUser.Name;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医保结算统计(明细).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDy_Click(object sender, EventArgs e)
{
try
{
if (dataGridView1.DataSource == null)
{
MessageBox.Show("没有数据！");
return;
}
DataTable tbmx = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
string bz = "";
if (txtDept.Text.Trim() != "")
{
bz = bz + " 开单科室:" + txtDept.Text.Trim();
}
if (txtUser.Text.Trim() != "")
{
bz = bz + " 开单医生:" + txtUser.Text.Trim();
}
parameters[2].Text = "备注";
parameters[2].Value = dtpTjKs.Value.ToString() + " 到 " + dtpTjJs.Value.ToString() + " " + " 部门名称:" + cmbjgbm.Text + " " + bz;
parameters[3].Text = "现金大写";
parameters[3].Value = "";
TrasenFrame.Forms.FrmReportView f;
//if (rdJg.Checked == true)
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医生收入情况统计.rpt", parameters);
//else
// f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医生收入报表(会计).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
if (dataGridView2.DataSource == null)
{
return;
}
DataTable hztb = (DataTable)dataGridView1.DataSource;
DataTable mxtb = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow;
for (int i = 0; i <= hztb.Rows.Count - 1; i++)
{
myrow = Dset.银医办卡统计.NewRow();
myrow["序号"] = Convert.ToString(hztb.Rows[i]["序号"]);
myrow["卡类型"] = Convert.ToString(hztb.Rows[i]["卡类型"]);
myrow["办卡数"] = Convert.ToString(hztb.Rows[i]["办卡数"]);
myrow["有效数"] = Convert.ToString(hztb.Rows[i]["有效数"]);
myrow["退卡数"] = Convert.ToString(hztb.Rows[i]["退卡数"]);
myrow["冻结数"] = Convert.ToString(hztb.Rows[i]["冻结数"]);
myrow["挂失数"] = Convert.ToString(hztb.Rows[i]["挂失数"]);
//myrow["预交金"] = Convert.ToString(hztb.Rows[i]["预交金"]);
myrow["办卡金额"] = Convert.ToString(hztb.Rows[i]["办卡金额"]);
myrow["退办卡金额"] = Convert.ToString(hztb.Rows[i]["退办卡金额"]);
Dset.银医办卡统计.Rows.Add(myrow);
}
DataRow mymxrow;
for (int i = 0; i <= mxtb.Rows.Count - 1; i++)
{
mymxrow = Dset.诊疗卡办卡明细.NewRow();
mymxrow["序号"] = Convert.ToString(mxtb.Rows[i]["序号"]);
mymxrow["姓名"] = Convert.ToString(mxtb.Rows[i]["姓名"]);
mymxrow["卡号"] = Convert.ToString(mxtb.Rows[i]["卡号"]);
//mymxrow["预交金"] = Convert.ToString(mxtb.Rows[i]["预交金"]);
mymxrow["身份证号"] = Convert.ToString(mxtb.Rows[i]["身份证"]);
mymxrow["办卡金额"] = Convert.ToString(mxtb.Rows[i]["办卡金额"]);
mymxrow["退卡金额"] = Convert.ToString(mxtb.Rows[i]["退办卡金额"]);
mymxrow["办卡操作员"] = Convert.ToString(mxtb.Rows[i]["办卡操作员"]);
mymxrow["退卡操作员"] = Convert.ToString(mxtb.Rows[i]["退卡操作员"]);
Dset.诊疗卡办卡明细.Rows.Add(mymxrow);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "日期";
parameters[0].Value = dtp1.Value.ToString() + " - " + dtp2.Value.ToString();
parameters[1].Text = "打印人";
parameters[1].Value = InstanceForm.BCurrentUser.Name;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_诊疗卡办卡数统计.rpt", parameters, false);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
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);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[6];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "统计来源";
parameters[1].Value = rdmz.Checked == true ? "门诊" : "住院";
parameters[2].Text = "统计类型";
parameters[2].Value = rdoqr.Checked == true ? "确认情况" : "开单情况";
parameters[3].Text = "rq1";
parameters[3].Value = dtp1.Value.ToShortDateString();
parameters[4].Text = "rq2";
parameters[4].Value = dtp2.Value.ToShortDateString();
parameters[5].Text = "jgbm";
parameters[5].Value = cmbjgbm.Text;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\YY_执行科室收入明细情况.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dgvList.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dgvList.DataSource;
if (tbmx == null || tbmx.Rows.Count == 0) //Add by zp 2013-10-22
{
MessageBox.Show("没有需要打印的数据!", "提示");
return;
}
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "统计时间";
parameters[1].Value = this.dtp1.Value.ToString("yyyy-MM-dd HH:mm:ss") + " ～ " + this.dtp2.Value.ToString("yyyy-MM-dd HH:mm:ss");
parameters[2].Text = "制表人";
parameters[2].Value = TrasenFrame.Forms.FrmMdiMain.CurrentUser.Name;
string ss = "";
if (txtks.Text.Trim() != "")
{
ss = " 接诊科室：" + txtks.Text.Trim();
}
if (cmbghjb.SelectedIndex != 0)
{
ss = ss + " 接诊级别：" + cmbghjb.Text.Trim();
}
if (txtys.Text.Trim() != "")
{
ss = ss + " 接诊医生：" + txtys.Text.Trim();
}
parameters[3].Text = "其它条件";
parameters[3].Value = ss;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_门诊医生接诊量统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null || ((DataTable)dataGridView1.DataSource).Rows.Count == 0)
{
MessageBox.Show("没有数据！");
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
try
{
//add by zouchihua 2013-5-6
myrow["T47"] = this.txtBkje.Text;
}
catch { };
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[26];
parameters[0].Text = "结帐起始时间";
parameters[0].Value = "";
parameters[1].Text = "医院名称";
parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[2].Text = "收费员";
parameters[2].Value = cmbuser.Text;
parameters[3].Text = "挂号退费数";
parameters[3].Value = "";
parameters[4].Text = "挂号退费金额";
parameters[4].Value = "";
parameters[5].Text = "收费退费数";
parameters[5].Value = "";
parameters[6].Text = "收费退费金额";
parameters[6].Value = "";
parameters[7].Text = "填报日期";
parameters[7].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
parameters[8].Text = "现金";
parameters[8].Value = lblxjzf.Text.Trim();
parameters[9].Text = "银联";
parameters[9].Value = lblylkzf.Text.Trim();
parameters[10].Text = "医保";
parameters[10].Value = lblybzf.Text.Trim();
parameters[11].Text = "财务记账";
parameters[11].Value = lblcwjz.Text.Trim();
parameters[12].Text = "欠费";
parameters[12].Value = lblqfgz.Text.Trim();
parameters[13].Text = "优惠";
parameters[13].Value = lblyhje.Text.Trim();
parameters[14].Text = "舍入";
parameters[14].Value = lblsrje.Text.Trim();
parameters[15].Text = "有效张数";
parameters[15].Value = lblyxzs.Text.Trim() + "张";
parameters[16].Text = "废票张数";
parameters[16].Value = lblfpzs.Text.Trim() + "张";
parameters[17].Text = "发票金额";
parameters[17].Value = lblfpje.Text.Trim();
parameters[18].Text = "现金大写";
parameters[18].Value = "";
parameters[19].Text = "备注";
parameters[19].Value = lblrq.Text + ":" + dtp1.Value.ToString() + " 到:" + dtp2.Value.ToString() + " 收费员:" + cmbuser.Text.Trim() + " 部门名称:" + cmbjgbm.Text;
parameters[20].Text = "废票金额";
parameters[20].Value = lblzfje.Text.Trim();
parameters[21].Text = "废票号集合";
parameters[21].Value = "";
parameters[22].Text = "支票";
parameters[22].Value = lblzpzf.Text;
parameters[23].Text = "预收款";
parameters[23].Value = lblyjj.Text;
//add by tck 2013-08-22
parameters[24].Text = "离休老干";
parameters[24].Value = lgje.ToString();
parameters[25].Text = "职工血透";
parameters[25].Value = xtje.ToString();
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_门诊收费项目及收入统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnsfyhz_Click(object sender, EventArgs e)
{
if (dataGridView2.DataSource == null)
{
return;
}
DataTable tb = (DataTable)dataGridView2.DataSource;
string[] GroupbyField1 = { "医保类型", "结算员" };
string[] ComputeField1 = { "结算金额", "帐户支付", "统筹支付", "其它支付", "现金支付" };
string[] CField1 = { "sum", "sum", "sum", "sum", "sum" };
TrasenFrame.Classes.TsSet xcset1 = new TrasenFrame.Classes.TsSet();
xcset1.TsDataTable = tb;
DataTable tbcf1 = xcset1.GroupTable(GroupbyField1, ComputeField1, CField1, "");
if (tbcf1.Rows.Count == 0)
{
return;
}
tbcf1.Columns.Remove("发票号");
tbcf1.Columns.Remove("姓名");
tbcf1.Columns.Remove("结算时间");
try
{
DataTable tbmx = tbcf1;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "条件";
parameters[1].Value = "收费日期:" + dtp1.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 到 " + dtp2.Value.ToString("yyyy-MM-dd HH:mm:ss");
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医保结算统计(按收费员汇总).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Print(Guid kjeid)
{
try
{
string ssql = "select dbo.FUN_ZY_SEEKFKFSNAME(a.fkfs) 支付方式,b.kye,a.* from yy_kdjb_je a inner join yy_kdjb b on a.kdjid=b.kdjid where a.kjeid='" + kjeid.ToString() + "' and a.bzfbz=0 and a.bdzbz=1";
DataTable tb = InstanceForm.BDatabase.GetDataTable(ssql);
if (tb.Rows.Count != 0)
{
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow;
myrow = Dset.预收款.NewRow();
myrow["类型"] = tb.Rows[0]["支付方式"].ToString();
myrow["票据号"] = tb.Rows[0]["pjh"].ToString();
myrow["金额"] = tb.Rows[0]["crje"].ToString();
myrow["收款日期"] = tb.Rows[0]["djsj"].ToString();
myrow["收款员"] = Fun.SeekEmpName(Convert.ToInt32(tb.Rows[0]["djy"]), InstanceForm.BDatabase);
myrow["大写金额"] = Money.NumToChn(tb.Rows[0]["crje"].ToString());
myrow["银行"] = tb.Rows[0]["khyh"].ToString();
myrow["单位"] = tb.Rows[0]["khdw"].ToString();
myrow["姓名"] = lblbrxm.Text;
myrow["支票号"] = tb.Rows[0]["zph"].ToString();
myrow["卡号"] = txtkh.Text;
myrow["年龄"] = lblnl.Text;
myrow["性别"] = lblxb.Text;
myrow["联系方式"] = lbllxfs.Text;
myrow["备注"] = tb.Rows[0]["bz"].ToString();
Dset.预收款.Rows.Add(myrow);
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "门诊预收款凭证";
//Add by zp 2014-01-07 新增卡余额参数
parameters[1].Text = "卡余额";
parameters[1].Value = tb.Rows[0]["kye"];
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_预收款票据.rpt", parameters);
string Bview = ApiFunction.GetIniString("划价收费", "发票预览", Constant.ApplicationDirectory + "//ClientWindow.ini");
if (Bview == "true")
{
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
else
{
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_预收款票据.rpt", parameters, true);
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null || ((DataTable)dataGridView1.DataSource).Rows.Count == 0)
{
MessageBox.Show("没有数据！");
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
string rq = "";
string sfy = "";
if (_menuTag.Function_Name == "Fun_ts_mz_tjbb_yb_rtj_jk")
{
rq = "缴款日期:";
sfy = "缴款员:";
}
else
{
rq = "收费日期:";
sfy = "收费员:";
}
parameters[2].Text = "备注";
parameters[2].Value = rq + dtp1.Value.ToString() + " 到 " + dtp2.Value.ToString() + " 部门名称:" + cmbjgbm.Text + " " + sfy + cmbuser.Text.Trim();
parameters[3].Text = "现金大写";
parameters[3].Value = "";
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_门诊医保日统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_Click(object sender, EventArgs e)
{
try
{
DataTable tbmx = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
string jsfs = "";
if (rbAll.Checked == true)
{
jsfs = rbAll.Text;
}
if (rbYb.Checked == true)
{
jsfs = rbYb.Text;
}
if (rbZf.Checked == true)
{
jsfs = rbZf.Text;
}
string ssql = rdJg.Checked == true ? "统计:按经管项目分类" : "统计:按会计项目分类";
parameters[2].Text = "备注";
parameters[2].Value = dtp1.Value.ToString() + " 到 " + dtp2.Value.ToString() + " " + ssql + " 部门名称:" + cmbjgbm.Text + " 结算方式:" + jsfs;
parameters[3].Text = "现金大写";
parameters[3].Value = "";
TrasenFrame.Forms.FrmReportView f;
if (rdJg.Checked == true)
{
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_科室收入报表(经管).rpt", parameters);
}
else
{
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_科室收入报表(会计).rpt", parameters);
}
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView1.DataSource;
DataTable tbzf = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Rows.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Rows[i]["项目"].ToString();
}
Dset.收费项目.Rows.Add(myrow);
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
int x = nrow + 1;
string nm = "je" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow]["金额"].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
DataRow myrow2 = Dset.收费项目1.NewRow();
for (int i = 0; i <= tbzf.Rows.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow2[nm] = tbzf.Rows[i]["项目"].ToString();
}
Dset.收费项目1.Rows.Add(myrow2);
DataRow myrow3 = Dset.收费项目金额1.NewRow();
for (int nrow = 0; nrow <= tbzf.Rows.Count - 1; nrow++)
{
int x = nrow + 1;
string nm = "je" + x.ToString();
myrow3[nm] = tbzf.Rows[nrow]["金额"].ToString();
}
Dset.收费项目金额1.Rows.Add(myrow3);
ParameterEx[] parameters = new ParameterEx[8];
parameters[0].Text = "结帐起始时间";
parameters[0].Value = "" + dtp1.Value.ToString() + " 到:" + dtp2.Value.ToString();
parameters[1].Text = "医院名称";
parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[2].Text = "填报日期";
parameters[2].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
parameters[3].Text = "备注";
parameters[3].Value = "";
decimal sumhj = Convert.ToDecimal(Convertor.IsNull(tbzf.Compute("sum(金额)", "项目='发票金额'"), "0"));
parameters[4].Text = "合计大写";
parameters[4].Value = Money.NumToChn(sumhj.ToString());
parameters[5].Text = "合计小写";
parameters[5].Value = sumhj;
parameters[6].Text = "操作员";
parameters[6].Value = InstanceForm.BCurrentUser.Name;
parameters[7].Text = "收费员"; //Add By zp 2014-02-10 新增收费员
parameters[7].Value = SfyName;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_门诊收入项目及支付项日报表.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_pos_Click(object sender, EventArgs e)
{
try
{
DataTable tbmx = dset.Tables[0];
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
int x = 0;
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = x + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
//}
}
Dset.收费项目.Rows.Add(myrow);
x = 0;
for (int nrow = 0; nrow <= tbmx.Rows.Count - 2; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
//}
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[6];
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 = cmbjgbm.Text;
bool bprint = chkprint.Checked == true ? false : true;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_预交款收款明细表.rpt", parameters, bprint);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void Print()
{
try
{
DataTable dt = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= dt.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = dt.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= dt.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= dt.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = dt.Rows[nrow][dt.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[13];
parameters[0].Text = "黑白B超";
parameters[0].Value = GetNumColOfItem(dt, "黑白B超");
parameters[1].Text = "彩超";
parameters[1].Value = GetNumColOfItem(dt, "黑白B超");
parameters[2].Text = "心电图";
parameters[2].Value = GetNumColOfItem(dt, "心电图");
parameters[3].Text = "脑血流图";
parameters[3].Value = GetNumColOfItem(dt, "脑血流图");
parameters[4].Text = "胃镜";
parameters[4].Value = GetNumColOfItem(dt, "胃镜");
parameters[5].Text = "肠镜";
parameters[5].Value = GetNumColOfItem(dt, "肠镜");
parameters[6].Text = "肝肾功能";
parameters[6].Value = GetNumColOfItem(dt, "肝肾功能");
parameters[7].Text = "三大常规";
parameters[7].Value = GetNumColOfItem(dt, "三大常规");
parameters[8].Text = "用血量";
parameters[8].Value = GetNumColOfItem(dt, "用血量");
parameters[9].Text = "血气分析";
parameters[9].Value = GetNumColOfItem(dt, "血气分析");
parameters[10].Text = "切片";
parameters[10].Value = GetNumColOfItem(dt, "切片");
parameters[11].Text = "涂片";
parameters[11].Value = GetNumColOfItem(dt, "涂片");
parameters[12].Text = "动态心电图";
parameters[12].Value = GetNumColOfItem(dt, "动态心电图");
TrasenFrame.Forms.FrmReportView f = null;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\医技项目人次统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
