public ReturnCountyCheck CountyCheck(CountryStatus requset)
{
using (var db = DbFactory.Open())
{
var build = db.From <AuditCounty>();
var returnCountryCheck = new ReturnCountyCheck();
build = build.Where(x => x.Year == DateTime.Now.Year).And(y => y.CountyADCD == adcd);
var list = db.Select <AuditCounty>(build);
if (list.Count > 0)
{
//-1审核失败增加失败原因否则没有失败原因
if (list[0].Status == -1)
{
returnCountryCheck.CheckStatus = list[0].Status;
returnCountryCheck.CheckSuggest = db.Select <AuditCountyDetails>("select Remarks,max(AuditTime) from dbo.AuditCountyDetails where CountyID='" + list[0].ID + "' group by Remarks ")[0].Remarks;
returnCountryCheck.IsSuccess = false;
}
else
{
returnCountryCheck.CheckStatus = list[0].Status;
returnCountryCheck.CheckSuggest = "";
returnCountryCheck.IsSuccess = false;
}
}
else
{
returnCountryCheck.CheckStatus = 2;
returnCountryCheck.CheckSuggest = "";
returnCountryCheck.IsSuccess = false;
}
return(returnCountryCheck);
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,CountryId,CasosConfirmados,Mortes,Recuperados")] CountryStatus countryStatus)
{
if (id != countryStatus.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(countryStatus);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CountryStatusExists(countryStatus.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CountryId"] = new SelectList(_context.Countries, "Id", "Id", countryStatus.CountryId);
return(View(countryStatus));
}
public async Task <IActionResult> Create([Bind("Id,CountryId,CasosConfirmados,Mortes,Recuperados")] CountryStatus countryStatus)
{
if (ModelState.IsValid)
{
_context.Add(countryStatus);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CountryId"] = new SelectList(_context.Countries, "Id", "Id", countryStatus.CountryId);
return(View(countryStatus));
}
public GetData(CountryActivty activity, CountryStatus obj)
{
this.activity = activity;
this.cdata = obj;
}
public ViewModel()
{
this.PaletteList = new ObservableCollection <string>();
PaletteList.Add("Metro");
PaletteList.Add("AutumnBrights");
PaletteList.Add("Florahues");
PaletteList.Add("Pineapple");
PaletteList.Add("TomotoSpectrum");
PaletteList.Add("RedChrome");
PaletteList.Add("BlueChrome");
PaletteList.Add("PurpleChrome");
PaletteList.Add("GreenChrome");
PaletteList.Add("Elite");
PaletteList.Add("LightCandy");
PaletteList.Add("SandyBeach");
//PieSeries
this.CountryStatus = new ObservableCollection <Model>();
CountryStatus.Add(new Model {
Country = "Finland", Status = 12.68
});
CountryStatus.Add(new Model {
Country = "Germany", Status = 10.59
});
CountryStatus.Add(new Model {
Country = "Poland", Status = 11.16
});
CountryStatus.Add(new Model {
Country = "France", Status = 10.48
});
CountryStatus.Add(new Model {
Country = "Australia", Status = 10.13
});
CountryStatus.Add(new Model {
Country = "Israel", Status = 10.50
});
CountryStatus.Add(new Model {
Country = "Brazil", Status = 7.99
});
CountryStatus.Add(new Model {
Country = "Switzerland", Status = 7.25
});
CountryStatus.Add(new Model {
Country = "Russia", Status = 6.25
});
CountryStatus.Add(new Model {
Country = "Singapore", Status = 5.90
});
//Active User in Year of 2012,2014,2015
this.AnnualStatus = new ObservableCollection <Model>();
AnnualStatus.Add(new Model {
SocialNetwork = "Facebook", Year2012 = 788, Year2014 = 1440, Year2015 = 1336
});
AnnualStatus.Add(new Model {
SocialNetwork = "QZone", Year2012 = 210, Year2014 = 632, Year2015 = 629
});
AnnualStatus.Add(new Model {
SocialNetwork = "WhatsApp", Year2012 = 800, Year2014 = 800, Year2015 = 600
});
AnnualStatus.Add(new Model {
SocialNetwork = "WeChat", Year2012 = 668, Year2014 = 668, Year2015 = 468
});
AnnualStatus.Add(new Model {
SocialNetwork = "Google+", Year2012 = 549, Year2014 = 549, Year2015 = 343
});
AnnualStatus.Add(new Model {
SocialNetwork = "Twitter", Year2012 = 540, Year2014 = 540, Year2015 = 284
});
AnnualStatus.Add(new Model {
SocialNetwork = "Instagram", Year2012 = 302, Year2014 = 302, Year2015 = 300
});
AnnualStatus.Add(new Model {
SocialNetwork = "Skype", Year2012 = 300, Year2014 = 300, Year2015 = 300
});
//Active Users
this.ActiveUsers = new ObservableCollection <Model>();
ActiveUsers.Add(new Model {
SocialNetwork = "Twitter", Status = 302
});
ActiveUsers.Add(new Model {
SocialNetwork = "WeChat", Status = 559
});
ActiveUsers.Add(new Model {
SocialNetwork = "Instagram", Status = 300
});
ActiveUsers.Add(new Model {
SocialNetwork = "Skype", Status = 300
});
ActiveUsers.Add(new Model {
SocialNetwork = "WhatsApp", Status = 800
});
ActiveUsers.Add(new Model {
SocialNetwork = "Google+", Status = 540
});
ActiveUsers.Add(new Model {
SocialNetwork = "QZone", Status = 668
});
ActiveUsers.Add(new Model {
SocialNetwork = "Facebook", Status = 1184
});
// Registered users
this.RegisteredUsers = new ObservableCollection <Model>();
RegisteredUsers.Add(new Model {
SocialNetwork = "Twitter", Status = 500
});
RegisteredUsers.Add(new Model {
SocialNetwork = "WeChat", Status = 1120
});
RegisteredUsers.Add(new Model {
SocialNetwork = "Instagram", Status = 300
});
RegisteredUsers.Add(new Model {
SocialNetwork = "Skype", Status = 663
});
RegisteredUsers.Add(new Model {
SocialNetwork = "WhatsApp", Status = 800
});
RegisteredUsers.Add(new Model {
SocialNetwork = "Google+", Status = 540
});
RegisteredUsers.Add(new Model {
SocialNetwork = "QZone", Status = 1000
});
RegisteredUsers.Add(new Model {
SocialNetwork = "Facebook", Status = 2000
});
}
public ReturnCountyCheck Get(CountryStatus requset)
{
return(CountryPerson.CountyCheck(requset));
}
