예제 #1
0
        /// <summary>
        /// /根据首页序号和病历分类获取共有多少病历文件信息
        /// </summary>
        /// <param name="m_Noofinpat"></param>
        /// <param name="sortid"></param>
        /// <returns></returns>
        private string GetRecordBySortID(string m_Noofinpat, string sortid)
        {
            string tooltipcontent = "条:";
            string sqlserach      = string.Format(@"select name from recorddetail where 
noofinpat='{0}' and sortid ='{1}' and valid=1 ", m_Noofinpat, sortid);
            int    recordcount    = 0;//此类型病历共几条

            switch (sortid)
            {
            case "AL":
                //会诊单独处理
                recordcount = DS_SqlService.GetConsultRecrod(Int32.Parse(m_Noofinpat)).Rows.Count;
                break;

            default:
                break;
            }
            DataTable dtPatRecordData = m_app.SqlHelper.ExecuteDataTable(sqlserach);

            if (dtPatRecordData != null && dtPatRecordData.Rows.Count > 0)
            {
                recordcount    = dtPatRecordData.Rows.Count;
                tooltipcontent = recordcount.ToString() + tooltipcontent;
                for (int i = 0; i < dtPatRecordData.Rows.Count; i++)
                {
                    tooltipcontent += dtPatRecordData.Rows[i]["name"].ToString() + "\r\n";
                }
            }
            if (dtPatRecordData.Rows.Count == 0)
            {
                tooltipcontent = "0条记录";
            }
            return(tooltipcontent);
        }