使用C＃在ASP.NET中搜索时如何获取重复记录？ [英] How to get duplicate records while searching in ASP.NET with C#?

问题描述

我希望在使用c＃在asp.net中搜索时获取重复记录。分页计数不适用于重复帐户否检查（x.EmployeeAccount.ToLower（）。包含（txt_Srch_AccNo.Text.ToLower（）。修剪（））



我尝试过：



我的代码如下：

I want to get duplicate records while searching in asp.net with c#. The paging count is not working for Duplicate Account No check (x.EmployeeAccount.ToLower().Contains(txt_Srch_AccNo.Text.ToLower().Trim())

What I have tried:

My code is as below:

List<MDL_NONMOLSalaryDetail> pagingList = (from o in objDetailList
                                                       select o).Where(x => (x.EmployeeID.ToLower().Contains(txt_Srch_EmployeeName.Text.ToLower().Trim()) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 || (x.EmployeeName.ToLower().Contains(txt_Srch_EmployeeName.Text.ToLower().Trim()) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 || (x.EmployeeAccount.ToLower().Contains(txt_Srch_AccNo.Text.ToLower().Trim()) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 || (x.IsEdited.Equals(1) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 ).Skip(LeftStart).Take(TopRecords).ToList<MDL_NONMOLSalaryDetail>();
            int pageCount = (from o in objDetailList
                             select o).Where(x => (x.EmployeeID.ToLower().Contains(txt_Srch_EmployeeName.Text.ToLower().Trim()) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 || (x.EmployeeName.ToLower().Contains(txt_Srch_EmployeeName.Text.ToLower().Trim()) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 || (x.EmployeeAccount.ToLower().Contains(txt_Srch_AccNo.Text.ToLower().Trim()) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 || (x.IsEdited.Equals(1) || txt_Srch_EmployeeName.Text.Trim() == "")
                                                                                 ).Count();

推荐答案

要查找重复项，您需要o按重复值所在的列进行分组，然后你必须做一个

To find duplicates, you have to do a Group by the column where the duplicate value is, then you have to do a

.Count()

这篇关于使用C＃在ASP.NET中搜索时如何获取重复记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！