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