コード例 #1
0
        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();
            }
        }