private void button4_Click(object sender, EventArgs e) { crm_aspect_monitor_aod crm = new crm_aspect_monitor_aod(); crm_aspect_monitor_aod aoddata = new crm_aspect_monitor_aod(); string tmp = JsonConvert.SerializeObject(aoddata); // string tmp = "abc"; string str = "{" + string.Format("\"aod_12\":\"{0}\"", tmp) + "}"; //string str = string.Format("{0}", tmp); Console.WriteLine(str); }
private void button4_Click_1(object sender, EventArgs e) { using (var ctx = new testEntities_crm_aspect_monitor_aod()) { { try { var users = from ex in ctx.crm_aspect_monitor_aod2 select ex; foreach (var c in users) { crm_aspect_monitor_aod aodaspect = utils.TransToAod(c); string jsonkey = string.Format("aod_{0}", c.serviceid); string jsonvalue = JsonConvert.SerializeObject(aodaspect); Console.WriteLine(jsonvalue); using (var bucket = Cluster.OpenBucket("osms_cb")) { if (bucket.Exists(jsonkey)) { var result = bucket.Replace(jsonkey, jsonvalue); Console.WriteLine(String.Format("======Replace======={0},{1}", jsonkey, result.Success)); } else { var result = bucket.Insert(jsonkey, jsonvalue); Console.WriteLine(String.Format("======Insert======={0},{1}", jsonkey, result.Success)); } } break; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
public static crm_aspect_monitor_aod TransToAod(object t) { crm_aspect_monitor_aod aodaspect = new crm_aspect_monitor_aod(); crm_aspect_monitor_aod2 c = (crm_aspect_monitor_aod2)t; aodaspect.serviceId = c.serviceid; aodaspect.service = c.service; aodaspect.status = c.status; aodaspect.agentsInAccept = c.agentsInAccept; aodaspect.agentsInActive = c.agentsInActive; aodaspect.agentsInConnect = c.agentsInConnect; aodaspect.agentsInHold = c.agentsInHold; aodaspect.agentsInHdle = c.agentsInHdle; aodaspect.agentsInInternal = c.agentsInInternal; aodaspect.agentsInManual = c.agentsInManual; aodaspect.agentsInMultil = c.agentsInMultil; aodaspect.agentsInNotReady = c.agentsInNotReady; aodaspect.agentsInOther = c.agentsInOther; aodaspect.agentsInPark = c.agentsInPark; aodaspect.agentsInPreview = c.agentsInPreview; aodaspect.agentsInWrap = c.agentsInWrap; aodaspect.agentsLoggedIn = c.agentsLoggedIn; aodaspect.application = c.application; aodaspect.applicationId = c.applicationId; aodaspect.avgAgentActiveTime = c.avgAgentActiveTime; aodaspect.avgAgentIdleTime = c.avgAgentIdleTime; aodaspect.avgAgentWrapTime = c.avgAgentWrapTime; aodaspect.callsAnswered = c.callsAnswered; aodaspect.callsInProgress = c.callsInProgress; aodaspect.callsInQueue = c.callsInQueue; aodaspect.callsServicedWithInServiceLevelDaily = c.callsServicedWithInServiceLevelDaily; aodaspect.callsTransferredToAgent = c.callsTransferredToAgent; aodaspect.callsTransferredToAxternal = c.callsTransferredToAxternal; aodaspect.callsTransferredToService = c.callsTransferredToService; aodaspect.durActiveTime = c.durActiveTime; aodaspect.durWrapTime = c.durWrapTime; aodaspect.maxCallsInQueue = c.maxCallsInQueue; aodaspect.occupancy = c.occupancy; aodaspect.serviceType = c.serviceType; aodaspect.serviceTypeId = c.serviceTypeId; aodaspect.startTimeMilitary = c.startTimeMilitary; aodaspect.statusId = c.statusId; aodaspect.stopTimeMilitary = c.stopTimeMilitary; aodaspect.abandonByDialer24Hour = c.abandonByDialer24Hour; aodaspect.abandonedByCustomer = c.abandonedByCustomer; aodaspect.abandonedBySwitch = c.abandonedBySwitch; aodaspect.agentAnsweringMachines = c.agentAnsweringMachines; aodaspect.agentAnsweringMachines24Hour = c.agentAnsweringMachines24Hour; aodaspect.abandonedPercent = c.abandonedPercent; aodaspect.answeringMachines24Hour = c.answeringMachines24Hour; aodaspect.answeringMachinesCurrent = c.answeringMachinesCurrent; aodaspect.busyHourCallRate = c.busyHourCallRate; aodaspect.callingPartyInfoViolation = c.callingPartyInfoViolation; aodaspect.callsAnsweredServiceLevelInterval = c.callsAnsweredServiceLevelInterval; aodaspect.callsDialed = c.callsDialed; aodaspect.callStartToGreetingAverage = c.callStartToGreetingAverage; aodaspect.callStartToGreetingHigh = c.callStartToGreetingHigh; aodaspect.callStartToGreetingLow = c.callStartToGreetingLow; aodaspect.currentDetectionType = c.currentDetectionType; aodaspect.currentDialMode = c.currentDialMode; aodaspect.currentDialRatio = c.currentDialRatio; aodaspect.currentDialSettingsAutoRevert = c.currentDialSettingsAutoRevert; aodaspect.currentQuota = c.currentQuota; aodaspect.detectToTransferAverage = c.detectToTransferAverage; aodaspect.detectToTransferHigh = c.detectToTransferHigh; aodaspect.detectToTransferLow = c.detectToTransferLow; aodaspect.falseNegativeCount = c.falseNegativeCount; aodaspect.falsePositiveCount = c.falsePositiveCount; aodaspect.greetingToConnectAverage = c.greetingToConnectAverage; aodaspect.greetingToconnectHigh = c.greetingToconnectHigh; aodaspect.greetingToconnectLow = c.greetingToconnectLow; aodaspect.greetingTodetectAverage = c.greetingTodetectAverage; aodaspect.greetingTodetectHigh = c.greetingTodetectHigh; aodaspect.greetingTodetectLow = c.greetingTodetectLow; aodaspect.hangup = c.hangup; aodaspect.hitRate = c.hitRate; aodaspect.lastFailAbandonPercent = c.lastFailAbandonPercent; aodaspect.lastTimeToFail = c.lastTimeToFail; aodaspect.lastTimeToRecover = c.lastTimeToRecover; aodaspect.maxQuota = c.maxQuota; aodaspect.minutesLeftOnSchedule = c.minutesLeftOnSchedule; aodaspect.numberAlertsOFCOM = c.numberAlertsOFCOM; aodaspect.numberAlertsOFCOM24Hours = c.numberAlertsOFCOM24Hours; aodaspect.numberHits24Hour = c.numberHits24Hour; aodaspect.numberHits24HourForFalsePositive = c.numberHits24HourForFalsePositive; aodaspect.numberHitsCurrent = c.numberHitsCurrent; aodaspect.numberHitsForFalsePositiveCurrent = c.numberHitsForFalsePositiveCurrent; aodaspect.numberMisses24Hour = c.numberMisses24Hour; aodaspect.numberMissesCurrent = c.numberMissesCurrent; aodaspect.numberOFCOMAbandons24Hour = c.numberOFCOMAbandons24Hour; aodaspect.numberOFCOMAbandonsCurrent = c.numberOFCOMAbandonsCurrent; aodaspect.numberOfRecoveries = c.numberOfRecoveries; aodaspect.numberOfSales = c.numberOfSales; aodaspect.peakHourCallRate = c.peakHourCallRate; aodaspect.playMessage = c.playMessage; aodaspect.playMessageFailure = c.playMessageFailure; aodaspect.playMessageTimeSuccess = c.playMessageTimeSuccess; aodaspect.playMessageTimeViolation = c.playMessageTimeViolation; aodaspect.playScript = c.playScript; aodaspect.recoveryTimeBegin = c.recoveryTimeBegin; aodaspect.recoveryTimeEnd = c.recoveryTimeEnd; aodaspect.ringNoAnswerViolation = c.ringNoAnswerViolation; aodaspect.scheduledCallbacks = c.scheduledCallbacks; aodaspect.sendDigits = c.sendDigits; aodaspect.sendFax = c.sendFax; aodaspect.timezoneIdentifier = c.timezoneIdentifier; aodaspect.transferTimeSuccess = c.transferTimeSuccess; aodaspect.transferTimeViolation = c.transferTimeViolation; aodaspect.transferCoConnectAverage = c.transferCoConnectAverage; aodaspect.transferToConnectHigh = c.transferToConnectHigh; aodaspect.transferToConnectLow = c.transferToConnectLow; aodaspect.utcStartTime = c.utcStartTime; aodaspect.utcStopTime = c.utcStopTime; aodaspect.getAodData = c.getAodData; return(aodaspect); }