784-1702083623 URC HGH 2750.00 90.00 3.00 HWT680 61490
784-1702083624 URC HGH 2750.00 90.00 3.00 HWT680 61490
784-1702083625 URC HGH 2750.00 90.00 3.00 HWT680 61490
784-1702083641 YIW CAN 770.00 90.00 3.00 HPSXHQ 61490
784-1702083642 YIW CAN 770.00 90.00 3.00 HPSXHQ 61490
784-1702083648 YIW YIW 2100.00 180.00 3.00 HR72RE 61490
784-1702083649 YIW YIW 2100.00 180.00 3.00 HR72RE 61490
784-1702083660 HRB HGH 1140.00 90.00 3.00 HS3MRX 61490
784-1702083672 YIW BJS 1180.00 90.00 3.00 HS3QEN 61490
784-1702083673 YIW BJS 1180.00 90.00 3.00 HS3QEN 61490
784-1702083688 YIW CAN 1100.00 90.00 3.00 HMC21R 61490
784-1702083696 YIW CAN 770.00 90.00 3.00 HXDEWQ 61490
784-1702083697 YIW CAN 770.00 90.00 3.00 HXDEWQ 61490
784-1702083759 YIW CAN 1100.00 90.00 3.00 HDQ99T 61490
784-1702083766 HRH SZX 2270.00 90.00 3.00 HS825Q 61490
784-1702083772 LHW SHA 3500.00 90.00 3.00 HDDQSK 61490
并输到数据库:
string textTemp = TextBox1.Text;
if (textTemp != "")
{
#region 外层
string[] strline = textTemp.Split(new char[] { '/r' });//行
for (int i = 0; i < strline.Length - 1; i++)
{
strline[i] = strline[i].Trim();
if (strline[i] != " ")
{
//Response.Write(strline[i]);
//string[] strlinec = strline[i].Split(Convert.ToChar(" "));
string[] strlinec = strline[i].Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);//例
string a0 = "";
string a1 = "";
string a2 = "";
string a3 = "";
string a4 = "";
string a5 = "";
string a6 = "";
string a7 = "";
#region 内层
for (int j = 0; j < strlinec.Length; j++)
{
if (j == 0)
{
a0 = strlinec[0];
}
if (j == 1)
{
a1 = strlinec[1];
}
if (j == 2)
{
a2 = strlinec[2];
}
if (j == 3)
{
a3 = strlinec[3];
}
if (j == 4)
{
a4 = strlinec[4];
}
if (j == 5)
{
a5 = strlinec[5];
}
if (j == 6)
{
a6 = strlinec[6];
}
if (j == 7)
{
a7 = strlinec[7];
}
}
#endregion
string a1a2 = a1 + " " + a2;
string a6a7 = a6 + " " + a7;
int Maxid = Conn.conn.Maxcode("FlightAccount");
string sql = "insert into FlightAccount( id, [TKT-NuMBER], [ORIG-DEST], COLLECTION, TAXS, COMM, PNPAGENT, AddTime)";
sql += "Values(" + Maxid + ",'" + a0 + "','" + a1a2 + "'," + Convert.ToDouble(a3) + "," + Convert.ToDouble(a4) + "," + Convert.ToDouble(a5) + ",'" + a6a7 + "','" + DateTime.Now + "')";
Conn.conn.Exec(sql);
}
}
#endregion
Response.Write(StringClass.MessageBox("提交成功"));
TextBox1.Text = "";
}