public IEnumerable <EventsModel> GetEvents(Guid ticket, DateTime startDate, DateTime endDate)
{
List <EventsModel> e = new List <EventsModel>();
IDataQueryService dataQueryService = new DataQueryServiceClient();
var result = dataQueryService.GetEvents(ticket, startDate, endDate);
CultureInfo provider = CultureInfo.InvariantCulture;
foreach (EventInfo events in result)
{
e.Add(new EventsModel()
{
Id = events.Id,
content = events.Content,
UserId = events.UserId,
departments = events.Department,
title = events.Title,
date = DateTime.Parse(events.Date),
notificationDate = DateTime.Parse(events.NotificationDate),
});
}
return(e);
}
public IEnumerable <UnitsModel> getUnits(Guid ticket)
{
List <UnitsModel> m = new List <UnitsModel>();
IDataQueryService dataQueryService = new DataQueryServiceClient();
var result = dataQueryService.GetUnits(ticket);
foreach (UnitInfo unit in result)
{
m.Add(new UnitsModel()
{
Id = unit.Id,
Name = unit.Name,
Description = unit.Description,
});
}
return(m);
}
public IEnumerable <UserModels> GetUsers(Guid ticket)
{
List <UserModels> users = new List <UserModels>();
IDataQueryService dataQueryService = new DataQueryServiceClient();
var result = dataQueryService.GetUsers(ticket);
foreach (DataQueryService.UserInfo user in result)
{
users.Add(new UserModels()
{
id = user.Id,
name = user.Name,
surname = user.Surname,
isAdmin = user.IsAdmin,
unitName = user.Unit.Name,
Login = user.Login,
});
}
return(users);
}
public IEnumerable <LibrariesModel> getLibraries(Guid ticket)
{
List <LibrariesModel> m = new List <LibrariesModel>();
IDataQueryService dataQueryService = new DataQueryServiceClient();
var result = dataQueryService.GetLibraries(ticket);
foreach (LibraryInfo lib in result)
{
m.Add(new LibrariesModel()
{
Id = lib.Id,
Name = lib.Name,
Address = lib.Address,
AdditionalInfo = lib.AdditionalInfo,
OpeningHours = lib.OpeningHours,
UserId = lib.UserId
});
}
return(m);
}
public IEnumerable <MessagesModel> GetMessages(Guid ticket, DateTime startDate)
{
List <MessagesModel> m = new List <MessagesModel>();
IDataQueryService dataQueryService = new DataQueryServiceClient();
var result = dataQueryService.GetMessages(ticket, startDate);
foreach (MessageInfo msg in result)
{
m.Add(new MessagesModel()
{
Id = msg.Id,
content = msg.Content,
UserId = msg.UserId,
departments = msg.Department,
title = msg.Title,
important = msg.Important
});
}
return(m);
}
public IEnumerable <DeansOfficesModel> GetDeansOffices(Guid ticket)
{
List <DeansOfficesModel> m = new List <DeansOfficesModel>();
IDataQueryService dataQueryService = new DataQueryServiceClient();
var result = dataQueryService.GetAllDeansOffices(ticket);
foreach (DeansOfficeInfo DeansOff in result)
{
m.Add(new DeansOfficesModel()
{
Id = DeansOff.Id,
AdditionalInfo = DeansOff.AdditionalInfo,
Address = DeansOff.Address,
Department = DeansOff.Department,
OpeningHours = DeansOff.OpeningHours,
UserId = DeansOff.UserId
});
}
return(m);
}
static void Main(string[] args)
{
DataQueryServiceClient client = new DataQueryServiceClient();
string pois = "";
//string pois = client.GetHotPoi();
//119410000001
//自行车
// string pois = client.GetThemeDataFromTable("119410000001");
//client.
// string pois = client.Search("", "STAN_NAME", "THEMENAME;X;Y", "VW_PLACENAME", 10);
pois = client.Search("4303", "ID", "NAME;STATE;CSVRID;CYCAVAIL;CYCBACK;TIME;ADDR;CALL;SERVICE;TYPE", "VW_BIKE", 10);
//ID，X,Y,站点名称，值守状态，CSVRID,可租数量，可还数量，服务时间，站点地址，服务电话，其他服务，站点备注
//pois = client.GetPois("ID", "X", "Y", "NAME;STATE;CSVRID;CYCAVAIL;CYCBACK;TIME;ADDR;CALL;SERVICE;TYPE", "VW_BIKE");
//client.GetPoiStates("ID", "STATE", "CYCAVAIL;CYCBACK", "VM_BIKE");
byte[] bytes = FX.Security.AesCryptography.Decrypt(pois);
byte[] results = Cellbi.SvZLib.Utils.Decompress(bytes);
///////
FX.Data.DataTable tbResult = FX.Serialization.DataContractSerialization.Deserialize <FX.Data.DataTable>(results) as FX.Data.DataTable;
//CreateExcelSheet(tbResult);
// string poi2 = System.Text.Encoding.UTF8.GetString(results);
client.Close();
}
