/// <summary>
/// 获得指定列查重后组成的SQL中In格式的字符串,按指定长度分组
/// </summary>
/// <param name="dt"></param>
/// <param name="ColumnName"></param>
/// <param name="?"></param>
/// <param name="MaxLength"></param>
/// <returns></returns>
public static IEnumerable <string> FormatGroupInValue(this DataTable dt, string ColumnName, int MaxLength)
{
return(CommonFormatStrTools.GetDataTableColValueFormatGroupIn(dt, ColumnName, MaxLength));
}
/// <summary>
/// 获得指定列查重后组成的字符串[指定分隔符]
/// </summary>
/// <param name="dt"></param>
/// <param name="ColumnName"></param>
/// <param name="Split"></param>
/// <returns></returns>
public static string FormatStrValue(this DataTable dt, string ColumnName, string Split)
{
return(CommonFormatStrTools.GetDataTableColValueFormatStr(dt, ColumnName, Split));
}
/// <summary>
/// 获得指定列查重后组成的SQL中In格式的字符串
/// </summary>
/// <param name="dt"></param>
/// <param name="ColumnName"></param>
/// <returns></returns>
public static string FormatInValue(this DataTable dt, string ColumnName)
{
return(CommonFormatStrTools.GetDataTableColValueFormatIn(dt, ColumnName));
}
/// <summary>
/// 获得查重后指定列的字符串集合
/// </summary>
/// <param name="dt"></param>
/// <param name="ColumnName"></param>
/// <param name="Split"></param>
/// <returns></returns>
public static IEnumerable <string> GetStrValue(this DataTable dt, string ColumnName)
{
return(CommonFormatStrTools.GetDataTableColValues(dt, ColumnName));
}
