using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ThirdPartyClient.Method
{
    public class CommonHelper
    {
        #region 方法 -> 合并Datatable中某个字符串的值
        /// <summary>
        /// 合并Datatable中某个字符串的值，返回list
        /// </summary>
        /// <param name="dataTable">数据源</param>
        /// <param name="FieldName">字段名称</param>
        /// <param name="SortStr">排序字段</param>
        /// <returns></returns>
        public static List<string> JoinListFromDataTable(DataTable dataTable, string FieldName, string SortStr = "")
        {
            List<string> JoinStr = new List<string>();

            foreach (DataRow dataRow in dataTable.DefaultView.ToTable(true, FieldName).Select("", SortStr))
            {
                if (dataRow[FieldName].ToString() != "")
                {
                    JoinStr.Add(dataRow[FieldName].ToString());
                }
            }

            return JoinStr;
        }

        /// <summary>
        /// 合并Datatable中某个字符串的值，返回string
        /// </summary>
        /// <param name="dataTable">数据源</param>
        /// <param name="FieldName">字段名称</param>
        /// <param name="SeparateStr">分隔符，默认为,</param>
        /// <param name="SortStr">排序字段</param>
        /// <returns></returns>
        public static string JoinStrFromDataTable(DataTable dataTable, string FieldName,
            string SeparateStr = ",", string SortStr = "")
        {
            string JoinStr = "";

            foreach (DataRow dataRow in dataTable.DefaultView.ToTable(true, FieldName).Select("", SortStr))
            {
                if (dataRow[FieldName].ToString() != "")
                {
                    JoinStr += (JoinStr == "" ? "" : SeparateStr) + dataRow[FieldName];
                }
            }

            return JoinStr;
        }
        #endregion
    }
}