public async Task <DataPaging <List <RevokeDebtSearch> > > SearchAsync(
DateTime?fromDate = null,
DateTime?toDate = null,
int dateType = 1,
int groupId = 0,
int assigneeId = 0,
string status = null,
int processStatus = -1,
string freeText = null,
int page = 1,
int limit = 10
)
{
fromDate = fromDate.HasValue ? fromDate.ToStartDateTime() : DateTime.Now.ToStartDateTime();
toDate = toDate.HasValue ? toDate.ToEndDateTime() : DateTime.Now.ToEndDateTime();
var data = await _rpRevoke.SearchAsync(_process.User.Id, fromDate, toDate, dateType, groupId, assigneeId, status, processStatus, freeText, page, limit);
if (data == null || !data.Any())
{
return(DataPaging.Create(null as List <RevokeDebtSearch>, 0));
}
var result = DataPaging.Create(data, data[0].TotalRecord);
return(result);
}
public async Task <JsonResult> SearchTemps(string freeText, string status, int page = 1, int limit = 20, string fromDate = null, string toDate = null, int loaiNgay = 0, int manhom = 0,
int mathanhvien = 0)
{
page = page <= 0 ? 1 : page;
DateTime dtFromDate = DateTime.MinValue, dtToDate = DateTime.Now.AddDays(3);
if (fromDate != "")
{
dtFromDate = DateTimeFormat.ConvertddMMyyyyToDateTimeNew(fromDate);
}
if (toDate != "")
{
dtToDate = DateTimeFormat.ConvertddMMyyyyToDateTimeNew(toDate);
}
var profiles = await _rpMCredit.GetTempProfiles(page, limit, freeText, GlobalData.User.IDUser, status, dtFromDate, dtToDate, loaiNgay, manhom, mathanhvien = 0);
if (profiles == null || !profiles.Any())
{
return(ToJsonResponse(true, "", DataPaging.Create(null as List <ProfileSearchSql>, 0)));
}
var result = DataPaging.Create(profiles, profiles[0].TotalRecord);
return(ToJsonResponse(true, "", result));
}
public DataPaging <ms_company> List(HttpRequestMessage v)
{
DataPaging <ms_company> dataPaging = new DataPaging <ms_company>();
dataPaging.meta = new MetaPaging();
var p = v.Content.ReadAsStringAsync().Result;
//var xsss = p.Result[""] ; // exam
NameValueCollection qscoll = HttpUtility.ParseQueryString(p);
string search = "";
string orderField = "";
string orderby = "";
string page = "";
string perpage = "";
string startRow = "";
search = qscoll["query[generalSearch]"];
page = qscoll["pagination[page]"];
perpage = qscoll["pagination[perpage]"];
orderField = qscoll["sort[field]"];
orderby = qscoll["sort[sort]"];
dataPaging.meta.perpage = Convert.ToInt32(perpage);
dataPaging.meta.page = Convert.ToInt32(page);
startRow = ((dataPaging.meta.page - 1) * dataPaging.meta.perpage).ToString();
// datatable[query]:
//pagination[page]:1
//pagination[pages]:1
//pagination[perpage]:5
//pagination[total]:0
//sort[field]:CompName
//sort[sort]:asc
//query:
List <ms_company> compList = null;
using (OASEntities _ent = new OASEntities())
{
int totalRow = _ent.Database.SqlQuery <int>(@" select count(*) totalRow from ms_company where compName like '%" + search + "%' or compCode like '%" + search + "%' ").Single();
compList = _ent.ms_company.SqlQuery(@" select top " + perpage + " * from ( Select *,ROW_NUMBER() OVER(ORDER BY " +
orderField + " " + orderby + ") r from ms_company where compName like '%" + search + "%' or compCode like '%" + search + "%'"
+ " ) company where r > " + startRow + " "
).ToList();
dataPaging.data = compList;
dataPaging.meta.total = totalRow;
dataPaging.meta.pages = Decimal.ToInt32(dataPaging.meta.total / dataPaging.meta.perpage);
}
return(dataPaging);
}
public async Task <DataPaging <List <EmployeeViewModel> > > SearchsAsync(int role, string freeText, int page = 1, int limit = 10)
{
var data = await _rpEmployee.GetsAsync(role, freeText, page, limit, _process.User.OrgId);
if (data == null || !data.Any())
{
return(DataPaging.Create <List <EmployeeViewModel> >(null, 0));
}
return(DataPaging.Create <List <EmployeeViewModel> >(data, data[0].TotalRecord));
}
public async Task <DataPaging <List <CompanyIndexModel> > > SearchsAsync(string freeText, int page, int limit)
{
var datas = await _rpCompany.GetsAsync(freeText, page, limit);
if (datas == null)
{
return(DataPaging.Create(datas, 0));
}
return(DataPaging.Create(datas, datas.FirstOrDefault().TotalRecord));
}
public async Task <DataPaging <List <GroupIndexModel> > > SearchAsync(int parentId, int page = 1, int limit = 10)
{
var data = await _rpGroup.GetChildGroupByParentIdForPagingAsync(page, limit, parentId, _process.User.Id);
if (data == null || !data.Any())
{
return(DataPaging.Create <List <GroupIndexModel> >(null, 0));
}
return(DataPaging.Create <List <GroupIndexModel> >(data, data.FirstOrDefault().TotalRecord));
}
private string CreateDescription(int numResults, int numPages, int pageIndex)
{
pageIndex = DataPaging.FixPageIndex(numPages, pageIndex);
return(string.Format(
"Total number of results found: {0}, Page {1} of {2}.",
numResults,
pageIndex + 1,
numPages));
}
private void LoadPagingControl(int Count)
{
pagingControl = Page.LoadControl("~/UserControl/DataPaging.ascx") as DataPaging;
pagingControl.PageSize = 5;
pagingControl.CurrentPage = CurrentPage;
pagingControl.TotalRecord = Count;
if (Count != 0)
{
pageHolder.Controls.Add(pagingControl);
}
}
public async Task <DataPaging <List <CheckDupIndexModel> > > GetsAsync(
string freeText,
int page,
int limit, int userId)
{
var datas = await _rpCheckDup.GetsAsync(freeText, page, limit, userId);
var result = DataPaging.Create(datas, datas.FirstOrDefault() == null ? 0 : datas.FirstOrDefault().TotalRecord);
return(result);
}
public async Task <JsonResult> Search(string freeText = null, int provinceId = 0, int courierId = 0, string status = null, int groupId = 0, int page = 1, int limit = 10, string salecode = null)
{
//var totalRecord = await _rpCourierProfile.CountHosoCourrier(freeText, courierId, GlobalData.User.IDUser, status, groupId, provinceId, salecode);
var datas = await _rpCourierProfile.GetHosoCourrier(freeText, courierId, GlobalData.User.IDUser, status, page, limit, groupId, provinceId, salecode);
var totalRecord = (datas != null && datas.Any()) ? datas[0].TotalRecord : 0;
//await _rpLog.InsertLog("courier-search", $"freetext:{freeText}, userid:{ GlobalData.User.IDUser}, courierId:{courierId}, status:{status}, salecode: {salecode}");
var result = DataPaging.Create(datas, totalRecord);
return(ToJsonResponse(true, null, result));
}
public async Task <JsonResult> Search(string freeText = null, int page = 1, int limit = 10)
{
var bizCompany = new CompanyRepository();
var totalRecord = await bizCompany.CountAsync(freeText);
var datas = await bizCompany.GetsAsync(freeText, page, limit);
var result = DataPaging.Create(datas, totalRecord);
return(ToJsonResponse(true, null, result));
}
public JsonResult loadTableData(string DeviceName)
{
try
{
/*db.Configuration.ProxyCreationEnabled = false;*/
int length = int.Parse(Request.Query["length"]);
int start = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(int.Parse(Request.Query["start"]) / length))) + 1;
string searchValue = Request.Query["search[value]"];
string sortColumnName = Request.Query["columns[" + Request.Query["order[0][column]"] + "][name]"];
string sortDirection = Request.Query["order[0][dir]"];
/*int length = 10;
* int start = 1;
* string searchValue = "";
* string sortColumnName = "ID";
* string sortDirection = "asc";*/
DataPaging apg = new DataPaging();
apg.data = new List <DataDevice>();
start = (start - 1) * length;
List <Data> listData = _db.Datas.Where(x => x.DeviceName == DeviceName).ToList <Data>();
apg.recordsTotal = listData.Count;
//filter
if (!string.IsNullOrEmpty(searchValue))
{
listData = listData.Where(x => x.TagName.ToLower().Contains(searchValue.ToLower())).ToList <Data>();
}
apg.recordsFiltered = listData.Count;
//paging
listData = listData.Skip(start).Take(length).ToList <Data>();
foreach (var i in listData)
{
DataDevice d = new DataDevice
{
TagName = i.TagName,
DeviceName = i.DeviceName,
Time = i.Time,
Value = i.Value,
Connected = i.Connected
};
apg.data.Add(d);
}
apg.draw = int.Parse(Request.Query["draw"]);
return(Json(apg));
/*return Json(apg, JsonRequestBehavior.AllowGet);*/
}
catch (Exception ex)
{
return(null);
}
}
public async Task <DataPaging <List <RevokeDebtSearch> > > SearchAsync(int userId, string freeText, string status, int page, int limit, int groupId = 0, int assigneeId = 0, DateTime?fromDate = null, DateTime?toDate = null, int loaiNgay = 1)
{
var data = await _rpRevokeDebt.SearchAsync(userId, freeText, status, page, limit, groupId, assigneeId, fromDate, toDate, loaiNgay);
if (data == null || !data.Any())
{
return(DataPaging.Create(null as List <RevokeDebtSearch>, 0));
}
var result = DataPaging.Create(data, data[0].TotalRecord);
return(result);
}
public ms_company Get(string id)
{
ms_company msCompany = null;
DataPaging <ms_company> dataPaging = new DataPaging <ms_company>();
using (OASEntities _ent = new OASEntities())
{
msCompany = _ent.ms_company.Find(id);
}
return(msCompany);
}
public async Task <JsonResult> TimHSQL(string fromDate,
string toDate,
string maHS,
string cmnd,
int loaiNgay = 1,
int maNhom = 0,
int maThanhVien = 0,
string freetext = null,
string status = null,
int page = 1, int limit = 10
)
{
List <HoSoQuanLyModel> lstHoso = new List <HoSoQuanLyModel>();
int totalRecord = 0;
if (!string.IsNullOrWhiteSpace(freetext) && freetext.Length > 50)
{
return(ToJsonResponse(false, "Từ khóa tìm kiếm không được nhiều hơn 50 ký tự"));
}
try
{
DateTime dtFromDate = DateTime.MinValue, dtToDate = DateTime.MinValue;
if (fromDate != "")
{
dtFromDate = DateTimeFormat.ConvertddMMyyyyToDateTime(fromDate);
}
if (toDate != "")
{
dtToDate = DateTimeFormat.ConvertddMMyyyyToDateTime(toDate);
}
string trangthai = string.IsNullOrWhiteSpace(status) ? Helpers.Helpers.GetAllStatusString() : status;
//trangthai +=
var isAdmin = await _rpEmployee.CheckIsAdmin(GlobalData.User.IDUser);
totalRecord = new HoSoBLL().CountHoSoQuanLy(GlobalData.User.IDUser, maNhom, maThanhVien, dtFromDate, dtToDate, maHS, cmnd, trangthai, loaiNgay, freetext);
lstHoso = new HoSoBLL().TimHoSoQuanLy(GlobalData.User.IDUser, maNhom, maThanhVien, dtFromDate, dtToDate, maHS, cmnd, trangthai, loaiNgay, freetext, page, limit, isAdmin: isAdmin);
if (lstHoso == null)
{
lstHoso = new List <HoSoQuanLyModel>();
}
var result = DataPaging.Create(lstHoso, totalRecord);
return(ToJsonResponse(true, null, result));
}
catch (BusinessException ex)
{
return(ToJsonResponse(false, ex.Message));
}
}
public async Task <DataPaging <List <ProductIndexModel> > > GetsAsync(
int page = 1
, int limit = 10
, int partnerId = 0
)
{
var response = await _rpProduct.GetsAync(_process.User.Id, page, limit, partnerId);
if (response == null || !response.Any())
{
return(DataPaging.Create(response, 0));
}
return(DataPaging.Create(response, response.FirstOrDefault().TotalRecord));
}
//parameter - в данном случае тег
public ActionResult Tag(string parameter, int page)
{
DataPaging dataPaging = new DataPaging()
{
controller = "Posts",
action = "Tag",
parameter = parameter,
page = page,
maxPage = ContentRepository.getCountPageByTag(parameter)
};
ViewBag.dataPaging = dataPaging;
return(View(ContentRepository.getPostsByTag(parameter, page)));
}
public ActionResult Index(int page = 1)
{
DataPaging dataPaging = new DataPaging()
{
controller = "Home",
action = "Index",
parameter = "",
page = page,
maxPage = ContentRepository.getCountPage()
};
ViewBag.dataPaging = dataPaging;
return(View(ContentRepository.getPosts(page)));
}
public async Task <DataPaging <List <CheckDupIndexModel> > > GetsAsync(
string freeText,
int page,
int limit)
{
var datas = await _rpCheckDup.GetsAsync(freeText, page, limit, _process.User.Id);
if (datas == null || !datas.Any())
{
return(DataPaging.Create <List <CheckDupIndexModel> >(datas, 0));
}
var result = DataPaging.Create(datas, datas.FirstOrDefault().TotalRecord);
return(result);
}
void Start()
{
Instance = this;
NewpagingData = new List <Personnel>();
//personnels = CommunicationObject.Instance.GetPersonnels();
// StartPerSearchUI();
AddPageBut.onClick.AddListener(AddPersonnelPage);
MinusPageBut.onClick.AddListener(MinusPersonnelPage);
pegeNumText.onEndEdit.AddListener(InputPersonnelPage);
selectedBut.onClick.AddListener(SetPerFindData_Click);
CloseBut.onClick.AddListener(ClosepersonnelSearchWindow);
CreatBut.onClick.AddListener(OPenAddPersonnelUI);
PerSelected.onEndEdit.AddListener(InputPerFindData);
ToggleAuthoritySet();
}
private async Task <DataPaging <List <CourierExportModel> > > SearchByModel(CourierSearchRequestModel request)
{
var datas = await _rpCourierProfile.GetHosoCourrier(request.freeText, request.courierId, GlobalData.User.IDUser, request.status, request.PageNumber, request.limit, request.groupId, request.provinceId, request.salecode);
var totalRecord = (datas != null && datas.Any()) ? datas[0].TotalRecord : 0;
try
{
var profiles = _mapper.Map <List <CourierExportModel> >(datas);
var result = DataPaging.Create(profiles, totalRecord);
return(result);
}
catch (Exception e)
{
return(null);
}
}
public async Task <IActionResult> TimHS(
string fromDate,
string toDate,
string maHS,
string cmnd,
int loaiNgay,
int maNhom = 0,
string freetext = null,
int page = 1, int limit = 10,
int maThanhVien = 0)
{
var data = await _bizHoso.GetHosoDuyet(fromDate, toDate, maHS,
cmnd, loaiNgay, maNhom, freetext, page, limit, maThanhVien);
var result = DataPaging.Create(data.datas, data.TotalRecord);
return(ToResponse(result));
}
public DataPaging <MS_Company> List(SearchCompDataPaging search)
{
List <MS_Company> compList = null;
DataPaging <MS_Company> dataPaging = new DataPaging <MS_Company>();
if (search != null)
{
using (OASEntities _ent = new OASEntities())
{
compList = _ent.MS_Company.Where(x => x.CompName.Contains(search.compName)).OrderBy(x => x.CompName).ToList();
dataPaging.data = compList;
dataPaging.meta = new MetaPaging();
dataPaging.meta.total = compList.Count;
dataPaging.meta.perpage = 10;
dataPaging.meta.page = 1;
}
}
return(dataPaging);
}
public ActionResult HouseList(long cityId, int pageIndex)
{
HouseListModel model = new HouseListModel();
var houses = houseService.GetAll(cityId);
foreach (var house in houses)
{
CreateStaticPage(house.Id);
}
model.Houses = houses;
model.Cities = cityService.GetAll();
model.SelectedCityId = cityId;
DataPaging pager = new DataPaging();
pager.PageIndex = pageIndex;
pager.TotalCount = houseService.GetAll(cityId).Count();
pager.UrlPattern = "/House/HouseList?cityId=" + cityId + "&pageIndex={pn}";
ViewBag.pager = pager.GetPager();
return(View(model));
}
public async Task <JsonResult> Search(string workFromDate, string workToDate,
string freetext = "",
int roleId = 0,
int page = 1, int limit = 10)
{
var fromDate = string.IsNullOrWhiteSpace(workFromDate) ? DateTime.Now.AddDays(-7) : DateTimeFormat.ConvertddMMyyyyToDateTime(workFromDate);
var toDate = string.IsNullOrWhiteSpace(workToDate) ? DateTime.Now : DateTimeFormat.ConvertddMMyyyyToDateTime(workToDate);
BusinessExtension.ProcessPaging(ref page, ref limit);
freetext = string.IsNullOrWhiteSpace(freetext) ? string.Empty : freetext.Trim();
var datas = await _rpEmployee.Gets(fromDate, toDate, roleId, freetext, page, limit, GlobalData.User.OrgId, GlobalData.User.IDUser);
if (datas == null || !datas.Any())
{
return(ToJsonResponse(true, null, DataPaging.Create(null as List <EmployeeViewModel>, 0)));
}
var result = DataPaging.Create(datas, datas[0].TotalRecord);
return(ToJsonResponse(true, null, result));
}
public async Task <DataPaging <List <TempProfileIndexModel> > > SearchsTemsAsync(
DateTime?fromDate
, DateTime?toDate
, int dateType = 1
, int groupId = 0
, int memberId = 0,
string freeText = null,
string status = null,
int page = 1,
int limit = 20)
{
page = page <= 0 ? 1 : page;
fromDate = fromDate.HasValue ? fromDate.Value.ToStartDateTime() : DateTime.Now.ToStartDateTime();
toDate = toDate.HasValue ? toDate.Value.ToEndDateTime() : DateTime.Now.ToEndDateTime();
var profiles = await _rpMCredit.GetTempProfilesAsync(_process.User.Id, fromDate, toDate, dateType, groupId, memberId, page, limit, freeText, status);
if (profiles == null || !profiles.Any())
{
return(DataPaging.Create(null as List <TempProfileIndexModel>, 0));
}
return(DataPaging.Create(profiles, profiles[0].TotalRecord));
}
public async Task <DataPaging <List <CourierIndexModel> > > GetsAsync(string freeText,
DateTime?fromDate
, DateTime?toDate
, int dateType = 2
, string status = null
, int page = 1
, int limit = 10
, int assigneeId = 0
, int groupId = 0
, int provinceId = 0
, string saleCode = null)
{
fromDate = fromDate.HasValue ? fromDate.Value.ToStartDateTime() : DateTime.Now.ToStartDateTime();
toDate = toDate.HasValue ? toDate.Value.ToEndDateTime() : DateTime.Now.ToEndDateTime();
var response = await _rpCourier.GetsAsync(freeText, fromDate.Value, toDate.Value, dateType, status, page, limit, assigneeId, groupId, provinceId, saleCode, _process.User.Id);
if (response == null || !response.Any())
{
return(DataPaging.Create(response, 0));
}
return(DataPaging.Create(response, response.FirstOrDefault().TotalRecord));
}
public async Task <DataPaging <List <ProfileIndexModel> > > GetsAsync(DateTime?fromDate
, DateTime?toDate
, int dateType = 1
, int groupId = 0
, int memberId = 0
, string status = null
, string freeText = null
, string sort = "desc"
, string sortField = "updatedtime"
, int page = 1
, int limit = 20)
{
fromDate = fromDate.HasValue ? fromDate.Value.ToStartDateTime() : DateTime.Now.ToStartDateTime();
toDate = toDate.HasValue ? toDate.Value.ToEndDateTime() : DateTime.Now.ToEndDateTime();
var result = await _rpProfile.GetsAsync(_process.User.Id, fromDate.Value, toDate.Value, dateType, groupId, memberId, status, freeText, sort, sortField, page, limit);
if (result == null || !result.Any())
{
return(DataPaging.Create((List <ProfileIndexModel>)null, 0));
}
return(DataPaging.Create(result, result[0].TotalRecord));
}
private async Task <ProteinSearchViewModel> Search(ProteinSearchQuery psq, int pageIndex)
{
var model = await CreateModel(psq, pageIndex);
var query = FaToolDbEntities
.GetProteinSearchValues(psq.SearchOption, psq.SourceOrganismID)
.Where(pv => pv.Value.Contains(psq.SearchValue));
int numResults = await query.CountAsync();
if (numResults == 0)
{
model.StatusDescription = "Query does not return any results.";
}
else
{
int numPages = DataPaging.CalculatePageCount(numResults);
pageIndex = DataPaging.FixPageIndex(numPages, pageIndex);
int skip = DataPaging.CalculateSkipCount(numResults, pageIndex);
var proteinValues = await query
.OrderBy(x => x.Value)
.ThenBy(x => x.TermName)
.ThenBy(x => x.ProteinName)
.Skip(skip)
.Take(DataPaging.PageSize)
.ToArrayAsync();
model.Results = proteinValues
.Select(CreateItem)
.ToArray();
model.StatusDescription = CreateDescription(numResults, numPages, pageIndex);
}
return(model);
}
/// <summary>
/// 输出Json字符串
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
private string ResponseJsonBySQL()
{
//if (string.IsNullOrEmpty(sql)) return null;
List <ICriterion> exps = new List <ICriterion>();
//查询数据时
if (!string.IsNullOrEmpty(GridPagingStruct.search))
{
var jarr = (JArray)JsonConvert.DeserializeObject(GridPagingStruct.search);
dynamic jsonObj = Razor.DynamicJson.DynamicJsonConvert.Parse(GridPagingStruct.search);
string Name = jsonObj[0].Name;
string Age = jsonObj[1].Age;
string Email = jsonObj[2].Email;
if (!string.IsNullOrEmpty(Name))
{
exps.Add((ICriterion)Expression.Like("Name", Name));
}
if (!string.IsNullOrEmpty(Age))
{
exps.Add((ICriterion)Expression.Eq("Age", int.Parse(Age)));
}
if (!string.IsNullOrEmpty(Email))
{
exps.Add((ICriterion)Expression.Like("Email", Email));
}
}
var list = DataPaging.FindAll <Employee>(GridPagingStruct.Page, GridPagingStruct.PageSize,
new Order[] { new Order("CreateTime", false) }, exps.ToArray());
GridJsonStruct gjs = new GridJsonStruct(list, DataPaging.GetCount <Employee>());
return(Razor.DynamicJson.DynamicJsonConvert.SerializeObject(gjs));
}
