//private frmDetail m_frmDetail;
public void GetDepartmentList()
{
try
{
OracleParameter par1 = new OracleParameter("@result", OracleType.Cursor);
par1.Direction = ParameterDirection.Output;
DataSet ds = DS_SqlHelper.ExecuteDataSet("EMRQCMANAGER.usp_QcmanagerDepartmentlist", new OracleParameter[] { par1 }, CommandType.StoredProcedure);
m_pageSouce = ds.Tables[0];
gridControldepartment.DataSource = m_pageSouce;
if (m_pageSouce.Rows.Count == 0)
{
MessageBox.Show("无数据");
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// xll 2013-06-25
/// 查询数据
/// 将病人信息 时段数据和日数据整合到一个DataTable中来
/// </summary>
/// <returns></returns>
public DataTable SearchInpatentDataZheHe(string hour, string date)
{
try
{
string departcode = CommonObjects.CurrentUser.CurrentDeptId;
string wardcode = CommonObjects.CurrentUser.CurrentWardId;
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@departCode", SqlDbType.VarChar, 50),
new SqlParameter("@wardcode", SqlDbType.VarChar, 50),
new SqlParameter("@Timelot", SqlDbType.VarChar, 50),
new SqlParameter("@TimelotSave", SqlDbType.VarChar, 50),
new SqlParameter("@date", SqlDbType.NVarChar, 50),
new SqlParameter("@result", SqlDbType.Structured, int.MaxValue),
new SqlParameter("@result1", SqlDbType.Structured, int.MaxValue),
new SqlParameter("@result2", SqlDbType.Structured, int.MaxValue)
};
sqlParams[0].Value = departcode;
sqlParams[1].Value = wardcode;
sqlParams[2].Value = hour;
sqlParams[3].Value = timelotSave;//天数据存为2时段
string surveyDate = m_CurrDatetime;
sqlParams[4].Value = surveyDate;
sqlParams[5].Direction = ParameterDirection.Output;
sqlParams[6].Direction = ParameterDirection.Output;
sqlParams[7].Direction = ParameterDirection.Output;
DataSet dataSet = DS_SqlHelper.ExecuteDataSet("EMR_NURSE_STATION.usp_GetPatientsOfDept2", sqlParams, CommandType.StoredProcedure);
DataTable dtInpatient = new DataTable();
dtInpatient = ConvertToDataTable(dataSet);
dtInpatient.DefaultView.Sort = "BED asc ";
return(dtInpatient);
}
catch (Exception ex)
{
throw ex;
}
}
