public CreateModel()
{
const string path = @"..\车辆基本信息表.csv";
var lists = FileService.ReadFromFile(path);
Details = InitializeService.InitializeCarDetail(lists);
}
public async Task OnPostAsync()
{
const string path = @"..\车辆基本信息表.csv";
CarDetails = new List <CarDetail>();
var lists = FileService.ReadFromFile(path);
CarDetails = InitializeService.InitializeCarDetail(lists);
if (!string.IsNullOrEmpty(SearchString))
{
switch (SearchOption)
{
case "Name":
CarDetails = CarDetails.Where(t => t.Name.Contains(SearchString)).ToList();
break;
case "CarType":
CarDetails = CarDetails.Where(t => t.CarType.Contains(SearchString)).ToList();
break;
case "PlateId":
CarDetails = CarDetails.Where(t => t.CarPlateId.Contains(SearchString)).ToList();
break;
default:
CarDetails = CarDetails.Where(t => t.Name.Contains(SearchString)).ToList();
break;
}
}
}
public IndexModel()
{
const string path = @"..\车辆基本信息表.csv";
CarDetails = new List <CarDetail>();
var lists = FileService.ReadFromFile(path);
CarDetails = InitializeService.InitializeCarDetail(lists);
}
public StatisticModel()
{
const string path = @"..\车辆基本信息表.csv";
CarDetails = new List <CarDetail>();
var lists = FileService.ReadFromFile(path);
CarDetails = InitializeService.InitializeCarDetail(lists);
sta = new List <CarStatic>();
Dictionary <string, CarStatic> dic = new Dictionary <string, CarStatic>();
foreach (var item in CarDetails)
{
if (dic.ContainsKey(item.CarType))
{
++dic[item.CarType].Total;
if (item.State == "y")
{
++dic[item.CarType].rent;
}
else
{
++dic[item.CarType].free;
}
}
else
{
int onrent = item.State == "y" ? 1 : 0;
dic.Add(item.CarType, new CarStatic
{
Type = item.CarType,
Total = 1,
rent = onrent,
free = 1 - onrent
});
}
}
foreach (var item in dic)
{
sta.Add(item.Value);
}
}
public async Task OnPostAsync()
{
const string path = @"..\车辆基本信息表.csv";
CarDetails = new List <CarDetail>();
var lists = FileService.ReadFromFile(path);
CarDetails = InitializeService.InitializeCarDetail(lists);
sta = new List <CarStatic>();
Dictionary <string, CarStatic> dic = new Dictionary <string, CarStatic>();
foreach (var item in CarDetails)
{
if (dic.ContainsKey(item.CarType))
{
++dic[item.CarType].Total;
if (item.State == "y")
{
++dic[item.CarType].rent;
}
else
{
++dic[item.CarType].free;
}
}
else
{
int onrent = item.State == "y" ? 1 : 0;
dic.Add(item.CarType, new CarStatic
{
Type = item.CarType,
Total = 1,
rent = onrent,
free = 1 - onrent
});
}
}
foreach (var item in dic)
{
sta.Add(item.Value);
}
switch (SearchOption)
{
case "TotalInfo":
break;
case "BarChart":
try
{
DataTable ChartData = new DataTable();
ChartData.Columns.Add("Programming Language", typeof(System.String));
ChartData.Columns.Add("Users", typeof(int));
foreach (var item in sta)
{
ChartData.Rows.Add(item.Type, item.Total);
}
// Create static source with this data table
StaticSource source = new StaticSource(ChartData);
// Create instance of DataModel class
DataModel model = new DataModel();
// Add DataSource to the DataModel
model.DataSources.Add(source);
// Instantiate Column Chart
Charts.ColumnChart column = new Charts.ColumnChart("first_chart");
// Set Chart's width and height
column.Width.Pixel(700);
column.Height.Pixel(400);
// Set DataModel instance as the data source of the chart
column.Data.Source = model;
// Set Chart Title
column.Caption.Text = "All type of the cars";
// Set chart sub title
column.SubCaption.Text = "2020.06";
// hide chart Legend
column.Legend.Show = false;
// set XAxis Text
column.XAxis.Text = "CarType";
// Set YAxis title
column.YAxis.Text = "Total";
// set chart theme
column.ThemeName = FusionChartsTheme.ThemeName.FUSION;
// set chart rendering json
ChartJson = column.Render();
}catch
{
}
break;
default:
break;
}
}
public async Task OnPostSaveFileAsync()
{
string filepath = @"..\AGenerateFile.csv";
const string path = @"..\车辆基本信息表.csv";
CarDetails = new List <CarDetail>();
var lists = FileService.ReadFromFile(path);
CarDetails = InitializeService.InitializeCarDetail(lists);
sta = new List <CarStatic>();
Dictionary <string, CarStatic> dic = new Dictionary <string, CarStatic>();
foreach (var item in CarDetails)
{
if (dic.ContainsKey(item.CarType))
{
++dic[item.CarType].Total;
if (item.State == "y")
{
++dic[item.CarType].rent;
}
else
{
++dic[item.CarType].free;
}
}
else
{
int onrent = item.State == "y" ? 1 : 0;
dic.Add(item.CarType, new CarStatic
{
Type = item.CarType,
Total = 1,
rent = onrent,
free = 1 - onrent
});
}
}
foreach (var item in dic)
{
sta.Add(item.Value);
}
try
{
// Create the file, or overwrite if the file exists.
using (FileStream fs = System.IO.File.Create(filepath))
{
string str = "";
foreach (var item in sta)
{
str = str + item.ToString() + "\n";
}
byte[] info = new UTF8Encoding(true).GetBytes(str);
// Add some information to the file.
fs.Write(info, 0, info.Length);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
