/// <summary>
/// 取得欄位值後轉型成decimal。
/// </summary>
/// <param name="row">資料列。</param>
/// <param name="fieldName">欄位名稱。</param>
/// <param name="dataRowVersion">資料列版本。</param>
public static decimal ValueAsDecimal(this DataRow row, string fieldName, DataRowVersion dataRowVersion)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CDecimal(row[fieldName, dataRowVersion]));
}
return(0);
}
/// <summary>
/// 依欄位資料型別設定欄位值
/// </summary>
/// <param name="dbType"></param>
/// <param name="fieldValue"></param>
/// <returns></returns>
public static object SetFieldValue(EFieldDbType dbType, object fieldValue)
{
object result = null;
switch (dbType)
{
case EFieldDbType.String:
case EFieldDbType.Text:
result = BaseFunc.CStr(fieldValue);
break;
case EFieldDbType.Boolean:
result = BaseFunc.CBool(fieldValue);
break;
case EFieldDbType.Integer:
result = BaseFunc.CInt(fieldValue);
break;
case EFieldDbType.Double:
result = BaseFunc.CDouble(fieldValue);
break;
case EFieldDbType.Currency:
result = BaseFunc.CDecimal(fieldValue);
break;
case EFieldDbType.DateTime:
result = BaseFunc.CDateTime(fieldValue);
break;
case EFieldDbType.GUID:
result = Guid.Parse(fieldValue.ToString());
break;
default:
result = fieldValue;
break;
}
return(result);
}
/// <summary>
/// 將傳入值轉型為指定欄位資料型別。
/// </summary>
/// <param name="fieldDbType">欄位資料型別。</param>
/// <param name="value">傳入值。</param>
public static object CFieldValue(EFieldDbType fieldDbType, object value)
{
switch (fieldDbType)
{
case EFieldDbType.String:
return(BaseFunc.CStr(value).Trim()); // 去除左右空白
case EFieldDbType.Text:
return(BaseFunc.CStr(value).Trim()); // 去除左右空白
case EFieldDbType.Boolean:
return(BaseFunc.CBool(value));
case EFieldDbType.Integer:
return(BaseFunc.CInt(value));
case EFieldDbType.Double:
return(BaseFunc.CDouble(value));
case EFieldDbType.Currency:
return(BaseFunc.CDecimal(value));
case EFieldDbType.DateTime:
if (BaseFunc.IsDBNull(value))
{
return(value);
}
else
{
return(BaseFunc.CDateTime(value));
}
case EFieldDbType.GUID:
return(BaseFunc.CGuid(value));
default:
return(value);
}
}