private void btOK_Click(object sender, System.EventArgs e) { Cursor.Current = PubStaticFun.WaitCursor(); DataSet ds = new DataSet(); string sSql = ""; DataTable GzrzTb = new DataTable(); DataTable GzrzMxTb = new DataTable(); if (checkBox1.Checked) { sSql = "select dbo.fun_zy_seekdeptname(DEPT_ID) 科别," + "sum(YY) 原有," + "sum(OUTALL) 出院合计," + "sum(OUTZY) 治愈," + "sum(OUTHZ) 好转," + "sum(OUTWY) 未愈," + "sum(OUTSW) 死亡," + "sum(TRANSOUT) 转出," + "sum([IN]) 入院," + "sum(TRANSIN) 转入," + "sum(NOW) 现有," + "sum(OPER) 手术," + "sum(BIRTH) 分娩," + "sum(BW) 病危," + "sum(BZ) 病重," + "sum(TJHL) 特护," + "sum(YJHL) 一级护理," + "sum(PH) 陪护 from zy_wardgzrz where book_date = '" + dateTimePicker1.Value.ToShortDateString() + "'"; sSql += " and dept_id in (select dept_id from jc_wardrdept where ward_id ='" + cmbdept.SelectedValue.ToString().Trim() + "')"; sSql += " group by DEPT_ID"; } else { sSql = "exec SP_ZYHS_wardgzrz '" + cmbdept.SelectedValue.ToString().Trim() + "','" + dateTimePicker1.Value.ToShortDateString() + "','" + dateTimePicker1.Value.ToShortDateString() + "',0"; } GzrzTb = InstanceForm.BDatabase.GetDataTable(sSql); GzrzTb.TableName = "tabWardGzrz"; if (checkBox1.Checked) { sSql = "select case type when 1 then '出院' " + "when 2 then '转出' " + "when 3 then '死亡' " + "when 4 then '入院' " + "when 5 then '转入' " + "when 6 then '手术' " + "when 7 then '分娩' " + "when 8 then '病危' " + "when 9 then '病重' end 项目, INPATIENT_NO 住院号," + "BED_NO 床号," + "NAME 姓名," + "ZD 诊断,dbo.fun_getdeptname(dept_id) 科别,'' 备注 from zy_wardgzrz_mx where book_date = '" + dateTimePicker1.Value.ToShortDateString() + "' and dept_id in (select dept_id from jc_wardrdept where ward_id ='" + cmbdept.SelectedValue.ToString().Trim() + "')"; } else { sSql = "exec SP_ZYHS_wardgzrz '" + cmbdept.SelectedValue.ToString().Trim() + "','" + dateTimePicker1.Value.ToShortDateString() + "','" + dateTimePicker1.Value.ToShortDateString() + "',1"; } GzrzMxTb = InstanceForm.BDatabase.GetDataTable(sSql); GzrzMxTb.TableName = "tabWardGzrzMx"; //add by zouchihua 2012-9-11 转科前的科室 ds.Tables.Add(GzrzTb); ds.Tables.Add(GzrzMxTb); FrmReportView frmRptView = null; ParameterEx[] _parameters = new ParameterEx[4]; _parameters[0].Text = "医院名称"; _parameters[0].Value = (new SystemCfg(0002)).Config; _parameters[1].Text = "病区"; _parameters[1].Value = (InstanceForm.BCurrentDept.WardName == ""?this.cmbdept.Text:InstanceForm.BCurrentDept.WardName); _parameters[2].Text = "填报人"; _parameters[2].Value = InstanceForm.BCurrentUser.Name; _parameters[3].Text = "日期加星期"; _parameters[3].Value = dateTimePicker1.Value.ToShortDateString() + " " + PubStaticFun.GetCHNWeekName(dateTimePicker1.Value.DayOfWeek.ToString()); frmRptView = new FrmReportView(ds, Constant.ApplicationDirectory + "\\report\\ZYHS_病区工作日志.rpt", _parameters); frmRptView.Show(); Cursor.Current = Cursors.Default; }