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);
}
