private void butprint_Click(object sender, System.EventArgs e) { try { string yplx = cmbyplx.Text.Trim(); string rq1 = dtp1.Value.ToShortDateString(); string rq2 = dtp2.Value.ToShortDateString(); string pmlx = this.rdosl.Checked == true?this.rdosl.Text:this.rdoje.Text; string pmws = txtnum.Text.Trim(); DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.进出货排名统计.NewRow(); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["排名"]); myrow["ypspm"] = Convert.ToString(tb.Rows[i]["品名"]); myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["pfj"] = Convert.ToDecimal(tb.Rows[i]["批发价"]); myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["零售价"]); myrow["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["pfje"] = Convert.ToString(tb.Rows[i]["批发金额"]); myrow["lsje"] = Convert.ToString(tb.Rows[i]["零售金额"]); myrow["plce"] = Convert.ToDecimal(tb.Rows[i]["零售金额"]) - Convert.ToDecimal(tb.Rows[i]["批发金额"]); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); Dset.进出货排名统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[6]; parameters[0].Text = "yplx"; parameters[0].Value = yplx.Trim(); parameters[1].Text = "rq1"; parameters[1].Value = rq1.Trim(); parameters[2].Text = "rq2"; parameters[2].Value = rq2.Trim(); parameters[3].Text = "pmlx"; parameters[3].Value = pmlx.Trim(); parameters[4].Text = "pmws"; parameters[4].Value = pmws.Trim(); parameters[5].Text = "TITLETEXT"; parameters[5].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + this.Text; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.进出货排名统计, Constant.ApplicationDirectory + "\\Report\\YF_进货排名统计.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
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, System.EventArgs e) { try { string where1 = ""; if (rdo1.Checked == true) { where1 = "按日期统计 日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); } else { where1 = "按会计月份统计 日期:" + this.statusBar1.Panels[2].Text; } DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.收费发药处方统计.NewRow(); int ii = 0; ii = ii + 1; myrow["xh"] = ii.ToString(); myrow["rq"] = Convert.ToString(tb.Rows[i]["日期"]); myrow["sfzs"] = Convert.ToInt64(tb.Rows[i]["收费张数"]); myrow["sfje"] = Convert.ToDecimal(tb.Rows[i]["收费金额"]); myrow["brfyzs"] = Convert.ToInt64(tb.Rows[i]["本日发药张数"]); myrow["brfyje"] = Convert.ToDecimal(tb.Rows[i]["本日发药金额"]); myrow["wrfyzs"] = Convert.ToInt64(tb.Rows[i]["往日发药张数"]); myrow["wrfyje"] = Convert.ToDecimal(tb.Rows[i]["往日发药金额"]); myrow["wfyzs"] = Convert.ToInt64(tb.Rows[i]["未发药张数"]); myrow["wfyje"] = Convert.ToDecimal(tb.Rows[i]["未发药金额"]); Dset.收费发药处方统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[3]; parameters[0].Text = "where1"; parameters[0].Value = where1.Trim(); parameters[1].Text = "where2"; parameters[1].Value = ""; parameters[2].Text = "title"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "收费发药统计"; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.收费发药处方统计, Constant.ApplicationDirectory + "\\Report\\YF_收费发药处方统计.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
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 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_Click(object sender, System.EventArgs e) { try { string where1 = ""; if (rdo1.Checked == true) { where1 = "按日期统计 日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); } else { where1 = "按会计月份统计 日期:" + this.statusBar1.Panels[3].Text; } DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; int ii = 0; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.单据汇总统计.NewRow(); myrow["xh"] = Convert.ToString(tb.Rows[i]["序号"]); myrow["rckfs"] = Convert.ToString(tb.Rows[i]["出库方式"]); myrow["wldw"] = Convert.ToString(tb.Rows[i]["往来单位"]); myrow["jhje"] = Convert.ToDecimal(tb.Rows[i]["进货金额"]); myrow["pfje"] = Convert.ToDecimal(tb.Rows[i]["批发金额"]); myrow["lsje"] = Convert.ToDecimal(tb.Rows[i]["零售金额"]); myrow["jlce"] = Convert.ToDecimal(tb.Rows[i]["进零差额"]); myrow["plce"] = Convert.ToDecimal(tb.Rows[i]["批零差额"]); myrow["djzs"] = Convert.ToDecimal(tb.Rows[i]["单据张数"]); Dset.单据汇总统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[3]; parameters[0].Text = "where1"; parameters[0].Value = where1.Trim(); parameters[1].Text = "where2"; parameters[1].Value = ""; parameters[2].Text = "title"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + "出库汇总表"; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.单据汇总统计, Constant.ApplicationDirectory + "\\Report\\YP_出库汇总报表.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprint_Click(object sender, System.EventArgs e) { try { string where1 = ""; if (cmbck.Visible == true) { where1 = "仓库名称:" + cmbck.Text.Trim() + " "; } where1 = where1 + "日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); where1 = where1 + " 药品类型:" + cmbyplx.Text; string title = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")"; title = title + cmbypsx.Text + "统计"; DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.贵重药品统计.NewRow(); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); myrow["yppm"] = Convert.ToString(tb.Rows[i]["品名"]); myrow["ypspm"] = Convert.ToString(tb.Rows[i]["商品名"]); myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["lsj"] = Convert.ToString(tb.Rows[i]["零售价"]); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["rksl"] = Convert.ToDecimal(tb.Rows[i]["入库数"]); myrow["cksl"] = Convert.ToString(tb.Rows[i]["出库数"]); myrow["kcsl"] = Convert.ToDecimal(tb.Rows[i]["库存数"]); Dset.贵重药品统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[3]; parameters[0].Text = "where1"; parameters[0].Value = where1.Trim(); parameters[1].Text = "where2"; parameters[1].Value = ""; parameters[2].Text = "title"; parameters[2].Value = title.Trim(); TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.贵重药品统计, Constant.ApplicationDirectory + "\\Report\\YP_贵重药统计.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprint_Click(object sender, System.EventArgs e) { try { string where1 = ""; if (rdo1.Checked == true) { where1 = "按日期统计 日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); } else { where1 = "按会计月份统计 日期:" + this.statusBar1.Panels[2].Text; } DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.处方统计.NewRow(); myrow["xmmc"] = Convert.ToString(tb.Rows[i]["项目名称"]); myrow["cfzs"] = Convert.ToInt64(tb.Rows[i]["处方张数"]); myrow["cfje"] = Convert.ToDecimal(tb.Rows[i]["药品金额"]); myrow["tyzs"] = Convert.ToInt64(tb.Rows[i]["退药张数"]); myrow["tyje"] = Convert.ToDecimal(tb.Rows[i]["退药金额"]); myrow["sumcfzs"] = Convert.ToInt64(tb.Rows[i]["合计张数"]); myrow["sumcfje"] = Convert.ToDecimal(tb.Rows[i]["合计金额"]); Dset.处方统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[3]; parameters[0].Text = "where1"; parameters[0].Value = where1.Trim(); parameters[1].Text = "where2"; parameters[1].Value = ""; parameters[2].Text = "title"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + "药品销售收入(处方)报表"; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.处方统计, Constant.ApplicationDirectory + "\\Report\\YF_处方统计.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprint_Click(object sender, System.EventArgs e) { try { string yplx = chkyplx.Checked == true?Convertor.IsNull(cmbyplx.Text, "全部") : "全部"; string ypzlx = chkypzlx.Checked == true?Convertor.IsNull(cmbypzlx.Text, "全部") : "全部"; string ypjx = chkjx.Checked == true?Convertor.IsNull(cmbjx.Text, "全部") : "全部"; DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.库存情况表.NewRow(); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); myrow["ypspm"] = Convert.ToString(tb.Rows[i]["品名"]); myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["pfj"] = Convert.ToString(tb.Rows[i]["批发价"]); myrow["lsj"] = Convert.ToString(tb.Rows[i]["零售价"]); myrow["kcl"] = Convert.ToString(tb.Rows[i]["总库存"]); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["pfje"] = Convert.ToString(tb.Rows[i]["批发金额"]); myrow["lsje"] = Convert.ToString(tb.Rows[i]["零售金额"]); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); Dset.库存情况表.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[4]; parameters[0].Text = "yplx"; parameters[0].Value = yplx.Trim(); parameters[1].Text = "ypzlx"; parameters[1].Value = ypzlx.Trim(); parameters[2].Text = "ypjx"; parameters[2].Value = ypjx.Trim(); parameters[3].Text = "TITLETEXT"; parameters[3].Value = TrasenFrame.Classes.Constant.HospitalName + "全院药品库存情况"; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.库存情况表, Constant.ApplicationDirectory + "\\Report\\YK_库存情况表.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
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 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 butprint_Click(object sender, System.EventArgs e) { try { string swhere = "药房:" + cmbks.Text.Trim() + " 日期:" + dtp1.Value.ToShortDateString() + " 到 " + dtp2.Value.ToShortDateString(); DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.药库调库单.NewRow(); myrow["lyyf"] = Convert.ToString(tb.Rows[i]["领药药房"]); myrow["djh"] = Convert.ToInt64(tb.Rows[i]["单据号"]); myrow["yppm"] = Convert.ToString(tb.Rows[i]["药品名称"]); myrow["ypspm"] = Convert.ToString(tb.Rows[i]["商品名"]); myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["jj"] = Convert.ToDecimal(tb.Rows[i]["进价"]); myrow["jhje"] = Convert.ToDecimal(tb.Rows[i]["进货金额"]); myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["零售价"]); myrow["lsje"] = Convert.ToDecimal(tb.Rows[i]["零售金额"]); myrow["jlce"] = Convert.ToDecimal(tb.Rows[i]["零售金额"]) - Convert.ToDecimal(tb.Rows[i]["进货金额"]); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); Dset.药库调库单.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[2]; parameters[0].Text = "swhere"; parameters[0].Value = swhere.Trim(); parameters[1].Text = "TITLETEXT"; parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + this.Text; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药库调库单, Constant.ApplicationDirectory + "\\Report\\YK_药品调拨调库单.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprintmx_Click(object sender, System.EventArgs e) { try { DataTable tb = (DataTable)this.myDataGrid2.DataSource; ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.药理分类统计明细.NewRow(); myrow["pm"] = Convert.ToString(tb.Rows[i]["品名"]); myrow["gg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["cj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["lsj"] = Convert.ToString(tb.Rows[i]["零售价"]); myrow["sl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["数量"], "0")); myrow["dw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["je"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["金额"], "0")); myrow["bfbl"] = Convert.ToString(tb.Rows[i]["百分比"]); Dset.药理分类统计明细.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[4]; parameters[0].Text = "swhere"; parameters[0].Value = "药剂科室:" + cmbyjks.Text.Trim() + " 日期从:" + dtp1.Value.ToShortDateString() + " 到 " + dtp2.Value.ToShortDateString(); parameters[1].Text = "swhere1"; parameters[1].Value = this.myDataGrid1.CaptionText; parameters[2].Text = "title"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + this.Text; parameters[3].Text = "username"; parameters[3].Value = InstanceForm.BCurrentUser.Name; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药理分类统计明细, Constant.ApplicationDirectory + "\\Report\\YK_药理分类统计(明细).rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprint_Click(object sender, System.EventArgs e) { try { DataTable tb = (DataTable)this.myDataGrid1.DataSource; // Xc_Yf_ReportView.配发药工作量统计 rpt=new Xc_Yf_ReportView.配发药工作量统计(); ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); // rpt.SetParameterValue("rq1",dtp1.Value.ToShortDateString()); // rpt.SetParameterValue("rq2",dtp2.Value.ToShortDateString()); // rpt.SetParameterValue("TITLETEXT",this.Text); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.发药配药工作量统计.NewRow(); myrow["tjr"] = Convert.ToString(tb.Rows[i]["姓名"]); myrow["fys"] = Convert.ToInt64(tb.Rows[i]["发药数"]); myrow["pys"] = Convert.ToInt64(tb.Rows[i]["配药数"]); myrow["phs"] = Convert.ToInt64(tb.Rows[i]["配核数"]); Dset.发药配药工作量统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[3]; parameters[0].Text = "rq1"; parameters[0].Value = dtp1.Value.ToShortDateString(); parameters[1].Text = "rq2"; parameters[1].Value = dtp2.Value.ToShortDateString(); parameters[2].Text = "TITLETEXT"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + this.Text; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.发药配药工作量统计, Constant.ApplicationDirectory + "\\Report\\YF_配发药工作量统计_JCHL.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void 打印ToolStripMenuItem_Click(object sender, EventArgs e) { DataGridViewRow currentRow = dataGridView1.CurrentRow; if (currentRow == null) { return; } ParameterEx[] paramters = new ParameterEx[11]; paramters[0].Text = "医院名称"; paramters[0].Value = Constant.HospitalName; paramters[1].Text = "门诊号"; paramters[1].Value = Convertor.IsNull(currentRow.Cells["clMzh"].Value, ""); paramters[2].Text = "姓名"; paramters[2].Value = Convertor.IsNull(currentRow.Cells["姓名"].Value, ""); paramters[3].Text = "临时诊断"; paramters[3].Value = Convertor.IsNull(currentRow.Cells["门诊诊断"].Value, ""); paramters[4].Text = "申请科室"; paramters[4].Value = Convertor.IsNull(currentRow.Cells["clDjDept"].Value, ""); paramters[5].Text = "申请医师"; paramters[5].Value = Convertor.IsNull(currentRow.Cells["clDjy"].Value, ""); paramters[6].Text = "申请时间"; paramters[6].Value = Convertor.IsNull(currentRow.Cells["clDjsj"].Value, ""); paramters[7].Text = "护士注意事项"; paramters[7].Value = Convertor.IsNull(currentRow.Cells["备注"].Value, ""); paramters[8].Text = "年龄"; paramters[8].Value = Convertor.IsNull(currentRow.Cells["年龄"].Value, ""); paramters[9].Text = "性别"; paramters[9].Value = Convertor.IsNull(currentRow.Cells["性别"].Value, ""); paramters[10].Text = "入院科室"; paramters[10].Value = Convertor.IsNull(currentRow.Cells["入院科室"].Value, ""); DataSet _dset = new DataSet(); DataTable dt = new DataTable("收费明细"); dt.Columns.Add("item_name", Type.GetType("System.String")); dt.Columns.Add("je", Type.GetType("System.String")); _dset.Tables.Add(dt); string reportFile = Constant.ApplicationDirectory + "\\Report\\MZ_住院证.rpt"; TrasenFrame.Forms.FrmReportView fView = new TrasenFrame.Forms.FrmReportView(_dset, reportFile, paramters, true); }
private void button3_Click(object sender, EventArgs e) { if (dataGridView1.DataSource == null) { return; } DataTable dt = dataGridView1.DataSource as DataTable; ts_mz_txyy.DataSet1 Dset = new ts_mz_txyy.DataSet1(); DataRow myrow; for (int i = 0; i <= dt.Rows.Count - 1; i++) { myrow = Dset.挂号室发卡量统计.NewRow(); myrow["登记员"] = Convert.ToString(dt.Rows[i]["登记员"]); myrow["发卡量"] = Convert.ToString(dt.Rows[i]["发卡量"]); Dset.挂号室发卡量统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[4]; parameters[0].Text = "yq"; parameters[0].Value = comboBox1.Text; parameters[1].Text = "kssj"; parameters[1].Value = dateTimePicker1.Value.ToString("yyyy-MM-dd") + " 00:00:00"; parameters[2].Text = "jssj"; parameters[2].Value = dateTimePicker2.Value.ToString("yyyy-MM-dd") + " 23:59:59"; parameters[3].Text = "dyr"; parameters[3].Value = InstanceForm.BCurrentUser.Name; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\挂号室发卡量统计.rpt", parameters, true); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } }
private void butprint_Click(object sender, EventArgs e) { if (dgvList.DataSource == null || ((DataTable)dgvList.DataSource).Rows.Count == 0) { MessageBox.Show("没有数据!"); return; } try { DataTable tbmx = (DataTable)dgvList.DataSource; ParameterEx[] parameters = new ParameterEx[3]; 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; TrasenFrame.Forms.FrmReportView f; f = new TrasenFrame.Forms.FrmReportView(tbmx, 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, System.EventArgs e) { string where1 = ""; // if (cmbck.Visible == true) where1 = "仓库名称:" + cmbck.Text.Trim(); if (rdo1.Checked == true) { where1 = "按日期统计 日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); } else { where1 = "按会计月份统计 日期:" + this.statusBar1.Panels[3].Text; } try { YpConfig s = new YpConfig(Convert.ToInt32(cmbyjks.SelectedValue), InstanceForm.BDatabase); DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 2; i++) { myrow = Dset.报损报溢单.NewRow(); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); if (s.打印单据时单据显示商品名 == true) { myrow["ypmc"] = Convert.ToString(tb.Rows[i]["商品名"]); } else { myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]); } myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["ypsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["数量"], "0")); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["pfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发价"], "0")); myrow["pfje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发金额"], "0")); myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售价"], "0")); myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售金额"], "0")); decimal plce = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售金额"], "0")) - Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发金额"], "0")); myrow["plce"] = plce.ToString("0.00"); myrow["jhj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进价"], "0")); myrow["jhje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进货金额"], "0")); decimal jlce = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售金额"], "0")) - Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进货金额"], "0")); myrow["jlce"] = jlce.ToString("0.00"); myrow["ypph"] = Convert.ToString(tb.Rows[i]["批号"]); myrow["ypxq"] = Convert.ToString(tb.Rows[i]["效期"]); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); myrow["kwmc"] = ""; //Convert.ToString(tb.Rows[i]["库位"]); Dset.报损报溢单.Rows.Add(myrow); } string title = _menuTag.Function_Name.Trim() == "Fun_ts_yk_tjbb_bshz" ? "药品报损汇总统计" : "药品报溢汇总统计"; ParameterEx[] parameters = new ParameterEx[9]; parameters[0].Text = "DJH"; parameters[0].Value = ""; //this.lbldjh.Text; parameters[1].Text = "DJY"; parameters[1].Value = InstanceForm.BCurrentUser.Name; parameters[2].Text = "BSBYYY"; parameters[2].Value = ""; //txtyy.Text.Trim(); parameters[3].Text = "RQ"; parameters[3].Value = ""; //dtprq.Value.ToShortDateString(); parameters[4].Text = "TITLETEXT"; parameters[4].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + title.Trim(); parameters[5].Text = "BZ"; parameters[5].Value = ""; //txtbz.Text.Trim(); parameters[6].Text = "ybps"; parameters[6].Value = ""; parameters[7].Text = "swhere"; parameters[7].Value = where1.Trim(); parameters[8].Text = "ckmc"; parameters[8].Value = cmbck.Text; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.报损报溢单, Constant.ApplicationDirectory + "\\Report\\YK_药品报损报溢单.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprinthz_Click(object sender, EventArgs e) { try { DataTable tb = (DataTable)this.myDataGrid2.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); if (tb.Rows.Count == 0) { return; } DataTable tbmx = (DataTable)this.myDataGrid1.DataSource; DataRow[] rows; rows = tbmx.Select("ypsl<>0"); if (rows.Length == 0 && new SystemCfg(8041).Config == "1") { MessageBox.Show("没有要打印的已发药处方", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } butprinthz.Enabled = false; //string lydw=Yp.SeekWardName(tb.Rows[0]["wardid"].ToString().Trim()); //string fyr=Yp.SeekEmpName(Convert.ToInt32(tb.Rows[0]["fyr"])); //string pyr=Yp.SeekEmpName(Convert.ToInt32(tb.Rows[0]["pyr"])); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { if (tb.Rows[i]["品名"].ToString().Trim().Equals("总金额")) { continue; } myrow = Dset.发药明细单.NewRow(); myrow["yppm"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["品名"]), ""); myrow["ypspm"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["商品名"]), ""); myrow["ypgg"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["规格"]), ""); myrow["sccj"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["厂家"]), ""); myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["单价"], "0")); myrow["ypsl"] = Convertor.IsNull(tb.Rows[i]["领药数"], ""); myrow["ypdw"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["单位"]), ""); myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["金额"], "0")); myrow["shh"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["货号"]), ""); myrow["tlfl"] = ""; myrow["fyrq"] = ""; myrow["fyr"] = ""; myrow["pyr"] = ""; myrow["lydw"] = ""; myrow["bz"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["药库单位"]), ""); Dset.发药明细单.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[2]; parameters[0].Text = "title"; parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")代煎处方汇总单"; parameters[1].Text = "lydwHeadText"; parameters[1].Value = ""; bool bview = this.chkprintview.Checked == true ? false : true; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方汇总单.rpt", parameters, bview); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } butprinthz.Enabled = true; } catch (System.Exception err) { butprinthz.Enabled = true; MessageBox.Show(err.Message); } }
public static void PrintCf(string inpatient_id, string mngtype, string groupid, RelationalDatabase _DataBase) { DataTable tb = null; string ssql = "select top 1 presc_no,execdept_id,cz_flag from zy_orderrecord a,zy_fee_speci b " + " where a.inpatient_id=b.inpatient_id and a.order_id=b.order_id and a.inpatient_id='" + inpatient_id + "' and (mngtype=" + mngtype + " or mngtype=5 ) and a.group_id=" + groupid + " and cz_flag in(0,1) order by cz_flag "; DataTable tbcx = _DataBase.GetDataTable(ssql, 30); decimal cfh = 0; int zxks = 0; int cz_flag = 0; if (tbcx.Rows.Count > 0) { cfh = Convert.ToDecimal(tbcx.Rows[0]["presc_no"].ToString()); zxks = Convert.ToInt32(tbcx.Rows[0]["execdept_id"].ToString()); cz_flag = Convert.ToInt32(tbcx.Rows[0]["cz_flag"].ToString()); if (cz_flag == 1) { MessageBox.Show("该处方已冲正,不能打印", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { MessageBox.Show("请确认处方已执行", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (cfh == 0) { return; } tb = ZY_FY.SelectCF("0", new Guid(inpatient_id), "", "", "", "", "", "", "0", 0, 0, 0, cfh, _DataBase, 2); if (tb.Rows.Count == 0) { tb = ZY_FY.SelectCF("0", new Guid(inpatient_id), "", "", "", "", "", "", "1", 0, 0, 0, cfh, _DataBase, 2); } if (new SystemCfg(8021).Config == "0") { #region 区分中药 try { if (tb.Rows.Count == 0) { return; } DataRow[] rows; rows = tb.Select("ypsl<>0"); ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= rows.Length - 1; i++) { myrow = Dset.发药明细单.NewRow(); myrow["rowno"] = Convert.ToString(rows[i]["序号"]); myrow["yppm"] = Convert.ToString(rows[i]["品名"]); myrow["ypspm"] = Convert.ToString(rows[i]["商品名"]); myrow["ypgg"] = Convert.ToString(rows[i]["规格"]); myrow["sccj"] = Convert.ToString(rows[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(rows[i]["单价"]); myrow["ypsl"] = Convert.ToDecimal(rows[i]["数量"]); if (Convert.ToDecimal(rows[i]["剂数"]) > 1 || Convert.ToString(rows[i]["STATITEM_CODE"]).Substring(0, 2) == "03") { myrow["cfts"] = "剂数:" + rows[i]["剂数"].ToString() + " 剂 " + rows[i]["煎药"].ToString(); } myrow["ypdw"] = Convert.ToString(rows[i]["单位"]); myrow["lsje"] = Convert.ToDecimal(rows[i]["金额"]); myrow["shh"] = Convert.ToString(rows[i]["货号"]); myrow["bed_no"] = Convert.ToString(rows[i]["床号"]); myrow["name"] = Convert.ToString(rows[i]["姓名"]).Trim() + " 处方日期:" + Convert.ToString(rows[i]["处方日期"]).Trim(); myrow["inpatient_no"] = Convert.ToString(rows[i]["住院号"]); myrow["lydw"] = Convert.ToString(rows[i]["发药科室"]) + " 医生:" + Convert.ToString(rows[i]["医生"]); myrow["ksname"] = Yp.SeekDeptName(Convert.ToInt32(rows[i]["dept_id"]), _DataBase); myrow["presc_no"] = rows[i]["处方号"].ToString().Trim(); myrow["order_usage"] = rows[i]["用法"].ToString().Trim() + " " + rows[i]["频次"].ToString().Trim(); myrow["xb"] = Convert.ToString(rows[i]["性别"]); myrow["nl"] = Convert.ToString(rows[i]["年龄"]); myrow["JTDZ"] = ""; myrow["LXDH"] = ""; myrow["SFZH"] = ""; myrow["bz1"] = Convert.ToString(rows[i]["诊断"]); myrow["bz2"] = Convert.ToString(rows[i]["中医诊断"]); myrow["bz3"] = Convert.ToString(rows[i]["中医症型"]); Dset.发药明细单.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[2]; parameters[0].Text = "titletext"; string ss = ""; //if (chkcydy.Checked == false) ss = "住院处方清单"; // else // ss = "出院带药清单"; parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + Yp.SeekDeptName(zxks, _DataBase) + ")" + ss.Trim(); parameters[1].Text = "BZ"; parameters[1].Value = ""; bool bview = false; TrasenFrame.Forms.FrmReportView f; f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方清单医生站用.rpt", parameters, bview); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion } else { try { DataRow[] rows; rows = tb.Select(" ypsl<>0"); DataRow[] rows_xy = null; DataRow[] rows_zy = null; rows_xy = tb.Select(" STATITEM_CODE not like '%03%' "); rows_zy = tb.Select(" STATITEM_CODE like '%03%' "); ts_Yk_ReportView.Dataset2 Dset; DataRow myrow; if (rows_xy.Length > 0) { Dset = new ts_Yk_ReportView.Dataset2(); for (int i = 0; i <= rows_xy.Length - 1; i++) { myrow = Dset.发药明细单.NewRow(); myrow["rowno"] = Convert.ToString(rows_xy[i]["序号"]); myrow["yppm"] = Convert.ToString(rows_xy[i]["品名"]); myrow["ypspm"] = Convert.ToString(rows_xy[i]["商品名"]); myrow["ypgg"] = Convert.ToString(rows_xy[i]["规格"]); myrow["sccj"] = Convert.ToString(rows_xy[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(rows_xy[i]["单价"]); myrow["ypsl"] = Convert.ToDecimal(rows_xy[i]["数量"]); if (Convert.ToDecimal(rows_xy[i]["剂数"]) > 1 || Convert.ToString(rows_xy[i]["STATITEM_CODE"]).Substring(0, 2) == "03") { myrow["cfts"] = "剂数:" + rows_xy[i]["剂数"].ToString() + " 剂 " + rows_xy[i]["煎药"].ToString(); } myrow["ypdw"] = Convert.ToString(rows_xy[i]["单位"]); myrow["lsje"] = Convert.ToDecimal(rows_xy[i]["金额"]); myrow["shh"] = Convert.ToString(rows_xy[i]["货号"]); myrow["bed_no"] = Convert.ToString(rows_xy[i]["床号"]); myrow["name"] = Convert.ToString(rows_xy[i]["姓名"]).Trim() + " 处方日期:" + Convert.ToString(rows_xy[i]["处方日期"]).Trim(); myrow["inpatient_no"] = Convert.ToString(rows_xy[i]["住院号"]); myrow["lydw"] = Convert.ToString(rows_xy[i]["发药科室"]) + " 医生:" + Convert.ToString(rows_xy[i]["医生"]); myrow["ksname"] = Yp.SeekDeptName(Convert.ToInt32(rows_xy[i]["dept_id"]), _DataBase); myrow["presc_no"] = rows_xy[i]["处方号"].ToString().Trim(); myrow["order_usage"] = rows_xy[i]["用法"].ToString().Trim() + " " + rows_xy[i]["频次"].ToString().Trim(); myrow["xb"] = Convert.ToString(rows_xy[i]["性别"]); myrow["nl"] = Convert.ToString(rows_xy[i]["年龄"]); myrow["JTDZ"] = ""; myrow["LXDH"] = ""; myrow["SFZH"] = ""; myrow["bz1"] = Convert.ToString(rows_xy[i]["诊断"]); myrow["bz2"] = Convert.ToString(rows_xy[i]["中医诊断"]); myrow["bz3"] = Convert.ToString(rows_xy[i]["中医症型"]); Dset.发药明细单.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[2]; parameters[0].Text = "titletext"; string ss = ""; //if (chkcydy.Checked == false) ss = "住院处方清单"; //else // ss = "出院带药清单"; parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + Yp.SeekDeptName(zxks, _DataBase) + ")" + ss.Trim(); parameters[1].Text = "BZ"; parameters[1].Value = ""; bool bview = false; TrasenFrame.Forms.FrmReportView f; f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方清单医生站用.rpt", parameters, bview); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } if (rows_zy.Length > 0) { Dset = new ts_Yk_ReportView.Dataset2(); for (int i = 0; i <= rows_zy.Length - 1; i++) { myrow = Dset.发药明细单.NewRow(); myrow["rowno"] = Convert.ToString(rows_zy[i]["序号"]); myrow["yppm"] = Convert.ToString(rows_zy[i]["品名"]); myrow["ypspm"] = Convert.ToString(rows_zy[i]["商品名"]); myrow["ypgg"] = Convert.ToString(rows_zy[i]["规格"]); myrow["sccj"] = Convert.ToString(rows_zy[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(rows_zy[i]["单价"]); myrow["ypsl"] = Convert.ToDecimal(rows_zy[i]["数量"]); if (Convert.ToDecimal(rows_zy[i]["剂数"]) > 1 || Convert.ToString(rows_zy[i]["STATITEM_CODE"]).Substring(0, 2) == "03") { myrow["cfts"] = "剂数:" + rows_zy[i]["剂数"].ToString() + " 剂 " + rows_zy[i]["煎药"].ToString(); } myrow["ypdw"] = Convert.ToString(rows_zy[i]["单位"]); myrow["lsje"] = Convert.ToDecimal(rows_zy[i]["金额"]); myrow["shh"] = Convert.ToString(rows_zy[i]["货号"]); myrow["bed_no"] = Convert.ToString(rows_zy[i]["床号"]); myrow["name"] = Convert.ToString(rows_zy[i]["姓名"]).Trim() + " 处方日期:" + Convert.ToString(rows_zy[i]["处方日期"]).Trim(); myrow["inpatient_no"] = Convert.ToString(rows_zy[i]["住院号"]); myrow["lydw"] = Convert.ToString(rows_zy[i]["发药科室"]) + " 医生:" + Convert.ToString(rows_zy[i]["医生"]); myrow["ksname"] = Yp.SeekDeptName(Convert.ToInt32(rows_zy[i]["dept_id"]), _DataBase); myrow["presc_no"] = rows_zy[i]["处方号"].ToString().Trim(); myrow["order_usage"] = rows_zy[i]["用法"].ToString().Trim() + " " + rows_zy[i]["频次"].ToString().Trim(); myrow["xb"] = Convert.ToString(rows_zy[i]["性别"]); myrow["nl"] = Convert.ToString(rows_zy[i]["年龄"]); myrow["JTDZ"] = ""; myrow["LXDH"] = ""; myrow["SFZH"] = ""; myrow["bz1"] = Convert.ToString(rows_zy[i]["诊断"]); myrow["bz2"] = Convert.ToString(rows_zy[i]["中医诊断"]); myrow["bz3"] = Convert.ToString(rows_zy[i]["中医症型"]); Dset.发药明细单.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[2]; parameters[0].Text = "titletext"; string ss = ""; //if (chkcydy.Checked == false) ss = "住院处方清单"; //else // ss = "出院带药清单"; parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + Yp.SeekDeptName(zxks, _DataBase) + ")" + ss.Trim(); parameters[1].Text = "BZ"; parameters[1].Value = ""; bool bview = false; TrasenFrame.Forms.FrmReportView f; f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方清单(中药)医生站用.rpt", parameters, bview); 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, System.EventArgs e) { try { string title = ""; string where1 = ""; if (rdo1.Checked == true) { title = "门诊医生用药情况统计"; } else { title = "住院医生用药情况统计"; } where1 = "日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); DataView dv = (DataView)this.myDataGrid1.DataSource; //DataTable tb=(DataTable)this.myDataGrid1.DataSource; DataTable tb = dv.Table; ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.医生用药情况统计.NewRow(); myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]); myrow["ypspm"] = Convert.ToString(tb.Rows[i]["商品名"]); myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["单价"]); myrow["ksmc"] = Convert.ToString(tb.Rows[i]["科室"]); myrow["ysmc"] = Convert.ToString(tb.Rows[i]["医生"]); myrow["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["lsje"] = Convert.ToDecimal(tb.Rows[i]["金额"]); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); Dset.医生用药情况统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[2]; parameters[0].Text = "swhere"; parameters[0].Value = where1.Trim(); parameters[1].Text = "title"; parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + title.Trim(); TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.医生用药情况统计, Constant.ApplicationDirectory + "\\Report\\YF_医生用药情况统计.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprint_Click(object sender, System.EventArgs e) { try { string where1 = "日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); if (rdosl.Checked == true && Convert.ToInt32(Convertor.IsNull(txtdm.Tag, "0")) != 0) { where1 = where1 + " 药品名称:" + txtdm.Text.Trim(); } DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.药品汇总统计.NewRow(); if (this.rdoje.Checked == true) { myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); myrow["wardname"] = Convert.ToString(tb.Rows[i]["病区"]); myrow["DJZS"] = Convert.ToDecimal(tb.Rows[i]["单据张数"]); myrow["djje"] = Convert.ToDecimal(tb.Rows[i]["金额"]); } else { myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); myrow["wardname"] = Convert.ToString(tb.Rows[i]["病区"]); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); myrow["yppm"] = Convert.ToString(tb.Rows[i]["品名"]); myrow["ypspm"] = Convert.ToString(tb.Rows[i]["商品名"]); myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["lsje"] = Convert.ToDecimal(tb.Rows[i]["金额"]); } Dset.药品汇总统计.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[3]; parameters[0].Text = "where1"; parameters[0].Value = where1.Trim(); parameters[1].Text = "where2"; parameters[1].Value = ""; parameters[2].Text = "title"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + "借药汇总统计"; if (rdoje.Checked == true) { TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品汇总统计, Constant.ApplicationDirectory + "\\Report\\YF_药品领药按单据汇总统计.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } else { TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品汇总统计, Constant.ApplicationDirectory + "\\Report\\YF_药品领药按药品汇总统计.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprint_Click(object sender, System.EventArgs e) { try { string where1 = ""; if (rdo1.Checked == true) { where1 = "按日期统计 日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); } else { where1 = "按会计月份统计 日期:" + this.statusBar1.Panels[3].Text; } // if (chkyplx.Checked==true) bz=bz+" 药品类型 "+cmbyplx.Text; // if (chkypmc.Checked==true) bz=bz+" 药品名称 "+txtypmc.Text; DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 2; i++) { myrow = Dset.药品调价单.NewRow(); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); if (s.打印单据时单据显示商品名 == true) { myrow["ypmc"] = Convert.ToString(tb.Rows[i]["商品名"]); } else { myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]); } myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["ypsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调价数量"], "0")); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["ypfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["原批发价"], "0")); myrow["xpfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调批发价"], "0")); decimal pfjdwcj = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调批发价"], "0")) - Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["原批发价"], "0")); decimal tpfje = pfjdwcj * (Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调价数量"], "0"))); myrow["pfjdwcj"] = pfjdwcj.ToString("0.00"); myrow["tpfje"] = tpfje.ToString("0.00"); myrow["ylsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["原零售价"], "0")); myrow["xlsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调零售价"], "0")); myrow["lsjdwcj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["单位差价"], "0")); myrow["tlsje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调零售金额"], "0")); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); myrow["tjwh"] = Convert.ToString(tb.Rows[i]["调价文号"]); myrow["zxrq"] = Convert.ToString(tb.Rows[i]["调价日期"]); myrow["ckmc"] = Convert.ToString(tb.Rows[i]["仓库名称"]); Dset.药品调价单.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[8]; parameters[0].Text = "DJH"; parameters[0].Value = "0"; parameters[1].Text = "DJY"; parameters[1].Value = InstanceForm.BCurrentUser.Name; parameters[2].Text = "RQ"; parameters[2].Value = ""; parameters[3].Text = "TJWH"; parameters[3].Value = ""; parameters[4].Text = "TITLETEXT"; parameters[4].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + "药房调价单"; parameters[5].Text = "BZ"; parameters[5].Value = ""; parameters[6].Text = "swhere"; parameters[6].Value = where1; parameters[7].Text = "DJY"; parameters[7].Value = InstanceForm.BCurrentUser.Name; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品调价单, Constant.ApplicationDirectory + "\\Report\\YF_药品调价单据.rpt", parameters); 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 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 || ((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 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 butprint_Click(object sender, System.EventArgs e) { try { string tjlb = rdo1.Checked == true?rdo1.Text.Trim() : rdo2.Text.Trim(); string kcsxxheadertext = rdo1.Checked == true?"下限":"上限"; string bjczheadertext = rdo1.Checked == true?"低于下限":"高于上限"; DataTable tb = (DataTable)this.myDataGrid1.DataSource; // ts_Yk_ReportView.药品高低储报警 rpt=new ts_Yk_ReportView.药品高低储报警(); ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; for (int i = 0; i <= tb.Rows.Count - 1; i++) { myrow = Dset.药品高低储报警.NewRow(); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); myrow["ypspm"] = Convert.ToString(tb.Rows[i]["品名"]); myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["pfj"] = Convert.ToDecimal(tb.Rows[i]["批发价"]); myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["零售价"]); if (rdo1.Checked == true) { myrow["kcsxx"] = Convert.ToDecimal(tb.Rows[i]["下限"]); } else { myrow["kcsxx"] = Convert.ToDecimal(tb.Rows[i]["上限"]); } myrow["kcl"] = Convert.ToDecimal(tb.Rows[i]["库存量"]); if (rdo1.Checked == true) { myrow["gdc"] = Convert.ToDecimal(tb.Rows[i]["低于下限"]); } else { myrow["gdc"] = Convert.ToDecimal(tb.Rows[i]["高于上限"]); } myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); Dset.药品高低储报警.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[5]; parameters[0].Text = "yplx"; parameters[0].Value = cmbyplx.Text; parameters[1].Text = "tjlb"; parameters[1].Value = tjlb; parameters[2].Text = "kcsxxheadertext"; parameters[2].Value = kcsxxheadertext.Trim(); parameters[3].Text = "bjczheadertext"; parameters[3].Value = bjczheadertext.Trim(); parameters[4].Text = "TITLETEXT"; parameters[4].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + this.Text; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品高低储报警, Constant.ApplicationDirectory + "\\Report\\YF_药品高低储报警.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } }
private void butprint_Click(object sender, System.EventArgs e) { string where1 = ""; if (rdo1.Checked == true) { where1 = where1 + "按日期统计 日期:" + dtp1.Value.ToShortDateString(); where1 = where1 + " 到:" + dtp2.Value.ToShortDateString(); } else { where1 = where1 + "按会计月份统计 日期:" + this.statusBar1.Panels[3].Text; } try { YpConfig ss = new YpConfig(Convert.ToInt32(cmbyjks.SelectedValue), InstanceForm.BDatabase); this.Cursor = PubStaticFun.WaitCursor(); DataTable tb = (DataTable)this.myDataGrid1.DataSource; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow; decimal pcjhje = 0; decimal ykjhje = 0; for (int i = 0; i <= tb.Rows.Count - 2; i++) { myrow = Dset.药品盘点单.NewRow(); myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]); if (ss.打印单据时单据显示商品名 == true) { myrow["ypmc"] = Convert.ToString(tb.Rows[i]["商品名"]); } else { myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]); } myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]); myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]); myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]); myrow["pfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发价"], "0")); myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售价"], "0")); myrow["zcsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["帐存数量"], "0")); myrow["zcje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["帐存金额"], "0")); myrow["pcsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盘存数量"], "0")); myrow["pcje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盘存金额"], "0")); myrow["yksl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盈亏数量"], "0")); myrow["ykje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盈亏金额"], "0")); myrow["jhj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进价"], "0")); pcjhje = pcjhje + Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进价"], "0")) * Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盘存数量"], "0")); ykjhje = ykjhje + Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进货金额盈亏"], "0")); myrow["ypph"] = Convert.ToString(tb.Rows[i]["批号"]); myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]); myrow["kwmc"] = ""; //Convert.ToString(tb.Rows[i]["库位"]); Dset.药品盘点单.Rows.Add(myrow); } ParameterEx[] parameters = new ParameterEx[10]; parameters[0].Text = "DJH"; parameters[0].Value = ""; //this.lbldjh.Text; parameters[1].Text = "DJY"; parameters[1].Value = InstanceForm.BCurrentUser.Name; parameters[2].Text = "RQ"; parameters[2].Value = ""; //dtprq.Text.Trim(); parameters[3].Text = "TITLETEXT"; parameters[3].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + this.Text; parameters[4].Text = "BZ"; parameters[4].Value = ""; //txtbz.Text.Trim(); parameters[5].Text = "swhere"; parameters[5].Value = where1.Trim(); parameters[6].Text = "YKJHJE"; parameters[6].Value = Convert.ToDecimal(ykjhje.ToString("0.00")); parameters[7].Text = "PCJHJE"; parameters[7].Value = Convert.ToDecimal(pcjhje.ToString("0.00")); parameters[8].Text = "ckmc"; parameters[8].Value = cmbck.Text.Trim(); parameters[9].Text = "dyr"; parameters[9].Value = InstanceForm.BCurrentUser.Name; TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品盘点单, Constant.ApplicationDirectory + "\\Report\\YF_药品盘点单据.rpt", parameters); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message); } finally { this.Cursor = Cursors.Arrow; } }