public long m_lngQueryLISAppHISByDate(string p_strStartDate, string p_strEndDate, out clsLISAppl_VO[] p_objResultArr) { p_objResultArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strStartDate) || string.IsNullOrEmpty(p_strEndDate)) { return(lngRes); } clsHRPTableService objHRPServ = null; try { string strSQL = @"select '' as outrester, c.registerid_chr as inrester, t.application_id_chr,t.modify_dat, a.confirm_dat, t.application_dat, t.appl_empid_chr, d.lastname_vchr as applempname, a.confirmer_id_chr as checkerid, e.lastname_vchr as checkername, '' as checkmonth, t.appl_deptid_chr, f.deptname_vchr from t_opr_lis_application t inner join t_opr_lis_sample a on a.application_id_chr = t.application_id_chr and a.status_int = 6 inner join t_opr_attachrelation b on b.attarelaid_chr = t.application_id_chr and b.sysfrom_int = 2 and b.status_int = 1 and b.attachtype_int = 3 left outer join t_opr_bih_order c on c.orderid_chr = b.sourceitemid_vchr left outer join t_bse_employee d on t.appl_empid_chr = d.empid_chr left outer join t_bse_employee e on a.confirmer_id_chr = e.empid_chr left outer join t_bse_deptdesc f on f.deptid_chr = t.appl_deptid_chr where t.pstatus_int > 0 and a.confirm_dat between ? and ?"; IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = Convert.ToDateTime(p_strStartDate); objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = Convert.ToDateTime(p_strEndDate); DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); objHRPServ.Dispose(); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; int iRowCount = dtResult.Rows.Count; clsLISAppl_VO objTemp = null; p_objResultArr = new clsLISAppl_VO[iRowCount]; for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLISAppl_VO(); objTemp.m_strVISITNO = drTemp["outrester"].ToString().Trim(); objTemp.m_strINHOSSEQNO = drTemp["inrester"].ToString().Trim(); objTemp.m_strOBSERVATIONID = drTemp["application_id_chr"].ToString().Trim(); objTemp.m_strOBSERVATIONDATETIM = drTemp["confirm_dat"] != DBNull.Value ? Convert.ToDateTime(drTemp["confirm_dat"]).ToString("yyyy-MM-dd HH:mm:ss") : ""; objTemp.m_strCREATEOBSERVATIONDATETIME = drTemp["application_dat"] != DBNull.Value ? Convert.ToDateTime(drTemp["application_dat"]).ToString("yyyy-MM-dd HH:mm:ss") : ""; objTemp.m_strCREATECLINICIANCODE = drTemp["appl_empid_chr"].ToString().Trim(); objTemp.m_strCREATECLINICIANNAME = drTemp["applempname"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTCODE = drTemp["checkerid"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTNAME = drTemp["checkername"].ToString().Trim(); objTemp.m_strOBSERVATIONWAY = drTemp["checkmonth"].ToString().Trim(); objTemp.m_strOBSERVATIONDEPTCODE = drTemp["appl_deptid_chr"].ToString().Trim(); objTemp.m_strOBSERVATIONDEPTNAME = drTemp["deptname_vchr"].ToString().Trim(); //// 执行科室代码 + 执行科室名称 //objTemp.m_strOBSERVATIONOPTDEPTCODE = drTemp[""].ToString().Trim(); //objTemp.m_strOBSERVATIONOPTDEPTNAME = drTemp[""].ToString().Trim(); p_objResultArr[iRow] = objTemp; } } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } return(lngRes); }
public long m_lngQueryLISAppByDate(string p_strStartDate, string p_strEndDate, out clsLISAppl_VO[] p_objResultArr) { p_objResultArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strStartDate) || string.IsNullOrEmpty(p_strEndDate)) { return(lngRes); } clsHRPTableService objHRPServ = null; //Hashtable objHsTable = new Hashtable(); try { string strSQL = @"select '' organcode, t.application_id_chr observationid,--检验单号 patientcardid_chr visitno, --就诊流水号 '' inhosseqno,--住院流水号 t3.paytypeid_chr kind, --病人性质代码 t1.sample_type_id_chr proveswatchcode,--检验样本编号 t1.sample_type_vchr proveswatchname, --检验样本名称 t1.sample_type_id_chr provetype, --检验类别代码 t.modify_dat observationdatetime,--检验日期 t1.application_dat createobservationdatetime,--开单时间 t1.appl_empid_chr createcliniciancode, --开单医生代码 f_getempnamebyid(t1.appl_empid_chr) createclinicianname, --开单医生姓名 t2.operator_id_chr observationoptcode, --检验人员代码 f_getempnamebyid(t2.operator_id_chr) observationoptname, --检验人员姓名 '' observationway, --检验方法 t1.appl_deptid_chr observationdeptcode, --开单科室代码 f_getdeptnamebyid(t1.appl_deptid_chr) observationdeptname, --开单科室名称 '' observationoptdeptcode, --执行科室代码 '' observationoptdeptname, --执行科室名称 '0' flag, --作废标志代码 t4.registerid_chr, t5.attarelaid_chr, --对应流水号 t5.sourceitemid_vchr, --源id (门诊) = 处方id; (住院) = 医嘱id t5.sysfrom_int --来源 1=门诊;2=住院 from (select a.modify_dat,a1.application_id_chr,a1.sample_id_chr from t_opr_lis_check_result a left join t_opr_lis_app_sample a1 on a.sample_id_chr = a1.sample_id_chr and a.groupid_chr = a1.sample_group_id_chr where a.modify_dat between ? and ? and a.status_int = 1) t left join t_opr_lis_application t1 on t.application_id_chr = t1.application_id_chr and t1.pstatus_int > 0 and t1.orderunitrelation_vchr in null left join t_opr_lis_app_report t2 on t1.application_id_chr = t2.application_id_chr and t2.status_int = 2 left outer join t_bse_patient t3 on t1.patientid_chr = t3.patientid_chr left outer join (select b.patientid_chr,max(b.registerid_chr) as registerid_chr from t_opr_bih_register b group by b.patientid_chr) t4 on t4.patientid_chr = t3.patientid_chr left outer join (select d.attarelaid_chr,d.sysfrom_int,d.sourceitemid_vchr,d.attachid_vchr from t_opr_attachrelation d where d.attarelaid_chr in (select max(c.attarelaid_chr) from t_opr_attachrelation c group by c.attachid_vchr)) t5 on t.application_id_chr = t5.attachid_vchr"; IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = Convert.ToDateTime(p_strStartDate); objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = Convert.ToDateTime(p_strEndDate); List <clsLISAppl_VO> objList = new List <clsLISAppl_VO>(); DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); objHRPServ.Dispose(); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; int iRowCount = dtResult.Rows.Count; clsLISAppl_VO objTemp = null; p_objResultArr = new clsLISAppl_VO[iRowCount]; for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLISAppl_VO(); objTemp.m_strOBSERVATIONID = drTemp["observationid"].ToString().Trim(); if (drTemp["sysfrom_int"].ToString().Trim() == "1") { objTemp.m_strVISITNO = drTemp["sourceitemid_vchr"].ToString().Trim(); } if (drTemp["sysfrom_int"].ToString().Trim() == "2") { objTemp.m_strINHOSSEQNO = drTemp["registerid_chr"].ToString().Trim(); } objTemp.m_strKIND = clsDataUpload_Svc.m_strConvertValue("kind", drTemp["paytypeid_chr"].ToString().Trim(), ""); objTemp.m_strPROVESWATCHCODE = drTemp["proveswatchcode"].ToString().Trim(); objTemp.m_strPROVESWATCHNAME = drTemp["proveswatchname"].ToString().Trim(); objTemp.m_strPROVETYPE = drTemp["proveswatchcode"].ToString().Trim(); objTemp.m_strOBSERVATIONDATETIM = Convert.ToDateTime(drTemp["modify_dat"]).ToString("yyyy-MM-dd HH:mm:ss"); objTemp.m_strCREATEOBSERVATIONDATETIME = drTemp["createobservationdatetime"] != DBNull.Value ? Convert.ToDateTime(drTemp["createobservationdatetime"]).ToString("yyyy-MM-dd HH:mm:ss") : ""; objTemp.m_strCREATECLINICIANCODE = drTemp["createcliniciancode"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strCREATECLINICIANCODE)) { objTemp.m_strCREATECLINICIANCODE = "*"; } objTemp.m_strCREATECLINICIANNAME = drTemp["createclinicianname"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strCREATECLINICIANNAME)) { objTemp.m_strCREATECLINICIANNAME = "*"; } objTemp.m_strOBSERVATIONOPTCODE = drTemp["observationoptcode"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTNAME = drTemp["observationoptname"].ToString().Trim(); objTemp.m_strOBSERVATIONWAY = drTemp["checkmonth"].ToString().Trim(); objTemp.m_strOBSERVATIONDEPTCODE = drTemp["observationdeptcode"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strOBSERVATIONDEPTCODE)) { objTemp.m_strOBSERVATIONDEPTCODE = "*"; } objTemp.m_strOBSERVATIONDEPTNAME = drTemp["observationdeptname"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTDEPTCODE = "*"; objTemp.m_strOBSERVATIONOPTDEPTNAME = "*"; objTemp.m_strFLAG = drTemp["flag"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strOBSERVATIONDEPTNAME)) { objTemp.m_strOBSERVATIONDEPTNAME = "*"; } try { //objHsTable.Add(objTemp.m_strVISITNO + objTemp.m_strINHOSSEQNO + objTemp.m_strOBSERVATIONID, ""); objList.Add(objTemp); } catch { } } p_objResultArr = objList.ToArray(); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; p_strEndDate = null; p_strStartDate = null; //objHsTable.Clear(); } return(lngRes); }