public static string SaveGuestMessage(string mInfo) { string returnStr = ""; JObject objVenue = JObject.Parse(mInfo); try { using (venuesEntities db = new venuesEntities()) { int guestId = 0; tbl_guest_message tbt = new tbl_guest_message(); if (objVenue["GuestID"].ToString() == "") { tbt.GuestID = 0; } else { tbt.GuestID = int.Parse(objVenue["GuestID"].ToString()); guestId = int.Parse(objVenue["GuestID"].ToString()); } tbt.MessageTime = DateTime.Now; //tbt.MessageContent = objVenue["MessageContent"].ToString(); //tbt.MessageTitle = objVenue["MessageTitle"].ToString(); tbt.VenueID = int.Parse(objVenue["VenueID"].ToString()); tbt.EventName = objVenue["EventName"].ToString(); tbt.EventType = objVenue["EventType"].ToString(); tbt.EstimatedAttendees = objVenue["EstimatedAttendees"].ToString(); tbt.EventStartDate = objVenue["EventStartDate"].ToString(); tbt.EventEndDate = objVenue["EventEndDate"].ToString(); tbt.Eventrequirements = objVenue["Eventrequirements"].ToString(); tbt.FirstName = objVenue["FirstName"].ToString(); tbt.LastName = objVenue["LastName"].ToString(); tbt.EmailAddress = objVenue["EmailAddress"].ToString(); tbt.Phone = objVenue["Phone"].ToString(); tbt.Organization = objVenue["Organization"].ToString(); tbt.OrganizationType = objVenue["OrganizationType"].ToString(); db.AddTotbl_guest_message(tbt); string guestName = ""; string guestEmail = ""; //if (guestId == 0) //{ guestName = objVenue["FirstName"].ToString() + " " + objVenue["LastName"].ToString(); guestEmail = objVenue["EmailAddress"].ToString(); //} //else //{ // string guestInfo = GetGuestByGuestID(guestId); // JObject guestObj = JObject.Parse(guestInfo); // guestName = guestObj["GuestName"].ToString(); // guestEmail = guestObj["GuestEmail"].ToString(); //} string venueInfo = VenuesManager.GetVenuesByVenueId(int.Parse(objVenue["VenueID"].ToString()), ""); JArray arrVenue = JArray.Parse(venueInfo); string venueEmail=""; string venueManager=""; string veneName=""; string SMTPHost = "smtp.163.com"; string SMTPuser = "******"; string SMTPpass = "******"; foreach (JObject venueObj in arrVenue) { venueEmail = venueObj["Email"].ToString(); venueManager = venueObj["VenueManager"].ToString(); veneName= venueObj["VenueName"].ToString(); } string fromEmailName = SMTPuser.Substring(0, SMTPuser.LastIndexOf("@")); string toEmailName=venueEmail.Substring(0,venueEmail.LastIndexOf("@")); string contentStr = guestName + "游客(" + guestEmail + ")给您留言了!\r\n" + "EventName:" + objVenue["EventName"].ToString() + "\r\n EventType:" + objVenue["EventType"].ToString() + "\r\n EstimatedAttendees:" + objVenue["EstimatedAttendees"].ToString() + "\r\n EventStartDate:" + objVenue["EventStartDate"].ToString() + "\r\n EventEndDate:" + objVenue["EventEndDate"].ToString() + "\r\n EventRequirements:" + objVenue["Eventrequirements"].ToString() + "\r\n FirstName:" + objVenue["FirstName"].ToString() + "\r\n LastName" + objVenue["LastName"].ToString() + "\r\n EmailAddress:" + objVenue["EmailAddress"].ToString() + "\r\n Phone:" + objVenue["Phone"].ToString() + "\r\n Organization:" + objVenue["Organization"].ToString() + "\r\n OrganizationType:" + objVenue["OrganizationType"].ToString(); //string guestMessageContnet = guestName + "游客(" + guestEmail + ")给您留言了!" + objVenue["MessageContent"].ToString(); // string fileAddress = "D:\\游客留言发送邮件.txt"; string fileAddress = ""; sendmail(SMTPuser, fromEmailName, venueEmail, toEmailName, "游客留言", contentStr, fileAddress, SMTPHost, SMTPuser, SMTPpass); //sendmail(SMTPuser, fromEmailName, venueEmail, toEmailName, objVenue["MessageTitle"].ToString(), guestMessageContnet, fileAddress, SMTPHost, SMTPuser, SMTPpass); if (db.SaveChanges() != 0) { returnStr = KeyManager.RetrunSucceed; } else { returnStr = KeyManager.RetrunUnSucceed; } } } catch (Exception e) { returnStr = e.Message; LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VisitorManager, "游客用户留言,mInfo=" + mInfo + ";错误信息:" + e.Message, null); } return returnStr; }