从txt文档中读取数据并做相应处理(c#)

从txt文本文档中读取数据并做相应处理(c#)

---

• txt文本文档内数据情况（部分）

HW0401 农药废液/废水 

• 处理后生成的相应语句(部分)

insert into T_COMN_GGDMZ(DM,DMNR,DMJBH,CJSJ,ORGID) VALUES('HW04','农药废液','2010102501',SYSDATE,'440301');
insert into T_COMN_GGDMZ(DM,DMNR,DMJBH,CJSJ,ORGID) VALUES('HW04','废水','2010102501',SYSDATE,'440301');

• 分析说明

HW04和农药废液是不断变化的部分，其余的都是公共部分。

• 代码实现

class Program { static void Main(string[] args) { Program p = new Program(); string left = @"insert into T_COMN_GGDMZ(DM,DMNR,DMJBH,CJSJ,ORGID) VALUES('"; string right = "','2010102501',SYSDATE,'440301');"; string[] splitSign = new string[] { "/" }; string readFilePath = @"001.txt"; string writeFilePath = @"007.txt"; Encoding encoding = Encoding.GetEncoding("GBK"); p.Sql(left, right, splitSign, readFilePath, writeFilePath, encoding); } #region 相关方法 /// <summary> /// 007 /// </summary> /// <param name="left">连接的左边字符串</param> /// <param name="right">连接的右边字符串</param> /// <param name="splitSign">污染物之间的分隔符号 如、 ， /等</param> /// <param name="initialFilePath">要读取的文件路径</param> /// <param name="resultFilePath">要写入的文件路径</param> /// <param name="encoding">读取文件和写入文件的编码方式</param> /* * 当txt文档为ANSI编码时候，用utf-8编码，汉字会出现乱码？ txt其他的编码方式显示正常。 * 无论txt文档为何种编码方式，用GBK编码都能实现汉字正常显示。 */ void Sql(string left, string right, string[] splitSign, string readFilePath, string writeFilePath, Encoding encoding) { FileStream fs = null; StreamReader sr = null; StreamWriter sw = null; try { fs = new FileStream(readFilePath, FileMode.Open, FileAccess.Read); sr = new StreamReader(fs, encoding); // Console.WriteLine(sr.CurrentEncoding.EncodingName); string all = sr.ReadToEnd(); sr.Dispose(); fs.Dispose(); string[] lines = all.Split(new char[] { '/n' }); int length = lines.Length; string temp = null; string bh = null; string[] list = null; string[] split; fs = new FileStream(writeFilePath, FileMode.Create, FileAccess.Write); sw = new StreamWriter(fs, encoding); for (int i = 0; i < length; i++) { //每次读取一行数据 temp = lines[i]; //当某行为空白行时，自动读取下一行。 if (temp == "/r") { continue; } //把每行数据根据情况，分成若干部分 split = Regex.Split(temp, @"[' ']+|['/t']+|['/r']+"); bh = split[0].Substring(0, 4); list = split[1].Split(splitSign, StringSplitOptions.RemoveEmptyEntries); for (int k = 0; k < list.Length; k++) { //Console.WriteLine(left+bh+"','"+list[k]+right); sw.WriteLine(left + bh + "','" + list[k] + right); } } } catch (Exception) { throw; } finally { if (sr != null) { sr.Close(); } sw.Close(); fs.Close(); } } #endregion }