private long m_lngUpdateProperty(clsUnitProperty_VO p_objVO) { long lngRes = 0; string strSQL = @"UPDATE t_aid_lis_unit_property SET PROPERTY_NAME_VCHR = ?,SUMMARY_VCHR = ?, PROPERTY_PRIORITY_NUM = ?,INUSE_FLAG_NUM = ? WHERE PROPERTY_ID_CHR = ?" ; try { System.Data.IDataParameter[] objDPArr = null; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(5, out objDPArr); objDPArr[0].Value = p_objVO.m_strPROPERTY_NAME_VCHR; objDPArr[1].Value = p_objVO.m_strSUMMARY_VCHR; objDPArr[2].Value = p_objVO.m_intPROPERTY_PRIORITY_NUM; objDPArr[3].Value = p_objVO.m_intINUSE_FLAG_NUM; objDPArr[4].Value = p_objVO.m_strPROPERTY_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 void m_mthInitProperty(clsUnitProperty_VO p_objProperty, clsUnitPropertyValue_VO[] p_objPropertyValueList) { this.m_lsvValue.Items.Clear(); this.m_cboValue.Items.Clear(); this.m_txtProperty.Text = p_objProperty.m_strPROPERTY_NAME_VCHR; this.m_txtProperty.Tag = p_objProperty; this.m_cboValue.Items.AddRange(p_objPropertyValueList); }
public long m_lngGetAllUnitPropertyAndDetail(System.Security.Principal.IPrincipal p_objPrincipal, out clsUnitProperty_VO[] p_objPropertyArr, out clsUnitPropertyValue_VO[] p_objValueArr) { long lngRes = 0; p_objPropertyArr = null; p_objValueArr = null; string strSQL1 = @"SELECT * FROM t_aid_lis_unit_property ORDER BY inuse_flag_num DESC, property_priority_num "; string strSQL2 = @"SELECT * FROM t_aid_lis_unit_property_value"; try { DataTable dtbData = new DataTable(); clsVOConstructor objVOConstructor = new clsVOConstructor(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL1, ref dtbData); if (lngRes > 0 && dtbData != null) { p_objPropertyArr = new clsUnitProperty_VO[dtbData.Rows.Count]; for (int i = 0; i < dtbData.Rows.Count; i++) { p_objPropertyArr[i] = objVOConstructor.m_objConstructUnitPropertyVO(dtbData.Rows[i]); } lngRes = 0; dtbData = new DataTable(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL2, ref dtbData); if (lngRes > 0 && dtbData != null) { p_objValueArr = new clsUnitPropertyValue_VO[dtbData.Rows.Count]; for (int j = 0; j < dtbData.Rows.Count; j++) { p_objValueArr[j] = objVOConstructor.m_objConstructUnitPropertyValueVO(dtbData.Rows[j]); } } } if (lngRes <= 0) { p_objPropertyArr = null; p_objValueArr = null; } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 } return(lngRes); }
public clsUnitProperty_VO m_objConstructUnitPropertyVO(System.Data.DataRow p_objRow) { clsUnitProperty_VO objVO = new clsUnitProperty_VO(); try { objVO.m_intINUSE_FLAG_NUM = int.Parse(p_objRow["INUSE_FLAG_NUM"].ToString()); objVO.m_intPROPERTY_PRIORITY_NUM = int.Parse(p_objRow["PROPERTY_PRIORITY_NUM"].ToString()); objVO.m_strPROPERTY_ID_CHR = p_objRow["PROPERTY_ID_CHR"].ToString().Trim(); objVO.m_strPROPERTY_NAME_VCHR = p_objRow["PROPERTY_NAME_VCHR"].ToString().Trim(); objVO.m_strSUMMARY_VCHR = p_objRow["SUMMARY_VCHR"].ToString().Trim(); } catch { objVO = null; } return(objVO); }
private long m_lngAddProperty(clsUnitProperty_VO p_objVO) { long lngRes = 0; string strSQL = @"INSERT INTO t_aid_lis_unit_property(PROPERTY_ID_CHR, PROPERTY_NAME_VCHR,SUMMARY_VCHR,PROPERTY_PRIORITY_NUM,INUSE_FLAG_NUM) VALUES (?, ?, ?, ?, ?)" ; try { System.Data.IDataParameter[] objDPArr = null; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(5, out objDPArr); string strNewID = null; objHRPSvc.m_lngGenerateNewID("t_aid_lis_unit_property", "PROPERTY_ID_CHR", out strNewID); if (strNewID == null || strNewID == "") { throw new Exception("不能分配ID"); } p_objVO.m_strPROPERTY_ID_CHR = strNewID; objDPArr[0].Value = p_objVO.m_strPROPERTY_ID_CHR; objDPArr[1].Value = p_objVO.m_strPROPERTY_NAME_VCHR; objDPArr[2].Value = p_objVO.m_strSUMMARY_VCHR; objDPArr[3].Value = p_objVO.m_intPROPERTY_PRIORITY_NUM; objDPArr[4].Value = p_objVO.m_intINUSE_FLAG_NUM; 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); }