pass dt & conditions to get the filtered data(For Data Column&Row)

DataTable-filter-for-field-and-row

        public static DataTable GetReportFilter(List<TEUserObjectReportFilterModel> _ModelField, List<TEUserObjectReportFilterModel> _ModelContent, DataTable DtReport)
        {
            DataTable _dt = DtReport.Clone();
            DataTable _dtreturn = new DataTable();
            
            try
            {
                foreach (TEUserObjectReportFilterModel _ObjTmp in _ModelField)
                {
                    try
                    {
                        _dtreturn.Columns.Add(_ObjTmp.strFilterField.ToString());
                    }
                    catch (System.Data.DuplicateNameException)
                    {
                        //duplicate column name do nothing
                    }
                }
                
                List<string> ListField = new List<string>();
                for (int i = 0; i < _dtreturn.Columns.Count; i++)
                {
                    ListField.Add(_dtreturn.Columns[i].ColumnName);
                }
                string[] strColumns = (String[])ListField.ToArray();

                #region content
                StringBuilder sb = new StringBuilder();
                int j = 0;
                foreach (TEUserObjectReportFilterModel tereport in _ModelContent)
                {
                    if (j > 0)
                    { sb.Append(" OR "); }//strFilterField(column), strFilterValue1(content)
                    sb.Append(tereport.strFilterField.ToString() + " IN ('" + TERM.strFilterValue1.ToString().Trim() + "')");
                    j++;
                }
                DtReport.DefaultView.RowFilter = sb.ToString();//default view: different dimensions to filter data
                _dt = DtReport.DefaultView.ToTable(true, strColumns);
                #endregion

                #region field
                _dtreturn.Merge(_dt, false, MissingSchemaAction.Ignore);
                #endregion
            }
            catch (Exception e)
            {
                logger.Fatal("GetReportFilter：" + e.Message);
            }
            return _dtreturn;
        }