需要阅读文本文件表 [英] need to read Text file tables
本文介绍了需要阅读文本文件表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
i需要以下要求的帮助。
我们有一些table.need文本文件,根据运行编号将这些表作为记录插入DataBase。请帮帮我吧。
i need help on below requirment.
we have text file having some tables.need to insert these table as a record into DataBase based on Run number.please help me on this.
------------------------------------------------------------------------------------------------------------------------------------
| From | To | | |
Wrh | Zone | Zone | Item Rev. | Quantity (Str.Un.) | Picked
Miss. | Location | Location | Description/Remark Inventory Date Pack.| | Quantity
Seq. | Row/Level/Bin | Row/Level/Bin | Lot Def. | |
-------+---------------+---------------+---------------------------------------------------------+--------------------+-------------
Run : BGLKAMAN Delivery Date: 23122013 00:00
Order Origin : Sales
Order : NOK000017
Ship To Type : Business Partner
Ship To Code : BPS000191
Position Number : 70
859001 | | | NOK-00807G4 | |
1 |BULK | STAGE | CARE A COVER & TOUCH ASSY 20-12-13 10:21:48 | 8000.0000 ea |
5 | | | | |
| | | | |
Position Number : 100
859001 | | | NOK-00808W4 | |
1 |BULK | STAGE | CARE WINDOW FRAME ASSEMBL 20-12-13 10:22:09 | 11000.0000 ea |
10 | | | | |
| | | | |
Position Number : 110
859001 | | | NOK-00809K8 | |
1 |BULK | STAGE | CARE DISPLAY MODULE ASSY 20-12-13 10:22:33 | 12000.0000 ea |
15 | | | | |
| | | | |
Position Number : 120
859001 | | | NOK-00809K9 | |
1 |BULK | STAGE | CARE USB PWB ACF ASSEMBLY 20-12-13 10:22:51 | 13000.0000 ea |
20 | | | | |
| | | | |
Reprint CHECKED :
Date : 20-12-13 [11:06, Asi] PICKING LIST BY ORDER NUMBER Page : 2
Company : 859
------------------------------------------------------------------------------------------------------------------------------------
| From | To | | |
Wrh | Zone | Zone | Item Rev. | Quantity (Str.Un.) | Picked
Miss. | Location | Location | Description/Remark Inventory Date Pack.| | Quantity
Seq. | Row/Level/Bin | Row/Level/Bin | Lot Def. | |
-------+---------------+---------------+---------------------------------------------------------+--------------------+-------------
Run : BGLKAMAN Delivery Date: 24122013 00:00
Order Origin : Sales
Order : NOK000029
Ship To Type : Business Partner
Ship To Code : BPS000191
Position Number : 20
859001 | | | NOK-00801J8 | |
1 |BULK | STAGE | CARE A COVER AND TOUCH WI 20-12-13 10:23:33 | 2000.0000 ea |
25 | | | | |
| | | | |
Position Number : 50
859001 | | | NOK-00801S3 | |
1 |BULK | STAGE | Care A COVER ASSY NCVM GO 20-12-13 10:21:28 | 2000.0000 ea |
30 | | | | |
| | | | |
Position Number : 60
859001 | | | NOK-00807G4 | |
1 |BULK | STAGE | CARE A COVER & TOUCH ASSY 20-12-13 10:21:48 | 1000.0000 ea |
35 | | | | |
| | | | |
Position Number : 70
859001 | | | NOK-00808W4 | |
1 |BULK | STAGE | CARE WINDOW FRAME ASSEMBL 20-12-13 10:22:09 | 2000.0000 ea |
40 | | | | |
| | | | |
Position Number : 80
859001 | | | NOK-00809K8 | |
1 |BULK | STAGE | CARE DISPLAY MODULE ASSY 20-12-13 10:22:33 | 3000.0000 ea |
45 | | | | |
| | | | |
Position Number : 90
859001 | | | NOK-00809K9 | |
1 |BULK | STAGE | CARE USB PWB ACF ASSEMBLY 20-12-13 10:22:51 | 3000.0000 ea |
50 | | | | |
| | | | |
推荐答案
没有什么难事......试试吧!
步骤:
There is nothing hard to do... Try!
Steps to do:
- 逐行阅读文本文件 如何:从文本文件中读取(C#编程指南) [ ^ ]
- 然后按
| $ c拆分$ c>delimiter
如何:拆分字符串(C#编程指南) [ ^ ]
- Read text file line by line How to: Read From a Text File (C# Programming Guide)[^]
- Then split line by "
|
" delimiter How to: Split Strings (C# Programming Guide)[^]
table.RootModels.Add(record);
record = new RootModel();
record.RootID = Guid.NewGuid().ToString();
start = false;
ExtraData = "";
这篇关于需要阅读文本文件表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文