-
Notifications
You must be signed in to change notification settings - Fork 0
/
Program.cs
183 lines (160 loc) · 8.68 KB
/
Program.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
using System;
using Excel = Microsoft.Office.Interop.Excel;
using System.IO;
using System.Text;
namespace FrameWork发票
{
class Program
{
static void Main(string[] args)
{
ExcelOp eo = new ExcelOp();
//Console.WriteLine("请输入税控盘持有人姓名:");
Console.WriteLine("请讲文件拖入此处(文件的名称格式为：xx商品编码，xx为税控盘名称！且软件运行后生成的excel文件在 《文档》 文件夹中)\n");
string fullname = Console.ReadLine();
Console.WriteLine("\n正在转换中，请耐心等待。。。");
string name = fullname.Substring(fullname.LastIndexOf("\\")+1, fullname.LastIndexOf("商品编码")+4- fullname.LastIndexOf("\\")-1);
eo.CreateExcelFile(name);
object Nothing = System.Reflection.Missing.Value;
Excel.Application app = new Excel.Application();
app.Visible = false;
//string item = eo.Read(string.Format("E://个人文件//妈妈//{0}商品编码.txt",name));
string item = eo.Read(fullname);
item = item.Substring(item.IndexOf("<SPXX>"));
int lastRow = item.LastIndexOf("<Row PID=\"");
int i1 = 0, i1_ = 0, i2 = 0, i2_ = 0, i3 = 0, i3_ = 0, i4 = 0, i4_ = 0, i5 = 0, i5_ = 0, i6 = 0, i6_ = 0, i7 = 0, i7_ = 0, i8 = 0, i8_ = 0, i9 = 0, i9_ = 0, i10 = 0, i10_ = 0, i11 = 0, i11_ = 0;
try
{
while (i8<lastRow)
{
Excel.Workbook mybook = app.Workbooks.Open(name, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);
Excel.Worksheet mysheet = (Excel.Worksheet)mybook.Worksheets[1];
i1 = item.IndexOf("MC=\"",i1_)+ "MC=\"".Length;//商品名称MC
i1_ = item.IndexOf("\"",i1);
i2 = item.IndexOf(" BM=\"",i2_)+ " BM=\"".Length;//商品编码BM
i2_ = item.IndexOf("\"",i2);
i3 = item.IndexOf("JM=\"",i3_)+ "JM=\"".Length;//简码JM
i3_ = item.IndexOf("\"",i3);
i4 = item.IndexOf("SPFLBM=\"",i4_) + "SPFLBM=\"".Length;//商品分类编码
i4_ = item.IndexOf("\"", i4);
i5 = item.IndexOf("SL=\"",i5_)+ "SL=\"".Length;//税率SL
i5_ = item.IndexOf("\"",i5);
i6 = item.IndexOf("GGXH=\"",i6_)+ "GGHX=\"".Length;//规格/厂牌GGXH
i6_ = item.IndexOf("\"",i6);
i7 = item.IndexOf("JLDW=\"",i7_)+ "JLDW=\"".Length;//计量单位JLDW
i7_ = item.IndexOf("\"",i7);
i8 = item.IndexOf("<Row PID=\"",i8_)+ "<Row PID=\"".Length;//适用税率PID
i8_ = item.IndexOf("\"",i8);
i9 = item.IndexOf("HSBZ=\"",i9_)+ "HSBZ=\"".Length;//含税标志HSBZ
i9_ = item.IndexOf("\"",i9);
i10 = item.IndexOf("YHZC=\"",i10_)+ "YHZC=\"".Length;//优惠政策类型YHZC
i10_ = item.IndexOf("\"",i10);
i11 = item.IndexOf("SLLX=\"",i11_)+ "SLLX=\"".Length;//免税类型SLLX
i11_ = item.IndexOf("\"",i11);
//int i1 = item.IndexOf("<SPMC>");//商品名称MC
//int i1_ = item.IndexOf("</SPMC>");
//int i2 = item.IndexOf("<SPBM>");//商品编码BM
//int i2_ = item.IndexOf("</SPBM>");
//int i3 = item.IndexOf("<JM>");//简码JM
//int i3_ = item.IndexOf("</JM>");
//int i4 = item.IndexOf("<SPBMJC>");//税收分类简称
//int i4_ = item.IndexOf("</SPBMJC>");
//int i5 = item.IndexOf("<ZZSSL>");//税率SL
//int i5_ = item.IndexOf("</ZZSSL>");
//int i6 = item.IndexOf("<GGXH>");//规格/厂牌GGXH
//int i6_ = item.IndexOf("</GGXH>");
//int i7 = item.IndexOf("<JLDW>");//计量单位JLDW
//int i7_ = item.IndexOf("</JLDW>");
//int i8 = item.IndexOf("<KYSL>");//适用税率PID
//int i8_ = item.IndexOf("</KYSL>");
//int i9 = item.IndexOf("<HSBZ>");//含税标志HSBZ
//int i9_ = item.IndexOf("</HSBZ>");
//int i10 = item.IndexOf("<YH>");//优惠政策类型YHZC
//int i10_ = item.IndexOf("</YH>");
//int i11 = item.IndexOf("<SYPC>");//免税类型SLLX
//int i11_ = item.IndexOf("</SYPC>");
string c1 = item.Substring(i1, i1_ - i1 );
string c2 = item.Substring(i2, i2_ - i2 );
string c3 = item.Substring(i3, i3_ - i3 );
string c4 = item.Substring(i4, i4_ - i4 );
string c5 = item.Substring(i5, i5_ - i5 );
string c6 = item.Substring(i6, i6_ - i6 );
string c7 = item.Substring(i7, i7_ - i7 );
string c8 = item.Substring(i8, i8_ - i8 );
string c9 = item.Substring(i9, i9_ - i9 );
string c10 = item.Substring(i10 , i10_ - i10 );
string c11 = item.Substring(i11 , i11_ - i11 );
eo.WriteToExcel("全部商品", c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, mybook, mysheet, Nothing, app);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("\n转换完成！请在‘我的文档’中查找点击！输入回车自动退出。");
Console.ReadKey();
app.Quit();
}
}
}
class ExcelOp
{
public string Read(string path)
{
StreamReader sr = new StreamReader(path, Encoding.UTF8);
return sr.ReadToEnd();
}
internal void CreateExcelFile(string FileName)
{
//create
object Nothing = System.Reflection.Missing.Value;
var app = new Excel.Application();
app.Visible = false;
Excel.Workbook workBook = app.Workbooks.Add(Nothing);
Excel.Worksheet worksheet = (Excel.Worksheet)workBook.Sheets[1];
worksheet.Name = FileName;
//headline
worksheet.Cells[1, 1] = "名称";
worksheet.Cells[1, 2] = "编码";
//worksheet.Cells[1, 2].numberFormatting = "@";
worksheet.Cells[1, 3] = "简码";
worksheet.Cells[1, 4] = "商品分类编码";
worksheet.Cells[1, 5] = "税率";
//worksheet.Cells[1, 5].numberFormatting = "formatnumber";
worksheet.Cells[1, 6] = "规格/厂牌";
worksheet.Cells[1, 7] = "计量单位";
worksheet.Cells[1, 8] = "适用税率";
worksheet.Cells[1, 9] = "含税标志";
worksheet.Cells[1, 10] = "优惠政策类型";
worksheet.Cells[1, 11] = "免税类型";
worksheet.Columns[2].NumberFormatLocal = "@";//设置第二列为 文本格式
worksheet.Columns[4].NumberFormatLocal = "@";
worksheet.SaveAs(FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing);
workBook.Close(false, Type.Missing, Type.Missing);
app.Quit();
}
internal void WriteToExcel(string excelName, string c1, string c2, string c3, string c4, string c5, string c6, string c7, string c8, string c9, string c10, string c11, Excel.Workbook mybook, Excel.Worksheet mysheet, object Nothing, Excel.Application app)
{
//open
mysheet.Activate();
//get activate sheet max row count
int maxrow = mysheet.UsedRange.Rows.Count + 1;
mysheet.Cells[maxrow, 1] = c1;
mysheet.Cells[maxrow, 2] = c2;
mysheet.Cells[maxrow, 3] = c3;
mysheet.Cells[maxrow, 4] = c4;
mysheet.Cells[maxrow, 5] = c5;
mysheet.Cells[maxrow, 6] = c6;
mysheet.Cells[maxrow, 7] = c7;
mysheet.Cells[maxrow, 8] = c8;
mysheet.Cells[maxrow, 9] = c9;
mysheet.Cells[maxrow, 10] = c10;
mysheet.Cells[maxrow, 11] = c11;
mybook.Save();
mybook.Close(false, Type.Missing, Type.Missing);
mybook = null;
}
}
}