/// <summary>
/// 取得欄位值後轉型成Guid。
/// </summary>
/// <param name="row">資料列。</param>
/// <param name="fieldName">欄位名稱。</param>
/// <param name="dataRowVersion">資料列版本。</param>
public static Guid ValueAsGuid(this DataRow row, string fieldName, DataRowVersion dataRowVersion)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CGuid(row[fieldName, dataRowVersion]));
}
return(Guid.Empty);
}
/// <summary>
/// 取得欄位值後轉型成bool。
/// </summary>
/// <param name="row">資料列。</param>
/// <param name="fieldName">欄位名稱。</param>
/// <param name="dataRowVersion">資料列版本。</param>
public static bool ValueAsBool(this DataRow row, string fieldName, DataRowVersion dataRowVersion)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CBool(row[fieldName, dataRowVersion]));
}
return(false);
}
/// <summary>
/// 取得欄位值後轉型成DateTime。
/// </summary>
/// <param name="row">資料列。</param>
/// <param name="fieldName">欄位名稱。</param>
/// <param name="dataRowVersion">資料列版本。</param>
public static DateTime ValueAsDateTime(this DataRow row, string fieldName, DataRowVersion dataRowVersion)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CDateTime(row[fieldName, dataRowVersion]));
}
return(default(DateTime));
}
/// <summary>
/// 取得欄位值後轉型成string。
/// </summary>
/// <param name="row">資料列。</param>
/// <param name="fieldName">欄位名稱。</param>
/// <param name="dataRowVersion">資料列版本。</param>
public static string ValueAsString(this DataRow row, string fieldName, DataRowVersion dataRowVersion)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CStr(row[fieldName, dataRowVersion]));
}
return("");
}
/// <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>
/// 取得欄位值後轉型成float
/// </summary>
/// <param name="row">資料列</param>
/// <param name="fieldName">欄位名稱</param>
/// <returns></returns>
public static float ValueAsFloat(this DataRow row, string fieldName)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CFloat(row[fieldName]));
}
return(0);
}
/// <summary>
/// 取得欄位值後轉型成double
/// </summary>
/// <param name="row">資料列</param>
/// <param name="fieldName">欄位名稱</param>
/// <returns></returns>
public static double ValueAsDouble(this DataRow row, string fieldName)
{
if (BaseFunc.IsNotNull(row) && DataFunc.HasField(row, fieldName))
{
return(BaseFunc.CDouble(row[fieldName]));
}
return(0);
}
/// <summary>
/// 根據來源單指定欄位資料，新增目的單指定欄位資料列
/// </summary>
/// <param name="destTable"></param>
/// <param name="srcTable"></param>
/// <param name="destField"></param>
/// <param name="srcField"></param>
public static void AddSrcTableRow(DataTable destTable, DataTable srcTable, string destField, string srcField)
{
if (DataFunc.HasField(destTable, destField) && DataFunc.HasField(srcTable, srcField))
{
foreach (DataRow row in srcTable.Rows)
{
DataRow newRow = destTable.NewRow();
newRow[destField] = row[srcField].ToString();
destTable.Rows.Add(newRow);
}
}
}
