Esempio n. 1
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="applyunitid"></param>
 /// <returns></returns>
 public long lngDeleteLimitTime(string applyunitid)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.DeleteLimitTime(applyunitid));
     }
 }
Esempio n. 2
0
        public void init()
        {
            //标本类型绑定数据
            #region
            clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc));
            DataTable dt = svc.GetSampleType();
            this.cboSampleType.Items.Add("全部");
            this.cboTimeType.Items.Add("核收时间");
            this.cboTimeType.Items.Add("开单时间");
            this.cboTimeType.SelectedIndex = 0;

            try
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        this.cboSampleType.Items.Add(dr["sample_type_desc_vchr"].ToString());
                    }
                }
            }
            finally
            {
                svc = null;
            }
            #endregion
        }
Esempio n. 3
0
 /// <summary>
 /// 细菌分布趋势报告
 /// </summary>
 /// <param name="micname"></param>
 /// <param name="p_dtDateFrom"></param>
 /// <param name="p_dtDateTO"></param>
 /// <param name="SamtNo"></param>
 /// <param name="DisNo"></param>
 /// <param name="Sex"></param>
 /// <param name="TestMethod"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetMicdistributionTend(string micname, DateTime p_dtDateFrom, DateTime p_dtDateTO, string applicationStr, string DeptIdArr, string sampleId, string DisNo, string Sex, string TestMethod, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetMicdistributionTend(micname, p_dtDateFrom, p_dtDateTO, applicationStr, DeptIdArr, sampleId, DisNo, Sex, TestMethod, out dtbResult));
     }
 }
Esempio n. 4
0
 /// <summary>
 /// lngGetLimitTime
 /// </summary>
 /// <param name="dtbResult"></param>
 /// <param name="applyunitid"></param>
 /// <returns></returns>
 public long lngGetLimitTime(out DataTable dtbResult, string applyunitid)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.GetLimitTime(out dtbResult, applyunitid));
     }
 }
Esempio n. 5
0
        private void frmCritialDeptList_Load(object sender, EventArgs e)
        {
            this.dgvDeptList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

            try
            {
                clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc));

                DataTable dt = svc.GetDeptList(deptint);

                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        int index = this.dgvDeptList.Rows.Add();
                        //this.dataGridView1.Rows[index].Cells[0].Value = index.ToString();
                        this.dgvDeptList.Rows[index].Cells[1].Value = (index + 1).ToString();
                        this.dgvDeptList.Rows[index].Cells[2].Value = dr["code_vchr"].ToString().Trim();
                        this.dgvDeptList.Rows[index].Cells[3].Value = dr["deptname_vchr"].ToString().Trim();
                    }
                }
            }
            finally
            {
            }
        }
Esempio n. 6
0
 /// <summary>
 /// 模糊查询抗生素
 /// </summary>
 /// <param name="micName"></param>
 /// <param name="IsEnglish"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetFuzzyQueryAnti(string micName, bool IsEnglish, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetFuzzyQueryAnti(micName, IsEnglish, out dtbResult));
     }
 }
Esempio n. 7
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="p_dtDateFrom"></param>
        /// <param name="p_dtDateTo"></param>
        /// <param name="SamtName"></param>
        /// <param name="strTempAntiName"></param>
        /// <param name="dtbResult"></param>
        /// <returns></returns>

        public long lngGetMicApplication(string strTempAntiName, DateTime p_dtDateFrom, DateTime p_dtDateTo, string criticalStr, string DeptIdArr, out DataTable dtbResult)
        {
            using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
            {
                return(svc.lngGetApplicateion(strTempAntiName, p_dtDateFrom, p_dtDateTo, criticalStr, DeptIdArr, out dtbResult));
            }
        }
Esempio n. 8
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="applicationStr"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetGss(string applicationStr, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetGss(applicationStr, out dtbResult));
     }
 }
Esempio n. 9
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="p_dtDateFrom"></param>
 /// <param name="p_dtDateTO"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetAntiCheckItem(DateTime p_dtDateFrom, DateTime p_dtDateTO, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetAntiCheckItem(p_dtDateFrom, p_dtDateTO, out dtbResult));
     }
 }
Esempio n. 10
0
 /// <summary>
 /// 细菌 按类型
 /// </summary>
 /// <param name="p_dtDateFrom"></param>
 /// <param name="p_dtDateTO"></param>
 /// <param name="applicationStr"></param>
 /// <param name="sampleId"></param>
 /// <param name="DisNo"></param>
 /// <param name="Sex"></param>
 /// <param name="TestMethod"></param>
 /// <param name="strTempAntiID"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetAntiByDept(string strTempName, string applicationStr, string DeptIdArr, string sampleId, string DisNo, string Sex, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetAntiByDept(strTempName, applicationStr, DeptIdArr, sampleId, DisNo, Sex, out dtbResult));
     }
 }
Esempio n. 11
0
 /// <summary>
 /// 细菌明细
 /// </summary>
 /// <param name="p_dtDateFrom"></param>
 /// <param name="p_dtDateTO"></param>
 /// <param name="applicationStr"></param>
 /// <param name="sampleId"></param>
 /// <param name="DisNo"></param>
 /// <param name="Sex"></param>
 /// <param name="TestMethod"></param>
 /// <param name="strTempAntiID"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetAntiDetail(string strTempName, DateTime p_dtDateFrom, DateTime p_dtDateTO, string DeptIdArr, string sampleId, string DisNo, string Sex, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetAntiDetail(strTempName, p_dtDateFrom, p_dtDateTO, DeptIdArr, sampleId, DisNo, Sex, out dtbResult));
     }
 }
Esempio n. 12
0
 /// <summary>
 /// 获取所有革兰细菌
 /// </summary>
 /// <param name="dt"></param>
 /// <returns></returns>
 public long lngGetAllGlMic(out DataTable dt)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetAllGlMic(out dt));
     }
 }
Esempio n. 13
0
 /// <summary>
 /// 检验项目阳性结果分析统计表
 /// </summary>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetPositiveReport(out DataTable dtbResult, string dteStart, string dteEnd, string checkItemId, string strDept, string groupId, string patNo)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.GetPositiveReport(out dtbResult, dteStart, dteEnd, checkItemId, strDept, groupId, patNo));
     }
 }
Esempio n. 14
0
 /// <summary>
 /// 获取所有检验项目
 /// </summary>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetAllCheckItem(out DataTable dtbResult, string groupId)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.GetAllCheckItemCpy(out dtbResult, groupId));
     }
 }
Esempio n. 15
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="dt"></param>
 /// <returns></returns>
 public long lngSaveLimitTime(DataTable dt)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.SaveLimitTime(dt));
     }
 }
Esempio n. 16
0
 /// <summary>
 /// 免费母婴阻断阳性结果汇总
 /// </summary>
 /// <param name="dteStart"></param>
 /// <param name="dteEnd"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetPmpcDetail(string dteStart, string dteEnd, string patType, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.GetPmpctDetail(dteStart, dteEnd, patType, out dtbResult));
     }
 }
Esempio n. 17
0
 /// <summary>
 /// 检验标本周转中位数统计表
 /// </summary>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetSampleMedSpec(out DataTable dtbResult, string dteStart, string dteEnd, string groupId, string applyUnitId, string strDept, string enmergencyFlg, string patType)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.GetSampleMedSpec(out dtbResult, dteStart, dteEnd, groupId, applyUnitId, strDept, enmergencyFlg, patType));
     }
 }
Esempio n. 18
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="dteStart"></param>
 /// <param name="dteEnd"></param>
 /// <param name="categoryId"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long GetWorkLoadCount(string dteStart, string dteEnd, string categoryId, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.GetWorkLoadCount(dteStart, dteEnd, categoryId, out dtbResult));
     }
 }
Esempio n. 19
0
        private void frmByDept_Load(object sender, EventArgs e)
        {
            this.LstDeptID   = new List <string>();
            this.LstDeptName = new List <string>();
            //clsDcl_Charge clsDcl_Charge = new clsDcl_Charge();
            clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc));
            long      num       = 0;
            DataTable dataTable = null;

            if (this.area == 1)
            {
                num = svc.GetArea(out dataTable);
            }
            else
            {
                num = svc.GetDeptArea(out dataTable);
            }

            if (num > 0L)
            {
                int i = 0;
                while (i < dataTable.Rows.Count)
                {
                    DataRow dataRow = dataTable.Rows[i];
                    if (this.LimitDeptIDArr.Count <= 0 || this.LimitDeptIDArr.IndexOf(dataRow["deptid_chr"].ToString()) >= 0)
                    {
                        string[] values = { "F", Convert.ToString(i + 1), dataRow["code_vchr"].ToString().Trim(), dataRow["deptname_vchr"].ToString().Trim() };
                        int      index  = this.dtDept.Rows.Add(values);
                        this.dtDept.Rows[index].Tag = dataRow;
                    }
                    i++;
                }
            }
            this.txtVal.Focus();
        }
Esempio n. 20
0
 /// <summary>
 /// 科室用药汇总
 /// </summary>
 /// <param name="dteStart"></param>
 /// <param name="dteEnd"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetKsMedStatment(string dteStart, string dteEnd, string deptStr, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetKsMedStatment(dteStart, dteEnd, deptStr, out dtbResult));
     }
 }
Esempio n. 21
0
 /// <summary>
 /// 预发药冲减
 /// </summary>
 /// <param name="putmeddetailId"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetRePretestMedStat(string putmeddetailId, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetRePretestMedStat(putmeddetailId, out dtbResult));
     }
 }
Esempio n. 22
0
 /// <summary>
 /// 累计MIC报告
 /// </summary>
 /// <param name="p_dtDateFrom"></param>
 /// <param name="p_dtDateTO"></param>
 /// <param name="SamtNo"></param>
 /// <param name="DisNo"></param>
 /// <param name="Sex"></param>
 /// <param name="TestMethod"></param>
 /// <param name="strTempAntiID"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetMicCumulative(string applicationStr, string sampleId, string DisNo, string Sex, string TestMethod, string strTempAntiID, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.lngGetMicCumulative(applicationStr, sampleId, DisNo, Sex, TestMethod, strTempAntiID, out dtbResult));
     }
 }
Esempio n. 23
0
        public List <string> GetYGItem()
        {
            #region
            clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc));
            DataTable dt = svc.GetYGItemType();

            List <string> lstData = new List <string>();

            try
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        lstData.Add(dr["refDesc"].ToString());
                    }
                }
            }
            finally
            {
                svc = null;
            }

            return(lstData);

            #endregion
        }
Esempio n. 24
0
 /// <summary>
 /// 名称检索检验项目
 /// </summary>
 /// <param name="strTempName"></param>
 /// <param name="dtbResult"></param>
 /// <returns></returns>
 public long lngGetCheckItemByName(string strTempName, string groudId, out DataTable dtbResult)
 {
     using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
     {
         return(svc.GetCheckItemByNameCpy(strTempName, groudId, out dtbResult));
     }
 }
Esempio n. 25
0
        /// <summary>
        /// 获取专业组
        /// </summary>
        /// <param name="dtbResult"></param>
        /// <returns></returns>
        public void lngGetAllCheckSpec(out DataTable dtbResult)
        {
            dtbResult = null;

            using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
            {
                dtbResult = svc.GetGategoryType();
            }
        }
Esempio n. 26
0
        /// <summary>
        /// 细菌名称检验细菌
        /// </summary>
        /// <param name="micName"></param>
        /// <param name="IsEnglish"></param>
        /// <param name="dtbResult"></param>
        /// <returns></returns>
        public long lngGetFuzzyQueryMic(string micName, bool IsEnglish, out DataTable dtbResult)
        {
            long lngRes = 0;

            dtbResult = null;
            using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
                lngRes = svc.lngGetFuzzyQueryMic(micName, IsEnglish, out dtbResult);
            return(lngRes);
        }
Esempio n. 27
0
        /// <summary>
        /// 敏感率趋势报告
        /// </summary>
        /// <param name="micname"></param>
        /// <param name="p_dtDateFrom"></param>
        /// <param name="p_dtDateTO"></param>
        /// <param name="SamtNo"></param>
        /// <param name="DisNo"></param>
        /// <param name="Sex"></param>
        /// <param name="AgeFrom"></param>
        /// <param name="AgeTo"></param>
        /// <param name="TestMethod"></param>
        /// <param name="strTempAntiID"></param>
        /// <param name="dtbResult"></param>
        /// <returns></returns>
        public long lngGetSensitiveTend(string applictionStr, string sampleId, string DisNo, string Sex, string strTempAntiID, out DataTable dtbResult)
        {
            long lngRes = 0;

            dtbResult = null;
            using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
                lngRes = svc.lngGetSensitiveTend(applictionStr, sampleId, DisNo, Sex, strTempAntiID, out dtbResult);
            return(lngRes);
        }
Esempio n. 28
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="dtbResult"></param>
        /// <returns></returns>
        public long lngGgetAllZyz(out DataTable dtbResult)
        {
            long lngRes = 0;

            using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)))
            {
                dtbResult = svc.GetGategoryType();
            }
            return(lngRes);
        }
Esempio n. 29
0
        private void btnSelect_Click(object sender, EventArgs e)
        {
            string BeginDate = this.dteRq1.Value.ToString("yyyy-MM-dd");
            string EndDate   = this.dteRq2.Value.ToString("yyyy-MM-dd");

            if (Convert.ToDateTime(BeginDate + " 00:00:01") > Convert.ToDateTime(EndDate + " 00:00:01"))
            {
                MessageBox.Show("开始日期不能大于结束日期。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            try
            {
                clsPublic.PlayAvi("findFILE.avi", "正在统计院感项目信息,请稍候...");
                dwRep.Reset();
                clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc));
                DataTable dt = svc.GetYGItem(BeginDate, EndDate);
                if (dt != null && dt.Rows.Count > 0)
                {
                    int row = 0;
                    dwRep.SetRedrawOff();
                    foreach (DataRow dr in dt.Rows)
                    {
                        row = dwRep.InsertRow(0);
                        dwRep.SetItemString(row, "areaName", dr["areaName"].ToString());
                        dwRep.SetItemString(row, "bedNo", dr["bedNo"].ToString());
                        dwRep.SetItemString(row, "ipNo", dr["ipNo"].ToString());
                        dwRep.SetItemString(row, "patName", dr["patName"].ToString());
                        dwRep.SetItemString(row, "sex", dr["patsex"].ToString());
                        dwRep.SetItemString(row, "age", dr["birthday"] != DBNull.Value ? clsPublic.CalcAge(Convert.ToDateTime(dr["birthday"].ToString())):"");
                        dwRep.SetItemString(row, "itemCode", dr["itemCode"].ToString());
                        dwRep.SetItemString(row, "itemName", dr["itemName"].ToString());
                        dwRep.SetItemString(row, "startDate", dr["startDate"] != DBNull.Value ? Convert.ToDateTime(dr["startDate"].ToString()).ToString("yyyy-MM-dd HH:mm") : "");
                        dwRep.SetItemString(row, "stopDate", dr["stopDate"] != DBNull.Value ? Convert.ToDateTime(dr["stopDate"].ToString()).ToString("yyyy-MM-dd HH:mm") : "");
                    }
                    dwRep.SetRedrawOn();
                }
                else
                {
                    dwRep.InsertRow(0);
                }
                dwRep.Modify("t_date.text = '" + BeginDate + " ~ " + EndDate + "'");
            }
            finally
            {
                clsPublic.CloseAvi();
            }
            this.dwRep.Refresh();
        }
Esempio n. 30
0
        internal void Query()
        {
            List <string> lstParam   = new List <string>();
            string        beginDate  = string.Empty;
            string        endDate    = string.Empty;
            string        sampleType = string.Empty;
            string        patName    = string.Empty;
            string        barCode    = string.Empty;
            string        peno       = string.Empty;
            string        ownerDept  = string.Empty;
            //string deptStr= string.Empty;
            int checkState = 0;

            getdeptstr();
            if (!chkDeptSelect.Checked)
            {
                lstParam.Add("ownerDept");
                deptStr = "('" + this.LoginInfo.m_strDepartmentID + "','" + this.LoginInfo.m_strInpatientAreaID + "')";
            }
            else
            {
                lstParam.Add("deptStr");
            }

            //this.LoginInfo.m_strDepartmentID

            beginDate = this.dteRq1.Value.ToString("yyyy-MM-dd HH:mm");
            endDate   = this.dteRq2.Value.ToString("yyyy-MM-dd HH:mm");
            int timeType = this.cboTimeType.SelectedIndex;

            lstParam.Add("queryDate");

            if (Convert.ToDateTime(beginDate + " :01") > Convert.ToDateTime(endDate + ":59"))
            {
                MessageBox.Show("开始日期不能大于结束日期。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            if (this.cboSampleType.Text.Trim() != string.Empty)
            {
                lstParam.Add("sampleType");
                sampleType = cboSampleType.Text.Trim();
            }

            if (this.txtBarcode.Text.Trim() != string.Empty)
            {
                lstParam.Add("barCode");
                barCode = this.txtBarcode.Text;
            }

            if (this.txtPatName.Text.Trim() != string.Empty)
            {
                lstParam.Add("patName");
                patName = this.txtPatName.Text;
            }

            if (this.txtPeno.Text.Trim() != string.Empty)
            {
                lstParam.Add("peno");
                peno = this.txtPeno.Text;
            }

            if (this.chkChecked.Checked == true)
            {
                lstParam.Add("check");
                checkState = 1;
            }

            if (this.chkUnchecked.Checked == true)
            {
                lstParam.Add("check");
                checkState = 2;
            }

            if (this.chkRefuseCheck.Checked == true)
            {
                lstParam.Add("check");
                checkState = 3;
            }

            try
            {
                clsPublic.PlayAvi("findFILE.avi", "正在项目信息,请稍候...");
                dwRep.Reset();
                clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc));
                DataTable dt = svc.GetSamplePackStat(lstParam, beginDate, endDate, sampleType, patName, barCode, peno, deptStr, checkState, timeType);

                if (dt != null && dt.Rows.Count > 0)
                {
                    int row = 0;
                    dwRep.SetRedrawOff();
                    foreach (DataRow dr in dt.Rows)
                    {
                        row = dwRep.InsertRow(0);
                        dwRep.SetItemString(row, "barcode", dr["barcode"].ToString());
                        dwRep.SetItemString(row, "patcardno", dr["patcardno"].ToString().Trim());
                        if (dr["peno"].ToString().Trim().Length < 12)
                        {
                            dwRep.SetItemString(row, "inpatno", dr["peno"].ToString().Trim());
                        }
                        else
                        {
                            dwRep.SetItemString(row, "peno", dr["peno"].ToString().Trim());
                        }
                        dwRep.SetItemString(row, "pattype", dr["pattype"].ToString());
                        dwRep.SetItemString(row, "patname", dr["patname"].ToString());
                        dwRep.SetItemString(row, "sampletype", dr["sampletype"].ToString());
                        dwRep.SetItemString(row, "checkcontent", dr["checkcontent"].ToString());
                        dwRep.SetItemString(row, "applyername", dr["applyername"].ToString());
                        dwRep.SetItemString(row, "deptname", dr["deptname"].ToString());
                        dwRep.SetItemString(row, "packtime", dr["packtime"] != DBNull.Value ? Convert.ToDateTime(dr["packtime"].ToString()).ToString("yyyy-MM-dd HH:mm") : "");
                        dwRep.SetItemString(row, "packname", dr["packname"].ToString());
                        dwRep.SetItemString(row, "checktime", dr["checktime"] != DBNull.Value ? Convert.ToDateTime(dr["checktime"].ToString()).ToString("yyyy-MM-dd HH:mm") : "");
                        dwRep.SetItemString(row, "checkname", dr["checkname"].ToString());
                        dwRep.SetItemString(row, "rechecktime", dr["rechecktime"] != DBNull.Value ? Convert.ToDateTime(dr["rechecktime"].ToString()).ToString("yyyy-MM-dd HH:mm") : "");
                        dwRep.SetItemString(row, "recheckreason", dr["recheckreason"].ToString());
                    }
                    dwRep.SetRedrawOn();
                }
                else
                {
                    dwRep.InsertRow(0);
                }

                dwRep.Modify("t_date.text = '" + beginDate + " ~ " + endDate + "'");
            }
            finally
            {
                lstParam = null;
                clsPublic.CloseAvi();
            }
            this.dwRep.Refresh();
        }