111,092
社区成员




public bool Add(List<img_entry_one> list)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into img_entry_one(");
strSql.Append("IMG_ID,FOLDER_ID,STATU_ID,WORK_TIME,START_TIME,END_TIME,OUTPUT_STATUS,INPUT_DATA)");
strSql.Append("values");
for (int i = 0; i < list.Count; i++)
{
if ((i == 0 || i % 500 == 1) && i != 1)
{
strSql.Append("(" + "'" + list[i].IMG_ID + "'");
strSql.Append("," + "'" + list[i].FOLDER_ID + "'");
//strSql.Append("," + "'" + list[i].USER_ID + "'");
strSql.Append("," + "'" + list[i].STATU_ID + "'");
strSql.Append("," + "'" + list[i].WORK_TIME + "'");
strSql.Append("," + "'" + list[i].START_TIME + "'");
strSql.Append("," + "'" + list[i].END_TIME + "'");
strSql.Append("," + "'" + list[i].OUTPUT_STATUS + "'");
strSql.Append("," + "'" + list[i].INPUT_DATA + "'" + ")");
}
else
{
strSql.Append(",(" + "'" + list[i].IMG_ID + "'");
strSql.Append("," + "'" + list[i].FOLDER_ID + "'");
//strSql.Append("," + "'" + list[i].USER_ID + "'");
strSql.Append("," + "'" + list[i].STATU_ID + "'");
strSql.Append("," + "'" + list[i].WORK_TIME + "'");
strSql.Append("," + "'" + list[i].START_TIME + "'");
strSql.Append("," + "'" + list[i].END_TIME + "'");
strSql.Append("," + "'" + list[i].OUTPUT_STATUS + "'");
strSql.Append("," + "'" + list[i].INPUT_DATA + "'" + ")");
}
if (i % 500 == 0 && i != 0)
{
strSql.Append(";");
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString());
if (i == list.Count - 1)
{
return true;
}
strSql = new StringBuilder();
strSql.Append("insert into img_entry_one(");
strSql.Append("IMG_ID,FOLDER_ID,STATU_ID,WORK_TIME,START_TIME,END_TIME,OUTPUT_STATUS,INPUT_DATA)");
strSql.Append("values");
}
else if (i == list.Count - 1)
{
strSql.Append(";");
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString());
return true;
}
}
return false;
}
string sql = "";
foreach(Row row in list){
sql += "insert ... values(...);";
}
//最后执行cmd