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 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_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 { 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 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) { 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 PrintCf(DataRow row, int cfgs, TrasenFrame.Forms.UcReportView reportView) { DataRow[] rows; if (cfgs == 1) { rows = cfmxTable.Select(" cfxh='" + row["cfxh"] + "' "); } else { rows = cfmxTable.Select(" cfxh='" + row["cfxh"] + "' and zsyp=1 "); } if (rows.Length == 0) { return; } ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow = null; int yzzh = 0; string jtdz = ""; string grlxdh = ""; string sfzh = ""; string brxm = ""; string ssql = "select * from yy_brxx a inner join mz_cfb b on a.brxxid=b.brxxid where b.cfid='" + row["cfxh"].ToString() + "'"; DataTable tb = InstanceForm.BDatabase.GetDataTable(ssql); if (tb.Rows.Count > 0) { jtdz = Convertor.IsNull(tb.Rows[0]["jtdz"], ""); grlxdh = Convertor.IsNull(tb.Rows[0]["brlxfs"], ""); sfzh = Convertor.IsNull(tb.Rows[0]["sfzh"], ""); brxm = Convertor.IsNull(tb.Rows[0]["brxm"], ""); } for (int i = 0; i <= rows.Length - 1; i++) { #region 非中药处方格式 myrow = Dset.病人处方清单.NewRow(); myrow["xh"] = Convert.ToInt32(rows[i]["序号"]); myrow["ypmc"] = Convert.ToString(rows[i]["品名"]); myrow["ypgg"] = Convert.ToString(rows[i]["规格"]); myrow["sccj"] = Convert.ToString(rows[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["单价"], "0")); myrow["ypsl"] = Convert.ToDouble(Convertor.IsNull(rows[i]["用量"], "0")).ToString(); myrow["ypdw"] = Convert.ToString(rows[i]["单位"]); myrow["cfts"] = rows[i]["剂数"].ToString(); myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["金额"], "0")); myrow["yf"] = Convertor.IsNull(rows[i]["用法"], ""); myrow["pc"] = Convertor.IsNull(rows[i]["使用频次"], ""); myrow["syjl"] = ""; myrow["zt"] = Convertor.IsNull(rows[i]["嘱托"], ""); myrow["shh"] = Convert.ToString(rows[i]["货号"]); myrow["ksname"] = Convert.ToString(rows[i]["科室"]).Trim(); myrow["ysname"] = Convert.ToString(rows[i]["医生"]).Trim(); myrow["PSZT"] = rows[i]["皮试"].ToString(); myrow["fph"] = Convert.ToString(rows[i]["发票号"]); myrow["hzxm"] = Convert.ToString(rows[i]["姓名"]); myrow["sex"] = Convert.ToString(rows[i]["性别"]); myrow["age"] = Convert.ToString(rows[i]["年龄"]); myrow["blh"] = Convert.ToString(rows[i]["门诊号"]); myrow["sfrq"] = Convert.ToString(rows[i]["收费日期"]); //myrow["pyr"] = rows[i]["配药人"]; myrow["fyr"] = Convert.ToString(rows[i]["发药员"]) == "" ? InstanceForm.BCurrentUser.Name : Convert.ToString(rows[i]["发药员"]); myrow["pyckdm"] = Convertor.IsNull(rows[i]["配药窗口"], "") == "" ? "" : Convertor.IsNull(rows[i]["配药窗口"], ""); myrow["fyckdm"] = Convertor.IsNull(rows[i]["发药窗口"], ""); //Convertor.IsNull(rows[i]["发药窗口"], "") == "" ? _Fyckh : Convertor.IsNull(rows[i]["发药窗口"], ""); myrow["zdmc"] = Convertor.IsNull(rows[i]["诊断"], ""); myrow["syff"] = Convert.ToString(rows[i]["用法"]); myrow["sypc"] = Convert.ToString(rows[i]["使用频次"]); myrow["jl"] = Convert.ToString(Convert.ToDouble(rows[i]["剂量"])); myrow["jldw"] = Convert.ToString(rows[i]["剂量单位"]); myrow["ts"] = Convert.ToDouble(Convertor.IsNull(rows[i]["天数"], "0")).ToString(); myrow["jx"] = Convertor.IsNull(rows[i]["剂型"], ""); if (rows[i]["组标志"].ToString() == "1") { yzzh = yzzh + 1; } myrow["yzzh"] = yzzh; myrow["pxxh"] = Convert.ToInt32(Convertor.IsNull(rows[i]["排序序号"], "0")); myrow["syjl"] = Convertor.IsNull(rows[i]["单位规格"], ""); myrow["sfrq"] = Convert.ToDateTime(rows[i]["收费日期"]).ToLongDateString(); myrow["cfrq"] = Convert.ToDateTime(rows[i]["录入日期"]).ToLongDateString(); //myrow["sfrq"] = PrintRq.ToLongDateString(); //myrow["cfrq"] = PrintRq.ToLongDateString(); //myrow["blh"] =PrintRq.Year.ToString()+"0"+PrintRq.Month.ToString()+PrintRq.Day.ToString()+ Convert.ToString(rows[i]["门诊号"]).Substring(8,Convert.ToString(rows[i]["门诊号"]).Length-8); myrow["fzbz"] = rows[i]["组标志"].ToString(); myrow["JTDZ"] = jtdz; myrow["LXDH"] = grlxdh; myrow["SFZH"] = sfzh; myrow["bz1"] = Convertor.IsNull(rows[i]["中药备注"], ""); myrow["bz2"] = Convertor.IsNull(rows[i]["备注2"], ""); myrow["bz3"] = Convertor.IsNull(rows[i]["备注3"], ""); myrow["dyr"] = InstanceForm.BCurrentUser.Name; myrow["image"] = GetImageByte((Convertor.IsNull(rows[i]["ysdm"], "0"))); myrow["hwmc"] = Convertor.IsNull(rows[i]["hwmc"], ""); Dset.病人处方清单.Rows.Add(myrow); #endregion } ParameterEx[] parameters = new ParameterEx[7]; parameters[0].Text = "cfts"; parameters[0].Value = rows[0]["剂数"].ToString(); parameters[1].Text = "zje"; parameters[1].Value = Convert.ToDecimal(Convertor.IsNull(rows[0]["总金额"], "0")); parameters[2].Text = "TITLETEXT"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + ""; parameters[3].Text = "text1"; parameters[3].Value = "发药单位:" + InstanceForm.BCurrentDept.DeptName + " 诊断:" + rows[0]["诊断"].ToString(); parameters[4].Text = "xyf"; if (Convert.ToString(rows[0]["cflx"]) != "03") { parameters[4].Value = Convert.ToDecimal(rows[0]["总金额"]); } else { parameters[4].Value = 0; } parameters[5].Text = "zyf"; if (Convert.ToString(rows[0]["cflx"]) == "03") { parameters[5].Value = Convert.ToDecimal(rows[0]["总金额"]); } else { parameters[5].Value = 0; } parameters[6].Text = "yfmc"; parameters[6].Value = InstanceForm.BCurrentDept.DeptName; reportView.Dock = DockStyle.Fill; TabPage pageCtl = new TabPage(); pageCtl.Text = string.Format("{0}{1}", brxm, row["发票号"]); pageCtl.Controls.Add(reportView); this.tabControl1.TabPages.Add(pageCtl); initReportTemp(reportView); if (Convert.ToString(rows[0]["cflx"]) == "03") { this.initReportData(reportView, Dset.病人处方清单, Constant.ApplicationDirectory + "\\Report\\YF_病人处方清单_中药处方.rpt", parameters, false); } else { this.initReportData(reportView, Dset.病人处方清单, Constant.ApplicationDirectory + "\\Report\\YF_病人处方清单(处方格式).rpt", parameters, false); } if (isPreview == false) { reportView.tbMain_ButtonClick(null, new ToolBarButtonClickEventArgs(new ToolBarButton())); string sql = string.Format("update mz_cfb set dybz = 1 where cfid = '{0}'", row["cfxh"]); InstanceForm.BDatabase.DoCommand(sql); } }
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; } }
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, EventArgs e) { try { DataTable tb = (DataTable)this.dataGridView1.DataSource; if (tb == null) { return; } DataRow[] rows; string swhere = ""; if (checkBox1.Checked == true) { swhere = "and 项目来源=2 "; } rows = tb.Select("单价<>0 " + swhere); if (rows.Length == 0) { return; } //string cftsname = ""; //cftsname = Convert.ToString(rows[0]["项目"]).Trim() == "中草药" ? "中药付数" : ""; ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow = null; //int yzzh = 0; //int xxx = 0; string str_blh = ""; //打印单据的门诊号,如果包含多个门诊号,则置空. bool bol = true; //判断是否重打,如果只有一个门诊号,则判断重打,反之不判断. for (int i = 0; i <= rows.Length - 1; i++) { #region 插入明细 myrow = Dset.病人处方清单.NewRow(); myrow["xh"] = Convert.ToInt32(rows[i]["序号"]); myrow["ypmc"] = Convert.ToString(rows[i]["项目名称"]); myrow["ypgg"] = Convert.ToString(rows[i]["规格"]); myrow["sccj"] = Convert.ToString(rows[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["单价"], "0")); myrow["ypsl"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["数量"], "0")); myrow["ypdw"] = Convert.ToString(rows[i]["单位"]); myrow["cfts"] = rows[i]["剂数"]; myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["金额"], "0")); myrow["yf"] = Convert.ToString(rows[i]["用法"]); // myrow["pc"] = rows[i]["使用频次"].ToString().Trim(); //["syjl"] = ""; myrow["zt"] = " " + Convert.ToString(rows[i]["嘱托"]); myrow["shh"] = Convert.ToString(rows[i]["编码"]); myrow["ksname"] = Convert.ToString(rows[i]["科室"]);//+" 费别:"+this.patientInfo1.FeeTypeName; string ysqm = ""; //if (Convert.ToString(row["医生签名"]).Trim()!="") ysqm=" 医生签名:"+Convert.ToString(rows[i]["医生签名"]); myrow["ysname"] = Convert.ToString(rows[i]["医生"]).Trim(); myrow["Pyck"] = rows[i]["皮试"].ToString(); myrow["fph"] = Convert.ToString(rows[i]["发票号"]); myrow["hzxm"] = lblxm.Text; myrow["sex"] = lblxb.Text; myrow["age"] = lblnl.Text; myrow["blh"] = Convert.ToString(rows[i]["门诊号"]); #region 判断结果集是否都是同一门诊号的处方,如果是,则打印之前要判断是否是重打,反之,不用判断 if (String.IsNullOrEmpty(str_blh)) { str_blh = myrow["blh"].ToString(); } else if (myrow["blh"].ToString().CompareTo(str_blh) != 0) { bol = false; } #endregion myrow["sfrq"] = Convert.ToString(rows[i]["收费日期"]); //if (Convert.ToString(rows[i]["配药员"]).Trim() == "") // myrow["pyr"] = this.cmbpyr.Text.Trim(); //else // myrow["pyr"] = Convert.ToString(rows[i]["配药员"]).Trim(); myrow["fyr"] = Convert.ToString(rows[i]["发药员"]).Trim(); //myrow["pyckdm"] = Convert.ToString(rows[i]["配药窗口"]); //myrow["fyckdm"] = Convert.ToString(rows[i]["发药窗口"]); //myrow["zdmc"] = Convert.ToString(rows[i]["诊断"]); //myrow["syff"] = Convert.ToString(rows[i]["用法"]); //myrow["sypc"] = Convert.ToString(rows[i]["频次"]); //myrow["jl"] = Convert.ToString(rows[i]["剂量"]); //myrow["jldw"] = Convert.ToString(rows[i]["剂量单位"]); //myrow["ts"] = Convert.ToDecimal(rows[i]["天数"]); myrow["pzh"] = Convert.ToString(rows[i]["CFID"]).Trim(); myrow["pxxh"] = Convert.ToInt32(rows[i]["pxxh"]); Dset.病人处方清单.Rows.Add(myrow); #endregion } //记录打印 string str_sql = ""; int printNum = 0; if (bol) { try { //取得之前打印次数 str_sql = "select count(1) from MZ_SF_PRINT where BLH='" + str_blh + "'"; printNum = Int32.Parse(InstanceForm.BDatabase.GetDataResult(str_sql).ToString()); if (printNum > 0) { if (MessageBox.Show("本次处方已经打印过,是否继续重新打印处方?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { return; } } //新增一条 str_sql = String.Format(@"insert into MZ_SF_PRINT (BLH,PRINT_TIME,PRINT_EMP) VALUES ('{0}',getdate(),'{1}')", str_blh, InstanceForm.BCurrentUser.EmployeeId); InstanceForm.BDatabase.DoCommand(str_sql, 30); } catch (Exception ex) { MessageBox.Show("管理打印次数出错: " + ex.Message); } } ParameterEx[] parameters = new ParameterEx[8]; parameters[0].Text = "cfts"; parameters[0].Value = ""; parameters[1].Text = "zje"; parameters[1].Value = 0;// Convert.ToDecimal(Convertor.IsNull(rows[0]["总金额"], "0")); parameters[2].Text = "TITLETEXT"; parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "门诊收费明细单" + (printNum > 0 ? "[重打]" : ""); parameters[3].Text = "text1"; parameters[3].Value = "诊断:" + lblzd.Text; parameters[4].Text = "xyf"; parameters[4].Value = 0; parameters[5].Text = "zyf"; parameters[5].Value = 0; parameters[6].Text = "yfmc"; parameters[6].Value = ""; //增加体重字段输入 string strTZ = Convertor.IsNull(InstanceForm.BDatabase.GetDataResult(string.Format("select tz from mz_brtz a inner join mz_ghxx b on a.ghxxid = b.ghxxid where b.blh='{0}'", str_blh)), ""); parameters[7].Text = "tz"; parameters[7].Value = strTZ; bool bview = true; bview = false; TrasenFrame.Forms.FrmReportView f; f = new TrasenFrame.Forms.FrmReportView(Dset.病人处方清单, Constant.ApplicationDirectory + "\\Report\\MZ_门诊收费清单.rpt", parameters, bview); if (f.LoadReportSuccess) { f.Show(); } else { f.Dispose(); } } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private bool PrintCf(DataRow row, int cfgs, UcReportView reportView) { DataRow[] rows; if (cfgs == 1) { rows = cfmxTable.Select(" cfxh='" + row["cfxh"] + "' "); } else { rows = cfmxTable.Select(" cfxh='" + row["cfxh"] + "' and zsyp=1 "); } if (rows.Length == 0) { return(false); } ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2(); DataRow myrow = null; int yzzh = 0; string jtdz = ""; string grlxdh = ""; string sfzh = ""; string brxm = ""; string ssql = "select * from yy_brxx a inner join mz_cfb b on a.brxxid=b.brxxid where b.cfid='" + row["cfxh"].ToString() + "'"; DataTable tb = DB.GetDataTable(ssql); if (tb.Rows.Count > 0) { jtdz = Convertor.IsNull(tb.Rows[0]["jtdz"], ""); grlxdh = Convertor.IsNull(tb.Rows[0]["brlxfs"], ""); sfzh = Convertor.IsNull(tb.Rows[0]["sfzh"], ""); brxm = Convertor.IsNull(tb.Rows[0]["brxm"], ""); } SystemCfg sc = new SystemCfg(10026); List <string> yflist = new List <string>(); yflist.Add("H"); yflist.Add("iv"); yflist.Add("im"); yflist.Add("iv drip"); yflist.Add("iv pump"); yflist.Add("静脉泵入"); yflist.Add("皮下注射"); for (int i = 0; i <= rows.Length - 1; i++) { if (sc.Config == "0") { if (!string.IsNullOrEmpty(yflist.Find(delegate(string s) { return(s.ToUpper() == Convertor.IsNull(rows[i]["用法"], "").Trim().ToUpper()); }))) { #region 非中药处方格式 myrow = Dset.病人处方清单.NewRow(); myrow["xh"] = Convert.ToInt32(rows[i]["序号"]); myrow["ypmc"] = Convert.ToString(rows[i]["品名"]); myrow["ypgg"] = Convert.ToString(rows[i]["规格"]); myrow["sccj"] = Convert.ToString(rows[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["单价"], "0")); myrow["ypsl"] = Convert.ToDouble(Convertor.IsNull(rows[i]["用量"], "0")).ToString(); myrow["ypdw"] = Convert.ToString(rows[i]["单位"]); myrow["cfts"] = rows[i]["剂数"].ToString(); myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["金额"], "0")); myrow["yf"] = Convertor.IsNull(rows[i]["用法"], ""); myrow["pc"] = Convertor.IsNull(rows[i]["使用频次"], ""); myrow["syjl"] = ""; myrow["zt"] = Convertor.IsNull(rows[i]["嘱托"], ""); myrow["shh"] = Convert.ToString(rows[i]["货号"]); myrow["ksname"] = Convert.ToString(rows[i]["科室"]).Trim(); myrow["ysname"] = Convert.ToString(rows[i]["医生"]).Trim(); myrow["PSZT"] = rows[i]["皮试"].ToString(); myrow["fph"] = Convert.ToString(rows[i]["发票号"]); myrow["hzxm"] = Convert.ToString(rows[i]["姓名"]); myrow["sex"] = Convert.ToString(rows[i]["性别"]); myrow["age"] = Convert.ToString(rows[i]["年龄"]); myrow["blh"] = Convert.ToString(rows[i]["门诊号"]); myrow["sfrq"] = Convert.ToString(rows[i]["收费日期"]); //myrow["pyr"] = rows[i]["配药人"]; if (Convert.ToString(rows[i]["发药员"]) != string.Empty) { myrow["fyr"] = Convert.ToString(rows[i]["发药员"]); } myrow["pyckdm"] = Convertor.IsNull(rows[i]["配药窗口"], "") == "" ? "" : Convertor.IsNull(rows[i]["配药窗口"], ""); myrow["fyckdm"] = Convertor.IsNull(rows[i]["发药窗口"], ""); //Convertor.IsNull(rows[i]["发药窗口"], "") == "" ? _Fyckh : Convertor.IsNull(rows[i]["发药窗口"], ""); myrow["zdmc"] = Convertor.IsNull(rows[i]["诊断"], ""); myrow["syff"] = Convert.ToString(rows[i]["用法"]); myrow["sypc"] = Convert.ToString(rows[i]["使用频次"]); myrow["jl"] = Convert.ToString(Convert.ToDouble(rows[i]["剂量"])); myrow["jldw"] = Convert.ToString(rows[i]["剂量单位"]); myrow["ts"] = Convert.ToDouble(Convertor.IsNull(rows[i]["天数"], "0")).ToString(); myrow["jx"] = Convertor.IsNull(rows[i]["剂型"], ""); if (rows[i]["组标志"].ToString() == "1") { yzzh = yzzh + 1; } myrow["yzzh"] = yzzh; myrow["pxxh"] = Convert.ToInt32(Convertor.IsNull(rows[i]["排序序号"], "0")); myrow["syjl"] = Convertor.IsNull(rows[i]["单位规格"], ""); myrow["sfrq"] = Convert.ToDateTime(rows[i]["收费日期"]).ToLongDateString(); myrow["cfrq"] = Convert.ToDateTime(rows[i]["录入日期"]).ToLongDateString(); //myrow["sfrq"] = PrintRq.ToLongDateString(); //myrow["cfrq"] = PrintRq.ToLongDateString(); //myrow["blh"] =PrintRq.Year.ToString()+"0"+PrintRq.Month.ToString()+PrintRq.Day.ToString()+ Convert.ToString(rows[i]["门诊号"]).Substring(8,Convert.ToString(rows[i]["门诊号"]).Length-8); myrow["fzbz"] = rows[i]["组标志"].ToString(); myrow["JTDZ"] = jtdz; myrow["LXDH"] = grlxdh; myrow["SFZH"] = sfzh; myrow["bz1"] = Convertor.IsNull(rows[i]["中药备注"], ""); myrow["bz2"] = Convertor.IsNull(rows[i]["备注2"], ""); myrow["bz3"] = Convertor.IsNull(rows[i]["备注3"], ""); //myrow["dyr"] = InstanceForm.BCurrentUser.Name; myrow["image"] = GetImageByte((Convertor.IsNull(rows[i]["ysdm"], "0"))); myrow["hwmc"] = Convertor.IsNull(rows[i]["hwmc"], ""); Dset.病人处方清单.Rows.Add(myrow); #endregion } } else { #region 非中药处方格式 myrow = Dset.病人处方清单.NewRow(); myrow["xh"] = Convert.ToInt32(rows[i]["序号"]); myrow["ypmc"] = Convert.ToString(rows[i]["品名"]); myrow["ypgg"] = Convert.ToString(rows[i]["规格"]); myrow["sccj"] = Convert.ToString(rows[i]["厂家"]); myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["单价"], "0")); myrow["ypsl"] = Convert.ToDouble(Convertor.IsNull(rows[i]["用量"], "0")).ToString(); myrow["ypdw"] = Convert.ToString(rows[i]["单位"]); myrow["cfts"] = rows[i]["剂数"].ToString(); myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(rows[i]["金额"], "0")); myrow["yf"] = Convertor.IsNull(rows[i]["用法"], ""); myrow["pc"] = Convertor.IsNull(rows[i]["使用频次"], ""); myrow["syjl"] = ""; myrow["zt"] = Convertor.IsNull(rows[i]["嘱托"], ""); myrow["shh"] = Convert.ToString(rows[i]["货号"]); myrow["ksname"] = Convert.ToString(rows[i]["科室"]).Trim(); myrow["ysname"] = Convert.ToString(rows[i]["医生"]).Trim(); myrow["PSZT"] = rows[i]["皮试"].ToString(); myrow["fph"] = Convert.ToString(rows[i]["发票号"]); myrow["hzxm"] = Convert.ToString(rows[i]["姓名"]); myrow["sex"] = Convert.ToString(rows[i]["性别"]); myrow["age"] = Convert.ToString(rows[i]["年龄"]); myrow["blh"] = Convert.ToString(rows[i]["门诊号"]); myrow["sfrq"] = Convert.ToString(rows[i]["收费日期"]); //myrow["pyr"] = rows[i]["配药人"]; if (Convert.ToString(rows[i]["发药员"]) != string.Empty) { myrow["fyr"] = Convert.ToString(rows[i]["发药员"]); } myrow["pyckdm"] = Convertor.IsNull(rows[i]["配药窗口"], "") == "" ? "" : Convertor.IsNull(rows[i]["配药窗口"], ""); myrow["fyckdm"] = Convertor.IsNull(rows[i]["发药窗口"], ""); //Convertor.IsNull(rows[i]["发药窗口"], "") == "" ? _Fyckh : Convertor.IsNull(rows[i]["发药窗口"], ""); myrow["zdmc"] = Convertor.IsNull(rows[i]["诊断"], ""); myrow["syff"] = Convert.ToString(rows[i]["用法"]); myrow["sypc"] = Convert.ToString(rows[i]["使用频次"]); myrow["jl"] = Convert.ToString(Convert.ToDouble(rows[i]["剂量"])); myrow["jldw"] = Convert.ToString(rows[i]["剂量单位"]); myrow["ts"] = Convert.ToDouble(Convertor.IsNull(rows[i]["天数"], "0")).ToString(); myrow["jx"] = Convertor.IsNull(rows[i]["剂型"], ""); if (rows[i]["组标志"].ToString() == "1") { yzzh = yzzh + 1; } myrow["yzzh"] = yzzh; myrow["pxxh"] = Convert.ToInt32(Convertor.IsNull(rows[i]["排序序号"], "0")); myrow["syjl"] = Convertor.IsNull(rows[i]["单位规格"], ""); myrow["sfrq"] = Convert.ToDateTime(rows[i]["收费日期"]).ToLongDateString(); myrow["cfrq"] = Convert.ToDateTime(rows[i]["录入日期"]).ToLongDateString(); //myrow["sfrq"] = PrintRq.ToLongDateString(); //myrow["cfrq"] = PrintRq.ToLongDateString(); //myrow["blh"] =PrintRq.Year.ToString()+"0"+PrintRq.Month.ToString()+PrintRq.Day.ToString()+ Convert.ToString(rows[i]["门诊号"]).Substring(8,Convert.ToString(rows[i]["门诊号"]).Length-8); myrow["fzbz"] = rows[i]["组标志"].ToString(); myrow["JTDZ"] = jtdz; myrow["LXDH"] = grlxdh; myrow["SFZH"] = sfzh; myrow["bz1"] = Convertor.IsNull(rows[i]["中药备注"], ""); myrow["bz2"] = Convertor.IsNull(rows[i]["备注2"], ""); myrow["bz3"] = Convertor.IsNull(rows[i]["备注3"], ""); //myrow["dyr"] = InstanceForm.BCurrentUser.Name; myrow["image"] = GetImageByte((Convertor.IsNull(rows[i]["ysdm"], "0"))); myrow["hwmc"] = Convertor.IsNull(rows[i]["hwmc"], ""); Dset.病人处方清单.Rows.Add(myrow); #endregion } } if (Dset.病人处方清单.Rows.Count == 0) { return(false); } ParameterEx[] parameters = new ParameterEx[7]; parameters[0].Text = "cfts"; parameters[0].Value = rows[0]["剂数"].ToString(); parameters[1].Text = "zje"; parameters[1].Value = Convert.ToDecimal(Convertor.IsNull(rows[0]["总金额"], "0")); parameters[2].Text = "TITLETEXT"; sc = new SystemCfg(2, DB); parameters[2].Value = "武汉市中心医院"; parameters[3].Text = "text1"; parameters[3].Value = "发药单位:" + deptName + " 诊断:" + rows[0]["诊断"].ToString(); parameters[4].Text = "xyf"; if (Convert.ToString(rows[0]["cflx"]) != "03") { parameters[4].Value = Convert.ToDecimal(rows[0]["总金额"]); } else { parameters[4].Value = 0; } parameters[5].Text = "zyf"; if (Convert.ToString(rows[0]["cflx"]) == "03") { parameters[5].Value = Convert.ToDecimal(rows[0]["总金额"]); } else { parameters[5].Value = 0; } parameters[6].Text = "yfmc"; parameters[6].Value = deptName; initReportTemp(reportView); if (Convert.ToString(rows[0]["cflx"]) == "03") { this.initReportData(reportView, Dset.病人处方清单, GetLocalPath() + "\\Report\\YF_病人处方清单_中药处方.rpt", parameters, false); } else { this.initReportData(reportView, Dset.病人处方清单, GetLocalPath() + "\\Report\\YF_快发病人处方清单(处方格式).rpt", parameters, false); } ToolBarButtonClickEventArgs clickEvent = new ToolBarButtonClickEventArgs(new ToolBarButton()); clickEvent.Button.Tag = 0; reportView.tbMain_ButtonClick(null, clickEvent); return(true); //string sql = string.Format("update mz_cfb set dybz = 1 where cfid = '{0}'", row["cfxh"]); //InstanceForm.BDatabase.DoCommand(sql); }
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); } }
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); } }