/// <summary> /// 生成测试csv数据 /// </summary> private void GenerateTestData() { ColumnsName = new List <string>(); ColumnsName.Add("ID"); ColumnsName.Add("Name"); ColumnsName.Add("Description"); ColumnsName.Add("Size"); ColumnsName.Add("Price"); ColumnsName.Add("Html"); ColumnsName.Add("Url"); ColumnsName.Add("CreateDate"); ModelCsvData = new List <TestProductModel>(); for (int i = 0; i < 100000; i++) { TestProductModel model = new TestProductModel(); model.ID = i + 1; model.Name = "name " + (i + 1).ToString(); model.Price = i / 3m; model.Url = "http://www.test.com/product/" + i.ToString(); model.Html = @"<div class=""description-div""><table class=""description-table""><tr> <td colspan=""2"" class=""description-td-title"">Details:</td> </tr> <tr> <td style=""color:#ffff"">Color Type:</td> <td class=""description-right-td"">Black/Brown/Red</td> </tr> <tr> <td class=""description-left-td"">MATERIAL:</td> <td class=""description-right-td"">Vinyl</td> </tr> <tr> <td class=""description-left-td"">Fabric:</td> <td class=""description-right-td"">Vinyl</td> </tr> <tr> <td class=""description-left-td"">Height:</td> <td class=""description-right-td"">-</td> </tr> <tr> <td class=""description-left-td"">Length:</td> <td class=""description-right-td"">5</td> </tr> <tr> <td class=""description-left-td"">Width:</td> <td class=""description-right-td"">3</td> </tr> <tr> <td class=""description-left-td"">Weight:</td> <td class=""description-right-td"">3.40g</td> </tr> </table></div>"; model.CreateDate = DateTime.Now; ModelCsvData.Add(model); } }
/// <summary> /// 将一行csv数据转为模型实例 /// </summary> /// <param name="data"></param> /// <returns></returns> private TestProductModel ConvertCsvRowToTestProductData(List <string> data) { TestProductModel result = new TestProductModel(); if (data != null) { for (int i = 0; i < data.Count; i++) { switch (i) { case 0: result.ID = Convert.ToInt32(data[i]); break; case 1: result.Name = data[i]; break; case 2: result.Description = data[i]; break; case 3: result.Size = data[i]; break; case 4: result.Price = Convert.ToDecimal(data[i]); break; case 5: result.Html = data[i]; break; case 6: result.Url = data[i]; break; case 7: result.CreateDate = DateTime.Parse(data[i]); break; } } } return(result); }
/// <summary> /// 将模型转为一行csv数据 /// </summary> /// <param name="model"></param> /// <returns></returns> private List <string> ConvertModelToRowData(TestProductModel model) { List <string> result = new List <string>(); if (model != null) { result.Add(model.ID.ToString()); result.Add(model.Name); result.Add(model.Description); result.Add(model.Size); result.Add(model.Price.ToString()); result.Add(model.Html); result.Add(model.Url); result.Add(model.CreateDate.GetDateTimeFormats('r')[0].ToString()); } return(result); }
public async Task <IActionResult> EditTerminalProduct(string id) { if (id == null) { return(NotFound()); } var terminal = await _removeTerminal.CheckIfTerminalIsValid(id); if (terminal == null) { return(NotFound()); } ViewData["Terminal"] = terminal.TerminalId; ViewData["TerminalDescription"] = terminal.TerminalDescription; var products = _requestAllProducts.RequestEveryProduct(); var model = new TestProductModel(); model.ProductList = new SelectList(products, "ProductId", "ProductName"); return(View(model)); }