- private void button1_Click(object sender, EventArgs e)
- {
- string text = this.ReadText();
- string clearText = this.Clear(text);
- IList<Air> airList = this.FormatToAirList(clearText);
- bool ok = true;
- foreach (Air airItem in airList)
- {
- ok &= this.Add(airItem);
- }
- if (ok)
- {
- MessageBox.Show("ok");
- }
- else
- {
- MessageBox.Show("False");
- }
- }
- private bool Add(Air air)
- {
- string conStr = "server=10.10.10.96;database=DorichTicket;uid=dorichuser;pwd=2332;Min Pool Size = 3";
- string sqlStr = "insert into AirCity(CityCode,CName,PinYin,AirPort)values('" + air.AirCode + "','"
- + air.AirName + "','" + air.Pinyin + "','" + air.AirPort + "')";
- SqlConnection con = new SqlConnection(conStr);
- SqlCommand cmd = new SqlCommand(sqlStr, con);
- try
- {
- con.Open();
- return cmd.ExecuteNonQuery() > 0;
- }
- catch (SqlException sqEx)
- {
- MessageBox.Show(sqEx.Message);
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- finally
- {
- cmd.Dispose();
- con.Close();
- }
- return false;
- }
- private string ReadText()
- {
- //string phyPath = this.
- StreamReader sr = File.OpenText("F://sql//sql//1.txt");
- return sr.ReadToEnd();
- }
- private string Clear(string value)
- {
- string result = Regex.Replace(value, @"()/1+", "", RegexOptions.None);
- result = result.Replace(@"//new", "");
- result = result.Replace(@"//add new", "");
- result = result.Replace("/"", "");
- result = result.Replace("/"", "");
- return result;
- }
- private IList<Air> FormatToAirList(string value)
- {
- IList<Air> airList = new List<Air>();
- string[] airArr = value.Split(new string[] { "/r/n/t" }, StringSplitOptions.RemoveEmptyEntries);
- foreach (string airArrItem in airArr)
- {
- Air air = new Air();
- string[] airCodeArr = airArrItem.Split(new string[] { ":" }, StringSplitOptions.RemoveEmptyEntries);
- //PEK : {cname : 北京,pinyin : ['bei','jing'],airport : 北京首都国际机场},
- air.AirCode = airCodeArr[0].Trim().ToUpper();
- air.AirName = airCodeArr[2].Split(',')[0].Trim().ToUpper();
- air.Pinyin = airCodeArr[3].Replace("[", "").Replace("]", " ").Replace(",", "").Replace("/'", "").Replace("airport", "").Replace(" ", "").Trim().ToUpper();
- air.AirPort = airCodeArr[4].Replace("}", "").Replace(",", "").Trim().ToUpper();
- airList.Add(air);
- }
- return airList;
- }
- public class Air
- {
- private string airCode;
- private string airName;
- private string pinyin;
- private string airPort;
- private int age;
- public int Age
- {
- get { return age; }
- protected internal set
- {
- if (this.age > 200 || this.age < 0)
- {
- throw new InvalidOperationException("Invalid data");
- }
- this.age = value;
- }
- }
- public string AirCode
- {
- get { return airCode; }
- set
- {
- if (value == null)
- {
- throw new NullReferenceException("Para Null");
- }
- this.airCode = value.Trim().ToUpper();
- }
- }
- public string AirName
- {
- get { return airName; }
- set { airName = value; }
- }
- public string Pinyin
- {
- get { return pinyin; }
- set { pinyin = value; }
- }
- public string AirPort
- {
- get { return airPort; }
- set { airPort = value; }
- }
- }
原始文本
PEK : {cname : "北京", pinyin : ['bei','jing'], airport : "北京首都国际机场"},
CTU :{cname :"成都",pinyin:['cheng','du'], airport :"成都双流机场"},
CKG :{cname :"重庆",pinyin:['chong','qing'], airport :"重庆江北机场"},
DLC :{cname :"大连",pinyin:['da','lian'],airport :"大连周水子机场"},
CAN : {cname : "广州", pinyin : ['guang','zhou'], airport : "广州新白云国际机场"},
HGH :{cname :"杭州",pinyin:['hang','zhou'], airport :"杭州萧山机场"},
TAO :{cname :"青岛",pinyin:['qing','dao'], airport :"青岛流亭机场"},
SHA : {cname : "上海", pinyin : ['shang','hai'], airport : "上海虹桥机场"},
SZX :{cname :"深圳",pinyin:['shen','zhen'], airport :"深圳宝安机场"},
WUH :{cname :"武汉",pinyin:['wu','han'], airport :"武汉天河机场"},
XMN :{cname :"厦门",pinyin:['xia','men'],airport :"厦门高崎机场"},
TSN :{cname :"天津",pinyin:['tian','jin'], airport :"天津滨海国际机场"}
AKU : {cname:"阿克苏", pinyin:['an', 'ke','su'], airport:"阿克苏机场"},
AKA : {cname:"安康", pinyin:['an', 'kang'], airport:"安康机场"},
AQG : {cname : "安庆", pinyin : ['an', 'qing'], airport : "天柱山机场"},
AEB : {cname :"百色",pinyin:['bai','se'], airport:"百色机场"} , //new
BAV : {cname :"包头",pinyin:['bao','tou'],airport :"包头机场"},
BSD : {cname :"保山",pinyin:['bao','shan'], airport :"保山机场"}, //new
BHY : {cname :"北海",pinyin:['bei','hai'],airport :"北海福城机场"},
PEK : {cname :"北京",pinyin:['bei','jing'],airport:"北京首都国际机场"},
CGQ : {cname :"长春",pinyin:['chang','chun'], airport :"长春大房身机场"},
CSX : {cname :"长沙",pinyin:['chang','sha'], airport :"长沙黄花机场"},
CGD : {cname :"常德",pinyin:['chang','de'], airport :"常德半姆湖机场"},
CZX : {cname :"常州",pinyin:['chang','zhou'], airport :"常州奔牛机场"},
CIH : {cname : "长治", pinyin : ['chang', 'zhi'], airport : "长治机场"},
CTU : {cname :"成都",pinyin:['cheng','du'], airport :"成都双流机场"},
CIF : {cname : "赤峰", pinyin : ['chi', 'feng'], airport : "赤峰机场"},
CKG : {cname :"重庆",pinyin:['chong','qing'], airport :"重庆江北机场"},
DLU : {cname :"大理",pinyin:['da','li'], airport :"大理机场"}, //new
DLC : {cname :"大连",pinyin:['da','lian'],airport :"大连周水子机场"},
DAX : {cname :"达县",pinyin:['da','xian'],airport :"达县机场"},
DAT : {cname : "大同", pinyin : ['da', 'tong'], airport : "大同机场"},
DDG : {cname :"丹东",pinyin:['dan','dong'], airport :"丹东浪头机场"},
DNH : {cname :"敦煌",pinyin:['dun','huang'], airport :"敦煌机场"}, //new
ENH : {cname : "恩施", pinyin : ['en', 'shi'], airport : "恩施机场"},
FOC : {cname :"福州",pinyin:['fu','zhou'],airport :"福州长乐机场"},
KOW : {cname :"赣州",pinyin:['gan','zhou'], airport :"赣州黄金机场"},
CAN : {cname :"广州",pinyin:['guang','zhou'], airport :"广州新白云国际机场"},
KWE : {cname :"贵阳",pinyin:['gui','yang'], airport :"贵阳龙洞堡机场"},
KWL : {cname :"桂林",pinyin:['gui','lin'],airport :"桂林两江国际机场"},
HRB : {cname :"哈尔滨", pinyin:['ha','er','bin'], airport :"哈尔滨太平机场"},
HAK : {cname :"海口",pinyin:['hai','kou'],airport :"海口美兰机场"},
HLD : {cname :"海拉尔",pinyin :['hai','la','er'], airport:"东山机场"}, //new
HDG : {cname :"邯郸",pinyin : ['han', 'dan'], airport : "邯郸机场"},
HZG : {cname : "汉中", pinyin : ['han', 'zhong'], airport : "汉中机场"},
HGH : {cname :"杭州",pinyin:['hang','zhou'], airport :"杭州萧山机场"},
HFE : {cname :"合肥",pinyin:['he','fei'], airport :"合肥骆岗机场"},
HET : {cname :"呼和浩特", pinyin:['hu','he','hao','te'], airport:"呼和浩特白塔机场"},
TXN : {cname :"黄山",pinyin:['huang','shan'], airport :"黄山屯溪机场"},
HYN : {cname :"黄岩",pinyin:['huang','yan'], airport :"黄岩路桥机场"},
JIL : {cname :"吉林",pinyin:['ji','lin'], airport :"吉林二台子机场"},
TNA : {cname :"济南",pinyin:['ji','nan'], airport :"济南遥墙机场"},
JMU : {cname :"佳木斯",pinyin :['jia','mu','si'], airport:"东郊机场"}, //new
JNZ : {cname :"锦州",pinyin:['jin','zhou'], airport :"锦州小岭子机场"},
JJN : {cname :"晋江",pinyin:['jin','jiang'], airport :"晋江泉州机场"},
JDZ : {cname :"景德镇",pinyin :['jing','de','zhen'], airport :"景德镇机场"}, //new
JIU : {cname : "九江", pinyin : ['jiu', 'jiang'], airport : "九江机场"},
JZH : {cname: "九寨沟", pinyin : ['jiu','zhai','gou'], airport : "九黄机场"}, //new
KRL : {cname : "库尔勒", pinyin : ['ku','er','le'], airport : "地窝堡机场"},
KMG :{cname :"昆明",pinyin:['kun','ming'], airport :"昆明巫家坝机场"},
LXA :{cname :"拉萨",pinyin:['la','sa'], airport :"拉萨贡嘎机场"},
LHW :{cname :"兰州",pinyin:['lan','zhou'], airport :"兰州中川机场"},
LJG :{cname :"丽江",pinyin:['li','jiang'], airport :"丽江机场"} , //new
LYG :{cname :"连云港", pinyin:['lian','yun','gang'], airport :"连云港白塔寺机场"},
LNC :{cname :"临沧",pinyin:['lin','cang'], airport :"临沧机场"}, //new
LYI :{cname :"临沂",pinyin:['lin','yi'], airport:"临沂机场"}, //new
LZH :{cname :"柳州",pinyin:['liu','zhou'], airport :"柳州白莲机场"},
LZO :{cname :"泸州",pinyin:['lu','zhou'],airport :"泸州兰田坝机场"},
LYA :{cname :"洛阳",pinyin:['luo','yang'], airport :"洛阳北郊机场"},
LUM :{cname :"芒市",pinyin:['mang','shi'], airport :"芒市机场"} , //new
MXZ :{cname :"梅州",pinyin:['mei','zhou'], airport :"梅县机场"},
NZH : {cname : "满洲里", pinyin : ['mian', 'zhou'], airport : "西郊机场"},
MIG : {cname: "绵阳", pinyin : ['mian','yang'], airport : "南郊机场"}, //add new
MDG :{cname :"牡丹江", pinyin:['mu','dan','jiang'], airport :"牡丹江海浪机场"},
KHN :{cname :"南昌",pinyin:['nan','chang'], airport :"南昌昌北机场"},
NAO : {cname : "南充", pinyin : ['nan', 'chong'], airport : "南充高坪机场"},
NKG :{cname :"南京",pinyin:['nan','jing'], airport :"南京禄口机场"},
NNG :{cname :"南宁",pinyin:['nan','ning'], airport :"南宁吴墟机场"},
NTG :{cname :"南通",pinyin:['nan','tong'], airport :"南通兴东机场"},
NNY :{cname :"南阳",pinyin:['nan','yang'], airport :"南阳姜营机场"},
NAY : {cname : "南苑", pinyin : ['nan', 'yuan'], airport : "北京南苑机场"},
NGB :{cname :"宁波",pinyin:['ning','bo'],airport :"宁波栎社机场"},
PZI :{cname :"攀枝花",pinyin:['pan','zhi','hua'], airport :"攀枝花机场"}, //new
NDG :{cname :"齐齐哈尔",pinyin :['qi','qi','ha','er'], airport :"三家子机场"} ,
SHP :{cname :"秦皇岛", pinyin:['qin','huang','dao'], airport :"秦皇岛山海关机场"},
TAO :{cname :"青岛",pinyin:['qing','dao'], airport :"青岛流亭机场"},
JUZ :{cname :"衢州",pinyin:['qu','zhou'],airport :"衢州机场"},
SYX :{cname :"三亚",pinyin:['san','ya'], airport :"三亚凤凰机场"},
SWA :{cname :"汕头",pinyin:['shan','tou'], airport :"汕头外砂机场"},
SHA :{cname :"上海",pinyin:['shang','hai'], airport :"上海虹桥机场"},
PVG :{cname :"上海浦东", pinyin :['shang','hai','pu','dong'], airport :"上海浦东机场"},
SZX :{cname :"深圳",pinyin:['shen','zhen'], airport :"深圳宝安机场"},
SHE :{cname :"沈阳",pinyin:['she','yang'], airport :"沈阳桃仙机场"},
SJW :{cname :"石家庄", pinyin:['shi','jia','zhuang'], airport :"石家庄正定机场"},
SYM :{cname :"思茅",pinyin:['si','mao'], airport:"思茅机场"}, //new
TYN :{cname :"太原",pinyin:['tai','yuan'], airport :"太原武宿机场"},
TSN :{cname :"天津",pinyin:['tian','jin'], airport :"天津滨海国际机场"},
TEN :{cname :"铜仁",pinyin:['tong','ren'], airport:"大兴机场"}, //new
WXN :{cname :"万县",pinyin:['wan','xian'], airport :"万县梁平机场"},
WEH :{cname :"威海",pinyin:['wei','hai'], airport:"大水泊机场"}, //new
WEF :{cname :"潍坊",pinyin:['wei','fang'], airport:"文登机场"} , //new
WNH : {cname : "文山", pinyin : ['wen', 'shan'], airport : "文山机场"},
WNZ :{cname :"温州",pinyin:['wen','zhou'], airport :"温州永强机场"},
URC :{cname :"乌鲁木齐", pinyin:['wu','lu','mu','qi'], airport:"乌鲁木齐地窝铺机场"},
WUX :{cname :"无锡",pinyin:['wu','xi'], airport :"无锡机场"}, //new
WUH :{cname :"武汉",pinyin:['wu','han'], airport :"武汉天河机场"},
WUS :{cname :"武夷山",pinyin :['wu','yi','shan'], airport:"武夷山机场"}, //new
XIY :{cname :"西安",pinyin:['xi','an'], airport :"西安咸阳机场"},
XIC : {cname : "西昌", pinyin : ['xi', 'chang'], airport:"青龙机场"},
XNN :{cname :"西宁",pinyin:['xi','ning'],airport :"西宁曹家堡机场"},
JHG :{cname :"西双版纳(景洪)",pinyin:['xi','shuang','ban','na'], airport:"嘎洒机场"},
XMN :{cname :"厦门",pinyin:['xia','men'],airport :"厦门高崎机场"},
DIG :{cname :"香格里拉(中甸)",pinyin:['xiang','ge','li','la'], airport :"中甸机场"}, //new
XFN :{cname :"襄樊",pinyin:['xiang','fan'], airport :"襄樊刘集机场"},
ACX : {cname : "兴义", pinyin : ['xing', 'yi'], airport : "兴义机场"},
XUZ :{cname :"徐州",pinyin:['xu','zhou'],airport :"徐州观音机场"},
ENY : {cname : "延安", pinyin : ['yan', 'an'], airport : "延安机场"},
YNZ :{cname :"盐城",pinyin:['yan','cheng'], airport :"盐城机场"}, //new
YNJ : {cname : "延吉", pinyin : ['yan', 'ji'], airport : "延吉机场"},
YNT :{cname :"烟台",pinyin:['yan','tai'],airport :"烟台莱山机场"},
YBP :{cname :"宜宾",pinyin:['yi','bin'], airport :"宜宾菜坝机场"},
YIH :{cname :"宜昌",pinyin:['yi','chang'], airport :"宜昌三峡机场"},
YIN : {cname : "伊宁", pinyin : ['yi', 'ning'], airport : "伊宁机场"},
YIW :{cname :"义乌",pinyin:['yi','wu'], airport :"义乌机场"},
INC :{cname :"银川",pinyin:['yin','chuan'], airport :"银川河东机场"},
YCU :{cname :"运城",pinyin:['yun','cheng'], airport :"运城机场"} , //new
UYN : {cname : "榆林", pinyin : ['yu', 'lin'], airport : "榆林机场"},
ZHA :{cname :"湛江",pinyin:['zhan','jiang'], airport :"湛江机场"}, //new
DYG :{cname :"张家界", pinyin:['zhang','jia','jie'], airport :"张家界机场"},
ZAT :{cname :"昭通",pinyin:['zhao','tong'], airport :"昭通机场"}, //new
CGO :{cname :"郑州",pinyin:['zheng','zhou'], airport :"郑州新郑机场"},
HJJ : {cname : "芷江", pinyin : ['zhi', 'jiang'], airport : "芷江机场"},
HSN : {cname : "舟山", pinyin : ['zhou', 'shan'], airport : "朱家尖机场"},
ZUH :{cname :"珠海",pinyin:['zhu','hai'],airport :"珠海三灶机场"}
=======================================================
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- string text = this.ReadText(this.FileUpload1.PostedFile.InputStream);
- string clearText = this.Clear(text);
- IList<BocTrade> bocTradeList = this.FormatToList(clearText);
- bool ok = true;
- foreach (BocTrade item in bocTradeList)
- {
- ok &= this.Add(item);
- }
- if (ok)
- {
- Response.Write("ok");
- }
- else
- {
- Response.Write("False");
- }
- }
- private bool Add(BocTrade bocTrade)
- {
- Response.Write(bocTrade.TerminalId + "<br>");
- Response.Write(bocTrade.TradeDate + "<br>");
- Response.Write(bocTrade.TradeTime + "<br>");
- Response.Write(bocTrade.TradeAccount + "<br>");
- Response.Write(bocTrade.TradeAount + "<br>");
- Response.Write(bocTrade.Commission + "<br>");
- Response.Write(bocTrade.BalanceAmout + "<br>");
- Response.Write(bocTrade.TradeType + "<br>");
- return true;
- }
- private string ReadText(Stream stream)
- {
- BufferedStream bfs = null;
- StreamReader sr = null;
- try
- {
- bfs = new BufferedStream(stream);
- sr = new StreamReader(bfs, Encoding.GetEncoding("GB2312"));
- bfs.Flush();
- return sr.ReadToEnd();
- }
- finally
- {
- if (bfs != null) { bfs.Close(); }
- if (sr != null) { sr.Close(); }
- }
- }
- private string Clear(string value)
- {
- string headText = "终端号 交易日期 交易时间 交易帐号 交易金额 回扣 结算金额 授权码 交易类型";
- string footText = "小计 笔数";
- int headPos = value.IndexOf(headText) + headText.Length;
- int footPos = value.IndexOf(footText);
- string tradeRecord = value.Substring(headPos, footPos - headPos);
- return Regex.Replace(tradeRecord, @"( )+", " ", RegexOptions.None);
- }
- private IList<BocTrade> FormatToList(string value)
- {
- IList<BocTrade> bocTradeList = new List<BocTrade>();
- string[] tradeRecordList = value.Split(new string[] { "/r/n" }, StringSplitOptions.RemoveEmptyEntries);
- foreach (string item in tradeRecordList)
- {
- BocTrade bocTrade = new BocTrade();
- string[] bocArr = item.Split(' ');
- bocTrade.TerminalId = bocArr[0];
- bocTrade.TradeDate = bocArr[1];
- bocTrade.TradeTime = bocArr[2];
- bocTrade.TradeAccount = bocArr[3];
- bocTrade.TradeAount = bocArr[4];
- bocTrade.Commission = bocArr[5];
- bocTrade.BalanceAmout = bocArr[6];
- //根据特性判定bocArr[7]为AuthorizeCode,还是TradeType
- bocTrade.AuthorizeCode = string.Empty;
- bocTrade.TradeType = bocArr[7];
- bocTradeList.Add(bocTrade);
- }
- return bocTradeList;
- }
- public class BocTrade
- {
- private string terminalId;
- private string tradeDate;
- private string tradeTime;
- private string tradeAccount;
- private string tradeAount;
- private string commission;
- private string balanceAount;
- private string authorizeCode;
- private string tradeType;
- public string TerminalId
- {
- get { return terminalId; }
- set { terminalId = value; }
- }
- public string TradeDate
- {
- get { return tradeDate; }
- set { tradeDate = value; }
- }
- public string TradeTime
- {
- get { return tradeTime; }
- set { tradeTime = value; }
- }
- public string TradeAccount
- {
- get { return tradeAccount; }
- set { tradeAccount = value; }
- }
- public string TradeAount
- {
- get { return tradeAount; }
- set { tradeAount = value; }
- }
- public string Commission
- {
- get { return commission; }
- set { commission = value; }
- }
- public string BalanceAmout
- {
- get { return balanceAount; }
- set { balanceAount = value; }
- }
- public string AuthorizeCode
- {
- get { return authorizeCode; }
- set { authorizeCode = value; }
- }
- public string TradeType
- {
- get { return tradeType; }
- set { tradeType = value; }
- }
- }