public static void AddRecord(FPFile file, string method)
{
string sql = "insert into record(name, srcpath, destpath, method, status, recordtime) values"
+ "(@name, @srcpath, @destpath, @method, @status, @recordtime)";
SQLiteParameter[] ps = new SQLiteParameter[] {
new SQLiteParameter("@name", file.mSrcName),
new SQLiteParameter("@srcpath", file.mSrcPath),
new SQLiteParameter("@destpath", file.mDstPath),
new SQLiteParameter("@method", method),
new SQLiteParameter("@status", FPFile.GetStatusString(file.mStatus)),
new SQLiteParameter("@recordtime", DateTime.Now)
};
DBUtil.ExecuteNonQuery(sql, ps);
}
