public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
r.UserName,
Name = BlEntity.FormatFullName(r.Entity),
Language = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "Language", r.LanguageId.ToUiString())),
r.PageSize,
roles = string.Join(",", r.Roles.Select(ro => ro.Code)),
Branch = BlBranch.GetBranchName(user.Id, r.BranchId),
IsBlocked = r.IsBlocked ? "close colorRed" : "check colorGreen"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public ObservableCollection <Evento> ListarEventos()
{
try
{
Eventos = new ObservableCollection <Evento>();
var nos = IdadosF1.ListaDados(EventoTipo.GetType());
if (nos != null)
{
foreach (XmlNode node in nos)
{
Eventos.Add(new Evento
{
GP = GPVm.ListaGPs().FirstOrDefault(x =>
x.DataCorrida == Convert.ToDateTime(node.SelectSingleNode("GP")?.InnerText)),
Grid = GridVm.ListaGrids().FirstOrDefault(x =>
x.Numero == Convert.ToInt32(node.SelectSingleNode("Grid")?.InnerText)),
Posicao = Convert.ToInt32(node.SelectSingleNode("Posicao")?.InnerText)
});
}
}
return(Eventos);
}
catch (Exception ex)
{
TrataExcecao(ex, " ocorreu na listagem do registros!", "Erro na listagem");
return(null);
}
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
ModuleId = r.Module.Id,
r.Action,
Text = r.Text ?? "",
User = r.UserId == 0 ? "" : BlUser.LoadSingle(r.UserId).UserName,
branch = BlBranch.GetBranchName(user.Id, r.BranchId),
LogDate = r.EntryDate.ToString(true)
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var i = 0;
var res = (from r in results
select new
{
Id = i++,
Module = r.Id,
Path = r.Path ?? "",
r.Description,
EntryDate = r.EntryDate.ToString(true),
Logging = r.EnableLogging ? "eye" : "eye-slash colorRed",
Status = r.Status == "A" ? "check colorGreen" : "close colorRed"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var i = 0;
var res = (from r in results
select new
{
Id = i++,
r.TableName,
r.CodeName,
r.Value1,
Value2 = r.Value2 ?? "",
Value3 = r.Value3 ?? "",
Order = r.DisplayOrder ?? "",
Status = r.Status ? "check colorGreen" : "close colorRed",
Protected = r.IsProtected ? "lock colorRed" : "unlock-alt colorGreen"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Gender = r.Entity.Gender == null ? "" : BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "Gender", r.Entity.Gender)),
Name = BlEntity.FormatFullName(r.Entity),
Number = r.Entity.IdType == "M" ? r.Entity.IdNum : "",
r.Entity.FullEnLongName,
Level = r.Level == null ? "" : BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "EmployeeLevel", r.Level)),
Status = r.Status == "A" ? "check colorGreen" : "close colorRed"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
private void InitGrid()
{
GridVm.Columns.Add(GridColumnVm.Create("Data.PrimaryKey", "PrimaryKey", 130));
GridVm.Columns.Add(GridColumnVm.Create("Data.X_Date_Value", "X_Date_Value", 130));
GridVm.Columns.Add(GridColumnVm.Create("Data.Y_String_Value", "Y_String_Value", 130));
GridVm.LoadDataSource += LoadGrid;
GridVm.Refresh();
}
public CrlFundListVm(IRESTService rESTService) : base()
{
this._RESTService = rESTService;
LineVm = new FdLineVm("X_Date_Value", "Y_String_Value", "TITLE", "日期", "净值涨幅");
//LineVm.LineColor = "lightblue";
GridVm = new GridVm(this);
ToolBar = new ToolBarTrayVm(this);
UnitLineVm = new FdLineVm("X_Date_Value", "Y_String_Value", "TITLE", "日期", "单位净值");
//UnitLineVm.LineColor = "lightblue";
}
private bool VerificaExistencia()
{
var listaGrids = GridVm.ListaGrids();
if (!listaGrids.Any())
{
return(false);
}
var itemGrid = listaGrids.FirstOrDefault(x =>
x.Temporada == Temporada && x.Equipe == Equipe && x.Piloto == Piloto && x.Motor == Motor);
return(itemGrid != null);
}
private string GeraPontuacao()
{
var maxId = 0;
var listaPontuacao = GridVm.ListaGrids();
if (listaPontuacao.Any())
{
maxId = listaPontuacao.Max(x => x.Numero);
}
maxId++;
return(maxId.ToString());
//return pontuacao;
}
private bool VerificaRepetido(int gridSelecionadoNumero, string[] dados)
{
var listaGrids = GridVm.ListaGrids();
if (!listaGrids.Any())
{
return(false);
}
var itemGrid = listaGrids.FirstOrDefault(x => x.Numero != gridSelecionadoNumero &&
x.Temporada.Numero == Convert.ToInt32(dados[1]) &&
x.Piloto.Nome == dados[2] &&
x.NumeroPiloto == Convert.ToInt32(dados[3]) &&
x.Equipe.Nome == dados[4] &&
x.Motor.Nome == dados[5]);
return(itemGrid != null);
}
public static GridVm <CallTrackingPhoneForGridVm> GetCallTrackingPhonesGridVm(int?pageNumber, int?pageSize)
{
int totalCount;
GridVm <CallTrackingPhoneForGridVm> callTrackingGrid = new GridVm <CallTrackingPhoneForGridVm>();
List <CallTrackingPhone> callTrackingPhones = CallTrackingBc.Instance.GetAll(pageNumber, pageSize, out totalCount);
callTrackingGrid.List = callTrackingPhones.MapToCallTrackingPhoneForGridVmList();
if (pageNumber.HasValue)
{
callTrackingGrid.PageNumber = pageNumber.Value;
}
if (pageSize.HasValue)
{
callTrackingGrid.PageSize = pageSize.Value;
}
callTrackingGrid.TotalCount = totalCount;
callTrackingGrid.GridUrl = MSLivingChoices.Mvc.Uipc.Legacy.MslcUrlBuilder.GetDefaultRouteUrl("CallTracking", "Grid");
callTrackingGrid.JsonGridUrl = MSLivingChoices.Mvc.Uipc.Legacy.MslcUrlBuilder.GetDefaultRouteUrl("CallTracking", "JsonGrid");
return(callTrackingGrid);
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), Int16.MaxValue, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
r.Code,
EntryDate = r.EntryDate.ToString(true),
Status = r.Status == "A" ? "check colorGreen" : "close colorRed"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, Int16.MaxValue, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadSearch(userId, CreateFilter(search));
totalRecords = results.Count();
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Name = r.Property,
r.Value
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Url = "<a class='text-primary' href=" + BlCode.LoadSingle(userId, "_System", "DocumentsRootUrl").Value1 + "documents/" + r.Path + " target='_blank' >" + r.Name + "</a>",
Type = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "DocumentType", r.Type)),
EntryDate = r.EntryDate.ToString(true),
User = r.UserId == 0 ? "" : BlUser.LoadSingle(r.UserId).UserName,
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Language = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "Language", r.LanguageId.ToUiString())),
Parent = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "DescriptionParent", r.Parent)),
r.Code,
r.Text
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public CrlListVm()
{
GridVm = new GridVm(this);
}
protected override void OnViewLoaded(object view)
{
base.OnViewLoaded(view);
Gps = GPVm.ListaGPs();
Grids = GridVm.ListaGrids();
}
