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;
}