Esempio n. 1
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();
        }