private void button9_Click(object sender, EventArgs e) { using (var ctx = new testEntities_table()) { try { var users = from ex in ctx.crm_aspect_monitor_table2 select ex; foreach (var c in users) { table tableaspect = utils.TransTotable(c); string jsonkey = string.Format("table_{0}", c.tableId); string jsonvalue = JsonConvert.SerializeObject(tableaspect); Console.WriteLine(jsonvalue); if (mc.Get(jsonkey) != null) { bool b = mc.Store(StoreMode.Replace, jsonkey, jsonvalue); Console.WriteLine(string.Format("replace key {0}============{1}", jsonkey, b)); } else { bool b = mc.Store(StoreMode.Add, jsonkey, jsonvalue); Console.WriteLine(string.Format("add key {0}============{1}", jsonkey, b)); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public static table TransTotable(object t) { table tableaspect = new table(); crm_aspect_monitor_table2 c = (crm_aspect_monitor_table2)t; tableaspect.tableId = c.tableId; tableaspect.filter = c.filter; tableaspect.service = c.service; tableaspect.status = c.status; tableaspect.application = c.application; tableaspect.applicationId = c.applicationId; tableaspect.serviceId = c.serviceId; tableaspect.serviceType = c.serviceType; tableaspect.serviceTypeId = c.serviceTypeId; tableaspect.startTimeMilitary = c.startTimeMilitary; tableaspect.statusId = c.statusId; tableaspect.scheduledCallbacks = c.scheduledCallbacks; tableaspect.abandoned = c.abandoned; tableaspect.badPhoneNumberCount = c.badPhoneNumberCount; tableaspect.dialed = c.dialed; tableaspect.endTimeMilitary = c.endTimeMilitary; tableaspect.excludedCount = c.excludedCount; tableaspect.filterId = c.filterId; tableaspect.inProgress = c.inProgress; tableaspect.leftToBeDialed = c.leftToBeDialed; tableaspect.recordsProcessed = c.recordsProcessed; tableaspect.rgBusyQueueCount = c.rgBusyQueueCount; tableaspect.selected = c.selected; tableaspect.serviceTableId = c.serviceTableId; tableaspect.tableName = c.tableName; tableaspect.timezoneFailureCount = c.timezoneFailureCount; tableaspect.touchedcount = c.touchedcount; tableaspect.timezoneIdentifier = c.timezoneIdentifier; tableaspect.utcStartTime = c.utcStartTime; tableaspect.utcStopTime = c.utcStopTime; return(tableaspect); }