/// <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)); }