示例#1
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// isEnabled 为 true 时,过滤掉未启用的记录
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarItem> FindByPagination(int pageNum, int pageSize, string code, string name, string dtpCode, string dtpName, bool isEnabled)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (code != null && code.Length > 0)
            {
                whereSql += " and code like ? ";
                listParam.Add("%" + code + "%");
            }
            if (name != null && name.Length > 0)
            {
                whereSql += " and name like ? ";
                listParam.Add("%" + name + "%");
            }
            if (dtpCode != null && dtpCode.Length > 0)
            {
                whereSql += " and dpt_code like ? ";
                listParam.Add("%" + dtpCode + "%");
            }
            if (dtpName != null && dtpName.Length > 0)
            {
                whereSql += " and dpt_name like ? ";
                listParam.Add("%" + dtpName + "%");
            }

            if (isEnabled)
            {
                whereSql += " and enabled = 1 ";
            }

            SPagintion <ClinicarItem> page = ClinicarItemDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum);

            return(page);
        }
示例#2
0
        private int FindResult(int pageNum, int pageSize)
        {
            int check_id = 0;

            if (DataEntityClinicarCheck != null && !string.IsNullOrEmpty(DataEntityClinicarCheck.Id))
            {
                check_id = Convert.ToInt32(DataEntityClinicarCheck.Id);
            }
            SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(pageNum, pageSize, check_id);
            IList <ClinicarCheckItem>      list = page != null ? page.Data : new List <ClinicarCheckItem>();

            SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties);

            //移除控件
            this.picb_left.Controls.Clear();
            this.panel3.Controls.Clear();
            if (list != null && !Convert.IsDBNull(list) && list.Count > 0)
            {
                listDraw = list;
                for (int i = 0; i < list.Count; i++)
                {
                    //右边条码
                    createBarCode(uTxt_checkNum.Text.Trim(), list[i].ItemCode, 27, 6 + i * 88);
                }
            }
            //左上角条码
            createLeftBarCode(uTxt_checkNum.Text.Trim());

            return(page.TotalRecordCount);
        }
示例#3
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinihospitalDpt> FindByPagination(int pageNum, int pageSize, string code, string name, string hospitalcode)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (code != null && code.Length > 0)
            {
                whereSql += " and code like ? ";
                listParam.Add("%" + code + "%");
            }
            if (name != null && name.Length > 0)
            {
                whereSql += " and name like ? ";
                listParam.Add("%" + name + "%");
            }
            if (hospitalcode != null && hospitalcode.Length > 0)
            {
                whereSql += " and hospitalcode = ? ";
                listParam.Add(hospitalcode);
            }

            SPagintion <ClinihospitalDpt> page = ClinihospitalDptDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum);

            return(page);
        }
        /// <summary>
        ///
        /// </summary>
        private void fillBack()
        {
            ClinicarItem entity = null;     //项目管理实体类

            if (this.dgrdView.CurrentRow != null && this.dgrdView.CurrentRow.Index >= 0 && f_CheckId != 0)
            {
                entity = ((BindingList <ClinicarItem>) this.dgrdView.DataSource)[this.dgrdView.CurrentRow.Index];
                SResult           rst = new SResult();
                ClinicarCheckItem clinicarCheckItem = new ClinicarCheckItem();
                clinicarCheckItem.ItemCode = entity.Id;
                clinicarCheckItem.ItemName = entity.Name;
                clinicarCheckItem.DptCode  = entity.DptCode;
                clinicarCheckItem.DptName  = entity.DptName;
                clinicarCheckItem.CheckId  = f_CheckId;
                rst = clinicarCheckItemBiz.Insert(clinicarCheckItem);

                if (rst.success)
                {
                    UcMessageBox.Information("添加成功!", "提示");
                }
                else
                {
                    UcMessageBox.Error(rst.message, "提示");
                }
                //刷新登记界面中的检查项目表
                SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(1, 999, f_CheckId);
                IList <ClinicarCheckItem>      list = page != null ? page.Data : new List <ClinicarCheckItem>();
                SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.dataGridViewTranmit, displayPropertiesTranmit);
            }
            else
            {
                UcMessageBox.Warning("请先选择一行数据", "提示");
            }
        }
 private int FindResult(int pageNum, int pageSize)
 {
     SPagintion<ClinicarConsultation> page = clinicarConsultationBiz.FindByPagination(pageNum, pageSize, uDat_Start.Value.ToString("yyyy-MM-dd"), uDat_End.Value.ToString("yyyy-MM-dd"));
     IList<ClinicarConsultation> list = page != null ? page.Data : new List<ClinicarConsultation>();
     SGridViewUtil.BindingData<ClinicarConsultation>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties);
     return page.TotalRecordCount;
 }
示例#6
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarCheck> FindByPagination(int pageNum, int pageSize, string checkNum, string name, string cardNum)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (checkNum != null && checkNum.Length > 0)
            {
                whereSql += " and check_number like ? ";
                listParam.Add("%" + checkNum + "%");
            }
            if (name != null && name.Length > 0)
            {
                whereSql += " and name like ? ";
                listParam.Add("%" + name + "%");
            }
            if (cardNum != null && cardNum.Length > 0)
            {
                whereSql += " and certificate_number like ? ";
                listParam.Add("%" + cardNum + "%");
            }

            SPagintion <ClinicarCheck> page = ClinicarCheckDao.FindByPagintion(whereSql, listParam.ToArray(), "check_number desc", pageSize, pageNum);

            return(page);
        }
        private int FindResult(int pageNum, int pageSize)
        {
            SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindUnCompletedPagination(pageNum, pageSize, check_id);
            IList <ClinicarCheckItem>      list = page != null ? page.Data : new List <ClinicarCheckItem>();

            SGridViewUtil.BindingData <ClinicarCheckItem>(list, ucDgvlist, displayProperties);
            return(page.TotalRecordCount);
        }
示例#8
0
        private int FindResult(int pageNum, int pageSize)
        {
            SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(pageNum, pageSize, DataEntityId);
            IList <ClinicarCheckItem>      list = page != null ? page.Data : new List <ClinicarCheckItem>();

            SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties);
            return(page.TotalRecordCount);
        }
        private int FindResult(int pageNum, int pageSize)
        {
            SPagintion <ClinihospitalDpt> page = ClinihospitalDptBiz.FindByPagination(pageNum, pageSize, this.ucTxt_code.Text, this.ucTxt_name.Text, hospitalcod);
            IList <ClinihospitalDpt>      list = page != null ? page.Data : new List <ClinihospitalDpt>();

            SGridViewUtil.BindingData <ClinihospitalDpt>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties);
            return(page.TotalRecordCount);
        }
示例#10
0
        private int FindResult(int pageNum, int pageSize)
        {
            SPagintion <ClinicarItem> page = clinicarItemBiz.FindByPagination(1, 9999, this.ucTxt_code.Text, this.ucTxt_name.Text, this.ucTxt_DtpCode.Text, this.ucTxt_DtpName.Text, false);
            IList <ClinicarItem>      list = page != null ? page.Data : new List <ClinicarItem>();

            SGridViewUtil.BindingData <ClinicarItem>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties);
            return(page.TotalRecordCount);
        }
示例#11
0
        private int FindResult(int pageNum, int pageSize)
        {
            SPagintion <ClinicarCheck> page = clinicarCheckBiz.FindByPagination(pageNum, pageSize, this.ucTxt_checkNumber.Text, this.ucTxt_name.Text, this.ucTxt_cre.Text);
            IList <ClinicarCheck>      list = page != null ? page.Data : new List <ClinicarCheck>();

            SGridViewUtil.BindingData <ClinicarCheck>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties);
            return(page.TotalRecordCount);
        }
示例#12
0
        private int FindResult(int pageNum, int pageSize)
        {
            SPagintion <SysBaseData> page = SysBaseDataBiz.FindByPagination(pageNum, pageSize, this.ucTxt_code.Text);
            IList <SysBaseData>      list = page != null ? page.Data : new List <SysBaseData>();

            SGridViewUtil.BindingData <SysBaseData>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties);
            return(page.TotalRecordCount);
        }
示例#13
0
        /// <summary>
        /// 刷新子表
        /// </summary>
        private void detailGridSearch(ClinicarItem entity)
        {
            if (entity == null)
            {
                return;
            }
            SPagintion <ClinicarItemDetail> page = clinicarItemDetailBiz.FindByPagination(1, 9999, entity.Id);
            IList <ClinicarItemDetail>      list = page != null ? page.Data : new List <ClinicarItemDetail>();

            SGridViewUtil.BindingData <ClinicarItemDetail>(list, this.ucdgv_itemDetail.UcDataGridViewControl, displayPropertiesDetail);
        }
示例#14
0
        /// <summary>
        /// 子表数据分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarCheckResult> FindByPagination(int pageNum, int pageSize, string checkNum)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            whereSql += " and deleted=0 and check_number = ? ";
            listParam.Add(checkNum);
            SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "item_code asc", pageSize, pageNum);

            return(page);
        }
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarItemDetail> FindByPagination(int pageNum, int pageSize, string itemCode)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            whereSql += " and item_code = ? ";
            listParam.Add(itemCode);

            SPagintion <ClinicarItemDetail> page = ClinicarItemDetailDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum);

            return(page);
        }
示例#16
0
        /// <summary>
        /// 子表数据分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarCheckItem> FindByPagination(int pageNum, int pageSize, int checkId)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            whereSql += " and deleted=0 and check_id = ? ";
            listParam.Add(checkId);

            SPagintion <ClinicarCheckItem> page = ClinicarCheckItemDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum);

            return(page);
        }
示例#17
0
        /// <summary>
        /// 子表数据分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarCheckResult> FindByPagination(int pageNum, int pageSize, string checkNum, string itemCode)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            whereSql += " and IFNULL(item_detail_name,'') not in ('Ref Group','Blood Mode','Take Mode') and deleted=0 and check_number = ?  and item_code = ?   ";
            listParam.Add(checkNum);
            listParam.Add(itemCode);

            SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "create_time desc", pageSize, pageNum);

            return(page);
        }
示例#18
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarAllCheck> FindByPagination(int pageNum, int pageSize, string checkNumber)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (checkNumber != null && checkNumber.Length > 0)
            {
                whereSql += " and check_number like ? ";
                listParam.Add("%" + checkNumber + "%");
            }
            SPagintion <ClinicarAllCheck> page = ClinicarAllCheckDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum);

            return(page);
        }
示例#19
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <SysBaseData> FindByPagination(int pageNum, int pageSize, string code)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (code != null && code.Length > 0)
            {
                whereSql += " and code like ? ";
                listParam.Add("%" + code + "%");
            }
            SPagintion <SysBaseData> page = SysBaseDataDao.FindByPagintion(whereSql, listParam.ToArray(), "code asc", pageSize, pageNum);

            return(page);
        }
示例#20
0
        /// <summary>
        /// 行改变监听事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgrdViewLeft_SelectionChanged(object sender, EventArgs e)
        {
            ClinicarCheck entity = this.GetCurrentRowData();

            if (entity == null || Convert.IsDBNull(entity))
            {
                return;
            }
            //检查科室表格绑定数据
            SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(1, 100, Convert.ToInt32(entity.Id));
            IList <ClinicarCheckItem>      list = page != null ? page.Data : new List <ClinicarCheckItem>();

            SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.dataGridView_Dtp.UcDataGridViewControl, displayPropertiesCenter);
        }
示例#21
0
        private int FindResult(int pageNum, int pageSize)
        {
            //检查科室表格绑定数据
            SPagintion <ClinicarCheck> page = clinicarCheckBiz.FindByPagination(1, 999, uTxt_checkNumber.Text.Trim(), "", entityCheckTransmit.CertificateNumber == null?"": entityCheckTransmit.CertificateNumber);
            IList <ClinicarCheck>      list = page != null ? page.Data : new List <ClinicarCheck>();

            SGridViewUtil.BindingData <ClinicarCheck>(list, this.ucDgv_listLeft.UcDataGridViewControl, displayPropertiesLeft);
            if (list == null || Convert.IsDBNull(list) || list.Count <= 0)
            {
                dgrdViewCenter.DataSource = null;
                dgrdViewRight.DataSource  = null;
            }
            return(page.TotalRecordCount);
        }
示例#22
0
        /// <summary>
        /// 根据检查号和项目编号分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarCheckResult> FindByNumAndItem(int pageNum, int pageSize, string checkNum, string itemCode)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (!string.IsNullOrWhiteSpace(checkNum))
            {
                whereSql += " and check_number = ? ";
                listParam.Add(checkNum);
            }

            whereSql += " and deleted=0 and item_code = ? ";
            listParam.Add(itemCode);

            SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum);

            return(page);
        }
示例#23
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarHospital> FindByPagination(int pageNum, int pageSize, string hospitalCode, string hospitalName)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (hospitalCode != null && hospitalCode.Length > 0)
            {
                whereSql += " and hospitalcode like ? ";
                listParam.Add("%" + hospitalCode + "%");
            }
            if (hospitalName != null && hospitalName.Length > 0)
            {
                whereSql += " and hospitalname like ? ";
                listParam.Add("%" + hospitalName + "%");
            }
            SPagintion <ClinicarHospital> page = ClinicarHospitalDao.FindByPagintion(whereSql, listParam.ToArray(), "hospitalcode desc", pageSize, pageNum);

            return(page);
        }
示例#24
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <SysUser> FindByPagination(int pageNum, int pageSize, string code, string name)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (code != null && code.Length > 0)
            {
                whereSql += " and code like ? ";
                listParam.Add("%" + code + "%");
            }
            if (name != null && name.Length > 0)
            {
                whereSql += " and name like ? ";
                listParam.Add("%" + name + "%");
            }

            SPagintion <SysUser> page = SysUserDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum);

            return(page);
        }
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarConsultation> FindByPagination(int pageNum, int pageSize, string beginDate, string endDate)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            //if (beginDate != null && beginDate.Length > 0 && endDate != null && endDate.Length > 0)
            //{
            //    whereSql += " and sechedulDate between ? and ? ";
            //    listParam.Add(beginDate);
            //    listParam.Add(endDate);
            //}

            whereSql += " and DATE_FORMAT(applyhospitaldate,'%Y-%m-%d') between ? and ? ";
            listParam.Add(beginDate);
            listParam.Add(endDate);

            SPagintion <ClinicarConsultation> page = ClinicarConsultationDao.FindByPagintion(whereSql, listParam.ToArray(), "applyhospitaldate desc", pageSize, pageNum);

            return(page);
        }
示例#26
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <SysUser> FindByPagination(int pageNum, int pageSize, string username, string fullName)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (username != null && username.Length > 0)
            {
                whereSql += " and username like ? ";
                listParam.Add("%" + username + "%");
            }
            if (fullName != null && fullName.Length > 0)
            {
                whereSql += " and fullName like ? ";
                listParam.Add("%" + fullName + "%");
            }

            SPagintion <SysUser> page = SysUserDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum);

            return(page);
        }
示例#27
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageNum"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public SPagintion <ClinicarDptSechedul> FindByPagination(int pageNum, int pageSize, string deptCode, string beginDate, string endDate)
        {
            List <object> listParam = new List <object>();
            String        whereSql  = "";

            if (deptCode != null && deptCode.Length > 0)
            {
                whereSql += " and deptCode like ? ";
                listParam.Add("%" + deptCode + "%");
            }
            if (beginDate != null && beginDate.Length > 0 && endDate != null && endDate.Length > 0)
            {
                whereSql += " and sechedulDate between ? and ? ";
                listParam.Add(beginDate);
                listParam.Add(endDate);
            }

            SPagintion <ClinicarDptSechedul> page = ClinicarDptSechedulDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum);

            return(page);
        }
示例#28
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="whereHql">以and开始,例如"and name=?"</param>
        /// <param name="whereParams">对应whereHql的参数(?)</param>
        /// <param name="orderSql">排序sql,例如"name desc, id desc"</param>
        /// <param name="pageSize">每页显示条数</param>
        /// <param name="pageNo">要查询的页数</param>
        /// <returns></returns>
        public static SPagintion <T> FindByPagintion(string _whereHql, object[] _whereParams, string _orderSql, int _pageSize, int _pageNo)
        {
            try
            {
                if (_pageNo < 1)
                {
                    _pageNo = 1;
                }
                Type tt = typeof(T);

                SPagintion <T> page = new SPagintion <T>();
                page.WhereSql       = _whereHql;
                page.WhereParams    = _whereParams;
                page.OrderSql       = _orderSql;
                page.PageSize       = _pageSize;
                page.CurrentPageNum = _pageNo;

                string filter = "1=1 " + page.WhereSql;
                page.TotalRecordCount = ActiveRecordBase.Count(tt, filter, page.WhereParams);//获得总条数

                if (page.TotalRecordCount > 0)
                {
                    string hql = "FROM " + tt.Name + " WHERE " + filter;
                    if (page.OrderSql != null && page.OrderSql.Trim().Length > 0)
                    {
                        hql += " ORDER BY " + page.OrderSql;
                    }
                    SimpleQuery <T> sq             = new SimpleQuery <T>(hql, page.WhereParams);
                    int             startRecordNum = (page.CurrentPageNum - 1) * page.PageSize;
                    sq.SetQueryRange(startRecordNum, page.PageSize);// Mysql是分页语句
                    page.Data = (IList <T>)ActiveRecordBase.ExecuteQuery(sq);
                }

                return(page);
            }
            catch (Exception err)
            {
                throw err;
            }
        }
示例#29
0
        /// <summary>
        /// 根据检查号回填信息
        /// </summary>
        private void fillByCheckNum()
        {
            if (DataEntity != null && Convert.IsDBNull(DataEntity) == false)
            {
                label8.Text                 = DataEntity.CheckNumber;
                uTxt_name.Text              = DataEntity.Name;
                uTxt_genderName.Text        = DataEntity.GenderName;
                uNum_age.Text               = DataEntity.Age.ToString();
                uTxt_maritalStatusName.Text = DataEntity.MaritalStatusName;
                uTxt_nationalityName.Text   = DataEntity.NationalityName;
                uTxt_checkNumber.Text       = DataEntity.CheckNumber;

                //检查科室表格绑定数据
                SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(1, 100, Convert.ToInt32(DataEntity.Id));
                IList <ClinicarCheckItem>      list = page != null ? page.Data : new List <ClinicarCheckItem>();
                SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.ucDgv_listLeft.UcDataGridViewControl, displayPropertiesLeft);
            }
            else
            {
                UcMessageBox.Warning("所查询的检查号不存在.", "提示!");
            }
        }
示例#30
0
        /// <summary>
        ///
        /// </summary>
        private void showResult(ClinicarCheckItem entity)
        {
            //检查结果表格绑定数据
            SPagintion <ClinicarCheckResult> page = clinicarCheckResultBiz.FindByPagination(1, 100, uTxt_checkNumber.Text.Trim(), entity.ItemCode);
            IList <ClinicarCheckResult>      list = page != null ? page.Data : new List <ClinicarCheckResult>();

            this.imageOrPdfPath = string.Empty;

            //数据类展示(表格)
            if (Util.showType(entity.DptName).Equals(Util.data))
            {
                //添加数据标签页
                tabControl1.TabPages.Insert(0, tabPage1);
                //结果表有数据则查询结果表,没有数据则查询项目表
                if (list != null && Convert.IsDBNull(list) == false && list.Count > 0)
                {
                    //不自动生成列
                    this.dataGridView_Result.AutoGenerateColumns = false;
                    this.dataGridView_Result.DataSource          = list;
                    this.f_blEdit = true;
                }
                else
                {
                    SPagintion <ClinicarItemDetail> pageItem = clinicarItemDetailBiz.FindByPagination(1, 100, entity.ItemCode);
                    IList <ClinicarItemDetail>      listItem = pageItem != null ? pageItem.Data : new List <ClinicarItemDetail>();
                    //不自动生成列
                    this.dataGridView_Result.AutoGenerateColumns = false;
                    this.dataGridView_Result.DataSource          = listItem;
                    this.f_blEdit = false;
                }
            }
            //图片类展示
            else if (Util.showType(entity.DptName).Equals(Util.image))
            {
                //添加图片类标签页
                tabControl1.TabPages.Insert(0, tabPage2);
                //加载图片
                if (list != null && Convert.IsDBNull(list) == false && list.Count > 0)
                {
                    if (list[0].AttachmentPath != null && !list[0].AttachmentPath.Equals(""))
                    {
                        this.label9.Visible = false;
                        try
                        {
                            pictureBox1.Image   = Image.FromFile(Util.basePath + list[0].AttachmentPath);
                            this.imageOrPdfPath = list[0].AttachmentPath;
                        }
                        catch
                        {
                            pictureBox1.Image   = null;
                            this.label9.Visible = true;
                        }
                    }
                    else
                    {
                        pictureBox1.Image   = null;
                        this.label9.Visible = true;
                    }
                }
                else
                {
                    pictureBox1.Image   = null;
                    this.label9.Visible = true;
                }
            }
            //pdf类展示
            else if (Util.showType(entity.DptName).Equals(Util.pdf))
            {
                //添加pdf类标签页
                tabControl1.TabPages.Insert(0, tabPage3);
                //加载pdf
                if (list != null && Convert.IsDBNull(list) == false && list.Count > 0)
                {
                    if (list[0].AttachmentPath != null && !list[0].AttachmentPath.Equals(""))
                    {
                        this.label10.Visible = false;
                        try
                        {
                            if (list[0].AttachmentPath.ToString().ToLower().EndsWith(".pdf"))
                            {
                                axAcroPDF1.LoadFile(Util.basePath + list[0].AttachmentPath);
                                this.imageOrPdfPath = list[0].AttachmentPath;
                            }
                            else
                            {
                                axAcroPDF1.LoadFile("");
                                this.label10.Visible = true;
                            }
                        }
                        catch
                        {
                            axAcroPDF1.LoadFile("");
                            this.label10.Visible = true;
                        }
                    }
                    else
                    {
                        axAcroPDF1.LoadFile("");
                        this.label10.Visible = true;
                    }
                }
                else
                {
                    axAcroPDF1.LoadFile("");
                    this.label10.Visible = true;
                }
            }
        }