コード例 #1
0
ファイル: Main.cs プロジェクト: jgh004/ITnmg.CsvHelper
        /// <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);
            }
        }
コード例 #2
0
ファイル: Main.cs プロジェクト: jgh004/ITnmg.CsvHelper
        /// <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);
        }
コード例 #3
0
ファイル: Main.cs プロジェクト: jgh004/ITnmg.CsvHelper
        /// <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);
        }
コード例 #4
0
        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));
        }