46 lines
1.5 KiB
C#
46 lines
1.5 KiB
C#
using System.Data;
|
|
using System.Text;
|
|
|
|
namespace YLErp.Helpers
|
|
{
|
|
public static class DataTableHelper
|
|
{
|
|
public static string ToStringContent(this DataTable dataTable)
|
|
{
|
|
if (!IsNotEmpty(dataTable)) return string.Empty;
|
|
var stringContent = new StringBuilder();
|
|
foreach (DataRow row in dataTable.Rows)
|
|
{
|
|
for (int i = 0; i < dataTable.Columns.Count; i++)
|
|
{
|
|
stringContent.Append(dataTable.Columns[i].ColumnName + ":" + row[i].ToString().Trim());
|
|
stringContent.Append(i == dataTable.Columns.Count - 1 ? "\r\n" : "\t");
|
|
}
|
|
}
|
|
var result = stringContent.ToString();
|
|
return result;
|
|
}
|
|
|
|
public static bool IsNotEmpty(this DataTable dataTable)
|
|
{
|
|
if (dataTable != null && dataTable.Rows.Count > 0)
|
|
return true;
|
|
else
|
|
return false;
|
|
}
|
|
|
|
public static string ToStringContent(this IDataReader dr)
|
|
{
|
|
if (dr == null) return string.Empty;
|
|
var stringContent = new StringBuilder();
|
|
for (int i = 0; i < dr.FieldCount; i++)
|
|
{
|
|
stringContent.Append(dr.GetName(i) + ":" + (dr.IsDBNull(i) ? "" : dr.GetValue(i)));
|
|
stringContent.Append(i == dr.FieldCount - 1 ? "\r\n" : "\t");
|
|
}
|
|
var result = stringContent.ToString();
|
|
return result;
|
|
}
|
|
}
|
|
}
|