public void UpdateTable(string tableName, string data) { List <SYNCOperation> list = JsonConvert.DeserializeObject <List <SYNCOperation> >(data); foreach (SYNCOperation item in list) { SYNCOperationBLL.Save(item); } ; //Common.UpdateTableVersion("CloudCourse.dbo.SYNCOperation"); }
static void Main(string[] args) { //test //Test(); //return; //GetAC(); //return; //test over string hostName = ConfigurationManager.AppSettings["RabbitMQHostName"]; string userName = ConfigurationManager.AppSettings["RabbitMQUserName"]; string password = ConfigurationManager.AppSettings["RabbitMQPassword"]; var factory = new ConnectionFactory() { HostName = hostName, UserName = userName, Password = password }; factory.AutomaticRecoveryEnabled = true; using (var connection = factory.CreateConnection()) { using (var channel = connection.CreateModel()) { channel.QueueDeclare("AssignCourseSYNC", true, false, false, null); var consumer = new QueueingBasicConsumer(channel); channel.BasicConsume("AssignCourseSYNC", false, consumer); Console.WriteLine(" [*] Waiting for messages." + "To exit press CTRL+C"); while (true) { var ea = (BasicDeliverEventArgs)consumer.Queue.Dequeue(); Console.WriteLine("获得消息*---*" + ea.DeliveryTag); var body = ea.Body; var message = Encoding.UTF8.GetString(body); PadSYNC.Model.AssignCourse ac = null; SYNCOperation op = null; //清除消息队列用 //channel.BasicAck(ea.DeliveryTag, false); //continue; try { #region 处理消息 ac = JsonConvert.DeserializeObject <PadSYNC.Model.AssignCourse>(message); //ac.Gid = new Guid("D67C7F51-29A1-4CA8-ACDF-08512FB3E8DF"); op = SYNCOperationBLL.GetById(ac.Gid); //op.Id = ac.AssignID; AssignCourseDataContract acdc = Translate.TranslateAssignCourseEntityToGuest(ac); bool b = false; string result = ""; AssignCourseServiceClient client = new AssignCourseServiceClient(); Console.WriteLine("处理消息*---*" + ea.DeliveryTag); if (ac.PadOperType == 0) { b = client.AddNewAssignCourseRetErrowString(out result, acdc); } else { List <CancelReasonConditionsDataContract> CancelReasonConditionsList = new List <CancelReasonConditionsDataContract>(); CancelReasonConditionsDataContract cancelReasonConditions = new CancelReasonConditionsDataContract(); cancelReasonConditions.AssignID = ac.AssignID; cancelReasonConditions.Reason = ""; CancelReasonConditionsList.Add(cancelReasonConditions); CancelReasonConditionsDataContract[] arr = CancelReasonConditionsList.ToArray(); b = client.CancleAssignCourse(arr, 0, 0, 1); result = "取消失败"; } if (b) { result = "Success"; op.Status = 1; } else { op.Status = 2; op.Content = result; } Console.WriteLine("处理成功 {0}", op.Gid + "*---*" + result); channel.BasicAck(ea.DeliveryTag, false); #endregion } catch (Exception ex) { if (op != null) { op.Status = 2; op.Content = ex.Message; } Console.WriteLine("处理失败 {0}", "*---*" + ex.Message); } if (op != null) { SYNCOperationBLL.Save(op); } //Thread.Sleep(3000); } } } }