private void btndy_Click(object sender, EventArgs e) { try { //获得卡号信息 string sql = " select kh from YY_KDJB where brxxid='" + Dqcf.brxxid + "'"; DataTable tbPat = FrmMdiMain.Database.GetDataTable(sql); string brkh = ""; if (tbPat.Rows.Count > 0) { brkh = tbPat.Rows[0]["KH"].ToString(); } DsJyJc.rptAPPDataTable tb = new DsJyJc.rptAPPDataTable(); DataTable dt = (DataTable)this.control_jysq1.dataGridView1.DataSource; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = tb.NewRow(); dr["binname"] = lblxm.Text; dr["sex"] = lblxb.Text; dr["age"] = lblnl.Text; dr["yqDoc"] = FrmMdiMain.CurrentUser.Name; dr["yqDate"] = dtpsqrq.Value; dr["deptName"] = FrmMdiMain.CurrentDept.DeptName; dr["wardName"] = FrmMdiMain.CurrentDept.DeptName; dr["bedID"] = ""; dr["symptom"] = control_jysq1.richTextBoxEx1.Text.Trim(); dr["diagnosis"] = control_jysq1.TextLczd.textBox1.Text.Trim(); //this.txtzd.Text.Trim(); dr["place"] = cmbbw.Text; //this.cmbPlace.Text.Trim(); dr["itemName"] = dt.Rows[i]["name"].ToString(); // chkListBox.CheckedItems; dr["inpatientid"] = lblmzh.Text; // 门诊号 dr["price"] = " " + dt.Rows[i]["je"].ToString(); for (int j = 4; j < 7; j++) { dr["col" + j.ToString()] = ""; } if (i < dt.Rows.Count - 1) { dr["bz"] = " 标本名称:" + dt.Rows[i]["bbmc"].ToString(); dr["col3"] = "附加说明:" + dt.Rows[i]["fjsm"].ToString(); } dr["yymc"] = (new SystemCfg(2)).Config; dr["lxmc"] = "门诊病人" + this.cmbClassJC.Text.Trim() + "申请单"; dr["col1"] = brkh; dr["col2"] = dt.Rows[i]["zxksmc"].ToString(); //cmbjcks.Text;//检查科室 tb.Rows.Add(dr); } string printFile = "Mz_化验申请.rpt"; FrmReportView rv = new FrmReportView(tb, Constant.ApplicationDirectory + "\\report\\" + printFile, null, false); rv.ShowDialog(); } catch (Exception ea) { MessageBox.Show("打印出现异常!原因:" + ea.Message, "提示"); } }
private void btPrintJC_Click(object sender, EventArgs e) { //获得卡号信息 string sql = " select kh from YY_KDJB where brxxid='" + Dqcf.brxxid + "'"; DataTable tbPat = FrmMdiMain.Database.GetDataTable(sql); string brkh = ""; if (tbPat.Rows.Count > 0) { brkh = tbPat.Rows[0]["KH"].ToString(); } DsJyJc.rptAPPDataTable tb = new DsJyJc.rptAPPDataTable(); for (int i = 0; i < this.dataGridView1.Rows.Count; i++) { DataRow dr = tb.NewRow(); dr["binname"] = lblxm.Text; dr["sex"] = lblxb.Text; dr["age"] = lblnl.Text; dr["yqDoc"] = FrmMdiMain.CurrentUser.Name; dr["yqDate"] = dtpsqrq.Value; dr["deptName"] = FrmMdiMain.CurrentDept.DeptName; dr["wardName"] = FrmMdiMain.CurrentDept.DeptName; dr["bedID"] = ""; // dr["address"]=dt.Rows[0]["unit_name"]; // dr["tele"]=dt.Rows[0]["unit_tel"]; dr["symptom"] = txtbs.Text; dr["diagnosis"] = this.txtzd.Text.Trim(); dr["place"] = cmbbw.Text; //this.cmbPlace.Text.Trim(); dr["itemName"] = dataGridView1.Rows[i].Cells[0].Value.ToString(); // chkListBox.CheckedItems; dr["inpatientid"] = lblmzh.Text; // 门诊号 dr["price"] = dataGridView1.Rows[i].Cells[2].Value.ToString(); dr["bz"] = ""; dr["yymc"] = (new SystemCfg(2)).Config; dr["lxmc"] = "门诊病人" + this.cmbClassJC.Text.Trim() + "申请单"; for (int j = 1; j < 7; j++) { dr["col" + j.ToString()] = ""; } dr["col1"] = brkh; dr["col2"] = cmbjcks.Text;//检查科室 tb.Rows.Add(dr); } string printFile = "Mz_检查申请.rpt"; FrmReportView rv = new FrmReportView(tb, Constant.ApplicationDirectory + "\\report\\" + printFile, null, false); rv.ShowDialog(); }