/// <summary>
/// 取得欄位值後轉型成double。
/// </summary>
/// <param name="row">資料列。</param>
/// <param name="fieldName">欄位名稱。</param>
/// <param name="dataRowVersion">資料列版本。</param>
public static double ValueAsDouble(this DataRow row, string fieldName, DataRowVersion dataRowVersion)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CDouble(row[fieldName, dataRowVersion]));
}
return(0);
}
/// <summary>
/// 取得指定名稱的雙精確浮點數
/// </summary>
/// <param name="source"></param>
/// <param name="propertyName"></param>
/// <returns></returns>
public static double TokenAsDouble(this JObject source, string propertyName)
{
var value = source.TokenValue(propertyName);
if (BaseFunc.IsNull(value))
{
return(0);
}
else
{
return(BaseFunc.CDouble(value.ToString()));
}
}
/// <summary>
/// 計算欄位值總和
/// </summary>
/// <param name="rows">取值計算的資料列陣列。</param>
/// <param name="fieldName">欄位名稱。</param>
public static double SumFieldValues(IEnumerable <DataRow> rows, string fieldName)
{
double sum = 0;
foreach (var r in rows)
{
if (r.RowState != DataRowState.Deleted && HasField(r, fieldName))
{
sum += BaseFunc.CDouble(r[fieldName]);
}
}
return(sum);
}
/// <summary>
/// 計算欄位值總和
/// </summary>
/// <param name="table">取值計算的資料表。</param>
/// <param name="fieldName">欄位名稱。</param>
public static double SumFieldValues(DataTable table, string fieldName)
{
double sum = 0;
if (!IsEmpty(table, false) && HasField(table, fieldName))
{
foreach (DataRow row in table.Rows)
{
if (row.RowState != DataRowState.Deleted)
{
sum += BaseFunc.CDouble(row[fieldName]);
}
}
}
return(sum);
}
/// <summary>
/// 計算欄位值總和
/// </summary>
/// <param name="row">取值計算的資料列。</param>
/// <param name="fieldNames">欄位名稱陣列。</param>
public static double SumFieldValues(DataRow row, params string[] fieldNames)
{
double sum = 0;
if (BaseFunc.IsNull(row))
{
return(sum);
}
foreach (var fieldName in fieldNames)
{
if (row.RowState != DataRowState.Deleted && HasField(row, fieldName))
{
sum += BaseFunc.CDouble(row[fieldName]);
}
}
return(sum);
}
/// <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);
}
}
/// <summary>
/// 取得指定名稱的參數值，並轉型為雙精度浮點數。
/// </summary>
/// <param name="name">參數名稱。</param>
public double GetParameterAsDouble(string name)
{
return(BaseFunc.CDouble(GetParameterValue(name, 0)));
}