private void initReportTemp(TrasenFrame.Forms.UcReportView reportView) { cryRepViw = reportView.CryRepViw_Uc; tbMain = reportView.tbMain_Uc; if (printReportInfo != null && printReportInfo.Length > 0) { reportView.sqlStr_Uc = printReportInfo; } reportView.IsExecSuccessChanged += new EventHandler(ucReportView1_IsExecSuccessChanged); User CurrentUser = null; if (FrmMdiMain.CurrentUser == null) { CurrentUser = new User(); } else { CurrentUser = FrmMdiMain.CurrentUser; } if (CurrentUser.IsAdministrator || new SystemCfg(21).Config == "0") { cryRepViw.ShowCloseButton = true; cryRepViw.ShowExportButton = true; cryRepViw.ShowRefreshButton = true; cryRepViw.ShowGroupTreeButton = true; } }
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 bool initReportData(TrasenFrame.Forms.UcReportView reportView, object reportDataSource, string reportFilePath, ParameterEx[] parameters, bool toPrinter) { return(reportView.Init(reportDataSource, reportFilePath, parameters, toPrinter)); }
/// <summary> /// 直接打印 /// </summary> /// <param name="reportDataSource">报表数据源</param> /// <param name="reportFilePath">报表文件路径</param> /// <param name="parameters">参数集合</param> /// <param name="localLogin">是否本机登录</param> /// <param name="printName">打印机名称</param> /// <param name="actualReportFilePath">报表文件路径是否为实际路径</param> /// <returns>打印是否成功</returns> public static bool DirectPrint(object reportDataSource, string reportFilePath, ParameterEx[] parameters, bool localLogin, string printName, bool actualReportFilePath) { return(UcReportView.DirectPrint(reportDataSource, reportFilePath, parameters, localLogin, printName, actualReportFilePath)); }
/// <summary> /// 取得用户自定义报表文件路径,如果不存在则从path拷贝只自定义路径下 /// </summary> /// <param name="path">当前报表路径</param> /// <param name="localLogin">是否为本机登录</param> /// <returns></returns> public static string GetCustomReportPath(string path, bool localLogin) { return(UcReportView.GetCustomReportPath(path, localLogin)); }