public long m_lngSaverMedicineType(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_MedicineTypeVisionmSet[] objMedicineType) { long lngRes = 0; string strSQL; try { strSQL = @"delete from t_ms_medicinetypevisionmset"; clsHRPTableService objHRPServ = new clsHRPTableService(); objHRPServ.DoExcute(strSQL); if (objMedicineType == null || objMedicineType.Length == 0) { return(1); } strSQL = @"insert into t_ms_medicinetypevisionmset (medicinetypeid_vchr,lotno_int,validperiod_int) values (?,?,?)"; long lngEff = -1; if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objLisAddItemRefArr = null; for (int iOr = 0; iOr < objMedicineType.Length; iOr++) { objHRPServ.CreateDatabaseParameter(3, out objLisAddItemRefArr); objLisAddItemRefArr[0].Value = objMedicineType[iOr].m_strMedicineTypeid; objLisAddItemRefArr[1].Value = objMedicineType[iOr].m_intLotno; objLisAddItemRefArr[2].Value = objMedicineType[iOr].m_intValidperiod; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objLisAddItemRefArr);//往表增加记录 } } else { DbType[] dbTypes = new DbType[] { DbType.String, DbType.Int32, DbType.Int32 }; object[][] objValues = new object[3][]; int intItemCount = objMedicineType.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iOr = 0; iOr < intItemCount; iOr++) { objValues[0][iOr] = objMedicineType[iOr].m_strMedicineTypeid; objValues[1][iOr] = objMedicineType[iOr].m_intLotno; objValues[2][iOr] = objMedicineType[iOr].m_intValidperiod; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
/// <summary> /// 删除选定的盘点药品顺序(无货架) /// </summary> /// <param name="p_objPrincipal"></param> /// <param name="p_objOrderArr"></param> /// <returns></returns> public long m_lngDeleteMedicineOrderWithoutPack(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_CheckMedicineOrderVO[] p_objOrderArr) { if (p_objOrderArr == null || p_objOrderArr.Length == 0) { return(-1); } long lngRes = -1; try { string strSQL = @"delete from t_ms_checkmedicineorder where medicineid_chr = ? and storageid_chr = ?"; clsHRPTableService objHRPServ = new clsHRPTableService(); long lngEff = -1; if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objDPArr = null; for (int iOr = 0; iOr < p_objOrderArr.Length; iOr++) { objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].Value = p_objOrderArr[iOr].m_strMEDICINEID_CHR; objDPArr[1].Value = p_objOrderArr[iOr].m_strSTORAGEID_CHR; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); } } else { DbType[] dbTypes = new DbType[] { DbType.String, DbType.String }; object[][] objValues = new object[2][]; int intItemCount = p_objOrderArr.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iOr = 0; iOr < intItemCount; iOr++) { objValues[0][iOr] = p_objOrderArr[iOr].m_strMEDICINEID_CHR; objValues[1][iOr] = p_objOrderArr[iOr].m_strSTORAGEID_CHR; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngUpdateReasonSort(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_RejectReason[] p_objReason) { if (p_objReason == null || p_objReason.Length == 0) { return(-1); } long lngRes = 0; try { string strSQL = @"update t_ms_rejectreasonset set sortnum_int = ? where reasonid_int = ?"; clsHRPTableService objHRPServ = new clsHRPTableService(); long lngEff = -1; if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objDPArr = null; for (int iID = 0; iID < p_objReason.Length; iID++) { objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].Value = p_objReason[iID].m_intSORTNUM_INT; objDPArr[1].Value = p_objReason[iID].m_intREASONID_INT; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); } } else { DbType[] dbTypes = new DbType[] { DbType.Int32, DbType.Int32 }; object[][] objValues = new object[2][]; int intItemCount = p_objReason.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_objReason[iRow].m_intSORTNUM_INT; objValues[1][iRow] = p_objReason[iRow].m_intREASONID_INT; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } p_objReason = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngAddGrossProfitRateSet(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_GrossProfitRateSet_VO[] p_objRateArr) { if (p_objRateArr == null) { return(-1); } long lngRes = 0; try { string strSQL = @"insert into t_ms_grossprofitrateset (grossprofitrate,medicinetypeid_chr) values (?, ?)"; clsHRPTableService objHRPServ = new clsHRPTableService(); long lngEff = -1; if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objDPArr = null; for (int iRow = 0; iRow < p_objRateArr.Length; iRow++) { objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].Value = p_objRateArr[iRow].m_dblGROSSPROFITRATE; objDPArr[1].Value = p_objRateArr[iRow].m_strMEDICINETYPEID_CHR; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); } } else { DbType[] dbTypes = new DbType[] { DbType.Double, DbType.String }; object[][] objValues = new object[2][]; int intItemCount = p_objRateArr.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_objRateArr[iRow].m_dblGROSSPROFITRATE; objValues[1][iRow] = p_objRateArr[iRow].m_strMEDICINETYPEID_CHR; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngUpdateOrderBeginDate(clsBIHOrder[] m_arrOrder) { long lngRes = 0; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = ""; ArrayList OrderATTACHList = new ArrayList(); try { int n = 0; strSQL = @" update t_opr_bih_order set PostDate_Dat=?, STARTDATE_DAT=? where STATUS_INT in (0,1,5,7) and REGISTERID_CHR=? and RECIPENO_INT=? "; //m_lngUpdateOrderBooking(m_arrOrderBooking[i]); DbType[] dbTypes = new DbType[] { DbType.Date, DbType.Date, DbType.String, DbType.Int32 }; object[][] objValues = new object[4][]; if (m_arrOrder.Length > 0) { for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[m_arrOrder.Length];//初始化 } for (int k1 = 0; k1 < m_arrOrder.Length; k1++) { n = -1; objValues[++n][k1] = m_arrOrder[k1].m_dtPostdate; objValues[++n][k1] = m_arrOrder[k1].m_dtPostdate; objValues[++n][k1] = m_arrOrder[k1].m_strRegisterID; objValues[++n][k1] = m_arrOrder[k1].m_intRecipenNo; } lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngUpdateByArr(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCDataVO[] p_objQCDataArr) { long lngRes = 0; if (p_objQCDataArr == null || p_objQCDataArr.Length <= 0) { return(lngRes); } clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngUpdateByArr"); if (lngRes <= 0) { return(-1); } try { int iCount = p_objQCDataArr.Length; DbType[] m_dbType = new DbType[] { DbType.Int32, DbType.Double, DbType.Int32, DbType.DateTime, DbType.Int32 }; object[][] objValues = new object[m_dbType.Length][]; for (int i = 0; i < objValues.Length; i++) { objValues[i] = new object[iCount]; } clsLisQCDataVO objTemp = null; for (int iRow = 0; iRow < iCount; iRow++) { objTemp = p_objQCDataArr[iRow]; objValues[0][iRow] = objTemp.m_intQCBatchSeq; objValues[1][iRow] = objTemp.m_dlbResult; objValues[2][iRow] = objTemp.m_intConcentrationSeq; objValues[3][iRow] = objTemp.m_datQCDate; objValues[4][iRow] = objTemp.m_intSeq; } clsHRPTableService objHRPServ = new clsHRPTableService(); lngRes = objHRPServ.m_lngSaveArrayWithParameters(m_strUpdateSql, objValues, m_dbType); } catch (Exception objEx) { new clsLogText().LogDetailError(objEx, true); } finally { p_objQCDataArr = null; } return(lngRes); }
public long m_lngAddNewMedStoreSetInfo(System.Security.Principal.IPrincipal p_objPrincipal, ref clsMS_MedicineStoreroom_VO p_objMedicineStoreroom) { if (p_objMedicineStoreroom == null) { return(-1); } long lngRes = 0; try { string strSQL = @" insert into t_ds_medstoreset (medstoreid, medstorename, medicinetypeid_chr) values (?, ?, ?)"; clsHRPTableService objHRPServ = new clsHRPTableService(); DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String }; object[][] objValues = new object[3][]; int intItemCount = p_objMedicineStoreroom.m_strMedicineTypeID_CHR.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int i = 0; i < intItemCount; i++) { objValues[0][i] = p_objMedicineStoreroom.m_strMedicineRoomID_VCHR; objValues[1][i] = p_objMedicineStoreroom.m_strMedicineRoomName_VCHR; objValues[2][i] = p_objMedicineStoreroom.m_strMedicineTypeID_CHR[i]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngUpdateCheckNUM(clsLisApplMainVO[] p_objMainArr, string p_strOperator) { long lngRes = 0; string strSQL = null; clsHRPTableService objHRPSvc = null; DbType[] dbType = new DbType[] { DbType.String, DbType.String, DbType.String }; object[][] objValue = new object[3][]; for (int i = 0; i < objValue.Length; i++) { objValue[i] = new object[p_objMainArr.Length]; } try { strSQL = @"update t_opr_lis_application a set a.application_form_no_chr = ?, a.modify_dat = sysdate, a.operator_id_chr = ? where a.application_id_chr = ? and a.pstatus_int = 2 "; for (int i = 0; i < p_objMainArr.Length; i++) { objValue[0][i] = p_objMainArr[i].m_strApplication_Form_NO; objValue[1][i] = p_strOperator; objValue[2][i] = p_objMainArr[i].m_strAPPLICATION_ID; } objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValue, dbType); } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { objValue = null; objHRPSvc.Dispose(); objHRPSvc = null; } return(lngRes); }
public long m_lngSaveStorageRack(System.Security.Principal.IPrincipal p_objPrincipal, Dictionary <string, string> p_dicStorageRack) { long lngRes = 0; try { string strSQL = @"update t_ds_storage_detail a set a.storagerackid_chr = ? where a.medicineid_chr = ? and a.lotno_vchr = ?"; clsHRPTableService objHRPServ = new clsHRPTableService(); DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String }; object[][] objValues = new object[3][]; int intItemCount = p_dicStorageRack.Count; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } int iRow = 0; foreach (KeyValuePair <string, string> kvp in p_dicStorageRack) { objValues[0][iRow] = kvp.Value; objValues[1][iRow] = kvp.Key.Substring(0, 10); objValues[2][iRow] = kvp.Key.Substring(10); iRow++; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngSaveStorageSet(System.Security.Principal.IPrincipal p_objPrincipal, DataTable p_dtbModify) { long lngRes = 0; try { string strSQL = @"update t_ds_storage a set a.noqtyflag_int = ?,a.ifstop_int = ?,a.storagerackid_chr = ? where a.seriesid_int = ?"; clsHRPTableService objHRPServ = new clsHRPTableService(); DbType[] dbTypes = new DbType[] { DbType.Int16, DbType.Int16, DbType.String, DbType.Int64 }; object[][] objValues = new object[4][]; int intItemCount = p_dtbModify.Rows.Count; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int i1 = 0; i1 < p_dtbModify.Rows.Count; i1++) { objValues[0][i1] = Convert.ToInt16(p_dtbModify.Rows[i1]["noqtyflag_int"].ToString()); objValues[1][i1] = Convert.ToInt16(p_dtbModify.Rows[i1]["ifstop_int"].ToString()); objValues[2][i1] = Convert.ToString(p_dtbModify.Rows[i1]["storagerackid_chr"]); objValues[3][i1] = Convert.ToInt64(p_dtbModify.Rows[i1]["seriesid_int"]); } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngSaveData(System.Security.Principal.IPrincipal p_objPrincipal, string p_strStoreid, clsOutOrInStorageDeptSet[] p_objDeptArr) { long lngRes = 0; string strSQL; try { //if (p_objDeptArr == null || p_objDeptArr.Length == 0) //{ // return lngRes; //} long lngdelEff = -1; strSQL = @"delete from t_aid_outindeptrelation where outstoragedept_chr=?"; clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strStoreid; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngdelEff, objDPArr); if (p_objDeptArr.Length == 0) { objHRPServ.Dispose(); objHRPServ = null; return(lngRes); } strSQL = @"insert into t_aid_outindeptrelation(outstoragedept_chr,instoragedept_chr,orderno_int) values(?,?,?)"; long lngEff = -1; if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objLisAddItemRefArr = null; for (int iOr = 0; iOr < p_objDeptArr.Length; iOr++) { objHRPServ.CreateDatabaseParameter(3, out objLisAddItemRefArr); objLisAddItemRefArr[0].Value = p_strStoreid; objLisAddItemRefArr[1].Value = p_objDeptArr[iOr].strDeptid; objLisAddItemRefArr[2].Value = iOr + 1; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objLisAddItemRefArr);//往表增加记录 } } else { DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String }; object[][] objValues = new object[3][]; int intItemCount = p_objDeptArr.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iOr = 0; iOr < intItemCount; iOr++) { objValues[0][iOr] = p_strStoreid; objValues[1][iOr] = p_objDeptArr[iOr].strDeptid; objValues[2][iOr] = iOr + 1; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngSaverExportdept(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_ExportDept[] p_objExportDeptArr) { long lngRes = 0; string strSQL; try { strSQL = @"delete from t_ms_exportdept"; clsHRPTableService objHRPServ = new clsHRPTableService(); objHRPServ.DoExcute(strSQL); if (p_objExportDeptArr == null || p_objExportDeptArr.Length == 0) { return(1); } strSQL = @"insert into t_ms_exportdept (seriesid_int,exportdept_chr,storageflag_int) values (?,?,?)"; long lngEff = -1; if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objLisAddItemRefArr = null; for (int iOr = 0; iOr < p_objExportDeptArr.Length; iOr++) { objHRPServ.CreateDatabaseParameter(3, out objLisAddItemRefArr); objLisAddItemRefArr[0].Value = p_objExportDeptArr[iOr].m_strSeriesID; objLisAddItemRefArr[1].Value = p_objExportDeptArr[iOr].m_strExportDept; objLisAddItemRefArr[2].Value = p_objExportDeptArr[iOr].m_strFlag; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objLisAddItemRefArr);//往表增加记录 } } else { DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String }; object[][] objValues = new object[3][]; int intItemCount = p_objExportDeptArr.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iOr = 0; iOr < intItemCount; iOr++) { objValues[0][iOr] = p_objExportDeptArr[iOr].m_strSeriesID; objValues[1][iOr] = p_objExportDeptArr[iOr].m_strExportDept; objValues[2][iOr] = p_objExportDeptArr[iOr].m_strFlag; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngAddNewMedicineStoreInfo(System.Security.Principal.IPrincipal p_objPrincipal, ref clsMS_MedicineStoreroom_VO p_objMedicineStoreroom) { if (p_objMedicineStoreroom == null) { return(-1); } long lngRes = 0; try { string strGetMax = @"select max(medicineroomid) maxid from t_ms_medicinestoreroomset"; //2008.5.14 wuchongkun+shortname_chr string strSQL = @"insert into t_ms_medicinestoreroomset (medicineroomid, medicineroomname, medicinetypeid_chr,deptid_chr,shortname_chr) values (?, ?, ?,?,?)"; clsHRPTableService objHRPServ = new clsHRPTableService(); long lngEff = -1; if (string.IsNullOrEmpty(p_objMedicineStoreroom.m_strMedicineRoomID_VCHR)) { DataTable dtbValue = null; lngRes = objHRPServ.lngGetDataTableWithoutParameters(strGetMax, ref dtbValue); if (dtbValue == null || dtbValue.Rows.Count == 0) { p_objMedicineStoreroom.m_strMedicineRoomID_VCHR = "0001"; } else { if (dtbValue.Rows[0][0] == DBNull.Value) { p_objMedicineStoreroom.m_strMedicineRoomID_VCHR = "0001"; } else { p_objMedicineStoreroom.m_strMedicineRoomID_VCHR = (Convert.ToInt32(dtbValue.Rows[0][0]) + 1).ToString("0000"); } } } if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objDPArr = null; for (int i = 0; i < p_objMedicineStoreroom.m_strMedicineTypeID_CHR.Length; i++) { objHRPServ.CreateDatabaseParameter(5, out objDPArr); objDPArr[0].Value = p_objMedicineStoreroom.m_strMedicineRoomID_VCHR; objDPArr[1].Value = p_objMedicineStoreroom.m_strMedicineRoomName_VCHR; objDPArr[2].Value = p_objMedicineStoreroom.m_strMedicineTypeID_CHR[i]; objDPArr[3].Value = p_objMedicineStoreroom.m_strDEPTID_CHR; //+m_strMidicineRommShortName_chr 2008.5.14 wuchongkun objDPArr[4].Value = p_objMedicineStoreroom.m_strMidicineRommShortName_CHR; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); } } else { DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String, DbType.String, DbType.String }; object[][] objValues = new object[5][]; int intItemCount = p_objMedicineStoreroom.m_strMedicineTypeID_CHR.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int i = 0; i < intItemCount; i++) { objValues[0][i] = p_objMedicineStoreroom.m_strMedicineRoomID_VCHR; objValues[1][i] = p_objMedicineStoreroom.m_strMedicineRoomName_VCHR; objValues[2][i] = p_objMedicineStoreroom.m_strMedicineTypeID_CHR[i]; objValues[3][i] = p_objMedicineStoreroom.m_strDEPTID_CHR; //+ wuchongkun.2008.5.14 objValues[4][i] = p_objMedicineStoreroom.m_strMidicineRommShortName_CHR; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngUpdateOrderATTACHTIMES(clsBIHOrder[] m_arrOrder) { long lngRes = 0; ArrayList OrderATTACHList = new ArrayList(); for (int k = 0; k < m_arrOrder.Length; k++) { if (m_arrOrder[k].m_intStatus != 0) { OrderATTACHList.Add(m_arrOrder[k].m_strOrderID); } } if (OrderATTACHList.Count > 0) { int[] intType = new int[] { 0, 1 }; ArrayList TypeList = new ArrayList(intType); bool blnExist = false; lngRes = this.m_lngCheckOrderStatus(OrderATTACHList, TypeList, ref blnExist); if (lngRes < 0 || blnExist == false) { return(-10); } } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = ""; try { int n = 0; strSQL = @" update t_opr_bih_order set ATTACHTIMES_INT=? where REGISTERID_CHR=? and RECIPENO_INT=? "; //m_lngUpdateOrderBooking(m_arrOrderBooking[i]); DbType[] dbTypes = new DbType[] { DbType.Int32, DbType.String, DbType.Int32 }; object[][] objValues = new object[3][]; if (m_arrOrder.Length > 0) { for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[m_arrOrder.Length];//初始化 } for (int k1 = 0; k1 < m_arrOrder.Length; k1++) { n = -1; objValues[++n][k1] = m_arrOrder[k1].m_intATTACHTIMES_INT; objValues[++n][k1] = m_arrOrder[k1].m_strRegisterID; objValues[++n][k1] = m_arrOrder[k1].m_intRecipenNo; } lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long lngInsertReport(System.Security.Principal.IPrincipal p_objPrincipal, int instrumentFlag, System.Collections.Generic.List <clsMBY2010VO> objResultArr, DateTime datReportDate) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsMBY2010Svc", "lngInsertReport"); if (lngRes < 0) { return(-1); } lngRes = 0; clsCheckResult_VO[] objCheckResultVO = null; List <string> strSampleIDArr = null; string strOriginDate = datReportDate.ToString(); //优化查询用 //构造VO this.m_mthContructResultVO(instrumentFlag, objResultArr, out objCheckResultVO, out strSampleIDArr, ref strOriginDate); if (strSampleIDArr.Count > 0) { clsAdvis2120Svc obj = new clsAdvis2120Svc(); obj.m_lngAddCheckResultList(strSampleIDArr, strOriginDate); } if (objCheckResultVO == null || objCheckResultVO.Length == 0) { return(lngRes); } #region 批量插入 string SQL = @"insert into t_opr_lis_check_result(modify_dat, groupid_chr, check_item_id_chr, sample_id_chr, result_vchr, unit_vchr, deviceid_chr, device_check_item_name_vchr, refrange_vchr, check_item_name_vchr, check_item_english_name_vchr, min_val_dec, max_val_dec, abnormal_flag_chr, check_dat, clinicapp_vchr, memo_vchr, confirm_dat, pointliststr_vchr, summary_vchr, graph_img, status_int, checker1_chr, checker2_chr, confirm_person_chr, operator_id_chr, check_deptid_chr, graph_format_name_vchr, is_graph_result_num) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )"; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); DbType[] dbTypes = new DbType[] { DbType.Date, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.Decimal, DbType.Decimal, DbType.String, DbType.Date, DbType.String, DbType.String, DbType.Date, DbType.String, DbType.String, DbType.Binary, DbType.Int16, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.String, DbType.Int16 }; object[][] objValues = new object[29][]; for (int i = 0; i < objValues.Length; i++) { objValues[i] = new object[objCheckResultVO.Length]; } for (int i = 0; i < objCheckResultVO.Length; i++) { if (objCheckResultVO[i] == null) { return(2); } int n = 0; objValues[n++][i] = Convert.ToDateTime(objCheckResultVO[i].m_strModify_Dat); objValues[n++][i] = objCheckResultVO[i].m_strGroupID; objValues[n++][i] = objCheckResultVO[i].m_strCheck_Item_ID; objValues[n++][i] = objCheckResultVO[i].m_strSample_ID; objValues[n++][i] = objCheckResultVO[i].m_strResult; objValues[n++][i] = objCheckResultVO[i].m_strUnit; objValues[n++][i] = objCheckResultVO[i].m_strDeviceID; objValues[n++][i] = objCheckResultVO[i].m_strDevice_Check_Item_Name; objValues[n++][i] = objCheckResultVO[i].m_strRefrange; objValues[n++][i] = objCheckResultVO[i].m_strCheck_Item_Name; objValues[n++][i] = objCheckResultVO[i].m_strCheck_Item_English_Name; objValues[n++][i] = objCheckResultVO[i].m_strMin_Val; objValues[n++][i] = objCheckResultVO[i].m_strMax_Val; objValues[n++][i] = objCheckResultVO[i].m_strAbnormal_Flag; if (objCheckResultVO[i].m_strCheck_Dat == null || objCheckResultVO[i].m_strCheck_Dat.Trim() == "") { objValues[n++][i] = System.DBNull.Value; } else { objValues[n++][i] = System.DateTime.Parse(objCheckResultVO[i].m_strCheck_Dat); } objValues[n++][i] = objCheckResultVO[i].m_strClinicApp; objValues[n++][i] = objCheckResultVO[i].m_strMemo; if (objCheckResultVO[i].m_strConfirm_Dat == null || objCheckResultVO[i].m_strConfirm_Dat.Trim() == "") { objValues[n++][i] = System.DBNull.Value; } else { objValues[n++][i] = System.DateTime.Parse(objCheckResultVO[i].m_strConfirm_Dat); } objValues[n++][i] = objCheckResultVO[i].m_strPointliststr; objValues[n++][i] = objCheckResultVO[i].m_strSummary; objValues[n++][i] = objCheckResultVO[i].m_byaGraph; objValues[n++][i] = objCheckResultVO[i].m_intStatus; objValues[n++][i] = objCheckResultVO[i].m_strChecker1; objValues[n++][i] = objCheckResultVO[i].m_strChecker2; objValues[n++][i] = objCheckResultVO[i].m_strConfirm_Person; objValues[n++][i] = objCheckResultVO[i].m_strOperator_ID; objValues[n++][i] = objCheckResultVO[i].m_strCheck_DeptID; objValues[n++][i] = objCheckResultVO[i].strGraphFormatName; objValues[n++][i] = objCheckResultVO[i].intIsGraphResult; } lngRes = objHRPSvc.m_lngSaveArrayWithParameters(SQL, objValues, dbTypes); objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } #endregion return(lngRes); }
public long m_lngAddNewMedicneTypeSet(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_MedicineTypeSetVO p_objTypeVO) { if (p_objTypeVO == null || p_objTypeVO.m_strMedicineTypeIDArr == null) { return(-1); } long lngRes = 0; try { string strSQL = @"insert into t_ms_medicinetypeset (medicinetypesetid, medicinetypesetname, medicinetypeid_chr) values (?, ?, ?)"; string strGetMax = @"select max(medicinetypesetid) from t_ms_medicinetypeset"; clsHRPTableService objHRPServ = new clsHRPTableService(); long lngEff = -1; if (p_objTypeVO.m_intMedicineTypeSetID <= 0) { DataTable dtbValue = null; lngRes = objHRPServ.lngGetDataTableWithoutParameters(strGetMax, ref dtbValue); if (dtbValue == null || dtbValue.Rows.Count == 0) { p_objTypeVO.m_intMedicineTypeSetID = 1; } else { if (dtbValue.Rows[0][0] == DBNull.Value) { p_objTypeVO.m_intMedicineTypeSetID = 1; } else { p_objTypeVO.m_intMedicineTypeSetID = Convert.ToInt32(dtbValue.Rows[0][0]) + 1; } } } if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle) { IDataParameter[] objDPArr = null; for (int i = 0; i < p_objTypeVO.m_strMedicineTypeIDArr.Length; i++) { objHRPServ.CreateDatabaseParameter(3, out objDPArr); objDPArr[0].Value = p_objTypeVO.m_intMedicineTypeSetID; objDPArr[1].Value = p_objTypeVO.m_strMedicineTypeSetName; objDPArr[2].Value = p_objTypeVO.m_strMedicineTypeIDArr[i]; lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); } } else { DbType[] dbTypes = new DbType[] { DbType.Int32, DbType.String, DbType.String }; object[][] objValues = new object[3][]; int intItemCount = p_objTypeVO.m_strMedicineTypeIDArr.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int i = 0; i < intItemCount; i++) { objValues[0][i] = p_objTypeVO.m_intMedicineTypeSetID; objValues[1][i] = p_objTypeVO.m_strMedicineTypeSetName; objValues[2][i] = p_objTypeVO.m_strMedicineTypeIDArr[i]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } p_objTypeVO = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngSetApplPrintedStatus(string[] arrApplicationId, bool isPrinted) { // long lngRes=0; // StringBuilder sb=new StringBuilder(); // int len= arrApplicationId.Length; // for (int i = 0; i <len; i++) // { // if (i != len - 1) // { // sb.Append(arrApplicationId[i] + " ,"); // } // else // { // sb.Append(arrApplicationId[i]); // } // } // string sqlFormat = @" update t_opr_lis_application // set printed_num = {0} // where pstatus_int = 2 // and application_id_chr in ( {1} ) "; // clsHRPTableService dbSvc = new clsHRPTableService(); // try // { // lngRes = dbSvc.DoExcute(string.Format(sqlFormat, isPrinted ? "1" : "0", sb.ToString())); // } // catch (Exception ex) // { // lngRes = 0; // new clsLogText().LogError(ex.Message); // } // return lngRes; long lngRes = 1; int n = -1; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { n = 0; if (isPrinted) { string strSQL = @"update t_opr_lis_application set printed_num = 1, printed_date = sysdate where pstatus_int > 0 and application_id_chr = ?"; DbType[] dbTypes = new DbType[] { DbType.String }; object[][] objValues = new object[1][]; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[arrApplicationId.Length];//初始化 } for (int k1 = 0; k1 < arrApplicationId.Length; k1++) { n = -1; objValues[++n][k1] = arrApplicationId[k1].Trim(); } if (arrApplicationId.Length > 0) { lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } // strSQL = @" // update t_opr_lis_application // set printed_num = 1 // where pstatus_int = 2 // and application_id_chr =? "; // dbTypes = new DbType[] { // DbType.String // }; // objValues = new object[1][]; // for (int j = 0; j < objValues.Length; j++) // { // objValues[j] = new object[arrApplicationId.Length];//初始化 // } // for (int k1 = 0; k1 < arrApplicationId.Length; k1++) // { // n = -1; // objValues[++n][k1] = arrApplicationId[k1].Trim(); // } // if (arrApplicationId.Length > 0) // { // lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); // } } else { string strSQL = @" update t_opr_lis_application set PRINTED_DATE = null,printed_num = 0 where pstatus_int = 2 and application_id_chr =? "; DbType[] dbTypes = new DbType[] { DbType.String }; object[][] objValues = new object[1][]; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[arrApplicationId.Length];//初始化 } for (int k1 = 0; k1 < arrApplicationId.Length; k1++) { n = -1; objValues[++n][k1] = arrApplicationId[k1].Trim(); } if (arrApplicationId.Length > 0) { lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngUpdateOrderAmount(clsBIHOrder[] m_arrOrder) { long lngRes = 0; ArrayList OrderATTACHList = new ArrayList(); for (int k = 0; k < m_arrOrder.Length; k++) { if (m_arrOrder[k].m_intStatus != 0) { OrderATTACHList.Add(m_arrOrder[k].m_strOrderID); } } if (OrderATTACHList.Count > 0) { int[] intType = new int[] { 0, 1, 5 };//0新开 1 提交 2 转抄 ArrayList TypeList = new ArrayList(intType); bool blnExist = false; lngRes = this.m_lngCheckOrderStatus(OrderATTACHList, TypeList, ref blnExist); if (lngRes < 1 || blnExist == false) { return(-10); } } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = ""; try { int n = 0; strSQL = @" update t_opr_bih_order set GET_DEC=? where REGISTERID_CHR=? and RECIPENO_INT=? "; //m_lngUpdateOrderBooking(m_arrOrderBooking[i]); DbType[] dbTypes = new DbType[] { DbType.Decimal, DbType.String, DbType.Int32 }; object[][] objValues = new object[3][]; if (m_arrOrder.Length > 0) { for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[m_arrOrder.Length];//初始化 } for (int k1 = 0; k1 < m_arrOrder.Length; k1++) { n = -1; objValues[++n][k1] = m_arrOrder[k1].m_dmlGet; objValues[++n][k1] = m_arrOrder[k1].m_strRegisterID; objValues[++n][k1] = m_arrOrder[k1].m_intRecipenNo; } lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); } strSQL = @" update T_OPR_BIH_ORDERCHARGEDEPT a set a.amount_dec=(select b.get_dec from t_opr_bih_order b where b.orderid_chr=?) where a.flag_int=0 and ORDERID_CHR=? "; DbType[] dbTypes2 = new DbType[] { DbType.String, DbType.String }; object[][] objValues2 = new object[2][]; if (m_arrOrder.Length > 0) { for (int j = 0; j < objValues2.Length; j++) { objValues2[j] = new object[m_arrOrder.Length];//初始化 } for (int k1 = 0; k1 < m_arrOrder.Length; k1++) { n = -1; objValues2[++n][k1] = m_arrOrder[k1].m_strOrderID; objValues2[++n][k1] = m_arrOrder[k1].m_strOrderID; } lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValues2, dbTypes2); } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngSetAccount(System.Security.Principal.IPrincipal p_objPrincipal, string p_strEmpID, DateTime p_dtmAccountDate, string[] p_strChittyIDArr, string p_strStorageID) { if (p_strChittyIDArr == null || p_strChittyIDArr.Length == 0) { return(-1); } long lngRes = 0; try { string strSQL = @"update t_ds_instorage a set a.inaccount_dat=? ,a.inaccounterid_chr=? where a.indrugstoreid_vchr=?"; clsHRPTableService objHRPServ = new clsHRPTableService(); DbType[] dbTypes = new DbType[] { DbType.DateTime, DbType.String, DbType.String }; object[][] objValues = new object[3][]; int intItemCount = p_strChittyIDArr.Length; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_dtmAccountDate; objValues[1][iRow] = p_strEmpID; objValues[2][iRow] = p_strChittyIDArr[iRow]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); if (lngRes < 0) { objHRPServ.Dispose(); objHRPServ = null; throw new Exception(); } strSQL = @"update t_ds_outstorage a set a.inaccount_dat=? ,a.inaccounterid_chr=? where a.outdrugstoreid_vchr=?"; dbTypes = new DbType[] { DbType.DateTime, DbType.String, DbType.String }; objValues = new object[3][]; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_dtmAccountDate; objValues[1][iRow] = p_strEmpID; objValues[2][iRow] = p_strChittyIDArr[iRow]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); if (lngRes < 0) { objHRPServ.Dispose(); objHRPServ = null; throw new Exception(); } strSQL = @"update t_ds_drugstorecheck a set a.inaccountdate_dat=? ,a.inaccountid_chr=? where a.checkid_chr=?"; dbTypes = new DbType[] { DbType.DateTime, DbType.String, DbType.String }; objValues = new object[3][]; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_dtmAccountDate; objValues[1][iRow] = p_strEmpID; objValues[2][iRow] = p_strChittyIDArr[iRow]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); if (lngRes < 0) { objHRPServ.Dispose(); objHRPServ = null; throw new Exception(); } strSQL = @"update t_ds_adjustprice a set a.inaccountdate_dat=? ,a.inaccountid_chr=? where a.adjustpriceid_vchr=?"; dbTypes = new DbType[] { DbType.DateTime, DbType.String, DbType.String }; objValues = new object[3][]; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_dtmAccountDate; objValues[1][iRow] = p_strEmpID; objValues[2][iRow] = p_strChittyIDArr[iRow]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); if (lngRes < 0) { objHRPServ.Dispose(); objHRPServ = null; throw new Exception(); } strSQL = @"update t_ds_initial a set a.inaccounterid_chr=? where a.initialid_chr=?"; dbTypes = new DbType[] { DbType.String, DbType.String }; objValues = new object[2][]; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_strEmpID; objValues[1][iRow] = p_strChittyIDArr[iRow]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); if (lngRes < 0) { objHRPServ.Dispose(); objHRPServ = null; throw new Exception(); } strSQL = @"update t_ds_account_detail a set a.state_int = 1, a.inaccountdate_dat = ?, a.inaccountid_chr = ? where a.chittyid_vchr = ?"; dbTypes = new DbType[] { DbType.DateTime, DbType.String, DbType.String }; objValues = new object[3][]; for (int j = 0; j < objValues.Length; j++) { objValues[j] = new object[intItemCount];//初始化 } for (int iRow = 0; iRow < intItemCount; iRow++) { objValues[0][iRow] = p_dtmAccountDate; objValues[1][iRow] = p_strEmpID; objValues[2][iRow] = p_strChittyIDArr[iRow]; } lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes); if (lngRes <= 0) { objHRPServ.Dispose(); objHRPServ = null; throw new Exception(); } objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngModiffyAppStatus(com.digitalwave.iCare.ValueObject.clsOutpatientRecipe_VO[] objRecipeVO) { //foreach (KeyValuePair<string, string> kvp in p_dicApp) //{ // if (kvp.Value.ToString() == "lis") // { // this.m_lngModiffyLisAppStatus(p_Recipe, kvp.Key.ToString()); // } // if (kvp.Value.ToString() == "test") // { // this.m_lngModiffyTestAppStatus(p_Recipe, kvp.Key.ToString()); // } // if (kvp.Value.ToString() == "ops") // { // this.m_lngModiffyOpsAppStatus(p_Recipe, kvp.Key.ToString()); // } //} long lngRes = -1; string strSQL = string.Empty; long lngEff = -1; strSQL = @"insert into t_opr_itemconfirm (outpatrecipedeid_chr, outpatrecipeid_chr, empno_vchr,record_dat,status_int) values ( ?, ?, ?, sysdate, 1)"; clsHRPTableService objHRPSvc = null; try { int intRowsCount = objRecipeVO.Length; object[][] objParams = new object[3][]; for (int i1 = 0; i1 < 3; i1++) { objParams[i1] = new object[intRowsCount]; } for (int i1 = 0; i1 < intRowsCount; i1++) { objParams[0][i1] = objRecipeVO[i1].m_strOutpatRecipeID.Trim(); objParams[1][i1] = objRecipeVO[i1].m_strOutpatRecipeNo.Trim(); objParams[2][i1] = objRecipeVO[i1].strDIAG_VCHR.Trim(); } DbType[] objTypes = new DbType[3] { DbType.String, DbType.String, DbType.String }; objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objParams, objTypes); } catch (Exception objEX) { clsLogText objLog = new clsLogText(); objLog.LogError(objEX); } finally { if (objHRPSvc != null) { objHRPSvc.Dispose(); objHRPSvc = null; } } return(lngRes); }