public long m_lngGetMedicineTypeData(System.Security.Principal.IPrincipal p_objPrincipal, out clsValue_MedicineType_VO[] p_objData) { p_objData = new clsValue_MedicineType_VO[0]; long lngRes = 0; //权限控制,clsPrivilegeHandleService为权限处理服务类 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.MedicineStoreService.clsStorageRacksetSVC", "m_lngGetMedicineTypeData"); if (lngRes < 0) { return(-1); } //创建COM对象 com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"select medicinetypeid_chr,medicinetypename_vchr from t_aid_medicinetype order by medicinetypeid_chr asc"; DataTable dtbResult = new DataTable(); try { lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); if (lngRes > 0 && dtbResult != null) { p_objData = new clsValue_MedicineType_VO[dtbResult.Rows.Count]; DataRow m_drDataRow = null; clsValue_MedicineType_VO tmp_p_objData = null; for (int i1 = 0; i1 < dtbResult.Rows.Count; i1++) { tmp_p_objData = new clsValue_MedicineType_VO(); m_drDataRow = dtbResult.Rows[i1]; tmp_p_objData.m_strMedicineTypeID = m_drDataRow["medicinetypeid_chr"].ToString(); tmp_p_objData.m_strMedicineTypeName = m_drDataRow["medicinetypename_vchr"].ToString(); p_objData[i1] = tmp_p_objData; } m_drDataRow = null; } objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } objHRPSvc.Dispose(); return(lngRes); }
public long m_lngGetMedicineTypeData(System.Security.Principal.IPrincipal p_objPrincipal, out clsValue_MedicineType_VO[] p_objData) { p_objData = new clsValue_MedicineType_VO[0]; long lngRes = 0; //权限控制,clsPrivilegeHandleService为权限处理服务类 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddleTier_StorageDetailQuerySVC", "m_lngGetStorageDetailData"); if (lngRes < 0) { return(-1); } //创建COM对象 com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"select b.medicineroomid, a.medicinetypeid_chr, a.medicinetypename_vchr, c.medicinetypesetid, c.medicinetypesetname from t_aid_medicinetype a inner join t_ms_medicinestoreroomset b on a.medicinetypeid_chr = b.medicinetypeid_chr inner join t_ms_medicinetypeset c on a.medicinetypeid_chr = c.medicinetypeid_chr order by c.medicinetypesetid asc"; // string strSQL = @"select // b.medicineroomid, // a.medicinetypeid_chr, // a.medicinetypename_vchr from t_aid_medicinetype a // inner join t_ms_medicinestoreroomset b // on a.medicinetypeid_chr=b.medicinetypeid_chr // order by a.medicinetypeid_chr asc"; DataTable dtbResult = new DataTable(); try { lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); if (lngRes > 0 && dtbResult != null) { p_objData = new clsValue_MedicineType_VO[dtbResult.Rows.Count]; DataRow m_drDataRow = null; clsValue_MedicineType_VO tmp_p_objData = null; for (int i1 = 0; i1 < dtbResult.Rows.Count; i1++) { tmp_p_objData = new clsValue_MedicineType_VO(); m_drDataRow = dtbResult.Rows[i1]; tmp_p_objData.m_strMedicineRoomID = m_drDataRow["medicineroomid"].ToString(); tmp_p_objData.m_strMedicineTypeID = m_drDataRow["medicinetypeid_chr"].ToString(); tmp_p_objData.m_strMedicineTypeName = m_drDataRow["medicinetypename_vchr"].ToString(); tmp_p_objData.m_strMedicineTypesetID = m_drDataRow["MedicineTypesetID"].ToString(); tmp_p_objData.m_strMedicineTypesetName = m_drDataRow["MedicineTypesetName"].ToString(); //p_objData[i1].m_strMedicineRoomID = dtbResult.Rows[i1]["medicineroomid"].ToString(); //p_objData[i1].m_strMedicineTypeID = dtbResult.Rows[i1]["medicinetypeid_chr"].ToString(); //p_objData[i1].m_strMedicineTypeName = dtbResult.Rows[i1]["medicinetypename_vchr"].ToString(); p_objData[i1] = tmp_p_objData; }//for m_drDataRow = null; } objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } objHRPSvc.Dispose(); return(lngRes); }