在没有页面刷新的情况下在mvc中的表（tr标签）中进行排序 [英] Sorting in table(tr tag) in mvc without page refresh

问题描述

用于检索数据的逻辑



public IQueryable< visitordm> GetCheckInVisitorList（int cityId，int page）

{

// DateTime todayDate = DateTime.Today;

using（VMSDBContext context = DAL.Instance .NewDefaultDbContext（））

{

var lstVistorDetails =（来自上下文中的objVisitors.Visitors

加入objVisits in context.Visits on objVisitors.ID equals objVisits.Visitor_id

加入objVisitorLocation in context.VisitorLocations on objVisits.Visitor_location_id equals objVisitorLocation.ID

join objEmployee in context.Employees on objVisits.Employee_to_visit equals objEmployee.ID

在上下文中加入objprogram.obr上的objEmployee.Program_id等于objprogram.ID

在context.IdentificationProofs中加入objIdProof on objVisits.Identification_proof_id等于objIdProof.ID

在context.Locations.Where中加入objLocation（objlocations => Objlocations.City_id == cityId）on objVisits.Location_id等于objLocation.ID

加入objVisitorPurpose in context.VisitPurposes on objVisits.Visit_purpose_id equals objVisitorPurpose.ID

where（objVisits.Office_out_time == null）

//&& objVisits.Office_in_time.Value.Day == todayDate.Day

//&& objVisits.Office_in_time.Value.Month == todayDate.Month

//&& objVisits.Office_in_time.Value.Year == todayDate.Year）

orderby objVisits.ID降序

选择新的VisitorDM

{

Visit_id = objVisits.ID，

Name = objVisitors.Name，

Mobile_number = objVisitors.Mobile_number，

Visitor_location = objVisitorLocation。姓名，

EmployeeName_to_visit = objEmployee.First_name ++ objEmployee.Last_name +（+ objEmployee.Employee_code +），

IdProof = objIdProof.ID_proof，

OfficeLocation = objLocation.Name，

VisitorPurpose = objVisitorPurpose.Name，

Office_in_time = objVisits.Office_in_time，

Office_in_entry_by = objVisits.Office_in_entry_by，

Office_in_system_name = objVisits.Office_in_system_name，

Office_out_time = objVisits.Office_out_time，

Office_out_entry_by = objVisits.Office_out_entry_by，

Office_out_system_name = objVisits.Office_out_system_name，

Modified_on = objVisits.Modified_on，

Modified_by = objVisits.Office_in_system_name，

ID = objVisitors.ID

}。ToList（）。AsQueryable（）;

返回lstVistorDetails;

}



}



在另一个函数中调用此函数

Logic used to retrieve a data

public IQueryable<visitordm> GetCheckInVisitorList(int cityId, int page)
{
// DateTime todayDate = DateTime.Today;
using (VMSDBContext context = DAL.Instance.NewDefaultDbContext())
{
var lstVistorDetails = (from objVisitors in context.Visitors
join objVisits in context.Visits on objVisitors.ID equals objVisits.Visitor_id
join objVisitorLocation in context.VisitorLocations on objVisits.Visitor_location_id equals objVisitorLocation.ID
join objEmployee in context.Employees on objVisits.Employee_to_visit equals objEmployee.ID
join objprogram in context.Programs on objEmployee.Program_id equals objprogram.ID
join objIdProof in context.IdentificationProofs on objVisits.Identification_proof_id equals objIdProof.ID
join objLocation in context.Locations.Where(objlocations => objlocations.City_id == cityId) on objVisits.Location_id equals objLocation.ID
join objVisitorPurpose in context.VisitPurposes on objVisits.Visit_purpose_id equals objVisitorPurpose.ID
where (objVisits.Office_out_time == null)
// && objVisits.Office_in_time.Value.Day == todayDate.Day
// && objVisits.Office_in_time.Value.Month == todayDate.Month
// && objVisits.Office_in_time.Value.Year == todayDate.Year)
orderby objVisits.ID descending
select new VisitorDM
{
Visit_id = objVisits.ID,
Name = objVisitors.Name,
Mobile_number = objVisitors.Mobile_number,
Visitor_location = objVisitorLocation.Name,
EmployeeName_to_visit = objEmployee.First_name + " " + objEmployee.Last_name + "(" + objEmployee.Employee_code + ")",
IdProof = objIdProof.ID_proof,
OfficeLocation = objLocation.Name,
VisitorPurpose = objVisitorPurpose.Name,
Office_in_time = objVisits.Office_in_time,
Office_in_entry_by = objVisits.Office_in_entry_by,
Office_in_system_name = objVisits.Office_in_system_name,
Office_out_time = objVisits.Office_out_time,
Office_out_entry_by = objVisits.Office_out_entry_by,
Office_out_system_name = objVisits.Office_out_system_name,
Modified_on = objVisits.Modified_on,
Modified_by = objVisits.Office_in_system_name,
ID = objVisitors.ID
}).ToList().AsQueryable();
return lstVistorDetails;
}

}

Calls this function in another function

public IQueryable<VisitorDM> GetTypeVisitorDetails(string searchText, string searchType, int cityId, int page, [Optional] string columnName, [Optional]string sortType)
      {
          List<VisitorDM> lstVistorDetails = new List<VisitorDM>();
          using (VMSDBContext context = DAL.Instance.NewDefaultDbContext())
          {
              if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
              {
                  switch (columnName)
                  {

                      case "Visit Id":
                          IEnumerable<VisitorDM> CheckInVisitID = (sortType == "ASC" ?
                                                            GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.Visit_id) :
                                                            GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.Visit_id));
                          lstVistorDetails = CheckInVisitID.ToList();
                          break;
                      case "Office Location":
                          IEnumerable<VisitorDM> CheckInOfficeLocation = (sortType == "ASC" ?
                                                            GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.OfficeLocation) :
                                                            GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.OfficeLocation));
                          lstVistorDetails = CheckInOfficeLocation.ToList();
                          break;
                      case "Visitor Name":
                          IEnumerable<VisitorDM> CheckInVisitorName = (sortType == "ASC" ?
                                                             GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.Name) :
                                                             GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.Name));
                          lstVistorDetails = CheckInVisitorName.ToList();
                          break;
                      case "Visitor Mobile Number":
                          IEnumerable<VisitorDM> CheckInVisitorMobileNumber = (sortType == "ASC" ?
                                                             GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.Mobile_number) :
                                                             GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.Mobile_number));
                          lstVistorDetails = CheckInVisitorMobileNumber.ToList();
                          break;
                      case "Person To Meet":
                          IEnumerable<VisitorDM> CheckInPersonToMeet = (sortType == "ASC" ?
                                                             GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.EmployeeName_to_visit) :
                                                             GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.EmployeeName_to_visit));
                          lstVistorDetails = CheckInPersonToMeet.ToList();
                          break;
                      case "In Time":
                          IEnumerable<VisitorDM> CheckInInTime = (sortType == "ASC" ?
                                                             GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.EmployeeName_to_visit) :
                                                             GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.EmployeeName_to_visit));
                          lstVistorDetails = CheckInInTime.ToList();
                          break;
                  }
              }
              else
              {
                  if (Convert.ToString(VisitorListType.CurrentCheckInVisitor) == searchType)
                  {
                      IEnumerable<VisitorDM> CheckInVisitorList = GetCheckInVisitorList(cityId, page).Where(
                                                                                               objCheckInlist =>
                                                                                                  (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Mobile_number.Contains(searchText) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Name.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.EmployeeName_to_visit.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.OfficeLocation.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Visit_id.ToString().Contains(searchText) : true)
                                                                                               );
                      lstVistorDetails = CheckInVisitorList.ToList();
                  }
              }

              if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
              {

              }
              else
              {
                  if (Convert.ToString(VisitorListType.TodayAllInVisitor) == searchType)
                  {
                      IEnumerable<VisitorDM> TodayVisitorList = GetTodayVisitorList(cityId, page).Where(
                                                                                               objCheckInlist =>
                                                                                                  (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Mobile_number.Contains(searchText) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Name.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.EmployeeName_to_visit.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.OfficeLocation.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Visit_id.ToString().Contains(searchText) : true)
                                                                                               );
                      lstVistorDetails = TodayVisitorList.ToList();
                  }
              }

              if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
              {

              }
              else
              {
                  if (Convert.ToString(VisitorListType.VisitorHistory) == searchType)
                  {
                      IEnumerable<VisitorDM> AllVisitorHistoryList = GetVisitorHistoryList(cityId, page).Where(
                                                                                               objCheckInlist =>
                                                                                                  (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Mobile_number.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Name.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.EmployeeName_to_visit.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.OfficeLocation.ToLower().Contains(searchText.ToLower()) : true)
                                                                                               || (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Visit_id.ToString().Contains(searchText) : true)
                                                                                               );
                      lstVistorDetails = AllVisitorHistoryList.ToList<VisitorDM>();
                  }
              }
          }
          return lstVistorDetails.ToList().AsQueryable();
      }

另一个函数的调用



public VisitorListVM GetAllTypeVisitorDetails（string searchText，string searchType，int cityId，int page，int UserId，[Optional] string columnName，[Optional] string sortType）

{

UserBL userBL = new UserBL（）;

VisitorListVM visitorListVM = new VisitorListVM（）;

visitorListVM.DefaultLocations = userBL.GetLocationList（UserId）;

if（！string.IsNullOrEmpty（columnName）&&！string.IsNullOrEmpty（sortType））

{

visitorListVM.Sort_Direction = sortType;

visitorListVM.PagedVisitorList = GetTypeVisitorDetails（searchText，searchType，cityId，page，columnName，sortType）.ToPagedList（page）;

}

else

{

visitorListVM.PagedVisit orList = GetTypeVisitorDetails（searchText，searchType，cityId，page）.ToPagedList（page）;

}



返回visitorListVM;

}



控制器

calls in another function

public VisitorListVM GetAllTypeVisitorDetails(string searchText, string searchType, int cityId, int page, int UserId, [Optional] string columnName, [Optional]string sortType)
{
UserBL userBL = new UserBL();
VisitorListVM visitorListVM = new VisitorListVM();
visitorListVM.DefaultLocations = userBL.GetLocationList(UserId);
if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
{
visitorListVM.Sort_Direction = sortType;
visitorListVM.PagedVisitorList = GetTypeVisitorDetails(searchText, searchType, cityId, page, columnName, sortType).ToPagedList(page);
}
else
{
visitorListVM.PagedVisitorList = GetTypeVisitorDetails(searchText, searchType, cityId, page).ToPagedList(page);
}

return visitorListVM;
}

Controller

public ActionResult Sorting(string searchType, int cityId,int Id, string columnName, string sortType)
       {
           visitorListBL = new VisitorListBL();
           VisitorListVM visitorListVM = new VisitorListVM();
           visitorListVM = visitorListBL.GetAllTypeVisitorDetails(string.Empty, searchType, Convert.ToInt32(cityId), Id, UserId, columnName, sortType);

           visitorListVM.Sort_Direction=sortType;

           if (Convert.ToString(VisitorListType.CurrentCheckInVisitor) == searchType)
           {
               return PartialView("~/Views/VisitorList/_CheckInVisitorList.cshtml", visitorListVM);
           }
           if (Convert.ToString(VisitorListType.TodayAllInVisitor) == searchType)
           {
               return PartialView("~/Views/VisitorList/_VisitorList.cshtml", visitorListVM);
           }
           if (Convert.ToString(VisitorListType.VisitorHistory) == searchType)
           {
               return PartialView("~/Views/VisitorList/_VisitorList.cshtml", visitorListVM);
           }
           return View();
       }

JQuery



函数排序（columnName，cityId，tabid）{

if（sort ==ASC）

{

sort =DESC ;

}

其他

{

sort =ASC;

}

$ .ajax（{

类型：GET，

contentType：'application / json'，

url：/ VisitorList / Sorting，

data：{Id：currentPage，cityId：cityId，searchType：tabid，columnName：columnName，sortType：sort}，

成功：函数（数据）{

$（'＃divVisitorsList'）。replaceWith（data）

sort = data.Sort_Direction;

}

}）;

}

$（文件）.on（'click'，'。sorting'，function（）{



var c olumnName = $（this）.text（）;

var cityId = $（'＃ddlLocation'）。val（）;

var tabid = $（。VisitorActiveTab ）.find（'。active'）。attr（'id'）;

排序（columnName，cityId，tabid）

}）;

JQuery

function Sorting(columnName, cityId, tabid) {
if (sort == "ASC")
{
sort = "DESC";
}
else
{
sort="ASC";
}
$.ajax({
type: "GET",
contentType: 'application/json',
url: "/VisitorList/Sorting",
data: { Id: currentPage, cityId: cityId, searchType: tabid, columnName: columnName, sortType: sort },
success: function (data) {
$('#divVisitorsList').replaceWith(data)
sort = data.Sort_Direction;
}
});
}
$(document).on('click', '.sorting', function(){

var columnName = $(this).text();
var cityId = $('#ddlLocation').val();
var tabid = $(".VisitorActiveTab").find('.active').attr('id');
Sorting(columnName, cityId, tabid)
});

推荐答案

.ajax（{

类型：GET，

contentType：'application / json'，

URL： / VisitorList /排序，

数据：{ID：当前页，cityId：cityId，检索类别：tabid，列名：列名，sortType：排序}

成功：函数（数据）{

.ajax({
type: "GET",
contentType: 'application/json',
url: "/VisitorList/Sorting",
data: { Id: currentPage, cityId: cityId, searchType: tabid, columnName: columnName, sortType: sort },
success: function (data) {

（'＃divVisitorsList'）。replaceWith（data）

sort = data.Sort_Direction;

}

}）;

}

('#divVisitorsList').replaceWith(data)
sort = data.Sort_Direction;
}
});
}

（document）.on（ 'click'，'。sorting'，function（）{



var columnName =

(document).on('click', '.sorting', function(){

var columnName =

这篇关于在没有页面刷新的情况下在mvc中的表（tr标签）中进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！