private long m_lngAddRelate(clsUnitPropertyRelate_VO p_objVO)
{
long lngRes = 0;
string strSQL = @"INSERT INTO t_aid_lis_unit_propert_relate
(APPLY_UNIT_ID_CHR, UNIT_PROPERTY_ID_CHR,
PRIORITY_NUM,VALUE_ID_CHR
)
VALUES (?, ?,?,?)" ;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objDPArr = null;
objHRPSvc.CreateDatabaseParameter(4, out objDPArr);
objDPArr[0].Value = p_objVO.m_strAPPLY_UNIT_ID_CHR;
objDPArr[1].Value = p_objVO.m_strUNIT_PROPERTY_ID_CHR;
objDPArr[2].Value = p_objVO.m_intPRIORITY_NUM;
objDPArr[3].Value = p_objVO.m_strVALUE_ID_CHR;
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);
}
public long m_lngGetRelatesByUnitID(System.Security.Principal.IPrincipal p_objPrincipal,
string p_strApplyUnitID, out clsUnitPropertyRelate_VO[] p_objVOArr)
{
long lngRes = 0;
p_objVOArr = null;
string strSQL = @"SELECT r.*
FROM t_aid_lis_unit_propert_relate r,
t_aid_lis_unit_property p,
t_aid_lis_unit_property_value v
where r.UNIT_PROPERTY_ID_CHR = p.property_id_chr
and r.VALUE_ID_CHR = v.vlaue_id_chr
and p.inuse_flag_num = 1
and v.inuse_flag_num = 1
and r.APPLY_UNIT_ID_CHR = ?
order by r.unit_property_id_chr, PRIORITY_NUM
" ;
try
{
System.Data.IDataParameter[] objDPArr = null;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
objHRPSvc.CreateDatabaseParameter(1, out objDPArr);
objDPArr[0].Value = p_strApplyUnitID;
DataTable dtbResult = new DataTable();
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr);
if (lngRes > 0 && dtbResult != null)
{
clsVOConstructor objVOConstructor = new clsVOConstructor();
int intCount = dtbResult.Rows.Count;
p_objVOArr = new clsUnitPropertyRelate_VO[intCount];
for (int i = 0; i < intCount; i++)
{
p_objVOArr[i] = objVOConstructor.m_objConstructUnitPropertyRelateVO(dtbResult.Rows[i]);
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
throw objEx;
}
return(lngRes);
}
public void m_mthAddValue(clsUnitPropertyRelate_VO p_objValue)
{
foreach (clsUnitPropertyValue_VO objValueVO in this.m_cboValue.Items)
{
if (objValueVO.m_strVALUE_ID_CHR == p_objValue.m_strVALUE_ID_CHR)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = objValueVO.m_strVLAUE_VCHR;
lvi.Tag = objValueVO;
this.m_lsvValue.Items.Add(lvi);
break;
}
}
}
public clsUnitPropertyRelate_VO m_objConstructUnitPropertyRelateVO(System.Data.DataRow p_objRow)
{
clsUnitPropertyRelate_VO objVO = new clsUnitPropertyRelate_VO();
try
{
objVO.m_strAPPLY_UNIT_ID_CHR = p_objRow["APPLY_UNIT_ID_CHR"].ToString();
objVO.m_strUNIT_PROPERTY_ID_CHR = p_objRow["UNIT_PROPERTY_ID_CHR"].ToString();
objVO.m_strVALUE_ID_CHR = p_objRow["VALUE_ID_CHR"].ToString();
objVO.m_intPRIORITY_NUM = int.Parse(p_objRow["PRIORITY_NUM"].ToString());
}
catch
{
objVO = null;
}
return(objVO);
}
