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