private void import_data() { List <tmpdata> alist = session.blist; List <AI_listenScore> blist = new List <AI_listenScore>(); string sqlstr = string.Format("SELECT batchno FROM AI_listenScore ORDER BY batchno desc LIMIT 1"); var a = MySqlHelper.ExecuteScalar(CommandType.Text, sqlstr); int batchno = 1; string batchdesc = txtbatchdesc.Text.Trim(); if (a != null) { batchno = Convert.ToInt32(a) + 1; } List <string> sqllist = new List <string>(); foreach (var item1 in alist) { AI_listenScore es = new AI_listenScore(); try { es.papercode = getproval(item1, comboBox1.Text); if (textBox1.Text != "") { es.papercode = es.papercode.Replace(textBox1.Text, textBox12.Text); } es.itemno = getproval(item1, comboBox2.Text); if (textBox2.Text != "") { es.itemno = es.itemno.Replace(textBox2.Text, textBox11.Text); } es.encodeno = getproval(item1, comboBox3.Text); if (textBox3.Text != "") { es.encodeno = es.encodeno.Replace(textBox3.Text, textBox10.Text); } es.filename = getproval(item1, comboBox4.Text); if (textBox4.Text != "") { es.filename = es.filename.Replace(textBox4.Text, textBox9.Text); } es.Score1 = getproval(item1, comboBox5.Text); if (textBox5.Text != "") { es.Score1 = es.Score1.Replace(textBox5.Text, textBox8.Text); } es.Statu = "0"; string sql1 = string.Format("INSERT INTO AI_listenScore ( papercode, itemno, encodeno, filename, Score1, Statu,batchno,batchdesc) VALUES ('{0}','{1}','{2}','{3}','{4}' ,'{5}','{6}','{7}')", es.papercode, es.itemno, es.encodeno, es.filename.Replace(@"\", "/"), es.Score1, es.Statu, batchno, batchdesc); sqllist.Add(sql1); } catch (Exception) { //blist.Add(es); } } MySqlHelper.ExecuteSqlTran(sqllist); MessageBox.Show("导入成功!!!"); }