void updateEpg(List <SearchLogResultItem> items0, SqlCommand cmd0) { List <EpgEventInfoR> epgList1 = new List <EpgEventInfoR>(); foreach (var item1 in items0) { epgList1.Add(item1.epgEventInfoR); } _db_EpgEventInfo.updateIfNotReferenced(epgList1, tableName, cmd0); // foreach (SearchLogResultItem item1 in items0) { cmd0.CommandText = "UPDATE " + tableName + " SET " + COLUMN_recodeStatus + "=" + (int)item1.recodeStatus + " WHERE " + COLUMN_ID + "=" + item1.ID; cmd0.ExecuteNonQuery(); } }