数组操作(字符串)

来源：互联网发布：java天气预报接口api 编辑：程序博客网时间：2024/06/05 17:09

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 = "";
        }