private void AssignOutputValuesToInstance(CommandMapping cmdMap, SqlCommand currentCmd, ref PersistableObject persistObject)
{
Type objType;
PropertyInfo prop;
objType = persistObject.GetType();
SqlParameter curParam;
foreach (CommandParameter cmdParameter in cmdMap.Parameters)
{
if ((cmdParameter.RealParameterDirection == ParameterDirection.InputOutput) ||
(cmdParameter.RealParameterDirection == ParameterDirection.ReturnValue) ||
(cmdParameter.RealParameterDirection == ParameterDirection.Output))
{
curParam = currentCmd.Parameters[cmdParameter.ParameterName];
prop = objType.GetProperty(cmdParameter.ClassMember);
if (prop != null)
{
if (curParam.Value != DBNull.Value) //如果传出参数的值不为空
{
prop.SetValue(persistObject, curParam.Value, null); //为当前属性设置值
}
}
}
}
}
private void AssignValuesToParameters(CommandMapping cmdMap, ref SqlCommand currentCmd, PersistableObject persistObject)
{
Type objType;
PropertyInfo prop;
objType = persistObject.GetType();
foreach (CommandParameter cmdParameter in cmdMap.Parameters)
{
if ((cmdParameter.RealParameterDirection == ParameterDirection.Input) ||
(cmdParameter.RealParameterDirection == ParameterDirection.InputOutput))
{
prop = objType.GetProperty(cmdParameter.ClassMember); //得到objType类型中属性名为cmdParameter.ClassMember的一个属性对象
currentCmd.Parameters[cmdParameter.ParameterName].Value = prop.GetValue(persistObject, null); //将persistObject对象中prop所表示的属性的值作为当前sql command对象所对应的参数的值
}
}
}
