public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckMethodVO p_objCheckMethod, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"INSERT INTO T_BSE_LIS_CHECKMETHOD( METHOD_SEQ_INT, CHECKMETHOD_NAME_VCHR, PYCODE_VCHR, WBCODE_VCHR ) VALUES ( ?, ? ,? ,?)"; try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_CHECKMETHOD", "METHOD_SEQ_INT", out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_intSeq, p_objCheckMethod.m_strName, p_objCheckMethod.m_strPycode, p_objCheckMethod.m_strWbcode ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objCheckMethod.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCSamplelotVO p_objQCSamplelot, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objQCSamplelot, p_intSeq); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objQCSamplelot.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCReportVO p_objQCReport, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; p_objQCReport.m_dtModify = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objQCReport, p_intSeq); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objQCReport.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
private long m_lngAddProperty(clsUnitProperty_VO p_objVO) { long lngRes = 0; string strSQL = @"INSERT INTO t_aid_lis_unit_property(PROPERTY_ID_CHR, PROPERTY_NAME_VCHR,SUMMARY_VCHR,PROPERTY_PRIORITY_NUM,INUSE_FLAG_NUM) VALUES (?, ?, ?, ?, ?)" ; try { System.Data.IDataParameter[] objDPArr = null; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(5, out objDPArr); string strNewID = null; objHRPSvc.m_lngGenerateNewID("t_aid_lis_unit_property", "PROPERTY_ID_CHR", out strNewID); if (strNewID == null || strNewID == "") { throw new Exception("不能分配ID"); } p_objVO.m_strPROPERTY_ID_CHR = strNewID; objDPArr[0].Value = p_objVO.m_strPROPERTY_ID_CHR; objDPArr[1].Value = p_objVO.m_strPROPERTY_NAME_VCHR; objDPArr[2].Value = p_objVO.m_strSUMMARY_VCHR; objDPArr[3].Value = p_objVO.m_intPROPERTY_PRIORITY_NUM; objDPArr[4].Value = p_objVO.m_intINUSE_FLAG_NUM; long lngRecEff = -1; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objDPArr); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); throw objEx; } return(lngRes); }
private long m_lngAddNewAppl(clsLisApplMainVO applMain, out clsLisApplMainVO applMainOut) { #region == SQL == string sql = @"insert into t_opr_lis_application ( application_id_chr , modify_dat, patientid_chr , application_dat, sex_chr , patient_name_vchr, patient_subno_chr , age_chr, patient_type_id_chr , diagnose_vchr, bedno_chr , icdcode_chr, patientcardid_chr , application_form_no_chr, operator_id_chr , appl_empid_chr, appl_deptid_chr , summary_vchr, pstatus_int , emergency_int, special_int , form_int, patient_inhospitalno_chr, sample_type_id_chr, sample_type_vchr , check_content_vchr, oringin_dat , charge_info_vchr, orderunitrelation_vchr ) values( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )" ; #endregion applMainOut = applMain; long lngRes = 0; try { IDataParameter[] objLisApplArr = null; clsHRPTableService objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(29, out objLisApplArr); DateTime CurTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); if (!IsNullOrEmptyOrSpace(applMain.m_strMODIFY_DAT)) { try { DateTime dtmPreModify = DateTime.Parse(applMain.m_strMODIFY_DAT); TimeSpan ts = CurTime - dtmPreModify; if (ts.TotalMilliseconds < 1000) { CurTime = CurTime.AddSeconds(1f); } } catch { } } if (IsNullOrEmptyOrSpace(applMain.m_strAPPLICATION_ID)) { string strNewApplID = null; objHRPSvc.m_lngGenerateNewID("t_opr_lis_application", "APPLICATION_ID_CHR", out strNewApplID); if (string.IsNullOrEmpty(strNewApplID)) { throw new Exception("不能分配申请单ID"); } applMain.m_strAPPLICATION_ID = strNewApplID; } objLisApplArr[0].Value = applMain.m_strAPPLICATION_ID; applMain.m_strMODIFY_DAT = CurTime.ToString("yyyy-MM-dd HH:mm:ss"); objLisApplArr[1].Value = CurTime; if (IsNullOrEmptyOrSpace(applMain.m_strPatientID)) { applMain.m_strPatientID = "-1"; } objLisApplArr[2].Value = applMain.m_strPatientID; objLisApplArr[2].DbType = DbType.String; if (Microsoft.VisualBasic.Information.IsDate(applMain.m_strAppl_Dat)) { objLisApplArr[3].Value = System.DateTime.Parse(applMain.m_strAppl_Dat); } else { applMain.m_strAppl_Dat = null; } objLisApplArr[4].Value = applMain.m_strSex; objLisApplArr[5].Value = applMain.m_strPatient_Name; objLisApplArr[6].Value = applMain.m_strPatient_SubNO; objLisApplArr[7].Value = applMain.m_strAge; objLisApplArr[8].Value = applMain.m_strPatientType; objLisApplArr[9].Value = applMain.m_strDiagnose; objLisApplArr[10].Value = applMain.m_strBedNO; objLisApplArr[11].Value = applMain.m_strICD; if (IsNullOrEmptyOrSpace(applMain.m_strPatientcardID)) { objLisApplArr[12].Value = System.DBNull.Value; } else { objLisApplArr[12].Value = applMain.m_strPatientcardID; } objLisApplArr[13].Value = applMain.m_strApplication_Form_NO; objLisApplArr[14].Value = applMain.m_strOperator_ID; objLisApplArr[15].Value = applMain.m_strAppl_EmpID; objLisApplArr[16].Value = applMain.m_strAppl_DeptID; objLisApplArr[17].Value = applMain.m_strSummary; objLisApplArr[18].Value = applMain.m_intPStatus_int; objLisApplArr[19].Value = applMain.m_intEmergency; objLisApplArr[20].Value = applMain.m_intSpecial; objLisApplArr[21].Value = applMain.m_intForm_int; objLisApplArr[22].Value = applMain.m_strPatient_inhospitalno_chr; objLisApplArr[23].Value = applMain.m_strSampleTypeID; objLisApplArr[24].Value = applMain.m_strSampleType; objLisApplArr[25].Value = applMain.m_strCheckContent; try { DateTime.Parse(applMain.m_strOriginDate); } catch { applMain.m_strOriginDate = CurTime.ToString("yyyy-MM-dd HH:mm:ss"); } objLisApplArr[26].Value = DateTime.Parse(applMain.m_strOriginDate); objLisApplArr[27].Value = applMain.m_strChargeInfo; objLisApplArr[28].Value = applMain.m_strOrderunitrelation; long lngRecEff = -1; lngRes = objHRPSvc.lngExecuteParameterSQL(sql, ref lngRecEff, objLisApplArr); objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().LogError(objEx); throw objEx; } return(lngRes); }
public long m_lngInsertQCReport(IPrincipal p_objPrincipal, clsLisQCReportVO p_objQCReport, out int p_intSeq) { long num = 0L; p_intSeq = -1; clsPrivilegeHandleService handSvc = new clsPrivilegeHandleService(); num = handSvc.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsQCBusiness_Serv", "m_lngInsertQCReport"); long result; clsHRPTableService svc = new clsHRPTableService(); if (num <= 0L) { result = -1L; } else { try { num = 0L; num = svc.m_lngGenerateNewID("T_OPR_LIS_QCREPORT", "QCREPORT_SEQ_INT", out p_intSeq); if (num <= 0L) { result = -1L; return(result); } num = 0L; p_objQCReport.m_dtModify = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); IDataParameter[] insertDataParameterArr = this.GetInsertDataParameterArr(p_objQCReport, p_intSeq); long num2 = -1L; num = 0L; string Sql = @"insert into t_opr_lis_qcreport (qcreport_seq_int, qcbatch_seq_int, qcstatus_int, unmatchedrule_vchr, reason_vchr, process_vchr, summary_vchr, report_dat, reportor_id_chr, status_int, modify_dat, report_stats_int) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "; num = svc.lngExecuteParameterSQL(Sql, ref num2, insertDataParameterArr); if (num > 0L) { p_objQCReport.m_intSeq = p_intSeq; } else { p_intSeq = -1; } } catch (Exception objEx) { new clsLogText().LogError(objEx); } finally { svc.Dispose(); } result = num; } return(result); }
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCRuleVO p_objRule, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCRulesSvc", "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @" INSERT INTO T_BSE_LIS_QCRULES ( RULE_SEQ_INT, RULE_NAME_VCHR, RULE_ALIAS_VCHR, RULE_DESC_VCHR, RULE_FORMULA_VCHR, RULE_SUMMARY_VCHR, RULE_DEFAULTFLAG_INT, RULE_TYPEFLAG_INT ) VALUES ( ?, ? ,? , ?, ?, ?, ?, ?)"; try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_QCRULES", "RULE_SEQ_INT", out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_intSeq, p_objRule.m_strName, p_objRule.m_strAlias, p_objRule.m_strDesc, p_objRule.m_strFormula, p_objRule.m_strSummary, (int)p_objRule.m_enmDefaultflag, (int)p_objRule.m_enmWarnType ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objRule.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long lngInsert(IPrincipal p_objPrincipal, clsBill_VO p_objEntity, out int p_intBillid_int) { long lngRes = -1; p_intBillid_int = -1; clsHRPTableService HRPSvc = new clsHRPTableService(); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsBillSvc", "lngInsert"); if (lngRes < 0) { return(-1); } string strSQL = string.Format( "INSERT INTO t_bse_bill( " + "billid_int,billtype_chr,billno_vchr,status_int,inempid_chr,indatetime_dat,inoprid_chr,inoprdatetime_dat,outempid_chr,outdatetime_dat,outoprid_chr,outoprdatetime_dat,returnempid_chr,returndatetime_dat,returnoprid_chr,returnoprdatetime_dat,useempid_chr,usedatetime_dat,cancelempid_chr,canceldatetime_dat,refempid_chr,refdatetime_dat,note_vchr,totalsum_mny,acctsum_mny,sbsum_mny" + ") VALUES ( " + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?" + ")"); try { int strRecordID = -1; lngRes = HRPSvc.m_lngGenerateNewID("t_bse_bill", "billid_int", out strRecordID); if (lngRes > 0) { IDataParameter[] paramArr = null; HRPSvc.CreateDatabaseParameter(26, out paramArr); paramArr[0].Value = strRecordID; paramArr[1].Value = p_objEntity.Billtype_chr; paramArr[2].Value = p_objEntity.Billno_vchr; paramArr[3].Value = p_objEntity.Status_int; paramArr[4].Value = p_objEntity.Inempid_chr; paramArr[5].Value = p_objEntity.Indatetime_dat; paramArr[6].Value = p_objEntity.Inoprid_chr; paramArr[7].Value = p_objEntity.Inoprdatetime_dat; paramArr[8].Value = p_objEntity.Outempid_chr; paramArr[9].Value = p_objEntity.Outdatetime_dat; paramArr[10].Value = p_objEntity.Outoprid_chr; paramArr[11].Value = p_objEntity.Outoprdatetime_dat; paramArr[12].Value = p_objEntity.Returnempid_chr; paramArr[13].Value = p_objEntity.Returndatetime_dat; paramArr[14].Value = p_objEntity.Returnoprid_chr; paramArr[15].Value = p_objEntity.Returnoprdatetime_dat; paramArr[16].Value = p_objEntity.Useempid_chr; paramArr[17].Value = p_objEntity.Usedatetime_dat; paramArr[18].Value = p_objEntity.Cancelempid_chr; paramArr[19].Value = p_objEntity.Canceldatetime_dat; paramArr[20].Value = p_objEntity.Refempid_chr; paramArr[21].Value = p_objEntity.Refdatetime_dat; paramArr[22].Value = p_objEntity.Note_vchr; paramArr[23].Value = p_objEntity.Totalsum_mny; paramArr[24].Value = p_objEntity.Acctsum_mny; paramArr[25].Value = p_objEntity.Sbsum_mny; long lngRecordsAffected = -1; lngRes = HRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr); HRPSvc.Dispose(); } } catch (Exception objEx) { string strTmp = objEx.Message; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisWorkGroupVO p_objWorkGroup, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @" INSERT INTO T_BSE_LIS_WORKGROUP ( WORKGROUP_SEQ_INT, WORKGROUP_NAME_VCHR, SUMMARY_VCHR, STATUS_INT ) VALUES ( ?, ? ,? , ?)"; try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_WORKGROUP", "WORKGROUP_SEQ_INT", out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_intSeq, p_objWorkGroup.m_strName, p_objWorkGroup.m_strSummary, (int)p_objWorkGroup.m_enmStatus ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objWorkGroup.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngAddNewInputGroup(System.Security.Principal.IPrincipal p_objPrincipal, clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults, out string strID) { long lngRes = 0; strID = null; if (p_objBaseInfo == null) { return(lngRes); } clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngAddNewInputGroup"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL1 = @"INSERT INTO t_bse_lis_input_group VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"; string strSQL2 = @"INSERT INTO t_bse_lis_input_group_detail VALUES (?, ?, ?)"; try { objHRPSvc.m_lngGenerateNewID("t_bse_lis_input_group", "input_group_id_chr", out strID); if (strID == null || strID.Trim() == "") { return(-1); } p_objBaseInfo.m_strINPUT_GROUP_ID_CHR = strID; IDataParameter[] objParamArr1 = null; objHRPSvc.CreateDatabaseParameter(9, out objParamArr1); objParamArr1[0].Value = p_objBaseInfo.m_strAPPLY_UNIT_ID_CHR; objParamArr1[1].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR; objParamArr1[2].Value = p_objBaseInfo.m_strINPUT_GROUP_NAME_VCHR; objParamArr1[3].Value = p_objBaseInfo.m_strSUMMARY_VCHR; objParamArr1[4].Value = p_objBaseInfo.m_strPYCODE_VCHR; objParamArr1[5].Value = p_objBaseInfo.m_strWBCODE_VCHR; objParamArr1[6].Value = p_objBaseInfo.m_strASCODE_VCHR; objParamArr1[7].Value = p_objBaseInfo.m_intSEQUENCE_NUM; objParamArr1[8].Value = p_objBaseInfo.m_intINUSEFLAG_NUM; long lngEff = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL1, ref lngEff, objParamArr1); if (lngRes > 0 && p_objResults != null) { for (int i = 0; i < p_objResults.Length; i++) { IDataParameter[] objParamArr2 = null; objHRPSvc.CreateDatabaseParameter(3, out objParamArr2); objParamArr2[0].Value = strID; objParamArr2[1].Value = p_objResults[i].m_strCHECK_ITEM_ID_CHR; objParamArr2[2].Value = p_objResults[i].m_intSEQUENCE_NUM; lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL2, ref lngEff, objParamArr2); if (lngRes <= 0) { break; } } } if (lngRes <= 0) { System.EnterpriseServices.ContextUtil.SetAbort(); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 lngRes = 0; } return(lngRes); }