/// <summary> /// 将集合中的对象插入到数据库 /// </summary> /// <param name="list"></param> /// <returns></returns> public bool Import(List <Student> list) { List <string> sqlList = new List <string>(); StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("insert into Students(studentName,Gender,Birthday,"); sqlBuilder.Append("StudentIdNo,Age,PhoneNumber,StudentAddress,CardNo,ClassId)"); sqlBuilder.Append(" values('{0}','{1}','{2}',{3},{4},'{5}','{6}','{7}',{8})"); foreach (Student objStudent in list) { string sql = string.Format(sqlBuilder.ToString(), objStudent.StudentName, objStudent.Gender, objStudent.Birthday, objStudent.StudentIdNo, objStudent.Age, objStudent.PhoneNumber, objStudent.StudentAddress, objStudent.CardNo, objStudent.ClassId); sqlList.Add(sql); } return(SQLHelper.UpdateByTran(sqlList)); }