// 插入一批日志记录
int AppendOperLogLines(
SQLiteConnection connection,
List <OperLogLine> lines,
out string strError)
{
strError = "";
using (SQLiteCommand command = new SQLiteCommand("",
connection))
{
StringBuilder text = new StringBuilder(4096);
int i = 0;
foreach (OperLogLine line in lines)
{
text.Append(
" INSERT INTO records(operation, action, itembarcode, location, readerbarcode, librarycode, opertime) "
+ " VALUES(@operation" + i
+ ", @action" + i
+ ", @itembarcode" + i
+ ", @location" + i
+ ", @readerbarcode" + i
+ ", @librarycode" + i
+ ", @opertime" + i + ")"
+ " ; ");
SQLiteUtil.SetParameter(command,
"@operation" + i,
line.Operation);
SQLiteUtil.SetParameter(command,
"@action" + i,
line.Action);
SQLiteUtil.SetParameter(command,
"@itembarcode" + i,
line.ItemBarcode);
SQLiteUtil.SetParameter(command,
"@location" + i,
line.ItemLocation);
SQLiteUtil.SetParameter(command,
"@librarycode" + i,
line.LibraryCode);
SQLiteUtil.SetParameter(command,
"@opertime" + i,
line.OperTime);
i++;
}
command.CommandText = text.ToString();
int nCount = command.ExecuteNonQuery();
}
return(0);
}